TimeSite Pro integrates with a number of Payroll applications including MYOB (both cloud- and file-based), HR3 (both cloud- and file-based), KeyPay, Sage, Quicken and Xero. To set up your export settings to your payroll package, go to Settings > Export Timesheets > Settings and pull down on Export To to select your payroll package and click Save. Note that users must be granted access to the Export Screen in their Security settings in their User record.
See Process and export timesheets for payroll for more details on how to export timesheets (and MYOB activity slips) to your payroll or accounting package.
Select Enable advanced timesheet exporting to access a range of advanced export options in the Export screen. This feature enables you to filter and export timesheet records for use in a variety of reporting and invoicing applications. See Advanced Timesheet Export for more information.
Once you have connected TimeSite Pro to your payroll system, then you can map your task types to payroll categories. Refer to our help article for more information on Payroll Mapping to Task Types. You can delete the mappings that we have set up by clicking on the Disconnect from button to disconnect from your payroll system and then clicking on the Delete Mappings button.
- Export to CSV
- Export to HR3 and HR3 Online
- Export to MYOB - Cloud-based integration
- Export to MYOB - File-based integration
- Export to MYOB Advanced
- Export to Quicken
- Export to ReckonOne
- Export to Sage
- Export to Text File
- Export to Xero
Export to CSV
Select Export to CSV if you want to create a simple timesheet export file that can be imported into a variety of payroll systems. The export to CSV does not require any mapping to payroll category.
Export to HR3 and HR3 Online
If you are using HR3's API integration, contact your HR3 support desk for more information on your REST Service location URL and API Key that TimeSite Pro needs to connect to your HR3 account. See HR3's Integrations page for more information on their API integration capabilities. Select HR3 if you want to export a timesheet file from TimeSite Pro that you can import directly into HR3.
TimeSite Pro can integrate directly with your KeyPay account to enable you to export timesheet records. Select Keypay from the list of available payroll system in the Export to pulldown menu and click on Save. The KeyPay integration panel will be displayed.
Go to your Account Details screen in KeyPay and copy the API Key (1).
Paste the API Key into the API Key field in TimeSite Pro and click on Save. Click on Connect to your KeyPay Business, select the business name that is to receive the timesheet records and click on Select.
TimeSite Pro will then download your Work Types and Expense Categories from KeyPay and populate your payroll mapping from Task Type to KeyPay Work Type and Expense Category in Settings > Payroll Mapping > Task Type.
Export to MYOB - Cloud-based integration
TimeSite Pro can export timesheet records and activity slips directly into your online MYOB account. To assist you in mapping your timesheet data to MYOB, we will automatically download your MYOB payroll categories into your TimeSite Pro configuration settings when you first connect to MYOB.
Select whether you want to send timesheet or activity slips to MYOB AccountRight or both types of information. Timesheets will be exported to the payroll module. Activity slips will be exported to the billing module in MYOB AccountRight. TimeSite Pro will also export client (MYOB cards) and project (MYOB jobs) to MYOB AccountRight if these details are not already available.
Enable Use the Activity rate instead of the TimeSite Pro bill rate if you want to use the bill rate already set up in MYOB AccountRight for invoicing purposes. Note that if these billing rates are different, then TimeSite Pro may not report the same revenue totals for projects in TimeSite Pro compared to the job revenue reported by MYOB AccountRight.
Enable Create Spend Money records for disbursements if you want TimeSite Pro to create Spend Money records in MYOB AccountRight to record the payments for expenses such as petrol, office stationery, phone bills that have been entered into TimeSite Pro as non-time related timesheet records. You should then select an MYOB expense account using the pulldown Pay from this account for Spend Money records.
Click on Save when you make any changes to these Export Settings.
Select Connect to MYOB to log in to your MYOB account. Enter your MYOB login email and password and TimeSite Pro will be authorised to export Timesheets and/or Activity slips directly to your MYOB account.
Once logged in, TimeSite Pro will download your payroll categories and apply then to your Payroll Mapping settings. Review these setting to complete your MYOB Cloud configuration. If you want to delete these mapping details, click on Disconnect from your MYOB account and then click on Delete Mappings to reset the payroll mapping that TimeSite Pro has established so that you can set them up manually.
Note that TimeSite Pro will only return payroll categories that are hourly-based including leave-related payroll categories. MYOB will not return salary-related payroll categories
Export to MYOB - File-based integration
TimeSite Pro can export a delimited .txt file in the format required by MYOB's timesheet import feature. Select whether you want to export Timesheets or Activity Slips to MYOB or both via the export file. You can also select that you want export Activity Slips instead of invoices from the Invoice panel. See MYOB's help article on Creating activity slips for more information on their time-billing feature.
Export to MYOB Advanced
TimeSite Pro can export timesheet records into your MYOB Advanced payroll system. Some configuration settings need to be completed by TimeSite support staff. Please contact TimeSite Support once you have entered your connection details and tested your connection to your MYOB Advanced account.
Export to Quicken
Contact TimeSite Pro for more information on our Quicken integration. See How do I contact TimeSite for support or assistance?
Export to ReckonOne
Contact TimeSite Pro for more information on our ReckonOne integration. See How do I contact TimeSite for support or assistance?
Export to Sage
TimeSite Pro can export a delimited .txt file in the format required by Sage's timesheet import feature. Sage requires an employee number which can recorded via Admin > User > [select user] > Details > Employee Number. The export to Sage does not require any mapping to payroll category.
Contact TimeSite Pro for more information on our Sage integration. See How do I contact TimeSite for support or assistance?
Export to Text File
Select Export to Text File if you want to create a simple delimited timesheet export file that can be imported into a variety of payroll systems. The export to Text File does not require any mapping to payroll category.
Export to Xero
Select Xero in the Export to pulldown menu and then click on Save. You will then see the Connect to Xero button.
Click on the Connect to Xero button and you will go to the Xero login page.
Enter your Xero login details and TimeSite Pro will be authorised to export Timesheets directly to your Xero account.
Click on Allow access and TimeSite Pro will automatically download your Xero Pay Items for Earnings and suggest mappings to your TimeSite Pro Task Types. You will see an information message confirming that we have downloaded these details.
Go to Settings > Export Timesheets > Payroll Mapping > Task Types to review these suggested mappings.
If you want to delete these timesheet mapping details, you can disconnect from your Xero account and then click on Delete Mappings to reset the payroll mapping that TimeSite Pro has established so that you can set them up manually.
Please sign in to leave a comment.