The Advancements Detail Report is available in countries/regions where Adyen offers the Advancement Product (which usually include countries/regions where we process and receive payments in installments).
This report provides details of the installments that were used by Adyen to determine the amount advanced to the merchant.
File name format: Includes the advancement code, the date we first register the advancement in Adyen, and the date the report is generated.
Generating and downloading: Get this report manually or automatically.
Time zone: Currently the time zone is only CET/CEST.
Availability: Only available for merchant accounts.
File name format
The name of the report in Customer Area / Back Office follows specific rules to ensure a standard for name generation. This helps to prevent existing reports from being overwritten by newly generated reports.
Report names follow this format:
advancements_detail_report_<ADVANCEMENT_CODE>_<DATE_1>_<DATE_2>
-
ADVANCEMENT_CODEspecifies a single advancement operation. However, because these operations are by legal entity number (for example CNPJ in Brazil), it is possible that the total advancement operation amount includes merchant accounts with the same legal entity number. Therefor, the merchant must consult the report for different merchant accounts to get the total amount for that advancement operation.You can see the type of the advancement by looking at the advancement code:
- When it starts with ADYEN-ADV, it is an operation performed through Own Advancements.
- When it starts with ADYEN-PRX, it is an operation performed through Proxy Advancements.
-
DATE_1indicates when the advancement was first registered in our accounting system. -
DATE_2indicates the request date of the report. If you request multiple times for the report to be generated on different days, the older versions will not be overwritten.
Examples of report names:
- advancements_detail_report_ADYEN-ADV_20241030-143614_1065_155_2024_11_19_2024_11_21
- advancements_detail_report_ADYEN-PRX_20241014_14796606000351_00001149_2024_11_19_2024_11_21
Generate and download reports
This report is generated per merchant account, and per advancement code.
To manually or automatically generate an Advancements Detail Report, or download a previously generated report, you must have the See installments reports user role. You need this role for each merchant account that you want to include in the report.
Manually generate a report
To manually generate a report:
- Log in to your Customer Area, and switch to the relevant merchant account.
- Select Reports > Advancements details.
- Select Manage report > Manual (generate once).
- Input the complete advancement code. Important: If you type an advancement code that does not exist in the account, you may receive an empty report.
- Under File type, select one of the following:
- CSV (default)
- XLS_GEN
- TSV
- XML
- XMLE
- Select Generate report. At the top of your screen you will see a pop-up message that says Report is successfully queued.
Automatically generate a report
To automatically generate a report:
- Log in to your Customer Area, and switch to the relevant merchant account.
- Select Reports > Advancements detail.
- Select Manage report > Automatic (generate on a schedule).
- Select On.
- Under File type, select one of the following:
- CSV (default)
- XLS_GEN
- TSV
- XML
- XMLE
- Select Schedule.
Sample report
Download a sample Advancements Detail Report for examples of the included data.
Based on your account and settings, a report you generate in your account can contain additional data or columns that are not included in the sample report.
Report structure
Entries
Under the header line, each line in the report is a separate entry. The types of entries include:
Transaction lines
This indicates how much of an installment was advanced for a specific advancement code. It can appear as AdvancedInstallment or AdvancedInstallmentCancelled.
Aggregated lines
In the event that we are unable to select specific installments for the advancement, we will show the remaining amount as AdvancedBulk and/or AdvancedBulkCancelled.
Total line
The total amount advanced for a specific advancement code, and for a specific merchant account.
Columns
Each column shows specific information about the entries.
Standard columns
The table below reflects the standard columns that are included in the report, and the default order. You can add more columns, or change the order of the default columns.
| # | Column name | Data type | Description |
|---|---|---|---|
| 1 | Company Account | Unicode Text (80-character) | The name of your company account as registered in the Adyen payments platform. |
| 2 | Merchant Account | Unicode Text (80-character) | The name of the merchant account that was used to process the original payment request. |
| 3 | PSP Reference | Unicode Text (16-character limit) | Adyen's 16-character unique reference associated with the transaction/the request. This value is globally unique; quote it when communicating with us about this request. |
| 4 | Merchant Reference | Unicode Text (80-character) | The reference that was specified by you in the payment request. |
| 5 | Payment Method Variant | Unicode Text (30-character) | The payment method used for the transaction. |
| 6 | Creation Date | Date field + Time field | The timestamp indicates when the payment was captured on the Adyen payments platform. Format:YYYY-MM-DD HH:MM:SS. For example: 2025-01-02 19:58:55. |
| 7 | TimeZone | Unicode Text | The time zone of the Creation Date in ISO code. At the moment it will always be in CET/CEST. |
| 8 | Modification Reference | Unicode Text | A unique ID that identifies the modification request, in this report it relates to an Advancement registration. Maximum length: 16 characters. For records of journal type Advancement, this is a description containing Account code, advancement code and batch number. |
| 9 | Gross Currency | Unicode Text (3-character limit) | The three-character ISO currency code for the payment currency. |
| 10 | Gross Debit (GC) | Numeric or String (only in .XLS and .XLSX report files) | The debit amount of an installment. For example 100.00. |
| 11 | Gross Credit (GC) | Numeric or String (only in .XLS and .XLSX report files) | The credit amount of an installment. For example 100.00. |
| 12 | Exchange Rate | Numeric or String (only in .XLS and .XLSX report files) | The exchange rate used for converting the gross amount into the net amount. This will be 1 if you process and settle in the same currency. |
| 13 | Net Currency | Unicode Text (3-character limit) | The three-character ISO currency code for the settlement currency. |
| 14 | Net Debit (NC) | Numeric or String (only in .XLS and .XLSX report files) | The debit amount of an advancement. For example when we have a cancellation of advancement in a particular installment minus the advancement fee. |
| 15 | Net Credit (NC) | Numeric or String (only in .XLS and .XLSX report files) | The net credit amount of an advancement. For example the amount you will receive for an advancement of a particular installment minus the advancement fee. |
| 16 | Commission (NC) | Numeric or String (only in .XLS and .XLSX report files) | Informs the aggregated estimated commission amount for a particular installment. |
| 17 | Markup (NC) | Numeric or String (only in .XLS and .XLSX report files) | The fee charged by the acquiring bank. However, since the events on this report are not related to settlement, this column will be empty. |
| 18 | Scheme Fees (NC) | Numeric or String (only in .XLS and .XLSX report files) | The fee charged by the schemes (for example Visa, Mastercard). However, since the events on this report are not related to settlement, this column will be empty. |
| 19 | Interchange (NC) | Numeric or String (only in .XLS and .XLSX report files) | The fee charged by the issuing bank. However, since the events on this report are not related to settlement, this column will be empty. |
| 20 | Sub Payment Variant | Unicode Text (50-character) | The sub-brand of the payment method (if applicable). For example: visaclassic, visadebit, mccorporate. |
| 21 | Batch Number | Unicode Text (50-character) | The code of the advancement batch. |
| 22 | Advanced (NC) | Numeric or String (only in .XLS and .XLSX report files) | The requested advanced amount of an installment. |
| 23 | Advancement Code | Unicode Text (50-character) | The code of advancement. |
| 24 | Advancement Batch | Unicode Text (50-character) | The code of the advancement batch. |
| 25 | Installments | Unicode Text | This informs the installment sequence. For example 1/12 (first installment of a 12 installment-plan). |
| 26 | Advancement cost | Numeric or String (only in .XLS and .XLSX report files) | The calculated fee for the advancement of an installment, in monetary value. Since this is a calculated value, rounding issues may arise. When the “journal type” is “Advancement”, this column will show the actual total cost amount of an advancement. |
| 27 | Advancement fee (%) | Numeric or String (only in .XLS and .XLSX report files) | The calculated fee for the advancement of an installment, in percentage. |
| 28 | Rounding difference | Numeric or String (only in .XLS and .XLSX report files) | This column will only be populated when the “journal type” is “Advancement”. It will show the value to correct the rounding issues that may have arise in the advancement cost for installment, and by consequence the net advanced amount. |
| 29 | Modification Merchant Reference | Unicode Text (50-character) | The optional modification reference sent in a capture or refund, if specified in the transaction. |
| 30 | Acquirer | Unicode Text | The name of the acquirer that processed the original payment. For example: AdyenMasterCard_BR_Ins_23316. |
| 31 | Journal type | Unicode Text | The event to which the row relates to. |
Additional columns
You can configure report columns to add these to your report:
| # | Column name | Data type | Description |
|---|---|---|---|
| 1 | Payment Method | Unicode Text (80-character) | The name of your company account as registered in the Adyen payments platform. |
| 2 | Booking type | Unicode Text | Identifies the type of an installment. Possible values: FIRST: original presentment ACCELL: acceleration of an installment REPRESENTMENT: installment resubmitted RETRY: new presentation attempt of an installment |
| 3 | Type | Unicode Text | The event to which the row relates to concatenated with the installment booking type. |
| 4 | Previously Advanced (NC) | Numeric or String (only in .XLS and .XLSX report files) | If an installment was partially advanced, this column will show the gross advanced amount before the current event. |
| 5 | Remaining Advanceable (NC) | Numeric or String (only in .XLS and .XLSX report files) | If an installment was partially advanced, this column will show the gross amount still available to be advanced after the current event. |
Configure report columns
If you want to add additional columns or change the order of columns in a report, you can do so in the Customer Area. If you have an automated system that uses the report's data, configuring the report columns can affect your automated system.
To configure report columns:
- Log in to your Customer Area, and switch to a merchant account.
- Select Reports > Advancements detail.
- Select the Column configuration tab. If you don't see it your user may be missing some permissions.
- Select checkboxes to indicate which columns you want to include in the report.
- Drag the columns into the order that you want them to appear.
- Select Save configuration.
Journal types
The journal types listed below correspond to the Type field in the report structure above.
| Journal type | Description |
|---|---|
| AdvancedInstallment | This journal indicates the amount of an installment that has been advanced. It informs the gross amount of the installment, the estimated fees regarding acquirer process (installment fees), the gross amount advanced, the advancement cost, the net amount advanced. In the event of a partial advancement, you can also see if any amount has been previously advanced and if any amount remains available to be advanced. |
| AdvancedInstallmentCancelled | This journal indicates the amount that is no longer advanced from an installment. This can happen when an advancement contract has been cancelled, has its amount diminished or had its amount over registered. It will still inform the same information as the AdvancedInstallment, but it will only inform the gross/net amount and the advancement cost for the portion that is no longer advanced. In the event of a partial advancement, you will also see any amount that is still advanced and the amount that is now available to be advanced. |
| AdvancedBulk | This journal only appears when we cannot describe the total advanced amount in transaction level. This can happen for many reasons such as advancement of debit card transactions, advancement of installments no longer available to be advanced. It will indicate the amount advanced in a particular advancement batch that we could not identify the installments, and will show the gross, net and the advancement cost of that portion. Since we cannot identify the transactions, it won't have any estimated commission in the commission column. |
| AdvancedBulkCancelled | This journal only appears when we cannot describe the amount that is no longer advanced in transaction level. It will indicate the cancelled amount in a particular advancement batch that we could not identify the installments, and will show the gross, net and the advancement cost of that portion. Since we cannot identify the transactions, it won't have any estimated commission in the commission column. |
| Advancement | This journal appears on the last line of the report and shows the total amounts for gross (in the Advanced (NC) column), net and advancement cost for a particular advancement code in a particular merchant account. This is where you will find the amount received in the bank account related to advancement. |