TL;DR: Reconciling Stripe and Mercury means matching each Stripe payout to the corresponding Mercury deposit, then accounting for Stripe fees and timing differences. The 4-step process: (1) export Stripe payouts, (2) match to Mercury deposits, (3) record gross revenue and fees separately, (4) flag unmatched items. Total time: under 30 minutes per month.
Stripe does not send you one payment per transaction. It batches everything, deducts fees, and sends a net payout to your bank. Mercury records that payout as a single deposit. Reconciling them means unwrapping what Stripe bundled and making sure your books show full gross revenue — not just the net cash.
Here is exactly how to do it.
Why Stripe and Mercury seem to disagree
Stripe payouts hit your Mercury account 2–7 days after the underlying charges. Stripe also deducts processing fees — typically 2.9% + $0.30 per transaction — before the payout. And Stripe bundles multiple days of charges into one payout.
So a $1,000 Mercury deposit might represent:
- $1,031 in gross charges from 3 days ago
- Minus $31 in Stripe fees
- Net payout: $1,000
Your books should show $1,031 as revenue and $31 as a payment processing expense — not $1,000 as revenue. That $31 difference is real money and a real tax deduction.
The 4-Step Reconciliation Process
Step 1: Export your Stripe payout report
In Stripe Dashboard → Reports → Payouts, export the payout summary for the month. This shows each payout, the gross amount, fees, and net. Download as CSV.
Step 2: Match each payout to a Mercury deposit
In Mercury, export your transactions for the same period. For each Stripe payout in your export, find the matching Mercury deposit. The amounts should match exactly — Stripe sends the net amount after fees.
Step 3: Record gross revenue and Stripe fees separately
For each matched pair:
- Record the gross amount as Revenue
- Record the Stripe fees as Payment Processing Expense (or a sub-category under Cost of Revenue)
- The net is what hit Mercury — do not record that as the revenue figure
If you are using double-entry bookkeeping: debit Cash for the Mercury deposit, debit Stripe Fees for the fee amount, credit Revenue for the gross amount.
Step 4: Flag any unmatched items
Items that appear in Stripe but not Mercury (or vice versa) may be:
- Timing differences: payout initiated but not yet deposited
- Refunds: Stripe deducted a refund from the payout
- Reserve holds: Stripe is holding funds temporarily
- Failed payouts: Stripe attempted a deposit that bounced
Each needs a specific journal entry. Most accounting software handles timing differences automatically — the others need manual attention.
Common mistakes founders make
- Recording the net Mercury deposit as revenue — understates revenue, misses the fee deduction
- Ignoring Stripe fee transactions entirely — overstates net income, misses a deduction worth 2.9% of your gross revenue
- Matching by date instead of payout ID — creates false mismatches due to timing differences
How to automate this
Prosper connects to both Stripe and Mercury and maps payouts automatically. Each Stripe payout is matched to its Mercury deposit, fees are split out as a separate expense line, and unmatched items surface for your review. See how it works.
FAQ
Why do my Stripe and Mercury balances not match? Stripe holds a reserve, batches payouts over multiple days, and deducts fees before sending. A payout that hits Mercury on Tuesday includes payments from several days prior, minus Stripe fees. These timing and fee differences cause apparent mismatches that need to be accounted for in your books.
How often should I reconcile Stripe with Mercury? Monthly at minimum. Weekly is better if you have high transaction volume. Most founders reconcile when they close the books each month — typically in the first week of the following month.
What is the easiest way to reconcile Stripe and Mercury automatically? Connect both accounts to bookkeeping software that understands Stripe's payout structure. Prosper maps Stripe payouts to Mercury deposits automatically and flags exceptions — cases where fees, refunds, or timing cause a mismatch.