With AccountLinx, you can export your employees' time data from ExakTime Connect into a compatible file for MYOB. As MYOB may be customized to fit your company's needs, the default AccountLinx export for MYOB may not match your MYOB setup exactly. Please read through this article before setting up AccountLinx to understand what is needed.
If you have any questions or concerns during setup and/or use, you can contact us with the "Request Support" link at the top of the page and we will try to assist as best as possible. Keep in mind, however, that we are not MYOB support. We will try to help you as much as we can, but there are aspects of MYOB that are out of our area of expertise and your questions may be better answered by MYOB support or your trusted contact to answer/assist.
Selecting MYOB as your Exporter
- Go to Tools and click Exporter Settings....
- The Exporter Settings window should open. Click Select Exporter....
- A window with a list of available exporters should open. Select "MYOB AccountRight & Premier Accounting" and click OK.
AccountLinx Settings Unique to MYOB
The MYOB export for AccountLinx offers a variety of settings when exporting your time data to help tailor the time data to your company's needs. These settings are unique to AccountLinx and will not affect ExakTime Connect or Mobile. If any of the settings offered do not sound familiar, you may not be using the setting in MYOB and can leave it as <None>.
- Go to Tools and click Exporter Settings....
- The Exporter Settings window should open. Click Configure....
- Payroll Category Codes
- Regular - Enter the regular pay ID as used in MYOB.
- Overtime - Enter the overtime 1 pay ID as used in MYOB.
- Overtime - Enter the overtime 2 (doubletime) pay ID as used in MYOB.
- Alternative Payroll Category Mapping
- Map Payroll Category to - Specify if an alternate payroll category should be associated with specific employees, locations, or cost codes. This allows particular employees, locations, or cost codes to have an alternate set of payroll categories when exported. The related mapping screen will show fields where you can enter the payroll category that should be associated with exported time records. If an entity does not have an alternate payroll category, it will use the default payroll category instead.
- Optional Settings
- Map Rate to - Specify which entity the rate should be associated with. The related mapping screen will have additional fields for you to complete.
- Date Format - Specify the date format for the AccountLinx export.
- Payroll Category Codes
- Click OK on the Configuration window and click OK on the Exporter Settings window to return to the main page of AccountLinx.
- Click the appropriate "Map Employee/Location/Cost Code" option to see the columns from the options enabled in Step 3.
General Use of AccountLinx
After setting up the configuration of AccountLinx to better match MYOB in the previous section, you will need to:
- Map your entities so any time data associated with an ExakTime entity will match with a MYOB entity and fill in any relevant fields enabled in the previous section. Refer to the following article if you are unfamiliar with mapping your data in AccountLinx.
- After mapping your entities, you can export your time data to import into MYOB. Refer to the following article if you are unfamiliar with exporting time data from AccountLinx.
How to Import Time Data into MYOB
Please note that you must not import data when more than one user is logged in to MYOB. For more information, see the topic "Single-user file locking for special tasks" in the MYOB help file.
Import of time records to MYOB can be processed in 2 separate ways, depending on whether or not you need to track Activity IDs (Cost Codes). Refer to the appropriate MYOB application that you use below:
AccountRight Premier
If Tracking Activity IDs
- Go to File\Import Data, select Activity Slips, set the import format as listed below, then click Continue.
- Import File Format - Comma Separated
- First Record - Header Record
- Identify Employee/Vendor by - Emp. Card ID
- Select the import file that AccountLinx saved to your PC.
- On the Import Data screen, match all fields from the left column to MYOB fields based on their name.
- Check the import log for errors and warnings.
- Check the imported data under “Enter Timesheets”.
If Not Tracking Activity IDs
- Go to File\Import Data, select Timesheet, and follow the steps (2-4).
- Select the import file that AccountLinx saved to your PC.
- Match all fields from the left column to MYOB fields based on their name. DO NOT match Activity ID.
- Check the import log for errors and warnings.
- Check the imported data under “Enter Timesheets”.
AccountRight Live Plus
If Tracking Activity IDs
- Go to File | Import/Export Assistant.
- Choose Import Data and click Next.
- Select Activity Slips and then browse to the import file that AccountLinx saved to your PC. Click Next.
- For the Format screen, specify that data is separated by Tabs and that the first line contains Headers Or Labels. Match Cards using their Emp. Card ID. Then click Next.
- On the Match Fields screen, match all fields from the left column to MYOB fields based on their name. Then click Next.
- On the Import screen, back up your company file. Then click Import.
- Check the import log for errors and warnings.
- Check the imported data by going to Payroll | Enter TimeSheets in the Command Centre to verify that everything is imported correctly.
If Not Tracking Activity IDs
- Go to File | Import/Export Assistant.
- Choose Import Data and click Next.
- Select TimeSheets and then browse to the import file that AccountLinx saved to your PC. Click Next.
- For the Format screen, specify that data is separated by Tabs and that the first line contains Headers Or Labels. Match Cards using their Emp. Card ID. Then click Next.
- On the Match Fields screen, match all fields from the left column to MYOB fields based on their name. Then click Next.
- On the Import screen, back up your company file. Then click Import.
- Check the import log for errors and warnings.
- Check the imported data by going to Payroll | Enter TimeSheets in the Command Centre to verify that everything is imported correctly.
It is recommended to consult with MYOB for further assistance with importing and using the time data as they are more knowledgeable of utilizing their system.