Link service. Uploading reports in electronic form How to download reports from 1s 7.7

For example, let's create Turnover balance sheet (Reports - Standard - Balance Sheet).

Specify the folder where to save the document, set the file name and select File type — Excel sheet (*.xls) or Sheet Excel2007-…(*.xlsx)- These are different versions of Excel. You can save in both formats and see which one suits you best. Also, when saving, other file formats are available. Press the button Save .

In our example, we selected the folder Documents from 1C and set the file name - SALT for 9 months. For example, we save in different Excel formats.

After saving, the documents will be located in the specified folder.

Both files will open, because Earlier versions of documents are supported by later versions of programs.

How to save a document in Excel in 1C

Let's look at saving using a document as an example Payment order . Let's create its printed form and among the buttons on the toolbar we see a button with a floppy disk.

When clicked, a window for saving the document opens, where we specify the folder where to save it and select the desired format. In our case it is - Microsoft Excel Sheet. Check the box and press the button Ready. The document is saved in a folder.

Uploading tables from 1C to Excel

Sometimes it becomes necessary to generate a list from the data in the tabular parts of document journals, directories, etc. In this case, you can set the selection of the necessary elements (date, name of the counterparty). Let's look at an example.

We want to display a list Payment orders for the payment of taxes and contributions for the period.

To select documents, you can select them by holding down the button Ctrl or Shift, and also used to select groups of lines. Then press the button More and select a team List .

In the window that opens, we configure which columns we need to display and select - display in spreadsheet document . If we have selected a group of lines in the list, then check the box - display Selected only . Click OK and the list is ready.

It looks like this.

The resulting report can be saved in any format, including Excel - *.xls. To do this (as described above), select the command Save(or Save as ) on the menu File and set the parameters.

These actions can be performed with any lists of the 1C program.

When working with large lists, for example, a directory Nomenclature , you can install additional selection and grouping, set the order of sorting the data.

Therefore, before creating any list, you should pay attention to the command List setup in the button More .

How to save table cell data from 1C in Excel

Sometimes we need to copy part of the data from a report or document. This can be done by regular copying. To do this, select some of the required cells and right-click and select the command Copy(or Ctrl+C).

Going to the program Excel using the command Insert, add the copied fragment to the table. This method works with all data in 1C, both in generated tables and with form cells - in directories, magazines, documents.

Did the article help?

Get another secret bonus and full access to the BukhExpert8 help system for 14 days free of charge

The system allows you to upload reports from 1C conveniently and quickly. To do this, it is proposed to install special add-ons in the 1C program in which reporting is generated.

Please note that the transfer of reporting from 1C to SBS++ is implemented only for version 7.7. Transferring reports from 1C programs version 8.0 is not yet possible. Check the version of the 1C program you have installed.

As a result, in 1C, in the reporting data upload window, a setting will appear for uploading data to " SBS++Electronic reporting":

Rice. 14-11 – Setting up uploading 1C reporting data

The necessary add-ons are installed automatically during system installation." SBS++Electronic reporting" (details in chapter " Installation and launch"). If necessary, add-ons can be installed in 1C at any time, you just need to use the special command " Add-ons for 1C" ("Main menu/Service") and indicate the databases for which you want to install add-ons:

Rice. 14-12 – Installing add-ons for 1C

The location of 1C information bases installed on your computer or server is determined automatically.

After installing new forms of regulated reporting in 1C or updating them, you need to reinstall add-ons for 1C.

Generating reports in 1C

In the 1C program, electronic reporting is generated in the following configurations: " 1c accounting", "1C: Taxpayer", "Complex configuration". In all configurations, the principles for generating electronic reporting are the same.

To generate a report:

1. Open the 1C program and go to “Main menu/Reports/ Regulated". A window opens" Regulated reports" with a list of reports that can be submitted electronically:

Rice. 14-13 – List of regulated reporting

2. In the list of reports, open the corresponding folder and then select and open (<Enter>) the report you want to create.

3. After this, a window opens with a list of sections that the form of this report contains.

