Every liquor store remits sales tax or VAT, and almost every liquor store has had at least one month where the number it remitted didn't quite match what it collected. Usually it's a few hundred dollars off in a direction you can't quite reconstruct — returns that untaxed themselves, a tax rate that changed on one product line, a cash drawer where tax got lumped in with receipts.
Note: this is general guidance on how to keep reporting straight, not tax or legal advice — your rates, filing rules, and responsibilities depend on your jurisdiction. Confirm them with your accountant or a tax professional.
What the software can do is remove the guesswork so your report matches your reality. Here's how.
The three numbers that must always agree
Whenever tax is involved, three figures should reconcile cleanly:
- Taxable sales — the value of sales on which tax is due.
- Tax collected — the tax actually charged and taken in.
- Tax remitted — what you pay to the authority.
If remitted doesn't equal collected, you're either shorting the taxman (interest and penalties) or giving away money you collected. The only way to be sure they match is to record tax at the moment of sale and report from that record — not reconstruct it at quarter-end from a pile of receipts.
Where a liquor store's tax reporting goes wrong
1. Returns and the tax that came with them
A refund should take back the tax that was collected on the original sale — and, if the sale was partial, that means pro-rating the tax on the returned portion. If returns just subtract the item total without touching tax, your collected number drifts upward while your remitted stays flat, and the discrepancy grows with every return.
2. Mixed tax rates across one invoice
Wine, beer, and spirits can attract different rates, and prepared items sometimes differ again. A system that only supports one rate per transaction forces you to either over- or under-collect somewhere. The register needs to handle line-level tax so each product carries its own correct rate.
3. Cash drawer drift
When tax and sales blend together in a drawer with no clean split, end-of-day reconciliation becomes an eyeball estimate. A proper register keeps taxable amount and tax separate on every tender so the daily cash-up totals match what you'll report.
4. Discounts and voided lines
Tax computed on a gross total, then a discount applied, can leave the tax figure slightly off. Tax should be calculated on the discounted line value, and voided lines should fully reverse their tax. Get this wrong by pennies across thousands of tickets and it stops being pennies.
Tax reporting isn't hard when the record is clean at the source. It's nearly impossible to reconstruct at quarter-end from a drawer and a box of receipts.
How to keep it straight from day one
- Record tax at the line level at the moment of sale — never bolt it on to a summary later.
- Handle returns as full reversals of both the item and its tax, pro-rated for partial returns.
- Support multiple rates per invoice so wine, beer, and spirits never get lumped into one wrong figure.
- Keep a tax/VAT report that totals taxable sales and tax collected by period — clean enough to hand to your accountant as-is.
If your system can't do line-level tax, that's a bookkeeping problem in disguise. For more on keeping the wider books clean — valuation, COGS, and the P&L your inventory actually drives — see our liquor inventory management guide.
What a good report answers
When filing day comes, you want a small set of numbers you trust, quickly:
- Total gross sales for the period.
- Taxable vs. exempt breakdown.
- Tax collected, broken out by rate.
- Returns and the portion of tax they reversed.
- A clean figure you can remit, backed by the detail under it.
CellarPoint computes tax at the line level with multiple rates, fully reverses tax on returns and voids, and produces a tax/VAT report that reconciles collected against remitted — ready for your accountant.
See how it works