Automate gift card liability reconciliation, from Shopify to your ledger

Every gift card you sell is money you have taken for goods you have not shipped yet. Until the card is redeemed, that money is a debt to the cardholder, so it sits in a liability account, not in sales. The trouble starts when the liability in your ledger and the outstanding balance in Shopify drift apart: free cards issued as refunds that nobody booked, redemptions recorded as a payment without reducing the liability, cards disabled in one system and not the other. This recipe closes that gap every month. It is one page of our automation library.

How does a monthly gift card roll-forward work?

A roll-forward explains how the liability moved from the first day of the month to the last. Every movement has a source in Shopify, and the closing line has to match two numbers: Shopify's own ending balance and the gift card liability account in your ledger. You can run this table today in a spreadsheet; the workflow only fills it in and checks it.

Closing liability = opening liability + cards sold + cards issued free - redemptions - disabled value +/- adjustments

Shopify's gift card data for reports gives most lines directly, per day, month or currency: the starting and ending gift card balance, the liability added by cards sold, the liability added by cards issued, the value removed when cards are disabled, and the value adjusted (checked November 13, 2026). Redemptions are not in that data. They come from the payments side, where Shopify's finance reports record the amount paid by or refunded to a gift card as a gift card entry (checked November 13, 2026).

These numbers are illustrative, for a brand selling about $6,000 of gift cards a month, not a client's results. The first check ties out: Shopify's movements explain its own ending balance. The second does not. The ledger is $150 low, and the card-level review finds two causes that partly cancel: $300 of promotional cards issued free were never booked (ledger too low), and a $150 card disabled in Shopify was never released in the ledger (ledger too high). A net difference of $150 hid $450 of errors, which is why the workflow explains each cause instead of posting a plug.

What causes gift card mismatches, and who fixes each one?

When either difference line is not zero, one of these is usually the reason. The workflow checks for each cause in turn, shows the cards involved, and only marks a difference unexplained when none fit.

Shopify documents several of these behaviors itself. Its finance reports page says an expired card's remaining balance keeps counting toward the outstanding balance, a deactivated card's balance returns to zero, deactivated values can take up to 24 hours to show, the amount paid by gift card on imported orders is not subtracted automatically, and gift card reports and exports can have different totals because they count different things (checked November 13, 2026). It also says there is no per-transaction gift card ledger report, which is why the workflow keeps its own.

Where does the card-level detail come from?

Totals tell you that something is wrong. Card-level detail tells you which card. Shopify's gift card export includes the issue date, expiry date, initial and current balance, currency, issue method, whether the card is expired or deactivated, the deactivation date, the issuing staff member and the note (checked November 13, 2026). The same page says a deactivated card cannot be reactivated, reloaded or refunded onto, and that balances cannot be edited directly from the admin: they change only through redemption, a refund or a custom integration that uses the gift card API.

For a daily check, the GiftCard object in Shopify's Admin API returns each card's balance, initial value, whether it is enabled, its expiry and deactivation dates, its transaction history and the order that created it, which is empty for cards issued manually (checked November 13, 2026). It needs the read_gift_cards access scope only; this workflow reads gift cards and never changes them.

Shopify's page on issuing gift cards lists the reasons a staff member creates one without payment: a promotion, incentive or reward, a custom denomination, or a refund or store credit (checked November 13, 2026). Those are exactly the cards the review list shows each day, with who issued them and why, so a refund issued as a card in your returns and refunds workflow is booked the same way as the cash refund it replaced.

How do you post gift card movements in QuickBooks Online or Xero?

Post one summary entry per month and currency, not one per card. Intuit's guide to selling and redeeming gift cards in QuickBooks Online sets up a liability account and a gift certificate product linked to it; a redemption adds that product as a negative line on the customer's invoice (checked November 13, 2026). A month-end journal entry works too, and QuickBooks requires the total of its debits column to equal the total of its credits column, per its journal entry guide (checked November 13, 2026).

In Xero, the Accounting API's manual journals need a narration and lines where debits are positive and credits are negative; the Xero Accounting API specification shows the error returned when total debits do not equal total credits (checked November 13, 2026). Either way, the account behind each line is your accountant's choice. The table shows what each movement does to the liability; the other side of each entry is left to that decision.

Check the redemption line against how your orders reach the ledger. If a connector already books each order as a sale paid partly by gift card, the redemption entry must only move the gift card portion out of the liability, or the sale is counted twice. Our marketplace payouts recipe covers the cash side of the same orders.

Which tools can run it?

Pick the smallest setup that ties out every month.

What should stay with a person?

The rules find and sort; people decide. Your accountant sets the account map once, including how free cards issued as refunds and promotions are booked. Each month a person reviews the cards the workflow flags, explains or accepts any difference the mismatch table cannot, and approves the entry before the month closes. Expiry and unclaimed balances go to your accountant or counsel. A person also decides who may issue, disable or adjust cards in Shopify. Free cards and discount codes leak margin the same way, which our discount code leak alerts recipe watches on the code side.

Who builds gift card reconciliation for Shopify brands?

Ecomsellertool builds finance workflows like this one on your own Shopify and accounting accounts. We have built software on Amazon's seller APIs since 2017 and shipped 50+ tools for 100+ teams. We start with your accountant's account map and how your cards are issued, then build the pulls, the roll-forward, the checks and the review list. Send a project brief below, or read how our workflow automation service works.

The alerting and finance data sides of this recipe are work we have shipped:

• Alerts that put a person on the right item. For AccountDr we built rule-based automation that notifies Amazon sellers about account events such as performance metrics, listing faults and stranded inventory, by push and email, so a person acts on the specific item instead of searching for it.
• An accounting firm's data pipeline. For Zonkeepers, an accounting firm, we built an AWS pipeline that ingests Amazon order and finance reports into profit and loss analytics, with sales and expenses broken out.

Get this workflow built