Report on retail sales in 1c trade. What is the retail sales report document used for? Retail Sales Report

Retail Sales Report Document

Sales ® Retail Sales Report

The document is used to generate retail sales. It is permissible to fill in the document based on the document
Inventory of goods in the warehouse.

Formation of the sale at the same time with the receipt of retail proceeds (warehouses with the "Wholesale" or "Retail" type)
Formation of a sale based on previously accepted revenue (warehouses with the "NTT" type)

Versions for print
Input based

When filling out the document at the top, it is imperative to determine the following parameters:

* Storage location is a point of sale where retail sales are formed.
* Price type - the price of the product at which the sale is created. It is set from several prices allowed for the item. 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 clicking the Price and currency button in the document menu.
* DDS article is an item of money movement, which will display the receipt of retail proceeds to the organization's cash desk.

Formation of sale at the same time with the reception of retail proceeds

To form retail sales from a wholesale warehouse or from a warehouse with the "Retail" type, you need to specify the KKM operation. After selecting an operation, you need to fill in the bookmarks:

* Agency services

* Payment cards and bank loans

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

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

(the principal) ".

The Payment cards and bank loans panel displays the purchaser's payments made by a payment card or with bank loans.

* Counterparty, Counterparty Agreement and Settlement Account - entered automatically by data from the specified type of payment.

Formation of a sale based on previously accepted revenue

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

* Agency services

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

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

* Accounting Account, VAT Account, Income Account and Expense Account - entered automatically when specifying an item on the basis of the Item Accounting Account register.

* Subconto - the contents of the nomenclature group of the specified product or service are inserted.

* Income Account and Expense Account - set whether this sales line is related to activities with a special taxation procedure. It is unacceptable to define for income and expenses accounts related to various types of activities.

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

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

* Counterparty agreement - an agreement with the principal is selected, the agreement must have the form "With the principal
(the 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 sold agency services.

Versions for print

A print form has been implemented for the Retail Sales Report document:

* 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:

* Receipt cash order

* Return of goods from the buyer

* Formation of VAT accrual

In this, we will take a closer look at all the main operations when keeping records of retail trade in the 1C Accounting 8.3 program, including sales in manual retail outlets.

Often, before handing over the goods purchased from the supplier at retail, they first arrive at 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 send them to the retail warehouse.

In our example we will create which is located in the "Shopping" menu. We will have the type of operation "Goods (invoice)".

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

The figure below shows an example of filling out a document of receipt at the wholesale warehouse of the Complex Trading House from the Products database.

Setting prices

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

They are located in the "Warehouse" menu, but for the sake of 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 created document automatically contains goods from the receipt. Let's fill in the prices for each item and indicate the type of prices (in this case, we created it ourselves in the reference book and named it “Retail”). The document can now 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 came to the wholesale warehouse, then you will need to transfer them to the retail warehouse, or to a manual point of sale. The latter means such points as a stall, a tent on the market and others, where it is impossible to keep records due to the lack of a PC or electricity.

We will first create these warehouses. They will practically not differ from the wholesale one except for the type.

As a result, we will get a sales area of \u200b\u200bstore No. 23 with the "Retail store" type.

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

In our example, both warehouses use the same price type, but you can set different ones. Then you will have to create two "Set Item Prices" 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, create a document "". You can find it in the "Warehouse" menu.

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

Retail Sales Report

If you have followed all the previous steps correctly, then your retail warehouse will already have items with filled in the sales prices to the end customer.

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 "Trade Hall of Shop No. 23". Cash account, as expected 50.01. Also, for the purpose of additional analytics on management accounting, we have indicated the DDS Article "Retail Revenue".

Sales at manual points of sale

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

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

Cash receipts

The first step is to record the receipt of cash with the transaction type Retail Revenue. If in a retail store the customer could have paid for the goods by credit 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 posted.

Reflecting retail

Suppose our salesperson does not write down in a notebook how many items he sold. In this case, it is most logical to get the sales volume by simply subtracting the remainder 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 will indicate the organization, our warehouse "Stall at the railway station" and, if necessary. For convenience, we will fill in the goods according to the balance in the warehouse After that, it is necessary to indicate how many goods are actually left in the column "Quantity in fact"

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

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

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

If you did not take into account the received proceeds in the program, then the program will not allow you to post the document and will display a message similar to that shown in the figure below.

See also the video instruction on how to reflect 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 of funds at the cash register office.

The document "Report on retail sales" can be drawn up from both a wholesale and a retail warehouse. Also, with the help of this document, sales of goods at a manual outlet can be recorded. When registering sales in a manual retail outlet, the control of the prices that are assigned for the sale of goods in a manual retail outlet is carried out.

Acceptance of retail proceeds from the cash register of the cash register to the cash desk of the company is carried out using the document “Receipt cash order” with the established type of operation “Acceptance of retail proceeds”.

The document "Report on retail sales" can be generated automatically using the "Close cash register shift" processing.

The tabular section of the document contains the "Warehouse" variable, 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 "Closing the cash register shift" processing, the "Warehouse" variable in the tabular section of the document will be filled in automatically in accordance with the information about the warehouse specified in the cash register receipts.

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 section 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 to each item in the item, just like in all other documents.

As in any other implementation document, this document provides for the ability to select an item with specific characteristics and series.

In accounting and tax accounting, the "Retail Sales Report" document reflects the sale of goods and services. In the event that earlier receipts were received from non-automated retail outlets, the document "Report on retail sales" redistributes the previously reflected earnings (document "Receipt cash order"). The redistribution is carried out by reversing it and generating transactions with the specification of the nomenclature groups of goods and services sold, as well as whether the goods that are owned or accepted for commission 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 quantities... As a result, the accounting process will become more efficient.

Who can use

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

use;
download the Kontur.Market cash register module;
use 1C: Enterprise 8.x in one of the following configurations: Enterprise Accounting 3.0, Manufacturing Enterprise Management 1.3, Integrated Automation 1.2.

Procedure for downloading a report:

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

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

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

Goods receipt in the organization

As a rule, before getting to the retail warehouse or NTT warehouse, the goods are received at the wholesale warehouse. In the wholesale warehouse, it is processed and then moved to retail.

Here is an example of filling out a 1C document so that further actions 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 document of goods receipt and press the button "Create on the basis". In the drop-down list, select the item "Set prices of the item".

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

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

Moving goods from a wholesale to a retail warehouse

You can now move an item from the wholesale warehouse to retail. To do this, the program uses the document "Goods movement". It is located in the "Warehouses" section.

Before moving, you need to create two warehouses - one with the "Retail" warehouse type, the second with the "Non-automated retail outlet" feature.

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

The first warehouse will be called “Store No. 2”, the type of warehouse - “Retail store”. Select the price type from the "Item Price Types" reference book:

Let the second one be called "Trading Room". “Warehouse type” - “Non-automated retail 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 floor". We will also create documents based on the goods receipt document. In this case, we will only have to fill in the "Warehouse - recipient" variable 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.

Report on retail sales in 1C for the store

To reflect the sale of goods in retail, you will need the document "Report on retail sales" from the "Sales" section. First, we will draw up a sales document from a retail warehouse. It differs little from the document “Implementation (acts, invoices). The only difference is that the counterparty is not specified, and you can immediately reflect the sales proceeds.

For this, a cash account is selected. For analytics in 1C, you can also fill in the "DDS movement" variable. This will be a subconto of the cashier account. Sample document:

Sale of goods in NTT

When selling goods at a manual outlet at the end of a 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 report on retail sales 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 an item and indicate the actual balance in the warehouse. You can use the "Fill" button. The deviation from the accounting quantity will be exactly the sale:

We pass the document and press the button "Create on the basis". In the drop-down list, select "Retail Sales Report". A new document will be created, reflecting the sale of goods in NTT

Reflection of proceeds from retail trade in 1C

For now, let's just write it down, since the document will not be posted at the moment. The fact is that you also need to reflect the receipt of retail proceeds in the "Bank and Cashier" section. Here's an example doc:

You can now post the "Retail Sales Report" document.

Based on materials: programmist1s.ru

It might be useful to read: