Why are my deposit amounts showing 100x larger in QuickBooks?

Stripe sends amounts in cents but QuickBooks expects dollars. You need to divide the Stripe amount by 100 in your field mapping: {{1.amount / 100}} instead of {{1.amount}}.

Can this handle multiple currencies from Stripe?

Only if your QuickBooks company supports multi-currency. The currency codes must match exactly between Stripe payouts and your QuickBooks currency settings, or deposits will fail.

What happens if QuickBooks is offline when a payout triggers?

Make will retry the failed operation up to 3 times over 2 minutes, then stop. You'll see the failed run in your execution history and can manually rerun it once QuickBooks is accessible.

How do I handle Stripe fees in the deposit?

This workflow creates deposits for net payout amounts only. For gross revenue tracking, you'd need a separate scenario watching Stripe charges and creating detailed journal entries with fee accounts.

Will this create duplicate deposits if I rerun the scenario?

Yes, unless you add duplicate checking. Consider adding a QuickBooks search step before creating deposits to check if a deposit with that Stripe payout ID already exists.

Beginner~12 min setupFinance & FinanceVerified April 2026

How to Create QuickBooks Bank Deposits from Stripe Payouts with Make

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

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

Make

Also on:Zapier N8n Power-automate Pipedream

Best for

Businesses processing 20+ Stripe payouts monthly who want automatic QuickBooks reconciliation.

Not ideal for

Companies with complex multi-entity accounting or those processing fewer than 5 payouts monthly.

Sync type

polling

Use case type

sync

Real-World Example

💡

A 25-person SaaS company processes 80-100 Stripe payouts monthly from subscription billing. Before automation, their bookkeeper spent 45 minutes each week manually creating bank deposits in QuickBooks and matching them to bank statement lines. Now deposits appear automatically with Stripe payout IDs as references, cutting reconciliation time to under 10 minutes weekly.

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

Skip the setup

Import this workflow directly into Make

Copy the pre-built Make blueprint and paste it straight into Make. All modules, filters, and field mappings are already configured — you just need to connect your accounts.

Before You Start

Make sure you have everything ready.

Active Stripe account with API key access and recent payout history

QuickBooks Online subscription with API permissions enabled

Bank account properly connected to both Stripe and QuickBooks

Chart of accounts set up in QuickBooks with appropriate income/clearing accounts

Make account with sufficient operations for your payout frequency

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Deposit Amount	`amount`	Stripe payout amount in cents, must be divided by 100 for QuickBooks dollar amount
Deposit Date	`arrival_date`	Date when Stripe payout arrives at your bank account, formatted as YYYY-MM-DD
Payout Reference	`id`	Stripe's unique payout identifier, used in deposit description for tracking
Bank Account	`DepositToAccountRef`	QuickBooks bank account that receives the deposit, must be type 'Bank'
Source Account	`AccountRef`	Chart of accounts entry for deposit line item, typically income or clearing account
Currency Code	`currency`	Three-letter currency code from Stripe payout, must match QuickBooks company currency

Step-by-Step Setup

Scenarios > Create new scenario > Add module

Create New Scenario in Make

Set up the foundation for your payout reconciliation workflow. This creates the container where you'll build the automation modules.

1Log into Make and click the blue 'Create a new scenario' button
2Click the large gray '+' circle in the center of the canvas
3Type 'Stripe' in the search box and select it from the app list

✓ What you should see: You should see a blank scenario canvas with the Stripe module selector open.

Stripe > Triggers > Watch Payouts

Configure Stripe Payout Trigger

Set up the trigger that fires when Stripe sends money to your bank. This monitors your Stripe account for completed payouts.

1Select 'Watch Payouts' from the Stripe triggers list
2Click 'Add' next to Connection and enter your Stripe API key
3Set Status filter to 'paid' to only trigger on completed payouts
4Leave Limit field at 10 for initial testing

✓ What you should see: The Stripe module shows a green connection badge and displays your account name.

⚠

Common mistake — Don't use 'pending' status — that fires before money actually moves to your bank.

Make

click +

search apps

QuickBooks

