Marketpay Balance Report

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.