# Bank Statement to QuickBooks Import

**Category:** Finance  
**Tools:** QuickBooks, Extract Data, n8n  
**Nodes:** 24  
**Built by:** Forgent Systems

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.

![Workflow](preview.webp)

## 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

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - OpenRouter account
   - QuickBooks Online account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Extract PDF Text** — `n8n-nodes-base.extractFromFile`
- **Transaction Extractor AI** — `@n8n/n8n-nodes-langchain.agent`
- **JSON Output Parser** — `@n8n/n8n-nodes-langchain.outputParserStructured`
- **Create QuickBooks SalesReceipt** — `n8n-nodes-base.httpRequest`
- **Bank Statement Form** — `n8n-nodes-base.formTrigger`
- **OpenRouter Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenRouter`
- **Split Transactions** — `n8n-nodes-base.splitOut`
- **Loop Over Items** — `n8n-nodes-base.splitInBatches`
- **Build Salesreceipt Payload** — `n8n-nodes-base.code`
- **Get many customers** — `n8n-nodes-base.quickbooks`
- **Create Vendor** — `n8n-nodes-base.quickbooks`
- **Vendor Exists?** — `n8n-nodes-base.if`
- **Find Vendor** — `n8n-nodes-base.quickbooks`
- **Search Categories** — `n8n-nodes-base.httpRequest`
- **Create Items** — `n8n-nodes-base.httpRequest`
- **Collect All Item Mappings** — `n8n-nodes-base.code`
- **Need to Create Items?** — `n8n-nodes-base.if`
- **Get All QB Items** — `n8n-nodes-base.quickbooks`
- **Check Which Items to Create** — `n8n-nodes-base.code`
- **Credit or Debit?** — `n8n-nodes-base.switch`
- **Customers Exists?1** — `n8n-nodes-base.if`
- **Create a Customer** — `n8n-nodes-base.quickbooks`
- **Create QuickBooks Expense** — `n8n-nodes-base.httpRequest`
- **Build Expense Payload** — `n8n-nodes-base.code`
