Cash Account Demonstrative
Overview
The cash_account_demonstrative report is a daily statement of the movements and balances of the fund's bank accounts at the end of the day. It is generated once a day, after the financial cycle closes, and presents the opening (D-1) and closing (D0) balances of each account, as well as all transactions that occurred throughout the day. Managers and administrators use this report to verify the cash position and reconcile the fund's financial movements.
The report can be generated in single-fund or multi-fund mode. In multi-fund mode, each fund class is presented in a separate tab within the same spreadsheet.
File Structure
| Attribute | Value |
|---|---|
| Format | XLSX |
| Naming | {fund_short_name}_cash_account_demonstrative_{YYYY-MM-DD}.xlsx |
Spreadsheet Content
Each tab of the spreadsheet (one per fund) contains the following sections:
Fund Header
Displayed at the top of the tab, with identification information for the fund class:
| Field | Description |
|---|---|
| Reference date | Report reference date in YYYY-MM-DD format. |
| Fund class name | Full name of the fund class. |
| Fund class CNPJ | Fund class CNPJ. |
| Manager name | Name of the fund manager. |
| Manager CNPJ | CNPJ of the fund manager. |
Statement per Bank Account
For each of the fund's bank accounts, a table is displayed with the following columns:
| Column | Type | Format / Example | Description |
|---|---|---|---|
Reference date | date | 2024-01-15 | Report reference date. |
Bank | string | "329 - QI SCD" | Financial institution code and name in the format {code} - {name}. |
Branch/Account | string | "0001/12345-6" | Branch and account number in the format {branch}/{account}-{digit}. |
Description | string | "Asset settlement" | Movement description according to the transaction's reconciliation group. |
Amount (BRL) | number | 10000.00 | Movement amount in BRL. Negative values indicate cash outflows. |
Each account table also displays two summary rows:
| Row | Description |
|---|---|
| D-1 Balance | Account balance at the beginning of the day (previous day's closing). |
| D0 Balance | Account balance at the close of the reference day. |
| Total | Sum of all day's movements for the account. |