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.

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

Print versions
Input based

When filling out the document at the top, you must define the following parameters:

* Storage location - retail outlet where retail sales are generated.
* Price type - the price of the product at which sales are created. Set from several acceptable prices for the product. The price type is entered automatically by the price type that is 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 item is a cash flow item that will reflect the receipt of retail proceeds to the organization’s cash desk.

Formation of sales at the same time as receipt of retail revenue

To create a retail sale from a wholesale warehouse or from a warehouse with the "Retail" type, you must specify a cash register operation. After selecting an operation, you need to fill out the bookmarks:

*Agency services

* Payment cards and bank loans

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

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

(principal)".

The Payment cards and bank loans panel displays buyer payments made by payment card or with bank loans.

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

Formation of sales based on previously accepted revenue

To create a retail sale from a warehouse with the type "NTT", you need to specify the NTT operation. After selecting an operation, you need to fill out the bookmarks:

*Agency services

The Products panel displays goods and services sold to a retail consumer. The panel is entered based on the results of the inventory in point of sale 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 - are entered automatically when specifying an item based on the Item Accounting register.

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

* Income account and Expense account - specify whether this sales line relates to activities with a special tax treatment. It is unacceptable to define for income and expenses accounts related to various types activities.

The Agency Services panel displays services for which our organization acts as an agent.

* Counterparty - the 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 look like “With the principal
(principal)".

* Settlement account - select the account for settlements with the principal under the agency agreement, which will reflect the principal’s revenue for the agency services sold.

Print versions

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

* KM-6 (Clerk-operator report)

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 calculations

Document Retail sales report in 1C generalized data for the period are reflected. After posting the document, the items listed in it will be deregistered. You can find this document in 1C 8.3 in the section Sales → Sales → Retail sales reports:

A retail sales report in 1C 8.3 is created:

• Automatically as a result of an operation Close shift;
• Based on document Inventory of goods;
• Can be created manually.

How to make a Retail Sales Report when selling through an automated point of sale (ATP) in 1C 8.3

In 1C 8.3, retail sales in a retail store (ATT) or from a wholesale warehouse are documented Retail sales (checks). In this case, each sale is recorded with a separate receipt.

Example

In a retail store (warehouse “Store Warehouse No. 2”), 06/20/2016. Three checks were punched during the shift:

• Receipt No. 1 sold: zipper 20 cm – 2 pcs. and threads - 1 pc.;
• Receipt No. 2 sold: buttons – 5 pcs. and ballpoint pen – 1 pc.;
• Receipt No. 3 sold: ballpoint pen – 3 pcs.:

At the end of the working day in the store or at the time of closing the cash register shift, it is necessary to perform the operation Close shift. This operation in 1C 8.3 is available in the document log Retail sales (checks):

As a result of performing this operation in 1C 8.3 Accounting 3.0, the following documents are automatically generated:

• Retail sales report;
• Cash receipt with transaction type – Retail revenue:

Each of these documents will be reflected in its own journal. In 1C 8.3, these documents are generated, recorded, but not posted. It is necessary to check that the information in the created documents is filled out correctly. If we are convinced that all the information in the documents is filled out correctly, we will check them:

In the document Retail sales report the same nomenclature will be written in one line, taking into account returns. In our example this is "Ballpoint pen". This item was punched in check No. 2 in the amount of 1 piece, and in check No. 3 in the amount of 3 pieces. Since there were no returns during the day, we see in the report that 4 ballpoint pens were sold.

In the document Cash receipt the total total revenue from punched checks, including returns, is reflected.

How to reflect product returns in the Retail Sales Report

As noted above, when automatically generating a document Retail sales report 1C 8.3 takes into account all returns made during the cash register shift.

Let's look at this situation with an example. To do this, we will use the example data above and assume that according to receipt No. 2, the product “Ballpoint pen” in the amount of 1 piece was returned. Return to 1C 8.3 is reflected in the document Check (Return):

After posting this document in the journal Retail sales (checks) a receipt with the type of transaction will be displayed Return:

Let's close the cash register shift and see that the report reflects sales including returns. Namely: goods "Ballpoint pen" was punched in check No. 2 in the amount of 1 piece, and in check No. 3 in the amount of 3 pieces. and a refund was made in the amount of 1 piece. Therefore, in the report we see that 3 ballpoint pens were sold:

How to make a Retail Sales Report manually

Let's consider the option of manually filling out a retail sales report in 1C 8.3 Accounting 3.0. This option is used when in 1C 8.3 each sale is not documented in a separate document Retail sales (checks), and sales are immediately entered into the Retail Sales Report document.

