How to download a supplier's invoice in 1c. Now you need to go to the tab "Tabular document"
17.05.2017
As in a typical configuration of 1C: Enterprise Accounting, version 3.0, set up the exchange of invoices between the supplier and the buyer in order to load receipts from the supplier's invoices in Excel format using standard exchange tools without using third-party processing.
Get access to the cloud 1C: Fresh for free for 30 days!Quite often, in the daily work of many enterprises, it becomes necessary to load data into an invoice from a 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 time-consuming work.
In such cases, many order the appropriate treatments from 1C franchisee programmers or third-party developers, but this additional expenses and time.
V new edition 3.0 of the standard configuration "1C: Enterprise Accounting" has a built-in mechanism for loading incoming documents from the TORG-12 consignment note, the Act of acceptance and delivery of works (services) or the supplier's UPD in excel or mxl format.
This option for the exchange of documents between contractors can be used in the standard configuration "Enterprise Accounting" version 3.0, both in the local version installed on the user's computer, and in the cloud version of 1C: Accounting.
Similar articles:
Let us consider, for example, the process of loading data into a document "Receipt" of a typical configuration of 1C: Enterprise Accounting, revision 3.0 ("Taxi" interface) from a supplier's invoice in excel (.xlsx) format. If the supplier saved his invoice in the .xlsx format in a regular way from the same typical configuration of 1C: Enterprise Accounting, revision 3.0, then users do not have any problems when loading an invoice from this file.
There is initial data:
- Standard configuration "Enterprise Accounting", revision 3.0, which is installed by both the Supplier and the Buyer.
- Supplier's invoice, created in a typical configuration of 1C: Enterprise Accounting. rev. 3.0. See Figure 1.
- It is necessary to load data from the supplier's invoice into the document “Receipt of goods and services” in a typical configuration of 1C: Enterprise Accounting. rev. 3.0.
Fig. 1 Supplier invoice.
For data exchange to be possible, the following conditions must be met:
- Card of this supplier must already exist in the directory of contractors of your infobase, and the requisites are filled in.
- All goods that we will load from the supplier's invoice must already exist in the nomenclature reference book of your 1C infobase: Enterprise Accounting, rev. 3.0. If the invoice contains new items that are not yet in the database, then before loading the invoice, you must enter them manually or automatically. Instructions for loading the nomenclature are described in the previous part of the series of articles "Downloading to 1C from Excel. Part 4. Loading the nomenclature reference book into 1C: Enterprise Accounting from the price list to Excel".
- There should be no duplicate items with the same name in the item reference book of your database.
Step 1. Save the invoice in Excel format.
In the consignment note, click "Print" and in the drop-down menu select the printable form "Consignment note (TORG-12)".
The printed form of the consignment note is being formed.
In the toolbar, click the button with the image of a floppy disk.
A window will open with a choice of the file format in which you want to save the printed form of the invoice. Select "Microsoft Excel 2007 Sheet (.xlsx)".
We save the file on disk and send it to the customer.
We save the file with the printed form of the consumable, which was sent by the supplier, on our computer.
In user mode, open the infobase into which you want to load the data.
Section "Purchases"> "Receipts (acts, invoices).
The journal of receipt documents will open. In the log toolbar, select "Load" and in the drop-down menu, select "From file".
A standard explorer window will open, with the help of which we select the saved vendor invoice file in the ".xlsx" format to load data into the receipt invoice.
If the data is loaded 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 a commodity item from your stock list reference for each item from the supplier's invoice.
If the comparison of directories has already been performed, the data will be loaded immediately, while the details of the "header" of the receipt invoice (Supplier, Buyer, supplier's invoice number) and the details of the tabular section (Name, Price, Quantity, Amount, Rate and the amount of VAT, Accounting accounts, CCD and Country of origin).
We check the correctness of the uploaded information from the supplier's invoice and if everything converges, 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 documents uploaded from a file in this way are not legally significant, therefore, both the buyer and the seller must have properly executed original documents in paper form.
If between contractors it is necessary to organize the exchange of legally significant electronic documents, which cancel the need to exchange original documents in hard copy, then it is necessary to set up the 1C-EDO / 1C: Taxcom electronic document management system.
Set up EDF with counterparties for the exchange of electronic documents
If you succeed, 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 you need electronic document management in the 1C program?
Electronic document flow - the exchange of legally significant documents (and not only) in in electronic format.
Let's give the simplest example of electronic document management - the exchange of "Word" documents by companies by e-mail.
Of course, such a document flow is not structured, a letter with a file can simply not be noticed in time and, most importantly, it does not have a valid signature and seal.
Also in this article it comes on the exchange of documents between 1C programs. Therefore, the document must have a certain structure so that the receiving program could correctly recognize it and “sort it out”.
For this, there are certain exchange rules, some of which are approved by law (for example, the form of an electronic invoice).
This article describes the procedure for setting up the transmission - acceptance of an 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".
For more efficient work with electronic exchange of documents, the 1C company decided to enter into cooperation with the long-proven and reliable Taxcom company. As a result of such cooperation, a module has appeared that is integrated into most of the popular 1C configurations.
This made it possible to achieve the organization of not only the exchange of data, that is, simply transferring them from one counterparty to another, but also to form objects of the 1C system on the basis of these data. These are just invoices, Acts, receipts and sales documents, warehouse documents etc.
In addition, one cannot fail to note a number of other advantages of this approach:
- The user does not have to switch to another program, and does not even have to change the familiar interface
- You do not need to additionally install and monitor the updates of the electronic document management operator program
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 complies with necessary requirements, namely, the program platform must be at least version 2.15 and the release of the used configuration must contain a document management module. This information can be found on the 1C website, or from partners. The partners can make the necessary updates.
- To connect the service, you need to submit an application. As mentioned earlier, the document module is already in the program. But it is not active yet. Its functionality will be activated after consideration of the application (usually it does not take much time). The application should be filled out in your "personal account".
- As soon as the application is considered and approved, the functionality of the document management module will be fully available.
- Now you can go to the 1C: Enterprise settings.
After these operations, the documents will have a button with a list of operations with electronic document flow (as we collected earlier, let's see the document "Invoice issued"):
You can try to send the "Invoice" to the counterparty, just do not forget to warn him about this and make sure that he also has the module configured.
To interact with regulatory authorities, you will also need certificates issued by them.
Based on materials: programmist1s.ru
Despite the fact that invoicing for payment of any goods or services to the buyer is not mandatory, nevertheless, in practice it 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.
It is very convenient to pay bills. We all receive monthly receipts for rent, electricity, gas, water. In essence, they are also analogous to accounts.
Of course, an invoice for payment is not a primary document, but it is from it that the reflection of sales of goods and services, as well as settlements with customers, begins. How to issue an invoice for payment in 1C 8.3 and print it - we will tell you in this article.
You can find invoices for payment in the "Sales" section.
Create new document and fill in his cap. In the field "Paid By" we will indicate August 31, 2017. 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 “Not paid”. After we receive any action from the buyer, the status will change.
We will select as counterparties and indicate that we are working with him under an agreement with the buyer "". The agreement 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 agreement with the customer based on the generated invoice.
Do not forget to indicate the bank account to which the 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 sweets, 30 Squirrel and 25 Cherry. We will definitely check the correctness of the automatically inserted prices. They can be edited manually.
If you deliver goods in a returnable container, for example, beer in kegs, information about it can also be indicated on the corresponding tab.
In the event that this invoice for payment is periodic, for example, you have a contract with a customer for a monthly supply, click on the "Repeat" hyperlink at the top of the document. In the window that opens, indicate 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 the mono invoice from the "Print" menu item of the same name in the header of the document.
After you print it, it is signed and stamped.
How to insert a seal and signature
When invoicing a buyer 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 already installed on it and facsimile signatures... This saves you the hassle of 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 want to set the seal and signature. In the "Logo and Printing" section, select files with previously prepared fax images (scanned) from your computer. 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 seal and signatures)". All those images that were uploaded to the organization card were displayed in printed form.
Now, when you click on the save button, we can get this invoice in an external file, for example, pdf, and send it to the buyer.
See also the video instruction on invoicing and drawing up an agreement in 1C 8.3:
The use of electronic document management (EDF) in the organization
In order to understand what electronic document management (EDM) is and what it is for, you should know general principle workflow. Namely:
- What primary documents are drawn up at the enterprise;
- How these documents are exchanged within the enterprise and with third parties;
- Who draws up and checks the execution of primary documents;
- Who has the right to sign documents.
Each company has developed an individual workflow schedule, which helps employees to understand and determine the movement of documents.
EDF first appeared in banking, then EDF systems began to be used in many Western enterprises. Currently, EDM is widely used in Russia as well, for the operational exchange of information.
EDI is a quick and high-quality exchange of various information both within the enterprise and with external counterparties or regulatory authorities. Timely identification of errors and discrepancies in settlements between counterparties, as well as reconciliation of the data of the buyer and supplier with the data of the Federal Tax Service Inspectorate, allows you to quickly identify discrepancies in invoices.
For example, when exchanging documents with counterparties using EDM, and not using postal services, the company will save not only the time of document processing: document printing, collecting signatures, registration of envelopes, etc., but also reduce the cost of mail services.
According to the legislation, documents processed using EDF have the same legal force as on paper. All contracts, agreements and other similar documentation are legally binding in accordance with the Civil Code of the Russian Federation. V Tax Code also provides for electronic documentation, which has the same validity as paper documents.
How to organize the exchange of electronic documents (EDF) in 1C 8.3 - step by step instructions
In the program 1C 8.3 Accounting ed. 3.0 provides a function designed for the use of EDF. Let's take an example of the rules for setting up and working with EDM in 1C 8.3.
Step 1. Setting up electronic document management in 1C 8.3
To work with EDM 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 which you send reports to the IFTS and off-budget funds;
- Get the password and login of the Internet support of the 1C company serving the company;
- Install crypto-pro on a computer or get a digital signature on a flash drive.
Attention! In the directory "Counterparties", the name of the counterparties must be filled in according to the IFTS data, in order for 1C 8.3 to correctly fill in the data: name of the organization, TIN / KPP, address and IFTS code.
To do this, go to the "References" menu, where we select the "Contractors" reference book:
In the list of contractors that opens, we check the correct filling of data for to all counterparties. To do this, hover the cursor over the required counterparty and use the "More" button to select the "Edit" editing function:
The counterparty card is opened:
If the counterparty's TIN has already been entered into the card, then we press the "Fill in by TIN" button, after which the auto fill information about the checkpoint, name and address according to the IFTS data.
The address must be filled in not in an arbitrary format, but according to the data of the address classifier. But for this, you need to configure the connection of the 1C base to the Internet and the IFTS server.
Step 2. Configuring EDF and cryptography
We go to the “Administration” section and select the function “Exchange of electronic documents”:
The window "Configuring the exchange of electronic documents" opens:
To work with EDM in 1C 8.3, tick the “Electronic Signatures” and “Exchange of Electronic Documents with Counterparties” functions:
Then you should make sure that the electronic signature is configured. To do this, go to the "Settings electronic signature and encryption "on the" Programs "tab, where the installed key should be displayed. If the key is not installed, then you should contact the 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 EDO and TAXCOM services, the connection assistant opens. Following the prompts of the 1C 8.3 program, we go through the filling stage:
Next, go to the EDM settings in 1C 8.3, where an automatically configured template for the exchange of electronic documents with counterparties opens. In the field "Organization" you must select entity to whom you want to send an invitation for electronic document exchange. After that, by clicking on the button "Record and close", the selected counterparty will automatically receive an invitation to connect to EDF:
To update EDM forms in 1C 8.3, you should check the box "Switch to new forms automatically":
In 1C 8.3, you can set up a schedule for the exchange of electronic documents:
Or watch our video tutorial:
Step 4. Working with EDF
When generating primary documents in the 1C Accounting 8.3 program, it should be noted that in the menu of the document for which the electronic document management form is approved, there is an "EDM" button. All actions with such primary documents can be done according to the selected command:
To view all information on the movement of documents for EDF, in 1C 8.3 there is a function "Archive EDF" in the "Administration" menu:
In the archive, you can view all operations performed with documents in EDF. Using the tabs and the 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 EDF in 1C 8.3, you should use the "Current EDF" function, which is located in the "Sales" section:
Or in the "Shopping" section:
Where you can also generate the necessary reports:
To exchange arbitrary electronic documents with suppliers or buyers in 1C 8.3, the function "Free electronic documents" is intended:
In this service, you can select a file of any format or a specified format from the drop-down list.
The development is designed to automate routine operations for entering invoices from a supplier into 1C. Allows you to quickly fill in the tabular part of the receipt of goods and services, as well as create goods that are not yet in 1C. Now the download time will be reduced to 5 minutes!
Problems solved by the development of "Loading invoices into 1C from Excel"
Accelerates the creation of documents "Receipt of goods and services" and "Sale of goods and services" To do this, it is enough to fill in the "header" of the document and start processing the filling of the document. Now you do not need to enter each item manually and fill in the columns (CCD number, unit of measure, quantity, price, amount, etc.).
Prevents duplication of goods in the 1C database The human factor when filling out important documents is widely known issue... Now you can minimize it. The processing itself will determine which products are already in the database and which ones need to be added. The addition will also happen automatically, which will avoid, among other things, grammatical errors in the name of the product.
"Loading invoices into 1C from Excel" is real help operators and accountants. Processing allows you to avoid errors and inaccuracies, saves time and effort of employees, saves the company money due to the absence of errors in documents.
Examples of using the development "Loading invoices into 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, whether there is already such a product in the database, then add it to a 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 the data is transferred to 1C as accurately as possible.
You are an intermediary between the wholesaler and the buyer.
If the scheme of your work looks like this:
1. You order a certain amount of goods;
2. You purchase this product from your supplier;
3. Sell this product with a surcharge to the customer;
then given processing automates this process. You just upload the invoice to the "Receipt of goods and services", and then upload it to the "Sale of goods and services", indicating the required margin. This, in turn, saves you the trouble of manually calculating the markup percentage. Everything will be done automatically!
How does the solution "Download invoices to 1C from Excel" work?
Advantages of the development of "Loading invoices into 1C from Excel"
Development is ready to use right after installation You just need to copy the file to your computer and add it using the 1C file upload service. For users it is provided step by step guide... If you have any difficulties, we are ready to help you install the solution using remote access to your computer.
The development is easy to operate and does not require special skills In order to master the loading of invoices into 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, processings and documents in 1C. Standard windows and buttons, standard data presentation are used. You don't have to get used to something completely new. It's just that now there will be one more opportunity in 1C.
Development does not affect the mechanisms of typical configurations Your 1C program will continue to be easily upgradeable, and all functions will work as before!
Technical features and support
It is possible to adapt the development to an individual order.
Development is intended for configurations:
- Enterprise accounting ed. 3.0
- Enterprise accounting ed. 2.0
1 year warranty We are ready to promptly resolve any possible problems related to the integration and quality of the program
All errors in the solution are promptly and free of charge corrected how in individually at the request of users, and in planned releases, during the warranty period.
The procedure for acquiring the development of "Loading invoices into 1C from Excel"
In accordance with the legislation Russian Federation the buyer has the right to refuse the ordered goods at any time before receiving it.
Attention! After receiving the set of source files, return Money the customer becomes impossible, since software is an object of 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 (Ch. 2, Art. 25) refer to the list of non-food products that cannot be returned or exchanged (as amended by the Resolutions of the Government of the Russian Federation of 20.10.1998 No. 1222, 06.02 .2002 No. 81).
The transfer of the goods is considered to be the receipt of a set of source files by e-mail or through other electronic exchange services.
Solution cost
Solution cost"Downloading invoices to 1C from Excel" is from 18,000 rubles
You can order individual modifications of this solution for the specifics of your business. Evaluation of modifications is made on an individual basis upon request.
Solution order form
All questions, wishes, as well as requests for the purchase of this development, you can leave in the comments. Site team specialists will promptly answer any questions about the solution "Loading invoices into 1C from Excel".
Registration is not required to post comments!
- The use of customer-supplied raw materials for the production of finished products: accounting, consumption rates, write-off Reflection of services for the processing of materials
- Terms of payment of insurance premiums and submission of reports under the new rules
- Reminder of admission to off-budget (paid) places How to pay for tuition
- Online courses for accountants, distance accounting courses online, online training for accountants Accounting for cash transactions and transactions with accountants