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.
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.
- Fee posting is switched off, or needs a setting such as a fee account or a tax rate for fees. On some connectors that setting is only on a paid plan.
- The connector only posts orders, not payouts, so it never sees the fees.
- The fee was posted with the wrong tax treatment. In GST and VAT countries, Shopify's fees may carry tax that you can claim. Fees exported as "no tax" or "BAS excluded" lose that.
- Multi-currency stores: fees can be posted in the wrong currency.
Check by hand
1. Get the fee total for each payout
- In Shopify admin, go to Finance → Payouts.
- Open a payout. Its summary shows the fees deducted. Use the export icon → Export payout transactions if you want the fee for each order.
- For a whole month, add up the fee totals of the payouts paid in that month.
2. In QuickBooks Online
- 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.
- If you use Intuit's Shopify Connector, it records fees as separate expenses: look for them under All apps → Accounting → Integration transactions.
- 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
- Run Reporting → All reports → Account Transactions for your fees account for the month.
- Compare it with the Shopify total. Check the tax rate column too.
Fix it
QuickBooks Online
- 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.
- 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
- 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.
- Payee "Shopify", account Merchant fees (or Bank fees), amount the payout's fee total, with the right tax rate for your country.
- 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.