When you need this
You process payroll in MYOB AccountRight or MYOB Business and want approved hours and leave from a SprintSuite pay run imported as MYOB timesheets, instead of entering them by hand.
Before you start
MYOB Payroll is on for the billable company, and every shift type, leave type and allowance is mapped. See Map MYOB payroll categories.
Each staff member's first name and last name in SprintSuite match their MYOB employee card exactly. MYOB uses the names to find the employee.
Timesheets are turned on in your MYOB payroll setup.
If you track jobs in MYOB, SprintSuite job numbers match your MYOB job numbers.
Steps
1. Export from SprintSuite
Approve the timesheets and leave for the pay period as usual.
Go to Staff Times and open the Pay Runs tab.
Find the pay run by its start and end dates, and click Export MYOB on that row.
Save the file.
Three columns on the Pay Runs list track the export:
Column | Shows |
MYOB Export Status | Whether the pay run has been exported. It shows Not Exported until you export. |
Last Exported to MYOB | When it was last exported |
Last Exported By | Who exported it |
2. Import into MYOB
In MYOB, open File → Import/Export Assistant and choose to import Timesheets.
Select the file, match the fields, and finish the import.
Review the import log, then process the pay run in MYOB.
What's in the file
Column | Comes from |
Employee Co./Last Name | Staff last name |
Employee First Name | Staff first name |
Employee Card ID | Optional employee identifier |
Payroll Category | The mapped category for the shift type, leave type or allowance |
Job | The SprintSuite job number |
Date | Shift or leave date, DD/MM/YYYY |
Units | Hours worked or taken |
Start time / End time | Shift start and finish, HH:MM |
The file includes approved shift hours, approved leave taken in the pay period, and allowances.
What success looks like
The pay run's MYOB Export Status updates, with the date and your name under Last Exported.
MYOB imports every line with no unmatched employees and no categories to allocate.
Each employee's hours in MYOB match the SprintSuite pay run.
If it fails
Employee not found → the SprintSuite name doesn't exactly match the MYOB employee card. Fix one to match the other, then re-import.
MYOB asks you to allocate a category → that shift type, leave type or allowance isn't mapped. Map it, then export again.
Category not found → the mapped name doesn't match MYOB exactly. Correct it on Payroll Categories.
Job not found → create the job in MYOB, or correct the job number in SprintSuite.
Hours missing → check the timesheets or leave were approved and fall within the pay run dates.