Are you looking for test card numbers?

Would you like to contact support?

Reportin icon

MarketPay payments accounting report

Use this report to view financial status changes, events, and modifications for all MarketPay payments.

About this report

This report is based on the time zone setting of your account.
See Downloading reports.

The MarketPay payments accounting report includes financial status changes, events, and modifications for all the payments across your marketplace including full bookkeeping. Use this report to keep your system up to date with all available status changes in your own database, and to replicate Adyen's accounting data for financial reporting. 

Report name format:  marketplace_payments_accounting_report_YYYY_MM_DD.csv
Subscription: Default
Frequency: Hourly, or daily

Report structure

Column Description
Market Place Name of the MarketPlace account.
Account Holder AccountHolder code. Defined by the MarketPlace when an accountHolder is created.
Account Virtual account code.
Psp Reference PSP reference for the action in the MarketPay system.
Payment Psp Reference PSP reference of the payment in the PSP system/ Customer Area. Can be empty if the action is not payment transaction related
Payment Merchant Reference Merchant reference provided on payment submission.
Capture Psp Reference PSP reference for modification requests, for example: capture, refund, chargeback.
Capture Merchant Reference Reference provided by the MarketPlace when requesting a modification. The value is <auto> when capture delay is set to immediate.
Payout Psp Reference PSP reference of a payout.
Chargeback Psp Reference PSP reference of a chargeback.
Booking Date Timestamp created when the booking is submitted.
TimeZone Timezone in which the report was generated.
Description Description of the split item line, payout, fundTransfer, or fundTransferReversed.

For PendingCredit, Credited, CreditFailed, PendingDebit, Debited, DebitReversedReceived, DebitedReversed, DebitFailed types, the format of the description is:

split.item.reference + " - " + split.item.description

For ChargebackReceived, Chargeback, ChargebackReversedReceived, and ChargebackReversed types, the format of the description is:

formatted:split.item.reference + " - " + chargeback reasonCode

Main Currency Currency in which the action was performed or in which the payment/payout/fundTransfer/fundTransferReversed was submitted.
Main Amount Amount defined in the split item line in the payment or payout/fundTransfer/fundTransferReversed request.
Record Type The type of record included in a report.

Allowed values:

  • Chargeback - A chargeback amount is deducted from the virtual account or MarketPlace's liable account.
  • ChargebackReceived - A chargeback is received, but the amount is not yet deducted from the virtual account or MarketPlace's liable account.
  • ChargebackReversed - A chargeback is reversed, and the funds are received and booked by Adyen back into the virtual account or MarketPlace's liable account.
  • ChargebackReversedReceived - A chargeback is reversed, but the funds have not yet been received and booked by Adyen.
  • Converted - Amount credited after currency conversion.
  • CreditFailed - Booking for capture-failed.
  • Credited - Adyen received the funds and the balance is available in the MarketPay system.
  • CreditedReversed - Adyen did not receive the funds and debits the original credited amount from the account.
  • DebitFailed - Booking for refund-failed.
  • DebitReversedReceived - An initiated refund could not be refunded. For example, when the account of the card holder was closed.
  • Debited - A refund is complete, and the account balance is adjusted accordingly.
  • DebitedReversed - Funds of the DebitReversedReceived are booked back into the virtual account's balance.
  • FundTransfer - A fundTransfer is submitted from one virtual account to another.
  • FundTransferReversed - A fundTransfer has been reversed.
  • ManualCorrected - Manual booking/adjustment by Adyen.
  • Payout - A payout is complete from a virtual account.
  • PendingCredit - The payment was captured (SentForSettle in PSP). The payment flow initiates collecting funds from the payer. The pendingCredit journal creates a pendingBalance, which is a balance not yet available for payout, as the funds have not been received by Adyen.
  • PendingDebit - A refund was initiated (SentForRefund), but the funds have not been paid.
  • PendingFundTransfer - A fundTransfer was submitted, but the funds have not yet transferred from one account to another.
  • TransferBalance - Aggregate amount of debits and credits to the liable account. This amount includes payment costs.
  • VirtualAccountPayoutReturned - A payout could not be completed. For example, when the account of the card holder is closed.
Balance Currency Currency of the balance after transferring it to the virtual account.
Pending (BC) Pending balance for the reported item line in the MarketPlace Accounting Report.
Balance (BC) Available balance for the reported item line in the MarketPlace Accounting Report.
Exchange Rate The exchange rate used for the payment
Bank account details Bank account details used for payouts.
US State State where the transaction was processed (e.g. FL or CA).
Refund terms "Right To Refund" legal text. This applies when the bank account being paid out to is in California (US).
Reserved5 Reserved for future enhancements
Reserved6 Reserved for future enhancements
Reserved7 Reserved for future enhancements
Reserved8 Reserved for future enhancements
Reserved9 Reserved for future enhancements
Reserved10 Reserved for future enhancements