Exporting a Report

iQ provides the ability to export most reports to Microsoft Excel (as a CSV file) for further analysis.

To export a report:

  1. Open the desired report, as described in Opening a Report.

  2. Click the Excel icon () at the top of the report. A dialog box prompts you to specify whether you want to save the data or open the file in Microsoft Excel.

  3. Choose an option as follows:

    • Save to Disk - saves the file to your computer.

    • Open the File - opens the report in an Excel spreadsheet, as shown below.

    • Cancel

Report Opened in Microsoft Excel

The exported data includes the contents of the summary panel and each of the tabs from the granular frame of the report. The Settlement Report tab corresponds to the summary panel data and the By Reporting Group, By Settlement Date, By Payment Method, and By Purchase Currency spreadsheet tabs correspond to the granular tabs of the same name.

Exporting Transaction-Level Data

Additionally, you can export daily transaction-level data from various reports to CSV-format or Microsoft Excel files. In most cases, the transaction-level data in these reports is available for the previous 24 months only. See the following sections for additional information:

Notes on Microsoft Excel

Due to certain limitations, data in some cells may not appear as expected when the exported CSV file is viewed in Microsoft Excel:

  • 15-Digit Limitation - you may notice that the values in certain columns are preceded by a single quote character (‘) when opened as a Microsoft Excel file. Excel has a limitation whereby a column that contains a number greater than 15 digits in length is truncated. When the column is viewed as a number, Excel replaces the trailing digits with zeros, resulting in an invalid value.

    To address this, we have preceded each impacted column with a single quote in the exported report.This ensures that Excel interprets the information as text and displays the values accordingly. To remove all of the single quotations, simply apply the following formula to each affected columns:

    "=MID(B1, 2, LEN(B1))

  • Leading Zeros Removed - you may also notice that the Account Suffix column includes a one, two, or three-digit value. This occurs when the account suffix contains leading zeros. For example, if the suffix is ‘0021,’ the value is displayed as ‘21.’ Excel treats the suffix as a numeric value and removes the leading zeros.