# Real Time Account Updater Report

The Real Time Account Updater Report provides a comprehensive history of all card updates made by the [Real-Time Account Updater service](https://www.checkout.com/docs/payments/store-and-manage-credentials/update-stored-credentials.md) during the selected timeframe. It provides information about each event, including:

- Details about the card that was updated
- The type of update that occurred
- The payment instrument IDs associated with the updated card
- The payment ID, if the update was triggered by a transaction

---

## Report availability

The client-level report data is refreshed daily at 08:00:00 UTC. You can generate the report on a daily, weekly, or monthly basis.

The report covers updates from the start of the first day of the reporting period at 00:00:00 UTC, to the end of the final day of the reporting period at 23:59:59 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)
- [Using the API](https://www.checkout.com/docs/business-operations/retrieve-reports.md#Retrieve_reports_via_API)
- [Using Secure File Transfer Protocol](https://www.checkout.com/docs/business-operations/retrieve-reports.md#Access_reports_via_SFTP) (SFTP)
- [Using webhooks](https://www.checkout.com/docs/business-operations/retrieve-reports.md#Receive_reports_using_webhooks)

---

## Report format

The report is provided as a CSV file. By default, the file name uses the following format:

- API and SFTP – `real_time_account_updater_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}.csv`
- Dashboard scheduled reports – `real_time_account_updater_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}.csv`

For SFTP, the report is uploaded in the following folder structure: <br>
`{Entity_name} > reports-{Entity_name} > real_time_account_updater`

---

## Sample report

[Download a sample report](https://www.checkout.com/docs/files/Sample_Real_Time_Account_Updater_Report.csv) (CSV file).

> **Information**
>
> If using Safari, hold down the _Option_ key when selecting the link to download the file.

---

## Report fields

The report includes the following fields in this order:

| Field name | Description |
| --- | --- |
| Event ID<br><br>`string` | The unique identifier for the card update. <br>Example – `evt_78ic66ux4no71twu9du0l8e7jx` |
| Timestamp<br><br>`date-time` | The date and time the card update occurred. <br>Format – ISO 8601 <br>Example – `2024-01-31T10:20:30.456` |
| Scheme<br><br>`string` | The card scheme of the updated card. This can be one of:<br><br>- `mastercard`<br>- `visa` |
| Card update reason<br><br>`string` | The reason the card was updated. This can be one of:<br><br>- `card_closed`<br>- `card_expiry_updated`<br>- `card_updated`<br>- `contact_cardholder` |
| Original card - BIN<br><br>`string` | The original card's Bank Identification Number (BIN). |
| Original card - Expiry Month<br><br>`string` | The original card's expiry month, in the format M. |
| Original card - Expiry Year<br><br>`string` | The original card's expiry year, in the format YYYY. |
| Original card - Last 4<br><br>`string` | The last four digits of the original card number. |
| Replacement card - BIN<br><br>`string` | The replacement card's Bank Identification Number (BIN).<br><br>If the card update reason was `card_closed` or `contact_cardholder`, this field is empty. |
| Replacement card - Expiry Month<br><br>`string` | The replacement card's expiry month, in the format M.<br><br>If the card update reason was `card_closed` or `contact_cardholder`, this field does not return a value. |
| Replacement card - Expiry Year<br><br>`string` | The replacement card's expiry year, in the format YYYY.<br><br>If the card update reason was `card_closed` or `contact_cardholder`, this field does not return a value. |
| Replacement card - Last 4<br><br>`string` | The last four digits of the replacement card number.<br><br>If the card update reason was `card_closed` or `contact_cardholder`, this field does not return a value. |
| Payment ID<br><br>`string` | The unique identifier for the payment associated with the card update. <br>Example – `pay_vgms549w8swfp8zvqr2v6qtwy3`<br><br>- Visa – Always returns a payment ID<br>- Mastercard – Only returns a payment ID if you use the Real-Time Account Updater service's [Mastercard Update & Retry](https://www.checkout.com/docs/payments/store-and-manage-credentials/update-stored-credentials.md) option |
| Source IDs<br><br>`string` | The unique identifiers for the payment instruments the updated card is associated with.<br>Example – `src_y5r7ig9p9klgkj1gbxvhkbur7v` |
| Account Updater Product<br><br>`string` | The Real Time Account Updater option used to update the card. This can be one of:<br><br>- `store_update`<br>- `update_retry`<br>- `vau` |
| Is Real Time Account Updater<br><br>`string` | Specifies if the card update was performed by the Real Time Account Updater, or a batch account updater. |