Skip to main content
Skip to content
Back to Accounting Guides7 min read

Ecommerce Reconciliation: Match Payouts to Bank Deposits

A practical guide to reconciling platform payouts with your bank account, handling fee deductions, timing differences, and multi-channel complexity.

8-Step ProcessMonthly ChecklistUpdated Feb 2026

What is Bank Reconciliation?

Bank reconciliation is the process of matching your internal accounting records (in QuickBooks or another system) to your bank statement. The goal is to ensure every transaction in your books has a corresponding entry on your bank statement, and vice versa.

Catch Errors Early

Reconciliation exposes duplicate entries, missing transactions, and incorrect amounts before they snowball into larger accounting problems.

Accurate Tax Reporting

Unreconciled accounts lead to incorrect revenue and expense figures on your tax return. The IRS expects your books to match your bank records.

Fraud Detection

Regular reconciliation is the frontline defense against unauthorized charges, stolen funds, or platform billing errors.

Why Ecommerce Makes Reconciliation Harder

Traditional businesses receive payment directly (cash, check, card terminal). Ecommerce sellers receive aggregated net payouts from platforms — and that creates four major reconciliation challenges.

Payout Aggregation

Platforms like Stripe, Shopify, and Amazon bundle multiple orders into a single bank deposit. A $5,247.83 deposit might represent 127 individual orders over 3 days. You cannot match individual orders to the deposit — you need the settlement report to decompose the payout.

Fee Deductions

Platforms deduct fees before depositing funds. These include processing fees (2.9% + $0.30 per transaction), marketplace commissions (8-15%), FBA fees, advertising costs, refund processing fees, and chargeback fees. Your deposit is always less than your gross sales, and the difference must be accounted for.

Timing Differences

The date an order is placed, the date the platform processes the payout, and the date the deposit appears in your bank can all be different. Stripe pays out T+2 by default, Amazon pays every 14 days, and Shopify pays every 1-5 business days depending on your plan. Month-end payouts often straddle two accounting periods.

Holds and Reserves

Amazon, Stripe, and PayPal may hold a portion of your funds as a rolling reserve (typically 5-10% for 90 days). New sellers may have 100% of funds held for 14-30 days. These reserves are not expenses — they are assets that will be released later. Failing to track them leads to phantom losses in your P&L.

Step-by-Step Reconciliation Process

Follow these eight steps every payout cycle (or at minimum, monthly) to keep your ecommerce books accurate and audit-ready.

  1. 1

    Gather All Source Documents

    Download settlement/payout reports from each platform (Stripe Dashboard > Payouts, Amazon Seller Central > Payments > Reports, Shopify Admin > Finances > Payouts). Also pull your bank statement for the same period.

  2. 2

    Match Gross Payouts to Bank Deposits

    Compare each payout amount on the platform settlement report to the corresponding bank deposit. Match by amount and date. Note: bank deposits may arrive 1-3 business days after the payout date shown on the platform.

  3. 3

    Break Down Each Payout

    For each matched payout, decompose it into: gross sales, platform fees, refunds, chargebacks, reserves held, and adjustments. The sum of these components should equal the net payout amount.

  4. 4

    Record in QuickBooks

    Create a journal entry (accrual) or record a deposit (cash basis) for each payout. Split the deposit across accounts: Sales Income (gross), Merchant Fees (expense), Refunds (contra-revenue), and Reserves (asset). PrimeConnect converter tools automate this splitting.

  5. 5

    Reconcile the Bank Account

    In QuickBooks, go to Reconcile and match the bank statement balance. Each deposit should now have a corresponding entry in QuickBooks. The ending balance should match your bank statement to the penny.

  6. 6

    Investigate Discrepancies

    If the reconciliation does not balance, check for: missing payouts, timing differences (deposits in transit), unrecorded refunds, chargeback adjustments, or reserve releases that were not booked.

  7. 7

    Document and Close

    Save a reconciliation report (QuickBooks generates one automatically). Note any unresolved discrepancies with a due date for follow-up. Mark the period as closed to prevent accidental changes to historical data.

  8. 8

    Review and Improve

    After each reconciliation, note any recurring issues. If the same discrepancy type appears monthly, create a bank rule or process improvement to catch it earlier next time.

