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)”.

Show filling in detail of this document within the scope of this article we will not. 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 the same type of 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 Sales Reports. retail sales" 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 get down to manual point of sale- “stall”.

Non-automated retail outlets in 1C are points where it is not possible to install a computer and establish a connection with a common database. 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 a buyer could pay for an item with a bank card, 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:

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.

For an accountant every day

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

• Admission Money 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.

Quick transfer of accounting to BukhSoft

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 now appears in the general list of 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 the cash book, it is necessary 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.

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

Who can benefit

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

• use ;
• download the cash register module of Kontur.Market;
• use 1C: Enterprise 8.x in one of the following configurations: Enterprise Accounting 3.0, Management manufacturing enterprise 1.3, Complex automation 1.2.

Procedure for downloading the report:

1. In 1C in the menu “ File» select the item « Open»:
2. From the list of files, select Contour.Market_Demo.epf:
   
3. Select the start and end dates of the period, then click " Update»:
   
4. Sales information for each day of the period will be loaded. By clicking on one of them, below you can see sales data for that day:
   
5. The two leftmost columns contain the product name. Moreover, in the first the name is taken from the 1C nomenclature, and in the second - from Contour.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 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 in a similar way:
   
8. When everything is ready, click the " Create a document in 1C" The system will download the report and show that it has been created:
   

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 closing time cash register shift, you need to perform an 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 such registration of retail sales, it is also necessary to register 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:

Retail sales report

The Retail Sales Report document is used to record retail sales. The Retail Sales Report document can be registered from both a wholesale and a retail warehouse (warehouse type -retail store). With the help of this document, it is possible to register sales of goods at a manual point of sale. Acceptance of retail revenue from the cash register cash register to the company cash register is carried out using the document
Receipt cash order with a given type of operation Receipt of cash from the cash register cash register.

A report on retail sales can be created automatically during the closing of a cash register shift, while working
Cash register in the fiscal registrar version. The retail sales report displays summary information about all products that were processed using cash register receipts during a cash register shift. The report also records information about discounts that are provided

Archiving of receipts can be done automatically while posting the Retail Sales Report document or done separately regulatory task Archiving of cash register receipts. How receipts are archived is determined by setting up accounting details (Archive cash register receipts during the closing of a cash register shift).

The retail sales report can be loaded automatically when the cash register is running in the OffLine version based on retail sales data sent from the cash register. The report is loaded in the Exchange with connected OffLine equipment processing.

using a scanner?

What information must be included in the retail sales report to record NTT sales?

The retail sales report must include information about the autonomous cash register that is assigned to
NTT and the warehouse that is specified for NTT. This information is entered in the necessary details of the KKM Cashier and
Storage.

Note. When filling out a document from the list with a given selection at the cash register counter corresponding to NTT, this information is entered into the document automatically.

How to fill out information about goods sold in NTT?

* In the lower table of the document, click on the Submit button.
* Products are entered by selecting from the Nomenclature directory.
* Select the quantity of goods sold in NTT.
* The price for the product is entered with the price value that is fixed according to the price type that is defined for the NTT warehouse specified in the document.
* The price is entered in the currency that is assigned to the NTT cash desk (Cashier
KKM).
* If accounting is created for a product by packaging or characteristics, then select the desired characteristic or packaging of the product.

How to fill out information about the discounts that are provided during the sale of goods in NTT?

Information about discounts that were provided in NTT during the sale of goods is recorded for each product. The discount can be entered as a percentage or as an amount.

* The discount percentage for the product is filled in the %manual field. When you fill in the discount percentage, the discount amount is automatically calculated.
* The discount amount for the product is filled in the Manual Amount field. When you fill in the discount amount, the discount percentage is automatically calculated.

How to process payment with payment cards if the consumer paid for goods sold at NTT with payment cards?

Information about payment by payment cards is registered on the Payment by payment cards page.
The amount for each payment card used to pay for goods is registered, specifying the card number and payment amount. At the same time, the possibility of using several acquiring terminals in NTT for fixing payments with payment cards has been released.

