Fix guide
Shopify gift card orders wrong or missing in QuickBooks
Gift cards break Shopify-QBO bookkeeping twice. First at sale: selling a gift card isn't revenue - it's a liability (you owe the holder goods), and a sync that posts it as income overstates revenue now and double-counts it at redemption. Second at redemption: an order paid partly or fully by gift card has a payment composition many syncs don't handle cleanly, so these orders post with wrong amounts or fall out of the sync entirely.
Orders with gift-card tenders are one of the recognized edge cases that route differently through many syncs - the same class of problem as multi-currency orders. Because gift-card orders are a small share of most stores' volume, the errors hide inside otherwise-clean books until a reconciliation forces the question.
The check is bounded and worth doing: filter to gift-card activity, verify a sample on each side of the lifecycle, and you'll know in an hour whether this edge case is costing you.
The symptoms
- Orders paid partly or fully by gift card are missing from QBO or posted at the non-gift-card remainder
- Gift card sales appear as product revenue instead of a liability
- A gift card liability account that never decreases as cards are redeemed - or doesn't exist at all
- Revenue slightly overstated in months with strong gift-card sales (holidays especially)
Why it happens
Redemption is a payment method, not a sale
When a customer pays with a gift card, the order's revenue is real but the payment isn't money movement - it discharges the liability created when the card was sold. Syncs that only understand cash-like tenders post these orders wrong (often at the cash portion only) or skip them.
Card sales posted as revenue
If gift card sales map to a product income account instead of a liability account, revenue is recognized twice: once at card sale, once at redemption. The books look better than reality by the amount of outstanding cards.
Split-tender complexity
An order paid $60 gift card + $40 card has two tenders, two settlement paths, and (on refund) two return paths. Each split point is a place syncs drop or mis-state the transaction - refunds back onto gift cards are the messiest case of all.
How to check and fix it by hand
- 01
List gift-card activity in Shopify
Shopify reports gift card sales and gift card redemptions separately. Pull both for a test period - a holiday month is ideal because volume is highest.
- 02
Check where card sales landed in QBO
Trace several gift card sales: they should credit a gift card liability account, not income. If they're in income, note the total for the period - that's your revenue overstatement at sale.
- 03
Verify redemption orders one by one
Take five orders paid partly or fully by gift card and find them in QBO. Check they exist, that the full order revenue is recorded, and that the gift-card portion debits the liability account rather than a cash/clearing account.
- 04
Correct the mapping and the history
Fix the sync's gift-card mapping (or add the liability account it needs), then correct historical postings with reviewable per-order entries. If gift-card orders are missing entirely, they show up in a line-by-line Shopify-QBO diff - LedgerClear's free scan flags them alongside every other missing or mis-stated order, read-only.
Common questions
- Why are my gift card orders not syncing to QuickBooks?
- Gift-card tenders route differently through many syncs than cash-like payments do. Split-tender orders (part gift card, part card) are the most commonly dropped or mis-stated shape. Verify a sample directly rather than assuming the sync handled them.
- Is selling a gift card revenue?
- No - it creates a liability until the card is redeemed. If your sync posts card sales to income, revenue is overstated at sale and double-counted at redemption. Your accountant can confirm the right treatment for your jurisdiction; the bookkeeping mechanics are a liability account either way.
- How do I find gift-card orders that went missing?
- Diff Shopify's paid-order list against QBO transactions and look at what's absent - gift-card and multi-currency orders cluster in the gaps. LedgerClear's free scan runs the diff read-only and lists each missing order with its Shopify side shown.
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.