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.
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.
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.