Reward & Recognition - Tracking Your Recognition Budget With SmartInsights Reports

Introduction

Can a recognition budget be tracked with SmartInsights Reports? The answer is, yes, it can be! This article explains how this can be done, who can access recognition reports, and the different types of reports that can be used for this purpose.

How Clients Can Track the Movements of Funds in Their Recognition Budgets

Clients can access three reports about transactions and budget movements in Reward Manager. 

• R201 - Top Up Report
• R605 - Pot Names, Owners and Balances for InstantAwards™
• R609 - Transaction Summary Report

How Recognition Reports Are Accessed and Who Can Access Them

Everyone with Reports Viewer access in Reward Manager will be able to see and download these reports. If you would like to give this access to anyone in your organization, contact your Client Success Manager or the Client Support team.

Once logged in to Reward Manager, users with Reports Viewer access can follow the steps below to see the reports:

1. Select Smart Products on the Reward Manager left hand menu
2. Select the SmartInsights™ option within Smart Products
3. Select the Reporting option within SmartInsights™
4. Enter a specific report name in the "Search by report name" bar at the top left of the page, or select RewardRecognition in the "Search by product" dropdown at the top right to see all reports relevant to Recognition (including nominations)

All reports can be displayed directly on the screen, or downloaded as a .xlsx file.

Read on to find out more about the information included in each report.

R201 - Top Up Report

• Information included: This report shows money transferred from the client’s main R&R budget to individual recognition programmes.
• Report can be filtered by:
  • Time period (users can pull the report for one or more months)
• The final report includes:
  • Top up date (date the money was transferred out of the main budget)
  • Transaction value - transactions can include:
    • Top ups to programs that have a dedicated budget in Reward Manager
    • Awards sent from programs that draw funds directly from the main budget
  • Program name - the name of the program the funds are transferred to
  • Program type - this could be one of:
    • Instant Awards
    • Nomination (AwardNominator™)
    • Upload (AwardFilePlus™)
    • BulkSchedule (Scheduled Recognition)

R605 - Pot Names, Owners, and Balances for InstantAwards and Nominations

• Information included: This report lists all of the manager budgets for the client’s InstantAwards™ programs, and their balances at the time of viewing the report. R605 is not built to provide a breakdown of top-ups, balance changes or changes in pot owners over a period of time.
• Report can be filtered by:
  • InstantAwards™ or Nominations programs
• The final report includes:
  • R&R Scheme Name - the client's main R&R budget, which funds all InstantAwards/Nomination programs
  • R&R Client Balance - the amount in the client's main R&R budget at the time of viewing the report. This balance can be used to fund the client's InstantAwards/Nomination programs
  • Programme name - the name of one of the client's InstantAwards/Nomination programs
  • Budget owner(s) payroll number - the employee IDs of all the members appointed as Main Budget Owners for the InstantAwards™ program
  • Budget owner(s) name - the names of all the members appointed as Main Budget Owners for the InstantAwards™ program
  • Programme balance - the main pot balance for the InstantAwards/Nomination programs at the time of viewing the report. This balance can be used to send awards, or fund the manager pots within the program
  • Manager pot name - the name of one of the manager pots within the InstantAwards™ program. On the row detailing the program's main pot balance, this cell will be empty
  • Manager Pot Owner(s) payroll number - the employee IDs of all the members appointed as owners of the manager pot. On the row detailing the program's main pot balance, this cell will be empty
  • Manager Pot Owner(s) name - the names of all the members appointed as owners of the manager pot. On the row detailing the program's main pot balance, this cell will be empty
  • Manager Pot Balance - the balance for the manager pot at the time of viewing the report. This balance can be used to send awards. On the row detailing the program's main pot balance, this cell will be empty

R609 - Transaction Summary Report

• Information included: This report shows the opening and closing balance of each of the client’s R&R programmes, within a period of time selected by the client. It also shows the transactions (top ups / awards sent / cancellations) that have contributed to calculating the balance.
• Report can be filtered by:
  • Time period (specific start and end date)
• The final report includes:
  • Opening Balance (on the selected start date)
    • The client's main recognition budget is included
    • All of the client's recognition programs (InstantAwards™, AwardNominator™, AwardFilePlus™, Scheduled Recognition) are included
      • Programs that draw funds directly from the main budget will always appear with 0 opening balance
    • Manager pots that sit within InstantAwards programs are included
  • Transactions (between the selected start date and selected end date)
    • Only programs and pots with transactions recorded within the time period will be included.
    • This may include programs and pots that have been deleted at a later stage, if they had transactions recorded within the time period
    • Manager pots that sit within InstantAwards™ programs may be included, if they had transactions recorded within the time period
    • Transactions can include:
      • Gross additions, for example:
        • Funds added to the client's main budget, following an invoice payment
        • Funds that moved to a recognition program (AwardNominator™, AwardFilePlus™, Scheduled Recognition) from the main budget.
          • This can happen either to top up a program's dedicated budget, or because awards are being sent with funds drawn directly from the main budget
        • Funds added to a manager pot from the InstantAwards™ main pot
        • Negative numbers in the Gross additions column indicate funds that have been moved back to their source (e.g. the client's main recognition budget; an InstantAwards™ program; or the client, in case they request a refund of money sitting in their main budget)
      • Gross sum of awards refunded
        • This is the total sum of awards that have been cancelled within the time period, and returned to the program or pot they were sent from
      • Gross sum of awards sent
        • This is the total sum of awards that have been sent within the time period
  • Closing Balance (on the selected end date)
    • The client's main recognition budget is included
    • All of the client's recognition programs (InstantAwards™, AwardNominator™, AwardFilePlus™, Scheduled Recognition) are included
      • Programs that draw funds directly from the main budget will always appear with 0 closing balance.
        • Even though the Transactions section shows a breakdown of transactions for each of these programs, the movements of funds these transactions create will always be reflected in the main budget's closing balance
    • Manager pots that sit within InstantAwards™ programs are not included

Frequently Asked Questions

Can Reward Gateway customize these reports on a client-by-client basis?

Are there any other breakdowns of transactions clients can access?

Why is one of the reports timing out?