Are you looking for test card numbers?

Would you like to contact support?

No momento, esta página não está disponível em inglês
Default icon

Marketplace Payments accounting report

Use this report to view financial status changes, events, and modifications for payments settled in Adyen for Platforms.

Time zones
Your time zone setting affects the data in this report.

The Marketplace Payments accounting report includes financial status changes, events, and modifications for all the payments across your marketplace or platform including full bookkeeping.

You can use this report to build a transactional ledger for all the accounts in your platform and to reconcile total fees debited against your platform's liable account.

Report name format:  

  • Daily: marketplace_payments_accounting_report_YYYY_MM_DD.csv
  • Hourly: marketplace_hourly_payments_accounting_report_YYYY_MM_DD_HH_UTC.csv

Subscription: Default
Frequency: Hourly, or Daily

Sample

Download a sample Marketpay Payments accounting report for examples of the included data.

Structure

Entries

Under the header line, each line in the report is a separate entry.

Columns

Each column shows specific information about the entries.

# Column Data type Description
1 Market Place Unicode Text Name of your marketplace or platform.
2 Account Holder Unicode Text The accountHolderCode you provided when you created the account holder.
3 Account Unicode Text
(Either 9- or 16-character limit)
The accountCode of the account that belongs to the account holder.
4 Psp Reference Unicode Text
(16-character limit)
PSP reference for the action in the Adyen for Platforms system.
5 Payment Psp Reference Unicode Text
(16-character limit)
PSP reference of the payment in the PSP system/Customer Area. Can be empty if the action is not related to a payment.
6 Payment Merchant Reference Unicode Text
(80-character)
The reference you provided when you submitted the payment.
7 Capture Psp Reference Unicode Text
(16-character limit)
PSP reference for modification requests, such as a capture, refund, or chargeback request.
8 Capture Merchant Reference Unicode Text
(80-character)
The reference you provided when you submitted a modification. When capture delay is set to immediate, the value here is set to auto.
9 Payout Psp Reference Unicode Text
(16-character limit)
PSP reference of a payout.
10 Chargeback Psp Reference Unicode Text
(16-character limit)
PSP reference of a chargeback.
11 Booking Date Date field +
Time field
Timestamp created when the booking was submitted.
12 TimeZone Alpha Text
(4-character limit)
Timezone in which the report was generated.
13 Description Unicode Text For the split item line and record types Payout, FundTransfer, or FundTransferReversed, this is the description sent in the request.

For record types PendingCredit, Credited, CreditFailed, PendingDebit, Debited, DebitedReversed, and DebitFailed , 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

14 Main Currency Alpha Text
(3-character limit)
Currency in which the action was performed or in which the payment/payout/fundTransfer/fundTransferReversed was submitted.
15 Main Amount Fixed point number Amount defined in the split item line in the payment or payout/fundTransfer/fundTransferReversed request.
16 Record Type Unicode Text The type of record.
Indicates if the amount affects the pending balance or the available balance.
17 Balance Currency Alpha Text
(3-character limit)
Currency of the balance after transferring it to the virtual account.
18 Pending (BC) Fixed point number Pending balance, reflects pending debits or credits. Record types such as PendingCredit and ChargebackReceived affect the pending balance.
19 Balance (BC) Fixed point number Available balance, reflects amounts that have already been credited or debited. Record types such as FundTransfer and DebitedReversed affect the balance.
20 Exchange Rate Floating point number The exchange rate used for the payment, used only when there was as currency conversion between the main currency and the balance currency.
21 Bank account details Unicode Text Bank account details used for payouts, in a JSON, single-line format.
22 US State Unicode Text State where the transaction was processed. For example, FL or CA.
23 Refund terms Unicode Text "Right To Refund" legal text. This applies when the bank account being paid out to is in California (US).
24 Reserved5 - Reserved for future enhancements
25 Reserved6 - Reserved for future enhancements
26 Reserved7 - Reserved for future enhancements
27 Reserved8 - Reserved for future enhancements
28 Reserved9 - Reserved for future enhancements
29 Reserved10 - Reserved for future enhancements

Record types

The Record type value indicates the type of entry and whether the entry affects the pending balance (Pending column) or the available balance (Balance column) of the account.

