Every Feature You Need to Automate Invoice Processing
PDFQBO provides a complete set of tools to convert PDF invoices into QuickBooks-ready QBO and IIF files. From intelligent field extraction to batch processing and API integration, every feature is designed to eliminate manual data entry and reduce errors in your accounting workflow.
Smart Invoice Parsing
The core of PDFQBO is its intelligent PDF parsing engine. When you upload a PDF invoice, the system reads the entire document and identifies each data field based on its position, label, and context within the invoice layout. The parser extracts vendor name, invoice number, invoice date, due date, payment terms, purchase order number, subtotal, tax amount, shipping charges, and total amount due.
Unlike simple text extraction tools that just dump all text from a PDF, PDFQBO understands the structure of financial documents. It knows that a number following the label "Invoice #" is an invoice number, that a date near the top of the document is likely the invoice date, and that the largest monetary value at the bottom of the page is typically the total due. This contextual understanding allows the parser to correctly interpret invoices from thousands of different vendors without requiring any manual configuration.
The parser handles both digitally generated PDFs and scanned paper invoices. Digitally generated PDFs contain embedded text that can be read directly with character-perfect accuracy. For scanned invoices, the system runs optical character recognition (OCR) optimized for financial documents. The OCR engine is trained to recognize common invoice fonts, monetary amounts, dates, and table structures, achieving accuracy rates above 95% on legible scans.
Multi-page invoices are fully supported. The parser processes all pages of a document, combining line items and data fields that span across page breaks. Invoices with 50 or more line items spread across multiple pages are handled correctly, with each line item properly associated with its description, quantity, unit price, and extended amount.
Fields Extracted
QBO File Structure
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<DTSERVER>20240115</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<STMTRS>
<BANKTRANLIST>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20240115</DTPOSTED>
<TRNAMT>-159.32</TRNAMT>
<NAME>Acme Supplies</NAME>
<MEMO>INV-2024-00847</MEMO>
</STMTTRN>
</BANKTRANLIST>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>
QBO File Export (Web Connect)
The QBO format, also known as Web Connect, is the standard way to import bank and credit card transactions into QuickBooks. PDFQBO generates fully compliant QBO files that follow the Open Financial Exchange (OFX) specification. These files are accepted by QuickBooks Online and QuickBooks Desktop without any additional conversion or formatting.
Each QBO file generated by PDFQBO includes the required OFX header block with version information, encoding settings, and security parameters. The sign-on response section includes the server date and language setting. The bank message response section contains the statement transaction response with individual transaction entries for each invoice.
Individual transactions within the QBO file include the transaction type (debit for payables, credit for credits), the posted date formatted as YYYYMMDD, the transaction amount with proper sign convention (negative for debits), the payee name matching the vendor on the invoice, and a memo field containing the invoice number. This structure allows QuickBooks to create the correct register entries when the file is imported through File, then Utilities, then Import, then Web Connect Files.
QBO files work with QuickBooks Online (all plans including Simple Start, Essentials, Plus, and Advanced), QuickBooks Desktop Pro 2020 and later, QuickBooks Desktop Premier 2020 and later, QuickBooks Desktop Enterprise 20.0 and later, and QuickBooks for Mac. The files are designed for maximum compatibility across all currently supported QuickBooks versions.
IIF File Export (Intuit Interchange Format)
The IIF format is a tab-delimited text format created by Intuit for bulk importing transactions, lists, and other data into QuickBooks Desktop. PDFQBO generates IIF files that create proper bill transactions in QuickBooks, with full support for multi-line invoices where each line item maps to a separate expense or cost of goods sold account.
Each IIF file begins with a header row that defines the column structure using the TRNS, SPL, and ENDTRNS keywords. The TRNS line represents the transaction header with the vendor name, date, transaction type (BILL), reference number (invoice number), and total amount. Following the TRNS line, one or more SPL (split) lines detail the individual line items with their descriptions, amounts, and account assignments. The ENDTRNS line closes the transaction block.
For invoices with multiple line items, PDFQBO creates a separate SPL entry for each item. This means that when the IIF file is imported into QuickBooks, the resulting bill transaction shows each line item on its own row with the correct description, quantity, unit price, and account assignment. This level of detail is not available through the QBO format, which records transactions at the header level only.
The IIF generator handles special characters in vendor names and item descriptions by escaping them according to the IIF specification. Tab characters, newlines, and quotation marks within field values are properly escaped to prevent parsing errors during import. The generator also validates that debit and credit amounts balance within each transaction block, ensuring that QuickBooks accepts the import without reporting out-of-balance errors.
IIF File Structure
!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM !SPL SPLID TRNSTYPE DATE ACCNT AMOUNT MEMO !ENDTRNS TRNS BILL 01/15/2024 Accounts Payable Acme Supplies -159.32 INV-2024-00847 SPL 1 BILL 01/15/2024 Office Supplies 85.98 Copy Paper 8.5x11 SPL 2 BILL 01/15/2024 Office Supplies 42.45 Ballpoint Pens Blue SPL 3 BILL 01/15/2024 Office Supplies 18.75 Manila Folders SPL 4 BILL 01/15/2024 Sales Tax Payable 12.14 Tax ENDTRNS
Supported QuickBooks Versions
- QuickBooks Desktop Pro
- QuickBooks Desktop Premier
- QuickBooks Desktop Enterprise
Example Line Item Extraction
| Description | Qty | Price | Total |
|---|---|---|---|
| Web Hosting - Annual Plan | 1 | $299.00 | $299.00 |
| SSL Certificate - 1 Year | 1 | $79.00 | $79.00 |
| Domain Registration - .com | 2 | $14.99 | $29.98 |
| Email Hosting - 5 Users | 1 | $59.88 | $59.88 |
| Subtotal | $467.86 | ||
Line Item Extraction
Most invoices contain a table of individual line items listing each product or service, along with quantities, unit prices, and extended amounts. PDFQBO reads these tables and extracts each line item as a separate data record. This granular extraction is critical for proper accounting because different items on the same invoice often need to be recorded against different expense accounts in QuickBooks.
The line item parser identifies table structures within the PDF by detecting column headers (such as Description, Qty, Unit Price, and Amount) and then reading each subsequent row as a separate item. The parser handles various table formats including bordered tables, tables with alternating row backgrounds, tables with merged cells, and tables without visible borders that use spacing and alignment to define columns.
Each extracted line item includes the full item description, quantity (with support for fractional quantities), unit price, and extended amount. The parser also captures item codes or SKU numbers when they appear as a separate column. For invoices that include discount lines or additional charge lines (such as shipping and handling), these are extracted as separate line items with the correct positive or negative amount.
When generating IIF files, each extracted line item becomes a SPL (split) entry in the transaction block. You can assign each line item to a specific expense account in QuickBooks, either manually during the review step or automatically using account mapping rules. This means that a single invoice from an office supply vendor can have items split across Office Supplies, Computer Equipment, and Postage and Shipping accounts based on the item descriptions.
Batch Processing
Instead of uploading and processing one invoice at a time, PDFQBO lets you upload multiple PDF invoices in a single batch and process them all together. Select anywhere from 2 to 20 or more PDF files from your computer, upload them all at once, and receive a combined export file containing every invoice as a separate transaction ready for QuickBooks import.
Batch processing is designed for the way bookkeepers actually work. Invoices accumulate throughout the week or month. Rather than processing each one as it arrives, you can collect them all and run the entire batch at the end of the week or at month-end close. The combined QBO or IIF file imports into QuickBooks as a single operation, which is faster and more organized than importing 20 individual files.
Each invoice in a batch is parsed independently. If one invoice has an unusual layout or a field that cannot be automatically identified, it does not affect the processing of the other invoices in the batch. The system reports the status of each invoice individually, so you can review and correct any issues on specific invoices while the rest of the batch proceeds without delay.
The batch export file groups transactions by vendor and sorts them by date within each vendor group. This ordering makes it easy to verify the import in QuickBooks, as all invoices from the same vendor appear together in the transaction register. For bookkeepers managing multiple clients, you can run separate batches for each client and generate client-specific export files.
Batch Processing by Plan
Upload and process one invoice at a time. Suitable for low-volume users who process invoices as they receive them.
Upload up to 20 PDF invoices at once and generate a single combined export file. Ideal for weekly invoice processing workflows.
No limit on batch size. Process 50, 100, or more invoices in a single batch with priority processing for faster completion.
What a Vendor Template Stores
Where to find vendor name, invoice number, date, and amount on the page
Default QuickBooks accounts for this vendor's invoices
Keyword-based rules for assigning line items to expense accounts
The date format this vendor uses (MM/DD/YYYY, DD/MM/YYYY, etc.)
Vendor Templates
Vendor templates allow you to save parsing configurations for specific vendors so that every future invoice from that vendor is processed with consistent, accurate results. When you process an invoice and verify the extracted data, you can save the field positions and account mappings as a template linked to that vendor name.
The next time you upload an invoice from the same vendor, PDFQBO recognizes the vendor and automatically applies the saved template. The system matches vendors by name, so even if the invoice layout changes slightly between billing periods, the template adapts as long as the vendor name remains consistent.
Templates are particularly valuable for recurring invoices from vendors you pay every month, such as utility companies, internet providers, office supply vendors, and software subscription services. Once the template is configured for the first invoice, every subsequent monthly invoice from that vendor is processed without any manual review required. The savings compound quickly when you have 10 or 20 regular vendors, each sending monthly invoices.
For team accounts, vendor templates are shared across all team members. When one person creates a template for a new vendor, every other team member benefits from that template immediately. This collaborative approach means that across your entire team, each vendor's invoice format only needs to be configured once, regardless of who processes the first invoice from that vendor.
REST API for Automated Workflows
The PDFQBO API lets you integrate invoice conversion into your existing systems and automate the entire workflow from invoice receipt to QuickBooks import. The REST API accepts PDF files via HTTP POST and returns structured JSON data with all extracted fields, or generates QBO and IIF files for download.
Common API use cases include connecting your email inbox to PDFQBO so that invoices received as email attachments are automatically processed and converted. Another common integration is with document management systems where invoices are scanned and stored: the API can pull new invoices from the document system, process them, and push the resulting QuickBooks files to a shared folder for import.
The API supports both synchronous and asynchronous processing modes. For small invoices (under 5 pages), the synchronous mode returns results within a few seconds. For larger invoices or batch requests, the asynchronous mode accepts the request immediately and sends a webhook notification to your callback URL when processing is complete. This prevents timeouts and allows your application to continue operating while invoices are being processed in the background.
API authentication uses bearer tokens that you generate from your account settings. Each token can be scoped to specific operations (upload only, download only, or full access) and can be revoked individually if compromised. Rate limits are generous for Pro plan users, with up to 1,000 API requests per hour and no per-file size restrictions beyond the standard 10 MB limit.
API Endpoints
Upload a PDF and receive extracted data in JSON format
Upload a PDF and download a QBO file
Upload a PDF and download an IIF file
List all past conversions with metadata
List and manage vendor templates
Additional Capabilities
Beyond the core conversion features, PDFQBO includes tools that make your invoice processing workflow more efficient and reliable.
Duplicate Detection
Before generating an export file, PDFQBO checks your conversion history for invoices with the same vendor name, invoice number, and amount. If a potential duplicate is found, the system warns you before proceeding. This prevents the common accounts payable error of entering the same invoice twice, which creates double payments and requires manual correction in QuickBooks. The duplicate check works across individual and batch uploads.
Multi-Currency Support
Process invoices in USD, CAD, EUR, GBP, AUD, and other major currencies. The parser detects the currency from symbols, codes, and contextual clues on the invoice. The correct currency code is included in the exported QBO or IIF file, so QuickBooks users with multi-currency enabled receive transactions in the correct currency without manual adjustment. Currency detection supports both symbol notation ($, EUR, GBP) and ISO 4217 codes.
Account Mapping Rules
Create rules that automatically assign QuickBooks expense accounts to invoice line items based on vendor name, description keywords, or amount thresholds. For example, configure a rule that assigns all invoices from your internet provider to the Utilities expense account, or a rule that maps any line item containing the word "shipping" to the Shipping and Delivery account. Rules are applied automatically during conversion, producing export files with pre-assigned accounts that import cleanly into QuickBooks.
Custom Field Mapping
For invoices with non-standard layouts that the automatic parser cannot fully interpret, you can define custom field positions using a visual mapping tool. Click on the area of the PDF where each field appears, and the system saves that position as part of a vendor template. This is useful for invoices from specialized industry software or custom billing systems that use unusual placements for standard fields like invoice number or date.
Export History
Every conversion is logged in your account with the original filename, conversion date, number of transactions, export format, and file size. You can re-download any previously generated QBO or IIF file without re-uploading the original PDF. This is useful when you need to re-import a file after a QuickBooks data issue, or when you want to review what was included in a past import. The history is searchable by date range, vendor name, and file format.
Priority Processing
Pro plan users receive priority processing for all conversions. During periods of high demand, such as month-end close or tax season when many users are processing large batches simultaneously, priority processing ensures your invoices are converted ahead of the standard queue. Average processing time for priority users is under 10 seconds per invoice, compared to up to 30 seconds during peak periods for standard processing.
PDFQBO vs. Manual Invoice Entry
A detailed comparison of automated conversion with PDFQBO versus the traditional method of manually typing invoice data into QuickBooks.
| Criteria | Manual Entry | PDFQBO |
|---|---|---|
| Processing time per invoice | 3 to 5 minutes | Under 30 seconds |
| Accuracy rate | 95 to 98% (human error) | Over 99% (digital PDFs) |
| Batch capability | One at a time only | Up to unlimited per batch |
| Line item detail | Must type each line manually | Automatic extraction |
| Vendor name consistency | Varies by person and day | 100% consistent |
| Duplicate detection | Manual memory only | Automatic checking |
| Account assignment | Must select each time | Rule-based automation |
| Audit trail | None built in | Complete conversion history |
Technical Specifications
Detailed technical information about file formats, limits, and system requirements for integrating PDFQBO into your workflow.
Input Requirements
Output Formats
QuickBooks Compatibility
Security and Infrastructure
Ready to Automate Your Invoice Processing?
Start converting PDF invoices to QuickBooks files in minutes. Choose the plan that fits your volume and eliminate manual data entry from your accounting workflow.