Retail sales report in 1s trade. What is the retail sales report used for? Retail sales report


Document "Report on retail sales"

Sales ® Retail Sales Report

The document is used to generate retail sales. The document can be filled out based on the document
Inventory of goods in the warehouse.

Shaping the sale at the same time as the reception retail revenue(warehouses with the "Wholesale" or "Retail" type)
Formation of a sale based on previously accepted revenue (warehouses with the "Ntt" type)

Print versions
Input Based

When filling out the document in the upper part, it is imperative to define the following parameters:

* Storage location - a point of sale where retail sales are formed.
* Price type - the price of the goods at which the sale is created. It is set from several acceptable prices for the product. The price type is entered automatically by the price type assigned to the specified warehouse. The price type can be edited or defined if the price type for the warehouse is not set by pressing the button Price and currency of the document menu.
* DDS item - an item of cash flow, which will display the receipt of retail revenue to the cash desk of the organization.

Generating a sale at the same time as receiving retail revenue

To form a retail sale from a wholesale warehouse or from a warehouse with the "Retail" type, you need to specify a cash register operation. After selecting the operation, you need to fill in the tabs:

* Agency services

* Payment cards and bank loans

The Goods panel displays the goods and services sold to the retail consumer.

* Counterparty - the principal-organization is selected, the services of which our organization provides as an agent.


(principal)."

The Payment cards and bank loans panel reflects the buyer's payments made by a payment card or with the involvement of bank loans.

* Counterparty, Counterparty Agreement and Settlement Account - are entered automatically with data from a given type of fee.

Formation of a sale on previously accepted revenue

To generate a retail sale from a warehouse with the "NTT" type, you must specify the NTT operation. After selecting the operation, you need to fill in the tabs:

* Agency services

The Goods panel displays the goods and services sold to the retail consumer. The panel is entered according to the results of the inventory in point of sale based on the Inventory of goods in the warehouse document.

* Price - entered automatically when specifying an item based on the Item Price register.

* Account, VAT Account, Income Account and Expenses Account - are entered automatically when specifying the nomenclature based on the register of the Nomenclature Account.

* Subconto - the contents of the item group are substituted specified product or services.

* Income account and Expenses account - set whether this sales line refers to activities with a special taxation procedure. The definition for income and expenses of accounts related to various types activities.

The Agency Services panel reflects the services in the implementation of which our organization acts as an agent.

* Counterparty - the principal is selected - the organization whose services our organization provides as an agent.

* Counterparty agreement - an agreement with a principal is selected, the agreement must have the form "With a principal
(principal)."

* Settlement account - the account of settlements with the principal under the agency agreement is selected, which will reflect the principal's revenue from the realized agency services.

Print versions

For the Retail Sales Report document, the following print form has been implemented:

* KM-6 (Help-report of the cashier-operator)

Input Based

Based on the Retail Sales Report document, it is permissible to fill out the following documents:

* Incoming cash order

* Return of goods from the buyer

* Formation of VAT calculation

In this article, we will consider in detail all the main operations in accounting. retail in the program 1C Accounting 8.3, including sales in non-automated outlets.

Often, before transferring the goods purchased from the supplier to retail, they first come to the wholesale warehouse. If you do not have such a practice, for example, you do not have a wholesale warehouse and all goods are immediately shipped to a single outlet. Feel free to bring them to the retail warehouse.

In our example, we will create a , which is located in the "Purchases" menu. The type of operation we will have is “Goods (invoice)”.

We will not show in detail the completion of this document within the framework of this article. Please note that when reflecting receipts to a wholesale warehouse, the warehouse itself must have the "Wholesale warehouse" type.

The figure below shows an example of filling out a receipt document for the wholesale warehouse of the Kompleksny trading house from the Produkty database.

Price setting

So, we have already purchased all the necessary goods from the supplier and are ready to sell them to the final buyer. But before doing this, we need to set retail prices - those at which we will already begin to sell these goods.

They are located in the "Warehouse" menu, but for simplicity of the example, we will create it based on the receipt of goods. Of course, this option is not always convenient, but it is used quite often.

The goods from the receipt were automatically included in the created document. Let's fill in the prices for each position, and indicate the type of prices (in this case, we created it ourselves in the directory and called it "Retail"). Now the document can be posted. These prices will be valid from the date indicated in the header of the document.

Moving goods to a retail warehouse

If you first received goods at a wholesale warehouse, then you will need to transfer them to a retail warehouse, or to a non-automated outlet. The latter refers to such points as a stall, a tent in the market and others where it is not possible to keep records due to the lack of a PC or electricity.

