What it shows
The forecast projects your bank and cash balance week by week, for 4 to 26 weeks, or month by month for a year. It reads like a spreadsheet: the weeks (or months) run across the top, and down the side:
- Cash at start of each week.
- Money in, one row for each place it comes from: invoices due, repeating invoices, budgeted sales (12-month view), other scheduled amounts and one-offs you add.
- Money out, the same way: bills due, repeating bills, wages, VAT, PAYE and CINSF, budgeted costs, other scheduled amounts and one-offs.
- Total money in, Total money out, Net change and Cash at end. Every total is the sum of the rows above it, and the Total column adds up the weeks.
Beside each row's name, a tag says what its figures are based on:
- Document: invoices and bills you have entered, still to be paid.
- Repeating: a repeating invoice, bill or journal that will be raised.
- Budget: your approved budget, for what is not entered yet (12-month view only).
- Estimate: worked out by Easy, such as wages from your pay runs and VAT from your last return.
- Added here: a one-off you typed on the forecast page.
Select any figure to list the invoices, bills and other movements behind it, under the grid; each opens its document. Select a week's heading to see everything in that week, a row's name for that row in every week, or Total for every movement.
Weeks are calendar weeks, Monday to Sunday, labelled with their Monday. The first is this week: it starts on this week's Monday, but only counts movements from today onwards. The page always says Cash, because it is about when cash moves, whatever reporting basis your workspace uses.
Opening cash is the balance in your accounts across your Bank and Cash accounts today, including any that have been made inactive. It is the same definition the cash-flow statement reconciles to.
The 12-month view
Choose 12 months, by month above the settings to see the year ahead, one calendar month a column, starting with this month (from today). It projects everything the weekly view does and adds your approved whole-business budget for what isn't entered yet, on its own rows: Budgeted sales and Budgeted costs, tagged Budget, so you can always tell planned money from documents already entered.
Where the documents end and the budget takes over:
- Documents you have entered count first: open invoices and bills, payroll, VAT, PAYE and CINSF, exactly as in the weekly view.
- For each month, the budget counts only what is not yet recorded for that month: the budgeted income less the income already in your accounts for it, and the same for costs. It is never below nil, so a month that has already beaten its budget adds nothing more, and nothing is counted twice.
- A recurring invoice or bill due to be raised in a budgeted month is part of what the budget plans, so the budget carries it there. In a month with no approved budget the recurring schedule counts as usual.
- Depreciation is not cash, so it is left out of the budget. When a pay calendar projects payroll, the budget's wages are left out too, because payroll and its PAYE and CINSF are already projected.
- Budget amounts are before VAT; VAT comes from your last filed return, as in the weekly view.
Budgeted income turns into cash after Customers usually pay after (days), and budgeted costs after Suppliers usually paid after (days), spread evenly over the month. Left blank, each is the average payment terms of your active customers or suppliers. The late-payment delays add to them. These two settings stay in the page address but are not saved in a scenario.
A financial year with no approved budget (none, or only a draft) shows only the documents already entered for its months, and the forecast notes say which months. With no approved budget at all, the page says so and links to the budgets.
When each movement is expected
- Customer receipts and supplier payments are placed on each open document's due date.
- Recurring invoices and bills use the customer's or supplier's payment terms, with 14-day and 30-day defaults where none are set.
- VAT and PAYE are estimated from the last filed RM205 return and fall due on the 20th of each month.
- CINSF (the employee and employer contributions withheld by finished pay runs) falls due on the last day of the month after the one the pay date is in. A month that has ended counts what its finished pay runs (those with a pay date in it) owe, shown as CINSF contributions. This month and later months are Estimated CINSF, taken from the latest of the last three months that had CINSF; if none did, they are left out and the forecast says so. Whatever has been recorded as paid for a month comes off it.
- Payroll uses the net pay of each scheduled, unposted pay run where one exists, otherwise the recent average net pay. Two runs on the same pay date are added together. Without a pay calendar, payroll isn't projected and the forecast says so.
What-if assumptions
The settings (Edit report) let you test a different picture, and the assumptions list under the page states whatever you have set:
- Customers pay late (days) moves every customer receipt, including recurring invoices, that many days after its due date.
- Suppliers paid late (days) does the same for supplier payments, including recurring bills.
- Payroll estimate per run replaces the recent average used for pay dates that have no prepared pay run. A prepared run still uses its own net pay.
Each delay can be up to 90 days. A delay can move an overdue item into a future week.
Opening a movement
Select a figure, then an invoice, bill, schedule or return in the list under the grid to open it. The settings stay in the page address, so going back returns to the same forecast. One-off movements you haven't saved as a scenario are not kept, so the page asks before you leave.
Overdue invoices and bills
Invoices and bills already past their due date are expected in the first week (or month), named Overdue in the list behind the figure. If you would rather not count on them, set Overdue invoices and bills to Leave out in the settings: they then appear in no week and the cash never counts them.
One-off movements and scenarios
Under the grid, add your own one-off money in or out, such as owner drawings, a loan or new equipment (plus for money in, minus for money out), then Update forecast. They show on the One-off money in and One-off money out rows. You can save the settings and one-offs as a named scenario and load it later.
A scenario keeps the weeks ahead, the two delays, the payroll estimate and the one-offs. Its Base, Optimistic or Conservative type is a tag to help you tell scenarios apart; it is the settings and one-offs that change the numbers.
Low balance alert
Alert me when the lowest balance is below (the card under the saved scenarios) is off until you type an amount and choose Save alert; blank switches it off. Each morning at 05:30 Easy works out the forecast as the page first opens (13 weeks, no one-offs). While its lowest balance is under your amount, Home's Today and Mail say so, with the amount and the week, and open this page; when a morning finds it back above, the alert goes. Anyone who sees Planning sees the amount; the people who manage Planning change it.
Scenarios side by side
With two or more saved scenarios, tick up to three under the list and choose Compare side by side. Each is worked out against today's books as loading it would. The first column is the cash at the end of each week for the base (a Base scenario when you picked one); the others show how far each differs from it, so (1,200.00) means $1,200 less. Point at a difference to see that scenario's own cash. The last row names each scenario's lowest balance and the week it falls in.
Exporting
Export (Excel) writes the grid on screen, the same rows and columns with what each row is based on, plus a worksheet listing every movement with its week (or month) and row, so each figure can be traced back to its source. The download uses what is on screen, including the settings and one-offs you haven't saved yet.
Health figures on the Planning overview
The strip at the top of the Planning overview shows five figures, each from your accounts as at today. Select one to open the report behind it; hover for its exact basis.
- Gross margin: gross profit (sales less cost of sales) as a share of sales, this financial year to today. It matches the gross profit on the profit and loss.
- Debtor days: what customers owe today, divided by what you invoiced over the last three months, times the days in those months. Roughly how many days customers take to pay.
- Creditor days: the same for suppliers: what you owe them today against what they billed over the last three months.
- Months of cash left: your bank and cash balance divided by the average amount it fell each month over the last three months. When it held or grew, the strip says Not running down.
- Current ratio: bank, cash and other current assets divided by current liabilities. Above 1 means what you own in the short term covers what you owe in the short term.
A figure with nothing to work from (no sales, no invoices or bills in three months, nothing owed) shows a dash rather than a made-up zero.