Make a request for an invoice 1s 8.3. Accounting info. Creating a Requirement-Invoice document based on another document

Selection of materials for writing off in 1C: Accounting (8.3, 8.2, editions 3.0 and 2.0)

2016-12-07T17:06:05+00:00

Often, accountants need to write off materials through a requirement-invoice for a certain amount, or even write off all available materials.

This processing allows you to easily and visually select the right amount of the right materials, which hang in the balance on the right account (for example, 10.1). Processing is suitable for "two" and "three" at the same time.

I'll show you with an example.

Open processing. We select the organization, the day on which we will write off and the account from which we will write off the materials.

Click the "Fill" button:

Processing automatically filled in the tabular part for us with the balances on account 10.1 in the context of warehouses on September 4 for our organization:

Now, right in the tabular part, we remove unnecessary materials (using the "Delete" button or the "Delete" key) and adjust the number of remaining ones, if necessary.

Then we press the "Create Invoice Requirement" button - the "Requirement-Invoice" document will be automatically created, already filled with our data. It turns out very convenient.

Here is the processing itself (separate for "three" and "two"):

Download for troika

Important#1! If an error occurs when opening processing " Access Violation" about what needs to be done.

Important#2! When any other error after opening or during processing - follow .
Healthy!

Download for deuce

Healthy!
Sincerely, Vladimir Milkin(teacher and developer).

When to write off materials from account 10

The question of when to write off materials from account 10 may arise with an accountant in two cases:

  • When it is necessary to give materials to production to create finished products, provide services or perform work. Common examples: writing off stationery in the office, auto parts for cars and machine tools, concrete in construction, various low prices (MBP), etc.
  • When there is a shortage of materials in the warehouse or materials become unusable. Based on the results, materials should be written off as other expenses.

What document in 1C to write off materials for production

In each case, write-offs of materials from account 10 of the posting are formed according to the Kt of the inventory account (account 10). In the 1C Accounting 8.3 program, the following documents are used when writing off materials:

  • If the materials are put into production, it is used;
  • If the materials are written off for shortages or become unusable, the document “Write-off of goods” is used.

Document requirement invoice in 1C 8.3

So, the materials are put into production. Consider the write-off of goods and materials into production step by step in the program 1C Accounting 3.0.

Step 1. We form the document Requirement-invoice

We select the section Production - Production release - Requirement-invoice:

On the screen: List of documents. We press the button Create:

Step 2. Fill in the title of the document Requirement-invoice

  • In field Number
  • In field " from"- indicate the date, month and year of the document;
  • In field Stock- reflects the warehouse for placing materials:

Step 3. Fill in the document table Requirement-Invoice

Filling out the tab materials. By button Add enter the name of the material to be written off and its quantity. The material account is filled in automatically with an invoice, :

Filling out the tab Cost account. In the graph Cost account select the expense account for writing off materials (20, 25.26). For each account, its own analytical accounting sections are used. For example, for account 26, you must fill in the fields Subdivision and :

Step 4. Posting the Document

We press the button Spend. When posting a document, postings are created for Dt cost accounts (field Cost account) and CT of the accounting account (column accounting account tables materials):

Postings can be viewed by clicking the button:

Step 5. View printable forms of the Invoice Claim document

In 1C 8.3, from the Requirement-invoice form, it is possible to print two forms:

  • Invoice requirement;
  • Standard form M-11.

Selecting a printable in the function Seal:

Printable form Requirement-consignment note in 1C 8.3:

M-11 printable in 1C 8.3:

For possible errors when writing off materials, setting a ban on writing off inventory in the absence of a balance in the warehouse, see our video:

Write-off of damaged materials in 1C 8.3

If there is a shortage in the warehouse or the materials become unusable, then, according to the results of the inventory, it is necessary to write off the materials for other expenses. Let's consider step by step how to write off materials if they become unusable in the 1C Accounting 3.0 program.

Step 1. Create a document Write-off of goods

Select the section Warehouse - Inventory - Write-off of goods:

The Document List is displayed on the screen. We press the button Create:

Step 2. Fill in the heading of the form Write-off of goods

  • In field Number– document number automatically generated by the program;
  • In field " From"– date, month and year of the document;
  • In field Stock- reflects the warehouse for placing materials;
  • In field Inventory– the Inventory document is selected, in which the shortage of materials was recorded:

