Search

Are you looking for test card numbers?

Would you like to contact support?

Reportin icon

Marketpay Balance Report

Use this report for an overview of the account balances across your marketplace.

About this report

This report is based on the time zone setting of your account.
See Downloading reports.

Moving funds around your platform and your account holders can get complicated, especially if you're dealing with many sellers or using complex payment flows. The Marketpay Balance Report gives you all balance information for your platform in one place, across account holders and accounts.

You can use this report to reconcile the balances of the accounts in your platform.

Report name format: MarketPay_balance_{MarketPlaceCode}_YYYY_MM_DD.csv
Subscription : Default
Frequency : Daily, Weekly, or Monthly

Download a sample report

To get an idea of the kind of data that you will see in the Marketpay Balance Report, you can download a sample report here.

Report structure

The first four rows of the report contain the following information.

MarketPay Balance Report
Report Time
YYYY-MM-DD HH:MM:SS.0
Accounts balance

The header row is in the fifth row and contains the following information.

# Column Data type Description
1 Marketplace Unicode Text Name of your marketplace or platform.
2 Account Holder Unicode Text The accountHolderCode you provided when you created the account holder.
3 Virtual Account Unicode Text
(Either 9- or 16-character limit)
The accountCode of the account that belongs to the account holder.
4 Currency Alpha Text
(3-character limit)
Three-character ISO currency code.
5 Balance Fixed point number Available balance on the Virtual Account in the currency defined in the Currency column. The amount is in minor units.
6 Pending Credit Fixed point number Pending Credit balance that is available on the Virtual Account in the currency defined in the Currency column. The amount is in minor units.
7 Pending Debit Fixed point number Pending Debit balance on the Virtual Account in the currency defined in the Currency column. The amount is in minor units.