Note No. 1
Your overdraft is a forecast you never wrote down.
ACash and the bank
Your bank set the limit from last year’s accounts. Thirteen weeks of figures, written down every Monday, will tell you whether it fits next quarter.
Guy Thomas Evans4 minutes
If your business has an overdraft, you probably think of it as a safety net. It’s closer to a guess. When the bank agreed your limit, it was making a forecast about your business: how far the balance would dip, and how often. It made that forecast from your last accounts, which were months old by then.1
You make the same forecast every morning when you check the bank balance. You just never write it down.
Writing it down takes an hour the first time and fifteen minutes a week after that. Take a sheet with thirteen columns, one for each of the next thirteen weeks. In the top row, put the cash you’ll start each week with. Under it, list what will come in, customer by customer, in the week you expect it to arrive.2 Then list what goes out: wages, the VAT quarter, PAYE on the 22nd,3 rent, and the suppliers you have to pay to keep working. The bottom row is where each week ends.
Draw a line across the sheet at your overdraft limit. Any week that ends below it is a conversation to have with your bank now, while it’s still a forecast.
Do this for a month and three things happen.
First, the shortfall stops being a surprise. In the specimen,4 a fabricator with £850,000 of sales and a healthy order book comes within £5,000 of its overdraft limit in the first week of January, because the Christmas shutdown, the VAT quarter and a slow-paying customer land in the same fortnight. Seen in November, that’s a calm phone call to the bank. Seen in January, it’s a hurried one.
Second, late payers get a date. Once a customer’s money has a week on the sheet, chasing it becomes a job with a deadline.
Third, the bank’s questions get easier, because you’ve already asked them yourself.
None of this needs software. A spreadsheet will do, and so will a sheet of A4. What matters is that you write it down on Monday and check it on Friday. Each week you find out how good your guesses were, and they get better.
If you’d like this built into your own accounts, so it refreshes itself every Monday at 7am, that’s a Build. If you’d like to know first whether you need one, that’s what the Business Survey is for.