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.