Start with five parts of the business
A spreadsheet should help you answer a question you actually have: which location needs a visit, which products need buying, or what was left after expenses last month. Start with the records below rather than building a dashboard with numbers you cannot maintain.
Use the same machine ID everywhere. Keep two machines at one property separate if you want to compare them, and also retain the location name so you can review the stop as a whole. A clear naming system is more useful than a complicated formula attached to inconsistent records.
| Record | Include | Question it helps answer |
|---|---|---|
| Machines | ID, location, equipment details, host terms | What do I operate and where? |
| Sales and costs | Period, sales, product cost, commissions, fees, service costs | What remains after the costs recorded? |
| Inventory | Product, unit cost, storage and machine counts | What needs replenishing? |
| Route visits | Visit date, work done, issues, follow-up | What needs attention next? |
| Summary | Totals drawn from the underlying records | Where should I take a closer look? |
Keep a sales total from turning into a profit claim
For a simple monthly operating view, subtract product cost, host commission, payment fees, and service costs from sales. Use the same month for every input. If a payment report covers a different period, reconcile the difference before comparing machines.
In an illustrative example, $600 in sales minus $270 of goods sold, $60 in commission, $25 in payment fees, and $90 in service costs leaves $155. That is a contribution after the costs entered—not take-home profit. Financing, depreciation, tax, and any omitted expenses still matter. The free calculator lets you change those operating inputs yourself.
Buying stock and selling stock happen at different times. Keep purchase records for cash planning, but use the cost of the goods actually sold when reviewing sales profitability. If your bookkeeping or tax treatment is uncertain, ask a qualified professional to help you set it up; the toolkit is not a substitute for accounting advice.
Make the spreadsheet easy to keep current
Choose a repeatable time to enter each visit and review the month. Keep the original receipt or report reference with your records so a number can be checked later. Mark estimates clearly and replace them when actual records arrive.
Save an untouched copy of a template before editing. Keep backups of your working files, and be deliberate about who receives a copy. Do not put passwords, card details, or unnecessary personal information into a machine log. If more than one person enters records, agree who updates each file so two versions do not silently diverge.
Build your own, or start with the Operator System
You can build these records yourself using the structure above. If you would rather start with editable files, the $79 Operator System includes a core workbook with Dashboard, Machines, Machine P&L, Inventory, and Route tabs. Those are tabs within one workbook, not five separate files.
The full download contains 19 XLSX spreadsheets, five PDF guides, and one editable DOCX location agreement template, plus getting-started material and a file list. It covers location assessment, startup planning, business records, and specialty models. The product page lists the actual files so you can judge which ones fit your business.
You enter your own numbers. The files do not sync with card readers, banks, or machines, and they do not promise business results. You need software that opens XLSX, a PDF reader, and a DOCX editor for the agreement. Checkout and download access are handled through Gumroad.
Sources & scope
Use this guide to help plan your next steps. Examples explain the calculations; they aren’t earnings forecasts. Check local requirements, get supplier terms in writing, and use your own records when making business decisions. This is educational guidance, not professional advice or original market research.
- SBA: Manage your business
Background on business finances and recordkeeping. The sample vending records and calculations in this guide are our illustrative examples, not SBA benchmarks.
Source background checked September 6, 2026. The links provide background, not validation of a particular location or product.
Keep these records in one toolkit.
Get editable spreadsheets for machines, costs, inventory, and route visits, alongside guides and a location agreement template.
Find the right file in the $79 toolkit
Open the free location checklist, try the free sales-and-cost calculator, or explore the $79 Operator System for spreadsheets and templates to track costs, assess locations, and organize your business.