Exporting Reserve Activity Data

You can export data on Reserve Activity from the Reconciliation Dashboard. The data is listed by date and exported to a Microsoft Excel file. If the option to export is available, a Microsoft Excel file icon () appears next to the values in the Reserve Activity column of the following data panels:

To export Reserve Activity data from the Reconciliation Dashboard:

From the iQ Bar, click the Financial icon and select Reconciliation Dashboard from the list of available reports, or from the Financial Navigation bar.
Select the desired view, either by Settlement Date or Activity Date.
Specify the desired Date, Reporting Group, and Currency and click View to refresh the page.
Click the Microsoft Excel file icon () next to a value in the Reserve Activity column. Depending on your browser, the File Download dialog box appears.
Choose an option as follows:
- Open - opens the report in Microsoft Excel file.
- Save - saves the file to your computer.
- Cancel

The data listed in the table below are included in the file.

See Notes on Microsoft Excel for information on the presentation of certain data fields in exported files.

Reserve Activity Export Report Field Descriptions
Field	Description
Transfer Date	The date of the transfer of funds to/from your organization’s reserve account as determined by adjustments made for the sales and refund activity.
Activity Date	The date that the financial transaction took place. The financial transaction can be either a sale or a refund.
Sales	The amount of money your organization charged customers by means of sale transactions.
Refunds	The amount of money your organization returned to customers by means of refund transactions. This column displays only if the reserve funding method on the billing profile has been configured for refunds.
Target Reserve Percent	The percentage of reserve period sales and refunds kept in your organization’s reserve account, which is configured as specified in your merchant agreement.
Target Reserve Period Length	The number of days of sales and refunds that affect the reserve account, as specified in your merchant agreement.
Start Reserve Period	The earliest date in the reserve period date range.
End Reserve Period	The latest date in the reserve period date range.
Reserve Period Sales	The amount of money your organization charged customers during the specified reserve period.
Reserve Period Refunds	The amount of money your organization returned to customers during the specified reserve period, if applicable. This column displays only if your account is configured for refunds.
Target Reserve Balance	The target amount for your organization’s reserve account, which is calculated based on the sales and refund activity occurring during the specified reserve period.
Starting Reserve Balance	The amount of money present in your organization’s reserve account before the reserve adjustment takes place for the specified activity date.
Miscellaneous Reserve Adjustment	The amount manually credited to or debited from your organization’s reserve account by our Finance Department.
Auto Reserve Adjustment	The amount of money automatically adjusted by the system to the Starting Reserve Balance to bring your organization’s reserve account balance to the Target Reserve Balance. This amount is calculated based on data in the following fields: Sales, Refunds, Starting Reserve Balance, Target Reserve %, and Target Reserve Balance.
Total Reserve Adjustment	Total of the Miscellaneous Reserve Adjustment and Auto Reserve Adjustment columns.
Ending Reserve Balance	The amount of money present in your organization’s reserve account after the reserve adjustment takes place.