BusinessPlanHub

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.

Download the free model Book a free consultation

Free · Excel (.xlsx) · Imports into Google Sheets

Download the service business financial model

Pick this if clients pay for your time at an hourly rate.

We use your email to send you the model and offer a free consultation. No spam.

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.

StepInput in the fileWhat it means
1Web traffic and conversion rateVisitors who become enquiries, then customers
2Ten acquisition channelsSwitch on only the ones you actually use
3Sales cycleDelay between a lead and a paying customer
4Average monthly hours billed per customerHours each customer buys in a month
5Average hourly rateWhat you charge for one hour
6Average days receivableGap 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.

  1. Enter your real hourly rate from recent invoices.
  2. Enter hours billed per customer from your time records.
  3. Build the people plan with real salaries and start dates.
  4. Set days receivable from your actual payment history.
  5. Switch on acquisition channels one at a time.
  6. 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.

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.