1c how to create a report. Formation of regulated reports
In this educational article, we will consider the concept of 1C Accounting 8 reports. When working in the program, you basically need to enter the data of primary documents, but in the end, the owner of any business will want to know how he is doing. Do not forget about the various regulatory authorities - tax office, Pension Fund and so on - which also regularly require reports. In the case of the latter, you can also get a fine for a report not submitted in time.
That is why reports take a special place in the 1C Accounting program. And, of course, you should know how to use them. We will not analyze all types of reports here, of which there are a huge number in 1C Accounting 8. Let's consider only the main types of reports and how to work with reports in 1C.
Types of reports 1C Accounting 8
All reports in 1C Accounting can be divided into two large groups: regulated and internal.
Regulated reports intended for delivery to the tax and other government bodies... The type of each such report is established by the state. Regulated reports in 1C Accounting include Balance sheet, Profit and loss statement, VAT return and many others. The screenshot below shows a fragment of the program window displaying some regulated reports.
Internal reports are designed for daily use and do not give up anywhere. This is the balance sheet, account analysis, checkerboard and many others.
This was an important part of the article, but without JavaScript it is not visible!
In 1C Accounting 8.2, most of the reports, including regulated ones, are in the menu Reports... The rest of the reports are available on the Function Bar tab To the head... In version 1C Accounting 8.3 are located in the section Accounting, taxes, reporting... Below is the contents of the menu Reports in 1C Accounting 8.2.
How to work with reports in 1C Accounting 8 - general principles
Let's start with internal reports. Let's consider how to work with reports in 1C using the example of a report Account balance sheet (SALT according to the account).
The appearance of reports that are different in purpose, as well as the same reports, but in 1C Accounting 8 may differ slightly from each other, but general principles work with them does not change.
First of all, it should be said that all reports have settings. If you have not configured the report, then the button Generate a report it is useless to press, because the result will be unknown what... This, by the way, is one of the typical user mistakes when working with the program.
Report settings, if they are not already open, should be opened by clicking the button Customization in the upper right corner of the report window. The settings for different reports are different, but the meaning is always the same - tell 1C Accounting what you want to receive. Besides, the main report settings are specified right below the title bar of its window. These settings include, first of all, the period for which the report is generated.
The period is worth mentioning especially. Do not forget to correctly indicate the start and end dates of the report! Otherwise, you can get wrong data... In some cases, the period can be omitted (according to the situation), then these fields remain empty, which means from minus infinity to plus infinity, i.e. from the beginning of the database and until the data runs out.
In the given example, you also need to specify the analyzed account. Without this, the report will not be generated at all. Field Organization usually filled in automatically. If you have several organizations in one 1C Accounting database, then select the required company.
All other settings are located in the column to the right (in Accounting 8.2) or by the button Show settings in Accounting 8.3. For version 8.3, the settings window looks a little different, but the meaning is the same.
For example, let's generate a report for account 71 (settlements with accountants). The result was given above. This report includes all employees for whom, on account 71, records were found in the 1C database for the specified period. If only one employee is required, then you can apply a filter as shown in the figure below.
In this case, only the specified employee was included in the report. If you need to specify multiple values \u200b\u200b( but not all), then instead of equally should choose in the list.
Other reports are configured in the same way. For example, in the report Subconto analysis it is required to indicate the type of subconto and (optionally) its specific values \u200b\u200b(we have already encountered the concept of subconto earlier).
The settings of any report can be saved and loaded, for which there are two corresponding buttons on the toolbar (for 1C Accounting 8.2 - at the top right of the report window; underlined in green in the figure above).
An important feature of any report is the ability to move from this report to another, more detailed one. To do this, move the mouse over the data about which you want to get more information, and if the cursor is converted into a lens, then double-click. The ultimate level of detail in any report is the primary documents.
Feature of regulated reports
The main feature of regulated reports is that it makes sense to generate them only when you have corrected all errors made in accounting (if any). Otherwise, the report will be filled with incorrect data and it makes no sense to submit it somewhere.
It is also worth noting that the forms of all regulated reports open unfilled... To fill out the report, click the corresponding button. A sample for 1C Accounting 8.2 is shown below for an example of a balance sheet.
If you want to get additional information about any cell, then select it and press the button Decoding.
12.08.2014
Each person keeping records in the 1C product, after a certain time, needs to perform an analysis of economic activities. This program assumes analytics and statistics implemented through reports. All reports are divided into blocks in accordance with the logical belonging to the data that you want to receive. Based on the configuration, the sets of reports may change, however, the principle of working with the reporting tool in the 1C product remains the same.
In all configurations 1C reports Enterprise 8.2 is divided into categories and, accordingly, are included in:
Analytics of goods and materials (by balances, stocks, movement)
Sales analytics (by gross profit, sales)
Accounting and finance (for VAT liabilities, turnover money, budget)
Production and operational (for transfer, processing)
Before you start using the reporting documentation, you should collect a documentary history in the database. Otherwise, the program will not have the initial data for analysis. Depending on the amount of history and information in the program for the period, the accuracy and value of the analysis data is determined. The more data in history, the more accurate the forecast will be.
However, the information base and history are not a complete set of tools for further obtaining information. To generate reports in 1C 8.2, the user will need certain skills and abilities that will enable him to extract the necessary data and present it in a form that is convenient for viewing. The ease of information for perception determines the simplicity and convenience of its analysis. For this reason, the user should know what the basic reporting tools in the program are for and how they should be used.
A typical 1C report includes a field that provides the result of the report generation, as well as a settings field. The setting is divided into quick and detailed. Simple reports can be generated using quick setup, while complex multi-level filter reports require advanced setup.
When setting up almost all types of reports in the program, the user may need to use:
- main tab. It includes date, units of measure, metrics, properties and category parameters, grand totals, and additional fields;
- groupings. With this tool, the user can instantly view information in expanded and collapsed versions, transform information into an easy-to-view form;
- selections. Allows you to select data in a group from the proposed list. One should be extremely careful with selections, since one selection sometimes excludes the other. You can disable the selection you do not need by unchecking the use box;
- additional fields.Additional fields are required to display more detailed descriptive data about the analyzed object;
- sorting. You can sort the data in the report by each column displayed in the report. The most common sorting methods are alphabetical, name, ascending and descending;
- save settings. The developers of the 1C company took care of the users who had to work regularly with reporting. To save time on setting up a report, you can set parameters once, save them and call them up as needed.
In addition to the built-in standard report options, 1C allows you to use external reports that are not saved in the basic software configuration. These reports can be written by 1C specialists on a special order of companies, for which the built-in arsenal of reports is not enough for successful work and management analytics. The main advantage of external reports is the ability to change them without direct intervention into the program, in other words, this does not require changes and configuration updates. This flexibility allows companies to quickly respond to information analytics needs and use new reports without major changes to the program structure.
To start working with regulated reports, a desktop form is intended.
Program desktop form
When the program starts, the form of the program's desktop opens.
On the left side of the form, groups of reports are displayed, on top - the selected taxpayer and the period for which reporting is submitted, on the right - a list of available actions. The main part of the form displays a list of report forms for the current group.
The desktop form is designed to fill out new reports. Before starting to fill out the report, you need to do the following.
1. Select the taxpayer and the reporting period by clicking on the corresponding hyperlinks.
2. On the left, select the required report group.
3. In the list of reports, double-click the name of the required report.
As a result, a regulated report form, prepared for data entry, will open on top of the desktop form, where the details of the selected taxpayer and the specified reporting period will already be substituted.
Regulated report form
The regulated report form is intended for entering data into the report form. In this case, some data will be calculated automatically.
The table of contents of the regulated report is displayed on the left side of the form - a list of its sections.
Filling individual cells
The report form contains cells of different colors.
Cells with a white background are analogous to the elements of a paper report form, printed by a typographic method - accordingly, the data in these cells cannot be corrected by the user. Cells with a different background color are filled by the program or the user, but at the same time:
- cells with yellow backgrounddesigned to be filled manually;
- cells with green background are calculated automatically based on data entered in other cells, but they are not available for correction.
Selection of a value from the list
To quickly fill in the indicators, the program provides the user with a convenient mechanism for selecting a value from the list. By double-clicking on the indicator, you can open a list from which you must select the desired value.
Setting up a scheduled report
The user can configure the parameters of the regulated report and the parameters of its display.
If the number of lines in any part of the report is not specified in advance, then when drawing up the report, you can add additional lines in the form.
For some sections, it may be possible to add a set of pages as a whole - in cases where this does not contradict the regulatory documents.
Checking the report
"1C: Taxpayer 8" provides the ability to automatically check the completed regulated reports for interconnection of the report indicators specified in different sections of the report or for different periods, as well as with other regulated reports.
1C 8.3 reports is a special metadata object designed to form a user-friendly presentation of data from 1C database tables.
Let's figure it outhow to set up reports, what they are for, how external reports differ from built-in ones, and how reports differ from processing.
In order to create or customize a report, you need to know the built-in and. Whatever one may say, at the heart of almost any report is the initial request that receives data. We process and display this data in a user-friendly form.
Reports are the main thing in any information system, therefore, 1C company paid close attention to the development of reports and created a large number of designers and mechanisms for their creation.
Consider the basic reporting techniques
How to make a report in 1C using a layout
Creating with a layout is the most routine way. However, it is often resorted to out of despair, because in this way, the developer completely prescribes each action in code, which means that we can do whatever we want. Other mechanisms cannot boast of this.
But in this case, all the items, menus and other "bows" will have to be written manually, which is very time consuming.
Get 267 1C video tutorials for free:
Create a report using the output form designer
The output form constructor is a mechanism built into the platform that facilitates the development of a report. The constructor is only available for regular forms.
The designer is given the request and all the necessary parameters of the future report, and he, in turn, generates the modules and report forms. The mechanism is based on the object of the embedded language 1C 8.2 - Report Builder.
Generating a Report Using Generic Report
The universal report has great functionality, convenient settings interface, familiar to the user:
Reports based on the Data Composition System
This is the most progressive method of creating reports in 1C, recommended by 1C itself. appeared in the 1C platform in version 8.1.
ACS allows you to create simple reports without a line of programming at all, because it has a very flexible and functional designer for creating a data composition schema:
In all recent configurations, all reports are written using the data composition system.
How external reports differ from built-in ones
As it is written in the documentation - nothing. The external reporting engine was created in order to debug reports during development.
The only difference when developing a solution is that you cannot refer to an external report "by name", unlike an embedded report.
How the report differs from processing
In fact, practically nothing. The main difference is the purpose of using the object: reports are needed to display information, and to change information.
The main differences are in properties: in reports, you can specify the Basic Data Composition Scheme (ACS) and specify settings for saving report parameters.
Before starting a conversation about reporting in 1C, it is important to point out that reporting can be of three types:
- Regulated;
- Standard;
- Own.
Each of these types is formed on the basis of the primary documentation entered into the program and serves specific purposes.
Regulated reporting is a set of legally approved printed forms and electronic documents that each organization must periodically submit to the regulatory authorities.
Own reporting is developed by each organization separately and serves to display the results of the enterprise at various stages.
Standard reporting is a commonly used form of displaying business transactions.
Regulated reporting
All typical 1C configurations are intended not only for accounting and recording business transactions, but also for generating reports based on the entered data for transfer to:
- Tax Service;
- Federal Statistical Service;
- Various foundations and supervisory bodies.
Filling in regulated documents, as a rule, occurs at the end of the reporting period (quarter, year). Regulated reporting forms are created for each federal service separately, periodically changed and refined.
1C specialists carefully study all changes in legislative framework and based on these changes, the regulated reports are updated. Thus, if the user has a valid subscription to information technology support (ITS) and he systematically updates the configuration, he can be sure that reports for transmission to the regulatory authorities will be generated in accordance with all relevant requirements.
Important! Before generating and submitting reports, check that all business transactions entered and correctly executed in the program, as well as make sure that routine maintenance, such as closing the month, has been completed.
Creation and filling of a regulated report
One of the oldest and most important documents for reflecting the economic activities of the enterprise is the "Balance Sheet". The current form was developed in 2010 at the Ministry of Finance Russian Federation and approved by order No. 66 dated 02.06.2010. According to this order, starting from 2013, all organizations operating in the territory of the Russian Federation must annually submit it to tax authorities.
In order to open the required regulatory report, we must (in the "Accounting 8.3" program) go to the "Reports" subsystem and select the appropriate command in the "1C Reporting" menu (Fig. 1)
Please note that some objects of the program interface, and, accordingly, the ability to generate regulated documents may not be available if the user does not have access rights to certain subsystems.
In the opened form (Fig. 2) we will see:
- What reports are already registered in the database;
- For what period were they created;
- Report type (primary or corrective);
- The state in which the report is located (submitted, in progress, prepared).
Fig. 2
Using the appropriate buttons, we can:
- Create the report we need;
- Load it from a file saved on your computer;
- Check if the upload is formed correctly and if the checksums correspond to the algorithms included in the program;
- Print spreadsheet documentgenerated on the basis of the entered data;
- Create and send an upload file.
We can find the "Balance Sheet" we need by clicking on the "Create" button. The result of the click will be the form (Fig. 3) Fig. 3
If in the window that opens on the "Favorites" tab there is no item " Financial statements (since 2011) ”, we will have to go to the“ All ”tab and select this document.
Before starting to enter the basic data, the program will offer to fill in some fields (Fig. 4)
Fig. 4
If the configuration keeps records for several organizations, the "Organization" selection field will be available on the form, in addition, you must fill in the period, the information for which will participate in the formation of the balance sheet.
By clicking on the "Create" button, we will open the corresponding form (Fig.5).
Fig. 5
You should immediately pay attention to one circumstance: "Financial statements" is not only "Balance sheet", but also:
- Report on financial results enterprises;
- Statement of changes in equity;
- Cash flow;
- About the targeted use of funds, etc.
And all these reports can be generated by pressing one button "Fill" (Fig. 6) by selecting "All reports".
Fig. 6
To fill out a specific document, you must select "Current".
The completed "Balance Sheet" form is shown in Fig. 7
Fig. 7
You can add your own data to any field by clicking on the "Add row" command.
All numbers in the key fields can be deciphered by clicking on the corresponding button in the header.
The form for decoding accounts receivable is shown in Fig. 8.
Figure: 8.
Double-clicking on any decrypted amount opens the standard "Account balance sheet" report.
Standard reports
"Turnover balance sheet", "Subconto analysis", "Account card", "Chessboard" and many other forms that allow analyzing accounting data are usually called standard reports.
Consider the principle of their work on the basis of the "Balance sheet". The form in Figure 1 shows that standard and regulated reports can be called from the same subsystem.
Let's open the object we need (Fig. 9)
Fig. 9
Before generating a report, the user can set the period for which the data will be taken into account when filling out the form, as well as make its finer settings (by clicking on the "Show settings" button)
In Fig. 10, we see that the program provides such a detailed description of unloading that the settings had to be divided into several tabs.
Fig. 10
Let's take a closer look at this structure:
- Grouping - the checked box "By sub-accounts" shows that the form will contain data in the context of not only the main accounts, but also their subgroups;
- Selection - here the user can indicate for which organization, department or account he wants to see the data, and also determine the need to display information on off-balance accounts;
- Indicators - it is determined whether the figures for accounting or tax accounting;
- Expanded balance - for which accounts and sub-accounts you need to display expanded information;
- Additional fields - define the appearance of the form;
- Appearance - whether negative values \u200b\u200bshould be highlighted in red and auto-offset should be reduced.
As in the regulated report "Balance Sheet" in the turnover, you can call the form for decoding a particular value.
Own reports
Of course, the mechanisms of standard reports allow you to seriously analyze economic activity enterprises, but sometimes they are not enough. In this case, the user can (with minimal training) independently display the information of interest to him in one or another aspect. For this, the program provides several mechanisms:
- Universal report;
- Data composition schema (ACS).
In the second case, in addition to knowledge about the structure of information storage in 1C, the user may need access to the configurator, as well as some idea of \u200b\u200bthe 1C query language. But the reports received with the help of the ACS are distinguished by great flexibility in customizing their appearance and parameters.
A generic report is less versatile, but much easier to work with, it can be called from the same subsystem. Figure 11 shows the appearance of this object.
Fig. 11
What we see:
- Standard period selection;
- The type of object on which we want to display information (in this case, the accumulation register, but can take values \u200b\u200bas a directory, information register, document, accounting register);
- Specific name of the metadata object (“UST information on income”);
- The table we are referring to - in this case "Turnovers" (for accumulation registers it can also take on the values \u200b\u200b"Balances" and "Balances and Turnovers").
A more detailed description of what data, with what selections and sorting directions should be displayed in a spreadsheet document, can be specified in the report setup form.
- The Central Bank told about the new tariffs for the civil liability insurance What's new for the civil liability insurance from June 1
- What is sleep and who uses it What does sleep mean income
- Debit cards of "Sberbank of Russia": what does this concept mean, how to use, an overview of the offered by the bank
- Simplified taxation system What does it mean in accounting usn