Questions? We have answers.

Xero (Advisor Permission): General Ledger Export

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn about the process of exporting a General Ledger file from Xero using the Advisor user role.

 


Configuration Details

To export the General Ledger you need the Advisor user role, which exposes the Adviser tab.

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

 


Instruction

Follow steps below to export GL data in CSV or XLS format from Xero:

Note: We also support text (.TXT) files, and Tab Separated Files (.TSV) - as long they're properly delimited. Common delimiters are comma ( , ), pipe ( | ), tab (    ), and semicolon ( ; )

  1. In the Adviser menu, click Export.xero advisor menu with export selected
  2. If prompted, add a "code to accounts" in your Chart of Accounts (COA). If you do not add a code, another accounting product will not import your data properly.
  3. Click "Caseware" to generate an additional field called Journal ID, which will be used as the Transaction ID within MindBridge. xero export screen
  4. Select the date range of the data to export.xero export screen with date range selected
  5. Click Download. When finished, open or save the file.

 


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.


Share this article on

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.