Match a bank CSV against the ledger in a sheet (n8n)

Drop a bank CSV in a folder and get a sheet of matched and unmatched items.

n8nBank reconciliationAdvancedHuman check: High

Tools
n8n: Google Drive, Google Sheets, QuickBooks Online

Time saved
~3-6 hrs/month (estimate)

Difficulty
Advanced

Steps

Google Drive Trigger: File Created in a Bank CSVs folder.
Google Drive → Download file, then Extract From File (Extract From CSV).
QuickBooks Online → Purchase → Get All and Payment → Get All for the same date range.
Code node: match on amount and date ±3 days, then tag each line Matched, Bank only, or Book only.
Google Sheets → Append Row into a reconciliation tab.

Keep a human check here: High risk

This builds a worksheet. It doesn't reconcile anything in your books, so mark items cleared in QuickBooks yourself.

Node and module names match n8n's docs as of Oct 2026. Apps rename triggers and actions sometimes, so check yours in the editor. Try it with test data or a sandbox company first.

Build it

[AFFILIATE LINK PLACEHOLDER: not live]
Try n8n. We may earn a commission if you sign up, at no cost to you. Disclosure

Related recipes

Get Slack alerts for large bank transactions (Zapier)

Get a message whenever a bank-feed transaction over a set amount shows up in QuickBooks.

ZapierBank reconciliationBeginnerHuman check: Low

Saves ~1 hr/month

Weekly reminder to clear uncategorized transactions (Make)

Count unreconciled Xero bank transactions and post the number every Friday, so month-end doesn't pile up.

MakeBank reconciliationIntermediateHuman check: Low

Saves ~1-2 hrs/month

Get AI-suggested GL codes for card transactions (n8n)

Paste card transactions into a sheet and get a suggested account and a confidence score for each one.

n8nBank reconciliationIntermediateHuman check: High

Saves ~2-4 hrs/month