Reporting - Option to add account numbers & zero balances to financial statements
Ability to have to have a check box for "Include Account Numbers" and "Include or Omit Zero balances".
Purpose: Because it demonstrates completeness to show that the balance actually is zero
![](https://secure.gravatar.com/avatar/3e8620417a8479ef69d5350df419cb19?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Hi everyone, we thoroughly appreciate your feedback and input to the idea here. To confirm it is possible to add account codes to the Profit & Loss, Balance Sheet, Budget Variance and Cash Summary reports through the 'More' option on the report.
We also understand the needs in wanting to be able to show accounts with a 0.00 balance. While this is something our team would like to be able to address, there have been other priorities that require more immediate attention. As soon as there is activity around progressing this idea, we'll update you all of this here.
-
Mike Beck commented
I agree with all the comments below. This should be basic functionality to enable users to extract a TB that is the same (with the same number of lines) every time and therefore reduce a lot of manipulation.
Xero's response of kicking this can further down the long road is quite insulting and disheartening. -
James Smith commented
If possible, choose a few comparative years. While this approach can be helpful, it doesn’t apply to new accounts with zero balances.
-
Alex Marsom commented
Kristin is right, and her reason is the exact same reason I came to this forum.
I’m not some low touch sole trader, I consolidate 23+ entities from Xero (each with there own subscription so our company spends over $1000 a month on Xero), and without this basic functionality I have to have 23 extra tabs in my consolidation so I can do various vlookups and other data manipulation to extract what I need. But it is unnecessary and it’s not on. It’s making us actively consider our options. It might seem trivial to some, but it’s actually a main pain point to others -
James Huntington commented
It's clear to me that Xero's developers have painted themselves in to a corner with this branch of the code and cannot "easilly" introduce this change.
As software develops over time it becomes increasingly difficult for developers to make even simple changes like this.
Xero won't admit it but 10 years has passed without this simple change request landing on some junior developers desk, suggests to me this is the case.
-
Gary Stocks commented
Kelly Munro
I have stopped recommending Xero to others simply because of the lack of this simple reporting facility.
The product is starting to resemble a competitor who would declare a fabulous new service that basically change the colour of an invoicing screen.
Maybe Xero's priorities are not the user's priorities and this is disappointing.
-
Kristen Saunders commented
You are not being helpful and this is not good enough. Just yesterday I had to spend half a day dumping 5 months of trial balances and using v-lookups to get data month by month into a trial balance template in excel I had to make so we could do our month end reporting. this is BASIC BASIC BASIC functionality. Xero continues to add useless bells and whistle features whilst ignoring essential needs. This seems to be the Xero ethos.
-
Chris Curlett commented
Alex I so agree with you however Xero software is sub falling well behind its competitors however this is a result of the attitude displayed by Kelly above.
-
Alex Marsom commented
With all due respect Kelly, it’s not good enough. Xero is literally the only accounting software I’ve used and seen (as an auditor I have seen and mapped trial balances from many countless softwares). It is part of the fundamental principles of accounting to demonstrate completeness. It is not something you need all the time, I understand that, but you will find from online forums most other products have the problem of not being able to exclude the nil balances. The fact this has been a known issue for over 10 years, and you have again politely told us as the users that it’s not a priority leaves little hope of a fix any time at all.
-
Chris Curlett commented
Kelly rather than re-cycling excuses how about getting things requested by users done!
This has been asked for so often you should be embarrassed by the repetitive requests.
To quote a well known American brand "Just Do It"
-
Mike Beck commented
This is so important and would make every user of Xero's life a bit easier. It seems like it would/should be easy to do.
It's incredibly frustrating that Xero have ignored this and similar threads for so many years. -
Alex Marsom commented
how do we get traction on this, or is this another case of the product developers pushing their own ideal changes when they aren't actually users of the product themselves so don't understand why something like this is so essential?
-
Ian Kerry commented
Happy Birthday to this thread. 10 years ago it was started.
I am sure with all the increases in subscriptions over that 10 year period that it won't be long before we have this rather simple feature done.
-
Chris Curlett commented
Come on XERO this can not be all that complicated!
XERO is not run by its management or Directors but the product development team who seem to be a law unto themselves.
Came on Management time to step up - or are you a part of the problem?
-
Sarah Whitston commented
Any update on this ? Last comment I can see here is from 2022 but it's still a really fundamental and much needed functionality !
-
Sarah Whitston commented
Any update on this ? Last comment I can see here is from 2022 but it's still a really needed functionality !
-
Chris Curlett commented
Oh YES PLEASE. this is such a basic feature that is well supported by users.
PLEASE CAN WE HAVE IT XERO
159 people wanting it makes it worth doing
-
Anita Wildman commented
PLEASE PLEASE PLEASE PLEASE
The amount of extra work it creates by not having this basic functionality is significant. Accountants and bookkeepers are begging and pleading for this. -
Chris Curlett commented
XERO look at the number of users who have supported this for so long. It is long overdue to be implemented.
With so many supporters you must feel obliged to support your users requests.
-
Chris Curlett commented
YES YES PLEASE.
XERO this can not be too hard to implement.
It is needed to download and use such things as the Trail Balance in excel.
PLEASE MAKE THE UPDATE!
-
Paul-John Mudie commented
'Xero Team shared this idea'... over a decade ago!