Import Invoices into QuickBooks from PDF or Excel

If a stack of vendor invoices is sitting in your inbox and you need them inside QuickBooks, you have two real jobs: get the data into a clean spreadsheet, then push that spreadsheet through the QuickBooks importer. QuickBooks handles the second job well. It is the first job, turning PDFs into rows QuickBooks will accept, that trips most people up. This guide walks through both, for QuickBooks Online and Desktop, with the exact menu paths, the row limits Intuit enforces, and the common errors that stop an import cold.

Can you import invoices into QuickBooks Online?

Yes. QuickBooks Online has a native import tool that accepts invoices in CSV or Excel format. You map your spreadsheet columns to QuickBooks fields, and the transactions land as proper invoices, not attachments. The one thing it will not do is read a PDF on its own. QuickBooks Online imports structured rows, so a PDF or scanned invoice has to be converted into a spreadsheet first before the importer can use it.

That split matters because it tells you where to spend your effort. The QuickBooks side is a guided wizard that takes a few minutes. The work is preparing accurate rows, which is why an extraction step usually sits in front of the import.

How do I import invoices into QuickBooks from Excel?

Open QuickBooks Online, click the gear icon (Settings), then choose Import data and select Invoices. Upload your .xlsx or .csv file, map each spreadsheet column to the matching QuickBooks field (customer, invoice date, due date, product or service, amount, and so on), review the preview, and click Start import. QuickBooks creates one invoice per invoice number in your file.

A few rules keep the import clean. Add any new customers, products, or services before you import, or QuickBooks may reject rows it cannot match. Use a consistent date format across the whole file. Keep one invoice number per transaction, with separate rows for each line item sharing that number. If your data already lives in a spreadsheet, you are most of the way there; if it lives in PDFs, the next section covers that.

How do I import PDF invoices into QuickBooks Online?

QuickBooks Online cannot import data straight from a PDF, so the reliable path is to convert the PDF invoices into an Excel or CSV file first, then run the native import. An extraction tool reads each PDF or scanned image, pulls the vendor, dates, line items, and totals, and writes them into spreadsheet rows formatted the way QuickBooks expects.

This is exactly what our convert invoices to QuickBooks tool is built for: upload your PDF or image invoices, get back a clean file, and import it through the QuickBooks wizard above. If you prefer to work in a spreadsheet first, the PDF invoice to Excel converter produces the same structured output that you can review before importing. The QuickBooks mobile app can snap a single receipt, but for a backlog of vendor invoices, converting to a spreadsheet and bulk importing is far faster.

What is the difference between importing invoices and bills in QuickBooks?

Invoices are money your customers owe you (accounts receivable); bills are money you owe vendors (accounts payable). Most people who say they want to import invoices into QuickBooks actually mean incoming vendor invoices, which QuickBooks records as bills. The import path is almost identical: gear icon, Import data, then choose Bills instead of Invoices.

One extra requirement applies to bills. QuickBooks Online makes you populate the Line Account field for every row, even when you only want to import bill totals, because each bill line has to post to an expense or other account. Decide up front whether your incoming documents belong in QuickBooks as bills, and add your vendors and expense accounts before importing.

How many invoices can you import into QuickBooks at once?

QuickBooks Online recommends importing no more than 100 invoices or bills in a single batch, and the spreadsheet itself is capped at 1,000 rows. Because each line item is its own row, a few dozen multi-line invoices can reach that ceiling quickly. If you have a larger backlog, split it into batches that stay under both limits.

Batching also makes errors easier to fix. If one file of 100 invoices fails, you only have a small set to review, rather than hunting through thousands of rows. Keep your converted spreadsheets in dated batches so you always know what has already gone into QuickBooks.

Can you import invoices into QuickBooks Desktop?

Yes, but the mechanics differ from QuickBooks Online. QuickBooks Desktop imports transactions through IIF (Intuit Interchange Format) files or through third-party tools that write directly to the company file. Lists such as customers, vendors, and items can be imported from Excel using the built-in Add Your Excel Data feature under the File menu.

For invoice and bill transactions specifically, an IIF file or a dedicated import app is the usual route, since Desktop is stricter about transaction structure than the Online importer. Whichever edition you run, the prep work is the same: you need accurate, well-mapped rows, which means a clean conversion from your source PDFs first. If the documents you are bringing into QuickBooks are PDF bank statements rather than invoices, a PDF bank statement to QBO converter produces a QuickBooks-ready file the Desktop importer accepts directly.

Why won't my invoices import into QuickBooks?

The most common reason an import fails is unmatched names: a customer, vendor, product, or account in your file does not exist yet in QuickBooks, so the row is rejected. Add those records first, or let your file create them, before you import. Other frequent culprits are mixed date formats, blank required fields (especially the Line Account on bills), totals that do not match the sum of line items, and files that exceed the 100-transaction or 1,000-row limits.

When QuickBooks shows an import error report, read it row by row. It usually names the exact field and line that failed, which makes the fix quick. Starting from accurate extracted data removes most of these errors before they happen, because the amounts, dates, and line items already line up with the source document.

Do you need a third-party app to import invoices into QuickBooks?

For data that is already in a clean CSV or Excel file, no: QuickBooks Online's built-in importer handles it. You only need outside help for the step QuickBooks does not do, which is turning PDF and scanned invoices into that structured file. That is where an extraction tool earns its keep, reading documents that QuickBooks cannot and handing you import-ready rows. The one exception is a CSV of bank transactions you want to reconcile rather than post as invoices: QuickBooks reads those through a QBO file, so a CSV to QBO converter bridges that gap.

The practical workflow for most US finance teams is two steps: extract invoice data to Excel from your PDFs, then run the native QuickBooks import. You keep full control, you review the data before it posts, and you avoid paying for a heavyweight accounts payable suite just to get invoices into your books.

The fastest reliable workflow

Put the pieces together and the routine is short. Collect your PDF or image invoices, convert them to a clean QuickBooks-ready spreadsheet, split into batches under 100, then import through the gear icon as invoices or bills depending on direction. Add any new vendors or accounts first, keep your date format consistent, and check the preview before you commit. Done this way, a backlog that used to mean hours of manual typing becomes a few short imports, with the numbers matching your source documents every time.