Step 3. Fill in the table of the document Write-off of goods

By button Add enter the name of the material to be written off and its quantity in the table Goods. The material account is filled in automatically with the account specified in the item card:

Step 4. Posting the Document

We press the button Spend:

The document makes postings to Dt of account 94 and Kt of the accounting account (column accounting account tables Goods). Postings can be viewed by clicking the button:

Step 5. Viewing printed forms of the Goods write-off document

In 1C 8.3, two forms can be printed from the Goods write-off document:

  • Standard form TORG-16.

Select the printable by clicking the button Seal:

The form "Act of write-off of goods" from the form Write-off of goods:

What to do if an error message appears in 1C 8.3 when posting a write-off document

When posting a document, the 1C 8.3 program performs the following operations:

  • Determines if the specified warehouse has the required amount of material;
  • Estimates the average cost of scrapped material.

Often, when posting a scrapped document, you can see an error message, for example: "Failed to post" Requirement Invoice<Номер документа>from<Дата документа>!» :

We press the button OK . Prompt messages appear on the screen:

The 1C 8.3 program informs that the required amount is not in the balance:

  • specified material;
  • In the specified warehouse;
  • on the specified account.

A standard report will help you find out the cause of the error. Subconto analysis. Let's generate this report in 1C 8.3 and make small settings for it.

Step 1. Specify the report period and subconto type

For our example, set the period: 01/01/2016. – 31.01.2016 Choose the type of subconto- Nomenclature:

Step 2. Fill in the report settings

Let's make the settings by clicking the Show settings button:

Subconto types tab. By button Add fill in the subconto Nomenclature and Warehouses:

Bookmark grouping:

  • Set the checkbox By sub-accounts;
  • Select the fields by which the data will be grouped - Nomenclature and Warehouses:

Bookmark Selection we turn on the selection according to the required nomenclature. For example, paper "Snow Maiden":

Bookmark Indicators:

  • Set the checkbox BU (accounting data);
  • Check the Quantity box:

Step 3. We generate a report

We press the button Form:

On the screen: Report Subconto analysis Nomenclature, Warehouses for 01/01/2016. -31.01.2016:

Step 4. Analyzing report data

In our example, in the form of the Requirement-invoice document, we tried to write off two packages of the Snegurochka paper from the main warehouse, while the accounting account 10.06 was indicated. However, the report shows that in the main warehouse on account 10.6 there is 1 pack of Paper "Snegurochka", and in the production warehouse - 25 packs. Therefore, the accounting account should be 10.01.

In this article, we will analyze the procedure for writing off materials in 1C Accounting (using the example of a BP 8.3 configuration), and also give step-by-step instructions for writing off. First, consider the methodological approach from the point of view of accounting and tax accounting, then the user's procedure for writing off materials in 1C 8.3. It should be noted that the general procedure for writing off materials is being considered, without taking into account certain industry-specific nuances. For example, a development, agricultural or manufacturing enterprise requires additional standard documents or acts for the write-off of materials.

Methodological guidelines

In accounting, the procedure for writing off materials is regulated by PBU 5/01 “Accounting for inventories”. According to paragraph 16 of this PBU, three options for writing off materials focused on:

  • the cost of each unit;
  • average cost;
  • the cost of the first in time acquisition of inventory items (FIFO method).

In tax accounting, when writing off materials, one should be guided by Article 254 of the Tax Code of the Russian Federation, where, under paragraph number 8, options for the assessment method are indicated, focusing on:

  • cost per unit of inventory;
  • average cost;
  • cost of first-in-time acquisitions (FIFO).

The accountant should fix in the accounting policy the chosen method of writing off materials for accounting and tax accounting. At the same time, it is logical that in order to simplify accounting in both cases, the same method is chosen. Often used to write off materials at an average cost. Write-offs at unit cost are appropriate for certain types of industries where each unit of material is unique, such as jewelry.

Account debit

Account credit

Wiring Description

Write-off of materials for the main production

Write-off of materials for auxiliary production

Write-off of materials for general production costs

Write-off of materials for general expenses

Write-off of materials for expenses related to the sale of finished products

Disposal of materials upon their gratuitous transfer

Write-off of the cost of materials in case of their damage, theft, etc.

Disposal of materials lost due to natural disasters

