How to Reconcile Stripe, PayPal & Shopify Payments Payouts

A payout is cash movement, not a complete sales report. Stripe, PayPal, and Shopify Payments may each deposit a net amount after processing fees, refunds, disputes, reserves, currency conversion, or other adjustments. If you book the bank deposit as revenue, the books can understate sales, hide fees, and make refunds difficult to trace. A better workflow starts with the processor's activity and proves that it ties to the payout and then to the bank.

The exact accounts and timing depend on your accounting method, systems, and tax reporting requirements. This article gives a general bookkeeping framework, not personalized accounting or tax advice.

Use a clearing account for each processor

Create a separate clearing or funds-in-transit account for Stripe, PayPal, Shopify Payments, and any other processor that settles into the bank. The clearing account is a temporary bridge: sales and refunds are recorded when the processor activity occurs, while the transfer to the bank moves the net amount from the processor clearing account to checking. Keeping processors separate makes it possible to find the source of a difference instead of treating every mismatch as a bank-feed problem.

For example, a $100 customer charge can be recorded as $100 of gross sales and a separate processing-fee expense of $3.20, leaving $96.80 to move through the processor clearing account. The bank deposit is then a transfer of $96.80, not $96.80 of revenue. Sales tax collected, if applicable, should remain separately identifiable as a liability rather than being included in income.

Match the right reports to the right period

Choose a cutoff rule and use it consistently. A daily sales report may include orders that have not yet settled. A payout report may cover activity from several prior days. A month-end bank statement may show a transfer initiated in the prior month. Reconciliation means respecting those timing differences, not forcing every report to match on the same date.

For each payout, record the processor name, payout ID, covered period, gross charges, refunds, disputes, fees, reserves or releases, adjustments, currency, and net payout. Then match the net payout to the bank deposit. Keep the payout report and, where useful, the transaction-level export attached to the reconciliation. A payout ID is usually more reliable than a deposit description for tracing the connection.

Stripe: separate charges, refunds, and fees

Stripe reports can contain payments, refunds, disputes, application or platform fees, processing fees, and transfers or payouts. Start by identifying which report is the source for your sales total and which report is the source for the payout. Do not add a charge export and a payout export together; the payout is the settlement of activity already represented in the charge and adjustment detail.

Suppose Stripe activity for a period shows $12,000 in charges, $700 in refunds, $360 in processing fees, and $10,940 paid out. The simplified bridge is $12,000 minus $700 minus $360 equals $10,940. In a real account, disputes, reserves, tax, or timing items may create more lines, but the principle is the same: the net payout should be explainable from gross activity and each adjustment. If Stripe has multiple currencies, reconcile each currency separately before recording conversion or settlement differences.

PayPal: investigate balances and transfers

PayPal can function as both a wallet balance and a payout source. A sale may sit in PayPal before it is transferred to the bank, and a transfer may be grouped differently from the underlying sales. PayPal fees, refunds, chargebacks, holds, and currency conversion can also affect the available balance. Reconcile the PayPal account itself, not only the checking-account deposits.

A useful sequence is to begin with the opening PayPal balance, add gross receipts, subtract refunds and fees, account for holds or releases, and arrive at the closing PayPal balance. Separately match transfers from PayPal to the bank. If a PayPal transfer is still pending at month-end, it belongs in the processor balance or funds-in-transit workflow rather than being forced into the bank balance.

Shopify Payments: do not confuse orders with settlements

Shopify order reports and Shopify Payments payout reports answer different questions. Orders describe what customers bought and can include discounts, returns, shipping, and tax. Payouts show what Shopify Payments settled after fees, refunds, adjustments, and timing. Marketplace sales or other payment methods may be reported in Shopify but settle outside Shopify Payments, so identify the payment method before mapping anything.

For channel reporting, keep a bridge from Shopify gross sales to payment-method totals, then reconcile Shopify Payments payouts to the dedicated clearing account. If a customer pays through PayPal inside the Shopify checkout, that amount should not also be counted as a Shopify Payments payout. The order platform and the processor are related systems, not interchangeable ledgers.

A practical month-end reconciliation checklist

1. Save the period's processor balance, transaction, fee, refund, dispute, and payout reports.
2. Confirm the opening clearing-account balance agrees to the prior reconciliation.
3. Record gross charges, refunds, sales tax activity, processor fees, disputes, reserves, and other adjustments in separate lines or accounts.
4. Match each payout to the processor report and the bank deposit, allowing for settlement timing.
5. Investigate unmatched deposits, duplicate imports, negative balances, and stale funds-in-transit items.
6. Document the closing balance and list any items that require follow-up next month.

Do not delete a difference just to make the reconciliation balance. A small unexplained amount may be a fee, currency conversion effect, duplicate import, or a report cutoff issue. The reconciliation note is part of the accounting record and helps the next reviewer pick up where you left off.

Example of the problem with net revenue

If ten $100 orders produce a $965 deposit after $35 of fees, recording $965 as sales makes revenue look $35 lower and leaves no visible processor-fee expense. The business may still have the right cash balance, but gross sales, expenses, margins, and channel comparisons are distorted. Recording the $1,000 gross sales and $35 fee, then clearing the $965 payout, tells the more useful story.

Linked-do-Books helps Shopify and multi-channel sellers organize processor reports, clearing accounts, bank deposits, fees, refunds, and month-end exceptions. For the connected sales-tax recordkeeping question, read our guide to multi-channel sales-tax nexus records. For inventory and gross-margin consistency, see inventory costing methods for e-commerce sellers.