Search docs

Are you looking for test card numbers?

Would you like to contact support?

Start searching Adyen's documentation...

  Documentation

MarketPay payments accounting report

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

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 or fundTransfer.

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 + " - " + charegeback reasonCode

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

Allowed values:

  • 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. 
  • Credited - Adyen received the funds and the balance is available in the MarketPay system. 
  • CreditFailed - Booking for capture-failed.
  • PendingDebit - A refund was initiated (SentForRefund), but the funds have not been paid.
  • Debited - A refund is complete, and the account balance is adjusted accordingly.
  • DebitReversedReceived - An initiated refund could not be refunded. For example, when the account of the card holder was closed.
  • DebitedReversed - Funds of the DebitReversedReceived are booked back into the virtual account's balance.
  • DebitFailed - Booking for refund-failed.
  • ChargebackReceived - A chargeback is received, but the amount is not yet deducted from the virtual account or MarketPlace’s liable account.
  • Chargeback -  A chargeback amount is deducted from 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.
  • ChargebackReversed - A chargeback is reversed, and the funds are received and booked by Adyen back into the virtual account or MarketPlace’s liable account.
  • FundTransfer - A fundTransfer is submitted from one virtual account to another.
  • PendingFundTransfer - A fundTransfer was submitted, but the funds have not yet transferred from one account to another.
  • Payout - A payout is complete from a virtual account.
  • CrossFlowPayout - Apayout is complete from a virtual account, for a US sub merchant.
  • VirtualAccountPayoutReturned - A payout could not be completed. For example, when the account of the card holder is closed.
  • TransferBalance - Aggregate amount of debits and credits to the liable account. This amount includes payment costs.
  • Converted - Amount credited after currency conversion.
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