Free Service Business Financial Model for Hourly Billing
The Service Business financial model is a free Excel download that turns hours billed and hourly rate into a five-year monthly forecast. It builds your income statement, balance sheet and cash flow from one Assumptions tab.
How does a service business financial model work?
A service business model multiplies customers by hours billed by your hourly rate. Everything else sits on top of that line.
The file runs 60 months on three tabs: Overview, Assumptions and Financials. You type into Assumptions. The Financials tab builds an income statement, a balance sheet and a statement of cash flows from what you typed.
Here is how the revenue chain runs.
| Step | Input in the file | What it means |
|---|---|---|
| 1 | Web traffic and conversion rate | Visitors who become enquiries, then customers |
| 2 | Ten acquisition channels | Switch on only the ones you actually use |
| 3 | Sales cycle | Delay between a lead and a paying customer |
| 4 | Average monthly hours billed per customer | Hours each customer buys in a month |
| 5 | Average hourly rate | What you charge for one hour |
| 6 | Average days receivable | Gap between invoicing and cash |
Revenue is customers, times hours, times rate. Get any one of the three wrong and the rest of the model inherits the error.
Which acquisition channels should you switch on?
Fill in the channels you have already used, and leave the rest at zero. Paid ads take a budget and a cost per click. The others take volumes, such as affiliates, partnerships, email and content.
Many service firms live on referrals and direct selling. A forecast that leans on paid ads you have never run is a guess, and a reader will treat it as one.
What is the difference between billable hours and paid hours?
Billable hours are the ones a client pays for. Paid hours are everything you pay staff for, including admin, training, sales and idle time.
The people plan holds 25 rows of staff and salaries. The hours-billed input lives separately. So the model will not stop you from forecasting more billed hours than your staff can work. You have to check that yourself.
The common mistake is assuming everyone bills every paid hour. No team does. Partners sell and manage. Juniors wait for work. Set billed hours below paid hours, and be ready to say why.
Why does your cash lag behind your revenue?
You invoice for work this month and get paid later. The Average days receivable input moves that gap into the cash flow statement.
At 30 days receivable, a month of work lands as cash a month later. At 60 days, two months later. Growth makes it worse, because each new month adds work you have done but not yet been paid for.
A service business can show profit on the income statement and still run out of cash. The balance sheet shows where the money is stuck, in receivables. Many founders ignore this line. A lender does not.
What will a lender or investor question first?
They will start with the hourly rate and the hours, because those two inputs drive every pound or dollar of revenue.
Expect questions like these:
- Where does your rate come from? Past invoices persuade. A hopeful figure does not.
- Why would customers buy that many hours each month?
- How many staff does it take to deliver those hours, and when do you hire them?
- How long do clients really take to pay?
A lender reads the cash flow to see whether the business can service debt. Our guide to what SBA lenders look for in a business plan sets out how that reading goes.
How do you fill it in?
Start with the numbers you can prove, then forecast outward.
- Enter your real hourly rate from recent invoices.
- Enter hours billed per customer from your time records.
- Build the people plan with real salaries and start dates.
- Set days receivable from your actual payment history.
- Switch on acquisition channels one at a time.
- Add starting cash, fixed assets and any equity rounds.
Placeholders in the file stand in for your figures until you type them.
Want a second pair of eyes? Our team will check your model on a free 30-minute consultation.
Where does the forecast go next?
Put the finished model behind a written plan. Our guide to business plan financial projections shows how the numbers sit inside the plan a reader receives.
Prefer to see a finished example? The consulting, advertising and marketing sample plans and the cleaning, repairs and maintenance sample plans show how service firms present their projections. Sample plan figures are fictional. Treat them as layout examples, never as targets.
If your revenue comes from fixed-fee projects, use the contract revenue model instead.
Sample business plans that fit this model
These are 6 of 100 sample plans for businesses that earn money the way this model does. Every sample plan is a fictional example, so use it for structure, not for figures.
- Accountancy Business Plan
- Business Consulting Business Plan
- Consulting Planning Business Plan
- Game Console Repair Shop Business Plan
- Internet Media Advertising Business Plan
- Marketing Strategy Business Plan
Browse more: Accounting, Insurance & Compliance business plans · Consulting, Advertising & Marketing business plans · Cleaning, Repairs & Maintenance business plans · Technology business plans
Service Business financial model: common questions
Can I use this service business financial model for a consulting firm?
Yes. Consulting, accounting, cleaning, repair and similar firms earn revenue from hours billed times an hourly rate, which is exactly how this file calculates it. If you charge fixed-fee projects instead, the contract revenue model fits better.
Does the template model billable utilisation?
Not as a single percentage. You set average monthly hours billed per customer and a 25-row people plan, so you can check that billed hours fit the paid staff hours behind them.
Does it work in Google Sheets?
Google Sheets can import the .xlsx through File > Import. Check the formulas once it is in.
Are the numbers in the file benchmarks?
No. Each figure is a placeholder so the formulas have something to calculate. Put in your own before the model goes to anyone.