E-commerce bookkeeping

    Why don’t my Shopify payouts match my sales? How to reconcile Shopify payouts

    Your Shopify sales report and your bank deposits will almost never show the same number. That is normal. Here is what sits between the two, which Shopify reports show it, and how to book it so your books, 1099-K and sales tax returns tie out.

    Free initial consultation · No obligation

    • Last reviewed October 18, 2026
    • Sources linked below

    Why don’t my Shopify payouts match my sales?

    Because a Shopify Payments payout is net: processing fees, refunds, chargebacks, reserve holds and some Shopify Capital repayments come out first, and gift card or third-party payments never enter it. Record gross sales and each deduction through a clearing account. Your Virtual CPA, a licensed CPA firm, reconciles Shopify payouts to the bank every month. Request a free consultation.

    What sits between your sales and your payout

    Shopify Payments collects the customer’s money, takes out what it is owed and pays you the rest on a schedule. Each of these makes a deposit smaller or larger than the sales for the same days:

    • Processing fees. Shopify deducts its payment fees from each charge before payout.
    • Refunds. Refunds you issue come out of your Shopify Payments balance.
    • Chargebacks. Shopify says the disputed amount is deducted from your next available payout. A dispute fee may apply. If you win, the amount comes back.
    • Reserves. A reserve holds a fixed amount or a percentage of each transaction for a set period. Shopify shows a negative reserve transaction when funds are held and a positive one when they are released.
    • Shopify Capital. For US loans accepted on or after March 9, 2026, Shopify says repayments are collected directly from your Shopify Payments balance and show under Adjustments. Older loans are debited from your bank account.
    • Currency. Orders in a currency without its own payout account are converted to your default currency, and Shopify says a currency conversion fee applies.
    • Gift cards and other gateways. A gift card sale is a liability, not a sale, per Shopify. Redemptions count as sales but bring in no new cash. PayPal and other third-party payments settle outside Shopify Payments.
    • Timing. One payout can include several days of activity, so a calendar month of sales rarely equals a calendar month of deposits.

    The Shopify reports to use, by name

    • Shopify Payments activity report. In the admin under Finance > Documents. It groups balance activity into Charges, Refunds, Disputes, Reserves & Holds, Adjustments and Duties & Taxes for a date range and currency. Shopify notes it is not accounting revenue and has a 3-day data delay.
    • Export payout transactions. On the Payouts page, open one payout and export its transactions. Use this to tie one bank deposit. Columns include Type, Order, Amount, Fee and Net. See viewing and exporting payout details.
    • Export balance transactions. All Shopify Payments transactions for a date range, with the same columns.
    • Finance reports. Finance Summary, Total sales breakdown and the Taxes or United States sales tax report give order-based sales and tax. Net sales from gift cards and Outstanding gift card balance support the gift card liability. See Shopify’s finance reports.

    A note on names: Shopify’s help center does not list a report called “Payout Reconciliation Report.” Apps and bookkeepers use that phrase. Inside Shopify, the tools are the activity report and the payout exports above.

    The clearing account method

    A clearing account is a balance sheet account named something like “Shopify Payments clearing.” Everything Shopify owes you flows through it. When it returns to zero after each payout, your books tie.

    1. Record sales gross. Debit clearing. Credit sales for the product and shipping revenue. Credit sales tax payable for tax collected.
    2. Record deductions. Credit clearing for processing fees (fee expense), refunds (refunds or returns account), chargebacks (chargeback account) and dispute fees (expense).
    3. Record reserves. Move held funds from clearing to a “Shopify reserve” receivable. Move them back when released.
    4. Record Capital repayments. Debit the Shopify Capital loan liability and credit clearing for the amount withheld.
    5. Record the payout. Debit bank and credit clearing for the deposit. Whatever is left in clearing is either still in transit or an error to find.

    Gift card sales go to a gift card liability, not sales. Redemptions move from the liability to sales. Under IRS rules, gross receipts are reported before fees and refunds, which are deducted separately. See IRS Publication 334.

    Illustrative example: one weekly payout

    Illustrative example. The numbers are made up to show the mechanics.

    • Charges for the week: $10,600 ($10,000 of products and shipping plus $600 sales tax).
    • Processing fees: $320. Refunds: $400. One chargeback: $150 plus a $15 dispute fee.
    • New reserve hold: $500. Shopify Capital repayment: $200.

    Payout to the bank: $10,600 − $320 − $400 − $150 − $15 − $500 − $200 = $9,015.

    Booked from deposits only, this week shows $9,015 of “sales.” Booked correctly, it shows $10,000 of sales, $600 of sales tax owed to the states, $400 of refunds, $150 of chargebacks, $335 of fees, a $500 receivable and $200 less loan. That is the gap a 1099-K or sales tax notice will expose.

    How it works with us

    Best for: Shopify brands whose books were built from bank deposits, or whose clearing account never gets to zero.

    1. Free initial consultation. Tell us your channels, payment providers and where the books stand.
    2. Fees quoted upfront, in writing. Transparent, fair fees in an engagement letter before work starts.
    3. Access. Add us to Shopify reports, your accounting software and bank feeds.
    4. Cleanup. We rebuild past months from payout exports and order reports. See catch-up bookkeeping.
    5. Monthly close. Every payout tied to the bank, plus sales tax, inventory and cost of goods sold. See Shopify bookkeeping.

    Payout differences: where they show in Shopify and how to book them

    DifferenceWhere it shows in ShopifyHow it’s booked
    Gross sales and shippingFinance Summary; Charges in the activity reportCredit sales; debit Shopify clearing
    Sales tax collectedTaxes or United States sales tax reportCredit sales tax payable (a liability, not revenue)
    DiscountsTotal sales breakdown; Discounts by orderReduce sales (or a discounts contra-revenue account)
    Processing feesFee column in payout exportsDebit payment processing fees (selling expense); credit clearing
    RefundsRefunds group; Type “refund” in exportsDebit refunds/returns (contra-revenue); credit clearing
    Chargebacks and dispute feesDisputes group in the activity reportDebit chargebacks (contra-revenue) and dispute fee expense; reverse if you win
    Reserve hold and releaseReserves & Holds group; negative and positive reserve transactionsMove between clearing and a Shopify reserve receivable; not an expense
    Shopify Capital repaymentAdjustments in payout details (US loans accepted on or after March 9, 2026)Debit loan liability; credit clearing. Fees per your loan agreement
    Currency conversionPayouts in multiple currencies; conversion feeRecord sales at the transaction rate; book conversion fees and differences separately
    Gift cardsNet sales from gift cards; Outstanding gift card balanceSale of card: credit gift card liability. Redemption: move liability to sales
    Payout depositPayouts page (Scheduled, Deposited, Failed)Debit bank; credit clearing. Clearing should return to zero

    Expert CPAs. Personal attention.

    Payouts that never tie to the bank? Bring your Shopify payout exports to a free initial consultation and we'll show you where the gap is.

    Frequently asked questions

    A payout is a net number. Shopify Payments takes out processing fees, refunds, chargebacks, reserve holds and, for newer Shopify Capital loans, loan repayments before it pays you. Payouts also run on a schedule, so one deposit can include sales from several days. Sales paid with gift cards or other payment providers never pass through Shopify Payments at all.

    Use the Shopify Payments activity report (Finance > Documents) for a period, and Export payout transactions on the Payouts page for a single bank deposit. Shopify says the activity report shows balance activity, not accounting revenue. For sales, use the Finance reports such as Finance Summary, which are based on orders.

    No. Recording only the net deposit understates both your sales and your expenses, and your 1099-K and sales tax returns will not tie to your books. Record gross sales, sales tax collected, fees, refunds and chargebacks separately, then match the net payout to the bank deposit through a clearing account.

    Often because of a reserve. Shopify can hold a fixed amount or a percentage of each transaction for a set period to cover future refunds and disputes. Reserved funds are still your money. Book them as a receivable, not an expense, and record the release when the funds come back in a later payout.

    Shopify says the disputed amount is deducted from your next available payout. Record it as a reduction of sales (or a chargeback account) and record any dispute fee as an expense. If you win the dispute, record the returned amount when it comes back. Keep the evidence with the order.

    Usually not. Payment processing fees and Shopify subscription and app fees are generally recorded as selling or operating expenses. Cost of goods sold covers the cost of the products you sold, such as purchase price, inbound freight and duties. Pick one treatment and use it every month so your margins compare.

    Shopify says a gift card sale is a liability, not a sale. The cash comes in when the card is sold. When a customer later redeems it, Shopify counts the item as a sale, but no new money reaches your payout. Book the redemption against the gift card liability, not the bank.

    Yes. We rebuild each month from Shopify order and payout reports, split out fees, refunds, chargebacks, reserves and sales tax, and tie every payout to the bank. Fees for cleanup are quoted upfront, in writing, after we see how many months need work.