Flag Unmatched Bank Transactions for Daily Reconciliation
Keep books clean by matching daily bank transactions against your ledger and flagging anything unmatched for quick review.
- 1
Pull Transactions
Add a
Schedule Triggerdaily and anHTTP Requestfetching new bank transactions. - 2
Match Against the Ledger
Add a
Codenode matching transactions to recorded entries. - 3
Flag the Unmatched
Add an
IFnode continuing for transactions with no match. - 4
Route for Review
Add a
Slacknode listing unmatched items for the bookkeeper. - 5
Activate and Test
Activate the workflow with an unmatched test transaction. Confirm it's flagged.
Frequently asked questions
Why reconcile daily?
Daily reconciliation catches errors and fraud early and makes month-end close far faster.
Can it auto-match obvious ones?
Auto-match high-confidence pairs and only surface genuine exceptions for human review.
Log Stripe Payments from Zapier into a Google Sheets Accounting Ledger
An n8n workflow that receives successful Stripe charges relayed by Zapier, calculates fees and net amount, and appends a clean bookkeeping row to a Google Sheets ledger — giving small businesses a real-time revenue log without paying for accounting software.
Free recipeGenerate a Weekly Cohort Retention Report Automatically
Know if customers are sticking — build a weekly cohort retention report from your usage data and deliver it to the team without touching a spreadsheet formula.
Free recipeGet Alerted the Moment a Supplier Changes Their Prices
An n8n workflow that periodically fetches your suppliers' price lists, compares them to the last known prices, and alerts you to any increases or drops with the exact delta — so cost creep never silently erodes your margins and you can renegotiate or re-price in time.