Your Shopify gift card revenue is probably wrong. Here's how to tell — and how to fix it.

Vikram Bhaskaran

•

March 11, 2026

•

7 min read

Shopify + QuickBooks

If you are a D2C or scaling ecommerce business that offers gift cards as a sales channel or store-credits to handle returns, this one’s for you.

Every time a customer pays with a Shopify gift card in your store, your accounting system makes a decision. For most ecommerce businesses, that decision is wrong. And it's silently inflating your revenue numbers.

TL;DR — What this post covers

🎯 The core problem

Most connectors post gift card sales as revenue — they're not
Gift cards are liabilities until redeemed
Split payments make it worse

⚡ What's at stake

Inflated taxable income — paying tax on money you haven't earned
P&L shows revenue that doesn't reconcile to your bank
Hidden balance sheet liability + possible escheatment exposure
Year-end close pain

🔧 The fix

Map gift_card payment method to a Gift Card Liability account — not income
Takes ~20 minutes to configure
Self-diagnose in under 10 min with the 3-check table below

📋 Who this is for

Shopify store owners who sell gift cards
Bookkeepers cleaning up a Shopify → QuickBooks integration
Anyone whose P&L doesn't reconcile to bank deposits

The problem, without accounting jargon:

Gift cards posted as sales revenue

⚠️ This is probably happening in your books

You just counted the same $100 twice. And you have no gift card liability on your balance sheet.

Shopify treats gift cards as a payment method — no different than a Visa or PayPal in its data. Most connectors read that signal and post it as revenue. Which means when a customer buys a $100 gift card, your books see a $100 sale. Then when they redeem that gift card on an actual order, your books see another $100 sale. One transaction, two revenue entries.

Or didn't happen at all — because that $100 sale you booked when they bought the card? That's not income either. It's a liability. You have their $100, but you still owe them $100 in goods. It becomes revenue the moment they use it — not before.

💡 The one rule to remember

Selling a gift card = creating a debt (liability), not earning income.
A gift card is only revenue when a customer uses it to buy something.
Until then, it lives on your balance sheet — not your P&L.

This is one of the most common accounting errors we see our customers struggle with. We were onboarding a new Shopify customer recently that had some serious accounting discrepancies. After a few hours of investigation, it turned out their previous connector had been posting gift card sales as revenue for 18 months. The fix required a retroactive journal entry and a conversation with their accountant. Not fun.

These issues happen more often than we'd like — over 97 customers in the last few months. And that's just the businesses who caught it.

Do you have this problem?

3 checks, under 10 minutes

3-check diagnostic gift card accounting Shopify QuickBooks

Why this keeps happening:

Reasons your connector gets it wrong

Shopify records gift cards as a payment method. Most connectors treat payment methods as revenue. That's the entire bug.

What's more painful is Shopify's own analytics actually handles this correctly. Gift card sales are excluded from sales reports in Shopify's own dashboard. It's only when the data moves into QuickBooks via a connector that the mistake gets made.

Before and after connector comparison gift card posting

Split payments make it worse. If a customer paid $90 with a gift card and $60 with a Visa on a $150 order, there are two separate payment legs in Shopify's data. Most connectors collapse those into a single entry.

"It was refunded in 2 parts — $51 to a gift card and $213.02 to a Visa card. However, I imported it as 1 refund for the total amount… why is this incorrect? Or should this have been downloaded as 2 separate refunds?"

— Webgility customer

Two payment legs collapsed into one. The gift card liability doesn't get relieved. The Visa payment doesn't get its own clearing entry. Both are wrong, and they compound.

What this costs you

Taxes, phantom revenue, and a liability you can't see

This isn't just a bookkeeping tidiness issue. Here's what broken gift card accounting does to your business:

You're paying tax on money you haven't earned

If gift card sales are hitting your revenue, your taxable income is inflated. For a store doing $5,000/month in gift card sales, that's potentially $60,000/year of phantom income showing up on your returns.

Your P&L is lying to you

When you look at last month's revenue, you can't tell what's real sales vs. gift cards sold. That means your margin calculations, inventory forecasting, and profitability picture are all wrong.

You have a liability you can't see

Every unredeemed gift card you've sold is money you owe to a customer. If it's not on your balance sheet, you don't know what you owe — and escheatment laws in most states require you to turn that money over to the state after a certain period.

Your year-end close will hurt

Your bookkeeper or tax preparer will find this. The question is whether they find it in October (fixable) or in April after you've already filed (painful). Q4 gift card spikes — holiday season — make this worse every year.

How to fix gift card posting in Shopify and QuickBooks with Webgility

The accounting logic: 4 scenarios, each with a correct treatment

