13-Week Cash Forecast
See cash today and what open invoices, bills, orders, payroll and taxes will move, week by week for the next 13 weeks, and compare it with named what-if scenarios.
The forecast is for owners and finance staff who need to know when cash runs low. It is built from records already in your books. Nothing is typed in by hand except scenarios and two settings.
Permissions
- Viewing the forecast, its CSV and the mobile screen needs the View accounting permission.
- Creating, editing and deleting scenarios, and saving the forecast defaults, needs Manage cash forecast. Without it the page is read-only.
- In the drill-down, a document links to its record only if you may open that record.
How The Weeks Work
- Week 1 starts on this week’s Monday. The forecast always covers 13 weeks; the horizon cannot be changed.
- Opening cash is the ledger balance of your cash and bank accounts today.
- A document whose expected date has passed, such as an overdue invoice, lands in week 1. A document expected after week 13 is left out.
- Figures show one currency at a time, your base currency by default. Amounts in other currencies are never converted or added in. Pick another currency to see the bank accounts held in it; with none, that forecast opens at zero.
What Feeds It
- Customer invoices — open balances by due date.
- Scheduled invoices — invoices your active recurring invoice schedules will raise, at the amount of the last invoice the schedule raised, or its lines before tax.
- Supplier bills — payable bills, and bills awaiting approval, by due date.
- Open purchase orders — the part not yet billed, at the expected delivery date plus the supplier’s usual terms learned from its bills (30 days when it has none).
- Payroll — unpaid runs on the last day of their month, with statutory deductions on the 9th of the month after. Months with no run repeat the last regular run.
- Unpaid expenses — approved expenses not yet paid.
- VAT and withholding — what the ledger owes, due on the 20th of the month after it arose.
- Recurring journals — active recurring journals that move a cash account, on each run date.
Projected items carry an Estimate tag. The page lists these assumptions under How the forecast is built.
Set It Up (Web)
- Open Accounting → 13-week cash forecast.
- Under How the forecast is built, set a Low-cash threshold. The page warns when a week closes below it. Leave it blank to warn only when cash goes negative.
- Tick Shift receipts by each customer’s payment history to move expected receipts by each customer’s average days late over the last year. A customer needs at least two paid invoices for this.
- Select Save defaults.
The filter bar can override both for one view: Receipt dates (Shift by payment history or Due dates as written) and Low-cash threshold.
Read The Forecast (Web)
- The cards show opening cash, expected in and out over 13 weeks, and the low point.
- The chart shows each week’s money in and out as bars, closing cash as a line, and the threshold as a dashed line.
- The table has one row per category. Select an amount to see the documents behind it, with the expected date and the basis for each.
- Select Download CSV for the weekly table and the document list, including the scenario shown.
Scenarios
A scenario is a named what-if shown beside the base forecast. It never changes the invoices, bills or orders.
- Select New scenario. Give it a Name and, if you like, a Description.
- Add adjustments: Move receipts by N days, Collect only part of receipts (%), Delay supplier payments by N days, One-off inflow or One-off outflow. Pick one customer or supplier, or leave it as all. Negative days bring a date forward.
- Select Save scenario. The forecast opens with the scenario beside the base, plus Base closing and Scenario less base rows.
- Pick another scenario from the Scenario filter, or edit and delete it from the Scenarios card.
In The App
- Open Cash Forecast from the Accounting hub. It shows opening cash, week 13, a bar chart of closing cash with weeks under the threshold in red, and a low-cash warning.
- Tap a week to see its documents. Tap a document to open it on the web.
- Choose a scenario from the pills, then switch between Base and Scenario. Change the currency if you hold more than one.
- The app is read-only. Scenarios and settings are created and edited on the web.
Common Issues
- No New scenario button: you lack the Manage cash forecast permission.
- An invoice is missing: it is due after week 13, or it is in another currency. Switch the currency.
- A one-off amount has no effect: its currency differs from the currency you are viewing.
- Opening cash looks wrong: it is the ledger balance of cash and bank accounts. Check Bank Reconciliation.
- A document in the drill-down has no link: you may not open that kind of record.
Need help with this topic?
Capture the module, record number, branch or warehouse, user, visible message, and what you expected to happen before contacting support.