In this article, you will learn about the job importing process in Workiz.
Workiz can help save you valuable time by importing various pieces of historical business data — including job information.
Importing overview
Here's what we can and cannot import for jobs:
What we can import | What we CANNOT import |
|
|
QuickBooks Online
If you are using or plan on using the QuickBooks Online integration in Workiz, it is not recommended to import jobs. This may result in complications with duplicate payment information.
File types
Workiz can only accept flat CSV or XLS/XLSX files for importing purposes. A flat file is a plain text file with each row representing a single, separate entity (e.g., one row = one job).
A flat CSV cannot have complex hierarchical structures or relationships between separate rows.
When compiling your data, be sure to create a separate file for each entity. If you are requesting an import of clients, jobs, leads, estimates, invoices, and items, you will need to have six separate files.
Preparing your file for import
In order to ensure a smooth and successful data migration, please review this article before creating your import file.
Job field guidelines
When importing jobs into Workiz, you will need to provide information relating to both the job and relevant client. Please prepare your import file using the exact field names seen below:
Field | Required/optional | Notes |
First name | Required |
|
Last name | Required |
|
Company | Optional |
|
Required* | May be optional if phone number is provided instead.
Can only contain one email address. | |
Phone | Required* | May be optional if email address is provided instead. |
Secondary phone | Optional |
|
Service address | Required | Can be formatted into one column or individual columns. Must include:
|
Billing address | Optional | Can be formatted into one column or individual columns. Must include:
If the billing address is the same as the service address, leave this column blank. |
Allow billing | Optional | Must be formatted as "true" or "false," where true = allow billing enabled and false = allow billing disabled.
With this setting enabled, you will be able to close jobs associated with this client despite having an outstanding balance.
If not provided, this field will be set to disabled. |
Job type | Required | Must match one of the job types that already exist in Workiz. |
Job status | Required | Must match one of the default statuses that exist in Workiz:
Sub-statuses cannot be imported. |
Job ad source | Optional | Must match one of the sources that already exist in Workiz. |
Job notes | Optional |
|
Created date | Required | Can be formatted as DD/MM/YY MM:HH AM/PM.
If not provided, this will be set to the date of the import. |
Job start date | Required | Can be formatted as DD/MM/YY MM:HH AM/PM.
Must include both date and time. |
Job end date | Required | Can be formatted as DD/MM/YY MM:HH AM/PM.
Must include both date and time. |
Job custom fields | Optional | Must match one of the custom fields that already exist in Workiz.
Follow the guidelines below based on your field type:
|
Payment field guidelines
With jobs, you can also import relevant payment information within the same file.
Field | Required/optional | Notes |
Single total | Required | Must be the final total after taxes, discounts, tips, and other total-related figures have been calculated. |
Cost | Optional |
|
Paid amount | Optional |
|
Payment date | Required | Can be formatted as DD/MM/YY MM:HH AM/PM.
Must include both date and time.
If not provided, the payment date will be set to the date of the import. |
Payment method | Required | Must match one of the default payment methods in Workiz:
If no method is provided, the payment will be logged under cash. |
Payment confirmation | Optional | May be provided for the following payment methods:
|
Job import sample file
For more help with putting together your job import file, please see the attached file below.