Cash Statement
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 is closed, and it presents the opening (D-1) and closing (D0) balances of each account, as well as all the transactions that occurred during the day. Managers and administrators use this report to check the cash position and to reconcile the fund's financial movements.
The report can be generated in single-fund mode or in multi-fund mode. In multi-fund mode, each fund class is presented in a separate tab within the same spreadsheet.
What you need to provide
| Variable | Required | Description |
|---|---|---|
fund_class_key | yes | Identifier of the fund class the report is generated for. |
reference_date | yes | Reference date, in the YYYY-MM-DD format. |
File Structure
| Attribute | Value |
|---|---|
| Format | XLSX |
| Tab | Demonstrativo de Caixa (in multi-fund mode, one tab per fund, named with the first 31 characters of the fund name — Excel's limit for a tab name) |
| Naming | {short_fund_name}_cash_account_demonstrative_{YYYY-MM-DD}.xlsx |
This report is a spreadsheet formatted for reading. To reconcile the movements in an automated way — with a transaction identifier, type, reconciliation status and balances before and after each entry — use the Cash Movements report, in CSV.
Spreadsheet Content
Each tab of the spreadsheet (one per fund) contains the following sections:
Fund Header
Presented at the top of the tab, with the identification information of the fund class:
| Field | Description |
|---|---|
| Data de referência | Reference date of the report in the YYYY-MM-DD format. |
| Nome da classe de fundo | Full name of the fund class. |
| CNPJ da classe de fundo | CNPJ of the fund class. |
| Nome da gestora | Name of the manager responsible for the fund. |
| CNPJ da gestora | CNPJ of the manager responsible for the fund. |
Statement by Bank Account
Below the header, under the Extrato title, one table per bank account of the fund is shown. The column names below are the literal headers of the spreadsheet in a delivery configured in Portuguese, the default. In a delivery configured in English, the tab name, the headers and the summary labels are translated (for example, Cash Statement, Bank, Pix identifier, Amount (BRL), Opening balance (D-1)).
| Column | Type | Format / Example | Description |
|---|---|---|---|
Data de referência | date | 2026-07-29 | Reference date of the report. |
Banco | string | "999 - BANCO EXEMPLO S.A." | COMPE code and name of the financial institution, in the {code} - {name} format. |
Agência/Conta | string | "0001/4417206-9" | Branch and account number, in the {branch}/{account}-{digit} format. |
Descrição | string | "Liquidação de parcelas" | Description of the movement according to the reconciliation group of the transaction. |
Identificador do Pix | string | "E99999999202607291200ABCDEFGHIJK" | End-to-end identifier (end_to_end_id) of the Pix transaction. Empty when the movement is not a Pix. |
Valor (R$) | number | 2417.86 | Value of the movement in reais. Negative values indicate a cash outflow. |
Each account table also shows three summary lines, in bold and with a gray background. On those lines, the label (Saldo D-1, Total, Saldo D0) occupies the first column, in place of the reference date:
| Line | Position | Description |
|---|---|---|
| Saldo D-1 | first line of the table | Balance of the account at the start of the day (closing of the previous day). |
| Total | after the movements | Sum of all the movements of the day for the account. |
| Saldo D0 | last line of the table | Balance of the account at the closing of the reference day. |