Cash Flow Projection Template: Build One That Works

I've sat across from business owners who can recite their YTD revenue down to a few hundred dollars but can't tell me what their bank balance will look like in 45 days. Both numbers matter. Only one of them determines whether you make payroll next month.

A cash flow projection template is the document that answers the 45-day question. It maps your expected cash inflows and outflows over a defined future window, week by week or month by month, so you can see problems coming instead of discovering them on a Friday afternoon. If you haven't built one yet, or you've got a version gathering dust because it stopped feeling useful, this guide walks you through it.

What a Cash Flow Projection Actually Tells You

Your P&L tells you whether the business is profitable. Your cash flow projection tells you whether the business can pay its bills. These are not the same document, and confusing them has ended companies that were growing by every other measure.

I've seen this pattern too many times. A business has a healthy P&L; revenue is up, gross margins look solid, the owner feels good about the year. Then something predictable happens: a major client pays 75 days late instead of 30, payroll comes due, and there isn't enough in the account to cover both. The P&L said profitable. The bank account said otherwise.

According to the U.S. Bank study widely cited in small business failure research, 82% of businesses that fail do so while technically profitable. The gap isn't revenue; it's timing. Cash comes in on one schedule and goes out on another, and without a projection, you're flying without instruments.

A cash flow projection template maps that timing explicitly. It starts with your current cash balance, adds the inflows you expect to receive (customer payments, loan draws, asset sales), and subtracts the outflows you're committed to (payroll, rent, vendor invoices, loan repayments). What's left at the end of each period is your projected ending balance — and that number tells you where the risk actually lives.

The projection doesn't have to be complex. I've seen tight, reliable projections built in 12 columns and 30 rows. What matters isn't the sophistication; it's that the numbers are grounded in real receivables, real obligations, and real timing. Not optimistic assumptions about when clients will pay.

Cash Flow Projection vs. Cash Flow Forecast: The Distinction That Matters

People use "projection" and "forecast" interchangeably, and in casual conversation that's fine. But if you're building a planning tool, the distinction is worth keeping straight.

A cash flow forecast typically refers to a structured model of expected future performance based on historical trends, growth assumptions, and known seasonal patterns. It's the 12-month view you build for a bank loan or an annual planning session; it relies on assumptions.

A cash flow projection is more tactical. It's a shorter-horizon document, usually 13 weeks, grounded in actual committed transactions rather than assumptions. Your signed contracts. Your known invoices. Your scheduled payroll runs and rent payments. The projection uses what you actually know is coming in and going out, not what you hope will happen based on last year's growth rate.

Both are useful. But they serve different decisions.

Most businesses need both. The forecast shapes your annual plan. The projection tells you whether you'll make payroll in three weeks. I'd argue the projection is more valuable day-to-day; it's the one that tells you something you didn't already know.

How to Build a Cash Flow Projection in Six Steps

Building a working cash flow projection template doesn't require a finance degree or expensive software. It requires discipline about inputs and honesty about timing. Here's how I walk business owners through it.

Set your time horizon and period length

Decide whether you're projecting weekly or monthly, and how far out. For most small businesses, I recommend a 13-week rolling projection updated weekly; it's close enough to be accurate and long enough to be useful. If your business has longer payment cycles or seasonal swings, extend to 26 weeks. Monthly periods work fine for businesses with predictable, recurring cash flows.

Lock in your opening cash balance

Your opening balance is the actual cash in your bank accounts at the start of the projection period — not accounts receivable, not invoiced-but-uncollected revenue. Cash on hand. Pull it directly from your bank statement. If you're combining multiple accounts, add them. This is your starting line.

Project your cash inflows

List every source of cash you expect to receive during the projection window. Work from your actual AR aging report, not from booked revenue. The critical question isn't "did we invoice this client?" It's "when will they actually pay?"

• Collected receivables: Which outstanding invoices are likely to be paid, and when? Sort by client payment history, not by invoice due date. If a client has paid 45 days late for the past three cycles, don't project them paying in 30.
• New sales collections: Based on your current pipeline and expected close dates, what new cash will come in? Apply a collection lag consistent with your payment terms; if you offer Net 30, budget for Net 40 in reality.
• Recurring revenue: Subscriptions, retainers, recurring service contracts. These are your most predictable line items. Lock them in first.
• Other inflows: Loan draws, tax refunds, asset sales, owner contributions. Only include these if they're confirmed, not hoped-for.

