How to Create a Cash Flow Projection for Your Business

Cash is the oxygen of your business. Profit is nice (and you should absolutely chase it), but cash is what actually keeps the lights on, pays your team, and prevents you from having that “why is my card declined at Office Depot?” moment.

A cash flow projection (also called a cash flow forecast) is your best attempt at predicting how much cash will move into and out of your business over a future periodso you can spot trouble early, plan growth, and sleep like someone who knows payroll won’t bounce.

What a Cash Flow Projection Is (and What It Isn’t)

A cash flow projection tracks timing. Not “Did we make a sale?” but “When will the money actually land in the bank?” That difference is the whole gameespecially if you sell on net-30 terms, carry inventory, or pay big bills upfront.

Quick distinction:

• Income statement (P&L): Profitability over a period (often accrual-based).
• Cash flow statement: Historical report of cash movement (operating, investing, financing).
• Cash flow projection: A forward-looking model that estimates future cash receipts and cash disbursements.

Lenders and investors love projections because they answer the question: “Will this business stay liquid?” And for owners, it’s even more practical: a projection tells you whether you can afford that new hire, that equipment, or that “tiny” marketing experiment that somehow costs $3,000 a month.

Pick Your Forecast Horizon: Monthly, Weekly, or Both

Most small businesses do best with two layers:

• Short-term: a 13-week cash flow forecast (weekly). Great for tight cash, seasonality, and “uh-oh” moments.
• Mid-term: a 12-month cash flow projection (monthly). Great for planning growth, taxes, and major expenses.

If you only build one, start with 12 months monthly. If cash is already feeling spicy, build the 13-week version first.

Before You Touch a Spreadsheet, Gather These Inputs

Your projection is only as good as the info you feed it. Collect this once, then update as you go:

Cash position

• Current bank balance(s) and any minimum cash you must keep on hand
• Credit line limits and current utilization (if applicable)

Money coming in (cash inflows)

• Sales forecast (units/orders, average price, seasonality)
• Collections assumptions (what % pays on time, late, or not at all)
• Accounts receivable aging (who owes you money and when)
• Other inflows: owner contributions, loan proceeds, grants, refunds, interest

Money going out (cash outflows)

• Payroll dates, benefits, contractor payments
• Rent, utilities, subscriptions, insurance
• Inventory purchases/materials (and vendor payment terms)
• Sales tax, payroll tax, estimated income tax payments
• Loan payments (principal + interest) and credit card payments
• Planned big spends: equipment, deposits, renovations, annual software renewals

Pro tip: cash projections fail most often because someone forgets taxes, annual bills, or the fact that customers are not, by default, punctual angels.

How to Build a 12-Month Cash Flow Projection (Step-by-Step)

You can do this in Excel, Google Sheets, or accounting software. The logic is the same:

Beginning cash + cash inflows − cash outflows = ending cash

Step 1: Set up the structure

• Create 12 columns for the next 12 months.
• Create rows for:
  • Beginning cash balance
  • Cash inflows (broken into categories)
  • Cash outflows (broken into categories)
  • Net cash flow (inflows − outflows)
  • Ending cash balance

Step 2: Start with your beginning cash

Your month 1 beginning cash is your real bank cash today (or today + any deposits/cleared checks you’re confident about). Then each month’s ending cash becomes the next month’s beginning cash.

Step 3: Forecast cash inflows (be realistic about timing)

Break inflows into categories so you can troubleshoot later:

• Cash sales (money collected immediately)
• Collections on invoices (money collected later)
• Other income (affiliate revenue, interest, refunds)
• Financing inflows (loan proceeds, owner injections)

Timing matters more than totals. If you invoice $50,000 in April on net-30 terms, that is not April cash. That’s usually May cashunless your client treats “net-30” as a fun suggestion.

Step 4: Forecast cash outflows (fixed, variable, and “surprise!”)

Separate outflows so you can see what you can control quickly:

• Fixed operating expenses: rent, base payroll, insurance, software
• Variable operating expenses: materials, shipping, hourly labor, merchant fees
• Financing: loan payments, credit card payments
• Investing/capex: equipment, buildouts, large one-time purchases
• Taxes: sales tax, payroll tax, estimated income tax

