Reflection of turnover in the accounting model. Reflection of turnover in the accounting model How to make the movement of goods in 1 s

Consider the possibilities of a typical configuration “Trade Management ed. 10.3" on the movement of goods between warehouses within the same organization in the following example.

  • On February 10, 2012, the following samples of equipment for sale were transferred from the warehouse of electrical goods to the showroom: 1 Jiponic fan (Taiwan), 1 table fan and 1 Moulinex combine.
  • On Feb. 10, the showroom placed an internal order to receive 1 Binatone Mixer and 1 Jacobs Coffee Maker on Feb. 11. The goods have been reserved at the main warehouse.
  • On February 11, the mixer and coffee maker were handed over to the showroom.
  • On February 12, a Binatone food processor was transferred from the main warehouse to the showroom, and the delivery from the warehouse and the acceptance to the showroom were registered separately using incoming and outgoing warehouse warrants.
Preparation for the movement of goods: accounting for samples in the showroom

To be able to keep track of goods in the showroom, you must register it in the program as a warehouse.

Menu: Directories - Enterprise - Warehouses (storage places)

Let's add a new warehouse and name it Showroom.

Since we are not going to sell samples through the showroom, we indicate the type of warehouse: wholesale, we do not fill in the price type. (If such sales were carried out, it would be necessary to specify the type of warehouse as “retail” and then register sales from it as from a retail outlet).

Important: You can change the warehouse type only as long as there has not been a single operation for this warehouse. After carrying out at least one operation on a warehouse, it will become impossible to change the type of this warehouse!

The fields "Responsible person" and "Subdivision" are optional, but they can be used when filling out printed forms and generating reports.

Save and close with the OK button.

Movement of goods without prior internal order

The transfer of goods from one warehouse to another is documented by the document "Movement of goods". Let's use it to reflect the transfer of samples to the showroom.

Menu: Documents - Stocks (warehouse) - Goods movements

Let's add a new document dated 10.02.12. Specify the sender warehouse - Warehouse of electrical goods, the recipient warehouse - Showroom.

The tabular part is filled with goods that were transferred to the showroom.

We post the document by clicking the "Actions - Post" button or using "OK". The transfer of goods to the showroom is reflected in the program.

By the "Print" button at the bottom of the document, we look at the printed forms: "Movement of goods", TORG-13, M-4 and others.

If necessary, you can set the default printing form: click "Print", select the printing form in the list, click "Default", close. Now the printing form is displayed by default on the button next to "Print", by clicking this button it will be generated.

Now let's check the correctness of the movement of goods using the report "Statement of goods in warehouses".

Menu: Reports - Stocks (warehouse) - List of goods in warehouses

We will form in one day - 10.02.2012. The report reflects the arrival of two fans and a combine in the exhibition hall and the consumption in the warehouse of electrical goods:

Preparation for the movement of goods using internal orders and reservation of goods

The program allows you to place internal orders for the transfer of goods from one warehouse to another, while automatic reservation of goods occurs. This means that this product will be saved for a specific recipient and no one else but him will be able to receive it. We will issue an internal order for the receipt of goods by the showroom.

Menu: Documents - Stocks (warehouse) - Internal orders

Let's add a document dated 10.02.12. Shipment date - 11.02.12. Customer - to the warehouse - Showroom.

In the tabular part, we indicate the required goods and their quantity. In the "Placement" column, a warehouse or order is indicated for placing our order and reserving goods. It can be filled in manually, but it can also be filled in automatically - the program will analyze which warehouse has the necessary goods in stock and place an order in this warehouse.

Let's use this. Click the "Fill and post" button at the top of the document. In the form that appears, there should be checkboxes for placement, reservations, placement strategy - "first in warehouses then in orders to suppliers." Click "Fill and post".

The document has been posted. At the same time, in each line in the "Placement" column, a warehouse appeared where the program found this product - in our example, this is the main warehouse. Now, in this warehouse, these goods are reserved for the showroom.

The document has a printed form "Internal order".

Important: in the case of manually filling in the “Placement” column, you must first, by pressing the “T” button, select the type of placement (in a warehouse, in an order to a supplier, in an internal order), and only then specify a specific warehouse or order:

Item reservations can be analyzed. Let's press the "Analyze" button at the top of our "Internal Order" document. The report "Analysis of the internal order" has been generated, from which it is clear that the order has not yet been completed.

This report can also be generated separately.

In addition, reserved goods can be seen in the Goods in reserve in warehouses report:

Menu: Reports - Inventory (warehouse) - Goods in reserve in warehouses

We will form on 11.02.12:

The goods in the reserve and the reservation document are reflected.

Movement of goods by internal order

The movement of goods by internal order can be reflected in the program in two ways:

Based on the document "Internal order". Create manually and autofill.

Let's try the second option.

Let's create a new document "Movement of goods" dated 11.02.12. Shipping warehouse: main warehouse, recipient: showroom. In the "Internal order" field, select our order dated 10.02.12

Important: the program "sees" only internal orders corresponding to the warehouses specified in the document. Therefore, if warehouses are specified incorrectly, internal orders will not be reflected in the list. If warehouses are not specified at all, all orders will be displayed in the list.

For automatic filling, press the button "Fill - Fill in by internal order". The tabular part was filled with the goods specified in the order.

We carry out the document as usual. The movement of goods to the showroom is registered in the program.

The movement of goods from the main warehouse to the showroom is reflected in the report "Statement of goods in warehouses":

The execution of an internal order is reflected in the report "Analysis of internal orders".

Menu: Reports - Inventory (warehouse) - Analysis of internal orders

Form for February:

It remains to be completed: 0 - means that the internal order has been completed.

Staged movement of goods with the execution of warrants for goods

If it is necessary to record separately the fact of the issue of goods from one warehouse and the fact of its acceptance to another warehouse, in the program, in addition to the document "Movement of goods", the documents "Outgoing order for goods" and "Incoming order for goods" are drawn up.

Let's reflect the issuance of the Binatone combine from the main warehouse and its acceptance to the showroom by orders.

