Clear pricing, quoted before any work begins. Book a free fit call.

Bookkeeping

Bookkeeping for Liquor and Convenience Stores: The Fixes

Reviewed by the Fairlight Accounting cross-border tax team — U.S. & Canadian Tax Desks

Bookkeeping for a liquor store or convenience store is the discipline of reconciling a high-volume register — merchandise, alcohol, tobacco, lottery, money orders, the ATM — to the bank every day, and counting a large, fast-moving inventory often enough to know the margin by category. Stores that record deposits as sales and vendor checks as cost of goods never learn which categories carry the store.

On this page
  1. What makes convenience-store bookkeeping different?
  2. What is revenue, and what only passes through?
  3. How should inventory and cost of goods be tracked?
  4. How do excise and sales taxes flow through the books?
  5. How do you reconcile the register to the bank?
  6. What else goes wrong?
  7. Which numbers should a store owner see every month?
  8. Frequently asked questions
  9. Next step

What makes convenience-store bookkeeping different?

Volume and mix. Thousands of transactions a day across categories with wildly different margins — cigarettes and other tobacco in low single digits, beer not far above, fountain drinks and prepared food far higher — plus several revenue streams that are not revenue at all. Add alcohol and tobacco excise taxes, sales tax that applies to some items and not others, EBT, card settlements, and cash handling by multiple employees, and the books need a structure most generic setups don't have.

What is revenue, and what only passes through?

  • Merchandise sales are revenue, recorded gross by category with cost of goods matched.
  • Lottery: ticket sales are not your revenue — you are an agent. The commission the lottery pays you is revenue; the ticket money collected is a liability until swept by the lottery commission. Cashed winning tickets are a reduction of that liability, reimbursed by the lottery.
  • ATM: cash dispensed is your cash moving from the register to the machine; only the surcharge income is revenue.
  • Money orders, bill payments, and prepaid phone cards: agent fees are revenue; the face amounts pass through.

Books that record lottery and ATM gross as sales overstate revenue massively and understate margin — and draw questions when the return doesn't match the merchant-processor and lottery statements.

How should inventory and cost of goods be tracked?

By category — beer, wine, spirits, tobacco, grocery, prepared food, non-food — with purchases to inventory and cost of goods recorded as items sell, ideally from the point-of-sale system's item costs. Where the register doesn't track cost, a monthly count by category (opening plus purchases minus closing) still produces category margins. Vendor rebates, slotting fees, and promotional allowances reduce cost of goods, not revenue. Shrink — theft, breakage, out-of-date product — is recognized at count and tracked by category; it is usually the second-largest controllable cost after payroll.

How do excise and sales taxes flow through the books?

Alcohol and tobacco excise taxes are generally embedded in what you pay distributors and are part of inventory cost; some states impose additional store-level taxes or fees with their own filings. Sales tax applies to most merchandise but not to many grocery staples, and not to SNAP/EBT-eligible purchases paid with benefits; the register has to apply the rules per item and tender. Collected tax is a liability remitted on schedule, and the sales tax return must reconcile to the books' taxable sales by category.

How do you reconcile the register to the bank?

Daily. Each day's Z-report (sales by category, tax collected, tenders by type: cash, card, EBT, lottery, checks) is posted as a single journal entry; card settlements arrive net of fees a day or two later, EBT settles on its own schedule, and cash is deposited by someone. The reconciliation catches skimming, mis-keyed tenders, and processor errors — and a store with multiple shifts needs a per-shift cash count signed by the cashier. Processor fees are an expense, never netted out of sales.

What else goes wrong?

  • Owner draws run through the register or vendor payments made in cash, leaving the books incomplete.
  • Beer and spirits distributors paid by EFT on delivery, with invoices never entered — purchases that don't reach inventory.
  • Gas (if sold) with its own margin, taxes, and credit-card economics — a separate department entirely.
  • Licenses — liquor, tobacco, lottery, food — renewing annually, best accrued.

Which numbers should a store owner see every month?

  • Gross margin by category, after shrink.
  • Shrink as a percent of sales by category.
  • Sales per day and transaction count, with average basket.
  • Lottery commission and ATM income separately from merchandise.
  • Payroll as a percent of sales and hours per day.
  • Sales tax payable and excise filings due.

Frequently asked questions

My bank deposits are way below my register sales. Is something wrong?

Possibly — but first remove lottery sweeps, card fees, EBT timing, and ATM cash loads. The daily reconciliation is how you tell theft from timing.

Can I count inventory once a year?

Not if you want to know your margin. Monthly category counts (beer and tobacco at minimum) are the norm for stores that control shrink.

Are lottery commissions taxable income?

Yes — the commission is revenue. The ticket sales themselves are not, and shouldn't be on your income line.

What does clean convenience-store bookkeeping make easier at tax time?

Revenue that reconciles to processor, lottery, and bank records; inventory supported by counts; cost of goods net of rebates; and sales tax filings that tie to the books — the exact areas a retail audit targets.

Next step

Fairlight Accounting handles U.S. domestic, cross-border (U.S.–Canada), and international tax returns, plus bookkeeping, payroll, and CFO advisory. If your store's books can't separate lottery from sales or beer margin from tobacco margin, our bookkeeping team can set up the categories, the daily reconciliation, and the monthly report. See our bookkeeping service, pricing, or book a free fit call.

Related service: Bookkeeping

Cross-border taxes, handled in one place

U.S. and Canadian filings prepared together by our U.S. and Canadian Tax Desks.

Book a free fit call

Have a question about Bookkeeping?

Book a free consultation and get a straight answer from our cross-border tax team — no obligation.