Cash flow forecasting software shows what money will come in and go out over the coming weeks, using your open invoices, bills due and regular costs. For a small business, ask three things: does it read your real books, how often does it update, and can you see the invoices behind each number?
What is a cash flow forecast?
A cash flow forecast is your best guess, week by week, of the money coming in and going out, starting from the cash you hold today.
Profit and cash aren't the same. Picture a bakery that's profitable on paper. A big customer pays late, the flour supplier wants payment on Friday, and wages are due too. That week the till is empty, even though the year looks fine.
Cash flow forecasting software works this out for you. It takes today's balance, adds what you expect in, takes away what you expect out, and shows the running total. The maths is easy. The hard part is where the numbers come from and how fresh they are.
Weekly periods suit most small businesses, because that's the rhythm of wages, supplier runs and customer payments. It's an estimate. Its job is to show direction and tight spots, not the balance to the last cent.
This is a checklist, not financial advice. Decisions about loans, payment terms or investment belong with you and your adviser.
What data does a forecast need?
It needs four things: the cash you hold, what customers owe you, what you owe suppliers, and regular costs that aren't invoiced yet.
Most of it already sits in your accounting system. A bill nobody has entered is a payment the forecast can't see.
Payment dates matter most. An invoice due in thirty days isn't money in on day thirty if that customer always pays two weeks late. Good tools use how customers really pay, taken from your own history, and let you change it for people you know well.
| Data | Where it usually lives | What goes wrong without it |
|---|---|---|
| Opening cash | Bank accounts | Every week after it is off by the same amount |
| Open sales invoices | Accounting system | Money in is too high or too low |
| Expected payment dates | Customer terms and payment history | Money lands in the wrong week |
| Bills due | Accounting system | Payments come as a surprise |
| Regular costs | Wages, rent, loans, subscriptions | The forecast looks better than real life |
| One-off items | Tax, equipment, yearly renewals | A big gap appears without warning |
Software, spreadsheet or a view built for you?
You have three choices: ready-made software, a spreadsheet you look after, or a view built to order on your own books.
Ready-made software connects to your accounts and bank and gives a forecast with what-if options. It suits businesses whose records are already clean. A spreadsheet is free and fits you exactly, but someone has to update it by hand, and it goes stale the day they stop.
The third option is a cash view built around your own accounts and sheets. We build it to order. It isn't running for a client yet. It reads the open invoices and bills already in your accounting system, adds the regular costs you list in a sheet, and shows the running balance, with each number linked to the invoices behind it. It's rented monthly, runs on our servers against your own accounts and changes nothing in your books.
Whatever you pick, ask the same things. How long does it take each week to bring it up to date? When a number looks wrong, can you trace it in a click?
Two related services are also built to order: matching bank lines to invoices, and chasing late payers with reminders ready on time. Our supplier bills service, which keeps what you owe up to date, runs today.
Your eight-week cash position
Enter your cash today and the money you expect in and out each week. The result is your balance at the end of week eight, from your figures only. Look at the weeks in between too, since a balance that ends above zero can still dip below it on the way.
What must a good forecast do?
Before you rely on a forecast, check it against a short list of must-haves.
Use these to judge any option, from a spreadsheet to the biggest software on the market.
- It reads your real books, not a copy someone typed in.
- It updates as often as you make cash decisions.
- You can open any number and see the invoices or bills behind it.
- Payment dates reflect how customers really pay.
- Regular costs and one-off items are on it, not just invoices.
- It shows the lowest point, not only the closing balance.
- It changes nothing in your accounts.
- You can take your data with you if you stop using it.
How do you keep it accurate, and use it?
A forecast is only as good as the records behind it, and it only helps if someone acts on it.
This is where most forecasts fail. The software is fine, but the books are behind. Bills sit in a mailbox for weeks, so the forecast shows more cash than there is. Payments that arrived aren't matched, so it still expects money you already have. That's why accounts receivable automation and bill entry belong to forecasting, not on the side.
Say a plumber's forecast shows a tight week in three weeks. There's time to call the slow-paying customer, move a van repair, and ask the supplier for a later date. A forecast earns its keep by giving you that time.
Chasing is the most common action. Credit control software and automated payment reminders help, but the wording matters, because a badly timed note can upset a good customer. Every step starts with your approval, then you choose which reminders can go out on their own.
A short weekly routine keeps the numbers honest.
- Enter every new supplier bill.
- Raise every sales invoice that's due.
- Match the week's bank receipts and payments to invoices and bills.
- Update the expected dates for customers who are running late.
- Add any new regular cost or one-off item you know is coming.
- Compare last week's forecast with what really happened, and note why it differed.
Questions
What is cash flow forecasting software?
Software that shows the money coming in and going out over the coming weeks or months, using open invoices, bills due and regular costs, so shortfalls show before they happen.
Can I forecast cash in a spreadsheet?
Yes, if someone updates it every week from current records. The risk is that it goes stale, and typed figures drift away from the real books.
How far ahead should I forecast?
Many small businesses look a few weeks ahead week by week, and further out month by month. It depends on your payment cycles, so check with your adviser.
What's the difference between a forecast and a budget?
A budget says what you plan to earn and spend. A cash forecast shows when money actually arrives and leaves, which decides whether you can pay on time.
Do payment reminders help cash flow?
They can, if they're accurate and well timed. Reminders prepared from a current list avoid chasing invoices that are already paid.
Tell us your workflow. We will build it around you.
Tell us how you forecast cash today and how long it takes each month. Write to hello@thenewaiemployee.com and we'll say plainly whether a view built on your own books fits.
Talk to us Related service: Bank and receivables


