IFRS automation: there are no universal recipes, but there are useful tips. Automation of IFRS - accounting according to international standards Methodology for automating accounting reporting according to IFRS

To make effective management decisions, it is necessary to have accurate and complete reporting, including according to IFRS. The standards are gradually becoming more complex, and the requirements for the timing of document preparation are also becoming more stringent. Available resources are not enough or they turn out to be ineffective in the context of a rapidly developing banking business. In this case, a reporting automation system can provide significant assistance to the bank.

The main objective of an automated reporting system in accordance with IFRS is to reduce preparation time by automating this process. In addition, by automating the verification of information both at the stage of entering it into the system and at the stage of monitoring the consistency of data in reporting, the number of errors associated with the human factor is significantly reduced. In this regard, the need for such systems is growing every year.

In the modern market, there are a number of systems for automating IFRS reporting using international standards and principles (IAS, GAAP) for different final purposes and consumers (published, internal, audited, interim reporting).

Almost all systems use the method of transforming data from national accounting reports to international ones. They are built using data warehouse technology and easily integrate with the software installed in the bank. The repository can collect data for compiling IFRS reports from any automated systems. At the same time, the tasks of preparing individual statements of organizations that are, for example, part of a banking group, and consolidated statements of the entire group are solved.

Specialized modules of such business applications cover all stages of the automation process - from loading the necessary data to issuing ready-made reports. Even the most complex adjustments are automatically calculated, thereby significantly reducing labor costs and reporting time.

A company automating reporting in a bank, first of all, must understand what approaches to building international reporting are used in it. And also what problems prompted the bank to implement an automation system. This is work at the intersection of IT and business consulting. In essence, the task of the automation company is to outline a certain path, following which the bank will receive automated reporting. In this case, the bank’s BI strategy and the development strategy for reporting reporting are combined. Their development is an indispensable condition for creating a system that would meet the needs of the bank.

Criterias of choice

The choice of an automated reporting system must be approached extremely responsibly, carefully weighing all the pros and cons. Of course, when choosing a particular solution, a bank is guided by certain criteria, such as ease of use, cost, and functionality.

“Since at the time of the start of the project to implement an automation system, the bank had an industrial solution, SAP BW (data warehouse), we had no questions related to finding a solution,” says Oleg Ilyukhin, director of the IT department of SDM Bank. - All the necessary data was already available in the warehouse, and all that remained was to correctly collect the necessary reports. Currently, the IFRS reporting automation system includes such components as source systems (ABS), SAP BW data warehouse, reporting forms in BEx (SAP application for generating reports).”

“Usually, before choosing one or another IFRS automation solution, it is necessary to identify the effectiveness of the project to automate the preparation of IFRS reporting, that is, compare the costs and benefits of this project,” says Natalya Rublenko, head of the IFRS reporting department of Rosgosstrakh Bank. “The choice of solution is also influenced by the degree of diversification of the bank’s business, the size of its branch network or the number of subsidiaries.”

“When choosing one or another IFRS automation solution, the bank must be guided by the basic principle - realistic implementation and support,” says Arkady Zatulovsky, CIO of Nordea Bank.

Labor-intensive process

Financial and credit organizations have different views on the process of automating reporting under IFRS. For example, at SDM-Bank, the implementation of such a system was dictated by the high labor intensity of collecting the necessary reports and the risks in manual processing of information.

“From the first day of operation, Raiffeisenbank, as a subsidiary of an Austrian bank, has been preparing monthly IFRS reports for the parent company,” says Natalya Shirokova, head of the international reporting department of Raiffeisenbank. “Raiffeisenbank has implemented an automated reporting system in accordance with IFRS, which is dictated by the need to prepare high-quality information for the bank’s management and shareholders in a short time.”

At Nordea Bank, an automated reporting system according to IFRS has been partially implemented. “We plan to build IFRS reporting on the basis of a corporate data warehouse (DW), says Arkady Zatulovsky. - This is a step-by-step process, since it depends on the stages of the data warehouse project (the sufficiency of the loaded primary data). Before the completion of this project, the financial unit is building a number of adjustments to IFRS based on the data warehouse, which will optimize the process of preparing IFRS as a whole.”

Rosgosstrakh Bank has not yet introduced an automated reporting system according to IFRS. First of all, this is due to the lack of high-quality offers of software products on the market and qualified personnel among software developers, explains Natalya Rublenko. “Today, complete automation of IFRS reports for a particular bank costs at least hundreds of thousands of dollars, and its implementation requires more than a year of painstaking work by the employees of the system supplier and the customer itself,” says an expert from Rosgosstrakh Bank. - While 2-3 employees of a multi-branch bank using MS Excel can successfully prepare financial statements under IFRS using the transformation method within 2-3 weeks. Moreover, the transition to IFRS requires changes to the bank’s existing business processes, and, consequently, to the document flow system installed in the company, since the analytical load on primary documents increases and additional links appear in the chain of movement/approval of documents.”

For the reasons outlined above, the construction of international reporting in Rosgosstrakh Bank is carried out using the transformation method, the essence of which boils down to the reclassification of accounts and transactions and the adjustment of Russian accounting data in accordance with IFRS requirements.

The question arises: when does the task of automating international reporting become truly relevant for a bank? According to Oleg Ilyukhin, such a task is always relevant for a large bank: “Large banks must regularly confirm their reporting for compliance with IFRS standards, so automation is necessary.”

Automation of IFRS reporting, in addition to the main goal of reducing the cost of preparing reports, also solves other problems, emphasizes Natalya Rublenko. “For example, automation of reporting may entail changes in the management of the entire bank. The efforts and funds invested in automating IFRS reporting can be compensated by improving business processes for managing the bank and by improving the quality of the bank’s integrated automation system,” says the specialist.

