A Cash Flow Forecast a Small Business Actually Uses

Four numbers before you touch a chart

Before any line or gauge, I put four numbers across the top, big enough to read from across the room. Cash on hand, which is the real money sitting in the accounts right now, not what is owed to you and not what you hope lands next week. Monthly profit, income minus what it actually cost to earn it, so a busy month that quietly lost money cannot hide behind a big sales figure. Net worth, everything you own minus everything you owe, the one number that tells you whether this year moved you forward at all. And debt left, with the months to zero sitting right under it, because a balance means very little until you know how long it will sit on your shoulders.

Four tiles, and that is the whole top of the screen. I have watched people build a beautiful dashboard with thirty widgets that they open twice and never again, because thirty things is not a glance, it is a chore. The test I keep coming back to is simple. If you cannot understand your money in the time it takes to read four short lines, the screen is working for itself and not for you. The person who can build even this cleanly in a spreadsheet already holds a paid skill, and I wrote separately about what that Excel skill is worth in real money.

The forecast that looks forward, not back

A normal accounting report tells you what already happened, and honestly that is the part I care about least, because you cannot change last month no matter how neatly you chart it. The view a small business truly lives by looks forward. So the heart of the dashboard is a rolling 13 week line, one row per week, and each week does the same small piece of arithmetic. Take the money you reasonably expect to come in, subtract the expenses you know are coming, subtract the loan and card payments due that week, and you land on the balance you will be sitting on when the week ends. Carry that closing number into the next week as the opening one, and let it roll.

Do that thirteen times and a shape appears that no single bank balance ever shows you. A quiet dip around week six, where a big supplier payment lands before a slow sales stretch has recovered, and then the slow climb back out of it. Seeing that dip four weeks early is the entire point, because in week two you still have ten easy moves, delay one order, chase one invoice, hold one payment, and by the week it actually hits you have almost none of them left.

A bank balance tells you where you stand. A forecast tells you where you are about to stand.

This is the same forward looking logic behind a good daily sales report, where the point is to catch the trend while you can still act on it, and I go deeper on the business side of that in my piece on the automated end of day sales report.

Snowball or avalanche, in plain words

Once the forecast shows you have a little room each month, the next question is where that spare money should go, and if you carry more than one debt the order matters more than most people think. There are two honest ways to choose, and I show both on the screen because the right one depends on the person and not on the math alone.

The snowball pays the smallest balance first while you keep the minimum on the rest. You clear a whole debt quickly, you feel it, and that feeling is what keeps a lot of people going, which is often the difference between sticking with the plan and quietly letting it slide. The avalanche pays the highest interest rate first. On paper it is the cheaper path because you starve the most expensive debt first, and across a big balance that saving is real money. So the plain version is this. If numbers keep you motivated, run the avalanche and pocket the savings. If finishing something keeps you motivated, run the snowball and buy the momentum. The worst plan is the smart one you stop following in month three.

The part that decides if you keep using it

Here is where most money dashboards quietly die. They work beautifully for two weeks, and then feeding them turns into a nightly typing job, and one skipped evening becomes a skipped week, and soon the whole thing is stale and gently lying to you. So the part I spend the most care on is import, getting the transactions in without a human retyping them.

The clean version pulls a bank or card export, sorts each transaction into a category by a set of plain rules you can actually read, and drops the totals straight into the forecast. If the business already runs on something like Zoho Books, its analytics side can hand you the same feed, and there are other tools that do it too. The tool matters far less than the one rule underneath it, that every number on the screen can be traced back to a real transaction, because a money dashboard that is even slightly wrong is worse than no dashboard, it makes you feel confident and be wrong at the same time. That is the same lesson I learned the hard way with data that looked clean and was not, which I wrote about in my piece on the silent errors hiding in a spreadsheet.

I can teach you the four tiles and the rolling line in an afternoon, and honestly for a lot of people a tidy spreadsheet version is enough forever. The part I hold back, because it only really works when it is shaped around your own accounts, is the import wiring, the category rules that match how your money actually moves, and the checks that catch a mislabeled transaction before it quietly bends the whole forecast. If you want that built around your real numbers rather than a generic template, start a project and tell me how your money comes in and goes out, even if my honest answer turns out to be that a spreadsheet will carry you just fine.