Once you've approved all employee timesheets, you can export your pay period and import it into Sage 50 to process payroll.
Step 1: Finalise your pay period
We recommend finalising your pay period before exporting it to help prevent any changes or errors.
To finalise a pay period:
Go to Attendance
Click the pay period status next to the date
Change the status to Finalised.
Step 2: Export your pay period
Once your pay period has been finalised, you're ready to export it.
Click Export Pay Period in the top-right corner
Select Sage 50
Choose whether you want to export payroll for all branches and positions
Click Export
Save the exported file to your computer.
Step 3: Import the file into Sage 50
Open Sage 50 and:
Go to File > Import/Export.
Select Import Timesheets.
The Timesheet Import Wizard will open.
Configure the import
On Page 3 – Data Format, use the following settings:
Separators: Each field is separated by a comma. Decimals are indicated by a dot.
Format: Date = yyyy-MM-dd and Time = Numeric
On Page 4, review any fields that haven't already been mapped in Sage 50, then complete the import.
Step 4: Complete your payroll
Once the timesheets have been imported:
Select Payroll Cheque Run from the main menu
Choose the correct pay period
Open the Payroll tab
Select Add Timesheet and Timesheet Hours
Choose the dates for the pay period you're importing
Click OK.
The imported hours will be added to the payroll, and you can continue processing payroll as you normally would.