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 Field Format Description
Id Str 21 Identifier for the Time Activity required for Modify
TxnDate Date The date of the time activity
NameOf Enum MANDATORY Values of Vendor or Employee
EmployeeVendorRefName Str MANDATORY - Name of the employee or vendor recording time activity, displayed as FirstName LastName
CustomerRefName Str Full 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 Status Enum Billable status - Billable or NotBillable
Taxable Boolean True if the time entry is billable and taxable
Hourly Rate Decimal Hourly bill rate for this time activity (required if Billable Status = Billable)
Duration hh:mm MANDATORY Duration of the time entry, in format of hh:mm
Break Duration hh:mm Break duration for time entry in format hh:mm
Start Time DateTime Time work started format as yyyy-mm-ddThh:mm:ss
End Time DateTime Time work ended format as yyyy-mm-ddThh:mm:ss
Description Str Description of work completed

 

By Steve Batten

 

Add Feedback