Reconcile Stripe payments and flag anomalies with Google Sheets and Gemini AI

Who is this for

SMB finance teams, SaaS companies, and accounting professionals who need to automate transaction reconciliation between Stripe payments and their accounting ledgers. Perfect for businesses processing dozens to hundreds of daily transactions.

How it works

This workflow automatically reconciles Stripe payments with Google Sheets accounting data daily. It fetches recent Stripe charges, compares them against your ledger entries using amount, date, and reference ID matching, then uses Gemini AI to analyze any discrepancies found.

The reconciliation engine identifies missing entries, amount mismatches, timing differences, and duplicate payments. Gemini AI categorizes each discrepancy by severity and provides actionable recommendations. Results are logged to a Google Sheets reconciliation report and team alerts are sent via Slack. On Mondays, a comprehensive weekly summary is emailed to finance stakeholders.

How to set up

Connect your Stripe, Google Sheets, Slack, and Gmail credentials in n8n. Update the "User Settings" node with your spreadsheet ID, Slack channel, email recipients, and tolerance threshold for amount matching. Configure your accounting ledger sheet with columns for Date, Amount, Description, and Reference ID. Test with a small date range initially.

Requirements