GoWithFund
Sign in
💳Smart Finance• Private Net Worth, Envelope Budgeting, Cashflow & Wealth Engine

Cash Flow Projection Template: Free Excel Download

Get a free cash flow projection template in Excel. Learn to forecast cash flow, avoid shortfalls, and manage finances with confidence.

GoWithFund Editorial Team
GoWithFund Editorial Team
••8 min read
A modern desk with a laptop showing a cash flow projection chart, notebook, calculator, and coffee, representing financial planning.
Quick Answer

A cash flow projection template is a pre-built spreadsheet that helps you forecast when money will enter and leave your business over a set period. It turns your expected income and expenses into a week-by-week or month-by-month view of your cash position, so you can spot shortfalls before they happen and plan ahead with confidence.

🌱
Key takeaways
  • A cash flow projection template forecasts cash in and out over time, helping you avoid shortfalls.
  • Include all operating, investing, and financing activities—not just sales and expenses.
  • The 13-week cash flow forecast is ideal for short-term liquidity management.
  • Use real data from your accounting system to make projections accurate.
  • Review and update your projection weekly to stay ahead of cash gaps.
  • Our free Excel template automates totals and highlights potential shortfalls.

Cash Flow Projection Template: Your Free Excel Download

A cash flow projection template is a pre-built spreadsheet that helps you forecast when money will enter and leave your business over a set period. It turns your expected income and expenses into a week-by-week or month-by-month view of your cash position, so you can spot shortfalls before they happen and plan ahead with confidence.

This guide gives you a free, ready-to-use Excel template and walks you through how to fill it in, including a 13-week cash flow example for short-term planning. Whether you're a freelancer'll learn how to create a cash flow projection that keeps your finances on track.

Key Takeaways

  • A cash flow projection template shows expected cash in and out over time, helping you avoid surprises.
  • Include all operating, investing, and financing activities—not just sales and expenses.
  • The 13-week cash flow forecast is ideal for short-term liquidity management.
  • Use real data from your accounting system to make projections accurate.
  • Review and update your projection weekly to stay ahead of cash gaps.
  • Our free Excel template automates totals and highlights potential shortfalls.

Why Cash Flow Projections Matter

Cash flow projections matter because they give you a forward-looking view of your liquidity—the cash you actually have on hand to pay bills, make payroll, and invest in growth. Profit on paper doesn't guarantee cash in the bank; timing differences between when you invoice and when you get paid can create dangerous gaps.

For small businesses and freelancers, cash flow problems are a leading cause of failure. According to a widely cited 2019 study by U.S. Bank, 82% of small businesses fail due to poor cash flow management. While that figure is often referenced, it's important to note that it comes from a survey and should be treated as an estimate. The core lesson stands: without a projection, you're flying blind.

A projection helps you answer critical questions: Will I have enough cash to cover next month's rent? Can I afford to hire? When should I chase late payments? It also supports better decision-making for loans, investments, and spending. By mapping out expected inflows and outflows, you can plan for seasonal dips, negotiate payment terms with suppliers, and build a cash buffer.

For freelancers, a cash flow forecast template is equally vital. Irregular income makes it hard to budget, but a projection smooths out the peaks and valleys, showing you how much to set aside for taxes and slow months.

What to Include in Your Cash Flow Projection

A complete cash flow projection includes all sources of cash inflows and outflows. It should cover a defined period—typically 13 weeks for short-term or 12 months for annual planning—and start with your opening cash balance.

Here's what to include:

  • Opening cash balance: The cash you have at the start of the period.
  • Operating inflows: Cash sales, collections from accounts receivable, interest income, and other day-to-day receipts.
  • Operating outflows:Payments to suppliers.
  • Investing activities: Purchase or sale of assets, equipment, or investments.
  • Financing activities: Loan proceeds, loan repayments, owner's draws or contributions, and equity injections.
  • Net cash flow: Total inflows minus total outflows for the period.
  • Closing cash balance: Opening balance plus net cash flow—this becomes next period's opening balance.

Be sure to separate cash flow from profit. Depreciation, for example, reduces profit but doesn't affect cash. Similarly, taking out a loan increases cash but isn't income. A good cash flow projection format clearly distinguishes these categories to avoid confusion.

For accuracy, base your projections on historical data and realistic assumptions. If you're unsure about a figure, use a range or mark it as an estimate. The goal is to anticipate timing, not to predict the future perfectly.

Hands using a tablet to fill out a cash flow projection template with a printed chart nearby.

How to Build a 13-Week Cash Flow Projection

A 13-week cash flow projection is a short-term forecast that tracks cash on a weekly basis for one quarter. It's the gold standard for managing liquidity because it gives you a granular view of when cash will hit your account and when bills are due, allowing you to react quickly to shortages.

