Skip to main content

What Reports are available in the Report Center?

This article contains an overview of every report and a link to the details and definitions of every report.

Updated over 2 months ago

Overview

  • This article is an index/guide to all reports that exist.

  • Reports are available in either summary or detail view. By design, some reports are available in either format, summary only, or detail only.

    • Detail reports show each individual transaction; they include individual card numbers

    • Summary reports show totals only

Before You Start

Depending on your organization's setup, or your user permissions, you may not see every report listed here. If you need access to a report, please contact your Paytronix administrator.

A card number is the unique identifier for an account. Both physical and digital accounts will have a card number. Depending on the type of report you run, the card number field will include different types of cards. For example, for Stored Value reports, the card numbers included in the report may be both physical gift cards and eGift cards depending on which report you run.


Navigating the Report Center

  • On the main Report Center page, the reports are grouped first by category (Stored Value, Loyalty, etc.), and then by Key Reports (most commonly used), and then Other Reports.

  • If there is a report you run frequently, you can bookmark it by clicking on the icon to the right of the summary or detail link. This creates a link to the report at the top of the page, under "Bookmarks"

Report Center bookmarks

  • Once you click SUBMIT, you do not need to wait on the report‘s page for a report to finish running. You will be notified when the report is ready for download. You can also access it from the Report History page (see below).

  • Some reports may be delayed by up to 45 minutes. For those impacted reports, you should see an informational box on screen the individual report page like this:

Report delay informational box
  • Once the report is ready, you can download it any of these formats:

    • HTML

    • CSV

    • TSV

    • Excel XLS

    • Excel XLSX

  • Reports are available for 2 days after you run them. You can find them on the Report History page:

Report history page


Note: You can delete any report from the Report History page by clicking on the red X.

Here's what the different statuses mean:

  • Active: The report is still running and is not available for download yet.

  • Succeeded: The report has finished running and is available for download.

  • Succeeded (bold type): The report is available, but you have not yet viewed the results.

  • Succeeded (grey text color): The report was viewed, but is no longer available.

  • Succeeded (grey text color, bold type): The report was never viewed and is no longer available.

Please note that Paytronix reporting queues are not shared by all clients but are separated based on each client's assigned database. Most clients will share a reporting queue with other clients.


General Reports

General reports are used by all Paytronix merchants regardless of the program they are running. These reports transcend the kind of program being run, and can help to glean information about your program.

Please click on the “Summary” or “Detail” link next to the report title to get more information about it.

Key Reports

Card Activity

Card Activity Detail Report

  • This report is helpful to pinpoint a certain card’s transactions, examining all activity for your merchant over a single day, checking a card with what looks like suspicious activity, and checking how many balance inquiries are done over the course of a single day.

Guest Analysis

Guest Analysis Detail Report

  • Guest Analysis is a tool that you can use to segment your guest base. If it is typical for your guests to register cards, there are many more options available to segment against, since in the course of registration, the guest will provide some demographic information which can then be queried against.

  • For example, if you want to find all people who have not used their card in the past 60 days so you can send them a reminder e-mail, this report would be the one for you!

Survey Response Report

Survey Response Detail Report

  • This report enables users to extract raw responses and respondent demographic information from an individual survey over a specific time period. Users can export rule and campaign-based survey responses via this report.

Web Registration

Web Registration Summary Report

  • Shows the numbers and percentages of cards that have been activated (enrolled), and/or registered.

  • Useful for determining which stores have the best registration rates.

  • You may use the information in this report to reward the stores with the best registration rates and help identify stores that may need to improve.

Other Reports

Campaign Email Open Detail Report

Campaign Open Detail Report

  • This is a report of campaign emails opened.

  • This report shows campaign emails that were opened over a specific date range. This is generally for offsite data warehousing.

Campaign Report

Campaign Summary Report

  • Report of Eat-Thru℠ Statistics on all campaign occurrences over the date range selected.

  • You can easily view all Eat-Thru℠ Statistics for all campaign occurrences over the specified date range to show results -- including open rates, unique guests, visits and dollars spent.

Card Orders

Card Orders Detail Report

  • This report shows all of the card orders within the given time period. If this report is run for a parent merchant, then all child merchant orders of the parent will be reported.

Cards Issued by Cashier

Cards Issued by Cashier Detail Report

  • This report shows cards issued and registrations for stores, card templates, and cashiers.

  • This report is typically used to identify top performing cashiers and/or stores in contests.

CSR Wallet Adjustment

CSR Wallet Adjustment Detail Report

  • Report of CSR-originated transactions which affected wallet balances.

  • Report shows individual card activity over a specific date range to identify possible fraud, system errors or interesting usage trends.

