Search docs

Are you looking for test card numbers?

Would you like to contact support?

Start searching Adyen's documentation...

  Documentation

Payment accounting report

Use this report for an overview of financial status changes, events, and modifications for all payments.

The payment accounting report is generated every day and includes financial status changes, events, and modifications for all payments. This includes full bookkeeping and user auditing. Use this report to maintain a copy of all available status changes in your own database, and to replicate Adyen's accounting data for financial reporting. 

Download a sample report

Review the sample report before you begin implementing your own process for managing reports. The sample report will give you an example of the kind of data that will be provided in your own reports.

To download a sample payment accounting report, click here.

Report structure

#

Column

Data Type

Description

1

Company Account

Unicode Text (80-character)

Name of your company account in the Adyen payments platform.

2

Merchant Account

Unicode Text (80-character)

Name of your merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.

3

Psp Reference

Unicode Text (16-character)

Unique 16 character reference for the payment. This is the PSP reference for the original authorisation request.

4

Merchant Reference

Unicode Text (80-character)

Reference number provided when initiating the payment request.

5

Payment Method

Unicode Text (30-character)

Payment method type of the payment which was processed. For example: visa, mc, amex.

6

Booking Date

Date field + Time field

Timestamp of when the event took place as entered into Adyen's accounting system. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-07-26 19:58:55.

7

TimeZone

Alpha Text (4-character limit)

Time zone of the Booking Date column. This is the ISO Code for the timezone set on your company account.

To configure for your company account, open the Customer Area and go to Account > Settings.

8

Main Currency

Alpha Text (3-character limit)

Three character ISO code for the main amount currency.

9

Main Amount

Text field Numeric (16-Character limit)

 

While the accounting record may move funds on multiple account "registers", each record type has a primary register which can be seen as a summary of the record.

For example, 100.00.

10

Record Type

Unicode Text (50-character)

Accounting record type.

For a list of record types, see Record types.

11

Payment Currency

Alpha Text (3-character limit)

Three character ISO code for the currency which was used for processing the payment.

12

Received (PC)

Fixed point number

Amount (in Payment Currency) debited or credited on the Received accounting register.

13

Authorised (PC)

Fixed point number

Amount (in Payment Currency) debited or credited on the Authorised accounting register.

14

Captured (PC)

Fixed point number

Amount (in Payment Currency) debited or credited on the Captured accounting register.

15

Settlement Currency

Alpha Text (3-character limit)

Three character ISO code for the currency which was used when settling the payment.

16

Payable (SC)

Fixed point number

Amount (in Settlement Currency) debited or credited on the Payable accounting register (i.e. funds which will be paid out to your bank account).

17

Commission (SC)

Fixed point number

Commission fee that was withheld by the acquirer (in Settlement Currency)
If the Acquirer provides the transaction information at the interchange level Adyen will split the commission into the Markup, Scheme Fees and Interchange registers instead.

18

Markup (SC)

Fixed point number

Fee charged by the Acquiring bank (in Settlement Currency).

19

Scheme Fees (SC)

Fixed point number

Fee which is charged by e.g. Visa / MC (in Settlement Currency).

20

Interchange (SC)

Fixed point number

Fee charged by the Issuing bank (in Settlement Currency).

21

Processing Fee Currency

Alpha Text (3-character limit)

Currency in which the processing (or gateway) fee is charged.

22

Processing Fee (FC)

Fixed point number

Amount (in Processing Fee Currency) charged on the Processing Fee accounting register.

23

User Name

Unicode Text (80-character)

User (interactive or webservice user) who performed the action resulting in the accounting record. If the record was created by an automated internal process the value "system" is used.

24

Payment Method Variant

Unicode Text (30-character)

Sub brand of the payment method (if applicable) For example: visaclassic, visadebit, mccorporate.

25

Modification Merchant Reference

Unicode Text (80-character)

Optional modification reference for modifications like capture or refund.

26

