How to Import Invoices into QuickBooks from a Spreadsheet

Last updated June 2026.

Typing invoices into QuickBooks one at a time is slow, and it is where most data-entry errors creep in. The faster path is a spreadsheet: get your invoices into a clean CSV or Excel file with the right columns, then let QuickBooks read the whole batch in one upload. This guide covers the exact steps for QuickBooks Online and QuickBooks Desktop, the formatting rules that trip people up, and how to handle vendor bills, which work differently from sales invoices.

How do I import invoices into QuickBooks from a spreadsheet?

In QuickBooks Online, click the gear icon, choose Import data under Tools, select Invoices, and download the sample CSV to see the expected columns. Format your file to match, browse to it, map each column to a QuickBooks field, then confirm the import. QuickBooks creates one transaction per invoice number in your file.

The mapping step is more forgiving than most people expect. Your headers do not have to match QuickBooks word for word. If your sheet says "Client" where QuickBooks wants "Customer," you simply point one to the other during mapping. That means you can keep your own column names and still import cleanly, as long as every required field is present somewhere in the file.

What is the difference between importing invoices and bills?

An invoice in QuickBooks is money a customer owes you (accounts receivable). A bill is money you owe a vendor (accounts payable). When you receive a supplier invoice and want it recorded, that is a bill, not an invoice, even though the paper document is called an invoice. The two use different import paths, so getting this right matters.

The native Import Data tool in standard QuickBooks Online imports sales invoices. It does not import vendor bills in the regular Simple Start, Essentials, or Plus tiers. To import bills directly you need QuickBooks Online Advanced, which adds Bills to the same import screen, or a third-party import app. We cover the bill path further down.

How do I format the spreadsheet for QuickBooks?

Give each invoice a single invoice number and put the required fields in their own columns: invoice number, customer, invoice date, due date, item or product, description, and amount. For a multi-line invoice, repeat the same invoice number on every row and change only the line item details. Keep the header fields identical across those rows and leave no blank rows between entries.

A few specifics save you a failed upload. Use a consistent US date format such as MM/DD/YYYY. Enter amounts as plain numbers without currency symbols. Make sure every customer (for invoices) or vendor (for bills) already exists in QuickBooks, or that you let the import create them. The native tool does not accept discounts, credit memos, or negative amounts, so handle those separately after the import.

Can you bulk import invoices into QuickBooks?

Yes. The whole point of a spreadsheet import is volume. QuickBooks Online lets you bring in many invoices in one upload, capped at 100 invoices per import with a 1,000-row limit per spreadsheet. If you have more than that, split the file into batches and run the import more than once. Each batch follows the same mapping you set up the first time.

For larger or recurring volumes, a third-party import app or the QuickBooks Online Advanced importer raises those ceilings and remembers your field mapping between runs. The bottleneck is rarely the upload itself. It is getting the source invoices into a clean, consistent spreadsheet in the first place, which is the step worth automating.

How do I import vendor bills into QuickBooks?

In QuickBooks Online Advanced, open Import data, choose Bills, and map the required fields: Vendor, Bill Date, Due Date, Account, Description, and Amount. Each bill needs a vendor that already exists and an expense or item account to post to. Multi-line bills repeat the bill reference on each row, the same as multi-line invoices.

If you are on a standard QuickBooks Online plan without Advanced, your options are a dedicated import app or moving the bills through a CSV-to-QuickBooks conversion. When you already have transactions in a CSV and need them in QuickBooks Desktop format, a CSV to QBO converter turns the spreadsheet into a file QuickBooks can import directly, which avoids the Advanced upgrade for one-off batches.

Can you import invoices into QuickBooks Desktop?

QuickBooks Desktop imports transactions through IIF (Intuit Interchange Format), a tab-delimited text file with header rows that define the transaction type. Sign in as Admin, switch to single-user mode, then go to File, Utilities, Import, and choose IIF Files. Select your prepared IIF file and open it. Desktop reads the headers and creates the matching invoices or bills.

Building an IIF file by hand is finicky because the column headers and order are strict. Most people start from a spreadsheet and convert it, rather than writing IIF directly. The same logic applies to bank activity: if you are also reconciling accounts, converting a bank statement to QuickBooks produces an import-ready file for Desktop or Online without manual keying.

Can you import PDF invoices into QuickBooks?

Not directly. QuickBooks imports structured data from CSV, Excel, or IIF files, not the raw PDF or scanned image. You first have to turn each invoice document into rows of data: vendor, invoice number, dates, line items, and totals. Once that data sits in a spreadsheet with the right columns, the import steps above apply.

That conversion is exactly what an invoice OCR tool does. It reads the PDF or photo, pulls the fields and every line item, and hands back an Excel or CSV file. From there you map the columns once and upload. Our QuickBooks invoice converter produces a file laid out for the QuickBooks import screen, so the formatting work is done before you ever open the import wizard.

Why will my invoices not import into QuickBooks?

The most common reasons are a missing required field, a customer or vendor that does not exist yet, or a column that was not mapped. Check that every row has an invoice number, a date in MM/DD/YYYY format, and a numeric amount with no currency symbol. Remove blank rows, and split the file if you are over the 100-invoice or 1,000-row limit.

Unsupported content also triggers errors. The native importer rejects discounts, credit memos, and negative amounts, so strip those out and add them manually afterward. If a multi-line invoice imports as separate invoices, the invoice number was not repeated identically on each line. Fix the source spreadsheet and re-run the upload rather than editing inside QuickBooks.

From received invoice to QuickBooks in three steps

The reliable workflow is short. First, convert your PDF or scanned invoices into a clean spreadsheet with one row per line item. Second, confirm the required columns are present and the customers or vendors exist in QuickBooks. Third, run the import, mapping your columns once, and let QuickBooks post the batch.

Doing the extraction step well removes almost all of the import pain, because a consistent file maps the same way every time. If high invoice volume is pushing you toward a fuller process, an accounts payable automation approach builds on the same idea: capture the data accurately first, then move it into your accounting system in batches instead of one screen at a time.