How to sync Stripe payouts to QuickBooks with Pipedream

Workflows > New

Create new Pipedream workflow

Go to pipedream.com and click New Workflow. You'll see a blank canvas with a trigger placeholder. This is where you'll set up the Stripe payout webhook that fires whenever money hits your bank account.

1. 1Click 'New Workflow' button in top right
2. 2Name it 'Stripe Payouts to QuickBooks'
3. 3Click the trigger step placeholder

Trigger > Select App > Stripe

Add Stripe payout webhook trigger

Search for Stripe in the trigger apps list. Select 'New Payout' from the event options. This webhook fires whenever Stripe transfers money to your connected bank account, which happens daily for most businesses.

1. 1Type 'Stripe' in the search box
2. 2Click the Stripe app icon
3. 3Select 'New Payout' from the event dropdown
4. 4Click 'Save and continue'

Trigger Configuration > Connect Account

Connect your Stripe account

Click 'Connect Account' to authenticate with Stripe. You'll need admin access to your Stripe dashboard. Pipedream will redirect you to Stripe's OAuth flow to grant read permissions for payout data.

1. 1Click the 'Connect Account' button
2. 2Sign in to your Stripe dashboard when redirected
3. 3Click 'Connect' to authorize Pipedream
4. 4Return to Pipedream when the redirect completes

Trigger Configuration > Test

Test the Stripe trigger

Click 'Send Test Event' to simulate a payout webhook. Pipedream will show you sample payout data including amount, currency, and arrival date. This helps you understand the data structure before mapping fields to QuickBooks.

1. 1Click 'Send Test Event' button
2. 2Wait 3-5 seconds for the test data to load
3. 3Expand the event data to see payout details
4. 4Note the 'amount' and 'currency' fields

Workflow > Add Step > QuickBooks Online

Add QuickBooks action step

Click the + button below your trigger to add a new step. Search for QuickBooks Online and select 'Create Deposit'. This action will create the bank deposit record that matches your Stripe payout amount.

1. 1Click the + button below the trigger step
2. 2Search for 'QuickBooks Online'
3. 3Select the QuickBooks Online app
4. 4Choose 'Create Deposit' from the actions list

Action Configuration > Connect Account

Connect QuickBooks Online account

Click 'Connect Account' to authenticate with QuickBooks. You'll need admin or accounting permissions in your QBO company. The OAuth process will ask you to select which company file to connect if you have multiple.

1. 1Click 'Connect Account' button
2. 2Sign in to QuickBooks when redirected
3. 3Select your company from the dropdown if multiple exist
4. 4Click 'Connect' to authorize Pipedream

Action Configuration > Deposit To Account

Configure deposit account mapping

Select your business checking account from the 'Deposit To Account' dropdown. This should match the bank account where Stripe deposits arrive. The account list pulls directly from your QuickBooks chart of accounts.

1. 1Click the 'Deposit To Account' dropdown
2. 2Select your main business checking account
3. 3Verify the account name matches your Stripe deposit destination
4. 4Leave other account fields for the next step

Action Configuration > Amount and Date

Map payout amount and date fields

Click in the 'Amount' field and select the Stripe payout amount from the dropdown. This pulls from your trigger data. Convert from cents by dividing by 100. Set the deposit date to match when funds actually arrive in your bank.

1. 1Click the 'Amount' field
2. 2Select 'steps.trigger.event.amount' from dropdown
3. 3Add '/ 100' to convert from cents to dollars
4. 4Set 'Deposit Date' to 'steps.trigger.event.arrival_date'

Action Configuration > Memo

Add deposit memo for identification

In the 'Memo' field, create a description that includes the Stripe payout ID and date. This helps your bookkeeper identify which bank transaction matches this QuickBooks deposit record during reconciliation.

1. 1Click the 'Memo' field
2. 2Type 'Stripe Payout: '
3. 3Add the payout ID from 'steps.trigger.event.id'
4. 4Include the arrival date for easy reference

Workflow > Test

Test the complete workflow

Click 'Test' to run the entire workflow with your sample data. Pipedream will create an actual deposit record in your QuickBooks company, so check that the amount, date, and memo look correct before going live.

1. 1Click the 'Test' button at the top of the workflow
2. 2Wait for both steps to complete successfully
3. 3Check for green checkmarks on each step
4. 4Review the QuickBooks response data

Workflow > Deploy

Deploy workflow to production

Click 'Deploy' to activate the workflow. Pipedream will start listening for real Stripe payout webhooks immediately. The webhook URL is automatically registered with Stripe, so no additional configuration is needed on the Stripe side.

1. 1Click the 'Deploy' button in the top right
2. 2Confirm you want to activate the workflow
3. 3Wait for the 'Active' status to appear
4. 4Note the webhook URL for your records

Add this Node.js code step between Stripe and QuickBooks to handle fee breakdowns and create separate expense entries for Stripe processing fees. Paste this in a new Code step after the trigger.

export default defineComponent({
  async run({ steps, $ }) {
    const payout = steps.trigger.event;

export default defineComponent({
  async run({ steps, $ }) {
    const payout = steps.trigger.event;
    
    // Calculate net deposit and fees
    const grossAmount = payout.amount / 100;
    const feeAmount = (payout.automatic_fees || 0) / 100;
    const netAmount = grossAmount - feeAmount;
    
    // Format dates for QuickBooks
    const depositDate = new Date(payout.arrival_date * 1000).toISOString().split('T')[0];
    
    // Create structured deposit data
    const depositData = {
      net_amount: netAmount,
      fee_amount: feeAmount,
      gross_amount: grossAmount,
      deposit_date: depositDate,
      payout_id: payout.id,
      memo: `Stripe Payout ${payout.id} - Net: $${netAmount.toFixed(2)}, Fees: $${feeAmount.toFixed(2)}`
    };
    
    // Return for next step
    return depositData;
  }
});