Ascend Pay - Deposits, Fees, and Report Definitions

If you're not an expert accountant, this page is a life saver.

Written By Eddy Cevilla (Administrator)

Updated at June 15th, 2024

The devil is in the details.  You can find all you need to know about the terms in Ascend Pay reporting below.

Once you're ready to reconcile your account with this information, click here. 

Ascend HQ Reports

To access all available Ascend Pay reports:

  1. Navigate to Ascend HQ (ascendrms.com).
  2. Select you desired report by clicking on Payments > Ascend Pay.

To export Ascend Pay reports:

  1. Navigate to your desired report.
  2. Customize your data columns using the gear icon, if necessary.
  3. Click Export.

What gets deposited to the bank?

  • HQ > Balance Platform Account
  • Click the gear icon and select the additional columns - Account Holder Description, Funds Available Date and Amount and Save
  • Export to Excel
  • Filter Account Holder Description to only the shop name
    • Filter Funds Available Date (date things should show in bank)
    • Sum Amount column

How can I see details about the fees I am being charged?

  • HQ > Balance Platform Account
  • Export to Excel
  • Filter Booking Date -OR- Funds Available Date (which ever you prefer)
  • Filter Status to only show Captured and Refunded
  • Filter Description to everything BUT Sellers Split
  • Determine the absolute sum of Amount column
  • Determine the sum of Platform Payment Markup column
  • Subtract the Payment Platform Markup from the Absolute Sum of Amount
  • The result of the above steps should match the amount of fees.

Report Definitions

Balance Platform Accounting Report

The Balance Platform Accounting Report is a daily report that tracks all balance changes on all balance accounts in your platform, including liable accounts. You can use the information from the Balance Platform Accounting Report to: 

  • Confirm all processed payments
  • Confirm transfers between balance accounts
  • Confirm payouts to your bank accounts
  • Track payment fees, costs, and invoice deduction

The generated report includes the balance mutations with a Booking Date for all the accounts for your platform between opening (00:00 AM) and closing (00:00 AM the next day) for your selected day in Central European Time (CET). 

The following table shows the standard columns that are included in the Accounting Report, in their default order:

# Column Financial service Description
1 Balance Platform issuing
payouts
platform payments
Name of your Balance Platform account.
2 Account Holder issuing
payouts
platform payments
Unique identifier of the account holder that owns the balance account.
3 Balance Account issuing
payouts
platform payments
The unique identifier of the balance account.
4 Transfer Id issuing
payouts
platform payments
The unique identifier of a pending debit or credit.
5 Transaction Id issuing
payouts
platform payments
The unique identifier of a transaction, reflects a completed debit or credit.
6 Category issuing
payouts
platform payments

The category of the transaction. Possible values:

  • platformPayment
  • internal
  • bank
  • issuedCard
7 Status issuing
payouts
platform payments
The status of the event. Example values: authorised, chargeback.
8 Type issuing
payouts
platform payments
The type of transfer or transaction. Example values: refund, chargeback.
9 Booking Date issuing
payouts
platform payments
Date of the booking.
10 Value Date issuing
payouts
platform payments
The date when the funds are available.
11 Value Date Time Zone issuing
payouts
platform payments
The time zone of the location where the funds are available.
12 Currency issuing
payouts
platform payments
The three-character ISO currency code for the balance account.
  Amount issuing
payouts
platform payments
The amount of the transfer or transaction.
13 Original Currency issuing The three-character ISO currency code of the payment amount as reported by the acquirer.
14 Original Amount issuing The payment amount in the currency defined in Original Currency.
15 Payment Currency issuing
payouts
platform payments
The currency of the payment.
  Received (PC) issuing
payouts
platform payments
The amount (in Payment Currency) debited or credited on the Received accounting register.
16 Reserved (PC) issuing
payouts
platform payments
The amount (in Payment Currency) debited or credited on the Reserved accounting register.
17 Balance (PC) issuing
payouts
platform payments
The amount (in Payment Currency) debited or credited on the Balance accounting register.
18 Reference issuing
payouts
platform payments
The unique identifier of a pending debit or credit.
19 Description issuing
payouts
platform payments