Reserved3

 

Reserved for future enhancements.

27

Reserved4

 

Reserved for future enhancements.

28

Reserved5

 

Reserved for future enhancements.

29

Reserved6

 

Reserved for future enhancements.

30

Reserved7

 

Reserved for future enhancements.

31

Reserved8

 

Reserved for future enhancements.

32

Reserved9

 

Reserved for future enhancements.

33

Reserved10

 

Reserved for future enhancements.

Record types

Record Type Description
Authorised

Payment approved by the financial institution.

AuthorisedPending Payment authorisation is pending acceptance from the issuer.
Cancelled Transaction cancelled.
CaptureFailed

Capture of a payment failed. For more information, refer to Failed capture.

Chargeback Payment reversed by the bank/scheme/consumer.
SecondChargeback

Unsuccessful defense of first chargeback.

ChargebackExternally Payment booked as a chargeback with external acquirer.
ChargebackExternallyWithInfo Payment booked as a chargeback with external acquirer.
ChargebackReversed Chargeback defended successfully, or the shopper re-paid the funds.
ChargebackReversedExternallyWithInfo

Chargeback defended successfully, or the shopper re-paid the funds.

Error Transaction error.
Expired Payment not captured within time limits.
PaidOut Payout successfully completed.
PaidOutExternally Payout successfully completed with external acquirer.
PaidOutExternallyWithInfo Payout successfully completed with external acquirer.
PaidOutReversed

Payout returned to Adyen's account as it could not be credited to the shopper.

PayoutAuthorised Payout successfully authorised.
PayoutError Payout that resulted in an error.
PayoutFailed Payout request was returned by the acquirer.
Received Registration of a validated payment attempt.
ReceivedPayout

Payout received by the Adyen payments platform.

RefundAuthorised Refund successfully authorised.
Refunded Payment successfully refunded.
RefundedBulk

Payment successfully refunded through Adyen Acquiring.

This journal type is deprecated and will be removed by 27-5-2019. For more information, see our FAQ.
RefundedExternally Payment successfully refunded through an external acquirer.
RefundedExternallyWithInfo Payment successfully refunded through an external acquirer.
RefundFailed The refund failed. For more information, refer to Failed refund.
RefundedInInstallments Payment has been fully refunded in installments.
RefundedInstallment Payment installment has been refunded.
RefundedReversed

Refund returned to Adyen's account as it could not be credited to the shopper.

Refused Payment was refused, either by the Adyen fraud tool or by the acquirer.
RefusedPayout

Payout was refused, either by the Adyen fraud tool or by the acquirer.

Retried Payment request was retried.
SentForPayout Payment sent for payout by the acquirer.
SentForRefund Payment sent for refund by the acquirer.
SentForSettle Request to transfer the payment sent to the financial institution.
Settled Payment has been settled, and the funds have been received by Adyen.
SettledBulk

Payment has been settled through Adyen Acquiring.

This journal type is deprecated and will be removed by 27-5-2019. For more information, see our FAQ.
SettledExternally Payment has been settled with an external acquirer.
SettledExternallyWithInfo Payment has been settled with an external acquirer.
SettledInInstallments Payment has been fully captured in installments.
SettledInstallmentSuspendInstallment Payment installment has been settled.
SuspendInstallment The installment will no longer be sent to the scheme due to a dispute in the transaction.
AdvancedInstallment The installment was advanced.
AdvancedInstallmentCancelled The advancement of the installment was cancelled.
OpenInstallment

An installment is still open.

There are 4 possible states of an OpenInstallment:

Initial: A transaction was captured.

Representement: You successfully defended a dispute, and we have resumed suspended installments.

Retry: A capture failed, and is being retried.

Acceleration: The shopper requested a refund, but the amount in the refund request is greater than the amount received, so future installments are accelerated and the installment is closed. See CloseInstallment.

CloseInstallment The installment will no longer be sent to the scheme and the OpenInstallment is closed.