What the forecast counts, week by week
Open the 13-week cash forecast from the Accounting overview, or type Cash Forecast in the command palette. Anyone who can view accounting can read it. Week 1 starts on this week’s Monday and each column is labelled Wk 1, Wk 2 and so on with its start date. The forecast opens at today’s ledger balance of your cash and bank accounts, the same accounts the cash-flow statement treats as cash, and the summary cards show Opening cash, Expected in, 13 weeks, Expected out, 13 weeks and the Low point with the week it falls in. The chart, Closing cash by week, draws money in and out as bars and closing cash as a line.
Inflows are open customer invoices by their due date, the invoices your active recurring schedules will raise, and recurring journals that bring cash in. Outflows are payable supplier bills by due date; issued purchase orders not yet fully billed, placed at their expected delivery plus that supplier’s usual terms (30 days when there is no bill history to learn from); payroll runs not yet paid, with months that have no run projected from the last regular one; unpaid approved expenses; VAT and withholding owed per the ledger, due on the 20th of the following month; and recurring journals that pay cash out. Anything already overdue lands in week 1, because it is still owed and the earliest it can move is now. Anything expected after week 13 is left out.
In practice: a Nairobi distributor’s controller opens the forecast on a Monday. Opening cash is KES 3.2 million; Wk 6 shows a large Supplier bills figure and closing cash dips to KES 410,000. She clicks that amount, and the panel below lists the documents behind it: two import bills due that week, each with its supplier, due date and a link to the bill. Download CSV gives the same weeks and categories for the board file. Nothing on the page changes a document; it reads what AWRA already holds.
Key takeaways
- The forecast opens at today’s ledger balance of cash and bank accounts and runs thirteen weeks from this Monday.
- Inflows are open and scheduled invoices and cash-in recurring journals; outflows are bills, open purchase orders, payroll, unpaid expenses, VAT and withholding, and cash-out recurring journals.
- Overdue items sit in week 1; items expected after week 13 are left out.
- Click any amount to see the documents behind it; Download CSV exports the grid.