The unique identifier of a pending debit or credit. When the transfer is a fee, the fee type is added before the description of the original payment.

Possible fee type indications:

  • Payment Fee for
  • Chargeback Fee for
  • SecondChargeback Fee for
  • ChargebackReversal Fee for

If the original payment did not contain a description, possible fee type indications are:

  • Payment Fee
  • Chargeback Fee
  • SecondChargeback Fee
  • ChargebackReversal Fee
20 Counterparty Balance Account Id issuing
payouts
platform payments
The unique identifier of the destination of the transfer.
21 Psp Payment Merchant Reference platform payments The PSP merchant reference of a payment.
22 Psp Payment Psp Reference platform payments The PSP reference of a payment.
23 Psp Modification Psp Reference platform payments The PSP modification reference of a payment.
24 Psp Modification Merchant Reference platform payments The PSP modification reference of a payment.
25 Payment Instrument Type issuing The type of the payment instrument used in the payment.
26 Payment Instrument Id issuing The unique identifier of the payment instrument.
27 Entrymode issuing

The point-of-sale entry mode as reported by the acquirer.

Possible values:

  • manual
  • chip
  • magstripe
  • magstripe_fallback
  • contactless
  • contactless_magstripe
  • cof
  • token
  • e_commerce
  • server
  • barcode
  • ocr
  • unknown
28 Auth Code issuing A unique authorization code generated for the payment. This code should be included when canceling or refunding a payment.
29 Shopper Interaction issuing

Transaction type. Possible values:

  • Ecommerce
  • ContAuth
  • POS
  • Moto
30 MCC issuing The merchant category code of the merchant that initiated the payment.
31 Counterparty Name issuing The name of the merchant that initiated the payment.
32 Counterparty Address issuing The address of the merchant that initiated the payment.
33 Counterparty City issuing The city of the merchant that initiated the payment.
34 Counterparty Country issuing The ISO country code of the merchant that initiated the payment.
35 Counterparty iban payouts The IBAN of the merchant that initiated the payment.
36 Counterparty bic payouts The BIC of the bank of the merchant that initiated the payment.
37 Counterparty Account Number payouts The account number of the merchant that initiated the payment.
38 Counterparty Postal Code issuing
payouts
The postal code of the merchant that initiated the payment.
39 Interchange Currency issuing The currency of the interchange.
  Interchange issuing The amount of interchange.
40 Beneficiary Balance Account issuing The unique identifier of the beneficiary balance account associated with your platform.
41 Brand variant issuing The brand variant for the payment instrument. For example: mcdebit, visaprepaid.
42 Reference for Beneficiary payouts Your reference for the beneficiary.
43 Platform Payment Interchange platform payments Fee charged by the Issuing bank. If the acquirer does not provide the transaction information at the interchange level, this field is empty.
44 Platform Payment Scheme Fee platform payments Fee which is charged by Visa or Mastercard. If the acquirer does not provide the transaction information at the interchange level, this field is empty.
45 Platform Payment Markup platform payments Fee charged by the acquiring bank. If the acquirer does not provide the transaction information at the interchange level, this field is empty.
46 Platform Payment Commission platform payments Blend fee charged by the acquiring bank. If the acquirer does not provide the transaction information at the payment level, this field is empty.
  Platform Payment Cost Currency platform payments The currency of the Platform Payment Cost fields.
47 Account Holder Description issuing
payouts
platform payments
Your description for the account holder.
48 Account Holder Reference issuing
payouts
platform payments
Your reference for the account holder.
49 Balance Account Description issuing
payouts
platform payments
Your description for the balance account.
50 Balance Account Reference issuing
payouts
platform payments
Your reference for the balance account.

 

Payment Accounting Report

The Payment Accounting Report includes Payments lifecycle status changes, events, and modifications for all transactions. You can use this report to see the costs associated with different statuses and perform invoice reconciliation.

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