Record type Affected balance column Description
PendingCredit Pending The payment was captured, but the balance is not yet available for payout because Adyen has not yet received the funds. The pending balance is adjusted accordingly.
Credited Pending, Balance The funds have settled and are added to the balance accordingly.
PendingDebit Pending A refund was initiated, but the funds have not been deducted yet. The pending balance is adjusted accordingly.
Debited Pending, Balance The funds were refunded and are deducted from the balance accordingly.
CreditFailed Pending The capture failed due to a technical issue, no funds were credited to the account.
DebitFailed Pending The refund failed due to a technical issue, no funds were debited from the account.
CreditReversed Balance Adyen did not receive the funds and debits the original credited amount from the account.
DebitedReversed Balance An initiated refund was returned to Adyen and the funds are booked back to the account. For example, when the bank account of the cardholder was closed.
ChargebackReceived Pending A chargeback was received but the amount is not yet deducted from the account.
Chargeback Pending, Balance Debit for a payment that was reversed by the bank, scheme, or the customer. The chargeback amount is deducted from the account balance.
ChargebackReversedReceived Pending A chargeback was reversed after a payment was successfully defended, or after the shopper repaid the funds, but the funds have not yet been received. The pending balance is adjusted accordingly.
ChargebackReversed Pending, Balance A previous chargeback was reversed after a payment was successfully defended, or after the shopper repaid. The funds are added to the account balance.
SecondChargebackReceived Pending A second chargeback is received for unsuccessful defense of a first chargeback, but the amount is not yet deducted from the account. The pending balance is adjusted accordingly.
SecondChargeback Pending, Balance Debit for unsuccessful defense of a first chargeback. The chargeback amount is deducted from the account balance.
FundTransfer Balance Funds were transferred from one account to another. The balance is adjusted accordingly.
FundTransferReversed Balance A fund transfer was reversed, so the funds are still in the source account.
PendingFundTransfer Pending Used only for funds transfers for accounts with a beneficiary setup. The pending balance is adjusted accordingly.
Payout Balance For payouts to bank accounts. Funds were paid out to the account holder and are deducted from the available balance.
VirtualAccountPayoutReturned Balance For payouts to bank accounts. A payout could not be completed and the funds were returned to the account holder. For example, when the bank account of the cardholder is closed.
PayoutInitiated Balance For payouts to cards. A payout was initiated. The funds are deducted from the available balance.
PaidOut Balance For payouts to cards. Funds were paid out to the account holder and are deducted from the available balance.
PayoutFailed Balance For payouts to cards. A payout could not be completed and the funds were returned to the account holder.
Deprecated ManualCorrected Balance Manual booking or adjustment by Adyen, used in existing platforms.

For new platforms, this record type is replaced by the new record types: ManualCorrectionCredited and ManualCorrectionDebited.
TransferBalance Balance Aggregate amount of debits and credits to the liable account. In previous versions of the report, this amount includes payment costs.

For new platforms, the TransferBalance only contains the aggregate amount of credits and debits that could not have been booked due to missing split information, missing split reference, or a technical issue. Other debits and credits are reported under new record types. For example, payment costs are reported under record type Fee.
New Fee * Balance Adyen fees booked against your platform's liable account during the specified period. This is enabled by default for new platforms.
New DepositCorrection * Balance Funds withheld from or released to your platform's liable account due to a change in the required security deposit (coverage of the exposure on the account). This is enabled by default for new platforms.
New InvoiceDeduction * Balance Represents a monthly invoice that is credited to or debited from your platform's liable account. This is enabled by default for new platforms.
New MerchantPayin * Balance A credit transfer or direct debit booked in your platform's liable account. This is enabled by default for new platforms.
New MerchantPayinReversed * Balance A payment meant to top up or fund your platform's liable account goes through a chargeback. This is enabled by default for new platforms.
NewManualCorrectionCredited * Balance Manual booking or adjustment by Adyen. The amount is added to the balance. This is enabled by default for new platforms.
NewManualCorrectionDebited * Balance Manual booking or adjustment by Adyen. The amount is deducted from the balance. This is enabled by default for new platforms.

* This record type is used by default in new platforms. For existing platforms, contact our Support Team to enable the new record types.

See also