Does Xero’s fixed asset register really work?

[3 min read]

An accountant we collaborate with recently told us that, in their experience, it did not.

Their team used an external spreadsheet to record fixed assets and calculate depreciation for a mutual client. This is common practice and provides a familiar working paper for the year-end accounts.

As the client’s bookkeepers, however, we work with the live Xero file throughout the year.

We had configured the fixed asset register so that book depreciation could be calculated and posted within Xero as part of the ongoing bookkeeping process.

This meant that, by the time the accountant was preparing the year-end accounts, much of the work had already been completed.

 

The information was already in Xero

The depreciation figures were available through two reports:

  • The Depreciation Schedule shows movements, values and book depreciation.

  • The Fixed Asset Reconciliation compares the register with the associated balance-sheet figures and identifies any difference.

The accountant’s spreadsheet and Xero were therefore producing substantially the same information.

That was why we suggested comparing the two and, once everyone was satisfied that Xero was accurate, retiring the spreadsheet.

Our intention was not to question the accountant’s process or expertise. It was to avoid their team recreating information that was already available for review.

 

The setup requires expertise

Of course, removing the spreadsheet only makes sense if the fixed asset register can be relied upon.

The register is not a magic button.

The start date, asset types, account mappings, depreciation methods and opening balances must all be correct. Existing items also need to be entered accurately, with their cost, accumulated depreciation and net book value reconciled to the balance sheet.

A reliable process is then needed for registering new purchases, running depreciation and dealing with changes and disposals.

This initial work requires time, expertise and careful checking. However, it is largely a one-off investment.

 

Set it up once, then keep saving time

Once the register has been configured and reconciled, Xero can calculate and post book depreciation within the accounting system.

The register still needs to be maintained and reviewed, but there is no need to repeat the full calculation in a separate spreadsheet every reporting period.

That can remove duplicated work:

  • Each month, when depreciation is calculated and posted

  • Each quarter, when management accounts and balance-sheet figures are reviewed

  • Each year, when the accountant prepares the year-end accounts

Spending time getting the setup right once can therefore create ongoing savings month after month and year after year.

 

Accountants and bookkeepers bring different expertise

This situation also illustrates how accountants and bookkeepers can complement one another.

Accountants bring year-end, tax and advisory knowledge. Bookkeepers may spend more time with the live Xero file and the practical detail of how transactions and reports flow through it.

Used collaboratively, both perspectives can improve the system.

Automation does not replace the accountant’s professional judgement or responsibility. It removes repeatable calculation and posting work, providing reliable information for the accountant to review.

The professional work remains important. The duplicated administration does not.

 

Practical support for accounting firms

Accounting firms understandably concentrate much of their time on compliance, year-end accounts, tax and advisory work. They may not have the capacity to explore every practical Xero nuance across every client file.

That is where experienced bookkeeping support can complement the firm’s expertise.

Whether your firm manages bookkeeping internally or helps clients keep it in-house, The Company That Counts can configure the fixed asset register, review an existing setup and establish a reliable process.

We can also show your team—or your clients—how to maintain the register, run depreciation, reconcile the reports and identify when something needs attention.

The aim is to invest the time needed to get the register working properly once, then benefit from the time saved every month, quarter and year.

How much time could your team save if the fixed asset register worked as part of Xero, rather than beside it?

 

The app has to fit the business

The app has to fit the business

The right sales integration should do more than move transactions into Xero. It should reflect the business, produce useful reports and continue to fit as the business evolves.

read more
The supplier deposit we did not know we had

The supplier deposit we did not know we had

  One of our clients is a very good payer. In fairness, all of our clients are—but this one now has a particularly good story attached to its payment record. When the business started trading around 15 years ago, one of its suppliers asked for a refundable...

read more
I nearly fell for a $50,000 invoice

I nearly fell for a $50,000 invoice

I am normally suspicious of unexpected payment requests, but this one was extremely convincing. I received an email that appeared to come from one of our client's suppliers. It included a thread showing what looked like a genuine conversation with an employee at the...

read more
Could you produce your grant evidence by next Friday?

Could you produce your grant evidence by next Friday?

When an organisation applies for grant funding, most of the immediate attention naturally goes into the application. What will the funding pay for? How will it help? What outcomes will the organisation deliver? The reporting requirements can feel like something to...

read more
When a negative quarter is part of the plan

When a negative quarter is part of the plan

One of our clients expected to report a net loss in the first quarter of its new financial year. At last week's quarterly budget meeting, the actual figures were almost exactly as expected: net profit was negative. Viewed on its own, that could sound worrying. But...

read more

Some Useful Tools to Enhance Your Bookkeeping

Over the years, I’ve built a toolkit of systems and apps that help me work efficiently and accurately in Xero. If you’re doing your own bookkeeping, these are tools that can genuinely make your life easier. Xero: My Core System It’s no secret that I work exclusively...

read more

Needs Exist. They’re Not Created.

A Lesson From My Sales Days Years ago, I worked in sales for a company that developed software for travel agencies. My role was to contact agencies, explain how this brilliant system could transform their admin, and book a demo. One day, after a demo, I asked the...

read more

Fear of Losing Customers

If you run a business, chances are you’ve worried that one day your clients’ needs might change — and they’ll stop working with you. It’s natural. And while attracting new customers is important, I believe even more strongly in keeping the ones you already have. So...

read more