Each column shows specific information about the entries. By default, the report includes these standard columns in this order:

# Column Data type Description
1 Company Account Unicode Text (80-character) The name of your company account as registered in the Adyen payments platform.
2 Merchant Account Unicode Text (80-character) The 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 Unicode Text (16-character) Adyen's 16-character unique reference associated with the transaction/the request. This value is globally unique; quote it when communicating with us about this request.
4 Merchant Reference Unicode Text (80-character) The reference that was specified in the payment request.
5 Payment Method Unicode Text (50-character) The payment method used for the transaction.
For example: visa, mc, amex.
6 Booking Date Date field + Time field The timestamp indicating when the event was entered into Adyen's accounting system. The format is YYYY-MM-DD HH:MM:SS.
For example: 2021-07-26 19:58:55.
  TimeZone Alpha Text (4-character limit) The time zone of the Booking Date column.
This is the ISO code for your time zone setting.
7 Main Currency Alpha Text (3-character limit) The three-character ISO code for the currency of the main amount.
  Main Amount Text field Numeric (16-Character limit) The amount recorded when the transaction reaches the Record Type. For example, the main amount of a Settled transaction is the amount after deducting payment processing fees.
8 Record Type Unicode Text (50-character) The accounting record type.
For a list of record types, see below.
9 Payment Currency Alpha Text (3-character limit) The three-character ISO code for the currency that was used to process the payment.
10 Received (PC) Fixed point number The amount (in Payment Currency) debited or credited on the Received accounting register.
11 Authorised (PC) Fixed point number The amount (in Payment Currency) debited or credited on the Authorised accounting register.
12 Captured (PC) Fixed point number The amount (in Payment Currency) debited or credited on the Captured accounting register.
13 Settlement Currency Alpha Text (3-character limit) The three-character ISO code for the currency that was used when settling the payment.
14 Payable (SC) Fixed point number The amount (in Settlement Currency) debited or credited on the Payable accounting register. This will be paid out to your bank account.
15 Commission (SC) Fixed point number 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.
16 Markup (SC) Fixed point number The fee charged by the acquiring bank (in Settlement Currency).
17 Scheme Fees (SC) Fixed point number The fee charged by, for example, Visa or Mastercard (in Settlement Currency).
18 Interchange (SC) Fixed point number The fee charged by the issuing bank (in Settlement Currency).
19 Processing Fee Currency Alpha Text (3-character limit) The three-character ISO code for the currency in which the processing (or gateway) fee is charged.
20 Processing Fee (FC) Fixed point number The amount (in Processing Fee Currency) charged on the Processing Fee accounting register.
21 User Name Unicode Text (80-character) 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 will be system.
22 Payment Method Variant Unicode Text (50-character) The sub-brand of the payment method (if applicable).
For example: visaclassic, visadebit, mccorporate.
23 Modification Merchant Reference Unicode Text (80-character) The optional modification reference for modifications, if specified in the transaction.

Record types

Record Type Description

Authorised

Payment approved by the financial institution.

AuthorisedPending

Payment authorisation is pending acceptance from the issuer.

Cancelled

Transaction cancelled.

CaptureFailed

Capture of a payment failed. For more information, refer to Failed capture.

Chargeback

Payment reversed by the bank/scheme/consumer.

SecondChargeback

Unsuccessful defense of first chargeback.

ChargebackExternally

Payment booked as a chargeback with external acquirer.

ChargebackExternallyWithInfo

Payment booked as a chargeback with external acquirer.

ChargebackReversed

Chargeback defended successfully, or the shopper re-paid the funds.

ChargebackReversedExternallyWithInfo

Chargeback defended successfully, or the shopper re-paid the funds.

Error

Transaction error.

Expired

Payment not captured within time limits.

PaidOut

Payout successfully completed.

PaidOutExternally

Payout successfully completed with external acquirer.

PaidOutExternallyWithInfo

Payout successfully completed with external acquirer.

