Help

Home  Import Export Feature

Zoho Invoice facilitates importing data from other invoicing software to Zoho Invoice. Our enhanced import-export feature has made data migration simpler and easier with the help of a wizard that guides you through the entire process in three steps. Zoho Invoice supports CSV or TSV file formats only for importing data. You can import or export the following into Zoho Invoice using our wizard:

Zoho Invoice supports exporting data in CSV or XLS format only.

Steps to import data from your CSV/TSV file into Zoho Invoice

Please follow the instructions below to import estimates into Zoho Invoice:

  1. Go to the "Estimates" Tab.
  2. Click on "Import Estimates" link on the side bar. This opens the "Import Estimates" page.
    select estimate
  3. Click on "Browse" button and select the file to be imported.
  4. Check the "Auto generate Estimate number" option if you wish Zoho Invoice to assign numbers to your estimate.
  5. Select either the CSV or TSV file format from the File Format drop down.
  6. Click the "Next" button to lead to the Map Fields section.
    Estimate map fields
  7. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  8. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Estimate preview
  9. If the fields have been matched you can see details of number of estimates that are ready to be imported.
  10. Click the "Import" button. You can see the message, on top of the "All Estimate" page.
    Estimate imported successfully
  11. If there is a mismatch between the fields, you can see an error message that displays why the estimate(s) could not be imported.
    Import estimate error message
  12. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  13. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  14. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your estimates file.

Steps to Import data from your CSV/TSV file into Zoho Invoice:

Please follow the instructions below to import invoices into Zoho Invoice:

  1. Go to the "Invoices" Tab.
  2. Click on "Import Invoices" link on the side bar. This opens the "Import Invoices" page.
    Select invoice
  3. Click on "Browse" button and select the file to be imported.
  4. Check the Auto generate Invoice number" option if you wish Zoho Invoice to assign numbers to your invoices.
  5. Select either the CSV or TSV file format from the File Format drop down.
  6. Click the "Next" button to lead to the Map Fields section. Here, you can instruct Zoho Invoice on how to treat your import data.
    Invoice map fields
  7. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  8. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import invoice preview
  9. If the fields have been matched you can see details of number of invoices that are ready to be imported.
  10. Click the "Import" button. You can see the message, on top of the "All Invoices" page.
    Invoice imprted successfully
  11. If there is a mismatch between the fields, you can see an error message that displays why the invoice(s) could not be imported.
    Import invoice error message
  12. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  13. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  14. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your invoices file.

Steps to import items into Zoho Invoice

Please follow the instructions below to import items into Zoho Invoice:

  1. Go to the "Items" sub-link under "Estimates" or "Invoices".
  2. Click on "Import Items" link on the side bar. This opens the "Import Items" page.
    Select Items
  3. Click on "Browse" button and select the file to be imported.
  4. Select either the CSV or TSV file format from the File Format drop down.
  5. Click the "Next" button to lead to the Map Fields section.
    Item map fields
  6. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  7. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import item preview
  8. If the fields have been matched you can see details of number of invoices that are ready to be imported.
  9. Click the "Import" button. You can see the message, on top of the "Active Items" page.
    Item imported successfully
  10. If there is a mismatch between the fields, you can see an error message that displays why the item(s) could not be imported.
    Import item error message
  11. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  12. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  13. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your items file.

Steps to import Recurring Invoices into Zoho Invoice

Please follow the instructions below to import recurring invoices into Zoho Invoice:

  1. Go to the "Recurring Invoices" sub-link under "Invoices".
  2. Click on "Import Recurring Invoices" link on the side bar. This opens the "Import Recurring Invoices" page.
    Select recurring invoice
  3. Click on "Browse" button and select the file to be imported.
  4. Select either the CSV or TSV file format from the File Format drop down.
  5. Click the "Next" button to lead to the Map Fields section.
    Recurring invoice map fields
  6. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  7. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import recurring invoice preview
  8. If the fields have been matched you can see details of number of recurring invoices that are ready to be imported.
  9. Click the "Import" button. You can see the message, on top of the "All Recurring Invoices" page.
    Recurring invoice imported successfully
  10. If there is a mismatch between the fields, you can see an error message that displays why the recurring invoice(s) could not be imported.
    Import recurring invoice error message
  11. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  12. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  13. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your recurring invoice file.

Please follow the instructions below to import expenses into Zoho Invoice:

Please follow the instructions below to import recurring invoices into Zoho Invoice:

  1. Go to the "Expenses" tab.
  2. Click on "Import Expenses" link on the side bar. This opens the "Import Expenses" page.
    Select expenses
  3. Click on "Browse" button and select the file to be imported.
  4. Select either the CSV or TSV file format from the File Format drop down.
  5. Click the "Next" button to lead to the Map Fields section.
    Expense map fields
  6. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  7. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import expense preview
  8. If the fields have been matched you can see details of number of expenses that are ready to be imported.
  9. Click the "Import" button. You can see the message, on top of the "All Expenses" page.
    Expense imported successfully
  10. If there is a mismatch between the fields, you can see an error message that displays why the expense(s) could not be imported.
    Import expense error message
  11. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  12. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  13. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your expenses file.

Steps to import customers into Zoho Invoice

Please follow the instructions below to import customers into Zoho Invoice:

  1. Go to the "Customers" tab.
  2. Click on "Import Customers" link on the side bar. This opens the "Import Customers" page.
    Select customer
  3. Click on "Browse" button and select the file to be imported.
  4. Select either the CSV or TSV file format from the File Format drop down.
  5. Click the "Next" button to lead to the Map Fields section.
    Customer map fields
  6. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  7. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import customer preview
  8. If the fields have been matched you can see details of number of customers that are ready to be imported.
  9. Click the "Import" button. You can see the message, on top of the "Active Customers" page.
    Customer imported successfully
  10. If there is a mismatch between the fields, you can see an error message that displays why the customers(s) could not be imported.
    Import customer error message
  11. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  12. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  13. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your customers file.

