How to account for Shopify gift cards in QuickBooks

The short answer

When a customer buys a Shopify gift card, the merchant receives money but still owes the customer future goods or services. A common accounting treatment records the cash or payment-provider balance and credits a gift-card liability rather than product revenue.

When the customer redeems the card, record the full sale under the approved revenue and tax treatment, then reduce the gift-card liability by the amount used. If the order is partly paid by gift card and partly by credit card, split the payment methods without splitting or duplicating the underlying sale.

At month end, the gift-card liability in QuickBooks should agree with Shopify's outstanding gift card balance after considering sold cards, cards issued without payment, redemptions, refunds, adjustments and deactivations. Differences should be traced to specific activity instead of posted to sales merely to make the balance disappear.

Why Shopify reports gift cards differently

Shopify's reports separate gift-card activity from ordinary product sales. A gift card created directly in the admin is not included as a sale. A sold gift-card product appears in the gift-card finance report, while the amount paid also appears in payment reporting under the customer's payment method.

When a customer redeems a gift card for a product, Shopify includes the full value of the item in sales reporting. The gift-card portion appears as a payment method and reduces the outstanding gift-card balance. This keeps product sales separate from the earlier cash collection.

That reporting can surprise a merchant who searches the sales report for the original gift-card cash. Use the Net sales from gift cards report to understand sold cards, the Payments reports to understand how cards were paid for, and the Outstanding gift card balance report to reconcile the continuing obligation.

The three gift-card events to separate

The debit and credit details depend on how Shopify sales, payments and clearing are recorded. The control is more important than a single template: the liability must increase and decrease for supported reasons, and the same product sale must never be recognized twice.

Worked example: sell a $100 Shopify gift card

A customer buys a $100 gift card and pays by credit card through Shopify Payments. The payment-provider activity contributes to a future payout, but the merchant has not yet delivered the product that will be chosen later.

Shopify processing fees and the eventual payout remain part of the normal Shopify Payments reconciliation. The gift-card liability explains why the $100 captured payment is not ordinary product revenue on this date.

If the gift card itself was sold at a discount—for example, the customer paid $90 for $100 of redeemable value—the treatment of the $10 difference needs an approved policy. Preserve both the cash received and the face value owed instead of forcing them into one amount.

Worked example: redeem part of the gift card

The customer later buys an $80 product and pays entirely with the gift card. The store now recognizes the $80 product sale under its normal revenue and tax policy and reduces the gift-card liability by $80. The card retains a $20 balance.

Tax and cost of goods sold are separate parts of the order. If the order includes tax, split the sale between the approved revenue and tax-liability treatment. If inventory costing is enabled, record the product cost through the separate COGS process.

Do not recognize $100 of sales when the card was sold and another $80 when it was redeemed. That would report $180 of revenue even though only $80 of goods have been delivered so far.

Handle split payments without duplicating the order

Suppose a $120 order is paid with $70 from a gift card and $50 by credit card. Shopify's sales report reflects the full $120 sale. The accounting should recognize that sale once, reduce the gift-card liability by $70, and record $50 through the credit-card payment or Shopify clearing path.

The payment split explains how the customer settled the order; it does not divide the economic sale into two unrelated sales. Tax, discounts, shipping and COGS still belong to the complete order under the approved policy.

Mixed tenders are a common source of duplication when one connector posts the order and another imports the gift-card payment separately as revenue. Choose one owner for the sale and reconcile payment-method movements against it.

Distinguish sold cards from cards issued without payment

A merchant can create or issue a Shopify gift card without collecting cash—for example as a promotion, service recovery or goodwill gesture. Shopify distinguishes created cards from sold gift-card products in its reports.

An issued card can still create an obligation because the customer may use it for future goods, but there is no customer payment to debit. Use the approved offset, which might relate to promotion, customer service, contra-revenue or another category depending on the reason and policy.

Keep issue method and reason in the evidence. A $50 card issued after a damaged order should not be indistinguishable from a $50 card sold for cash. Combining them can make both marketing spend and gift-card cash collection impossible to explain.

Refunds to gift cards increase the obligation

