Enter your idea

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

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.

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

As stated, this 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 accounts pack spreddy. This should be sorted ASAP!

There should be an option to show zero option to show zero balances, this should be a basic function.

This is essential to help us with our budgeting

This is fundamental to ensuring consistency.

If all GL accounts can be exported it can easily imported into my excel template without much manipulations for reporting and checking.

1. I want a Trial Balance with $0.00 balances.
2. Cannot get this functionality.
3. Contact Xero support. Xero support advises functionality not in Xero.
4. Xero support refers me to Xero Product Ideas.
This process drives a truck through my productivity. Thanks Xero

It would be so useful to be able to run a Trial Balance that includes all accounts, including those with a zero balance.

I thought it used to be possible in Xero maybe I'm mistaken?

Most accounts systems give that option and it can't be hard to do.

Please.....

I want to run budget variance reports across multiple tracking codes (separate tabs) that feed into a consolidated sheet - all in Excel. Not having zero balances means a lot of extra time spent correcting for new lines each month. It's a huge time waster which would be fixed by having all lines each month so that cell references never change.

I absolutely agree that accounts with zero balances should still be reportable. I believe this is a major short coming, particularly for balance sheet accounts. There should be a filter or option to allow this setting to be chosen.
I thought something major was wrong when not all my bank accounts were listed on the balance sheet report!
Some reports already have the option to include account codes.

I need the option to show contacts that have a zero balance, in an Aged Receivables report filtered by contact group.

It would clearly indicate to the recipient of the report that all contacts that should be on the report, are on the report.

Should be a basic function to have the option ot show zero balances

For anyone doing serious reporting outside of Xero this requirement is a necessity. It absolutely staggers me that Xero has not addressed this issue considering how long users have been asking for it. Just get it done Xero, it can't be that hard to fix it.

this is critical. if a balance sheet account has had any activity, even if the current balance is $0, then it should show the balance as $0.

We have a budget outside of Xero becuase of 13 periods and it would be very useful to be able to copy paste the P&L values across when needed. At the moment we have to manually type the values as there is no option to include zero balances.

Why hasn't this been addressed? MYOB has this option, come on Xero the time we spent lining reports up because of this is so frustrating.

Needed for Public Benefit Entity as one of the Charities reporting requirements to show certain items even if they have not had any expenses in this category for the last couple of years.

Hugely frustrating that this is not an option. I guess since the original request is from 2014 that it is unlikely to happen.