Why did my MYOB export fail?
A failure can happen in two places: when Swift Checkin makes the CSV file, or when you import the file into MYOB. Most file problems come from the column mapping. Most import problems come from names or job numbers that don't match.
Failures when importing into MYOB
When some timesheets fail, MYOB emails you about them.
| Why | What to do |
|---|---|
| The worker's first name or last name in Swift Checkin doesn't match MYOB. | Make the name the same as in MYOB on the worker's app user profile. |
| The project number in Swift Checkin doesn't match the job number in MYOB. | Make the project number the same as the MYOB job number. |
| The Employee Card ID doesn't match MYOB. | Set the worker's Payroll ID to their MYOB card ID. |
| The payroll category doesn't match MYOB. | Make the pay item name the same as the MYOB payroll category. |
MYOB imports the lines that match and rejects the rest. See Why did MYOB reject some timesheets?
After you fix them, delete the current pay period's timesheets in MYOB first, then import the corrected file. If you import again without clearing the period, the hours that already went in are added a second time. For the full steps, see How do I export timesheets to MYOB?
Failures when making the file
| What you see | Why | What to do |
|---|---|---|
| Failed to export PayRun. | The MYOB column mapping doesn't match. | Check Map MYOB Import Columns, then try again. See How do I map MYOB import columns? |
| No Pay Run tab | MYOB isn't connected. | Connect MYOB in Account > Integrations, under Supported Apps for Manual Export. |
| "Name" already exists. | You already have a MYOB column with that name. | Use a different name. |
| The file isn't there yet | Exports are prepared in the background. | Wait a moment, then check Downloads. See Where do I find exported files? |
Example
You export the 12–18 October pay run and see Failed to export PayRun.
- You open Map MYOB Import Columns. A column you need for your MYOB import hasn't been mapped.
- You add the mapping and save.
- You export the pay run again. A red number on Downloads shows the file is ready.
- After importing it into MYOB, you change the pay run's Status to Submitted to MYOB.