Retail sales in 1s. What is the retail sales report used for? Sale of goods in NTT

This lesson shows the maintenance of retail sales for three types of cash registers, cash flow and the formation of sales analytics.

To begin with, let's deal with retail sales in the easiest way, using an autonomous cash register.

Autonomous cash desk KKM

In this situation, the cash desk is not registered in UT 11 in any way, the primary sales accounting is carried out in a notebook / excel.

You will need to create a Retail Sales Report document yourself and reflect the daily sales data in it:

In the list of documents, select our cash register with the Autonomous cash register type:

We create new document, on the first tab we indicate the sold goods:

On the second tab, we indicate information about how much the buyers paid by bank card:

The following tabs indicate information about gift certificates and bonus points (we will analyze in detail in the following lessons):

You can print the following printables from a document:

That's all, sales at the offline cash register are successfully reflected.

fiscal registrar

There is a separate workplace cashier (RMK):

The cashier's workplace looks like this:

Because account is enabled in settings personal selling sales floor managers, for each sale, not only the cashier, but also the seller must be selected:

After selecting a seller, the title of the workspace changes. Now we can select goods in the check (using a scanner or manually through the selection form):

In the standard selection form, select desired goods and transfer to the document:

We ran into a problem - the price was not put down:

The reason for this is that a price type was selected in the warehouse card, for which no item prices were set:

Let's select the correct type of prices, now the prices have been successfully filled. But you can see another potential problem - there is no button for paying with a bank card:

For her to appear in RMK settings add an acquiring terminal:

Now the button has appeared, press the payment button:

The program warns that the cash register shift is not open (every morning you need to start with the opening of the shift), we agree:

Enter the amount of cash received:

Now I will demonstrate payment by card, create a new receipt:

I fill in the goods, press the payment by card:

The program asks if the card payment was made at the terminal itself:

If passed, then we break the check:

If necessary, in addition to cash receipt we can print the product:

In the event that the client has delayed payment for some reason, we can postpone the check (in this case, the goods can be reserved for the client, or not reserved):

Then when the client returns with the money, you can return to the pending check:

The program immediately shows what pending checks are:

Now we can accept payment by check:

After closing the store must be closed checkout shift(remove report with blanking, Z-report):

As a result, a z-report is printed on the fiscal registrar, and a retail sales report is automatically generated:

In addition to filling in the sold goods, information on the amounts paid for acquiring is filled in:

For the analysis of retail sales, there are such reports:

Now let's make a withdrawal of funds from KKM cash desks:

Enter the amount:

Now it remains to issue a cash receipt order (for posting the DS to the cash desk of the organization):

In the statement for money we see that the motion of the DC is reflected correctly:

Now, for example, we will reflect the deposit of money into the KKM cash desk from the organization's cash desk. To do this, create an expense cash warrant:

Please note that the button Application in the RMK you do not need to press:

KKM offline

Now let's consider working with the third type of KKM cash registers - KKM offline. The principle here is as follows - first, analytics on goods and prices are unloaded from 1C into an XML file of a special format. Then this file is uploaded to the cashier and all sales are processed at the cashier itself. At the end of the day, the shift closes at the checkout, and as a result, an XML file with sales data is generated on the cash register. Then this file is loaded into 1C and as a result a document is automatically generated Retail sales report.

Let's open a workplace for the exchange with the cashier:

Let's create a rule for uploading product information:

Upload to cash machine we will only have goods that are in the balance in the warehouse, and for which the price is set:

Now we upload the goods to a file:

We get a file of this format:

If desired, you can set up automatic file exchange between 1C and the cash register at an arbitrary time interval:

I remind you that in order for the cash desk itself to be available in the workplace for the exchange with the KKM offline cash desk, it must be selected in the settings of the current location:

3.0" step by step reflect all retail operations. In this material, we will consider the receipt of products and their movement to retail, the sale of retail warehouses, the sale of products in non-automated outlets, as well as the collection or receipt of proceeds at the cash desk.

NTT includes trade objects that do not have the opportunity to install a personal computer, or to establish a connection with a common information database. This, for example, could be traveling trade or stall.

Receipt of products to the enterprise

In almost all cases, in order to get to the HTT warehouse or retail warehouse, products first go to the wholesale warehouse. Then in this warehouse it is processed and moved to retail.

We will not describe the supply to the wholesale warehouse, since we have devoted a separate material to this. Just so that our further actions are clear, we will give an example of filling out a 1C document:

in the program "1C" for retail

After entering 1C, it is necessary to set retail prices for products. To carry out this operation, use a document called "Setting item prices". The latter is entered in the section named "Warehouse". But we will generate a document based on the receipt document. First you need to go to the previously generated product receipt document and press the button called "Create based on". After that, in the drop-down list, select the item with the name "Set item prices".

