Your privacy choice. Allow optional analytics to help us improve these tools? We don’t send form entries or calculator numbers to Google. Privacy details

Route, profit, and inventory XLSX

Monthly Income & Expense Tracker

Build a monthly record that explains where the collections went.

Made for: An operator reconciling monthly records and preparing organized expense information for a bookkeeper or tax professional.

Preview the actual worksheets

Inside the actual file

See the worksheets before you buy

These excerpts show the blank template included in the download. Add your own products and operating records when you make your working copy.

Selected rows and columns are shown. A dash marks a blank cell; “Calculated” marks a cell with a workbook formula. These are readable excerpts, with the original worksheet labels.

01

Monthly Log

Selected income, purchase and expense rows. January–March and the annual total are shown; the workbook includes all twelve months.

Monthly Log — excerpt from the delivered XLSX
CategoryJanFebMarAnnual Total
Machine revenue — Location 1———Calculated
Machine revenue — Location 2———Calculated
Product purchases — snacks / candy———Calculated
Commissions paid to host locations———Calculated
Cashless payment / card reader fees———Calculated
Machine maintenance & repairs———Calculated
TOTAL OPERATING EXPENSESCalculatedCalculatedCalculatedCalculated
NET PROFIT (Gross − Operating Expenses)CalculatedCalculatedCalculatedCalculated
02

By Machine

The first machine's revenue, product cost and gross margin rows. The sheet supplies the example machine ID M-01; you enter your own machine records.

By Machine — excerpt from the delivered XLSX
Machine IDLocation NameJanFebMar
M-01Revenue———
—Product Cost———
—Gross Margin %CalculatedCalculatedCalculated

Inside the workbook

The working tabs

  • Monthly Log
  • By Machine
  • Tax Summary
  • How to Use

Editable XLSX file with an included Start Here tab. Use a compatible spreadsheet app and review formulas after opening.

What this file helps you do

Keep revenue and spending together

Monthly Log separates machine revenue, product purchases and operating expenses across January through December. Categories include host payments, payment fees, route costs, repairs and insurance.

Review individual machines

By Machine provides a separate monthly revenue and product-cost breakdown. Use it to see which locations need closer review rather than relying only on the annual total.

Prepare a useful handoff

Tax Summary brings annual category totals together for review. Keep receipts and source records with the workbook so your preparer can assess classification and any missing adjustments.

From download to use

Your first pass through the file

  1. Set the fiscal year and identify which source records support each category.
  2. Reconcile each month to collections, settlements and receipts.
  3. Review the annual summary with your accounting or tax professional.

Know what the file can tell you

The tax summary is organizational support, not a tax return or complete accounting system. Treatment of inventory, vehicle costs, depreciation and other deductions needs professional review.

Before you download

A closer look

Does this connect to my bank or payment processor?

No. Enter the amounts yourself using your records. The file does not import transactions, reconcile a bank account automatically or submit tax information.

What do I receive when I buy?

The $79 Operator System includes this file within a ZIP containing 25 operator files: 19 XLSX spreadsheets, five PDF guides and one DOCX agreement. Start Here and a file manifest are also included. You supply your own business data; the files do not connect to machines, banks or payment accounts.

VendingAnalysis Operator System

Put this tool to work with the rest of the kit.

Get Monthly Income & Expense Tracker and the other 24 operator files in one download.

Get the complete bundle · $79