A busy sales month can still leave you wondering whether there will be enough cash for the next payroll, supplier payment or equipment bill.
A weekly cash flow forecast organizes that question around timing. It sets out the cash you expect to receive and pay, week by week, so you can identify questions before the payment date arrives.
The forecast is a working estimate. Its value comes from using realistic inputs and updating them when circumstances change.
Start with a clear purpose
Choose the period you need to understand. For a first version, you might map the next six weeks and extend it as the routine becomes useful.
Write down what the forecast should help you see. Perhaps several customer payments are expected around the same time as a large supplier bill. Perhaps seasonal purchasing is about to increase. A specific question makes it easier to decide which details matter.
A forecast looks ahead. A statement of cash flows reports what happened during a past period. Profit is another measure: the SEC’s guide to financial statements explains that income statements describe earnings, while cash-flow statements describe cash moving in and out.
Use the forecast alongside your financial reports, with help from your bookkeeper or CPA when the relationship between them is unclear.
1. Establish the starting cash position
Pick a start date and identify the business cash accounts included in the forecast.
Check the opening amount with your bookkeeping records and current account activity. Make outstanding payments and other known commitments visible, and be consistent about whether they are reflected in the opening figure or listed as future outflows.
If some money is restricted or set aside for a particular obligation, show that separately. Ask your accountant how to present it appropriately for your business.
Write down the accounts included. This helps prevent a transfer between your own accounts from being counted as new money available to the business.
2. List expected cash receipts by week
Start with existing customer invoices and known payment arrangements. Use the week you reasonably expect collection rather than automatically placing every invoice in its due-date week.
For each significant receipt, note:
-
The customer or source
-
The expected amount
-
The expected payment week
-
What supports that expectation
-
Whether someone needs to confirm the timing
Keep uncertain new sales distinct from invoices already issued. A possible project and a payment confirmed by a customer carry different uncertainty.
Where several customers pay through a processor, use a consistent approach to fees and settlement timing. Your bookkeeper can help avoid counting both the underlying payments and the eventual bank deposit.
3. Map cash payments to the week they will leave
Gather the amounts and dates for payroll, rent, supplier bills, subscriptions, financing payments and other known commitments.
Include irregular payments that may be absent from an ordinary weekly spending pattern. Annual insurance, inventory orders and equipment purchases can matter even when recent weeks looked quiet.
Use actual payment schedules and advice from the responsible professional for tax or financing obligations. Do not estimate legal deadlines from a generic article.
Mark payments that still need a quote, approval or confirmed amount. An empty cell can be mistaken for zero; an explicit estimate makes the uncertainty visible.
4. Calculate the weekly ending balance
For each week, start with opening cash, add expected receipts and subtract expected payments. Carry the ending amount into the next week.
Here is a fictional example:
-
Opening cash: $12,000
-
Expected receipts: $8,000
-
Expected payments: $11,500
-
Forecast ending cash: $8,500
If $4,000 of those expected receipts moves into the following week, the first week ends at $4,500 instead. The total sale has not changed; the timing has.
These figures illustrate the calculation only. They are not a recommended cash reserve, spending level or target for your business.
5. Test the assumptions that matter most
Ask which changes would materially affect the picture.
What happens if a large customer pays a week later? What if an order requires a deposit earlier than expected? What if a planned expense has not been approved?
Keep the main forecast based on your current expectations. Then make a clearly labeled alternative scenario for the uncertainty you want to examine. Avoid changing several assumptions at once without documenting them.
The purpose is to understand the dependency. You can then ask the relevant customer, supplier or adviser a more focused question.
6. Replace estimates with actuals every week
Set a regular review time and compare the completed week with what you expected.
Record the reason for meaningful differences. A delayed customer payment needs a different response from an expense that was left out entirely.
Update the coming weeks and add another week at the end. Assign each open question to someone who can answer it.
Keep the previous forecast long enough to understand how the assumptions changed. Quietly overwriting every number makes it harder to learn which estimates need improvement.
Use the forecast to support a conversation
A cash forecast is useful when it leads to clear questions and timely decisions. It cannot guarantee that customers will pay or that costs will stay fixed.
AMX provides financial reporting and forecasting and budgeting and planning. We can discuss the records, reporting and review process needed to build a forecast around the way your business operates.
Schedule a free consultation to talk through the cash-flow questions you want your reports to answer.