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
1 - Click the Accounting drop-down menu and then click Advanced.
2 - Click Export Accounting Data.
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.
4 - Export your General Ledger (GL) file
5 - Select Caseware under the Trial Balance section. You’ll need the opening trial balance for every period. If you're auditing the year ended 31 December 2018, you will want the following documents;
· Trial Balance as at 31 December 2017 (Opening Balances)
· Trial Balance as at 31 December 2018 (Closing Balances)
· GL from 1 January 2018 to 31 December 2018
6 - Export your Trial Balance (TB) file