Introduction

FStateMan stands for The financial statement management system.
FStateMan downloads the electronic file (XBRL file) of financial statements submitted to the Financial Services Agency of Japan (EDINET), and then registers the downloaded XBRL files.

The XBRL file has a redundant file structure.
As a result, financial statements cannot be displayed easily and quickly.
FStateMan converts the XBRL file into financial statement format and registers it in the database.
This allows you to view and analyze financial statements instantly.

The financial statements will be presented in the same format as the submitted securities report.
Financial data is displayed as a time series data in a table or bar graph.
This allows you to intuitively predict the future financial condition of the company.
You can view financial data of multiple companies in parallel. (Displayed as a table or bar graph.)
In addition, you can display financial ratios such as operating profit margin for multiple companies in parallel.
The financial ratio is irrelevant to the size of the company and is suitable for comparing the financial status of multiple companies.

You can view the text information of the submitted documents as a PDF file.
You can refer to detailed information such as notes of securities report and segment information.
The registered financial data can be output to a csv file.
This makes it easy to process financial data.

Functions and features

Simplification of data collection and registration
You can set the company to register the data.
You can set the type of document to register.
This function makes daily data collection and registration easy.
Time series display of financial data
You can easily see how the financial status of a company changes over time.
Display of financial ratio
You can evaluate the financial status of a company with objective numbers.
Comparison of financial status of multiple companies
Easily compare and compare financial data with other companies in the same industry.
You can view the published securities report as a PDF.
You can look up detailed textual information in the securities report.
The financial table is displayed in a list sorted by display frequency.
You can easily view your financial data because the financial tables you look up frequently appear at the top.
The list of registered companies can be displayed in the following format.
Document submission date order
By industry
EDINET code order
Only companies of interest

This feature makes it easy and quick to view the financial data of the company you are looking for.
The registered financial data can be output to a csv file.
You can freely process financial data.

Operating procedure

This section describes the procedure for using FStateMan.

File description

EDINET site: FStateMan acquire information from the EDINET site useing API (application program interfase).
List of documents to be submitted: The information on the documents submitted to the Financial Services Agency is stored in the order of submission time.
Contains information that associates the XBRL or PDF file of the submitted document with the submitter or fund and the document.
XBRL file: The file that defines the contents of the document.
Data items are managed with predefined tags. This makes it easy for multiple companies to compare data from the same account.
Taxonomy files: The definition information that categorizes the data items.
You must refer to it to create a financial statement from an XBRL file.
EDINET code, Fund code: Information about the submitter or fund is stored.
You can download it from the EDINET site.
FStateMan manages the submitter or fund with an EDINET code or fund code.
If this file is not referenced, the submitter or fund name cannot be displayed.
Registered company: The latest registration date of the submitter (company) or fund where the XBRL file is registered is saved.
Financial statement database: Financial statement data created based on XBRL files and taxonomy files is stored in a file for each submitter or fund.

Start FStateMan

When installing FStaeMan, the library folder is created in the package folder.
The contents of the package folder are automatically deleted when you uninstall FStateMan.
If you want to keep the financial data you have created, we strongly recommend that you set the library folder to another folder.
You can set the library folder in [File][Setting Library Folder]menu.

Register code list files

Code list file registration procedure

Select main menu [Settings]>[EDINET Download].
Then, the EDINET code list download page is displayed in the browser.
Click the download button at the bottom of the page to download the code file.
Select main menu [Settings]>[Register downloaded files].
Then, register the EDINET code list file and fund code list file.
If you do not register the code list, the submitter name and fund name will not be displayed properly.

At this time, it is convenient to set the company to automatically register the XBRL file.

Acquisition of list information of submitted documents

Select main menu [List of Documents].
The list of documents submitted on the same day or in the past is obtained from the EDINET site.
If you set the submission date to the same day, the documents submitted by the current time will be displayed.

In the settings, it is convenient to limit the types of documents displayed to securities reports only.
This is because when you register an XBRL file, you do not have to register any XBRL file other than the securities report.

XBRL file registration

On the "List of Documents" screen, select the required XBRL file and register it.
At this time, if the referenced taxonomy is not in the local environment, it will be automatically downloaded from the Internet.
"Registered company" file will also be updated.
You can view financial statements in FStateMan after register XBRL file.

Screen structure

This section describes the processing for each function.
For details of the process, refer to the Help on each screen.

Most menus and buttons have access keys.
The set access key is displayed by pressing the Alt key once.

Settings

Set the execution environment.
The following items can be set here.

Library folder settings: Select main menu[File]>[Setting Library Folder].
The financial data files are store in the libray folder.
You can be set either on the local PC or on the NAS (network-attached storage).
If you set it on the NAS, you can refer to it from all PCs connected by LAN.
If you change the location of the library folder on the way, you can copy all the subfolders on the old library folder to the new folder and keep the previous data.
Collection of information on past submitted documents: Select main menu[Settings]>[List of past Document].
You can collect information for the last 5 years.
The securities report has a five-year browsing period, so you can refer to the reports up to five years ago.
This process puts a heavy load on the server, so it should be performed on weekdays at night or on holidays.
We expect good behavior.
Register codelist file: Select main menu[Settings]>[EDINET Download].
Download the code files.
Then, slect main menu[Settings]>[Register downloaded files].
Register the code list file downloaded in advance.
The code list is a list that contains basic information about the submitter or basic information about the fund.
At EDINET, submitters and funds are managed by EDINET code and fund code.
This list must be pre-registered to display submitters and funds by name.
Please download and register the code list about once a year.
Also, if the fund name or submitter name is displayed as unknown, please register the latest code list file.
EDINET code list: Select main menu[Settings]>[EDINET code].
You can set the XBRL file automatic collection submitter here.
Fund code list: Select main menu[Settings]>[Fund code].
You can set the XBRL file automatic collection submitter here.

List of Documents

Get list information of documents submitted daily from EDINET site.
Based on this information, you can register the XBRL file of the required document and display the PDF file.
If an automatic collection submitter is set in advance, registration of the XBRL file can be done with one click.
If you specify the submission date on that day, the list information of documents submitted by that time will be acquired and displayed.

The submitted document list information is the information of the documents submitted on the submission date.
Based on this information, the XBRL file of the documents to be registered is downloaded and registered.
Since the submitted documents are managed by ID, the submitted document list information is required to refer to the ID of the document to download.

Single company

The submitters who have registered the XBRL file are listed as "registered companies".
FStateMan targets only registered companies.
Companies and funds that do not have an XBRL file registered will not be displayed.

You can switch between company selection lists in the following ways.
Order by submission date
Featured companies
By industry
Code order

Even unregistered companies can display PDF files of submitted documents on the "List of Documents" screen.

The registered financial data can be displayed in a table format or bar graph.
You can display financial ratios such as operating profit margin.

You can search the documents of the relevant company from the list of documents to be submitted in the past and display the list.

Multiple company

Select multiple companies to compare financial data.
The data of multiple companies can be displayed in tabular form and bar graph.
You can view the financial ratio of multiple companies.

Log area

If a message log is output, it will be displayed at the bottom of the window.
The message log can be deleted.
The display area is automatically hidden when the log is deleted.
How to delete the message log
Click the right mouse button in the log display area to display the popup menu and select "Clear".

Library folder structure

The library folder consists of the following two folders.

Data base folder(DB)
Taxonomy folder(taxonomy)

[Note]
Since the library folder consists entirely of character string files, setting the compression attribute for this folder will save disk space.
It takes about half the space.

Database folder

This folder contains files created by FStateMan.
Financial data for each company is stored in this folder.

Taxonomy folder

EDINET taxonomy files are stored in this folder.
The taxonomy referenced when registering the XBRL file is automatically copied from the EDINET site to a local folder.
If the referenced taxonomy file exists locally, use that local file.

[Note]
When EDINET server is congested, the taxonomy file may not be able to be acquired normally from the server.
In such cases, we recommend downloading the taxonomy files directly from the EDINET site and copying them to a local folder.

How to download EDINET taxonomy and copy it to a local folder

Select main menu[Settings]>[EDINET Download].
The taxonomy download page will be display in web browser. In general, you will need to download the "00 . ALL" file for the required year.
Select main menu[Settings]>[Register downloaded files].
The downloaded taxonomy files will be listed.
Select the target file and click the "Register" button.

Local taxonomy folder