# Quarterly Mastercard Report The Quarterly Mastercard Report (QMR) contains operational metrics that you must send to Mastercard every quarter. It covers: - The quarter date range, your Interbank Card Association (ICA) number, and the report currency - The counts and volumes for cleared purchases and refunds/returns/credits (as a group), and their location in relation to the merchant - How many accounts and cards you have, how many you created, suspended, and revoked during the quarter, and how many made at least one transaction - The number of virtual prepaid cards you have, and their transaction count and volume > **Information** > > This report is for [processing-only clients](https://www.checkout.com/docs/card-issuing/set-up-card-program.md#Processing-only_clients). --- ## Report availability The report data is refreshed twice daily at around 12:30 AM and 10:30 AM, in UTC. See instructions on how to download the report on demand or on a schedule [in the Dashboard](https://www.checkout.com/docs/business-operations/retrieve-reports.md#Generate_reports_in_the_Dashboard). > **Information** > > When you select a date range for this report, it aggregates the data per row to a single date for the specified quarter. --- ## Report format The report is provided as a CSV file. The file name uses the following formats by default: - API and SFTP – `issuing_quarterly_mastercard_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv` - Dashboard scheduled reports – `{Start date:YYYYMMDD}-{End date:YYYYMMDD}-Card Issuing: Quarterly Mastercard Report (QMR)-{Entity name}.csv` For SFTP, the report is uploaded in the following folder structure:
`{Entity_name} > reports-{Entity_name} > issuing_mastercard_qmr` --- ## Sample report [Download a sample report](https://www.checkout.com/docs/files/Sample_Quarterly_Mastercard_Report.csv) (CSV file). > **Information** > > If using Safari, hold down the _Option_ key when selecting the link to download the file. --- ## Report fields > **Information** > > - `Within Region` and `Outside Region` columns apply to Europe only – that is, SEPA or non-SEPA. > - The values for all `Accounts` columns match the `Cards` columns because cards have one account for Issuing. The report includes all the following fields in this order: | Field name | Description | | --- | --- | | Report ID

`string` | The report's unique identifier.
Format – `YYYY-Q1/2/3/4-Transfer Agent ID-Report Name`
Example – `2024-Q3-11111-qmr_issuing_sbox` | | Quarter

`string` | The number and year of the current quarter.
Format – `YYYY-Q1/2/3/4`
Example – `2024-Q3` | | Transfer Agent ID

`string` | Your Interbank Card Association (ICA) number from Mastercard to enable settlement.
Format – Five-digit number
Example – `11111` | | Entity ID

`string` | The entity's unique identifier, prefixed with `ent_`. | | Client ID

`string` | Your unique identifier as a Checkout.com client, prefixed with `cli_`. | | Report Name

`string` | The name of this report and the environment you downloaded it from.
Example – `qmr_issuing_sbox` | | Currency

`string` | The currency in which you provide this report.
Format – [ISO 4217 code](https://www.checkout.com/docs/developer-resources/testing/codes/currency-codes.md)
Default – `USD` | | Purchase Domestic Interchange Count

`integer` | The number of cleared purchases where the merchant is in the same country as you. | | Purchase International Count

`integer` | The number of cleared purchases where the merchant is in a different country to you. | | Purchase International Within Region Count

`integer` | The number of cleared purchases where the merchant is in a different country but same region as you. | | Purchase International Outside Region Count

`integer` | The number of cleared purchases where the merchant is in a different country and region from you. | | Purchase Domestic Interchange Volume

`integer` | The total monetary value of cleared purchases where the merchant is in the same country as you. | | Purchase International Volume

`integer` | The total monetary value of cleared purchases where the merchant is in a different country from you. | | Purchase International Within Region Volume

`integer` | The total monetary value of cleared purchases where the merchant is in a different country but same region as you. | | Purchase International Outside Region Volume

`integer` | The total monetary value of cleared purchases where the merchant is in a different country and region from you. | | Refund Domestic Interchange Count

`integer` | The total number of cleared refunds/returns/credits where the merchant is in the same country as you. | | Refund International Count

`integer` | The total number of cleared refunds/returns/credits where the merchant is in a different country from you. | | Refund International Within Region Count

`integer` | The total number of cleared refunds/returns/credits where the merchant is in a different country but same region as you. | | Refund International Outside Region Count

`integer` | The total number of cleared refunds/returns/credits where the merchant is in a different country and region from you. | | Refund Domestic Interchange Volume

`integer` | The total monetary value of cleared refunds/returns/credits where the merchant is in the same country as you. | | Refund International Volume

`integer` | The total monetary value of cleared refunds/returns/credits where the merchant is in a different country from you. | | Refund International Within Region Volume

`integer` | The total monetary value of cleared refunds/returns/credits where the merchant is in a different country but same region as you. | | Refund International Outside Region Volume

`integer` | The total monetary value of cleared refunds/returns/credits where the merchant is in a different country and region from you. | | Accounts at Beginning of Quarter

`integer` | The total number of active and suspended accounts you had on the last day of the previous quarter. | | Suspended Accounts at Beginning of Quarter

`integer` | The number of suspended accounts you had on the last day of the previous quarter. | | Accounts Created During Quarter

`integer` | The number of accounts you created during the current quarter. | | Accounts Terminated During Quarter

`integer` | The number of accounts you revoked during the current quarter. | | Accounts at End of Quarter

`integer` | The total number of active and suspended accounts you have on the last day of the current quarter. | | Accounts with at Least One Transaction

`integer` | The total number of accounts that made at least one purchase or cash transaction during the current quarter. | | Suspended Accounts at End of Quarter

`integer` | The number of suspended accounts you have on the last day of the current quarter. | | Cards at Beginning of Quarter

`integer` | The total number of active and suspended cards you had on the last day of the previous quarter. | | Suspended Cards at Beginning of Quarter

`integer` | The number of suspended cards you had on the last day of the previous quarter. | | Cards Created During Quarter

`integer` | The number of cards you created during the current quarter. | | Cards at End of Quarter

`integer` | The total number of active and suspended cards you have on the last day of the current quarter. | | Suspended Cards at End of Quarter

`integer` | The number of suspended cards you have on the last day of the current quarter. | | Cards with at Least One Transaction

`integer` | The total number of cards that made at least one purchase or cash transaction during the current quarter. | | Virtual Prepaid Cards Count

`integer` | The number of virtual, non-reloadable prepaid cards without contactless functionality that you have. | | Virtual Prepaid Cards Transaction Count

`integer` | The number of cleared transactions made with your virtual, non-reloadable prepaid cards without contactless functionality. | | Virtual Prepaid Cards Transaction Volume

`integer` | The total monetary value of cleared transactions made with your virtual, non-reloadable prepaid cards without contactless functionality. |