Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics gift-cards

Report Gift Card Liability

Total outstanding gift card balances by issue date to show the store's current redemption liability.

📋 Prompt
Run in Sidekick
Report the store’s current gift card liability — the total unredeemed balance owed to customers as of today.

Summary:

  Total gift cards issued (all time, or since [DATE])
  Total value issued
  Total value redeemed
  Total outstanding balance (value issued − value redeemed − any expired/voided balance)


Breakdown:

  Outstanding balance grouped by issue month/quarter, to show how much liability is from recent vs old issuances
  Gift cards issued but never redeemed at all, grouped by age (0-90 days, 91-180 days, 180+ days) — the older ones are the least likely to ever be redeemed but still count as liability until they expire or the store writes them off per its policy
  Top 10 largest outstanding balances by individual gift card


Output format:

  Summary block with the total outstanding liability number
  Table: issue period, value issued, value redeemed, outstanding balance
  Table: largest 10 outstanding balances


Deliverables:

  All of the above
  One clear number: total outstanding gift card liability today
  Flag if a large share of outstanding balance is from cards older than 180 days, since that’s worth a note to whoever manages the store’s books

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions