What is the difference between direct and indirect cash flow forecasting?

The direct method builds cash flow by listing actual cash receipts and payments - customer collections, supplier payments, wages, tax. The indirect method starts with net profit and adjusts for non-cash items (depreciation, accruals) and changes in working capital (debtors, creditors, inventory). Direct is more accurate for short-term forecasts; indirect ties back to the P&L for integrated models.

Which method do Australian businesses use most?

Most Australian SMEs use the direct method for internal cash management because it matches how they actually see money move in and out. The indirect method is more common in three-way integrated models and in statutory reporting, where it links the P&L to the balance sheet. Many businesses use both - direct for weekly cash management and indirect for monthly board reporting.

How does GST affect cash flow forecasting?

GST creates a timing difference between when you invoice (or are invoiced) and when the GST is paid or refunded by the ATO. In a direct method forecast, include GST on each receipt and payment line as they occur, then show the net BAS settlement as a separate line item in the months you lodge. In the indirect method, GST is captured in the working capital movements through debtors and creditors.

How do PAYG withholding and super affect the forecast?

PAYG withholding is collected from employee wages but remitted to the ATO on a different schedule (monthly or quarterly depending on your withholding amount). In a direct forecast, show wages at gross cost and PAYG remittance as a separate payment line. Superannuation guarantee at 11.5% must be paid quarterly by the 28th day after quarter end - a common cash flow trap for growing businesses.

How often should I update my cash flow forecast?

For the direct method, weekly updates are standard - pull actual bank data, compare to forecast, and roll forward. The indirect method forecast is typically updated monthly alongside management reporting, since it relies on P&L and balance sheet data that is not available in real time.

Cash Flow Forecasting in Excel: Direct vs Indirect Method Explained

There are two ways to forecast cash flow in Excel. The direct method lists actual cash receipts and payments. The indirect method starts with profit and adjusts for non-cash items and working capital changes. Neither is better than the other - they serve different purposes.

This post explains both methods, walks through how to build each one, and covers the AU-specific adjustments (GST, PAYG, super) that make the difference between a useful forecast and a misleading one.

The Direct Method: Build from Cash Transactions

The direct method is intuitive. You list every cash inflow and outflow the business expects, by week or month, and the closing balance is your starting balance plus all inflows minus all outflows.

Structure

Set up columns for each week (13 weeks is standard) with these row groups:

Cash Inflows:

Customer receipts (cash sales plus debtor collections)
GST refunds from BAS lodgement
Other income (interest, government grants, asset sales)

Cash Outflows:

Supplier payments (stock, materials, operating expenses)
Employee costs (wages net of PAYG, plus super contributions)
PAYG withholding remittance
BAS payment (net GST owed)
Rent and lease payments
Loan repayments
Capital purchases
Owner drawings or dividends

Net movement = total inflows minus total outflows

Closing balance = opening balance plus net movement

Why the Direct Method Works for SMEs

The direct method matches how business owners actually see cash move. You know when a customer usually pays, when the BAS is due, and when the quarterly super bill lands. Building the forecast by listing these actual movements makes it a practical management tool rather than an accounting exercise.

The weakness is that it does not link to the P&L. A profitable month can show negative cash flow if a large debtor is overdue, and the direct method alone will not tell you why. That is where the indirect method adds value.

The Indirect Method: Start from Profit

The indirect method begins with net profit and adjusts to arrive at cash flow. It answers the question: if we made this much profit, why is the cash balance different?

The Adjustments

Non-cash items (add back):

Depreciation and amortisation
Provisions and accruals
Unrealised gains or losses
Deferred tax

Working capital changes:

Increase in debtors = cash not yet collected (subtract)
Increase in creditors = cash not yet paid (add back)
Increase in inventory = cash spent (subtract)
Decrease in debtors = cash collected (add back)
Decrease in creditors = cash paid (subtract)

Structure the Worksheet

Create three sections:

Operating activities - net profit, add back non-cash, adjust working capital
Investing activities - asset purchases and sales
Financing activities - loans, equity, dividends

Operating cash flow is the key number. If a business is consistently profitable but operating cash flow is negative, there is a working capital problem that needs attention.

When to Use the Indirect Method

The indirect method is essential for three-way integrated models where the P&L, balance sheet, and cash flow statement must balance. It is also the format banks and investors expect to see in financial reports.

For day-to-day cash management, it is less useful because the information arrives too late - you need month-end accounts to calculate it, by which time the cash has already moved.

AU-Specific Adjustments

GST in Cash Flow Forecasts

GST creates a timing difference that can trip up both methods if not handled correctly.

In the direct method, include GST on each receipt and payment. A $110 customer payment includes $10 GST. Record $100 revenue and $10 GST collected. When you lodge your BAS (monthly or quarterly depending on your GST turnover), show the net payment or refund as a line item in the month it is due.

In the indirect method, GST is captured through the movement in debtors and creditors, provided your balance sheet includes GST control accounts. The net BAS payment or refund flows through as a movement in the ATO payable or receivable balance.

PAYG Withholding and Super

PAYG withholding is deducted from employee wages but remitted to the ATO on a schedule that depends on your total withholding: monthly if you withhold $25,000+ per year, quarterly otherwise.

In the direct method, show wages at gross cost and PAYG remittance as a separate line. In the indirect method, wages accrual already includes PAYG, and the timing difference is captured through the ATO payable balance.

Superannuation guarantee at 11.5% is due quarterly by the 28th day after the quarter ends. This is a common cash flow surprise for growing businesses. In a direct forecast, add a super payment line in the months following each quarter end.

Which Method Should You Use?

Use the direct method if you need a practical weekly cash management tool and you or your client runs the business day to day.

Use the indirect method if you are building an integrated three-way model for investors, banks, or board reporting.

Use both if you need to reconcile the operational cash view with the financial reporting view. Many businesses run a direct forecast for weekly management and an indirect cash flow statement for monthly board packs.

Simplifying the Build in Excel

Whichever method you choose, keep the model structure clean:

One assumptions section for all drivers (payment terms, tax rates, super rate)
Separate the cash flow calculation from the dashboard
Use named ranges for any input that changes
Add a simple variance column to compare forecast to actual

The best forecast is the one you actually update. A simple direct method forecast updated weekly is worth more than a sophisticated indirect model reviewed quarterly.

Next Steps

If you are building cash flow forecasts regularly, the next step is connecting them to a full three-way model that integrates P&L, balance sheet, and cash flow. The three-way financial models guide covers that progression. For automating data feeds into your forecast, the automated cash flow forecast with Power Query post shows how to connect live bank data.

For a full overview, see the Financial Modelling in Excel: The Complete Guide for Australian Businesses (2026).