.jpg){kind=logo}
Know your Back Office E-Journal Report
| Objective | This report aims to generate the soft copy of POS printouts such as Bill, Sales Invoice, Void Slip, X-Read and Z-Read. Computations are the same with POS Printouts. |
|---|---|
| User Access | Manager = Store Admin = can access own e-journal only Brand = no access Enterprise = can access all locations' e-journal Super Admin = can access all accounts' e-journal |
| Date Filter Limit | None |
Filters
| Field / Button | Description | User Access |
|---|---|---|
| From Date | Start Date of POS Date that wants to check | All Users |
| To Date | End Date of POS Date that wants to check. Limited to 3 days difference from From Date. | All Users |
| Account | Account Name | Super Admin |
| Location | Location Name | Enterprise, Super Admin |
| Terminal | Terminal Name where transaction was processed | All Users |
| OR Number | Official Receipt or Sales Invoice Number of the transaction that wants to check | All Users |
Types of POS Printout
| Printout | Description |
|---|---|
| Bill | The transaction bill for settlement |
| Sales Invoice | The official receipt or invoice of the transaction |
| Void Slip | The void confirmation of the transaction |
| X-Read | The report consolidating sales for particular shift |
| Z-Read | The report consolidating sales for the whole business date |
Z-READ
| Data Line | Description |
|---|---|
| Report Title | "Z-Report" |
| Account Name | The name of the account or alias if provided on the Back Office |
| Location Name | The name of the store location |
| Location Address | The address of the store location |
| VAT Reg TIN | The registered VAT TIN |
| Machine Identification Number | The identification number of the machine |
| Serial Number | The serial number of the machine |
| Report Title | "Z-Reading" |
| 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 Inclusion: Beginning Balance + Net Sales |
| Beginning OR # | The Sales Invoice Number of the first transaction of the business date including voided settled transaction |
| Ending OR # | The Sales Invoice Number of the last transaction of the business date including voided settled transaction |
| Beginning Bill # | The Bill Number of the first transaction of the business date including voided billed transaction |
| Ending Bill # | The Bill Number of the last transaction of the business date including voided billed transaction |
| Beginning Void # | The Void Number of the first voided transaction of the business date. If there's no voided transaction, it will use the last voided transaction's Void Number. |
| Ending Void # | The Void Number of the last voided transaction of the business date. If there's no voided transaction, it will use the last voided transaction's Void Number. |
| Beginning Void Amount | The accumulated amount of voided settled transactions |
| Ending Void Amount | The accumulated amount of voided settled transactions plus the voided amount for the current POS date Inclusion: Beginning Void Amount + Voided Sales Amount |
| Gross Sales | Sales before all deductions and after VAT and All Charges 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 |
| Gross w/ Void | Gross Sales plus voided settled amount |
| Gross w/o Service Charge | Gross Sales excluding Service Charge and Other Charges |
| Service Charge | The total amount of Service Charge if applicable |
| Other Charges | Other Charges such as Delivery Fee, Packaging Fee, etc if applicable |
| Net Sales w/ VAT & SC | The total amount of collection Inclusion: Net Sales + All Charges such as Tax, Service Charge and Other Charges |
| Discounts | The breakdown and total of all discounts used including open and aggregators discounts |
| VAT Adjustment | The removed VAT from Tax-Inclusive Item and Modifier Prices. Based on 12% VAT Computation: Tax-Inclusive Item and Modifier Prices / 1.12 * 0.12 |
| VATable Sales | The Item and Modifier Price less the VAT Computation: Tax-Inclusive Item and Modifier Prices / 1.12 |
| VAT Amount | The VAT from Tax-Inclusive Item and Modifier Prices. Based on 12% VAT 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 |
| Net Sales | Sales after all deductions and before VAT Inclusion: Sum of VATable Sales, VAT Exempt Sales and Zero Rated Sales |
| Voided Sales | Amount of voided paid transactions, in Gross Sales with all charges |
| Voided Billed | Amount of voided billed but unpaid transactions, excluding Service Charge and Other Charges |
| Service Type Sales | Net Sales per Service Type |
| Income Head Sales | Total Items and Modifiers Sold and Net Sales per Product Category |
| Breakdown of Tender | Total amount of collection per payment type |
| Cash Funds | The in and out of the cash on the cash drawer - Beginning Fund, Cash Bleed/Withdraw and Additional Fund |
| Cash Drawer | The current cash amount on the cash drawer after cash fund logs |
| Z-Counter | The Z-Counter or number of the current POS Date. It increments upon every day end. |
| Product Mix Summary | The summary of items and modifiers sold for the current POS date |
Download
| File Format |
|---|
| zip > txt |
Future Enhancements
| Description | Target Deployment Date | |
|---|---|---|
| Generate specific type of report only - z-read, x-read, sales invoice, bill, all | Q4 2025 |