Configure Stripe Payout Trig…

QuickBooks

module added

Run once > View module output

Test Stripe Connection

Verify Make can read your payout data correctly. This shows you the actual field structure you'll map to QuickBooks.

1Click the 'Run once' button in the bottom left
2Wait for the webhook to show data (may take 30 seconds)
3Click on the Stripe module to view the payout data structure
4Note the 'amount', 'arrival_date', and 'id' fields

✓ What you should see: You should see payout data with fields like amount (in cents), currency, and arrival_date displayed.

⚠

Common mistake — Stripe amounts come in cents — you'll need to divide by 100 for QuickBooks dollar amounts.

Make

▶ Run once

executed

✓

QuickBooks

✓

Stripe

🔔 notification

received

Add module > QuickBooks Online > Create a Deposit

Add QuickBooks Module

Connect to QuickBooks to create the bank deposit records. This establishes the connection to your accounting system.

1Click the '+' button to the right of the Stripe module
2Search for 'QuickBooks Online' and select it
3Choose 'Create a Deposit' from the actions list
4Click 'Add' next to Connection and authorize your QuickBooks account

✓ What you should see: QuickBooks module appears connected with your company name showing in the connection field.

QuickBooks module > Deposit to Account

Map Bank Account Field

Tell QuickBooks which bank account receives the deposit. This ensures the deposit lands in your connected bank account ledger.

1Click the 'Deposit to Account' dropdown in the QuickBooks module
2Select your bank account that receives Stripe payouts
3Verify the account type shows as 'Bank' not 'Other Current Asset'

✓ What you should see: The deposit account field shows your bank account name with account type 'Bank' in parentheses.

⚠

Common mistake — Pick the actual bank account, not an undeposited funds or clearing account.

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

QuickBooks module > Total Amount

Configure Deposit Amount

Map the Stripe payout amount to QuickBooks deposit amount. This requires converting from cents to dollars.

1Click in the 'Total Amount' field in QuickBooks module
2Click the Stripe data tab and find 'amount'
3Wrap the amount field with division: {{1.amount / 100}}
4Set Currency to match your Stripe payout currency

✓ What you should see: The Total Amount field shows the Stripe amount formula with division by 100.

⚠

Common mistake — Forgetting to divide by 100 creates deposits 100x larger than actual payouts.

QuickBooks module > Deposit Date

Set Deposit Date

Use Stripe's arrival date as the deposit date in QuickBooks. This matches when money actually hits your bank.

1Click in the 'Deposit Date' field
2Select 'arrival_date' from the Stripe data
3Verify the date format shows as YYYY-MM-DD

✓ What you should see: Deposit Date field shows the Stripe arrival_date mapped with proper date formatting.

QuickBooks module > Line Items > Add item

Add Deposit Line Items

Create the actual deposit line that shows the source of funds. This appears in the deposit detail within QuickBooks.

1Scroll to 'Line Items' section and click 'Add item'
2Set Account to your Stripe clearing account or income account
3Map Amount to {{1.amount / 100}} (same as total)
4Set Description to 'Stripe Payout {{1.id}}'

✓ What you should see: Line items section shows one item with account, amount, and description properly mapped.

⚠

Common mistake — The line item amount must equal the total deposit amount or QuickBooks will reject it.

Right-click module > Add error handler

Configure Error Handling

Set up what happens when QuickBooks rejects a deposit. This prevents the scenario from breaking on duplicate or invalid data.

1Right-click on the QuickBooks module
2Select 'Add error handler' from the context menu
3Choose 'Ignore' for the error directive
4Check 'Resume subsequent execution' box

✓ What you should see: A small error handler route appears below the QuickBooks module with 'Ignore' directive.

Run once > Monitor execution

Test Complete Workflow

Run the full scenario to verify deposits create correctly in QuickBooks. This validates your field mapping and catches any issues.

1Click 'Run once' with recent payout data
2Watch both modules execute successfully (green checkmarks)
3Log into QuickBooks and verify the bank deposit was created
4Check that amounts and dates match your Stripe payout

