The Balance Platform Balance Report shows the balances for every account holder, balance account, and balance account currency. You can use this report to reconcile the balances for each account holder in your balance platform. You can generate a Balance Report automatically based on a schedule, or manually in your Customer Area for a specific day.
Sample
Download a sample Balance Report for examples of the included data.
Based on your balance platform settings, the report you generate in your account can contain additional data or columns that are not included in the sample report.
Here is an example of what the report looks like.
| Balance Platform | Account Holder | Balance Account | Opening Balance Currency | Opening Balance Amount | Opening Date | Opening Time | Closing Balance Currency | Closing Balance Amount | Closing Date | Closing Time |
|---|---|---|---|---|---|---|---|---|---|---|
| YOUR_BALANCE_PLATFORM | AH00000000000000000000001 | BA00000000000000000000001 | USD | 10.00 | 2022-06-08 00:00:00 | CEST | USD | 5.00 | 2022-06-09 00:00:00 | CEST |
| YOUR_BALANCE_PLATFORM | AH00000000000000000000001 | BA00000000000000000000001 | CAD | 25.00 | 2022-06-08 00:00:00 | CEST | CAD | 85.00 | 2022-06-09 00:00:00 | CEST |
| YOUR_BALANCE_PLATFORM | AH00000000000000000000002 | BA00000000000000000000002 | USD | 60.00 | 2022-06-08 00:00:00 | CEST | USD | 70.00 | 2022-06-09 00:00:00 | CEST |
Report structure
The generated report takes the opening (00:00 AM) and closing (00:00 AM the next day) balance of all the accounts in your balance platform for the selected day. You can generate the report in the timezone configured for your balance platform, or in Central European Time (CET).
| # | Column | Data type | Description |
|---|---|---|---|
| 1 | Balance Platform | Unicode Text | Name of your Balance Platform account. |
| 2 | Account Holder | Unicode Text | Unique identifier of the account holder that owns the balance account. |
| 3 | Balance Account | Unicode Text | The unique identifier of the balance account. |
| 4 | Opening Balance Currency | Alpha Text (3-character limit) |
The currency of the balance amount at the date and time defined by the Opening Date column. Its value is a three-character ISO 4217 currency code. |
| 5 | Opening Balance Amount | Fixed point number | Available balance of the account at the time and date defined in the Opening Date column. |
| 6 | Opening Date | Date field + Time field | Timestamp indicating when . Format is YYYY-MM-DD HH:MM:SS. For example: 2021-06-02 00:00:00. |
| 7 | Opening TimeZone | Alpha Text (4-character limit) |
Time zone of the Opening Date column. |
| 8 | Closing Balance Currency | Alpha Text (3-character limit) |
The currency of the balance amount at the date and time defined by the Closing Date column. Its value is a three-character ISO 4217 currency code. |
| 9 | Closing Balance Amount | Fixed point number | Available balance of the account at the date and time defined by the Closing Date column. |
| 10 | Closing Date | Date field + Time field | Timestamp indicating when . Format is YYYY-MM-DD HH:MM:SS. For example: 2021-06-02 00:00:00. |
| 11 | Closing TimeZone | Alpha Text (4-character limit) |
Time zone of the Closing Date column. |
| 12 | Reserved1 | - | Reserved for future enhancements |
| 13 | Reserved2 | - | Reserved for future enhancements |
| 14 | Reserved3 | - | Reserved for future enhancements |
| 15 | Reserved4 | - | Reserved for future enhancements |
| 16 | Reserved5 | - | Reserved for future enhancements |
| 17 | Reserved6 | - | Reserved for future enhancements |
| 18 | Reserved7 | - | Reserved for future enhancements |
| 19 | Reserved8 | - | Reserved for future enhancements |
| 20 | Reserved9 | - | Reserved for future enhancements |
| 21 | Reserved10 | - | Reserved for future enhancements |