Daily Cash Drawer Reconciliation – Free Excel Template for Retail Stores
Stop losing money at the cash counter. Match what the POS says you sold against what is actually in the drawer – every shift, every branch. The sheet calculates expected cash (float + sales – card –...
Stop losing money at the cash counter. Match what the POS says you sold against what is actually in the drawer – every shift, every branch. The sheet calculates expected cash (float + sales – card – returns), shows the variance and flags shortages automatically, with a dashboard of sales and shortages per branch.
Table Of Content

Why it matters
In a clothing, perfume or grocery store, profit is decided by small numbers: a few thousand dinars missing from the drawer every day, a supplier invoice paid twice, a discount that eats the whole margin. Stores that write these numbers down every day see problems weeks earlier and make calmer decisions.
What’s inside the template
You fill in: Date, Branch, Shift, Cashier, Opening Float (IQD), POS Sales (IQD), Card / Online (IQD), Cash Refunds (IQD), Counted Cash, Deposited to Bank/Safe, Checked by, Notes.
Calculated automatically:
- Expected Cash – Float + POS sales – card – refunds
- Variance – Counted – expected. Negative = shortage
- Status
How to use it, step by step
- Fill one row per cashier per shift.
- Enter the opening float, POS total, card payments and returns from the POS Z-report.
- Count the drawer and type the counted cash – the variance and status appear automatically.
- Variances within ±1,000 IQD are treated as Matched (change the 1000 in the Status formula if you want).
- Check the Dashboard weekly for branches with repeated shortages.
The dashboard: numbers to watch
- Total POS sales
- Total card / online
- Total counted cash
- Net variance
- Shifts with shortage
- Cash deposited
Summary tables: Sales & variance by branch.
Example from the template
| Date | Branch | Expected Cash | Variance | Status |
|---|---|---|---|---|
| 2026-11-01 | Baghdad Mall | 1,695,000 | – | Matched |
| 2026-11-01 | Baghdad Mall | 2,070,000 | -25,000 | Shortage |
| 2026-11-01 | Karbala | 1,010,000 | 500 | Matched |
Download the template free
Free, no registration. Two versions: English and Arabic (right-to-left). Works in Excel, Google Sheets and WPS.
Browse all 60 templates in the ProSite Library
Related templates
Need help running your store?
ProSite fits out, opens and runs retail stores in Baghdad and Erbil – store fit-out, visual merchandising, operations teams, IT setup and manager training. Call or WhatsApp us on +964 780 930 9998.




[…] Space Productivity – Sales per m² & per Fixture – Free Excel Template for Retail Stores Daily Cash Drawer Reconciliation – Free Excel Template for Retail Stores Retail Staff Performance Appraisal (KPI Score) – Free Excel Template for Retail Stores […]