Automated Stripe Sales & Fee Reconciliation (Zapier)

Eliminate manual bookkeeping and perfectly reconcile Stripe payments including processing fees using Zapier Paths.

Tools: Stripe → QuickBooks Online

Platform: Zapier

Short Answer

For every successful Stripe charge, Zapier will automatically create a Sales Receipt for the gross amount and a separate Expense for the Stripe fee. This ensures your QuickBooks 'Stripe Clearing Account' balance matches your actual Stripe dashboard to the penny.

The Problem

Manual entry of Stripe transactions into QuickBooks Online is time-consuming and prone to human error. Specifically, Stripe payouts are 'net' of fees, making it impossible to reconcile bank deposits against gross sales without manual calculations.

The Outcome

For every successful Stripe charge, Zapier will automatically create a Sales Receipt for the gross amount and a separate Expense for the Stripe fee. This ensures your QuickBooks 'Stripe Clearing Account' balance matches your actual Stripe dashboard to the penny.

Step-by-Step Guide

1. **Create the Zap**: Log into Zapier and click 'Create Zap'. Name it 'Stripe to QBO: Sales & Fees'. 2. **Set Trigger**: Select **Stripe** as the App and **New Charge** as the Event. Connect your Stripe account via API key. Test the trigger to pull in a recent successful payment. 3. **Add Filter (Optional but Recommended)**: Add a 'Filter by Zapier' step. Set it to only continue if `Status` exactly matches `succeeded`. This prevents uncaptured authorizations from hitting your books. 4. **Format Currency**: Stripe sends amounts in cents (e.g., 1000 for $10.00). Add **Formatter by Zapier** -> Numbers -> Spreadsheet-Style Formula. Input `{{amount}} / 100`. Repeat this for the `Fee` field found under the Balance Transaction lookup. 5. **Find/Create Customer**: Add **QuickBooks Online** -> **Find Customer**. Map the Stripe `Customer Email`. Check the box 'Create QuickBooks Online Customer if it doesn't exist yet' and map the `Customer Name` from Stripe. 6. **Create Sales Receipt**: Add **QuickBooks Online** -> **Create Sales Receipt**. - **Customer**: Use the ID from Step 5. - **Deposit To**: Select your 'Stripe Clearing' Asset Account. - **Line Items**: Map the Gross Amount from the Formatter step. 7. **Record Stripe Fee**: Add **QuickBooks Online** -> **Create Expense**. - **Payee**: Create a Vendor named 'Stripe'. - **Payment Account**: Select your 'Stripe Clearing' Asset Account. - **Category**: Select 'Bank Service Charges' or 'Processing Fees'. - **Amount**: Map the Fee amount from the Formatter step. 8. **Turn on Zap**: Run a final test on all steps and publish the Zap.