Why Xero reports don’t work

This blog is for any user of Xero who uses performance or statutory reports. It is a little technical, not for the faint-hearted.

Here are some definitions:

Business owner = a client of a bookkeeping or accounting firm

Bookkeeper = licensed / registered agent

Accountant = licensed / registered agent

Xero Reports Are Crap

Xero reports are shXX!

These reports take me 25 minutes; they used to take me two minutes!

These Xero reports just dont work!

Why would I bother moving to Xero when everything works fine already?

These are comments I hear all the time.

When I hear these comments, at times, I can see beads of sweat preparing to trickle down the sides of faces. I also see the forehead vein swell with stress and frustration, getting ready to pop.

Does this sound like you?

• Are you having trouble understanding the simple things in Xero?

Accountants Fail

Accountants, with all their amazing skills, still have trouble figuring out how to use Xero reports.

Many of them are what they call “CA – Chartered Accountant” or “CPA – Certified Practicing Accountant” which means they belong to certain special “clubs” or “groups” and their technical knowledge is highly valued by businesses and families across the world.

But they can’t figure out how to use Xero reports.

Why?

How on earth could these technicians fail to use Xero reports properly?

Well, there are a few common factors.

Probably the biggest issue is that they make assumptions.

​The Most Common Assumption

Excuse me, I now have to delve into accounting software history for about two minutes of your time.

I know, I know. Does that sound like pulling teeth?

Try writing it……………

The main assumption accountants make is actually because for the last 20 years, accountants’ financial reporting software has been HIDDEN.

What? Hidden? What do you mean hidden?

Accountants have been able to “hide” the chart of accounts from their business owner customers for the last 20 years.

This means, they can get on with preparing financial statements using their systems and charts of accounts, knowing full well they have complete control over the chart of accounts. The only people who can edit, delete or add an account are the accounting staff.

These accountants choose the correct accounts using “code ranges”.

For example,

200 is for “sales of goods”

300 is for “direct costs”

400 is for “expenses”

So they know this “language of codes” like their palm print. It becomes second nature after a while. They could probably recite them in their sleep.

But hold on!

ShXX!

Xero does NOT have code ranges.

When you add a Xero account, you CHOOSE the account code.

Also, Xero is online…the business owner can log in and edit, delete or add accounts.

STOP THE CLOCK.

Boom!

There it goes.

The assumption is that the reports will work based on “code ranges”.

Where as they don’t!

So how the fXXk do they work?

​So How Do You Get Around This Issue?

Well, don’t worry accountants.

Xero has you covered.

Xero has designed a further “mapping process” around the chart of accounts and only “Xero Partners” can do it (bookkeepers and accountants who are registered as Xero Partners).

So in other words, this next part, business owners can never do.

I think the easiest way to explain it, is to watch this video.

No sound needed; a phone is too small to see text.

It will explain why your reports don’t work.

​The Secret Sauce Of Xero Report Templates

You see, each account needs a REPORT CODE.

If your accounts are NOT mapped, then the report templates probably won’t work.

Having knowledge of this “language” allows accountants to take full control of the chart of accounts WITHOUT interruption to their business owners who are using Xero.

Get it?

This is the reason Xero’s single ledger has become so popular.

Accountants can still control the reports; they just need to learn how.

Now that you understand the concept of report codes, I bet you have some more questions for me!

Well, check out some frequently asked questions that I get below.

That might help you understand how this will work for you.

Frequently Asked Questions

Q – If I add an account under the chart of accounts screen, such as a receivable account which is a current asset, will it get a report code assigned to it?

A – Yes, it will get either asset, liability, equity, revenue or expense as a default. In this case, it gets asset (ASS). It is your job to drill it deeper. You would map it to ASS.CUR.REC.TRA.

Q – My clients signed up to Xero online. Will these accounts be mapped?

A – Yes, most of them will be mapped. However, you will probably need much more mapping detail in these accounts (see our services below).

Q – If you have mapped all the accounts, will I have to do it again next year when I run the reports?

A – No, once they are mapped, that job is done. If you ADD a new account, you will need to map it.

Q – Can I create a report code?

