QuickBooks Online · Xero
Shopify refunds not showing in QuickBooks or Xero
The order synced, the customer was refunded, and your books still show the full sale. Refunds are the part connectors handle worst. Here's how to find the missing ones and record them.
Why refunds go missing
- The connector only sends orders when they're created. A refund days later is a change to an old order, and some connectors never look at old orders again.
- Partial refunds, returns and exchanges are harder to map than a simple order. Refunds of shipping only, restocking fees or store credit often fail.
- A refund to a different payment method (store credit, a gift card, cash) has no account mapped.
- A cancellation before payment may remove the sale in Shopify but leave the synced invoice open in your books.
The money still left your account: Shopify Payments takes refunds out of your next payout. So a missing refund shows up twice: sales are overstated, and the payout won't match the bank.
Check by hand
1. List the refunds in Shopify
- In Shopify admin, go to Analytics → Reports and open Finance Summary for last month. Its returns line is the total to account for.
- For the order numbers: Orders, filter Payment status to Refunded and Partially refunded, then export. Open an order to see the refund date and amount in its timeline.
2. In QuickBooks Online
- Go to Reports → Standard reports and run Transaction List by Date for last month.
- Click Customize and filter Transaction Type to Refund Receipt and Credit Memo.
- Compare the list with Shopify's refunds. Use the search box at the top for a specific order number.
2. In Xero
- Go to Sales → Invoices and click Search. Set last month's start and end dates; credit notes show with a minus sign.
- Or run Reporting → All reports → Account Transactions for your sales accounts and look for negative lines.
- Compare with Shopify's refunds.
Fix it
QuickBooks Online
- Click + Create → Refund receipt.
- Choose the customer, the refund date, the product or service lines and the same tax as the original sale.
- In Refund from, pick the account your Shopify payouts go through (Undeposited Funds or a clearing account), so the refund can be included when you match the payout.
- Put the Shopify order number in the reference or memo.
Xero
- Open the original invoice, click the menu icon (⋯) and choose Create and apply credit. Or create one from Sales → Invoices → New Credit Note, then Approve.
- Set the refund amount, lines and tax rate to match Shopify.
- If the invoice was already paid, open the credit note and click Add cash refund, paid from the account your Shopify payments go through (a clearing or Shopify Payment Balance account).
- Reference the Shopify order number.
Then check your connector's settings for a refund or credit note option, so future refunds come across on their own.
If a sales tax, VAT or GST return already covers the period, ask your accountant whether to date the refund in the original period or the current one.