GUIDES

Tracking cash drawers across multiple stores: paper, POS, spreadsheet or app

Updated 2026-11-12 · By the Assistlify team · AI-assisted, every fact linked to its source below

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

MethodWho enters the countWhen the owner sees itCross-store viewWeak point
Paper count sheetsCloser, on a printed sheetWhen sheets reach the officeNone until someone retypes themMath done by hand; sheets get lost
POS cash managementCashier or manager, in the POS at drawer closeAs soon as the drawer session endsDepends on the POS; one report across locations NOT FOUND for Square in our checkOnly covers stores and registers on that POS
Shared spreadsheetCloser, from a phone or the office computerAs soon as the row is typedYes, if every store uses one logAnyone with edit access can change past rows or break a formula
Store-operations app with drawer countsCloser, in the appAs soon as the count is savedYes, by locationOne 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:

  1. Can I see every location's drawer sessions in one report, sorted by over/short?
  2. Does the session record which employee counted, not only who was logged in?
  3. 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.

ColumnFieldTyped or formula
ADateTyped
BStore (pick from a fixed list)Typed
CRegisterTyped
DCashierTyped
EFloatTyped
FPOS cash salesTyped
GPaid-outsTyped
HExpected cash=E2+F2-G2
ICounted cashTyped
JOver/short=I2-H2
KCounted byTyped

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:

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 setupStart with
One store, owner closes most nightsPaper sheets plus the free cash drawer count calculator
2-5 stores, all on one POS with drawer sessionsThe POS feature, after the three questions above
2-5 stores, mixed POS or no cash-management featureThe shared spreadsheet or a store-operations app
Shorts repeating at one storeAdd 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