How to download the vendor invoice in 1s. Now you need to go to the tabular table document
17.05.2017
As in the standard 1C: Accounting Enterprise Edition 3.0 configuration, configure the exchange of invoices between the supplier and the buyer to download incoming invoices from the supplier’s invoices in Excel format using standard means of exchange without using third-party processing.
Get access to 1C: Fresh cloud for free for 30 days!Quite often, in the daily work of many enterprises, it becomes necessary to load data into the receipt invoice from the supplier's invoice in Excel format, which the supplier for example sent by e-mail.
The automatic exchange of data between the supplier and the buyer is especially relevant when the number of elements that need to be entered is tens, hundreds or even thousands, and manual input of such a volume of data is quite a laborious task.
In such cases, many order the appropriate processing from 1C franchisee programmers or third-party developers, but this is an additional cost and time.
In the new version 3.0 of the standard configuration “1C: Enterprise Accounting” there is a built-in mechanism for loading incoming documents from the TORG-12 expense bill, the Act of Acceptance of Work (Services), or the Supplier's Delivery Certificate in excel or mxl format.
This option for exchanging documents between counterparties can be used in the standard configuration "Enterprise Accounting" edition 3.0, both in the local version installed on the user's computer and in the cloud version 1C: Accounting.
Similar articles:
Consider, for example, the process of loading data into a document “Incoming invoice” of a typical 1C configuration: Enterprise Accounting, revision 3.0 (Taxi interface) from a vendor invoice in excel format (.xlsx). If the supplier saved his consignment note in the .xlsx format in a regular way from the same standard configuration 1C: Enterprise Accounting, edition 3.0, then users do not have any problems loading the incoming invoice from this file.
There are initial data:
- Typical configuration "Enterprise Accounting", edition 3.0, which is installed both at the Supplier and the Buyer.
- Supplier invoice, created in a standard configuration 1C: Accounting company. rev.3.0. See figure 1.
- It is necessary to load the data from the supplier’s invoice into the document “Goods and services receipt” in the standard configuration 1C: Accounting of the enterprise. rev.3.0.
Fig. 1 Supplier invoice.
To be able to exchange data, the following conditions must be met:
- The card of this supplier should already exist in the directory of contractors of your information base, and the details are filled.
- All the goods that we will load from the supplier’s bill of lading should already exist in the nomenclature directory of your information base 1C: Enterprise Accounting, rev.3.0. If there are new items in the invoice that are not yet in the database, then before loading the invoice, you must enter them manually or in automatic mode. Instructions for loading the item are described in the previous part of the series of articles “Downloading to 1C from Excel. Part 4. Downloading the item list to“ 1C: Enterprise Accounting from the price list in Excel ”.
- In the nomenclature directory of your database there should not be duplicate elements with the same names.
Step 1. Save the invoice in Excel format.
In the consignment note, click "Print" and in the drop-down menu select the print form "Consignment note (TORG-12)."
The printed form of the waybill is formed.
In the toolbar, click the button with the image of a floppy disk.
A window opens with a choice of the file format in which you want to save the printed form of the invoice. Select "Microsoft Excel 2007 Worksheet (.xlsx)."
We save the file to disk and send it to the buyer.
We save the file with the printed form of the consumable that the supplier sent on his computer.
In user mode, open the infobase into which data must be loaded.
Section "Purchases"\u003e "Receipts (acts, invoices).
The journal of incoming documents opens. In the log toolbar, select "Download" and select "From File" in the drop-down menu.
A standard explorer window will open, with which we select the saved vendor invoice file in the ".xlsx" format for loading data into the incoming invoice.
If the data is being downloaded for the first time, the program will automatically offer to compare the item in your database with the item from the downloaded file by selecting the item from your item list for each item from the supplier’s invoice.
If directories have already been compared, the data will be downloaded immediately, and the details of the header of the receipt invoice (Supplier, Buyer, number of the supplier’s invoice) and the details of the tabular section (Name, Price, Quantity, Amount, Rate) are automatically filled in and the amount of VAT, Accounts, Customs Declaration and Country of Origin).
We check the correctness of the downloaded information from the supplier’s consignment note and if everything fits together, then we post the document.
Please note that this exchange option is intended only to simplify and speed up the process of entering documents and similarly downloaded documents from a file are not legally significant, therefore both the buyer and the seller must have properly executed original documents in paper form.
If it is necessary to organize the exchange of legally significant electronic documents between contractors, which eliminate the need to exchange the original documents on paper, then you need to configure the electronic document management system 1C-EDO / 1C: Taxcom.
Set up EDI with contractors for the exchange of electronic documents
If everything worked out for you, then we like the article on social networks and share the link on the forums))).
We wish you success!
To be continued...
Online Company 2017,
Why do we need electronic document management in the 1C program?
Electronic document management - the exchange of legally significant documents (and not only) in electronic form.
We give the simplest example of electronic document management - the exchange of companies “Word” documents by e-mail.
Of course, such a document flow is not structured, a letter with a file can simply not be noticed on time and most importantly it does not have a valid signature and seal.
In addition, this 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 “put it on the shelves”.
There are certain exchange rules for this, some of which are approved by law (for example, the form of an electronic invoice).
This article describes the procedure for setting up the transfer - acceptance of the invoice in electronic form based on the configuration of 1C 8.3 Accounting 3.0.
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-established and reliable company Takskom. As a result of such cooperation, a module appeared that was integrated into most popular 1C configurations.
This made it possible to organize not only the exchange of data, that is, simply transferring them from one counterparty to another, but also to form “1C” system objects on the basis of this data. These are just invoices, Acts, documents of receipt and sale, warehouse documents and so on.
In addition, it is impossible not to mention 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
- No need to additionally install and monitor updates to the electronic document management program
Let's move on to the technical side of the procedure settings. It consists of four stages:
- To begin with, 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 management module. This information can be found on the 1C website, or at partners. Partners can make the necessary updates.
- To connect the service, you must submit an application. As previously written, the document module is already in the program. But he is not yet active. Its functionality will be involved after consideration of the application (usually this does not take much time). The application should be completed in your "personal account".
- As soon as the application is reviewed and approved, the functionality of the workflow module will be fully available.
- Now you can proceed to the settings of “1C: Enterprise”.
After these operations, the documents will have a button with a list of operations with electronic document management (as we collected earlier, we will see the document “Invoice issued”):
You can try to send the “Invoice” to the counterparty, just remember to warn him about this and make sure that he also has a module configured.
To interact with regulatory authorities, certificates issued by them will also be required.
Based on materials: programmist1s.ru
Despite the fact that invoicing for the payment of any goods or services to the buyer is not mandatory, nevertheless, in practice he is quite common. The invoices indicate the details of the supplier, as well as a list of goods and services for which you need to make an advance payment.
Paying bills is very convenient. Every month we receive receipts for rent, electricity, gas, water. They, in essence, 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 begins, as well as settlements with customers. How to invoice for payment in 1C 8.3 and print it - we will tell in this article.
You can find invoices in the "Sales" section.
Create a new document and fill in its heading. In the field "Paid up to" we will indicate August 31, 2017. If the buyer does not pay it within the specified time, the account will become invalid. There can be many reasons, for example, price changes.
The status of our account will initially be “Not Paid”. After we receive any actions from the buyer, the status will change.
As counterparties, we select and indicate that we are working with him under a contract with a buyer "". The contract may not be indicated, in this case, to the right of this field, click on the "New" button. In this case, the program will create a new contract with the buyer based on the account being created.
Do not 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 specify its size.
In the tabular section of the “Goods and Services” tab, we indicate that we sell 20 units of “Assorted” candies, 30 “Squirrel” and 25 “Cherry”. Be sure to check the correctness of the prices set automatically. They can be edited manually.
If you deliver goods in returnable containers, for example, beer in kegs, data about it can also be indicated on the corresponding tab.
In case this payment invoice is periodic, for example, you have an agreement with the buyer for a monthly delivery, click on the “Repeat” hyperlink at the top of the document. In the window that opens, specify how often this account should be repeated. A reminder of 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 mono invoice from the "Print" menu item of the same name in the document header.
After you print it, it is signed and stamped.
How to insert a seal and signature on an account
When invoicing a customer from 1C 8.3 in electronic form, for example, by e-mail it is much more convenient to receive a printed form from the program with seals and facsimile signatures already installed on it. This will save you from printing a document, signing it and scanning afterwards.
Go to the directory of organizations and open the card of the one for which you want to set the seal and signatures. In the "Logo and Printing" section, select files from your computer with previously prepared fax images (you can scan them). Please note that the background of the images should be either white or transparent.
Now back to the previously created invoice for payment and this time from the print menu we will select the item “Invoice for payment (with seal 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 will be able to get this invoice in an external file, for example, pdf and send it to the buyer.
See also video instructions for invoicing and drafting a contract in 1C 8.3:
The use of electronic document management (EDO) in the organization
In order to understand what electronic document management (EDO) is and why it is needed, you should know the general principle of document management. Namely:
- What primary documents are prepared at the enterprise;
- How is the exchange of these documents within the enterprise and with third-party organizations;
- Who draws up and checks the execution of primary documents;
- Who has the right to sign documents.
Each enterprise has developed an individual workflow schedule that helps employees understand and determine the movement of documents.
For the first time, EDI appeared in the banking sector, then EDI systems began to be applied at many Western enterprises. Currently, EDI is widely used in Russia, for the rapid exchange of information.
EDI is a quick and high-quality exchange of various information both within the enterprise and with external contractors or regulatory authorities. Timely identification of errors and discrepancies in settlements between counterparties, as well as reconciliation of buyer and supplier data with IFTS data, allows you to quickly identify discrepancies in invoices.
For example, when exchanging documents with counterparties using EDI, and not using postal services, the company will save not only the time it takes to process a document: printing a document, collecting signatures, processing envelopes, etc., but also reduce the cost of mail services.
Documents processed using EDI, according to the legislation, have the same legal force as on paper. All contracts, agreements and other similar documentation is legally binding in accordance with the Civil Code of the Russian Federation. The Tax Code also provides for electronic documentation, which has the same force as paper documents.
How to organize the exchange of electronic documents (EDO) in 1C 8.3 - step by step instructions
The program 1C 8.3 Accounting ed. 3.0 provides a feature designed to use EDI. Consider the example of the rules for setting up and working with EDI in 1C 8.3.
Step 1. Configuring electronic document management in 1C 8.3
To work with EDI in 1C 8.3, you must first configure the program, namely:
- Make updates to the current release;
- Conclude an agreement with a telecom operator for the transmission of electronic data. It is possible with the operator through whom you send reports to the IFTS and extra-budgetary funds;
- Get a password and login for Internet support of the 1C company serving the enterprise;
- Install crypto-pro on a computer or receive an digital signature on a flash drive.
Attention! In the directory “Counterparties”, the name of the counterparties must be filled in according to the data of the Federal Tax Service Inspectorate, so that in 1C 8.3 the data are correctly filled in: name of organization, TIN / KPP, address and code of the Federal Tax Inspectorate.
To do this, go to the “Directories” menu, where we select the “Counterparties” directory:
In the list of counterparties that opens, check the correct filling of data by to all counterparties. To do this, move the cursor to the desired counterparty and use the "More" button to select the "Edit" editing function:
Counterparty card opens:
If the TIN of the counterparty has already been entered into the card, then click the "Fill in by TIN" button, after which the information on the checkpoint, name and address will be automatically filled in according to the IFTS.
The address must be filled in not in an arbitrary format, but according to the address classifier. But for this, you should configure the connection of the 1C base to the Internet and the IFTS server.
Step 2. Setting up EDI and cryptography
We go to the “Administration” section and select the function “Exchange of electronic documents”:
The "Configuring Electronic Document Exchange" window opens:
To work with EDI in 1C 8.3, it should be noted that the “Electronic Signatures” and “Exchange of electronic documents with counterparties” functions are “checked”:
Then make sure that the electronic signature is configured. To do this, go to the "Electronic Signature and Encryption Settings" menu on the "Programs" tab, where the installed key should be displayed. If the key is not installed, then you should contact specialists to install it:
Step 3. Connect electronic document management
The next step is to connect to the 1C EDO service. To do this, select the functions “Connect to 1C EDO service” and “Connect to 1C Taxcom service”:
When connecting to the EDO and TAXCOM services, the connection assistant opens. Following the prompts of the program 1C 8.3, we go through the filling stage:
Next, go to the EDI settings in 1C 8.3, where an automatically configured template for exchanging electronic documents with contractors opens. In the "Organization" field, you must select the legal entity to which you want to send an invitation to electronic exchange of documents. After that, by clicking on the “Record and Close” button, the selected counterparty will automatically be sent an invitation to connect to EDI:
To update EDI forms in 1C 8.3, check the box "Switch to new forms automatically":
In 1C 8.3, you can configure the schedule for the exchange of electronic documents:
Or watch our video tutorial:
Step 4. Work with EDI
When forming primary documents in the program 1C Accounting 8.3, it should be noted that in the menu of the document for which the form of electronic document management is approved, there is a button “EDO”. All actions with such primary documents can be performed according to the selected command:
To view all the information on the movement of documents by EDI, in 1C 8.3 there is a function "Archive EDO" in the "Administration" menu:
In the archive you can see all the operations performed with documents in the EDI. Using bookmarks and settings menu, in 1C 8.3 you can get various reports on the types of documents and the degree of their execution:
To work in the current mode with EDI in 1C 8.3, you should use the function "Current affairs of EDI", which is located in the "Sales" section:
Or in the "Shopping" section:
Where you can also generate the necessary reports:
For the exchange of arbitrary electronic documents with suppliers or customers in 1C 8.3, the function "Free Electronic Documents" is intended:
In this service, you can select a file of any format or an established format from the drop-down list.
The development is intended to automate routine operations on making invoices from a supplier in 1C. It allows you to quickly fill out the tabular part of the receipt of goods and services, as well as create goods that are not yet in 1C. Now the data loading time will be reduced to 5 minutes!
Problems solved by the development of “Loading invoices in 1C from Excel”
Accelerates the creation of documents “Receipt of goods and services” and “Sales of goods and services” To do this, just fill in the "header" of the document and start processing the filling of the document. Now you do not need to enter each product manually and fill in the columns (GTE number, unit of measure, quantity, price, amount, etc.).
Prevents duplication of goods in the 1C database The human factor in filling out important documents is a well-known problem. Now you can minimize it. Processing itself will determine which products are already in the database and which need to be added. Adding will also happen automatically, which will avoid, including grammatical errors in the name of the product.
“Downloading invoices to 1C from Excel” is a real help to operators and accountants. Processing allows you to avoid errors and inaccuracies, saves time and effort of employees, saves company money due to the absence of errors in the documents.
Examples of using the development “Loading invoices to 1C from Excel”
Quickly create goods receipts. If your store regularly receives a sufficiently large number of electronic invoices, then the need to automate the receipt of goods is obvious. Your 1C users will no longer first search in 1C if there is already such a product in the database, then add it to the document or create a new product, and then carefully fill in the quantity and price, checking the documents from the supplier. Everything happens quickly, simply and data is transferred to 1C as accurately as possible.
You are the intermediary between the wholesale company and the buyer.
If your workflow looks like this:
1. You order a certain amount of goods;
2. You purchase this product from your supplier;
3. Sell this product at a premium to the customer;
then this processing automates this process. You simply upload the invoice to the “Receipt of goods and services”, and then upload it to the “Sales of goods and services”, indicating the required mark-up. This, in turn, saves you from having to calculate the percentage markup manually. Everything will be done automatically!
How does the solution “Download invoices to 1C from Excel” work?
Advantages of the development of “Loading invoices in 1C from Excel”
Development is ready to use immediately after installation Simply copy the file to your computer and add it using the file download service in 1C. A step-by-step guide is provided for users. If you have any difficulties, we are ready to help you install the solution using remote access to your computer.
Development is easy to operate and does not require special skills. In order to master loading invoices to 1C from Excel, no additional training is required.
The development interface is designed according to the standards adopted by 1C It is no different from other reports, processes and documents in 1C. Uses standard windows and buttons, standard data presentation. You do not have to get used to something fundamentally new. Just now in 1C there will be another opportunity.
Development does not affect typical configuration mechanisms Your 1C program will continue to be easily updated, and all functions will work as before!
Technical Features and Support
There is the possibility of adapting custom development.
Development is intended for configurations:
- Company Accounting Ed. 3.0
- Company Accounting Ed. 2.0
1 year warrantyWe are ready to quickly solve any possible problems associated with the integration and quality of the program
All errors arising in the work of the solution are promptly and free of charge corrected. both individually at the request of users, and in scheduled releases, during the warranty period.
The procedure for acquiring the development of “Downloading invoices to 1C from Excel”
In accordance with the legislation of the Russian Federation, the buyer has the right to refuse the ordered goods at any time before receiving it.
Attention! After receiving a set of source files, a refund to the customer becomes impossible, since the software is subject to copyright and is protected as a literary work (Civil Code of the Russian Federation, part 4, article 1259). In turn, non-periodical publications in accordance with the Law on the Protection of Consumer Rights of the Russian Federation (Chapter 2, Article 25) relate to the list of non-food goods that are not subject to return or exchange (as amended by Decisions of the Government of the Russian Federation of October 20, 1998 No. 1222, 06.02 .2002 No. 81).
The fact of transferring goods is considered to be receiving a set of source files by e-mail or through other electronic exchange services.
Solution cost
Solution cost “Loading invoices to 1C from Excel” is from 18 000 rubles
You can order individual modifications of this solution to the specifics of your activity. Evaluation of improvements is made individually on request.
Solution Order Form
All questions, wishes, as well as requests for the purchase of this development, you can leave in the comments. The site team specialists will promptly answer any questions regarding the work of the solution “Download invoices to 1C from Excel”.
Registration is not required to send comments!