First we will create these warehouses. They practically will not differ in any way from the wholesale except for the type.

As a result, we will get the trading floor of store No. 23 with the type "Retail Store".

Let's call a non-automated outlet "Stall at the railway station". She will have a different type.

In our example, both warehouses use the same price type, but you can also set different prices. Then you will have to create two Item Pricing documents for each of these price types.

In order to reflect the transfer of purchased goods from our wholesale warehouse to the store and stall created above, we will create a document "". You can find it in the Warehouse menu.

The figure below shows an example of filling out a document for the movement of goods from the main wholesale warehouse to a stall near the railway station.

Retail sales report

If you have completed all the previous steps correctly, then your retail warehouse will already have products with filled end-customer sales prices.

Now we can move on to the direct reflection of the sale of goods. From the Sales menu, select Retail Sales Reports. This document is required to reflect retail sales.

In the header of the document, we indicated the organization and the retail warehouse " Shopping room store number 23. Cash account, as expected 50.01. Also, for the purpose of additional analytics on management accounting we indicated the item of the VAT "Retail revenue".

Sales in non-automated outlets

Above, we took into account sales in a retail store. Now let's proceed to a non-automated outlet - the "stall".

Non-automated outlets in 1C are points where it is not possible to put a computer and establish a connection with a common database. Sales data is not entered regularly.

Cash flow

The first step is to reflect the receipt of cash with the type of operation "Retail revenue". If in a retail store the buyer could pay for the goods with a bank card, then this is unlikely here.

An example of a completed document is shown in the figure below. With the missing revenue, the retail sales report will simply not be held for you.

Reflection of retail sale

Suppose our salesperson does not write down in a notebook how many of which goods he sold. In this case, it is most logical to get the sales volume by simply subtracting the balance from the previously transferred quantity of goods.

For such purposes, in the 1C: Accounting program, there is a document "Inventory of goods". It is located in the Warehouse menu.

In the inventory document, we indicate the organization, our warehouse "Stall at the railway station" and, if necessary. For convenience, we will fill in the goods according to the balances in the warehouse. After that, you need to indicate how many goods are actually left in the column "Quantity fact".

As shown in the figure above, the “Deviation” column reflects, in fact, the quantity that was sold in this stall.

Now you can post this document and, based on it, create a report on retail sales.

Before us opened the form of the created document, in which absolutely everything was filled in automatically. Please note that the "Quantity" column contains all the data from the "Quantity fact" column of the inventory document.

If you have not taken into account the received revenue in the program, the program will not allow you to post the document and will display a message similar to the one shown in the figure below.

See also the video instruction on the reflection of such operations:

The document "Report on retail sales" is intended for registration of retail sales.


The document "Report on retail sales" records the fact of shipment of goods and the fact of receipt Money at the checkout of KKM.


The document "Report on retail sales" can be issued both from the wholesaler and from retail warehouse. Also, with the help of this document, sales of goods in a non-automated outlet can be recorded. When registering sales in a non-automated retail outlet, the prices assigned for the sale of goods in a non-automated retail outlet are controlled.


Receipt of retail proceeds from the cash desk of KKM to the cash desk of the company is carried out using the document "Incoming cash order" with the established type of operation "Receiving retail proceeds".


The document "Retail sales report" can be generated automatically using the processing "Closing checkout shift».


The tabular part of the document contains the "Warehouse" attribute, which allows you to conduct sales using one cash register from different warehouses (for example, in different sections of the store).


In the event that the document is generated automatically using the processing "Closing the checkout shift", then the "Warehouse" attribute in the tabular part of the document will be filled in automatically in accordance with the information about the warehouse specified in the KKM checks.


The document "Report on retail sales" can also be generated on the basis of the document "Inventory of goods in the warehouse".


In this case, the tabular part of the document is automatically filled in according to the results of the inventory with the number of goods sold, identified as a result of the inventory in the warehouse.


In the Retail Sales Report document, you can assign discounts for each item of the item, just like in all other documents.


As in any other implementation document, in this document it is possible to select a nomenclature item with certain characteristics and series.


In accounting and tax accounting, the document "Report on retail sales" reflects the sale of goods and services. In the event that previously accounted for revenue received from non-automated outlets, the document "Report on retail sales" redistributes the previously reflected revenue (the document "Incoming cash order"). The redistribution is carried out by its reversal and the formation of postings with the specification of item groups goods sold and services, as well as whether own or commissioned goods were sold.

You can simplify your work with a retail sales report. It will be sent from Kontur.Market to 1C and transfer there list of goods sold, including their prices and quantity. As a result, the accounting process will become more efficient.

