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
-
Kristen Saunders commented
its ridiculous that you can't do this .
-
Christopher Mills commented
It also ensures report format stability, so that each time a report is downloaded to excel it has the same account id's in the same excel row.
-
Katrina Steffens commented
P&L and Balance Sheets to show all accounts even if $0 balance.
We frequently export these reports to Excel and combine with earlier reports. The reports are basically always inconsistent in length as not all items are relevant for each period.
If the reports had the option to display all accounts it would remove the need to continually manually manipulate the output.
-
Mike Beck commented
Why does Xero ignore this request? This has been an issue for a long time. It will clearly save users' a lot of time and I can't believe it is a complex thing to implement.
I can only assume so long as people continue to use the system they figure it doesn't really matter? -
David Anderson commented
Yes, can you implement this as soon as possible please?
It is important - by being able to see a zero balance means we can easily look into the account to see why it is a zero balance (especially if we are not expecting it) but also easily allows us to look at transactions in that account.
-
Anita Wildman commented
Appreciate we can now add account number to financial statements
I am begging xero to implement the ability to show/hide nil balances.
The amount of extra work created by this lack of functionality is astounding.
Please implement. -
Megan Botha commented
Yes please , there should be an option to include zero balances in the P&L
-
Gsolutions Finance Team commented
Xero already has the option to include All accounts, including zero balance for Reports: Account Transactions. Please extend the same feature to Profit and Loss, Trial Balance, and Balance Sheet
-
Janet Poon commented
It is not making sense by not showing zero balance on the financial statements!!
-
David Benady commented
Also useful when using tracking as the balance may be zero overall but there maybe a balance for some of the individual categories
-
Bill Kitley commented
Important!
-
Pam Nelson commented
Yes, please!!!
-
Gemma Phillips commented
Agreed, this would be extremely useful!
-
Gillian Jackson commented
I can see that you can now add account numbers, but being able to switch on or off zero balances on a TB or Balance sheet with Zero balances would be great.
-
Jacqueline Whittingham commented
Completely agree with comments below. This is a complete handicap to anyone using a financial model. And given the comments date back over a year I'm astonished you haven't fixed it. Really regretting the choice of Xero for our start-up now.
-
MIchelle Ewing commented
I have only started using Xero on a regular basis recently and was very surprised that this is not an option. I am sure all other accounting software I have used allows you to do this.
-
Kemran Kaya commented
There's an option to move negative balances around in a Xero Custom Report; seemingly a more complicated tool than to include nil balances in a report. Does not make much sense
-
Silke Dietzel commented
Can't believe Xero doesn't have any option for this funtion. It is really is a basic accounting function to be able to export an excel TB from Xero that includes nil balances, this would assist massively with being able to be able to map a TB into a user created excel spreadsheets. This should be sorted ASAP
-
John Schuts commented
Please create this option, I use a multi software budget outside of Xero and need to be able to export the data as Excel. At present I have to clean the data every time before using it.
A simple dropdown option to include accounts with zero values would be amazing.
-
Charlotte Goodwin commented
Need this function PLEASE, makes it very difficult to use actuals to inform budget prep in a budget manager exported s/sheet - I want a P&L with zero balances showing please