Cash Drawer Reconciliation
Free cash drawer reconciliation template for Excel. Track cash sales, payments, and drawer shortages for retail and restaurant.
| Line Item | Amount |
|---|---|
| Beginning Balance | |
| Starting Cash in Drawer | $200.00 |
| Cash Received | |
| Cash Sales | $1,250.00 |
| Cash Payments Received | $350.00 |
| Other Cash Receipts | $0.00 |
| Total Cash In | $1,600.00 |
| Cash Paid Out | |
| Cash Payouts | $45.00 |
| Change Given | $150.00 |
| Bank Deposits | $1,200.00 |
| Total Cash Out | $1,395.00 |
| Expected Ending Balance | $205.00 |
| Count | |
| Actual Counted | $195.00 |
| Shortage / Overage | ($10.00) |
Cash Drawer Reconciliation
Get New Templates in Your Inbox
Join 2,000+ others getting free finance templates. No spam, unsubscribe anytime.
Daily Tracking
Record each shift
Shortage Alerts
Spot discrepancies
Multi-Shift
Track all shifts
Auto-Calculations
Totals computed
How to Use
1. Set starting balance for each shift.
2. Record all cash received from sales and payments.
3. Track cash paid out for change and payouts.
4. Count ending balance and compare.
The spreadsheet flags any shortage or overage automatically.
What's Included
Complete cash drawer tracking:
Related Templates