Exchanged Cards

Exchanged Cards Detail Report

  • Gives you the ability to view all media exchange transactions by store or card number over a specific date range.

  • Helps you to correlate current card numbers with exchanged card numbers.

Manager Card Activity

Manager Card Activity Detail Report

  • This report is useful if you are running an employee card program, where employees are able to use a special card for meals at your restaurants.

  • This report shows all of the transactions, including reloads and redemptions. It also includes the card holder‘s name for reference.

Mobile Payment Detail

Mobile Payment Detail Report

  • This is a report of all mobile payments.

  • This report shows all successful mobile payments over a specific date range, and optionally by a specific store or store group or for a particular card.

Web Order Fulfillment

Web Order Fulfillment Detail Report

  • This report shows web sale fulfillment activities over a specific date range, by web sale program.

  • Shows all fulfillment information, including customer name and contact information.


Stored Value / Gift Card Reports

Stored Value / Gift Card reports are useful for reconciling and accounting for gift card purchases, redemptions and liability.

Please click on the “Summary” or “Detail” link next to the report title to get more information about it.

Key Reports

Stored Value Overview

Stored Value Overview Report Summary Report

  • Shows a summary of gift card activity

  • Good for giving you a “big picture” look at your Stored Value activity

Stored Value Reconciliation

Stored Value Reconciliation Summary Report

Stored Value Reconciliation Detail Report

  • Use these reports to compare the Paytronix and point of sale reports of stored value (gift card) transactions.

  • The amounts added and redeemed at the POS should match those in these reports.

  • For an overview, look at the Summary report. For a listing of each transaction, look at the Detail report.

Redemption

Redemption Summary Report

Redemption Detail Report

  • Show all redemption activity for the time defined when running the report.

  • Help to identify redemption rates by store.

Sales and Added Value

Sales and Added Value Summary Report

Sales and Added Value Detail Report

  • Show all sales (card activation) and added value (cards that were already active and had money added to them) totals.

Other Reports

Card Expiration

Card Expiration Summary Report

Card Expiration Detail Report

  • This is used by merchants that have automated expiration/escheatment/exemption configured.

  • Report gives information by geographic state as to the total amount written off over a given period.

  • This report may be used as part of the preparation of escheatment filings to a particular state.

Dormancy

Dormancy Summary Report

Dormancy Detail Report

  • For merchants with Dormancy Fees configured. If Dormancy is not configured, there will be no values in the report output.

  • Shows a summary of all dormancy transactions over the date range given.

Liability Aging By Card Template

Liability Aging by Card Template Report

  • Shows the age of your gift card liability, by card templates.

  • Helpful in determining breakage and tax liability.

Liability Aging By Store

Liability Aging By Store Summary Report

  • Shows the age of your gift card liability, by store of activation.

  • Helpful in determining breakage and tax liability.

Liability By Card

Liability by Card Detail Report

  • Shows ALL non-zero gift (stored value) cards and the liability associated with them.

  • Sorted by store

  • Designed to help with assessing the dollar liability associated with unredeemed stored-value (gift) cards.

Liability Summarized by Card Template

Liability Summarized by Card Template Summary Report

  • Shows the total amount of outstanding gift card balances, summarized by card templates.

  • Assists you in assessing the dollar liability associated with unredeemed gift (stored value) dollars.

Liability Summarized by Store

Liability Summarized by Store Report

  • Shows the total amount of outstanding gift card balances, summarized by store.

  • Assists you in assessing the dollar liability associated with unredeemed gift (stored value) dollars.

Money Movement ACH by Account

Money Movement ACH by Account

  • Only used by merchants who have contracted with Paytronix to do periodic money movement to settle funds for gift card sales and redemptions across different business entities.

  • Determine amount of money debited or credited from each ACH (Automated Clearing House) or Credit Memo account.

  • Shows each account‘s number and routing number.

Money Movement ACH by Account NACHA

Money Movement ACH by Account NACHA Summary Report

  • Gives corporate users information on the amount of funds to be transferred (either debited or credited) through Money Movement model on the following business day.

  • Report shows net change in stored value liability on a per store basis to facilitate the transfer of funds in both directions between franchise-owned stores and corporate.

  • This report is structured to work for Centralized or Decentralized Money Movement. In centralized operation the corporate accounts holds the float of activated stored value cards until they are redeemed. In decentralized operation the stores (franchisees) hold the float of activated stored value cards until they are redeemed.

  • This report relies on settings in the Money Movement Configuration. Absent these settings, you can still use the Stored Value Money Movement reports.

  • This report nets out stored value discounts, providing the net amount for money movement.

  • This report sums all stored value transactions that have no promotion. Transactions with a promotion are ignored for the purposes of this report.

Money Movement ACH by Store

Money Movement ACH by Store Summary Report

  • Only used by merchants who have contracted with Paytronix to do periodic money movement to settle funds for gift card sales and redemptions across different business entities.

  • Shows all debits and credits for each store’s billing account.

  • Includes account information for each store.

Money Movement by Store

Money Movement by Store Summary Report

Money Movement by Store Detail Report

  • Shows how money related to gift card liability has traveled between locations.

New Card Activation

Stored Value New Card Activation Summary Report

  • Shows total number of cards activated, by store.

  • Shows total amount activated on Stored Value (Gift) cards.

  • Includes comp and loyalty card activations (in the card counts), but only displays amounts added to Stored Value wallets at the time of the card activation.

  • In many cases, the Sales and Added Value Summary and/or the Sales and Added Value Detail reports may be more useful for getting the required information.

Redemption Profile

Redemption Profile Summary Report

Store Activity

Stored Value Store Activity Detail Report

  • Shows all stored value transactions for each store for a user-defined period of time.

  • Many other stored value reports can be used in place of this report (and may be more useful), including the Reconciliation Detail, Redemption Detail and Sales and Added Value Detail reports.

  • Some merchants use this report as a daily data feed into a system/data warehouse and have it run and delivered on a schedule.

Stored Value Instant Payments

Stored Value Instant Payments Summary Report

Stored Value Instant Payments Detail Report

  • Shows information on transactions using the Instant Payments feature

  • Currently available only for Revel POS users

  • Read more about Instant Payments.

Web Card Sales

Web Card Sales Summary Report

Web Card Sales Detail Report

  • Shows total number of orders and credit card charges for your Web Card Sales program.

Web Guest Recharge

Web Guest Recharge Detail Report

  • Shows all web recharges (both auto recharges and one-time recharges) of gift cards by guests.

  • Use to balance what you received from credit card transactions.


Loyalty / Comp Reports

Loyalty reports are useful for segmenting guests, getting information about your guests’ behavior and gauging the success of your program.

Please click on the “Summary” or “Detail” link next to the report title to get more information about it.

Key Reports

Coupons Report

Coupons Summary Report

Coupons Detail Report

  • Choose from either a summary or detail report of coupon redemptions.

  • This report shows the number of successful coupon redemptions over a specified date range, for each coupon.

Loyalty Overview

Loyalty Overview Summary Report

  • Shows a “big picture” of your loyalty program‘s status

  • Includes number of new enrollees, number of registrations and percentage of registered accounts that have opted-in

  • Includes totals for guest spending, number of visits and number of points accrued as well as the number of rewards accrued and redeemed

Loyalty New Card Activation

Loyalty New Card Activation Summary Report

Loyalty New Card Activation Detail Report

  • Report of all loyalty and comp card enrollments (activations).

  • Allows you to identify store’s rates and types of enrollments.

Point Accrual

Point Accrual Summary Report

Point Accrual Detail Report

  • Shows total point accruals for the period for which the report is run

  • Displays totals for all add and internal wallets

  • Helps to determine effectiveness of your loyalty program by showing total volume

Reward Accrual

Reward Accrual Summary Report

Reward Accrual Detail Report Report

  • Shows all reward accruals done. (A reward accrual is defined as when a reward wallet is added to.)

  • Helps you determine the amount of rewards given to your guests.

  • Additions to comp cards show up in this report.

  • Can be sorted by store, tier, and reward type (wallet label) over a specific date range.

Reward Redemption

Reward Redemption Summary Report

Reward Redemption Detail Report

  • This report shows all redemption activity on rewards wallets.

  • Rewards wallets include “bonus” or “rewards” dollars wallets. It will NOT include redemptions of stored value.

  • Comp card redemptions are included in this report.

RFM - Guest Segmentation

RFM Guest Segmentation Summary Report

  • Helps you to identify trends in guest behavior

  • Reports on guests divided up into five equal groups or by visit rate.

  • Shows average visits, spending, and registration rates.

RFM - Store Frequency

RFM Store Frequency

  • Shows each location’s guest activity including number of guests and average amount spent

  • Helps determine high and low performing locations

Other Reports

Reward Liability

Reward Liability Summary Report

  • Gives outstanding liability for all reward/point/comp wallets by tier.

Top Randomized Customers Weighed by Activity

