How to record Shopify fees in QuickBooks Online

The simple answer

To record Shopify fees in QuickBooks Online, keep the customer's full sale as income and record the Shopify Payments fee in a payment-processing expense account. The fee reduces the amount Shopify owes you; it does not reduce the original selling price.

For example, if a customer pays $100 and Shopify keeps a $3 processing fee, record $100 of sales and $3 of fees. Shopify owes you $97 before any refunds, tax, reserves, or other adjustments. When the $97 reaches your bank, match it to the payout record instead of adding another $97 of sales.

The important detail is that not every charge from Shopify belongs in the payout. Processing fees can be withheld from Shopify Payments payouts, while subscription plans, apps, shipping labels, and some transaction fees appear on Shopify bills. Record each cost from the source where it was actually charged.

First, identify which Shopify fee you are looking at

Merchants often use “Shopify fees” to describe every amount Shopify charges. That is understandable, but the costs do not all come from the same report or reach QuickBooks in the same way.

Before entering anything, find the charge in Shopify and decide whether it reduced a payout or was charged through Shopify billing.

This guide focuses mainly on Shopify Payments processing fees—the amounts taken from customer payments before Shopify sends a payout. Later sections explain how to keep Shopify bill charges separate.

Shopify states that its payout reconciliation report covers Shopify Payments balance activity, including fees and payouts, but does not include Shopify billing fees or third-party processors. That is why one Shopify report cannot be used as a complete list of every cost.

Where to find the exact Shopify Payments fees

For one completed payout, open Shopify admin and go to Settings → Payments. In the Shopify Payments section, open the payouts area and select the payout you want to record. The payout details show the transactions included, the fees applied, and the net amount sent to the bank.

If you need transaction-level detail, open the Shopify Payments transactions list and export the balance transactions for the relevant date range. The export includes Amount, Fee, and Net columns. Use the fee values in that export rather than multiplying sales by an advertised rate.

For a period-level check, Shopify's payout reconciliation report is available from Finance → Documents. It shows account activity before fees, total fees, net activity, payouts, and the ending Shopify Payments balance for a selected date range and payout currency.

• Use a completed payout, not a payout that is still changing.
• Confirm the payout currency and destination bank account.
• Keep the Shopify payout ID with the QuickBooks record.
• Use the fee shown for the payout or its transactions.
• Check whether refunds, disputes, reserves, or adjustments are also included.

The payout date and the bank date may differ, so do not reject a correct match only because the dates are a few days apart. Compare the payout ID, currency, destination, and exact amount.

Create a sensible fee account in QuickBooks

In QuickBooks Online, use a dedicated expense account for payment-processing fees. A plain name such as Payment processing fees, Merchant fees, or Shopify Payments fees is easier to understand than a general account called Bank charges or Miscellaneous.

A separate account lets you see what it costs to collect online payments and compare that cost over time. If you use several processors, you can keep one payment-processing expense account and use classes or locations for detail, or create separate fee accounts for Shopify Payments, PayPal, and other providers. Choose the level of detail you will actually review.

Do not automatically place payment-processing fees in cost of goods sold. Cost of goods sold normally tracks the direct cost of products sold, while a payment fee is a cost of accepting payment. Your accountant might choose a different presentation for your business, so confirm the account type and any tax treatment before automating it.

1. Open Settings → Chart of accounts in QuickBooks Online.
2. Select New account and choose an Expense account type.
3. Give the account a clear name such as Shopify Payments fees.
4. Add a description explaining that it holds fees deducted from Shopify Payments payouts.
5. Save the account and use it on one test payout before importing older activity.

Worked example: record the fee without losing the gross sale

Suppose one US-dollar Shopify payout contains $4,800 of product sales, $200 of shipping, and $400 of sales tax. It also contains $350 of customer refunds and $160 of Shopify Payments fees. Shopify sends $4,890 to the bank.

QuickBooks should still show $4,800 of product sales and $200 of shipping income. The $400 of sales tax is normally recorded as a liability rather than income, subject to the tax setup approved for the business. The $350 refund reduces sales or reaches the refund account your accountant uses. The $160 fee goes to the payment-processing expense account.

Those amounts leave $4,890 in the Shopify clearing account—the amount Shopify owes you for this payout. When the $4,890 deposit appears in the QuickBooks bank feed, match it to the existing payout or transfer. Do not categorise the deposit as another $4,890 of sales.

How to record a Shopify payout manually

There is more than one valid QuickBooks workflow. Some businesses use a journal entry for each payout; others use a sales receipt, deposit, or connector-generated summary. The form matters less than the result: the sales and deductions must be visible, the entry must total the Shopify payout, and the bank deposit must not create duplicate income.

If your Shopify sales have not already been recorded in QuickBooks, record the payout breakdown against a Shopify clearing account. Debit the clearing account for the amount Shopify will pay, debit the fee and refund accounts for the deductions, then credit sales, shipping, and tax liability accounts for the amounts collected.

When Shopify deposits the payout, move the net amount from the Shopify clearing account to the bank account. If the bank feed downloads that deposit, use Match to connect it to the transfer or payout entry already in QuickBooks.

• Gross sales remain visible instead of being replaced by the net deposit.
• The actual Shopify Payments fee reaches the approved expense account.
• Refunds and sales tax are kept separate from processing fees.
• The clearing amount equals the Shopify payout exactly.
• The bank deposit is matched, not added as new income.
• Retrying an import cannot create the same payout twice.

If sales are already entering QuickBooks from another source, do not record them again in a payout journal. Coordinate the workflows so the payout clears the existing customer payments rather than duplicating revenue. Test one payout from start to finish before changing several months of books.

Record Shopify bill charges separately

Your Shopify subscription, paid apps, shipping labels, domain, theme, and some transaction or tax-service fees are not necessarily deducted from Shopify Payments payouts. Shopify can charge them to the payment method used for your Shopify bills.

When a Shopify bill is paid by credit card or bank account, record that bill or payment from the same account in QuickBooks. Split the total into useful categories when the bill contains different costs—for example, software subscriptions, app expenses, shipping-label costs, and transaction fees.

Do not add those billed charges to a payout just because Shopify is the vendor. If you record them inside the payout and again from the credit-card feed, the expense is doubled. Shopify says its billing charges can appear on a bank or card statement with a Shopify description and bill number, which helps you match the payment to the correct invoice.

What happens to fees when you refund an order?

Do not assume that every refund returns the original processing fee. Fee treatment can depend on the payment method, store location, and Shopify's current terms. Use the actual fee or fee adjustment shown in the payout instead of reusing the fee from the original sale.

Shopify's payout reconciliation report groups refunds with related fee adjustments when they apply. If a fee credit appears, record the credit against the same payment-processing expense account so the net fee cost remains accurate. If no fee credit appears, do not create one in QuickBooks simply because the customer received a full refund.

Disputes and chargebacks can also create separate holds, reversals, or dispute fees. Keep them out of the ordinary processing-fee total when you need to review them separately. The Shopify payout detail should tell you which activity reduced the payout.

Watch for multiple currencies and payment providers

If you accept currencies other than your payout currency, the transaction can include currency conversion as well as payment processing. Record the figures in the payout currency shown by Shopify and preserve the original-currency detail as supporting information. Do not treat every exchange-rate difference as a payment fee.

PayPal, Klarna, or another gateway might settle money to the bank independently. Their fees do not belong in a Shopify Payments payout unless Shopify's own report actually includes them. Reconcile each provider from its settlement report to its own bank deposit.

Separate clearing accounts by provider and payout currency make differences easier to investigate. One combined account can hide whether Shopify, PayPal, or a currency conversion caused the remaining balance.

Common mistakes that make Shopify fees look wrong

• Recording only the net bank deposit as sales, which hides both revenue and fees.
• Recording the gross sale correctly but forgetting the fee expense, leaving the clearing account too high.
• Estimating fees from a published rate instead of using the actual fee shown in the payout.
• Adding Shopify subscription and app charges to the payout even though they were paid through Shopify billing.
• Recording a Shopify bill from the invoice and again from the credit-card feed.
• Combining Shopify Payments, PayPal, and other processors in one payout calculation.
• Assuming a refund always returns the original processing fee.
• Importing months of payouts before checking that one payout matches the bank and does not duplicate sales.

Where Vatteo fits

The arithmetic for one payout is manageable. The difficulty is repeating it across every payout, keeping the actual fees tied to the right sales and refunds, using approved QuickBooks accounts, and stopping the same payout from being posted twice.

Vatteo groups each Shopify payout into sales, shipping, tax, refunds, payment fees, disputes, and other adjustments. It shows the proposed QuickBooks accounts before posting and checks that the breakdown reaches the exact amount Shopify says it paid.

That leaves the bank match as a control rather than a guess. You can trace the $160 fee in the example back to the payout, see where it will appear in QuickBooks, and investigate a difference before it reaches the books.