Forecast my cash week by week
Here you see your cash for the coming weeks, computed from the book.
How to
- Pick the horizon in the list at the top of the page (« 13 weeks (book) » by default).
- Set your threshold: « ⋯ », then « Threshold and settings ».
- Spot the « Low point » tile and the « Below threshold » weeks.
- Click an amount in the « By week » tab for its detail.
- Click « What if »: late customers, moved payment, one-off.
- Click « Export », as CSV or Excel.
Learn more
The forecast starts from today's cash and adds, week by week, what the ledger expects: nothing to enter again. It rolls on its own: every Monday, the closed week moves to actuals and a new week appears at the end of the horizon. Scenarios (« What if ») change no data.
Read the forecast
The tiles show « Cash today », « Low point » (the lowest end-of-week balance and its date), « Receipts, 13 wks » and « Payments, 13 wks » (the number follows the chosen horizon). The curve shows the actuals of closed weeks, the forecast as a dashed line and the alert threshold. « By week » tab: click an amount to see the items behind it (invoice, bill, run, entry) and open them. The « incl. estimated » column opens the estimate basis.
Where the amounts come from
Cash today: class 5 accounts of posted entries, except items to cash (51) and discounting (565). Customers and suppliers: the unlettered items of accounts 41 and 40, at their due date, net of partial payments. An invoice entered or synced counts once, through its entry. A supplier invoice placed in a payment run is paid on the run date. Bills receivable in portfolio or at the bank, accepted bills payable: at their due date. VAT: the 443 / 445 balance on your country's payment day. Payroll: net salaries of approved runs, payroll charges due, and the following months estimated from the last run. Recurring: each upcoming occurrence. A customer item overdue more than 90 days is left out (listed in « Assumptions »).
The estimate
So the forecast does not fall to zero after the known due dates, each week gets an estimate: the weekly average of cash movements with no invoice (cash sales, bank fees, expenses paid directly) over the last 3 months. Movements forecast elsewhere (customers, suppliers, bills, VAT, payroll, recurring) are left out of it. « See the basis movements » lists the entries used.
Choose the horizon
The forecast covers 13 weeks by default. The list at the top of the page offers 4, 8, 13, 26 or 52 weeks: your choice is kept for this book on this device, and « (book) » marks the book's horizon. The book administrator sets the book's horizon in « ⋯ » > « Threshold and settings » > « Forecast horizon » (4 to 52 weeks; empty, the book follows the organization). An organization administrator also sets the « Organization default horizon » there, used by all its books without their own. The Monday e-mail alert and the dashboard use the book's horizon. The forecast stays weekly. Each change is written to the audit log.
Alert threshold and low point
« ⋯ » menu > « Threshold and settings » (book admin): « Minimum cash (alert threshold) », « Estimate basis » (last 3 to 6 months) and the delay after which a receivable is left out. Weeks under the threshold show « Below threshold » and the lowest one « Low point »; with no threshold, the alert is below zero. « E-mail me on a low point » sends an e-mail on Monday when a low point is forecast, to you only; turn it off in the same menu.
Run a scenario
« What if » opens the scenario: « Customers pay late » shifts customer receipts by N days; in a week's detail, « Exclude » or « Move » a payment; « One-off » adds a receipt or a payment on a date. The curve and tiles show the scenario against the base. « Reset » goes back to the base. Nothing is saved.
Actual and forecast, reliability
Each week, the forecast is set aside. « Actual and forecast » tab: for each of the last 8 closed weeks, what was received and paid (class 5 movements) against what was forecast the week before, and the variance. Reliability sums up these variances as a percentage. With Procura, « Include committed orders » (« ⋯ » menu) adds purchase orders not yet invoiced.
Frequently asked questions
It may be a draft (not in the ledger yet), already lettered with its payment, overdue more than 90 days (« Assumptions » > « Receivables left out ») or due after the last week of the horizon.
A source (for example bills or payroll) could not be read: the forecast shows the rest and names the missing source. Reload the page; if the message stays, contact support.