Using the example data given above, let's fill out the document manually by following these steps: section Sales → Sales → Retail Sales Reports → Report → Retail store:

Using the button Pick up fill out the document table:

Document Cash receipt With this type of registration, retail sales must also be completed manually. This can be done using the mechanism Create based on. The created document will reflect the total revenue for the document Retail sales report:

How to fill out a Retail Sales Report when selling through non-automated retail outlets (NTT) in 1C 8.3

A manual point of sale in 1C 8.3 is a store in which sales data is not entered daily.

Document preparation Retail sales report to reflect sales in NTT depends on how the accounting department receives sales information. Information can be submitted in two ways:

• Information about the goods sold is provided;
• An inventory is being taken.

Both can be done daily or at intervals specified in the organization’s document flow. Let's consider both methods.

Method No. 1

For example, the accounting department receives daily information about the goods sold. In this situation, in 1C 8.3 we draw up a document Retail sales report. Chapter Sales → Sales → Retail sales reports → Reports → Manual point of sale:

In the header of the document, select the warehouse. In the tabular section, using the Add or Select button, we indicate the product sold per day. The document is ready:

Method number 2

Let's assume that the organization does not submit sales information, but takes inventory of the warehouse every three days. Then the actions in 1C 8.3 will be as follows:

• We come to retail revenue;
• We carry out inventory in the warehouse. Forming a document Inventory of goods;
• We prepare the document Retail sales report n and based on the inventory document .

In the inventory document we indicate the actual balances of goods in the warehouse. In lines where the actual quantity does not coincide with the accounting quantity, a deviation is reflected. The deviation will reflect sales:

Using mechanism Create based on, create a document Retail sales report:

Whether all of this product was actually sold or part of it is a shortage, the 1C 8.3 program will check during the document processing Retail sales report, since before this document is carried out it is necessary to capitalize retail revenue. Otherwise, it will not be possible to post the document Retail Sales Report in 1C 8.3:

If the capitalized revenue does not coincide with the amount indicated in the report, then this report on retail sales in 1C 8.3 is not carried out. Therefore, it is necessary to find out the reasons for the discrepancy:

In this article, we will look in detail at all the main operations when maintaining retail trade records in the 1C Accounting 8.3 program, including sales at non-automated retail outlets.

Often, before goods purchased from a supplier are transferred to retail, they first arrive at a 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 retail outlet. You can safely bring them to the retail warehouse.

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

We will not show in detail how to fill out 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 “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 buyer. But before we do this, we need to set retail prices - those at which we will begin to sell these goods.

