Brought to you by

Release days are the best days

Posted 6 years ago in Advisors by Xero
Posted by Xero

Today’s release brings a new balance sheet report, a quicker way to get to the new reports, as well as other smaller enhancements.

Balance Sheet

If you follow our blog, then you will have seen the release of our new P&L, which enabled a raft of new features when creating layouts. At the time we mentioned that the balance sheet would be the next big financial report to get a makeover, and here it is!

Like the Profit and Loss report, there is a clean new look with a focus on readability, and a brand new layout editor that let’s you do much more than the original. When modifying the layout of your balance sheet, you can now reorder the groups, rename them, delete them, and you can place accounts in a specific order and create formulas as well. As with all new reports, the dates are entered using a convenience date picker to quickly select common dates, and of course, they can now be run on a specific day, not just end of month.

If you are a UK customer and want to place your accounts in liquidity order, now you can. If you are in education and want to create a working capital layout then that too is possible with the new layout editor. Create the layout which is most useful to you!

To make it easier to get to the new reports while we transition our reporting system there is now a direct link in the Reporting menu to take you straight there.

Reporting Menu

Reporting Menu


What’s coming up next from the reporting team?

  • Text notes – very soon you will be able to add text sections to all reports, as many as you need. Summary, signatory note, disclaimer, you name it.
  • Movements in Equity – this report is close to completion
  • Drilldowns from all the new financial reports to the new account transactions report which supports multiple accounts

However, reports are just one part of Xero which we are working on, the Sniper team have also been busy!

New Contact account number

New Contact Account Number is here! And while there is so much more that we have planned for Contacts, we know from the many Community threads requesting this feature or similar that this is a valuable change that we could deliver now.

Use this field for whatever is useful for your business – it’s a user-defined reference that you can give your customers or suppliers and it doesn’t even have to be a number – so long as its different or unique for each contact.

And we pretty much put it everywhere – search your contacts using it, display it on your invoices, bills and purchase orders by simply turning on its display from Invoice Settings. Whether you see it or not is over to you.

To help get you moving we have also prepared some detailed guidance on bulk updating your contacts, updating standard branding themes and DOCX.

Find out how to include contact account numbers on your invoices and other documents

Oh… and as we just couldn’t wait to get this to you, updates to Mobile and the API are coming soon.

Powering up contact search

We know your contacts are everything to your business. Finding the correct one when you create your invoice, bill or reconcile your bank account is something that should be super easy.

contact auto

In today’s release we have included some pretty big changes to the contact search that are worth highlighting.

  • Mistyping and accidentally creating new contacts is such headache.  Now you will know explicitly when you are adding a new contact with the + New Contact indicator.
  • Search your contacts by email address or contact account number.
  • Looking for someone’s surname or the second part of a business name? The ‘contains’ search now works for as few or as many characters as you like,  prioritising occurrences based on whether the characters appear at the start of any word.
  • Faster. We have also significantly optimized the search and included some additional caching, meaning we can better keep up with your keystrokes.
  • And finally we’ve added it to the bank reconciliation.

Void checks on specified date (US edition)

If you’re in the United States and track your checks via the check register in Xero, you will well know the consequences of voiding a stale or expired check and having the related payment automatically deleted on the check’s creation date as if it never happened.

Now with void check on specified date there is an alternative void option that allows you to choose the date you want the check void to occur and the date the related payment reversals are to be reported.

And, just in case you selected this new void option by mistake, entered the wrong date or the check turns up and is cashed… you can now unvoid.

Allow your votes to do the talking

We’d heard a bit of feedback that 5 votes in our Community isn’t enough, so a few weeks ago we gave everyone 5 more.  Now is a great time to see what you’ve already voted on, just log in, and go to your Public Profile.

We also want to see all the smaller pain points highlighted so make sure to add your votes on other features/improvements.



Dianne Jewell
November 3, 2014 at 12.31 pm

Love the new Contact Account Numbers!

Jennifer Hewitt
November 3, 2014 at 2.03 pm

