Import Invoices into QuickBooks

Getting invoices into QuickBooks is one of those jobs that looks simple until you try it. You can type each one in by hand, but at a few minutes per invoice that adds up fast, and a single wrong date or amount can quietly corrupt a report. QuickBooks does support importing invoices, but the right method depends on which version you run, whether your invoices are in a spreadsheet or a PDF, and whether they are sales invoices or vendor bills.

This guide walks through every practical way to import invoices into QuickBooks Online and QuickBooks Desktop: the built-in CSV and Excel import, how to handle PDF invoices, bulk imports, third-party importer apps, and the common reasons an import fails. It also covers the fastest route for teams that receive invoices as PDFs and want clean data in QuickBooks without retyping.

Can you import invoices into QuickBooks?

Yes. QuickBooks Online has a built-in tool that imports sales invoices from a CSV or Excel file under Settings, Import data, Invoices. QuickBooks Desktop imports invoices through IIF files or the Import Excel and CSV toolkit. Neither version reads invoice data straight from a PDF, so PDF invoices need an extraction step first to turn them into a spreadsheet QuickBooks can accept.

The method you pick comes down to three questions: are these invoices you send (sales) or invoices you receive (vendor bills), are they already in a spreadsheet or stuck in PDFs, and how many do you process? The sections below match each situation to the cleanest import path.

How to import invoices into QuickBooks Online from Excel

To import invoices into QuickBooks Online from Excel, go to the Settings gear, choose Import data, then Invoices, and upload your CSV or Excel file. Map your spreadsheet columns to the QuickBooks fields, review the preview, and start the import. QuickBooks accepts up to 100 invoices at a time, with a limit of 1,000 rows per file, so large batches are split into smaller uploads.

Step by step

The workflow is short once your file is formatted correctly:

1. Prepare the spreadsheet

Build a CSV or Excel file with one row per invoice line. Each row needs at least the customer name, invoice number, invoice date, due date, product or service, amount, and tax where it applies. The customer and the product or service must already exist in QuickBooks, or the import will reject those rows. Use the US date format, month/day/year, because a date like 27/02/2026 will either error or post to the wrong day.

2. Open the import tool

Select the Settings gear in the top right, then Import data, then Invoices. QuickBooks offers a sample template you can download to match its expected column names exactly. Starting from that template removes most mapping headaches.

3. Map the columns and import

Upload your file and QuickBooks shows a mapping screen where each of your columns is matched to a QuickBooks field. Confirm every field lines up, fix anything marked in red, and click Start import. QuickBooks reports how many invoices imported and lists any rows it skipped so you can correct and re-run them.

How do I import a PDF invoice into QuickBooks?

QuickBooks Online cannot read data from a PDF invoice on its own, so you first convert the PDF into a structured spreadsheet, then import that file. An AI extraction tool reads the vendor, invoice number, date, line items, tax, and total from the PDF and exports clean rows to Excel or CSV, which you then import through Settings, Import data, Invoices.

This is where most of the manual time disappears. Instead of reading each PDF and typing the numbers, you upload the files, let the software pull the fields, and download a spreadsheet already formatted for import. Our convert invoices to QuickBooks tool does exactly this: it extracts the data from PDF and scanned invoices and gives you a file ready to bring into QuickBooks. If you only need the spreadsheet itself, the invoice PDF to Excel converter handles the conversion, and our step-by-step guide on how to convert a PDF invoice to Excel covers the manual options too.

How to import invoices into QuickBooks Desktop

QuickBooks Desktop imports invoices through an IIF (Intuit Interchange Format) file, a tab-delimited text file whose header rows define the transaction type. You can also use the free QuickBooks Import Excel and CSV toolkit, which includes a manual and sample files, and QuickBooks Desktop Enterprise has a built-in Excel import wizard with guided field mapping.