First, let's create the document "Movement of goods" dated 12.02.12.

It is necessary to change the type of document operation: click on the "Operation" button and select "Goods by orders" (the operation type is displayed in the header). Now the document "Movement of goods" will not register the fact of movement itself, this will require warrants.

We fill out the document and conduct it as usual.

We will generate the report "Statement of goods in warehouses" for 12.02.12. The movement of the combine from the main warehouse to the showroom has not yet been reflected:

To register the issuance of a combine from the main warehouse, the document “Goods issue note” is required. Let's enter it on the basis of "Movement of goods" (in the document "Movement of goods" click Actions - On the basis of - Outgoing order for goods). A completed document with the operation type "Move" has been created. Date 12.02.12.

The document has a printed form "Expense order", as well as other printed forms available by clicking the "Print" button. We post and close the document.

We will generate the report "Statement of goods in warehouses" for 12.02.12. Reflected issuance of the combine from the main warehouse:

Now it is necessary to formalize the acceptance of the combine to the showroom using the document "Incoming order for goods". Let's also introduce it on the basis of "Movement of goods". A completed document has been created with the operation type "transfer". Date 12.02.12.

The document has a printed form "Incoming order", as well as others. We post and close the document.

We will generate the report "Statement of goods in warehouses" for 12.02.12. Now both the issuance of the combine from the main warehouse and the arrival to the showroom are reflected:

You can find the incoming and outgoing orders that we entered based on the movement of goods through the menu.

Menu: Documents - Inventory (warehouse) - Receipt orders for goods

Menu: Documents - Stocks (warehouse) - Goods issue orders

In addition, all warehouse documents are displayed in the corresponding thematic journal.

Menu: Documents - Stocks (warehouse) - Journal "Warehouse documents":

The movement of exhibition samples from the exhibition hall back to the warehouses of the organization is formalized with similar documents.

Each trading or manufacturing company has a warehouse where goods and materials are stored, and it often happens that control and accounting in this warehouse leave much to be desired.

The director once again calls in a programmer, a database operator and a storekeeper and tries to understand why no one in the company knows the stock balance. The manager looks at the stock balance reports generated in the database and realizes that they are not true. The storekeeper takes inventory and confirms this unfortunate discrepancy. A familiar situation, isn't it? The leader must understand who is to blame - the people or the program. By posing the question in this way, we are already making a mistake. The truth, as always, is somewhere in the middle.

So let's look at the methodology warehouse accounting, requirements for accounting systems, as well as the interaction of company employees with each other and the accounting program. Let's try to figure out how the program should look like, which would correctly reflect the state of the warehouse and allow you to see the company's turnover. To complete the picture, we present options for maintaining inventory records in companies of different levels.

The first and easiest option is when we have a small warehouse in a small company with a limited range of about 100 items. At the same time, we make the assumption that goods arrive and depart from the warehouse only with accompanying documents - incoming and outgoing invoices. In this case, we have the following accounting model (Fig. 1). The receipt of goods at the warehouse is accompanied by waybills, which are accepted and checked by the logistician. The sales manager conducts trade according to warehouse balances, forming invoices for sales.

Rice. 1. Simplified inventory model

In this case, as a rule, significant efforts are not required to automate a warehouse section - a correct registration of primary documents for receipt and write-off by a logistician and sales manager is sufficient. You can use any program that has an incoming and outgoing invoice and a mechanism that allows you to calculate inventory balances. In addition, it would be nice to provide documents that allow you to fix deviations between the actual balances in the warehouse and the balances reflected in the database, i.e. once a week or a month, recalculate the goods in the warehouse and record discrepancies, if any. To bring the data in the database in line with reality, the surplus of goods is accounted for and the shortage is written off:

  • inventory allows you to fix the discrepancy between the credentials and the fact;
  • posting ensures accounting of the surplus of goods found in the warehouse;
  • when writing off, a shortage is recorded.

So, we have dealt with the documents with the help of which the movement of goods is recorded. The quantity of goods can always be counted and, if necessary, correct discrepancies. All data on the turnover in the warehouse can be summarized in Table. one.

Table 1. Accounting for goods

Summing up the "Quantity" column for each product, we get its remainder.

However, the considered model is oversimplified. For example, we are interested not only in the quantity of a product, but also in its cost. This is necessary at least in order not to trade at a loss, i.e. it is necessary to store information on how much the goods are stored in the warehouse and at what cost price we sell them. Let's add the column "Amount" in the table. 1 (Table 2).

table 2

In the "Amount" column on receipt, you should record the cost of the entire lot of the received goods, and not the price per unit, otherwise it will be difficult to obtain the correct total for this column. Thus, by the column "Amount" you can determine how much the goods are stored in the warehouse. But in order to calculate the cost of goods in the warehouse, when debiting, you need to set the amount by which its total balance is reduced, and for this you can use one of three methods: FIFO, LIFO or “average”. Let's consider them.

To calculate the cost of shipped goods using the "average" method, at the time of shipment, it is necessary to determine the balance of the goods in the columns "Quantity" and "Amount". The cost of the written-off goods is calculated by the formula:

In our case, for the product T1, the cost price "according to the average" will be equal to (Table 3):

The FIFO and LIFO methods use the principle of batch accounting. Each receipt of goods is considered a batch. For each batch, cost accounting is kept. At the time of sale of the goods, the cost is written off in the context of batches.

The FIFO (First Input First Output) method implies that the earliest receipt of goods is written off first (Table 4). Let's add the column "Party" in the table. 3 and calculate.

Table 4

The LIFO (Last Input First Output) method assumes that the later receipt of goods is written off first (Table 5).

Table 5

As you can see, the amount of goods written off in all examples is the same, but the cost is different. However, in all cases, when all the goods received at the warehouse are written off, their cost will also be equal to zero. Methods allow you to simply regulate the method of writing off the cost of goods from the warehouse, but if they are not used, then we will never know what real profit was received.

So, for a small company, you should choose a ready-made software product that would ensure the maintenance of the accounting model described above and the accompanying workflow and cost calculation.