Hi, do the templates set up for use with the old P&L and balance sheet not carry through to these new reports (at least as a starting point) being released?

Mark Blundell
November 3, 2014 at 3.22 pm

Hi Jennifer, no we have not converted the old style layouts over yet. We still need to add formula columns and budgets to the P&L before we will look to do that conversion.

Mary-Clare Switz
November 3, 2014 at 4.10 pm

WARNING – Regarding using the csv import option for adding in your account numbers (a feature I am very excited about) …. WHEN EXPORTING THE CSV OUT OF XERO YOUR BANK ACCOUNT NUMBERS WILL BE IN THE WRONG FORMAT. IF YOU REIMPORT THE CSV WITH THE UPDATED DATA YOU WILL ALSO BE OVERWRITING THE BANK ACCOUNT DATA. This has left me one very unhappy bunny today.

Mark Blundell
November 3, 2014 at 4.56 pm

Hi Mary-Claire
Yikes, thanks for raising this, certainly not supposed to happen!
Have you logged a ticket with our support team? They will be able to help you quicker and more completely than I can here on the blog.
The issue sounds like Excel has automatically formatted your bank accounts on your contacts into scientific notation, which when you re-imported has overwritten the proper numbers. Not very helpful I know!
The good news is if you go back to Excel and set the formatting on that column to be Text and then re-import, it will fix it again for you.

Mary-Clare Switz
November 3, 2014 at 5.21 pm

Thanks Mark. Yes I have logged a ticket. That is exactly what happened, however, I did not catch it until too late. I did try to change the column to text, but it made no difference. I now have over 200 bank accounts to reenter. I did try to change the column to text, but it made no difference. Yes I have logged a ticket.

November 4, 2014 at 2.32 am

This is all good stuff – thank you.

Contact account numbers will be great. We create our contacts by importing CSV’s of invoices. Can those CSV’s be loaded with a column of the new Contact Account Numbers so that we can bring them in to Xero automatically?

Jordan E Baker
November 4, 2014 at 4.05 am

Really good post and the product looks great we will all being downloading at the office!

Heather Smith
November 4, 2014 at 12.35 pm

@Mark and @Mary It seems that we in Australia [I note from LinkedIN you are based in Melbourne Mary] have very long account numbers. Of note we have a 6 digit BSB number and then an Account number which can be 6 to 15 digits long.

I too have imported and have had this happen. I seem to follow all the correct steps – yes indeed I agree its a Excel issue, but its frustrating nonetheless.

Any chance our Contacts in Australia could have a BSB field?

Penny Wildash
November 5, 2014 at 12.14 pm

@Mary-Clare and @Heather as it is easy to miss Excel’s reformatting on long numbers we’ve updated the help page (yesterday) to recommend that you actually only re-import the contact name and contact account number columns that you wish to update and included a warning about Excel.

Also breaking out the BSB field on the Contact bank account record is certainly something that makes sense and we are looking at providing some more detailed messaging during the import process to advise exactly what import updates are going to take place.

@Nigel very happy to hear this is useful for you. Adding the new contact account number field to the invoice importer is on our radar, no timeframe yet but we can see that it is a convenient place to add them for new contacts.

December 7, 2014 at 10.32 pm

Hi Xero team

It is nice to see that you are adding more and more reports with the new layout. However, I am a bit sad to see that the new reports do not have links in the accounts to take you to more detailed info like the old layout. For example, in the old layout if I wanted to see the transactions related to “offices expenses” I just had to click there in the report; with the new layout this is not possible at all, unless I am missing something.
Hope this was clear enough for your feedback.

Mark Blundell
December 8, 2014 at 8.32 am

Hi Fabio, as stated in the blog, drilldowns on the new reports are coming, in fact they will ship on the 15th of this month.

Aliesha Mcgilligan
February 9, 2015 at 6.48 am

Hi Mark, this is wonderful, could you email me please? 😛 I will delete this once you have.

Leave a reply

Your email address will not be published. Required fields are marked *