How to Build a Cash Flow Projection Template (Free Walkthrough)

Why Every Business Needs a Cash Flow Projection

A cash flow projection is a forward-looking estimate of the money flowing into and out of your business over a specific period. Unlike a cash flow statement that records what already happened, a projection helps you anticipate shortfalls before they become emergencies.

According to a U.S. Bank study, 82% of small businesses fail due to cash flow mismanagement. The majority of those failures could have been prevented with a simple projection updated weekly or monthly. The businesses that survive are not necessarily the most profitable ones. They are the ones that never run out of cash.

Step 1: Set Up Your Projection Time Frame

The first decision is how far ahead to forecast. There are three standard time frames, each serving a different purpose:

For most small businesses, the 13-week rolling forecast is the gold standard. It is granular enough to catch near-term problems but long enough to give you a three-month runway view. Start here, then add a longer-range projection once you are comfortable with the process.

Step 2: Map Your Cash Inflows

Cash inflows include every source of money entering your business. The most common categories are:

• Accounts receivable collections: Existing invoices you expect to collect, adjusted for your average days sales outstanding
• New sales revenue: Projected sales based on pipeline, seasonality, and historical trends
• Other income: Interest, tax refunds, asset sales, or insurance payouts
• Financing inflows: Loan proceeds, lines of credit draws, or investor funding

The critical mistake most people make is projecting inflows based on when sales are invoiced rather than when cash is collected. If your average customer pays in 45 days, a January invoice should appear in your March projection, not January.

Adjusting for Collection Probability

Not every invoice gets paid in full or on time. Apply a collection rate to your receivables. If historically 5% of invoices go unpaid or are significantly delayed, discount your inflow projections by that amount. A conservative projection is always better than an optimistic one that leaves you scrambling for cash.

Step 3: Estimate Your Cash Outflows

Cash outflows fall into fixed and variable categories. Fixed costs like rent, insurance, and loan payments are predictable. Variable costs like materials, contractor payments, and commissions fluctuate with revenue.

Build your outflow schedule by listing every recurring payment and its exact due date. Common categories include:

• Payroll and benefits (typically the largest expense, usually bi-weekly or semi-monthly)
• Rent and utilities (monthly, on fixed dates)
• Supplier and vendor payments (variable timing based on purchase orders)
• Loan repayments (fixed schedule)
• Tax obligations (quarterly estimated taxes, annual filings)
• Software subscriptions and operating costs

Do not forget irregular expenses like annual insurance premiums, quarterly tax payments, or equipment maintenance. These lump-sum outflows are the most common cause of cash flow surprises.

Step 4: Calculate Your Weekly Net Cash Position

For each week in your projection, subtract total outflows from total inflows. The formula is straightforward:

Ending Cash Balance = Beginning Cash + Inflows - Outflows

Each week's ending balance becomes the next week's beginning balance. This rolling calculation reveals exactly when your cash balance dips below a safe threshold. If you see a negative balance approaching in week eight, you have seven weeks to act: accelerate collections, delay a discretionary purchase, or arrange a credit line.

Step 5: Review, Adjust, and Automate

A projection is only useful if you keep it updated. Each week, compare your projected numbers to actual results. Where were you right? Where were you off? Every variance teaches you something about your business's cash behavior.

Over time, your projections become more accurate as you develop a better understanding of seasonal patterns, customer payment habits, and expense timing. Tools like Finntree automate much of this process by pulling in real transaction data and updating your projections automatically, eliminating the manual spreadsheet work that causes most business owners to abandon their forecasts.

For a deeper dive into forecasting methodologies, check out our guide on cash flow versus working capital to ensure you are tracking the right metrics. If you are already profitable but struggling with cash, read our analysis of why profitable businesses experience negative cash flow.