What it shows
Insights → Cash flow starts from the cash and bank balances in your books today and walks the next 13 weeks: what is likely to come in (sales, with a likely range; money customers owe) and what has to go out (supplier invoices on their due date, everyday costs at their recent average, salaries at month end, the reorders Insights suggested). Each week ends with a closing balance; the lowest point is named at the top, with what to do about it.
A warning in orange means a week may go below zero. Chase what is owed, ask a supplier for a few more days, or dismiss a suggested reorder on the Replenish screen to take it out of the first week.
Where each line comes from
Sales expected: the same forecasting as the item forecast, on all your sales together; the range shows how far it was off in the last four weeks. Owed to you: the Customer accounts balances, the overdue part expected in the second week and the rest in weeks three and four. Supplier invoices due: the open invoices under Finance → Payables, each on its due date. Everyday costs: the average of the last three months of expenses in your books, salaries apart, spread over the weeks. Salaries: the average monthly payroll, in the week of each month end. Suggested reorders: the pending suggestions on the Replenish screen, counted in the first week.
How it is worked out, under the table, says which method was used and on how many days of history.
When the figures update
Every night with the rest of Insights. Refresh now on the Insights overview recomputes them during the day, for example after you posted supplier invoices.
More in this area
- Insights: how suggestions work and the Overview
- Reading the demand forecast
- What to reorder: Replenish and draft purchase orders
- Stock health: dead stock, slow movers and markdowns
- Prices: price and margin suggestions
- Loss prevention: unusual voids, refunds, discounts and cash shortages
- Baskets: items bought together and "Also bought" on the till
- The daily digest
- Food cost and your menu