{"product_id":"reconcile-stripe-payouts-to-invoice-ledgers-in-google-sheets","title":"Reconcile Stripe Payouts to Invoice Ledgers in Google Sheets","description":"\u003ch3\u003eReconcile every Stripe payout to your invoice ledger—automatically in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eIf 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekly schedule\u003c\/strong\u003e: A schedule node triggers every Monday morning, using a single \u003cstrong\u003eSettings\u003c\/strong\u003e node for all configurable values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches paid payouts\u003c\/strong\u003e: It retrieves recent \u003cstrong\u003eStripe\u003c\/strong\u003e payouts within your configured lookback window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads payout line items\u003c\/strong\u003e: For each payout, the workflow opens the payout to list the underlying \u003cem\u003ebalance transactions\u003c\/em\u003e (the lines that should reconcile).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your invoice ledger\u003c\/strong\u003e: It reads your invoice sheet once from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches lines to invoices\u003c\/strong\u003e: The matcher first pairs using a \u003cstrong\u003ereference\u003c\/strong\u003e. If no reference match exists, it falls back to an \u003cstrong\u003eexact amount\u003c\/strong\u003e match within a \u003cstrong\u003edate window\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReports verdicts with tolerance\u003c\/strong\u003e: A \u003cstrong\u003etolerance in pence\u003c\/strong\u003e prevents rounding differences from being flagged. Every line gets a verdict in a \u003cstrong\u003ereport tab\u003c\/strong\u003e alongside its payout ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts emails for exceptions\u003c\/strong\u003e: If matching fails and the summary switch is enabled, it creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e for you to review before sending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators reconciling weekly \u003cstrong\u003eStripe payouts\u003c\/strong\u003e to invoice-level accounting in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a repeatable \u003cstrong\u003eStripe-to-ledger\u003c\/strong\u003e matching workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003eFinance teams managing reconciliation exceptions only (no time wasted on matches).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: if, set, code, gmail, sticky note, http request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eStripe\u003c\/strong\u003e via HTTP Request nodes using an n8n Stripe credential type; \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via Sheets credentials.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration\u003c\/strong\u003e: Update placeholders in the \u003cstrong\u003eSettings\u003c\/strong\u003e node and ensure your sheet column names match exactly; set the report tab headers as listed on the canvas note beside the report node.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001866670259,"sku":"N8N-19458","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jQkOTJLE-eiiLy9BAARIB_lSkfCg6E.png?v=1789117946","url":"https:\/\/buyflowscripts.com\/products\/reconcile-stripe-payouts-to-invoice-ledgers-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}