Standard postings for the write-off of materials

Before writing off materials in 1C 8.3, you should set (check) the appropriate accounting policy settings.

Accounting policy settings when writing off materials in 1C 8.3

In the settings we will find the submenu "Accounting policy", and in it - "Method of assessing the inventory".

Here you should remember a number of specific features characteristic of the 1C 8.3 configuration.

  • Enterprises in the general mode can choose any method of assessment. If you need a valuation method based on the cost of a material unit, you should choose the FIFO method.
  • For enterprises on the simplified tax system, such a method as FIFO is considered the most suitable. If the simplification is 15%, then in 1C 8.3 there will be a strict setting for writing off materials using the FIFO method, and the choice of the “Average” assessment method will not be available. This is due to the peculiarities of tax accounting under this taxation regime.
  • Pay attention to the auxiliary information 1C, which says that only according to the average, and nothing else, the cost of materials accepted for processing is estimated (account 003).

Write-off of materials in 1C 8.3

To write off materials in the 1C 8.3 program, you must fill out and post the document "Requirement-invoice". The search for it has some variability, that is, it can be done in two ways:

  1. Warehouse => Requirement-Invoice
  2. Production => Requirement-Invoice


We create a new document. In the header of the document, select the Warehouse from which we will write off the materials. The "Add" button in the document creates records in its tabular part. For the convenience of selection, you can use the "Selection" button, which allows you to see the remaining materials in quantitative terms. In addition, pay attention to the related parameters - the tab "Cost accounts" and the checkbox setting "Cost accounts on the "Materials" tab". If the checkbox is not checked, then all positions will be debited to one account, which is set on the "Cost Accounts" tab. By default, this is the account that is set in the account policy settings (usually 20 or 26). This indicator can be changed manually. If you need to write off materials for different accounts, then check the box, the "Accounts" tab will disappear, and on the "Materials" tab it will be possible to set the necessary transactions.


Below is the form screen when you click the Pick button. For the convenience of work, in order to see only those positions for which there are actual balances, make sure that the "Only balances" button is pressed. We select all the necessary positions, and with a mouse click they fall into the "Selected positions" section. Then click the "Transfer to Document" button.


All selected items will be displayed in the tabular part of our document for the write-off of materials. Please note that the parameter “Cost accounts on the “Materials” tab” is enabled, and from the selected positions “Apple jam” is written off to the 20th account, and “Drinking water” to the 25th.

In addition, be sure to fill out the sections "Cost division", "Nomenclature group" and "Cost item". The first two become available in documents if the settings are set in the system parameters "Keep cost records by departments-Use several product groups". Even if you keep records in a small organization where there is no division into item groups, enter the “General item group” item in the help and select it in the documents, otherwise problems may arise when closing the month. At larger enterprises, the correct maintenance of this analytics will allow you to quickly receive the necessary cost reports. A cost unit can be a shop floor, a department, an individual store, etc., for which you want to collect the cost amount.

The nomenclature group is associated with the types of products produced. By product groups, the amount of revenue is reflected. In this case, for example, if different shops produce the same products, one item group should be indicated. If we want to see separately the amount of revenue and the amount of costs for different types of products, for example, chocolate and caramel candies, we should establish different item groups when releasing raw materials into production. When specifying cost items, be guided at least by the tax code, i.e. you can specify the items "Material costs", "Labor costs", etc. This list can be expanded depending on the needs of the enterprise.


After specifying all the necessary parameters, click the "Submit and close" button. Now you can see the wiring.


With further accounting, if you need to issue a similar invoice requirement, you can not create the document again, but make a copy using the standard features of the 1C 8.3 program.



Algorithms for calculating the average price

Algorithm for calculating the average price, on the example of the position "Apple Jam". Before the decommissioning, there were two receipts of this material:

80 kg x 1,200 rubles = 96,000 rubles

The total average at the time of debiting is (100,000 + 96,000) / (100 + 80) = 1088.89 rubles.

We multiply this amount by 120 kg and get 130,666.67 rubles.

At the time of writing off, we used the so-called moving average.

Then, after the write-off, there was an incoming:

50 kg x 1,100 rubles = 55,000 rubles.

The weighted average for the month is:

(100,000 + 96,000 + 55,000) / (100 + 80 + 50) = 1091.30 rubles.

