QuickBooks Online makes it easy to import timesheets from a CSV (comma-separated values) file. The CSV file must be in a specific format in order to be imported successfully. Most timesheet formats can be imported, as long as they meet the requirements outlined below.
- The file must be in a CSV (comma separated) or TSV (tab separated) format
- There can only be one timesheet entry per line
- Each timesheet line requires, at minimum:
- Start/End date/time or Date + Units
- Employee
- Go to Payroll and select Employees (Take me there).
- Select Manage Employees, then select Import Timesheets.
- From the dropdown, select Custom file upload.
- Browse and select the file to upload.
- Select Confirm upload?.
- Once the upload is complete, set the Date format of the file.
- The next step is to configure the type of data for each column. A preview of the first few lines of each column are shown to help you map each column.
- Choose whether the timesheets are automatically approved or if they should go through the standard timesheet approval workflow.
- Once the columns are mapped, select Import.
Note: If timesheets are included in a pay run, they may not be replaced.
Once the upload is complete, any errors will be shown. If there are no errors, then your file is ready to be imported. If there are errors, you can either fix them and re-upload the file, or reconfigure the columns and try again.
If the import is successful, you should see a message indicating that the import was successful and how many records were imported. You can also select Save timesheet format so you can re-use the template later.