Cash Flow Forecast: Meaning, Formula, Steps and Example

What Is a Cash Flow Forecast?

A cash flow forecast estimates the cash a business expects to receive and pay during a future period. It may use daily, weekly, or monthly columns depending on how closely the business needs to monitor liquidity.

Cash Flow Forecast Formula:

Net cash flow = cash inflows - cash outflows

Closing cash = opening cash + net cash flow

A negative closing balance warns that expected payments will exceed the available cash under the assumptions used.

For short-term forecasting, record a transaction on the date it is expected to change the bank or cash balance. For example, if a customer’s invoice is due on 10 October but the customer usually pays 20 days late, show the receipt around 30 October.

For entities applying Indian Accounting Standards (Ind AS), Ind AS 7 classifies cash flows as operating, investing, or financing activities. It permits the direct and indirect methods for reporting operating cash flows and encourages the direct method.

A management forecast is not an Ind AS 7 cash flow statement. However, the same categories can make a forecast easier to review. The direct approach is usually clearer for short-term planning because it lists the cash expected from customers and the payments expected to leave the business.

Profit is also different from cash. Under Ind AS 115 , revenue is recognised when or as the business delivers the goods or services it promised. The customer may pay before or after that point. A profitable business can therefore face a cash shortage when customers have not yet paid.

Before scheduling GST, calculate the expected cash payment. Input tax credit is GST paid on eligible business purchases that can be used to reduce GST payable. The electronic cash ledger records amounts deposited on the GST portal for tax and related dues. Forecast the amount remaining after eligible credits, available cash-ledger balances, and other adjustments.

1. Set the Horizon and Time Interval

Use weekly columns when exact payment timing matters or cash is tight. A rolling 13-week forecast is commonly used for short-term liquidity management.

Monthly columns may be more suitable for a 12-month planning view covering inventory, tax, hiring, or large asset purchases. These periods are planning conventions, not statutory requirements.

2. Confirm the Opening Cash Position

Start with the balances shown in your bank accounts and verify them through a bank reconciliation . Then add cash in hand and exclude restricted, blocked, or uncleared amounts.

An incorrect opening balance affects every later period, even if the receipt and payment estimates are otherwise accurate.

3. Place Receipts on Realistic Collection Dates

Use bill-wise accounts receivable , agreed credit terms, and each customer’s actual payment behaviour.

Separate receipts supported by invoices, orders, or contracts, rather than by uncertain sales estimates. If the collection date is unclear, place the amount in a downside scenario instead of treating it as certain cash.

4. Place Payments on Expected Bank Dates

Schedule each payment for the date on which it is expected to leave the bank account. Check supplier bills, payroll, rent, tax, insurance, loan instalments, annual renewals, asset purchases, and other committed payments.

Review standing instructions and automatic debits separately. They are easy to miss because they do not require a fresh payment entry each month.

5. Calculate Closing Cash and Test Scenarios

Subtract total payments from total receipts for each period. Add the result to opening cash and carry the closing amount into the next period.

Prepare at least a base case and a downside case when the business depends on uncertain collections. The downside case could assume that receipts arrive later or are lower than expected.

6. Replace Forecast Figures With Actuals

At the end of each period, replace forecast figures with actual bank movements. Classify each difference as:

• A timing difference
• An amount difference
• A missing or duplicated item
• A cancelled or newly added transaction

Add a new period at the end so the forecast continues to cover the same planning horizon.

Worked Cash Flow Forecast Example

Consider a trading business with opening cash of ₹1,50,000. Customers pay 40% of each month’s gross billings in the same month and the remaining 60% in the following month.

The previous month’s billings were ₹5,00,000, so the business expects to collect ₹3,00,000, or 60%, from those billings in Month 1. Gross billings for Months 1 to 3 are ₹6,00,000, ₹7,00,000, and ₹8,00,000. All amounts include GST.

Gross billings increase by 33.33%, from ₹6,00,000 to ₹8,00,000, but cash falls in every month. At the end of Month 3, ₹4,80,000 of that month’s billings remains uncollected while a larger stock payment has already left the business.

The forecast therefore identifies a ₹20,000 shortage before Month 3 ends. Management can use that warning to accelerate collections, renegotiate the stock payment date, reduce the purchase, or arrange an approved short-term loan or credit line.

Stress-Test the Collection Assumption

If collections are 10% lower while payments remain unchanged, closing cash falls to ₹46,000 in Month 1, -₹33,000 in Month 2, and -₹2,12,000 in Month 3. The cash shortage now appears in Month 2 instead of Month 3, giving the business one month less to respond.

Indian Payment Dates to Include

The following are standard payment dates. Notifications, holidays, filing profiles, or case-specific provisions may change the applicable date, so check the relevant portal before payment.

These rules come from different laws and took effect at different times. The Quarterly Return Monthly Payment (QRMP) scheme took effect on 1 January 2021 under Central Board of Indirect Taxes and Customs (CBIC) Circular No. 143/13/2020-GST . The Finance Act, 2023 added Section 43B(h) to the Income-tax Act, 1961, effective 1 April 2024. 

From 1 April 2026, the Income-tax Act, 2025 carries the corresponding tax deduction rule in Section 37(2)(g). The 15-day and 45-day supplier payment limits remain in Section 15 of the Micro, Small and Medium Enterprises Development Act ( MSMED Act ); Section 37(2)(g) concerns the tax year in which an overdue amount can be deducted, generally the year it is actually paid.

Accuracy Controls for a Reliable Cash Flow Forecast

After preparing the forecast, apply these controls before using it for payment or funding decisions.

These controls do not replace the forecasting process. They test whether the completed forecast is current, internally consistent, and suitable for management decisions.

Using BUSY Records as Forecast Inputs

BUSY accounting software provides bill-wise receivable and payable tracking, customer credit limits and alerts, bank reconciliation, cash-flow and fund-flow statements, and payment-reminder tools.

These records provide useful inputs for a cash flow forecast, including current bank balances, expected customer collections, supplier dues, and past payment patterns. Use them to prepare a weekly or monthly forecast and update it as invoices are paid, new bills are recorded, or bank balances change.

Businesses can start a free trial or request a BUSY demonstration to explore the accounting records and controls that support cash planning.

Conclusion

A cash flow forecast helps management see when available cash may fall short of upcoming payments. Its value depends on current records and realistic assumptions. Start with a 13-week forecast using reconciled bank balances, expected customer receipts, and known payments. Update it every Friday, compare it with actual cash movements, and revise the coming weeks when dates or amounts change.