Matching Payouts to Orders

Each ecommerce platform structures its payout reports differently. Here are platform-specific techniques for decomposing payouts back to individual orders.

Amazon

  • 1.Download the V2 Settlement Report from Seller Central > Reports > Payments > Date Range Reports.
  • 2.The "total-amount" column in the settlement summary should match your bank deposit (plus or minus rounding).
  • 3.Break down the settlement by type: product-charges, shipping-charges, fba-fee, commission, refund, promo-rebate, etc.
  • 4.Use PrimeConnect's Amazon-to-QB converter to automatically split into accounting categories.

Shopify

  • 1.Go to Settings > Payments > View payouts, or Finance > Payouts in the Shopify admin.
  • 2.Click on a specific payout to see the breakdown: charges, refunds, adjustments, and reserves.
  • 3.Export the payout details as CSV. Each row represents a line item (order, refund, fee) within that payout.
  • 4.Use PrimeConnect's Shopify-to-QB converter to transform the export into a QuickBooks-ready file.

Stripe

  • 1.Navigate to the Stripe Dashboard > Balance > Payouts. Click on any payout to see included transactions.
  • 2.Export the payout reconciliation report (Reports > Reconciliation > Payout reconciliation).
  • 3.The report shows: gross charges, fees, refunds, disputes, and the net payout. The net should match your bank deposit.
  • 4.Use PrimeConnect's Stripe-to-QB converter with automatic fee splitting.

PayPal

  • 1.Go to PayPal > Activity > Download Activity. Select the date range and CSV format.
  • 2.PayPal records each transfer to your bank as a "General Withdrawal" row. Match these to your bank deposits by amount and date.
  • 3.Note: PayPal deducts fees per transaction (not per payout), so each payment row already shows the fee deducted.
  • 4.Use PrimeConnect's PayPal-to-QB converter for locale-aware parsing and fee extraction.

Handling Discrepancies

When your QuickBooks balance does not match your bank statement, do not panic. Most discrepancies have straightforward causes. Here is a systematic approach to finding and fixing them.

Deposits in Transit

A payout was initiated by the platform but has not yet appeared in your bank account. This is common at month-end.

Resolution: Check the platform payout status. If it shows "paid" or "in transit," wait 1-3 business days and check again. Do not record it as revenue until the deposit clears.

Unrecorded Refunds

A customer refund was processed on the platform but not recorded in QuickBooks.

Resolution: Cross-reference the platform refund report with your QuickBooks refund entries. Record any missing refunds as contra-revenue (reducing Sales Income, not as an expense).

Fee Discrepancies

Platform fees changed mid-period (new pricing tier, promotional credits, or fee adjustments).

Resolution: Compare the total fees in the settlement report to the fees recorded in QuickBooks. Adjust the Merchant Fees expense account to match.

Chargeback Adjustments

A chargeback was debited from your account, reducing the payout amount.

Resolution: Record chargebacks as a debit to a Chargebacks expense account. If the chargeback is later reversed, record the reversal as income when funds are returned.

Reserve Changes

The platform increased or decreased the rolling reserve, affecting the payout amount.

Resolution: Record reserve changes as transfers to/from a "Platform Reserve" asset account — never as revenue or expense.

Currency Conversion Differences

Exchange rate on the transaction date differs from the rate on the payout date.

Resolution: Record the difference as a Realized FX Gain/Loss in the Other Income/Expense section of your chart of accounts.

Monthly Close Checklist

Use this checklist every month to ensure a clean close. Complete each item in order before marking the period as closed in QuickBooks.

  1. 1Download all platform settlement/payout reports for the month
  2. 2Download bank statements for all business accounts
  3. 3Match every payout to a bank deposit (resolve any unmatched items)
  4. 4Verify that total platform fees recorded match fee reports
  5. 5Record all refunds and chargebacks as contra-revenue entries
  6. 6Book any reserve holds or releases to the Funds Held account
  7. 7Reconcile each bank account in QuickBooks to the statement balance
  8. 8Review the Profit & Loss report for unusual expenses or missing revenue
  9. 9Run a Balance Sheet report and verify asset/liability balances
  10. 10Save reconciliation reports and mark the period as closed
  11. 11File or note any sales tax collected during the month
  12. 12Back up your QuickBooks file (Desktop) or export a data backup (Online)

