I am trying to use the ‘Xero Trial Balance,’ to populate my custom reports in Excel. Can anyone help with the following?
- What order does the trial balance import as it seems almost random?
- Has anyone experienced that when you sort the trial balance by nominal code number (A-Z) and save the excel file, when you reopen the document it breaks because of the ‘sort function.’
- I use ‘V-Look ups’ to populate my custom reports. If the trial balance is not sorted by code the vlook up does not work (even though it is exactly the same data range) . Is there a reason for this?
I hope someone can help or advise what I could/should try instead.