These requirements can be met following programs families "1C:Enterprise": "1C:Enterprise 7.7. Aspect”, “1C:Enterprise 7.7. Trade and warehouse", "1C: Accounting 7.7", "1C: Enterprise 7.7. Production + Services + Accounting, 1C:Enterprise 7.7. Complex configuration”, “1C: Accounting 8.0”. However, it should be noted that "1C: Accounting 7.7" makes it possible to calculate the cost only "on average".

Over time, the company expands, and with each inventory, the manager begins to realize that the discrepancy between the accounting and the actual quantity of goods in the warehouse is prohibitively large. Things have come to the point that the manager can no longer rely in his transactions on the report on warehouse balances in the database. The question arises: why the warehouse accounting model and the program that implements it do not work.

There may be several reasons: firstly, the receipt of goods at the warehouse without accompanying documents, and secondly, the discrepancy between the accompanying documents for receipt - sale and actual shipments. For example, a supplier can deliver goods in several batches at intervals of several days and issue one general invoice for it. The manager can issue one invoice for the goods, which will be taken from the warehouse in several stages, due to its shortage in the warehouse. At the same time, he is forced to issue one invoice for all goods at once in order to satisfy the requirements of the client and close mutual settlements according to financial statements.

In fact, waybills cease to be accompanying documents and become documents for the transfer of ownership. In this case, to correctly reflect the turnover, additional internal warehouse documents are introduced, i.e. all operations of receiving and leaving the warehouse are accompanied by orders for the receipt and consumption of goods. The warehouse accounting model will look as shown in Fig. 2.

Rice. 2. Warehouse accounting model

In this model, the warehouse is included in the company's document flow and generates its own documents. It follows from this that it is necessary to automate accounting in the warehouse.

Order warehouse documents should be simple and linked to the rest of the company's workflow.

  • receipt from the supplier;
  • return from the buyer;
  • receipt as a result of a transfer from another warehouse.
  • shipment to the buyer;
  • receipt from an accountable person (in the case when an employee of the company buys something for cash);
  • return to the supplier;
  • write-off as a result of moving to another warehouse.

In addition to the specified documents, it is necessary to take into account which invoices for shipment did not write off all the goods and which receipt orders were not issued with accompanying documents. To do this, the system must have appropriate reports.

The 1C company has developed the following solutions that allow you to keep order records in a warehouse: “1C: Enterprise 8.0. Trade Management" and "1C: Enterprise 8.0. Control manufacturing plant". "Manufacturing Enterprise Management" is a more comprehensive solution that includes all the functionality of "Trade Management".

If a company has grown to such a size that knowing that a product is in stock becomes irrelevant, since the warehouse itself covers a large area in several hangars, in such a situation, searching for goods can take quite long time, and inventory becomes simply impossible. The storekeeper is not able to quickly find the right product. In this case, a decision should be made to warehouse logistics, since it is necessary to track the movement of goods between cells inside the warehouse. To reduce the time spent on its movement, it is necessary to optimize storage in a warehouse, i.e. most hot commodity place in closer cells.

In this case, the accounting system does not become much more complicated, just additional tables are added that should store information about the location of the goods in the warehouse in a certain cell and about its movement through the warehouse. To reflect the turnover inside the warehouse, the following internal documents will be required (Fig. 3):

  • application for acceptance of goods;
  • a job to place goods with a route containing a list of storage bins;
  • intra-warehouse movement to reflect the movement of goods in the warehouse;
  • task for picking goods containing a list of cells from which it should be taken for shipment;
  • assembly of goods for shipment;
  • packaging of goods before shipment.

Rice. 3. Model of detailed warehouse logistics

The assembly of goods should also include the function of optimizing its movement through the warehouse and, possibly, selection by batches of receipts.

Inventory in the warehouse becomes a daily procedure that is carried out in the course of work. It is impossible to stop its work for recalculation, as was possible in previous cases, so the inventory is carried out in the following options:

recalculation of only one commodity item in the warehouse (shipment for it is blocked at this moment);

inventory within one warehouse storage area (goods turnover in this area is blocked for this time);

inventory of empty cells (cells in which there is no product are fixed).

In order for the system to be used by warehouse workers, it must have a simple interface, the ability to connect commercial equipment. The requirements set out in this model are implemented in software product"1C-Logistics: Warehouse Management", which is easily integrated into standard solutions "1C: Enterprise 8.0. Trade Management" and "1C: Enterprise 8.0. Manufacturing enterprise management.

Thus, we considered three models of warehouse accounting in order of increasing complexity (Fig. 4).

Rice. 4. Three models of inventory control

Based on the analysis of these models, we can conclude that the greater the turnover in the company, the more intermediate stages and states appear in seemingly simple operations of receipt and write-off of goods in the warehouse. To correctly track the status of receipts and shipments and the history of trade, you should enter specialized internal documents. To increase the speed of work, it is logical to form these documents in the database and display them for the company's employees in the most accessible form.

Automation of models will reduce the time of communication between company employees and warehouse workers, increase labor productivity. However, when automating accounting, some restrictions are imposed on the sequence of actions of employees. How fully the possible warehouse situations are reflected in the system model and how exactly the instructions are followed by the company's employees, how accurately the system "reflects" warehouse balances.

Therefore, for competent warehouse automation, it is necessary to understand how often situations arise that are omitted, simplified in this accounting model. If the simplified model ceases to work, then it is necessary either to change the model towards a more complex one, or to restrict the actions of employees more strictly so that these actions fit into the rules and assumptions. accounting model.

Limiting the choice of actions, of course, makes the company less flexible, but it avoids the destructive process of thinking employees over the question “what to do?”. If the model and instructions of employees are thought out in advance, then it will be possible to always have accurate data on the state of the warehouse.

A. Okunev
"Softek" company

Goods in an organization can move between any warehouses: from wholesale to retail, from wholesale to wholesale, from retail to wholesale, and so on. In 1C, the movement of goods must be fixed in order to have up-to-date information about stock balances and conduct analytics. Consider how to arrange the movement of goods, and what are the nuances when moving goods between warehouses. To reflect the movement of goods in 1C 8.3, the document "Movement of goods" is provided, which is located in the "Warehouse" menu in the section of the same name:


