Exporting Data to Xero

Exporting Data to Xero

Before exporting data from Retailer to Xero, a number of areas need to be set up first. Click HERE to learn more about the set up process for Xero integration.

Exporting Accounting Data From Retailer

Once the End of Shift routine is transferred from the Server/Main computer, the accounting data is ready to be exported to Xero through the steps below:
  1. Click on Tasks -> Export Accounting Data.
  2. If you are exporting for the first time, you have a choice of selecting a date range to be exported. We recommend changing the dates to today's date to avoid discrepancies with older End of Shift figures. Click OK.
  3. The Export Accounting Data screen will appear.
  4. In Date Range of Data to Export to Accounting Program, the dates should correspond with the dates on your End of Shift Report (unless this is your first time exporting).
  5. In Balancing Details and Invoice Details, check that the amounts match the End of Shift amounts.
  6. In Banking Details, type in the totals of cash and cheques that will be deposited into each bank account. This should be the exact total, otherwise, a discrepancy will appear.
  7. Click on Connect to Xero.
  8. This will create a file in C:\Xero and display the Exported Accounting Entries report. You can print this report or save it as a PDF file. Additionally, Retailer automatically saves a copy if you enable the option in Accounting Link Setup.
  9. Close the report screen and close the Export Accounting Data screen.
  10. Retailer will then connect to and export the data to Xero.
  11. The Tower Advantage website will then open. Login with your Tower username and password, if prompted.
  12. It will then connect to Xero and prompt for your e-mail address and password for Xero.
  13. Make sure the correct store name is selected and click on Authorise.

Manually Importing Accounting Data Into Xero

If the export process fails for whatever reason, you can import the file into Xero manually by following the steps below:

  1. Go to www.towersystems.com.au and log in to your Tower Advantage account.
  2. Click on the Tower Advantage Link logo on the left panel.
  3. On the Tower Advantage Link homepage, click on Xero.
  4. Then click on the Connect to Xero icon.
  5. Enter your e-mail address and password to log in to Xero.
  6. Make sure the correct store name is selected and click on Authorise.
    Note: If there has been any setup changes in Xero since last export you will need to click on Download Account and then Download.
  7. Click on Import Sales to Xero
  8. A screen will appear prompting you to select and upload the sales.txt file. Click on Browse.
  9. Navigate to C:\Xero. The file will have a format of Sales_STORENAME_YYYYMMDD
  10. Select the file you want to upload and click Open.
  11. Back in the import screen, click on Upload Files.
  12. The file will be imported into Xero and a message will appear to notify you that the import was successful. 
  13. Click on Dashboard and then click on Xero.
  14. Click on Import Bills to Xero.
  15. A screen will appear prompting you to select and upload the bills.txt file. Click on Browse.
  16. Navigate to C:\Xero. The file will have a format of Bills_STORENAME_YYYYMMDD
  17. Select the file you want to upload and click Open.
  18. Back in the import screen, click on Upload Files.
  19. The file will be imported into Xero and a message will appear to notify you that the import was successful. 
  20. You have now completed the import process and you will receive an e-mail to the defined address notifying you about the data that was imported.

    • Related Articles

    • Xero Link Integration Setup

      Before Setting Up Xero Integration Before following the steps below, you need to meet the following requirements: An active account with Xero. Visit the Xero website for more information: https://www.xero.com An active Tower Advantage Support ...
    • Xero Link Integration With Retailer

      What is Xero? Xero is a cloud based accounting package. We use it ourselves in our own retail shops. xero is easy to use. We have migrated from MYOB and have previously had experience with Quicken. So, Xero is a full function accounting system ...
    • Exporting Data to Ezylink

      Before exporting data from Retailer to MYOB (OzBiz), a number of areas need to be set up first. Click HERE to learn more about the set up process for MYOB integration. Exporting Accounting Data Complete the end of shift process as normal. From the ...
    • EzyLink Setup

      Retailer has the ability to integrate with various accounting packages including MYOB and QuickBooks using a third-party software program called EzyLink from OzBiz. Before Using Accounting Link / OzBiz To use EzyLink, you must be using one of the ...
    • Verifying / Reconciling Xero link export

      The easiest way to reconcile is using the Exported Accounting Entries report that is produced when exporting to Xero. The values on this report should match the sales invoice in Xero. Note: some values with GST will display as ex-GST in Xero. To ...