Bookkeeping for Retail Clients
Till totals, stock movements and merchant payouts tell different stories. Reconcile your retail client’s sales and inventory before closing the period.
- Published
- Updated
Bookkeeping for retail reconciles sales and payment records separately, then connects stock movements, supplier balances and vouchers to the closing accounts.
Your client’s bank deposits show settled money. Till records explain what was sold, while merchant statements explain fees and payments still on their way.
Reconcile the Shop’s Takings
Start with the point-of-sale (POS) transaction records for the agreed trading period. Retain the report settings and time zone so an overnight settlement does not move sales into the wrong period.
Before importing anything, read the documentation for your client’s actual POS and merchant reports. Establish whether refunds and discounts are already deducted. Check whether displayed amounts include GST and whether a settlement contains more than one day’s transactions.
Use separate reconciliations for sales and payment methods. Sales records explain gross sales, discounts and refunds. Tender records explain how customers paid, including cash, cards and vouchers.
A voucher redemption can pay for a sale without creating a new bank deposit. Selling a voucher can bring in money before the related goods are supplied. Keep those movements identifiable in the reconciliation.
A Fictional Takings Reconciliation
Assume this example contains only taxable goods paid for by cash or card. All sales amounts include GST. The merchant deducts a $132 fee, whose GST treatment follows its supporting invoice.
| Reconciliation item | Amount | Evidence |
|---|---|---|
| Gross sales before discounts and refunds | $11,000 | Till sales records |
| Discounts | ($550) | Discount report |
| Refunds | ($550) | Refund transactions |
| Net sales including GST | $9,900 | Reconciled sales total |
| Cash tender after refunds | $3,300 | Tender report and count |
| Card tender after refunds | $6,600 | Tender report and merchant activity |
| Merchant fee deducted | ($132) | Merchant statement and fee invoice |
| Merchant bank deposit | $6,468 | Bank statement |
The sales calculation is $11,000 - $550 - $550 = $9,900. Because this example assumes every sale is taxable, that amount contains $900 GST and $9,000 sales excluding GST.
The card calculation is $6,600 - $132 = $6,468. Posting the deposit as sales would omit cash sales and combine merchant fees with revenue.
For the till, assume a $200 opening float and no paid-out expenses. The expected closing cash is $3,500: the float plus $3,300 cash tender. Banking $3,000 leaves $500 cash on hand, including the float.
Keep cash paid-outs and owner withdrawals separate when they occur. Match the count to expected cash before matching deposits to the bank. Record an unexplained shortage as an exception for investigation.
A merchant clearing account connects card activity to settlements. Carry unsettled transactions forward by transaction reference. If a deposit differs, inspect refund timing, fees, chargebacks and reserves before posting an unexplained adjustment.
Stock and Supplier Records
Reconcile stock quantities by product and location before assessing value. Opening units plus receipts and customer returns must explain sales, transfers, write-offs and closing units.
For one fictional product, start with 100 units. Receive 60 and accept five saleable customer returns. After 80 units sold, ten transferred out and three written off, the location’s expected balance is 72 units.
If the physical count is 70, investigate the two-unit difference. Check unrecorded sales and transfer receipts, then recount. Post an authorised count adjustment only when the cause or unresolved shortage is documented.
A transfer between your client’s own locations changes each location’s quantity. It does not create a purchase or change the business’s total stock. Reconcile dispatch and receipt together to identify goods still in transit.
Match supplier invoices to delivery records before recording payables. Trace supplier returns through the stock record and requested credit. A returned item can leave the shop before the supplier issues its credit note.
Reconcile supplier statements to the payable ledger. Separate unpaid invoices, unapplied credits and payments in transit. Investigate goods received without an invoice so the accountant can assess the period-end accrual.
Business.gov.au’s inventory guidance explains how stocktakes compare physical stock with inventory records. Keep the signed count sheets and movement records supporting every correction.
A quantity reconciliation establishes what the retailer holds. The accountant separately assesses its financial-statement value, including damaged or obsolete stock and any write-down. Record evidence of condition without treating every slow-selling item as worthless.
The ATO’s trading-stock valuation guidance describes tax valuation methods. Keep the tax calculation separate from financial-statement valuation and provide the accountant with costs and condition evidence.
Vouchers and Store Credits
Keep a voucher schedule that reconciles opening unredeemed value with issues, redemptions, refunds and authorised adjustments. Match each movement to an identifiable voucher or credit reference.
Retain the original terms and evidence of what the customer paid. Record whether a credit arose from a purchased gift voucher, a returned product or a promotional offer. These transactions can require different accounting and GST treatment.
The ATO’s GST guidance for vouchers distinguishes face value vouchers from other vouchers. For qualifying face value vouchers, GST generally arises on redemption for taxable supplies.
An amount charged above face value can create GST when issued. Send the actual terms and transaction facts for GST review before assigning tax codes. A label saying gift card does not settle the classification.
Keep voucher issues separate from revenue until the accounting treatment is established. On redemption, clear the recorded voucher obligation and account for the goods supplied under the approved treatment. Avoid recognising the same sale again through the bank import.
Do not clear old balances solely because the voucher register shows them as expired. Give the accountant the terms and remaining balance. Include redemption history so they can assess any release and GST adjustment.
Close the Trading Period
Prepare a closing workpaper that shows each reconciled balance, its evidence and any decision still required. A bank reconciliation alone cannot establish that sales, stock and vouchers are complete.
Fictional Closing Workpaper
The following independent schedules illustrate one retailer’s close. The takings lines use the example above. Supplier payments and voucher activity have their own reconciliations and are outside that example’s sales and bank figures.
| Schedule | Reconciliation | Closing result |
|---|---|---|
| Sales | $11,000 - $550 - $550 | $9,900 including GST |
| Merchant clearing | $0 + $6,600 - $132 - $6,468 | $0 unsettled for the example batch |
| Till cash | $200 + $3,300 - $3,000 banked | $500 cash held |
| One product at one location | 100 + 60 + 5 - 80 - 10 - 3 - 2 authorised adjustment | 70 units counted |
| Supplier payable | $2,000 opening + $5,500 invoices - $550 credits - $4,950 paid | $2,000 payable |
| Voucher obligation | $800 opening + $400 issued - $300 redeemed | $900 unredeemed |
The two-unit stock adjustment records the manager’s approval after investigation. Retain it in the exception history even though the adjusted quantity now agrees with the count.
Give the accountant a short exception list with an owner and supporting records for each item:
- The cause of the two-unit shortage remains unresolved after recounting and checking movements.
- Damaged stock needs a valuation decision supported by photographs and cost records.
- One promotional voucher arrangement needs GST classification before its next transaction is posted.
Finish by matching each closing schedule to the trial balance and retaining the underlying reports. Record approved adjustments once, then confirm the affected schedules still agree. The accountant receives reconciled records and a bounded list of decisions to make.
One client form. One finished return.
Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.
Made for Australian accounting firms