Know if you're making money, and if the bank balance will cover the slow season, before it arrives.
Plan the year month by month with busy and slow seasons, then type in what really happened as each month closes. You see gross profit, overhead and net profit, plus the cash that leaves without being an expense: loan payments, equipment, tax set-aside.
The Dashboard shows plan vs actual year to date, how many months of costs you have in the bank, your lowest projected balance, and a plan vs actual bank balance chart.
What's included:
Monthly Profit & Cash Flow Tracker (.xlsx) with an example year
BLANK copy, ready for your numbers
Dashboard with plan vs actual and a bank balance chart
2-page quick-start guide (PDF)
Instant download (.zip)
Works in Google Sheets and Excel 2010+. No macros, no add-ons, no subscription
Formulas locked so they can't be typed over; light copper cells are yours to fill in
Built for small trade businesses: electrical, plumbing, HVAC, roofing, landscaping, painting, cleaning, handyman, pest control, general contracting. Rename the job types, crews and items to fit yours. Example data is made up. This is an organizing tool, not accounting, payroll, tax or legal advice.
Want the prices your numbers need? The Flat-Rate Pricing Calculator works out your real hourly rate and flat-rate prices. Or get all 5 spreadsheets in the Trade Business Spreadsheet 5-Pack for $49.



