# Import PDF Invoices into QuickBooks Online

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-04-16
- Updated: 2026-04-16
- Category: Invoices, bills and lists
- Canonical: https://www.simplebankconvert.com/blog/import-pdf-invoices-into-quickbooks-online

> How to import PDF invoices into QuickBooks Online: why PDFs need converting first, what goes on each line and how to attach the original PDF to each invoice.
To import PDF invoices into QuickBooks Online, first copy each invoice's details into a spreadsheet, one row per line item, because the invoice importer only reads CSV, Excel or Google Sheets files. Then run Import data from Settings, map the columns, and afterwards attach each original PDF to its matching invoice by hand.

## Why can't QuickBooks Online read a PDF invoice directly?

QuickBooks Online has no screen that turns a PDF of a sales invoice into an invoice record. The invoice importer accepts spreadsheets, and the screens that do accept PDFs are built for other jobs: receipts and bills you owe, or bank statements. A PDF of an invoice you sent a customer fits neither, so it has to become rows first.

Intuit's page of [common questions about importing data into QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/common-questions-importing-data-quickbooks-online/L4OYJRFdj_US_en_US) lists the file types the Import data screens take: CSV, Google Sheets and XLS or XLSX. A PDF is not on that list. The same page lists invoices among the record types you can import, so the importer exists. It just needs a table.

### The PDF screens that look tempting

