Automated Stripe Revenue Recognition & Fee Reconciliation (Zapier)

Eliminate manual bookkeeping by syncing Stripe sales and processing fees to QuickBooks Online with 100% accuracy.

Tools: Stripe → QuickBooks

Platform: Zapier

Short Answer

Every Stripe transaction automatically creates a Sales Receipt and an Expense record in QuickBooks. By using a 'Stripe Clearing' account, you achieve perfect reconciliation where Gross Sales minus Fees equals the Net Deposit in your bank.

The Problem

Accounting for Stripe payments is notoriously difficult because Stripe reports in cents and deposits funds 'Net of Fees.' This leads to discrepancies between gross sales and bank deposits, often requiring hours of manual journal entries and reconciliation.

The Outcome

Every Stripe transaction automatically creates a Sales Receipt and an Expense record in QuickBooks. By using a 'Stripe Clearing' account, you achieve perfect reconciliation where Gross Sales minus Fees equals the Net Deposit in your bank.

Step-by-Step Guide

1. **Trigger**: Select **Stripe** as the Trigger App and choose **New Charge** or **New Payment Intent Succeeded**. Connect your Stripe account via API key. 2. **Formatter (Numbers)**: Stripe sends amounts in cents (e.g., 1000 for $10). Add a **Formatter by Zapier** step. Choose **Numbers** > **Perform Math Operation** > **Divide**. Map the Stripe `Amount` field and divide by `100` to get the dollar value. 3. **Formatter (Fees)**: Repeat step 2 for the `Fee` field provided by Stripe to ensure your processing costs are also converted to decimals. 4. **Action (Search)**: Add **QuickBooks Online** as the Action App. Choose **Find Customer**. Search by the Stripe `Customer Email`. Check the box **'Create QuickBooks Online Customer if it doesn't exist yet'** to prevent duplicates. 5. **Action (Create Receipt)**: Add **QuickBooks Online** > **Create Sales Receipt**. - Link the **Customer ID** from the previous step. - Set the **Deposit To** field to a 'Stripe Clearing' Asset Account (not your main Checking account). - Map the converted Gross Amount from the Formatter step. 6. **Action (Create Expense)**: Add **QuickBooks Online** > **Create Expense**. - **Payee**: Create a vendor named 'Stripe'. - **Payment Account**: 'Stripe Clearing'. - **Category**: 'Bank Charges & Fees'. - **Amount**: Map the converted Fee amount from Step 3. 7. **Error Handling**: Use **Zapier Paths** (Professional Plan) to handle cases where a transaction fails. If a step fails, create a 'Path B' that sends a Slack notification with the Stripe Charge ID for manual review. 8. **Publish**: Name your Zap and flip the toggle to **On**.