What happens if QuickBooks is offline when a payout occurs?

Zapier retries failed actions up to 3 times over 1 hour. If QuickBooks API remains unavailable, the task fails and you'll need to manually replay it from your Zap history once service resumes.

Can I split one Stripe payout into multiple QuickBooks deposits?

Not directly in Zapier - it creates one deposit per payout. You'd need Make's iterator module or custom logic to split based on Stripe metadata. Most businesses deposit the full amount then use journal entries for allocation.

How do I handle Stripe payouts that include refunds or chargebacks?

Stripe nets these against your payout automatically, so the arrival amount is already adjusted. Create separate Zaps for refund and chargeback webhooks if you want individual QuickBooks entries for audit trails.

Will this work with Stripe Express or Connect accounts?

Only if you have access to the transfer.created webhook for those connected accounts. Standard Zapier integration works with your main Stripe account - connected accounts require custom webhook setup.

What if my QuickBooks and Stripe currencies don't match?

Zapier doesn't handle currency conversion automatically. You'll need a Formatter step to convert amounts using current exchange rates, or handle multi-currency deposits manually in QuickBooks.

Beginner~8 min setupFinance & FinanceVerified April 2026

How to Create QuickBooks Deposits from Stripe Payouts with Zapier

Automatically create bank deposit records in QuickBooks when Stripe sends payouts to your bank account for easier reconciliation.

Steps and UI details are based on platform versions at time of writing — check each platform for the latest interface.

Zapier

Also on:Make N8n Power-automate Pipedream

Best for

Small businesses processing under 100 Stripe payouts monthly who want simple setup without coding.

Not ideal for

High-volume merchants or companies needing custom payout splitting logic across multiple QuickBooks entities.

Sync type

real-time

Use case type

sync

Real-World Example

💡

A 12-person SaaS company processes 40 Stripe payouts monthly and spent 2 hours each month manually entering deposits into QuickBooks. Their bookkeeper had to cross-reference Stripe transfer IDs with bank statements and often made data entry errors on amounts. Now deposits appear automatically in QuickBooks within minutes of Stripe processing, with transfer IDs in the memo field for easy bank reconciliation.

What Will This Cost?

Drag the slider to your expected monthly volume.

Monthly workflow runs

/mo

505005K50K

Each platform counts differently — Zapier: 1 task per trigger. Make: 1 operation per module per record. n8n: 1 execution per run.

$30/mo if billed monthly

Pipedream

$29/mo

Basic plan

Prices shown for annual billing. Based on published pricing as of April 2026.

Estimated ROI

1000

min saved/mo

$583

labor value/mo

Free

no platform cost

Based on ~2 min manual effort per operation at $35/hr fully loaded labor cost.

Implementation

Before You Start

Make sure you have everything ready.

Active Stripe account with payouts enabled to your bank account

QuickBooks Online subscription with bank deposit permissions

Chart of accounts set up in QuickBooks with your business checking account

Revenue account created in QuickBooks for Stripe income

Zapier account with available tasks on your plan

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Deposit Amount	`net_amount`	The actual amount deposited to your bank account after Stripe fees
Deposit Date	`arrival_date`	When the funds arrive in your bank account according to Stripe
Transfer ID	`id`	Stripe's unique identifier for the payout, used for reconciliation tracking
Bank Account	`destination`	The bank account receiving the deposit (mapped to QuickBooks account)

2 optional fields▸ show

Currency	`currency`	Three-letter currency code (USD, EUR, etc.) for the deposit
Payout Description	`description`	Optional description from Stripe about the payout timing or source

Step-by-Step Setup

Dashboard > Create Zap > Choose App & Event

Set up Stripe payout trigger

Configure Zapier to detect new Stripe payouts. This trigger fires whenever Stripe processes a payout to your bank account, capturing the amount and timing details.

1Click 'Create Zap' from your Zapier dashboard
2Search for 'Stripe' in the app selector
3Select 'Transfer Created' as your trigger event
4Choose 'automatically' for the transfer type filter

✓ What you should see: You should see 'Transfer Created' selected with Stripe as your trigger app.

Zapier

click +

search apps

QuickBooks

Set up Stripe payout trigger

QuickBooks

module added

Trigger > Choose Account > Sign in to Stripe

Connect your Stripe account

Authenticate Zapier with your Stripe account using your API keys. You'll need your live API keys for production payouts.

