Summary
Learn how to export opening balances from Xero for use in MindBridge.
Instructions
-
Open Xero.
-
Go to the Accounting tab, then select Reports.
-
Under the Accounting section, select General Ledger.
-
In the General Ledger Report, set the appropriate date range for your analysis period, then select Show YTD.
-
Export the general ledger report to Excel.
-
In Excel, delete rows 1-4 and row 6.
The column headers are now in row 1, with no blank rows. Your formatted file should have the same structure as the image below. -
Separate the account descriptions from the account codes as follows:
-
Create a new column to the right of the Account column.
-
Name the column Account Number.
-
Enter the following formula into B2:
=RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,"(","@",LEN(A2)-LEN(SUBSTITUTE(A2,"(",""))),1))
-
-
Copy the formula to the bottom of your spreadsheet.
-
Select column B, then copy and paste the values to remove the completed formulas:
-
With column B selected, perform a find and replace to remove all right brackets.
-
Delete the Total row from the bottom of your report.
Your file is complete and should look like this: -
Save the formatted file in .CSV format.
-
Import the file into MindBridge.
-
Map your columns as follows:
-
Account ID to Account Number
-
Balance to Opening Balance
-
Account description to Account
-
Anything else on your mind? Chat with us or submit a request for further assistance.