Cash register reconciliation is the single most important daily task for any brick-and-mortar business. Yet according to the National Association of Convenience Stores (NACS), the average convenience store loses between $2,000 and $8,000 annually from cash handling errors alone — not theft, just mistakes. When you add in employee dishonesty, the number climbs significantly higher.
If you're running a convenience store, gas station, or franchise location and you're only reconciling your registers weekly or monthly, you're essentially flying blind. By the time you spot a problem, the trail is cold, the shift records are gone, and the money is unrecoverable.
This guide walks you through the complete daily cash reconciliation process — from opening your register in the morning to filing your final report at night. Whether you're doing this manually or considering automation, you'll find actionable steps you can implement today.
What Is Cash Register Reconciliation?
Cash register reconciliation is the process of comparing the actual cash in your register drawer to the amount your point-of-sale (POS) system says should be there. The difference between these two numbers is your over/short — the most critical daily metric for any cash-handling business.
The formula is simple:
Actual Cash in Drawer – Expected Cash (per POS) = Over/Short Amount
A perfectly reconciled register shows $0.00 over/short. In practice, small variances of $1-$2 are normal due to change-making. Anything over $5 deserves investigation. Anything over $20 demands immediate action.
Before You Begin: What You Need
Before you start your daily reconciliation, gather these items:
- Cash counting sheet — a printed form that lists denominations ($100, $50, $20, $10, $5, $1, quarters, dimes, nickels, pennies)
- POS Z-report or end-of-day report — the system-generated summary of all transactions for the shift
- Calculator — or use the POS system's built-in reconciliation feature if available
- Safe drop log — records of any mid-shift cash deposits to the safe
- Payout receipts — records of any cash paid out for vendor CODs, lottery payouts, or petty cash
- Starting bank amount — the exact amount you placed in the drawer at the start of the shift
Step-by-Step Daily Reconciliation Process
Step 1: Run the Z-Report (or End-of-Shift Report)
At the end of every shift — not just at the end of the day — run the Z-report from your POS system. This report captures:
- Total cash sales for the period
- Total credit/debit card sales
- Voids and refunds processed
- No-sale drawer opens
- Lottery payouts (if applicable)
- Any other cash-in or cash-out transactions
The Z-report is your system of record. Print it immediately and never run it twice — the second run resets the counters on most POS systems, destroying your audit trail.
Step 2: Remove the Drawer and Count Cash by Denomination
Remove the entire cash drawer from the register. Take it to a secure counting area — ideally a back office with camera coverage. Never count cash at the register where customers can observe your process.
Count every denomination separately and record the results:
- $100 bills — Count twice. Hundreds are where the biggest errors occur.
- $50 bills — Count twice. These are uncommon enough that an extra one stands out.
- $20 bills — This is typically the largest stack. Count in groups of 5 ($100 bundles).
- $10 bills — Count once, verify once.
- $5 bills — Count once, verify once.
- $1 bills — Count in groups of 25 ($25 bundles).
- Coins — Count by denomination. Round to nearest dollar if under $5 total coin variance.
Write the total for each denomination on your counting sheet, then add them up. This is your Total Cash in Drawer.
Step 3: Calculate Expected Cash
Your expected cash is calculated as:
Starting Bank + Cash Sales (from Z-report) – Cash Payouts – Safe Drops = Expected Cash in Drawer
Let's walk through an example:
- Starting bank: $200.00
- Cash sales (Z-report): $1,847.50
- Lottery payouts (cash): –$125.00
- Safe drops during shift: –$1,400.00
- Vendor COD payment: –$85.00
- Expected cash: $437.50
Step 4: Compare Actual vs. Expected
Now compare your counted cash to the expected amount:
- Actual cash counted: $432.75
- Expected cash: $437.50
- Over/Short: –$4.75 (short)
A $4.75 shortage on a shift with $1,847 in cash sales represents a variance of 0.26% — within the acceptable range for most operators. Document it and move on.
Step 5: Investigate Any Significant Variance
If your over/short exceeds $5, start investigating immediately. The most common causes of cash register discrepancies are:
- Counting errors — Recount the drawer. A misplaced $5 or $10 bill is the most common explanation.
- Unrecorded safe drops — Check if a mid-shift safe drop was made but not logged in the POS.
- Incorrect change given — Review large-bill transactions. Giving change for a $50 when the customer handed you a $20 creates a $30 shortage instantly.
- Voided transactions — Check all voids on the Z-report. Was merchandise voided but cash not returned to the drawer?
- Lottery payout errors — Lottery is one of the top sources of cash discrepancies at convenience stores. Verify every winning ticket payout against the lottery terminal report.
- No-sale drawer opens — Multiple no-sale events can indicate cash removal. Cross-reference with video if available.
Step 6: Record and File
Every day's reconciliation should be recorded in a log that tracks:
- Date and shift
- Cashier name or ID
- Starting bank amount
- Total cash sales
- Total safe drops
- Total payouts
- Actual cash counted
- Over/short amount
- Explanation for any variance over $5
- Manager signature
Keep these records for at least 12 months. If you're a franchisee, your franchisor may require longer retention. 7-Eleven franchisees, for example, must maintain records that align with corporate audit cycles.
The 5 Most Common Reconciliation Mistakes
Mistake 1: Reconciling at the End of the Day Instead of Per Shift
If you have two or three cashiers working different shifts and you only reconcile once at closing, you have no way to know which shift caused the shortage. Always reconcile at every shift change.
Mistake 2: Allowing Cashiers to Count Their Own Drawers Unsupervised
The person counting the cash should not be the same person who operated the register. If that's not possible (in single-employee shifts), ensure camera coverage of the counting area and require a manager to verify the count within 24 hours.
Mistake 3: Forgetting to Account for Lottery Payouts
Lottery is the number-one blind spot in convenience store reconciliation. The average convenience store loses approximately $5,000 per year to lottery-related discrepancies — a mix of payout errors, ticket theft, and reconciliation failures. Always run a separate lottery terminal report and reconcile it against your cash payouts.
Mistake 4: Not Tracking Over/Short Trends Over Time
A single $10 shortage means nothing. Ten consecutive $10 shortages on the same cashier's shift means everything. Track your over/short data in a spreadsheet or reconciliation system and look for patterns by cashier, shift, and day of week.
Mistake 5: Skipping Reconciliation on Busy Days
The busiest days — holidays, weekends, promotional events — are precisely when errors and theft are most likely. Never skip reconciliation because "we were too busy." That's when you need it most.
Manual Reconciliation vs. Automated Systems
Manual reconciliation works — it's how businesses have operated for decades. But it has significant limitations:
Automated reconciliation services like DohAssist pull data directly from your POS system, lottery terminal, and fuel dispensers. They reconcile cash, credit, lottery, and fuel automatically — flagging discrepancies the same day they occur. For operators with more than one location, this eliminates the need to physically be at every store every day.
Special Considerations: Fuel and Lottery
Fuel Reconciliation
Gas station operators have an additional reconciliation layer: fuel inventory. Every day, you should compare:
- Gallons sold (from POS/dispenser readings)
- Gallons delivered (from fuel delivery tickets)
- Tank stick readings or automatic tank gauge (ATG) data
The industry-accepted variance threshold is approximately 1% of throughput plus 130 gallons per tank per month (per Warren Rogers research). Anything beyond that suggests a leak, meter drift, or theft.
Lottery Reconciliation
Lottery reconciliation requires matching three data sets:
- Lottery terminal activation report — tickets activated during the shift
- Lottery terminal payout report — winning tickets cashed out
- Cash drawer impact — net lottery cash flow (activations collected minus payouts given)
The gap between what your lottery terminal says and what shows in your cash drawer is your lottery shrink. Industry research from LottoReco suggests that 40-50% of lottery shrink at convenience stores comes from employee theft — cashiers cashing winning tickets and pocketing the proceeds or activating scratch-offs without payment.
Building Your Daily Reconciliation System
Whether you choose manual or automated reconciliation, you need a consistent system. Here's a framework:
- Morning: Verify starting bank. Record opening ATG/fuel readings. Count lottery inventory.
- Shift change: Run Z-report. Count drawer. Record over/short. Reset for next shift.
- End of day: Final Z-report. Full cash count. Lottery terminal report. Fuel readings. Compile daily reconciliation report.
- Weekly: Review over/short trends. Identify patterns by cashier. Address any recurring variances.
- Monthly: Full inventory count. Compare lottery commissions received vs. expected. Review fuel loss/gain report. File monthly P&L reconciliation.
Frequently Asked Questions
Manual reconciliation typically takes 45-60 minutes per shift, including counting, documentation, and filing. With an automated service like DohAssist, the store-level effort drops to 5-10 minutes — primarily the physical cash count and safe drop verification.
Most operators consider a variance under $5 per shift acceptable and attributable to normal change-making. Variances of $5-$20 should be documented and investigated within 24 hours. Anything over $20 requires immediate investigation and likely involves video review.
Always reconcile per shift. If you only reconcile at end-of-day and you have two or three shifts, you can't isolate which cashier or time period caused a discrepancy. Per-shift reconciliation is the standard for franchise operations and is required by many franchisors.
Run a separate lottery terminal report every shift. Compare the net lottery cash flow (ticket sales minus payouts) to the actual cash impact on your drawer. Track lottery discrepancies separately from general cash over/short. If discrepancies exceed $50/week consistently, consider implementing a lottery-specific reconciliation service.
Yes. Services like DohAssist connect directly to your POS system, lottery terminal, and fuel dispensers to pull transaction data automatically. The physical cash count still happens at the store, but all the data matching, variance calculation, trend analysis, and reporting is handled for you — including lottery and fuel reconciliation.