“The task of automating reporting becomes relevant for a bank as its size and profit increase,” says Natalya Shirokova (Raiffeisenbank). - Automation helps improve quality and reduce reporting preparation time. At the same time, an assessment of its costs and future benefits is carried out.”

According to Arkady Zatulovsky, automation of IFRS reporting is necessary when an organization begins to actually live by Western rules, or the requirements of the parent bank become mandatory for it. “This is the reality of all the subsidiaries of Western banks in Russia, which imply extremely short deadlines for preparing IFRS reporting and the regularity of its submission at least once a month,” explains the IT director of Nordea Bank.

Automation of all stages

The system's mechanisms provide automation of all stages of the technological cycle of preparation and release of reports. Firstly, collection and verification of source data. Accounting information and analytical data on transactions and other accounting objects are collected in a data warehouse from branches or subsidiaries of the group's banks. The uploaded data is verified for consistency.

Secondly, data is entered into the category “professional judgments”. The system provides interfaces for entering data that is missing in national accounting, including risk assessment parameters and estimates of the market value of instruments in accordance with the requirements of international standards.

Third, balance sheet items and income statements are regrouped. This operation is done on the basis of customizable tables for regrouping source accounting data into reporting forms according to IFRS.

Fourth, adjusting entries are made. The system provides interfaces for setting up correspondence of articles and formulas for calculating the amounts of adjusting entries. These postings can be performed manually or automatically.

The next stage is the consolidation of reporting. The system provides all the necessary tools for consolidating the financial statements of subsidiaries and associated companies and banks using the full consolidation method, the equity method or the acquisition price method. Interfaces are provided for viewing data before and after consolidation, as well as interfaces for setting up and making consolidation adjusting entries.

As a result of completing all stages of the technological cycle, users receive a set of reports in accordance with IFRS: balance sheet, profit and loss statement, cash flow statement, statement of shareholders' equity, tables for notes to financial statements.

It should be noted that the accounting automation project according to international standards is characterized by the same difficulties as all automation projects. Firstly, certain negative aspects arise in the work of personnel due to increased control and increased workload. Secondly, problems arise in developing technical specifications. Thirdly, it may be necessary to purchase additional equipment. However, if there is a strong-willed message from the management of the organization to make the transition to IFRS and at the same time it agrees to the material and time costs associated with this project, then the process will be successful.

Effective management decisions cannot be made without the most accurate and complete reporting, including reporting in accordance with IFRS.

Recently, representatives of various organizations increasingly have an urgent need to automate the preparation of various types of reports. This trend is easily explained by the fact that the deadlines for preparing the necessary documents are becoming more stringent, and the standards are becoming more complex. As practice has shown, automation of the reporting process provides invaluable assistance!

Company "Informauditservice" For more than 20 years, it has been providing financial reporting services to various organizations using an automated system and compliance with international standards GAAP, IAS.

The main goal of any automated system is to prepare the correct reporting of a given type (published, audited, internal, intermediate), reducing the time required to carry out this process to a minimum. We select for our clients the optimal system that can solve even the most complex problems even before the deadline.

Advantages of IFRS

The transition to international financial reporting and accounting standards allows banking organizations:

reflect the real economic essence of the transaction as accurately as possible, placing emphasis on content rather than form, as is the case with RAS, which require the strictest compliance with reporting standards prescribed by law.
write off the cost to replacement value if it turns out to be lower than the book value.
reflect the initial cost of fixed assets;
include only direct costs in work in progress;
work only with those funds and bank accounts that are available for settlement of transactions...

We have listed only a small number of the advantages of IFRS, according to which all progressive enterprises prepare reports.

Methods of reporting under IFRS

There are several methods of reporting according to IFRS: the parallel accounting method, the reporting transformation method and the transaction translation method, which differ not only in the complexity of implementation, but also in the quality of the information received.

The most complex is considered to be parallel accounting, which uses primary documents as input and produces reporting in several standards as output, as well as postings in accounting registers. In this case, all business transactions are reflected in databases both according to Russian standards and IFRS. This method is also the most expensive, and therefore is used extremely rarely by enterprises.

The method of translating transactions in one of the standards allows you to create accounting registers. Accounting is organized in one database in accordance with national standards, after which each of the operations is translated into the database according to IFRS (from the source database to the destination database). Broadcast types differ in what currency is used (one-to-one, historical, current, weighted average, original or preset). This method is complex and labor-intensive, which also entails time and material costs for clients.

Transformation of reporting is the best way to solve problems

Based on what was written above, the most convenient, fastest and most profitable method of reporting is transformation. Transformation is the generation of financial statements according to IFRS, i.e. translation of data into international financial statements from national ones.

This method is based on the use of storage technologies, which contain all the data that integrates with the software installed in the bank. Such a repository can collect information from any existing automated systems. This allows you to prepare individual reports for the bank, as well as reports for the group in which it belongs.

The transformation of IFRS reporting makes it possible to create reporting periodically and for a given date due to the reclassification of RAS reporting and their adjustment. Typically, the transformation is a set of tables that clearly demonstrate the transition from financial statements and Russian balance sheet items to IFRS standards. Let us note that only this method of reporting can ensure the visibility of such a reconciliation.

The specialists of the Informauditservice company draw up any reports, reducing labor costs and timing of this responsible and painstaking work to a minimum. At the same time, even the most complex adjustments can be made at any time. Despite the fact that some experts consider automation of the preparation of IFRS reporting by the transformation method to be the most risky in terms of errors, we guarantee that to all the advantages of this method, our qualified employees will add one more thing - vigilance: the reports that our clients receive are compiled in such a way professionally, that the presence of errors in them is excluded.

Transformation of financial statements according to IFRS (IFRS)

