Three-Way Forecasting with Xero: One Plan, Three Connected Statements

You plan a new hire, expect a stronger sales month and schedule an equipment purchase. Your profit forecast looks reasonable. But does the cash forecast include the purchase? Does the balance sheet show the new asset? And what happens when a customer pays a month late?

Three-way forecasting means answering those questions through one connected plan, not three spreadsheets that happen to share a heading.

One business event should have one consistent financial story. The three statements are different views of that story.

What “three-way” actually means

A profit and loss forecast shows expected revenue, expenses and profit over a period. A cash flow forecast shows expected money moving in and out. A forecast balance sheet shows the resulting assets, liabilities and equity at a point in time. Xero’s financial statements guide explains the underlying reports.

Connecting them matters because changing a sales or payment assumption can affect more than one statement. A delayed customer receipt, for example, can reduce forecast cash while leaving more money in receivables.

Start from a reconciled set of actuals

For a business using Xero, a practical starting pack is a profit and loss report, a balance sheet and the supporting customer and supplier balances, all at a consistent cut-off. Check the accounting basis and account mapping before extending the numbers forward.

The opening position should be explainable. Unreconciled cash, stale receivables or a misclassified loan will travel into the forecast unless someone resolves or explicitly adjusts them. Keep forecast adjustments visible; do not silently rewrite accounting actuals to make a model work.

Xero’s cash flow forecasting guide describes both short-term projections and the use of connected forecasting applications for more detailed planning. This article focuses on the model logic, rather than assuming any particular plan or integration has every required feature.

A worked example that connects all three statements

Illustrative example, not MagicHub customer data. All figures below are A$000. Tax and GST are excluded. The business has no inventory, supplier payables, owner distributions or other transactions. Equipment is shown at net carrying value.

Opening assets are cash of 60, receivables of 20 and equipment of 40: a total of 120. They are funded by a loan of 30 and equity of 90.

During the month, the business earns and invoices 50, collects 45 from customers and incurs and pays 30 of operating expenses. It buys equipment for 12 in cash, recognises total depreciation of 2 for the month and repays 3 of loan principal.

The profit and loss forecast

Illustrative monthly profit — A$000

Item	Amount
Revenue	50
Operating expenses	−30
Depreciation	−2
Profit before tax	18

The cash flow forecast

Illustrative monthly cash movement — A$000

Item	Amount
Opening cash	60
Customer collections	45
Operating payments	−30
Equipment purchase	−12
Loan principal repayment	−3
Closing cash	60

The closing balance sheet

Illustrative closing financial position — A$000

Item	Opening	Movement	Closing
Cash	60	0	60
Receivables	20	5	25
Equipment, net	40	10	50
Total assets	120	15	135
Loan	30	−3	27
Equity	90	18	108
Liabilities plus equity	120	15	135

The business earns 18 of profit, but cash does not increase. Collections lag revenue by 5, depreciation adds back 2 as a non-cash expense, equipment consumes 12 and principal repayments consume 3. The check is 18 + 2 − 5 − 12 − 3 = 0.

The balance sheet also reconciles. Receivables are 20 + 50 − 45 = 25. Equipment is 40 + 12 − 2 = 50. The loan is 30 − 3 = 27. Equity is 90 + 18 = 108. Assets of 135 equal liabilities and equity of 135, consistent with the accounting equation.

Now change one assumption

Suppose 10 of the expected customer collections move into the following month, with all other assumptions unchanged and no impairment or credit adjustment. Closing cash falls from 60 to 50. Receivables increase from 25 to 35. Profit remains 18.

Total assets remain 135 because this is a timing shift between receivables and cash. That is exactly the kind of connection the model should produce automatically from its formulas, rather than require someone to manually edit in three places.

The management question is whether cash of 50 is enough for the obligations ahead. The accounting question is whether the entries remain consistent. A useful forecast answers both, without pretending they are the same question.

Build around business drivers, not percentage guesses

For the first version, choose the few assumptions that materially change the decision. These might include the start date of a contract, the customer’s collection timing, a hiring date, a supplier payment schedule or the timing of equipment purchases.

Separate delivery from billing and collection. The date you win a contract is not necessarily the date you earn all the revenue, send the invoice or receive the money. Our pipeline-to-cash guide walks through that distinction.

Checks before the forecast reaches a decision-maker

1. The opening position agrees to the chosen actuals. Any adjustment is documented.
2. The balance sheet balances in every forecast period. A balancing “plug” is not an explanation.
3. Cash rolls forward correctly. The cash flow closing balance agrees to balance sheet cash.
4. Supporting schedules reconcile. Receivables, payables, equipment and debt have explainable movements.
5. Scenarios change drivers consistently. Moving a collection date does not create or erase a sale.

A model can balance and still contain poor assumptions. These checks establish internal consistency; they do not prove customer payment dates or sales expectations are correct.

Start with the decision, then build the model

Choose a real question: can we hire before the new contract starts, fund a purchase or manage slower collections? Build the smallest connected model that can test it, then add detail only where it improves the answer.

For immediate payment timing, pair the longer-range model with a 13-week cash forecast. For a plain-English explanation of the relationship, read profit versus cash flow.

Explore MagicHub and our approach to connecting business plans with the numbers behind them.

General business education only; not accounting, tax, legal or financial advice. All worked figures are fictional. Confirm accounting treatments, model assumptions and software capabilities for your circumstances.