How to Reconcile Vending Machine Cash: Counted vs Expected (Spreadsheet Method)

Most vending operators count their cash. Far fewer know what the count was supposed to be.

That’s the whole difference. Counting tells you how much money you have. Reconciling tells you whether the machine gave you all of it — and it’s the only way to distinguish “someone is skimming” from “the coin hopper dispensed a lot of quarters last week.”

The reason people skip it isn’t laziness. It’s that calculating expected cash by hand, per machine, per visit, is genuinely annoying. Which is exactly the kind of problem a spreadsheet exists to erase.

What Reconciliation Actually Means Here

Two numbers, one difference:

Expected cash = the cash sales the machine should have taken since your last collection Counted cash = what you actually pulled out and counted Over / short = counted − expected

Positive is over. Negative is short. Neither is automatically bad. What you’re looking for is a pattern, and you cannot see a pattern without a running log.

Calculating Expected Cash Without Getting It Wrong

Expected cash is units sold multiplied by vend price — but only for the cash portion of sales.

This is the step that ruins most first attempts. If the machine sold $340 last cycle and $240 of that went through the card reader, your expected cash is $100. Run the calculation against total sales and every collection looks catastrophically short, you panic about theft that isn’t happening, and you abandon the practice within a month.

Given how far cashless has gone, this matters more every year. Cantaloupe’s Micropayment Trends Report put U.S. vending at 71% cashless in 2024, a 17% jump in a single year, with contactless making up 77% of those cashless sales. On a modern machine, cash is now the minority channel — but it’s the only channel that can physically walk away, which is why it’s the one you reconcile.

So the working formula is:

Expected cash = Σ (units sold × vend price) − card sales for the period

Then, per collection:

Setting a Tolerance So the Log Means Something

If every $0.75 variance flags red, you’ll ignore the flags inside two weeks. Set a band.

A practical rule: $2.00 or 1% of expected cash, whichever is larger. On a $110 collection that’s $2.00; on a $600 micro market week that’s $6.00. Anything inside the band is noise. Anything outside gets a note.

Then let the sheet do the judging. A single formula comparing the absolute over/short against your tolerance turns 200 rows of numbers into a column that says “OK” or “Check” — and now you’re reading a report instead of scanning a ledger.

The Vending Machine Business Tracker from ReadySheetGo handles this on its Cash Reconciliation tab: you set your tolerance once on the Settings sheet, enter expected and counted per collection, and the over/short and status flag calculate themselves — anything past tolerance turns red without you looking for it.

Reading the Pattern: Six Causes Before Theft

When a machine comes up short, run the list in order of likelihood. Theft is at the bottom for a reason.

1. Change dispensed. The hopper handed out $9.25 in quarters against bills you’re now counting. If you don’t account for the change bank, every busy cycle looks short. Count the hopper as part of the machine’s cash position, not as a loss.

2. A jam. The customer paid, the coil didn’t turn, they walked away. You keep the money and lose the product, so this actually shows up as over on cash and short on inventory — which is why reconciling cash without reconciling units only tells you half the story.

3. Price mismatch. The machine is set to $1.75 for a product your Products sheet says vends at $2.00. Every single sale is 25 cents “short” and the arithmetic will never balance until you walk out and check the price on the selection.

4. Free vends. You tested three selections during the service visit. That’s $6 of product and no cash. Log it or it becomes a mystery.

5. Miscount. Coin counts drift. It happens.

6. Then theft. By which point you’re not guessing — you have a machine that’s been short on nine of the last eleven collections while the other four machines run clean.

That last sentence is only available to someone with a log. Without one, the honest answer to “is that machine being skimmed?” is always “I don’t know,” and the honest answer is what keeps people from acting.

The Shrinkage Context

Loss is a live concern across the industry, not a paranoid one. The 2026 State of the Vending and Micro Market Industry report found nearly two-thirds of operators reporting shrink under 5%, with 12.5% reporting shrink above 10%. Cameras tied to monitoring services were the most commonly reported deterrent, followed by visible camera feeds and signage — but the report also lists regular inventory audits as a core tool for identifying and measuring losses.

That distinction is worth sitting with. Cameras deter. Reconciliation measures. You need the measurement to know whether the deterrent is working, and to know which of your machines deserves the camera in the first place.

At 5% shrink on a route grossing $2,000 a month, you’re losing $1,200 a year. At 10%, $2,400 — most of a new machine.

Tracking Deposits Too

One more column, easy to skip, immediately useful: Deposited? Yes/No.

Vending is one of the few small businesses still generating meaningful physical cash, and cash sitting in a bag in your truck is cash that isn’t in the business and isn’t in your books. A deposit flag per collection means you can answer “how much collected cash is currently undeposited” in one glance, which is both an internal control and a favor to whoever does your taxes.

The Habit

Reconciliation only works if it’s part of the service visit, not a monthly catch-up session. Count at the machine, enter the row that evening or from your phone at the truck, move on. Four fields — date, machine, expected, counted — and the sheet does the rest.

Do it for a quarter and you’ll have something most operators never get: a factual answer to which machines are clean, which are drifting, and which need attention this week rather than eventually.

Featured on ReadySheetGo

Vending Machine Business Tracker — 9 tabs for new and scaling vending operators. Machine register, product sheet with auto margin % and profit-per-unit flags, sales & restock log where revenue and COGS fill in automatically, cash reconciliation with a configurable over/short tolerance and red flags, commission payout tracker for flat rent or % of sales, a dashboard ranking every machine and location by profit, and an ROI Calculator with payback months per unit. Pre-filled with sample data. Works in Excel and Google Sheets, no macros. Instant digital download — $13.99.

Sources: Cantaloupe — 2025 Micropayment Trends Report · Automatic Merchandiser — 2026 State of the Vending & Micro Market Industry