They are located in the “Warehouse” menu, but to simplify 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 included goods from the receipt. Let’s fill in the prices for each item and indicate the price type (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 the goods at the wholesale warehouse, then you will need to transfer them to the retail warehouse or to a manual point of sale. The latter refers to points such as a stall, a market tent 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 will be practically no different from the wholesale one except for the type.

As a result, we will get a sales area of ​​store No. 23 with the “Retail store” type.

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

In our example, both warehouses use same type prices, but you can set different ones. Then you will have to create two “Setting 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, 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 moving goods from the main wholesale warehouse to a kiosk at the railway station.

Retail sales report

If you have completed all the previous steps correctly, then your retail warehouse will already contain goods with completed sales prices to the final buyer.

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

In the header of the document we indicated the organization and retail warehouse " Shopping room store number 23." The cash register account, as expected, is 50.01. Also for the purpose of additional analytics on management accounting we indicated the DDS item “Retail revenue”.

Sales in manual retail outlets

Above we took into account sales in a retail store. Now let's move on to a non-automated point of sale - a “stall”.

Manual retail outlets in 1C are points where it is not possible to install a computer and establish a connection with common base data. Sales data is not entered regularly.

Cash receipt

The first step is to reflect the receipt of cash with the transaction type “Retail Revenue”. If in a retail store the buyer could pay for the goods by bank card, then this is unlikely here.

An example of a completed document is shown in the figure below. If you have missing revenue, you simply won’t be able to report on retail sales.

Reflection of retail sales

Let's assume that our seller does not write down in a notebook how many of which goods he sold. In this case, it is most logical to obtain 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 will indicate the organization, our warehouse “Stall at the railway station” and, if necessary, . For convenience, we will fill the goods according to the balances in the warehouse. After this, you need to indicate how many products actually remain in the “Actual Quantity” column.

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

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

The form of the created document opened in front of us, in which absolutely everything was filled out automatically. Please note that the “Quantity” column includes all the data from the “Quantity fact” column of the inventory document.

If you did not take into account the revenue received 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 video instructions for reflecting such operations:

The document “Report on Retail Sales” is intended for registration of retail sales.

The document “Retail Sales Report” records the fact of shipment of goods and the fact of receipt Money to the KKM cash desk.

The “Retail Sales Report” document can be issued from both a wholesale and a retail warehouse. This document can also be used to record sales of goods at a manual point of sale. When registering sales at a manual retail outlet, control is carried out on those prices that are assigned for the sale of goods at a manual retail outlet.

Reception of retail revenue from the cash register cash register to the company's cash desk is carried out using the document "Cash receipt order" with the established type of operation "Reception of retail revenue".

The “Retail Sales Report” document can be generated automatically using the “Cash Shift Closing” processing.

In the tabular part of the document there is a “Warehouse” attribute, which allows you to conduct sales using one cash register from different warehouses (for example, in different sections of the store).

If the document is generated automatically using the “Closing cash register shift” processing, then the “Warehouse” attribute in the tabular part of the document will be filled in automatically in accordance with the information about the warehouse indicated in the cash register receipts.

The “Retail Sales Report” document can also be generated on the basis of the “Inventory of goods in warehouse” document.

In this case, the tabular part of the document is automatically filled in based on the inventory results 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 product item, just like in all other documents.

As with any other implementation document, this document provides the ability to select a product item with certain characteristics and series.

In accounting and tax accounting, the document “Retail Sales Report” reflects the sale of goods and services. In the event that previously revenue was received from non-automated retail outlets, the “Retail Sales Report” document redistributes the previously recorded revenue (with the “Cash Receipt Order” document). Redistribution is carried out by reversing it and generating entries with clarification of the nomenclature groups of goods and services sold, as well as whether goods of their own or those accepted for commission were sold.

Reflection in retail sales accounting is one of the most common transactions in trade. Retail sales in 1C 8.3 Accounting are accounted for using a special document - a retail sales report. Filling out this report can be automated, or you can generate it manually. Read this article on how to fill out a retail sales report in 1C 8.3.

When selling goods at retail, several transactions must be reflected in accounting:

• Receipt of funds from the buyer (cash or non-cash);
• Reflection of revenue on the credit of account 90;
• Write-off of cost of goods sold.

In 1C 8.3 Accounting there is a special document that forms these operations - a retail sales report. There are two ways to create it:

1. In automated mode
2. In manual mode

If a store has equipment and software that records all product movements online, then such a retail outlet is considered automated. In this case, using special 1C software, you can automatically generate a report on retail sales in 1C 8.3.

If the store does not have equipment for detailed accounting of sales, then such a retail outlet is considered non-automated. The report on retail sales in such cases is done manually or based on inventory. As a rule, non-automated points are trays, kiosks and small shops.

In 1C 8.3 Accounting in the “Warehouse” directory, for each retail outlet you need to select one of two types of warehouses:

1. Retail store;
2. Manual point of sale.

For stores with automated accounting, choose the first type of warehouse. For other points of sale, select the value “Manual point of sale”.

How to make the necessary settings in 1C 8.3 Accounting in a few steps and fill out a report on retail sales, read in this article.

Step 1. Set up 1C 8.3 Accounting for retail trade

To account for retail in 1C 8.3 Accounting, you need to make some settings. To do this, go to the “Administration” section (1) and click on the “Functionality” link (2).

In the window that opens, go to the “Trade” tab (3) and check the box next to the inscription “ Retail" (4). If necessary, also check the boxes next to the words “Gift Certificates” (5) and “Alcohol Products” (6). Now the 1C 8.3 Accounting program is ready for retail accounting.

In retail, there are two ways to account for product valuation:

• By purchase price;
• At sales price, using account 42 “Trade margin”.

It is necessary to establish one of the methods in the accounting policy of the organization. To do this, go to the “Main” section (7) and click on the “Accounting Policy” link (8).

In the window that opens, indicate your organization (9) and select one of the assessment methods:

• “At acquisition cost” (10);
• “At sale price” (11).

The necessary settings have been made, and you can begin recording retail transactions.

Step 2. Create a report for a manual point of sale manually

If your store is not equipped automated system accounting for sales, then you can generate a report on retail sales in 1C 8.3 Accounting manually. To do this, go to the “Sales” section (1) and click on the “Retail Sales Reports” link (2).

In the window that opens, you see a list of previously created documents. Click the “Report” button (3) and select the “Manual point of sale” link (4). A form for creating a document will open.

In the window that opens, specify:

• Formation date (5). If the report is generated over several days, put the last date of the period;
• Your organization (6);
• Warehouse (Retail outlet) (7). A separate warehouse is created for each point. We remind you that the warehouse type in this case should be “Manual retail outlet”;
• DDS article (8). Select the value “Retail revenue” from the directory.

In the product section, fill in:

• Sold item (9);
• Its quantity (10);
• Selling price (11);
• VAT rate (12).

To conduct, click the “Post and close” button (13). The document will be posted only if cash receipt orders or payment card transactions are created during the reporting period. Moreover, the amount in the report must match the amount of payments at the cash register and card transactions. If the amount of payments for the reporting period is 140,000-00 rubles, and the amount of goods sold in the sales report is 145,000-00 rubles, then when posting the document there will be an error message: “Available retail revenue for sales: 140,000, required: 145,000. Missing the proceeds must first be capitalized using the Cash Receipt document.”

The document has now appeared in general list reports. When it is carried out in accounting 1C 8.3 Accounting, entries are generated to write off the cost of goods sold. Also, postings are created on the off-balance sheet accounts of RV “Retail Revenue” and postings for adjusting revenue in account 90 “Revenue” (entries for the total amount are reversed and new ones are generated, broken down by item and quantity).

Step 3: Create an Inventory Report

A report on sales at a manual point of sale can be created from an inventory document. This document automatically calculates the accounting quantity of goods on the inventory date. It also manually indicates the actual quantity of goods identified as a result of the recalculation. The difference between the accounting and actual quantities of goods will be transferred to the retail sales report. Next, read how to create such a report in 1C 8.3 Accounting.

Create an inventory of goods in 1C 8.3

Go to the “Warehouse” section (1) and click on the “Goods Inventory” link (2). A window with previously created inventories will open.

In the window that opens, click the “Create” button (3). The inventory form will open.

In the “Product Inventory” window, specify:

• Inventory date (4);
• Your organization (5);
• Retail outlet (warehouse) (6);
• Responsible person (7).

Now in the product section in the “Accounting quantity” field (10) we see the balances according to the data accounting. In the “Actual quantity” field (11), manually enter the actual quantity of goods as of the inventory date. After this, the quantity of goods sold will be automatically calculated in the “Deviation” field (12). To carry out an inventory, click the “Record” (13) and “Conduct” (14) buttons.

Generate Retail Sales Report from Product Inventory

To create a sales report, click the “Create based on” button (15) and select the “Retail sales report” link (16). The completed sales document will open.

In the document that opens, indicate the correct date (17), check the quantity sold (18) and selling price goods (19). To reflect sales in accounting, click the “Post and close” button (20). Now in accounting there are entries for writing off the cost of goods sold. Also, entries were generated on the off-balance sheet accounts of RV “Retail Revenue” and entries for adjusting revenue in account 90 “Revenue”.

Step 4: Create a retail sales report for the automated point of sale

If your store is equipped with an automated sales accounting system, then a retail sales report in 1C 8.3 Accounting is generated automatically. To see it, go to the “Sales” section (1) and click on the “Retail Sales Reports” link (2). A list of previously created documents will open.

There are two types of reports in the list:

• With the type of operation "Retail store";
• With the type of operation “Manual point of sale”.

In reports on an automated point of sale, the type of operation should be “Retail store” (3). This report, as we have already said, is automatically loaded into 1C 8.3 Accounting. The loading schedule depends on software your store. Before running the report, go into it and check all the data. To enter it, double-click on it in the general list of reports (4).

In the report that opens, check the date (5), point of sale (warehouse) (6), quantity (7) and selling price (8) of the goods sold. At the bottom of the window, check the total amount (9) with the amount of payment received for the reporting period. These two indicators should be equal. After checking, check the document. To do this, click the “Post and close” button (10). Now, accounting entries have been created for writing off the cost of goods sold and for recording revenue. Also, the report on retail sales for an automated point of sale generates transactions for receipt of cash payments. This differs from a report on a manual point of sale, where payment transactions are generated by receipts.

A report on an automated point of sale can also be created manually, similar to a report on a manual point of sale.

Attention - this is important! As we have already said, the report on retail sales at an automated point itself generates transactions for the receipt of cash payments. In order for these payments to be reflected in cash book you need to create a cash receipt order. In order not to double the entries for the receipt of money in accounting, in the cash receipt order in the “Type of transaction” field, you must indicate “Retail revenue”. In this case, the receiver will not generate accounting entries, but will be reflected in the cash book.