Thirteen Weeks Ahead: Finding a Cash Shortfall Before It Becomes a Crisis

The order is profitable. The bank account can still run dry.

A manufacturer pays for material and wages before the customer settles. A consultancy records completed work while the invoice remains outstanding. A retailer has money tied up in slow stock when rent and tax fall due. None of those businesses can pay a Friday bill with profit that exists only in the accounts.

That timing difference is why a short-horizon, rolling cash-flow forecast is useful. Thirteen weeks—approximately one quarter—is a common management horizon because it is long enough to show payroll, rent, tax, loan and supplier cycles while remaining close enough for weekly estimates to be tested. It is a management convention, not a statutory format. A business can use eight, twelve or sixteen weeks if that better matches its trading cycle.

What official guidance supports

Australia's official business portal advises businesses to forecast incoming cash using prior periods, seasonal trends and regular income sources, and to forecast outgoing cash from the costs and timing required to operate. It also distinguishes a budget from a forecast: a budget sets the intended plan, while a forecast uses current financial information and recent trends to estimate what is now likely to happen.

That distinction is central. A forecast should change when a customer pays late, sales weaken, a shipment is delayed or a supplier alters its terms. Copying an annual budget into weekly columns can produce a neat spreadsheet without producing useful information.

Build it from the bank balance, not the sales target

Begin week one with the reconciled cash that is genuinely available. Keep restricted deposits, undrawn credit and money held for others separate unless the business can legally and practically use them. Then list expected receipts by the week in which payment is likely to clear—not merely the invoice due date.

Receipts may include cash sales, card settlements, customer invoices, deposits, grants, tax refunds and confirmed loan drawdowns. Separate committed receipts from uncertain opportunities. A signed order from a reliable customer is not the same as an enquiry, and even a valid invoice may arrive later than its contractual date. Where uncertainty is material, prepare a base case and a downside case instead of hiding optimism inside one number.

Record the full payment calendar

For each week, list payroll, supplier payments, rent, utilities, insurance, loan principal and interest, taxes, software subscriptions, freight, advertising, owner drawings and planned capital purchases. Include annual or quarterly bills when their payment dates fall inside the horizon. A forecast that excludes tax because it is calculated elsewhere can overstate the cash available to the owner.

Currency also matters. An exporter billing in US dollars but paying wages in local currency should forecast both the expected receipt date and a reasonable converted amount. An importer should identify foreign-currency purchase commitments and bank charges. This is not a prediction of exchange rates; it is recognition that settlement value may differ from the original estimate.

Use a simple weekly calculation

For every week, calculate opening cash plus expected receipts minus expected payments to reach closing cash. The following week's opening cash must equal the prior week's closing cash. Add a separate minimum-cash threshold reflecting the amount management believes is necessary for normal operations. When forecast cash falls below that threshold, the spreadsheet should flag the week and the cause.

Do not add the full value of an overdraft or credit facility to opening cash. Show available borrowing separately, together with its limit, interest, fees, covenants, expiry and any conditions for drawing it. A facility can provide liquidity, but it is not sales income and may not always be available on the assumptions originally expected.

Update actuals every week

A rolling forecast works because it learns. At the end of each week, replace estimates with actual bank receipts and payments, reconcile the balance, investigate significant differences and add a new week at the far end. Record the reason for major variances: customer delay, lower volume, price change, duplicate estimate, unplanned repair or timing error.

Over several cycles, those notes reveal where judgement is consistently weak. If invoices forecast for 30 days usually arrive after 45, the collection assumption should change. If card settlements take two business days, the forecast should not treat a weekend sale as immediately available cash. Accuracy improves through disciplined comparison, not through adding more spreadsheet colours.

Make late-payment control part of forecasting

The UK's Small Business Commissioner advises checking agreed payment terms, due dates and invoice errors when an invoice remains unpaid. Its guidance for new businesses recommends considering credit checks for new customers, upfront or staged payments for larger projects, submitting invoices through the agreed channel and contacting the customer promptly after a payment becomes overdue.

These are commercial controls, not substitutes for a healthy customer relationship. A clear quote should state the price, deposit, milestone, delivery and payment terms before work begins. The invoice should use the correct legal entity, purchase-order reference, tax details and payment instructions. The forecast owner should know who approves the invoice and when the customer's payment run occurs.

Turn a forecast gap into decisions

When the model shows a shortage, first verify the data. Then evaluate actions in operational order: correct and issue invoices, collect deposits or milestone payments, follow up overdue accounts, slow non-essential purchases, renegotiate supplier timing, adjust stock orders, reduce owner drawings or postpone capital spending. Financing may be appropriate, but it should address a defined timing or investment need rather than conceal an unprofitable model.

Australia's business portal advises loan applicants to understand income, expenses, debts and cash flow, and to use a forecast to estimate future sales and costs. It says this information helps determine how much funding is needed and what repayment the business can afford. A lender will normally require more than a spreadsheet, but a forecast linked to bank statements, receivables, payables and realistic assumptions gives management a clearer basis for the discussion.

Keep profit, cash and tax separate

The profit-and-loss statement records income and expenses under the applicable accounting basis. The cash forecast tracks bank timing. A tax computation follows the rules of the relevant country. These reports connect, but they are not interchangeable. Singapore's tax authority, for example, requires companies to keep records and file specified corporate returns; it notes that good record keeping helps businesses understand their financial position and prepare accurate filings.

A business operating across the United States, United Kingdom, Canada, Australia, Singapore or any other market should place its actual payroll and tax deadlines into the forecast using the responsible authority's current rules. Tax dates, instalment options and indirect-tax treatment vary by entity, turnover, jurisdiction and accounting method. General articles cannot replace local accounting or tax advice.

A useful weekly review takes questions, not just numbers

Management should ask which receipts are supported by issued invoices, which customers have changed behaviour, which payments are compulsory, what assumptions moved, and when the lowest cash point occurs. It should also examine concentration: if one customer supplies most expected cash, a delay from that customer should be visible in a downside scenario.

The aim is not to predict every bank movement perfectly. It is to identify the weeks in which choices become constrained while there is still time to respond. A maintained 13-week forecast turns bookkeeping records into an operating conversation—one that connects sales, purchasing, stock, staffing, tax and finance before a shortage becomes an emergency.