Tasks can be bulk imported into WorkGuru using the task import function and the CSV Import Template.  Note: there is a lot of field validation to ensure that consistent data is imported into WorkGuru - eg pricing tiers must be a number (can't be blank etc).


WorkGuru Task Import Template Import Field Definitions

Name
Task Name
Required
Description
Task Description

UnitCost
Hourly cost rate for the Task.  Cannot be blank and must be a number.  Enter a 0 (zero) if no rate required.
Required
Rate
Hourly billable sell rate for the Task.  Cannot be blank and must be a number.  Enter a 0 (zero) if no rate required.
Required
AccountCode
Xero alternate GL sales account number. eg 200. This must match an existing code exactly

SellTaxCode
Xero sales tax code.  Case sensitive and must match exactly.  eg GST on Income

SellTaxRate
Tax rate. Must be a number eg 10 for 10% GST
Required
CostMultiplier
Numerical multiplier to be used for correct costing of staff base rates for timesheets on tasks used for capturing penalty rates. (Usually 1.  1.5, 2 etc used for time and a half, double-time)
Required


Optional Task Import Field Definitions

Pricing Tiers - You can import your alternate task pricing tiers via additional columns with the pricing tier name (case sensitive) as the header name.   Eg If the price tier names are Wholesale and Trade, the import template would look like this:

Wholesale
Trade
100
90


You can upload your import template from Tasks -> Import Tasks or from the Actions menu on the Tasks Dashboard Tasks -> List Tasks

If you are experiencing errors importing your data, check here for resolutions for the most common messages or contact the WorkGuru team.