When you go to the section, a list of goods movements opens. To create a new move, you need to use the "Create" button:


A new transfer document opens, where the date, document number and organization within which the goods are transferred are already filled in by default. If you work with several organizations, then you need to choose the right one. Further, in the header of the document, the sending warehouse and the receiving warehouse are indicated:


This is the easiest way to move. For example, between wholesale warehouses. In this case, the account remains unchanged, only the analytics for this account changes. For this operation, the heading of the document indicates the wholesale warehouse-sender and the wholesale warehouse-recipient. Further, in the tabular part, a product is selected (by pressing the "Add" button), its quantity is indicated. But the accounts of the sender and recipient remain the same:


pops this document recorded, checked and carried out. In 1C, postings for the movement of goods look like this:


As you can see, the accounting account has not changed, only the warehouse has changed.

before moving the goods, it is necessary to check its availability in the warehouse of the sender. If you carry out the transfer at least a second before the goods arrive at the shipping warehouse, 1C will not be able to fill in the amount of the transfer.

This is also true when an organization uses 1C in the cloud and at the same time the operation of moving the same product can be performed by several people. When carrying out a transfer from a warehouse where there are not enough balances of this item, this position will be reflected in accounting with a negative quantity.

Movement of goods with changes in accounting accounts and prices

For example, from a wholesale warehouse, goods are sent to a retail warehouse for the purpose of subsequent sale to end customers. In this situation, the price of the product changes - as usually when retail sales there is a markup. Also, the goods can be turned into material, for this, in the tabular part of the document, you need to change the accounting account in the recipient's warehouse. Let's continue with the example of sending goods to retail.

To move the goods in this case, the same document “Movement of goods” is used, its header is filled in in the same way as described above. The desired retail warehouse is specified as the recipient.

But the type of prices for this warehouse is set by the document "Setting item prices". Thus, for each warehouse that is used in the organization, you can specify its own price type.


As a result, the goods will arrive at the retail warehouse with prices at which retail sales will be conducted in the future.

6.1. Formation of reports on the movement of goods

Using the report "Statement of inventory balances" you can control information about the movement of inventory in a particular warehouse, for a particular company. You can also control information about the movement of goods and materials in the context of various analytical features management accounting. Using filters in the report, you can display information only on the movement of goods and materials in a specific warehouse (or in several warehouses using a multiple filter). This report is entered from the item "Statement of inventory balances" of the main menu of the "Reports" program.

The data in the report can be presented in both basic and major units of measure. In the event that base units of measurement are set for the report, it is possible to display quantitative totals for each of the inventory groups in the report. To do this, set the flag "Results by groups". To get a more complete picture of the movement of goods and materials, you can set the flag "Show balances with commission agents" and get information not only about the movement of your own goods and materials in warehouses, but also about the transfer of goods and materials for sale to commission agents. On the "Multiple filter" tab, the user can set special filter parameters for generating a report - By item, By warehouse, By item properties, By company, By legal. persons, According to management analytics. At the same time, in the “List of selected elements” report form window, it is possible to select specific values ​​or a list of values ​​corresponding to the selected type of filter. It should be noted that both elements of the directory and groups of elements can act as the values ​​of the selected elements.

– Firm / Warehouse / Item property / Item / movement documents - information about the warehouse and item. If the appropriate detailing is specified, then information about the company, the property of the item and the document of the movement, according to which the movement of goods and materials was carried out through warehouses, is displayed.

– Starting balance – inventory balance at the beginning of the reporting period.

– Incoming – the amount of goods and materials received (purchased or moved from another warehouse) to the warehouse for reporting period.

– Consumption – the amount of goods and materials written off (sold or moved to another warehouse) from the warehouse for the reporting period.

– Closing balance – inventory balance at the end of the reporting period.

– Ending reserve - the balance of the reserve of goods and materials at the end of the reporting period.

In the report "Remains of goods and materials" you can display data on the balances of goods and materials with distribution by warehouses. This report is entered from the "Remains of goods and materials" item of the main menu of the "Reports" program. The report presents both quantitative and sum indicators of goods and materials. The price and the cost of goods left in warehouses are calculated based on the price value specified in the report settings: cost price with VAT, cost price without VAT, price from the price guide. For retail warehouses, the report can show the price at which goods and materials are stored in a retail warehouse and the amount. In this case, you must select the value of the "Price" column: selling price (retail only). When you select the value of the column "Price": "from the price guide", an additional window opens in which you must select the type of price from the drop-down list. The list displays all types of prices specified in the corresponding reference book (Purchase, Small wholesale, Wholesale, Retail). The price and cost of goods and materials when choosing a price from the directory is displayed in the currency that is set for this price type in the directory. In the event that it is necessary to control only quantitative balances, for the “Price” column, you can select the “do not show” value. In this report, you can set a filter for inventory balances in the warehouse. For wholesale warehouses, you can set a filter by the availability of goods and materials, taking into account reserved goods and materials. In this case, it is necessary to set the value “minus reserves” in the “Balances” field. With the help of this report, you can control information about the balance of goods and materials in a particular warehouse, for a particular company. You can also control information about inventory balances in the context of various analytical features of management accounting. To get a more complete picture of the movement of goods and materials, you can set the flag in the "Show balances from commission agents" field and get information not only about the balances of your own goods and materials in warehouses, but also about the balances of goods and materials transferred for sale to commission agents.

Information that is generated in the report:

– Goods and materials – a group of goods and materials, the full name of goods and materials or a group of goods and materials.

– Price – this column appears if the price display setting is set (any value is selected, except for “do not show”). Prices will be shown in the currency that is defined for this price type in the directory.

– Cost and selling price (sales price) for retail is shown in currency accounting. In the event that goods and materials are stored in a retail warehouse at different prices, then the inventory balances will be shown at each price at which there are inventory balances in the retail warehouse.

– Name of the warehouse (commission agent) – the quantity and amount of goods and materials in the warehouses as of the date the report was generated.

