Are you looking for test card numbers?

Would you like to contact support?

Marketpay icon

Balance Platform Accounting Report

Get an overview of all financial activities on your platform.

You can use the information from the Accounting Report to:

  • Track all processed payments.
  • Track internal transfers between balance accounts.
  • Track payouts to your users' bank accounts.
  • Track payment fees, costs, and invoice deductions.

  • You can generate the report automatically based on a schedule, or manually for a specific day in your Balance Platform Customer Area.

    Transfers and Transactions

    Most events on your balance platform follow the same structure. The structure contains a Transfer and Transactions.

    • Transfer: Events where the credit or debit is pending and no real money movement has taken place. The payment or transfer is initiated and then authorized or refused. Linked events share the same Transfer Id. Refunds initiate a new flow where separate received and authorised payments are created with a new Transfer Id that does not link to the original payment.
    • Transactions: Events where the credit and debit are booked on the balance and real money movement has taken place. If there is no Transaction Id available, no money movement has taken place yet. You can link a transaction to a transfer by matching the Transfer Id.

    Sample

    Download a sample BalancePlatform Accounting Report for examples of the included data. Based on your platform settings, the report that you generate may contain additional data or columns that are not included in the sample report.

    Report structure

    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. You can generate the report in the timezone configured for your platform, or in Central European Time (CET).

    # Column Data type Description
    1 Balance Platform Unicode Text Name of your Balance Platform account.
    2 Account Holder Unicode Text Unique identifier of the account holder that owns the balance account.
    3 Balance Account Unicode Text The unique identifier of the balance account.
    4 Transfer Id Unicode text The unique identifier of a pending debit or credit.
    5 Transaction Id Unicode text The unique identifier of a transaction, reflects a completed debit or credit.
    6 Category Enum The category of the transaction. Possible values: platformPayment, internal, bank, issuedCard.
    7 Status Enum The status of the event. Example value: authorised
    8 Type Enum The type of transfer or transaction. Example value: refund
    9 Booking Date Date field + Time field Date of the booking.
    10 Booking Date Time Zone Alpha Text
    (4-character limit)
    The time zone of the location where the booking happened.
    11 Value Date Date field + Time field The date when the funds are available.
    12 Value Date Time Zone Alpha Text
    (4-character limit)
    The time zone of the location where the funds are available.
    13 Currency Alpha Text
    (3-character limit)
    The default currency of the balance account. Its value is a three-character ISO 4217 currency code.
    14 Amount Alpha text The amount of the transfer or transaction.
    15 Original Currency Alpha text
    (3-character limit)
    The currency of the payment amount as received from the acquirer.
    Its value is a three-character ISO 4217 currency code.
    16 Original Amount Fixed point number The payment amount in the currency defined in Original Currency.
    17 Payment Currency Alpha Text
    (3-character limit)
    The currency of the payment.
    18 Received (PC) Fixed point number (16-Character limit) Amount (in Payment Currency) debited or credited on the Received accounting register.
    19 Reserved (PC) Fixed point number (16-Character limit) Amount (in Payment Currency) debited or credited on the Reserved accounting register.
    20 Balance (PC) Fixed point number (16-Character limit) Amount (in Payment Currency) debited or credited on the Balance accounting register.
    21 Reference Unicode text Your reference for the transfer.
    22 Description Unicode text Your description for the transfer.
    23 Counterparty Balance Account Id Unicode text The unique identifier of the destination of the transfer.
    24 Psp Payment Merchant Reference Unicode Text
    (16-character limit)
    The PSP merchant reference of a payment.
    25 Psp Payment Psp Reference Unicode Text
    (16-character limit)
    The PSP reference of a payment.
    26 Psp Modification Psp Reference Unicode Text
    (16-character limit)
    The PSP modification reference of a payment.
    27 Psp Modification Merchant Reference Unicode Text
    (16-character limit)
    The merchant modification reference of a payment.
    34 Counterparty Name Unicode text The name of the merchant that initiated the payment.
    35 Counterparty Address Unicode text The address of the merchant that initiated the payment.
    36 Counterparty City Unicode text The city of the merchant that initiated the payment.
    37 Counterparty Country Unicode text The country of the merchant that initiated the payment. Its value is a three-character ISO 3166-1 alpha-3 country code.
    38 Counterparty iban Unicode text The IBAN of the merchant that initiated the payment.
    39 Counterparty bic Alpha text The BIC of the bank of the merchant that initiated the payment.
    40 Counterparty Account Number Unicode Text The account number of the merchant that initiated the payment.
    41 Counterparty Postal Code Unicode Text The postal code of the merchant that initiated the payment.
    42 Interchange Currency Unicode Text The currency of the interchange.
    43 Interchange Unicode Text The amount of interchange.
    44 Beneficiary Balance Account Unicode Text The unique identifier of the beneficiary balance account associated with your platform.
    46 Reference for Beneficiary Unicode Text Your reference for the beneficiary.
    47 Reserved1 - Reserved for future enhancements
    48 Reserved2 - Reserved for future enhancements
    49 Reserved3 - Reserved for future enhancements
    50 Reserved4 - Reserved for future enhancements
    51 Reserved5 - Reserved for future enhancements
    52 Reserved6 - Reserved for future enhancements
    53 Reserved7 - Reserved for future enhancements
    54 Reserved8 - Reserved for future enhancements
    55 Reserved9 - Reserved for future enhancements
    56 Reserved10 - Reserved for future enhancements

    Next steps

    You can use the Accounting Report for the following common processes.