Issuin icon

Balance Platform Accounting Report

Get an overview of the financial activities on your platform.

You can use the information from the Accounting Report to:

  • Track the payment lifecycle by checking the statuses of rows with a shared Transfer Id.
  • Track incoming and outgoing funds to and from external bank accounts.
  • Create insights into your authorization rate.

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, authorised, and refunded events 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. A status of cancelled has a Transaction Id even though there is no real money movement. This allows you to reconcile the cancellation with the corresponding payment.

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 Accounting Report has standard columns that are included by default in every report, and additional columns you can add to reports by contacting our Support Team.

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

Standard columns

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

# Column Financial service Data type Description
1 Balance Platform issuing
payouts
platform payments
Unicode Text Name of your Balance Platform account.
2 Account Holder issuing
payouts
platform payments
Unicode Text Unique identifier of the account holder that owns the balance account.
3 Balance Account issuing
payouts
platform payments
Unicode Text The unique identifier of the balance account.
4 Transfer Id issuing
payouts
platform payments
Unicode text The unique identifier of a pending debit or credit.
5 Transaction Id issuing
payouts
platform payments
Unicode text The unique identifier of a transaction, reflects a completed debit or credit.
6 Category issuing
payouts
platform payments
Enum The category of the transaction. Possible values:
  • platformPayment
  • internal
  • bank
  • issuedCard
7 Status issuing
payouts
platform payments
Enum The status of the event. Example values: authorised, chargeback.
8 Type issuing
payouts
platform payments
Enum The type of transfer or transaction. Example values: refund, chargeback.
9 Booking Date issuing
payouts
platform payments
Date field + Time field Date of the booking.
10 Value Date issuing
payouts
platform payments
Date field + Time field The date when the funds are available.
11 Value Date Time Zone issuing
payouts
platform payments
Alpha Text
(4-character limit)
The time zone of the location where the funds are available.
12 Currency issuing
payouts
platform payments
Alpha Text
(3-character limit)
The three-character ISO currency code for the balance account.
Amount issuing
payouts
platform payments
Alpha text The amount of the transfer or transaction.
13 Original Currency issuing Alpha text
(3-character limit)
The three-character ISO currency code of the payment amount as reported by the acquirer.
14 Original Amount issuing Fixed point number The payment amount in the currency defined in Original Currency.
15 Payment Currency issuing
payouts
platform payments
Alpha Text
(3-character limit)
The currency of the payment.
Received (PC) issuing
payouts
platform payments
Fixed point number
(16-character limit)
The amount (in Payment Currency) debited or credited on the Received accounting register.
16 Reserved (PC) issuing
payouts
platform payments
Fixed point number
(16-character limit)
The amount (in Payment Currency) debited or credited on the Reserved accounting register.
17 Balance (PC) issuing
payouts
platform payments
Fixed point number
(16-character limit)
The amount (in Payment Currency) debited or credited on the Balance accounting register.
18 Reference issuing
payouts
platform payments
Unicode text The unique identifier of a pending debit or credit.
19 Description issuing
payouts
platform payments
Unicode text 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
Unicode text The unique identifier of the destination of the transfer.
21 Psp Payment Merchant Reference platform payments Unicode Text
(16-character limit)
The PSP merchant reference of a payment.
22 Psp Payment Psp Reference platform payments Unicode Text
(16-character limit)
The PSP reference of a payment.
23 Psp Modification Psp Reference platform payments Unicode Text
(16-character limit)
The PSP modification reference of a payment.
24 Psp Modification Merchant Reference platform payments Unicode Text
(16-character limit)
The PSP modification reference of a payment.
25 Payment Instrument Type issuing Unicode text The type of the payment instrument used in the payment.
26 Payment Instrument Id issuing Unicode text The unique identifier of the payment instrument.
27 Entrymode issuing Unicode text 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 Text field numeric A unique authorization code generated for the payment. This code should be included when canceling or refunding a payment.
29 Shopper Interaction issuing Alpha text
(30-character limit)
Transaction type. Possible values:
  • Ecommerce
  • ContAuth
  • POS
  • Moto
30 MCC issuing Text field numeric The merchant category code of the merchant that initiated the payment.
31 Counterparty Name issuing Unicode text The name of the merchant that initiated the payment.
32 Counterparty Address issuing Unicode text The address of the merchant that initiated the payment.
33 Counterparty City issuing Unicode text The city of the merchant that initiated the payment.
34 Counterparty Country issuing Unicode text The ISO country code of the merchant that initiated the payment.
35 Counterparty iban payouts Unicode text The IBAN of the merchant that initiated the payment.
36 Counterparty bic payouts Alpha text The BIC of the bank of the merchant that initiated the payment.
37 Counterparty Account Number payouts Unicode Text The account number of the merchant that initiated the payment.
38 Counterparty Postal Code issuing
payouts
Unicode Text The postal code of the merchant that initiated the payment.
39 Interchange Currency issuing Unicode Text The currency of the interchange.
Interchange issuing Unicode Text The amount of interchange.
40 Beneficiary Balance Account issuing Unicode Text The unique identifier of the beneficiary balance account associated with your balance platform.
41 Brand variant issuing Unicode text The brand variant for the payment instrument. For example: mcdebit, visaprepaid.
42 Reference for Beneficiary payouts Unicode Text Your reference for the beneficiary.
43 Platform Payment Interchange platform payments Fixed point number 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 Fixed point number 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 Fixed point number 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 Fixed point number 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 Alpha text
(3-character limit)
The currency of the Platform Payment Cost fields.
47 Account Holder Description issuing
payouts
platform payments
Unicode Text Your description for the account holder.
48 Account Holder Reference issuing
payouts
platform payments
Unicode Text Your reference for the account holder.
49 Balance Account Description issuing
payouts
platform payments
Unicode Text Your description for the balance account.
50 Balance Account Reference issuing
payouts
platform payments
Unicode Text Your reference for the balance account.
51 Reserved 1 - - Reserved for future enhancements.
52 Reserved 2 - - Reserved for future enhancements.
53 Reserved 3 - - Reserved for future enhancements.
54 Reserved 4 - - Reserved for future enhancements.
55 Reserved 5 - - Reserved for future enhancements.
56 Reserved 6 - - Reserved for future enhancements.
57 Reserved 7 - - Reserved for future enhancements.
58 Reserved 8 - - Reserved for future enhancements.
59 Reserved 9 - - Reserved for future enhancements.
60 Reserved 10 - - Reserved for future enhancements.

Additional columns

The following table reflects additional Accounting Report columns.

By default, these columns are not included in the Accounting Report. To add any of these columns to your reports, contact our Support Team.

Column Financial service Data type Description
Payment Instrument Reference issuing String Your reference to the payment instrument.
Payment Instrument Description issuing String The description provided for the payment instrument.
Event Id issuing String Id to identify unique events on a single transfer. For example: multiple authorization adjustments or cancellations.

Next steps

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