Setting up regulated reporting. Installation of regulated reporting 1s accounting 7.7 regulated reporting

1C:Accounting 7.7, like all programs of the 1C:Enterprise system, has a single mechanism for building reports and working with them. | The typical configuration of 1C: Accounting includes a set of standard reports designed to obtain data on accounting results and accounting entries in a variety of sections.

  • Generation of standard reports. Turnover balance sheet.

    The balance sheet contains for each account information about the balances at the beginning and at the end of the period and the debit and credit turnover for the specified period. This report (colloquially - "turnover") is one of the most frequently used reports in accounting practice.

  • Summary postings

    The list of summary transactions is a report containing turnovers between accounts (amounts in the debit of one account from the credit of another) for the specified period. To display a list of summary transactions, select the "Summary transactions" item of the "Reports" menu of the main menu of the program.

  • checkerboard

    A chessboard is a report containing a tabular representation of the turnover between accounts for a certain selected period. The chessboard is often used by accountants, as it gives a visual representation of the organization's cash flow and liabilities.

  • Account balance sheet

    For accounts for which analytical accounting is maintained, you can get a breakdown of balances and turnovers for specific objects of analytical accounting (subconto). The corresponding report is called "Account Turnover and Balance Sheet".

  • Account turnovers (General ledger)

    The "Account turnover" report is used to display turnover and account balances for each month. It can be very useful in debriefing and reporting. | To get the account turnovers, select the "Account turnovers (General Ledger)" item of the "Reports" menu of the main menu.

  • Journal-order and account statement

    The "Journal-Order and Account Statement" report is essentially a report on the movement on the account (opening balance, turnovers with other accounts and closing balance), detailed by dates (periods) or by transactions (transactions).

  • Journal-order of the account by subconto

    The report "Journal-order of the account by subconto" is essentially a report on the movement on the account in the context of the subconto: opening balance, turnover with other accounts and ending balance. | To receive this report, you must select the "Journal-order of the account by subconto" item of the "Reports" menu of the main menu.

  • Account analysis

    The "Account Analysis" report contains the turnover of the account with other accounts for the selected period, as well as the balance at the beginning and at the end of the period. | To receive this report, select the "Account analysis" item of the "Reports" menu of the main menu. A request for account analysis parameters is displayed on the screen.

  • Account card

    The "Account card" report includes all transactions with this account or transactions on this account for specific values ​​​​of analytical accounting objects - the name of the material, the supplier organization, etc.

  • Account analysis by subconto

    The report "Analysis of the account by subconto" contains the total amounts of correspondence of this account with other accounts for the specified period, as well as account balances at the beginning and at the end of the period in the context of analytical accounting objects.

  • Invoice analysis by dates

    It is often necessary to obtain turnovers and account balances for each date of a certain period. This may be required, for example, to analyze the change in time of the organization's funds or liabilities, to check the compliance of the data entered into the information database specified in bank statements, etc. The necessary information can be obtained from the "Analysis of accounts by dates" report.

  • Subconto analysis

    For subconto types associated with several synthetic accounts, using the balance sheet for any one account, it is impossible to obtain complete information about the turnover and totals for the subconto. In such cases, you should use the "Analysis of subconto" report.

  • Subconto card

    If you need to get the most complete picture of operations on the object of analytical accounting (subconto) or a group of subconto, you can display the "Card of subconto". This report contains all operations with a specific object of analytical accounting (subconto) in chronological order, indicating the details of the transactions, balances on the subconto after each operation, at the beginning and end of the period.

  • Turnovers between subcounts

    To analyze turnovers between one or all subcontoses of one type and one or all subaccounts of another type, you can use the "Turnovers between subcontoses" report. This report allows you to find out, for example, how many goods of various types each buyer bought, or, conversely, for each product, find out the total volume of its purchases by each buyer.

  • Posting report

    The posting report is a selection from the posting log according to some specified criteria. | To generate a report, select the "Transaction Report" item of the "Reports" menu of the main menu of the program. A request for output parameters for this report is displayed on the screen.

  • Advanced subconto analysis

    This type of report is used only for accounts on which analytical accounting is maintained by subconto. In it, for each type of subconto, for which analytical accounting is maintained on the account, the debit and credit turnovers for the subconto, as well as the expanded and collapsed balances at the beginning and end of the selected period are given.

  • Diagram

    The "Diagram" report is a powerful tool for visual analysis of invoices in the form of various types of diagrams. | To obtain this report, select the "Diagram" sub-item of the "Additional" item of the "Reports" menu of the main menu. A request for report parameters is displayed on the screen.

    • Updating regulated reporting 1C 7.7 is a simple and accessible process for every user. At the moment, the 1C: Accounting for Ukraine 7.7 program allows you to submit almost all the necessary reporting to the tax office and not only. Many reports are filled in fully automatically or semi-automatically, some only manually. But all reporting is built on approximately the same principle, and therefore, it is enough to deal with several reports, and then everything becomes very simple.

    So let's see how we can do it updating of the regulated reporting 1C 7.7 on one's own. It all depends on the form in which you received the regulated reporting files. Firm "1C" delivers regulated reporting either in the form of an application Rp14q2.exe (where 14 is a year, 2 is a quarter), or in the form of an archive in which the above application is located. In addition, you can get regulated reporting from me in the form of an application that allows you to set up reporting in two clicks. Moreover, it is possible to install immediately in several information bases.

    Update of regulated reporting 1C 7.7 (3 ways):

    1. Manual (most difficult):

    In principle, the procedure for installing regulated reporting (RO) is described in an accessible language, in the documentation, on the ITS disk and in the file that comes with the RO. It contains complete and detailed instructions for self-installation. In this case, you need, having received the RO, just read this file Rp**Q*.TXT (** year, * quarter) again.

    Need to go to your database directory, open a folder in it extforms, create a folder there Rp14q2.grp and copy the file Rp14q2.exe into her. Then double click to run Rp14q2.exe.

    2. Automatic (simple):

    Need to run1C, go to menu Reports → Regulated reports ( built-in) , press the button «Z load ". In the window that opens, selectthe file you receivedR R 1

    3. Automatic from the file I provide (the simplest):

    You just need to run the file, and select one or more infobases in which you want to set up reporting with the birds, and click the button Copy to inf. base. This is all.

    Automatic update of regulated reporting 1C 7.7

    note :

      The version of your configuration must match the selected R O. ( Configuration information can be obtained by selecting "About" from the "Help" menu.)

    If necessary, you can get reporting by contacting me. My contacts are at the top right. Also, if you have any difficulties in installing regulated reporting or questions about work, setting up 1C, feel free.

    It is impossible to make managerial decisions without knowing the internal business processes taking place in the organization, the main information about which is contained in the accounting registers. E.V. tells how specially configured reports of the Accounting configuration (rev. 4.5) for 1C:Enterprise 7.7 help in the analysis of such information. Baryshnikova, head of the training center "Domino Soft".

    Accounting in an organization is aimed at generating information about the financial position, financial results of economic activity, necessary for internal and external users of financial statements, at preventing negative results and identifying intra-economic reserves of the organization.

    For information processing and for obtaining data on accounting results in various sections, the 1C: Accounting 7.7 program provides a single mechanism for building reports and working with them.

    A set of standard reports included in the configuration can be used to obtain summary and detailed information on any sections of accounting.

    In everyday work, the accountant is faced with the task of analyzing the state of various accounting objects. One of the central issues of enterprise management is the issues of accounting for production costs, since it is information about costs that underlies a very large range of decisions.

    Production accounting is divided into:

    • Cost accounting by type;
    • Accounting for costs at the places of their occurrence;
    • Accounting for media costs.

    Cost accounting by types shows what types of costs arose at the enterprise in the process of production (performance of work, provision of services) in the reporting period. Cost center accounting allows you to distribute them among the individual departments in which they were incurred. Cost accounting by media involves the determination of all costs associated with the production of a unit of any specific product (work performed, service).

    In accordance with the Chart of Accounts for accounting of the financial and economic activities of the organization and the Instructions for its application (approved by order of the Ministry of Finance of Russia dated October 31, 2000 No. 94n), account 20 "Main production" is intended to account for production costs. Analytical accounting on account 20 "Main production" is carried out by types of costs and types of products (works, services), as well as by divisions of the organization.

    Using reports of a typical configuration, we will try to obtain information for the analysis of production costs. To do this, let's turn to the configuration chart of accounts and see how the chart of accounts is configured for account 20. Account 20 "Main production" provides for analytical accounting for 3 types of subconto (3 analytical sections):

    • "Types of nomenclature",
    • "Cost Items"
    • "Subdivisions".

    Such an accounting procedure on account 20 "Main production" fully complies with the requirements of the Chart of Accounts and allows the user to receive information both on all 3 analytical sections, and on each separately.

    Suppose an accountant is faced with the task of analyzing manufacturing costs by media. The cost carrier is understood as various types of products (works, services) produced by the enterprise and intended for sale. For this purpose, you can use the report "Turnover and balance sheet for the account" (Fig. 1). In the report settings, in the "Type of subconto1" field, an analytical section is selected - "Types of nomenclature", the option for generating the report is set to "Expand", for the remaining analytical sections the option is set - "Ignore".

    This report, grouped by types of items, allows the accountant to obtain information on the volume of spent resources of the enterprise in the context of cost carriers (calculation objects). In the analyzed period, the largest amount of costs falls on the type of product "Finished products (coats)" - 62,626.19 rubles, and the least expensive is "Small repair of clothes after dry cleaning and dyeing" - 333.33 rubles.

    For a more detailed analysis of turnovers, you can use the report "Journal-order of accounts by subconto", which, in addition to information on turnovers by product types, allows you to additionally see information on turnovers with corresponding accounts (Fig. 2).


    The report shows that the maximum share of costs for the analyzed period, 26,265.49 rubles, attributed to "Finished products (coats)" falls on general business expenses (debited from account 26 "General business expenses").

    Let's use the same reports to analyze production costs by their types. In the "Account balance sheet" report setting, in the "Type of subconto1" and "Type of subconto3" report, you must select the option for generating the report - "Do not take into account", and for "Type of subconto2" - "Expand" (Fig. 3).


    In the resulting version of the report, each line of the balance sheet contains the name of the analytical accounting object (subconto), in this case, the cost item, the balance at the beginning of the period, debit and credit turnover and the balance at the end of the period for each item. This report, grouped by types of costs, allows us to conclude that the largest volume in the composition of production (excluding types of products) is occupied by:

    • general business expenses - 81,856.10 rubles,
    • material costs - 40,183.33 rubles.

    Which report can we use to get a detailed breakdown of material costs?

    For this purpose, you can use the report "Analysis of account by subconto". The report contains the total amounts of correspondence of this account with other accounts for the specified period, as well as account balances at the beginning and end of the period in the context of analytical accounting objects. This report can be generated only for accounts for which analytical accounting is maintained.

    From the report (see Fig. 4) it can be seen that the material costs of the main production include the cost of materials written off for production and semi-finished products of own production:

    • RUB 27,850 written off from the credit of account 10 "Materials";
    • 12 000 rub. written off from the credit of account 21 "Semi-finished products of own production".

    Additionally, the material costs included the amount of expenses incurred through an accountable person (333.33 rubles) (Fig. 4).


    Accounting for production costs at the places of their occurrence provides control and management of production resources in the context of the structural divisions of the enterprise. The report setting "Turnover and balance sheet for the account" is filled in as follows: for the "Type of subconto1" and "Type of subconto2" we select the option for generating the report - "Ignore", and for "Type of subconto3" - "Expand" (Fig. 5).


    Analyzing the distribution of costs by departments, it can be seen that the largest amount of costs falls on the "Sewing Shop" division - 100,742.90 rubles.

    With the help of standard configuration reports, we examined the state of account 20 separately for each of the analytical sections. If we want to get information, taking into account all 3 analytical sections, then in the report settings for each type of subconto, it is necessary to set the "Expand" report generation option. Such a report is more difficult to understand, but gives the most complete picture of the state of production.

    One of the features of working with reports in the configuration is the ability to change the order in which analytical sections (types of subconto) are displayed in the report. For example, when preparing the report "Analysis of an account by subconto", you can use the standard order of analytical sections: "Nomenclature types" - "Cost items" - "Departments", but when generating a report, we have the opportunity to change this order. In the report settings, in the "Type of subconto1" field, specify the analytical section "Cost items", in the "Type of subconto2" field select "Nomenclature types", and in the "Type of subconto3" field - "Subdivisions". In this option, cost items will be displayed on the first level in the report, types of items on the second level, and subdivisions on the third. Changing the order of analytical sections is possible in any report that provides for obtaining information on analytics - "Account journal-order by subconto", "Account analysis by subconto", "Analysis of subconto", "Subconto card".

    Thus, by changing the order of 3 analytical sections, we have the opportunity to get several options for generating a report:

    • "Types of nomenclature" in the context of "Cost items" and "Subdivisions";
    • "Types of nomenclature" in the context of "Subdivisions" and "Cost Items";
    • "Cost items" in the context of "Nomenclature types" and "Subdivisions";
    • "Cost items" in the context of "Subdivisions" and "Types of items";
    • "Subdivisions" in the context of "Cost items" and "Types of items";
    • "Subdivisions" in the context of "Nomenclature types" and "Cost items".

    In terms of analysis and detailing, the report "Turnovers between subcontos" has ample opportunities. This report allows you to analyze turnovers between one or all subcontos (analytical sections or objects) of one type, and one or all subcontos (analytical sections or objects) of another type. For example, using this report, we can see how many and what materials were included in the material costs for the selected period. To do this, in the report settings, in the "Type of subconto" (main) field, select - "Production costs", in the "Subconto" field, select - "Material costs"; then in the field "Type of subconto" (corresponding) set - "Materials" (Fig. 6).


    To present accounting totals data in a graphical form, you can use the "Diagram" report (Main menu Reports - Additional - Diagram). The "Diagram" report is a visual analysis tool and can be used by the head of the organization, managers and other professionals who are not directly related to accounting services.

    Let's analyze the turnover by cost items using this report. To do this, on the "Data" tab, specify the period, select account 20, select the type of totals on which the report will be built. The chart can be built on initial balances, turnovers or ending balances. In this case, only debit totals, only credit totals, or the difference between debit and credit totals can be taken. To generate our report, set the switches to the position - turnover, debit, amount. On the "Diagram" tab, the parameters describing the construction of the diagram are set. In the upper part, one of the possible types of chart outline is selected (pie, histogram, etc.). Figure 7 shows a variant of constructing a pie chart.


    As can be seen from the diagram, the largest volume in the composition of production is occupied by general business expenses and material costs.

    What conclusion can be drawn from the information we have received?

    Analyzing the production costs of our abstract enterprise, we can say:

    • production is material-intensive - the share of material costs is high (26%);
    • a very large volume in the composition of production is occupied by general business expenses (53%).

    To reduce the material consumption of production, a more rational use of materials is necessary.

    General business expenses are carried out for the purpose of managing the organization, are not directly related to production and remain, as a rule, unchanged. Reducing the share of general business costs is possible by increasing the volume of sales of the company's products.

    Thus, the use of the reporting mechanism, their application in everyday practice, enables the accountant to analyze the final data, obtain information in various sections, the manager to receive information that can later be the basis for making decisions that increase the efficiency of the enterprise.

    As a rule, the installation of reporting forms takes no more than 5 minutes. However, certain difficulties may arise. At the beginning, the process of installing reporting forms will be described, then typical problems that may arise during installation will be analyzed. More detailed information can be found in the documentation for the 1C configuration: Accounting 7.7, as well as in the RP??Q!.txt file (where! denotes the quarter to be installed, and ?? - the year, for example, for the 2nd quarter of 2007 the file will be called PR07Q2 .txt), the file is located in the directory with reporting forms.

    Installation of reporting forms for 1C version 7.7

    Copying reporting forms from the ITS disk

    1. Run disk number 1 "We work with programs."
    If the disk does not start, you need to find the disk through Explorer (usually it is D:) Then open the disk and run the Autorun.exe file in the root directory
    2. Press the "View CD" button in the launched program.

    4. Next, the window "1C. Reporting forms, releases of programs and configurations" opens. Select "1C: Enterprise 7.7" in the menu. Next, you need to select the menu "Reporting forms for the Y quarter of 20XX", where Y is the number of the quarter, and 20XX is the year of the required reporting form. If the required item is missing, then this disk does not contain the necessary reporting forms, you should.

    5. Items appear to the right of the menu:
    a) "Form of reporting for the 2nd quarter of 2007"
    b) "Reporting forms for the 2nd quarter of 2007 for the configuration of the simplified taxation system"
    c) "Reporting forms for the 2nd quarter of 2007 for the Entrepreneur Accounting and Reporting configuration".
    You should carefully choose one of the three items. Reporting forms b) of the paragraph are suitable for the configuration "1C: Accounting Simplified Taxation System", forms c) of the paragraph are suitable for the configuration "1C: Accounting and reporting of an entrepreneur", and forms a) of the paragraph are suitable for all other configurations (1C: Accounting, 1C : Complex configuration, etc.).

    6. After selecting the required reporting forms, information about the current changes in the reporting release as well as the added forms is displayed. Scroll to the bottom of the page and select the "Copy" link.

    7. The window that opens allows you to copy reporting forms directly to the catalogs of connected 1C infobases. However, this method is inconvenient: the installation files end up in the ExtForms directory of the working base, and after installing the reporting forms, it is problematic to remove these files due to their large number. It is recommended to click on the "Copy to directory" button.

    8. In the selected dialog, you must select a temporary directory, for example, c:\temp, if the directory does not exist, the program will create it automatically and copy the installation files there.

    Copying reporting forms from a directory with files (or a zip archive)

    Updated forms can be obtained not only using the ITS disk, but also using the resulting catalog with regl form files. reporting, or an archive in zip format or some other format. For installation, you need to unpack such an archive file into a specific folder. Only after that, continue installing the regulated reporting forms following the instructions in the "Installing regulated reporting" chapter.

    Installation of regulated reporting forms

    1. Open the infobase in 1C: Enterprise mode.
    2. Open regulated reports from the menu "Reports"->"Regulated"

    3. Click the "Download" button

    4. In the dialog that opens, specify any of the catalog files with files of regulated reporting forms with the .exe extension, and then click the "open" button.

    5. In the window that opens, click the "OK" button. If you do not need to copy some report forms, you must uncheck them.

    Updating regulated reporting forms when connected to the Internet and having an ITS disk

    Often there is a need to obtain more recent reporting forms for a quarter in which the forms have already been installed. In order to update reporting forms via the internet, you must do the following:
    1. Insert ITS disk No. 1 "We work with programs"
    2. Select the dialog of forms of regulated reports through the menu "Reports"-> "Regulated"
    3. Connect to the Internet and update the reporting forms automatically using the "Update" button.

    Manual setting of reporting forms

    Sometimes, for some reason, it is not possible to automatically install reporting forms. In this case, you can set up reporting as follows:
    1. In the directory where the installation files from the ITS are copied or unpacked from the archive file, you must run all files with the exe extension in sequence. As a result, new files will appear in the directory. If the unpacking program stops and asks for confirmation, with a question about replacing files, you must press the "A" button (on the English keyboard layout)
    2. You need to find the directory of the working base of the program. You can find the directory of the working base by looking at the start of the working configuration at the bottom of the launch window let the location of the data.
    3. In the directory of the working base, you need to find the directory "ExtForms". If the directory does not exist, it must be created.
    4. In the ExtForms directory, you need to create a directory of the form RP**Q?.GRP, where the symbols ** denote the year and symbol? - quarter. For example, RP07Q2.GRP is Q2 2007 and PR08Q1.GRP is Q1 2008.

    5. In the created directory of the RP**Q?.GRP type, you need to copy the files unpacked in the installation directory of the regulated reporting forms.


    Incorrect display of barcodes in reporting forms

    If the reporting barcodes are not displayed correctly, you most likely do not have the EanGnivc font installed. To install, do the following:
    1. The font EANG000.ttf must be copied from the directory where the regulated reporting forms are installed.
    2. You need to open the operating system control panel, then you need to find the "Fonts" icon. (for example, this can be done as follows: Start -> Settings -> Control Panel).
    3. Find EanGnivc in the list of fonts. If the font is found, it must be deleted (for example, by clicking the Delete button)
    4. Next, select "File" -> "Install Font" from the menu.
    5. In the dialog that opens, specify the directory where regulated reporting is installed. In the list of found fonts, select EANG000.ttf (if everything is done correctly, there will be only one file in the list of fonts to select)
    6. After the font is found, it is necessary to mark it in the list of fonts, and then click the "OK" button.
    7. Font installation is complete. The barcode on the reporting forms must be displayed correctly.

    Errors are generated when starting and generating reporting forms

    Errors, as a rule, are associated with incorrect entries in files saved using regulated reporting forms (when saving the setting). In order to avoid errors, you must:
    1. Find the working base directory.
    2. In the directory of the working base, find the ExtForms folder
    3. In the ExtForms folder, you need to find directories like 12345678.90 , the numbers can be in any order.
    4. It is necessary to delete the found directories of the format 12345678.90, and then try to run the regulated reporting forms again.

    Sometimes errors occur due to the use of an old release of the program. To generate reporting forms, at the moment, a 1C program release of at least 25 is required. You can view the release of your program by clicking "Service" -> "About the program ..." in the menu. In the window that opens, the program release number is visible in the upper right corner.

    Errors in the formation of regulated reporting may occur if the reporting forms are not set for your configuration. To determine if the reporting is suitable for your configuration, you must click on the "i" button in the regulated reports form, located to the right of the list of regulated reports. If your reporting forms do not suit you, you need to reinstall the regulated reporting forms.

    Occurs in two stages - updating the platform and configuration. In addition, configurations often add additional steps to update regulated reporting. Consider step by step instructions.

    To update the 1C 7 Platform, just run the installation file and install the program with the new version in the same directory as the old one. The installer will replace the old files with new ones.

    You can install in different directories. In this case, the computer will have two instances of the Platform with different versions:

    Please note that when installing an update, you can change the initial settings, such as the name of the organization that owns the program or the set of installed components:

    Configuration update 1C 7

    Configuration is a 1C 7.7 application solution, for example, 1C Accounting 7.7, Salary and Personnel, etc.

    To update the 1C configuration, you first need to prepare the update distribution kit. The fact is that in most cases the update is delivered in a universal form: for the basic version and for the professional version. More precisely, the distribution kit is supplied specifically for the basic version, and if you have a professional version, you need to prepare it.

    Create a separate folder, for example, "Preparing for update" and copy all the files from the update distribution package there:

    Now let's run the 1C program and create another infobase. Let's call it "Preparing for the update" and specify the path to our new folder:

    Run the program in Configurator mode. Before any actions with the configuration, you need to open it (menu "Configuration" - "Open configuration" or the corresponding icon).

    If you have a professional version, this warning will open:

    We press "OK". This will open the configuration tree. Click "Save":

    Now let's open the Configurator of the database we are going to update:

    Get 267 1C video lessons for free:

    For example, I chose Configuration 1C “Accounting and reporting of an entrepreneur, ed. 1.2":

    As you can see from the figure, the current release of the program is 7.70.260. Now we will update it to release 7.70.265. Let me remind you that we have already prepared it and it lies in the “Preparing for the update” folder.

    Be sure to make a backup copy of the information database first. To do this, go to the menu "Administration" - "Saving data":

    Select the save path and file name here. Click "Save".

    After saving, we will start updating. In our case, the update must be done in merge mode. Go to the menu "Configuration" - "Combining configurations ...". Select the file "1cv7.md" from the "Preparing for update" directory:

    The program will compare the current configuration and the updated one. The result will be displayed in a separate window. In this window, you can see what changes have been made in the new release, and if you wish, you can refuse some.

    Set the "Configuration Priority" section to "Loadable Configuration", and in the "Merge Method" section - "Replace Objects":

    We press "OK".

    After merging, we save the resulting configuration. The database will be restructured according to the update. Click "Accept":

    This completes the update from the Configurator side.

    Now let's run the program in Enterprise mode and confirm the legality of the received update. After that, if necessary, the system will make updates already at the level of credentials, and at this point the update can be considered complete:

    Update of regulated reporting in 1C 7.7

    Unlike version 1C 8, in version 7.7, regulated reporting is delivered separately.

    To download it, you need to go to the "Reports" menu - "" (the path may differ in different configurations):

    As you can see, I have not downloaded any package of regulated reports at the moment. Now we will fix it.

    Initially, the reporting is in a packaged form. The file should look something like this: 16q2001_PBOUL.zip, where 16 is the year, q2 is the second quarter, 001 is the distribution version, PBOUL is the name of the configuration.

    You need to unpack this archive into a folder convenient for you.