Tracking cash drawers across multiple stores: paper, POS, spreadsheet or app
To track cash drawer over/short across several stores, use any method that records one row per drawer per shift with the same fields at every store and puts all stores on one screen each week: a POS cash-management feature, a shared spreadsheet or a store-operations app can do that, and paper can only if someone retypes it. Three stores with two registers and two shifts produce 84 drawer counts a week.
Four ways to track drawers across stores
| Method | Who enters the count | When the owner sees it | Cross-store view | Weak point |
|---|---|---|---|---|
| Paper count sheets | Closer, on a printed sheet | When sheets reach the office | None until someone retypes them | Math done by hand; sheets get lost |
| POS cash management | Cashier or manager, in the POS at drawer close | As soon as the drawer session ends | Depends on the POS; one report across locations NOT FOUND for Square in our check | Only covers stores and registers on that POS |
| Shared spreadsheet | Closer, from a phone or the office computer | As soon as the row is typed | Yes, if every store uses one log | Anyone with edit access can change past rows or break a formula |
| Store-operations app with drawer counts | Closer, in the app | As soon as the count is saved | Yes, by location | One more app for staff to learn |
Example of the volume: 3 stores × 2 registers × 2 shifts × 7 days = 84 drawer counts a week, or 84 × 52 = 4,368 a year. With paper, each of those is retyped or never compared.
Option 1: paper count sheets
Paper works when one person reads every sheet within a day. Use a denomination sheet (the template is in how to count a cash drawer), staple it to the register tape, and have the closer and a witness initial it. The IRS lists cash register tapes and deposit information among the records that support gross receipts, so the sheets double as records.
Across stores, paper fails on timing: a short at Store C is found when the envelope arrives, not that night.
Option 2: the POS cash-management feature
If all your stores run one POS, check its cash-management screens first. Square's help center, for example, describes a cash management feature that tracks starting cash and expected cash per drawer session, ends the session with the actual counted amount, and runs on Android tablets, iPad, Square Terminal, Square Register and Square Handheld but not on mobile phones. Square's help pages show the add-on as "Add for free" in the POS app.
Ask your POS vendor three questions before relying on it:
- Can I see every location's drawer sessions in one report, sorted by over/short?
- Does the session record which employee counted, not only who was logged in?
- Can the counter enter the count without first seeing the expected cash (a blind count)?
Option 3: one shared spreadsheet
A single log with the same columns at every store gives a cross-store view for free. Put the formulas in columns staff never type in.
| Column | Field | Typed or formula |
|---|---|---|
| A | Date | Typed |
| B | Store (pick from a fixed list) | Typed |
| C | Register | Typed |
| D | Cashier | Typed |
| E | Float | Typed |
| F | POS cash sales | Typed |
| G | Paid-outs | Typed |
| H | Expected cash | =E2+F2-G2 |
| I | Counted cash | Typed |
| J | Over/short | =I2-H2 |
| K | Counted by | Typed |
Example row: float 200.00, cash sales 812.40, paid-outs 25.00 gives H = 200.00 + 812.40 − 25.00 = 987.40; counted 990.40 gives J = 990.40 − 987.40 = +3.00 over. How to compare stores of different sizes from this log (absolute variance per $1,000 of cash sales) is in tracking cash variance across multiple stores.
Spreadsheet rules that keep it honest: one row per drawer per shift, never edit a past row (add a correction row with a note), and keep a copy of each week's file before the next week starts.
Option 4: an app built for store operations
In our November 2026 check of vendor pricing and feature pages, a cash-drawer count feature was NOT FOUND for Sling, Homebase, 7shifts, Deputy, When I Work, ZoomShift, Connecteam or Buddy Punch; Connecteam offers a downloadable cashier closing checklist template, which is a form, not a count log. Homebase's "Cash Out" is an earned-wage pay feature, not a drawer count.
What a drawer-tracking app must record, whatever you pick:
- Location, register, date and shift on every count
- Denomination-level count, so a recount can find the error
- Expected cash and the signed over/short
- The counter's name, separate from the cashier's
- A note field, required above your written threshold (see cash drawer over/short)
- A list of all stores' counts for one week on one screen
Assistlify records cash-drawer counts and stock counts per location alongside the weekly schedule; it is in early access and can be tried in the preview workspace.
Which option fits
| Your setup | Start with |
|---|---|
| One store, owner closes most nights | Paper sheets plus the free cash drawer count calculator |
| 2-5 stores, all on one POS with drawer sessions | The POS feature, after the three questions above |
| 2-5 stores, mixed POS or no cash-management feature | The shared spreadsheet or a store-operations app |
| Shorts repeating at one store | Add blind counts and a second counter before changing tools |
Questions
Is there an app to track cash drawer counts?
Some POS systems include drawer sessions; Square's help center describes tracking starting, expected and counted cash per drawer session. A cash-drawer count feature was not found on the pricing or feature pages of the eight scheduling apps we checked.
How do I track cash over/short in Excel or Google Sheets?
Use one row per drawer per shift with expected cash = float + cash sales − paid-outs and over/short = counted − expected; a $200.00 float, $812.40 sales, $25.00 paid-outs and $990.40 counted is +$3.00 over.
How many drawer counts does a 3-store business log?
With 2 registers and 2 shifts per store, 3 × 2 × 2 × 7 = 84 counts a week.
Should cash counts be kept for taxes?
The IRS lists cash register tapes and deposit information among the records that support gross receipts, so keep the count sheet or log with them.
Sources
- Square Support: Set up cash management (article 5152) (checked 2026-11-12)
- Square Support: Start and end a cash drawer session (article 8344) (checked 2026-11-12)
- IRS: What kind of records should I keep (checked 2026-11-12)
- Connecteam: Cashier closing checklist template (checked 2026-11-12)
- Homebase pricing (checked 2026-11-12)
- Sling pricing (checked 2026-11-12)
- 7shifts pricing (checked 2026-11-12)
- Deputy pricing (checked 2026-11-12)
- When I Work pricing (checked 2026-11-12)
- ZoomShift pricing (checked 2026-11-12)
- Buddy Punch pricing (checked 2026-11-12)