Next, a new document window should open, in which all the main details will already be filled in. You will only need to specify the price type. Create two such documents at once so that you do not have to return to this section later. In the existing documents, assign price types under the names "Retail price" and "". Prices must be the same. Further, for example, we offer a document:

The button called "Change" will also provide access to special options for manipulating prices. For example, it is possible to decrease or increase by a certain percentage.

Moving products from wholesale to retail warehouse

And now the necessary products can already be moved from the wholesale warehouse to retail. To this end, in software product there is a document called "Movement of Goods", which is located in a section named "Warehouses".

Before moving, you need to start two trains - one with the sign “Non-automated outlet”, and the second with the composition type “Retail”.

For this purpose, compositions are formed in the section called "Reference books" - "Warehouses".

Let's give the name "Store No. 2" to the first of the compositions, its type - "Retail store". We select the price type from the directory with the name "Nomenclature price types":

The second one will be called Shopping room". The warehouse type will be "Manual outlet", the price type will be "Retail", and the item group will be "Products".

In addition, we will generate two documents "1C 8.3": moving to the warehouse "Trading Room" and "Shop No. 2". Documents must also be generated on the basis of the goods receipt document. AT this case it remains to fill in only the details called "Warehouse - recipient" and the quantity of products:

At the end, the products will be in retail warehouses. There is an opportunity to proceed with the registration of the sale of prepared products.

"1C": report for the store on retail sales

In order to reflect the sale of products in retail, a document called "Retail Sales Report" from the section named "Sales" is useful. To begin with, we will issue a sales document from a retail warehouse. The latter, by the way, is not much different from the document called "Implementation (acts, invoices)". The only difference is that the counterparty is not indicated, and it is immediately possible to reflect the proceeds from the sale itself.

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

Sale of goods in NTT

In the case of the sale of products in a non-automated outlet at the end of the shift, we do not have information on how many products were sold. But it is known exactly how much was moved from the wholesale warehouse. In order to calculate the quantity of products sold, it is necessary to calculate the remaining products in the warehouse, and subtract it from the quantity received. Consider an example: fifty packages of sweets were transferred to NTT, as a result of the trade, thirty packages remained. According to this, twenty packages were sold.

In order to reflect this calculation in the software product, you need to use a document called "Inventory of goods", which is located in the section named "Warehouse".

After that, go to the menu called "Warehouse", then the link named "Inventory of goods". Finally, click on the "Create" button.

After that, add the nomenclature in the table and indicate the actual balance in the warehouse. It is possible to use such a key as "Fill". The deviation from the accounting quantity will just be our sales of products:

Once done, swipe the document and click on the button called “Create Based on” and then select “Retail Sales Report” from the drop-down list. A new document will be generated reflecting the sale of products in NTT.

Reflection of revenue for retail in "1C"

Let's just write it down for now, as the document will not be held at this time. This means that it is also necessary to reflect the receipts of retail revenue in the section called "Bank and cash desk". Here is an example document:

Now you need to post a document named "Retail Sales Report".

The document "Report on retail sales" is intended to reflect sales in retail trade.

"Retail sales report" can be entered on the basis of the document "Inventory of goods in the warehouse", "Reflection of sales simultaneously with receipt of retail revenue" (warehouse type "Wholesale" or "Retail"), "Reflection of sales by previously received revenue" (warehouse with view "Non-automated outlet").

To reflect retail sales from a wholesale warehouse or a warehouse with the "Retail" type in the "1C: Accounting 8" program, do the following (Fig. 1):

Menu: Sales – Sales–Retail sales reports.
Click the "Report" button, then select "Retail Store" or "Hands-held Point of Sale". If an organization retails through an automated point of sale, then the funds technical support or specific trading activities allow you to generate a daily detailed report on the goods sold for subsequent entry into the information base, for example, into the program "1C: Accounting 8". If you select the transaction type of the document "Manual outlet", then the outlet of the organization is considered manual, since there is no daily registration of goods sold in it. Information about goods sold in a manual outlet may be obtained with some delay based on the inventory. At the same time, the number of goods sold for each item is determined as the difference between the credentials from the infobase and the data received by the inventory. In the case of keeping records in sales prices, it is possible to obtain information about the sold goods only in total terms, without a detailed breakdown by product range.
Fill in the required document tabs that reflect the relevant sales or form of payment. On the "Goods" tab, goods and services sold to a retail customer are indicated. In this case, the fields "Price", "Amount", "% VAT", "VAT", "Total" will be filled in automatically based on retail prices and the specified quantity that must be checked.
In the "Account account" field, select account 41.11 "Goods in retail trade (in ATT at sale value)", if the goods are recorded at sale prices and using an automated outlet. The choice of account depends on the settings of the accounting policy (Fig. 2).
To call the printed form "Help-report of the cashier-operator" in the form of KM-6, you can use the button "Help-report of the cashier (KM-6)".

