Logiframe

Cash flow in Xero

Every cash view in Xero reads from the same ledger.

Which means the dashboard, the snapshot and the projection are all exactly as reliable as the reconciliation behind them, and no more. Most businesses looking for better cash visibility do not need a different screen. They need the four numbers underneath to be true. This is what Xero shows you, what each view assumes, and what has to be right before any of it is worth acting on.

The four that have to be true How the projection works

The number itself

What a Cash Position Actually Tells You

A bank balance is a fact. A cash position is a calculation, and calculations inherit the quality of what went into them.

Your cash position is the bank balance adjusted for what has been committed but not yet moved: invoices raised and unpaid, bills approved and unpaid, payroll due, tax accrued. Xero can assemble that in seconds. What it cannot do is know about the bill sitting in somebody's inbox, the invoice that was never raised, or the direct debit that stopped being reconciled four months ago.

So the first question about any cash figure is not whether it looks healthy. It is what the figure was built from. A business with $48,000 in the bank and $61,000 of unentered bills is not solvent, it is uninformed.

The tell

If two people in the business would give you two different answers to “how much cash do we have available,” the problem is not that they disagree. It is that the file does not answer the question, so both of them are estimating.

The screens

The Cash Views Xero Gives You

Four places show you cash, each answering a different question. Using the wrong one is how people end up trusting a number that was never meant to carry that weight.

    The dashboard bank widgets. Current balance per account, and the reconcile count. The fastest read in Xero and the shallowest. It tells you what the feed has delivered, not what you owe.

    Business Snapshot. A summary view covering profitability, how quickly you are getting paid and how quickly you are paying. Useful for direction of travel. Not a cash position.

    Short-term cash flow. A projection built from bills and invoices already in the file, with dates, running forward from today. The closest thing Xero has to a forward cash view.

    Aged receivables and aged payables. The two reports that actually determine near-term cash, and the two most people skip because they are less pleasant to read than a balance.

The order matters. Aged receivables and aged payables are the inputs; the projection is the output. A business that reads the projection without reading the aging is reading a conclusion without its evidence.

Xero's Business Snapshot, financial position and cash panel: overall cash balance, average time to get paid of 70 days against average time to pay suppliers of 34 days, with the value of unpaid invoices and unpaid bills.
Screenshot: the financial position and cash panel of Business Snapshot in Xero, shown on a demo organisation. Read the two figures on the right together. Getting paid in 70 days while paying suppliers in 34 is a 36-day hole that has to be funded out of the balance on the left. No forecasting tool closes that gap. Collecting faster does. This is Xero software, not a Logiframe product, and the figures are illustrative.

The prerequisites

Four Things That Have to Be True First

Before any cash view in Xero means anything, four things have to hold. Each one is checkable in a few minutes, and each one fails quietly.

    Every bank and card account agrees to a statement. Not an empty reconcile queue. The Bank Reconciliation Summary, with the calculated balance out by nothing. A feed that stopped delivering shows a clean queue and a stale balance at the same time.

    Every bill is in the file. Approved, coded, dated. A bill sitting in an inbox is a liability that exists in the world and not in your cash position. This is the single most common reason a business is more exposed than its file suggests.

    Aged receivables ties to the control account. If the aging report and the balance sheet disagree, one of them is wrong, and you do not know which until someone checks. Until then, every collection expectation built on that report is built on sand.

    Deferred revenue is not sitting in cash as though it were earned. Money received for work not yet done is an obligation. A business that treats customer deposits as available cash is spending money it may have to give back.

Three of these four are reconciliation work, not analysis. Cash visibility is a bookkeeping outcome. The reporting layer only reveals what the ledger already knows.

The projection

Short-Term Cash Flow, and What It Assumes

Xero’s short-term cash flow view projects forward from what is already recorded. Understanding what it is reading explains both its usefulness and its limits.

It takes the invoices and bills in your file, uses their due dates, and plots the resulting balance forward. Everything it shows you is a consequence of documents that already exist. It is arithmetic on your own data, performed instantly and without judgment.

Three things follow from that.

    It assumes everyone pays on the due date. Your customers do not. If your average collection runs three weeks past terms, the projection is optimistic by three weeks, every time, in the same direction.

    It only knows what has been entered. Recurring costs that arrive as direct debits without a bill, payroll that is not accrued, quarterly tax: if it is not in the file with a date on it, the projection cannot see it coming.

    It projects, it does not model. There is no scenario in it. It answers what happens if everything proceeds as recorded, which is a useful question and not the only one.

Used properly, it is a very good early warning for the next few weeks, because the near term is mostly determined by documents that already exist. Used as a forecast, it will flatter you.

Xero's short-term cash flow projection: total invoices owed, total bills to pay and a projected end balance, a forward balance line over thirty days, and a breakdown listing each upcoming transaction by contact.
Screenshot: the short-term cash flow projection in Xero, shown on a demo organisation. The subtitle states the limit exactly: based on invoices and bills. Every movement in that line comes from a document already in the file, named in the breakdown underneath. Anything not yet entered does not appear, and every invoice is assumed to be paid on its due date. This is Xero software, not a Logiframe product, and the figures are illustrative.

The levers

Where Cash Actually Moves

Cash position is an outcome of four operational habits. None of them is a forecasting exercise, and all of them are visible in Xero.

Invoices leaving on time

