How to enter paper invoices in 1s. Automatic filling of the bill of lading. Write-off of materials for household needs

Today we will consider one of the most pressing issues for any accountant - how to create an invoice in 1C.

An invoice in 1C is created in a few simple steps. To do this, you need to open the main menu and find the "sale" section there. In the list of items that appears, click on the item "Sale of goods and services." After clicking, a magazine of the same name will open in front of the user.

There is another way to open the log:

select the "sale" tab (located on the function panel);

find the button "sale of goods and services" and click on it.

The magazine "realization of goods and services" contains almost all documents related to sales. There you can easily print documents such as:

consignment note 1C 8.2;

the act of providing services;

bill of lading.

To create a new document, you need to find the "add" button in the journal menu and click on it. There is an alternative way: hold down the "insert" key. As a result of these actions, the program itself will create a new document for you, in which some values ​​will already be filled in by default.

First, specify the type of operation you need. In our example, this would be "sale and commission".

Once you have specified the type of operation, you can proceed to filling in the rest of the details. Expenditure invoice Ukraine requires mandatory data:

specify the counterparty (shipment is carried out to him);

notify the contract with the buyer (if any);

Specify the warehouse from which the sold goods are shipped.

Remember, you need to specify settlement documents only if there are appropriate options in settlements with counterparties or special settings are set in the accounting policy of the enterprise.

The next step is to fill in the table, which is located in the "goods" tab. Moreover, you need to fill it out only if you sell products. For those who provide services, there is a special part of the table, which is located on the corresponding tab.

When you have added items of goods or services for sale, you must specify the quantity sold. After that, the program will automatically calculate all positions automatically. The main thing is to correctly fill in the necessary details, then the 1C nomenclature with reference books for each category of goods will not contain errors.

Remember to periodically scroll the table horizontally so as not to miss the blank fields in the document. Otherwise, the 1C 8.2 invoice will be created with errors.

container (if necessary);

expense accounts (they need to be checked and adjusted if necessary);

additional details (verify and complete).

If you open the "additional" tab, then you will need to fill in information about the recipient of the goods, as well as the address where the goods will be delivered. In order not to leave the “print” tab blank, you can specify information regarding the power of attorney, as well as fill out the profile of the authorized person who will receive the shipment.

After that, you need to carefully check the data that you entered in the header and in the tabular section. Invoice in 1C should contain only the correct details. When you make sure that there are no errors, click on the "record" button. If you are not going to print the created document yet, then you need to click on the “ok” button. In this case, all data will be saved, and the document will simply close, exactly until the moment you need to print it.

In our example, we will print the invoice, so after clicking on the "write" button, you will need to wait a while (the program saves the data in the document). After that, click on the "invoice invoice" button, which is located in the lower menu.

If you need to print other types of documents, then they must first be selected in the menu that is displayed by the "print" button. Next, an invoice is generated in a printed form.

You can then view the results of the work both in the journal with consumable documents and in the top menu of the document itself.

The 1C:Accounting 8 program allows you to perform not only accounting operations, but is also a means of generating primary documents. Such documents include - acts of work performed, TORG-12, invoices and many others. The 1C function for printing documents in most cases suits users, but there are situations when the typical functionality of "1C: Accounting 8" clearly does not cover all the needs of the company. These features include bill of lading printing.

Bill of lading in 1s

Using the function of filling TTN in "1C: Accounting 3.0" Does NOT require modification standard configurations "1C: Accounting".

Functionality filling out a bill of lading connects as external printing forms and treatments. And this means that your ability to update software products "1C: Accounting" WILL NOT be affected and changed.

In "1C: Accounting" in the document "Sale of goods of services" when you select the printed form "Consignment note (1-T)", a ready-filled "Typical interindustry form No. 1-T" immediately opens a printed form ttn, in which almost all fields are filled , except:

