# Getting a PDF invoice into the books

QuickBooks Online's emailed-bill route lists dates, amounts, vendor and card digits; Xero fills six header fields on a draft bill; Excel's PDF connector reads tables only; Azure's invoice model also extracts line items. Read from vendor help pages, 2026-11-06.

An invoice arrives as a PDF and has to become a bill in the books. Four routes appear in vendors' own pages, and they differ in what they read from the document. This page lists what each page says it reads and what it limits, so that what is sold as AI invoice processing can be compared by fields rather than by name. Per-page prices for the cloud services are on [AI document processing for invoices and receipts](/research/ai-document-processing-invoices-receipts), the capture tools on [Dext and Hubdoc](/research/dext-and-hubdoc), and a test of language models on document fields on [Can AI do data entry?](/research/ai-data-entry).

| Route | Reads | Lands as | Stated limit |
|---|---|---|---|
| Excel, Power Query PDF connector | Tables in a PDF[1] | A table in a workbook | Multiple files need a Folder connector[1] |
| QuickBooks Online, email a bill | Dates, amounts, vendor, last four card digits[2] | A receipt to review and match[2] | 46KB to 20 MB per attachment[2] |
| Xero, upload a bill | Contact, Date, Total, Due Date, Reference, Description[3] | A draft bill[3] | Under 25MB; JPG, PDF, PNG[3] |
| Azure Document Intelligence, invoice model | Key fields and line items[4] | JSON for your own system[4] | Free tier reads the first two pages[4] |

## Excel reads tables and not invoices

Microsoft's Power Query documentation lists a PDF connector, generally available in Excel, whose function `Pdf.Tables` "Returns any tables found in a PDF file."[1] It has options for page ranges and for combining tables that run across pages.[1] The page says nothing about scanned documents or recognizing text in images, and it does not read an invoice as an invoice: what comes out is whatever the connector detects as tables. For many files it says "use a multi-file connector such as the Folder connector or SharePoint Folder connector."[1]

## QuickBooks Online takes a forwarded bill

Intuit's help article says to forward images of receipts and bills to a custom address at assist.intuit.com: "We'll extract info like dates and amounts to populate the transaction."[2] Further down: "QuickBooks automatically pulls dates, amounts, vendor, and last four digits of the credit card from the image." Files can be PDF, JPEG, JPG, GIF or PNG, and "The email attachment's file size must be between 46KB to 20 MB."[2] The result sits in the Receipts tab to "add them to your accounts or match them to existing transactions."[2] The article does not mention line items or account coding. It is the US-English article (`en-us`).

A different feature goes the other way. Intuit's help for Intuit Intelligence describes turning project documents into draft invoices to customers: "Review the extracted details alongside the source document and confirm the files you want to create invoices from."[5] That is for sales invoices, not bills received.

## In Xero each file becomes a draft bill

Xero's help says "Each file creates a draft bill in the organisation", with no limit on how many files go in at once, and the file "must be less than 25MB in size" in JPG, PDF or PNG.[3] "If Xero can read the uploaded bill successfully, we automatically populate the Contact, Date, Total, Due Date, Reference and Description fields."[3] The draft is set to tax inclusive, and "The correct tax amount is calculated once you enter an Account Code and Tax Rate", so coding stays with the person.[3] If the organisation uses several currencies, the draft is created in the base currency and "you need to manually change the currency".[3]

## Azure reads fields and line items

Microsoft's Document Intelligence page says the invoice model "uses powerful Optical Character Recognition (OCR) capabilities to analyze and extract key fields and line items from sales invoices, utility bills, and purchase orders."[4] Output is JSON, with values such as invoice ID, bill to, total and line items for a developer to send on to an accounts payable system.[4] Limits: "For PDFs and TIFFs, up to 2,000 pages can be processed. (With a free-tier subscription, only the first two pages are processed.)" and password-locked PDFs "must" be unlocked first.[4]

A workflow tool can sit between these routes and the books; what n8n's QuickBooks and Xero nodes and its invoice templates claim is on [n8n for accounting: nodes, templates, licence](/research/n8n-for-accounting).

## Not yet proven

- **Accuracy of any route on real invoices.** These are help pages; none reports how often a field is wrong.
- **Whether QuickBooks Online reads line items.** The article lists header fields and says nothing on line items.
- **Canadian versions of the QuickBooks articles.** The QuickBooks articles read are the US-English versions.
- **Whether Excel's connector can read scanned invoices.** The page is silent on it.
- **The time saved.** No source here times a person against a route on the same set of invoices.

If you move supplier invoices into your books and have counted the fields you still re-key, I would like to compare notes: mackenzie@mackenziebowes.com.

## Sources

1. Microsoft Learn, Power Query PDF connector. Read in Rotunda 2026-11-06. <https://learn.microsoft.com/en-us/power-query/connectors/pdf>
2. Intuit QuickBooks Help, Email receipts and bills. Read in Rotunda 2026-11-06. <https://quickbooks.intuit.com/learn-support/en-us/help-article/accounts-payable/email-receipts-bills-quickbooks-online/L7r2LAQ7C_US_en_US>
3. Xero Central, Upload bills into Xero. Read in Rotunda 2026-11-06. <https://central.xero.com/0/article/Upload-bills-into-Xero>
4. Microsoft Learn, Document Intelligence invoice model. Read in Rotunda 2026-11-06. <https://learn.microsoft.com/en-us/azure/ai-services/document-intelligence/prebuilt/invoice?view=doc-intel-4.0.0>
5. Intuit QuickBooks Help, Automate invoices with Intuit Intelligence. Read in Rotunda 2026-11-06. <https://quickbooks.intuit.com/learn-support/en-us/help-article/job-estimates/automate-invoices-intuit-intelligence/L6mh8JHg5_US_en_US>

---

Published 2026-11-06. Web page: https://www.mackenziebowes.com/research/pdf-invoices-into-accounting-software