By button<Инвентаризация>the user can generate the document "Inventory by warehouse" based on the data obtained from the report.

The report "Batch of goods and materials" presents not only quantitative, but also total indicators of goods and materials. This report is entered from the item "Statement of goods and materials batches" of the main menu of the "Reports" program. With the help of this report, you can find out how much goods and materials are listed for a certain material person, find out from which supplier the goods and materials were received, how much the goods and materials were spent at cost for a certain period, etc. The amounts in the report can be calculated in the currency of management accounting ( Upr. accounting) or in the currency of accounting (Accounting.). In the event that the amounts are calculated in the accounting currency, they can be shown with or without VAT (Accounting (with VAT) or Accounting (excluding VAT)). You can select various data in the report using filters. You can select information on purchased goods and materials, accepted for the sale of goods and materials, as well as information on various materials, product, service, semi-finished product or container (Batch status parameter). You can select information on one financially responsible person or an arbitrary list of financially responsible persons (parameter "MOL"). You can generate data on transactions registered in one company that is part of the company (Firm), on transactions registered by a legal entity (Legal entity) or on transactions that have a certain analytical attribute (Management analytics). With the help of detailing and grouping in the report, you can get a variety of information. For example, if you set the detailing Supplier - Nomenclature - Movement documents, you can get information about which goods and materials were purchased from the supplier and what documents were issued at the same time. If you set the detail MOT - Nomenclature, and set a filter by groups of goods and materials, or by an arbitrarily selected list (on the "Multiple filter" tab), then you can get information about how much in the currency of management accounting these goods and materials are credited to materially responsible persons. To obtain more visual information in reports, it is not recommended to set the detailing for a large number of parameters, this will lead to cumbersome presentation of data in the report, i.e. information from the generated report will be difficult to analyze. If you check the box "Detailed by transactions", you can get more detailed information on all transactions that were made during the reporting period. For example, in this case, the “Incoming” column will be detailed to the level of specific operations for the receipt of goods and materials, the transfer of goods and materials to retail, the assembly of kits, the posting of goods and materials, etc. The corresponding columns will present the amounts in accordance with the selected accounting currency (“Management accounting ”, “Accounting with VAT”, “Accounting without VAT”) for each operation. If detailing by movement documents is specified, then the corresponding amounts will be displayed for each document. Quantitative characteristics in this report are displayed if any batch parameters are set, for example, a specific batch status is selected, drilldown is set by batch status, drilldown is set by batch properties.

In this report, it is also possible to drill down on the properties of the commodities and materials batch - by size, color, shelf life, etc. To obtain this kind of information, you need to set the report drilldown on the properties of the batch. In this case, if a certain property was assigned upon receipt of goods and materials, it will be grouped in the report.

Information that is generated in the report:

– Initial balance – information on the initial balance of goods and materials on the date of the report in quantitative and sum terms;

– Incoming – information on how much goods and materials were received in quantitative and total terms for the reporting period;

– Consumption – information on how much goods and materials were spent during the reporting period;

– Final balance – information on how much goods and materials in quantitative and total terms remained at the end of the report generation.

"Inventory sales report" is used in the system to provide users with information about inventory sales. This report is entered from the "Inventory sales report" item of the main menu of the "Reports" program. From the report, the user can obtain complete information about the purchase and selling prices of goods and materials, profits and turnover received from the sale of goods. This report also displays information about the discounts provided for the sale of goods, the amount of VAT paid upon receipt and sale of goods. Using report settings, you can select and group report parameters in various ways.

In the report, you can select information on specific goods and materials, groups of goods and materials, goods and materials that have certain properties, as well as on an arbitrary list of goods and materials, groups of goods and materials and properties of goods and materials (on the "Multiple filter" tab). You can filter by specific buyers (suppliers), a group of buyers (suppliers) or by an arbitrary list of buyers (suppliers) by selecting values ​​on the "Multiple filter" tab. The user can select according to the status of goods and materials sold: “all”, “purchased”, “accepted” (selection from the list of the “Product type” parameter). In the event that the flag “Withdraw commission on accepted goods and materials” is set, the commission will be shown as profit on goods and materials accepted for sale. In this case, the report can be generated only in the accounting currency and only for those goods and materials accepted for sale, for which the enterprise has already reported to the principal (the “Report to the principal” document has been drawn up). When deciphering the amount of profit, a list of those reports of consignors is shown, as a result of which the commission was accrued. Selection can also be made by type of sale: "any", "wholesale", "retail". It should be taken into account that: “wholesale sale” is a sale executed with the help of the documents “Sale of goods and materials (purchase and sale)”, “Commission agent’s report”, and “retail sale” is a sale executed with documents retail(“KKM report”, “Sales (retail)”). The return of goods from the buyer is displayed in the column "Sales" with a minus sign. In the event that the goods returned by the buyer were then sold, a new batch of goods is formed, created by the return document.

The configuration provides the possibility of detailing the report by various parameters. You can also change the order in which the data is presented in the report. The order of data presentation is changed in the "Report detailing" settings window on the "Basic" tab using the control buttons (up, down). By placing the cursor on the desired position, you can use the control buttons to move it to the desired location. By changing the level of detail and the order of data presentation, you can get a wide variety of information in the sales report. So, for example, by setting the detailing parameters "Nomenclature" - "Delivery documents" - "Sale documents", you can get information about the profit from the sale of goods by suppliers and compare the profit received from the sale of goods by several suppliers. By setting the detailing parameters: "Nomenclature" - "Sales documents" - "Delivery documents", you can get information about which supplier's goods were sold to the buyer.

The report "Reserves of goods and materials" is designed to display information about the reserves of goods and materials. This report is entered from the "Reserves of goods and materials" item of the main menu of the "Reports" program. The report generates a complete or partial (if a certain filter is set) list of reserved goods and materials. Reservation of goods and materials is made in a specific warehouse or in general for the company. You can display information on how much goods and materials are reserved in a particular warehouse in the report. With the help of a multiple filter (“Multiple filter” tab), you can display a report on the reservation of goods and materials in several randomly selected warehouses.

