Tagrain Reporting Guide

Transaction Report

Overview

Transaction Report is used to review and monitor the transactions performed in Tagrain over the period of time. This report includes transactions for all the stores or retail outlets run or owned by the business. Every transaction listed in the report can be further expanded to reveal the transaction details: Line Item(s) and Payment Type(s). These are covered in detail in the upcoming sections.

The Payment(s) section focuses on the different payment types used to pay for the transaction. It includes the following fields: Payment Type | Amount.

Steps to generate a Transaction Report

Log in to your Tagrain Tenant. Navigate to Home > Reports > Transaction Report to open the Transaction Report Master Screen.

Select a Store, specify a Date Range, and then click on the Search button to generate the Transaction Report. This will generate the Transaction Report based on your selection. However, if you do not specify the Store it will pull a consolidated Transaction Report for all your stores. You can also toggle the switch Include Suspended Transactions to ON in case you want to include the suspended transactions in your Transaction Report.

Transaction Report Grid

The Transaction Report Screen is divided into Rows and Columns known as Grids. These Grids display information specific to the transaction report. This transaction report data is crucial to your business and must be handled with caution. The various grid fields in the Transaction Report are explained below:

Transaction ID

This grid displays the Transaction ID. Every ID is unique. It may contain alphabets or numbers or both and is tied to each transaction performed.

Refunded Against

This grid displays the original transaction ID against which this refund transaction was raised.

Store

This grid displays the name of the Store where the transaction was performed.

POS

This grid displays the name of the Point of Sale (POS) where the transaction was created.

User

This grid displays the name of the user who processed the transaction at the Point of Sale (POS)

Actual Date

This grid displays the date and time stamp when the transaction occurred.

Customer

This grid displays the name of the customer who purchased or refunded the goods.

Total

This grid displays the total amount. This amount is the total amount of the individual transaction.

Is Suspended

This grid displays if the transaction is a suspended transaction or not. If the Is Suspended checkbox is ticked, then the transaction is suspended and is yet to be processed.

Balance Amount

This grid displays the amount outstanding if any on the transaction. This is usually applicable to those transactions where the mode of payment is “On Account”. If the transaction has been paid “On Account” the outstanding amount is shown in this column.

Has Sales

This grid displays if the transaction includes a sale item or not. If the Has Sales checkbox is ticked, then the transaction includes sale items, if unticked it may include refunds or account payments.

Transaction Status Type

This grid displays the transaction status type. It will hold the value Completed only if the transaction has been completed.

If the Plugin Customer Order and Delivery Management has been activated in your Tagrain account, the field will have the following status:

1. Delivery Pending:

This is the case where the customer has preferred to get the order delivered, but the order is yet to be delivered

2. Delivery Complete:

This is the state when the transaction (order) marked for delivery has been delivered

3. Pickup Pending:

This is the case where the customer has preferred to store pick up the order, but the order is yet to be picked up

4. Pickup Complete:

This is the state when the transaction (order) marked for pickup has been picked up by the customer

Delivery Option Type

This grid denotes whether the transaction (order) is to be either delivered to the customer or is supposed to be picked up by the customer. This column will display the value Store Pickup or Home Delivery if the plugin Customer Order and Delivery Management is activated in your Tagrain account else it will display None.

At the beginning of each transaction row, there is an arrow symbol. Clicking on this arrow will expand the transaction. The transaction when expanded further reveals the transaction details: Line Item(s) and Payment Type(s).

Line Item(s)

This section focuses on the transaction details. It includes the following fields:

Transaction Type

Product

UPC

Quantity Sold

Sales (Inc. Tax)

Sales (Exc. Tax)

Discounts

Purchase Cost (Base Price)

Gross Profit

Margin %

Payment(s)

This section focuses on the different payment types used to pay for the transaction. It includes the following fields:

Payment Type

Amount

Export the Transaction Report

You can generate a snapshot of all your sale and sale-refund transactions, via the export template. This template is excel based and allows you to review all the transactions in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Transaction Report is generated, click on the Export button to download the TransactionReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

The date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings ( Home > Setup > General Settings > Display Settings ) OR the date time format of the Operating System OR Excel.

The exported Transaction Report has 3 worksheets in it – Transaction Report Sheet | Transaction Line-Item Sheet | Transaction Payments Sheet.

Transaction Report (Sheet)

This sheet lists all the transactions by store. These transactions are sorted by transaction date in the descending order.

Transaction Line Item (Sheet)

This sheet lists all the products transacted in the transactions. This sheet gives detailed information about every product in the transaction. In addition to the transaction id, type of transaction (sale or a refund), quantity sold, the report also gives you the following details: Sales (inc. tax) | Sales (Ex. tax) | Discounts |Product Cost | Gross Profit | Margin %.

Transaction Payments (Sheet)

This sheet is the 3rd sheet in the downloaded report and details the different payment types used in the transactions.

Sales Report

Overview

Sales Report is used to review and monitor the sale performed over time for all the stores or retail outlets run or owned by the business. Every sale listed in the report can be filtered based on: Product, or Product Group, or Customer, or Customer Group, or Cahier. It also helps you obtain detailed information about the sales inclusive tax, sale exclusive tax, and discounts.

Steps to generate a Sales Report

Select a Store, select a POS, specify a Date Range, and then click on the Search button to generate the Transaction Report. However, if you do not specify the report filters it will pull a consolidated Sales Report for all your stores, and POS. You can also sort your Sales Report by Product, or Product Group, or Customer, or Customer Group, or Cahier, or Store. Depending upon how you choose to filter your Sales Report, the Columns or Grids displayed will change.

Sales Report Grid

The Sales Report data is divided into Rows and Columns also known as Grids. Each Row displays the sale, and each column displays information pertaining to that sale. This sale data is crucial to your business and must be handled with caution. Depending upon how you choose to filter your Sales Report, the Columns or Grids displayed will change.

As stated earlier, you can filter your Sales Report based on Product, or Product Group, or Customer, or Customer Group, Cahier, or Store. For example in a Sale by Product report you will not have the Customer and Customer Group columns. Similarly in a Sale by Customer report you will not have the Product and Product Group columns.

Types of Sales Report

There are 5 types of reports included in your sales report. These are:

Sale by Product
Sale by Product Group
Sale by Customer
Sale by Customer Group
Sale by Cashier
Sale by Store

Each of these reports are explained in the section below:

Sale By Product Report

The Sale By Product Report represents the Sale Report data from a Product’s perspective.

Like every other Report this report is also divided into Rows and Columns known as Grids. These grid fields are explained below:

Store

This grid displays the name of the selected store for which the sales report is populated.

POS

This grid displays the name of the Point of Sale (POS) where the sales transaction originated.

Product

This grid displays the code and description of the product selected for the report.

Product Group

