Skip to main content
Must know
  • Both reports are tabs on Reports > Payments: Gift cards and Gift card activity. They need the Gift Cards feature and the View financials permission.
  • Outstanding Liability ignores the issue date. It counts the remaining value on every card the other filters select, including locked cards.
  • Give-back corrections show as Adjusted rows. The Give-back corrected label appears only in the card’s History.
  • Both reports open on the last 365 days. A very large range can hit the row limit. A banner says so and the tiles show Partial.
Gift cards has one row per card: its value, what’s left, and what you owe. Gift card activity has one row per event.
1

Open the report

In the sidebar’s Operations tab, click Reports (under Dashboard; it needs the Reports feature), choose Payments, then pick the Gift cards or Gift card activity tab. They come after Payment allocations, Settlements and Settlement reconciliation.
2

Set the dates and filters

Adjust the date range, use Search, or select Filters. Filters open in a side sheet, apply as you change them, and have Clear all and Done. A “Filtering by:” line names what is active.
3

Export

Select Export, choose CSV or Excel and the columns, then select Download. The file follows the filters and sort.
On a phone the rows show as cards, with a Table and Cards toggle. See How do I run, filter, and export business reports?

The Gift cards report

The range is Issued date from and Issued date to. Columns. Card, Card ID, Holder and Purchaser (each opens the guardian’s profile), Source, Issued By, Note, Initial, Remaining, Redeemed, Scope, Status and Issued, newest first. A bar chart shows Issued Value by source. Tying out. With no Status, Source, Issued By or Staff Note filter, Outstanding Liability equals Outstanding value on Financials > Gift Cards. If they disagree, select Clear all in Filters.

The Gift card activity report

The range is Activity date from and Activity date to. Columns. Card (opens the card’s panel on Financials > Gift Cards), Card ID, Type, Amount, Balance After, Invoice # (opens the invoice), Actor and Date, newest first. Card IDs show only the last four digits. Given back as money. A balance given back is filed under Adjusted in the filter, but its Type reads Given back as cash, Given back by cheque or Given back by Interac e-transfer (check and e-transfer outside Canada). Undoing it adds a plain Adjusted row. Corrected give-backs. A Financial admin can use Correct in the card’s History to reverse a give-back. When the money goes onto the card or its replacement card, the report shows a plain Adjusted row. Give-back corrected appears only in History. If the card was cancelled outright, the money goes onto the holder’s account credit and this report gets no row. Replacing a lost card. Replacing a lost card adds a Moved to a new card row on the old card and an Issued row on the new one. Total Issued counts the moved value again. Who shows as Actor. Staff who apply a card through Take payment are named on the Redeemed row.

Limits and the ledger

Row limit. When a report has more rows than it can load, a “This report hit its row limit” banner appears. Narrow the date range or filters. On Gift cards, all four tiles then show Partial, and the table and chart cover only the rows loaded. Outstanding Liability still adds up every matching card. On the ledger. In the ledger reports (Reports > Ledger, tabs General ledger and GL by account), a gift card sale credits the account set as Gift cards not yet spent, and spending shows as a “Gift card spent” debit. They also show comps, balance adjustments, cards carried over from Uplifter 1.0, the write-off when you cancel a card, refunds returned to a card, balances moved to a new card, balances given back as money, and corrections of a give-back (described as “given back” and “corrected”). Refunds and chargebacks. The ledger reports take each refund or chargeback off the sale’s revenue on the day it settled, whatever month the sale was in. A refund returned to a gift card therefore shows both the card’s credit back to the liability account and that revenue debit. Other automatic postings are not in these reports. Each entry is explained in How do gift cards show up in my ledger? Related: How do I see gift-card balances and reconcile my outstanding liability? · How do gift cards show up in my ledger? · How do I run, filter, and export business reports? · Which reports are available?