Questions? We have answers.

General Ledger Export - Xero UK (No Adviser Permission)

Article author
Jonathon Plowman-Samson
  • Updated

Note: The below guide was created using the UK version of Xero.  However, it should still be a valuable article for using other versions of Xero.  

Click the Accounting drop-down and then click Advanced.

xero_UK_1.png

Click Export Accounting Data.

xero_UK_2.png

Select Caseware (this is the only export format that provides a Journal ID, which corresponds with the Transaction ID within MindBridge.

xero_UK_3.png

Export your General Ledger (GL) file and opening trial balance for every period. If you're auditing the year ended 31 December 2018, you will want the following documents;

  • Trial Balance as at 31 December 2017 (Opening Balances)
  • Trial Balance as at 31 December 2018 (Closing Balances)
  • GL from 1 January 2018 to 31 December 2018

Once you have the documents, you will need to add column headers to your Trial Balance documents.

Trial Balance headers 

  • Amount
  • Account Number
  • Account Name
  • Date
  • Account Name 2

  Your data should now look like this;

xero_UK_4.png

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.