This grid displays the name of the product group the selected product (above) belongs to.

Sales Inclusive Tax

This grid displays the sales amount inclusive of sales tax

Sales Exclusive Tax

This grid displays the sales amount exclusive of sales tax

Refund Inclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is inclusive of sales tax.

Refund Exclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is exclusive of sales tax.

Discount

This is the total amount of discount allowed for the sales by product, product group, customer, customer group, cashier.

Net Sales

This grid displays the new sales amount. The formula to calculate Net Sales is

Net Sales = Sales (inc. tax) - Refun (inc. tax)

Units Sold

This grid displays the number of units sold.

Product Cost

This grid displays the cost of the product in the currency specified in General Settings. Product Cost is the Base Price of the product.

Gross Profit

This grid displays the gross profit. The formula to calculate the Gross Profit is:

Gross Profit = {[Sales (Ex. tax) – Refund (Ex. Tax)] – [Product Cost at Sale – Product Cost at Refund]}

Margin %

This grid displays the Margin%. The formula to calculate Margin% is:

Margin % = Gross Profit / {Sales (Ex. Tax) – Refund (Ex. Tax)

Net Tax

This is the tax amount levied on a product, in a store, or POS. The formula to calculate Net Tax is:

Net Tax = {[Sales (Inc. Tax) – (Sales (Ex. Tax)] – [Refunds (Inc. Tax) – (Refunds (Ex. Tax)]}

Sale By Product Group Report

The Sale By Product Group Report represents the Sale Report data from a Product Group’s perspective.

Like every other Report this report is also divided into Rows and Columns known as Grids. These grid fields are explained below:

Store

This grid displays the name of the selected store for which the sales report is populated.

POS

This grid displays the name of the Point of Sale (POS) where the sales transaction originated.

Product Group

This grid displays the name of the product group the selected product (above) belongs to.

Sales Inclusive Tax

This grid displays the sales amount inclusive of sales tax

Sales Exclusive Tax

This grid displays the sales amount exclusive of sales tax

Refund Inclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is inclusive of sales tax.

Refund Exclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is exclusive of sales tax.

Discount

This is the total amount of discount allowed for the sales by product, product group, customer, customer group, cashier.

Net Sales

This grid displays the new sales amount. The formula to calculate Net Sales is:

Net Sales = Sales (inc. tax) - Refun (inc. tax)

Units Sold

This grid displays the number of units sold.

Product Cost

This grid displays the cost of the product in the currency specified in General Settings. Product Cost is the Base Price of the product.

Gross Profit

This grid displays the gross profit. The formula to calculate the Gross Profit is:

Gross Profit = {[Sales (Ex. tax) – Refund (Ex. Tax)] – [Product Cost at Sale – Product Cost at Refund]}

Margin %

This grid displays the Margin%. The formula to calculate Margin% is:

Margin % = Gross Profit / {Sales (Ex. Tax) – Refund (Ex. Tax)

Net Tax

This is the tax amount levied on a product, in a store, or POS. The formula to calculate Net Tax is:

Net Tax = {[Sales (Inc. Tax) – (Sales (Ex. Tax)] – [Refunds (Inc. Tax) – (Refunds (Ex. Tax)]}

Sale By Customer Report

The Sale By Customer Report represents the Sale Report data from a Customer’s perspective.

Like the Transaction Report this report is also divided into Rows and Columns known as Grids. These grid fields are explained below:

Store

This grid displays the name of the selected store for which the sales report is populated.

POS

This grid displays the name of the Point of Sale (POS) where the sales transaction originated.

Customer

This grid displays the name of the customer against whom the sale was recorded.

Customer Group

This grid displays the name of the customer group the selected customer (above) belongs to.

Cashier

This grid displays the name of the cashier logged in to the Point of Sale when the sale was made.

Sales Inclusive Tax

This grid displays the sales amount inclusive of sales tax

Sales Exclusive Tax

This grid displays the sales amount exclusive of sales tax

Refund Inclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is inclusive of sales tax.

Refund Exclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is exclusive of sales tax.

Discount

This is the total amount of discount allowed for the sales by product, product group, customer, customer group, cashier.

Net Sales

This grid displays the new sales amount. The formula to calculate Net Sales is:

Net Sales = Sales (inc. tax) - Refun (inc. tax)

Units Sold

This grid displays the number of units sold.

Product Cost

This grid displays the cost of the product in the currency specified in General Settings. Product Cost is the Base Price of the product.

Gross Profit

This grid displays the gross profit. The formula to calculate the Gross Profit is:

Gross Profit = {[Sales (Ex. tax) – Refund (Ex. Tax)] – [Product Cost at Sale – Product Cost at Refund]}

Margin %

This grid displays the Margin%. The formula to calculate Margin% is:

Margin % = Gross Profit / {Sales (Ex. Tax) – Refund (Ex. Tax)

Net Tax

This is the tax amount levied on a product, in a store, or POS. The formula to calculate Net Tax is:

Net Tax = {[Sales (Inc. Tax) – (Sales (Ex. Tax)] – [Refunds (Inc. Tax) – (Refunds (Ex. Tax)]}

Sale By Customer Group Report

The Sale By Customer Group Report represents the Sale Report data from a Customer Group’s perspective.

Like every other Report this report is also divided into Rows and Columns known as Grids. These grid fields are explained below:

Store

This grid displays the name of the selected store for which the sales report is populated.

POS

This grid displays the name of the Point of Sale (POS) where the sales transaction originated.

Customer Group

This grid displays the name of the customer group the selected customer (above) belongs to.

Cashier

This grid displays the name of the cashier logged in to the Point of Sale when the sale was made.

Sales Inclusive Tax

This grid displays the sales amount inclusive of sales tax

Sales Exclusive Tax

This grid displays the sales amount exclusive of sales tax

Refund Inclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is inclusive of sales tax.

Refund Exclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is exclusive of sales tax.

Discount

This is the total amount of discount allowed for the sales by product, product group, customer, customer group, cashier.

Net Sales

This grid displays the new sales amount. The formula to calculate Net Sales is:

Net Sales = Sales (inc. tax) - Refun (inc. tax)

Units Sold

This grid displays the number of units sold.

Product Cost

This grid displays the cost of the product in the currency specified in General Settings. Product Cost is the Base Price of the product.

Gross Profit

This grid displays the gross profit. The formula to calculate the Gross Profit is:

Gross Profit = {[Sales (Ex. tax) – Refund (Ex. Tax)] – [Product Cost at Sale – Product Cost at Refund]}

Margin %

This grid displays the Margin%. The formula to calculate Margin% is:

Margin % = Gross Profit / {Sales (Ex. Tax) – Refund (Ex. Tax)

Net Tax

This is the tax amount levied on a product, in a store, or POS. The formula to calculate Net Tax is:

Net Tax = {[Sales (Inc. Tax) – (Sales (Ex. Tax)] – [Refunds (Inc. Tax) – (Refunds (Ex. Tax)]}

Sale By Cashier Report

The Sale By Cashier Report represents the Sale Report data from a Cashier’s perspective.

Like every other Report this report is divided into Rows and Columns also known as Grids. The various grid fields in the Sale By Product Report are explained below:

Store

This grid displays the name of the selected store for which the sales report is populated.

POS

This grid displays the name of the Point of Sale (POS) where the sales transaction originated.

Cashier

This grid displays the name of the cashier logged in to the Point of Sale when the sale was made.

Sales Inclusive Tax

This grid displays the sales amount inclusive of sales tax

Sales Exclusive Tax

This grid displays the sales amount exclusive of sales tax

Refund Inclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is inclusive of sales tax.

Refund Exclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is exclusive of sales tax.

Discount

This is the total amount of discount allowed for the sales by product, product group, customer, customer group, cashier.

Net Sales

This grid displays the new sales amount. The formula to calculate Net Sales is:

Net Sales = Sales (inc. tax) - Refun (inc. tax)

Units Sold

This grid displays the number of units sold.

Product Cost

This grid displays the cost of the product in the currency specified in General Settings. Product Cost is the Base Price of the product.

Gross Profit

This grid displays the gross profit. The formula to calculate the Gross Profit is:

Gross Profit = {[Sales (Ex. tax) – Refund (Ex. Tax)] – [Product Cost at Sale – Product Cost at Refund]}

Margin %

This grid displays the Margin%. The formula to calculate Margin% is:

Margin % = Gross Profit / {Sales (Ex. Tax) – Refund (Ex. Tax)

Net Tax

This is the tax amount levied on a product, in a store, or POS. The formula to calculate Net Tax is:

Net Tax = {[Sales (Inc. Tax) – (Sales (Ex. Tax)] – [Refunds (Inc. Tax) – (Refunds (Ex. Tax)]}

Sale By Store Report

The Sale By Store Report represents the Sale Report data from a Store’s perspective.

Like every other Report this report is divided into Rows and Columns also known as Grids. The various grid fields in the Sale By Product Report are explained below:

Store

This grid displays the name of the selected store for which the sales report is populated.

POS

This grid displays the name of the Point of Sale (POS) where the sales transaction originated.

Sales Inclusive Tax

This grid displays the sales amount inclusive of sales tax

Sales Exclusive Tax

This grid displays the sales amount exclusive of sales tax

Refund Inclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is inclusive of sales tax.

Refund Exclusive Tax

This grid displays the amount aggregated against a sale refund. This amount is exclusive of sales tax.

Discount

This is the total amount of discount allowed for the sales by product, product group, customer, customer group, cashier.

Net Sales

This grid displays the new sales amount. The formula to calculate Net Sales is:

Net Sales = Sales (inc. tax) - Refun (inc. tax)

Units Sold

This grid displays the number of units sold.

Product Cost

This grid displays the cost of the product in the currency specified in General Settings. Product Cost is the Base Price of the product.

Gross Profit

This grid displays the gross profit. The formula to calculate the Gross Profit is:

Gross Profit = {[Sales (Ex. tax) – Refund (Ex. Tax)] – [Product Cost at Sale – Product Cost at Refund]}

Margin %

This grid displays the Margin%. The formula to calculate Margin% is:

Margin % = Gross Profit / {Sales (Ex. Tax) – Refund (Ex. Tax)

Net Tax

This is the tax amount levied on a product, in a store, or POS. The formula to calculate Net Tax is:

Net Tax = {[Sales (Inc. Tax) – (Sales (Ex. Tax)] – [Refunds (Inc. Tax) – (Refunds (Ex. Tax)]}

Export the Sales Report

Once the Sales Report is generated, click on the Export button to download the SalesReport.xls file to your “Downloads” folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Inventory Report

Overview

Inventory Report is used to review and monitor the inventory across stores. It analyses the inventory status across 5 parameters: In Stock | Low Stock | Critical Stock | Zero Stock | Negative Stock. These are covered in detail in the upcoming sections. Each inventory listed in the report can be filtered based on the 5 parameters mentioned above. It also helps you obtain detailed information about the total available quantity, reserved quantity, and reorder level.

Steps to generate a Inventory Report

Select a Store, select a Product, select a Product Group, and click on the Search button to generate the Inventory Report. However, if you do not specify the report filters it will pull a consolidated Inventory Report for all your stores, and POS. You can also choose to sort your Inventory Report by All, In Stock, Low Stock, Critical Stock, Zero Stock, or Negative Stock.

Inventory Report Grid

Like every other report, this report is also divided into Rows and Columns known as Grids. Each Row displays the inventory, and each column displays information pertaining to that inventory.

This inventory data is crucial to your business and must be handled with caution. The various grid fields in the Inventory Report are explained below:

Status

This grid displays circular dots. Each dot is color coded, and each color represents inventory status. The green circular dot represents that the inventory is available. The red circular dot represents that the product is not available in inventory. The Yellow circular dot represents that the inventory is low on stock.

Store

This grid displays the name of the store for which the Inventory Report is generated.

Product

This grid displays the code of the product against which the Inventory Report is generated.

Description

This grid displays the description of the product (above).

Product Group

This grid displays the name of the product group to which the product (above) belongs.

Brand

This grid displays the brand name of the product selected for the inventory report.

Base Price

This grid displays the base price of the product with which the product is listed in the warehouse.

Total Available Quantity

This grid displays the total count of the inventory available.

Reserved Quantity

This grid displays the total count of the inventory reserved.

Reorder Level

This grid displays the inventory reorder level.

Unit of Measure

Reorder level is the level that has been set.

Parameters of the Inventory Report

As stated earlier, this report analyses the stock status of products across 5 parameters. These parameters are explained in the section below.

A. In Stock

These are products that have their Available Quantity > 0

B. Low Stock

A product is marked Low Stock when its Available Quantity < Minimum Stock Level (specified in the product master)

C. Critical Stock

A product is marked Critical Stock when its Available Quantity < (Minimum Stock Reorder Level X 10) / 100

D. Zero Stock

Available Quantity = 0

E. Negative Stock

Available Quantity < 0

Export the Inventory Report

You can generate a snapshot of all your inventory, via the export template. This template is excel based and allows you to review all the inventory in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Inventory Report is generated, click the Export button to download the InventoryReport.xls file to your “Downloads” folder. However, if you want to save the file to a different location, click the “Save As” button instead. Navigate to your desired location on the drive and then click the “Save” button.

Inventory Status Report

Overview

Inventory Status Report is used to review and monitor the inventory status across stores. It lets you know the actual inventory count across all the stores. It also helps you obtain detailed information about the Total Available Quantity, Quantity Sold, PO Pending Quantity, and Reserved Quantity.

Steps to generate Inventory Status Report

Log in to your Tagrain Tenant. Navigate to Home > Reports > Inventory Status Report to open the Inventory Status Report Master Screen.

Select a Store, a Product, a Product Group, specify a date range, and click on the Search button to generate the Inventory Status Report. However, if you do not specify the report filters it will pull a consolidated Inventory Status Report for all your stores, and POS.

Inventory Status Report Grid

The Inventory Status Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the Inventory Status.

This inventory status data is crucial to your business and must be handled with caution. The various grid fields in the Inventory Status Report are explained below:

Store

This grid displays the name of the store against which the Inventory Status Report has been generated.

Product

This grid displays the Product Code as updated in the Product Master Data. Every Product Code is unique.

Description

This grid displays a brief description of the Product (above). It makes it easy to identify the product specially when you have a huge product portfolio.

Product Group

This grid displays the name of the product group the product (above) is associated with.

UPC (Universal Product Code)

This grid displays the Universal Product Code assigned to the product in the Product Master.

Brand

This grid displays the Manufacturer (Brand) of the product.

Stock on Hand (now)

This grid displays the quantity of the product in hand on the date specified, per store(s).

Qty Sold (Date Range)

This grid displays the quantity of the product sold on the date specified, per store(s).

Purchase Order Pending Quantity (as of now) Reserved Quantity

This grid displays the quantity of the product for which the order has been received but is still yet to be fulfilled.

Export the Inventory Status Report

You can generate a snapshot of your inventory status, via the export template. This template is excel based and allows you to review the inventory status across all your stores in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Inventory Status Report is generated as per the steps explained above, click on the Export button. Clicking the “Export” symbol will download the InventoryReport.xls file to your “Downloads” folder. However, if you want to save the file to a different location on the drive, you need to click the “Save As” button and navigate to your desired location on the drive and then click the “Save” button.

Inventory Movement Report

Overview

Inventory Status Report is used to review and monitor the movement of inventory across stores. It lets you know the changes that may have occurred to the inventory level including sales / refunds / goods receipts etc.

Steps to generate Inventory Movement Report

Log in to your Tagrain Tenant. Navigate to Home > Reports > Inventory Status Report to open the Inventory Movement Report Master Screen.

Select a Store, select a Product, specify a date range, select the movement type and then click the Search button to generate the Inventory Movement Report. However, if you do not specify the report filters it will pull a consolidated Inventory Movement Report for all your stores, and POS. The Movement Type selection drop-down gives you the following options: Good Receipt | Goods Receipt PO | Goods Receipt STN | Stock Transfer | Goods Issue | Sale Transaction and Opening Stock.

Inventory Movement Report Grid

The Inventory Movement Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the Inventory Movement across stores.

This inventory status data is crucial to your business and must be handled with caution. The various grid fields in the Inventory Status Report are explained below:

Document Date

This grid displays the date and time stamp as to when the inventory movement was initiated.

Store

Displays the name of the Store where the inventory movement took place.

Type

Displays the Type of inventory movement that took place.

Product

Displays the Product ID.

Description

Displays the name of the Product.

Reserved Quantity

Quantity

Displays the quantity of the Product.

UoM (Unit of Measure)

Displays the Unit of Measure. For example, each, pair, box, etc

Base Quantity

Displays the base quantity.

Base UoM

Displays the base Unit of Measure. This will be the default UoM.

Export the Inventory Movement Report

You can export your inventory movement report via the export template. This template is excel based and allows you to review the inventory movement across all your stores in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Inventory Movement Report, click the Export button to download the InventoryReport.xls file to your “Downloads” folder. However, if you want to save the file to a different location, click the “Save As” button instead. Navigate to your desired location on the drive and then click the “Save” button.

Customer Report

Overview

Customer Report is used to review and monitor customer information. It lets you know the group to which the customer belongs to along with the date and time when that customer was created. It also gives you the total value of sales made by that customer. This report helps you formulate marketing strategies to boost the sales figures. For e.g. You can use promotion tools (discounts, gift cards, coupons) against customers with less revenue to lure them into buying more products.

Steps to generate Customer Report

Upon clicking the Customer Report, an exhaustive list of all the customers created in Tagrain software suite is auto populated. However, you may choose to selectively filter the report by selecting the customer group, specify the date range and click on the search button.

Customer Report Grid

The Customer Report Master Data is split into Rows and Columns also known as Grids. These Grids display information specific to the customer report.

This transaction report data is crucial to your business and must be handled with caution. The various grid fields in the Transaction Report are explained below:

Customer

Displays the customer ID and customer name.

Customer Group

Displays the name of the group to which the customer belongs to.

Customer Balance

Displays the customer balance.

Creation Time

Displays the Date and the Time in the format specified under Display Settings when the Customer was created.

Last Sale Date

Displays the Date and the Time in the format specified under Display Settings when the last sale was made by the customer.

Sales Value

Displays the value in currency of the sale incurred by the customer.

Export the Customer Report

You can export your customer report via the export template. This template is excel based and allows you to review your existing customers in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Customer Report is generated, click the Export button to download the CustomerReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Tax on Sales Report

Overview

The Tax on Sales Report displays the total tax collected for the sales made per store during the period specified. It also lets you know the Total before tax and total after tax for the selected store. It can be generated on a daily basis, weekly basis, monthly basis, or quarterly basis, depending upon the need.

Steps to generate Tax on Sales Report

Log in to your Tagrain Tenant. Navigate to Home > Reports > Tax on Sales Report to open the Tax on Sales Report Master Screen.

Specify a date range, select a store, and then click on the search button. However, if you do not specify the report filters it will pull a consolidated Tax on Sales Report for all your stores.

Tax on Sales Report Grid

The Tax on Sales Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the tax collected across stores. This tax collection status data is crucial to your business and must be handled with caution. The various grid fields in the Tax on Sales Report are explained below:

Store

This is the name of the store for which tax details are generated

Tax Code

This is the tax code Id.

Total Before Tax

This is the sales value excluding Tax.

Total After Tax

This is the sales value including tax.

Tax Amount

This is the total amount of tax collected.

Export the Tax on Sales Report

You can export your Tax on Sales Report via the export template. This template is excel based and allows you to review your total tax collected in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Tax on Sales Report is generated, click the Export button to download the TaxonSalesReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Tax on Purchases Report

Overview

Tax on Purchases Report displays the total tax that has been paid in different purchase related transactions in a selected store. Tax payable report displays the Total before tax and total after tax along with Tax Amount. It can be generated on a daily basis, weekly basis, monthly basis or quarterly basis, depending upon the need of the organization.

Steps to generate Tax on Purchases Report

Log in to your Tagrain Tenant. Navigate to Home > Reports > Tax on Purchases Report to open the Tax on Purchases Report Master Screen.

Specify a date range, select a store, and then click on the search button. However, if you do not specify the report filters it will pull a consolidated Tax on Purchases Report for all your stores.

Tax on Purchases Report Grid

The Tax on Purchases Report Master Screen is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the tax payable across stores. This tax payable status data is crucial to your business and must be handled with caution. The various grid fields in the Tax on Sales Report are explained below:

Store

This is the name of the store for which tax details are generated

Tax Code Id

This is the tax code id

Total Before Tax

This is the gross amount of transaction in a store for the selected date range before the tax

Total After Tax

This is the net amount of transaction in a store for the selected date range after the tax

Tax Amount

This is the total tax amount that has been paid in different transactions.

Export the Tax on Purchases Report

Tagrain allows you to export your Tax on Purchases Report via the export template. This template is excel based and allows you to review your total tax collected in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once you have generated the Tax on Purchases Report, click the Export button to download the TaxonSalesReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Tender Collection Report

Overview

Tender Collection Report is a snapshot of the tender collection activities performed by the company via different sources. It can be generated on a daily basis, weekly basis, monthly basis or quarterly basis, depending upon the need of the organization. This report helps you analyze different sources of tender collection. It lets you compare this year's performance to last year's for sales, units, gross margin, and variance, as well as new-store analysis.

Steps to generate Tender Collection Report

Log in to your Tagrain Tenant and navigate to Home > Reports > Tender Collection Report. This will open the Tender Collection Report Master Screen.

When you click the Tender Collection Report sub menu, an exhaustive list of all the tender collected is auto populated. However, you may choose to selectively filter the report on the basis of Tender Type, Store, or Date.

Tender Collection Report Grid

The Tender Collection Report Master Screen is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the tender collected. This tender data is crucial to your business and must be handled with caution. The various grid fields in the Tender Collection Report are explained below:

Tender Type

Tender Type displays the tender mode. It can be Cash, Credit Card, Debit Card, Gift Certificate, Loyalty, etc.

Total Sale Amount

Total Sale Amount displays the total amount of the sale transaction.

Creation Time

Displays the Date and Time when the Tender Collection Report was created.

Last Modification Time

Displays the Date and Time when the Tender Collection Report was last modified.

Created By

Displays the name of the person who created the Tender Collection Report.

Modified By

Displays the name of the person who modified the Sales Target Report was last modified.

Export the Tender Collection Report

You can export your Tender Collection Report via the export template. This template is excel based and allows you to review your tenders collected in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once the Tender Collection Report is generated, click the Export button to download the TenderCollectionReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Sales Target Report

Overview

Sales Target Report is a snapshot of the sale activities. It can be used to compare targeted performance with actual. It can be generated daily, weekly, monthly, or quarterly, depending upon the need.

Steps to generate Sales Target Report

Log in to your Tagrain Tenant and navigate to Home > Reports > Sales Target Report. This will open the Sales Target Report Master Screen.

You need to select a predefined Sales Target, specify a date range, and then click the Search button to generate the Sales Target Report.

Sales Target Report Grid

The Sales Target Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to a predefined sales target.

This sales target data is crucial to your business and must be handled with caution. The various grid fields in the Sales Target Report are explained below:

Target Type:

Target Type displays the Target audience.

Value:

Value displays the value as on a specific date.

Target Value:

Target Value is value to be achieved.

Actual Value:

Actual Value is the value on a specific date.

Export the Sales Target Report

Tagrain allows you to export your Sales Target Report via the export template. This template is excel based and allows you to review your sales target achieved in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once you have generated the Sales Target Report, click on the Export button to download the SalesTargetReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Collections and Delivery Order Report

Overview

Collections and Delivery Order Report, as is apparent from the name itself, is a report that is used to review and monitor the customer orders be it Home Delivery or Store Pickup. It lets you know if an order is pending or successfully delivered or picked up. In a nutshell, this report displays a fulfillment summary.

Steps to generate Collections and Delivery Order Report

Log in to your Tagrain Tenant and navigate to Home > Reports > Collections and Delivery Order Report. This will open the Collections and Delivery Order Report Master Screen. Upon clicking the Collections and Delivery Order Report, an exhaustive list of all the tender collected is auto populated. However, you may choose to selectively filter the report on the basis of Type, and/or Status.

Collections and Delivery Order Report Grid

The Collections and Delivery Order Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the orders fulfilled or pending.

This fulfillment data is crucial to your business and must be handled with caution. The various grid fields in the Tender Collection Report are explained below:

Transaction ID

Transaction ID is a unique alphanumeric number assigned to the Transaction. You have the option to expand the Transaction row to reveal information about the Product ID | Description | Quantity | Open Quantity | Pending | Total. A brief explanation of each of these is mentioned below:

Product ID

Displays the Product ID.

Description

Displays the Product Description.

Quantity

Displays the Ordered quantity.

Open Quantity

Displays the quantity that is eligible for a refund.

Pending

Displays the quantity that is yet to be delivered or picked up.

Total

Displays the Order Total.

Store

Store is the name of the store where the transaction occurred.

POS

POS is the name of the Point of Sale where the transaction was created.

Users

The name of the person who sold the products.

Actual Date

The date and time on which the transaction took place.

Customer

The name of the customer who purchased the product(s).

Transaction Status Type

This displays the type of transaction that occurred at the POS. Each transaction will fall under one of the following types:

● Completed

● Delivery Pending

● Pickup Pending

● Delivered

● Suspended

Delivery Option Type

This displays whether the product was Home Delivered or Store Picked.

Export the Collections and Delivery Order Report

Tagrain allows you to export your Collections and Delivery Order Report via the export template. This template is excel based and allows you to review all your fulfillment details in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once you have generated the Collections and Delivery Order Report, click the Export button to download the TenderCollectionReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Expense Report

Overview

Expense Report, as is apparent from the name itself, is a report that is used to review and monitor the expenses incurred during the day. It lets you know the amount of cash that was dispensed from the cash drawer on account of expenses.

Purpose

The purpose of an Expense Report is to keep a check on the cash amount being dispensed from the cash drawer on account of expenses. This also helps you to prioritise your expenses and ensure that amount is spent only on those expenses that are necessary.

Steps to generate Expense Report

Log in to your Tagrain Tenant and navigate to Home > Reports > Expense Report. This will open the Expense Report Master Screen.

On the Expense Report Master Data Screen, you need to select a Store, select a POS, select a User, specify a date range, and then click the Search button to generate the Expense Report.

Expense Report Grid

The Expense Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the expenses incurred.

This expense data is crucial to your business and must be handled with caution. The various grid fields in the Expense Report are explained below:

Store:

This grid displays the name of the Store where the expense was incurred.

POS:

This grid displays the name of the POS where the expense was incurred.

Date:

This grid displays the date and time stamp as to when the expense was incurred.

User:

This grid displays the name of the person logged in at the POS Register at the time when the expense incurred.

Expense Description:

This grid displays brief information about the type of expense occurred.

Amount:

This grid displays the amount dispensed from the cash drawer to meet the expense (above).

Export the Expense Report

Tagrain allows you to export your Expense Report via the export template. This template is excel based and allows you to review all your expenses incurred at the store in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management.

Once you have generated the Expense Report, click the Export button to download the ExpenseReport.xls file to your Downloads folder. However, if you want to save the file to a different location, click the Save As button instead. Navigate to your desired location on the drive and then click the Save button.

Z-Tape Report

Overview

Z Tape report is normally the last report that you would print for the POS / Register or the store and is therefore also called an end-of-day report. The reports summarize sales, refunds, and other till operations on the POS. More importantly the reports help reconcile cash and other payment types transacted on the POS. Z Tape Report is generated when the POS / Register is closed. At the click of Close Register button on the POS, the user is expected to enter the counted numbers of Cash and other payment types.

Once the user is done entering the counted numbers and clicks the Close Register button, the register is closed and the user is prompted to print the Z Tape report.

Steps to read the Z-Tape Report

Z Tape Report details a lot of information that proves useful only when you know how to read and understand its contents. The Report includes start and end date/time of the register, the user who closed the register, the opening amount in the drawer, Cash-Ins, Cash-Outs, Expenses, Closing amount (cash) and cash variance (if any).

For easy reference, the report mentions the formula that calculates the Cash Variance in the drawer.

Variance Amount = Closing Amount (entered) - Expected Drawer

Similarly, the report also mentions the formula that calculates the Total Cash in the drawer.

Transaction Total = Sales + Gift Card Sales - Refunds

The report goes on to mention the total number of All the transactions, total sales transactions and total number of refund transactions. The grid lists the amount collected for every Payment Type defined in the application.

Once a Z Tape report is generated, the numbers in the report cannot be changed.

Steps to generate Z-Tape Report

There are 2 ways you can generate a Z-Tape Report. One way is to generate it from under the Reports sub menu like in case of other Reports. The other way is to generate it from the Web Register.

Method 1 - From the Reports Sub Menu

Log in to your Tagrain Tenant and navigate to Home > Reports > Z-Tape Report. This will open the Z-Tape Report Master Screen. On the Z-Tape Report Master Screen, you need to select a Store, specify a date range, select a POS, and then click on the Search button to generate a Z-Tape Report.

Method 2 - From the Web Register

Log in to your Tagrain Tenant and navigate to Home > Web Register. Select a POS and specify an opening amount on the Opening Count screen, to begin your day with. Start recording your transactions on the Web Register. At day end, you need to click the Close Register tile to close your Web Register. The application will display a Till Count screen that gives you a summary of the sales transactions performed during the day.

You must count the numbers displayed against each Payment type to ensure they are in sync and then enter the counted numbers in the comments column. Once you are done entering the counted numbers you need to click on the Close Register button, the register is then closed and you are prompted to print the Z Tape report.

In stores where a POS is operated in multiple shifts, the same POS is closed more than once in a day - at the end of every shift. The sequence number in the Z Tape report clearly signifies the number of times the POS Register was closed in a day.

Export the Z-Tape Report

There is no way you can export a Z-Tape Report. Exporting a Z Tape report will only tempt a user to edit its contents. Z-Tape report is a snapshot of your everyday POS transaction and is crucial to your business. Once a Z Tape report is generated, the numbers in the report cannot be changed. You can however print a Z-Tape Report for your records.

Promotion Report

With the introduction of the Offers, Discounts and Pricing Management Plugin Tagrain allows retailers like you to define the following promotion types:

Buy X | Get Y
Buy X | For a fixed price
Buy X | Save an amount
Spend X | Save an amount

These promotions are configured in the application to automatically apply when a certain condition is met. To obtain a snapshot of the promotions applied over a period, you must run a Promotion Report. The report once generated can be filtered based on the time specified.

Purpose

The purpose of the Promotion Report is to analyze the total discount offered via promotions.

Steps to generate a Promotion Report

Go to Home > Reports > Promotion Report. Upon clicking the Promotion Report, an exhaustive list of the promotions offered is auto populated. You may later choose to filter the report generated, based on Promotion, Promotion Count, Promotional Discount, Transaction Count, and Total Transaction Value.

To selectively filter the report, you need to perform the following steps:

Navigate to Home > Reports >Promotion Report

Select the Store from the drop-down list. You can either type the name of the Store in the Store Text Field OR click on the [...] to select a Store on the Store Selection screen.

Note - If you do not select a Store, the report will be generated for all the Stores by default.

Select the Promotion from the drop-down list. You can either type the name of the Promotion in the Search Field OR click on the [...] to select a Promotion on the Promotion Selection screen.

Note - If you do not select a Promotion, the report will be generated for all the Promotions applied.

Specify a Date Range from the calendar. You can either select a predefined option like Today, Yesterday, Last 7 Days, Last 15 Days, Current Month, Last Month OR select a Custom Range.

Click on the Search button.

Promotion Report for the specified fields is generated.

Print the Promotion Report

Promotion Report can be printed using the Print button.

Promotion Report can be printed using the Print button. The steps to print the Promotion Report are listed below:

Step 1. Generate the Promotion Report.

Step 2. Click the Print button to open the Print Preview page.

Step 3. Select the destination printer.

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the Promotion Report.

Export the Promotion Report

Promotion Report can be exported using the Export button. The steps to export the Promotion Report are listed below:

Step 1. Generate the Promotion Report

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the Promotion Report.

Step 4. Click on the Save button to save the PromotionReport.xls file.

Idea - The PromotionReport.xls file is a .xls file and can be opened using Microsoft Excel or Google Sheets or any compatible spreadsheet processor.

When exporting the Promotion Report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings (Home > Setup > General Settings > Display Settings) OR the date time format of the Operating System OR Excel.

Promotion Report Data

Promotion

This field displays the name of the promotion applied.

Transaction Count

This field reflects the number of transactions that qualified for the promotion.

Promotion Count

This field displays the number of times the promotion was applied on the transaction. In the screenshot above, the Promotion Count for the Spend $1500, Save 15% is displayed as 6. This means that this promotion was applied six times on the transaction.

Total Transaction Value

This field displays the total value of the transaction. In the screenshot above, the total value of the transaction on which the Spend $1500, Save 15% promotion was applied is $1428.52

Promotional Discount

This field displays the total discount offered. In the screenshot above, the total promotional discount offered via the Spend $1000, Save 10% promotion was $235.05

BIR Sale Transaction Report is used for reviewing and monitoring the sale transactions done on a particular day and for a specified store.

The BIR Sale Transaction Report contains the following information:

Transaction Id
Customer Id
Customer Name
Customer Address
Customer TIN
Gross Sales
Net Sales
VATable Sales
VAT Exempt Sales
Zero Rated Sales
VAT Amount
Regular Discount
VAT Amount SC/PWD
Senior Citizen Discount
Person With Disability Discount

There are some very specific features that a retail POS application must possess to qualify for being used by retailers in The Philippines.

When you create a new tenant, on the Tenant Registration Page there is a specific section that prompts you to select the Country and the Trading Currency. You need to select The Philippines as your country and Philippine Peso as your currency.

The BIR (Bureau of Internal Revenue) features are country specific and are applicable only in the Philippines.

These country specific features are activated only when you select The Philippines as your country and Philippine Peso as your currency.

Steps to generate the BIR Sale Transaction Report

The steps to generate the BIR Sale Transaction Report, are explained below:

Navigate to Home > Reports > BIR Sale Transaction Report

Select the POS. This field is mandatory. You can either type the name of the POS in the POS Text Field OR click on the [...] to select a POS on the POS Selection screen.

Specify a Date Range for which the report is to be generated. You can either click on the date itself to pick the Start Date and the End Date OR use the Date Template to pick a date range from the menu displayed on the right. You can even define a Custom Date Range. Click the Apply button to save the Date Range specified.

Click on the Search Button to generate the report.

Once the report is generated, the columns can then be filtered in ascending / descending order.

The BIR Sale Transaction Report is displayed in a grid format. Every row in the grid represents a transaction. Each column in the grid represents the different values of the transaction (row)

Export the BIR Sale Transaction Report

BIR Sale Transaction Report can be exported using the Export button.

The steps to export the BIR Sale Transaction Report are as follows:

Step 1. Generate the BIR Sale Transaction Report

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the BIR Sale Transaction Report.

Step 4. Click on the Save button to save the BIRSaleTransactionReport.xls file.

When exporting the BIR Sale Transaction Report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings (Home > Setup > General Settings > Display Settings) OR the date time format of the Operating System OR Excel.

Print the BIR Sale Transaction Report

BIR Sale Transaction Report can be printed using the Print button. The steps to print a BIR Sale Transaction Report are explained below:

Step 1. Generate the BIR Sale Transaction Report.

Step 2. Click the Print button to open the Print Preview page.

Step 3. Select the destination printer.

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the BIR Sale Transaction Report.

BIR Sales Report Summary is used for reviewing and monitoring the sale transactions done on a particular day and for a specified store.

The BIR (Bureau of Internal Revenue) Sales Report Summary report contains the following information:

Date
Start No.
End No.
Starting Sales
End Sales
Daily Sales
Senior Discount
PWD Discount
Sales Count
Refund Count
VAT Exempt Sales
Zero Rated Sales
VAT Amount
Regular Discount
Number of Products
Total Quantity

Steps to generate the BIR Sales Report Summary

The steps to generate the BIR Sales Report Summary are explained below:

Navigate to Home > Reports > BIR Sales Report Summary Report

Select the POS. This field is mandatory. You can either type the name of the POS in the POS Text Field OR click on the [...] to select a POS on the POS Selection screen.

Click on the Search Button to generate the report.

Once the report is generated, the columns can then be filtered in ascending / descending order.

The BIR Sales Report Summary is displayed in a grid format. Every row in the grid represents an EOD report (Z Reading). Each column in the grid represents the different values of the EOD report. See: Z Reading

BIR Sales Report Summary Report Data

The BIR (Bureau of Internal Revenue) Sales Report Summary report contains the following information:

Date
Start No.
End No.
Starting Sales
End Sales
Daily Sales
Senior Discount
PWD Discount
Sales Count
Refund Count
VAT Exempt Sales
Zero Rated Sales
VAT Amount
Regular Discount
Number of Products
Total Quantity

Export the BIR Sales Report Summary

BIR Sales Report Summary can be exported using the Export button.

The steps to export the BIR Sales Report Summary are as follows:

Step 1. Generate the BIR Sales Report Summary

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the BIR Sales Report Summary

Step 4. Click on the Save button to save the BIRSalesReportSummary.xls file.

When exporting the BIR Sales Report Summary, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings (Home > Setup > General Settings > Display Settings) OR the date time format of the Operating System OR Excel.

Print the BIR Sales Report Summary

BIR Sales Report Summary can be printed using the Print button. The steps to print a BIR Sales Report Summary are explained below:

Step 1. Generate the BIR Sales Report Summary.

Step 2. Click the Print button to open the Print Preview page.

Step 3. Select the destination printer.

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the BIR Sales Report Summary.

BIR Refund By Item Report

BIR Refund By Item Report is specific to BIR (Bureau of Internal Revenue) in the Philippines. This report is used to keep a track of all the products refunded in refund sale transactions.

The BIR Refund By Item Report contains all the information pertaining to a refund transaction

Transaction Date
Transaction ID
Original Transaction ID
Product Code
Product Description
Price
Quantity
Amount

Steps to generate the BIR Refund By Item Report

The steps to generate the BIR Refund By Item Report are explained below:

Navigate to Home > Reports > BIR Refund By Item Report

Select the POS. This field is mandatory. You can either type the name of the POS in the POS Text Field OR click on the [...] to select a POS on the POS Selection screen.

Click on the Search Button to generate the report.

Once the report is generated, the columns can then be filtered in ascending / descending order.

The BIR Refund By Item Report is displayed in a grid format. Every row in the grid represents a transaction. Each column in the grid represents the different values of the transaction (row)

BIR Refund By Item Report Data

The BIR Refund By Item Report contains all the information pertaining to a refund transaction

Transaction Date
Transaction ID
Original Transaction ID
Product Code
Product Description
Price
Quantity
Amount
Discount

Export the BIR Refund By Item Report

The BIR Refund By Item Report can be exported using the Export button. The steps to export the BIR Refund By Item Report are as follows:

Step 1. Generate the BIR Refund By Item Report button

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the BIR Refund By Item Report.

Step 4. Click on the Save button to save the BIRRefundByItemReport.xls file.

When exporting the BIR Refund By Item Report report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings (Home > Setup > General Settings > Display Settings) OR the date time format of the Operating System OR Excel.

Print the BIR Refund By Item Report Report

BIR Refund By Item Report can be printed using the Print button.

Click the Print button to open the Print Preview page. Specify the print options like the destination printer, number of copies and pages to be printed etc. Click on the Print button to print the BIR Refund By Item Report.

BIR Refund Report

BIR Refund Report is specific to BIR (Bureau of Internal Revenue) in the Philippines. This report is used for reviewing and monitoring the refund sale transactions done on a POS terminal.

The BIR Refund Report contains the following information:

Transaction Id
Transaction Date
Return Number Invoice
Quantity
Vatable Refund
BIR Vat Amount
Refund Amount
Discount

Steps to generate the BIR Refund Report

The steps to generate the BIR Refund Report are explained below:

Navigate to Home > Reports > BIR Refund Report

Select the POS. This field is mandatory. You can either type the name of the POS in the POS Text Field OR click on the [...] to select a POS on the POS Selection screen.

Click on the Search Button to generate the report.

Once the report is generated, the columns can then be filtered in ascending / descending order.

The BIR Refund Report is displayed in a grid format. Every row in the grid represents a transaction. Each column in the grid represents the different values of the transaction (row)

BIR Refund Report Data

The BIR Refund Report contains the following information:

Transaction ID
Transaction Date
Return Number Invoice
Quantity
VATable Refund
BIR Vat Amount
Refund Amount
Discount

Export the BIR Refund Report

The BIR Refund Report can be exported using the Export button. The steps to export the BIR Refund Report are as follows:

Step 1. Generate the BIR Refund Report button

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the BIR Refund Report.

Step 4. Click on the Save button to save the BIRRefundReport.xls file.

When exporting the BIR Refund Report report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings (Home > Setup > General Settings > Display Settings) OR the date time format of the Operating System OR Excel.

Print the BIR Refund Report

BIR Refund Report can be printed using the Print button. The steps to print a BIR Refund Report are explained below:

Step 1. Generate the BIR Refund Report.

Step 2. Click the Print button to open the Print Preview page.

Step 3. Select the destination printer.

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the BIR Refund Report.

BIR Discount Report

BIR Discount Report is specific to BIR (Bureau of Internal Revenue) in the Philippines. This report is used for reviewing and monitoring the discount offered to:

General customers
Senior Citizen customers and Person With Disability customers

The BIR Discount Report contains the following information:

Transaction Date
Transaction Id
Amount
VATable Sale on Discount
VAT Exempt Sale on Discount
VAT On Discount
Discount

Steps to generate the BIR Discount Report

The steps to generate the BIR Refund Report are explained below:

Navigate to Home > Reports > BIR Discount Report

Select the POS. This field is mandatory. You can either type the name of the POS in the POS Text Field OR click on the [...] to select a POS on the POS Selection screen.

Select the Discount Type from the drop-down. This field lets you decide whether you want to generate a report incorporating General discount or Senior Citizen or Person With Disability discount.

Click on the Search Button to generate the report.

Once the report is generated, the columns can then be filtered in ascending / descending order.

The BIR Discount Report is displayed in a grid format. Every row in the grid represents a transaction. Each column in the grid represents the different values of the transaction (row)

BIR Discount Report Data

The BIR Discount Report contains the following information:

Transaction Date
Transaction ID
Amount
VATable Sale on Discount
VAT Exempt Sale on Discount
VAT on Discount
Discount

Export the BIR Discount Report

The BIR Discount Report can be exported using the Export button. The steps to export the BIR Discount Report are as follows:

Step 1. Generate the BIR Discount Report button

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the BIR Discount Report.

Step 4. Click on the Save button to save the BIRDiscountReport.xls file.

BIR Discount Report - Regular Discounts

The BIR Regular Discount Report is generated when you select Standard as the Discount Type.

BIR Discount Report - Senior Citizen Discounts

The BIR Senior Citizen Discount Report is generated when you select Senior Citizen as the Discount Type.

When exporting the BIR Discount Report report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings (Home > Setup > General Settings > Display Settings) OR the date time format of the Operating System OR Excel.

Print the BIR Discount Report

BIR Discount Report can be printed using the Print button. The steps to print the BIR Discount Report are explained below:

Step 1. Generate the BIR Discount Report.

Step 2. Click the Print button to open the Print Preview page.

Step 3. Select the destination printer.

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the BIR Discount Report.

BIR Audit Log Report

Audit Log Report in Tagrain is used to record the chronological sequence of activities performed by the user. The activity is recorded from the time the user logs in to the application and is recorded until the user logs out from the application. Since every click and every activity done on the POS system is recorded, the report proves useful in ensuring that the procedures being followed are in compliance with the BIR regulations.

The Audit Log Report can be further used to review and monitor the steps performed by the user, to prevent any security breach or misuse of information.

Steps to generate Audit Log Report

The steps to generate the Audit Log Report are explained below:

Navigate to Home > Reports > Audit Log Report.

Select the POS. This field is mandatory. You can either type the name of the POS in the POS Text Field OR click on the [...] to select a POS on the POS Selection screen.

Select the User. You can either type the name of the User in the User Text Field OR click on the [...] to select a User on the User Selection screen.

Click on Search Button, to generate the Audit Log Report.

Once the report is generated, the columns can then be filtered in ascending / descending order. You can also print or export the report.

Export the Audit Log Report

Audit Log Report can be exported using the Export button. The steps to export the Audit Log Report are as follows:

Step 1. Generate the Audit Log Report button

Step 2. Click on the Export button

Step 3. Browse to a location where you want to save the Audit Log Report.

Step 4. Click on the Save button to save the AuditLogReport.xls file.

The exported Audit Log Report has a single worksheet labeled - Cashier Activity Report

Cashier Activity Report (sheet)

This is the list of all the activities carried out by a cashier from the time he logged in to the time he logged out from the application.

Print the Audit Log Report

Audit Log Report can be Printed using the Print button. The steps to print the Audit Log Report are explained below:

Step 1. Generate the Audit Log Report.

Step 2. Click the Print button to open the Print Preview page.

Step 3. Select the destination printer.

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the Audit Log Report.

When exporting the Audit Log report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings ( Home > Setup > General Settings > Display Settings ) OR the date time format of the Operating System OR Excel.

Related Articles
Tagrain Quick Start Guide
Welcome to Tagrain … Congratulations on signing up with Tagrain! At the end of your 14-day evaluation, you either opt for a free COMMUNITY edition OR become a paid subscriber of the ENTERPRISE Edition. Tagrain gives you some sample data. This sample ...
Tagrain Hospitality Guide
Tagrain Hospitality Overview Tagrain Hospitality is targeted towards small sized cafes and restaurants that sell food items like Burgers, Wraps, Sandwiches, Muffins, Pastries and beverages like coffee, tea, and bottled drinks along with service. ...
Cashiers Guide to Tagrain App for iPad
Cashiers Guide to Tagrain App for iPad This guide is designed to help cashiers learn the daily processes around selling using the Tagrain App for iOS. Meet the sell screen Adding products to the sale Adjusting product quantities Line Level ...
Cashiers Guide to Tagrain App for Android Tablet
Cashiers Guide to Tagrain App for Android This guide is designed to help cashiers learn the daily processes around selling using the Tagrain App for Android. Meet the sell screen Adding products to the sale Adjusting product quantities Line Level ...