Credit Rights Conciliation

This report documents payment events for credit operations (credit rights) recorded on a given accounting date. It consists of two complementary files:

• Assets (credit_rights_conciliation_assets) — consolidated view per payment event, with financial amounts received and accounting result per operation.
• Installments (credit_rights_conciliation_installments) — breakdown of payments by individual installment, identifying the installment settled in each event.

Both files share the same reference date. To reconstruct the relationship between the two files, use the external_id field as the join key.

---

Assets (credit_rights_conciliation_assets)

Overview

The credit_rights_conciliation_assets file lists all payment events for credit operations that occurred on the reference date. Each row represents a payment event, containing the amounts received (principal, interest, fines, and late fees), the change in asset value, and the accounting result calculated.

File Structure

Attribute	Value
Format	CSV
Encoding	UTF-8
Delimiter	, (comma)
Header	Yes (first line)
Naming	{fund_short_name}_credit_rights_conciliation_assets_{YYYY-MM-DD}.csv

Columns

Column	Type	Format / Example	Description
reference_date	date	2024-01-15	Report reference date.
fund_class_name	string	"Example Fund FIC"	Fund class name.
fund_class_document_number	string	"12.345.678/0001-99"	Fund class CNPJ.
originator_name	string	"Originator S.A."	Name of the company that originated the operation.
originator_document_number	string	"12.345.678/0001-99"	Originator's CNPJ.
assignor_name	string	"Assignor S.A."	Name of the assignor of the operation.
assignor_document_number	string	"12.345.678/0001-99"	Assignor's CNPJ.
borrower_name	string	"Borrower Ltd."	Name of the debtor (credit borrower).
borrower_document_number	string	"123.456.789-00"	CPF or CNPJ of the debtor.
asset_type	string (enum)	"ccb"	Asset type. Examples: ccb.
asset_key	string	"a1b2c3d4-e5f6-7890-abcd-ef1234567890"	Internal asset key generated by QI Tech (UUID).
external_id	string	"931e9437-d025-41ab-bb53-6b94e10fd361"	External identifier of the asset.
contract_number	string	"CCB-2024-001"	Contract number of the credit operation.
maturity_date	date	2025-06-30	Final maturity date of the operation.
payment_date	date	2024-01-15	Accounting date on which the payment was recorded.
payment_amount	number	1050.00	Total amount received in the payment event (in BRL).
principal_paid_amount	number	980.00	Principal portion received in the payment (in BRL).
interest_paid_amount	number	70.00	Interest portion received in the payment (in BRL).
delay_fine_value	number	0.00	Late fine received in the payment (in BRL).
delay_interest_value	number	0.00	Late interest received in the payment (in BRL).
post_maturity_interest_value	number	0.00	Post-maturity interest received in the payment (in BRL).
asset_reduction_value	number	1000.00	Change (reduction) in the asset's book value due to the payment (in BRL).
result_value	number	50.00	Accounting result from the payment event (in BRL).
installment_number	string	"2"	Number of the installment settled in this event.
payment_type	string (enum)	"installment_settlement"	Classification of the payment event type.
written_off_accounting_result_value	number	0.00	Written-off accounting result associated with the event (in BRL).
payment_key	string	"b2c3d4e5-f6a7-8901-bcde-f12345678901"	Internal payment event key generated by QI Tech (UUID).

---

Installments (credit_rights_conciliation_installments)

Overview

The credit_rights_conciliation_installments file details payments by installment for credit operations on the reference date. Each row associates a payment event with a specific installment of the operation, allowing reconciliation of the amount received with the expected installment flow.

File Structure

Attribute	Value
Format	CSV
Encoding	UTF-8
Delimiter	, (comma)
Header	Yes (first line)
Naming	{fund_short_name}_credit_rights_conciliation_installments_{YYYY-MM-DD}.csv

Columns

Column	Type	Format / Example	Description
reference_date	date	2024-01-15	Report reference date.
fund_class_name	string	"Example Fund FIC"	Fund class name.
fund_class_document_number	string	"12.345.678/0001-99"	Fund class CNPJ.
originator_name	string	"Originator S.A."	Name of the company that originated the operation.
originator_document_number	string	"12.345.678/0001-99"	Originator's CNPJ.
assignor_name	string	"Assignor S.A."	Name of the assignor of the operation.
assignor_document_number	string	"12.345.678/0001-99"	Assignor's CNPJ.
borrower_name	string	"Borrower Ltd."	Name of the debtor (credit borrower).
borrower_document_number	string	"123.456.789-00"	CPF or CNPJ of the debtor.
asset_type	string (enum)	"ccb"	Asset type. Examples: ccb.
asset_key	string	"a1b2c3d4-e5f6-7890-abcd-ef1234567890"	Internal asset key generated by QI Tech (UUID).
external_id	string	"931e9437-d025-41ab-bb53-6b94e10fd361"	External identifier of the asset.
contract_number	string	"CCB-2024-001"	Contract number of the credit operation.
maturity_date	date	2025-06-30	Final maturity date of the operation.
principal_value	number	9800.00	Total principal value of the operation (in BRL).
payment_date	date	2024-01-15	Accounting date on which the payment was recorded.
payment_amount	number	1050.00	Total amount received in the payment event (in BRL).
installment_number	string	"2"	Number of the installment settled in this event.
installment_maturity_date	date	2024-01-15	Maturity date of the settled installment.
installment_business_maturity_date	date	2024-01-15	Maturity date of the installment in business days.
face_value	number	1050.00	Face value of the settled installment (in BRL).
payment_type	string (enum)	"installment_settlement"	Classification of the payment event type.