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 a modification request is submitted. submitting modification. 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 of submitting the request.
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 & 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 action after transferring it into the virtual’s account: the virtual account’s currency.
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

The state for which the transaction is applicable (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