Assets Portfolio Composition
Overview
The assets_wallet_composition report presents the complete position of all the assets that make up the fund's stock on a given reference date. It is generated once a day and consolidates four categories of assets:
- credit operations (e.g. CCB) — one line per installment of the operation;
- discounted credit rights (e.g. duplicatas, CT-e, discounted contracts) — one line per instrument;
- contracts (
contract,financing_contract,debt_acknowledgment) — one line per installment of the contract; - private securities (e.g. debentures, commercial papers) — one line per installment of the security.
Managers and analysts use this report to track the stock, assess the allowance for doubtful accounts and monitor the evolution of the portfolio.
For installment credit operations, the same operation appears in several lines — one per installment — repeating the registration data (external_id, contract_number, purchase_value) and varying installment_number, face_value, maturity_date and installment_purchase_value.
This report is described in business language in the QI Tech Reports Manual — revision 3, October 2026. The manual is written in Portuguese and covers four reports: this one, the Assignment Assets Composition, the Consolidated Acquisition and the Consolidated Credit Rights Reconciliation.
In that section of the manual the column names appear in uppercase. In the delivered file they always come in lowercase, as shown in the columns table below.
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. |
For funds that operate with an opening quota report, the position delivered is that of the day before the reference date provided.
File Structure
| Attribute | Value |
|---|---|
| Format | CSV |
| Encoding | UTF-8 |
| Delimiter | , (comma) |
| Header | Yes (first line) |
| Naming | {short_fund_name}_assets_wallet_composition_{YYYY-MM-DD}.csv |
The column names are generated in lowercase. Dates are written in the YYYY-MM-DD format and decimal values use a period as the separator, with up to 8 decimal places.
Columns
| Column | Type | Format / Example | Description |
|---|---|---|---|
fund_name | string | "FUNDO EXEMPLO FIDC RESPONSABILIDADE LIMITADA" | Name of the fund class. |
fund_document | string | "11.222.333/0001-81" | CNPJ of the fund class. |
report_date | date | 2026-07-30 | Date the report was generated. On the private securities lines, this column carries the reference date of the portfolio. |
originator_name | string | "ORIGINADOR EXEMPLO S.A." | Name of the company that originated the operation. For private securities, the value is -. |
originator_document | string | "22.222.222/0001-91" | CNPJ of the originator. For private securities, the value is -. |
assignor_name | string | "CEDENTE EXEMPLO S.A." | Name of the assignor of the operation. For private securities, the value is -. |
assignor_document | string | "33.333.333/0001-91" | CNPJ of the assignor. For private securities, the value is -. |
borrower_name | string | "MARIA APARECIDA DE SOUZA" | Name of the borrower. For discounted credit rights, it is the drawee; for private securities, it is the issuer. Empty for contracts. |
borrower_document | string | "969.698.790-03" | CPF or CNPJ of the borrower / drawee / issuer. |
external_id | string | "10a20b30-0001-4bbb-9222-000000000201" | External identifier of the asset, as provided at creation. |
contract_number | string | "0900112233/EXA" | Contract number or order number (order_number) associated with the operation. |
asset_type | string (enum) | "ccb" | Asset type. Examples: ccb, duplicata_mercantil, duplicata_servicos, cte, discounted_contract, debenture. |
face_value | number | 1678.90 | Face value of the installment (or of the security) on the reference date, in reais. |
present_value | number | 1663.48 | Present value of the installment (or of the security) on the reference date, in reais. |
purchase_value | numeric text | 4690.80 | Value at which the asset was acquired by the fund, in reais. Repeated in all the installments of the same operation. |
bad_provision_value | number | 0.0 | Value of the allowance for doubtful accounts (PDD) established over the asset, in reais. |
bad_provision_range | string | "AA" | Risk classification range of the PDD — the usual ones are AA, A, B, C, D, E, F, G and H, and written-off assets may carry WO. When there is no classification, the report carries AA. |
fund_date | date | 2026-07-29 | Reference date of the portfolio. |
maturity_date | date | 2026-08-28 | Maturity date of the installment (or of the security). |
business_maturity_date | date | 2026-08-28 | Maturity date adjusted to a business day. For private securities, it repeats maturity_date. |
issue_date | date text | 2026-07-28 | Issue date of the contract. For discounted credit rights and contracts, it corresponds to the acquisition date. |
purchase_date | date text | 2026-07-29 | Date the asset was acquired by the fund. |
total_duration | integer | 30 | Total term in calendar days, from the acquisition to the maturity. |
present_duration | integer | 30 | Remaining term in calendar days, from the reference date to the maturity. It becomes negative when the asset is overdue. |
asset_maturity_status | string (enum) | "on_time" | Maturity situation: OVERDUE when overdue, on_time when within the term. |
assignment_rate_of_return | number | 0.0312 | Internal rate of return (IRR) of the assignment. Empty for private securities. |
purchase_rate_of_return | numeric text | 0.031874210 | Current IRR of the operation at the moment of acquisition. For private securities, the value is -. |
has_assignor_coobligation | string | "False" | Indicates the assignor's co-obligation: True or False. For private securities, the value is -. |
installment_number | integer | 1 | Installment number. For discounted credit rights, it is always 1. |
bad_debt_type | string | "default" | Type of PDD classification applied to the asset. |
nominal_rate | number | 0.0231 | Pre-fixed monthly nominal rate of the operation. Empty for discounted credit rights and private securities. |
operation_type | string | "ccb" | Type of the operation recorded in the asset registration. Empty for private securities. |
installment_purchase_value | numeric text | 1598.74210000 | Value paid by the fund for the specific installment, in reais. Empty for discounted credit rights and private securities. |
asset_key | string | "1a2b3c40-0001-4aaa-9111-000000000101" | Internal key of the asset generated by QI Tech (UUID). |
asset_external_id | string | "10a20b30-0001-4bbb-9222-000000000201" | External identifier of the asset. In credit operations, external_id may carry the installment identifier; asset_external_id is always the asset's. |
When the delivery is configured with the benefit_number option, the report carries an extra benefit_type column at the end, with the type of benefit associated with the operation's collateral. With the original_face_value option, it also carries the original_face_value column (original face value of the installment; empty for discounted credit rights and private securities).