You've spent the afternoon in a client's workbook. You've reclassified a few accounts, posted a couple of adjustments, cleaned up a coding error the client left behind. The Excel file is exactly right.

Now you open Xero and do the whole thing again, line by line, so the ledger matches. Same numbers, second time, by hand.

That second pass never shows up on a timesheet, but it's real work. And it's the part a lot of "Xero to Excel" setups still leave you to do yourself.

"Connect Xero to Excel" can mean two very different things. One sends data in a single direction. The other keeps both sides talking.

The gap between them is where a lot of double-handling lives.

Importing pulls Xero data into Excel one way and stops there. Two-way sync also pushes your changes from Excel back to Xero, so the two stay aligned.

For accountants who adjust figures in Excel, that difference has a real cost. One-way import means you do the work twice.

What is two-way sync?

Two-way sync means data moves in both directions between Xero and Excel. You pull a report into your workbook, and when you make a change, you can push it back to Xero. Both stay current without re-keying anything.

One-way import only does the first half. It brings Xero data into Excel and leaves it there. What you do next is your problem; the tool has already done its one job.

The difference sounds small on paper. In practice, it decides whether Excel is a dead end or part of your actual workflow. With import, Excel is where the data goes to sit. With sync, Excel is where you work — and Xero keeps up. You're not managing two copies of the same numbers and hoping they match. There's one set of figures, and it's live in both places.

Why isn't importing Xero data into Excel enough?

Because accountants don't just read the data, they work it. You post an adjustment, reclassify an account, and fix a coding issue. With one-way import, every change has to be re-entered in Xero by hand. You've done the work twice and opened a second chance to make a mistake.

That second data-entry pass is where errors creep in. A transposed figure. An adjustment was applied in the workbook but was forgotten in Xero. A number that's right in one place and wrong in the other. None of these is dramatic on its own, and that's exactly why they're easy to miss.

The knock-on cost is the checking. By month-end, you're not sure which version is correct, so you check both. Then you check them against each other. The time you meant to spend on the client's actual accounts goes into reconciling two files that should never have drifted apart. Two-way sync closes that loop, so there's one version of the truth and nothing to reconcile, because nothing diverged in the first place.

What does this look like day to day?

You're working on a client's file in Excel. You spot an adjustment, make it in the workbook, and push it back to Xero from the same place. No switching apps, no separate data-entry pass. The workbook and the ledger agree because they're connected.

A few examples of where that shows up:

• You're reviewing a trial balance and find a cost coded to the wrong account. You fix it in Excel and push it back. Xero updates. Done — no second trip into Xero to redo what you just did.

• You've built a workbook that a client sends through every quarter. Instead of exporting a fresh report and rebuilding the whole thing, you refresh it with a click, and the new figures drop straight into the layout you already have.

• You manage a handful of entities for one client. Each one's data lives in the same connected workbook, and a single refresh pulls the latest from all of them — no logging in and out of separate orgs.

The common thread: not once do you copy a figure from one window into another. Everything happens in the workbook, and Xero stays in step. That's the part import can't do.

Import vs sync — the short version

Import is a one-time pull. Xero to Excel, and it stops there. It's good for a quick look and useless the moment the numbers change, because it has no idea what they did. To get current data, you export again — and if you'd made changes to the old file, you lose them or have to rebuild them.

Sync is an ongoing connection. Data flows both ways, on demand. You refresh when you want the latest, and you push when you've made a change. The workbook stays live instead of going stale the second you save it. Your formatting, your formulas, your layout — all of it survives a refresh, because you're updating the data inside a workbook you've already built, not downloading a new one each time.

If you only ever glance at the numbers, import is enough. If you edit them — and most accountants do — you want sync.

Where RadiusCore fits

RadiusCore is an Excel add-in that connects Microsoft Excel directly to Xero, with true two-way sync. Pull data in, refresh with a click, push changes back — all without leaving Excel.

Connect a client once, and the connection is shared across the firm, so anyone on your team can open the workbook and refresh it themselves. No re-authenticating, no one person being the bottleneck, because the connection lives on their machine. It works across multiple organisations too, which matters when one client is really five entities.

Best of all, it works with the tools you already use every day. There's no new platform to learn, no exporting and re-importing, no wondering whether Xero and your workbook still agree. They do, because they're connected — and that's the whole idea.

FAQ

What's the difference between importing and syncing Xero data? Importing is one-way: Xero to Excel. Syncing is two-way: changes flow back to Xero as well, so both stay current.

Can you push data from Excel back to Xero? With most connectors, no — they only pull. With RadiusCore's two-way sync, yes.

Why does two-way sync matter for accountants? Because you adjust figures as part of the work. Two-way sync updates Xero automatically instead of you re-keying every change by hand.

Do I have to leave Excel to use it? No. RadiusCore runs inside Excel as an add-in, so pulling data, refreshing, and pushing changes all happen in one place.

Does refreshing wipe out my formatting or formulas? No. A refresh updates the data inside the workbook you've built — your layout, formulas, and formatting stay put.