When a customer is refunded to a gift card, available card value increases. The gift-card liability should increase by the supported amount while the order refund follows the approved revenue and tax treatment.

A refund can cross accounting periods. The original sale may have been recognized last month, while the refunded gift-card value appears this month. Preserve the original order and refund evidence rather than editing the historical gift-card sale.

Shopify notes that gift cards can be reloaded in certain return and exchange flows and that refunds can affect the outstanding balance report. Reconcile the liability movement, not only the cash payout, because no new bank deposit may accompany value returned to a card.

Gift cards, store credit and discount codes are not the same

Do not funnel all four into Gift Cards Outstanding because the checkout screen looks similar. The balance source, customer right and cash movement differ. Separate mapping keeps the liability roll-forward and sales reports understandable.

Reconcile the outstanding gift-card liability

Shopify's Outstanding gift card balance report provides a daily roll-forward: starting balance, issued value, deactivated value, redeemed value, refunded value, adjustments and ending balance. Use the same period and currency as QuickBooks.

Run the roll-forward separately for each currency represented in the liability. Confirm the store timezone and include the final day's events before comparing balances. A difference caused by comparing a USD Shopify balance with a home-currency QuickBooks translation needs a currency reconciliation; it is not an unexplained gift-card gain or loss.

The QuickBooks Gift Cards Outstanding balance should be $14,600 after supported activity. If it is $14,850, investigate the $250 difference by event type, date, currency and order rather than posting a $250 sales entry.

Do not guess at expiry or breakage income

Gift-card expiry, unredeemed balances and breakage are governed by accounting policy and consumer-protection or unclaimed-property rules that vary by jurisdiction. The merchant cannot assume an old card balance is free income merely because no one redeemed it recently.

Shopify may continue to include an expired card's remaining value in outstanding balance reporting, and deactivation changes the balance from the deactivation date without rewriting historical data. That platform behavior is evidence, not a legal conclusion about when the obligation ends.

Before reducing the liability, obtain approval for the jurisdiction, card terms, legal requirements, accounting method and tax treatment. Keep the calculation and reviewer evidence with the journal.

How to set up QuickBooks for Shopify gift cards

1. Create or confirm an Other Current Liability account for outstanding gift-card value, subject to accountant approval.
2. Map sold gift cards so the captured customer payment increases the liability rather than product revenue.
3. Map redemptions so the product sale is recognized once and the gift-card portion reduces the liability.
4. Create distinct treatments for issued promotional cards, refunds to cards and approved deactivations.
5. Keep Shopify Payments clearing and payout fees in the normal payout workflow.
6. Test a sold card, a partial redemption, a mixed-tender order and a refund to a card.
7. Compare the ending QuickBooks liability with Shopify's outstanding balance report.
8. Save the roll-forward, difference analysis, mapping approvals and close sign-off.

How Vatteo prevents gift-card duplication

Vatteo separates Shopify gift-card payment activity from ordinary external gateways. A mixed gift-card and card order recognizes the order once, keeps the cash-funded portion in the payout, and moves the gift-card portion through the liability.

Gift-card issuance, redemption, refund, reduction and expiry or adjustment evidence roll into a balanced liability view. Missing or ambiguous evidence blocks the close instead of pushing the difference into generic revenue.

For a Shopify Payments merchant using QuickBooks Online, Vatteo is the stronger way to connect gift cards with the wider close. Payout evidence, account mappings, COGS, tax, reports and the liability roll-forward stay in one review path rather than separate spreadsheets.

Month-end gift-card checklist

• Sold cards and issued cards are separated by issue method and reason.
• The cash-paid portion of sold cards is included once in Shopify Payments or other gateway activity.
• Product revenue is recognized on redemption, not both sale and redemption.
• Mixed-tender orders are recognized once and split only by payment method.
• Refunds to gift cards increase the liability with source-order evidence.
• Store credit and discount codes are not mapped as gift cards.
• Deactivations, expiry and breakage follow an approved legal/accounting policy.
• QuickBooks agrees with Shopify's outstanding balance by currency.
• Every remaining difference has a specific event, owner and next action.