Who can use

In order to set up joint work services, you need:

Procedure for downloading a report:

  1. In 1C in the menu " File» select item « Open»:
  2. Select Contour.Market_Demo.epf from the list of files:
  3. Select the start and end dates for the period, then click " Refresh»:
  4. Sales information for each day of the period will be loaded. By clicking on one of them, below you can see the implementation data for that day:
  5. The two leftmost columns contain the product name. At the same time, in the first the name is taken from the nomenclature 1C, and in the second from Kontur.Market(this name was obtained from the cash register and printed on the check). Accordingly, they will not always coincide. If such a discrepancy is detected, the cell will remain empty and will be highlighted in red. When you click on it, a list of names will appear:
  6. You need to choose the most appropriate product name:
  7. This name will be placed in the highlighted field. Other missing details are filled in the same way:
  8. When everything is ready, you should press the button " Create a document in 1C". The system will load the report and show that it has been created:

Step-by-step instructions on how to reflect retail operations in 1C 8.3 "Enterprise Accounting 3.0".

NTT includes objects of trade in which it is not possible to install a computer or establish a connection with a common database. This is, for example, a stall, or exit trade.

Receipt of goods to the organization

As a rule, before reaching the retail warehouse or NTT warehouse, the goods fall on the wholesale warehouse. At the wholesale warehouse, it is processed and then moved to retail.

Let's give an example of filling out a 1C document so that further steps are clear:

Setting item prices in 1C for retail

After receipt, you need to set retail prices for goods in 1C. To do this, use the document "Setting item prices". It is entered in the "Warehouse" section. Let's create a document based on the receipt document. Let's go to the previously created goods receipt document and click the "Create based on" button. In the drop-down list, select the item "Set item prices".

A new document window will open, where the main details will already be filled in, it remains only to specify the price type. In order not to return to this section, let's create two such documents at once, where we assign prices for the "Retail" and "Retail price" types. We will make the prices the same. Here is an example document:

By clicking the "Change" button, special options for manipulating the price are also available. For example, increase or decrease by the specified percentage.

Moving goods from wholesale to retail warehouse

Now you can move the goods from the wholesale warehouse to retail. To do this, the program uses the document "Movement of goods". It is located in the Warehouses section.

Before making a transfer, you need to set up two warehouses - one with the type of warehouse "Retail", the second with the attribute "Manual outlet".

Warehouses are created in the "Directories" - "Warehouses" section.

Let's name the first warehouse "Shop No. 2", the type of warehouse - "Retail store". We select the price type from the "Nomenclature price types" reference book:

Let the second one be called "Trading Room". "Warehouse type" - "Manual outlet", Price type "Retail", item group - "Products".

We will also create two documents 1C 8.3: moving to the warehouses "Shop No. 2" and "Trading Room". Documents will also be created on the basis of the goods receipt document. In this case, we will only have to fill in the requisite "Warehouse - recipient" and the quantity of goods:

As a result, the product has a price and is in retail warehouses. You can proceed to the registration of the sale of goods.

Retail sales report in 1C for a store

To reflect the sale of goods in retail, you will need the Retail Sales Report document from the Sales section. First, we will issue a sales document from a retail warehouse. It is not much different from the document “Implementation (acts, invoices). The only difference is that the counterparty is not indicated, and you can immediately reflect the proceeds from the sale.

For this, a cash account is selected. For analytics in 1C, you can also fill in the details "DDS Movement". This will be a subconto at the cash register account. Document example:

Sale of goods in NTT

When selling goods in a non-automated outlet at the end of the shift, we do not know how many goods are sold. But we know how much was moved from the wholesale warehouse. How to fill out a retail sales report in 1C 8.3 (8.2) in this case?

Accordingly, 20 packages were sold.

To reflect this calculation in the program, you must use the document "Inventory of goods" (section "Warehouse").

In the header of the document, we indicate the organization and warehouse of NTT.

In the tabular section, add the nomenclature and indicate the actual balance in the warehouse. You can use the Fill button. The deviation from the accounting quantity will be the sale:

We carry out the document and press the button "Create based on". Select "Retail Sales Report" from the drop-down list. A new document will be created reflecting the sale of goods in NTT

Reflection of revenue from retail trade in 1C

For now, just write it down, since the document will not be held at the moment. The fact is that you also need to reflect the receipt of retail revenue in the "Bank and cash desk" section. Here is an example document:

You can now post the Retail Sales Report document.

Source: programmer1s.ru

 

It might be useful to read: