Xero: General Ledger Export, Opening Balance and Closing Balance

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.

Note: You will need access as an Advisor to your client's Xero account.

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.
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.
Export your General Ledger (GL) file.

Select Caseware under the Trial Balance section. You’ll need the opening trial balance for every period.
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)
Export your Trial Balance (TB) file.

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:

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 article on

2 comments

Melody Trinh
- July 05, 2021 13:09
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
Kaitlyn Masseo
- July 08, 2021 13:51
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.