The Receipts page takes PDF files. According to [Intuit's guide to uploading receipts and bills](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/upload-receipts-bills-quickbooks-online/L862MmZHn_US_en_US), QuickBooks reads each uploaded file and drafts a transaction for you to review, and you can then create an expense or match it to one that exists. That is the right place for a supplier's bill, but the wrong place for money a customer owes you. An invoice you issued is income. If you push it through Receipts, it can end up as an expense, which flips the effect on your profit.

The bank upload screen also takes PDF statements, but it creates bank lines, not customer invoices. Neither route gives you an open invoice with a customer, a due date and an amount still owed.

### Where the PDFs usually come from

Most people with a folder of invoice PDFs are in one of three spots. They billed customers from another tool, such as a word processor template, and are moving to QuickBooks. They are catching up on a backlog created outside the books. Or a previous bookkeeper left only printed copies. In each case the goal is the same: open invoices in QuickBooks that match what customers were actually sent.

## Turning each PDF invoice into spreadsheet rows

Each PDF invoice becomes one or more rows in a spreadsheet, one row per line item. Every row repeats the invoice number, customer, invoice date and due date, so QuickBooks knows which rows belong together. An invoice with three line items becomes three rows sharing one invoice number. A one-line invoice becomes a single row.

Intuit's article on [importing multiple invoices into QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/import-multiple-invoices/L7E9Xrd8l_US_en_US) says each line item needs its own invoice number, customer, invoice date, due date and item amount. It also caps a file at 1,000 rows and an import at 100 invoices. A large backlog therefore goes in as several files.

### A worked example with two invoices

Here are two made-up PDF invoices from an example design studio. The values are examples only.

- Invoice 1041, to Harbor Dental, dated 03/02/2026, due 04/01/2026: logo revision, 600.00; business cards, 150.00.
- Invoice 1042, to Pine Street Cafe, dated 03/09/2026, due 04/08/2026: menu layout, 420.00.

As import rows they look like this:

| InvoiceNo | Customer | InvoiceDate | DueDate | Item(Product/Service) | ItemDescription | ItemAmount |
| --- | --- | --- | --- | --- | --- | --- |
| 1041 | Harbor Dental | 03/02/2026 | 04/01/2026 | Design | Logo revision | 600.00 |
| 1041 | Harbor Dental | 03/02/2026 | 04/01/2026 | Printing | Business cards | 150.00 |
| 1042 | Pine Street Cafe | 03/09/2026 | 04/08/2026 | Design | Menu layout | 420.00 |

Three rows, two invoices. The column names in this example are labels, not fixed spellings, because you match them to QuickBooks fields during the import. Downloading the sample file from the import screen shows the layout Intuit expects, and copying your data into it saves a round of mapping.

### Copying the details out of the PDF

For a handful of invoices, typing is fine. Open the PDF on one side of the screen and the spreadsheet on the other, and work down the printed lines. For dozens, try selecting the text in the PDF and pasting it into a spreadsheet. A PDF made by software usually pastes as text you can split into columns. A scanned PDF is a picture and pastes nothing useful, so it needs retyping or a text recognition tool, followed by a careful check of every amount.

Whichever way you copy, add a check column at the end of each invoice: the total printed on the PDF. Then add up the line amounts per invoice number and compare. A mismatch means a line was missed or a number was misread. Fix it before the import, because a wrong invoice that reaches a customer statement is far more awkward to correct.

## PDF invoice fields mapped to the QuickBooks import columns

Most fields printed on a PDF invoice have a home in the import, and a few do not. The invoice number, customer, dates, product or service, description and line amount all map to columns. Payment terms, notes and a shipping address may need to be filled in on the invoice afterwards, depending on what the mapping screen offers you.

The table below pairs what you see on a typical PDF with where it goes.

| Printed on the PDF | Import column | Notes |
| --- | --- | --- |
| Invoice # | Invoice number | Required. Repeat it on every line of the same invoice. |
| Bill to | Customer | Required. Spell it exactly as the customer's name in QuickBooks. |
| Invoice date | Invoice date | Required. Use one date format for the whole file. |
| Due date | Due date | Required. If the PDF shows only terms such as Net 30, work out the date. |
| Item or service | Product/Service | Optional in the file. A missing one falls back to a generic item. |
| Line description | Description | Optional. Keeps the wording the customer saw. |
| Line total | Item amount | Required. A positive number for every row. |
| Invoice total | (none) | Keep it in your check column only. Do not import it as a line. |

### Customers and products come first

Intuit's article says to add new customers, products and services to QuickBooks before you import. The import screen can create missing customers if you tick its box, but it creates them with little more than a name. If you want addresses and email on file for the customer, build the list first. The post on [importing customers into QuickBooks Online](/blog/import-customers-into-quickbooks-online) covers that list. A product or service that does not exist gets swapped for a generic item called Sales, according to Intuit. That puts the income on whichever account that item points to, which may not be the one you report on.

### Dates and invoice numbers

Pick one date format and use it in every row. The import asks which format your file uses, and a file that mixes 3/2/2026 and 2026-03-02 will either fail or land some invoices in the wrong month. Invoice numbers matter too. Keep them exactly as printed on the PDFs, so the number a customer quotes when paying matches the number in QuickBooks.

## Running the invoice import from Settings

The invoice import starts in Settings, under Import data, where you choose Invoices. From there QuickBooks Online walks you through four steps: upload the file, map your columns to its fields, confirm the date format, then review a summary and start. A final screen tells you how many invoices went in and lists any that failed.

The screens are the same whether your rows came from PDFs or from another program's export. The full sequence, including the checkbox for new customers and the result screen to read before you close it, is in [stepping through the invoice import screens](/blog/upload-invoices-to-quickbooks-online#stepping-through-the-invoice-import-screens). For PDF backlogs, import in small files, so any failed invoice is easy to trace back to its PDF.

### Checking the result

Open the invoice list and filter to the date range you imported. Count the invoices, then compare a few totals with their PDFs, especially any invoice with several lines. Run a customer balance report for one or two customers you know well and see whether it looks right. If an invoice came in wrong, edit it or delete it and re-import that one, rather than importing the whole file again and doubling everything.

## When sales tax, discounts or credits block a PDF invoice import

Some PDF invoices cannot go through the importer at all. Intuit says you cannot import invoices this way if sales tax is set up in your QuickBooks account. The importer also refuses negative lines, so discounts and credit memos printed on a PDF cannot come in as part of the invoice.

That rules the importer out for many businesses that charge sales tax. In that case, the practical choices are to type each invoice into QuickBooks by hand, or to look for an app that adds the invoices for you. For a small number of invoices, typing is usually the quicker of the two.

### Discounts and credits on the PDF

A PDF invoice with a "10% off" line or a "credit from last month" line has a negative row that the importer rejects. Two ways round it:

- Import the invoice without the negative line, then open it in QuickBooks and add the discount there. The total will then match the PDF.
- Leave the invoice out of the file and enter the whole thing by hand.

Never fold the discount into one of the positive lines to make the total match. The invoice would add up, but the line amounts would no longer match what the customer was billed, and that confuses any later question about a single line.

### Old invoices that are already paid

If a PDF invoice was paid long ago and you only need history, ask whether it belongs in QuickBooks at all. Importing a paid invoice means you also have to record its payment, or it will sit open and inflate what customers seem to owe. Many people bring in only invoices still unpaid on the date they start using QuickBooks, and keep the older PDFs as records outside the books.

## Attaching the original PDF to each imported invoice

The import brings in the numbers but not the PDF file itself. To keep the original document with the record, open each imported invoice in QuickBooks Online and add the PDF in the attachments area at the bottom of the form, then save. There is no column in the import file that carries an attachment.

This is slow for a large batch, so decide which invoices deserve it. An invoice a customer might dispute, or one with custom terms, is worth attaching. A routine invoice whose PDF you keep in a dated folder may not be.

### Naming the files so they are easy to find

Rename each PDF to start with its invoice number before you start, for example 1041-harbor-dental.pdf. When you open invoice 1041 in QuickBooks, the matching file is the first one in the folder sorted by name. It also helps a year later, when someone asks for a copy and you search the folder by number.

### Purchase orders work the same way

A supplier's purchase order PDF has the same problem: QuickBooks needs rows, not a document. The steps for those are in [importing purchase orders into QuickBooks Online](/blog/import-purchase-orders-into-quickbooks-online), which uses a vendor in place of a customer.

## Is the PDF invoice paid already?

An imported invoice starts as open, owed in full, until you record a payment against it. For any PDF invoice the customer has already paid, record that payment in QuickBooks and link it to the invoice, then match it to the deposit on your bank account. Otherwise the deposit gets categorized as new income and the sale counts twice.

The order matters. Import the invoices, record the payments, then review the bank lines. When QuickBooks sees a bank deposit for the same amount as a recorded payment, it suggests a match, and accepting it closes the loop without creating a second sale. The post on [importing payments into QuickBooks Online](/blog/import-payments-into-quickbooks-online) covers recording many payments at once.

### Getting the bank side in

The deposits have to be in QuickBooks before you can match them. A connected bank feed brings them in on its own, unless the connection breaks. If the bank sign-in keeps failing with a numbered message, the fix for one common case is in [what QuickBooks error 103 means and how to clear it](/blog/quickbooks-error-103). If your bank only gives you PDF statements, those need converting into a file the bank upload accepts. [SimpleBankConvert](/) is being built for that job: it turns a PDF bank statement into a CSV or QBO file for the QuickBooks Online upload, so the customer payments show up as lines you can match to these invoices.

### A quick end-of-batch check

When the batch is done, three numbers should agree. The total of the PDFs you imported, minus the payments you recorded against them, should equal the open balance of those invoices in QuickBooks. If it does not, the gap points to an invoice that was imported twice, missed, or paid without being linked.