✓ What you should see: Both modules show green success indicators and a new deposit appears in your QuickBooks bank account register.

⚠

Common mistake — If testing with old payout data, you might create duplicate deposits — check QuickBooks first.

Schedule > Every 15 minutes > Turn ON

Schedule Scenario

Set the scenario to run automatically and check for new payouts. This makes the reconciliation truly hands-off.

1Click the clock icon at the bottom of the scenario
2Select 'Every 15 minutes' from the schedule options
3Toggle the scenario 'ON' using the switch in bottom left
4Click 'Save' to preserve all settings

✓ What you should see: Scenario shows 'ON' status with a 15-minute schedule indicator in the bottom panel.

⚠

Common mistake — Don't set it faster than 15 minutes — Stripe payouts don't happen that frequently.

Drop this into a Make custom function.

JavaScript — Custom Function{{formatDate(parseDate(1.arrival_date; "YYYY-MM-DD"); "MM/DD/YYYY")}}

▸ Show code

{{formatDate(parseDate(1.arrival_date; "YYYY-MM-DD"); "MM/DD/YYYY")}}

... expand to see full code

{{formatDate(parseDate(1.arrival_date; "YYYY-MM-DD"); "MM/DD/YYYY")}}

Scaling Beyond 100+ payouts/month+ Records

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

Add Rate Limit Protection

QuickBooks limits API calls to 500/hour per app. Add a 10-second delay module between high-volume runs to avoid hitting rate limits during batch processing.

Implement Duplicate Checking

Before creating each deposit, search QuickBooks for existing deposits with the same Stripe payout ID in the memo field. This prevents double-entry during reruns or data recovery.

Going live

Production Checklist

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

Set Stripe trigger status filter to 'paid' only, not 'all' or 'pending'

Applies when: Always

Add error handler to QuickBooks module with 'Ignore' directive for duplicate deposits

Applies when: Always

Test with actual payout data, not Make's sample data which lacks proper amount formatting

Applies when: Always

Verify chart of accounts mapping points to correct income/clearing account

Applies when: Always

Set scenario schedule to 15+ minutes, not faster intervals that waste operations

Applies when: Always

Add date filter to only process payouts from last 48 hours to prevent duplicates

Applies when: High volume

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy Make for this workflow

Use Make for this if you process 20+ Stripe payouts monthly and want deposits automatically matched in QuickBooks. Make's visual builder makes the cent-to-dollar conversion obvious, and the 15-minute polling catches payouts fast enough for daily reconciliation. Skip Make if you only get 1-2 payouts monthly — just create those deposits manually in QuickBooks.

Cost

This workflow uses 2 operations per payout (Stripe trigger + QuickBooks create). At 50 payouts monthly, that's 100 operations total. Make's Core plan at $9/month includes 10K operations, so you're well covered. Zapier's Starter plan costs $20/month for the same volume, making Make 55% cheaper. N8N self-hosted is free but requires server management.

Tradeoffs

Zapier handles QuickBooks duplicate detection better — it checks existing deposits before creating new ones. N8N offers better error logging with detailed QuickBooks API responses when deposits fail. But Make's visual data mapping makes the Stripe-to-QuickBooks field conversion much clearer, especially for non-technical users setting up the cent-to-dollar math.

Stripe's API paginates payout history at 100 records, so if you're catching up on months of old payouts, you'll need Make's iterator module to process them in batches. QuickBooks also has a 500-request-per-hour rate limit per app, so high-volume scenarios need built-in delays. The arrival_date field from Stripe sometimes differs from when your bank actually receives funds by 1 business day due to bank processing delays.

Ideas for what to build next

→
Add Slack Notifications for Large Payouts — Create a filter that sends Slack alerts when payouts exceed a threshold amount, giving you immediate visibility into significant cash flow events.
→
Track Stripe Fees Separately — Build a parallel workflow that captures Stripe fees from balance transactions and creates expense entries in QuickBooks for complete P&L accuracy.
→
Generate Monthly Reconciliation Reports — Set up a scheduled scenario that compares total monthly Stripe payouts against QuickBooks deposits and emails discrepancy reports to your accounting team.