Skip to content
/ RFSD Public

The Russian Financial Statements Database (RFSD) is an open, harmonized collection of annual unconsolidated financial statements of the universe of Russian firms in 2011-2023. It is the first open data set with information on every active firm in the country, including non-filing firms.

License

Notifications You must be signed in to change notification settings

irlcode/RFSD

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

9 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

The Russian Financial Statements Database (RFSD)

Hugging Face Β Β Β  Zenodo Β Β Β  arXiv Β Β Β  License: CC BY-NC-SA 4.0 Β Β Β  R Β Β Β  Python

The Russian Financial Statements Database (RFSD) is an open, harmonized collection of annual unconsolidated financial statements of the universe of Russian firms:

  • πŸ”“ First open data set with information on every active firm in Russia.

  • πŸ—‚οΈ First open financial statements data set that includes non-filing firms.

  • πŸ›οΈ Sourced from two official data providers: the Rosstat and the Federal Tax Service.

  • πŸ“… Covers 2011-2023, will be continuously updated.

  • πŸ—οΈ Restores as much data as possible through non-invasive data imputation, statement articulation, and harmonization.

The RFSD is hosted on πŸ€— Hugging Face and Zenodo and is stored in a structured, column-oriented, compressed binary format Apache Parquet with yearly partitioning scheme, enabling end-users to query only variables of interest at scale.

The accompanying paper provides internal and external validation of the data: https://arxiv.org/abs/2501.05841.

Here we present the code used to create the dataset, as well as the instructions for importing the data in R or Python environment and use cases.

Importing The Data

You have two options to ingest the data: download the .parquet files manually from Hugging Face or Zenodo or rely on πŸ€— Hugging Face Datasets library.

Python

πŸ€— Hugging Face Datasets

It is as easy as:

from datasets import load_dataset
import polars as pl

# This line will download 6.6GB+ of all RFSD data and store it in a πŸ€— cache folder
RFSD = load_dataset('irlspbru/RFSD')

# Alternatively, this will download ~540MB with all financial statements for 2023
# to a Polars DataFrame (requires about 8GB of RAM)
RFSD_2023 = pl.read_parquet('hf://datasets/irlspbru/RFSD/RFSD/year=2023/*.parquet')

We provide a file in aux/descriptive_names_dict.csv which can be used to change the original names of financial variables to user-friendly ones, e.g. B_revenue and CFo_materials in lieu of line_2110 and line_4121, respectively. Prefixes are for disambiguation purposes: B_ stands for balance sheet variables, PL_ β€” profit and loss statement, CFi_ and CFo β€” cash inflows and cash outflows, etc. (One can find all the variable definitions in the supplementary materials table in the accompanying paper and consult the original statement forms used by firms: full is KND 0710099, simplified β€” KND 0710096.)

# Give suggested descriptive names to variables
renaming_df = pl.read_csv('https://raw.githubusercontent.com/irlcode/RFSD/main/aux/descriptive_names_dict.csv')
RFSD = RFSD.rename({item[0]: item[1] for item in zip(renaming_df['original'], renaming_df['descriptive'])})

Please note that the data is not shuffled within year, meaning that streaming first n rows will not yield a random sample.

Local File Import

Importing in Python requires pyarrow package installed.

import pyarrow.dataset as ds
import polars as pl

# Read RFSD metadata from local file
RFSD = ds.dataset("local/path/to/RFSD")

# Use RFSD_dataset.schema to glimpse the data structure and columns' classes
print(RFSD.schema)

# Load full dataset into memory
RFSD_full = pl.from_arrow(RFSD.to_table())

# Load only 2019 data into memory
RFSD_2019 = pl.from_arrow(RFSD.to_table(filter=ds.field('year') == 2019))

# Load only revenue for firms in 2019, identified by taxpayer id
RFSD_2019_revenue = pl.from_arrow(
    RFSD.to_table(
        filter=ds.field('year') == 2019,
        columns=['inn', 'line_2110']
        )
)

# Give suggested descriptive names to variables
renaming_df = pl.read_csv('local/path/to/descriptive_names_dict.csv')
RFSD_full = RFSD_full.rename({item[0]: item[1] for item in zip(renaming_df['original'], renaming_df['descriptive'])})

R

Local File Import

Importing in R requires arrow package installed.

library(arrow)
library(data.table)

# Read RFSD metadata from local file
RFSD <- open_dataset("local/path/to/RFSD")