Project your cash outflows

List every cash obligation for the period. I find it's easiest to separate fixed obligations from variable ones.

• Fixed outflows: Payroll (including employer taxes), rent, debt service, software subscriptions, insurance premiums. These happen on a schedule and don't change with volume.
• Variable outflows: Supplier payments, contractor invoices, materials, commissions. These scale with activity; be honest about the volume you're expecting.
• One-time outflows: Equipment purchases, legal fees, tax payments, refunds. These are easy to forget in projections and expensive to ignore.

Calculate your net cash position for each period

Subtract total outflows from total inflows for each period. Add that net figure to your opening balance. The result is your closing balance, which becomes the opening balance for the next period.

If any period shows a closing balance below your comfort threshold (I usually recommend a floor of one full payroll cycle plus your largest recurring vendor payment), that's a gap you need to address before it arrives.

Review, stress-test, and update

A projection is only as good as its assumptions. Before you finalize it, run a quick stress test: what happens if your two largest clients pay 15 days late? What if a deal you were counting on slips to next month? The projection that survives a few realistic scenarios is the one worth acting on.

Then update it weekly. It takes 20 minutes once the template is built, and it keeps the tool relevant. A projection built once and never updated is just a historical exercise in wishful thinking.

The Data Problem Nobody Talks About

Most businesses I work with have all the data they need to build an accurate cash flow projection. The problem isn't that the data doesn't exist; it's that it lives in four different places and nobody has connected them.

Your invoices are in your accounting software. Your client payment history is in your CRM or email. Your payroll schedule is in Gusto or ADP. Your vendor obligations are spread across a mix of email threads and spreadsheet tabs. Nobody's combining these into a single projection view because that would require manually pulling from all four systems on a weekly basis, and that's work that feels like it can wait until things get uncomfortable.

My friend, that's exactly when it's too late.

I worked with a real estate company that was profitable on paper every single month. Revenue was strong, the owner knew it, the accountant confirmed it. But the business was constantly cash-constrained; it struggled to cover operating expenses between the time deals closed and cash was distributed, and it routinely scrambled to cover routine bills that should have been non-events.

The first step was painful. When we built the initial projection, the owner saw, laid out clearly on a single page for the first time, that there were three consecutive months with closing balances below the minimum needed to cover payroll and basic vendor obligations. The revenue was real. The problem was purely timing. She'd known something was off for months; she hadn't known how off until the numbers were all in one place.

After implementing strategic cash flow forecasting — mapping actual receivable timing, debt obligations, and operating expenses against each other — the company improved its operating liquidity by more than 1,866% in six months (measured against the baseline we established on that first painful projection day). That number is exact; I don't round it. The business didn't grow its way out of the problem. It got visibility and acted on what it saw.

That's what a proper cash flow projection template does, at its core. It forces you to pull all your cash-related data into one place and look at it together. The insight isn't magic; it's just what happens when the numbers stop being separate and start being a complete picture.

This is also why cash flow forecasting in Excel is better than no forecasting — but it's worse than a system connected to your actual receivables, payroll data, and project pipeline. The spreadsheet tells you what you think will happen based on what you manually entered last Tuesday. A connected dashboard tells you what's actually happening, updated in real time. Both beat nothing. But they're not equivalent, and pretending they are is how cash gaps become cash crises. According to the U.S. Bank research, 82% of businesses that fail do so while technically profitable; the gap is nearly always a visibility problem, not a revenue problem.

Common Mistakes That Make Projections Useless

I've reviewed a lot of cash flow projection templates that looked impressive and failed completely. The failures aren't random; they cluster around the same errors.

The most common one: projecting revenue instead of collections. Revenue is when you earn it; cash is when you collect it. If your projection shows January revenue of $120,000 but your average collection cycle is 45 days, your January cash inflow is closer to what you invoiced in November. Project collected cash, not billed revenue. The difference can be $30,000 on a single month, and most businesses don't catch this until they've already missed a payment.

Equally common is using blanket payment terms instead of client-specific history. Not all clients pay the same way. Some pay early; some pay a month late regardless of terms. A projection that applies "Net 30" across the board is hiding real risk. Segment your AR by client and apply their actual payment behavior. The clients who routinely pay in 50 days need to show up in your projection as 50-day payers. The alternative is a projection that looks fine every time a particular client's invoice is outstanding and then goes red every time they actually pay.

