Cash flow visibility for multi-branch businesses: a practical forecasting guide

Profitable companies still get into trouble when they cannot see their cash. Multi-branch and multi-company businesses in the Philippines face extra complexity: collections arrive through many branches and banks, customers pay with post-dated checks, suppliers are paid by checks that clear days later, and payroll for thousands of employees lands twice a month. Cash flow visibility means knowing today's cash position and the next 13 weeks with confidence.

Two views of cash

Building the daily cash position

• Balances per bank account, per company, updated daily
• Collections deposited today and in transit
• Checks issued but not yet cleared
• Committed payments for today and tomorrow

Assign a treasury owner to publish the position every morning.

Building a 13-week cash forecast

The 13-week forecast uses known data first and estimates second.

Cash in

• Receivables by expected collection date (from aging and counter receipts) (AR management)
• Post-dated checks on hand by date (PDC guide)
• Expected POS and cash sales by branch, based on recent averages
• Other inflows: loan proceeds, asset sales

Cash out

• Payables by due date and planned payment runs (AP process)
• Checks issued not yet encashed
• Payroll and government contributions on their dates
• Taxes and recurring obligations (rent, utilities, loan amortization)
• Planned capital expenditures

Net position = opening cash + cash in − cash out, week by week.

Sample forecast layout

Week 3 shows a dip as payroll and taxes coincide. Seeing it two weeks ahead allows options: accelerate collections, reschedule non-critical payments or arrange a credit line.

Improving forecast accuracy

1. Compare forecast to actual every week and record the variance by line.
2. Use payment behavior, not terms, to predict collections from each customer.
3. Apply a bounce rate to PDCs based on history.
4. Get operational inputs: large purchases and projects planned by operations.
5. Keep it rolling: drop the past week and add a new week every week.

Levers to improve cash

• Faster invoicing and counter receipt follow-up
• Deposit PDCs on time and push customers to bank transfer
• Align supplier payment runs with collection patterns
• Reduce slow-moving inventory (inventory valuation)
• Approve capital spending against the forecast

Managing many bank accounts

Groups often hold dozens of bank accounts across companies and banks. To keep control:

• Maintain a register of every account with its purpose, signatories and online access users
• Close dormant accounts to reduce risk
• Sweep or transfer excess branch collection balances to main operating accounts on a schedule, within the rules for intercompany transactions
• Review signatories and online banking users whenever people change roles

Fewer, well-understood accounts make both the cash position and the forecast more reliable.

Data you need in one place

Forecasting fails when every input is in a different spreadsheet. The biggest improvement is connecting receivables, PDCs, payables, check monitoring and payroll in one system, so the forecast updates from transactions.

Cirquolus Financial management connects payables, receivables, customer aging and check monitoring with purchasing and sales; accounts receivable tracks post-dated checks; and payroll schedules salary obligations across companies and branches.

Frequently asked questions

What is a 13-week cash flow forecast?

A rolling weekly forecast of cash receipts and payments for the next 13 weeks, used to spot shortfalls and plan actions early.

How often should a cash forecast be updated?

Weekly for the 13-week forecast, and daily for the cash position.

What is the difference between cash flow and profit?

Profit records income and expenses when earned or incurred; cash flow records when money actually moves. Timing differences can make a profitable company short of cash.

Who should own the cash forecast?

Treasury or the finance head, with inputs from collections, AP, payroll and operations.