How to Reconcile Shopify, Stripe, and PayPal Payouts in Your Books

If you sell online, your bank deposit is not the whole story. A single payout from Shopify, Stripe, or PayPal might include multiple orders, refunds, processing fees, chargebacks, currency effects, reserves, and timing differences. If you record that deposit as sales, your books may look simple, but they will not be accurate.

Reconciliation is the process of matching what your platform says happened to what actually landed in the bank. It is not glamorous, but it is one of the habits that separates clean e-commerce books from confusing ones.

Why payouts do not equal sales

Imagine your store makes $1,000 in orders. Before the money hits your bank, the platform may subtract payment fees. A customer may be refunded. Some orders may be paid through PayPal instead of Shopify Payments. A weekend payout may combine several days. The final bank deposit might be $912. That does not mean sales were $912. It means the payout was $912 after other activity.

The documents you need

• Bank statement: shows the deposits that actually landed.
• Shopify payout report: shows payout dates, included transactions, fees, refunds, and adjustments where available.
• Stripe balance or reconciliation report: shows charges, fees, refunds, disputes, and transfers to the bank.
• PayPal activity report: shows payments, fees, refunds, withdrawals, and balances.

The monthly reconciliation workflow

1. Start from the bank. List every Shopify, Stripe, and PayPal deposit that landed during the month.
2. Open the matching platform report. Find the payout ID, transfer ID, or date range that explains the deposit.
3. Break the payout into components. Separate gross sales, refunds, processing fees, chargebacks, and adjustments.
4. Record fees separately. Do not let fees disappear inside the net deposit.
5. Check timing differences. A sale on the last day of the month may be paid out next month. That is normal, but it should be understood.
6. Investigate unmatched deposits. If a bank deposit does not match a payout report, do not guess. Look for split payouts, currency conversion, reserve releases, or manual transfers.

A simple example

Your Stripe report shows $2,000 in customer charges, $100 in refunds, and $70 in fees. The transfer to your bank is $1,830. The right bookkeeping view is not simply "sales: $1,830." A cleaner view is gross sales of $2,000, refunds of $100, payment fees of $70, and a bank deposit of $1,830. That gives you the real sales number and the real cost of getting paid.

Common mistakes

• Recording net deposits as revenue. This understates sales and hides fees.
• Ignoring refunds. Refunds need to be visible so you can track product or customer issues.
• Combining processors. Shopify, Stripe, and PayPal each need their own reconciliation trail.
• Reconciling annually. E-commerce volume makes annual cleanup painful and error-prone.
• Forgetting reserves or holds. Some processors may hold funds temporarily, so payout timing can differ from sales timing.

How often should you reconcile?

For a low-volume store, monthly may be enough. If you have daily payouts, high refund volume, multiple processors, or inventory decisions tied to cash flow, weekly review may be calmer. The goal is to catch mismatches while the details are still fresh.

What to do with timing differences

Timing differences are normal. A customer may place an order on June 30, the platform may include it in a payout on July 2, and the bank may show the deposit on July 3. That does not mean anything is wrong. It means the sale date, payout date, and bank date are different.

The important thing is to track the difference intentionally. If you sell physical products, this matters even more because sales, refunds, shipping costs, and inventory movement may not all land in the same period. A clean reconciliation notes what belongs to the current month and what will clear next month.

How to handle fees

Fees deserve their own category because they are one of the quietest drains on e-commerce profit. Payment processing fees, marketplace fees, chargeback fees, and currency conversion fees can be hidden inside the net payout. If you only record the deposit, those costs vanish from your expense report and your sales number is understated.

A better habit is to record gross sales, refunds, and fees separately. That gives you a clearer margin picture and makes it easier to compare processors over time.

How to handle PayPal balances

PayPal can be especially confusing because money may sit in the PayPal balance before you withdraw it to the bank. The withdrawal is not a new sale. It is a movement of money from one account to another. The original customer payment, PayPal fee, refund, or dispute is the activity that needs to be recorded.

If you treat every PayPal withdrawal as revenue, you can double count or distort your sales. The cleaner approach is to use PayPal activity reports to explain the balance, then match withdrawals to bank deposits as transfers.

Monthly reconciliation checklist

• List every Shopify, Stripe, and PayPal deposit in the bank statement.
• Download the matching payout or activity report for each processor.
• Separate gross sales, refunds, processor fees, disputes, and adjustments.
• Mark deposits that relate to prior-month sales or next-month payouts.
• Investigate any deposit that has no matching platform report.
• Save the reports with the month-end bookkeeping file.

The bottom line

E-commerce bookkeeping gets messy when deposits are treated as sales. Reconciliation fixes that by showing what customers paid, what platforms kept, what was refunded, and what actually arrived in the bank.

Tools like Compass Finance help by turning transaction data into categories and review items, so payout deposits do not sit in your books as mystery income. You still review the details, but the first pass is far less manual.