# Import Bills into QuickBooks Desktop

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Invoices, bills and lists
- Canonical: https://simplebankconvert.com/blog/import-bills-into-quickbooks-desktop

> How to import bills into QuickBooks Desktop with Excel batch entry or an IIF file, and how to pay them later so the bank payment matches each bill.
To import bills into QuickBooks Desktop, use Accountant > Batch Enter Transactions with Bills selected if you have Accountant or Enterprise, and paste rows from Excel. On Pro or Premier, build an IIF bill file instead. Later, pay each bill through Pay Bills so the bank withdrawal matches a bill payment, not a new expense.

## Bill import routes by QuickBooks Desktop edition

QuickBooks Desktop Accountant and Enterprise can paste bills straight from Excel. Intuit's guide to [batch entering transactions in QuickBooks Desktop](https://quickbooks.intuit.com/learn-support/en-us/help-article/accountant-features/accountant-tools-batch-enter-transactions/L2dnHEij8_US_en_US) lists bills and bill credits among the types the Batch Enter window accepts. Pro and Premier lack that window, so their route is an IIF file.

Intuit's [IIF overview and Import Kit page](https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US) offers sample files for bills, bill credits and bill payments. Start from the bill sample and keep its header rows exactly as they are. The same page warns that IIF has limited error checking and that an account missing from the company file becomes a new bank account.

Whichever route you take, back up first. Intuit's [guide to importing data into QuickBooks Desktop](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/import-export-data-quickbooks-desktop/L9KS42UxP_US_en_US) says an import cannot be undone and that a backup should come before every import.

## Columns a vendor bill batch needs in Excel

A vendor bill in the batch grid needs a vendor, a bill date, a due date or terms, a reference number, an expense account and an amount. The grid reads columns in its own order, so pick Bills, choose the Accounts Payable account at the top and arrange the sheet to match the headings on screen.

The rows below are an example with invented values:

| Vendor | Bill date | Due date | Ref no. | Account | Amount | Memo |
| --- | --- | --- | --- | --- | --- | --- |
| Example Office Lease LLC | 06/01/2026 | 06/05/2026 | JUN-26 | Rent Expense | 1,850.00 | June rent |
| Northline Courier | 06/03/2026 | 07/03/2026 | 88213 | Postage and Delivery | 214.60 | May deliveries |
| Brightwater Utilities | 06/04/2026 | 06/24/2026 | 5521-0604 | Utilities | 309.17 | Electric |

Type amounts without the thousands comma when you paste; the comma above is for reading only. Use the vendor's own invoice number as the reference. That number is how you, and Desktop's duplicate warning, will tell one bill from another later. Any vendor or account the grid does not know shows in red. Fix spelling for names that exist, and add only the ones that are truly new.

## Is it safe to run a bill IIF file twice?

No. A second run of the same IIF bill file creates a second copy of every bill. IIF has no step that compares the file with bills already in Desktop, so the payables total doubles and each vendor appears to be owed twice. The fix is a restore from the pre-import backup, or deleting the copies one at a time.

Doubles usually come from a first run that seemed to fail. The results window showed an error, someone fixed one line and imported the whole file again, and the lines that worked the first time went in twice. Before a second attempt, open Reports > Vendors & Payables > Unpaid Bills Detail and look for bills dated in the file's range. If some are there, either restore the backup or trim the file down to the lines that are missing.

## Paying imported bills so the bank withdrawal matches

Pay imported bills with Vendors > Pay Bills, choosing the bank account and the payment method. Each payment closes its bill and writes one withdrawal to the bank register. When the bank download or statement shows that withdrawal, it matches the bill payment instead of being added as a fresh expense.

The amount on the bank line must equal the payment, not the bill. If you pay Northline Courier's 214.60 bill together with another of its bills in one check, the bank shows one withdrawal for the combined sum. Pay both bills in one Pay Bills session so Desktop writes a single check that matches the bank line.

### Partial payments and credits

A bill credit from the vendor, entered through batch entry or IIF, can be applied on the Pay Bills screen. The payment then shows the bill amount less the credit, and the bank line should show that smaller figure.

## What if the bank download already recorded the bill payments?

If the bank download added those payments as checks coded straight to expense accounts, importing the bills as well counts each cost twice. The expense lands once from the check and again from the bill, and the bills sit unpaid forever. Pick one record for each payment: the check or the bill with its bill payment.

For recent downloads, [undoing a Web Connect import in QuickBooks Desktop](/blog/undo-web-connect-import-in-quickbooks-desktop) explains how to remove the downloaded lines so they can be matched to bill payments instead. For older months already reconciled, it is often cleaner to import only bills that are still unpaid.

Bills are the payables half. If your business also keeps sales documents in QuickBooks Online, [importing estimates into QuickBooks Online](/blog/import-estimates-into-quickbooks-online) and [importing customers into QuickBooks Online](/blog/import-customers-into-quickbooks-online) cover that side. When the bank side of the month only exists as a PDF statement, [SimpleBankConvert](/) is being built to turn it into a QBO file Desktop can open, so bill payments have lines to match; [Get started](/get-started) adds you to the early-access list.