Questions? We have answers.

Xero: Opening balances export guide

  • Updated

Summary

Learn how to export opening balances from Xero for use in MindBridge.


Instructions

  1. Open Xero.

  2. Go to the Accounting tab, then select Reports.

    Image1.png

     

  3. Under the Accounting section, select General Ledger.

    Image2.png

     

  4. In the General Ledger Report, set the appropriate date range for your analysis period, then select Show YTD.

    Image3.png

     

  5. Export the general ledger report to Excel.

    Image4.png

     

  6. 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.

    Image5.png

     

  7. Separate the account descriptions from the account codes as follows:

    1. Create a new column to the right of the Account column.

    2. Name the column Account Number.

    3. Enter the following formula into B2:
      =RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,"(","@",LEN(A2)-LEN(SUBSTITUTE(A2,"(",""))),1))

      Image6.png

       

  8. Copy the formula to the bottom of your spreadsheet.

    Image7.gif

     

  9. Select column B, then copy and paste the values to remove the completed formulas:Image8.gif

     
  10. With column B selected, perform a find and replace to remove all right brackets.

    Image9.gif

     

  11. Delete the Total row from the bottom of your report.
    Your file is complete and should look like this:

    Image10.png

     

  12. Save the formatted file in .CSV format.

  13. Import the file into MindBridge.

  14. Map your columns as follows:

    • Account ID to Account Number

    • Balance to Opening Balance

    • Account description to Account

      Image11.png

       


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related articles

Was this article helpful?