Help

Cashflow Forecast Analyzer  |  How to read your forecast and keep it right

← Back to your forecast
Start here

Reading your forecast in two minutes

1. The coloured bar at the top. It answers one question: does the money last? It names the lowest balance the bank is projected to reach in the next 12 months and the day, or the first day it is projected to reach a warning level you set. If no income is in the forecast yet, it says so instead, because a line with nothing coming in can only fall.

2. The low point on the chart. In the Balance outlook, the solid line is what the bank balance actually was and the dashed line is where it is projected to go. It counts only payments and deposits that repeat on a schedule, plus anything entered under Expected. Day to day spending and deposits that vary too much to predict are not in it. Drag across the chart to read the balance on any day.

3. The week it gets tight. Find that week on the Payment calendar and click a day. You will see every payment and deposit forecast for that day, so you can see what is causing the dip and whether anything could move.

Most boxes under the coloured bar show a typical week or month: the middle of what has happened. Where a box shows quiet and strong beside it, those are a slow and a busy week. A box marked expected is what has been entered, not measured. None of it is a promise, and it is money in and out, not profit: owner draws, loan payments and sales tax collected all move it.

Your own alarm

Choosing a warning level

The warning level is the lowest balance you are comfortable with. A good starting point is the cost of one payroll, or one month of fixed bills. Enter it under the Balance outlook.

Once it is set, the coloured bar tells you the first day the balance is projected to fall to it, which is usually more useful than the lowest point, because it is the last day you can still do something about it.

With more than one bank account, each account can have its own level, and so can All accounts. A business can look comfortable in total while the account the bills come out of does not.

Trust

Why a figure differs from your bank today

The forecast is only as current as the books. The top of the page says Includes transactions up to a date. Anything after that date is not in it yet. The most common reasons a figure does not match the bank:

What the bank cannot know

Adding money and bills you expect

The forecast learns from what repeats in past bank transactions. It cannot know about a new customer, an unpaid invoice, a grant, a yearly insurance renewal or a tax instalment until someone adds it. Those go in Expected income and Expected costs, on a bank account's own tab, with the date you expect the money to move. A cost paid by credit card is not taken from the bank on that date. It reaches the bank inside the card payment.

Each payment stays in the forecast, even after its date has passed, until someone clicks In the bank for income or Paid for a cost. Nothing leaves the forecast just because its date went by. A repeating entry carries on after that; only that one payment is closed off.

Do not add a payment or deposit that already repeats on a schedule in the bank, such as rent, payroll or a monthly retainer. The tool has already counted it, and adding it again counts it twice.

Found for you

Costs the tool found in the bank

Bank account fixed costs are payments found repeating on a steady schedule: rent, payroll, loan payments, subscriptions. Each is projected forward at the amount it has been running.

A cost that has not appeared for a while is flagged may have stopped and left out of the balance until it turns up again.

Cards

Credit cards

A card purchase does not leave the bank when you make it. The card payment does. So card spending reaches the bank forecast only as the payment to the card.

Where the bank already shows regular payments to a card, those are what the forecast uses, at the amounts they have been running. Where it does not, add the card payment under Expected costs, or that card's spending is missing from the bank forecast.

Each card's own tab shows its spending: what repeats on a schedule, what comes up often but not on a schedule, and what happened once.

Planning

Trying a what-if

A scenario is your changes laid over the real forecast. Anything updated on the forecast shows in the scenario too, and the scenario never changes the forecast. Use New scenario at the top of the page, give it a name, then add a cost or income, or change or take out something already in the forecast. The coloured bar, the Balance outlook and the Payment calendar then show the scenario, with its low point set beside the real forecast's.

Switch between the forecast and your scenarios from the Viewing menu at the top. You can keep up to five. The real forecast is never changed by a scenario.

Good ones to try: losing your biggest customer, hiring someone, a rent increase, or paying down a loan faster.

Questions

The assistant

Where it has been switched on for your business, you can ask the assistant questions about your figures in plain words, such as “why does the balance dip in March?”. It answers from the same figures on the page.

It can suggest a change, such as adding an expected cost, but it never makes one: you confirm every change yourself. It is switched on for a business only after that business has agreed to it. See the Terms & Privacy Policy for how your data is handled.

Glossary

Words we use

Balance outlook
The chart of where the bank balance has been and where it is projected to go over the next 12 months.
Typical, quiet, strong
Typical is the middle week or month: half were higher, half lower. Quiet is the point a quarter of weeks or months fell below. Strong is the point a quarter rose above. On spending, the same two figures are called light and heavy.
Expected
Something someone has entered, rather than something the tool measured from the bank.
Projected
Where the forecast expects a figure to be, based on what repeats and what has been entered. Not a promise.
Warning level
The lowest balance you are comfortable with. The coloured bar names the first day the balance is projected to reach it.
Scenario
A set of what-if changes laid over the real forecast, without touching it.
All accounts
Every bank account in the tool, added together. Each account also has its own tab.

Still stuck? Contact info@balancemybooks.ca.