Know your Back Office BIR Sales Summary Report

Objective	This report aims to generate the Sales Summary Report that clients submit to BIR for auditing
User Access	Store Admin = can access own sales summary only Brand = no access Enterprise = can access all locations' sales summary Super Admin = can access all accounts' sales summary
Filter Fields and Buttons	Manager From Date, To Date, [Generate] Store Admin From Date, To Date, [Generate] Brand no values/disabled Enterprise From Date, To Date, Location, [Generate] Super Admin From Date, To Date, Account, Location, [Generate]
Page Buttons	[Download Excel] - xls and xlsx format
Date Filter Limit	None

Values

View Table Column	Description and Computation
Date	POS Date
MIN	The MIN of the device used for day end process
Invoice Number From	The Sales Invoice Number of the first transaction of the day, including Voided Settled transactions
Invoice Number To	The Sales Invoice Number of the last transaction of the day, including Voided Settled transactions
Beginning Balance	The accumulated grand total sales (based on net sales) as of previous POS Date
Ending Balance	The accumulated grand total sales (based on net sales) as of previous POS Date plus the net sales of the current POS Date
Net Sales	Sales after all deductions and before VAT Inclusion: Sum of VATable Sales, VAT Exempt Sales and Zero Rated Sales
Gross Sales	Sales before all deductions and after VAT Inclusion: Sum of VATable Sales, VAT, VAT Exempt Sales, Zero Rated Sales, All Discounts, VAT Adjustment, Service Charge and Other Charges
VATable Sales	Tax-Inclusive Prices: The Item and Modifier Price less the VAT Computation: Tax-Inclusive Item and Modifier Prices / 1.12
VAT	The VAT from Tax-Inclusive Item and Modifier Prices Computation: Tax-Inclusive Item and Modifier Prices / 1.12 * 0.12
VAT Exempt Sales	The sales after Senior Citizen and PWD Discounts and VAT Removal Tax-Exclusive Prices Computation: (For 20% Senior Citizen and PWD Discounts) Tax-Inclusive Item and Modifier Prices / 1.12 * .80
Zero Rated Sales	The sales after VAT Removal for Diplomat Discount Computation: (For Diplomat Discount) Tax-Inclusive Item and Modifier Prices / 1.12
Delivery Fee	(for checking with dev, no trigger on POS)
Other Income	(for checking with dev, no trigger on POS)
GC Excess	The excess payment when customer use Gift Certificate or Voucher as payment
Discount PWD	The deducted PWD Discount based on set percentage or amount (20%, 5%, etc) Limitation: Deductions from aggregators (Grab, FoodPanda) not yet included
Discount Senior	The deducted Senior Citizen Discount based on set percentage or amount (20%, 5%, etc) Limitation: Deductions from aggregators (Grab, FoodPanda) not yet included
Discount Other	All deducted regular discounts not falling under Senior Citizen and PWD
VAT Adjustment	The VAT removed from Senior Citizen, PWD and Diplomat transactions
Sales Overrun Amount	The discrepancy between recorded Cash Sales on POS versus declared by the Cashier a. Over = if the cashier declared higher cash amount versus expected b. Short = if the cashier declared lower cash amount versus expected
Returns	Not supported on POS. 0 by default
Void	Amount of voided paid transactions, in Gross Sales with all charges
EOD Counter	Also known as Z-Counter on Z-Read, increments every day end
Remarks	Blank by default

Future Enhancements

	Description	Target Deployment Date
Gross Sales-based Beginning and Ending Balance	Update the computation from based on Net Sales to Gross Sales
Show Service Charge column	The service charge for table service locations