Cash flow forecasting methods and tools for Hong Kong companies

Cash Flow Forecasting Methods and Tools for Hong Kong Companies

A cash flow forecast projects the cash entering and leaving a business over a defined period. For a Hong Kong company, the forecast serves two distinct purposes. It supports day-to-day management decisions about liquidity and working capital, and it feeds directly into the going concern assessment that the statutory auditor must perform.

Cash Flow Forecasting for Hong Kong Companies

Cash flow forecasting for Hong Kong companies must reconcile two accounting frameworks. Statutory financial statements are prepared on an accrual basis under HKFRS, recognising revenue when earned and expenses when incurred, regardless of cash movement. A cash flow forecast tracks actual cash movements. The skill lies in converting accrual-based management accounts into a projected cash position directors can use for spending and borrowing decisions.

A forecast starts with the opening cash balance. It adds expected receipts from accounts receivable and other income. It then deducts expected payments for accounts payable, salaries, rent, and tax. The result is a closing balance. The period covered is 12 months. For companies with tight liquidity, break the first three months into weekly or daily intervals.

Hong Kong Cash Flow Forecast Template

A Hong Kong cash flow forecast template should include line items reflecting local business realities. The template must capture:

• Receipts from trade debtors, categorised by expected payment terms (30, 60 or 90 days)
• Other operating receipts such as refunds of deposits or government subsidies
• Payments to trade creditors, again by expected terms
• Salaries and Mandatory Provident Fund contributions
• Rent and rates
• Professional fees for the statutory audit and tax filing
• Profits tax instalments payable under the tax demand note
• Capital expenditure on fixed assets
• Loan repayments and interest
• Director’s remuneration and dividends declared

Include a column for budget vs actual comparison once the period has passed. This comparison helps directors refine their assumptions for the next forecast cycle.

Cash Flow Forecasting Methods Hong Kong

Two methods are used for cash flow forecasting methods Hong Kong companies adopt: the direct method and the indirect method.

Direct method. The direct method lists each expected cash receipt and payment by source and use. It is the more intuitive approach and is preferred for short-term operational forecasts. The direct method requires detailed input from the sales and purchasing teams. It works best when the company has reliable accounts receivable and accounts payable ageing reports.

Indirect method. The indirect method starts with the net profit from the management accounts and adjusts for non-cash items such as depreciation, changes in working capital, and provisions. This method is used for the cash flow statement in the statutory financial statements because it ties directly to the accrual-based profit and loss account. For forecasting purposes, the indirect method is useful when the company has stable profit margins and predictable working capital cycles.

Many Hong Kong SMEs use a hybrid approach: the indirect method for the first three months of the forecast and the direct method for the remaining nine months. The accuracy of detailed receipt and payment data diminishes over longer horizons.

Cash Flow Projection Hong Kong SME

A cash flow projection Hong Kong SME prepares must be realistic about payment behaviour. Trade debtors often pay later than the stated terms. Trade creditors may be stretched by the company itself. The projection should include a sensitivity analysis that shows what happens to the cash balance if debtors pay 15 days late or if a major customer delays payment by 30 days.

The projection also feeds into the going concern assessment. Under HKFRS, directors must evaluate whether the company can continue as a going concern for at least 12 months from the date of approval of the financial statements. The auditor will review the cash flow projection as part of this assessment. If the projection shows a negative cash balance within the forecast period, the directors must disclose the material uncertainty and explain how they intend to address it.

How the Forecast Differs From Management Accounts

Management accounts are prepared on an accrual basis and show the company’s financial performance and position at a point in time. They include non-cash items such as depreciation, accrued expenses and prepayments. The cash flow forecast shows only cash movements and ignores non-cash entries.

A company that relies solely on its management accounts to assess liquidity can be misled. The management accounts may show a healthy profit. But if the accounts receivable balance is growing faster than cash collections, the company may still run out of cash. The cash flow forecast reveals this gap.

Record Retention and the Seven-Year Rule

The Companies Ordinance (Cap. 622) requires a company to keep accounting records for seven years. The cash flow forecast, while not a statutory record in itself, is part of the supporting documentation that the auditor may request when reviewing the going concern assumption. Retain the forecast, the underlying assumptions and the budget vs actual comparisons for the full seven-year period.

The records may be kept outside Hong Kong, but the company must send to Hong Kong accounts and returns sufficient to disclose its financial position with reasonable accuracy. Most companies keep the forecast files with the monthly close documentation in Hong Kong.

Tools for Building the Forecast

Spreadsheet software such as Microsoft Excel remains the most common tool for Hong Kong SMEs. A well-structured spreadsheet allows the user to link the forecast to the bank reconciliation, the petty cash log and the accounts receivable ageing report. Cloud accounting platforms such as Xero and QuickBooks include built-in cash flow forecasting modules that pull data directly from the accounting records. These modules update automatically as invoices are raised and bills are paid, reducing the risk of manual error.

For companies that prepare consolidated financial statements for a group, prepare the forecast for each entity and then consolidate, eliminating intercompany receipts and payments.

Connecting the Forecast to the Statutory Audit

The statutory auditor will request the cash flow forecast as part of the audit planning. The auditor uses the forecast to:

• Assess whether the company is a going concern
• Identify periods of tight liquidity that may affect the valuation of assets
• Evaluate the recoverability of accounts receivable
• Test the reasonableness of the directors’ profit forecasts

The auditor will also compare the forecast to the actual cash flows that occurred during the year. Significant variances may indicate that the company’s internal controls over cash management need improvement.

The directors’ report must include a statement that the financial statements have been prepared on a going concern basis. The cash flow forecast is the primary evidence that supports this statement. If the forecast shows a cash shortfall, the directors must document the planned actions. These may include a loan from a shareholder, a reduction in capital expenditure or a renegotiation of payment terms with creditors.

Practical Steps for Building the Forecast

1. Start with the bank reconciliation to establish the opening cash balance.
2. Extract the accounts receivable ageing report and estimate collection dates.
3. Extract the accounts payable ageing report and estimate payment dates.
4. Add known fixed payments: salaries, rent, MPF, insurance, audit fees.
5. Add tax payments based on the latest profits tax assessment.
6. Add planned capital expenditure.
7. Run the forecast and review the projected cash position at each month end.
8. Compare the forecast to actual results each month and adjust the assumptions.

The monthly close process is the natural time to update the forecast. The management accounts for the month just ended provide the actual cash flow data. The budget vs actual analysis highlights where the forecast assumptions need revision.