Scenario	What Shopify shows	Correct accounting	Common mistake
Customer buys a $100 gift card	Payment received, product = gift card	DR Bank $100 · CR Gift Card Liability $100 · No revenue recognized.	Posting $100 to Sales Income.
Customer redeems $100 gift card in full	Order paid via gift_card payment method	DR Gift Card Liability $100 · CR Sales Income $100 · Revenue recognized now.	Posting $100 to Sales Income again (double-count).
Split: $90 gift card + $60 Visa ($150 order)	Single order, two payment entries	DR Gift Card Liability $90 · DR Clearing $60 · CR Sales Income $150	Collapsing to one entry — liability doesn't clear, or Visa disappears.
Refund back to gift card	Refund, payment method = gift_card	DR Sales Income · CR Gift Card Liability · Liability reinstated.	Reversing only the order — liability never comes back.

Gift card accounting lifecycle sold held redeemed refunded

Configuring Webgility: one mapping change, everything flows correctly

Webgility handles all four scenarios — but the configuration has to be right. The fix comes down to one setting: your payment method mapping. The gift_card payment type needs to route to your Gift Card Liability account, not to Sales Income. Once that's set, Webgility handles everything else: liability creation on sale, liability relief on redemption, split-payment separation, and refund reinstatement.

If you're not sure whether yours is set up correctly, check: does a Gift Card Liability account exist in your QuickBooks Chart of Accounts? If not, create a Current Liability account named "Gift Cards Outstanding," then map your gift_card payment method to it in Webgility.

✅ After configuration, your books should show

Gift card sales post to liability — no P&L impact at time of sale
Gift card redemptions relieve the liability and hit income
Split-payment orders show two separate accounting lines
Refunds to gift card reinstate the liability balance
Shopify Gift Card Liabilities report and QB balance sheet match

Can I do the same with Discount Codes?

Discount codes aren't liabilities — they just reduce your selling price. But they create a specific posting failure that trips up a lot of stores. They deserve their own treatment.

But that's a whole other story we'll discuss next time 😀

Month-end checklist:

Gift cards & split payments done right

Print this or paste it into your close checklist.

Gift Card Liability account exists in QuickBooks as a current liability — NOT an income account

No gift card sale transactions appearing in any sales income account

No split-payment orders sitting in error queue

Discount codes posting with dollar amounts, not just code references

Refunds issued to gift card are reinstating the liability — not just reversing the payment

P&L revenue reconciles to actual bank deposits (excess = likely double-count)

(QB Desktop only) Gift card item is set as Non-Inventory Part, income account = liability account, non-taxable

Common questions

Gift card accounting in Shopify + QuickBooks

My Shopify gift card balance and QuickBooks don't match. Where do I start?

Pull Shopify's Gift Card Liabilities report and export it. That shows what Shopify thinks is outstanding. Compare the closing balance to your Gift Card Liability account in QuickBooks. The gap between those two numbers is the size of your error — and usually tells you when it started.

We give out promotional gift cards for free. Are those handled the same way?

Same redemption accounting, different issue on the way in. When you issue a free promo gift card, you debit a marketing expense and credit the Gift Card Liability — no cash received. Redemption accounting is identical to a purchased card.

We're on QuickBooks Online, not Desktop. Does this still apply?

Yes, same logic. In QBO you'll create a Service item instead of a Non-Inventory Part, and map it to your gift card liability account. The account mapping in Webgility works the same way.

Should I be worried about escheatment if I have unredeemed gift cards?

If you have any material gift card liability outstanding for more than 2–3 years, yes — talk to your accountant or a state tax advisor. Escheatment rules vary by state but most require reporting and remittance after a dormancy period.

Glossary

Accounting terms, for Non-Accountant Operators

Gift card liability — A debt you owe to a customer. When someone buys a gift card, you have their money but haven't delivered goods or services yet.

Deferred revenue — Cash you've received but not yet earned. Gift card sales create deferred revenue. It only converts to real revenue when the card is redeemed.

Split payment — A single order paid using two or more payment methods — e.g., $90 from a gift card and $60 from a credit card.

Payment method mapping — A setting in Webgility that tells the integration where to post transactions based on how the customer paid.

Redemption — When a customer uses a gift card to pay for an order. This is the moment deferred revenue becomes real revenue.

Escheatment — A legal requirement in most U.S. states that obligates businesses to turn over unclaimed gift card balances to the state after a dormancy period.

Non-Inventory Part (QB Desktop) — An item type used for things you sell but don't physically stock. Used for gift cards to enable correct account mapping.

Balance sheet — Shows what your business owns (assets), owes (liabilities), and the difference (equity). Gift card liabilities live here.

P&L (Profit & Loss) — Shows revenue, expenses, and profit over a period. Gift card sales should not appear here until redeemed.

Connector / integration — Software that moves data between Shopify and QuickBooks. Basic connectors push raw order data; Webgility applies accounting logic.

Your Shopify gift card revenue is probably wrong. Here's how to tell — and how to fix it.

Contents