Overview

You can transfer invoices directly into your CRM by uploading a properly formatted CSV file. This guide covers:

  1. Required CSV headers and their purposes
  2. Optional columns you may include
  3. How to upload and map fields
  4. Troubleshooting and finishing the import


Required CSV Columns

The following columns (marked with *) are mandatory. Make sure they appear exactly as shown and have valid data in each row.

HeaderDescriptionSample DataMandatory?
*InvoiceNoUnique identifier for the invoice1001Yes
*InvoiceNameTitle or reference name for the invoiceWeb Design InvoiceYes
*CustomerNameFull name or company name of the customerJane Doe / Acme CorpYes
*CustomerEmailEmail address of the customer[email protected]Yes
*IssueDateDate the invoice was created; format can vary (e.g. MM/DD/YYYY)03/01/2025Yes
*DueDateDate the invoice payment is due04/01/2025Yes
*CurrencyCurrency code (e.g. USD, CAD)USDYes
*ItemNameThe name of the invoice line itemDesign ServiceYes
*ItemRateThe cost per unit for the line item500Yes

Optional CSV Columns

You can include these columns to capture additional invoice details. If you don’t have data for an optional field, leave it empty.

HeaderDescriptionSample DataMandatory?
TermsPayment terms or notesNet 30No
ItemDescriptionExtra details about the item/product5 hours of design workNo
ItemQuantityQuantity of each item2No
Taxable (Y/N)Indicates if the item is taxable (Y or N)YNo
TaxNameName of the tax associated with the itemSales TaxNo
TaxRatePercentage rate of the tax10No
DiscountTypeType of discount applied (Fixed or Percentage)PercentageNo
DiscountValueThe discount amount (either a fixed value or a % based on DiscountType)10No
StatusInvoice payment status (Paid or Partially Paid)PaidNo
AmountPaidAmount the customer has already paid200No


Example CSV Snippet

Below is a minimal CSV snippet with both required and optional columns. (A real CSV would have more rows.)

*InvoiceNo*InvoiceName*CustomerName*CustomerEmail*IssueDate*DueDate*Currency*ItemName*ItemRateTermsItemDescriptionItemQuantityTaxableTaxNameTaxRateDiscountTypeDiscountValueStatusAmountPaid
INV001Web DesignJohn Doe[email protected]03/01/202503/31/2025USDHomepage Design300Net 30Design of homepage1YSales Tax10Paid300
INV001Web DesignJohn Doe[email protected]03/01/202503/31/2025USDContact Page Design200Net 30Design of contact page1YSales Tax10Paid200
INV002SEO ServicesAcme Inc[email protected]03/05/202504/05/2025USDKeyword Research150Comprehensive keyword research1N150
INV002SEO ServicesAcme Inc[email protected]03/05/202504/05/2025USDOn-page Optimization250Optimizing page elements1N250
INV002SEO ServicesAcme Inc[email protected]03/05/202504/05/2025USDLink Building200Building quality backlinks1N200

Tip: If you open your CSV in a spreadsheet editor like Excel or Google Sheets, ensure your top row has these column headers in exactly the same spelling and order (the order can vary, but the header names must match perfectly for the required fields).


Uploading Your CSV into the CRM

  1. Click Import using CSV

    • Go to the Invoices section of your CRM.
    • Choose Import Invoices.
  2. Upload Your File

    • Click Upload CSV (or drag-and-drop your file) and follow any on-screen prompts.


Map Fields and Confirm Date Formats

  1. Map each CSV column to the corresponding CRM field if prompted. The system often auto‐detects these fields, but review them carefully.
  2. Confirm or adjust the date format (e.g., MM/DD/YYYY vs. DD/MM/YYYY).


Troubleshoot and Re‐Upload if Necessary

  • If any required field is missing, or if the CRM sees invalid data (like a non‐date in your *IssueDate field), you’ll see an error screen.
  • Correct the issues by editing your CSV or adjusting your field mappings.
  • Re‐upload the corrected file until the CRM shows no further errors.


Finalize Your Import

  • Click Import or Finish once the system reports no errors.
  • You’ll see a confirmation message and can then view your newly created invoices within the CRM.