> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://amer.developers.trustly.com/llms.txt.
> For full documentation content, see https://amer.developers.trustly.com/llms-full.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://amer.developers.trustly.com/_mcp/server.

# Reconciliation Report-BNY

## Reading the Reconciliation Report

The Reconciliation Report contains any transactions that were created during the reporting period (excluding RTP transactions).\
How to Read the Reconciliation Report\
The Reconciliation Report consists of individual rows of data. Each row provides one of three types of data:

* Header
* Transaction Record
* Trail

Each row contains only one type of data and begins with a Record Type Indicator, which conveys the data type. For example, the file header rows indicator is H while the individual transaction rows have an indicator of T.

![](https://files.buildwithfern.com/trustly.docs.buildwithfern.com/41bd3e82c1fbafebbd5c8db055336ca040966ccc737fa4a768c517af323496ca/docs/assets/north-america/7f9d9fb-image.png)

Every report begins with the Header and ends with the Trail.

All transaction records in the report reflect the transaction events created during the reporting period. The event status will reflect the status after the event for the record.\
Some transactions will have a parent transaction ID, or original transaction ID, as shown in the example below.\
The original transaction was an authorization, and then the child transaction was the capture.

![](https://files.buildwithfern.com/trustly.docs.buildwithfern.com/c90aa21d1ebedab50bba8864bc41d8c6ed8133847eae9f80255fec5a03de3060/docs/assets/north-america/df129e0-image.png)

The trail shows how many transactions were part of the report and the total amount of the transactions created during the reporting period.

![](https://files.buildwithfern.com/trustly.docs.buildwithfern.com/de91fba23880cdcb3d20352adc56e0a1c53e43a7f1e66758c12e60acd59e000f/docs/assets/north-america/f29c2e7-image.png)

### Reconciliation Report Fields

Each line in the Reconciliation File is prefixed with a `Record Type Indicator` that dictates the type of information it is conveying.

#### Header

The first line of the report is always the Header and it looks like this:

![](https://files.buildwithfern.com/trustly.docs.buildwithfern.com/7829e327f36914f8cd487c7ae12449710c83af316d7405f4d97c9474d82ffe86/docs/assets/north-america/a4af23e-image.png)

This line contains the following fields and information:

| Field Name            | Max Length | Format                           | Required | Sample Data            | Notes                                                     |                  |
| :-------------------- | :--------- | :------------------------------- | :------- | :--------------------- | :-------------------------------------------------------- | :--------------- |
| Record Type Indicator | 1          | `H`                              | Yes      | `H`                    | Always `H`                                                |                  |
| Magic                 | 7          | `P11KREC`                        | Yes      | `P11KREC`              | Magic number                                              | Always `P11KFUN` |
| Version               | 11         | Alphanumeric                     | Yes      | `1.0.0`                | File version                                              |                  |
| Start Date            | 24         | UTC Date Time in ISO 8601 format | Yes      | `2017-01-21T12:00:00Z` | Report start date                                         |                  |
| End Date              | 24         | UTC Date Time in ISO 8601 format | Yes      | `2017-01-22T12:00:00Z` | Report end date                                           |                  |
| Merchant ID           | 50         | Numeric                          | Yes      | `10000000234`          | Merchant identifier                                       |                  |
| Sequence              | 10         | `NNNNofNNNN`                     | Yes      | `0001of0002`           | File sequence. A report can be broken into multiple files |                  |

#### Transaction Record

A transaction record provides details for an event that occurred with the merchant and it looks like this:

![](https://files.buildwithfern.com/trustly.docs.buildwithfern.com/4129369829a661192d8be1e697a9db0dfa42367e247b6094dc4818df50c223ab/docs/assets/north-america/90eb6f7-image.png)

This line contains the following fields and information:

#### Trail

The Trail indicates the end of the report and is a summation of the records within the report. It looks like this:

![](https://files.buildwithfern.com/trustly.docs.buildwithfern.com/1501602dd91004e261633cf483bfd9eed18ecf667b1428e3b1b1587baf6d5d22/docs/assets/north-america/48aba8e-image.png)

This line contains the following fields and information:

| Field Name            | Max Length | Format         | Required | Sample Data | Notes                                         |
| --------------------- | ---------- | -------------- | -------- | ----------- | --------------------------------------------- |
| Record Type Indicator | 1          | `L`            | Yes      | `L`         | Always `L`                                    |
| Num Item Records      | 9          | Numeric        | Yes      | `300`       | Total count of the item records               |
| Total Items Amount    | 18         | Decimal String | Yes      | `100.00`    | Total sum of the transaction records amount   |
| Currency              | 3          | Alphanumeric   | No       | USD         | Currency of total value of financing records. |