Cash Movements
Overview
The cash_account_demonstrative_movements report lists, transaction by transaction, all the movements of the fund's bank accounts on the reference date. It is the tabular version of the Cash Statement: while the statement is a spreadsheet formatted for reading, this file is a CSV designed for automated reconciliation, with the identifier of each transaction, the type, the reconciliation status and the balances before and after the entry.
The transactions recorded between 03:00 (UTC) of the reference date and 03:00 (UTC) of the following day are considered — that is, the whole day in Brasília time. The lines come ordered by transaction date and time.
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 | CSV |
| Encoding | UTF-8 |
| Delimiter | , (comma) |
| Header | Yes (first line) |
| Naming | {short_fund_name}_cash_account_demonstrative_movements_{YYYY-MM-DD}.csv |
The amount, previous_balance and post_balance columns are integers in cents — 241786 means R$ 2,417.86. Unlike the other reports, which carry values in reais.
Columns
| Column | Type | Format / Example | Description |
|---|---|---|---|
fund_class_name | string | "FUNDO EXEMPLO FIDC RESPONSABILIDADE LIMITADA" | Name of the fund class. |
fund_class_document_number | string | "11.222.333/0001-81" | CNPJ of the fund class. |
account_number | string | "4417206" | Bank account number, without the digit. |
account_digit | string | "9" | Check digit of the account. |
account_branch | string | "0001" | Branch of the account. |
if_name | string | "BANCO EXEMPLO S.A." | Name of the financial institution. |
if_code | string | "999" | COMPE code of the financial institution. |
if_ispb | string | "99999999" | ISPB of the financial institution. |
transaction_key | string | "30c40d50-0001-4ddd-9444-000000000401" | Unique identifier of the transaction at QI DTVM (UUID). |
external_key | string | "40d50e60-0001-4eee-9555-000000000501" | Identifier of the transaction at the originating financial institution. |
transaction_description | string | "Liquidação de parcelas de CCB" | Description of the transaction as provided by the financial institution. |
transaction_type | string (enum) | "incoming_pix" | Transaction type. See the types table. |
transaction_status | string (enum) | "reconciled" | Reconciliation status: created, pending_conciliation or reconciled. |
amount | integer (cents) | 241786 | Transaction value. A negative value indicates a cash outflow. |
previous_balance | integer (cents) | 52811947 | Balance of the account before the transaction. |
post_balance | integer (cents) | 53053733 | Balance of the account after the transaction. |
transaction_datetime | date | 2026-07-29 | Date and time of the transaction. In the file, the field is exported with the date only, in the YYYY-MM-DD format. |
accounting_date | date | 2026-07-29 | Accounting date assigned to the transaction. |
conciliation_description | string | "Liquidação de parcelas" | Description of the reconciliation group the transaction was associated with. Empty while the transaction is not reconciled. |
Transaction types
| Value | Description |
|---|---|
incoming_pix | Pix received. |
outgoing_pix | Pix sent. |
incoming_wire_transfer | Incoming TED. |
outgoing_wire_transfer | Outgoing TED. |
outgoing_bank_slip_payment | Bankslip payment. |
incoming_bank_slip_payment_reversal | Bankslip payment reversal. |
outgoing_bankslip_registration | Bankslip registration cost. |
outgoing_bankslip_payment | Bankslip payment cost. |
outgoing_bankslip_due_date_extension | Bankslip due date extension cost. |
outgoing_bankslip_permanence | Bankslip permanence cost. |
outgoing_bankslip_rebate | Bankslip rebate cost. |
outgoing_bankslip_write_off | Bankslip write-off cost. |
outgoing_ted_fee | Fee for an outgoing TED. |
outgoing_pix_fee | Fee for an outgoing Pix. |
incoming_pix_fee | Fee for receiving a Pix. Despite the incoming prefix, it is a cash outflow. |
incoming_reversal | Reversal received for an outgoing transaction. |
incoming_pix_reversal | Refund received for an outgoing Pix. |
outgoing_pix_block | Block of an amount related to Pix. |
incoming_pix_unblock | Release of an amount blocked due to Pix. |