Here's a step-by-step framework to build one:

  1. Gather your starting data:Collect your current cash balance.
  2. Set up the spreadsheet: Create columns for each of the 13 weeks. Rows should include opening cash, inflows (by category), outflows (by category), net cash flow, and closing cash.
  3. Project inflows week by week: Estimate when customers will pay based on payment terms and historical collection patterns. For example, if you invoice on net 30, cash arrives about 30 days later. Include other inflows like loans or asset sales.
  4. Project outflows week by week: List all known payments—rent—and assign them to the week they'll be paid. Use actual due dates, not just month-end.
  5. Calculate net and closing cash: For each week, subtract total outflows from total inflows to get net cash flow, then add opening cash to get closing cash. The closing cash for week 1 becomes opening cash for week 2, and so on.
  6. Identify shortfalls: If closing cash ever drops below your minimum safety buffer (e.g., one month of operating expenses), you have a shortfall. Plan corrective actions like delaying payments, accelerating collections, or arranging a credit line.
  7. Update weekly: Replace projected figures with actuals as weeks pass, and roll the forecast forward. This keeps it accurate and actionable.

For a concrete cash flow projection example, imagine a small design agency with $50,000 in starting cash. In week 1, it expects $10,000 in client payments and $8,000 in expenses, ending with $52,000. By week 5, a large tax bill of $15,000 is due, but only $5,000 in collections are expected, causing a dip to $42,000. Seeing this in advance, the agency can arrange a short-term loan or delay a planned equipment purchase.

Free Template: Download and Instructions

Our free cash flow projection template is an Excel file designed for small businesses, freelancers, and finance managers. It includes a 13-week forecast tab and a 12-month annual tab, with pre-built formulas for totals and conditional formatting to flag negative cash balances.

To use the template:

  1. Download the Excel file from the link below.
  2. Enter your opening cash balance in the designated cell.
  3. Fill in your expected inflows and outflows for each week or month. Use the categories provided or customize them.
  4. The template automatically calculates net cash flow and closing balance for each period.
  5. Review the summary dashboard to see your cash position at a glance.

Download the free cash flow projection template (Excel) — [Insert download link]

The template is fully editable and works in Excel, Google Sheets, and most spreadsheet software. It's a cash flow projection template free of charge, with no hidden fees.

For a quick comparison of template types, see the table below:

Template TypeBest ForTime HorizonKey Feature
13-Week Cash FlowShort-term liquidity management13 weeksWeekly granularity
12-Month Cash FlowAnnual budgeting and planning12 monthsMonthly overview
Project-Based Cash FlowFreelancers and project teamsProject durationTracks per-project cash

If you prefer a more automated solution, consider using the GoWithFund Smart Finance app, which generates real-time cash flow reports and budgets from your transactions.

Tips for Accurate Cash Flow Forecasting

Accurate cash flow forecasting requires discipline and realistic assumptions. The more closely your projections mirror actual cash timing, the more useful they become for decision-making.

Here are key tips:

  • Use historical data: Base your collection and payment patterns on actual past behavior. If customers typically pay in 45 days, don't assume 30.
  • Be conservative with inflows: It's better to underestimate receipts and overestimate payments. This creates a safety margin.
  • Account for seasonality: If your business has busy and slow seasons, adjust your projections accordingly.
  • Separate cash from accruals: Don't include non-cash items like depreciation or accrued expenses that haven't been paid.
  • Update regularly: A forecast is only useful if it's current. Update weekly or at least monthly.
  • Involve your team: Get input from sales, purchasing, and finance to ensure all cash flows are captured.
  • Use software: Tools like the GoWithFund Smart Finance app can automate data entry and provide real-time cash flow insights, reducing manual errors.

Remember that forecasting is not about perfection—it's about preparation. Even a rough projection is better than none, as it forces you to think about future cash needs.

Small business owner reviewing cash flow reports on a laptop with a whiteboard graph in the background.
Keshav Gautam
Verified E-E-A-T Author

Keshav Gautam

Director, GoWithFund Inc.

Published on behalf of GoWithFund Inc., a registered U.S. 501(c)(3) tax-exempt public charity in Idaho (EIN: 33-1243835 | Idaho SOS #5902503). Articles are reviewed for statutory compliance under IRS Internal Revenue Code Section 170.

GoWithFund Smart Finance0% Platform Fee Ecosystem

Take Control of Your Personal Wealth & Cashflow

Stop letting predatory apps sell your financial data. Enjoy instant net worth calculations, automated envelope budgeting, and 1-click CPA exports.

100% Donor Funds DeliveredInstant Stripe Direct DepositNo Monthly Retainers
Recommended Reading
Explore all Smart Finance guides
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Freelancer's desk with laptop, notebook charts and calculator used for irregular income budgeting
💳 Net Worth & Wealth
Nov 22, 2026•8 min read

How to Budget for Irregular Income: Freelancer Method

Learn how to budget for irregular income with a baseline-plus-buffer method, worked examples and a simple cash-flow routine for freelancers.

GoWithFund Editorial Team

GoWithFund Editorial Team

Staff Contributor

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read