X & Z Report
At the end of each day, the X and Z reports should be printed (to track and manage transaction data, including cash in the drawer, and so on) and to declare tender (count and mark the values of each tender received that requires counting.
The X report gives information such as the Gross sale, discounts, and sales in each tender type, and information about tender operation amounts since the last Z-report.
Disclaimer: Now, we support the X and Z report for all countries' apps except the NA countries' app. You can print the End of Day report before posting it.
In this article
Report header information
Both the X report and the Z report open with the same header block, identifying the company and the period, store, staff, drawer, and POS terminal that the report covers.
| Field | Description |
|---|---|
| Company name and VAT registration number | The name and VAT registration number of the company, as set up on the Company Information page. |
| Store No. | The store that the report was run for. |
| Datetime | On the X report, the date and time the report was produced. On the Z report, the date and time the closed-out summary was posted. |
| From Datetime / To Datetime | The start and end of the period that the report covers. |
| Staff ID | The staff member the report is filtered to, if the report was run for a specific staff member rather than for the whole store or drawer. |
| POS ID | The identifier of the POS terminal that the report was produced on. |
| Drawer ID | The drawer that the report is filtered to. |
| X-Report No. / Z-Report No. | The number of the underlying store summary (X report) or posted close-out summary (Z report) that the figures on the report were calculated from. |
Sales and returns summary
Sales and returns are reported separately, each broken down into a gross amount, the discount taken out of that gross amount, and the resulting net amount.
| Field | Description |
|---|---|
| Total gross sales | Total sales for the period before line and invoice discounts are deducted. |
| Total discount (sales) | Total line and invoice discounts deducted from sales for the period. |
| Total net sales | Total sales for the period after discounts, that is, the amount actually charged to customers. |
| Total gross return | Total returns for the period before discounts are deducted. |
| Total discount (returns) | Total line and invoice discounts on returns for the period. |
| Total net return | Total returns for the period after discounts. |
| Grand total net sales | Total net sales combined with total net returns for the period. |
Statistics
The statistics section counts transactions and POS activity for the period.
| Field | Description |
|---|---|
| No. of sales transactions | Number of posted sales invoices for the period. |
| No. of voided transactions | Number of sales that were deleted at the POS during the period (logged as Delete Sales in the POS Action Log). |
| No. of returned transactions | Number of posted sales credit memos for the period. |
| No. of items sold / No. of items returned | Total quantity of inventory and non-inventory items sold and returned during the period. |
| No. of services sold / No. of services returned | Total quantity of service-type items sold and returned during the period. |
| No. of inv. copies printed / Total inv. copies printed amount | Number and total amount of posted sales invoices that have been printed more than once during the period. |
| No. of rcpt. copies printed / Total rcpt. copies printed amount | Number and total amount of sales receipts that have been printed more than once during the period. |
| No. of drawer openings | Number of times the drawer was opened without an active sale during the period (logged as Open Drawer in the POS Action Log). |
| No. of suspended sales / Suspended sales amount | Number and total amount of sales that were suspended at the POS during the period. |
| No. of payment line deleted / Total amount of payment line deleted | Number and total amount of payment lines that were deleted at the POS during the period (logged as Delete Payment in the POS Action Log). |
Float cash
The float cash section reports cash movements in and out of the drawer that are not tied to a sale, such as adding or removing float.
| Field | Description |
|---|---|
| Total added cash | Total cash added to the drawer during the period, outside of a sale. |
| Total removed cash | Total cash removed from the drawer during the period, outside of a sale. |
| Net float cash | Total added cash and total removed cash combined. |
Customer account activity
This section reports sales and payments that reduce the day's cash and card sales because they were posted to, or paid from, a customer account instead of settled directly at the POS.
| Field | Description |
|---|---|
| No. of sales posted to acc. / Total of sales posted to acc. | Number and total outstanding amount of posted sales invoices marked to pay to a customer account, that is, sales for which no payment was collected at the POS. |
| No. of returns posted to acc. / Total return amount posted to acc. | Number and total outstanding amount of posted sales credit memos marked to pay to a customer account. |
| No. of customer payment / Total of customer payment | Number and total amount of payments received during the period against a customer's previously posted invoices, rather than at the point of sale. |
Sales by item category
A line is printed for every item category with sales in the period, showing the net sales amount for that category, followed by the combined total.
| Field | Description |
|---|---|
| Item category | The description of an item category that had sales during the period, with the sales amount for that category next to it. |
| Total item category | The combined sales amount across all item categories shown. |
Tax breakdown
Sales are broken down by VAT percentage, since the disclaimer above means this page's countries always report by VAT %, not by tax group.
| Field | Description |
|---|---|
| VAT % | A VAT percentage that was used on sales during the period, with the total VAT amount charged at that percentage next to it. |
| Total vat amount | The combined VAT amount across all VAT percentages shown. |
Payment method breakdown
Sales, returns, refunds, and amounts posted to a customer account are broken down by payment method.
Note: The total for a payment method is net of refunds, returns, and amounts posted to a customer account through that payment method, so it can legitimately be negative for the period — for example, if a payment method saw more refunds than sales. This is expected behavior, not an error. On the equivalent close-out screens in LS Express, a negative total for a payment method is shown with the same styling used for an unfavorable amount, so it stands out from a normal (favorable) positive total.
| Field | Description |
|---|---|
| Payment method | A payment method that was used during the period, with the total amount taken through that payment method next to it. |
| Total payment amount | The combined amount across all payment methods shown. |
X report vs. Z report
The X report and the Z report show the same fields, described above. The X report can be printed at any time during the day as a preview of the current, still-open summary, and printing it does not change any data. The Z report is printed from the posted, closed-out summary: once it has been posted, the sales and return data behind it is marked as belonging to that Z report and cannot be included in a later summary.
Note: The report number shown is the X-Report No. on the X report and the Z-Report No. on the Z report.