Books Watchdog

QuickBooks Online · Xero

Shopify Payments fees not recorded in QuickBooks or Xero

Sales came across, but the payment processing fees didn't. Expenses are understated and every payout is short by the fee amount. Here's where to find the fees and how to record them.

Updated 11 November 2026

Why fees go missing

Shopify Payments takes its processing fee before paying you, so the fee never appears on your bank statement as its own line. It only exists inside the payout. If the connector doesn't post it, nothing else will.

Check by hand

1. Get the fee total for each payout

  1. In Shopify admin, go to Finance → Payouts.
  2. Open a payout. Its summary shows the fees deducted. Use the export icon → Export payout transactions if you want the fee for each order.
  3. For a whole month, add up the fee totals of the payouts paid in that month.

2. In QuickBooks Online

  1. Run Reports → Standard reports → Profit and Loss for the month and click the amount on your merchant fees (or bank charges) line to see what's in it.
  2. If you use Intuit's Shopify Connector, it records fees as separate expenses: look for them under All apps → Accounting → Integration transactions.
  3. Or open the bank deposits for Shopify payouts: a deposit that includes fees has a negative line under Add funds to this deposit.

2. In Xero

  1. Run Reporting → All reports → Account Transactions for your fees account for the month.
  2. Compare it with the Shopify total. Check the tax rate column too.

Fix it

QuickBooks Online

  1. For a payout not yet matched: in + Create → Bank deposit, tick the payout's sales and add a line under Add funds to this deposit: account Merchant fees (or your bank charges account), amount as a negative number. The deposit then equals the payout, and it matches in the bank feed.
  2. For a payout already matched at the wrong amount, record the missing fees with + Create → Expense, paid from the same account the sales sit in, and ask your accountant how they want it tidied up.

Xero

  1. In Accounting → Bank accounts, open the menu for the clearing account (or the account your connector uses) and choose Spend money. The + icon in the top bar also has it.
  2. Payee "Shopify", account Merchant fees (or Bank fees), amount the payout's fee total, with the right tax rate for your country.
  3. Reference the payout date so it's easy to tie up.

Then turn on fee posting in the connector, if it offers it, so the next payout comes across complete.