# Use schema() to glimpse into the data structure and column classes
schema(RFSD)

# Load full dataset into memory
scanner <- Scanner$create(RFSD)
RFSD_full <- as.data.table(scanner$ToTable())

# Load only 2019 data into memory
scan_builder <- RFSD$NewScan()
scan_builder$Filter(Expression$field_ref("year") == 2019)
scanner <- scan_builder$Finish()
RFSD_2019 <- as.data.table(scanner$ToTable())

# Load only revenue for firms in 2019, identified by taxpayer id
scan_builder <- RFSD$NewScan()
scan_builder$Filter(Expression$field_ref("year") == 2019)
scan_builder$Project(cols = c("inn", "line_2110"))
scanner <- scan_builder$Finish()
RFSD_2019_revenue <- as.data.table(scanner$ToTable())

# Give suggested descriptive names to variables
renaming_dt <- fread("local/path/to/descriptive_names_dict.csv")
setnames(RFSD_full, old = renaming_dt$original, new = renaming_dt$descriptive)

Use Cases

FAQ

Why should I use this data instead of Interfax's SPARK, Moody's Ruslana, or Kontur's Focus?

To the best of our knowledge, the RFSD is the only open data set with up-to-date financial statements of Russian companies published under a permissive licence. Apart from being free-to-use, the RFSD benefits from data harmonization and error detection procedures unavailable in commercial sources. Finally, the data can be easily ingested in any statistical package with minimal effort.

What is the data period?

We provide financials for Russian firms in 2011-2023. We will add the data for 2024 by July, 2025 (see Version and Update Policy below).

Why are there no data for firm X in year Y?

Although the RFSD strives to be an all-encompassing database of financial statements, end users will encounter data gaps:

  • We do not include financials for firms that we considered ineligible to submit financial statements to the Rosstat/Federal Tax Service by law: financial, religious, or state organizations (state-owned commercial firms are still in the data).

  • Eligible firms may enjoy the right not to disclose under certain conditions. For instance, Gazprom did not file in 2022 and we had to impute its 2022 data from 2023 filings. Sibur filed only in 2023, Novatek β€” in 2020 and 2021. Commercial data providers such as Interfax's SPARK enjoy dedicated access to the Federal Tax Service data and therefore are able source this information elsewhere.

  • Firm may have submitted its annual statement but, according to the Uniform State Register of Legal Entities (EGRUL), it was not active in this year. We remove those filings.

Why is the geolocation of firm X incorrect?

We use Nominatim to geocode structured addresses of incorporation of legal entities from the EGRUL. There may be errors in the original addresses that prevent us from geocoding firms to a particular house. Gazprom, for instance, is geocoded up to a house level in 2014 and 2021-2023, but only at street level for 2015-2020 due to improper handling of the house number by Nominatim. In that case we have fallen back to street-level geocoding. Additionally, streets in different districts of one city may share identical names. We have ignored those problems in our geocoding and invite your submissions. Finally, address of incorporation may not correspond with plant locations. For instance, Rosneft has 62 field offices in addition to the central office in Moscow. We ignore the location of such offices in our geocoding, but subsidiaries set up as separate legal entities are still geocoded.

Why is the data for firm X different from https://bo.nalog.ru/?

Many firms submit correcting statements after the initial filing. While we have downloaded the data way past the April, 2024 deadline for 2023 filings, firms may have kept submitting the correcting statements. We will capture them in the future releases.

Why is the data for firm X unrealistic?

We provide the source data as is, with minimal changes. Consider a relatively unknown LLC Banknota. It reported 3.7 trillion rubles in revenue in 2023, or 2% of Russia's GDP. This is obviously an outlier firm with unrealistic financials. We manually reviewed the data and flagged such firms for user consideration (variable outlier), keeping the source data intact.

Why is the data for groups of companies different from their IFRS statements?

We should stress that we provide unconsolidated financial statements filed according to the Russian accounting standards, meaning that it would be wrong to infer financials for corporate groups with this data. Gazprom, for instance, had over 800 affiliated entities and to study this corporate group in its entirety it is not enough to consider financials of the parent company.

Why is the data not in CSV?

The data is provided in Apache Parquet format. This is a structured, column-oriented, compressed binary format allowing for conditional subsetting of columns and rows. In other words, you can easily query financials of companies of interest, keeping only variables of interest in memory, greatly reducing data footprint.