PaidOutReversed

Payout returned to Adyen's account as it could not be credited to the shopper.

PayoutAuthorised

Payout successfully authorised.

PayoutError

Payout that resulted in an error.

PayoutFailed

Payout request was returned by the acquirer.

Received

Registration of a validated payment attempt.

ReceivedPayout

Payout received by the Adyen payments platform.

RefundAuthorised

Refund successfully authorised.

Refunded

Payment successfully refunded.

RefundedBulk

Payment successfully refunded through Adyen Acquiring.


This journal type will be deprecated.

 

RefundedExternally

Payment successfully refunded through an external acquirer.

RefundedExternallyWithInfo

Payment successfully refunded through an external acquirer.

RefundFailed

The refund failed. For more information, refer to Failed refund.

RefundedInInstallments

Payment has been fully refunded in installments.

RefundedInstallment

Payment installment has been refunded.

RefundedReversed

Refund returned to Adyen's account as it could not be credited to the shopper.

RefundNotProcessed

Refund has not been settled because the acquirer has not process the refund 30 days after initiation; however, the customer has received the funds. If the refund is processed after 30 days, you will see an additional Refunded record.

Refused

Payment was refused, either by the acquirer or by the Adyen fraud tool.

RefusedPayout

Payout was refused, either by the Adyen fraud tool or by the acquirer.

Retried

Payment request was retried.

SentForPayout

Payment sent for payout by the acquirer.

SentForRefund

Payment sent for refund by the acquirer.

SentForSettle

Request to transfer the payment sent to the financial institution.

Settled

Payment has been settled, and the funds have been received by Adyen.

SettledBulk

Payment has been settled through Adyen Acquiring.


This journal type will be deprecated.

 

SettledExternally

Payment has been settled with an external acquirer.

SettledExternallyWithInfo

Payment has been settled with an external acquirer.

SettledInInstallments

Payment has been fully captured in installments.

SettledInstallmentSuspendInstallment

Payment installment has been settled.

SettledReversed

Payment has not been settled because Adyen has not received the funds 30 days after capture. If Adyen receives the funds more than 30 days after capture, then you will see a Settled record.

SuspendInstallment

The installment will no longer be sent to the scheme due to a dispute in the transaction.

AdvancedInstallment

The installment was advanced.

AdvancedInstallmentCancelled

The advancement of the installment was cancelled.

OpenInstallment

An installment is still open. There are 4 possible states of an OpenInstallment:

Initial: A transaction was captured.

Representment: You successfully defended a dispute, and we have resumed suspended installments.

Retry: A capture failed, and is being retried.

Acceleration: The shopper requested a refund, but the amount in the refund request is greater than the amount received, so future installments are accelerated and the installment is closed. See CloseInstallment.

CloseInstallment

The installment will no longer be sent to the scheme and the OpenInstallment is closed.

 

Settlement Details Report

The Settlement Details Report is used to reconcile settlements on a transaction level. It includes the details of payments that have been settled and paid out to you in one batch by Ascend Pay. You can use this report to see the costs of each transaction and perform reconciliation on a transaction level. 

Under the header line, each line in the report is a separate entry. The types of entries include: Transactions, Transaction fees, Deposit corrections, Invoice deductions, and Payouts.

Each column shows specific information about the entries. The table below reflects the standard columns that are included in the report, and the default order:

# Column Description
1 Company Account The name of your company account as registered in the Adyen payments platform.
2 Merchant Account The name of the merchant account that was used to process the original payment request.
3 Psp Reference Adyen's 16-character unique reference associated with the transaction/the request. This value is globally unique; quote it when communicating with us about this request.
4 Merchant Reference The reference that was specified in the payment request.
5 Payment Method The payment method used for the transaction.
For example: visa, mc, amex.
6 Creation Date The timestamp indicating when the payment was created on the Adyen payments platform. Format: YYYY-MM-DD HH:MM:SS.
For example: 2012-07-26 19:58:55.
  TimeZone The time zone of the Creation Date.
