Cash Flow Forecast for a Service Business

Photo source

A week of booked visits can look healthy while the bank balance is heading towards a difficult Friday. A booking states that work is planned. An invoice records what a customer owes. Neither tells you when the money will be available to cover an outgoing payment. Cash can be short even when work is profitable if the receipts and bills fall in the wrong order.

That timing problem is the reason to make a cash flow forecast. It is a dated view of cash expected into and out of the business, with a running balance. For a mobile operator, it joins the diary to the payment record and the costs of doing the visits. The gap between delivering a job and receiving payment is especially important when supplies, travel or other commitments must be paid first.

This guide builds a small manual forecast. It does not assume a particular accounting method, recommend a borrowing product or claim that Offlico calculates a forecast for you. The useful question is simple: after each known payment date, how much cash is left?

Choose a starting date and record the business cash available at that point. If you use more than one account for operating money, be clear which balances you include. Do not add a booked fee or an unpaid invoice to the opening balance. The difference between an annual budget and bank timing is the entire point of this exercise.

Set one column for each coming week if the next few payment dates matter, or use months if the business is less exposed to a short gap. Put the opening balance at the top, then money expected in, money expected out and the closing balance. A template with historical actuals and opening and closing balances is useful for the layout, even if you keep your own sheet much smaller.

For irregular appointment work, separate what is confirmed from what is only hoped for. The freelancer planner separates confirmed and expected income. That is a useful discipline for a home visit diary too: a repeat client who has not booked yet may be a reasonable scenario, but is not a committed receipt.

Photo source

For each confirmed visit, write down the service amount, the planned visit date, how payment is normally requested and the date cash is realistically expected to reach the business. A card payment taken after a visit, a bank transfer due after an invoice and a deposit taken at booking belong on different lines if their cash dates differ. Do not treat all three as money arriving on the appointment day.

If an invoice is already overdue, place the amount on a cautious expected date rather than quietly leaving it on the old due date. The self employed late payment guide sets out several ordinary reasons an invoice can stall, including late sending or a missed message. The cash forecast need not settle a dispute; it needs to expose the timing risk.

Keep the payment follow up separate from the forecast line. A clear invoice, a contact record and a timely reminder can help resolve what is owed. Practical late payment steps for small businesses cover the follow up process. In the forecast, revise the expected receipt when you learn more, then link back to the invoice or booking so you can see why it changed.

Do not fill an empty future week with a sales target and call it cash. Show unconfirmed work in a second scenario or note. That makes the baseline useful for decisions you must make before a customer has booked. To check which earlier jobs were actually paid, use the client payment tracker guide as a separate recordkeeping task.

Photo source

List costs in the period when the bank will pay them. For appointment work this might include materials bought before a job, fuel or other travel spending, wages if you employ people, subscriptions, rent, loan repayments and known tax payments. Use the actual bill or your normal payment date where possible. Do not insert a tax figure you have not checked.

Regular costs can stay due even if the diary is quiet. A seasonal business example of fixed costs continuing after busy trading makes the mismatch clear; the exact months and sector in that example are not assumed for your business. The cash flow impact of quieter periods and cautious scenarios is useful when a service business sees weather, school term or holiday swings.

Distinguish a receipt for a past purchase from a future outgoing. In a hypothetical case, a £60 supply bill already paid is reflected in the opening bank position, assuming the balance is taken after the payment cleared. It is not another £60 due next week. A supplier invoice not yet paid belongs on its expected payment date. That single check prevents an easy double count.

Keep the categories simple enough to maintain. If an amount is uncertain, mark the assumption and the person or document you will check. A forecast with a few honest unknowns is more useful than a detailed sheet that silently treats estimates as facts.

Here is a wholly hypothetical example for an appointment led operator. It is arithmetic to show the method, not a real business, average result or recommended cash reserve. Assume £500 is in the operating account at the start. Payments and costs below are placed in the week the cash is expected to move.

The calculation is opening cash plus receipts minus payments. In week two, £250 of expected receipts arrives before £700 of costs, so the forecast closes at £150. The figure is not profit. It is the amount the example expects to remain after that week’s cash movements. Opening and closing balance columns in a cash flow template make the carry forward visible.

Now suppose that week two £250 receipt slips into week three. The revised week two view is £600 opening cash, no receipt and £700 out: a £100 shortfall. Week three may still end at £400 once the delayed amount arrives, but that later recovery does not pay the earlier bill. The focus on the timing of bank inflows and outflows is what makes the gap visible.

If the gap were real, the next step would be to check the receipt date, the outgoing commitment and available options before making a promise or purchase. Do not treat the hypothetical negative balance as permission to use an overdraft. It is an early warning that the plan needs attention.

A forecast is not a prediction. Write down the assumption behind each less certain receipt: customer confirmation, invoice due date, past payment pattern or a conversation about the date. Then make one cautious version. Move a late paying invoice, reduce unconfirmed work to zero and leave the known costs where they are.

This is not pessimism for its own sake. Late customer payments can strain the money available for other commitments, while the small business payment discussion on cash passing through a supply chain shows why a delay does not stop with one invoice. Neither source justifies applying an industry statistic to your own customers. Use your own payment records for the dates.

If your work genuinely has busy and quiet periods, test a version in which fewer visits happen while the fixed costs continue. Scenario planning across a seasonal cycle can be adapted to a smaller diary without making a complicated annual model. Label the extra view “cautious”, not “confirmed”, so it cannot be mistaken for money already earned.

The useful output is the lowest projected cash point and the assumption causing it. A precise looking year end total matters less if next week is where the risk sits.

Choose a short repeatable review slot. Start by matching the opening balance to the bank, mark which expected receipts actually arrived, mark which payments left and move any remaining entries to the right dates. Keep the old estimate available so the reason for a change is visible. A rolling week by week cash forecast is designed to be updated, not filed away after one calculation.

If a visit moves, move its expected receipt and any cost that genuinely moves with it. If a customer pays early, enter the actual receipt date. If a payment is disputed, do not keep it in the certain column just because it is on an invoice. The forecast to actual review habit helps keep a useful model tied to what the bank is doing.

Look for repeated errors in your assumptions. Does one client routinely pay later than the agreed date? Do supplies leave the account earlier than the job income arrives? Those are reasons to revise the next forecast, not to rewrite history. A step by step small business forecasting guide is a further check on timing assumptions, but your own records should settle your actual dates.

If records are scattered, start with a small sheet and three source lists: confirmed bookings, unpaid invoices and known outgoings. The forecast should remain simple enough that you will update it after a busy day, not only when the balance becomes uncomfortable.

Read the forecast from left to right and circle the first period where the closing cash looks too low for commitments already made. Check the two or three entries that drive that low point. A late invoice may need follow up. A purchase may need a more careful date. A booking that is only tentative should not finance a certain bill.

Keep the decision separate from the forecast. The numbers help you see when action is needed; they do not prove that a particular loan, payment term or tax treatment is right. If the forecast shows a persistent shortfall or a commitment you cannot meet, speak to a qualified adviser and the relevant creditor early.

Offlico offers booking, invoicing and bookkeeping tools that can help organise some of the records feeding this exercise. The cash flow forecast described here is a separate manual calculation. Keep that distinction clear when deciding what to track in the product and what to maintain in your own forecast.