* Go to the Payment cards page.
* Click on the Deposit button.
* Indicate the acquiring terminal in which payment by payment card was recorded. The list for selection displays only those terminals that are specified for the NTT cash register (cash register specified in the document).
* Select the card number and payment amount.
* Register payments for other payment cards in the same way.

How to register a case of selling goods in NTT?

After entering all the required data in the Retail Sales Report document, click on the Post and close button.

When filling out the bottom table of a document, how can you understand that for a product record you need to determine series or expiration dates?

If the document specifies a type of item for which a record of series and expiration dates is created at the warehouse specified in the document, then in the lower table of the document a column is formed in which an icon marks those goods for which series or expiration dates must be specified for the specified warehouse.

* If the icon is highlighted in red, then the serial numbers or expiration dates are not specified for the product (or not all are specified).
* If the icon is highlighted in green, then the information on the series is given in its entirety.

Note. If the storage location is ordered, then information about the series is selected during the actual reception
(release) of goods from the warehouse by the warehouseman: in the documents Receipt order for goods and Outgoing order for goods.

How to determine series or expiration dates in the lower table of the document?

* Specify the Define series command in the menu of the lower table of the document.
* The Fixing product series dialog box will open, in which you need to determine the series and/or expiration dates.
* If a rule with a policy type of Goods batches having identical series numbers (expiration dates, serial numbers and expiration dates) is specified for the item type, then the quantity of the product must be determined in the form for each completed series.
* If a rule with the policy type Instances of goods with unique serial numbers is specified for an item type, then the number of specified series (serial numbers) must correspond to the number of units of the item for which these series are reflected (each unit of goods has its own serial number).

For example, if a document contains ten units of a product, then in the Recording product series form you need to define ten serial numbers.

At the bottom of the Fixing product series form, information is displayed on the number of series that need to be registered and how many series have already been recorded.

What data is recorded on the retail sales report during the closing of a cash register shift?

The retail sales report displays summary information about all products that were processed using cash register receipts during a cash register shift.

The Payment by payment cards panel records information about all payments by payment cards that were made during the cash register shift.

The Auxiliary panel shows the duration of the cash register shift and the status of the cash register shift.

* Closed - the shift is closed, but the receipts are not archived.
* Closed (checks archived) - shift closed, checks archived.

How to print a certificate from a cashier-operator using the KM-6 form?

In the form of the Retail Sales Report document, click on the Print button and select the menu item Help - Cashier Operator Report (KM-6). Check the printable version of the help and click on the Print button.

How is it permissible in a document to obtain data from a data collection terminal?

To load data from the data collection terminal into the lower table Products, you need to use the command of the tabular section All actions/Load products from TSD. If the data collection terminal is connected and its connection details are configured, then the lower table will be filled with data from the terminal. Otherwise, 1c will issue a warning. If you receive a barcode from the terminal that is not registered in the program, then 1c will offer to issue it and compare it with the product available in the program.

How can I enter data into the lower Products table using a scanner?

If the scanner is connected and its connection details are configured, then after reading the barcode in tabular part The product with the required barcode will be added. If a product is already present in the table section, its quantity will be increased. If a readable barcode is not registered in the program, then 1c will offer to issue it and match it with the product available in the program.

In order to search for a product in the tabular section, you need to use the tabular section command All actions/Find products by barcode. Then, in the form that opens, read the barcode of the product. If a product with a read barcode is present in the table section, it will be highlighted (the mouse pointer will be placed on it). If a readable barcode is not registered in the program, then 1c will offer to issue it and match it with the product available in the program.

How to detect a product in the tabular section using a barcode scanner?

How can you fill in the quantities in the bottom table of the document using scales?

Using the command in the lower table of the document Get weight, the Quantity (number of packages) field of the current line of the document will be entered with the weight obtained from the connected electronic scales. Electronic scales must be connected to the computer, and their connection details must also be configured.

Success stories