Top Randomized Customers Weighed by Activity Detail Report

  • This report helps pick a set of customers based on random numbers (weighted by activity on a specified Wallet).

  • You can include all active cards within a card template of your choosing and give each of them a base number of credits for a no purchase necessary inclusion in a contest.

  • You can also pick a date range over which Wallet activity is summed and multiplied so that you can encourage guests to visit more frequently, or buy a specific product category (for multiple entries in the contest).

  • After the total number of credits are calculated for each eligible guest, a random number is calculated and used to pick contest winners in order. The output report shows the order in which contest winners were picked.

  • Before you use this report, you must clear contests and sweepstakes with your legal department. Individual states have laws relating to: eligibility, guest notification, contest rules, weighting, sales tax, etc.

Transactions from Scheduled Periodic Rules

Transactions from Scheduled Periodic Rules Detail Report

  • Report of accruals/redemptions performed via a scheduled periodic rule.

  • This report shows all accruals/redemptions for the most recent execution of a scheduled periodic rule. This provides information that can be used for various purposes, such as bulk mailing to recipients of birthday rewards.

Web Reward Redemptions

Web Redemptions Summary Report

Web Redemptions Detail Report

  • If you use a Bankable Points loyalty program (e.g. "Reward Yourself"), this report captures the summary version of point redemption in exchange for rewards.


Fraud Detection Reports

Fraud detection reports help you to find suspicious behavior for gift card and loyalty card programs. Please click on the “Summary” or “Detail” link next to the report title to get more information about it.

Key Reports

High Point Accrual Activity

High Point Accrual Activity Summary Report

  • Shows loyalty cards that have high levels of activity, which may indicate fraudulent use.

  • Note that this report only provides guidance, the cards identified are not always being used fraudulently.

  • This report is trying to identify suspicious activity based on three potentially fraudulent uses of loyalty cards.

Suspicious Redemption Activity

Suspicious Redemption Activity Summary Report

  • Detects stored value (gift) cards that may have fraudulent activity on them

  • Note that this report only provides guidance, the cards identified are not always being used fraudulently.

  • This report is trying to identify suspicious activity based on three potentially fraudulent uses of gift cards.

Other Reports

Cashier Activity

Cashier Activity Summary Report

Cashier Activity Detail Report

  • Reports all of cashier activity.

  • You can track and analyze cashier activity over a specific date range and by card number.

Combined Cards

Combined Cards Detail Report

  • Report shows cards with a combine card event withiin a certain period.

  • Helps users (typically corporate office) to identify cards that were combined during a certain period, which may indicate fraudulent use

Stored and Forwarded Transaction

Stored and Forwarded Transaction Detail Report

  • Shows transactions that happened in Store and Forward mode, which may indicate fraud.

Void

Void Report

  • Reports all of voids associated with stored-value cards (gift cards).

  • You can see all the voids that occurred on a per store basis, by the void type.


Billing/Franchisee Reports

Billing

Billing Summary Report

Billing ACH

Billing ACH Summary Report

Billing ACH NACHA

Billing ACH NACHA Summary Report

Transaction Accounting

Transaction Accounting Summary Report

Transaction Accounting Detail Report

  • Report provides information on transaction account.

  • Gives information on the transaction counts by transaction type. Information is used for monitoring volume/activity across stores, and to aid in accounting


Charge Reports

Shows all transactions by cards that have a Charge wallet and rule attached to them.

Please click on the “Summary” or “Detail” link next to the report title to get more information about it.

Charge Customers

Charge Customers Report

  • Reports all of registered users by registration date.

  • Allows you to verify registered customers' information.

Charge Reconciliation

Charge Reconciliation Summary Report

  • Identifies in-house charges by location.

  • You can compare the Paytronix and point of sale reports to identify discrepancies in information on in-house charges.

In-house Charge

Charge In House Charge Summary Report

Charge In House Charge Detail Report

  • Reports all in-house charge related activity by store.

  • You can view all in-house charges by store over a specific date range. The information outputted can be used for billing purposes.


Variance Reconciliation Reports

These reports are useful for reconciling gift cards.

Please click on the “Summary” or “Detail” link next to the report title to get more information about it.

Reversed Transaction

Reversed Transaction Detail Report

  • Will output all discrepancies between the point of sale system and the Paytronix server which have been reconciled by reversing the discrepant transaction.

  • Will include all store codes in the report which can help track account adjustments made based on the transaction variance.

Transaction Variance

Transaction Variance Detail Report

  • Reports all discrepancies between the point of sale system and the Paytronix server.

  • You can view the different store codes in the report to identify any of these discrepancies.

  • This will help you identify potential training and software issues.


System Reports

Long Transactions

Long Transactions Summary Report

  • Report shows long transactions

Long Transactions by Hour

Long Transactions by Hour Summary Report

  • Report shows long transactions by hour of day

Did this answer your question?