Today, the service of automating the preparation of financial statements under IFRS is the most popular. However, this convenient and quick method of reporting is not considered the simplest.

The practical application of IFRS requires considerable knowledge and solid work experience, which is what our company’s employees are so proud of. Let us note that IFRS, which is not a set of strict rules and leaves freedom of action for specialists, also has a downside: responsibility for the accuracy of the reports compiled falls entirely on the shoulders of the person who undertakes to perform such work.

Our company’s employees approach the implementation of assigned tasks independently, but our clients can always act as the main adviser and the person who has the right to control the work process at any time.

When starting to set goals, we proceed not only from the essence of the operation, but also from the specifics of the enterprise’s activities, as well as its economic situation. Our specialists have extensive experience in such work - experience in auditing, as well as reporting not only for corporate purposes, but also in providing the necessary documents to international financial institutions.

Preparation of IFRS financial statements consists of several stages:

designation of accounting policies within the framework of IFRS for each of our clients separately;
determining the company's obligations;
drawing up a working chart of accounts;
processing of RAS accounting information, which will be translated into compliance with IFRS;
reclassification of transactions taking into account their economic component;
formation of valuation reserves;
recalculation of necessary indicators according to IFRS;
determining the value of assets;
development of reporting forms that best suit the specifics of the enterprise;
preparation of ready-made reports, as well as explanations.

What do our clients get as a result of cooperation?

Our Clients receive ready-made IFRS statements and explanations for these documents in the form of four forms: statements of financial position, statements of capital and comprehensive income, as well as statements of cash flow. Explanations include information about both financial and non-financial activities of a particular enterprise that were not included in the reporting.

5 reasons why our clients absolutely trust us

Company "Informauditservice" exists for more than 20 years
Our experience is confirmed by our portfolio, client names and reviews
Our company employs highly qualified employees
Automation of reporting will save your time, and verification of documents by specialists will ensure their accuracy and literacy
The reports we issue have never had any complaints.

We guarantee impeccable work, which is backed by competence, experience, the ability to listen and convince, love for our work and respect for our clients. We listen to your every word!

Cost of services

The cost of reporting is individual for each customer and is always beneficial for the client.

This article is so unique, that we couldn't find any services related to it!

The problem of automating accounting processes and preparing reports under IFRS.

In connection with the spread of IFRS, especially after its official adoption in Russia at the end of 2011, the problem of automating the preparation of reports according to International Standards is becoming increasingly relevant. However, currently there is no software product on the market that would satisfy the basic needs of consumers and would be a kind of standard in their field, such as 1C products for accounting, MSProject for project management, AutoCAD for preparing drawings, etc. The reasons for this are that IFRS do not regulate accounting as strictly as, for example, Russian Accounting Standards (hereinafter referred to as RAS), and are more difficult to formalize. The main software that can be purchased is either very complex accounting systems such as SAP, Cognos, Hyperion, etc., or small systems from domestic manufacturers.

The first products are very expensive both in themselves and their implementation itself requires large material and time costs. Only large companies can afford this. The implementation of such a system, as a rule, affects many business processes in enterprises and requires an expensive restructuring of the IT infrastructure. Products from domestic manufacturers may be cheaper and simpler, but usually they do not provide the full range of necessary functionality. The development of these products will also require large investments, because... Manufacturers hide technical features from buyers and offer a range of expensive services for the implementation and modification of these systems to suit the characteristics of each specific business.

Therefore, many people have a myth that automating IFRS is difficult, time-consuming and expensive. I would like to dispel it a little and describe an idealized example of how automation can be introduced in the preparation of IFRS in a large holding company (the consolidation perimeter may include more than 100 organizations). The implementation time is estimated at 2...3 months, the budget is the department's own resources (for example, 4..5 people between reporting periods). Of course, you won’t get a “big button” that solves all problems, but the effect will be significant. You will not be ashamed to show such a project to management. Maybe someone will find this example interesting, because... automation of these processes in many enterprises leaves much to be desired.

The category of stakeholders may be different, so I divided the presentation of the example into two parts: for people not related to IT (How it works and what we are changing) and for IT specialists (Solution concept). The same thing is described, but just from different points of view. If you are not an IT specialist, then you don’t need to read the second part. To prepare reports, the method of transforming RAS reporting into IFRS is considered, since it is the one that is used in practice in most cases and is the easiest to use.

Part 1. How it works and what we change.

A situation that is proposed to change radically.

Let's imagine the following picture. The company has been preparing reports in accordance with International Standards for several years. The level of automation of the IFRS department is low. The main automation tool is Excel tables. A simple consolidation program can be used, which does not allow the creation of analytical reports. Or consolidation is also carried out in an excel file. Reporting is based on the method of transforming RAS into IFRS. It goes something like this.

Each of the holding's enterprises collects reporting forms for IFRS in the form of Excel tables in a single file. We will further call this file “Package”. These forms are reviewed and loaded into the consolidation program (or excel summary file). Next, intragroup transactions are reconciled and adjustments are calculated. The results of calculating all adjustments are performed in excel files and entered into the consolidation system in a summary form. To prepare analytical reports and financial disclosures, information is collected from many source files. Sometimes separate transcript tables may be maintained for specific accounting areas, moving from period to period (“Roll”). There may be many versions of such tables, making it difficult to analyze the information. Those. During your work, you may encounter the following problems.

1. The transformation package is tested for a long time and is difficult. Because Since the package is collected in final figures, it is difficult to compare it with accounting data. You have to call the accountant and find out - on the basis of what data he filled out this or that line, or, if you filled out the package yourself, open files with calculations and search there. The auditor also does not understand how the package was formed. And in some cases he is forced to repeat the work of assembling the package again or ask you a lot of questions in order to check it properly.

