Free 12-Month Cash Flow Forecast Template
Forecast the cash moving into and out of your business throughout the year. Compare forecast amounts with actual results, calculate monthly net cash flow and monitor your ending cash balance using this free Excel spreadsheet.
What's Included in the Cash Flow Forecast Template?
The workbook contains three primary worksheets designed to work together.
Cash Flow Dashboard
12-Month Cash Flow
Setup & Instructions
Track Business Cash Inflows
The spreadsheet includes commonly used cash inflow categories. Cash flow tracks when cash actually enters or leaves the business and may differ from accounting revenue or profit.
Cash Inflows
- Sales / Service Revenue
- Accounts Receivable Collections
- Owner Contributions
- Loan Proceeds
- Other Cash Inflows
Track Common Business Cash Outflows
The spreadsheet includes commonly used cash outflow categories. Categories may be adapted to your business's needs.
Cash Outflows
- Inventory / Materials
- Payroll & Wages
- Rent / Lease
- Utilities
- Insurance
- Marketing & Advertising
- Software & Subscriptions
- Professional Services
- Office Supplies
- Repairs & Maintenance
- Vehicle & Transportation
- Shipping / Delivery
- Bank & Payment Processing Fees
- Licenses & Permits
- Telephone & Internet
- Travel & Meals
- Taxes & Fees
- Loan / Debt Payments
- Equipment Purchases
- Owner Draws / Distributions
- Other Cash Outflows
How to Use the Cash Flow Forecast Template
- 1Download and open the Excel workbook.
- 2Enter your starting cash balance.
- 3Estimate expected cash inflows for each month.
- 4Estimate expected cash outflows for each month.
- 5Enter actual cash inflows and outflows as they occur.
- 6Review forecast vs. actual variance.
- 7Monitor monthly Net Cash Flow.
- 8Review Ending Cash Balance.
- 9Use the Dashboard to identify cash-balance trends.
- 10Update the forecast as business conditions change.
How Cash Flow Is Calculated
Net cash flow shows whether more cash entered or left the business during a month. Ending cash balance shows what remains. Because each month's ending balance becomes the next month's beginning balance, the template rolls your cash position forward through the entire year.
What Is a Cash Flow Forecast?
A cash flow forecast estimates when money is expected to enter and leave a business during a future period. It can help businesses organize expected customer payments, operating expenses, payroll, debt payments, equipment purchases, and other cash movements. A forecast is a planning tool — it does not predict future results with certainty, and actual cash activity will usually differ from the estimate.
Cash Flow vs. Profit: What's the Difference?
Profit measures revenue minus expenses under applicable accounting treatment. Cash flow tracks the actual movement of cash into and out of the business. A business can report a profit while still experiencing cash-flow pressure because the timing of cash receipts and payments may differ from when revenue and costs are recorded. For example, invoiced sales may count as revenue before the customer pays, while a loan payment or equipment purchase moves cash out without showing up as an ordinary expense the same way.
Why Compare Forecast vs. Actual Cash Flow?
Comparing forecast amounts against actual results helps identify differences between expectations and real business activity. Common examples include slower customer payments, higher expenses, unexpected purchases, stronger-than-expected sales collections, and changes in payroll or operating costs. Spotting those differences early lets you adjust spending, follow up on receivables, or revise the forecast before a small gap becomes a larger problem. Neither a positive nor negative variance is automatically good or bad — the context matters.
Why Monitor Cash Flow Monthly?
Monthly monitoring makes changes easier to identify than relying only on annual totals. Seasonality, payment timing, recurring expenses, large purchases, temporary cash shortages, and changing revenue patterns all show up month to month. Reviewing cash flow monthly helps you see when a shortfall is building and act while there is still time to adjust.
Download the Free Cash Flow Forecast Spreadsheet
Use this 12-month spreadsheet to forecast business cash inflows and outflows, record actual results and monitor your cash position throughout the year.
Related Business Tools & Templates
Cash Flow Forecast Template FAQ
What is a cash flow forecast?+
A cash flow forecast is an estimate of when money is expected to enter and leave a business during a future period. It helps owners anticipate cash balances, plan for upcoming expenses, and identify potential cash shortages before they happen.
Is this cash flow forecast template free?+
Yes. The 12-Month Cash Flow Forecast Template is free to download and use. No signup, email, account, or payment is required.
What is the difference between cash flow and profit?+
Profit measures revenue minus expenses under applicable accounting treatment. Cash flow tracks the actual movement of cash into and out of the business. A business can report a profit while still experiencing cash-flow pressure because the timing of customer payments and outgoing expenses may not match when revenue and costs are recorded.
How do I create a 12-month cash flow forecast?+
Start with your beginning cash balance, estimate expected cash inflows for each month, estimate expected cash outflows for each month, and calculate the net cash flow and ending balance for each month. Each month's ending balance becomes the next month's beginning balance. This template automates those calculations.
What should be included in a cash flow forecast?+
Common cash inflows include sales revenue, accounts receivable collections, owner contributions, loan proceeds, and other cash receipts. Common cash outflows include inventory, payroll, rent, utilities, insurance, marketing, software, loan payments, taxes, and owner draws. Include the categories that reflect how cash actually moves in your business.
How often should I update my cash flow forecast?+
Most small businesses review and update their cash flow forecast monthly, entering actual results as they occur and adjusting future months as conditions change. More frequent updates can help when cash is tight or revenue is unpredictable.
What is net cash flow?+
Net cash flow is the difference between total cash inflows and total cash outflows for a period. A positive net cash flow means more cash came in than went out; a negative net cash flow means more cash went out than came in.
What is an ending cash balance?+
Ending cash balance is the amount of cash a business has at the close of a period. It equals the beginning cash balance plus net cash flow for that period. The ending balance for one month becomes the beginning balance for the next month.
Can I customize the spreadsheet?+
Yes. The category names are editable so you can adapt them to your business. Add, rename, or remove inflow and outflow categories to match how cash actually moves in your operations.
Does this replace accounting software?+
No. This template is an organizational and planning tool. It does not replace accounting, bookkeeping, or tax software. For formal financial reporting, use dedicated accounting software and consult qualified professionals.
Can service businesses use this template?+
Yes. Service businesses can use the same structure. If you have little or no inventory, you can leave those outflow categories at zero or repurpose them for direct service-delivery costs.
Can I compare forecast and actual cash flow?+
Yes. The workbook includes Forecast and Actual columns for each month and calculates the variance automatically, so you can see where real cash movement differs from your plan.
This template is provided for general educational and organizational purposes only. It is not accounting, tax, legal, investment or financial advice. Forecasts are estimates and actual business results may differ. Businesses should review their individual financial and reporting requirements with qualified professionals when appropriate.