Your finances don't need more willpower

My cashflow forecast spreadsheet gets opened and reconciled every week. That is my secret weapon for managing money.
Not opened when I feel brave. Not glanced at when there's a worrying email from the bank. Opened and reconciled weekly, so that the forecast is brought back into line with what has actually happened.
This was taught to me by two multi-millionaires. They understood something my bank manager and accountant hadn't been able to explain: HOW to manage money in a small business.
When I asked my bank manager and accountant about it, they didn't know how to help with that practical, day-to-day job. They were employees of big companies with accounting teams and bookkeepers. Their salaries arrived monthly and reliably.
Small-business income doesn't necessarily have those good manners.
I'm talking about those two advisers and that conversation, not declaring that accountants and bank managers are no use. But being able to prepare accounts or assess a business plan isn't the same as showing someone how to manage the money coming in and going out of their own business.
In my book 'The Money Gym', I wrote about trying just about every accounting package under the sun. A couple worked for a while, but none produced what I needed.
A see-at-a-glance, easy to update, weekly statement of what was actually happening in my bank account.
Most were just too complicated.
My answer wasn't to become a more disciplined person. It was to make the job simpler.
In the same chapter, I explained that I don't really believe in self-discipline. I believe in having something you want to achieve, breaking it down into manageable goals, and setting things up so that doing the useful thing is easier.
For money, that means a simple system you actually use. Mine centres on that weekly reconciliation.
Stop making it a character assessment
"I'm just not good with money."
It's a very final-sounding statement. Almost a diagnosis. It can also get you out of opening the spreadsheet.
What does it actually mean? That you don't understand the report? That the figures are out of date? That you don't know which money is available to spend? Or that you're afraid the answer will be unpleasant?
Those are different problems. None is helped by deciding you're a fundamentally defective entrepreneur.
You can learn what a number means. You can get the records brought up to date. You can ask your accountant which amounts need setting aside. And you can look at an uncomfortable figure without turning it into a verdict on your entire working life.
The aim is to find out what needs doing. Self-reproach is optional, and doesn't pay particularly well.
Give the numbers a smaller job
In 'The Money Gym', I described using a simple spreadsheet to track a bank account and feed into a cash flow forecast. The point was to see potential problems early enough to do something about them.
That isn't an instruction to abandon your accounting software. Your records still need to do the legal accounting job your business requires.
But let your book-keeper handle that (and in fact your own weekly cashflow forecast will provide the numbers your book-keeper needs. You may even save some money here!)
The simple spreadsheet tool you use to make everyday decisions should answer the questions you actually have.
For a start: what money is available, what has to go out, and when?
A bank balance on its own doesn't answer all of that. Some of the money may already be needed for a supplier, a tax bill or work you've been paid for but haven't delivered yet.
Equally, an invoice you've sent isn't money in the bank. If your plan depends on it being paid on Friday, it matters whether Friday is an agreed payment date or simply a date you're rather fond of.
You don't need to stare at every figure every time. You need a clear enough picture to make the next decision.
Open it. Reconcile it. Every week.
A forecast isn't something you produce once, admire briefly and leave in a folder. It needs to meet reality regularly. In my case, weekly.
Reconciliation means checking the spreadsheet against the bank transactions, accounting for what actually came in and went out, and making sure the balances agree. If they don't, find out why. Don't simply change a figure until the spreadsheet looks more cheerful.
Then update the forecast ahead. A customer has paid late. A bill is larger than expected. Something you thought would arrive next week now won't. Those changes need to show up in the weeks ahead, not sit in your head while the spreadsheet carries on telling a more comforting story.
That's the difference between looking at the numbers and using them.
Put the weekly appointment in your diary. Have the bank transactions, unpaid invoices and upcoming bills ready in one place. If you have a bookkeeper, agree who updates what and what you need from them before you sit down.
Work through the same questions:
- Have I recorded the money that actually came in and went out, and do the balances agree?
- Which expected payments have moved, changed or not happened?
- What does that change in the forecast for the coming weeks?
- What do I need to do about it now?
If a future figure is an estimate, mark it as an estimate. A tidy-looking guess is still a guess.
Finish by deciding what to do. Send the overdue invoice reminder. Check the bill you don't recognise. Ask about the tax payment you haven't allowed for. If the revised forecast shows a shortfall, deal with it rather than hoping next week's sales will be in a generous mood.
The secret isn't owning a spreadsheet. It's opening it, reconciling it and acting on what it tells you. Every week.
Don't confuse a better system with another purchase
There is a tempting stage in any awkward task where shopping for the solution feels remarkably like solving it.
Perhaps you do need better software. But before you sign up, write down the job it must do.
"Show me what's due in and out over the next few weeks" is a job. "Make me feel like a proper business owner" is a fairly expensive brief to give an app.
If you already have a tool, find out whether it can give you the simple view you need. If you need help setting it up, ask for that specific help. Don't build a second set of records just because the first set feels intimidating.
And if the routine keeps failing, look at the point where it breaks. Is the information missing? Are there too many steps? Does the appointment clash with something that always wins?
Change that part. You don't have to rebuild the entire system every time you miss a Thursday.
Looking won't fix everything. Not looking fixes nothing.
A simple routine won't turn an unprofitable offer into a profitable one. It won't make a late-paying customer suddenly considerate. And if you can't meet your commitments, you need proper help with the situation, not a more attractive spreadsheet.
What it can do is give you a chance to respond before the problem gets bigger.
That might mean changing payment terms, reducing a cost, revisiting a price or having a conversation you've been putting off. Tax, debt and accounting decisions need advice suited to your business, not a rule borrowed from somebody else's.
Knowing the position doesn't mean you'll enjoy it. It does mean you can stop trying to make decisions in the dark.
So before you promise yourself that, from Monday, you'll be wonderfully disciplined with money, try a smaller promise.
Put the weekly reconciliation in your diary. Open the cashflow forecast, check it against what actually happened, then update what comes next.
You don't have to become someone who loves doing the accounts.
You do need a way of knowing what's going on.
Photo by Jakub Żerdzicki on Unsplash
