Why are there duplicate entries in MYOB?
Usually the Job number was missing. MYOB uses the Job number to recognise a line it has already imported. Without it, MYOB treats the line as new and creates a second entry.
Common reasons
| Why | What to do |
|---|---|
| The file has no Job column, or the Job is empty. | Map Project Number to MYOB's Job column in Map MYOB Import Columns. |
| The project has no project number. | Add the project number on the project, matching the MYOB job number. |
| The same file was imported twice, once with a Job number and once without. | Delete the duplicate entries in MYOB. |
Example
You import the 12–18 October file with Job numbers. Later you re-import it from an older template with no Job column.
- MYOB can't match the lines, so it creates new entries.
- Ravi now has two 8-hour entries for 14 October.
To fix it, delete the extra entries in MYOB, and make sure Project Number is mapped to Job before your next export.