2. In the consolidation system, reporting is collected at the top level only in synthetics: Account Amount, and all decryptions have to be kept in separate files. There may be several versions of such files, which makes your work more difficult. Collaboration with such transcripts is also difficult.

3. To carry out calculations of adjustments according to IFRS, it is necessary to obtain certain data in different sections. Since the reporting capabilities of the consolidation system are very limited, you have to spend a lot of time generating these reports manually.

4. Revising adjustments from period to period is difficult. You have to open separate databases and compare analytical reports. Those. all information is distributed in many databases and files. Its collection and analysis also takes a lot of time.

You have a lot of work and often have to stay late and work outside of working hours and on weekends. But you still want to have time for your personal life...

Basic principles to use.

To solve these problems, I suggest you create a centralized information system for yourself. Let's say that you have little money for development and need a guaranteed result in a short time. Therefore, in this situation, I propose to use the following principles:

Divide the future system into modules. The implementation of each module should give a tangible result, both on its own and in combination with other parts. There are risks of not having time to solve something, so the system must work in case of failure or lack of time to implement one or another module.
Automate only the most difficult and time-consuming processes. You should focus on the main problems first. It is their solution that will have the greatest effect.
To provide ample opportunities for local people to automate their accounting area. Those. automation tools should provide some constructors that each user can customize for themselves. This will allow you not only to save resources, but also to involve people in the system development process, which is also very important from a motivational point of view. After all, if a person is given the opportunity to make his work easier himself, in most cases he will try to do it and will be happy about it.
Do not change the primary data. You need transparency of the transformation and the ability to “stretch” the entire chain of calculations from the primary document to the final figure in the reporting. Therefore, accounting is expected to be organized according to the principle of IFRS = RAS + Adjustment 1 + Adjustment 2.

I suggest starting with the following modules:

Transformation package;
Automated means of filling out the transformation package;
Centralized data warehouse with analytical reports;
Design tool for filling out printed forms.

Changing the transformation package.

A transformation package with data from a local accounting system is usually built on the basis of many tables connected to each other. In practice, it is very difficult to trace the connections between these tables. Automation of a huge number of such tables is also very complicated. We face two tasks:

Simplify the structure of data entry into the automation package as much as possible so that its filling can be automated while maintaining its completeness;
Add data decryption to the package, based on which balances from which accounts certain lines were filled in.

To implement these tasks, it is proposed to use the following solution. Two flat tables are added to the package for entering summary information for the period from RAS:

Table of account balances broken down by all subaccounts. Table columns: Account IFRS, Account RAS, Amount, Analytics1, Analytics2;
Table of summary turnover. IFRS account, Account DtRSBU, Account KtRSBU, Amount, Analytics Dt1,..., Analytics Kt1,...

Data entry into the remaining tables is blocked (reserved only for entering the total package amounts for the previous period, since these amounts do not participate in the generation of reporting, but are entered for comparison). Data is pulled into other tables, for example, through excel formulasSummesif() from the sheets of the tables of balances and turnover. Schematically, in a simplified form, this can be depicted as the following diagram:

Thus, the Auditor and IFRS Preparer checks the same package (if you already had it), but sees on what data it was filled out. Moreover, the IFRS chart of accounts is uniform, but the RAS chart of accounts can be different in each system. At its core, the process of preparing a package requires posting the balance sheet in the context of IFRS accounts, and not filling the package with final figures from RAS, as is often the case in practice. The principle is observed - no changes to derived data, and the package becomes more “transparent”.

It takes about two weeks to solve this problem, write formulas and block data entry (depending on the complexity of the package).

Automation of filling the package.

Because The package has been modified, now you can automate its filling. The task before us is:

Automate the posting of balance sheets by IFRS accounts for a large number of holding companies.

Because the structure in terms of storing accounting data in 1C Enterprise systems is usually the same (it does not matter whether it is Production Enterprise Management or Enterprise Accounting), then it is proposed to create external 1C processing as a means of automation (the prototype can be found in the application). Those. For each accounting system, an external procedure will be launched, which, based on the correspondence table, will fill two tables of the package. There will be two types of correspondence, for the table of balances and summary turnover, respectively:

RAS account, Subconto1, Subconto2, Subconto3 ---> IFRS account

Account DtRSBU, Account KtRSBU, SubcontoDt1,..., SubcontoKt1,...--->Account IFRS

Next, we write instructions (including video instructions with an example) and conduct training for specialists, and we transfer this automation tool to the holding’s enterprises. With quality training and your support, those responsible for providing information for IFRS will master this tool and cope with the task of filling out the package. Those. For each database, a correspondence between RAS and IFRS accounts will be created, which will be stored in a separate file and used as a parameter for an external procedure. The accountant runs an external procedure, specifies the settings-correspondence file, changes it if necessary, clicks the execute button, receives the report and inserts it into our package.

It will take about a month or two to solve this problem. Creation of treatments takes 2-3 weeks (development can be ordered from a contractor), testing them together with the package takes 2-3 weeks (depending on the complexity and number of systems). The time it takes to fill out the package will be reduced, and “transparency” will increase. I think that most contractors to solve such integration problems will either offer you the replacement of IT systems with a single platform, or offer the development of integrations with existing systems, which will also require a lot of time and resources.

Centralized data warehouse with analytical reports.

In order to automate reports and organize all your information, you need a consolidation system that would store all the data in one place. You have two main tasks:

Provide the ability to obtain data from a centralized storage.

I propose to use a Database Management System as a data warehouse and at the same time a consolidation system. The data will be stored in a structured tabular form. Their processing and analysis in this case can be automated.

The structure of the new system should be as simple as possible for receiving reports. Therefore, it is recommended to choose a snowflake architecture as the base architecture. We will put all the package data into one large table with columns: RAS Account, IFRS Account, Amount, Counterparty, Reporting Period, Project, Analytics1, Analytics2... To store possible values of Reporting Periods, Projects (or types of products), IFRS Accounts, etc. Let's create separate tables. Thus, it turns out that one central table (RAS Data) has many connections with others.

This type of architecture is very convenient. Because All data is collected in a single table, then using the pivot table mechanism, you can get a huge number of reports. This construction principle is usually called an OLAP cube.

There will be a lot of data in the RAS Data table, and for final reporting under IFRS we suggest creating another such table. Data from the RAS Data table will be collapsed and transferred to the IFRS Data table, which has a similar structure. Those. When the package is loaded into the consolidation system, the RAS Data table is loaded, then totals are generated for some of the columns and they are loaded into the IFRS Data table. The set of columns of the IFRS Data table is approximately the following: IFRS Account, Amount, Organization, Reporting Period, Adjustment Number, Analytics1, Analytics2. Columns with Analytics will depend on the specifics of the business. This could be, for example, Counterparty, Project/Order, Type of Product, etc.

All adjustments will be made only in the IFRS Data table in separate rows. Thus, it turned out that the Total amount according to IFRS = RAS data + Adjustment 1 + Adjustment 2, etc.

We keep records of adjustments in a separate table with the columns: Adjustment Number, Path to Adjustment File, Adjustment Period, Organization. Those. For each adjustment, we write down the path to the calculation file on the basis of which it was generated.

I advise you to choose the 1C Enterprise 8 system as a platform:

due to the ability to conduct rapid development;
due to the powerful data composition mechanism, what is needed to build reports based on one “big” table with data;
due to the wide opportunities for development, especially in terms of Web technologies;
due to the large number of specialists in the labor market.

The following tasks can be solved: creating a repository, writing algorithms for loading data from packages, creating two universal reports and creating mechanisms for exchanging reference books with the Regulatory Reference Information system (if you have one) in about 3 weeks.

Design tool for filling out printed forms

Our task is to ensure that data is output from our Data Warehouse to a printable form. MSExcel is very suitable for automating a printed form. We use the following technology.

A) Create two sheets in the Excel book “Report Data”, “Printable Report Form”.

B) On the “Print form” sheet we create a printable form of our report. We will fill in the numerical columns using, for example, the sumslim() function, taking information from the “Report Data” sheet.

D) To the “Report Data” sheet, copy the information from the IFRS Data table of our Data Warehouse. It is better to write a separate automatic procedure for this. You can first collapse the table a little, removing redundant analytics and reducing the volume.

The principle is shown in the figure:

The mechanism can be improved. On the printed form sheet, we create cells to set the parameters of our report. Parameter values can be saved in separate lists and selections can be made from the list. Depending on these parameters, the calculated cells of our printed form will be filled. One of these parameters may be, for example, Reporting period. Our printed form will be filled out based on the “Report Data” sheet and depending on the selected period in the cell. This method is suitable for filling out many printed forms.

Another great feature of MSExcel is that tables can be inserted directly into an MSWord file using Paste Special. If you need to update your reporting, you just need to update the information on the “Report Data” sheet, and the reporting book data will be updated automatically.

It will take the developer about 3 days to implement this universal mechanism.

What will you get in the end?

Now your data is stored in a single system. You have no problems with the output of analytical reports. Packages are filled out faster, and you can always show the auditor where this or that number in your reporting came from. There are more opportunities. But you want more:

compare your analytical accounting data in a centralized system with other accounting systems in the enterprise;
streamline and formalize the calculations and methodology of all your processes;
automate the calculation of adjustments;
etc.

These problems can also be solved by you. To do this, you need to believe in your own strengths, have a close-knit team of specialists, and use simple and effective solutions. The effect of putting things in order will be enormous.

Part 2. Solution concept.

Initial conditions (before automation):

A large holding with different types of activities (there may be more than 100 organizations);
The method of transforming RAS into IFRS is used;
Accounting systems for Russian accounting are mainly 1C Enterprise 7.7 and 1C Enterprise 8 in different configurations (including highly modified ones). This requirement is not mandatory, but if it is, you will get the greatest effect;
The enterprise already has an accounting transformation model in the form of a package, which is an Excel file with reporting forms for collecting RAS data. If there is no such model, then you can download it on the Internet. There are many such files in the public domain.
This is not the first year that IFRS reporting has been prepared.

Basic principles used for automation:

Use of modern technologies (ETL, OLAP, unified data model);
Maximum use of the potential of available tools and minimal programming (only where it is really necessary);
Minimal changes to local information systems;
No changes to derived data;
Short development and implementation time: 2-3 months;
Minimum cost of further support;
Modular structure of the solution with the ability to replace individual modules when more advanced technologies become available.

Business process (enlarged):

Preparation of RAS data (closing databases);

Filling out transformation packages for IFRS at enterprises;

Calculation of adjustments and entering them into the consolidation system;

Preparation of the reporting book (main reports and reports for disclosures).

Problems (which will later be solved as a result of automation):

High level of manual labor, packages are filled with final data manually;
There is no way to trace on the basis of which primary data certain figures in the reporting were obtained and, as a result, a long audit of packages;
Lack of analytical disclosure of figures in reporting in a single database. All transcripts are stored in separate files, which leads to inconsistency between the data in the transcripts and the final reporting;
A large amount of labor spent on creating analytical transcripts for reporting and the inability to build analytical reports automatically using a software tool, because all analytical information is stored in separate files or databases.
The “reporting book” tables are filled out manually, which leads to a lot of time spent filling it out.

Architecture of the solution and description of its operation.

Solution scheme:

