At a glance VoucherGrid vs the spreadsheet.
Ten rows that decide it. Each one expanded below.
| Feature | VoucherGrid | Spreadsheet | Why it matters |
|---|---|---|---|
| Online sales | Branded storefront, 24/7, buyers anywhere in Australia. | None - local foot traffic only. | Most online voucher buyers live outside the business's local area. A spreadsheet makes you invisible to them. |
| Real-time balance & partial redemptions | Every redemption logged instantly. Partial balances tracked to the cent. | Manual cell updates. Two staff editing at once and one overwrites the other. | Partial redemptions are the #1 failure mode for spreadsheet voucher tracking - they require the right cell, by the right person, every time. |
| ACCC three-year minimum expiry | Enforced at point of creation - non-compliant dates are blocked. | No enforcement. Whatever you type goes out. | All gift vouchers sold to Australian consumers must have a minimum three-year expiry. Breach is a breach of Australian Consumer Law. |
| GST timing (face value vs non-face value) | Voucher type set at creation; GST timing handled automatically for BAS. | No distinction. BAS figures may be wrong at any meaningful volume. | The ATO treats face value and non-face value vouchers differently. A spreadsheet applies neither rule. |
| AASB 15 deferred revenue | Outstanding liability report generated automatically, synced to Xero & QuickBooks. | Manual count, or a guess, when the accountant asks. | Every unredeemed voucher is a liability on your balance sheet. Your accountant needs the number, not a hand-tallied estimate. |
| Breakage recognition | Expired unredeemed value recognised as revenue automatically. | Manual - and usually missed entirely. | Breakage is real revenue you're entitled to recognise. Spreadsheets don't surface it. |
| Audit trail | Every issue, redemption and edit timestamped against a user. | None. Google Sheets version history exists, but reconstructing a voucher's lifecycle from cell diffs is not a workflow. | When a customer disputes a redemption you need a log, not a forensic afternoon. |
| Multi-user access | Role-based access. Concurrent staff edits, no conflicts. | Conflict-prone. Single point of failure when the spreadsheet's owner is on leave. | Voucher operations are a team activity. The tracking system has to be too. |
| Storefront design | Curated designs, custom artwork, up to three designs per product (Professional). | No storefront, no design. | Buyers are choosing a gift, not a database row. The design matters. |
| Xero & QuickBooks integration | Native Connections - deferred revenue, redemptions and breakage post directly. | Manual data entry into the ledger, every period. | Manual re-entry is where reconciliation errors are born. |
Why spreadsheets work until they don’t.
Every small business starts with a spreadsheet. It’s free, it’s flexible, and for the first handful of vouchers it’s fine. The problems arrive gradually, then all at once.
Partial redemptions are the failure mode.
A customer uses $80 of a $150 voucher. Someone updates the sheet. Or doesn’t. Or updates the wrong cell. Or two staff members edit at the same time and one overwrites the other. Partial redemptions require the right person, in the right cell, every single time - which is not how voucher operations actually run.
A spreadsheet enforces nothing.
It won’t stop you issuing a voucher with a 12-month expiry. It won’t flag that a face value voucher’s GST should usually defer to redemption. It won’t warn you when expiry is approaching and the customer hasn’t been reminded. It stores what you type; it doesn’t know what you should have typed.
Single point of failure.
The person who built the spreadsheet understands it. When they’re on leave, nobody else does - column layouts, hidden sheets, conditional formatting, the formula in F12. It’s institutional knowledge that walks out the door without warning.
No audit trail.
If a customer disputes a redemption or a staff member makes an error, there’s no log. Google Sheets version history exists, but digging through timestamped cell changes to reconstruct a voucher’s lifecycle is nobody’s idea of a productive afternoon.
The compliance gap three regulators, one grid.
Spreadsheets aren’t just operationally fragile - they’re a compliance liability. Three regulators care about gift vouchers, and a spreadsheet satisfies none of them.
Three-year minimum expiry
All gift vouchers sold to Australian consumers must carry at least three years’ validity. A spreadsheet can’t enforce this - if you or a staff member type a shorter date, the voucher goes out non-compliant. VoucherGrid blocks it at creation.
GST timing, by voucher type
Face value and non-face value vouchers have different GST timing rules. Spreadsheets apply neither. VoucherGrid classifies each voucher at creation and handles BAS treatment automatically - see the gift voucher GST guide.
Deferred revenue, on the balance sheet
Every unredeemed voucher is a liability. Your accountant needs the outstanding total, not a guess. VoucherGrid reports it automatically, synced to Xero or QuickBooks - full method in the accounting guide.
The revenue ceiling you’re only selling to walk-ins.
The less obvious cost of spreadsheet voucher tracking: you’re invisible to anyone who can’t walk through the door.
Spreadsheet
- In-person sales only.
- No 11pm Sunday purchases.
- No interstate daughter buying for mum.
- No corporate buyer sending wellness gifts at scale.
- No personal message, no scheduled email delivery.
VoucherGrid
- Branded online store, 24/7.
- Buyers anywhere in Australia.
- Curated designs - up to three per product (Professional).
- Personal message, scheduled delivery, instant email.
- Every sale flows into the same ledger as in-store.
The majority of online voucher purchases come from outside the business’s local area. That’s real revenue - and a spreadsheet makes you invisible to it.
When a spreadsheet is still the right answer.
If you sell fewer than ten vouchers a year, all in person, with no partial redemptions, and your accountant isn’t asking about deferred revenue - a spreadsheet is probably fine. It’s not compliant, but the risk is proportional to the volume.
For anything beyond that - selling online, multiple staff handling redemptions, growing volumes, or an accountant who wants proper reporting - a purpose-built system pays for itself in the first audit you don’t have to reconstruct.