Cash Flow Forecasting for Small Business Owners

Profitable businesses go broke. It happens more often than most people realize. Not because the business was bad or the owner made terrible decisions. Because the timing of money in versus money out did not line up.

Cash flow forecasting is how you see that problem coming before it arrives.

Profit and Cash Are Not the Same Thing

This is the part that surprises new business owners and trips up experienced ones.

You can show a profit on your P&L and still run out of cash in your checking account. Here is how:

You land a $30,000 contract in January. You invoice it net-30. Your client pays in February. But your payroll is every two weeks, your rent is due February 1st, and your supplier payment hit January 28th. In January, your P&L shows revenue. Your bank account shows stress.

Cash flow forecasting tracks when money actually moves, not when you earn it or owe it on paper.

What a Cash Flow Forecast Is

A cash flow forecast is a projection of money coming in and money going out over a specific time period, typically 13 weeks (one quarter) looking forward.

It is not a budget. A budget plans for what you want to happen. A forecast projects what will actually happen based on what you know today: your real receivables, your real payables, your actual payment terms.

Most small business owners who use forecasting run a 13-week rolling model. Each week, you look 13 weeks out. Each week, you update it with what actually happened and push the window forward. It becomes part of how you operate.

How to Build a Simple One

You do not need software to start. A spreadsheet works. The structure is the same either way.

Column 1: Week ending date

Thirteen rows, one per week.

Column 2: Cash inflows

Expected deposits that week. Customer payments, loan draws, owner contributions. Be conservative. If a client is slow to pay, do not count it until you have some reason to believe it is coming.

For each row, list:

• Collections from invoices already sent
• Expected sales you can reasonably count on
• Any other known deposits

Column 3: Cash outflows

Everything you will pay out that week. Payroll, rent, loan payments, supplier invoices, utilities, tax deposits. Use actual due dates.

Column 4: Net weekly cash flow

Inflows minus outflows.

Column 5: Running cash balance

Start with your current bank balance. Add or subtract the weekly net. This column shows you exactly where you will stand at the end of each week, 13 weeks from now.

What You Are Looking For

Any week where the running balance goes negative is a problem. That means you will not have enough cash to cover obligations without intervention.

When you see that problem coming 6, 8, or 10 weeks out, you have options. You can accelerate collections. You can push a payable. You can tap a line of credit proactively instead of in a panic. You can defer a purchase.

When you see it three days before it happens, your options are much worse.

A Real Scenario

Sarah runs a 12-person marketing agency. Her clients pay net-45. Her payroll runs every two weeks. Her forecast showed a $22,000 shortfall in week 9.

The cause: three large projects finished in the same week, all invoiced net-45 simultaneously. The payments were all coming, but they would land in week 11, two weeks after the shortfall.

Because she saw it in week 1, she called her two best clients and offered a 2% early payment discount. Both paid in two weeks instead of six. She covered the gap without touching her line of credit and without stress.

Without the forecast, she would have discovered this problem when checks started bouncing.

Common Mistakes

Being too optimistic on inflows. Count only money you actually expect to collect in each week based on your history with each customer. If a client has paid late 4 of the last 6 months, do not put them in week 4.

Forgetting irregular outflows. Annual insurance premiums, quarterly tax payments, equipment maintenance, seasonal inventory builds. These are predictable if you look at the calendar, but they get missed when owners only think week to week.

Building it once and ignoring it. A forecast you update once a quarter is not a forecast. It is a historical document. The value is in the weekly update, where you correct for what actually happened and push the projection forward.

Not including the owner draw. If you pay yourself, that is a cash outflow. Many owner-operators forget to include it or treat it as discretionary. Plan for it.

Tools to Help

You can use a spreadsheet, your accounting software (QuickBooks and Xero both have cash flow tools), or purpose-built forecasting tools.

The most important thing is not which tool you use. It is that you use one consistently.

Start with the Cash Flow Forecasting Template on KnowYourNut. It walks you through the 13-week structure with plain instructions and handles the running balance calculation automatically.

How Often to Update

Weekly, at minimum. Friday afternoon or Monday morning. It takes 15 to 30 minutes once you have the structure set up.

Check your actual bank balance against what the forecast predicted. If you are off by more than 10%, figure out why. That is how you get better at forecasting, and that is how you start catching problems earlier.

The Goal Is Not Perfection

Your forecast will not be exactly right. Clients pay late. Expenses surprise you. A big order comes in that you did not expect. That is fine. The goal is not a perfect prediction. It is enough warning to make a decision before you are in a corner.

Profitable businesses run out of cash when they do not see the timing problem coming. A 13-week forecast is how you see it.

FAQ

What is a 13-week cash flow forecast?

A 13-week cash flow forecast projects your cash inflows and outflows week by week for the next quarter. Each week you update it with actual results and push the window forward by one week. It shows your running cash balance so you can spot shortfalls 6-10 weeks before they hit.

How is a cash flow forecast different from a budget?

A budget plans what you want to happen. A forecast projects what will actually happen based on real receivables, real payables, and actual payment terms. Budgets set targets; forecasts tell you whether you will have enough cash to meet your obligations.

How long does it take to update a cash flow forecast each week?

Once you have the structure set up, a weekly update takes 15 to 30 minutes. You check your actual bank balance against the forecast, correct for what happened, and push the projection forward. Friday afternoon or Monday morning are the most common times to do it.

What should I do if my forecast shows a cash shortfall?

When you see a shortfall coming 6-10 weeks out, you have options: accelerate collections by offering early payment discounts, push a payable to a later date, tap a line of credit proactively, or defer a non-essential purchase. Catching problems early is the entire point of forecasting.

Can a profitable business really run out of cash?

Yes, and it happens regularly. If your clients pay on net-45 terms but your payroll and rent are due on the first of the month, you can show a profit on paper and still not have enough cash to cover obligations. The gap between when you earn money and when you collect it is what forecasting is designed to reveal.