What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/QuickBooks Import Excel and CSV
QuickBooks + Excel

QuickBooks Import from Excel and CSV: What Goes In, What Doesn't, and the Desktop Toolkit

QuickBooks Online has its own import screen for lists and a handful of transaction types, and it takes CSV, Excel or Google Sheets. It's good at a clean customer or product list. It gets fussy with transactions, and it caps how much you can load in one go. Here's what to expect before you upload.

Import a spreadsheet into QuickBooks Online

Open the import screen, pick what you're importing, upload the file, then match your columns to QuickBooks fields.

Settings ⚙ Import data

Imports natively: customers, vendors, chart of accounts, products and services, bank data, invoices, bills and journal entries.

Limits that catch people: each file must be under 1,000 rows, and invoices go in 100 at a time at most. Split anything bigger into several files.

On QuickBooks Desktop? Lists in CSV need Intuit's free Import Excel and CSV Toolkit, a Windows download with sample files and a field reference.

What are you trying to get into QuickBooks?

The import screen is the right tool for some of these and the wrong one for others. Find your row.

You're importing Use Expect trouble with
A customer, vendor or product list The built-in import, one list at a time Names that already exist. QuickBooks won't import a contact it already has, and there's no bulk undo if you load a messy list.
A chart of accounts from an old system The built-in import, before anything else Account types. If the column doesn't map to a real QuickBooks account type, the row won't go in cleanly. Read the chart of accounts guide first.
Open invoices, a few hundred at most The built-in invoice import, in batches of up to 100 Discounts and credit lines. Negative lines can't be imported, and Intuit says this import isn't available once sales tax is set up in the account.
Years of transaction history from a previous ledger Journal entries, or a third-party importer such as SaasAnt Transactions or Transaction Pro Importer One unbalanced entry or one missing account stops that entry. Across thousands of rows, finding which ones failed is the real work.
A spreadsheet that arrives every week or month Not a manual import at all Repeating the same mapping by hand forever. A recurring file is better handled as a feed into QuickBooks.

Why the upload fails, or goes in wrong

Most failed imports are a file problem, not a QuickBooks problem. Check these before you try again.

Your first row was data, not headers

How you'll know: The first customer or invoice in your file is missing after the import.

Fix: QuickBooks uses row one to map columns and never imports it. Add a header row with plain column names.

Dates in a format QuickBooks guessed wrong

How you'll know: Invoices land in the wrong month, or 03/04 became April 3 instead of March 4.

Fix: Pick the date format that matches your file on the mapping screen, and make every date in the column use it. Mixed formats in one column are the usual cause.

Accounts, items or customers that don't exist yet

How you'll know: Journal entries or invoices reject rows, or invoice lines show a generic Sales item instead of your product.

Fix: Import in Intuit's order: chart of accounts, customers, vendors, products and services, then the transactions that use them. Names in the transaction file must match exactly.

A file over the limit

How you'll know: The upload stalls or refuses the file.

Fix: Keep each file under 1,000 rows and each invoice batch to 100 invoices. Split by month or by customer so you can tell which batch is done.

A journal entry that doesn't balance

How you'll know: That entry is rejected while the others go in.

Fix: Total the debits and credits for each journal number in Excel before uploading. They have to match for every entry, not just for the whole file.

The file itself is corrupted

How you'll know: QuickBooks says the file can't be read, even though it opens fine in Excel.

Fix: Copy the data into a brand new sheet, save it as CSV, and upload that instead.

One clean import, start to finish

Same steps for a list or a batch of invoices. The data type you pick changes which fields you have to map.

  1. 1

    Download Intuit's sample file

    Settings ⚙ Import data Pick a data type

    Each import screen offers a sample CSV. Copy your data into its columns rather than inventing your own layout. It's the fastest way to see which fields are required.

  2. 2

    Upload and map the columns

    Choose your file, then match each column to a QuickBooks field. Required fields are marked. Set anything your file doesn't have to Not applicable.

    Watch for: the option to add customers that don't exist yet on an invoice import. Ticking it creates them as bare names, which you'll have to fill in later.

  3. 3

    Check the preview, then import

    QuickBooks shows what it's about to create. Fix anything flagged in your spreadsheet, not on screen, so the file stays your record of what went in.

  4. 4

    Note what failed

    If some rows don't import, QuickBooks lists the reasons. Copy them down before you click Done, so you know which rows to fix and re-import.

A migration that kept failing partway

Company moving off an older accounting system

Before

About two years of invoices and journal entries sat in exported spreadsheets, far more than the import screen was built for.

Every attempt stopped partway through, and the errors didn't say which rows were wrong. Someone was going through thousands of lines by hand to find out.

After

n-frames built an import pipeline that checks each row against QuickBooks' real field rules before sending anything.

Rows that don't fit are flagged one by one instead of failing the batch, and everything else loads in one pass.

What looked like weeks of retries became a short list of flagged rows someone fixed in an afternoon.

Questions people ask

What is the QuickBooks Import Excel and CSV Toolkit?

A free download from Intuit for QuickBooks Desktop on Windows. It holds sample CSV and Excel files, a PDF manual, and a reference of the fields each list (customers, vendors, items and so on) accepts. Desktop needs it installed before it will import lists in CSV. QuickBooks Online doesn't use it, because the import screen and its sample files are built in.

Can I import transactions into QuickBooks from Excel?

Some. QuickBooks Online imports invoices, bills and journal entries natively, with limits: under 1,000 rows per file, up to 100 invoices at a time, and no negative lines. For years of history or several transaction types at once, most people use a third-party importer or a custom import that checks the data first.

Why does my QuickBooks Excel import keep failing?

Usually a mismatch between the file and what QuickBooks expects: a missing header row, a date format that doesn't match, an account or customer name that doesn't exist yet, an unbalanced journal entry, or a file over 1,000 rows. Fix the file and re-upload rather than editing on screen.

Does QuickBooks import CSV files the same way as Excel files?

In QuickBooks Online, yes. CSV, XLS and XLSX all go through the same upload and column mapping, and so do Google Sheets. If a particular import refuses an Excel file, saving it as CSV usually fixes it, and it also strips out formatting that can confuse the upload.

Can I undo an import in QuickBooks Online?

Not in bulk. Imported contacts have to be deleted or made inactive one at a time, and an overwrite of products and services can't be undone once you click Import. Test with a small file first.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.