Rice. 14-14 – List of tax reporting

Open each section sequentially and enter the data. A form window with fields for data entry appears as soon as you open the section. Once the form is completed, save the information.

In the same way, generate all the reports that you submit in a given tax period in electronic form. After all the reports have been generated, proceed to their uploading to SbiS++.

Transfer of reporting to SBS++

After the necessary reports have been generated in 1C, you can proceed to transfer them to " SBS++ Electronic reporting".

In the 1C program in the window " Uploading reporting data"(Fig. 14-11):

1. Select the forms that you want to transfer to SBiS++.

2. Select the period for which forms are downloaded.

3. Check the " to the program "SbiS++ Electronic reporting".

4. Using the " button Review"Indicate the location of the directory with the SBiS++ program.

5. Returning to the data upload window, click " Download reporting data".

6. Reports are uploaded to electronic reporting files. The process report is displayed in the message window in 1C.

Rice. 14-15 – Report on uploading reports to files

As soon as the uploading of reports is completed, SBIS++ is launched and loading of reports into SBS++ begins.

In this case the following messages may appear:

Message

In the programs "1C: Accounting 8" and "1C: Accounting KORP" edition 3.0, starting from version 3.0.48, the ability to download a regulated report from an electronic submission file has been implemented. 1C experts told BUKH.1C how to use this opportunity.

You can create or open a regulated report from an electronic submission file as follows:

• by transferring data from regulated reports between 1C:Enterprise platform configurations;
• by loading data from files generated by other accounting programs or services, including transferring an archive of sent reports from programs and/or services of specialized telecom operators.

Report loading mechanism

The mechanism is intended for organizations with a branch structure and separate divisions that use various application solutions on the 1C:Enterprise platform: programs of versions 7.7 and regulated reports of programs of versions 8.X, containing the “Regulated Reporting” subsystem.

The mechanism allows you to load data from XML files of electronic submissions into regulated reports for the Federal Tax Service, Social Insurance Fund, Rosstat and other regulatory authorities.

For example, if a report is generated in another 1C program or in a third-party program, a file is generated when the report is uploaded. This file is the basis for the report loading mechanism.

Capabilities of the report loading mechanism

• loading data into an existing regulated report;
• creating a new report from the upload file;
• in the downloaded report, the change in the reporting period is within acceptable limits (not earlier than 2015);
• in the downloaded report, select another organization;
• editing the downloaded file;
• sending a report via 1C-Reporting.

How to download a report

1. Creating a new report from the upload file in the Report Log

In the Report Log when you click on the button Download select Report form.

Then in the window that appears, find the folder with the saved file and open it.

The report file window will open. The program will automatically detect Report type, Report period, Document type and Organization.

In the window you can select:

• another organization (or add a new one);
• another period or set a period in the report for which the report period has not been loaded (missing in the upload file);
• type of document (primary\corrective).

To open the report screen form, click the button Load and close.

What to pay attention to

1. There is no way to decrypt the data.

Cause: Data obtained directly from the accounting program must be decrypted.

There is no solution due to the lack of initial accounting data.

Cause: indicators are loaded in their original form, without distortion through automatic calculation.

Solution: Open Report Settings and uncheck the box Disable automatic calculation of calculated cells.

The downloaded report can, if necessary, be adjusted, checked, downloaded and sent to the regulatory authority via 1C-Reporting.

2. Loading data into an existing regulated report

If you need to load data into an open report, use the button Download on the top panel of the open report.

Important!

1. If you try to download a file that does not correspond to the type of open report or its reporting period, a message will be displayed stating that downloading is impossible.
2. It is not possible to load data from a file with an electronic presentation format different from that approved for this report form.
3. If data is loaded into an existing report and the process fails due to an inappropriate format, the previous completion of the report is not changed.
4. When you load a file into an open report, the data in the existing report is cleared and the data from the upload file is loaded.

The remaining actions are similar to those specified in paragraph “ Creating a new report from the upload file in the Report Log."

For such a complex report consisting of several download files, such as a VAT Declaration, it is necessary to download all electronic submission files.