Steps to import contacts persons into Zoho Invoice

Please follow the instructions below to import customer contacts persons into Zoho Invoice:

  1. Go to the "Customers" tab.
  2. Click on "Import Contact Persons" link on the side bar. This opens the "Import Contact Persons" page.
    Select contact persons
  3. Click on "Browse" button and select the file to be imported.
  4. Select either the CSV or TSV file format from the File Format drop down.
  5. Click the "Next" button to lead to the Map Fields section.
    Contact persons map fields
  6. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  7. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import contact persons preview
  8. If the fields have been matched you can see details of number of contact persons that are ready to be imported.
  9. Click the "Import" button. You can see the message, on top of the "Active Customers" page.
    Contact persons imported successfully
  10. If there is a mismatch between the fields, you can see an error message that displays why the contact person(s) could not be imported.
    Import contact persons error message
  11. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  12. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  13. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your contact persons file.

Steps to import Payments into Zoho Invoice

Please follow the instructions below to import customer payments into Zoho Invoice:

  1. Go to the "Customer Payments" sub-link under "Invoices".
  2. Click on "Import Payments" link on the side bar. This opens the "Import Payments" page.
    Select payment
  3. Click on "Browse" button and select the file to be imported.
  4. Select either the CSV or TSV file format from the File Format drop down.
  5. Click the "Next" button to lead to the Map Fields section.
    Payment map fields
  6. Select a field(s) found below the "Your Data" Column and click to map to the relevant field(s) under the "Zoho Invoice" field.
  7. Click the "Next" button to see the "Import Preview" section that displays the results of matching.
    Import payment preview
  8. If the fields have been matched you can see details of number of payments that are ready to be imported.
  9. Click the "Import" button. You can see the message, on top of the "All Payments" page.
    Payment imported successfully
  10. If there is a mismatch between the fields, you can see an error message that displays why the payment(s) could not be imported.
    Import payment error message
  11. You can click on "No of Records skipped" link or the "figure" link to check the error details.
  12. Click on "Unmapped Fields" link or the "figure" link to check how many fields have been mismatched with Zoho Invoice fields.
  13. Click the "Previous" button to map the above fields and then click the "Import" button to import data from your payments file.

Here is a list of some specific problems that you might come across while importing data into Zoho Invoice.

  • File Types with extension not supported.
    This error occurs when you have chosen a file format that is not supported by Zoho Invoice. Verify if you have selected a file with the extension supported in the file format displayed in the drop-down. Data will be imported into Zoho Invoice only if your file has a .csv or .tsv extension.
  • The import data does not match with the file format selected below. Please check your data and the file format.
    This error message indicates that the file for upload has a different format from the one you have chosen from the File Format drop-down. To proceed further, ensure that the file you selected to upload and the file format chosen from the file format drop-down are the same. Select a CSV file if you have chosen the CSV file format. Alternatively select a TSV file if you have chosen a TSV file format in the drop down.
  • Mapping for one or more mandatory Zoho Invoice fields is missing.
    This error message indicates that you haven't mapped certain mandatory Zoho Invoice fields to fields in your import data, without which you will not be able to proceed with the import. For example, to import items you should definitely have fields from your import file that are mapped to mandatory Zoho Invoice item fields. Item Code and Rate are mandatory fields that need to be mapped while importing items.
  • Same Column header has been matched with multiple columns.
    This error occurs when there is a duplicate mapping with Zoho Invoice fields. Check if you have mapped the same column header from your import data to one or more Zoho Invoice fields. To proceed further, select a different column header from your import file and map it to a Zoho Invoice field.

To export estimates from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Estimates" tab.
  2. Click on "Export Estimates" link on the sidebar of the page.
    Export estimates
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export invoices from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Invoices" tab.
  2. Click on "Export Invoices" link on the sidebar of the page.
    Export invoices
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export items from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Items" sub-link under "Invoices".
  2. Click on "Export items" link on the sidebar of the "Active Items" page.
    Export items
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export recurring invoices from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Recurring Invoices" sub-link under "Invoices".
  2. Click on "Export Recurring Invoices" link on the sidebar of the "All Recurring Invoices" page.
    Export recurring invoices
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export expenses from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Expenses" tab.
  2. Click on "Export Expenses" link on the sidebar of the "All Expenses" page.
    Export expneses
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export customers from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Customers" tab.
  2. Click on "Export Customers" link on the sidebar of the "Active Customers" page.
    Export customers
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export contact persons from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Customers" tab.
  2. Click on "Export Contact Persons" link on the sidebar of the "Active Customers" page.
    Export contacts
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

To export payments from Zoho Invoice, please follow the steps mentioned below:

  1. Go to the "Customer Payments" sub-link under "Invoices".
  2. Click on "Export Payments" link on the sidebar of the "All Payments" page.
    Export invoice payment
  3. Click on the Export formats drop-down and select the desired format.
  4. Click on the "Export" button to export data from Zoho Invoice.

Got more questions?

Submit your request to us and we will help you out.

Zoho Invoice Import Export Feature

Spread the Word

© 2013, ZOHO Corp. Invoice Software 4900 Hopyard Rd, Suite 310, Pleasanton, CA 94588, USA Support: +1 888-900-9646 | Sales: +1 888-204-3539,