You can additionally display information about the reserve of specific goods and materials in the report. The selection of goods and materials is made using the appropriate filters: goods and materials, groups of goods and materials, properties of goods and materials. Selection by goods and materials properties is made on the "Multiple filter" tab. In the report, you can also get information about for which of the buyers goods and materials are reserved. To do this, in the report detailing, you need to set the flag "By buyers". If you need to see how many goods and materials are reserved for a specific buyer, then it must be selected in the "Buyer" field. The report can be detailed by warehouses, customers for whom inventory is reserved, contracts, and movement documents. If you set the "Totals by groups" flag, then the report will display groups of goods and materials and the total number of goods and materials reserved for this group. Group totals can only be displayed if the information in the report is displayed in base units.

Information that is generated in the report:

– Warehouse / Nomenclature / Buyer / Movement documents - information about goods and materials (group of goods and materials), full name of goods and materials (group of goods and materials). If the appropriate detailing is specified, then information is displayed about the warehouse where there are reserved inventory, for which buyer the inventory was reserved, under which contract the reservation was made. It also displays information about the document used to reserve and remove the reserve in the warehouse. You should pay attention to the fact that if the reservation was made not for a specific warehouse, but for the entire company as a whole, then the line “not selected” is displayed in the report.

– Initial reserve - how much inventory was reserved at the start date of the report.

– Reserved – how many goods and materials are reserved for the entire report generation period. Reservation of goods and materials is carried out when drawing up the documents "Application for a warehouse", "Application for delivery". Automatic reservation of goods and materials is also performed if the mode of through registration of applications is used. In this case, the receipt document issued on the basis of the "Order to the supplier" reserves goods and materials at the warehouse specified in it for the buyer to whom this order was distributed.

– Removed from the reserve – information about the quantity of goods and materials removed from the reserve. Removal of the reserve is carried out upon shipment of goods and materials at the request of the buyer (document "Sale of goods and materials"). Manual withdrawal of the reserve is carried out with the help of the document "corr. buyer's order". This document is issued on the basis of an existing request and corrects the amount of goods and materials reserved for the request.

– Ending reserve – how much inventory is left reserved at the end date of the report.

By button<Снятие резерва>the user can generate the document "Reserve withdrawal by company" or "Reserve withdrawal by warehouse" based on the data presented in the report.

Using the report "Card of quantitative and total accounting" in the "Trade + Warehouse" configuration, you can generate a printed form of a card of quantitative and total accounting, approved by the Decree of the State Statistics Committee of Russia dated December 25, 1998 No. 132 (form according to OKUD 0330228). At the same time, it is possible to select a nomenclature unit, a storage warehouse and a discount price type. For warehouses with sign retail warehouse the discount price type selection parameter becomes inactive. It should be taken into account that the card number in the report is automatically set to one more than the previously entered one. This report is entered from the "Card of quantitative and sum accounting" item of the main menu of the "Reports" program. In the "Legal entity for printing" field, the user can set entity, which should fall into the header of the quantitative-sum accounting card. It is important to keep in mind that in order to generate a report, all fields of the card must be filled in.

The "Report on projects" form is used in the system to obtain information about the fulfillment of buyers' requests, control over the fulfillment of orders by suppliers, as well as the movement of inventory items grouped by projects. This report is entered from the "Report on projects" item of the main menu of the "Reports" program. In the project report, you can generate data using various filters. Using the "Report detailing" group of settings, you can set a different order of data presentation in the report. To obtain more visual information in reports, it is not recommended to set the detailing for a large number of parameters, this will lead to the cumbersome presentation of data in the report and create additional problems in their analysis. It should be noted that the project report does not analyze the documents “Receipt of services, etc.”, “Implementation of fixed assets, intangible assets”. The project report also does not analyze documents that record the movement of inventory items and Money. In the report on projects, only the document “Advance report line (payment to the supplier)” is analyzed, all other documents on settlements with accountants are not analyzed in the report.

Consider several options for using this report. One of the options for using projects may be the possibility of distributing documents to responsible persons (for example, managers) responsible for the purchase and sale of goods and materials. In this case, when drawing up a document, the name of the manager responsible for carrying out this operation is entered in the "Project" field. In order for the user in the project report to receive information about the fulfillment of buyers' requests (orders by suppliers) by managers, it is necessary to set the flags - "About buyers' requests", "About suppliers' orders" in the "Display information" group, and in the "Report detail" group set the following grouping order "Project" - "Authors of documents" - "Movement documents". In this report, you can also get information about which of the managers is responsible for the fulfillment of a specific buyer's request, which of the employees executed the documents within the framework of the project, according to which documents the shipment (or receipt) of goods and materials was carried out. The amounts in the report are given in the currency of the contract of the counterparty, according to which the documents of the buyer's application or the order to the supplier are executed. Setting the detail "On cash flows" will also allow the user to obtain information about the payment made by counterparties - suppliers and buyers. Another example of the use of projects is the ability to track the effectiveness of a marketing campaign. When registering a document in the project field, you can specify Additional information about how the user learned about the products sold by the company (from advertising in a newspaper, from information on a billboard, or from printed products published by the company itself). You can then use the report to compare product sales performance and determine which of the company's marketing campaigns was more effective. In this case, in the report in the "Display information" group, the flag "On the movement of goods and materials" should be set. In the "Report detailing" settings group, set the following grouping order - "Projects" - "Nomenclature". Information in the report can be displayed in the currency of accounting or management accounting. The quantity of goods and materials can be displayed in basic or basic units of measure. The data in the "Incoming" column is formed on the basis of the documents for the receipt of goods and materials, and the data in the "Expense" column is formed on the basis of shipment documents. If you set the additional detail “Movement Documents”, then you can control which documents were used to register the receipt and shipment of goods and materials.

The report "Commodity report" is designed to generate printed form commodity report, approved by the Decree of the State Statistics Committee of Russia dated December 25, 1998 No. 132 (TORG-29). A product report can be generated for a specific company or legal entity. For a legal entity, a commodity report is generated if the company has several firms that have the same legal entity, but different analytical features of management accounting. The product report number is set in the settings before the report is generated.