Data from primary sources of information (databases for maintaining RAS accounting) using a universal ETL tool (in our case this is external processing for 1C) is transformed into a single chart of accounts according to IFRS and loaded into a consolidation package (excel file, hereinafter simply package) in the form of two tables: summary balances and summary turnover of accounts broken down by all analytics (sub-accounts). The operating principle is simple. The user, who is responsible for filling out the package at the enterprise, creates a setting - a correspondence between his chart of accounts and the chart of accounts according to IFRS (the correspondence can include not only accounts, but also sub-accounts). Based on this correspondence, using external processing, tables of balances and turnover are uploaded with reference to two charts of accounts simultaneously: the RAS chart of accounts of the local database and the unified chart of accounts of the IFRS consolidation database.

In the package, verification reports are built using formulas based on these two tables, incl. and a trial balance according to RAS in the format of IFRS accounts (table of balances - for the balance sheet, table of consolidated turnover - for the income and expense statement). Package data (tables of balances and turnover) are loaded into the consolidation system. Auditors have the opportunity to check package data using verification reports within the package itself, checking them against the accounting in the RAS database.

The consolidation system is a data warehouse built according to the “snowflake” principle on the 1C Enterprise 8 platform. Theoretically, it can be any other platform, but it is advisable to use a database management system. In our system we will have two “snowflakes” - two central tables:

Table for RAS Data (contains RAS account balances and consolidated turnover, downloaded from packages);

IFRS data table (IFRS general ledger = aggregated RAS data + Adjustments) with linking reference books, some of which are centralized analytics. In my practice, these were reference tables: “Organizations”, “Projects”, “Reporting Periods”, “IFRS Chart of Accounts”, “Adjustments Table”.

Data for the RAS data table is loaded only from packages. These data are then aggregated and transferred in summary form to a data table according to IFRS. This happens when downloading from a package automatically. In the IFRS data table it is also possible to add adjustment lines. Each adjustment is linked to an excel file - the source of calculations. Thus, the final balance sheet according to IFRS can be divided into accounts into adjustment lines linked to the calculation file and lines downloaded from the package. The primary data does not change, and it is possible to trace the entire chain of calculations from the final result to the original data source.

The hierarchical Anglo-Saxon model of the chart of accounts according to IFRS is used (without correspondence). The income statement accounts are subordinate to the Retained Earnings account. This provides a link between the balance sheet and the income statement. You can develop a chart of accounts for yourself or take any recommended one. The balance sheet and income and expense report are obtained using the pivot table tool based on the IFRS data table.

The data warehouse has two reports: Report on IFRS data and Report on RAS data. The reports are built on the 1C data layout and essentially represent two OLAP cubes: a cube for IFRS data and a cube for RAS data. These reports are built very quickly, because... Essentially, the 1C platform tool is used - data composition. Programming may be necessary when you want to implement a connection between reports, when decoding the lines of an IFRS report obtained on the basis of RAS data, you can call a report to decrypt RAS data. Thus, the report will allow you to obtain a decryption of IFRS data before primary analytics. Having studied the principle of operation of pivot tables, the user will be able to build the necessary reports for himself.

It is proposed to use the following technology as a universal means for obtaining printed reporting forms. The data is aggregated into a data warehouse and uploaded in the form of a table onto a separate sheet in an Excel workbook. Using simple formulas, the data source for which is the downloaded table with summary IFRS data, printed forms are generated on separate sheets. To update the printed forms, you simply need to re-upload the data to a sheet of the excel file; all sheets with printed forms will be updated automatically. Any competent Excel user can create a printable form for themselves. This will save you many hours of work from IT specialists.

Results:

Automated filling of packages according to IFRS. In practice, it may turn out that in some cases you cannot avoid some manual filling. You can easily solve this problem by adding 2 sheets to the package for entering manual adjustments, which will be similar to the sheets of consolidated turnover and balances, and will also be loaded into the Data Warehouse.
The process of recording information according to IFRS has been implemented, when it is possible to trace on the basis of what primary data the reporting was generated (up to RAS account balances in the context of subconto);
A centralized data warehouse for IFRS has been created in the context of analytics (Centralized directories, analytics from local databases, etc.). Almost all IFRS data is stored in one place in the database and can be processed automatically.
The process of obtaining analytical transcripts of figures for reporting has been automated.
The process of filling out the reporting book has been automated.

The positive growth dynamics of enterprises switching to international standards when preparing their reporting increases the need for a rapid transition and makes it urgent to automate the reporting preparation process through the use of modern technical means. It should be noted that a streamlined automated process will reduce time, that is, increase efficiency, and also reduce the likelihood of errors and incorrect filling associated with the human factor.

Due to the fact that each industry is unique and has its own specifics, there is no single widely used software product in the IT market for preparing financial statements under IFRS. Spreadsheet editors, databases and complex software products of individual companies are used as products that transition from national reporting forms and data to forms and data that comply with IFRS.

To automate the reporting preparation process, spreadsheet editors are often used, which by their nature are less expensive. For example, a spreadsheet program created by Microsoft Corporation is Microsoft Office Excel. This software product is convenient for carrying out the transformation process, which is presented in the form of detailed analytical transcripts for each balance sheet item and profit and loss statement. You should start by compiling and filling out a worksheet of opening balances. To do this, you need to transfer and regroup information from reporting compiled according to Russian standards into a table of opening balances. It is better to indicate data with signs corresponding to the logic of accounting entries: assets in the transformation table are indicated with a “plus” sign, liabilities with a “minus” sign. During the regrouping process, balances are entered into the table taking into account their future presentation in the balance sheet under IFRS. The transformation table is filled in both rows and columns: the rows show the names of the balance sheet and income statement items according to IFRS, and the columns show balances according to Russian data. After which all individual adjustments according to IFRS are indicated. So, analytical tables are filled with data on operations and accounting objects, after which the results are recalculated using formulas and classifications, which brings the data into compliance with international standards.

