Questions? We have answers.

Xero: General Ledger Export, Opening Balance and Closing Balance

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 accounting tab with Advanced option selected

  2. Click Export Accounting Data.
    xero accounting export accounting data selected

General Ledger

  1. 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 export screen with CaseWare option selected

  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 document: GL from 1 January 2020 to 31 December 2020.
    xero export with date range Jan 2020 to Dec 2020 filled out

  3. Export your General Ledger (GL) file.
    exported general ledger file from xero

 


Opening and Closing Balance

  1. Select Caseware under the Trial Balance section. You’ll need the opening trial balance for every period.
    xero export screen with CaseWare selected

  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)
    xero export screen with dates filled out

  3. Export your Trial Balance (TB) file.
    exported trial balance file in excel

 


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.