The Accompanying Register report is intended for compiling accompanying registers when accounting for goods at purchase prices, when maintaining varietal, batch accounting of goods. This report is entered from the "Accompanying register" item of the main menu of the "Reports" program. It can be formed only for one specific company or for one legal entity. A report on a legal entity is compiled if, in the configuration, there are several firms that have the same legal entity, but different analytical features of management accounting. The accompanying registry number is set in the report settings. When a new accompanying register is entered, its number is automatically set to one more than the previously entered number. The user can create an accompanying register for a specific warehouse.

From the book Accounting author Bychkova Svetlana Mikhailovna

The method of calculating the cost of goods (except for goods accounted for at the sale value) upon sale (release) Goods are valued similarly to the inventories, the methods of valuation of which are discussed in the subsection “Procedure for writing off the cost of inventories”. When

From the book Accounting author Melnikov Ilya

PREPARATION OF ACCOUNTING REPORTS When compiling an accounting report, it must be ensured that: - a complete reflection for the reporting period of all business transactions and the results of an inventory of production resources, finished products and calculations; - complete

From the book Accounting in trade author Sosnauskene Olga Ivanovna

2.7. Compilation of commodity reports A commodity report is primarily a document confirming the balance of goods assigned to a specific financially responsible person. The commodity report is compiled by a financially responsible person on the basis of

From the book Balance Science: tutorial author Zabbarova Olga Alekseevna

3.1. Structural construction of balance reports The general idea of ​​using the balance method is to equalize the total value of the indicators recorded in the left and right sides of the balance equation. The first experience of building balance sheets belongs to the accounting

From the book Consumer Protection: Frequently Asked Questions, Document Samples author Enaleeva I. D.

Chapter 2 The Right of Consumers to proper quality goods, works, services and safety of goods 2.1. Product quality. Warranty period According to art. 470 of the Civil Code of the Russian Federation, the goods that the seller is obliged to transfer to the buyer must comply with the quality requirements established by the Civil Code of the Russian Federation,

From book 1C: Accounting 8.2. A clear tutorial for beginners author Gladkiy Alexey Anatolievich

Chapter 12. Setting up, generating and printing statements and reports In fact, all accounting is carried out in order to obtain clear and reliable reports. In this chapter, we will describe how reports are processed in the 1C Accounting 8 program. It is worth noting that

From book Foreign economic activity: training course author Makhovikova Galina Afanasievna

5.3. The order of arrival of goods on customs territory RF, departure of goods from the customs territory of the Russian Federation. Release of goods Arrival of goods and Vehicle to the customs territory of the Russian Federation is allowed at checkpoints through state border RF during work

From book Desk book on internal audit. Risks and business processes the author Kryshkin Oleg

Sub-process "Formation of demand for goods and materials/works/services and formation of applications" This sub-process includes four main stages: formation of the need for goods and materials/works/services; preparation and execution of the application by the customer, approval of the application for

From book 1C: Enterprise. Trade and warehouse author Suvorov Igor Sergeevich

The nuances of writing reports There is an extensive literature on business letter. However, it is unlikely that there will be a mention of the specific moments of writing audit reports. There are a number of nuances, both before writing a report, and during and after writing

From the book 1C: Enterprise, version 8.0. Payroll, personnel management author Boyko Elvira Viktorovna

6.4. Preparation of financial reports The "Book of purchases" report is called from the sub-item "Book of purchases" of the item "Accounting reports" of the main menu of the program "Reports". The purchase book is formed on the basis of purchase book entries. Purchase ledger entries can be generated

From book Google AdWords. Comprehensive guide author Gedds Brad

6.5. Creation of analytical reports The "Sales dynamics" report is designed to obtain information about the dynamics of sales for a selected period of time. The period of this analysis is set in the report settings (Period). This report is called from the sub-item "Sales dynamics"

From the book Great Team. What you need to know, do and say to build a great team by Miller Douglas

4.5.2. Formation of scheduled reports At the beginning of the procedure for generating a regulated report, a start form opens. The start form is intended for:? choice of the period for the formation of a regulated report;? automatic shape detection

From the book Complex economic analysis enterprises. Short Course author Team of authors

Using reports to optimize your account Now that you know how to download and extract data from the AdWords system, you need to understand how to use different reports to analyze your account in the most effective way. If you want to visualize data using a conditional

From the book Management of financial and commodity flows at trade enterprises author Neveshkina Elena

2. Reporting If you are reporting official records for guidance, both your project team leader and other project team members need to know when they can get the information they need from you. You must meet the deadlines for

From the author's book

8.2. Analysis of Segmented Reports Having recognized that the use of a two-stage calculation of marginal income provides greater information opportunities, we will analyze more detailed segments. Sectional reporting for Plant No. 1 certain types products

From the author's book

Chapter 2. Formation of the cost of goods when they are accepted for accounting The concepts of "price" and "cost", "cost" and "cost" are so often confused and interchanged that no one pays attention to the differences between them. So you've bought a product for

If you have more than one warehouse in your company, then you will almost certainly need operations to move goods between warehouses. Let's consider how such operations of moving goods from one warehouse to another warehouse are reflected in the management of the 1C Trade Management version 11.2 program.

Relocation documents are located in the section "Warehouse and delivery". There are two logs: "internal merchandising" and "movement of goods". In essence, it is the same magazine. We can verify this by opening both log data. The only thing in the magazine "movement of goods", - the type of operation " movement of goods" and set the appropriate header. We can also set all the necessary flags here and we will immediately see a set of documents that is available to us in the journal "Internal merchandising".

Both of these magazines have a tab "for decoration", which provides the basis documents, order documents for processing the relevant operations. As such documents-orders are usually orders- for example, transfer orders. In its structure, this document resembles the transfer document itself, but, unlike it, does not directly carry out the movement of goods through warehouses, but is a document that plans the operation of moving goods from one warehouse to another.

