Consolidated Credit Rights Reconciliation

Overview

The consolidated_credit_rights_conciliation_assets report lists the payment events of the credit rights recorded on an accounting date, showing the effect of each payment on the asset value: value before, value after, reduction and the accounting result computed. In a single file, it brings together three natures of asset:

• credit operations (e.g. CCB);
• discounted credit rights (e.g. duplicatas);
• securities (commercial_paper, cri, cra, debenture).

This report replaces the former credit_rights_conciliation_assets, credit_rights_conciliation_installments and discounted_credit_rights_conciliation_assets, which are no longer delivered.

Also in PDF

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 Assets Portfolio Composition and the Consolidated Credit Rights Acquisition.

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. Without end_date, it is the only day in the report; with end_date, it is the first day of the range.
end_date	no	End date of the range, in the YYYY-MM-DD format, equal to or later than reference_date. When provided, the report carries the events from reference_date to end_date, both days included.

Date range

The range is available when you request the report in the Manager Portal: in Carteira > Gerar Relatório, choose Liquidados e baixados and fill in Data de Início and Data de Fim. The file arrives by e-mail with the events of the whole range. In delivery routines, the report always carries a single day: the delivery's reference date.

File Structure

Attribute	Value
Format	CSV
Encoding	UTF-8
Delimiter	, (comma)
Header	Yes (first line)
Naming	{short_fund_name}_consolidated_credit_rights_conciliation_assets_{YYYY-MM-DD}.csv, with the reference_date — in a range, the first day.

What the report carries

• The payment events whose accounting date is the reference date — or, with end_date, any date from reference_date to end_date, both included.
• It considers the assets in the active, sold, settled and written-off situations.
• Each line is one payment event — the same asset can appear in several lines on the same day. In a range, the reference_date column carries the accounting date of each event, not the requested reference date.

Fields without a value come as -

Unlike the other CSV reports, this one fills the null fields with - instead of leaving them empty.

Opening delivery

When the report is delivered at the opening moment, the reference date of the delivery is the immediately preceding business day to the closing day. That same date applies to the file content (all asset natures), to the file name and to the reference_date of the Delivery Webhook.

Columns

Column	Type	Format / Example	Description
reference_date	date	2026-07-29	Accounting date of the payment event.
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.
originator_name	string	"ORIGINADOR EXEMPLO S.A."	Name of the company that originated the asset.
originator_document_number	string	"22.222.222/0001-91"	CNPJ of the originator.
assignor_name	string	"CEDENTE EXEMPLO S.A."	Name of the assignor.
assignor_document_number	string	"33.333.333/0001-91"	CNPJ of the assignor.
borrower_name	string	"MARIA APARECIDA DE SOUZA"	Name of the borrower (the credit taker) or of the drawee.
borrower_document_number	string	"969.698.790-03"	CPF or CNPJ of the borrower/drawee.
asset_type	string (enum)	"ccb", "duplicata_mercantil", "duplicata_servicos"	Asset type. It determines which nature produced the line. For securities: commercial_paper, cri, cra or debenture.
asset_key	string	"1a2b3c40-0003-4aaa-9111-000000000103"	Internal key of the asset generated by QI Tech (UUID).
external_id	string	"10a20b30-0003-4bbb-9222-000000000203"	For a credit operation, external identifier of the paid installment, as recorded in the payment event — it comes as - when the event does not carry that identifier. For the other natures, external identifier of the asset.
asset_external_id	string	"10a20b30-0003-4bbb-9222-000000000203"	External identifier of the asset. Use this field, not external_id, to cross-reference with the other per-asset reports.
contract_number	string	"0900098765/EXC"	Contract number (credit operation) or order number (discounted credit right). For a discounted credit right without an order number, it falls back to the contract number.
maturity_date	date	2027-01-11	Final maturity date of the asset.
total_purchase_value	number	5324.8	Total value paid by the fund in the acquisition of the asset (in reais).
purchase_date	date	2026-01-12	Date the asset was acquired by the fund.
internal_rate_of_return	number	0.0231	Internal rate of return of the asset. Credit operation: current rate. Discounted credit right: purchase rate of the receivable. Securities: -.
payment_date	date	2026-07-29	Accounting date of the payment. It always carries the same value as reference_date.
payment_amount	number	512.68	Value paid in the event (in reais).
payment_key	string	"20b30c40-0001-4ccc-9333-000000000301"	Internal key of the payment event generated by QI Tech (UUID).
payment_type	string (enum)	"installment_settlement", "installment_amortization", "asset_settlement", "asset_amortization", "fine_payment", "gloss", ...	Payment type.
payment_event_type	string (enum)	"settlement", "substitution", "repurchase", "extension", "unperformed", "reactivation", "installment_payment_reversal", "asset_payment_reversal", "bankslip"	Nature of the event that originated the payment — for example settlement, substitution, repurchase, extension or default. Events prior to the creation of this field come as -.
old_asset_current_value	number	5361.42	Accounting value of the asset immediately before the event (in reais).
new_asset_current_value	number	4890.33	Accounting value of the asset immediately after the event (in reais).
asset_reduction_value	number	471.09	Reduction of the accounting value of the asset (old − new), in reais.
result_value	number	41.59	Accounting result computed in the event (in reais).
written_off_accounting_result_value	integer	0	Write-off accounting result associated with the event, in cents — this is the only monetary field of the file that is not converted to reais. For a discounted credit right and for securities, always 0.
installment_number	string	"1"	Number of the settled installment. For a discounted credit right, it is the suffix of the order number when it exists (8977-3 → 3); otherwise, -. For securities, it is the installment recorded in the payment event.
end_to_end_id	string	"-"	End-to-end identifier of the payment transaction, when recorded in the event; otherwise, -.

Checking the result of the day

The sum of result_value is the accounting result recognized by the credit rights on the date, and it must reconcile with the corresponding revenue accounts in the Balance Report and in the Accounting Ledger. The sum of asset_reduction_value is the variation of the stock explained by payments on the day.