Trade Trak to MYOB AccountRight Import

Please note:
We are in the process of updating our help guides. In the past few months, there have been many upgrades to the app, so we apologise if the instructions do not match your use. If you are having trouble location or using a feature, please use the in-app chat feature to get in touch with the Trade Trak development team.

Trade Trak supports the exporting of data into a MYOB specific csv format for easy importing into MYOB AccountRight.

The video below shows the full end-to-end process of configuring Trade Trak to suit your MYOB Sales GL account, the exporting of clients and invoices from Trade Trak, and the importing of this data into MYOB AccountRight.

Additionally, the help guide below has detailed instructions and screenshots for:

1. Setting up your MYOB Sales GL Account Number.
2. Exporting Trade Trak Clients (MYOB Customer Cards)
3. Exporting Trade Trak Invoices (MYOB Sales / Service Sales)
4. Importing Trade Trak Clients into MYOB
5. Importing Trade Trak Invoices into MYOB

Set up MYOB Sales GL Account Number

Before starting any import process into MYOB, you must set a GL account code in Trade Trak to reflect what sales code you would like the invoices to be assigned to. This may be something like "4-1600". At this stage, Trade Trak only supports one GL code for exports. If you require two codes (e.g. one for materials and one for labour), you will need to manually edit imported invoices in MYOB.

To set your GL account code:

1. Press your name at the top right of the app to open the navigation menu.
2. Press Company Settings
3. Press Integrations
4. Under MYOB Invoicing Account Number, set your GL code for sales.
5. Press Save.

Export Trade Trak Clients (MYOB Customer Cards)

For invoices to be created in MYOB via the import function, a customer card must exist. If you have all your MYOB customers in Trade Trak and vice-versa, this step will not apply. However, if required, you can export all clients from Trade Trak and import into MYOB. Please be aware that this step does not check for duplicates. It is only recommended if you do not have your Trade Trak customers set up in MYOB.

To export Trade Trak clients in a MYOB AccountRight ready format, access the Data Management section, by:

1. Press your name at the top right of the app to open the navigation menu.
2. Press Company Settings
3. Press Data Management

When in data management, scroll to the "Accounting Exports" section, ensure "MYOB" is selected, then select Clients and press Export Data. This will email you a copy of the csv file with all your clients in the MYOB format.

Exporting Trade Trak Invoices (MYOB Sales / Service Sales)

You can quickly export your invoices from Trade Trak into a MYOB AccountRight friendly format.

To export Trade Trak invoices in a MYOB AccountRight ready format, access the Data Management section, by:

1. Press your name at the top right of the app to open the navigation menu.
2. Press Company Settings
3. Press Data Management

When in data management, scroll to the "Accounting Exports" section, ensure "MYOB" is selected and then select Invoices and press Export Data.

Once Invoices has been selected, you will see some additional options appear:

• Created date range (start to end)
• Invoice status
• Job

This allows you to filter what invoices you are exporting from the system.

We recommend exporting on a recurring and consistent period so that no invoices are missed or duplicated. For example, you may:

• Export invoices daily, for the previous business day
• Export invoices weekly, for the previous week
• Export invoices monthly, for the previous month.

Once you have entered your date range, press Export Data. You will then receive an email with the csv file ready for import into MYOB.

Importing Trade Trak Clients into MYOB

To import clients, or Customer Cards in MYOB, you will need to export the data per the above steps, and then follow these instructions:

1. Open your MYOB AccountRight application and company file
2. Press File and select Import/Export Assistant
3. Select Import data, press next
4. Select "Import: Cards" and "Cards type: Customer Cards"
5. Select using the file picker your clients csv file (by default, it is called "clients_accounting_export - myob_export.csv") -- Note: you must change the file type to from "Text Files" to "All Files" -- press next
6. Match the data fields to the correct MYOB fields (the names will be the very similar), press next
7. Back up your your company file, if required, press Import
8. Import conclusion screen appears. Note, that there will be some skipped blank link items. View the log file for any errors.

Importing Trade Trak Invoices into MYOB

To import invoices, or Sales in MYOB, you will need to export the data per the above steps, and then follow these instructions:

1. Open your MYOB AccountRight application and company file
2. Press File and select Import/Export Assistant
3. Select Import data, press next
4. Select "Import: Sales" and "Sales type: Services Sales"
5. Select using the file picker your clients csv file (by default, it is called "invoices_accounting_export - myob_export.csv") -- Note: you must change the file type to from "Text Files" to "All Files" -- press next
6. Press "Auto Match" to automatically match the data fields to the correct MYOB fields, press next
7. Back up your your company file, if required, press Import
8. Import conclusion screen appears. View the log file for any errors.