Daily ending balance report
The daily ending balance report provides the account balance information of the marketplace and its sub-merchants at 23:59 on the T day.
Report details
The daily ending balance report consists of three parts: header information, information about daily ending balance, and the end-of-file <END> that appears in the last line of the report. The header information is represented by parameter names, and the information of the daily ending balance is represented by the corresponding values of the parameters.
The following table shows the parameters in the daily ending balance report and parameter descriptions:
Parameter | Description |
merchantId | MANDATORY String (64) The unique ID assigned by Alipay to identify a marketplace or a sub-merchant. |
referenceMerchantId | OPTIONAL String (64) The unique ID of a sub-merchant that directly provides services or goods to users, assigned by the marketplace to its sub-merchants. The value of this parameter needs to be the same as that of the referenceMerchantId parameter in the original payment or authorization request. If the value of merchantId represents a marketplace, the value of this parameter is empty. |
accountNo | MANDATORY String (32) The unique account number that Alipay assigns to a marketplace or a sub-merchant. |
accountCurrency | MANDATORY String (3) The currency associated with accountNo, specified by a 3-letter currency code as defined in ISO 4217. |
balance | MANDATORY String (16) The ending balance of the account. |
accountDate | MANDATORY String (64) The date when the ending balance is recorded, in the format of YYYY-MM-DD. |
Report sample
The following sample shows the daily ending balance report of a marketplace and its sub-merchant.
merchantId | referenceMerchantId | accountNo | accountCurrency | balance | accountDate |
2159110286065381 | None | 21590000000000010986 | BRL | 1177 | 20230901 |
2159110286271340 | seller1023 | 21590000000000010987 | BRL | 277 | 20230901 |
Download a sample of the account activity report in CSV format: 📎Daily ending balance report.csv