It should be noted that the number of tables is large, and the work of filling out analytical tables is usually done manually. The complexity and labor intensity of the work depends on the type of activity of the enterprise, on the scale and geography of the business entity, as well as on the amount of incoming information. Work on filling out data is differentiated by department: accounting provides information on fixed assets, inventories, debt, etc., credit department - information on loans and loans, legal department - data on real estate (buildings and land plots). In each department, forms are filled out, which are subsequently subjected to algorithms to verify the correctness of the information entered. After all analytical transcripts are completed, they are provided to the accounting department and combined into a common file. The information received by the accounting department allows the initial posting to IFRS accounting items. When the analytical tables with recalculated data are ready, all that remains is to make adjustments to bring the reporting values under RAS to IFRS.

In order to transform Russian reporting into international reporting, it is necessary to use a horizontal transformation model, which is a plan of balance sheet and profit and loss account items, which are placed on one sheet for viewing in conjunction. The model contains the results of the initial transformation from RAS, sequentially all adjusting entries and the final result according to IFRS, supplemented by translation into foreign currency.

At the stage of filling out analytical transcripts, you can create a program that would automate this process. For example, use modules to regularly import data from accounting systems into Microsoft Excel. Such downloads allow you to automatically generate detailed information about the composition and amount of receivables and payables, the nomenclature and amount of inventories, etc. This will make the preparation of IFRS reporting more efficient and somewhat reduce the time spent on preparation.

Despite the ease of use of the spreadsheet editor, this automation method does not solve the problems that arise in larger organizations with large volumes of data. The next stage of automated programs is software in which accounts and postings are set up in a more convenient format than in spreadsheet editors. An example would be the software product “1C: Enterprise 8” (developed by the PB company), “Transformation ToolK.it” (Finaco), “RS-DataHouse: IFRS”, the “Galaktika” system, etc. Such systems support multi-currency accounting and allow you to make a number of adjustments, for example:

transfer of the account amount from the Russian accounting database to the corresponding account in international reporting documents;
transfer to the parallel accounting system of only debit or only credit turnover on the account;
account transfer taking into account analytics;
transfer of an account by transaction type (for example, “Counterparty A - legal entity B”);
transfer of an account according to a set of transactions (“Advance payment”);
transfer of account turnover to a group of parallel accounting accounts in proportion to a certain base, etc.

The integrated enterprise management system "Galaktika" is a complex multifunctional enterprise/holding management system, positioned by the developers as a system belonging to the ERP (Enterprise Resource Planning) class. The program supports all three methods of transforming financial statements from Russian standards to other accounting standards: parallel accounting, translation of transactions, transformation of reporting. Along with the implementation of a wide range of management functions, the system allows you to maintain accounting records and generate financial statements that comply with the requirements of Russian accounting regulations, as well as International Financial Reporting Standards - International Accounting Standard (IFRS - IAS) and Generally Accepted Accounting Principles - General

Accepted Accounting Principles (US GAAP) .

“1C: Enterprise 8” is an application software platform for the development of business applications - software systems for automating accounting and enterprise management in various areas of the economy: manufacturing, trade, insurance, services, etc. Application solutions on boards

80 Chistov D.V. Automation of transformation of reporting from RAS to IFRS // http://fa-kit.ru form “1C: Enterprise 8” is developed directly by 1C, its partners, as well as independent developers. Application solutions developed on the 1C: Enterprise 8 platform are also called configurations.

The 1C company on the 1C: Enterprise 8 platform has developed a standard configuration “1C: ERP Enterprise Management”, which is an integrated production enterprise management system that comprehensively implements the functions of accounting and tax accounting, economic analysis, planning, budgeting, and personnel management. Based on the composition of the accounting and management functions covered by automation, this solution can easily be classified as an ERP (Enterprise Resource Planning) class system. The purpose of an ERP system is to connect all areas of an enterprise’s activities into a single information model of data and processes, ensuring constant optimization of the resources of departments and the entire enterprise as a whole. The capabilities of the 1C: ERP Enterprise Management 2 program allow us to call it a full-fledged ERP system. This configuration provides for accounting according to Russian standards and IFRS. Accounting according to IFRS is implemented by a separate module “International Accounting”, which we will also call “IFRS module” for brevity. This module is linked to the Accounting module, which provides accounting and reporting according to Russian rules.

For large companies with a complex structure and a large number of subsidiaries, the most suitable transformation technology is based on the use of data warehouses - the Kontur-Corporation system. Reporting under IFRS." The Intersoft Lab company develops the software Platform for Data Warehouses “Kontur”. Based on this platform, Intersoft Lab and its partners develop management solutions of various purposes and scales. The Kontur Corporation financial data warehouse allows holdings, industrial groups, organizations and banks with a multi-branch structure to create a unified information environment to ensure effective business management. The software and hardware implementation of the Repository allows the use of this development in very large organizations, providing, if necessary, the collection of data on a daily basis from hundreds of subsidiaries, the rapid execution of complex calculations and the generation of consolidated financial and management reporting with deep analytical detail. These software packages include an industrial database management system and interface programs that allow you to work with databases. Thanks to a database management system, an organization can store almost unlimited amounts of information while maintaining connections between them. Connections are established using user settings and saved in the system. The main stages by which data are converted are similar to the stages of a table editor, because the transformation method is the same. But unlike spreadsheet editors, the data warehouse is configured only with the help of the skills of the IT department or an experienced analyst. Implementing a reporting conversion system using repositories is a more expensive way than using Microsoft Excel, but this method also solves the problems of multi-user access and delimitation of rights.

