What is in the MYOB import file?
Each line of the file is one block of hours: one worker, one day, one pay item and one job. MYOB uses the names and numbers in each line to find the right employee, payroll category and job, so they must match MYOB exactly.
The columns
| MYOB column | Comes from in Swift Checkin | Must match in MYOB |
|---|---|---|
| Date | Date | The day worked. |
| Employee Card ID | Payroll Id | The employee's card ID. |
| Employee First Name | First Name | The employee's first name. |
| Employee Co./Last Name | Last Name | The employee's last name. |
| Payroll Category | Pay Item | The payroll category name, for example Base Hourly. |
| Units | Hours | The number of hours. |
| Job | Project Number | The job number. |
You choose which Swift Checkin field goes in each column in Map MYOB Import Columns. See How do I map MYOB import columns?
Why the Job column matters
MYOB uses the Job number to recognise a line it has seen before. Always include it. Without it, MYOB treats every line as new, which can create duplicates. See Why are there duplicate entries in MYOB?
Example
Tom worked 8 hours on 14 October at Harbour Apartments (project number HA102). The line in the file looks like this:
| Date | Employee Card ID | Employee First Name | Employee Co./Last Name | Payroll Category | Units | Job |
|---|---|---|---|---|---|---|
| 14/10/2026 | EMP017 | Thomas | Nguyen | Base Hourly | 8 | HA102 |
MYOB imports it only if card ID EMP017, the name Thomas Nguyen, the payroll category Base Hourly and job HA102 all exist in MYOB as written.