Overview
Import invoices into Jobber from a CSV file to create many invoices at once, for example when you move from another platform or bring in past invoices for your records. Each row in your file becomes one invoice, with its line items, and Jobber links it to an existing client or creates a new one.
An invoice import creates new invoices only. It can’t edit invoices that are already in Jobber, and it can’t import custom fields.
For every column you can use, and how Jobber matches invoices to clients, see Quote and invoice import columns.
Prepare your invoice CSV file
Start from the sample file so your columns match what Jobber expects.
Download invoice import sample file
To prepare your file:
- Open the sample file in a spreadsheet program, such as Excel or Google Sheets.
- Delete the example rows and add one row for each invoice.
- Save the file as a CSV file with UTF-8 encoding. If you don’t see a CSV option, look under Save As, Export, or Download in the spreadsheet program’s File menu.
Keep these rules in mind:
- Column headers: Keep the first row exactly as it is in the sample file. A renamed header might not map to the right field.
- Row limit: A file can have up to 5,000 rows. Split a longer list into more than one file.
- Accepted values: When a header lists options in brackets, such as Invoice Status (Draft/Sent/Paid), enter only one of those options.
- Dates: Use the YYYY-MM-DD format for Invoice Issued Date and Invoice Due Date, for example 2025-03-01.
- Invoice numbers: Use numbers only, such as 1001. Leave the cell blank and Jobber gives the invoice your next invoice number.
- Line item prices: Enter the total for the whole line in each TOTAL Price column, not the price for one unit.
- Symbols: Don’t use symbol fonts, such as Wingdings or Webdings.
Add more than 10 line items to an invoice
You can import up to 100 line items on each invoice. The sample file has columns for 10 line items.
To add more line items to your invoice CSV file:
- Copy the six Line Item 10 columns and paste them after the last column.
- Change the number in each copied header to 11, for example Line Item 11 Name and Line Item 11 TOTAL Price.
- Repeat for each extra line item, up to Line Item 100.
When you import, choose how many line items to import, up to 100, so it matches the columns in your file. Leave unused line item cells blank.
Import your invoice CSV file
To import your invoices:
- Select Invoices from the side navigation, then select More Actions.
- Start a new invoice import:
- If you haven’t imported invoices before: Select Import Invoice Data.
- After your first invoice import: Select Manage Imports, then New Import, then Import Invoice Data.
- Read and agree to the terms and conditions, then select Begin Import.
- Select Upload file and choose your CSV file.
- Check that each column maps to the right Jobber field, then select Continue.
- Check how the values in each column map, such as each Invoice Status, then select Continue. Choose Do Not Import for any data you want to leave out.
- Select the Invalid tab, then correct or delete each cell highlighted in red. The All and Valid tabs show every row and the rows that are ready to import.
- Select Start Import.
The import runs in the background, so you can keep working in Jobber. When it finishes, Jobber shows how many rows it imported, for example “Imported 25 of 25 rows.” Select View Imported Data to see what the import created.
Manage Imports opens the Imports page, which lists your past quote, invoice, and job imports.
Cancel or revert an invoice import
To stop an invoice import while it’s running, select Cancel Import, then select Confirm. Jobber deletes the import and removes any data it already imported.
To undo an invoice import after it finishes:
- Select Invoices from the side navigation, then select More Actions.
- Select Manage Imports to open the Imports page.
- Select the import. Its Import overview opens on the Data Imports page.
- Select Revert Data.
Fix invoice rows that don’t import
A date shows an error. The date isn’t in the YYYY-MM-DD format. Change it to that format, for example 2025-03-01.
An invoice number shows an error. Invoice numbers can only contain numbers, so a value like INV-1001 fails. Change it to numbers only, or leave it blank to use your next invoice number.
Jobber marks a cell invalid in a column with options in its header. These columns accept only the options in the brackets. Change the value to one of them, for example Unit or Percentage in Invoice Discount Type (Unit/Percentage).
A row is missing required data. Jobber needs enough information to find or create the client and to build the invoice. Add a Jobber Client ID, an exact client name, or the details for a new client: Client First Name or Client Company Name, Property Street 1, and at least one line item.
A row has both an existing and a new tax rate. Each invoice uses one tax rate. When Jobber asks, keep one and remove the other.
A column doesn’t map to a Jobber field. The header no longer matches the sample file. Change it back to the header in the sample file, or choose the right field when you map columns.
The import created a duplicate client. Jobber couldn’t match the client details in your file to the client in Jobber, so it created a new client. Merge the duplicate clients. In future imports, use the Jobber Client ID column, or enter client names and email addresses exactly as they appear in Jobber.