How every figure on the Z‑Reading is calculated. Use this to answer "where does this number come from?"
The end‑of‑day fiscal reset for one POS terminal. Each terminal files its own Z per calendar day, with its own Z counter. Once filed, that terminal is locked for that date — a second attempt just reprints and shows "You have already generated a Z‑Reading for this date."
Everything on it covers: one Sales Date, one terminal (Terminal #), all shifts on that terminal combined.
| Line | Where it comes from |
|---|---|
| Terminal # | The workstation number of this POS. |
| Cashier | The user logged in when the Z was run. |
| Report Date / Time | The moment the Z‑Reading was generated. |
| Sales Date | The business day being closed. |
| Z Counter | This terminal's own running count of Z‑Readings + 1. A brand‑new terminal starts at 1. |
| Reset Counter | This terminal's reset counter (increments only if the OR number ever rolls over at 99,999,999 — normally stays 0). |
| Line | Formula |
|---|---|
| Beg. Balance | Sum of all Net Amount (total paid) for this terminal for every day before today. This is the running "grand total" as it stood at yesterday's close. |
| Net Amount | Today's net: Σ (sales total paid) − Σ (refund amounts). |
| Ending Balance | Beg. Balance + Net Amount — the new running grand total. |
| Acc. Grand Total | Same as Ending Balance (the accumulated grand total after this Z). |
| Closing Total | Same as Net Amount (today's net). |
A cross‑date void (a sale from an earlier day cancelled today) stays inside the grand total — it was a real sale on its own day. It shows on today's Void Sales line but does not pull the register down.
| Line | Formula |
|---|---|
| Beg. Invoice # / Ending Invoice # | The lowest / highest OR number issued on this terminal today (sales + voided sales). |
| # of Transactions | Count of sales + voided sales, plus the count of voids again. (The voided ticket is counted twice — this is how the report has always worked.) |
| # of Void Trx's | Count of transactions voided today on this terminal. |
| # of Items Sold | Total quantity of line items on sales tickets. (A refunded item is not subtracted here — this is the gross count.) |
All of these are net of same‑day refunds and exclude voids.
| Line | Formula |
|---|---|
| Gross Amount | Original selling price (VAT‑inclusive, before any discount) of all sold items − the VAT portion of SC/PWD discounts − refunds − a small discount‑rounding reconciliation. This is the "grossed‑up" sales figure. |
| Sales Ret (Vat Incl) | Total of returned/refunded VATable line items (negative). |
| Sales Ret (Vat Exmp) | Total of returned/refunded VAT‑exempt line items (negative). |
| Void Sales | Total amount of all transactions voided today (shown negative). Informational only — not deducted from anything below. |
| SC Discount | Senior Citizen discount granted (SC method), net of any refunded senior sales. |
| PWD Discount | PWD discount granted (PWD method), net of refunds. |
| Regular | Ordinary line discounts (not SC/PWD), net of refunds. If a discounted sale is fully refunded, this nets to 0.00. |
| VATable Sales | Σ (VATable sales of each invoice) − Σ (VATable portion of refunds). |
| VAT Amount | Σ (output VAT of each invoice) − Σ (VAT portion of refunds). |
| VAT‑Exempt Sales | Σ (VAT‑exempt sales) − Σ (exempt portion of refunds). |
| Zero‑Rated Sales | Σ of zero‑rated line items. |
| Net Amt (VAT Incl) | VATable Sales × 1.12. |
| Net Amt (VAT Ex.) | Net Amount − VAT Amount. |
VAT Amount is the sum of each invoice's already‑rounded VAT, not VATable × 12% recomputed. They can differ by a centavo — the per‑invoice figure is the correct one, and it is what gets filed.
| Line | Formula |
|---|---|
| CASH / VISA / GCASH / … (per method) | Σ of all payments of that method collected for this terminal today. |
| Total (bottom) | Same as Net Amount. |
A refund posts a negative payment against the original tender method, so the breakdown stays in step with the cash drawer.
On a clean day, these all tie to the centavo:
Gross Amount = VATable Sales + VAT Amount + VAT-Exempt Sales + Zero-Rated Sales Net Amount = Gross Amount − SC Discount − PWD Discount − Regular Net Amt(VAT Incl) = VATable Sales × 1.12 Net Amt(VAT Ex.) = Net Amount − VAT Amount Ending Balance = Beg. Balance + Net Amount Payment Breakdown total = Net Amount
| Symptom | Explanation |
|---|---|
| A voided sale's amount isn't in VATable Sales / Net Amount | Correct. Voids only appear on the Void Sales line. |
| A discounted sale was refunded, but a discount line still shows an amount | The refund should net it to 0. If it doesn't for SC/PWD, the refund ticket wasn't tagged as a senior/PWD transaction. |
| Payment Breakdown total ≠ Net Amount | A refund was processed without going through the normal refund flow (no negative payment row was posted). |
| A reprint of an old Z shows slightly different centavos | Re-running any reading re-derives that day's VAT columns from the line items. The originally‑printed paper is the record of truth. |
| A prior day's reprinted Z shows lower VATable than the paper | A sale from that day was voided on a later day. The tax lines on a reprint reflect the void; the original filed Z does not. |
| Each terminal's Z counter is different / a new terminal starts at 1 | Expected. Every terminal keeps its own independent Z counter. |