DocuClipper logo
Docs/Help Center
Integrations

Import Invoices into QuickBooks Desktop (IIF)

Export extracted invoices from DocuClipper as a QuickBooks Desktop IIF file. Choose between Vendor Bill (AP) or Sales Invoice (AR), validate against your Chart of Accounts, and fix the 'Account Name does not exist' error.

Last updated

DocuClipper can export your extracted invoices and receipts as a QuickBooks Desktop IIF file. You can post each invoice as either a Vendor Bill (accounts payable) or a Sales Invoice (accounts receivable). This guide covers both, plus the most common error users hit on the first import.

If you have not yet uploaded your QuickBooks Chart of Accounts (COA) to your DocuClipper project, do that first. See How to export your Chart of Accounts from QuickBooks Desktop. Once your COA is uploaded under Project Settings → QuickBooks Desktop, DocuClipper validates the IIF against it and flags account name mismatches before you ever open QuickBooks.

For a higher-level overview of the use case, see Convert PDF invoices to QuickBooks Desktop.

Before you start

  • A QuickBooks Desktop company file (Pro, Premier, Enterprise, or Mac).
  • A DocuClipper project with at least one extracted invoice or receipt.
  • (Recommended) Your QBD Chart of Accounts uploaded once per project. See the COA export guide.

Step 1. Choose Vendor Bill or Sales Invoice

DocuClipper supports two QBD posting types from the same export dialog. The choice is a top-level radio toggle at the top of the IIF panel. Pick the one that matches the document.

Vendor Bill (Accounts Payable) — most common.

  • Use this for invoices and receipts you receive from vendors and need to pay or record as paid.
  • Posts to Accounts Payable as the header account.
  • Each line item posts to the matching expense account from your Chart of Accounts.
  • This is the right choice for accountants and bookkeepers processing supplier bills, utility statements, and expense receipts.

Sales Invoice (Accounts Receivable)

  • Use this for invoices you issue to customers.
  • Posts to Accounts Receivable as the header account.
  • Each line item posts to the matching income account from your Chart of Accounts.
  • Use this when you are migrating customer-facing invoices from another system into QuickBooks.

If you are unsure, choose Vendor Bill. It is the right answer for the large majority of DocuClipper invoice workflows.

Step 2. Export the IIF from DocuClipper

  1. Open the project that contains your processed invoices.
  2. Above the invoice table, click Download / Export. (If you are uploading more invoices into an existing project, use the Add Documents dropdown rather than the first-time card picker.)
  3. In the Output Format dropdown, choose QuickBooks Desktop IIF.
  4. At the top of the IIF panel you will see a banner. If no COA is uploaded, it is a warning banner with a link to upload one. If a COA is uploaded, it is an info banner reading "Validating against N accounts...".
  5. Pick the posting type using the top-level radio toggle:
    • Vendor Bill (AP), or
    • Sales Invoice (AR).
  6. Confirm the AP or AR header account name matches your QuickBooks setup. The defaults are Accounts Payable and Accounts Receivable. If your QBD file uses different names (for example A/P or a localized variant), enter them here.
  7. Click Download IIF.

If your project has a Chart of Accounts uploaded, DocuClipper validates every header account and every line-item category against your COA before producing the file, and lists any mismatches inline.

Even if you skip the upload, the downloaded IIF file includes a ; WARNING: comment block at the very top listing every account name that DocuClipper could not validate. Open the IIF in any text editor before importing so you know what QuickBooks is about to reject.

Screenshot placement: /kb/export-invoices-to-quickbooks-desktop-iif/01-bill-vs-invoice-toggle.png showing the Vendor Bill / Sales Invoice toggle in the export dialog.

Step 3. Import the IIF into QuickBooks Desktop

  1. Open your company file in QuickBooks Desktop.
  2. Go to File → Utilities → Import → IIF Files.
  3. Click Import IIF and select the .iif file you downloaded.
  4. QuickBooks shows a confirmation when the import finishes.
  5. Verify the result:
    • Vendor Bills appear in Vendors → Vendor Center under the right vendor.
    • Sales Invoices appear in Customers → Customer Center under the right customer.

The most common error

If your account names do not match, QuickBooks shows this exact error:

Some of your records have errors. Click View errors to fix them.

The Account Name on a distribution does not exist in Quickbooks.

For invoices, this can come from two places:

  1. The header account (AP or AR) does not match. For example the IIF says Accounts Payable but your QBD file uses A/P.
  2. A line-item category does not match an expense or income account in your QBD Chart of Accounts.

QBD account name matching is strict:

  • Case-sensitive: Office Supplies is not the same as office supplies.
  • Punctuation-sensitive: Meals & Entertainment is not the same as Meals and Entertainment.
  • Whitespace-sensitive: trailing spaces and double spaces count.
  • Sub-account paths must match in full, separated by colons. For example Auto:Fuel, not Fuel.

How to fix it

  1. In DocuClipper, open the project, open Project Settings, and click the QuickBooks Desktop tab.
  2. Upload your QuickBooks Desktop COA (.iif file or pasted account names). See How to export your Chart of Accounts from QuickBooks Desktop for the exact steps inside QBD.
  3. Re-run the IIF export. DocuClipper compares every header account and every line-item category against your COA and lists mismatches inline. For each mismatch:
    • Rename the category in DocuClipper to match QBD, or
    • Add the missing account in QuickBooks and re-upload the COA.
  4. Re-export and re-import. The error should be gone.

You only need to upload the Chart of Accounts once per project. DocuClipper reuses it for every future IIF export in that project.

How DocuClipper maps fields

For a Vendor Bill (TRNSTYPE=BILL):

  • Vendor → bill payee. Comes from the invoice's vendor field (edited values take precedence over automated values).
  • Bill date → invoice date.
  • Bill number → invoice number.
  • AP account → the header account you set in the export dialog (defaults to Accounts Payable).
  • Line items → one expense split per line, posted to the line's category and labeled with the line's item description.
  • Amounts → use each line's Price. The bill total is the sum of line amounts.

For a Sales Invoice (TRNSTYPE=INVOICE), the same shape applies but with Customer as the payee, AR account as the header, and income accounts on the line splits.

Limitations

  • Sales tax is included in the total but is not split into a separate tax line.
  • IIF is a one-way import. Edits made in QuickBooks after import do not flow back to DocuClipper.
  • If a line item has no category, DocuClipper assigns it to Uncategorized Expenses (or Uncategorized Income for sales invoices), which QuickBooks creates automatically on first import. To avoid the auto-create, categorize the line in DocuClipper first or upload your COA so the validator catches it.

Troubleshooting

  • Some bills or invoices are missing after import. Open the IIF import log file (in the same folder as your company file). It lists rejected rows along with the reason, usually a missing or mismatched account name.
  • A new account showed up in my chart of accounts. That category did not match an existing QBD account. Either rename the auto-created account or upload your COA in DocuClipper to prevent this on future imports.
  • The vendor name has weird characters. IIF treats tab and newline characters as field separators. DocuClipper strips those out automatically, but other special characters (commas, ampersands) are preserved as-is.

Related