How to Build a 13-Week Cash Flow Forecast and Get Paid on Time

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a week-by-week list of the money that will arrive in and leave your bank accounts over the next quarter. Each week has an opening balance, receipts, payments and a closing balance, and the closing balance of one week becomes the opening balance of the next. It came from turnaround and restructuring work, where lenders needed to know whether a business would survive the next three months, and it has since become a standard tool for any company that wants to see trouble coming.

Thirteen weeks is a quarter. It is long enough to cover a full cycle of payroll, monthly suppliers, quarterly tax payments and most customers' payment patterns, and short enough to be accurate. A monthly forecast hides the dips that matter: a month can balance on paper while payroll, rent and a loan repayment all leave in the same four days, a fortnight before the receipts that cover them.

This is different from profit. The profit and loss account records revenue when work is done, not when it is paid for, and leaves out loan repayments, capital spending and the owner's drawings. A company can be profitable and still be unable to pay its staff on Friday.

Why do profitable companies run out of cash?

Because cash hides in three places the profit line does not show: money owed by customers, money tied up in stock or work in progress, and payments that never appear as costs, such as loan principal and equipment. Together they make up the cash conversion cycle, the number of days between paying for the work and being paid for it.

Late payment makes this worse, and it is normal rather than exceptional. Atradius, the trade credit insurer, reported in its May 2026 Payment Practices Barometer for Western Europe that nearly four in five companies faced late payments from business customers, and that trade credit financed 52 percent of business-to-business transactions. Xero's Small Business Insights for the December 2025 quarter, published in March 2026, put the average time small businesses were paid after the due date at 8.0 days in the United Kingdom, 7.8 in the United States and 6.6 in Australia.

Buffers are thin. A 2016 study by the JPMorgan Chase Institute of 597,000 small businesses found the median firm held enough cash to cover 27 days of outflows if no money came in. One large customer paying a month late can use most of that.

How do you set up the forecast, step by step?

You can build a workable first version in about an hour if your books are reasonably up to date. Use a spreadsheet with weeks across the top or down the side, and follow these steps in order.

• Pick week 1: the coming Monday. Write the start and end date of all thirteen weeks.
• Opening balance: the cleared balance across all bank accounts that morning, less payments you have issued that have not cleared. Not the figure in your accounting software.
• Set a floor: the balance at which you will act. A common starting point is one net payroll plus the largest regular tax payment, less receipts that reliably arrive in the same week.
• Receipts: every open invoice placed in the week you expect the cash, then retainers and contracted milestones, then likely new work with a confidence rating.
• Payments: payroll, statutory deductions and tax, rent, loan instalments, software, suppliers, planned capital spending and owner drawings, each in the week it leaves the bank.
• Calculate: net movement and closing balance for each week, the headroom over the floor and a flag for any week below it.
• Check it: compare three months of bank statements with your payments list and add anything recurring you missed.

How do you forecast receipts accurately?

Receipts are the hard half, because they depend on other people. The common mistake is to place each invoice on its due date. Instead, measure how many days after the due date your customers actually pay, using the last six months of paid invoices, and add that to each due date. If a customer has promised a date, use the promise. If an invoice is disputed, keep it on a separate line with a low confidence until the dispute is settled.

Retainers go in the week the money arrives, not the week you invoice. Some customers pay on a fixed run day; place them there. For project work, put each milestone payment at the milestone date plus terms plus typical lateness. For the pipeline, ask sales for the customer, the week the cash would land if everything went to plan, and a confidence out of ten, then move the week one later. Show a probability-weighted total beside the full one so you can see how much of the forecast is hope.

What should you do when a week drops below the floor?

Pull levers in a sensible order: receipts first, because they also strengthen the next quarter; payments second, because they only buy time; financing last, because it costs money and attention. Write each lever, its expected effect and its week on a worksheet, so the next forecast shows whether it worked.

How do you keep the forecast accurate week after week?

Hold a 30-minute cash meeting every Monday with the owner, whoever runs finance and whoever owns the key customer relationships. Type last week's actual receipts, payments and closing bank balance. For any variance over about ten percent, record one main reason (customer paid late, invoice raised late, dispute, unplanned payment, tax timing) and one lesson, then change the assumption that caused it. Roll the window forward a week, add the new week 13, and agree actions for any week below the floor.

Add a simple downside case by multiplying receipts by, say, 0.85 and payments by 1.05, and look at the lowest week. If the downside dips below zero, open a conversation with your bank now, with the forecast in hand, rather than when you are already short.

Measure three things monthly: days sales outstanding (DSO) against the best possible DSO if nothing were overdue, the overdue share of receivables, and how close the receipts forecast came to reality. When the first two fall and the third improves, the routine is working.

What does a good collections process look like?

The forecast tells you when cash should arrive; collections makes it happen. Treat collections as a dated sequence, the same for every customer, that asks one question in gradually firmer ways: what date will this be paid? Start before the due date with a friendly check that the invoice is in the customer's system, and log every contact and every promise with its date and amount.

Most delays begin with the invoice itself: no purchase order number, a due date written as 'net 30', a description the customer's accounts payable team cannot match, or a portal upload that failed. Fix the template once and many 'late payers' become on-time payers. Decide credit before the work starts, using references and a written limit, so you are not lending to customers who were never likely to pay.

• Log every promise with a date and amount and follow up the day after
• Treat disputes as a separate problem with an owner and a target date, and ask for the undisputed part
• Keep payment plans short, take a deposit and put them in writing

Can you charge interest on late payments?

It depends on the country and your contract. In the United Kingdom, for example, the government's guidance says businesses can claim statutory interest on late commercial payments at 8 percent plus the Bank of England base rate, unless the contract sets a different rate. The European Union's Late Payment Directive (2011/7/EU) sets a framework for payment periods and late payment interest across member states. In March 2026 the UK government published its response to a consultation on late payment, setting out plans including a 60-day maximum payment term between businesses, subject to legislation.

Elsewhere, interest is often a matter of contract and local law, and some countries protect small suppliers with specific rules. Rules change, so treat interest as a lever you check before you use it: read your contract, check the current official guidance for the customer's country, and ask your accountant or a qualified adviser. A wrong claim weakens a strong case.

Where does AI help with cash flow forecasting and collections?

AI assistants such as ChatGPT, Gemini, Claude, Copilot or your company's approved tool are useful for the grinding parts of the job: grouping a bank export into recurring payments, spotting that one customer explains most of your receipts variances, drafting a reminder in the right tone, preparing for a difficult call and drafting the monthly report narrative from your numbers. Remove bank details and personal data first, and label customers rather than naming them unless your tool is approved for confidential data.

Keep decisions with people. Escalating a debt, charging interest, suspending supply, setting a credit limit, agreeing a payment plan or writing off a balance are judgements about a relationship and the law, and a model does not know your contract, your customer or this month's rules. Check every number against your workbook and every legal statement against an official source.

If you want the whole routine ready to use, the Cash Flow Forecast and Collections Kit from Bodhih Training includes a 13-week forecast and collections workbook, a credit and payment plan calculator, a meeting form, a script and letter library and a prompt pack built around the steps in this guide.