Reconcile Stripe Payouts to Invoice Ledgers in Google Sheets

Reconcile every Stripe payout to your invoice ledger—automatically in Google Sheets

If Stripe pays you in lump sums while your invoice sheet records single amounts, this n8n workflow automatically matches them for you. Every Monday it opens recent Stripe payouts, pairs the underlying charge lines to your invoice ledger in Google Sheets, and writes an exceptions report so you only review what’s truly mismatched.

What this workflow does

• Runs on a weekly schedule: A schedule node triggers every Monday morning, using a single Settings node for all configurable values.
• Fetches paid payouts: It retrieves recent Stripe payouts within your configured lookback window.
• Reads payout line items: For each payout, the workflow opens the payout to list the underlying balance transactions (the lines that should reconcile).
• Loads your invoice ledger: It reads your invoice sheet once from Google Sheets.
• Matches lines to invoices: The matcher first pairs using a reference. If no reference match exists, it falls back to an exact amount match within a date window.
• Reports verdicts with tolerance: A tolerance in pence prevents rounding differences from being flagged. Every line gets a verdict in a report tab alongside its payout ID.
• Drafts emails for exceptions: If matching fails and the summary switch is enabled, it creates a Gmail draft for you to review before sending.

Use cases

• SaaS operators reconciling weekly Stripe payouts to invoice-level accounting in Google Sheets.
• Automation engineers needing a repeatable Stripe-to-ledger matching workflow in n8n.
• Finance teams managing reconciliation exceptions only (no time wasted on matches).

Technical details

• n8n nodes: if, set, code, gmail, sticky note, http request
• Integrations: Stripe via HTTP Request nodes using an n8n Stripe credential type; Google Sheets via Sheets credentials.
• Configuration: Update placeholders in the Settings node and ensure your sheet column names match exactly; set the report tab headers as listed on the canvas note beside the report node.