The gap between doing the work and sending the invoice is cash you have already earned and not asked for. It is also the easiest thing to fix, and the most commonly broken, because invoicing competes with delivery and delivery always wins. Repeating invoices and quote conversion remove the decision entirely for anything predictable.

A reminder ladder that runs without anyone remembering

Xero sends invoice reminders on a schedule you define, under your own name. Most files have the feature switched off. A configured ladder collects earlier than a person who chases when they think of it, because it never forgets and never feels awkward.

Cash applied to the right invoice

A payment received and not matched leaves the invoice showing as unpaid, which corrupts the aging, which corrupts every collection decision made from it. Partial payments and single receipts covering several invoices are where this breaks.

Bills entered when they arrive, paid when they are due

Entering bills on arrival is what makes the payables side of the cash position real. Paying them on terms rather than on receipt keeps the cash in your account for the period you agreed to. Both require the bill to be in the file.

Where to look in Xero for each
Habit Where it shows What good looks like
Invoices out on time Draft invoices; repeating invoice templates Nothing sitting in draft past the week it was earned
Reminders running Invoice reminders settings Switched on, with a ladder rather than a single nudge
Cash applied Aged Receivables Detail No paid invoices still showing outstanding
Bills entered Bills awaiting payment; the payables control account Aging ties to the balance sheet, with nothing arriving unrecorded
Xero's invoice reminder settings: a ladder of three reminders at seven, fourteen and twenty-one days overdue, with an editor open showing the trigger set to seven days and a message template built from merge fields for contact name, invoice number and amount due.
Screenshot: invoice reminders in Xero, shown on a demo organisation with the reply address masked. Three reminders at seven, fourteen and twenty-one days overdue, each with its own message built from merge fields, sending from your own address. Configured once, it runs on every overdue invoice without anyone deciding to chase. This is Xero software, not a Logiframe product.

The boundary

Where This Stops

Everything above is bookkeeping. It produces a cash position you can act on and a short-term view you can trust. It is not financial strategy.

Scenario modelling, fundraising, covenant planning, capital structure and the conversations that go with them belong to a CFO, fractional or otherwise. That work needs presence, judgment about your market, and a relationship with your bank. We do not do it and we will tell you so in the first conversation.

What we do is make that work possible. A fractional CFO handed a reconciled file with accurate aging spends their time on the decision. Handed an unreconciled one, they spend it reconstructing, at CFO rates.

Questions

Cash Flow in Xero, Answered

Why does my Xero cash flow projection keep being wrong?
Two causes, and they compound. It assumes invoices are paid on their due date, so if your customers run past terms it is optimistic by however long they run. And it only sees what is in the file, so recurring costs that arrive as direct debits without a bill, unaccrued payroll and quarterly tax are invisible to it. Fixing the second is bookkeeping. Living with the first means reading the projection as a best case rather than an expectation.
Does Xero do cash flow forecasting?
It projects rather than forecasts. The short-term cash flow view runs your existing invoices and bills forward using their dates, which answers what happens if everything proceeds as recorded. It has no scenarios and no assumptions you can vary. For modelling beyond that, businesses use a connected forecasting app or a spreadsheet, and both are only as good as the ledger they read from.
My dashboard says we have cash. Why are we short?
The dashboard shows bank balances, not your position. Balance minus approved bills, payroll due, tax accrued and any customer deposits held for work not yet done is the number that matters. Businesses are most often caught out by bills that have not been entered, because an unentered bill is a real obligation that the file cannot see.
How far ahead can I see with Xero alone?
A few weeks, reliably, because the near term is mostly determined by invoices and bills that already exist. Beyond that the projection is extrapolating from documents that have not been raised yet, and its usefulness drops quickly. Anything longer needs assumptions, which means it needs a model rather than a projection.
Do we need a cash flow app on top of Xero?
Only after the file is reconciled and bills are entered on arrival. A forecasting app reading an incomplete ledger produces a more confident version of the wrong number, which is worse than no forecast because people act on it. Once the underlying data is right, an app adds scenario modelling that Xero does not have.
Can you manage this for us?
We run the bookkeeping that the cash position depends on: reconciliation, bills entered on arrival, receivables accurate and aging that ties, closed monthly. Where you want the receivables cycle actively run, reminder ladders configured and running under your name, that is an add-on. We do not do forecasting, modelling or CFO advisory, and where you need those we will say so.
Xero Gold Partner Certified advisors, with Xero as the platform our depth genuinely sits in.
Xero Asia Partner of the Year Recognised by Xero for delivery, not for sales volume.
13+ years, 1,500+ engagements Across accounting outsourcing, ERP and accounting software work.

Next

Where to Go Next

Xero guide Accounts Receivable Invoices out, reminders running, cash applied to the right invoice. Xero guide Accounts Payable Bills entered on arrival, approved properly, paid on terms. Xero guide Bank & Credit Card Reconciliation Why an empty reconcile queue is not an agreed balance. Diagnostic The 32-Point Health Check Whether the four things on this page are actually true in your file. Xero guide Month-End Close Locking a period so the numbers you reported stay the numbers you see. Service Bookkeeping Packages & Pricing The work above, run for you every month, with prices.

Want a cash position you can act on?

Start with whether the four things on this page are true in your file. The 32-point health check answers that in writing, and you keep the findings either way.

Book a free 30-minute call See the 32-point check
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.