Importing invoices using a CSV file allows you to quickly add multiple invoices in one go instead of creating them manually. This method helps maintain accuracy, saves time, and keeps your billing records organized. By using the correct format, you can upload invoices without errors.

TABLE OF CONTENTS

• What You Need Before Uploading
• Example CSV Format
• How to Import Invoices
• Common Mistakes to Avoid
• FAQs
• Need Help?

What You Need Before Uploading

Before uploading your file, make sure your CSV is properly formatted. The system depends on exact column names and valid data. Even small mistakes, like incorrect headers or missing values, can cause the import to fail.

Required Fields (Must Match Exactly)

Certain fields are mandatory and must be included exactly as listed. Each row must contain valid data for these fields.

Required fields include:

• Invoice number
  
  

• Invoice name
  
  

• Customer name
  
  

• Customer email
  
  

• Issue date
  
  

• Due date
  
  

• Currency
  
  

• Item name
  
  

• Item rate

These fields define the core structure of your invoice and cannot be skipped.

Optional Fields (Optional but Helpful)

You can also include additional fields to enhance your invoices. These may include:

• Payment terms
  
  

• Item description
  
  

• Quantity
  
  

• Tax details
  
  

• Discounts
  
  

• Payment status

These fields are optional but useful for better tracking and reporting.

Example CSV Format

Below is a simple example of a properly formatted CSV:

*InvoiceNo,*InvoiceName,*CustomerName,*CustomerEmail,*IssueDate,*DueDate,*Currency,*ItemName,*ItemRate INV001,Web Design,John Doe,[email protected],03/01/2025,03/31/2025,USD,Homepage Design,300

How to Import Invoices

This image shows where to begin the invoice import process.

Go to the Invoices section, click New, and select Import Invoices from CSV.

Upload Your File

Upload your CSV file by clicking to select it or dragging and dropping it into the upload area.

Check & Map Fields

Review how your CSV columns match the system fields. Confirm everything is mapped correctly.

Fix Errors (If Any)

If errors appear, update your CSV file and upload it again until all issues are resolved.

Finish Import

Once everything is correct, complete the import. Your invoices will be created and available for use.

Common Mistakes to Avoid

Most errors come from simple issues like incorrect column names, missing required fields, invalid date formats, or duplicate invoice numbers. Double-check your file before uploading to avoid these problems.

FAQs

Q: Can I add multiple items to one invoice?

Yes, use the same invoice number across multiple rows to include multiple items.

Q: What happens if required data is missing?

The import will fail, and you will need to fix the file before trying again.

Q: Can I update existing invoices using CSV?

No, this process only creates new invoices.

Q: Do I need to include optional fields?

No, optional fields can be left blank.

Need Help?

If your import isn’t working, check your column names, required fields, and date formats. If you’re still stuck, reach out to support for assistance.