A cash flow forecast estimates when money will enter and leave your business. It helps you see whether enough cash will be available for payroll, suppliers, taxes, rent, loan payments, and other commitments.
You do not need advanced accounting knowledge to create one. Accurate records, realistic assumptions, and a simple monthly layout are enough to get started.
Quick Answer
A 12-month cash projection shows how much money you expect to receive and spend over the next year. It helps you plan expenses, identify shortages early, and make better decisions about hiring, inventory, financing, and growth.
Why Profitable Businesses Can Still Run Out of Cash
Profit and cash are not the same.
A business may record strong sales but still have little money in the bank because customers have not paid, cash is tied up in inventory, or bills are due before receipts arrive.
For example, a company may complete $80,000 of work in March but allow customers 60 days to pay, while payroll and suppliers must be paid sooner.
The JPMorgan Chase Institute found that the median small business in its study held only 27 days of cash reserves, showing how quickly delayed payments can create pressure.
What Does a Cash Projection Show?
A projection tracks opening cash, customer receipts, other income, operating costs, taxes, debt payments, major purchases, and the expected closing balance.
Timing matters. You might send an invoice in January but receive payment in March. Although the sale may appear in January’s accounting records, the cash belongs in March for forecasting purposes.
Why Plan 12 Months Ahead?
A full-year view can reveal seasonal slow periods, annual renewals, tax deadlines, planned hiring, and months when several large payments may fall together.
It helps you judge whether to hire, buy equipment, increase reserves, change payment terms, or arrange financing, and what those decisions may mean several months later.
Cash Flow Budget vs. Forecast
A cash flow budget records what you planned or hoped would happen. A forecast reflects what you currently expect based on recent results and new information.
Suppose your budget assumes monthly sales of $50,000. After the first quarter, actual sales average $42,000. Your updated projection should use the newer figure rather than the original target.
The budget shows the plan, while the forecast shows the latest expectation. Comparing the two helps explain performance changes and improves future cash flow planning.
How to Build a Cash Flow Forecast in 7 Steps
1. Create 12 monthly columns
Set up one column for each month of the coming year. Add rows for opening cash, incoming cash, outgoing cash, net movement, and closing cash.
A business facing immediate pressure may also need a weekly model covering the next 8 to 13 weeks.
2. Enter your opening balance
Start with money currently available in your business bank accounts.
Do not include unpaid invoices, unsold inventory, unused credit facilities, or equipment. Those items may have value, but they are not cash you can spend today.
The closing balance from one month becomes the opening balance for the next.
3. Estimate money coming in
List the cash you reasonably expect to receive, including customer payments, subscriptions, retainers, owner contributions, grants, loans, tax refunds, and asset-sale proceeds.
Use evidence where possible. Review signed contracts, unpaid invoices, renewal dates, and customer payment habits.
Place income in the month you expect to receive it, not automatically in the month you issue the invoice.
4. Estimate money going out
List each expected payment in the month when it will leave your account.
Common examples include payroll, rent, inventory, software, insurance, marketing, loan repayments, professional fees, and taxes.
Review at least 12 months of records to catch quarterly taxes, annual renewals, repairs, bonuses, and other easily missed costs.
5. Calculate each closing balance
Use this formula:
Opening cash + cash received − cash paid = closing cash
Assume the business starts April with $25,000, expects to receive $40,000, and plans to pay $52,000.
$25,000 + $40,000 − $52,000 = $13,000
The $13,000 closing figure becomes May’s opening balance.
Month | Opening cash | Cash received | Cash paid | Closing cash |
January | $20,000 | $35,000 | $32,000 | $23,000 |
February | $23,000 | $28,000 | $36,000 | $15,000 |
March | $15,000 | $40,000 | $33,000 | $22,000 |
February is the tightest month. Seeing that early gives the owner time to collect overdue invoices, delay a nonessential purchase, or arrange temporary funding.
6. Test different scenarios
One version is rarely enough. A large customer may pay late, sales may slow, or an expense may arrive earlier than expected.
Create three versions:
Expected: Your most realistic estimate.
Cautious: Lower sales, slower payments, or higher costs.
Stronger: Better sales, faster collections, or lower costs.
Test what happens if sales fall by 10%, a customer pays 30 days late, or supplier prices rise. Scenario testing supports better business financial planning by showing how much flexibility you have before money becomes tight.
7. Replace estimates with actual results
At the end of each month, replace estimates with actual figures. Review important differences, adjust the remaining months, and add another month at the end.
If customers repeatedly pay later than expected, change future receipt dates. If expenses are regularly higher than planned, update the assumptions.
This creates a rolling annual view that becomes more accurate over time.
Spreadsheet or Cash Flow Forecasting Software?
A spreadsheet may be enough for a smaller company with straightforward finances. It is flexible, inexpensive, and easy to adapt.
However, spreadsheets can become harder to control as a business grows. Formulas may be changed accidentally, information can become outdated, and several versions may circulate.
Cash flow forecasting software may be useful when you manage multiple accounts, entities, revenue streams, or reporting requirements. Some tools connect with accounting platforms and import balances, invoices, bills, and transactions automatically.
Choose the simplest option your team will maintain properly. A basic spreadsheet updated every month is more useful than complex software nobody uses.
Common Mistakes to Avoid
Treating a sale as immediate cash
Use the expected customer payment date, not automatically the invoice date.
Forgetting irregular expenses
Include taxes, annual insurance, equipment, bonuses, renewals, and professional fees.
Using optimistic assumptions
Do not assume every opportunity will close or every customer will pay on time.
Using inaccurate bookkeeping records
A projection based on missing transactions, unreconciled accounts, or outdated balances can be misleading.
How Cash Flow Forecasting Supports Growth
Forecasting also helps you grow at a pace the business can support. It can guide decisions about hiring, inventory, equipment, new services, and financing.
A clear projection does not guarantee funding, but it shows lenders and investors how money will be used and whether future payments appear manageable.
When Professional Support Makes Sense
Professional guidance becomes useful when a company is growing, seeking finance, managing several entities, or considering a major commitment.
Outsourced CFO services can connect projections with financial statements, test growth scenarios, identify working-capital risks, and prepare lender or investor information. A useful adviser should also explain what drives the numbers and which actions are available.
Plan Your Next 12 Months With FixIT ConsulTech
At FixIT ConsulTech, we support startups and growing businesses with bookkeeping, financial reporting, cloud accounting, forecasting, and CFO services.
We can build a practical 12-month projection using your actual customer payment cycles, recurring expenses, hiring plans, and growth targets. We also help keep the underlying books accurate because any financial model is only as reliable as the information behind it.
Contact FixIT ConsulTech to schedule a consultation and turn your financial data into a practical plan for the next 12 months.
Frequently Asked Questions
How accurate should a forecast be?
It should be realistic enough to support decisions, though it will rarely match actual results exactly. Current records, confirmed contracts, payment history, and realistic expense dates improve accuracy.
How often should it be updated?
Most businesses should update it monthly. Fast-growing, seasonal, or cash-tight companies may need weekly updates.
What is the difference between forecasting and budgeting?
A budget shows the original plan; forecasting updates it using recent results, costs, and expectations.
Can a spreadsheet be used?
Yes. A spreadsheet suits simple finances; software may help when accounts, entities, users, or reporting needs increase.
How far ahead should a small business forecast?
Use 12 months for general planning and a weekly 8-to-13-week view for immediate obligations.
Editorial note: This article provides general business information. Forecasting assumptions, tax treatment, and reporting requirements vary by jurisdiction and business structure.
