trial_balance

In short

Trial balance aggregating bookkeeping entries by account and fiscal year.

Compared to the general ledger, the trial balance aggregates bookkeeping entries by account and fiscal year.

It is a useful tool to get a quick overview of the company’s financial situation, and identify anomalies such imbalanced accounts. It can also be used for analysis purposes, to compare the company’s financial situation from one period to another for instance.

Individual supplier and customer accounts are grouped together under 401 and 411 accounts. Because of the possible heterogeneity of these individual accounts, a default VAT rate ("any") is set for the consolidated accounts.

Available Columns

company_id

bigint

Unique ID of the company on Pennylane, referring to companies.id.

company_name

character varying

Name of the company on Pennylane, referring to companies.name.

id

bigint

Unique ID of the accounting plan item on Pennylane, for granular accounts that are not consolidated.

number

character varying

Accounting plan item number, associated with the id column. 401/411 in case of supplier/customer accounts.
Examples: "411", "445710", "512001"

vat_rate

character varying

Accounting plan item VAT rate, defaulting to "any".
Examples: "any", "FR_200", "FR_55"

country_alpha2

character varying

Country code of the accounting plan item, defaulting to "any".
Examples: "any", "FR", "US"

label

character varying

Accounting plan item label, associated with the id and number columns.
Examples: "Suppliers", "Customers", "Autres immobilisations incorporelles", "Stocks de marchandises"

enabled

boolean

"true" if the accounting plan item is enabled for the company, "false" if disabled.

debits

numeric

Sum of all debits for the accounting plan item and fiscal period.

credits

numeric

Sum of all credits for the accounting plan item and fiscal period.

balance

numeric

Difference between the sum of all debits and the sum of all credits for the accounting plan item and fiscal period.

ledger_events_count

bigint

Number of ledger events for the accounting plan item and fiscal period.

notes_count

bigint

Number of comments attached to the accounting plan item on Pennylane, if any.

fiscal_period_start

date

Starting date of the fiscal period, in YYYY-MM-DD format.

fiscal_period_finish

date

Ending date of the fiscal period, in YYYY-MM-DD format.

updated_at

timestamp without time zone

Last update date of the last update of the accounting plan item on Pennylane.