Automate purchase bill processing with AI OCR & QuickBooks integration

by InfyOm Technologies ✓ · 736 views · created 2025-12-22 · Invoice Processing, AI Summarization

What this workflow does

This AI workflow has 20 nodes and runs when someone submits an n8n form (“Invoice Parser + QuickBooks Bill Creator”). Along the way it connects QuickBooks Online and OpenRouter Chat Model. It also calls sandbox-quickbooks.api.intuit.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Invoice Parser + QuickBooks Bill Creator”).

1. Convert to Separate Items (Code): runs custom JavaScript code
2. Loop Over Invoices (Loop Over Items (Split in Batches)): loops over the items in batches
3. Extract from PDF (Extract from File): extracts data from a file (pdf)
4. Clean Text (Code): runs custom JavaScript code
5. Extract Invoice Data (Information Extractor): extracts structured fields from text with AI, with model: OpenRouter Chat Model
6. Prepare Items to Check (Code): runs custom JavaScript code
7. Get All QB Items (QuickBooks Online): get many (item)
8. Check Which Items to Create (Code): runs custom JavaScript code
9. Need to Create Items? (If): checks a condition and branches into true / false
10. Split Items to Create (Split Out): splits a list into separate items

…plus 8 more steps. See the full node list below.

Services it uses

QuickBooks OnlineOpenRouter Chat Model

HTTP calls to: sandbox-quickbooks.api.intuit.com

Before you upgrade to n8n 3.0

Nodes used (11)

• Split Outn8n-nodes-base.splitOut
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• QuickBooks Onlinen8n-nodes-base.quickbooks
• Ifn8n-nodes-base.if
• Information Extractor@n8n/n8n-nodes-langchain.informationExtractor
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Extract from Filen8n-nodes-base.extractFromFile
• OpenRouter Chat Model@n8n/n8n-nodes-langchain.lmChatOpenRouter
• n8n Form Triggern8n-nodes-base.formTrigger

From the author

✅ What problem does this workflow solve? Accounting teams spend hours manually entering purchase bills into accounting systems—copying vendor details, creating items, checking duplicates, and reconciling totals. This workflow removes that manual effort…

View the original on n8n.io → Check your own copy