fiscal_years

NEW

In short

Fiscal years of companies managed on Pennylane.

This table is suited for incremental ingestion with an ETL tool. For standard data analysis, use schema pennylane.

A fiscal year is a 12-month period used for calculating a company’s income taxes. The first year, it can exceptionally be shorter or longer than 12 months, up to 24 months.

Companies can choose to match their fiscal year to the calendar year (from January 1 to December 31), or to match it to another 12-month period (for example, from April 1 to March 31).

The choice of the fiscal year end date is free. A date closing a calendar quarter (March 31, June 30, September 30) is often chosen for simplicity.

Available Columns

id

bigint

UNIQUE

Unique ID of the fiscal year on Pennylane.

company_id

bigint

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

company_name

character varying

Name of the company, referring to companies.name.

company_external_id

character varying

External ID of the company, referring to companies.external_id.

start_year

integer

Calendar year in which the fiscal year starts.

start_date

date

First day of the fiscal year.

end_date

date

Last day of the fiscal year.

descriptor

text

Fiscal year descriptor. When the fiscal year starts and ends on the same year (e.g. Jan 2022 to Dec 2022), then this value will be '2022'. When the fiscal year ends in a different year (e.g. April 2022 to Dec 2023), then this value will be '2022-2023'.
Examples: "2021-2022", "2022", "2023"

closed_at

timestamp without time zone

Timestamp of the closing of this fiscal year.

updated_at

timestamp without time zone

Timestamp of the last update of this fiscal year on Pennylane.

synchronised_at

timestamp without time zone

Timestamp of the last synchronisation of this fiscal year's information with Pennylane's application.

deleted_at

timestamp without time zone

Timestamp of the deletion of this fiscal year on Pennylane.