CSV format for bulk invoices, with examples.

Choose the columns your invoice template needs

A CSV invoice file should keep customer details, invoice identifiers, dates, and amounts in separate columns. Include the fields your template uses, with no merged cells or billing details stored only in notes.

Use predictable column names

Choose names that describe the invoice field clearly: invoice_no, customer_name, billing_address, issue_date, due_date, payment_terms, item_description, quantity, unit_price, subtotal, tax_amount, and total_due. These are examples, not required headers. You can map labels such as Invoice # or Customer Name to the same template fields.

Repeat the invoice number for itemized rows

For itemized invoices, every row that belongs to the same invoice should repeat the same invoice_no. After importing, select that column for grouping so the rows become one customer invoice.

Keep money fields consistent

Use one currency convention and numeric format. Avoid mixing symbols, commas, text notes, and empty calculations in the same amount column.

Do not put important data only in comments

Invoice numbers, dates, totals, customer names, and item descriptions should live in their own columns so they can be mapped into the template.

Preview before exporting every invoice

Before generating the full batch, preview records with short and long customer names, multiple line items, discounts, taxes, and edge-case totals.

Copy a working CSV structure

One row per invoice

Download the CSV invoice template with five sample invoices, or use the Excel version. These are the first two records from the CSV:

Customer Name,Invoice #,Date,Address,Description,Total,Notes
Avery Johnson,INV-1001,"Sep 3, 2026",123 Business Rd.,Consulting services,"$1,250.00",Payment due within 30 days.
Maya Chen,INV-1002,"Sep 4, 2026",48 Oak Avenue,Design package,$860.00,Payment due within 30 days.

Each record contains the values for one complete invoice. The quoted date and amount keep their commas inside a single CSV field.

Several line items per invoice

Download the grouped line-item sample when an invoice contains several products or services:

Invoice #,Customer Name,Description,Quantity,Unit Price,Line Total
INV-1001,Avery Johnson,Consulting session,2,500.00,1000.00
INV-1001,Avery Johnson,Written report,1,250.00,250.00
INV-1002,Maya Chen,Design package,1,860.00,860.00

The first two rows share INV-1001. Select Invoice # as the identifier to keep those items together; INV-1002 belongs to a separate invoice. This sample contains line totals and no tax columns. Add any invoice-level totals or tax fields your own template needs.

Calculate before saving as CSV

In the example above, Quantity is column D and Unit Price is column E. In Excel, =ROUND(D2*E2,2) calculates the line total in F2. Fill the formula down and check the results before saving. CSV stores the resulting values rather than the workbook's formulas or formatting.

Four formatting checks that prevent bad output

• Quotes: a value containing a comma must be enclosed in double quotes, such as "125 Main Street, Suite 4". A double quote inside a quoted field is doubled.
• Dates: use one unambiguous convention, such as 2026-09-03 or Sep 3, 2026. Quote dates containing commas.
• Amounts: use consistent decimal formatting. For calculation columns, prefer 1250.00 to a mixture of currency symbols and regional separators.
• Encoding: save as CSV UTF-8 when customer names or descriptions contain accented characters. Preview those characters after import.

Check invoice totals once per invoice

A line total belongs to an item; an invoice total belongs to the complete invoice. Repeating the full invoice total on every item row and then summing it will overstate the amount. Verify one grouped invoice manually against its source before exporting the batch.

Prepare the file in Excel

Keep one header row, remove merged cells, and check calculated amounts before exporting the invoice data sheet as CSV UTF-8. Reopen the CSV to check that names, dates, and amounts still match your source. You can also upload the XLSX or XLS workbook directly to the invoice generator from Excel.

When the file is ready, open the bulk invoice generator, upload it, connect the template fields, and review the output before exporting the batch. See the Excel invoice walkthrough for the mapping and preview steps.

Already imported a file and something looks wrong? Use the invoice CSV troubleshooting guide to diagnose shifted columns, missing zeros, blank PDF fields, and incorrect grouping.

Prepare a CSV for recurring invoice batches

Keep the header names used by your saved template, and create a fresh export for each billing period. Consistent columns let you reuse the mapping while changing the values that belong to the new invoice.

• Invoice number: allocate a new number for each new invoice; use a separate customer ID for the recurring client. See how to continue invoice numbering next month.
• Current values: update the service period, issue date, due date, descriptions, and approved amounts. Do not leave last month's date as fixed text in the PDF design.
• Export selection: include only the current period's approved records. Check the exported file itself instead of relying on hidden rows in the working spreadsheet.
• Batch check: count distinct invoice numbers and reconcile totals by currency before generation. Repeated line-item identifiers should still produce one invoice per group.

Use the monthly recurring invoice checklist for the complete routine from approval through PDF generation and delivery.

Create PDF invoices from your prepared CSV

1. Import the file. Open the CSV to invoice generator and upload the CSV with its header row intact.
2. Connect the columns. Map customer details and amounts to the starter invoice or your own PDF. For itemized records, select Invoice # as the grouping column and connect the service columns to a table.
3. Check a small batch. Compare invoice numbers, customer details and totals against your source, then download separate PDFs in a ZIP or one combined PDF.

The itemized example above covers consulting sessions, a written report and a design project. See how these rows become two invoices in the service business bulk invoicing example. If you only need to save an existing invoice worksheet, follow the steps to create a PDF invoice in Excel.