An operations platform, built in-house
- 24,000+invoices searchable, back to 2018
- 18,000+customer profiles
- $11kâ$14ka year in temp labor eliminated
- <3 wksfrom first code to live
I built a company-owned operations platform around the way the business already worked. Office staff open it in a browser on the shop network: nothing installed, no monthly bill, and the company keeps its own copy of every record.
It holds more than 24,000 invoices going back to 2018 and over 18,000 customer profiles, with dispatch routing, purchase orders, and an invoice builder. The install crew kept scheduling in their own Google Sheet. The platform mirrors that sheet every 20 minutes and links each job to its invoice, reading five years of layout changes along the way.
Payment reports never matched billing, and the cause turned out to be one field. The shop software writes “Amount Paid” once and never updates it, while staff record the real payments in their notes. A reader now turns those notes into payment records, and they add up to the billed total on 99% of 2025 invoices.
The invoice builder’s pricing and tax rules were worked out from the archive, then checked by replaying 300 real invoices to the cent. A bot cleared a backlog of roughly 2,500 invoices into QuickBooks Online and took over the pushing that had been costing $11,000–$14,000 a year in temp labor.
Buying the same pieces as subscriptions would have run $3,000–$10,000 a year. First code to live took under three weeks.