Fractional CFO, cash flow
Cash Flow Forecasting for a Service Business: How to Build One and What Goes In It
For owners of service and trade businesses who want to see a tight month coming, not find it in the bank balance.
A cash flow forecast for a service business starts with today's cleared bank balance, adds the money expected in by the date it should clear in the bank, and takes away the money going out by the date it leaves. Each week or month ends with an expected balance, so a short month shows up early enough to act on. At Right Way Profits, Debbie DeKnight builds the forecast and the plan as part of her fractional CFO service for founder-led service and trade businesses across the US.
Last updated
What is a cash flow forecast?
A list of the cash you expect in and the cash you expect out, period by period, with an expected bank balance at the end of each one.
It answers one question: will there be enough money in the account when each bill comes due? That is a different question from whether the business made a profit, which is why an owner can have a good month on paper and still feel short.
Debbie's own list of the signs includes this one: "Cash feels tight even in a good month." A forecast is how you see that month before you are in it.
How is a forecast different from a profit and loss statement?
The profit and loss statement looks back at income and expenses. The forecast looks ahead at money in the bank.
| Profit and loss statement | Cash flow forecast | |
|---|---|---|
| Looks at | A period that has already happened | The weeks or months ahead |
| Counts a job | As income for the period the work belongs to (on accrual books) | When the customer's payment is expected to clear in the bank |
| Equipment or a truck bought outright and recorded as an asset | Recorded on the balance sheet as an asset, not as an expense | Counted in full in the period the money leaves |
| The principal part of a loan payment | Not an expense | Counted, because the cash still leaves |
| Answers | Did we make money? | Will the money be there when the bills are due? |
A large purchase recorded as an asset, such as equipment bought outright, uses cash in the period it is paid without appearing as an expense on the P&L. The cash leaves, and the profit figure does not show it. The page on being profitable on paper and broke in the bank walks through the rest of that gap.
How do you build a cash flow forecast for a service business?
In five steps, using the books as the starting point.
- Start with today's cleared bank balance. Add up the cleared balances of all the business accounts, reserve accounts included. Then list each payment or deposit that has not cleared yet, such as a check you wrote or a customer check not yet in the bank, once, on the date you expect it to clear. Do not list it again as an invoice, a bill, payroll, a loan payment, a tax payment or any other line. Internal transfers and Profit First reserve moves, including transfer checks that have not cleared, count as neither money in nor money out. Timing is the one thing they change, because a transfer can leave one account before it lands in the other. For a transfer you plan inside the forecast, take it off the balance on the date it leaves and add it back on the date it lands. For one started before today, check each account's cleared balance. If the money has already left the sending account but not reached the other, only add it to the receiving account on the date it lands. If it has not left the sending account yet, take it off on the date it leaves and add it back on the date it lands.
- List the money coming in, by when it will clear. Unpaid invoices go in the period you expect the payment to clear in the bank, not the day you sent the invoice. Add deposits or prepayments you still expect to receive, and work you have booked but not yet billed. Add confirmed loan proceeds or money the owner puts in, each once, on the date it is expected to clear. The materials and subcontractor costs that booked work will bring go on the money-out side in step 3. Enter each deposit and each remaining payment on its own expected date, so no job is counted twice. Money already in the bank stays in the starting balance only. For later weeks or months, add an estimate of cash from work not booked yet, based on your sales history, seasonal pattern and how long customers usually take to pay. Label those lines as estimates, put the materials and subcontractor costs those jobs will bring on the materials line in step 3, and replace both with real amounts as jobs are confirmed.
- List the money going out, by when it leaves. Every payment goes in on the date it is expected to leave the bank. For payroll, that can be before payday if a payroll provider debits the account in advance. Then list rent, loan payments, supplier and materials bills, insurance, tax payments (with each due date noted beside it) and any owner draws. Enter each materials or subcontractor cost once. An open bill goes in on the date you expect the payment to leave the bank, which is not always its due date. Costs not billed yet, including the rest of a partly billed job, go in on the dates you expect to pay them. For later weeks or months, add the estimated costs of expected new work, including any extra paid hours or overtime it will need on the payroll line. Swap an estimate for the real bill when it arrives. Moves between your own accounts stay out, as in step 1. Before each payroll, check the available balance of the account that pays it, not just the total, as in step 4.
- Work out the ending balance. Starting balance, plus money in, minus money out, with transfers timed as in step 1. That ending balance is the starting balance for the next period. If you keep money in more than one account, such as a reserve or a tax account, the projected cleared balance that matters for each bill is the one in the account that pays it, not the total. To project it, run the same steps for that account on its own: its cleared balance, the money from customers and other sources that lands in it, and the payments that leave it. A transfer still ahead is taken off the account it leaves on the date it leaves and added only to the account it lands in on the date it lands, and that is its only entry. A transfer already out of an account's cleared balance today is not taken off that account again; it is only added to the account it lands in, on the date it lands. If you run Profit First, that is what you expect in the account that pays the bill after the planned allocations, usually Operating Expenses for operating bills, the Tax account for a tax payment and the Owner's Pay account for an owner draw. Money still in Income waits for the next allocation day, and the Profit account is set aside. A projected cleared balance can still show enough while the bank holds back a pending debit or part of a deposit, so before any dated payment, also check the available balance the bank shows for the paying account, and whether it already reflects any part of that payment, and confirm when any deposit or transfer you are counting on will be available. If the available balance falls short of the amount still to come out, move the funds in before the payment leaves the account, and before any earlier funding cutoff your payroll provider sets. Reschedule only a bill whose terms allow it or whose payee agrees to a new date. Confirm payroll funding dates with your provider and tax deposit deadlines with your accountant.
- Compare it with what happened, and update it. At the end of each period, put the real figures next to the forecast, find out why they differ, and roll the forecast forward.
The fifth step is the one that makes it useful. A forecast built once and left alone goes stale quickly, because customers pay late, jobs move and bills change.
What does a forecast look like?
A few rows and a column for each period. This is an illustration with made-up figures, not a client's numbers.
| Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
| Starting balance | $40,000 | $52,000 | $21,000 | $29,000 |
| Customer payments in | $30,000 | $12,000 | $26,000 | $14,000 |
| Payroll out | $0 | $28,000 | $0 | $28,000 |
| Materials, rent, loan and other bills out | $18,000 | $15,000 | $18,000 | $12,000 |
| Ending balance | $52,000 | $21,000 | $29,000 | $3,000 |
In this illustration the first three weeks end with cash to spare, and week 4 ends at $3,000 after the second payroll and all the listed money in and out. Weekly totals can also hide a dip inside a week. In a tight week, list each payment by the date you expect it to clear and keep a running balance: in week 4, if payroll and the other bills cleared before the $14,000 of customer payments landed, the balance would dip to minus $11,000 before ending at $3,000. Seen in week 1, that is a choice: chase the slowest invoices, move a supplier payment, or hold back a purchase. Seen in week 4, it is a scramble.
What should a service business put in its forecast?
Every payment that moves the bank balance, not just the ones on the profit and loss statement.
| Line | Why it matters | Where the number comes from |
|---|---|---|
| Customer payments | Finished work is not cash until the customer pays | The list of unpaid invoices, the remaining payments on booked work not invoiced yet, how long customers usually take to pay and how long payments take to clear, each payment counted once |
| Deposits and prepayments still to come | Money you expect for work not yet done, if the business takes it | Booked jobs and signed agreements |
| Payroll | On the dates the money is expected to leave the account; a payroll provider may debit it before payday | The payroll provider's funding schedule |
| Materials and supplier bills | Due on the supplier's terms, whatever the customer does | Open bills on the date payment is expected to leave the bank, plus costs not billed yet (including the rest of a partly billed job) and the estimated costs of expected new work, each cost entered once |
| Loan payments | The full payment leaves the bank, interest included; the principal part does not appear as an expense | The loan schedule |
| Large purchases | A truck or equipment bought outright takes the cash in one period | Planned purchases |
| Tax payments | Due on set dates, and easy to miss in a busy month. Note each due date, enter the payment once on the date it is expected to leave the bank, and check that the account that pays it will have enough available funds before that date | Your accountant's estimate of what is due and when |
| Expected new work | Cash in only, from jobs not booked yet, labeled as an estimate. Their materials and subcontractor costs go on the materials line, and any extra paid hours or overtime on the payroll line, once | Your sales history, seasonal pattern and typical time to pay |
| Other money in | Confirmed loan proceeds or money the owner puts in also change the balance | Loan paperwork and your own plan, on the expected dates |
| Owner draws | Planned draws or distributions leave the bank like any bill | What you plan to take, and when. If your salary runs through payroll, count it there once |
Should you forecast weekly or monthly?
It depends on how tight cash is and how your payments fall.
- Weekly suits the weeks ahead, when the question is whether payroll and other dated bills are covered. Whenever you check whether payroll or another dated bill is covered, keep a running balance by clearing date too.
- Monthly suits the year, when the question is whether the business can afford a hire, a price change or a large purchase.
Some owners keep both.
How does Profit First fit with a forecast?
They do different jobs, and they work together.
In Mike Michalowicz's Profit First method, customer payments land in an Income account and is divided into separate bank accounts on set allocation days, with the percentages applied to what he calls Real Revenue: income after materials and subcontractors, without subtracting your own employees' wages. His own example of the days is the 10th and the 25th, in 5 Easy Ways to Start Profit First. That organizes the cash you have. A forecast looks ahead at the cash you will have. Debbie describes the link in her own words: "Profit First keeps the cash organized underneath it, and clean bookkeeping keeps the whole thing accurate." The Profit First page covers the method.
When is it time to get help with a forecast?
When big decisions are being made on gut feel and the bank balance.
Debbie names the pattern on her fractional CFO page: owners making the biggest calls in the business, "what to charge, who to hire, what to buy", on gut feel and the bank balance. Other signs she lists:
- You are not sure you can afford the next hire, so you guess.
- Cash feels tight even in a good month.
- You are growing, but you are not keeping more.
A forecast is only as reliable as the books under it, which is why clean books come before any CFO advice. If yours are behind, a rough forecast can still be built from the cleared bank balance, open invoices and scheduled payments, but get the books current with bookkeeping before you make big decisions on it. The comparison of a bookkeeper, an accountant and a fractional CFO explains who does which job.
How does Right Way Profits help with cash flow forecasting?
As part of its fractional CFO work. In Debbie's words: "As your Fractional CFO, I give you a clear read on where you stand, build the forecast and the plan, and meet with you on a steady rhythm so you're always running the business on real numbers."
- What she publishes about the service: a clear, forward-looking view of your cash and your numbers; a plan you run the business on, updated as you grow; straight answers on pricing, hiring and big purchases before you commit; and someone who catches problems early, while they are still cheap to fix.
- The levels: three published levels, Foundation, Growth and Scale, set out on the fractional CFO page.
- Pricing: fractional CFO pricing is set on the call.
- Not on her site: how far ahead the forecast she builds runs, the format of the forecast, or which software she builds it in. The table on this page is a general illustration. Ask on the call.
Debbie DeKnight leads Right Way Profits and is a Master Certified Profit First Professional. The Profit First Professionals podcast page about her says she brings over 30 years of accounting experience and calls her a Profit First Master certified coach. For what clients say, read the client testimonials.
Frequently asked questions
What is a cash flow forecast?
A list of the cash you expect to come into the business and go out of it, period by period, starting from today's cleared bank balance. Checks and deposits that have not cleared yet go in once each, on the date they are expected to clear, and moves between your own accounts are not money in or money out. A transfer can leave one account before it lands in the other, even within the same week. For one you plan inside the forecast, take it off the balance on the date it leaves and add it back on the date it lands. If it had already left when you took today's balance, only add it back on the date it lands. Each period ends with an expected bank balance, so a tight week or month shows up before it arrives.
How is a cash flow forecast different from a profit and loss statement?
A profit and loss statement shows income and expenses for a period that has already happened. A cash flow forecast looks ahead and puts each receipt and payment on the date you expect it to clear or leave the bank. Some payments, such as equipment bought outright and recorded on the balance sheet as an asset, or the principal part of a loan payment, take cash without showing up as an expense on the profit and loss statement.
Should a service business forecast weekly or monthly?
It depends on how tight cash is and how the payments fall. A weekly view, with a running balance by the date each payment is expected to clear, shows whether payroll and other dated bills are covered in the weeks ahead. A monthly view helps with longer-range planning, such as weighing a hire or a large purchase. Some owners keep both.
Do I need clean books before I can forecast cash?
Not to start a rough one. You can build a first draft from the cleared bank balance, open invoices and scheduled payments while the books are caught up, mark the uncertain items, and update it once the books are reconciled. Current, reconciled books are what make the forecast reliable enough to decide on. Right Way Profits also offers bookkeeping as a separate service.
How does Profit First fit with a cash flow forecast?
They do different jobs. In Mike Michalowicz's method, customer payments land in an Income account and is divided into separate bank accounts on set allocation days, with the percentages applied to what he calls Real Revenue: income after materials and subcontractors, without subtracting your own employees' wages. A forecast looks ahead at what will come in and go out. Debbie DeKnight puts it this way: "Profit First keeps the cash organized underneath it, and clean bookkeeping keeps the whole thing accurate."
Can Right Way Profits build my cash flow forecast?
Yes, as part of fractional CFO work. Debbie DeKnight, who leads Right Way Profits, describes that work as building the forecast and the plan. The firm serves founder-led service and trade businesses across the US. Fractional CFO pricing is set on the call. The discovery call is 45 minutes, by web conference, and at the end you will know whether Debbie can help.
Want to see a tight month before it arrives?
Book a 45-minute discovery call. At the end you will know whether Debbie can help.
Keep going
Where to next
- All services
- Fractional CFO
- Profit First
- Bookkeeping
- The Profit Revolution course
- Bookkeeper vs accountant vs fractional CFO
- Profitable on paper, broke in the bank
- How working together works
- How to choose a fractional CFO
- Certified Profit First Professionals, explained
- Fractional CFO for $1M to $3M businesses
- Fractional CFO for $3M to $15M businesses
- Fractional CFO for home service businesses
- Fractional CFO for HVAC companies
- Fractional CFO for plumbing companies
- Remote bookkeeping with a monthly close
- Profit First for contractors
- Profit First for HVAC and plumbing companies
- Podcast interviews with Debbie
- Blog
- About Debbie DeKnight
- Client testimonials
- Contact