• Vehicle data
• Driver details (name, driver's license)

In addition, difficult situations are possible when the consignor may not be the organization that issues the documents. And it is possible that the payer of transportation services will not be the company that receives the goods.

In this case, it is necessary to fill in the finished printed document "1-T" manually as in MS Excel. In addition, a typical situation is when in "1C: Accounting" you need to print some document from the previous period and see what was indicated in the TTN. But printed data is not saved in 1C. Under all these conditions, filling and printing bill of lading in 1C

Solution for 1C TTN printing in "1C: Accounting 3.0"

We offer you the function TTN seal (1-T), which connects to the "1C: Accounting 8" configuration and allows you not only to print the TTN from the "Sale of goods of services" document, but also to pre-specify the necessary parameters (car, driver, driver's passport data), as well as save information to the database. This will allow you to open the document after any period of time and print it. bill of lading the way it was printed earlier.

And most importantly - no need to make changes to the configuration "1C: Accounting 3.0"

How it works

The program "1C: Accounting 8" already has all the necessary data in order to indicate them when generating a printed form of TTN

Information about the car. As information about the vehicle, we use the directory "Fixed assets" of the program "1C: Accounting 8". In addition, along with the fixed asset in 1C, you can also specify data on the registration of a vehicle with a state number.

Vehicle driver. For information about drivers, we use the directory "Individuals". In addition, for an individual, you can specify information not only about the passport data of an individual, but also information about a driver's license. We use this information to print TTN in 1C: Accounting.

You can enter and change information in the following fields:

• Counterparty. transport service payer
• Consignee
• Shipper
• loading point
• unloading point

When you click on the "Print" button, a completed printable form opens and at this moment the specified information is saved in the additional parameters of the "Sales of goods and services" document. The next time you select the TTH printable form, exactly the values ​​that were filled in will be substituted in the filling form.

You can on your own test the printing of the bill of lading in our demo database.

To do this, you need to enter the path http://217.173.74.78:8090/AccDemo in the browser in the address bar and the web client "1C: Accounting 3.0" will load. In the list of users, select "Demo" and enter the database.

Next you go to the section "Sales"->"Implementation (acts, invoices)", open any document "Realization of goods of services" and in the "Print" menu select the item "TTN". Fill in the fields and perform TTN printing

If you don't have enough data in the demo database to fully test the waybill printing, then you can enter any necessary information.

The essence of this method is to use processing "loading into the tabular part".

In the work of a modern accountant, a lot of time is occupied by operator work on driving the same type of information into the database.

For example, the posting of stationery for the office is a multi-page invoice with a large number of positions.

There are software systems for automatic scanning entering into the database. Their cost is from 10,000 per year for 1 workplace.

The proposed method is free and does not require the installation of additional software systems. The example is written on the basis of 1C Enterprise 8.3 Accounting department of a state institution, respectively, the account numbers are different. otherwise, the essence and procedure are the same for other configurations and platform versions.

Procedure:

Scanning the invoice

Recognizable in xls format.

We download from the Internet or take the processing “Loading into a spreadsheet document” from the ITS disk.

If there is no nomenclature in the directories, which is an invoice, select processing.

If, as in this example, the articles are indicated before the name of the position - in cell C26 we write in the formula “= MID (B26; FIND (" "; B26; 1) + 1; 999)". Copy this formula to the remaining rows in column C. Next, copy from column C to processing.

If the amounts are recognized as text, then in an empty column we write the formula “=K26*1” and also copy it for processing. If it doesn’t work out, we score with our hands.

To make it easier to fill in the tabular part, open the nomenclature card already in the database and rewrite the data that is filled in (accounting units, VAT, accounting account, etc.).

After you have filled in the tabular part of the work, press Download.

In 1C we start a document Purchase of materials.

In 1C, we start a document for the purchase of materials in it, the first line on the invoice.

We go to the recognized file in xls format.

If, as in this example, the articles are indicated before the position name, we write the formula “=MID(B26;FIND(" ";B26;1)+1;999)" in cell C26. Copy this formula to the remaining rows in column C. Next, copy from column C to processing.

If the amounts are recognized as text, then in an empty column we write the formula “=K26*1” and also copy it to processing

We go to processing, select the download mode in tabular part further purchase of materials and select our document, I click update.

This will show us which columns and how to fill. We also copy the lines from the recognized document there: names, units of measurement, account, quantity, VAT, amounts, etc. Click download.

Now we go to our document in 1s, check it against the invoice and post it.

P.S. This method is applicable to all types of documents that are apparently processed.

In this article, we will consider another frequently asked question by our users. It refers to a sale transaction and contains information and credentials for the item being sold. This document - . Accordingly, we will consider the creation and reflection of an expense invoice in accounting.

The process for making a sale is simple. Implementation documents include several types of documents and reports. This is an invoice, invoice, tax invoice, etc.

Today we will create an invoice.

To do this, go to the "Sale" main menu item and select the "Sale of goods and services" item. The magazine of the same name will open. You can get exactly the same result by selecting the "Sale" tab of the function panel and clicking the "Sale of goods and services" button.

The magazine "Realization of goods and services" contains sales documents in which you can print out both an invoice and an act on the provision of services, a bill of lading.

Let's create a new document by selecting the "Add" button in the log menu or by pressing the Insert button on the keyboard. As a result, the program will create a new implementation document with some default values ​​filled in.

First, we indicate the type of operation - "Sale, commission".

Fill in the rest of the details. Specify the counterparty; to which the contract with the buyer, if any, is being carried out; the warehouse from which the goods are shipped. The settlement document is indicated if the appropriate options are selected in settlements with the counterparty and/or the accounting policy settings.

After adding the position of the item to be sold, specify the quantity and the program will calculate the positions according to the tabular part automatically. This will happen if you fill in the necessary details in the stock list reference book for the goods. You can read how to fill out the nomenclature reference book in our article -

Do not forget to scroll the horizontal slider of the tabular part of the document window to control and fill in all the accounting parameters.

Next, we go through the bookmarks, indicate the container if necessary, check and correct the expense accounts filled in by the program, verify and fill in additional details. On the "Additional" tab for the TTN, you can fill in the values ​​​​of the consignee and the delivery address. On the "Print" tab, you can fill in the information about the power of attorney and the data of the person receiving the goods.

We check the entered details of the header and filling in the tabular part. If everything is correct, click the "Record" button. If we do not plan to print the document in physical form at the moment, then we can click the "OK" button, after which the created document will be written and closed.

We are planning to print the invoice. Therefore, after pressing the "Record" button and some waiting, which means saving the document, we press the "Invoice" button in the lower menu. If you need to print documents of a different type, they can be selected from the menu displayed by clicking the "Print" button.

A printed form of the invoice is formed.

The result of the transaction can be viewed both in the journal of consumable documents and in the top menu of the document itself.

On this, in fact, the creation of the invoice is completed.