After you have imported your Timesheets into MYOB, the Summary Screen will let you know if you have successfully imported all timesheets or any records were skipped.
If records were skipped, then you'll need to fix those errors before processing your Payroll. A record is a line of pay, so even if there is only 1 record skipped, you'll still need to fix it.
At the bottom of the Summary Screen is a link to the MYOB LOG. This is normally located in your MYOB Folder, on your computer.
Locate the folder and click on the text file called MYOB LOG. You may have more than one in the folder, so use the date modified column to locate the file with today's date.
This is an example of what the MYOB LOG will look like:
The two areas you want to pay attention to are the Summary of Errors and then the Error Codes next to each record line. To solve the error, you need to look at the error code next to each record line to see which employee and payroll category is affected. You can then use the information below for each error code to troubleshoot.
Error -216: Payroll Category not found
This can occur with both the Tanda Managed Award Template and Custom Rules. It means either the Payroll Category hasn't been created in MYOB or it there is a spelling mistake.
For the Managed Award Template, all the Items in the Configuration Report need to be created as Payroll Categories in MYOB. To check this, in Tanda go to Payroll > Payroll Manager > Manage Award > Get MYOB configuration report:
When you click on the button the report will generate and display the new Payroll Categories that must be created to match to in MYOB:
If you have already entered these, double check the spelling and spaces (it is more accurate to click COPY and paste into the field in MYOB).
For Custom Rules, this either means there isn't a Payroll Category in MYOB or the Award Rule in Tanda hasn't been matched against the Payroll Category in MYOB. To check this:
In MYOB, go to Payroll > Payroll Categories > Wages. Check the relevant Payroll Category or create it if it wasn't there by clicking New.
In Tanda, go to Payroll > Award Rules (or Allowances) > click on the relevant rule and check that the Export name is linked with the relevant Payroll Category in MYOB:
Error - 217: Payroll Category is not linked to employee
This means the Payroll Category hasn't been linked with the employee. In MYOB go to Card File > Cards List > click on the relevant employee > Payroll Details tab > go to Wages > in the Wage box at the bottom, ensure there is a tick next to the Payroll Category that had the error line against it and press OK to save:
Error -218: Payroll category is not an hourly wage category.
For Custom Award rules, this error will come up if the Payroll Category is not setup as Hourly.
In MYOB, go to Payroll > Payroll Categories > Wages tab > click on the relevant Payroll Category and ensure it is selected as Hourly:
Error -296: Employee not found
This means either the employee hasn't been added to MYOB or there is an issue linking the employee with the Card ID from Tanda.
First, check that you have added the employee to MYOB under Card File > Cards List > Employee. Add them if they weren't in your Employee List.
Next in Tanda, go to the employee's profile by clicking on Workforce > Staff > click the employee's profile > click on Payroll tab:
Ensure the Employee ID entered matches with the Card ID in MYOB. You might also want to check that when you're importing the Timesheets into MYOB, you're matching by Card ID and not Last Name, as differences in spelling or hyphens in one system and not the other can cause this error, which is why we use Card ID to match instead
- If records are not importing for some staff, make sure that you are deselecting the Emp. Co./Last Name field when doing a timesheet import. This ensures MYOB checks for staff based on their Card ID (Tanda unique ID).
- If you get an error while attempting to import the file into MYOB, make sure you don’t have it open in any other programs (such as Notepad).
- Tanda uses “Base Hourly” as the default payroll category, so data that has not been matched to a specific payroll category will be entered into that one. Some old versions of MYOB use “Basic Hourly” instead of “Base Hourly”. You can either update it in MYOB to Base Hourly, or in Tanda under Payroll > Award Rules > Base Hourly > ensure the export name says Basic Hourly.
- If MYOB says that your timesheets have been imported successfully, but they are not showing up showing up in MYOB’s timesheets section:
- Check that the correct payroll year is open. Check by going to File > Close Payroll Year.
- Check that you have selected the correct Pay period start and Pay period end in Process Payroll:
- Check that your computer’s date format matches what you expect. If your computer is set to use American date formats, then the date formats Tanda exports won’t work because MYOB will mix around the months and days. In your Control Panel’s Region settings you can change the date format - we recommend English (United Kingdom).
Once you have fixed all the errors, you'll need to generate new export file from Tanda. If you use the same one (with everyone's data in it), it will duplicate the data for all the Timesheets that imported successfully.
You will need to download an individual export file for each employee that had an error. To do this, in Tanda go to Timesheets > Weekly (or Fortnightly) > click on the relevant employee's name > in the top right corner of their Timesheet click Export to > select MYOB AccountRight Desktop:
Repeat this process for every other employee that had an error and then follow the process as before to import the Timesheet into MYOB.
If you have tried troubleshooting the errors in your Timesheet Export but you're still having issues or you just need a bit more assistance, please don't hesitate to contact Tanda Support on 1300 859 117 or firstname.lastname@example.org