Pro tip: In QuickBooks Online, go to Settings > Advanced > Accounting and set a "Close the books" date to prevent accidental edits to prior periods after reconciliation.

Automation Tips

Manual reconciliation is time-consuming. Here are strategies to automate the most repetitive parts using PrimeConnect tools and QuickBooks features.

Use PrimeConnect Converters

Instead of manually splitting payouts into gross sales, fees, and refunds, use PrimeConnect's platform converters. They automatically:

  • - Split each transaction into debit/credit components
  • - Separate platform fees into a dedicated expense category
  • - Map refunds to contra-revenue accounts
  • - Output QuickBooks-ready CSV, IIF, or QBO files

Set Up Bank Rules

In QuickBooks Online, create bank rules to auto-categorize recurring transactions:

  • - "STRIPE TRANSFER" deposits → Stripe Sales Income
  • - "SHOPIFY INC" deposits → Shopify Sales Income
  • - "AMAZON.COM" deposits → Amazon Sales Income
  • - Set up split rules for deposits with known fee structures

Pre-Scan for Duplicates

Before importing any converted file, run it through PrimeConnect's Duplicate Detector. This catches internal duplicates within the file and prevents double-entry in QuickBooks. It takes 5 seconds and can save hours of reconciliation work.

Multi-Channel Merge

If you sell on multiple platforms, use PrimeConnect's Multi-Channel Merge Tool to combine all platform exports into a single QuickBooks-ready file. This eliminates the need to import multiple files separately and reduces the risk of missing a platform during reconciliation.

Frequently Asked Questions

How often should I reconcile my ecommerce accounts?
Weekly reconciliation is the gold standard for ecommerce sellers processing more than 50 orders per week. For lower-volume sellers, biweekly reconciliation works. Monthly reconciliation is the absolute minimum — but the longer you wait, the harder it becomes to track down discrepancies. Each payout period should ideally be reconciled within one week of the deposit hitting your bank.
Why does my bank deposit not match my total sales?
Ecommerce platform payouts are net of fees, refunds, chargebacks, and reserves. For example, if you sold $10,000 on Shopify, the payout might be $9,400 after deducting Shopify Payments processing fees ($290), transaction fees ($10), and refunds ($300). Additionally, payouts aggregate multiple days of orders into a single deposit, making direct order-to-deposit matching impossible without a settlement report.
What is a reserve hold and how does it affect reconciliation?
Platforms like Amazon, Stripe, and PayPal may hold a percentage of your funds as a reserve — especially for new sellers, high-risk categories, or after chargeback spikes. Reserves are not deducted from sales; they are temporarily held and released later. In your books, reserves should be tracked as a separate "Funds Held" asset account, not as an expense. When the reserve is released, it appears as a separate deposit.
How do I handle multi-currency transactions during reconciliation?
Convert foreign currency transactions to your home currency using the exchange rate on the transaction date (not the payout date). Most platforms include the converted amount in settlement reports. Record any FX gains/losses as a separate line item in your books. QuickBooks Online Plus and above support multi-currency tracking natively.
What is the difference between accrual and cash basis reconciliation?
In accrual basis, you record revenue when the order is placed (regardless of when you receive the money). In cash basis, you record revenue when the payout hits your bank account. Most ecommerce sellers use accrual basis because it matches revenue to the period when the sale occurred. Your reconciliation process stays the same either way — the difference is in the timing of revenue recognition.
How do I reconcile Amazon settlements specifically?
Amazon pays out every 14 days via settlement reports. Each settlement includes orders, refunds, FBA fees, advertising charges, and reimbursements. Download the V2 Settlement report from Seller Central > Reports > Payments. The net payout amount should match your bank deposit. Use PrimeConnect's Amazon-to-QB converter to split each line item into proper accounting categories automatically.

Start Reconciling Faster

Scan your transaction files for duplicates before importing into QuickBooks. PrimeConnect's Duplicate Detector catches overlapping entries in seconds — saving you hours of manual reconciliation work.

Try the Duplicate Detector
Or browse all free accounting tools