Payment accounting report

The payment accounting report is generated every day and includes financial status changes, events, and modifications for all the payments including full bookkeeping and user auditing (audit for manual capture/cancel/refund and callcenter use or when using multiple web service users). This report is ideal if you want to maintain a copy of all available status changes in your own database to replicate Adyen's accounting data for financial reporting. 

Position

Column Name

Data Type

Description

1

Company Account

C X80

The static name of your company account within the Adyen payments platform.

2

Merchant Account

C X80

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

3

Psp Reference

C 16

This is Adyen's unique 16 character reference for the payment; it denotes the PSP reference for the original authorisation request.

4

Merchant Reference

C X80

This is the reference number that was provided when initiating the payment request.

5

Payment Method

C X30

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

6

Booking Date

D+" "+T

The 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

A 4

The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account:
Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc)

8

Main Currency

A 3

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. We refer to this as the main amount. This is the three character ISO code for the main amount currency.

9

Main Amount

N 16

The main amount; for an explanation, see previous record. For example, 100.00.

10

Record Type

C X50

The accounting record type. For a list of record types, see Record types.

11

Payment Currency

A 3

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

12

Received (PC)

F

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

13

Authorised (PC)

F

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

14

Captured (PC)

F

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

15

Settlement Currency

A 3

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

16

Payable (SC)

F

The 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)

F

The 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)

F

The fee charged by the Acquiring bank (in Settlement Currency).

19

Scheme Fees (SC)

F

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

20

Interchange (SC)

F

The fee charged by the Issuing bank (in Settlement Currency).

21

Processing Fee Currency

A 3

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

22

Processing Fee (FC)

F

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

23

User Name

C X80

The 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

C X30

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

25

Modification Merchant Reference

C X80

For modifications like capture or refund, the (optional) modification reference supplied by the merchant.

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