Cash Flow Forecast: How to Prepare One
You will learn how to prepare a cash flow forecast and calculate the future balance. You will find a data checklist, spreadsheet structure, and updating tips.
A company's cash flow forecast is a plan of future receipts and payments showing how much money will remain at the end of a selected period. When preparing one, you forecast not only amounts but also the expected dates of receiving and spending money, allowing you to spot a potential shortfall in advance [british-business-bank.co.uk].
What is a cash flow forecast and why is it needed
The key question this plan answers is: will there be enough money on the payment date? By listing upcoming payments, you can assess whether expected receipts will cover outflows and prepare for a period when the balance falls [british-business-bank.co.uk].
Without planning, you risk noticing a shortfall only when a payment is due. You then have to urgently decide how to pay employees or suppliers instead of adjusting your payment and purchasing plan in advance.
How a forecast differs from a profit forecast and cash flow statement
A profit forecast projects revenue, costs, and the result. In financial reporting, a cash flow statement shows actual receipts and payments for the reporting period, not future cash movements. These documents differ in purpose and timing [e-tar.lt].
When planning the future balance, the key factor is when the customer will pay. For example, you may record a sale in one month and receipt of the money in the next: a sales entry alone is not yet a receipt [british-business-bank.co.uk].
What data to prepare before you start
First, collect the data needed to determine the amount and payment date:
- Customer debts and expected payment dates.
- Supplier debts and planned purchases.
- Sales plan and customer payment times.
- Inventory needs, salaries, and rent.
- Taxes, investments, and loan payments [icaew.com].
Reconcile the opening cash balance with bank and accounting data. Do not start the calculation with an unverified amount: all subsequent balances will depend on it [apqc.org].
Who should prepare the forecast and how much time to allocate
You can start filling in a simple spreadsheet yourself. If you need a detailed financial model or find it difficult to support your assumptions, it is worth involving an accountant or finance specialist [icaew.com].
There is no single preparation time that applies to everyone. When planning the work, assess data collection, spreadsheet preparation, and checking separately, and clarify who will provide missing information before you begin.
How to prepare a cash flow forecast step by step
The basic sequence is simple: choose a period, plan receipts and payments, then calculate the change in cash. Complete this sequence with checks and an updating procedure [british-business-bank.co.uk].
1. Choose the forecast period and a weekly or monthly interval
Cover at least one full cash cycle: from spending money to receiving it back into the company. There is no universal period for every business [british-business-bank.co.uk].
A monthly view works for general planning, but fast-moving cash may require weekly or even daily detail. Choose an interval that does not hide important payment dates [icaew.com].
2. Prepare an Excel spreadsheet based on a forecast example
To get started, you can review the Innovation Agency's free business plan calculator. It is a Lithuanian starting point for financial planning, but you will still need to prepare your own payment data and assumptions [inovacijuagentura.lt].
In Excel, place periods in the columns, receipt and payment groups in the rows, and include the balances. Use the SUM function for amounts and link balance cells with formulas [resource.download.wjec.co.uk].
| Spreadsheet row | Content or calculation |
|---|---|
| Opening balance | Money at the beginning of the period |
| Total receipts | Sum of all receipt rows |
| Total payments | Sum of all payment rows |
| Net cash flow | Receipts - payments |
| Closing balance | Opening balance + net cash flow |
| Start of next period | Previous closing balance [resource.download.wjec.co.uk] |
3. Plan receipts according to expected customer payment dates
Use invoice due dates and customers' actual payment times. If a customer usually pays late, do not treat the contractual due date as a guaranteed receipt date [icaew.com].
In practice, broader debt-management projects base payment expectations on schedules, payment history, and recorded promises to pay, while also assessing disputes and customer responses.
4. Include future payments according to their due dates
Allocate outflows according to when the money will be paid, not only according to cost allocation. Check these groups:
- Suppliers, raw materials, and operating expenses.
- Salaries, rent, and marketing expenses.
- Taxes and bank charges.
- Asset purchases and loan payments [british-business-bank.co.uk].
5. Calculate the future cash balance
Apply the formula: closing balance = opening balance + receipts - payments. Move the resulting closing balance to the start of the next period to see cash movements continuously [resource.download.wjec.co.uk].
6. Check the assumptions and whether the forecast is realistic
Record what the key amounts and dates are based on. Check data completeness, duplicate entries, and outdated information, then compare previous forecasts with actual cash flows and test an adverse scenario [apqc.org].
7. Establish a forecast updating procedure
Assign a responsible person and agree on the review frequency. Define who will update the data, who will check the assumptions, and who will approve changes [apqc.org]. If you use payroll payment system data, assign someone to check it as well.
Review the data regularly, especially when the company's operations change. There is no single interval suitable for every company, so match the frequency to your payment rhythm [icaew.com].
8. Update the forecast if receipts are delayed or expenses increase
Move a delayed receipt to its new expected date, update increased outflows, and recalculate the balances. Once you have more accurate estimates, do not leave the previous assumptions in the spreadsheet simply because they showed a more favourable result [british-business-bank.co.uk].
9. Automate forecast updates: data and integration requirements
Projects of this kind typically require a reusable model: actual results are entered regularly and the forecast period rolls forward. A shorter cash plan and longer-term financial projections are coordinated separately from the update schedule; monthly updates and a weekly view of debts and planned transactions are common. If the company uses a business management system, specify which of its data will be transferred to the model.
An automation project should cover these areas:
- Data connections. Projects connect bank files and business systems using Power Query or an API to reduce repetitive exporting and importing.
- Unrecognised transactions. Different bank file structures and unfamiliar transaction types cause discrepancies, so their review and checks of historical data and assumptions are planned.
- Use of funds. Requirements include separating the bank balance from funds allocated to operating expenses, materials, subcontractors, salaries, and taxes, as well as monitoring temporary borrowing between accounts.
- Scenarios and actuals. Clear assumptions, alternative operating scenarios, and comparisons of planned and actual cash flows are required.
- Broader financial model. Larger projects also prepare profit and balance sheet projections, and plan inventory, delivery times, and the results of individual business units.
You do not have to build a custom spreadsheet: you can also commission configuration of ready-made software, historical data entry, settings checks, and preparation of results for internal use.
In European public procurement, broader accounts-payable automation is purchased together with order initiation processes, secure document submission, data validation, and integration with existing systems. In commercial projects, it is also linked to extracting data from invoices and receipts.
Examples from Irish public procurement include a healthcare procurement organisation serving hospitals. Commercial accounts-receivable automation projects also include recruitment agencies. These examples reflect the process needs of specific sectors, not a forecasting solution suitable for everyone.
Common mistakes: unsupported dates, missed payments, and duplicate entries
Before using the result for decision-making, perform a quick check:
- Are payment dates supported by a written rationale?
- Are there any missed, outdated, or duplicate entries?
- Does the opening balance match verified data?
- Are differences between the plan and actuals explained [apqc.org]?
Pay particular attention to the link between invoices and bank transactions: the same receipt should not remain recorded both as received and still expected. This is a practical rule for checking data duplicates.
Is a cash flow forecast mandatory for your company
The Law on the Financial Reporting of Companies and Groups of Companies regulates the composition of financial statements and applicable exemptions. It does not create a general obligation for all companies to prepare a separate management forecast; do not confuse it with a cash flow statement [e-tar.lt].
If you are preparing the document to obtain financing, check the specific financing requirements: what period, level of detail, and support for assumptions are required.
What to assess when comparing forecast preparation proposals and prices
The Innovation Agency's business plan calculator is free [inovacijuagentura.lt]. This guide does not provide a price range for paid preparation.
When requesting a proposal, define the same scope of work: data preparation, model development, assumption checks, integrations, and subsequent updates. This will let you compare more than just the final proposal amount.
From forecast to action: what to do when money runs short
Turn a negative or insufficient balance into a specific action list:
- Identify when the shortfall begins and which payments cause it.
- Confirm realistic payment dates with customers.
- Assess postponing non-essential purchases and investments.
- Discuss solutions with suppliers and your lender in advance.
- Check options for resolving tax obligations with the State Tax Inspectorate.
What matters is not a positive balance that looks good in the spreadsheet, but well-supported dates and feasible solutions. When you change a payment assumption, recalculate all subsequent periods.
Sources
British Business Bank: Cash flow forecast in 4 steps
TAR: Law on the Financial Reporting of Companies and Groups of Companies (2024)
ICAEW: Cash flow forecasts and inventory (2025)
APQC: How to Create an Accurate Cash Flow Forecast
Innovation Agency: Calculators
WJEC: GCSE Business - Finance
Business development team
Consultants and technologists helping businesses bridge the gap between strategy and implementation - turning digital transformation plans into operational reality.