Import Invoices Into QuickBooks Desktop and Enterprise From PDF in One Batch

Import invoices into QuickBooks Desktop, the short answer

QuickBooks Desktop imports invoices from a file, not from a PDF. Customer invoices go in as an IIF file through File, Utilities, Import, IIF Files on Pro, Premier and Enterprise. Enterprise and Accountant can also paste invoices and vendor bills from Excel with Batch Enter Transactions. Either way, the work is turning the PDFs into rows first, and that is the part InvoiceExtractor does.

Desktop has no document reader of its own, which is the main difference from QuickBooks Online. Whatever the route, somebody or something has to read each invoice and lay it out as structured data. Typing that data into a spreadsheet only moves the keying from one window to another. Extracting it from the document is what removes it.

Can you import invoices into QuickBooks Desktop?

Yes. QuickBooks Desktop accepts invoice transactions in IIF, the Intuit Interchange Format, on every Desktop edition. Enterprise and Accountant add Batch Enter Transactions, which takes rows pasted from Excel or CSV into the accounts receivable and accounts payable registers. Pro and Premier users who need more than IIF use a third-party importer app that maps spreadsheet columns.

One date matters for planning. Intuit stopped selling new Pro Plus, Premier Plus and Mac Plus subscriptions in the US on September 30, 2024. Existing subscribers can renew, and QuickBooks Desktop Enterprise is still sold. Most of the businesses importing invoices into Desktop today are therefore on Enterprise, which is good news, because Enterprise has the strongest import route.

How do I import multiple invoices into QuickBooks Desktop?

Build one IIF file that holds every invoice and import it in a single pass. Back up the company file, sign in as the admin, switch to single-user mode, then choose File, Utilities, Import, IIF Files and select the file. Each invoice is one TRNS line for the receivable, one or more SPL lines for income, and an ENDTRNS line closing the block.

Writing that file by hand is where most people give up. InvoiceExtractor writes it for you: upload the invoices, check the rows, and click the QuickBooks export. Each invoice lands as a TRNS line on Accounts Receivable with the date, customer name and total, a matching SPL line on your income account, and the invoice number in the memo so you can find it later. If your export layout names an income account, the file uses it instead of a generic Sales account.

Two habits keep IIF imports clean. Run the first file against a copy of the company file with three or four invoices. And make sure customer names in the file match the customer list exactly, because a misspelt name creates a new customer rather than failing.

How do I import invoices into QuickBooks Enterprise from Excel?

Use Batch Enter Transactions. In QuickBooks Desktop Enterprise or Accountant, open the Accountant menu, choose Batch Enter Transactions, pick Invoices or Bills as the transaction type, and arrange your spreadsheet columns in the same order as the screen. Copy the rows, right-click the first date field and paste. Names that QuickBooks does not recognize turn red, and you can Quick Add or set them up before saving.

Intuit's own guidance is that rows sharing the same transaction number are grouped into one transaction, which is how a multi-line bill keeps its lines together. That is exactly the shape of InvoiceExtractor's bills CSV: one row per line, with the bill number, vendor and date repeated on every row and your default expense account filled in. Sort the columns once to match the Batch Enter screen, and every later month pastes the same way.

Can you import vendor bills into QuickBooks Desktop?

Yes, on Enterprise and Accountant through Batch Enter Transactions with the Bills type, and on any edition through a Desktop importer app or an IIF file written with the BILL transaction type. QuickBooks itself will not read the bill PDF on any edition. The bill has to exist as rows first, with vendor, bill number, date, due date, expense account and amount on each line.

For vendor bills, use the bills CSV rather than the IIF export. The IIF file InvoiceExtractor writes is a customer invoice file posting to Accounts Receivable, which is the right shape for invoices you issued and the wrong shape for bills you owe. The bills CSV carries every line, the default expense account and the bill number, and pastes into Batch Enter or loads into an importer without retyping.

What does an IIF invoice file look like?

Three header rows define the columns, then each invoice is a block of rows. A minimal file that QuickBooks Desktop accepts looks like this:

!TRNS  TRNSTYPE  DATE        ACCNT                NAME           AMOUNT    MEMO
!SPL   TRNSTYPE  DATE        ACCNT                NAME           AMOUNT    MEMO
!ENDTRNS
TRNS   INVOICE   10/01/2026  Accounts Receivable  Harbor Supply  1840.50   INV-20931
SPL    INVOICE   10/01/2026  Sales                Harbor Supply  -1840.50  INV-20931
ENDTRNS

The columns are separated by tabs, not spaces, and the SPL amount is the negative of the TRNS amount so the transaction balances. The file posts one income line per invoice at the invoice total. If you need every product line on the Desktop invoice itself, use Batch Enter Transactions with the line rows instead, or keep the Excel export alongside the IIF file as the line detail for review.

What it costs to stop typing invoices into Desktop

At a loaded cost of $35 an hour, 20 hours of keying is $700 a month. An extraction plan at $49 to $149 a month plus a few hours of review is the cheaper setup from roughly 30 invoices a month upward, and the gap grows with line counts, because typing time scales with lines while extraction time barely moves.

Which QuickBooks Desktop versions does this work with?

The IIF route works on every current Desktop edition: Pro Plus, Premier Plus, Enterprise and Accountant. Batch Enter Transactions is Enterprise and Accountant only. Check that your version is still supported before you plan a big import: secondary sources report that Desktop 2023 support ended May 31, 2026 and that Desktop 2024 is supported to September 30, 2027. An unsupported version still opens IIF files, but you lose updates, bank feeds and payroll.

After the invoices are in

IIF imports do not link transactions, so receive payments against the imported invoices as usual and the receivables age correctly. If you also reconcile Desktop accounts from PDF bank statements, turning those statements into a spreadsheet uses the same review habit as the invoice import. And if you are weighing a move to the cloud, the QuickBooks Online bill import page covers the same job on the other product.