Telemetry & Financial Reconciliation

Mike reveals how to turn machine data into profits by tracking KPIs, managing logs, and automating reconciliations with precision.

Core Reporting with Telemetry

Mike pulls custom sales reports by date, site, or machine, exporting CSV or PDF for accurate bookkeeping. He tags best/worst SKUs, comparing sell-through and margin.

Weekly KPIs include:

• Daily revenue per machine

• Gross margin % = (Revenue - COGS) / Revenue

• Sell-through % = Units Sold / Units Stocked

• Stockout hours per row

• Shrink or spoilage %

He uses auto-alerts for low inventory, temp spikes, or offline units.

End-of-Month & Barebones Alternatives

Mike runs an EOM close checklist: reconcile card payouts vs dashboard totals, log cash pulls, and file taxes. No telemetry? A Google Sheet works.

Essential columns: date, location, SKU, stock, sold, cost, price, cash pulled, notes.

Formulas: (Price - Cost)/Price = Margin %, Sold/Stocked = Sell-through %.

Use the phone app to enter data on-site and create dropdowns and pivot tables.

Barcode scanner apps speed entry. Use color codes:

Red = low margin, Yellow = slow mover, Green = top seller.

Logging, Reconciliation & Trend Tracking

All breadcrumbs go in one hub. Mike logs visits by date, issue, fix, parts, time, and next action. He logs card payouts, cash pulls, rev share, and profit.

Attachments include jam photos, receipts, and signed rev share docs. He backs up weekly to the cloud and runs quarterly trend audits to flag weak machines.

His SLA matrix is clear:

Minor jam = 24 hrs, Cooler/High-value = same day, Full outage = immediate.