The choice of automation method depends on the goals that the company sets for itself, on the scale of work and the size of the organization itself. In addition, it is necessary to take into account the need for frequency of reporting, the level of training and qualifications of specialists, and compare the time and financial costs required for the transition to IFRS. All this emphasizes the individuality of the company’s prioritization when choosing a product for automation.

Let's turn to research and statistics on the use of reporting tools. Surveys conducted from 2010 to 2012 showed a positive trend in the transition of companies to new reporting standards using “1 C” products and ERP systems. However, in recent years this dynamic has become downward. It should be noted that the number of companies leading and transforming swelling according to IFRS using the Microsoft Excel product today exceeds 50 percent. This is explained by the fact that the Microsoft Excel program is a cheaper and easier to configure product compared to the 1C program or ERP systems. According to the survey, even companies with revenues of more than 15 billion rubles are currently transforming reporting in this program. and a group structure of over 10 companies. Surveys show that next year companies with revenue of 50 billion rubles. plan to switch to using ERP systems and abandon Microsoft Excel. The chart shown in Figure 3.9 shows the percentage distribution of automation product use among 300 Russian companies.

Rice. 3.9.

Automated applications are a comprehensive solution to achieve several goals at once:

automation of the process of preparing financial and management reporting based on uniform IFRS principles;
prompt preparation of information for management, quick access to data from the entire financial corporation;
the ability to generate reporting both for a group of enterprises as a whole and for each individual company with automatic calculation of even the most complex consolidation adjustments;
preparing reports in a short time, reducing errors and reducing the “human factor”, eliminating rush jobs and night shifts;
reducing the burden of preparing data for auditors;
simultaneous release of reports using various methods based on a single pool of detailed data.

Regardless of the company’s decision to choose a reporting method within the framework of international standards, at the initial stage it is necessary either to develop rules for shifting transactions or even groups of Russian accounting transactions according to international accounting rules,

81 Auditing and consulting company "Baker Tilly Russia" Tools for preparing IFRS reporting // http://www.bakertilly.ru/ or develop a unified chart of accounts with advanced analytics that will allow the preparation of all types of reporting. Note that the interpretation of the standard in relation to specific business operations, especially in industries with pronounced specifics (for example, construction), often causes difficulties even for professionals. This forces us to attract qualified, highly paid specialists to the project. In addition, the organization will face natural difficulties that arise with any implementation of new processes:
- staff resistance due to increased control and increased workload;
- difficulties in developing technical specifications;
- the need to purchase additional equipment, etc.

All these difficulties are a small price that the organization will pay

to improve their work and to achieve the main goal - preparing correct reports of a given type in a short time using the main tool - automation.

Maintaining financial statements in accordance with IFRS is necessary, first of all, for international companies, as well as organizations whose head office is located abroad.
Also, accounting according to IFRS must be implemented by enterprises whose activities are connected with foreign banks or investors.
The third reason for automating accounting according to IFRS may be the requirement of a business owner who seeks to receive comprehensive information about how things are going in the company, because the use of IFRS significantly helps to achieve management goals.

The implementation of specialized software that allows a company to keep records in accordance with IFRS must be carried out with the assistance of specialists.

We provide comprehensive services in the field of accounting automation in accordance with IFRS:

transformation of reporting,
transition to reporting according to IFRS,
implementation of IFRS,
preparation of financial statements according to IFRS (including consolidated ones),
training users to work with the relevant software product, as well as
post-project support and support of the implemented system.

Stages of IFRS implementation

Our company offers its clients both the comprehensive implementation of IFRS “from scratch” and the implementation of individual stages in this area.

In general, the full cycle of IFRS implementation includes the following stages:

Analysis of the client’s tasks and requirements, as well as the company’s current accounting and reporting process.
Development and unification of accounting methodology according to IFRS and corporate standards.
Assistance in choosing a software product that best suits the company's objectives.
We offer our clients to switch to accounting in accordance with international rules by introducing specialized solutions in this area:
- BIT.FINANCE,
- 1C:Manufacturing enterprise management,
- 1C:ERP Enterprise Management ,
- 1C: Holding management,
- BIT.IFRS case and others.
Implementation of a control system (consistency of information, data protection, audit trail).
Adaptation of the methodology to the requirements imposed by the client’s information system.
Even if the company has already developed a methodology, or has engaged a third-party consultant for these purposes, we will help adapt it to the selected information system and implement it in the form of a fully functioning business process.
Development of an IT architecture for the accounting and reporting process.
Development of requirements for integration with other information systems.
Additional functionality requirements based on business processes.
System design development and testing.
User training and test operation.
Support for pilot production.

Launch accounting according to IFRS in 5 days! (Video)

Tip 1
Be sure to provide, because the latter are more flexible in matters of accounting policies and regulations. Probably, at the time of receiving and reconciling statements, you should think about the possibility of bringing together accounting under RAP and IFRS.

Advice2
Before setting up the chosen IT solution, develop an accounting methodology, on the basis of which the corresponding business processes will be formed, which will subsequently affect the functioning of the system as a whole.

Advice3
Be prepared for increased volumes of work and tasks in real time. This is due to an increase in the degree of control, because now the company will have to keep two records, control them, reconcile them and debug all processes.

Expert opinion:

“The introduction of reporting in accordance with IFRS is undoubtedly a trend dictated by modern market requirements. First of all, foreign companies or organizations whose activities are in one way or another connected with foreign business should think about accounting under IFRS. Today, the most pressing tasks in the field of IFRS are setting up account mapping, building business processes for reporting, accounting for intragroup turnover (IGT), as well as consolidated reporting. It is the implementation of these stages that you should pay attention to when implementing the appropriate IT system.” - Tatyana Solovyova, leading consultant, First BIT, project office "Sportivnaya"