Reference the article below for more information on how to utilize this report to reconcile funding request invoices from Awardco for the redemption account. This report is useful if your invoicing method is based on points awarded. Click here for a downloaded sample report.
Data Filters
To access this report:
- Access “Admin Settings”
- Click on the “Reports” tab at the top of the screen.
- Find the “Funding Reconciliation” report on the “Featured” tab
- Click “Open”
Before running the report, we’ll need to select data filters. Select as many as you’d like to narrow down exactly what you need. These are optional; for any filter that is not selected the report will assume a “Select All” option. The following filters are available:
- Time Frame: Select the time frame from which you’d like the report to pull data. Select an option from the list of default periods or specify a custom date range. Use the drop-down menu to the right to pull the report in your preferred time zone. UTC is recommended for reconciliation with funding request invoices.
- Initiator
- Initiator Employee Id
- Transaction Type
- Country Code
- Currency
If you plan on exporting the Funding Reconciliation report, use the drop-down menu on the right to select columns that will appear on your exported .csv file. The column options are as follows:
| Header | Example | Description |
| DATE* | 2/5/2023 6:06:26 AM | MM/DD/YYYY and time of transaction. |
| INITIATOR* | Josh Smith | User initiating the addition or removal of points to another user’s wallet. |
| INITIATOR EMPLOYEE ID* | 78943 | Employee Id of the user initiating the addition or removal of points to another user’s wallet. |
| EMPLOYEE* | Dan Anderson | Full name of the user whose wallet balance is being adjusted. |
| EMPLOYEE ID* | 78944 | Employee Id of the user whose point balance is being adjusted. |
| COUNTRY CODE* | US | ISO 2 letter country code associated with the employee |
| POINT AMOUNT* | 100 | Point amount being added or taken away from the employee’s wallet balance. |
| BASE AMOUNT* | 100 | The value of the points being added or taken away from the employee’s wallet balance, in the platform’s base currency. |
| BASE CURRENCY* | USD | Currency code of the platform's base currency. |
| INITIATOR SUPERVISOR | Martha Watson | Supervisor of the user initiating the addition or removal of points to another user’s wallet. |
| BUDGET | Company | The budget from which the points came. |
| EMPLOYEE SUPERVISOR | Chris Alexander | Supervisor of the user whose point balance is being adjusted. |
| TRANSACTION TYPE | Recognition |
The way points move in or out of a user’s wallet. Possible values:
|
| WALLET BALANCE | 100 | The total balance of the employee’s wallet after the event of the transaction. |
| RECOGNITION PROGRAM | Peer to Peer | The recognition program from which points were awarded. |
| RECOGNITION ID | 58488331 | An Id assigned to the recognition by the platform. |
| COST CENTER ID | CO-491 | An Id assigned to the cost center. |
| COST CENTER NAME | Company 491 | Name assigned to the cost center. |
| INITIATOR META: [value] | Department: Marketing | Metadata value applying to the user initiating the addition or removal of points to another user’s wallet. |
| Employee META: [value] | Job Title: Marketing Manager | Metadata value applying to the user whose point balance is being adjusted. |
*If no column specifications are applied, these columns will load by default.
Once you’ve selected your preferred filters, select “Run the Report” to display the data. If you’d like to export the data in a .csv format, select “Export”. If you’d like to save these search parameters, select “Save View” and enter a name for your saved view. The next time you access the Funding Reconciliation report you can access this saved view in the drop-down menu at the top right. If you “star” or favorite a saved view, it will be the default report that loads first and runs automatically. If you'd like a saved view to be sent to your email on a regular cadence, please visit our Sending Scheduled Reports article to find out more on how to configure this option.
Total Transactions & Total Base Amount
The two figures below the data filters display Total Transactions and Total Base Amount. The Total Transactions reflect the number of transactions, or the movement of points in or out of a user’s wallet, during the filtered time period. The Total Base Amount is the value of the transactions in the platform’s base currency.
Exporting Charts and Graphs
If you'd like to export any chart, graph, or data visualization as a single PNG image, click on the circular icon at the top right of any graph.
Source Data
At the bottom of the page is the raw data from the filters applied. If you were to export the report to a .csv/JSON file, this is the same format you would find. Use the search bar to search for keywords such as initiator names, employee names, and transaction types. Click here for a sample report.
If you have any questions, please contact Awardco Admin Support.