{"product_id":"vending-machine-tracker-spreadsheet-per-machine-profit-ranking-restock-log-and-location-profit-google-sheets","title":"Vending Machine Tracker Spreadsheet | Per-Machine Profit Ranking, Restock Log and Location Profit - Google Sheets","description":"\u003cp\u003e\u003cstrong\u003eINSTANT DOWNLOAD — HOW IT WORKS:\u003c\/strong\u003e This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.\u003c\/p\u003e\u003cp\u003eWhich machines are quietly losing you money?\u003c\/p\u003e\n\u003cp\u003eEvery vending operator has them: machines that get restocked, collected, and serviced like clockwork — and still barely earn their floor space. The problem is never effort. It's that nobody adds up what each machine actually makes after product cost, the location's commission, and the drive out there.\u003c\/p\u003e\n\u003cp\u003eThis tracker does that math for you, machine by machine. Log each collection in one row, and the Dashboard ranks every machine by real profit per week — best to worst — and flags the ones falling under your line as RENEGOTIATE OR PULL, so the placement decision makes itself.\u003c\/p\u003e\n\u003cp\u003eTransparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT'S INSIDE — 7 focused tabs:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- \u003cstrong\u003eStart Here\u003c\/strong\u003e — a plain-English guide and quick-start steps\u003cbr\u003e- \u003cstrong\u003eDashboard\u003c\/strong\u003e — the ranking: every machine sorted by profit per week, route totals, business expenses, your net after expenses, and a flag count\u003cbr\u003e- \u003cstrong\u003eMachines \u0026amp; Locations\u003c\/strong\u003e — your roster: machine, location, type, the commission % you pay the location, weeks in period — with live totals per machine\u003cbr\u003e- \u003cstrong\u003eSales \u0026amp; Collections\u003c\/strong\u003e — one row per collection: gross sales, product cost, service\/travel cost. The location commission and net profit fill themselves in\u003cbr\u003e- \u003cstrong\u003eRestock \u0026amp; Inventory\u003c\/strong\u003e — what you bought for each machine and what each restock run cost, line by line\u003cbr\u003e- \u003cstrong\u003eProducts \u0026amp; Margins\u003c\/strong\u003e — your product list with unit cost, sell price, and margin per item, calculated for you\u003cbr\u003e- \u003cstrong\u003eExpenses\u003c\/strong\u003e — the route-level costs that belong to no single machine: fuel, repairs, insurance, card reader fees\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHOW IT WORKS\u003c\/strong\u003e\u003cbr\u003e1. After checkout you get a PDF with your private link. Click it and choose \"Make a copy\" — the tracker is yours.\u003cbr\u003e2. List your machines and what each location takes in commission. Log each collection as it happens — a minute per machine.\u003cbr\u003e3. Read the Dashboard. Every machine ranked by profit per week, and the dead spots flagged before they cost you another month.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTHE FLAG RULE, IN PLAIN ENGLISH\u003c\/strong\u003e\u003cbr\u003eProfit per week = a machine's net profit (gross sales − product cost − location commission − service\/travel) divided by the weeks in your period. Any machine under $25 profit per week gets flagged RENEGOTIATE OR PULL. That $25 is a starting line, not our opinion — it lives in one cell on the Dashboard, and changing it updates every flag. A flag isn't a verdict; it's the start of a conversation: renegotiate the commission, swap the product mix, raise a price — or pull the machine and place it where it earns.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHY THIS ONE\u003c\/strong\u003e\u003cbr\u003eMost vending spreadsheets track inventory or sales. Operators don't lose money on tracking — they lose it on placements. This one leads with the placement decision: which locations earn their floor space, and which ones you're subsidizing. It comes loaded with six fictional sample machines (offices, gyms, a laundromat, a warehouse) so you can watch the ranking and the flags work before you replace them with your own route.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eREQUIREMENTS:\u003c\/strong\u003e a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works at the warehouse, on the route, and on your phone.\u003c\/p\u003e\n\u003cp\u003eThis is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.\u003c\/p\u003e\n\u003cp\u003eFINISHED FILE — PLEASE READ: This listing is for the finished file exactly as shown — nothing is customized, personalized or revised. If anything prints wrong or you find an error in a file, message us and we will fix it — error fixes are always free, with no time limit.\u003c\/p\u003e","brand":"InkSheet Studio","offers":[{"title":"Default Title","offer_id":68083121619229,"sku":null,"price":2.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1015\/0618\/7549\/files\/01-hero_e152948a-47c1-4ee8-bdfc-53e946f8153a.jpg?v=1794697108","url":"https:\/\/inksheetstudio.com\/products\/vending-machine-tracker-spreadsheet-per-machine-profit-ranking-restock-log-and-location-profit-google-sheets","provider":"InkSheet Studio","version":"1.0","type":"link"}