1Click 'Sign in to Stripe'
2Enter your Stripe account email and password
3Click 'Allow access' to authorize Zapier
4Verify the connection shows your account name

✓ What you should see: A green checkmark appears next to your Stripe account name.

⚠

Common mistake — Use live API keys for production payouts, not test keys - test transfers won't trigger for real bank deposits.

Zapier settings

Connection

Choose a connection…Add

click Add

QuickBooks

Authorize Zapier

popup window

✓

Connected

green checkmark

Trigger > Test > Choose Record

Test the Stripe trigger

Pull in a recent payout from Stripe to use as sample data. This ensures your trigger is working and gives you real field values to map.

1Click 'Test trigger' button
2Select a recent payout from the dropdown list
3Click 'Continue with selected record'
4Review the payout data fields displayed

✓ What you should see: You should see payout details including amount, currency, arrival_date, and destination fields.

⚠

Common mistake — Pick a completed payout, not a pending one - pending transfers show estimated dates that may change.

Zapier

▶ Turn on & test

executed

✓

QuickBooks

✓

Stripe

🔔 notification

received

Action > Choose App & Event > QuickBooks Online

Add QuickBooks action step

Set up the action to create a bank deposit in QuickBooks when the Stripe trigger fires. This deposit will match your actual bank deposit.

1Click the '+' button to add an action step
2Search for 'QuickBooks Online' in the app list
3Select 'Create Bank Deposit' as the action event
4Click 'Continue' to proceed

✓ What you should see: QuickBooks Online appears as your action app with 'Create Bank Deposit' selected.

Action > Choose Account > Sign in to QuickBooks

Connect QuickBooks account

Authenticate with your QuickBooks Online account. Zapier needs access to create deposits and read your chart of accounts.

1Click 'Sign in to QuickBooks Online'
2Log in with your QuickBooks credentials
3Select the correct company if you have multiple
4Click 'Authorize' to grant Zapier access

✓ What you should see: Your QuickBooks company name appears with a connected status indicator.

⚠

Common mistake — Select the right company file - switching later requires reconnecting and remapping all fields.

Action > Set up Action > Deposit To Account

Map deposit account

Choose which bank account in QuickBooks receives the deposit. This should match the actual bank account where Stripe sends your payouts.

1Click the 'Deposit To Account' dropdown
2Select your primary business checking account
3Verify the account name matches your Stripe payout destination
4Click to confirm the selection

✓ What you should see: Your checking account appears in the Deposit To Account field.

⚠

Common mistake — Don't use a general 'Undeposited Funds' account - pick the specific bank account that receives Stripe transfers.

QuickBooks fields

DocNumber

CustomerRef.name

TotalAmt

Balance

DueDate

available as variables:

1.props.DocNumber

1.props.CustomerRef.name

1.props.TotalAmt

1.props.Balance

1.props.DueDate

Action > Set up Action > Deposit Date

Set deposit date

Map the payout arrival date from Stripe to the deposit date in QuickBooks. This keeps your records aligned with when money hits your bank.

1Click in the 'Deposit Date' field
2Select 'Arrival Date' from the Stripe data dropdown
3Verify the date format shows correctly
4Leave other date fields blank

✓ What you should see: The deposit date field shows 'Arrival Date' mapped from your Stripe trigger data.

⚠

Common mistake — Use arrival_date, not created_date - arrival_date reflects when funds actually reach your bank account.

Action > Set up Action > Line Items

Configure deposit line items

Set up the deposit details including amount and description. This creates the actual deposit entry that matches your Stripe payout amount.

1Click 'Add Line Item' to create a deposit line
2Map 'Amount' to the Stripe transfer amount field
3Set 'Account' to your Stripe revenue account
4Add 'Stripe Payout' in the description field

✓ What you should see: A line item appears with the Stripe amount mapped and your revenue account selected.

⚠

Common mistake — Map to net_amount if available - this excludes Stripe fees that were already deducted from previous transactions.

Action > Set up Action > Memo

Add deposit memo

Include identifying information in the deposit memo to help with manual reconciliation. Reference the Stripe transfer ID for easy lookup.

1Scroll to the 'Memo' field
2Click in the memo text box
3Type 'Stripe Payout - Transfer ID: '
4Map the Stripe transfer ID after the colon

✓ What you should see: The memo field shows 'Stripe Payout - Transfer ID: [Transfer ID from Stripe]'.

Action > Test > Send Test

Test the QuickBooks action

