How to Prepare a CSV for QuickBooks Online Invoice Import

QuickBooks Online's native invoice import accepts CSV files — but only in a specific format. If your source data uses different column names, has extra columns, or contains validation errors, the import fails with cryptic errors or, worse, silently creates duplicate invoices.

The QuickBooks Invoice CSV Preparer maps your source columns to QuickBooks' expected format, validates invoice data, and automatically creates QuickBooks-compatible import batches when a valid source is larger than one destination batch.

What QuickBooks Online expects

QuickBooks Online's native invoice import requires these columns:

| Column | Required | Notes | | -------------- | -------- | ------------------------------------------------------- | | Invoice number | Yes | Must be repeated for multi-line invoices | | Customer | Yes | Must match existing customer names | | Invoice date | Yes | Use one consistent date format; select it during import | | Due date | Yes | Use the same selected date format throughout the file | | Item amount | Yes | Cannot be negative (zero is allowed) | | Description | No | Line item description |

A single invoice can have multiple line items. Each line item is a separate CSV row sharing the same invoice number. The total invoice amount is the sum of its line items.

A realistic starting point

A typical invoice export looks like this. The columns are named for your system, not QuickBooks.

Invoice INV-1001 has two line items. Both rows share the same invoice number. The preparer preserves this structure while mapping column names and validating the data.

What the tool actually does

A focused pipeline: map columns → validate rules → export clean CSV.

1. 01

   Drop in your CSV

   Upload a CSV with invoice data. The first rows are inspected to detect headers. Files up to 200 MB are supported.

2. 02

   Map your columns

   Match each QuickBooks field to the corresponding column in your source. The tool auto-suggests mappings based on header names.

3. 03

   Run the preflight

   Validates required values, non-negative amounts, and consistent row width, then plans QuickBooks batches of at most 1,000 rows and 100 invoices each.

4. 04

   Review issues

   Any validation errors are listed with row numbers and fields. Fix them in your source and re-upload; the download stays disabled until validation passes.

5. 05

   Download the prepared output

   One batch is downloaded as quickbooks-invoices.csv. Multiple batches are downloaded as quickbooks-invoices.zip with numbered QuickBooks-ready CSV files.

Multi-line invoices

QuickBooks Online supports multiple line items per invoice. In your source data, each line item is a separate row sharing the same invoice number.

The preparer preserves this structure: INV-2001 has three line items, and the output CSV maintains all three rows. The total for INV-2001 is $725.00.

Common validation errors

The preparer catches issues that would cause QuickBooks to reject the import:

| Error | What it means | How to fix | | --------------------------- | ---------------------------------------------------------- | ------------------------------------------------ | | Missing value | A required cell is empty | Fill in the blank cell in your source | | Invalid amount | Item amount is not a number | Check for currency symbols, commas, or text | | Negative amount | Item amount is below zero | Verify credit notes are handled separately | | Row width | Row has different column count than header | Fix ragged rows in your source | | One invoice over 1,000 rows | A single invoice cannot fit in one QuickBooks import batch | Reduce that invoice or use another import method |

QuickBooks Online limits

QuickBooks Online enforces hard limits on CSV imports:

• Maximum 1,000 data rows per import file
• Maximum 100 distinct invoices per import file
• Amounts cannot be negative for invoice line items (zero is allowed)

Nablyx's 200 MiB limit is a browser-processing limit, not a QuickBooks import limit. QuickBooks Online accepts no more than 1,000 rows and 100 invoices in a single invoice import. You can still process a larger source CSV locally with Nablyx, up to 200 MiB. After validation, Nablyx creates as many QuickBooks-ready batch files as needed while keeping every invoice intact in one batch. For larger datasets, download the ZIP and import quickbooks-invoices-batch-01.csv, quickbooks-invoices-batch-02.csv, and the remaining batches one at a time in QuickBooks Online.

What the tool does not do

The preparer is a validation and mapping tool. It does not:

• Create or edit invoices directly in QuickBooks
• Handle credit notes or refunds (negative amounts are flagged as errors)
• Convert or validate date formats (QuickBooks Online asks you to select the format used during import, such as DD/MM/YYYY or MM/DD/YYYY; use one format consistently throughout the file)
• Merge duplicate invoice numbers

After downloading the prepared CSV or ZIP, import each QuickBooks-ready CSV through QuickBooks Online's Settings → Import Data → Invoices workflow.

customer_id ; name ; email

1042 ;  Alex  ; alex@example.com
1043 ; Sam ; sam@example.com ;

customer_id,name,email
1042,Alex,alex@example.com
1043,Sam,sam@example.com