Gift card reconciliation means matching the face value of cards issued, your sales records, redemptions and the outstanding liability across every system and location. Start by exporting sales, redemption and balance reports, then compare totals by date, batch and location, flagging unapplied cash and manual portal edits. Cash received is deferred revenue under IFRS 15, and the ATO sets separate GST rules for vouchers.
TL;DR:
- Export sales, redemption, balance, gateway, and bank reports, then reconcile by date, batch, and location, accounting for partial and cross location redemptions.
- Freeze the ledger at month end, preserve dated versions, attach transaction evidence, and require preparer and reviewer sign off before locking each period.
- Record sale proceeds as a liability and recognize revenue on redemption; recognize breakage only with documented historical support, not by applying industry estimates blindly.
- Face value vouchers usually incur no GST at sale; GST applies on taxable redemption, while expired balance writebacks require a 1/11th BAS adjustment.
- Investigate mismatches by checking transaction IDs, timestamps, locations, refunds, voids, and top ups before escalating recurring variances or system mapping faults to audit or IT.
Table of Contents
- What is the exact order for reconciling gift card sales and redemptions?
- What should a reconciliation template and audit log include?
- How do deferred revenue and breakage work in the books?
- How are GST and BAS affected by gift cards?
- Which monthly reports and controls keep you audit-ready?
- How do you investigate mismatches?
- Why should salons standardize gift card reconciliation?
- How can our platform reduce your reconciliation work?
- FAQ
- Sources
What is the exact order for reconciling gift card sales and redemptions?
Work from the biggest totals down to individual cards. Totals that agree first save you from tracing cards one by one.
Begin by exporting five reports: POS gift card sales, redemption transactions, the gift card ledger or balance report, payment gateway receipts and bank deposits. Group everything by cohort (issue date, batch or location). Then match sales to redemptions, remembering that partial redemptions leave a remaining balance and cross-location redemptions put the sale and the redemption in different places. Practitioner guidance on gift card reports is clear that cash at sale is a deferred liability, and that manual portal adjustments are balance changes, not sales.
Use this period-close checklist:
- Aggregate gift card sales for the period by location and cohort.
- Aggregate redemptions for the same cohorts, including partial and cross-location ones.
- Compare both totals with the ledger’s outstanding balance.
- Match sales cash to gateway receipts and bank deposits.
- List every unmatched item with its transaction ID and the likely cause.
- Record manual edits separately, with the reason and the person who made them.
- Sign off and file the evidence.
What should a reconciliation template and audit log include?
A good template is an audit trail first and a calculator second. A public gift card audit log and reconciliation template shows the basic idea: record every purchase and disbursement so a reviewer can follow each card from sale to use.
Build your own log with these controls:
- Versioning: save a dated copy at each close so earlier periods never get overwritten.
- Evidence links: attach receipt or transaction IDs to every line.
- Sign-off: require a preparer and a reviewer before the period is locked.
- Retention: keep logs for as long as your tax and audit obligations require.
| Column | Why it matters |
|---|---|
| Card ID / cohort | Groups cards for matching |
| Issue date and face value | Sets the liability |
| Sale transaction ID | Ties the card to cash received |
| Issuing and redeeming location | Maps cross-location redemptions |
| Redemption IDs | Traces each use, including partial ones |
| Remaining balance | Reconciles to the ledger |
| Adjustments and reason | Isolates manual edits |
| Staff and sign-off | Creates accountability |
For a cross-location redemption, record the sale under the issuing location and the redemption under the redeeming one, so the settlement between them is visible.
How do deferred revenue and breakage work in the books?
Cash received at sale is not revenue. It creates a gift card liability, and under IFRS 15 revenue is recognized when the card is redeemed. Typical entries:
- Sale: DR Cash / CR Gift card liability
- Redemption: DR Gift card liability / CR Revenue
- Breakage (once justified): DR Gift card liability / CR Revenue, for the estimated unredeemed portion
Breakage is the part of card value that will never be redeemed. You can estimate it from historical redemption patterns over time, or proportionally as cards are redeemed across a pool of similar cards. Either way, keep the supporting data. An IFRS Interpretations Committee staff paper on prepaid cards reflects the expectation that a documented historical basis supports whatever you recognize, and that lump-sum recognition draws scrutiny.
Industry-cited breakage estimates typically run from 5% to 19% of issued face value. Use that range as context only. Your own redemption history decides your number.
How are GST and BAS affected by gift cards?
The ATO guidance on vouchers separates face value vouchers from everything else. Check these points before you close each period:
- Selling a face value voucher is generally not a taxable supply. GST arises when the card is redeemed for a taxable supply.
- For vouchers that are not face value vouchers, check the applicable GST treatment with the ATO or a tax adviser.
- Top-ups and refunds need their own treatment, so tag them in your log.
- When you write an unredeemed or expired balance back to income, the BAS adjustment is 1/11th of that balance.
- Keep the documents behind every write-back so your BAS figures can be explained later.
Which monthly reports and controls keep you audit-ready?
Run the same set every month so drift shows up early:
- Issued gift card ledger
- Redemption ledger
- Outstanding balances by cohort and location
- Bank deposit match
- Manual edit log
Reconcile totals first, then trace a small sample of individual cards from sale to last redemption. Reconcile portal edits on their own, and require two sign-offs on any material adjustment.
Track three indicators: redemption rate by cohort, aging of outstanding balances, and the trend in your breakage percentage. A cohort that stops redeeming earlier than usual is worth a look before it affects your estimate.
Pro Tip: Freeze the ledger on the last day of the month before you start matching, so late edits don’t move your totals mid-reconciliation.
How do you investigate mismatches?
Most variances come from a short list: manual portal edits, partial redemptions recorded differently across systems, settlement lag between sale and deposit, refunds and voids, and data-mapping gaps between systems.
Work through them in this order:
- Verify transaction IDs on both sides of the mismatch.
- Confirm timestamps and locations, since cross-location redemptions often land in the wrong period.
- Check for refunds, voids and top-ups attached to the card.
- Reconcile manual edits and portal adjustments against your edit log.
Escalate to audit or IT when a variance repeats across periods or points to a system mapping fault. Treat very small balances as immaterial for close purposes, but document the threshold you use so it is applied consistently.
Why should salons standardize gift card reconciliation?
A fixed procedure can make gift card reconciliation more consistent and easier to review. The hardest mismatches I see come from gift card data scattered across a POS, a portal and a spreadsheet. Centralizing the ledger can make gift card balances and reporting easier to review. Our features help manage gift cards.
Ali
How can our platform reduce your reconciliation work?
ZibaDesk brings salon management tools into one platform. Here is what shortens a close:
- Gift card management
- Reporting tools
Review our pricing for current details, or check whether the reports cover your close checklist.
FAQ
How do you record gift cards in accounting?
Record the cash at sale as a liability, not revenue: debit cash and credit gift card liability. When the customer redeems, debit the liability and credit revenue. Under IFRS 15, breakage is recognized only when it can be reasonably estimated.
How many gift cards go unspent?
It varies by business. Industry-cited breakage estimates range from 5% to 19% of issued face value, but your own redemption history is the number to rely on.
Does reconciliation mean refund?
No. Reconciliation is a comparison of records, such as sales, redemptions, balances and deposits, to confirm they agree. A refund is a separate transaction that returns money to a customer, and it should be logged on its own so it doesn’t distort your totals.
What does credit card reconciliation mean?
It means matching your card processor statements to your sales records so every settled payment ties to a transaction. For gift cards, the same step compares gateway receipts and bank deposits against gift card sales in your ledger.
Sources
- GST and vouchers | Australian Taxation Office
- IFRS 15 Revenue from Contracts with Customers
- Gift Card Audit Log & Reconciliation Template
- Gift Card Reports Overview