shopify-admin-gift-card-balance-report

Generate CSV reports of active Shopify gift card balances via GraphQL queries.

174|18|Updated Apr 11, 2026
One-click install
npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-gift-card-balance-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: shopify-admin-gift-card-balance-report
Source: https://github.com/40RTY-ai/shopify-admin-skills/tree/main/skills/finance/shopify-admin-gift-card-balance-report
Command: npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-gift-card-balance-report

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It eliminates the manual accounting effort of finding all active gift cards, calculating their remaining (unredeemed) balances, and identifying balances that are expiring soon for liability tracking.

Core Features & Use Cases

  • Reads-only gift card inventory: Queries all active and partially-redeemed gift cards and surfaces remaining balance, initial value, and key dates for deferred revenue reporting.
  • Expiry and status filtering: Filters by enabled/disabled/all status and flags gift cards expiring within a configurable number of days.
  • Exports a reconciliation-friendly CSV: Produces a CSV file that includes gift card identifiers, customer email, balance details, and an expiring-soon indicator for downstream accounting workflows.
  • Use Case: Before monthly financial close, generate a gift card liability report to reconcile deferred revenue and forecast imminent liability reduction from expiring gift cards.

Quick Start

Ask the assistant to run shopify-admin-gift-card-balance-report for your store and output the results in human-readable format.

Frequently Asked Questions about shopify-admin-gift-card-balance-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a Shopify gift card liability report for accounting reconciliation?

To generate a Shopify gift card liability report, you can run a query that extracts active and partially-redeemed gift cards, calculates remaining balances, and outputs a CSV summary of total outstanding liability for deferred revenue tracking.

Can I filter Shopify gift cards by status and expiration date for balance-sheet liability tracking?

Yes, you can filter Shopify gift cards by enabled, disabled, or all statuses, and flag balances expiring within a configurable number of days to forecast imminent liability reduction for balance-sheet tracking.

How does gift card deferred revenue reporting work for unused Shopify balances?

Gift card deferred revenue reporting works by querying all active Shopify gift cards with remaining balances, validating their status and expiry, and summing unredeemed amounts to calculate total outstanding liability.

Does this gift card balance report require write access to my Shopify store?

No, this gift card balance report requires only read-only data access to your Shopify store to query active gift cards and calculate remaining balances for auditing and liability tracking without modifying store data.

What is the best way to export Shopify gift card balances to a CSV for monthly financial close?

The best way to export Shopify gift card balances to a CSV is to run a GraphQL query with pagination that retrieves gift card identifiers, customer emails, balance details, and expiring-soon indicators for downstream accounting workflows.

What is included in the CSV output for Shopify gift card liability tracking?

The CSV output for Shopify gift card liability tracking includes gift card identifiers, customer email, initial value, remaining balance, key dates, expiring-soon indicators, and total outstanding liability summaries for reconciliation.