Put expenses in the month cash actually leaves. If you pay annual insurance in March, your projection should feel that punch in March.

Step 5: Calculate net cash flow and ending cash

For each month:

• Net cash flow = total inflows − total outflows
• Ending cash = beginning cash + net cash flow

Step 6: Add guardrails (minimum cash + “uh-oh” alerts)

Decide a minimum cash balance (your cash cushion). Many owners use one month of fixed expenses as a starting point. Then highlight any month where ending cash drops below that linebecause that’s when you’ll need to pull levers: speed up collections, delay spending, draw on a line of credit, or renegotiate vendor terms.

A Simple Example: The “Sunny Side Bakery” Projection

Here’s a mini cash flow projection example (numbers simplified). Notice how it’s built around cash collection timing, not just sales.

Month 2 goes negative on net cash flow. That doesn’t mean the business is doomedit means Month 2 needs a plan: maybe push a promotion to bring cash forward, renegotiate a supplier payment, or avoid optional spending that month.

Make Your Projection Smarter With Working Capital Timing

Most cash flow problems aren’t “sales are bad.” They’re “cash is stuck in working capital.” In plain English: your money is trapped in accounts receivable and inventory while accounts payable bills are due.

Collections reality check

• If you offer net-30, assume some customers pay in 45 days unless you have strict follow-up.
• Model a small % of invoices as “late” and a tiny % as “never,” especially for B2B.
• Consider incentives: early-pay discounts, deposits, milestone billing, or subscription/prepay options.

Inventory and vendor terms

• If you buy inventory today but sell it next month, cash leaves before cash returns.
• Vendor terms can be a lever: net-30 vs net-45 can change your cash curve dramatically.

Friendly reminder: invoices are not Pokémon. They do not magically evolve into cash if you ignore them long enough.

Upgrade to a 13-Week Cash Flow Forecast (When Precision Matters)

A 13-week cash flow forecast is the short-term “control tower” version of forecasting. It’s usually built weekly and uses a direct approach: weekly receipts minus weekly disbursements, starting from your current cash balance.

This format is especially useful when:

• You have seasonal swings (retail, tourism, construction, landscaping)
• You’re growing fast and cash is tight
• You’re dealing with large, lumpy payments (projects, wholesale, manufacturing)
• You want early warning before a low-cash week hits

Practical setup:

1. Columns = Week 1 through Week 13
2. Rows = beginning cash, expected receipts, expected disbursements, ending cash
3. Update it weekly (or even twice a week if you’re in a crunch)

Scenario Planning: Build Base, Best, and Worst Cases

Your “base case” projection is what you truly expect. But your business deserves backup plans. Create two quick variations:

• Best case: slightly faster collections, slightly higher sales, controlled costs
• Worst case: slower collections, lower sales, one surprise expense

You’re not being pessimisticyou’re being prepared. Scenario planning helps you answer: “If sales dip 15% and customers pay two weeks late, when do we hit the danger zone?”

How to Keep Your Projection Accurate Over Time

A projection isn’t a one-time homework assignment. It’s a living tool.

Use variance analysis (the grown-up way to say “compare forecast vs actual”)

• Each month (or week), record actual cash inflows/outflows.
• Calculate variances and label them:
  • Timing variance: cash arrived later/earlier than expected
  • Volume variance: more/less sales than expected
  • Cost variance: expenses higher/lower than expected
• Update the next periods based on what reality is teaching you.

Over time, your forecast becomes less “guessing” and more “data with a personality.”

Tools and Templates That Make This Easier

You can build a great cash flow projection with a spreadsheet. Many businesses start with templates and then customize:

• Spreadsheet templates (simple, flexible, and cheapaka the small business holy trinity)
• Accounting software forecasts that use historical patterns and your AR/AP data
• Bank dashboards that categorize transactions and may provide short-term forecasting

Whatever tool you pick, the secret sauce is consistent updating. A fancy forecast that never gets refreshed is just a well-formatted way to be surprised later.

Common Mistakes (and How to Avoid Them)

1) Treating sales like cash

Fix: model collections based on terms and real customer behavior, not hope and vibes.

2) Forgetting taxes

Fix: schedule sales tax, payroll tax, and estimated tax payments like they’re non-negotiable (because they are).

3) Ignoring “lumpy” expenses

Fix: list annual renewals, insurance premiums, equipment deposits, and inventory buys in the month they hit.

4) Never updating

Fix: set a recurring calendar slot30 minutes weekly for a 13-week forecast, or 60 minutes monthly for the 12-month projection.

5) Building a forecast that’s too detailed to maintain

Fix: start with 10–20 categories you’ll actually update, then add detail only if it improves decisions.

Wrap-Up: Your Cash Flow Projection Is a Decision Tool

A cash flow projection doesn’t exist to impress anyone (though it can). It exists to help you make smarter choices: when to hire, when to buy, when to slow down, and when to negotiate terms like your cash depends on itbecause it does.

Build the first version quickly. Then improve it with updates, real data, and scenario planning. In a few cycles, you’ll have a forecast that feels less like fortune-telling and more like steering.

Experiences That Make Cash Flow Projections “Click” (Real-World Patterns)

Business owners often say cash flow projections felt intimidatinguntil the first time the projection “called it.” The moment your spreadsheet flags a low-cash month weeks in advance, forecasting stops being a finance chore and starts feeling like a superpower with a keyboard shortcut.

Here are common experiences owners report when they start projecting cash flow consistently:

They discover the real villain: timing, not revenue

Many businesses aren’t failing because they can’t sellthey’re struggling because cash is delayed. A service business might invoice $80,000 in a month and still feel broke if payments land 45 days later. Once owners model collections timing (and not just billed revenue), they realize they have options: request deposits, shift to milestone billing, tighten follow-up, or offer small early-pay incentives. The projection becomes a negotiation map: “If we can pull in 20% of invoices 10 days earlier, we avoid dipping below our minimum cash.”

They stop being surprised by “predictable surprises”

The first few forecasts usually miss somethingan annual insurance premium, a quarterly tax payment, a software renewal that quietly upgraded itself. But once it’s in the model, it stops being a surprise forever. Owners often describe a strange new feeling: getting hit by a big bill and thinking, “Yep, we already knew you were coming.” That’s the point. Forecasting turns financial jump scares into scheduled events you can plan around.

They learn which costs are truly flexible

A projection makes “fixed vs variable” painfully clear. When cash tightens, owners naturally ask, “What can we cut?” The forecast answers more precisely: certain costs can be delayed (non-urgent tools, discretionary marketing tests, optional inventory buys), while others are hard walls (core payroll, rent, insurance, debt payments). Seeing this ahead of time helps owners avoid panicked, last-minute cuts that damage operations. Instead, they can make calm choices earlierlike trimming spend two months before a crunch, not two days before payroll.

They build a habit: weekly cash huddles

Teams that adopt a simple weekly rhythmupdate the 13-week forecast, review upcoming inflows/outflows, decide on actionsoften report less stress and better coordination. Sales knows which invoices are urgent. Operations knows which purchases can wait. Leadership knows whether growth decisions are funded by cash or fueled by optimism. The meeting doesn’t need to be long. It just needs to be consistent.

They become faster at “what-if” decisions

Owners frequently say the biggest benefit isn’t the numbers themselvesit’s how quickly they can answer questions. Can we hire now? Can we buy equipment or should we lease? Should we run a promotion to bring cash forward? By duplicating the forecast tab and tweaking a few assumptions (sales down 10%, collections slower, or a new expense added), the decision becomes less emotional and more measurable: “If we do this, our cash cushion drops below the line in Juneso we either need a deposit policy or we wait.”

Over time, forecasting becomes less about perfect accuracy and more about building cash awareness. You’re not trying to predict the future with wizard-level precision. You’re trying to see around corners early enough to act. And that, honestly, is the most underrated competitive advantage a small business can have.