Questions? We have answers.

Xero: Export the general ledger

  • Updated

Summary

Learn about the process of exporting a general ledger file from Xero.


Notes

  • You will need access as an Advisor to your client's Xero account.
  • The following guide was created using the AUS version of Xero. However, the same steps should apply to other versions of Xero.
  • Xero will output the exports into a tab delimited text file. 
  • Alternatively, our  Direct Xero Integration can be used.

Extract data

Watch the following video on how to extract data or read the steps outlined below.

Complete.gif

  1. Click the Accounting drop-down menu and then click Advanced.mceclip1.png

  2. Click Export Accounting Data.mceclip2.png

  3. Select Caseware under the General Ledger section (this is the only export format that provides a Journal ID, which corresponds with the Transaction ID within MindBridge).mceclip3.png

  4. Select the date range for your General Ledger Activity. If you're auditing the year ended 31 December 2020 for example, you will want the following document: GL from 1 January 2020 to 31 December 2020.mceclip4.png

  5. Download your general ledger (GL) file.
  6. The resulting text file export should be in a format similar to the following:mceclip5.png

 


Importing delimited text files into Excel

  1. Open Excel and choose to open a document directly from Excel. You might need to select to display text files or all files *.*mceclip5.png 
  2. You will be taken to the Text Import Wizard
  3. In Step 1 of 3: Choose "Delimited"mceclip3.png

  4. In Step 2 of 3: Choose "Tab"mceclip4.png

  5. In Step 3 of 3:  The "JournalDate" column should be imported as "Date" with DMY as the format. The various amount columns should be imported as "General". All other columns should be imported as "Text" to prevent unintended data type conversions by Excel. mceclip0.png

  6. The resulting Excel import should be in a format similar to the following:mceclip1.png

 


 


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Was this article helpful?