Questions? We have answers.

Xero: Opening balances export guide

Article author
Tasha Kociszewski
  • 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 as a .csv

  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?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


Related articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.