To scan invoices into QuickBooks, extract the invoice data into a CSV or Excel file formatted with QuickBooks’ required columns, then use the built-in import function. QuickBooks Online accepts CSV imports via Banking > Upload Transactions or through the vendor bill import. QuickBooks Desktop uses the IIF import format or Add/Edit Multiple List Entries. For automated scanning, use an AI extraction tool like Lido to pull data from invoice PDFs into Excel, then import the formatted spreadsheet directly into QuickBooks.
QuickBooks does not have a proper invoice scanning feature. The receipt capture tool reads simple receipts, but it cannot handle multi-page vendor invoices with line items, purchase order references, and payment terms. So most small business owners end up manually typing invoice data into QuickBooks, one bill at a time. At 5–10 minutes per invoice, a business processing 100 invoices per month loses 8–16 hours to data entry every month.
The workaround is importing invoices into QuickBooks from Excel or CSV. If you can get your invoice data into a spreadsheet with the right column format, QuickBooks will accept it. The question is how you get from a stack of PDF invoices to that formatted spreadsheet. This guide covers every method, from fully manual to fully automated, so you can pick whichever fits your volume and budget. Lido handles the extraction step for teams processing more than 20–30 invoices per month, but the import process into QuickBooks is the same regardless of how you create the spreadsheet.
Whether you use QuickBooks Online or QuickBooks Desktop, importing invoices from Excel into QuickBooks follows the same general pattern. The differences are in file format and menu location, which this guide covers for both versions.
QuickBooks has a receipt scanning feature (QuickBooks Online) and a document attachment feature (QuickBooks Desktop), but neither is an invoice scanner. The receipt tool is designed for single-transaction receipts: one vendor, one total, no line items. It works for expense receipts from a lunch meeting or a hardware store run. It fails on multi-page invoices from suppliers.
Intuit has not built proper invoice scanning into QuickBooks because the problem is hard. Vendor invoices come in thousands of different formats. Every supplier uses a different layout, different field names, different placement for totals and line items. A scanning feature that works for one vendor’s invoices breaks on another’s. Building and maintaining an intelligent OCR system that handles arbitrary invoice formats is a full product in itself.
Instead, Intuit has partnered with third-party apps that handle the scanning and feed data into QuickBooks via API. Dext (formerly Receipt Bank), Hubdoc, and AutoEntry all fill this gap. But they charge $20–$60 per month on top of your QuickBooks subscription, and their accuracy on complex invoices with line items varies significantly.
You end up with a fragmented workflow: QuickBooks handles accounting, a separate tool handles scanning, and you bridge the gap between them. The methods below are ordered from simplest (but slowest) to most automated.
Most small businesses still handle invoices this way. You open the PDF invoice on one screen, open QuickBooks on the other, and type the data in field by field.
In QuickBooks Online: Navigate to Expenses > Bills > Create Bill. Enter the vendor, bill date, due date, and add line items with category, description, amount, and quantity.
In QuickBooks Desktop: Navigate to Vendors > Enter Bills. Same fields, different interface.
Manual entry takes 5–12 minutes per invoice depending on the number of line items. Error rates run 2–5% per field according to IOFM research. On a 10-line invoice, that means roughly one wrong number every other invoice. A wrong quantity or unit price that slips through creates reconciliation problems at month-end.
Manual entry is acceptable if you process fewer than 10–15 invoices per month. Above that volume, the labor cost and error rate make it the most expensive method per invoice, even though it has zero software cost.
QuickBooks Online includes a receipt capture feature (labeled “Receipts” in the left navigation menu). You can upload photos or PDFs of documents, and QuickBooks attempts to read the vendor name, date, and total amount.
It handles simple single-page receipts with one transaction: gas station receipts, restaurant bills, retail purchases. It reads the total, date, and sometimes the vendor name correctly.
It cannot handle multi-page invoices, line item detail, purchase order references, payment terms, tax breakdowns, or vendor account numbers. Anything beyond the most basic receipt information is out of scope.
QuickBooks Desktop has a “Doc Center” feature that attaches PDFs to transactions, but it does not extract any data from them. It is purely for document storage and reference, not scanning.
If you are searching for how to scan invoices into QuickBooks Online using the built-in tools: you cannot do it reliably for vendor bills. The receipt capture feature is designed for expense receipts, not AP invoices. It will read the total amount and sometimes create a draft transaction, but it misses line items entirely and frequently misreads multi-line invoices.
For simple expenses (not vendor bills), the receipt capture feature saves time. For actual accounts payable invoices from suppliers, you need one of the methods below.
The most reliable method for getting bulk invoice data into QuickBooks without third-party subscriptions. If you can get your invoice data into a properly formatted spreadsheet, QuickBooks will import it.
QuickBooks Online import format: QuickBooks Online does not have a direct “import bills” feature in the standard interface. However, you can import invoices into QuickBooks Online using the bank feed upload (Banking > Upload Transactions) for simple transactions, or use the QuickBooks Online Import Tool (a first-party Intuit tool) that accepts CSV files for vendor bills.
The CSV format QuickBooks needs for bill import:
| Column | Required | Format | Example |
|---|---|---|---|
| Vendor | Yes | Must match existing vendor in QB | Acme Supply Co |
| Bill Date | Yes | MM/DD/YYYY | 03/15/2026 |
| Due Date | Yes | MM/DD/YYYY | 04/14/2026 |
| Bill Number | No | Text | INV-12345 |
| Category/Account | Yes | Must match QB chart of accounts | Office Supplies |
| Description | No | Text | Printer paper, 10 boxes |
| Amount | Yes | Number (no $ sign) | 487.50 |
| Memo | No | Text | PO-789 |
QuickBooks Desktop import format: Desktop uses the IIF (Intuit Interchange Format) for importing bills. IIF is a tab-delimited text file with header rows that define the transaction type. The format is rigid but well-documented. Alternatively, QuickBooks Desktop Enterprise supports Excel imports directly through the “Add/Edit Multiple List Entries” feature for certain transaction types.
The import itself is straightforward. The hard part is getting your invoice data into the spreadsheet. If you are manually typing from PDFs into Excel before importing into QuickBooks, you have not saved time versus entering directly into QuickBooks. The Excel import method pays off when you pair it with automated extraction (Method 5 below).
For a complete guide to extracting invoice data into spreadsheet format, see how to extract invoice data into Excel and Google Sheets.
Several apps integrate directly with QuickBooks to provide invoice scanning and automatic posting. These sit in the QuickBooks app marketplace and connect via API.
Dext (formerly Receipt Bank). $30–$60/month depending on plan. You email or upload invoices. Dext extracts vendor, date, total, and sometimes line items. Extracted data syncs to QuickBooks as draft bills for review. Accuracy is strong on simple invoices but inconsistent on multi-page documents with complex line items.
Hubdoc (owned by Xero, works with QuickBooks). Free with Xero subscriptions, $20/month standalone. Connects to supplier portals to auto-fetch invoices. Extracts basic fields. Limited line-item extraction. Best for businesses whose invoices come from a small number of regular suppliers with online portals.
AutoEntry (now part of Sage). $24–$70/month based on document volume. Better line-item extraction than Hubdoc. Supports QuickBooks Online and Desktop. Publishes directly to QuickBooks as bills. Includes category rules for recurring vendors.
The advantage of these apps is tight QuickBooks integration. Bills post directly without an export/import step. The disadvantage is cost (another monthly subscription), accuracy limitations on complex invoices, and vendor lock-in. If you switch accounting systems, your scanning workflow breaks.
For businesses processing 50–200 invoices per month from varied vendors, these apps save hours versus manual entry. But if you need high accuracy on line items, or process documents beyond invoices (purchase orders, receipts, packing slips), accuracy drops noticeably. For a comparison of tools in this category, see the best invoice data extraction software.
This method splits scanning from QuickBooks import. Instead of trying to upload invoices to QuickBooks Online directly (which only works for simple receipts), you scan invoices into Excel first using AI extraction, then import the formatted spreadsheet. Two steps, both reliable, no monthly app subscription beyond the extraction tool.
Step 1: Extract invoice data into Excel. Upload your invoice PDFs (or connect your email inbox) to Lido. Define the fields you need: vendor name, invoice number, invoice date, due date, line items, quantities, unit prices, totals. Lido’s AI reads each invoice and extracts these fields into a spreadsheet, regardless of invoice format or layout. No templates, no per-vendor setup.
Step 2: Format the spreadsheet for QuickBooks. Map Lido’s output columns to QuickBooks’ expected format. This is a one-time setup. Vendor name maps to Vendor. Invoice date maps to Bill Date. Due date maps to Due Date. Line item amounts map to Amount. You can set up this mapping in the output spreadsheet template so every extraction produces a QuickBooks-ready file automatically.
Step 3: Import into QuickBooks. In QuickBooks Online, use the import tool to upload the CSV. In QuickBooks Desktop, convert to IIF format (a simple column reorder) and import. Review the draft bills in QuickBooks and post them.
This workflow handles scanning invoices into QuickBooks at any volume. Whether you process 20 invoices per month or 2,000, the extraction step takes minutes (upload, wait for processing, download the spreadsheet). The import step is a single file upload into QuickBooks.
The main advantage over Method 4 apps: Lido extracts line items accurately from complex multi-page invoices because it uses vision-language models that understand document structure, not template-based rules that break on new formats. You also own the extracted data in your spreadsheet, so switching accounting systems later does not mean losing your scanning workflow.
For setting up automated email-based ingestion so invoices are extracted without manual upload, see how to set up automated email invoice processing.
The import process differs between QuickBooks Online and QuickBooks Desktop. Here is what matters for each.
| Feature | QuickBooks Online | QuickBooks Desktop |
|---|---|---|
| Import format | CSV | IIF (tab-delimited) or Excel (Enterprise) |
| Import location | Settings > Import Data > Bills | File > Utilities > Import > IIF Files |
| Line item support | Yes (one row per line item) | Yes (sub-rows under bill header) |
| Vendor matching | Exact match required, or creates new | Exact match required, or errors |
| Batch size limit | 1,000 rows per import | No hard limit (performance degrades at 5,000+) |
| Receipt capture | Yes (basic, receipts only) | No (document attachment only) |
| Third-party app support | Strong (open API) | Limited (IIF or SDK integration) |
| Can you import invoices? | Yes (bills, not sales invoices) | Yes (bills via IIF) |
Important terminology note: In QuickBooks, “invoices” are what you send to customers (sales). What you receive from vendors are called “bills.” When you are importing vendor invoices into QuickBooks, you are technically importing bills. The import function you need is under Bills, not Invoices. This trips up many users searching for how to import invoices into QuickBooks Online.
If you are scanning invoices into QuickBooks Desktop specifically, the IIF format is your primary option. IIF files are simple text files with a specific header structure. Many extraction tools, including Lido, can format output directly into IIF-compatible layouts. For importing invoices into QuickBooks Desktop from Excel, you need QuickBooks Desktop Enterprise or Pro Plus to access the Excel import feature, or you convert your Excel file to IIF format first.
QuickBooks Online is easier for imports because CSV is a universal format. Any spreadsheet application exports to CSV, and the QuickBooks Online import wizard maps columns interactively so you can fix formatting issues during import rather than discovering them after.
The right method depends on your monthly invoice volume and how complex those invoices are.
Under 15 invoices per month, simple format: Manual entry is fine. Under 2 hours per month. The software overhead is not worth it at this volume.
15–50 invoices per month, mixed vendors: QuickBooks’ receipt capture handles the simple ones. For complex multi-page invoices, use Method 5 (AI extraction to Excel) on a batch basis. Upload all invoices at month-end, extract, import once. Total time: 30–45 minutes including review.
50–200 invoices per month: A dedicated tool starts paying for itself quickly. Either a third-party app (Method 4) for convenience, or AI extraction to Excel (Method 5) for higher accuracy on complex invoices. At 100 invoices monthly, Method 5 saves 10–15 hours compared to manual entry.
200+ invoices per month: You need automated ingestion. Set up email forwarding to Lido for automatic extraction, with the output spreadsheet formatted for QuickBooks import. Process runs daily or weekly without manual upload. At this volume, consider whether QuickBooks itself is still the right tool, as most businesses over 200 invoices monthly have outgrown it for AP management.
Most businesses stay on manual entry too long. The time cost is easy to underestimate because it happens in small increments throughout the month. Track your actual time for one month. If you spend more than 3 hours on invoice entry, automation has already paid for itself.
For automating the full invoice lifecycle beyond just the QuickBooks import step, see what is automated invoice processing and how to automate invoice data extraction from email.
Yes. QuickBooks Online supports CSV imports for vendor bills (which is what vendor invoices are called in QuickBooks). Navigate to Settings > Import Data > Bills and upload a CSV file with columns for Vendor, Bill Date, Due Date, Amount, and Category. Each line item gets its own row. The vendor names in your CSV must match existing vendors in QuickBooks, or new vendor records will be created automatically.
QuickBooks Desktop does not have a built-in invoice scanning feature. To get invoice data into Desktop, extract the data from your invoice PDFs into an IIF (Intuit Interchange Format) file or Excel spreadsheet, then import via File > Utilities > Import > IIF Files. QuickBooks Desktop Enterprise and Pro Plus also support direct Excel imports through Add/Edit Multiple List Entries. Third-party apps like Dext can also post bills directly via QuickBooks Desktop SDK.
QuickBooks Online has a limited receipt capture feature that can read simple single-page receipts (vendor, date, total), but it cannot read multi-page PDF invoices with line items. QuickBooks Desktop cannot read PDFs at all; it only attaches them as reference documents. To get data from PDF invoices into QuickBooks, you need either manual entry, a third-party scanning app, or an AI extraction tool that outputs to a QuickBooks-compatible import format.
QuickBooks Online accepts CSV files with columns for Vendor, Bill Date, Due Date, Bill Number, Category (matching your chart of accounts), Description, and Amount. QuickBooks Desktop uses IIF format (tab-delimited text with specific header rows defining transaction types) or Excel files in Enterprise edition. In both cases, vendor names must match existing vendor records exactly, and category names must match your chart of accounts.
In QuickBooks Online, save your Excel file as CSV, then go to Settings > Import Data > Bills and upload the CSV. Map your columns to QuickBooks fields in the import wizard. In QuickBooks Desktop Enterprise, use File > Utilities > Import > Excel Files for direct import. In other Desktop editions, convert your Excel file to IIF format (reorder columns to match IIF specification and save as tab-delimited text) and import via File > Utilities > Import > IIF Files.
%20(1).svg)
