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	Manager = 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 = 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 format
Date Filter Limit	None

View Table 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 VAT Adjustment Computation = Displayed VAT Exempt Sales / .80 + Displayed Zero Rated Sales * 0.12
VATable Sales	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 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	(for checking with dev, no trigger on POS)
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	(for checking with dev, no trigger on POS)
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
Show VAT Adjustment column	The removed VAT from Senior Citizen, PWD and Diplomat transactions	Q4 2025
Gross Sales-based Beginning and Ending Balance	Update the computation from based on Net Sales to Gross Sales	Dec 2025
Show Service Charge column	The service charge for table service locations