Run a test to create an actual deposit in QuickBooks using your sample Stripe data. This verifies all field mappings work correctly.

1Click 'Test action' at the bottom
2Review the test data being sent
3Click 'Send test to QuickBooks Online'
4Check the success message and deposit ID returned

✓ What you should see: A success message appears with a QuickBooks deposit ID number.

⚠

Common mistake — This creates a real deposit in QuickBooks - delete the test deposit manually if needed after verification.

Review > Publish > Turn On

Review and publish

Turn on your Zap to start automatically creating QuickBooks deposits for new Stripe payouts. The Zap runs every time Stripe processes a payout.

1Click 'Publish Zap' in the top right
2Give your Zap a descriptive name like 'Stripe Payouts to QuickBooks'
3Verify the trigger and action summary
4Click 'Turn on Zap' to activate

✓ What you should see: Your Zap shows 'On' status and begins monitoring for new Stripe payouts.

⚠

Common mistake — Your next real Stripe payout will trigger this Zap - monitor the task history for the first few runs.

Drop this into a Zapier Code step.

Copy this template{{arrival_date | date: "MM/DD/YYYY"}}

▸ Show code

{{arrival_date | date: "MM/DD/YYYY"}}

... expand to see full code

{{arrival_date | date: "MM/DD/YYYY"}}

Scaling Beyond 100+ payouts/month+ Records

If your volume exceeds 100+ payouts/month records, apply these adjustments.

Add deduplication logic

Create a lookup table in Google Sheets or Airtable to track processed transfer IDs. Add a filter step that skips payouts already recorded to prevent webhook retry duplicates.

Batch processing schedule

Switch from real-time to scheduled processing (every 4 hours) to reduce API rate limit conflicts with QuickBooks during busy periods. High-volume accounts often hit concurrent connection limits.

Going live

Production Checklist

Before you turn this on for real, confirm each item.

Test with a real Stripe payout, not sample data from the trigger test

Applies when: Always

Verify the mapped bank account matches where Stripe actually sends deposits

Applies when: Always

Set up email notifications for failed Zaps to catch QuickBooks API errors

Applies when: Always

Create a filter to skip payouts older than 24 hours to prevent duplicate processing

Applies when: High volume

Add error handling to pause the Zap after 5 consecutive failures

Applies when: Always

Document the revenue account mapping for your bookkeeper's reference

Applies when: Always

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy Zapier for this workflow

Use Zapier for this if you process under 100 payouts per month and want dead-simple setup. The guided interface handles Stripe webhooks and QuickBooks API calls without any coding. Your bookkeeper can set this up in 20 minutes. Skip Zapier if you need custom matching logic - like splitting payouts across multiple QuickBooks entities based on metadata. That requires Make's conditional routing.

Cost

This workflow uses 1 task per payout. At 50 payouts monthly, that's 50 tasks costing $20/month on Zapier's Professional plan. Make charges $9/month for 1,000 operations, so the same volume costs $0.45/month. N8n self-hosted is free but requires server management. Zapier costs 44x more than Make here, but the setup simplicity often justifies the premium for small teams.

Tradeoffs

Make handles this better with dedicated Stripe modules that parse webhook payloads more reliably than Zapier's generic transfer triggers. N8n offers superior error handling with retry policies and dead letter queues - crucial when QuickBooks API goes down during month-end processing. But Zapier's QuickBooks integration auto-refreshes expired tokens and handles rate limits transparently, eliminating the authentication headaches that plague Make and N8n users.

You'll hit Stripe's webhook retry logic when QuickBooks is slow - the same payout triggers multiple times creating duplicate deposits. Zapier's deduplication only works within 1 hour, so weekend processing delays cause issues. QuickBooks deposit API is picky about decimal precision - amounts like $1,234.567 get rejected even though Stripe sends them. The arrival_date field contains timezone info that QuickBooks rejects, requiring date formatting that isn't obvious in Zapier's mapper.

Ideas for what to build next

→
Add failed payment tracking — Create a second Zap that logs failed charges or disputed transactions to a Google Sheet for follow-up by your finance team.
→
Automate expense reconciliation — Set up invoice matching by connecting your expense management tool to QuickBooks, automatically matching receipts to credit card transactions.
→
Monthly reconciliation reports — Build a Zap that generates monthly Stripe vs QuickBooks reconciliation summaries in Google Sheets, highlighting any discrepancies for review.