Import timesheets into QuickBooks Online

You can import timesheets into QuickBooks Online from a text file, Excel file or IIF directly using Zed Axis.

  1. First connect Zed Axis to QuickBooks Online
  2. Click on the import tab and browse to the file that contains your timesheet data that you would like to import.
  3. Map the columns in your import file to the corresponding fields in QuickBooks Online
  4. Click import and the timesheet will be imported directly into your QuickBooks Online company file.


QuickBooks Online FieldFormatDescription
IdStr 21Identifier for the Time Activity required for Modify
TxnDateDateThe date of the time activity
NameOfEnumMANDATORY Values of Vendor or Employee
EmployeeVendorRefNameStrMANDATORY - Name of the employee or vendor recording time activity, displayed as FirstName LastName
CustomerRefNameStrFull Customer Job name for the time entry (required if Billable Status = Billable)
DepartmentRef Name Name of the department
ItemRef Name Service Item name for the time entry
Class Ref Name Class reference
Billable StatusEnumBillable status - Billable or NotBillable
TaxableBooleanTrue if the time entry is billable and taxable
Hourly RateDecimalHourly bill rate for this time activity (required if Billable Status = Billable)
Durationhh:mmMANDATORY Duration of the time entry, in format of hh:mm
Break Durationhh:mmBreak duration for time entry in format hh:mm
Start TimeDateTimeTime work started format as yyyy-mm-ddThh:mm:ss
End TimeDateTimeTime work ended format as yyyy-mm-ddThh:mm:ss
DescriptionStrDescription of work completed


By Steve Batten



Add Feedback
Is there a way to import time for payroll? If this is the way where does the payroll item go? (Regular overtime Doubletime etc.)
Brad Williams (March 20, 2019 at 3:49 PM)
Sorry at the moment we cant import the Payroll item on Timesheets into QuickBooks Online, we are hoping to add that field in an update
Steve (May 28, 2019 at 12:46 AM)
is the payroll item available yet?
Brad Williams (June 26, 2019 at 10:55 PM)
Hi Brad, we just added that in the V14.1 release.
Steve (April 14 at 10:42 PM)
I'm trying to import time entries into Quickbooks Online, using the above mapping, and Zed Axis just stops at the end of the validation. Validates 1000 of 1000 records, then an error pops up "Error occurred while importing data to Quickbooks. Please check log file." But no log file is created, and none of the 1000 rows are listed as an error. Only 1 row is listed, and that has the status "Pending". Any suggestions?
Andrew Shelley (March 27, 2019 at 8:48 AM)
Worked it out - I needed to have 'auto-numbering' checked.
Andrew Shelley (March 28, 2019 at 1:42 AM)
The HourlyRate column is not mapping and I have no idea why. I have it mapped, but it is just not showing up when I hit save as one of the mapped columns.
Rachel Smith (June 5, 2019 at 11:15 PM)
Can you please check to make sure there is not a # or $ symbol in the header row, if so please remove that and try again.
Steve (June 6, 2019 at 6:57 AM)

Add Feedback