Document "Transfer order" statuses can be used - for example, statuses "to ensure", "to fulfill". Depending on the status, the document will act as the basis for certain operations. Able "to ensure" the warehouse requirement will be planned by the sender in order to provide this quantity on it. By status "to be done" the document will be the basis, the document-order for registration of operations for the movement of goods.

On the tab "Products" the nomenclature is filled in, its quantity that needs to be moved.

On the tab "Additionally" the department that prepared this document is indicated.

On the tab "Comment" we have a field for an arbitrary comment.

And the main two props are "sender's warehouse" and "consignee's warehouse". These are two warehouses, from one of which the goods will be moved to another warehouse.

In order to see how these transactions are reflected, we will first create two additional warehouses. To do this, we will go to the section "Regulatory and reference information and administration". Find a hyperlink here "Warehouses and shops" and create 2 retail stores.

The first one will be called Shopping room". This will retail store. The accounting type of prices here will be retail. The retail type of prices will also be retail. Additionally, we will not set any flags. Flag "control provision" we have already installed. Let's write such a store.

We will create another retail store. It will be called that - "Retail Store". He will also have accounting prices - a retail type of prices. On the tab "Order scheme and structure" we will establish that we will use the order scheme when goods arrive at this warehouse. Cells will not be used. On the tab "basic" also check that the flag is set "control provision". Let's write such a store.

Now we have prepared two stores, and we can consider the operations of moving inventory of goods to these warehouses, to these stores.

Order for the movement of goods in the program 1C Trade Management (UT 11) 11.2

Let's start the goods transfer operations by creating a transfer order. For this we go to the section "Warehouse and delivery". Opening the magazine "Orders for the movement of goods" and create the first order. The sending warehouse will be a “order warehouse”, the receiving warehouse will be a “retail store”.

On the tab "Products" add nomenclature. Let it be a “kitchen table”, the characteristic “mahogany”. We will set today's date as the start of shipment. Set the quantity to "1 piece". The end of receipt will also be today's date.

The shipping start and receipt end dates are used to plan the movement of goods to the respective warehouses.

Let's add one more position. Let it be our dark wood table. The dates will also be today's, and the quantity is "1 piece". Let's add one more position. This time we will have a table, the color is mahogany, the date is today, the quantity is "2 pcs." and the end of the receipt - the date is today.

On the tab "additionally" Our division is full.

On the tab "comment" you can fill nothing.

We will transfer such an order to the state "to be done", hold and close.

The document "Movement of goods" in the program 1C Trade Management (UT 11) 11.2

Now this order can be the basis for creating a transfer document. In order to create such a document, we go to the section "Warehouse and delivery", to the log "movement of goods" and go to tab "for decoration". We do not have here documents-orders for processing the movement of goods. There can be only one reason - we do not have registered documents in the program in the status "to be done" with completed tables "products", for which it is indicated that the goods must be shipped.

Let's go back to our order. Since we are status "to be done" set, but the action that needs to be performed with the product, we still have "to ensure". I have not installed software "for shipment". Select all lines and use command "fill provision". Here we are interested in the command "ship". Actions on these commodity items are now with us "ship". Let's carry out such a buyer's order and go back to the magazine "Movement of goods".

Now we have goods for the movement of goods as order documents. Select this position and issue a command "make to order". Program 1C Trade Management 11.2 created a document for us "movement of goods". The reason is that the transfer document is based on a transfer order. In this case, the shipping warehouse is a warrant warehouse. The recipient warehouse is a retail store. Organization - trading house"Wholesaler".

On the tab "Products" selected our headings along with the characteristics, and indicated in the "transfer order". Set status "shipped", and carry out such a document.

Now, based on this transfer order and the transfer itself, it is necessary to create, firstly, an outgoing order for the shipping warehouse, and, secondly, an incoming order for the receiving warehouse, since in a retail store, we have a scheme for the receipt of goods .

To do this, we go first to the section "Warehouse and delivery". In a group "Order Warehouse" we are interested in the magazine "Shipment". We see that we have here "transfer order". The recipient is a retail store, and for this movement we see the item that needs to be collected and shipped. Having selected the corresponding position, we create an order. Program 1C Trade Management (UT 11) 11.2 asks whether to create an order for a selected order, or you can use the “create for all” flag.

An issue note has been created. We can open it, look at it and make sure that the corresponding commodity items were shipped from the warehouse to order, the recipient - "retail store" - two tables of different colors and two chairs.

Now our movement needs to be translated into a status "received", and optionally create a receipt in a retail store. To do this, we go to the section "Warehouse and delivery". In a group "Order Warehouses" we will be interested in - magazine « workplace acceptance". Here we select the warehouse we need. In this case, it will not be a warrant warehouse, but a retail store. And we see that here our “transfer order” is used as the basis document, according to which our 3 positions appear - 2 tables of different colors and a chair. On the basis of such an order, you can create a credit note.

Program 1C Trade Management version 11.2 filled in all the necessary details. It is noted that the order is "transfer order", warehouse "retail store". Commodity positions are also filled. Additionally, at the top of the document, you can specify the number and date incoming document on the basis of which this receipt was issued. Let's go through and close this document, and move on to transfer orders.

This order has been fully worked out for us, namely, it has been shipped from one order warehouse and accepted at the second order warehouse. After I updated the log, I see that the state of this order has already been set by the 1C Trade Management 11.2 program in the state "closed". Thus, the movement of goods through warrant warehouses is carried out.

Moving goods through ordinary warehouses (not order warehouses) is somewhat easier. You do not need to additionally create warehouse orders. In this case, I will do the transfer without using "transfer orders".

For this in the log "Movement of goods" I will manually create the displacements. I will point out that the sending warehouse will be the main warehouse, the receiving warehouse will be the “trading floor”.

On the tab "Products" I will additionally point out that I have a Panasonic TV in the amount of 1 piece, and a Sony TV also in the amount of 1 piece. Document status can be set immediately "received", and such a document can be posted and closed. Thus, I have just reflected the operation of moving goods from the main warehouse to the "Trading Room" warehouse. These warehouses do not use an order scheme, so there is no need to create additional warehouse orders.

 

It might be useful to read: