Upload Invoices to QuickBooks Online from CSV
Prepare, map, review, and upload invoice rows with QuickBooks Online’s native CSV import workflow.
The safest QuickBooks invoice CSV workflow has two separate stages: prepare the file, then upload it through QuickBooks Online. That keeps mapping problems visible before they become import errors.
1. Prepare the CSV
Map source headers to Invoice number, Customer, Invoice date, Due date, Item amount, and Item(Product/Service). Review Product/Service values against the names configured in QuickBooks.
2. Stay inside QuickBooks batch limits
Intuit documents a maximum of 1,000 rows and 100 invoices per import. Split larger prepared data into batches that satisfy both limits.
3. Upload and map in QuickBooks Online
Open Settings, choose Import data, select Invoices, and upload the prepared CSV. Map the file headers to QuickBooks fields, choose the date format, review the summary, then start the import.
4. Resolve rejected rows from the reported reason
If QuickBooks rejects Product/Service values, compare them with the items that exist in the account. For category hierarchies, use the exact colon-separated path such as Flowers:Roses:Interpreting. Keep the prepared CSV as the reproducible source for any corrections.
See the transformation
Awkward source headers become import-ready columns.
Rename the columns you need while keeping every value under the correct header.
cust_idcustomer_idgiven_namefirst_namemailemail✓ Values stay with the right column
Need to do this now?
Map CSV before QuickBooks uploadRelated tools
Open the tool this guide is about, or explore a related one.
- CSV column mapper and renamerRename, reorder, and remove CSV columns before importing data into a CRM, store, database, or accounting system — without uploading your file.
- Validate CSV files online freeScan a CSV once for structural, encoding, header, delimiter, and whitespace problems without changing the file.
- Clean and fix CSV files — no uploadRepair common CSV problems including wrong delimiters, uneven rows, empty lines, whitespace, BOM markers, and duplicate headers.