Skip to main content

Stored Value Reconciliation Summary

Use this report to compare the Paytronix and point of sale reports of stored value (gift card) transactions

Updated over 2 months ago

If you do not see this report in your Report Center, you do not currently have permission to run it. If you feel that this report could be useful for you, but it doesn’t appear on your list, please contact your user administrator for assistance.

IS THIS REPORT RIGHT FOR ME?

Uses

* Use this report 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 this report.

* If the amounts do not match, please use the Stored Value Reconciliation Detail report to identify individual transactions that may be causing the discrepancy.

Restrictions

Can only do one of the following:
* Run for up to 100 days for all stores.
* Run for all days for one store.

SAMPLE OUTPUT
Reconciliation Summary - One Store, Unlimited Days

User-added image



Reconciliation Summary - All Stores, Limited Days

User-added image

HOW DO I INTERPRET THIS REPORT?

Interpretation Summary

This report has two sections, both Net Summary and Summary Information. The Net Summary information combines the add/redeem transactions and void add/redeem transactions to arrive at a net amount. The Summary information shows both the add/redeem and void add/redeem transactions. There is a preview available for this report, but you may find it easier to view by downloading in Excel. You will notice that there are several Activity Types in this report. Each activity will either add value to or remove value from a card. To see a total of what‘s been added or taken away, look at the Total Amount column. You can also see the number of transactions (in the # Txns column) and finally, a Net Amount in the last column. Please note that the column for “Non-POS Amounts”includes all transactions not done at the POS. These include web, IVR (phone system adjustments), CSR (customer service adjustments) and other non-pos activities.

Column Name

Definition

Store Number

The Paytronix number for the store where the transaction took place

Store Name

The Paytronix name for the store where the transaction took place

Net Activity Type

The type of pos transaction that took place.

Rule Name

The Paytronix rule that adjusted the card; see: What are Rules and Wallets?

#Txns

The number of transactions that took place

POS Amounts

The amount that was added or redeemed through the POS

Non-POS Amounts

The amount that was added or redeemed not through the POS

Total Amount

POS amounts plus non-POS amounts

Discount Amount

The amount of stored value discount that was added or redeemed; click Stored Value Discounts for more information on stored value discounts.

Net Amount

POS and non-pos transactions plus or minus any discounts added or redeemed

I LIKE IT, SO HOW DO I RUN THIS REPORT?

User-added image

  1. First enter the date range for which you’d like to run the report. The report can be run for unlimited days for one store or for up to 100 days for all stores.

    • Quick Date: Here you can choose Yesterday, Today, the current month, or last month. If you have set up by your custom fiscal periods, you may also choose to run the report by fiscal period.

    • Manual Date Entry: Here you can type in your desired date range or find the day by clicking on the calendar icon to the right.

  2. Check the “All” box if you would like to include all stores. You can also enter a specific store code to see one store or select a store group from the drop down box.

  3. Click Submit!

Did this answer your question?