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 following:
- MYOB Premier 9 or newer
- MYOB Accounting 15 or newer
- MYOB Accounting Plus 15 or newer
- End of Shift needs to be configured to transfer sales for ALL terminals.
- Contact OzBiz Solutions (02 6568 9399) to install the OzBiz EzyLink software.
Set Up Accounting Link
- From the main screen of Retailer, click on Tasks -> Export Accounting Data.
NOTE: If you don't see this option in the menu, please contact your local Tower Systems salesperson to purchase the Accounting Link module. - The Change Date Range screen will then appear.
- Click on Setup Acc. Link.
- A message will appear asking if you use EzyLink. Click on Yes.
- The Setup Accounting Link screen will appear.
- You need to ensure the Terminal ID is identical to your computer name (eg. MAIN or POS1).
- The Export Directory must to set to C:\Program Files\OzBiz_Ezylink\Files. If the directory you see if incorrect, click on the yellow folder and navigate to the correct directory.
- Click on Further Settings and enter your Level D password when prompted.
- You will be shown a warning message regarding the importance of these settings. Read it, then press OK.
- In What to Export to your Accounting Program, you can tick both Arrivals Information and Returns Information if you want them transferred over.
NOTE: Transferring arrivals and returns requires that information to be 100% correct or reconciliation will become extremely difficult. - Assign the account numbers that link your Discrepancy and Freight account in your accounting program.
- If you sell Lotto products, you need to specify the departments for each item by clicking on the lightning bolt icon and selecting the respective departments.
- Click Close.
- In the Journal Entry Settings section, enter the respective account number for Clearing Account and Default Write-Offs Expense Account (eg. Clearing Account 1-1130, Write Offs Expense Account 6-1160 etc.)
- Next, click on Other Accounts.
- Select Setup Write Offs and press OK.
- Click on Add to create Write-Off Reasons and their respective Expense Account Numbers.
- Click Close.
- Repeat steps 15-18 for No Sales, Payment Types and Banking Accounts.
- Back in the Setup Accounting Link screen, type the Journal Entry Name for each department as well as its respective Income Account Number and Purchase Account Number from your accounting program.
- In the Supplier Settings section, enter the information in Supplier Name In Accounting Program as well as Supplier Card ID from your accounting program.
- The Department Listing and Supplier Listing buttons will give you a report detailing your department settings and supplier settings.
End of Shift Setup
Exporting accounting data needs to be done each time an End of Shift is performed and transferred. As such, the End of Shift should only be transferred once per day for all terminals. Follow the steps below to configure Retailer for proper End of Shift procedures.
On the SERVER/MAIN (the one backups are done on) computers:
- From the main screen of Retailer, click on the End of Shift icon.
- In the End of Shift screen, click on Setup on the bottom-left.
- In Selected Terminals, make sure All Terminals is selected.
- In Options, make sure Transfer The End Of Shift Sales? is TICKED.
- Click Proceed and click Yes to save the changes.
- Close the End of Shift screen.
On the CLIENT/POS (all other) computers:
- From the main screen of Retailer, click on the End of Shift icon.
- In the End of Shift screen, click on Setup on the bottom-left.
- In Selected Terminals, make sure This Terminals is selected.
- In Options, make sure Transfer The End Of Shift Sales? is UNTICKED.
- Click Proceed and click Yes to save the changes.
- Close the End of Shift screen.
This setup allows the individual tills to be counted and reconciled but also forces the End of Shift totals from all terminals to be transferred from the Server/Main computer only.
Click HERE to learn about exporting data to Ozbiz Ezylink