How to Build a Cash Flow Forecast for a Small Business

Profit tells you whether your business makes money over time. Cash flow tells you whether you can pay the bills next Tuesday. Both matter, but it is cash that keeps the lights on, and plenty of profitable small businesses have stumbled because the money simply was not in the account when a big payment came due.

A cash flow forecast is the tool that prevents those surprises. It is a running estimate of the money you expect to receive and spend over the coming weeks or months. You do not need accounting software or a finance background to build one. A spreadsheet and an honest afternoon are enough.

Why a Forecast Beats Checking Your Balance

Looking at your bank balance shows you where you are today. It says nothing about the quarterly tax payment due next month, the slow season after the holidays or the customer who always pays 45 days late. A forecast lines those events up on a calendar so you can act early.

With a forecast in hand you can:

• Spot a shortfall weeks ahead and decide how to cover it calmly.
• Time large purchases for months when cash is strongest.
• Know whether you can afford a new hire, a lease or new equipment.
• Show a lender that you understand your numbers, which helps if you apply for an SBA microloan or 7(a) loan.

Step 1: Choose Your Time Frame and Interval

Most small businesses do well with a rolling forecast that looks 13 weeks ahead in weekly columns. Thirteen weeks is roughly a quarter, long enough to see trouble coming and short enough to estimate with reasonable accuracy. If your business is very seasonal, add a second, rougher view by month for the full year.

Set up a spreadsheet with weeks across the top and three main blocks down the side: opening cash, cash in and cash out.

Step 2: List Every Source of Cash Coming In

Write down each way money actually arrives in your account, and when. The key word is when. A sale you make on the 1st but get paid for on the 30th belongs in the week the money lands.

• Card and cash sales, after payment processing fees.
• Payments on invoices, based on how quickly each customer really pays.
• Deposits and retainers.
• Loan proceeds, owner contributions or other one-time inflows.

Base your estimates on recent history where you have it. If you are brand new, start conservative. It is far easier to deal with a pleasant surprise than an empty account.

Step 3: List Every Payment Going Out

This side usually needs more lines. Split it into fixed and variable costs so you can see what moves with sales and what does not.

Fixed outflows

• Rent and any shared building charges.
• Insurance, software subscriptions and phone or internet service.
• Loan payments.
• Salaries and your own owner draw.

Variable and occasional outflows

• Inventory, materials and supplies.
• Hourly wages that rise and fall with demand.
• Estimated tax payments, sales tax remittances and annual license renewals.
• Equipment repairs and planned purchases.

Watch commercial rent closely. If you lease a storefront or office, the monthly check may not be the whole story. Under a triple net lease, for instance, tenants typically pay a share of property taxes, insurance and maintenance on top of base rent, and some of those charges get reconciled once a year. A year-end true-up bill can be a nasty surprise if it is not in your forecast.

Taxes deserve the same care. Due dates and amounts depend on your business structure and where you operate, and the rules change. Check current deadlines with the IRS, the Missouri Department of Revenue and your city or county, and confirm the details with a qualified tax professional. This guide is general information only.

Step 4: Do the Math Week by Week

For each week, the calculation is simple:

1. Start with the opening cash balance.
2. Add total cash in for that week.
3. Subtract total cash out.
4. The result is closing cash, which becomes next week's opening cash.

Then look across the row of closing balances. Any week that dips below zero, or below the minimum cushion you want to keep, is a warning light. You now have time to respond.

Step 5: Plan Your Response to Tight Weeks

Seeing a shortfall early gives you options that disappear when it is already upon you. Common moves include:

• Speed up money coming in. Invoice the day work is done, offer easy payment methods and follow up promptly on late accounts.
• Ask for deposits on larger or custom orders.
• Shift timing on money going out. Ask suppliers about payment terms, or move a non-urgent purchase to a stronger month.
• Trim inventory so less cash sits on shelves.
• Arrange a line of credit before you need it, since lenders are more comfortable with businesses that are not yet in trouble.

Founders growing on their own revenue lean on these moves more than anyone. If that is you, our guide to bootstrapping a startup covers more ways to protect cash while you grow.

Step 6: Update It Every Week

A forecast is only useful if it stays current. Pick a regular time, maybe Monday morning with coffee, and spend 20 minutes on it:

• Replace last week's estimates with what actually happened.
• Add a new week at the far end so you always see 13 weeks ahead.
• Note where your guesses were off and adjust future weeks.

Over time your estimates get sharper. You will learn which customers pay on time, which months are slow and how much cushion you really need.

Connecting the Forecast to Your Other Numbers

Your cash flow forecast works best alongside a couple of other simple tools. A break-even analysis tells you how much you need to sell each month to cover costs, which gives you a reality check on the cash-in side. Your business plan sets the goals the forecast should support. Together, they turn a vague sense of how things are going into concrete numbers you can act on.

Getting Started This Week

You can have a working forecast by the end of the day:

1. Open a spreadsheet and create 13 weekly columns.
2. Enter today's bank balance as opening cash for week one.
3. List expected cash in by the week it will actually arrive.
4. List every payment going out, including rent extras, taxes and annual bills.
5. Calculate closing cash for each week and mark any week below your comfort level.
6. Set a weekly reminder to update it.

The first version will not be perfect, and that is fine. Even a rough forecast is far better than finding out about a cash crunch when the payment bounces.