VoucherGrid vs the spreadsheet, at a glance.
Ten practical differences, with the strengths of each approach kept in view.
| Feature | VoucherGrid | Spreadsheet | Why it matters |
|---|---|---|---|
| Online sales | Hosted storefront on Premium and Professional, with Stripe readiness required. | A workbook can record online sales; checkout and delivery need separate tools or automation. | Decide how much of the order-to-voucher handover you want to maintain. |
| Balances and partial redemptions | Each redemption updates the voucher balance and event history. | Formulas and a transaction sheet can calculate balances when the data is complete. | Reconcile events, not just the current balance cell. |
| Expiry checks | Checks configured expiry rules at voucher creation. | Date formulas and validation can help enforce your process. | Most purchased gift cards need three years, with exceptions; review the applicable rules. |
| GST classification | Uses saved voucher, registration and supply-classification evidence. | Columns, formulas and accountant review can record and calculate the required treatment. | The quality of classification matters in either system. |
| Voucher records | Voucher details and Redemption activity support accountant review. Accounting liability reports are currently unavailable. | A maintained transaction register can calculate outstanding totals. | Reconcile the register with your accounting records. |
| Expiry and breakage | Tracks expiry events and related reporting. | Formulas can identify expired balances for review. | Expiry, income recognition and tax adjustments are related but distinct questions. |
| History | Voucher events retain timestamps and available actor context. | Version history can show changes; a separate transaction log preserves the voucher story. | Choose a process that makes corrections and redemptions easy to explain. |
| Multi-user access | Role-based access to voucher operations. | Shared workbooks can support collaboration, permissions and protected ranges. | Both need appropriate access and a clear owner of the process. |
| Voucher presentation | Voucher designs and delivery are part of the workflow, subject to plan limits. | Artwork and delivery use separate tools or a maintained integration. | Compare the complete workflow, including the buyer experience. |
| Xero & QuickBooks | Accounting reports and Xero or QuickBooks sync are not available. Operational records remain available for your accountant. | Manual entry, exports or separately configured automation. | A connection does not replace reconciliation. |
Swipe sideways for the full comparison
VoucherGrid vs spreadsheets
Online sales
- VoucherGrid
- Hosted storefront on Premium and Professional, with Stripe readiness required.
- Spreadsheet
- A workbook can record online sales; checkout and delivery need separate tools or automation.
- Why it matters
- Decide how much of the order-to-voucher handover you want to maintain.
Balances and partial redemptions
- VoucherGrid
- Each redemption updates the voucher balance and event history.
- Spreadsheet
- Formulas and a transaction sheet can calculate balances when the data is complete.
- Why it matters
- Reconcile events, not just the current balance cell.
Expiry checks
- VoucherGrid
- Checks configured expiry rules at voucher creation.
- Spreadsheet
- Date formulas and validation can help enforce your process.
- Why it matters
- Most purchased gift cards need three years, with exceptions; review the applicable rules.
GST classification
- VoucherGrid
- Uses saved voucher, registration and supply-classification evidence.
- Spreadsheet
- Columns, formulas and accountant review can record and calculate the required treatment.
- Why it matters
- The quality of classification matters in either system.
Voucher records
- VoucherGrid
- Voucher details and Redemption activity support accountant review. Accounting liability reports are currently unavailable.
- Spreadsheet
- A maintained transaction register can calculate outstanding totals.
- Why it matters
- Reconcile the register with your accounting records.
Expiry and breakage
- VoucherGrid
- Tracks expiry events and related reporting.
- Spreadsheet
- Formulas can identify expired balances for review.
- Why it matters
- Expiry, income recognition and tax adjustments are related but distinct questions.
History
- VoucherGrid
- Voucher events retain timestamps and available actor context.
- Spreadsheet
- Version history can show changes; a separate transaction log preserves the voucher story.
- Why it matters
- Choose a process that makes corrections and redemptions easy to explain.
Multi-user access
- VoucherGrid
- Role-based access to voucher operations.
- Spreadsheet
- Shared workbooks can support collaboration, permissions and protected ranges.
- Why it matters
- Both need appropriate access and a clear owner of the process.
Voucher presentation
- VoucherGrid
- Voucher designs and delivery are part of the workflow, subject to plan limits.
- Spreadsheet
- Artwork and delivery use separate tools or a maintained integration.
- Why it matters
- Compare the complete workflow, including the buyer experience.
Xero & QuickBooks
- VoucherGrid
- Accounting reports and Xero or QuickBooks sync are not available. Operational records remain available for your accountant.
- Spreadsheet
- Manual entry, exports or separately configured automation.
- Why it matters
- A connection does not replace reconciliation.
What a workbook can do well.
A spreadsheet offers a familiar, flexible way to keep a voucher register. Formulas, data validation, protected ranges and shared access can support a disciplined process. These capabilities depend on the software and how you configure it.
Give transactions their own rows.
Record sales, each partial redemption and corrections separately. Overwriting a balance alone loses context. A maintained transaction log can calculate the current balance while preserving its history.
Maintain the controls.
Test formulas, protect important cells and document the process for staff. Excel offers data validation; Google Sheets offers version history. Those tools can help, but they need to be configured around your voucher workflow.
Plan for handover.
Another team member should be able to understand the workbook, restore a backup and reconcile its totals. If only its author can maintain it, that is a process risk worth addressing.
Choose the history you need.
Cell version history and a voucher event log answer different questions. Consider how easily you can explain a redemption, correction or balance when a customer or accountant asks.
Keep the accounting and expiry checks explicit.
Neither a workbook nor a subscription establishes compliance by itself. Build a repeatable process rather than relying on memory and discipline alone.
Check the applicable rule
Most purchased gift cards need at least three years of validity; exceptions apply. Use validation and review in a workbook, or the configured expiry checks in VoucherGrid. See the ACCC guidance.
Save the classification
Voucher type, GST registration and supply taxability affect the treatment. A workbook can record those facts; VoucherGrid stores the evidence with voucher events. Ask your accountant to review the treatment. See the ATO voucher ruling.
Reconcile the liability
Maintain the outstanding balance and its supporting events. Revenue recognition and GST timing are separate. Use those records with your accountant to assess AASB 15 where applicable.
Online selling needs more than a register.
A spreadsheet can sit behind online sales. The comparison is the work needed to connect payment, voucher creation and delivery.
Spreadsheet
- Record in-person, phone or online sales.
- Choose a separate checkout or payment link.
- Transfer confirmed sales into the register.
- Prepare voucher codes and designs in your chosen tools.
- Arrange email delivery or maintain your own automation.
VoucherGrid
- Hosted storefront on Premium and Professional.
- Online checkout through an eligible Stripe connection.
- Voucher designs within your plan allowance.
- Personal messages and email delivery, with delivery status to check.
- Every sale flows into the same ledger as in-store.
Online selling can help someone buy a gift from outside your local area. It does not guarantee extra sales; choose the workflow that suits your customers and the effort you can maintain.
When a spreadsheet is still the right answer.
A workbook may be adequate when your transaction log is complete, formulas and validation are maintained, access is controlled, backups are available and your accountant can reconcile the records. There is no universal volume threshold, and a spreadsheet is not inherently non-compliant.
Consider a dedicated system when maintaining those controls, managing handovers or joining payment and delivery becomes a burden. Compare the subscription cost with your real administrative effort; neither option guarantees a particular financial return.
Keep comparing: vs manual tracking