In the window that opens we find the processing file
Configuration: 1c accounting
Configuration version: 3.0.44.177
Publication date: 20.01.2017
The 1C: Accounting program now offers the ability to routinely upload and download data from Excel spreadsheet documents, without the use of third-party processing or configuration changes. Loading and unloading is so easy that experienced users will quickly fall in love with this convenient mechanism, and new users will quickly master it.
Download from Excel 1C: Accounting 8.3 ed. 3.0
For example, we have this Excel spreadsheet document for loading a list of items and prices (retail and purchasing).
Come to .
At the top click Nomenclature and Prices - Download. This is where loading and unloading from spreadsheet documents is hidden.
The download supports xls (old Excel 97-2003 format) and xlsx (new format), as well as mxl and ods formats. Now we select our file with the nomenclature and wait for it to load.
The spreadsheet document has been loaded in the form we saw it in Excel, now we’ll assign columns and delete the unnecessary ones.
Click on Please provide details and select the desired item from the list.
Select the row that contains unnecessary entries, namely the table header, and click Delete line.
Now we delete the column with the purchase price, note that processing can fill out only 1 type of price at a time!!! Then you can do this operation again and load the 2nd type of price, for the 1st load Retail for the 2nd purchase.
Fill in the blank data, Price type, Set prices for. The buttons All, Found, New, Duplicates will greatly facilitate the search and help compare items. Fill in and click Download after which the data will be loaded into 1C: Accounting.
New items have appeared in the product list, filled and with assigned prices. If you need to load another type of price, do all the steps again, but select a column with a different price, 1C itself will find already created positions and will not try to duplicate them, but will simply add a new type of price.
As you can see, the download created 2 documents for setting item prices, for the Purchase Price and for the Retail Price. The difference between this treatment is Loading from Excel to 1C: Accounting 8.3, The fact is that this is standard processing and it works without failures and takes into account all the features of filling out the document.
Uploading to Excel from 1C: Accounting 8.3 ed. 3.0
A very useful function in edition 3.0.44.177 and higher is uploading to Excel from 1C: Accounting 8.3; this processing will help you create a company price list or transfer your list of items to suppliers or buyers immediately with prices.
It's all there in the directory Nomenclature - Nomenclature and Prices - Unload.
In point Columns, select the columns that need to be built in the Excel document. Selection serves to select items by Groups, properties, names... etc.
To upload to Excel, we will add a new column, namely the VAT rate, it doesn’t seem to be very necessary, but we are practicing.
Despite the fact that issuing invoices for payment of any goods or services to the buyer is not mandatory, in practice it is quite common. Invoices indicate the details of the supplier, as well as a list of goods and services for which an advance payment must be made.
Paying bills is very convenient. We all receive monthly receipts for rent, electricity, gas, water. In essence, they are also analogues of accounts.
Of course, the invoice for payment is not the primary document, but it is with it that the reflection of sales of goods and services, as well as settlements with customers, begins. We will tell you how to issue an invoice for payment in 1C 8.3 and print it in this article.
You can find invoices for payment in the “Sales” section.
Create a new document and fill in its header. We will indicate August 31, 2017 in the “Paid by” field. If the buyer does not pay within the specified time, the invoice will become invalid. There can be many reasons, for example, price changes.
Our invoice status will initially be “Unpaid”. Once we receive any action from the buyer, the status will change.
We will select as a counterparty and indicate that we are working with him under an agreement with the buyer “”. You don’t have to specify the contract; in this case, to the right of this field, click on the “New” button. In this case, the program will create a new agreement with the buyer based on the created invoice.
Don't forget to indicate the bank account to which payment should be received. If you provide any discounts to the buyer, select the appropriate item from the drop-down list of the same name and indicate its size.
In the tabular section on the “Products and Services” tab, we will indicate that we sell 20 units of “Assorted” candies, 30 “Squirrel” and 25 “Cherry”. We will definitely check the correctness of the automatically entered prices. They can be edited manually.
If you supply goods in returnable containers, for example, beer in kegs, information about it can also be indicated on the corresponding tab.
If this payment invoice is periodic, for example, you have a contract with the buyer for monthly delivery, click on the “Repeat” hyperlink at the top of the document. In the window that opens, specify how often this count should be repeated. A reminder about this will be displayed in the list of documents.
Printing invoices for payment
Invoices for payment in 1C are issued to the buyer in paper or electronic form. In the first case, everything is quite simple. Print the mono invoice from the “Print” menu item of the same name in the document header.
After you print it out, it is signed and stamped.
How to insert a stamp and signature on an invoice
When issuing an invoice to a buyer from 1C 8.3 electronically, for example, by e-mail, it is much more convenient to receive from the program a printed form with stamps and fax signatures already installed on it. This will save you from printing the document, signing it and scanning it later.
Go to the directory of organizations and open the card of the one for which you need to install a seal and signatures. In the “Logo and Printing” section, select files from your computer with previously prepared fax images (can be scanned). Please note that the background of the images must be either white or transparent.
Now let’s return to the previously created invoice for payment and this time from the print menu, select the item “Invoice for payment (with stamp and signatures)”. All those images that were uploaded to the organization’s card were displayed in printed form.
Now, when you click on the save button, we can receive this invoice in an external file, for example, pdf, and send it to the buyer.
See also video instructions for issuing an invoice and drawing up an agreement in 1C 8.3:
How can you download documents from a supplier by email in 1C:Accounting 8 edition 3.0?
The video was made in the 1C: Accounting 8 program (release 3.0.42.84).
The transition to electronic document management (EDF) will help to significantly simplify the process of exchanging documents between counterparties, as well as reduce the costs of delivering documents, purchasing consumables and storing archives. Since April 8, 2011, the Federal Law of April 6, 2011 No. 63-FZ “On Electronic Signatures” has been in force, which determined the procedure for obtaining and using an electronic signature and the responsibilities of participants in the exchange of electronic documents. For more information about the exchange of electronic documents, see the directory “Exchange of Electronic Documents” in the “Accounting and Tax Accounting” section.
If the counterparties are not participants in the electronic document flow, then exchanging documents via e-mail will help simplify the process of registering the primary accounting document in the information system.
Accounting system documents Buyer's invoice, Sales (act, invoice), Invoice issued can be sent to the counterparty by email (click Send by email with an image of an envelope). The document is sent as a file attached to the letter in the format selected by the user. Also attached to the letter is a file intended for downloading by the recipient in “1C: Accounting 8” (rev. 3.0).
You can upload documents received from the supplier in the document list forms.
Invoices for payment are uploaded in the form of a list of documents Money orders. Invoices and acts - in the list Receipts (acts, invoices).
The recipient can upload documents like or UPD from files with the extension xls, mxl or in a format approved by the Federal Tax Service of Russia. You can upload documents from a file or from email. You can select the loading method in the form of the list of receipt documents by clicking the button Download. When loading, the program checks for format compliance and reports the results of the check.
When uploading documents TORG-12, Work (service) acceptance certificate or UPD an accounting system document is created Receipt (act, invoice), in which the necessary details are automatically filled in. An additional document can be created for receipt documents Invoice received.
If a product or service arrives to the recipient from the supplier for the first time, and the items of the buyer and supplier are not synchronized, then in the form that opens Comparison of data by item field must be filled in Nomenclature by selecting the appropriate position from the directory Nomenclature, and press the button Save and close .
Setting up email accounts is done in the section Administration - Organizer. The counterparty's email address must be specified in the directory element form Counterparties.
Please note that downloaded documents from e-mail (from a file) are not legally binding documents, therefore both the buyer and the seller must have properly executed documents in paper form.
Most organizations in their daily practice use the Excel software product from the Microsoft office suite to keep track of various accounting transactions in the old fashioned way. This happens when a company just recently switched to the 1C system and the reporting sections have not yet been properly debugged, or the supplier prefers to send a price list in the form of a summary table in .xls format. It is not surprising that there is often a need to replace manual entry of positions with an automated system. This will significantly reduce the time for filling out nomenclature documents and reduce the number of errors, which is important to consider when it comes to several dozen or even hundreds of items.
This problem can be solved in different ways: some organizations prefer to entrust this work to their IT department, others hire developers working in the franchisee’s company, but this is quite expensive and takes a lot of time.
A much more profitable way out of this situation would be to use the appropriate 1C configuration, which will process the data absolutely free of charge and become a universal assistant in the integration of 1C documents and Excel spreadsheets.
In this section, we will help you figure out how to configure the loading of data from a .xls file into one of the software configurations from the 1C company based on “1C:Enterprise 8”
Every user of the professional version of 1C:Enterprise 8 already has such processing! ITS on disk!
Typical processing “Loading Data From Tabular Document.epf”, located in the section: “Technological support” > “Methodological support 1C: Enterprise 8” > “Universal reports and processing” >
D:1CIts\EXE\EXTREPS\UNIREPS82\UploadFromTableDocument Download
Please note that starting from February 2010, on the ITS disk, this processing for configurations on platform 8.1 is located in another section: “Technological support” > “Methodological support 1C:Enterprise 8” > “1C:Enterprise 8.1 platform” > “Universal reports and processing" > "Loading data from a spreadsheet document".
D:1CIts\EXE\EXTREPS\UNIREPS81\UploadFromTableDocument Download
Source data available:
- Price list in Excel “PriceOnlineKhimSnab.xls” - Microsoft Office Excel 97-2003 (.xls)
- Typical configuration Enterprise Accounting Edition 2.0, release 2.0.12.2, platform 8.2 (8.2.10.77)
- It is necessary to load product names and prices into 1C from Excel
From the Price List you need to download the item reference book into 1C: Accounting 8.
We launch the 1C program. To start processing, select the menu item “File”> “Open”.
In the window that opens we find the processing file
Located on the ITS disk in the directory \1CIts\EXE\EXTREPS\UNIREPS82\UploadFromTableDocument
If you previously copied the processing file to your computer, you can select it.
A window will open
Please note that data loading will be carried out in two stages: Stage 1 - loading names and setting the values of the details of new directory elements necessary to get started (unit of measurement, VAT rate, product/service attribute). Stage 2 - loading prices.
Loading titles
Set the “Download Mode” - Upload to the directory “Directory View” - Nomenclature
In the “Table document” tab
Click the ex1_b01.jpg “Open file” button, in the selection window that appears, we find the directory in which we have a price list in Excel from which we plan to load data into 1C.
The file may not appear initially. Set the file type to “Excel Sheet (*.xls)”
Select our file
The details of the item card are displayed.
Setting up title loading options
We want to draw your attention to the aspect of recognizing structural units of nomenclature reference books in the 1C: Accounting program version 8, because one of the key points in identifying these elements is the name. If the information base positions were not initially filled, then you will need to track duplicate positions and, if any, delete them.
Duplicate names are difficult to avoid; it is especially difficult for employees who will use this type of loading not for one-time data entry into the list, but for systematically loading information automatically.
The matter is complicated by the fact that the employee has to deal with various abbreviations and other abbreviations, double spelling of the name and the use of various punctuation marks.
With repeated use and a significant amount of downloaded information, we recommend using other software from the “1C: Enterprise 8” series, for example “1C: Trade Management 8”, “1C: Small Firm Management 8”, or “1C: Integrated Automation 8”, which have the “Article” parameter, which ensures reliable recognition of data loaded into nomenclature directories and eliminates the possibility of duplicating names.
Line “Base unit of measurement” - in the “Load mode” column select “Install”, in the “Default value” column select the unit of measurement (in our case - pcs.)
Line “VAT rate” - in our case, for all downloaded elements we set VAT to 18%, for this in the “Load mode” column we select “Set”, in the “Default value” column we select “18%”.
If the goods come with different VAT, which is indicated in a separate column of the downloaded price list, then in the “Loading mode” column, set “Search” and the number of the corresponding price list column in “Column No. of the spreadsheet document”.
Line “Service” - in the “Loading mode” column, select “Install”, in the “Default value” column, select “No” (in our case, all positions are products).
We have set the minimum values for new items in the nomenclature directory, which will allow you to start working. To close the month, distribute costs, generate accounting and tax reporting, you will need to set the values “Item Group” and “Cost Item”; for imported goods, set the “Country of Origin” and “Customs Declaration Number”, but this can be done later using group processing.
If you are ready to set the values of these details now, then indicate. Click “Download” in the lower right corner, click “Yes” when asked
We check for the presence of new elements in the corresponding group of the item reference book
Open the product card and check that the details are loaded correctly
If everything is correct, then you can proceed to the second stage - loading prices from the price list into Excel.
If you plan to use this data loading procedure in the future with the same loading parameters settings, we recommend that you save the current settings. To do this, click the ex1_b03.jpg “Save Settings” button and clearly name the current setting, for example, “Loading product names from the Excel price list.”
Next time you can load the saved settings by clicking on the “Restore Settings” button and selecting the desired one from the list.
Loading prices
In “Enterprise Accounting” Rev. 2.0, prices are set using the document “Setting Item Prices”.
Set “Load mode” - “Load to table section”.
In the “Link” field, select “Setting item prices”.
Here you can select an existing document into which we want to add new elements, or create a New one (recommended), in the document we indicate which “Price Type” we will load (in our example, “Retail”).
Click “Ok” and save the empty document for now. Now select this new saved document from the journal in the “Link” line. In the “Tabular section” field, select “Products”
Now you need to go to the “Table document” tab
Again, select our price list in Excel from which we downloaded the items, and now we will download the prices (see point 5).
Electronic document management – exchange of legally significant documents (and not only) in electronic form.
I can give the simplest example of electronic document management – companies exchanging Word documents by email.
Of course, such document flow is not structured, a letter with a file may simply not be noticed in time, and, most importantly, it does not have a valid signature and seal.
In addition, our article deals with the exchange of documents between 1C programs. Therefore, the document must have a certain structure so that the receiving program can correctly recognize it and “sort it out.”
For this purpose, there are certain exchange rules, some of which are approved by law (for example, the form of an electronic invoice).
It is for this reason that in this article I want to describe the procedure for setting up the transfer and acceptance of an Invoice in electronic form based on the 1C 8.3 Accounting 3.0 configuration.
Setting up an electronic configuration document 1C: “Enterprise Accounting 3.0”.
To work more efficiently with electronic document exchange, 1C decided to enter into cooperation with the long-proven and reliable company Taxcom. As a result of this cooperation, a module appeared that was integrated into most popular 1C configurations.
Get 267 video lessons on 1C for free:
This made it possible to organize not only the exchange of data, that is, simply transfer it from one counterparty to another, but also to form objects of the 1C system based on this data. These are invoices, Acts, receipt and sales documents, warehouse documents, etc.
In addition, one cannot fail to note a number of advantages of this approach:
- the user does not have to switch to another program and does not even have to change the familiar interface;
- There is no need to additionally install an electronic document management operator program and monitor its updates.
Let's move on to the technical side of setting up the procedure. It consists of four stages:
- First, let’s make sure that the 1C: Enterprise system meets the necessary requirements, namely, the program platform must be at least version 2.15, and the release of the configuration used must contain a document flow module. This information can be found on the 1C website or from partners. You can make the necessary updates from partners.
- To activate the service, you must submit an application. As I wrote earlier, the document module is already in the program. But he is not active yet. Its functionality will be activated after reviewing the application (usually this does not take much time). The application should be filled out in your “personal account” at: http://users.v8.1c.ru.
- As soon as the application is reviewed and approved, the functionality of the document flow module will be fully available.
- Now you can proceed to setting up “1C: Enterprise”.
