Vending Machine Bookkeeping That Survives a Bad Month

One machine, one profit center. How to build a chart of accounts, record card sales gross with the fee separate, and find the machine losing money quietly.

分享此贴

A two-van operator in Ohio showed me two numbers last year. His profit and loss statement said the business made about $3,100 a month. His bank account had grown by $900 over the same period. Both numbers were real. Neither was wrong. The gap was sales tax he had collected, booked as income, and spent on a used van in March.

That is not a rounding problem. It is the difference between a set of books that tells you what happened and a set that tells you what you want to hear. Vending machine bookkeeping has one awkward feature that most small business accounting advice ignores. You are running twenty or two hundred tiny retail stores, each with its own revenue, its own cost of goods, its own commission, and its own spoilage, and most of them are a forty minute drive apart.

Get that structure right and the monthly close takes forty minutes. Get it wrong and you spend three weekends in April reconstructing a year.

One machine, one profit center

The first decision in vending machine bookkeeping is not software. It is whether every dollar gets tagged with a machine.

If you cannot answer which machine earned a dollar, you cannot answer which machine is worth keeping, which one needs a price change, or which one is quietly losing money while the route average hides it. A route that nets $2,400 a month can contain one machine losing $60 and three carrying the rest.

The practical version of this is a machine ID that appears everywhere. On the deposit slip. On the purchase order for that machine’s stock. On the commission check. On the service log. It does not need to be clever. A two letter site code and a number is enough, as long as the same string shows up in every record.

Once the tag exists, vending machine bookkeeping becomes a filtering problem rather than a memory problem. You are not maintaining twenty separate spreadsheets. You are running twenty different views of one ledger.

A chart of accounts that does the work

Most vending machine bookkeeping setups start with six accounts and grow them into a mess. Start with the ones that answer questions instead.

AccountTypeWhat it answers
Vending salesIncomeGross revenue, cash and card combined
Product costCost of goods soldWhat the goods you actually sold cost
Card processing feesExpenseWhat the reader takes
Location commissionsExpenseWhat the site takes
Sales tax payableLiabilityWhat you owe the state, not yours
Undeposited fundsOther current assetMoney settled but not yet in the bank
Machines and equipmentFixed assetWhat you own and depreciate
Owner drawEquityWhat you took out

Two of those rows do more work than the rest.

Sales tax payable is a liability because the money was never yours. Booking it as income inflates revenue, inflates profit, and creates a tax bill on money you already sent to the state. This single mistake is the most common reason a small operator’s books and bank account disagree by five figures.

Undeposited funds is the account that makes card reconciliation possible. When a processor settles on Tuesday for Friday through Sunday sales, the money is real but not in your account yet. Without a holding account, every weekend looks like a loss until Wednesday.

If you use QuickBooks, classes are the cheap way to tag machines, and they are available on the Plus tier and above. A class per machine, or per site if you run two machines at one address, gives you a profit and loss by class in one click. The alternative is a spreadsheet with a machine column, which works fine at eight machines and stops working at twenty.

Cash and card are two different reconciliations

Cash is a counting problem. Card is a timing problem. Treating them the same is the most common vending machine bookkeeping error, and it is why the first week of every month feels like detective work.

For cash, the discipline is a collection log with the machine ID, the date, the meter reading, and the count, filled in at the machine rather than at the kitchen table. A cash handling routine that takes ninety seconds per stop prevents the version where you find $340 in a cup holder in September.

For card, the rule is to record gross sales and the fee separately, never the net deposit as revenue. A $980 card month that settles as $921.69 is $980 of sales and $58.31 of expense. Book the net and your revenue is understated, your fee expense is invisible, and your margins look better than they are until you try to explain them to a lender.

The matching detail that trips people up is settlement lag. A Friday batch often lands Monday or Tuesday, and weekend batches frequently combine. Match deposits by batch total and date range, not one transaction at a time. Chasing individual vends against a bank line is a losing chase with a $2.45 average ticket.

Cost of goods sold is about what left the machine

Inventory is the account where vending machine bookkeeping quietly breaks. Buying stock is not an expense. It becomes one when the product sells.

The arithmetic that works without a full inventory system is opening stock plus restocks minus closing stock equals units sold. Multiply by unit cost and you have cost of goods sold for that machine for that period. It is approximate, and it is far better than expensing every purchase order, which produces a profit figure that swings with your ordering habits rather than your sales.

The gap between those two numbers is shrink, and it deserves its own line. Spoilage, expired product, a jammed spiral that crushed four bags, and the occasional missing case all land there. When shrink on one machine runs three times the route average, you have learned something a sales report cannot tell you. Our inventory management guide covers the par level side of the same problem.

The number that decides whether a machine stays

Once every transaction carries a machine tag, you can calculate contribution margin per machine per month.

Contribution margin equals gross sales minus product cost minus location commission minus card fees minus direct maintenance and parts. That is it. Notice what is missing. Fuel, insurance, the truck payment, and your own wage are route level costs, and they belong above the machine line, not inside it. The point of the number is to isolate the profit that exists because that machine exists.

A negative contribution margin means the machine is destroying value before you start the van. That is a removal decision, not a pricing experiment.

The rule of thumb I use is two hours of fully loaded route cost. If a machine’s monthly contribution is below what two hours of driving, loading, and labor actually costs you, it is a candidate for relocation. Operators who run this report quarterly tend to prune somewhere between ten and twenty percent of their equipment in the first year, and the remaining route usually earns more than the original one did.

That is the counterintuitive part of vending machine bookkeeping. The report’s main job is not to tell you what you made. It is to tell you what to stop doing.

Sales tax is not revenue, and the rate is not one rate

Vending sales tax rules vary by state in ways that surprise people. Some states tax all vending sales at the standard rate. Some exempt food below a price threshold. A few apply a separate vending rate. Some put the obligation on the operator and some on the site owner, depending on the agreement.

Two habits keep this manageable. Record taxable and exempt sales separately for each machine, and record the jurisdiction for each site, because two machines twelve miles apart can sit in different taxing districts. Our sales tax guide walks through the state variation in more detail.

Then reconcile the liability account monthly against what you actually remitted. If the balance grows for three months without a payment, you have either a filing problem or a data problem, and both get more expensive with time.

The small ticket problem

Card fees deserve their own paragraph in a vending business because the ticket size is smaller than almost any other retail category.

Published vending rates cluster around two shapes. A blended rate near 5.95% with no per swipe charge, or a lower percentage plus a fixed amount, something like 2.5% plus ten cents. On a $12 sale the second shape wins easily. On a $2.45 sale, which is close to the industry average cashless ticket, the flat ten cents is worth more than four percentage points of the transaction.

The break even between those two shapes sits near $2.90. Below it, take the blended rate. Above it, take the percentage plus fixed fee. Most snack and drink machines live below the line, which is the opposite of what a generic merchant services pitch assumes. Our processing fee breakdown has the arithmetic.

The bookkeeping consequence is simple. Track fees per machine, not per month. A machine with a high card share and a low ticket can carry an effective rate near fifteen percent, and you will never see that in a single monthly total.

The forty minute close

A vending machine bookkeeping close that takes forty minutes gets done. One that takes a weekend gets postponed until it is useless.

  • Pull the card settlement report for the month and confirm it ties to the deposits by batch total.
  • Enter cash counts by machine from the collection log.
  • Enter restocks and closing inventory, then calculate cost of goods sold per machine.
  • Record commissions from the site statements, and check each one against the contract rate.
  • Reconcile sales tax payable against filings and payments.
  • Review the profit and loss by class and flag anything that moved more than twenty percent.
  • Set a closing date and password it, so last month stops changing.

That last step matters more than it sounds. Books that can be edited silently are books nobody trusts, and the first time you need a clean twelve month history for a loan or a sale, you will want the periods locked.

What the accountant needs from you

You do not need to do your own tax return. You do need to hand over something an accountant can use without charging you for archaeology.

That means a fixed asset register with purchase date, cost, and serial number for every machine, since machines are typically depreciated over five to seven years under MACRS, with Section 179 as an option if you qualify. It means a mileage log kept as you drive rather than reconstructed in January. It means W-9s for any route help you pay as a contractor, because those payments can require a 1099-NEC.

And it means a separation between business and personal money that survives a bad month. The entity and account structure piece covers why that matters beyond taxes.

Two stories, one lesson

The Ohio operator with the sales tax problem fixed it in an afternoon. He moved the liability to its own account, started transferring the collected amount to a separate savings account every Friday, and stopped treating the operating account as a measure of profit. His P and L dropped by about $500 a month on paper. His bank balance started matching it.

The second story is quieter. A fourteen machine route in the Pacific Northwest looked healthy at $2,900 a month net. Running contribution margin by machine found one unit at a hospital annex contributing $18 a month after commission and card fees, and costing about two and a half hours of drive time. It had been on the route for three years. Nobody had ever looked at it alone.

Both stories end the same way. The books were not wrong. They were just organized at a level where the useful question could not be asked.

If you are setting up the structure now, the business ROI model is the other half of the picture, and you can ask us which of our machines fits a route like yours. Vending machine bookkeeping will not sell a machine for you. It will tell you, honestly, whether the last one you bought was a good idea.

常见问题

How should a vending machine business keep its books?

Good vending machine bookkeeping starts with a machine tag on every transaction. Keep sales tax in a liability account rather than income, and record card sales gross with the processing fee as a separate expense. Then calculate cost of goods sold from what actually sold rather than what you purchased. That structure lets you produce a profit and loss per machine, which is the only view that shows which locations earn their keep.

Do I need accounting software for a small route?

Under about eight machines, a spreadsheet with a machine column and a disciplined monthly close is enough. Past that, class tracking in QuickBooks or a similar tool saves more time than it costs, because a profit and loss by class replaces the manual filtering. What matters is consistency, not the tool. The same machine ID in the same column every month beats any feature list.

Should card deposits be recorded as revenue?

Record the gross sale as revenue and the processing fee as an expense. Booking the net deposit understates revenue and hides the fee, which is the number you need to see when a machine’s average ticket is small. On a $2.45 average ticket, an effective rate near fifteen percent is possible, and it will stay invisible if you only ever see net deposits.

How do I account for product that spoils or goes missing?

Give shrink its own line rather than burying it in cost of goods sold. The figure comes from opening stock plus restocks minus closing stock, compared against units actually sold. A machine running well above the route average is usually telling you something about par levels, temperature, or a slow moving product line, and it is worth investigating before it becomes a habit.

What records should I keep for taxes?

A fixed asset register with the purchase date, cost, and serial number of each machine, since equipment is usually depreciated over five to seven years. A mileage log written as you drive. Sales tax filings with the taxable and exempt split by site. W-9s for contractors. And a clear trail from card settlement to bank deposit, because that is the first thing anyone asks for in an audit or a loan application.

订阅我们的时事通讯

获取最新信息并向专家学习

更多探索

您想促进业务发展吗?

请给我们留言并保持联系