E-Commerce Reconciliation: Why Your Stripe and PayPal Numbers Never Match Your Bank

You sold $10,000 on Shopify last month. But your bank only shows $9,247 in deposits. Where did the other $753 go?

If you sell online using Stripe, PayPal, Shopify Payments, or Amazon, your bank deposits will never match your gross sales. This is normal, but if your bookkeeping does not account for the difference, your financial statements are wrong — and you might be overpaying on taxes.

Here is why the numbers never match, and how to reconcile them properly.

Why the Numbers Do Not Match

Payment processors do not deposit your gross sales into your bank. They deduct processing fees, refunds, chargebacks, and reserves before sending you a net payout. Here is what typically gets deducted.

Processing Fees

Stripe charges 2.9% + $0.30 per transaction. PayPal charges 2.99% + $0.49. Shopify Payments varies by plan. On $10,000 in sales, you could easily lose $300 to $400 in processing fees alone. These need to be recorded as a separate expense in your books, not buried in your revenue number.

Refunds and Returns

When you refund a customer, the payment processor deducts that amount from your next payout. But if your books recorded the original sale as revenue, you need a corresponding refund entry. Without it, your revenue is overstated.

Chargebacks

A chargeback happens when a customer disputes a charge with their bank. The payment processor pulls the money back from your account, often with an additional chargeback fee ($15 to $25 per dispute). These need to be tracked separately because they affect your revenue, your expenses, and potentially your processing rates.

Payout Timing

Stripe typically holds funds for 2 business days. PayPal can hold funds longer for new accounts. Shopify batches payouts on a schedule. This means sales made on January 30th might not hit your bank until February 3rd. If you are doing accrual-basis accounting, the revenue belongs in January even though the cash arrives in February.

The Right Way to Reconcile

There are two approaches to e-commerce reconciliation, and the right one depends on your volume.

For Lower Volume (Under 200 Transactions per Month)

You can reconcile manually by downloading your payout reports from each payment processor and matching each payout to the corresponding bank deposit. For each payout, you verify that gross sales minus fees minus refunds minus chargebacks equals the net deposit in your bank. This is time-consuming but straightforward.

For Higher Volume (200+ Transactions per Month)

Manual reconciliation becomes impractical at scale. This is where tools like A2X come in. A2X connects to your Shopify, Amazon, or other e-commerce platform and automatically creates summary journal entries in QuickBooks or Xero that break down each payout into gross sales, fees, refunds, and net deposit. This saves hours of work and dramatically reduces errors.

Common Mistakes We See

After reconciling thousands of e-commerce transactions, here are the mistakes we see most often.

Recording bank deposits as revenue instead of matching them to specific payouts. This understates your gross revenue and misclassifies your processing fees. Recording refunds as expenses instead of contra-revenue. A refund is not an expense — it is a reduction of revenue, and it affects your gross margin calculation differently. Ignoring chargebacks entirely. Chargebacks affect your revenue AND create an additional fee expense. Double-counting by recording both the Shopify sale and the bank deposit as separate revenue entries.

What Clean E-Commerce Books Look Like

When your e-commerce reconciliation is done right, your books should show gross revenue that matches your e-commerce platform reports, processing fees broken out as a separate expense line, refunds recorded as contra-revenue reducing your gross sales, chargebacks tracked with associated fees, and bank deposits that reconcile perfectly to your payment processor payouts.

This is not just about having accurate numbers. It means you know your true gross margin, you are not overpaying on taxes, and you can hand your books to any CPA and they can file immediately without questions.

If your e-commerce books are behind or your numbers do not match, do not wait. The longer you let it go, the harder the reconciliation becomes.