Features of retail sales through a non-automated outlet, or NTT (for types of retail outlets in 1C, see the article) is that in this case there is no way to register sales directly in the program. Information about already completed sales is entered into the information base - the so-called "post-mortem" record is kept.

In "1C: Trade Management 8" (rev. 11.3) there are two options for accounting for sales through NTT - manually and based on the results of the inventory. We will now consider the first option. The registration of retail sales based on the results of the inventory is described in the article.

In 1C, a document called the “Retail Sales Report” is used to reflect the sale of goods from a retail outlet and the receipt of funds at the KKM cash desk.

Let's open the corresponding log of documents.

Sales / Retail Sales / Retail Sales Reports

In the "KKM cash desk" field, select the stand-alone cash register of the cash register of the non-automated outlet from which the sale was made.

Important. Manual creation of the “Retail sales report” document is only possible if a cash register with the “Autonomous cash register” type is selected in the corresponding journal in the “KKM cash register” field.

Create a “Retail Sales Report” by clicking the “Create” button. In the new document, the KKM cash register, as well as the retail store linked to it, are already filled in automatically (the latter is not available for change).

On the “Products” tab, we will enter the sold products by manually adding lines (the “Add” button) or selecting them (the “Fill - Pick up products” button). Please note that the price of the product is also filled in automatically and cannot be edited (since the price is linked to the store).

In the "Client" column, the program has substituted a predefined element from the partner directory - "Retail buyer", it should not be changed.

In addition to the sale of goods, the document is intended to reflect the acceptance of payment for the goods sold. If no other methods of payment are recorded, the program “considers” that the payment was received in cash, and when conducting the “Retail Sales Report”, it registers the receipt of money at the KKM cash desk indicated in it.

The Retail Sales Report document allows you to register payments with payment cards, gift certificates, bonus points, and reflect accrued bonuses. There are corresponding tabs for this. Some of these features will be discussed in future articles.

Let's carry out the document "Report on retail sales". After that, by clicking the "Document Movements" button, you can see the movements in the registers - goods in warehouses, free balances, cash at the cash desks of KKM and others.

Statement of cash at the cash desk of KKM

After the retail sale is completed, we will make sure that there is money at the cash desk of the KKM using the report.

Sales / Sales Reports / Retail Sales / Cash at KKM

Let's generate a report on our KKM checkout. The receipt of cash from sales is reflected in the cash desk.
Transferring money from the cash register of KKM to the cash desk of the enterprise
Cash received during retail sales and located in the box of an autonomous cash register must be transferred to the cash desk of the enterprise. This operation is executed in 1C using the document "Incoming cash order".
Let's open the corresponding magazine.
Treasury / Cash desk / Incoming cash orders
Let's create a new document with the type of operation "Receipt from the cash desk of the cash register".
In the created document, on the “Basic” tab, in the “Cashier” field, we indicate the recipient of the money - the cash desk of the enterprise (if the cash desk was indicated in the journal of orders, then when creating a new order, it is filled in automatically). In the field "Cashier of KKM" we will select the KKM from which the money is received.
The amount must be entered manually.
Important. If the organization is a VAT payer, in addition to the amount of receipt, you must manually enter the amount of VAT in the incoming cash order for receipt from the cash register of KKM.
Do not forget to specify the details for printing the incoming order on the "Print" tab.
After filling out the document, we will conduct it.
If we now reformat the statement of cash at the cash desk of KKM, it will reflect both the receipt of sales and the issuance of money from KKM - in the column "Receiving retail revenue".
Statement of cash
The movement of money from the KKM cash desk to the enterprise cash desk can be seen in the Cash Statement report. Let's open this report.
Treasury / Treasury reports / Statement of cash
Let's create a report on our organization. By default, reports are generated in the currency of management accounting (in our example, US dollars). The report reflects the movement of cash: receipt and write-off from the cash register of KKM, receipt at the cash desk of the enterprise.

1C offers ample opportunities for keeping records of retail trade. In this article, we will look at:

how to reflect retail sales in 1C 8.3 Accounting;
what is important to consider when filling out the Retail Sales Report document in 1C 8.3;
what determines which postings will be generated in 1C in retail.

In retail, outlets are delimited by automation. Automated and non-automated outlet in 1C 8.3 - what is it?

Automated Point of Sale (ATT) is retail outlet, in which during the day they are issued. At the end of the shift, the cash desk closes and a detailed report on the goods sold at retail is generated.
A non-automated point of sale (NTT) is a retail point where during the day CCP checks are not reflected in the database, and only a detailed report on goods sold for a certain period is entered into it.

Retail accounting setup

If the organization is engaged in retail trade, then in the settings in the section Main - Settings - Accounting policy ask Method of valuation of goods in retail :

By purchase price- goods in the warehouse are accounted for at cost, while the trade margin on account 42 "Trade margin" is not taken into account. Accounting for the cost of goods is carried out on the account "Goods in retail trade (at purchase price)".
By selling price- goods in the warehouse are accounted for at the selling price, while the trade margin for goods is reflected on account 42 "Trade margin". Accounting for the cost of goods is carried out:
- for ATT - "Goods in retail trade (in ATT at selling value)";
- for NTT - "Goods in retail trade (in NTT at selling value)".

If goods are posted at sales value, for NTT, define .

Retail outlets (warehouses) in 1C

Retail outlets are reflected in the directory Warehouses In chapter Directories - Goods and services - Warehouses.

It is in the warehouse card that it is specified that it is a retail store or a non-automated point. This attribute is indicated in the field Warehouse type :

For NTT, if records are kept in sales prices, also indicate Nomenclature group of retail revenue . Then when posting the document Retail sales report in 1C 8.3, the analytics for account 92.01.1 “Revenue from activities with the main taxation system” will be filled in.

Be sure to ask Price type for retail (including NTT) warehouses. And also set the price using the document Setting item prices .

Automated outlet in 1C 8.3

Consider how to fill out a retail sales report in ATT using an example

The organization sells goods at retail through ATT. Accounting is carried out without using account 42 "Trade margin".

On April 18, the following products were sold individuals for a total amount of 70,800 rubles. (including VAT 18%):

Blinds "Plastic (white)" - 20 pcs. at a price of 3,540 rubles.

Payment for goods is made in cash at the checkout.

Retail sales of goods

Complete a detailed report on the goods sold in ATT document Retail sales report transaction type Retail store In chapter Sales - Retail Sales - Retail Sales Reports - Report - Retail Store.

Stock Directory Warehouses, Warehouse type Retail store.

On the tab Products indicate the goods sold from reference book Nomenclature.

accounting account filled in the document automatically, depending on the settings in the register Item accounting accounts . You can change it manually if necessary. Learn more about .
Subconto- the item group related to retail trade is selected from of reference Nomenclature groups.

If payment is not made in cash at the cash desk retail store, then all types of non-cash payments (by payment card, electronic means etc.) indicate on the tab Cashless payments .

postings

Postings in ATT will be standard and depend only on the accounting policy setting (which account is used).

At the end of the shift, when the retail proceeds are transferred from the operating cash desk to the main cash desk of the organization, an incoming cash order is created (clause 4.1 of the Instruction of the Bank of Russia dated March 11, 2014 N 3210-U).

based on document Retail sales report by button Create based on - Cash inflow.

In the document, indicate:

Stock- retail outlet, selected from Directory Warehouses, Warehouse type Retail store;
Amount of payment

The document does not generate postings in accounting records and accounting records. The receipt of cash in the debit of the account "Cashier of the organization" is reflected in the document Retail sales report .

With this document, you can create printed form Incoming cash order (KO-1).

Non-automated outlet in 1C 8.3

Consider how to fill out a retail sales report at NTT.

The organization retails goods through NTT. Accounting is carried out without using account 42 "Trade margin".

Fabric "Blackout Scarlett" - 100 running meters.

Fabric "Jacquard Sylvia" - 100 linear meters.

There were no other receipts to the warehouse during May.

In May at online cashier the organization received retail revenue in the amount of:

May 06 - 12 980 rubles.

May 18 - 11,210 rubles.

May 23 - 14,750 rubles.

May 31 - 8 850 rubles.

Fabric "Blackout Scarlett" - 65 running meters.

Fabric "Jacquard Sylvia" - 20 linear meters.

On the same day, based on the inventory, a retail sales report was generated for a total of 47,790 rubles:

Fabric "Blackout Scarlett" - 35 running meters. at a price of 826 rubles.

Fabric "Jacquard Sylvia" - 80 linear meters. at a price of 236 rubles.

Unlike ATT, in this case, the retail revenue is first entered into the posting, and then a detailed report on the goods sold is entered.

Posting retail receipts to the cashier

The posting of retail revenue to the main cash desk of the organization is issued document Cash inflow transaction type Retail revenue In chapter Bank and cash desk - Cash desk - Cash documents.

In the document, indicate:

Stock- retail point, selected from the directory Warehouses , Warehouse type - Non-automated outlet;
Amount of payment - the amount of retail proceeds handed over to the cashier.

postings

Revenue received by the cash desk from a retail store (NTT) is considered undistributed until the document is entered Retail sales report , and is reflected in:

Dt - revenue,

Dt - VAT.

Retail sales of goods

Complete a detailed report on the goods sold in NTT document Retail sales report Transaction type Hands-on point of sale In chapter Sales - Retail Sales - Retail Sales Reports - Report - POS.