Closing the Batch, Not the Shop: Daily Card Reconciliation for Bristol Independents

At the end of a trading day, most card terminals will ask whether the batch should be settled. For many independent businesses, the prompt is acknowledged and the report is filed without much inspection. That is understandable when the shop is being closed and staff are waiting to leave, but the Z report is one of the more useful control documents a card-accepting business receives. It does not need to become an accounting project. A short, consistent routine is usually enough to show whether the day's card takings are internally consistent and ready to pass into the accounts.

What a Z report actually proves

A card terminal groups transactions into a batch. When the batch is closed, the terminal produces a Z report and submits the batch to the acquirer. The report typically shows the number and value of sales by card scheme, refunds processed in that batch, and any gratuities or surcharges that have been configured to pass through the terminal. It may also show voided transactions, offline transactions or open pre-authorisations, depending on the terminal and the arrangement with the provider.

The important point is what the Z report proves. It proves what the terminal recorded and submitted at the point of closure. It does not prove that the money has reached the bank account, that the till or EPOS agrees, or that the figures are ready for VAT accounting. It is a batch control record, not a substitute for the sales ledger. Read in that light, it becomes a practical daily check rather than another administrative task.

The five-minute routine

The routine should begin before the till is cashed up. Confirm that no customer is midway through a card transaction and that all staff have finished using any handheld terminals. If the business uses more than one terminal, each will normally have its own batch. Close them in a consistent order and keep the reports together.

Run the Z report at roughly the same time each day. Print it or save the electronic copy in a dated folder. Note the batch number, the terminal identifier and the time of closure. Then compare the card total on the report with the card total recorded by the till or EPOS. A simple note of any difference is more useful than attempting to resolve every small query immediately. The purpose of the five minutes is to establish a daily record, not to recreate the month-end accounts at 6pm.

Matching the batch to the till

Start with the gross card sales figure. This is normally the value of sales before refunds are deducted. Check that the till or EPOS shows a comparable card sales figure for the same period. If the terminal is configured to add gratuities, decide whether those tips are included in the card total on the till. If they are recorded separately, the comparison will need to reflect that.

Next, look at refunds. A Z report usually shows refunds processed in the batch. Some tills record refunds as negative sales, while others record them separately. The arithmetic should still be clear: gross card sales less refunds should equal the net batch total. If the terminal adds a surcharge, that may also need to be separated out. Cashback, where offered, can further complicate the comparison because it is not a sale but does affect the amount submitted.

If the figures do not agree, check the common causes before assuming a fault. A transaction may have been declined after the till believed it had been accepted. A split tender may have been recorded differently. A training-mode transaction may have been included by mistake. A manual entry or an offline transaction may have been submitted later. A completed pre-authorisation may not yet be a sale. A short discrepancy log, kept with the daily reports, will usually reveal a pattern within a few weeks.

Refunds, gratuities and later adjustments

Refunds are not the only items that move the batch total. Gratuities added at the terminal can be included in the settlement and may need to be separated for payroll or staff distribution. If the business operates a tronc or another arrangement for sharing tips, the daily Z report should be reconciled with the record used for that arrangement. The terminal report is not a substitute for a clear tipping policy, but it is a useful cross-check.

Chargebacks generally do not appear on the daily Z report in the way a refund does. They arrive later as adjustments through the acquirer, often after the customer has contacted their card issuer. A daily reconciliation routine can therefore catch sales and refund discrepancies, but it cannot catch every chargeback on the day. That is why the Z report should be paired with a periodic review of settlement statements and chargeback notices. The daily habit prevents small gaps from becoming unexplained month-end entries; the monthly review catches the items that operate on a different timetable.

Settlement is a separate step

The Z report shows what was submitted. Settlement shows what the acquirer has processed and what will be paid, after fees and any adjustments. The two figures will not usually match exactly. A card payment submitted on a Friday may not settle until the next business day, and weekend timing can vary by provider. Fees are typically deducted before the funds reach the bank account.

For that reason, the daily Z report should not be reconciled directly against the bank feed without allowing for settlement timing and fees. Use the provider portal or settlement statement to match the batch number to the expected payment. If a batch appears to be missing, quote the batch number, terminal identifier and closure time when contacting the provider. That information makes a query far easier to resolve than a general question about missing card takings.

A record that answers questions later

A simple daily record can be kept in a spreadsheet or a notebook. Include the date, terminal identifier, Z report batch number, gross card sales, refunds, net batch total, gratuities, the card total from the till or EPOS, any variance and a short note. File the Z report with the record. A weekly glance at variances and a monthly check against settlement statements will usually be sufficient for a small independent business.

This record is also useful when staff change, when a terminal is replaced, or when the business is preparing information for an accountant. It provides a clear trail from the card terminal to the till to the bank. It does not replace proper accounting records, and it should not be treated as a VAT invoice, but it does make the card side of the business easier to explain and verify.

When the figures will not agree

Persistent variances deserve a proper query. Contact the provider with the batch number, the date and time of closure, the terminal identifier and one or two example transactions. Avoid repeatedly re-running the Z report in the hope that the figures will change; that can create confusion about which report is the final record for the day. Do not delete or overwrite batch records. If the till needs an adjustment, record why it was made rather than simply changing the total.

For Bristol independents, card takings often represent the majority of daily revenue. A five-minute closing routine is therefore a sensible control rather than a sign of distrust. It gives the business a clear daily record, makes settlement queries easier to pursue and reduces the chance that a small discrepancy at the counter becomes a month-end mystery in the accounts.