Finance

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.

The Bank Statement to QuickBooks Import workflow on the n8n canvas, with its 24 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Finance
Nodes
24
Apps
QuickBooks, Extract Data
Price
Free
Download JSON
On this page

How it works

  1. A statement PDF is uploaded through a form and its text is extracted.
  2. AI converts the text into a clean list of transactions.
  3. Each transaction is classified as credit or debit.
  4. Customers, vendors and items are matched, or created if they don't exist yet.
  5. 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

  1. 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.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. 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

NodeType
Extract PDF TextextractFromFile
Transaction Extractor AIagent
JSON Output ParseroutputParserStructured
Create QuickBooks SalesReceipthttpRequest
Bank Statement FormformTrigger
OpenRouter Chat ModellmChatOpenRouter
Split TransactionssplitOut
Loop Over ItemssplitInBatches
Build Salesreceipt Payloadcode
Get many customersquickbooks
Create Vendorquickbooks
Vendor Exists?if
Find Vendorquickbooks
Search CategorieshttpRequest
Create ItemshttpRequest
Collect All Item Mappingscode
Need to Create Items?if
Get All QB Itemsquickbooks
Check Which Items to Createcode
Credit or Debit?switch
Customers Exists?1if
Create a Customerquickbooks
Create QuickBooks ExpensehttpRequest
Build Expense Payloadcode

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.

Keep exploring
  • n8n canvas of the Purchase Bill OCR to QuickBooks workflow

    Finance20 nodes

    Purchase Bill OCR to QuickBooks

    Upload supplier invoices and they become accurate QuickBooks bills, with no typing. AI extracts vendor, line items and totals, and anything missing in QuickBooks is created automatically.

  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.

  • n8n canvas of the AI Email Classifier & Slack Router workflow

    AI Automation11 nodes

    AI Email Classifier & Slack Router

    Reads incoming emails, has AI classify each one (support, sales, billing, HR and so on) and notifies the right team on Slack straight away.