Dataset Construction

The below figure explains how we constructed the dataset. An annotated Makefile documents the process (with renv taking care of creating virtual R environment with packages required for this project). Please be aware that in order to replicate it one has to have an access to the fee-based API of the Federal Tax Service of the Russian Federation, and also be in possession of the panels of all active organizations and their classification code, and geocoded addresses. We built them outside of this project from the official sources β€” the Uniform State Register of Legal Entities (EGRUL) and Rosstat's Statistical Register of Economic Entities β€” and do not provide here.

Schematic overview of the dataset construction process

Repository Structure

.
β”œβ”€β”€ aux
β”‚Β Β  └── descriptive_names_dict.csv
β”œβ”€β”€ code
β”‚Β Β  β”œβ”€β”€ 1_financials
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ helpers
β”‚Β Β  β”‚Β Β  β”‚Β Β  β”œβ”€β”€ check_articulation_functions.R
β”‚Β Β  β”‚Β Β  β”‚Β Β  β”œβ”€β”€ lines_tags_dict.R
β”‚Β Β  β”‚Β Β  β”‚Β Β  └── parsing_functions.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 1a_collect_rosstat_data.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 1b_build_rosstat_panel.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 2a_collect_fns_xmls_ids.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 2b_collect_fns_xmls.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 2c_parse_fns_xmls.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 2d_build_fns_panel.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 3_build_filing_panel.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 4_combine_rosstat_fns_panels.R
β”‚Β Β  β”‚Β Β  β”œβ”€β”€ 5_build_articulation_panel.R
β”‚Β Β  β”‚Β Β  └── 6_adjust_values.R
β”œβ”€β”€ figures
β”‚Β Β  β”œβ”€β”€ dataset_construction.png
β”‚Β Β  └── filing_by_month.png
β”œβ”€β”€ renv
β”‚Β Β  β”œβ”€β”€ library
β”‚Β Β  β”œβ”€β”€ activate.R
β”‚Β Β  └── settings.json
β”œβ”€β”€ use_cases
β”‚Β Β  β”œβ”€β”€ interest_payments.Rmd
β”‚Β Β  β”œβ”€β”€ spatialization.Rmd
β”‚Β Β  └── tfp.Rmd
β”œβ”€β”€ AUTHORS
β”œβ”€β”€ LICENCE
β”œβ”€β”€ Makefile
β”œβ”€β”€ README.md
└── renv.lock

Version and Update Policy

Version (SemVer): 1.0.0.

We intend to update the RFSD annualy as the data becomes available, in other words when most of the firms have their statements filed with the Federal Tax Service. The official deadline for filing of previous year statements is April, 1. However, every year a portion of firms either fails to meet the deadline or submits corrections afterwards. As the figure below shows, filing continues up to the very end of the year but after the end of April this stream quickly thins out. Nevertheless, there is obviously a trade-off between minimization of data completeness and version availability. We find it a reasonable compromise to query new data in early June, since on average by the end of May 96.7% statements are already filed, including 86.4% of all the correcting filings. We plan to make a new version of RFSD available by July, 2025.

Line plot of number of filing by month

ToDo and Known Deficiencies

Below is our To-Do list, we will be grateful for any contributions you can make. If you spot a bug, just raise it as a GitHub issue.

Licence

Creative Commons License
Creative Commons License Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0).

Copyright Β© the respective contributors, as shown by the AUTHORS file.

Citation

Please cite as:

@unpublished{bondarkov2025rfsd,
  title={{R}ussian {F}inancial {S}tatements {D}atabase},
  author={Bondarkov, Sergey and Ledenev, Victor and Skougarevskiy, Dmitriy},
  note={arXiv preprint arXiv:2501.05841},
  doi={https://doi.org/10.48550/arXiv.2501.05841},
  year={2025}
}

Acknowledgments and Contacts

Data collection and processing: Sergey Bondarkov, sbondarkov@eu.sbb.ru, Viktor Ledenev, vledenev@eu.spb.ru

Project conception, data validation, and use cases: Dmitriy Skougarevskiy, Ph.D., dskougarevskiy@eu.spb.ru

About

The Russian Financial Statements Database (RFSD) is an open, harmonized collection of annual unconsolidated financial statements of the universe of Russian firms in 2011-2023. It is the first open data set with information on every active firm in the country, including non-filing firms.

Topics

Resources

License

Stars

Watchers

Forks