DTVM Reports

The DTVM reports provide a detailed view of the operations and financial positions of the investment funds administered by QI DTVM. They are intended for managers and analysts who need to track the portfolio composition, the acquisitions and settlements of assets, and the fund's cash movement on each reference date.

Report examples

Download examples of all the available reports: example_reports.zip

The package contains one file of each report, with the same layout as the files generated in production and fictitious data. All of them describe the same fund (FUNDO EXEMPLO FIDC RESPONSABILIDADE LIMITADA) on the same reference date (2026-07-29). The position reports — wallet compositions, quotas, cash and ANBIMA XMLs — reconcile with one another: net worth, cash balance and position by asset class are the same in all of them. The balance sheet and the accounting ledger use their own set of entries, only to illustrate the layout.

File naming

All the files follow the {short_fund_name}_{model}_{reference_date}.{extension} pattern, where:

• short fund name is the base report name registered for the fund class, in lowercase and without accents (in the examples, example_name);
• model is the name of the report, as shown in the "Model" column of the table below;
• reference date is in the YYYY-MM-DD format.

The prefix comes from the fund class registration, not from the delivery configuration. If you need a different prefix, talk to the integration team. Deliveries configured in English receive the _EN suffix before the extension.

There are four exceptions to the pattern: wallet_composition_by_composition is delivered as wallet_composition (without the model suffix); xml_5_by_composition follows the ANBIMA standard name, FD{fund CNPJ, digits only}_{YYYYMMDD}.xml; assignment_assets_wallet_composition appends the assignment identifier to the end of the name; and assignment_documents places the assignment identifier before the date, which in its case is the file generation date.

Period reports

quota_mec, balance_report and accounting_ledger are generated from a range (start_date / end_date), not from a single date. In those cases, the date in the file name is the reference_date set in the routine; when the routine does not set a reference_date, it is the file generation date, in Brasília time. The Consolidated Conciliation optionally accepts a range (reference_date / end_date); the file name carries the reference_date, the first day of the range.

CSV file conventions

These apply to all the CSV reports:

Attribute	Standard
Encoding	UTF-8, without BOM
Delimiter	, (comma)
Decimal separator	. (period)
Line ending	CRLF (\r\n)
Header	always present, on the first line, with the column names in lowercase

The delimiter and the decimal separator are configurable

If your process requires ; as the delimiter or , as the decimal separator, QI DTVM can configure that per fund in the delivery. Without a specific configuration, the defaults in the table above apply. The exceptions are quota_mec in CSV, which uses ; by definition of the report, and assignment_documents, which always uses , as the delimiter and . as the decimal separator.

How the reports are delivered

The delivery is organized into routines, configured per fund. Each routine defines three things: which reports are included, with which frequency, and to which destination.

Element	Options
Frequency	daily · weekly (first business day of the week) · monthly (last business day of the month)
Destination	SFTP · e-mail

The same fund can have more than one routine — for example, a daily one over SFTP and a monthly one by e-mail. To include or remove a report, change the frequency or the destination, contact the integration team.

When the routine is triggered

The trigger is the day-end closing of that fund, not a fixed time. The closing only happens on a business day, and it triggers the reports at three distinct moments:

Moment	Contains
Pre-quota	Reports calculated before the quota of the day is computed.
Closing	Reports of the consolidated position of the day, with the closing quota.
Opening	Reports calculated on the opening quota.

Opening reports use as their reference date the business day before the accounting date being opened — that is the date shown in the file name.

Each report is delivered at the moment defined in the fund's routine configuration — that is why the files of the same day do not all arrive together. A weekly or monthly routine only materializes files on the date its frequency falls on; on the other days the closing runs and it produces nothing.

Reports outside the routine

Two reports do not follow the frequency of the routine, because they belong to an operation rather than to the fund's day: the Assignment Assets Composition and the Assignment Collateral. Both are generated when the assignment enters the approval stage, provided they are enabled in the assignment configuration, and they are delivered to the destination defined in the assignment configuration.

They do not emit the Delivery Webhook — tracking is done through the assignment batch status webhook.

Delivery via SFTP

Each file is written to the folder configured for the fund, with exactly the name described above. For connection instructions, credentials and code examples for downloading, see the SFTP integration documentation.

You can be notified on each completed delivery

Instead of scanning the folder at fixed intervals, configure the Delivery Webhook: at the end of each delivery, QI DTVM notifies your application with the list of written files and the status of each report.

Available reports

Report	Description	Model	File format
Assets Portfolio Composition	Complete position of all the assets that make up the fund's stock on a reference date, asset by asset.	assets_wallet_composition	CSV
Assignment Assets Composition	Assets of a specific assignment, in the same format as the portfolio composition. Generated per assignment, outside the daily routine.	assignment_assets_wallet_composition	CSV
Assignment Collateral	Supporting documents of the assets of an assignment, with a download link per file. Generated per assignment, outside the daily routine.	assignment_documents	CSV
Portfolio Composition	Consolidated portfolio of the fund at the end of the day, by asset class, with issuance series, payables and receivables, cash, profitability and result.	wallet_composition_by_composition	XLSX
Consolidated Credit Rights Acquisition	Credit rights acquired in one day — credit operations by installment and discounted credit rights by asset, in the same file.	consolidated_credit_rights_acquisition_assets	CSV
Consolidated Credit Rights Reconciliation	Payment events of the credit rights on an accounting date, with the effect of each payment on the asset value.	consolidated_credit_rights_conciliation_assets	CSV
Cash Statement	Daily statement of the movements and balances of the fund's bank accounts.	cash_account_demonstrative	XLSX
Cash Movements	The same movement as the cash statement in a tabular format, transaction by transaction, for automated reconciliation.	cash_account_demonstrative_movements	CSV
MEC Quotas	Daily evolution of quotas, net worth and profitability of the issuance series.	quota_mec	XLSX or CSV
Balance Report	Consolidated accounting balance of the fund with balances and movements by account.	balance_report	XLSX
Accounting Ledger	Detailed accounting ledger with all the entries by account in the period.	accounting_ledger	XLSX
ANBIMA XML (types 5 and 401)	Position files in the ANBIMA standard, generated from the portfolio composition.	xml_5_by_composition xml_401_by_composition	XML