Exporting Timesheets for Quickbooks

Exporting Timesheets

1. Go to Staff > Log/Timesheets

  • Get Staff Timesheets for the date range and users to be exported

2. Click ‘Quickbooks Export to CSV’

  • The export file will have the following fields for each employee/day worked:
    • EmployeeCode
    • Date
    • StartTime
    • EndTime
    • TotalHoursWork

Importing Timesheets

The timesheets can be imported directly into the Payroll module of Quickbooks (KeyPay). To begin the timesheet import process, select 'Manage Employees' > 'Import Timesheets' on your payroll dashboard.

From here you can choose the timesheet source from the drop-down menu and select Custom file upload.

Importing Timesheets to KeyPay

Note: The employee code needs to be entered in the employee's profile in OWNA.

Still need help? Message Us