In the upload window, use the button to add files Add.

Each downloaded file can be opened.

After pressing the button Load and close in the VAT return, sections from all downloaded electronic submission files are filled in and the procedure for checking counterparties by the Federal Tax Service service is launched.

Quite often, users need to save data from 1C 8.3 to a file, for example, pdf, Word, Excel and other formats. For example, send a report by email to another person, make calculations in Excel. Unfortunately, not all users know that it is very easy to download such data from 1C on their own without outside help.

It is often necessary to download a list of some data from the tabular part of a document, list form, document log, etc. Such tasks are often isolated, and it is inappropriate to involve a specialist to write a report.

For example, you need to get the entire item with the “Materials” view, but you only need the columns “Item” and “Unit”.

In the case when you need to upload data with filtering, first of all, you need to configure the list in the “More” menu of the tabular section.

In the window that appears, from the left side (available fields), you need to select those by which you will make a selection (in this case, “Type of item”). In the right part of the window, the values ​​of the selection parameters are set. Moreover, the type of comparison is not limited to equality alone.

After the stock has been set, in the list form of the “Nomenclature” directory, only those items that meet the specified condition will be displayed.

The next step is to output this list into a spreadsheet document.

From the More menu, select List.

If you need to display not all columns, as in our example, then check the boxes only for those that are necessary.

As a result, you essentially get a report that we can save in any available format. How to do this will be discussed below. In a similar way, you can download tabular parts of documents and reference books, data from document journals, list forms, and more.

Uploading reports and printed forms from 1C

Any report, printed form, spreadsheet document (for example, which we received in our example) in 1C 8.3 can be uploaded to an external file in two clicks.

On the top panel of the program there is a button to save to an external file (Taxi interface). It will be active on any reports and printed forms where saving is available.

Uploading the entire 1C database

This method is necessary in cases where the 1C database needs to be unloaded as a whole, for example, to create a test copy.

Go to the desired information base in configurator mode.

In the “Administration” menu, select “Download infobase”.

Specify a different file name and save path if necessary.

The resulting downloaded data file with the *.dt extension is very easy to download in the future. To do this, in the configurator mode, in the “Administration” menu, select “Load infobase” and open the *.dt file received earlier.

It was a small discovery for me that 1C users do not know how to quickly upload almost any data from 1C to Excel. Recently I came across what my colleagues did, and then using FineReader they translated the data into text from a picture, because the save button in 1C did not work (see picture). Long way, isn't it? But there are more convenient ways. There is no secret in unloading from 1C; there are quite a lot of possibilities.

Let's look point by point at how we can save data from 1C to Excel:

The easiest way to save data from 1C to Excel is to select one cell in a document or journal and click (copy), then in Excel select the cell where you want to save the data and click v. This way you will save the contents of that cell. For the example picture it will be 42,289.23

This method works for any version of 1C.

2. How to download a large amount of data from 1C to Excel?

The previous method is good, but you can’t accumulate a large amount of data this way. Therefore, it is better to use the List tool.

In almost any document journal, reference book, or document, right-click and look for List.

For versions 8.3 and the “Taxi” interface, the button to display the list is in the More menu

A list of these elements will appear as text (you may need to select which columns to select first). This text can already be copied into any document. But I advise you to use the File - Save As menu (since large amounts of data will take a long time to process and an error may occur when copying to the buffer).

Then select the desired file format.

All files are saved in the required format.

This method also works for any version of 1C.

For version 1c 8.2 and higher in the thin client or Taxi interface, the File - Save As tool is available in the panel in the upper right corner in the form of a floppy disk

3. How to download printed forms of documents from 1C to Excel?

Printed forms of documents such as

1 - Uncheck the View Only button to be able to change the printable

2 - Save the document in the desired format, see point 2

You can also save the contents of the printed form as any text data, just like in Word.

Often a printable or report form can be saved with a simple Copy-Paste into Excel.

How to load data from Excel into 1C is a completely different story. But I’ll tell you that soon, just wait ;)

Share our article on your social networks: