Bank Statement to QuickBooks Import
Reads a bank statement PDF, pulls out every transaction with AI and books it in QuickBooks: credits as sales receipts and debits as expenses. Missing customers, vendors and items are created on the fly.

On this page
How it works
- A statement PDF is uploaded through a form and its text is extracted.
- AI converts the text into a clean list of transactions.
- Each transaction is classified as credit or debit.
- Customers, vendors and items are matched, or created if they don't exist yet.
- Sales receipts and expenses are posted to QuickBooks.
Use cases
- Bookkeepers and accounting firms
- Small business owners
- Month-end reconciliation
What you need
This workflow connects to these apps.
- QuickBooks
- Extract Data
- n8n
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- OpenRouter account
- QuickBooks Online account
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| Extract PDF Text | extractFromFile |
| Transaction Extractor AI | agent |
| JSON Output Parser | outputParserStructured |
| Create QuickBooks SalesReceipt | httpRequest |
| Bank Statement Form | formTrigger |
| OpenRouter Chat Model | lmChatOpenRouter |
| Split Transactions | splitOut |
| Loop Over Items | splitInBatches |
| Build Salesreceipt Payload | code |
| Get many customers | quickbooks |
| Create Vendor | quickbooks |
| Vendor Exists? | if |
| Find Vendor | quickbooks |
| Search Categories | httpRequest |
| Create Items | httpRequest |
| Collect All Item Mappings | code |
| Need to Create Items? | if |
| Get All QB Items | quickbooks |
| Check Which Items to Create | code |
| Credit or Debit? | switch |
| Customers Exists?1 | if |
| Create a Customer | quickbooks |
| Create QuickBooks Expense | httpRequest |
| Build Expense Payload | code |
Frequently asked questions
Reads a bank statement PDF, pulls out every transaction with AI and books it in QuickBooks: credits as sales receipts and debits as expenses. Missing customers, vendors and items are created on the fly. It's a 24-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for OpenRouter and QuickBooks. It uses only nodes that ship with n8n, so there's nothing else to install.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



