Import Timesheets
Import timesheet entries into QuickBooks Online from an Excel spreadsheet.
Complete each step below in order.
1
Connect to QuickBooks
Authorise this tool to access your QuickBooks Online company.
Connect to QuickBooks
Not connected
2
Download Template
Fill in the Excel template with your time entries, then upload it in Step 3.
Download Template
Opens as timesheet-template.xlsx
Columns: Date (yyyy-MM-dd) · Employee Name · Customer · Service Item · Hours · Description · Billable (Yes/No)
3
Import Timesheets
Upload your completed spreadsheet to import entries into QuickBooks.
You must connect to QuickBooks (Step 1) before importing.
Click to choose a file or drag and drop here
.xlsx files only
Select a file to continue
0
Imported
0
Duplicate
0
Skipped
0
Failed