Fast uploads of new Xero trial balance

Xero recently updated their trial balance reports (including prior year balances) making them much easier to import into Audit Assistant.  In response we have now updated our importer to recognise the new headings and account type column.

There is now no need to edit the Xero TB prior to import. Just import the raw Excel TB.

Screen_Shot_2019-10-30_at_3.45.00_PM.png

Step 1 - From Xero TB use "Export", "Excel" to create a TB like this:

Screen_Shot_2019-10-21_at_2.19.34_PM.png

 

Step 2 - Go to the Audit Assistant Trial Balance page and select "Upload Trail Balance":

Screen_Shot_2019-10-21_at_2.22.03_PM.png

Step 3 - Select "Choose file" button:

Screen_Shot_2019-10-21_at_2.22.50_PM.png

Step 4 - Browse to where you have saved the Xero TB file, select the file and click "Open", then in AA click "Add":

Screen_Shot_2019-10-21_at_2.27.16_PM.png

Step 5 - Drag and drop any accounts that are out of place, (Xero puts Tax under current liabilities (so it defaults to T section), and Intangibles as Fixed Assets (so it defaults to N section). Use shift and click to select multiple codes to drop and drop into the correct section.)

 From here...

Screen_Shot_2019-10-21_at_2.34.50_PM.png

....to here:

Screen_Shot_2019-10-21_at_2.36.57_PM.png

All done!

For subsequent years just import the new year TB and if there have been no changes to account codes or names everything should just match up with prior year and work seamlessly.

Have more questions? Submit a request

Subscribe to our mailing list

We have a regular newsletter which includes the latest updates in the audit and assurance space as well as on to our latest work.

Click here to view previous newsletters, enter your email bellow to subscribe.