IIF works well when another application exports that format for you, but hand-building an IIF file is error-prone. For Excel and CSV files, the Import toolkit walks you through matching your columns to QuickBooks fields. Many Desktop users skip both and run a third-party importer such as Transaction Pro, which opens QuickBooks, reads a CSV, TXT, or Excel file, and posts the invoices with configurable mapping. Whichever route you choose, the data still has to come out of your PDFs first, so an extraction step usually sits in front of it.

Can you import vendor bills into QuickBooks?

Yes, but vendor bills (the invoices you receive and pay) are handled differently from sales invoices. QuickBooks Online has no simple native CSV import for bills, so most teams use a third-party importer app or QuickBooks bill capture to bring them in. The reliable pattern is to extract the bill data into a spreadsheet first, then push it in through an app that supports the Bill transaction type.

Because vendor bills are where accounts payable teams spend the most keying time, automating the extraction matters most here. AI invoice data extraction software reads each bill, including the full line-item table, and outputs structured rows you can import or sync. That turns a stack of PDF bills into a clean file without anyone retyping vendor names and amounts.

How many invoices can you import into QuickBooks at once?

QuickBooks Online imports up to 100 invoices per import, with a maximum of 1,000 rows in the spreadsheet, so a multi-line invoice uses several rows toward that limit. For larger volumes you either split the file into batches of 100 or use a third-party importer app that supports scheduled and higher-volume imports through email, FTP, or an integration.

If you regularly bring in hundreds or thousands of invoices, batching by hand gets old quickly. A connected extraction-to-import workflow, where invoices are read automatically and the data flows in on a schedule, scales far better than repeating the 100-at-a-time upload all day.

Why won't my invoices import into QuickBooks?

Most failed QuickBooks imports come down to formatting. The usual culprits are dates in the wrong format, required columns left blank, a customer or product that does not yet exist in QuickBooks, duplicate invoice numbers, or a file saved in a layout QuickBooks does not recognize. QuickBooks lists the rows it skipped, so the fix is almost always in the spreadsheet, not the software.

Run through this checklist before you blame the import tool. Use US dates in month/day/year form. Make sure every customer name and product or service in the file already exists in QuickBooks exactly as spelled. Fill in all required fields. Remove invoice numbers that are already in QuickBooks to avoid duplicates. And start from the sample template so your column headers match what QuickBooks expects. Clean source data is the single biggest factor in a smooth import, which is another reason letting software extract the fields beats typing them by hand.

Does QuickBooks have an invoice scanner?

QuickBooks has a receipt and bill capture feature that lets you photograph or email documents and pulls a few header fields like vendor, date, and total. It is handy for receipts, but it does not reliably capture full line-item detail or handle high volumes, and it is built around bills rather than a flexible invoice-to-spreadsheet workflow. For complete line items and bulk processing, a dedicated extraction tool does more.

A purpose-built reader runs OCR on scanned files and uses AI to identify each field by meaning instead of fixed position, so it reads vendor layouts it has never seen and captures the entire line-item table. If you want to understand how that accuracy is achieved, our overview of invoice OCR software explains how modern extraction differs from basic scanning. We break down exactly what the built-in feature reads and where it stops in does QuickBooks have OCR, and the paper-to-bills workflow itself is covered in scanning invoices into QuickBooks. For the adjacent job of getting bank statements into QuickBooks, a dedicated bank statement to QuickBooks converter handles that document type.

The fastest way to get invoices into QuickBooks

If your invoices arrive as PDFs or scans, the quickest path is to extract the data automatically and import the resulting file, rather than reading and typing each one. Upload your invoices, let the tool pull every field and line item into a clean Excel or CSV file formatted for QuickBooks, review anything it flags, and import. A job that took an afternoon of keying becomes a few minutes of review.

That is the workflow our convert invoices to QuickBooks tool is built for. Drop in your PDF or scanned invoices, get back structured data ready to import into QuickBooks Online or Desktop, and keep your books current without the manual entry. The accuracy checks catch math errors and duplicates before they reach your accounting system, so the numbers you import are the numbers you can trust.