Fix guide
Shopify refunds missing from QuickBooks
Refunds are the transaction type syncs drop most quietly. The sale posted fine; the refund three weeks later - partial, split across items, maybe in another currency - didn't. Result: your books show revenue you gave back.
Unrecorded refunds overstate income and, depending on jurisdiction and setup, overstate the sales tax you appear to owe. Because each one is small, they accumulate unnoticed until a reconciliation or a tax return forces the question.
The symptoms
- QBO net revenue higher than Shopify's net sales for the same period
- Refund count in Shopify exceeds refund receipts in QBO
- Payout deposits smaller than your books expect (payouts are net of refunds)
- Partial refunds especially absent - full-order refunds sync more reliably
Why it happens
Partial and multi-line refunds
Item-level partial refunds, refunds with restocking adjustments, and split refunds stress sync logic far more than clean full-order refunds. Many pipes handle the simple case and drop the messy ones.
Refund happened after the order synced
Order posts on day 1; refund happens on day 20. Syncs that don't re-visit already-posted orders never see the refund at all.
Outage windows
Any period the sync was down drops its refunds just like its orders - but reconciliation attention goes to the missing orders, and the missing refunds slip through.
How to check and fix it by hand
- 01
Count refunds on both sides
Shopify: refunds report for the period. QBO: refund receipts (or credit memos, per your sync's posting mode) for the same period. Mismatched counts are your list to chase.
- 02
Match refund by refund
For each Shopify refund, find its QBO counterpart by order reference, date, and amount. Recent refunds inside the settlement window may legitimately still be in transit - give them ~5 business days.
- 03
Record the missing ones
Each confirmed-missing refund needs a refund receipt or correcting entry: debit returns/allowances (and the tax component to the liability account), credit your clearing account.
- 04
Respect filed periods
A refund belonging to an already-filed tax period changes what you owed. That correction is a bookkeeper conversation, not an auto-post.
Common questions
- Why don't my Shopify refunds show in QuickBooks?
- Partial/multi-line refunds stress sync logic, refunds issued weeks after the order are missed by pipes that don't revisit posted orders, and outage windows drop refunds alongside orders - but less visibly.
- What do unrecorded refunds do to my books?
- They overstate revenue and can overstate the sales tax you appear to owe. Small individually, they accumulate - and they're exactly the kind of finding a periodic line-by-line diff surfaces.
- How does LedgerClear handle refunds it finds missing?
- Each confirmed-missing refund is a finding with the Shopify refund and the absent QBO side shown together. Cleanup proposes the correcting entry; you approve it (or route it to your bookkeeper if the period is filed).
LedgerClear doesn’t replace your sync. It audits per-order syncs today - the official connector and Synder. Summary-posting tools like A2X and Link My Books: auditing support is coming later, and LedgerClear runs alongside them without touching their entries. If the right answer for you is switching tools, the scan report is the damage report to migrate with.