Netmend

Netmend · Guides · Convert PDF invoices to Excel for QuickBooks

Convert PDF invoices to Excel for QuickBooks

QuickBooks will not ingest a supplier PDF for you. It will import a spreadsheet of invoices or bills, if the columns match. This page shows the official import shape, how to get line items out of a text-based PDF, and the mistakes that silently create the wrong invoices.

Free tool in your browserNo accountFrom $20 if you want it done

Convert a PDF now

This converter is built for tables. Use it on a digital invoice or receipt with a real text layer. Switch to “Every text row” if the first preview looks short.

No file at hand? (fictional data)

How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.

What QuickBooks actually imports

There are two different jobs, and they use two different files. Do not mix them up.

Connecting the bank feed, when QuickBooks offers it, is usually better than any of these files for ongoing bookkeeping. Use a spreadsheet import when the feed does not go back far enough, or when you have a pile of PDFs and no feed.

How to get line items out of a PDF invoice

The free tool on this page is the same in-browser converter we built for bank statements. It reads the text layer of a digital PDF on your computer (no upload). It works when the invoice is a real text PDF with a line-item table — description, quantity, unit price, line total. It does not work well on a photographed invoice, a logo-heavy layout with the totals in a random place, or a scanned page. For those, type the lines or use the done-for-you option below.

  1. Save the supplier’s PDF (or our sample invoices, if you just want to see the tool).
  2. Drop it in the box below. If the preview looks messy, switch to Every text row (raw table) so wrapped descriptions are not dropped.
  3. Download the CSV and reshape it in Excel or Google Sheets to the QuickBooks invoice or bills template: one row per line item, the invoice number repeated on every line of the same invoice, dates in one format, tax codes that exist in your company file, no discount rows as negatives.
  4. Tick each invoice total against the PDF before you import. Then import from Settings → Import data, and map the columns on the screen.

If you only need a payment to match a bank line, you do not import the invoice as a bank transaction. Raise or import the invoice or bill first, then match the bank feed to it. Importing the same amount twice — once as an invoice and once as a bank split — is how balances go wrong.

Sources (checked 13/11/2026). Official product help is linked in the text. Menus and templates change: treat the current screen in QuickBooks, Xero or your bank as the authority.

Need it done for you? From $20

The free tool is for a clean, text-based PDF. For scans, password files, a packed year of documents or a layout that has to match QuickBooks or Xero, we convert them and check the totals against each document.

Done-for-you conversion
$20 / 20 pages

75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.

Need it done for you? From $20
Privacy

Your file is processed only for the order and deleted after delivery. This page itself never uploads the file.

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.

FAQ

Can QuickBooks import a PDF invoice directly?

Not as an invoice or bill. QuickBooks Online imports a CSV (or its sample spreadsheet) of invoices or bills, and a separate CSV or bank-feed file for transactions. You convert the PDF first, then map the columns.

How many invoices can I import at once?

Official help: up to 100 invoices per import, and up to 1,000 rows in the spreadsheet. Discounts and credit notes cannot go through this invoice import as negative charges.

Should I import invoices or bank transactions?

If the invoice is a sale or a bill you need on the books, import it as an invoice or a bill. If the money has already hit the bank and you only need the feed to match, use the bank CSV or the live bank feed — not the invoice template.

Related guides

Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services