If we multiply it by 120, we get 130,956.52.

The difference 130,956.52 - 130,666.67 = 289.86 will be written off at the end of the month when performing the scheduled operation Adjustment of the cost of the item (the difference of 1 kopeck from the calculated one arose in 1C during rounding).



In this case, the cost of expenses per month will be as follows:

100 kg x 1,000 rubles = 100,000 rubles

20 kg x 1,200 rubles = 24,000 rubles

The total result is 124,000 rubles.



Important addition

The formation of invoice requirements and their use for write-off requires the fulfillment of an important condition: all materials written off from the warehouse must be used for production in the same month, that is, their full cost write-off to costs is correct. In fact, this is not always the case. In this case, the transfer of materials from the main warehouse should be recorded as a transfer between warehouses, to a separate sub-account of account 10, or alternatively, to a separate warehouse on the same sub-account on which it is recorded. With this option, materials should be written off for costs by an act for writing off materials, indicating the quantity actually used.

The version of the act printed on paper should be approved in the accounting policy. For this, 1C provides for the document “Production report for a shift”, through which, for manufactured products, you can write off materials manually, or, if standard products are produced, draw up a specification for 1 unit of production in advance. Then, when specifying the quantity of finished products, the required amount of material will be calculated automatically. This work option will be discussed in more detail in the next article, which will also cover such special cases of write-offs of materials as accounting for workwear and write-offs of customer-supplied raw materials.

The requirement-invoice document is needed to account for the movement of valuables, write-off of inventories, posting of balances and waste within the organization.

Write-off of materials for household needs

Let's consider how to make an invoice requirement in the 1C:Enterprise accounting program, as well as how to fill it out, using the example of writing off materials for the administrative needs of a company.

To create a document, go to the menu item "Warehouse" and follow the hyperlink to the document journal "Requirements-invoices".

Fig. 1 Window of the program "1C: Accounting", menu item "Warehouse"



Fig.2 Creating a document

Pay attention to the button next to the "Create" button.

This is the copy button. If you have to fill out documents with the same nomenclature, for example, write off gasoline every month, then you can simply copy the previous document by correcting the quantity in it.

In the form that opens, fill in the necessary details - the date of the document, the warehouse from which the materials will be debited, and using the "Selection" or "Add" button, select the nomenclature for debiting or transferring.



Fig.3 Filling in the details of the "Demand-invoice"

Please note that if the checkbox “Cost accounts on the Materials tab” is not checked, then write-off accounts are filled in on a separate tab of the document - “Cost accounts”, which are set in accordance with the accounting policy of your company.



Fig.4 Filling in details

When selecting an item (the “Selection” button), by selecting an item group in the window on the left and clicking the “Only balances” button, in the right part of the window we can see the current balances for the selected warehouse. The "Settings" button has a checkmark - "Request quantity" (if not, you can check it). In this case, when you select an item, a dialog box will appear where you enter the number of units to add to the document. The selected items will be preliminarily displayed at the bottom of the selection window. Then, using the "Transfer to document" button, they get into the tabular part.



Fig.5 Item selection window



Fig.6 Dialog box for selecting the number of item units

From the document, you can print the "Demand-Invoice (M-11)" form and a simple printed form "Demand-Invoice" by clicking the "Print" button.



Fig.7 Selecting a printable



Fig. 8 Requirement-invoice M-11



Fig. 9 A simple printed form of the document "Invoice request"

Creating a Requirement-Invoice document based on another document

There are many useful functions in 1C programs, one of which is document input based on. So, the document we are considering can be entered on the basis of the previously executed document “Receipt (act, invoice)”. To do this, open the receipt document (from the "Purchases" section) (Fig. 10) and click the "Create based on" button. From the list, select the document "Requirement-invoice" and, if necessary, edit it.



Fig. 10 Window of the program "1C: Accounting", menu "Purchases"



Fig.11 Document selection menu "Create based on"



Fig. 12 The document "Demand-invoice" created from the document "Receipt (act, invoice)"

Creation of the document "Requirement-invoice" on the basis of other documents in production activities

Also, the document "Requirement-invoice" is available in the menu item "Production". And if the enterprise is engaged in production activities, then there are several more options for processing this document, and the materials that were spent by the production workshop can also be written off through this document. Another document can be entered manually or based on the documents “Production report for a shift”, “Provision of production services”, “Sale of processing services”.