A – No. Only Xero does that.

Q –  I want a master chart of accounts that is fully mapped so I can set up customers on Xero and not have to worry about the mapping stage. How do I do that?

A – We provide this as a key part of our service (see below). It is essential for success in getting your money’s worth from Xero reporting.

Q – Once I map all my accounts, is the problem solved?

A – Not quite. Sometimes the account name (as well as the reporting name) can be improved. See our services.

Q – There are no accounts for distributions, intangibles, related party loans, taxation, drawings and financial liabilities. How are these managed?

A – A master chart of accounts (in Excel) is essential to solve this. See our services.

Q – Are all Xero income statements / profit and loss statements and balance sheets based on report codes?

A – No. There are two sets of these reports. The first are what I call “ad-hoc” income statements and balance sheets; these are accessed from the reports tab in Xero. They are based on account type and account name. The second are “Xero report templates” which are for “compliance or statutory” accounts.

Q – If I map an account, will it affect the income statement and balance sheet reports a business owner uses?

A – No, those are “ad-hoc” reports and are based on account type and account name.

Q – I have mapped all my accounts but the reports are still not satisfactory. How do I get them to look better?

A – You have two choices. You can do it yourself by going into Xero HQ / reports / copy the Xero one and start doing it yourself. Or, you can get us to do it; see below.

Q – If I create my own Xero report templates under Xero HQ, can I use them across all my customers?

A – Yes, that is the purpose; they are “practice-wide” reports.

Q – Can I edit these Xero report templates for each client and save a customised template for them for each month or year?

A – Yes, watch this video here which shows how to do it.

Q – I want my reports to look almost identical to my current financial statement software. Can I achieve that?

A – Yes. Either do it yourself or engage us. Here is an example of a set of financial statements for a trust.

Q – Can I have management reports based on report codes?

A – Yes, here is an example of what we build for our customers.

Q – Okay, so maybe we get you to do it for us. How does the process work?

A – First, we scope out your needs, just to make sure you understand where we start and end, then we provide a proposal. Here is an example of a proposal for a client that:

Has been using Handiledger

Has now got 65 clients on Xero and is sick of exporting data and entering into Handiledger

Is using Xero tax for free

Has four staff on Xero

Is based in Rockhampton, QLD, Australia

Q – Okay, so how much does it cost?

A – In a nutshell, we don’t do cheap and easy, we do the best available. See below.

Q – How do I measure how much value Entry Counts provides?

A – Time. We are in the time-saving business. Typically, our clients take two minutes to prepare financial statements. Any longer than five minutes, and we expect that something is seriously wrong. How long does it take you?

Our Successful Customers

​How Does Entry Counts Help Me?

I work as a freelance consultant helping people get their money’s worth from the Xero reporting platform. I have been trading for 12 months and have done around 45 implementations and training for accounting firms around Australia.

What that means is, I often walk into crime scenes.

The “do not cross” tape is up, the witnesses are being interviewed and the evidence is direct, as well as circumstantial. It’s my job to assess what happened, why it happened and how to make it better for everyone involved.

That was just a cool way of describing the work I do.

The actual work I do is based on this page of our website.

We also have these explainer videos, as well.

We offer the full range of services to make this a success.

​How Much Will This Cost Me?

The minimum price is $3,300 AUD.

Onsite training costs more, around $1,100, depending on where you are.

Fix-up jobs tend to cost more. We find that if we need to fix, sometimes it is cheaper to start again.

Remember, you get all these benefits in this example proposal.

The best way to value an investment with us is to see how long it takes you now, multiplied by the number of Xero customers you have, and compare it to our two-minute rule.

Example:

It takes you 22 minutes, you have 100 Xero clients.

You 22 x 100 = 2,200 minutes (37 hours)

Us 2 x 100 = 200 minutes (3 hours)

34 hours saved, just on publishing for year 1, then 34 hours for every year after that.

​Summary

So Xero’s report templates work well when they are fully understood and used properly.

It requires investment.

It is not something that you just pick up.

I see people who try and self-teach; most end up not getting value for money. They do extensive editing and have workflows that are inefficient.