Skip to main content

Balance Report

Overview​

The balance_report report presents the fund's consolidated accounting balance between two reference dates. For each account of the chart of accounts, it shows the opening balance (Start Date), the debit and credit movements that occurred in the period and the closing balance (End Date). The report organizes the accounts in a hierarchical structure (groups and subgroups) and includes totals for assets, liabilities, net worth, revenues, expenses and offsetting accounts. Administrators and analysts use this report to check the accounting consistency and to audit the evolution of the fund's balance.

What you need to provide​

VariableRequiredDescription
fund_class_keyyesIdentifier of the fund class the report is generated for.
start_dateyesStart date of the period, in the YYYY-MM-DD format.
end_dateyesEnd date of the period, in the YYYY-MM-DD format. It must be later than the start date.

The movements considered are those with an accounting date after the Start Date and up to the End Date, inclusive. The entries of the Start Date itself are already in the opening balance.

There must be a closed accounting period on both dates

The report is only generated if there is an accounting closing on the start date and on the end date. In an ad hoc request, without it the request is refused with the message "Não existe contabil na data ...". In a routine delivery this check does not happen at request time: the generation fails and the report ends with status failed.

Both dates must be in the same accounting period

Besides having a closing on both dates, they must belong to the same accounting period (the same ledger). A range that crosses the period-end closing makes the generation fail.

File Structure​

AttributeValue
FormatXLSX
Naming{short_fund_name}_balance_report_{YYYY-MM-DD}.xlsx

The date in the name is the request's reference_date, not the end_date. If the request does not provide a reference_date, the file generation date applies, in Brasília time.

Spreadsheet Content​

Fund Header​

Presented on the first lines of the spreadsheet, with the label in column A and the value in column B. The labels below are the literal texts of the spreadsheet, colons included:

FieldDescription
Nome do Fundo:Full name of the fund class.
CNPJ do Fundo:CNPJ of the fund class.
Data de Início:Start date of the period in the YYYY-MM-DD format.
Data Final:End date of the period in the YYYY-MM-DD format.
Total do Ativo:Sum of the closing balance of the asset accounts.
Total do Passivo:Sum of the closing balance of the liability accounts.
Total de PL:Closing balance of the net worth accounts.
Total de Receitas:Closing balance of the revenue accounts.
Total de Despesas:Closing balance of the expense accounts.
Total de Compensação Ativa:Closing balance of the active offsetting accounts (group 3).
Total de Compensação Passiva:Closing balance of the passive offsetting accounts (group 9).
PL por Contas Patrimoniais:Total do Ativo - Total do Passivo
PL por Contas de Resultado:Total de PL + Total de Receitas + Total de Despesas
Bate Compensação :Total de Compensação Ativa - Total de Compensação Passiva

In deliveries configured in English, the labels, the table headers and the account names come translated — for example Fund Name:, Total Assets: and Closing Balance on {date}.

The totals are Excel formulas

The header cells are not fixed values: they reference the total lines of the accounts table (for example, Total do Ativo is =G20). When you open the file, Excel recalculates everything — and, if you edit the table, the totals follow.

Accounts Table​

Lines organized hierarchically by account number, with no special formatting — only the header line of the table comes in bold. Besides the accounts and groups of the chart of accounts, the table has two total lines: TOTAL DO ATIVO (3.9.9.99.99-3, sum of groups 1 and 3) and TOTAL DO PASSIVO (9.9.9.99.99-5, sum of groups 4, 6, 7, 8 and 9). The column names below are the literal headers of the spreadsheet in a delivery in Portuguese.

ColumnTypeFormat / ExampleDescription
Número da Contastring"1.1.2.80.00.010.001-8"Account number in the chart of accounts, with a check digit. The group lines carry the number of the corresponding level — for example 1-7 (ATIVO) and 1.1-6 (DISPONIBILIDADES).
Nome da Contastring"Conta Caixa - Banco Exemplo"Descriptive name of the accounting account.
Tipo da Contastring (enum)"A"Line type: "A" for an analytical account; "S" for a synthetic account (an aggregating one).
Saldo em Término de {Data de Início}number40000.00Balance of the account on the Start Date, in reais. A negative value indicates a balance whose nature is the opposite of the account's.
Movimentos de Débitonumber5000.00Sum of the debit entries in the period (in reais). The sign follows the nature of the account: positive in debit accounts, negative in credit accounts.
Movimentos de Créditonumber0.00Sum of the credit entries in the period (in reais). The sign is inverted in relation to the debit column: negative in debit accounts, positive in credit accounts.
Saldo em Término de {Data Final}number45000.00Balance of the account on the End Date, in reais.