This is the ISO code for your time zone setting.
7 Type* The Journal type of the entry.
8 Modification Reference*
  • For entries of Type Settled, Refunded, Chargeback, this is the modification PSP reference, a unique ID that identifies the modification request. Maximum length: 16 characters.
In some cases, the modification reference returned for entries of Type Chargeback is the same as the reference returned when the payment was captured. This is expected behavior.
  • For records of Type MerchantPayout, this is a description containing Account code, batch number, and the unique payout reference (TX...XT), which can also be found on the bank statement. Maximum length: 256 characters.
9 Gross Currency* The three-character ISO currency code for the transaction currency.
  Gross Debit (GC)* The amount submitted in the transaction request.
For example, 100.00.
  Gross Credit (GC)* The amount submitted in the transaction request.
For example, 100.00.
  Exchange Rate

The exchange rate used for converting the gross amount into the net amount.
This will be 1 if you process and settle in the same currency.

For externally settled payments, the listed exchange rate is Adyen's reference exchange rate, not the actual rate applied by the external acquirer.
10 Net Currency The three-character ISO currency code for the settlement currency.
  Net Debit (NC) The net amount debited from the Payable batch. For example, for a Refunded booking, this is the amount sent as part of the refund request plus any additional costs withheld.
  Net Credit (NC) The amount submitted in the transaction request minus transaction costs and fees.
For example, 98.26.
11 Commission (NC)

The commission fee that was withheld by the acquirer. This should be the difference between the gross and net amounts.
If the acquirer provides the transaction information at interchange level, Adyen splits the commission into:

 

  • Markup
  • Scheme Fees
  • Interchange

 

In this case, the Commission column is empty and columns Markup (12), Scheme Fees (13), and Interchange (14) are populated.
If the acquirer does not provide the transaction information at interchange level, Adyen populates the total commission in the column Commission (11).
In this case, columns Markup, Scheme Fees, and Interchange are empty.

 

For externally settled refunds (for example, American Express refunds), this amount will be negative. If you are automating your reconciliation, make sure your system can handle negative values.

 

12 Markup (NC) The fee charged by the acquiring bank. If the acquirer does not provide the transaction information at the interchange level, this field is empty.
13 Scheme Fees (NC) The fee charged by, for example, Visa or Mastercard. If the acquirer does not provide the transaction information at the interchange level, this field is empty.
14 Interchange (NC) The fee charged by the issuing bank. If the acquirer doesn't provide the transaction information at the interchange level, this field is empty.
15 Payment Method Variant The sub-brand of the payment method (if applicable).
For example: visaclassic, visadebit, mccorporate.
16 Modification Merchant Reference The optional modification reference for modifications, if specified in the transaction.
17 Batch Number The sequence number of the settlement.

Journal types

The journal types listed below correspond to the Type field.

Journal Type Occurrence Description
Fee* Debit The Adyen transaction fees for Received and SentForRefund transactions booked during the specified batch period.
MiscCosts* Debit/Credit The costs from externally settled payments that could not be matched with any specific transactions.
MerchantPayout* Debit The amount that is paid for a settlement currency from the payout batch to your bank account.
Refunded Debit A debit for a payment that was SentForRefund.
Settled Credit A credit for a payment that was SentForSettle.
Chargeback Debit A debit for a payment that is reversed by the bank/scheme/consumer.
SecondChargeback A debit Debit for an unsuccessful defense of a first chargeback.
ChargebackReversed Credit A previous chargeback that is credited to you after a payment is successfully defended, or after the shopper re-pays the funds.
RefundedReversed Credit A refund that is returned to our account because it cannot be credited to the shopper by the scheme/bank or is returned by the shopper.
DepositCorrection* Debit/Credit The funds being withheld from/released to the account due to a change in the required security deposit (coverage of the exposure on the account).
InvoiceDeduction* Debit/Credit A payment processing invoice that is credited/deducted from the account.If an invoice includes VAT/GST charges, you will see two separate bookings: costs/discounts and taxes. Details are specified in the Modification Reference column.
MatchedStatement Debit/Credit A wire transfer from merchant booked in the account.
ManualCorrected Debit/Credit A manual booking/adjustment by Adyen.
BankInstructionReturned Credit A credit for previous merchant payouts that were not processed successfully or that were returned to Adyen.
EpaPaid Debit/Credit An Electronic Payment Advice (EPA) from an external acquirer that was confirmed by the acquirer but not settled through Adyen.
Balancetransfer Debit/Credit A balance transfer to or from subsequent payout batches in order to process negative payable/capture balances or for batches that could not be paid out.
PaymentCost Debit/Credit

Used only in the following scenarios:

  • For Klarna payments, deductions such as dispute fees are booked using the PaymentCost journal type, referencing the PSP reference of the original payment.
  • For ELO payments, financial adjustments and arbitration costs are booked using the PaymentCost journal type.
  • For MasterCardPersonalPayments, when the transaction fee for the payout is booked.
  • For Visa disputes, financial adjustments will be booked on the corresponding transaction using the PaymentCost journal type.
  • For Mastercard disputes, the issuer can collect a dispute administration fee for disputes where a (pre-)arbitration case is filed, and the issuer wins. This fee will be booked using the PaymentCost journal type.
PaidOut Debit The net debit for a payout that was SentForPayout.
PaidOutReversed Credit A payout returned to Adyen's account because it could not be credited to the shopper by the scheme/bank or is returned by the shopper.
RefundedInstallment Debit The debit amount for a payment that was SentForRefund. This journal is used for credit transactions using an Adyen installments-capable acquirer (like Brazil and Mexico), regardless of whether the transaction is one-off or an installment.
SettledInstallment Credit The credit amount being settled for a credit card transaction created in installments. For installment-based transactions, the settled credit amount does not equal the whole amount that was SentForSettle. When it is a one-off transaction, then the credit amount that will be settled for this payment will equal the whole amount that was SentForSettle. If you have made an advancement, then the credit amount for this journal SettledInstallment will be zero.
SuspendInstallment Debit Indicates that submitting subsequent installments to the scheme has been suspended due to a chargeback requested by the issuing bank. If you have made an advancement of the installment settlement, then this journal will appear in the Settlement details report to indicate the debit to compensate the advanced amount.
CaptureFailed (Sales Day payout) Debit Capturing funds has failed for a transaction. In other words, these funds will not be received yet from the card scheme or payment method. A debit booking will be made to the next payout, because Adyen doesn't receive the pre-financed transaction amount from the card scheme or payment method.
RefundFailed (Sales Day payout) Credit A refund to a card or payment method has failed. If your account has already been debited for the refund, a credit booking is made to the next merchant payout (because Adyen will not have to pay for the refunded amount).
RefundNotCleared (Sales Day payout) Credit A refund hasn't been settled because the acquirer hasn't processed the refund 30 days after initiation. However, the customer has received the funds. No action is needed; adjustments to your balance happen automatically. If the refund is processed after 30 days, you will see an additional Refunded booking.
This journal type was formerly called RefundNotProcessed.
SettledReversed (Sales Day payout) Debit A debit that reverses a Settled transaction for which Adyen hasn't received the funds from the card scheme or payment method within 30 days of capture. No action is needed; adjustments to your balance happen automatically. If Adyen receives the funds after 30 days, you will see an additional Settled booking.
MerchantPayin Credit A credit transfer or direct debit booked in the account to fund the Reserve.
ReserveAdjustment Debit/Credit The funds being withheld from or released to the account due to funding or for using the Reserve register.
MerchantPayinReversed Debit A payment that was meant to top up or fund an account, goes through a chargeback.
XASTransfer Debit The funds debited to your platform's liable account. Used in classic Adyen for Platforms integrations. For more information, refer to Reconcile your platform's accounts receivable.

*The data type for these fields is Unicode Text (80-character) instead of Alpha Text (50-character).

 

KB24-006