GST Invoices and Card Settlement: Reconciliation for Stationery Retailers

Published: 25 October 2026

Category: how-to-guides | cardbuzz

Tags: stationery shops, GST, invoicing, reconciliation, card settlement, tax records, bookkeeping

A stationery shop's card sales and its tax records must tell the same story. Every card payment should correspond to a sale, every sale to an invoice or bill, and every invoice to a settlement in the bank. When those three records diverge, the shop faces extra work at filing time, queries from buyers, and the risk of reporting a figure that does not match its own bank credits. Good reconciliation is therefore not merely tidy bookkeeping; it is the bridge between the till and the tax return.

This guide explains, in general terms, how a stationery retailer can reconcile GST invoices with card settlements, what to check each day and each month, and how to handle the common mismatches. It describes process only and offers no tax advice for any particular business; a shop with complex circumstances should consult its own tax adviser.

The three records that must agree

Three records sit at the heart of reconciliation. The first is the sales record: bills and GST invoices issued at the counter or for bulk and online orders, showing items, values and tax components as applicable. The second is the card record: terminal settlement reports and online payment reports, showing card transactions, refunds and adjustments. The third is the bank record: credits received for card settlements, showing when money actually arrived.

In a clean month, these records agree in a straightforward way: total invoiced card sales, less card refunds and less payment deductions, equals total bank credits for card settlements, allowing for timing differences at month boundaries. Timing differences are normal — a sale on the last day of a month may settle in the bank in the next month — but they should be identifiable and explainable, not a vague gap.

The discipline is to keep the three records in the same filing system, by date, so any one transaction can be traced across all three. A sale that can be found in the invoice file, the settlement report and the bank statement is a sale that will not cause trouble later.

Issuing invoices that support reconciliation

An invoice that supports reconciliation is detailed enough to be matched. It should show the date, a unique invoice number, the buyer's details where required, item descriptions, quantities, values and tax break-up as applicable, and the total. For card-paid sales, it should also show the payment method and, where the shop's system allows, a reference linking it to the card transaction.

Sequential invoice numbering is essential. Gaps in numbering invite questions, so cancelled or void invoices should be retained and marked as cancelled rather than deleted, with a brief reason noted. A shop that reuses numbers or deletes invoices creates a reconciliation problem that no amount of later effort can fully repair.

For walk-in retail sales where a full GST invoice is not required for every small purchase, the shop's billing system should still produce a consistent bill record that feeds into the daily sales total. The daily total, not each individual small bill, is what will be matched to card settlements, but the total must be built from real bills, not estimated.

Daily reconciliation: a short routine that prevents month-end pain

Daily reconciliation need not take long if it is done daily. At close, gather the day's invoice and bill totals split by payment method, the terminal settlement report, and any online payment report. Compare card sales per the bills with card sales per the settlement report. They should match, apart from any transaction that failed, was voided, or is still pending.

Investigate differences immediately. Common causes include a card payment voided after the bill was issued, a payment taken twice for the same bill, a refund processed without a corresponding credit note, or a bill settled partly by card and partly by another method but recorded as wholly card. Each cause has a different correction, and each is far easier to identify on the day it happened than weeks later.

Record the day's reconciliation in a simple log: date, invoiced card sales, settled card amount, difference, and explanation for any difference. That log becomes the first document consulted at month end, and it turns a large monthly task into a series of small verified days.

Handling refunds, credit notes and adjustments

Refunds are where reconciliation most often breaks down. A card refund reduces the amount the shop ultimately receives, but it does not erase the original sale. The correct treatment is to keep the original invoice, issue a credit note for the refunded goods, and record the card refund against that credit note. The three records then show a coherent story: sale, credit, and reduced settlement.

The same logic applies to price adjustments, short deliveries and substituted items. Each adjustment needs a document — a credit note, a supplementary invoice, or a revised invoice as appropriate — that references the original invoice number. An undocumented adjustment, such as a cash refund for a card sale or a verbal agreement to reduce a bill, leaves a gap that reconciliation cannot close.

Timing matters for refunds too. A refund processed in a later month than the original sale will appear in that later month's settlement report. The daily log should note the original invoice date alongside the refund date, so the two months can be tied together at filing time.

Month-end reconciliation and filing preparation

At month end, aggregate the daily logs into a monthly summary: total invoiced sales by payment method, total card settlements, total refunds and credit notes, total deductions, and total bank credits. Reconcile the monthly summary to bank statements, listing any timing differences — settlements still in transit at month end, or refunds processed but not yet reflected — with amounts and dates.

This summary is the basis for preparing tax filings and for answering any query about the month's card income. It should be retained with the month's invoices, settlement reports and bank statements as a single month file. A shop that can produce a complete month file on request is a shop that will handle scrutiny calmly.

If a difference cannot be explained after reasonable investigation, note it as unexplained, with the amount and the steps taken to trace it, rather than forcing the figures to agree with an invented adjustment. An honestly noted difference is far better than a hidden one, and it gives the shop's adviser something concrete to work with.

Common mismatches and how to trace them

Several mismatches recur in stationery retail. A settlement total higher than invoiced card sales may indicate a duplicate charge, a payment taken without a bill, or a previous day's settlement included in error. A settlement total lower than invoiced sales may indicate a failed or voided transaction, a refund, or a settlement still in transit.

A bank credit that does not match any settlement report may be a combined credit covering multiple days, or a credit net of deductions and adjustments. Check the settlement reports for the surrounding days before concluding that money is missing. Conversely, a settlement report with no matching bank credit may simply reflect a bank holiday or a weekend delay, and should be flagged for follow-up rather than treated as a loss.

In each case, trace from the middle record — the settlement report — outward to the invoice on one side and the bank credit on the other. That approach narrows the search quickly, because the settlement report carries transaction references that appear in both neighbouring records.

Closing note

Reconciling GST invoices with card settlements is a habit, not a heroic month-end effort. Issue sequential, detailed invoices, reconcile daily, document every refund with a credit note, and summarise monthly with timing differences explained. A stationery shop that follows that routine will file with confidence, answer buyer queries with documents rather than memory, and keep its till, its bank and its tax records telling one consistent story.