Reports & accounting

Reports overview

What's on the Reports page (Summary, Gift cards, Adjustments and Liability), what each Summary and Home figure means, date ranges and time zones, filtering by customer email, who can see reports, and how often the numbers update.

The Gift cards report

What the Gift cards report shows, which cards it includes (activated in the date range, not hidden from reporting), what each of its 26 columns means, and how to filter it by customer email and export it.

The Liability report

How Wrapped's three liability reports work - current liability by sales channel, detailed current liability, and point-in-time liability as at a past date - what liability, total issued, redeemed and expired mean, how the date range is applied, and which one to use for month-end.

The Adjustments report

How the Adjustments report lists every change to every gift card balance (activations, redemptions, top-ups, voids, manual adjustments, bonus credit and expiries), what each column and adjustment type means, and how the Summary by sales channel and Summary by reason reports total them.

How often reports update

Reports and the Home overview refresh about every 2 hours from a separate reporting database, while a gift card's own page and timeline update immediately; what that means for today's sales, hidden and deleted cards, and when to contact support.

Export a report to CSV

How to download any Wrapped report as a CSV file or an Excel (.xlsx) workbook from the Export menu, what the file contains (the whole result for your date range and filter, not just the page on screen), how dates and amounts are formatted, and how to open it in Excel or Google Sheets.

Revenue, voids and discounts in reports

What "revenue" means in each part of Wrapped (the gift card list's Revenue column, Summary and Home figures), why a voided gift card sale still shows its original revenue, and whether a discounted gift card sale is recorded at its face value or the price paid.

Promotional gift cards and bonus credit in reports

How bonus gift cards, bonus credit and other promotional value show up in Wrapped's reports - summary figures don't separate them from paid cards, but the Gift cards, Adjustments and Detailed current liability reports let you split them out - with steps to measure promotional value.

Accounting for gift cards: liability and revenue

General background on how gift card sales, redemptions, promotional value and expiry are commonly treated in the books, how Wrapped's gift card sales appear in Shopify's reports, and a step-by-step month-end reconciliation using Wrapped's Liability and Adjustments reports. Not accounting or tax advice.