Questions? We have answers.

Exporting General Ledger, Opening Balance and Closing Balance Data from Xero

Article author
Jonathon Plowman-Samson

Summary

Learn how to export financial data from Xero to upload to your general ledger analysis in MindBridge.

Note: The following guide was created using the AUS version of Xero. However, the same steps should apply to other versions of Xero.
 

Exporting from Xero

Note: You will need access as an Advisor to your client's Xero account
 
1. Click the Accounting drop-down menu and then click Advanced.

 

xero-1.jpg

 

2. Click Export Accounting Data.

 

xero-2.jpg

General Ledger

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.

 

xero-3.png
 
4. Select the date range for your General Ledger Activity.

If you're auditing the year ended 31 December 2020, you will want the following document:

GL from 1 January 2020 to 31 December 2020.

Screen_Shot_2021-06-25_at_10.59.48_am.png

 

5. Export your General Ledger (GL) file.

Screen_Shot_2021-06-25_at_10.49.04_am.png

 

Opening & Closing Balance

1. Select Caseware under the Trial Balance section. You’ll need the opening trial balance for every period.

 

xero-4.png

 

2. Select the date range for your General Ledger Activity.

If you're auditing the year ended 31 December 2020, you will want the following documents;

· Trial Balance as at 31 December 2019 (Opening Balances)

· Trial Balance as at 31 December 2020 (Closing Balances)

Screen_Shot_2021-06-25_at_11.04.22_am.png

3. Export your Trial Balance (TB) file.
Screen_Shot_2021-06-25_at_11.05.47_am.png

 

 


Technical names of reports in Xero (might not exactly match the name displayed in the user interface)

The technical name of this report in the Xero system is journals

The following are the technical names in Xero of other files you might need to pull:

File for MindBridge

Report to Pull

General Ledger

journals

Opening Balance

 

Closing Balance

trialbalancereport

Chart of Accounts

accounts

 


Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


 

Share this:

Was this article helpful?

Comments

2 comments

  • Comment author
    Melody Trinh

    I dont seem to have the "Advanced" drop down in my client's Xero account. Is this based on the level of access you have? 

    0
  • Comment author
    Kaitlyn Masseo

    Hi Melody Trinh, thanks for your question. We checked with our Xero experts here at MindBridge - you will need "Advisor" access to your client's Xero account to be able to complete this. We will make an update to our article to show this information. 

    0

Please sign in to leave a comment.