Overview
This article lists the columns in the quote and invoice CSV import, the values each column accepts, and how Jobber uses them to match or create clients. For the import steps, see Import quotes or Import invoices.
Quote and invoice imports can’t import custom fields, and they can’t edit quotes or invoices already in Jobber.
How Jobber matches imported quotes and invoices to clients
Every imported quote and invoice belongs to a client. Jobber looks for an existing client using these columns, in this order, and uses the first one you fill in:
- Jobber Client ID
- Client Email
- Client First Name and Client Last Name, or Client Company Name
When you fill in Jobber Client ID, Jobber ignores the other client columns. For example, if the ID belongs to Jason but Client First Name says Jane, Jobber adds the quote or invoice to Jason.
Name and email matching ignores capital letters, so “michael” matches “Michael.” Otherwise, enter client details exactly as they appear in Jobber. For example, “Mike” doesn’t match “Michael.”
When Jobber matches a client, it adds the quote or invoice to that client and doesn’t change the client’s details. A different billing address in your file doesn’t change the client’s billing address. If the property address in your file is new, Jobber adds it to the matched client as a new property.
Rows in the same file with the same client name, email, and property address all go to one client.
When no client matches, Jobber creates one. To create a client, a row needs at least:
- Client First Name or Client Company Name
- Property Street 1
- At least one line item
How Jobber matches imported quotes and invoices to properties
Every imported quote needs a property, and an imported invoice can have one. Jobber finds the property this way:
- With a Jobber Property ID: Jobber links the quote or invoice to that property and ignores the property address columns.
- Without an ID: Jobber looks for a property whose address matches every address column exactly. Abbreviations don’t match, so “LA” doesn’t match “Los Angeles.”
- With no match: Jobber creates a property from the address in your file.
Find a Jobber Client ID and Jobber Property ID
Jobber Client IDs and Jobber Property IDs exist only for clients already in Jobber. To find them, export your client list. The J-ID column holds both IDs, separated by an underscore, for example 12345_67890. The first number is the Jobber Client ID, and the second is the Jobber Property ID.
You can also find a client’s Jobber Client ID at the end of the web address on their client page.
What each status does on an imported quote or invoice
Importing never sends a quote or invoice to your client. The status column only sets where the quote or invoice starts in Jobber.
Quote Status (Draft/Awaiting Response/Approved) accepts these values:
- Draft: Saves the quote as a draft, so you can review and send it later.
- Awaiting Response: Marks the quote as waiting on your client, without sending it.
- Approved: Marks the quote as approved, without sending it, so you can convert it to a job.
Invoice Status (Draft/Sent/Paid) accepts these values:
- Draft: Saves the invoice as a draft, so you can review and send it later. A draft invoice doesn’t affect the client’s balance.
- Sent: Marks the invoice as sent, without sending it. The invoice counts toward the client’s balance and shows as Past due once its due date passes.
- Paid: Marks the invoice as paid. Jobber doesn’t record a payment, and the client’s balance doesn’t change. The invoice’s paid date is the day you import it, not its issued or due date.
How taxes work on imported quotes and invoices
Each quote or invoice uses one tax rate. The quote columns start with Quote, and the invoice columns start with Invoice.
- Existing tax rate: Enter the name in Quote Existing Tax Rate Name or Invoice Existing Tax Rate Name. The name must match exactly, or Jobber creates a new tax rate. It can also be the name of a tax group.
- New tax rate: Leave the existing tax rate column blank. Fill in Quote New Tax Rate Name and Quote New Tax Rate (Percentage), or the matching Invoice columns. Jobber creates the tax rate, but doesn’t make it your default.
- No tax rate: Jobber applies your default tax rate to taxable line items.
A row can’t have both an existing and a new tax rate. An import never changes your existing tax rates.
To import a quote or invoice with no tax, enter FALSE in every Line Item Taxable (True/False) column. The tax rate still appears on the quote or invoice, but Jobber adds no tax.
Tax Method (Inclusive/Exclusive) sets how prices handle tax:
- Exclusive: Jobber adds tax on top of the price. A $100 line item with 10% tax totals $110.
- Inclusive: The price already includes tax. A $100 line item with 10% tax totals $100.
Client columns in quote and invoice imports
Both sample files use the same client columns. Apart from the matching columns, Jobber uses them only to create a new client. An import never changes an existing client’s details.
- Name: Client Title (such as Mr, Mrs, Ms, Miss, or Dr), Client First Name, Client Last Name, and Client Company Name. Client Full Name (Display Only) only displays the full name.
- Company: Client Is a Company? (True/False). Enter TRUE to show a new client as a company.
- Contact: Client Email, Client Main Phone, Client Home Phone, Client Work Phone, Client Mobile Phone, Client Fax Phone, and Client Other Phone.
- Text messages: Client SMS Enabled Phone Number. Enter the number that receives text messages. If you leave it blank, no number receives text messages.
- Automatic messages: Client Receives Auto Visit Reminders? (True/False), Client Receives Auto Job Follow-ups? (True/False), Client Receives Auto Quote Follow-ups? (True/False), Client Receives Auto Invoice Follow-ups? (True/False), and Client Receives Auto Review Requests? (True/False). Enter TRUE or FALSE in each.
Property and billing address columns
Both sample files use the same address columns:
- Property: Jobber Property ID, Property Street 1, Property Street 2, Property City, Property State/Province, Property Zip/Postal Code, and Property Country.
- Billing address: Billing Street 1, Billing Street 2, Billing City, Billing State/Province, Billing Zip/Postal Code, and Billing Country. Jobber uses the billing address only for a new client.
Quote columns
The quote sample file uses these quote columns:
| Column | What to enter |
|---|---|
| Quote Number | Numbers only. Leave it blank to use your next quote number. |
| Quote Title | The quote’s title. |
| Quote Status (Draft/Awaiting Response/Approved) | Draft, Awaiting Response, or Approved. |
| Quote Message | A message your client sees on the quote. |
| Quote Internal Note | A note only your team sees. |
| Quote Introduction Title, Quote Introduction Body | The heading and text of the quote’s introduction. |
| Quote Contract Disclaimer | Terms or a disclaimer shown on the quote. |
| Quote Discount Type (Unit/Percentage), Quote Discount Amount (Unit/Percentage) | Unit and 25 for a $25 discount, or Percentage and 10 for 10% off. |
| Quote Deposit Type (Unit/Percentage), Quote Deposit Amount (Unit/Percentage) | Unit and 25 for a $25 required deposit, or Percentage and 10 for 10%. |
The quote tax columns are Quote New Tax Rate Name, Quote New Tax Rate (Percentage), Quote Existing Tax Rate Name, and Tax Method (Inclusive/Exclusive). See How taxes work on imported quotes and invoices.
Invoice columns
The invoice sample file uses these invoice columns:
| Column | What to enter |
|---|---|
| Invoice Number | Numbers only. Leave it blank to use your next invoice number. |
| Invoice Subject | The invoice’s subject. |
| Invoice Status (Draft/Sent/Paid) | Draft, Sent, or Paid. |
| Invoice Issued Date, Invoice Due Date | Dates in YYYY-MM-DD format. |
| Invoice Discount Type (Unit/Percentage), Invoice Discount Amount (Unit/Percentage) | Unit and 25 for a $25 discount, or Percentage and 10 for 10% off. |
| Invoice Internal Note | A note on the invoice that only your team sees. |
The invoice tax columns are Invoice New Tax Rate Name, Invoice New Tax Rate (Percentage), Invoice Existing Tax Rate Name, and Tax Method (Inclusive/Exclusive). See How taxes work on imported quotes and invoices.
Line item columns
Each quote or invoice can have up to 100 line items. Each line item uses its own numbered set of columns, starting with Line Item 1. The sample files include 10 sets, so add a set of columns for each line item after 10. When you import, you choose how many line items to import, up to 100.
Quotes and invoices both use these line item columns:
- Line Item 1 Category (Service/Product): Service or Product.
- Line Item 1 Name and Line Item 1 Description: The line item’s name and description.
- Line Item 1 Quantity: The quantity.
- Line Item 1 Taxable (True/False): TRUE if the line item is taxable, or FALSE if it isn’t.
Quotes also use Line Item 1 UNIT Price, the price for one unit, and Line Item 1 UNIT Cost, your cost for one unit.
Invoices use Line Item 1 TOTAL Price instead of a unit price. Enter the total for the whole line, not the price for one unit. Jobber divides the total by the quantity to set the unit price. For example, a quantity of 2 with a TOTAL Price of 200 imports with a unit price of 100 and a total of 200.