Fig. 13 Window of the program "1C: Accounting" - menu item "Production"

Let's consider the creation of the document "Requirement-invoice" based on the "Production report for the shift".

The program provides for two ways to release finished products:

  • 1 way with write-off of materials. In this case, they are filled in according to the specification in the document "Production report for the shift";
  • Method 2 without writing off materials. Here, materials can be written off on the basis of the “Shift production report” by our document.

In our example, in accordance with the accounting policy, the formation of the cost of finished products is carried out at the planned cost per unit of production without using account 40. In the future, we need to issue a “Requirement-invoice” and write off materials for the release of this product. From the production, the products “French Bun” were released and capitalized earlier with the document “Production report for the shift”. To create our document and write off materials in the “Production report for a shift” document, click the “Create based on” button and select the appropriate document.



Fig. 14 Creation on the basis of the "Production report for the shift"

In the “Invoice-requirement”, the tabular part was filled in according to the product specification specified in the “Production report for the shift”.



Fig.15 Completed document form

Each line contains the “Cost Account”, to the debit of which all materials will be written off in accordance with the accounting policy of the enterprise (in our example, this is account 20.01 - “Main production”), as well as the “Nomenclature group” and “Cost item”. So, the document reflects the postings for the write-off of materials into production. Button "Show postings and other movements of the document":



Fig. 16 Accounting entries generated by the document "Demand-invoice"

Write-off by "Demand-consignment note" of customer-supplied materials

The program provides for the ability to keep records of operations for the processing of customer-supplied materials, i.e. materials transferred for processing by third-party customers. The document “Requirement-invoice” has a tab “Customer's materials”, which reflects the transfer of customer's materials to production. They are recorded on the off-balance account 003.01 "Materials in the warehouse", and transferred for processing to account 003.02 "Materials transferred to production".



Fig.17 Document "Requirement-invoice" - tab "Customer's materials"

Thus, the document "Demand-waybill" can be considered a universal document for writing off and transferring materials.

Let us consider in more detail the step-by-step instructions for filling out the invoice requirement in 1C 8.3 (Accounting).

Today we will dwell in more detail on how to fill out the “Requirement-invoice” in 1C, as they continue to ask questions about it.

So, what does this document do and where is it located in the 1C program? He writes off the materials necessary for the production of finished products from the warehouse and transfers them, respectively, to production. More precisely, it will already be considered the cost of production. As a rule, this is the debit of account 20.01 "Main production".

Account 20.01 is not quantitative, only sum. Therefore, all production costs accumulate on it: both material (direct) and indirect (costs for electricity, heating, wages for workers, etc.).

Document 1C 8.3 "Requirement-invoice" in production, you can only write off raw materials and materials. this document cannot be written off.

The cost account is indicated in the "Cost account" column of the same name in each row of the table. If you cancel the mode of specifying cost accounts in the tab with materials, the tab “Cost account” will become visible, and the column will disappear. In this tab, the cost account is indicated once, and all materials will be charged to it. This is convenient if all materials are debited to one account.

To create and fill out a document, you need to go to the "Production" menu and click on the "Requirement-Invoice" link in the "Product Release" section. After that, we will get to a window with a list of already created documents (if any). Click the "Create" button. A window for creating a new document will open.

It is necessary to fill in the details:

Get 267 1C video lessons for free:

  • Organization (if the program keeps records of several).
  • The warehouse from which the write-off will take place.

A sample of filling out an invoice requirement in 1C 8.3:

In order for the document to generate postings and thereby be reflected in the accounting, click the "Post" button.

Now you can see the postings that we generated when posting the document. Let me remind you that for this you need to click the button:

It can be seen from the figure that the cost account (20th) has analytics, or rather, three subcontos: “Unit” - we have it “Lamps”, “Nomenclature group” - in this case “Main group” and directly the name “Cost items” - for example, "Material costs".

Analytics can be useful in reports to analyze one or another subconto.

Printing form M-11 from 1C 8.3

The program has the ability to print a special form M-11. You can print it by pressing the button "Print - Request-Invoice (M-11)":

In addition to the regulated form, the system also has a simplified, “administrative” printed form - it is the first in the list.

And this is how the form Requirements-invoice M-11 printed from the program 1C 8.3 looks like: