Accounting 3.0 report on retail sales. Document “Report on retail sales. How to make a retail sales report "manually"

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 in detail the filling of this document 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, 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 go 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 point-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 figure above, the “Deviation” column reflects, in fact, the quantity 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" includes all data from the column "Quantity 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:

We propose to consider how the retail sale process takes place in a non-automated retail outlet based on the 1C 8.3 program, Accounting version 3.0.

A non-automated retail outlet (NTT) is a retail facility that does not have the ability to directly access the 1C database. This can be a retail store, kiosk, marketplace, or off-site.

Reflecting retail sales involves creating multiple related documents. It:

    Receipt of goods.

    Setting prices.

    Moving.

    Sale from a retail warehouse in NTT.

    Collection or receipt of proceeds.

Retail items are sold from a retail warehouse. Where it gets by moving from a wholesale warehouse. Let's analyze the initial receipt of goods. This process is registered with the document “Receipt of goods and services”. The fields are filled in the header:

    Invoice No. - the number of the supplier's document.

    Original received - put a tick in the box if the supplier presented original documents for the delivery of goods.

    Number and date are generated automatically in order.

    Organization - if one organization is registered in the accounting policy of the 1C program, then the field is filled in automatically, or it is absent. And if accounting is kept, for example, remotely through 1C in the cloud for several organizations, then we select the necessary company from the directory.

    Warehouse - we indicate to which warehouse the consignment of goods is received, it is selected from the directory. Typically, this is the "Main warehouse" or "Wholesale warehouse".

    A business partner is a supplier organization. We select from the directory of contractors or create a new one.

    Agreement - is inserted automatically after choosing a counterparty.

    Invoice for payment - is selected from the journal if it was previously issued. If not checked out, the field remains empty.

    Settlements - this item can be configured depending on the type of settlement with the counterparty. It is enough to click on the link and indicate the desired type.

    The consignor and consignee is a link by clicking on which it is possible to specify or change information. Used when the data differs from the stated.

    The item with VAT is reflected automatically based on the entered parameters in the counterparty card and accounting policy.

The tabular section of the document can be filled in in any of the following ways:

    Through the "Add" button. Each item is individually selected from the stock list and the quantity is manually specified.

    Through the "Selection" button. In this case, an item with the required quantity is selected from the stock list and is massively transferred to the document.

After adding the product, if necessary, you can specify the information in the columns "CCD number" and "Country of origin".

After entering all the data, we check and conduct. If the supplier has provided an invoice, you must register it by entering the number and date in the appropriate field at the bottom of the document. The goods are capitalized. Now you need to establish the cost at which it will sell. For this, there is a special document "Setting item prices". Located on the Warehouse menu tab. Filling in the document is done manually. In the 1C program, it is possible to massively set prices directly from the receipt document, this is very convenient and saves time. We go into the created document "Receipt of goods and services" and press the button "Create on the basis". In the drop-down list, select the item "Set prices of the item". A form filled with master data will open. All you need to do is select the type of price in the corresponding field.

Based on the receipt, you can create several documents "Setting item prices" with different types of prices (if it is not possible to enter all the required types of prices).

The form contains the item "Register zero prices". If the box is checked, then it is better to remove it. Otherwise, for goods for which a new value has not been established, a price with the value "0" will be registered. It is unacceptable.

You can adjust the price value (increase or decrease by%) using the "Change" button. The cost of the goods is assigned, it can be moved to the outlet. It could be NTT or a trading floor. The process is drawn up through a special document "Transfer", the journal with which is located on the "Warehouse" menu tab. This is useful if you need to move a small number of positions. During a mass transfer, a “Transfer” is usually generated from the receipt document through the “Create on basis” key. All fillings take place according to the document-base, it remains only to specify the type of the receiving warehouse and manually set the number of the moved commodity units.

Based on the receipt, you can create several “Transfer” documents to different warehouses. In this case, the quantity is edited manually. If you suddenly made a mistake and indicated more than is listed in the warehouse, the program will display an error displaying the name of the product.

Now you can sell the product. If sales are carried out from the warehouse "Trading hall", then at the end of the working day, a "Report on retail sales" is generated. All goods sold will be displayed here. The report is created for the warehouse, which you need to select yourself, showing the revenue:

Fields are filled:

    Warehouse - for which warehouse the report is generated.

    DDS article - it is necessary to indicate "Cash receipts, retail proceeds".

    Cash account - an account used to keep records of revenue.

