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:
- Click on Tasks -> Export Accounting Data.
- 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.
- The Export Accounting Data screen will appear.
- 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).
- In Balancing Details and Invoice Details, check that the amounts match the End of Shift amounts.
- 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.
- Click on Connect to Xero.
- 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.
- Close the report screen and close the Export Accounting Data screen.
- Retailer will then connect to and export the data to Xero.
- The Tower Advantage website will then open. Login with your Tower username and password, if prompted.
- It will then connect to Xero and prompt for your e-mail address and password for Xero.
- 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:
- Go to www.towersystems.com.au and log in to your Tower Advantage account.
- Click on the Tower Advantage Link logo on the left panel.
- On the Tower Advantage Link homepage, click on Xero.
- Then click on the Connect to Xero icon.
- Enter your e-mail address and password to log in to Xero.
- 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.
Click on Import Sales to Xero.
- A screen will appear prompting you to select and upload the sales.txt file. Click on Browse.
- Navigate to C:\Xero. The file will have a format of Sales_STORENAME_YYYYMMDD.
- Select the file you want to upload and click Open.
- Back in the import screen, click on Upload Files.
- The file will be imported into Xero and a message will appear to notify you that the import was successful.
- Click on Dashboard and then click on Xero.
- Click on Import Bills to Xero.
- A screen will appear prompting you to select and upload the bills.txt file. Click on Browse.
- Navigate to C:\Xero. The file will have a format of Bills_STORENAME_YYYYMMDD.
- Select the file you want to upload and click Open.
- Back in the import screen, click on Upload Files.
- The file will be imported into Xero and a message will appear to notify you that the import was successful.
- 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.