Skip to main content
Import Invoices from a Spreadsheet

More than one invoice can be imported from a spreadsheet

Updated over a year ago

Before importing, the customer/company and contact at the company (if set in the import) need to be in Zigaflow. Otherwise, the import will fail.

These columns are compulsory in the import file:

  • ID - this is just the reference from the previous system, such as the quote number

  • Status (the Zigaflow status)

  • Company

  • Assigned User Email - the user the quote will be assigned to in Zigaflow

  • Initial Assigned User Email - the initial user the quote will be assigned to in Zigaflow

  • Invoice Date

  • Payment Date
    โ€‹

1. Click on the Cog

2. Click "Import Center"

3. Click "Invoices"

4. Click "Download Template" for the template spreadsheet

5. More than one invoice can be imported at a time.

The template consists of three areas: header, section name, and item details.

6. For each item in an invoice, there needs to be a complete row. This means that the master invoice details, such as the customer name or note, need to be repeated on each line. Similarly, the section name (if given) needs to be repeated for all the items in the section.

7. Drag and drop the file here

8. Click "Upload"

9. The banner shows the success or failure of the import

10. The original ID/Reference from the previous system is appended to the descriptio

Did this answer your question?