If necessary, you can enter the "Account" and the Account of income ", if not automatically substituted, and subconto.

To report retail sales at a manual point of sale, you must first take an inventory. We go to the "Warehouse" menu tab and select the item "Inventory of goods". The head of the document indicates the warehouse and organization. Adding goods in bulk is carried out through the "Fill" button. From the drop-down list, select "Fill in the warehouse balances". The tabular section will display all the items listed for the specified warehouse. After recounting the goods, the available balance is entered in the column "Actual quantity". The column "Deviation" will reflect the quantity of goods sold.

After carrying out the inventory, directly from the document, through the "Create on the basis" button, we form the "Sales report". But the report will not be carried out until the receipt of proceeds is registered in 1C. To do this, go to the "Bank and Cashier" menu tab and form the "Cash receipt" document.

We fill in the fields:

    Transaction type - retail revenue.

    Warehouse - at which warehouse the sales were made.

    Amount - the amount of revenue.

    In the tabular section, add a line indicating the payment amount and the DDS article.

We post the document. Then we go back to the sales report and run it.

This guide will guide you through the steps of all retail transactions in. I want to consider the following points here: setting up transactions in a retail sales report, goods receipt and movement at retail, sales from a retail warehouse, sale of goods at manual point-of-sale (NTT), and receipt or collection of proceeds at the cashier.

Non-automated retail outlets in 1C are trade objects in which there is no way to put a computer or establish a connection with a common database. Sales data are not entered daily. This is, for example, a stall or exit trade.

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.

I will not describe the arrival at the wholesale warehouse, as there is about it. I will give just an example of filling out a 1C document so that my further actions are clear:

Setting item prices in 1C for retail

After receipt, you need to set retail prices for goods in 1C. For this, the document ““ is used. It is entered in the "Warehouse" section. But we will 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, all that remains is 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 price" types. We will make the prices the same. Here's an example doc:

By clicking the "Change" button, special options for manipulating the price 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. For this, the program uses the document "". It is located in the "Warehouses" section.

Get 267 1C video tutorials for free:

Before making a transfer, we 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 Hall". “Warehouse type” - “Non-automated retail outlet”, Price type “Retail”, - “Products”.

Let's also create two documents 1C 8.3: "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" requisite and the quantity of goods:

As a result, the goods have a price for us and are 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, we 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 ““. 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 point of sale at the end of a shift, we do not know how many goods were 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?

To calculate the quantity of goods sold, you need to calculate the balance of the goods in the warehouse and subtract it from the receipt quantity. For example, 50 packages of chocolates were transferred to NTT, after the sale, 30 packages remained. Accordingly, 20 packages were sold.

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

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

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

The Retail Sales Report document is intended to reflect retail sales.

"Report on retail sales" can be entered on the basis of the document "Inventory of goods in the warehouse", "Reflection of sales at the same time the receipt of retail proceeds" (warehouse type "Wholesale" or "Retail"), "Reflection of sales by previously accepted proceeds" (warehouse with view "Non-automated retail outlet").

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

  1. Menu: Sales – Sales– Retail Sales Reports.
  2. Click the "Report" button, then select "Retail store" or "Manual point of sale". If an organization carries out retail sales through an automated point of sale, then technical support or the specifics of trading activities allow you to daily generate a detailed report on the goods sold for subsequent entry into the information base, for example, into the "1C: Accounting 8" program. If you select the type of operation of the document "Non-automated sales outlet", then the sales outlet of the organization is considered non-automated, since it does not conduct daily registration of the goods sold. Information about items sold at a manual point of sale may take some delay based on inventory. In this case, the number of goods sold for each item is determined as the difference between the credentials from the infobase and the data obtained by the inventory. In the case of keeping records in sales prices, it is possible to obtain information on goods sold only in total terms, without a detailed breakdown by nomenclature.
  3. Fill in the required document bookmarks 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, which must be checked.
  4. In the "Accounting account" field, select account 41.11 "Goods in retail trade (in ATT at sales value)" if the accounting of goods is carried out at sales prices and using an automated point of sale. The choice of account depends on the settings of the accounting policy (Fig. 2).
  5. To call the printed form "Help-report of the cashier-operator" in the form KM-6, you can use the button "Help-report of the cashier (KM-6)".

 

It might be helpful to read: