MEC Quotas

Overview

The quota_mec report presents the daily evolution of the fund's quotas and net worth over a date range, calculated based on the issuance series closings. Each line represents a business day of an issuance series, containing gross and net worth values, closing quota, application and redemption movements, come-cotas and accumulated daily, monthly and yearly profitability. Managers and administrators use this report to track the fund's performance and to send regulatory information to MEC (Método de Envio de Cota).

The report can be generated in the XLSX (one tab per fund class) or CSV formats. CSV is only accepted when the request covers a single fund class.

What you need to provide

Variable	Required	Description
fund_class_key	yes	Identifier of the fund class the report is generated for.
start_date	yes	Start date of the period, in the YYYY-MM-DD format.
end_date	yes	End date of the period, in the YYYY-MM-DD format. It cannot be earlier than the start date.
include_secondary_market	no	Boolean. When omitted, it is true.
file_format	no	xlsx (default) or csv. Any other value is refused.
issuance_serie_key	no	Restricts the file to a single issuance series.

There must be a quota in the period

The report is only generated if at least one issuance series of the class has a quota value (opening or closing) within the range. Without it the request is refused.

File Structure

Attribute	Value
Format	XLSX or CSV
Encoding	UTF-8
Delimiter (CSV)	; (semicolon)
Naming	{short_fund_name}_quota_mec_{YYYY-MM-DD}.xlsx (or .csv)

In the XLSX, each fund class occupies a tab, named after the fund (limited to 31 characters by Excel), the header comes in Portuguese and the lines are in ascending chronological order. Dates are presented in the DD/MM/YYYY format.

Variation in the CSV format

The CSV is generated for only one fund class per file and differs from the XLSX in two respects: the header comes with the technical names in English (fund_class_name, fund_class_document_number, sub_class_name, issuance_serie_name, accounting_date, gross_net_worth, gross_quota_value, performance_fee_current_value, net_net_worth, net_quota_value, final_net_worth, final_quota_value, total_net_worth, issued_quotas, total_daily_applications, redeemed_quotas, total_daily_redemptions, tax_anticipated_quotas, total_daily_tax_anticipations, total_daily_amortizations, daily_rentability, monthly_rentability, yearly_rentability), in the same order as the table below; and the lines come in descending chronological order, from the most recent date to the oldest.

Columns

The column names below are the literal headers of the XLSX, delivered in Portuguese.

Column	Type	Format / Example	Description
Nome do Fundo	string	"FUNDO EXEMPLO FIDC RESPONSABILIDADE LIMITADA"	Name of the fund class.
CNPJ do Fundo	string	"12.345.678/0001-99"	CNPJ of the fund class.
Sub Classe	string	"SUBORDINADA"	Name of the fund subclass.
Série de Emissão	string	"PRIMEIRA"	Name of the issuance series.
Data de Referência	date	29/07/2026	Accounting reference date (business days only).
Patrimônio Bruto	number	10500000.00	Gross net worth before the performance fee provision (in reais).
Cota Bruta	number	1.050000	Gross quota value before the performance fee.
Taxa de Performance	number	5000.00	Current value of the provisioned performance fee (in reais).
PL Pré Movimentação	number	10495000.00	Net worth before the movements of the day (in reais).
Cota Pré Movimentação	number	1.049500	Quota value before the movements of the day.
PL de Fechamento	number	10495000.00	Closing net worth before the amortizations (in reais).
Cota de Fechamento	number	1.049500	Closing quota value before the amortizations.
PL Pós Movimentações	number	10490000.00	Total net worth after all the movements of the day (in reais).
Cotas Integralizadas	number	1000.00000	Number of quotas issued (applied) in the day.
Total Aplicado	number	1049500.00	Total value applied in the day (in reais).
Cotas Resgatadas	number	500.00000	Number of quotas redeemed in the day.
Total Resgatado	number	524750.00	Total value redeemed in the day (in reais).
Come-cotas	number	200.00000	Number of quotas consumed by the income tax anticipation (come-cotas).
Total de Come-cotas	number	200.00	Total value of the come-cotas of the day (in reais).
Total Amortizado	number	0.00	Total value amortized in the day (in reais).
Rentabilidade Diária	number	0.000420	Profitability of the day, calculated as (pre_movement_quota / previous_closing_quota) - 1.
Rentabilidade Mensal	number	0.005200	Profitability accumulated in the current month (compound basis). It restarts at the beginning of each month.
Rentabilidade Anual	number	0.063000	Profitability accumulated in the current year (compound basis). It restarts at the beginning of each year.