Automated Stripe Sales & Fee Reconciliation (Make.com)

Accurately sync Stripe transactions and processing fees to QuickBooks Online using advanced Make.com workflows.

Tools: Stripe → QuickBooks Online

Platform: Make.com

Short Answer

Every Stripe payment automatically creates a Sales Receipt and an Expense for the fee in QuickBooks. Your QBO 'Stripe Clearing Account' will match your Stripe balance to the penny, enabling one-click reconciliation.

The Problem

Manual entry of Stripe sales into QuickBooks leads to human error and reconciliation headaches. Because Stripe payouts are net of fees, bank balances never match sales receipts without manual fee adjustments.

The Outcome

Every Stripe payment automatically creates a Sales Receipt and an Expense for the fee in QuickBooks. Your QBO 'Stripe Clearing Account' will match your Stripe balance to the penny, enabling one-click reconciliation.

Step-by-Step Guide

1. **Establish Connections**: In Make.com, add the Stripe ‘Watch Events’ module. Link your Stripe account using your Restricted API Key. Add the QuickBooks Online module and authorize via OAuth2. 2. **Stripe Trigger**: Set the Stripe module to the 'payment_intent.succeeded' event. In the 'Limit' field, set it to 1 initially for testing. 3. **Retrieve Fee Data**: Add a Stripe 'Retrieve a Balance Transaction' module. Map the `Balance Transaction ID` from the trigger module; this is essential to access the exact `fee` amount. 4. **Search and Match**: Add a QuickBooks Online 'Search for Customers' module. Use the filter: `Name = {{Customer_Name}}` or `Email = {{Customer_Email}}` to prevent duplicates. 5. **Conditional Logic (Router)**: Place a Router after the search. If the search returns no results, use a 'Create a Customer' module. If results exist, proceed to use that ID. 6. **Create Sales Receipt**: Map the `Amount` from Stripe (Note: Stripe uses cents, so use `{{amount / 100}}`). Map the transaction date and select your 'Stripe Clearing Account' as the 'Deposit To' account. 7. **Record Processing Fee**: Add a QuickBooks 'Create an Expense' module. Map the `Fee` from the Balance Transaction module (divided by 100). Set the 'Category' to 'Bank Charges/Stripe Fees' and the 'Payment Account' to 'Stripe Clearing Account'. 8. **Data Conversion**: Use Make's built-in `formatDate` function for transaction dates: `{{formatDate(created; "YYYY-MM-DDTHH:mm:ssZ")}}` to ensure QuickBooks compatibility. 9. **Error Handling**: Right-click the QuickBooks modules and select 'Add error handler'. Use the 'Break' directive to store the execution and allow you to fix and retry if QBO is down.