---
title: "Build a transactional ledger"
description: "Track transactions for each account holder and account in your platform."
url: "https://docs.adyen.com/classic-platforms/reconciliation-use-cases/build-transactional-ledger"
source_url: "https://docs.adyen.com/classic-platforms/reconciliation-use-cases/build-transactional-ledger.md"
canonical: "https://docs.adyen.com/classic-platforms/reconciliation-use-cases/build-transactional-ledger"
last_modified: "2023-03-28T13:38:00+02:00"
language: "en"
---

# Build a transactional ledger

Track transactions for each account holder and account in your platform.

[View source](/classic-platforms/reconciliation-use-cases/build-transactional-ledger.md)

This page is for classic Adyen for Platforms integrations. If you are just starting your implementation, refer to our [new integration guide](/adyen-for-platforms-model) instead.

To break down the amounts credited or debited for the [accounts in your platform](/classic-platforms/account-structure/#your-platform), use the [Marketplace Payments accounting report](/reporting/marketpay-payments-accounting-report). The report contains all the financial activities within your platform—useful when creating a transactional ledger for your account holders or to reconcile your records.

You can use the information in the Marketplace Payments accounting report to:

* Track credits resulting from payments and transfers.
* Track debits resulting from refunds, chargebacks, transfers, fees, and payouts.
* Reconcile the balance of your platform's liable account, from which Adyen deducts all payment fees.

## Split data in reports

Adyen credits funds to the accounts in your platform based on the [split instructions](/classic-platforms/processing-payments#providing-split-instructions) that you provide at the time of payment or capture. The split information is reflected in the Marketplace Payments accounting report.

If you split a payment between two accounts, the split is reflected in two separate rows that credits each account with the specified split amount. The same applies for refunds; a refund split between two accounts results in two rows indicating a debit to each account.

If you do not provide instructions for the split instructions, Adyen credits or debits the amount to or from your liable account. For example, if you do not provide split instructions in a partial refund, Adyen debits the funds from your liable account. The aggregate of these debits and credits are reflected in the report with a **TransferBalance** [record type](/classic-platforms/reports-and-fees/marketplace-payments-accounting-report#record-types).

All the transaction fees are deducted from your liable account. The total fees are reflected in the row with **Fee** record type.

## Example

We show selected rows and columns below to illustrate how you can track transactions. To get a complete report, refer to [Marketplace Payments accounting report](/reporting/marketpay-payments-accounting-report).

In this example, we group the transactions for the same **Account holder** and **Account** by using different colors for each.

### Selected columns from Marketplace Payments accounting report

| Account holder              | Account | Payment PSP reference | Payment merchant reference number | Main currency | Main amount | Record type |
| --------------------------- | ------- | --------------------- | --------------------------------- | ------------- | ----------- | ----------- |
| LiableAccountHolderPlatform | 1234567 | 852584129291587A      | REF\_001                          | EUR           | 60          | Credited    |
| AccountHolder\_1            | 7891012 | 852584129291587A      | REF\_001                          | EUR           | 240         | Credited    |
| LiableAccountHolderPlatform | 1234567 | 853781278121997C      | REF\_002                          | EUR           | -2          | Debited     |
| AccountHolder\_2            | 3823129 | 853781278121997C      | REF\_002                          | EUR           | -48         | Debited     |
| LiableAccountHolderPlatform | 1234567 | 852584132050336H      | REF\_003                          | EUR           | 30          | Credited    |
| AccountHolder\_2            | 3823129 | 852584132050336H      | REF\_003                          | EUR           | 120         | Credited    |
| LiableAccountHolderPlatform | 1234567 |                       |                                   | EUR           | -9.72       | Fee         |
| AccountHolder\_1            | 7891012 |                       |                                   | EUR           | -240        | Payout      |

When you filter based on the **Account holder** and **Account**, you can get transactions for each account holder and account in your platform. Below is an example of a summary of their transactions.

| Account holder              | Account | Transactions                                              |
| --------------------------- | ------- | --------------------------------------------------------- |
| LiableAccountHolderPlatform | 1234567 | Credited EUR 90, Debited EUR 2, Debited EUR 9.72 for fees |
| AccountHolder\_1            | 7891012 | Credited EUR 240, Paid out EUR 240                        |
| AccountHolder\_2            | 3823129 | Debited EUR 48, Credited EUR 120                          |

Note: to find out more about transaction identifiers, refer to [Combining reports](/classic-platforms/prepare-reports#combine-reports).

## Getting the balance for each account

You can calculate the balance of an account holder's account by tracking all the credits, debits, and payouts for each account holder and account in the Marketplace Payments accounting report.

Alternatively, you can also use the [MarketPay balance report](/classic-platforms/reports-and-fees/marketpay-balance-report) where you can get the available balances of all the accounts in your platform, including your liable account.

### Negative balances

Accounts in your platform can have a negative balance as a result of refunds or chargebacks. Adyen allows negative balances for up to 30 days. At the end of the month, if an account has had a negative balance for more than 30 days, Adyen compensates by debiting the amount from your platform's liable account. If you'd rather have account holders cover their negative balances instead, you can provide them the option to [top up their accounts](/classic-platforms/top-up-accounts).

When Adyen compensates a negative balance, this will be reflected in an entry of record type **FundTransfer** in the Marketplace Payments accounting report. The description provides more information about the negative balance compensation, for example, *Compensate negative balance from account 1 to account 2*.

Note that negative balances only occur as a result of refunds or chargebacks. An account cannot have a negative balance due to paying out or transferring a balance. You can only pay out or transfer the available balance.

### Example

We show selected rows and columns below to illustrate how you can get an overview of the balances per account. To get a complete report, refer to [Marketpay Balance Report](/classic-platforms/reports-and-fees/marketpay-balance-report).

The example below shows what the corresponding balances will be based from the [previous example](#selected-columns-from-marketplace-payments-accounting-report).

#### Selected columns from Marketpay Balance Report

| Account holder              | Virtual account | Currency | Balance |
| --------------------------- | --------------- | -------- | ------- |
| LiableAccountHolderPlatform | 1234567         | EUR      | 78.28   |
| AccountHolder\_1            | 7891012         | EUR      | 0       |
| AccountHolder\_2            | 3823129         | EUR      | 72      |

## See also

* [Adyen for Platforms account structure](/classic-platforms/account-structure)
* [Marketplace Payments accounting report](/reporting/marketpay-payments-accounting-report)
* [Marketpay Balance Report](/reporting/settlement-reconciliation/transaction-level/marketpay-balance-report)