Then there are forgotten quarterly and annual obligations. Quarterly tax estimates, annual insurance renewals, lump-sum software contracts, year-end bonuses. These hit once or four times a year, and they're still predictable. If it exists on a calendar, it belongs in the projection. I've watched tidy monthly projections blow up in March because nobody entered the Q1 estimated tax payment.

Building the projection once and never updating it is another failure pattern, and possibly the most self-defeating one. Markets move, clients pay late, deals slip. The projection you built in January isn't telling you anything useful in March unless you've been updating it. Treat it as a living document or don't bother building it.

And finally: projecting from hope instead of evidence. The most dangerous number in any cash flow projection is the deal that's "definitely closing next week." I've built projections where owners were certain about four things that all slipped. Apply a close-rate discount to pipeline-dependent inflows, or build a conservative scenario that excludes anything without a signed contract. The projection that assumes every optimistic outcome is accurate will be accurate exactly once, and that's the month it closes correctly by accident.

When the Numbers Turn Red: What to Do Before the Gap Arrives

A cash flow projection is only valuable if you act on what it shows you. When a period flips red — projected closing balance below your floor — you've got lead time. That lead time is the entire point.

If the gap is 3–6 weeks out and modest, you have meaningful options. Call clients with invoices over 30 days personally — a short call closes more invoices than any automated reminder, and I've seen owners recover $40,000 in a single afternoon of direct outreach. The accounts receivable management system handles the routine follow-up; the owner's voice handles the exception. Beyond collections, look at which variable outflows can slide 30 days without operational consequence. Software renewals, equipment upgrades, discretionary subscriptions — not payroll, not rent, not vendors you need next week — but anything that can move without breaking something should be reconsidered in a tight month.

If the gap is larger or further out, your options are more structural. A line of credit exists precisely for timing gaps; draw it before the gap arrives, not after the bank can see you're in trouble. Renegotiate payment terms with your largest vendors; most suppliers would rather give you 60 days temporarily than lose a customer, and they'll almost always say yes if you ask before you're desperate. Reassess hiring plans. If the projection shows a gap and you were planning to bring on two people next month, those decisions are now connected. Hiring ahead of cash is one of the fastest ways to turn a timing problem into a solvency problem.

The projection doesn't solve the problem. It gives you the lead time to solve it yourself.

When a Spreadsheet Stops Being Enough

I want to be direct here: a well-maintained Excel or Google Sheets cash flow projection template is a legitimate business tool. If you've got a clean template, you update it weekly, and the inputs are grounded in real data, it works. I'm not going to suggest you abandon something that's working.

But there are specific situations where a spreadsheet starts creating more risk than it manages.

The first is when your AR is large and client-diverse. If you've got $200,000 or more in outstanding invoices across 15 clients with different payment behaviors, manually projecting collections becomes a part-time job; it's also less accurate than a system that's reading your actual invoice aging in real time. Research from BigTime confirms what I've seen in practice: cash flow forecasting works best when it's connected directly to accounting systems, because live data improves forecast accuracy more than any template optimization. The accounts receivable data is already digital somewhere. The question is whether your projection is connected to it.

The second is when your business has multiple revenue streams with different timing. A business with project-based revenue, a retainer base, and a few one-time sales isn't doing three projections; it's doing one projection that tries to account for three different timing patterns in a single tab. That's where errors compound silently. A connected system that tracks each stream separately and rolls them up automatically is more reliable than a formula that a human updates imperfectly every week.

The third is the clearest signal: you've been surprised by a cash crunch in the last 12 months. Not because something genuinely unpredictable happened, but because the signals were sitting in your AR aging or your payroll schedule and nobody was looking at them in the same place at the same time. The spreadsheet is fine when the discipline exists. The tool needs to close the discipline gap when it doesn't.

When you probably don't need to upgrade yet

• You're a solopreneur under $300K with predictable monthly revenue and minimal AR complexity. A Google Sheet covers it.
• Your cash flow is entirely recurring; subscriptions or retainers paying reliably, almost no timing gap between invoicing and collection. Your bank balance and your MRR dashboard tell the whole story.
• You're pre-revenue or very early stage. Build the projection habit in a spreadsheet, get your first consistent clients, then revisit when the complexity earns a better tool.

The platform earns its value when there are multiple moving parts to connect: receivables, payroll timing, project pipeline, multi-stream revenue. Most businesses hit that point earlier than they expect. A free trial is the fastest way to find out whether you've arrived there.

Frequently Asked Questions