Picture the last hour before a set of accounts goes out. The workpaper's done. Your Excel figures tie to the trial balance you pulled on Monday. Then someone opens Xero to check one thing, and the balance has moved. A client recorded a transaction on Wednesday. Now nothing agrees, and you're re-exporting at 4:45 pm with a reviewer waiting.

If that feels familiar, sit with this for a second: you didn't make a mistake. Your numbers were right when you keyed them. They just stopped being right, and nothing in Excel told you.

That's the real problem with an export-based workflow. It has nothing to do with how careful you are and everything to do with timing.

Why the numbers drift

An export is a photo. It captures Xero at one moment and freezes it. The second a client posts a journal, fixes a coding error, or reconciles a new batch, the photo is out of date. Your Excel copy keeps showing the old number as if it were still true.

There's no warning. Excel doesn't know the source has moved. So the gap sits there until someone ties the workbook back to Xero, usually at review, usually when there's the least time to fix it.

The instinct is to work harder. Check the export twice. Re-pull before sign-off. Add a note about when the data was current. All of that helps a little. None of it fixes the real issue. The workbook holds a copy, and a copy goes out of date the moment Xero changes. No amount of careful copying stops that.

Stop copying, start connecting

The fix is to stop exporting a snapshot and connect Excel straight to Xero. The workbook stops holding a copy of last Monday's figures. It reads the live data, and you refresh it whenever you want.

RadiusCore does this with one click. It's an Excel add-in that links Microsoft Excel directly to Xero, with two-way sync. When a client posts something new, you don't rebuild the export. You hit refresh, and the workbook matches Xero as it is right now.

The difference sounds small. In practice it changes the whole rhythm of the job. Checking the data stops being a task you schedule and dread. It becomes a button.

When to refresh

Short answer: whenever the data could have moved.

• Before you start reviewing

• Before sign-off

• Any time a client's been active in the file

With a manual export, doing that every time is a grind, so it gets skipped. With a one-click refresh, it costs a few seconds, so it becomes a habit. That's the whole point. The best control is the one people will actually use.

What you stop worrying about

When data is linked instead of typed, a whole category of error goes away:

• No stale exports sitting in a workbook, pretending to be current

• No transposed columns from a copy-paste

• No figure keyed in wrong and carried through three tabs

Because the sync runs both ways, you can push changes back to Xero from Excel and keep both sides aligned. Fewer review notes. Fewer late surprises.

None of this asks you to change how you work. You're still in Excel, still in Xero, still using the workpapers you know. You've just taken out the one step that was quietly causing the drift.

The takeaway

A workbook is only as current as the last time someone updated it by hand. Connect it instead, and "the last time someone updated it" becomes "the last time you clicked refresh." That's a much easier promise to keep.

If your firm runs on Xero and Excel, RadiusCore is free to try for 30 days, no credit card required. Connect one client, refresh a report, and watch the gap close.

Why don't Xero and Excel numbers match?

Because the export in your workbook is a snapshot from a moment that's passed. The instant a client codes a transaction, posts a journal, or fixes a coding error in Xero, your Excel copy is out of date. Nothing in Excel tells you that. The mismatch usually surfaces at the worst time, when a reviewer ties the workbook back to Xero and finds they don't agree.

Get started

FAQ

• Why do my Xero and Excel figures keep drifting apart? Because a manual export is frozen in time. Any change made in Xero after you exported won't show in Excel until you re-export. A live connection keeps both current.

• Can Excel pull live data from Xero? Yes. With RadiusCore, Excel connects directly to Xero and refreshes with a click.

• Does syncing work both ways? Yes. RadiusCore offers two-way sync, so you can pull data into Excel and push changes back to Xero.