Cash Flow Forecast Template for Contractors
For plumbers, electricians, HVAC and other trades balancing job deposits, van costs and parts on account.
Cash lines a contractor & trades forecast needs
These are the receipts and payments we build into the Contractor & Trades template. Use them as a checklist even if you build your own.
Cash in
- Job payments
- Deposits
- Service contracts
- Emergency call-outs
- Financing partner payouts
Cash out
- Parts and materials
- Technician payroll
- Vehicle costs and fuel
- Tools and equipment
- Insurance and licensing
- Marketing and lead fees
- Supplier accounts
Trades businesses are paid job by job but pay for vans, tools, parts and technicians every week. A plumber, electrician or HVAC contractor can be fully booked and still short of cash if parts are bought on account, customers pay on completion and a slow season follows a busy one.
Why trades cash flow is different
- Parts before payment. Materials are bought from suppliers on account or by card before the job is finished and invoiced.
- Mixed customers. Homeowners pay on the day; commercial clients and property managers pay on 30-day terms or later.
- Seasonal demand. Heating engineers are busiest in winter, air conditioning in summer, and emergency call-outs spike in cold snaps.
- Vans and tools. Vehicle finance, fuel, insurance and tool replacement are steady costs that don’t fall when work does.
- Lead costs. Paying for leads or advertising means spending before the job is won.
A worked example
A four-technician HVAC business takes about $68,000 a month. Parts and materials run at 32 percent of job revenue.
| Month | Revenue | Parts | Payroll | Vans, insurance, other | Net |
|---|---|---|---|---|---|
| July | 78,000 | 25,000 | 23,100 | 17,500 | 12,400 |
| April | 64,600 | 20,700 | 23,100 | 17,500 | 3,300 |
The shoulder season still covers costs, but only just. If a van needs replacing in April, the business needs cash saved from July. A forecast makes that saving a plan, not luck.
How to build a trades cash forecast
- Forecast job revenue by month from last year’s pattern and your booked work.
- Split cash customers from account customers and apply their real payment delay.
- Tie parts and materials to job revenue as a percentage.
- Add technician payroll, vans, fuel, insurance, licences and marketing.
- Include service contract income as steady monthly receipts.
- Keep a buffer for vehicle repairs and the slow season.
The how to make a cash flow forecast guide walks through each step in detail.
Common mistakes
Charging deposits but spending them before the job starts. Forgetting supplier account statements that all fall due on the same day. And hiring a new technician in the busy season without checking the quiet months that follow.
What the template gives you
The Contractor & Trades template includes a Job Costs tab that ties parts and materials to job revenue, so costs follow your busy and quiet months automatically. Deposits, service contracts and emergency call-outs have their own lines, and scenarios show what a mild winter or a lost commercial contract would do to cash.
Key assumptions built into the Contractor & Trades template
- The Job Costs tab calculates parts and materials at 32% of job payments and emergency call-outs. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
- 5 cash in lines and 7 cash out lines are already named for contractor & trades businesses, and every one can be renamed or extended.
- The example figures follow a typical contractor & trades year, busiest in July and August and quietest in October and November, so the tight months show up where they usually fall.
Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.
Free or premium?
If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Contractor & Trades template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.
Contractor & Trades cash flow forecasting: questions
How should a trades business handle deposits in a cash flow forecast?
Record deposits in the week they are received, and the matching parts cost in the week you pay for them. Don’t spend deposits on unrelated bills before the job’s materials are covered.
What cash buffer does a contractor need?
Aim for at least one month of payroll, van finance and insurance. Seasonal trades should save more from the busy season.
Are service contracts good for cash flow?
Yes. Maintenance and service agreements bring in steady monthly income that smooths out seasonal swings in call-out work.