Retail sales reports manual trading. Postings of retail revenues and preparation of cash documents. Retail sales analysis

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:

This lesson shows how to maintain retail sales for three types of cash register cash registers, cash flow and the formation of sales analytics.

First, let's look at retail sales in the easiest version, using an autonomous cash register.

Autonomous cash register

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

You will need to independently create a document Retail Sales Report and reflect the sales data for the day in it:

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



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


On the second tab we indicate the amount paid by customers using a bank card:


The following tabs contain information about gift certificates and bonus points (we will go into detail in the following lessons):


The following printable forms can be printed from the document:


That's all, sales in the offline checkout have been successfully reflected.

Fiscal registrar

To record sales at the cash register with the Fiscal Registrar type, there is a separate cashier workplace (RMK):




The cashier's workplace looks like this:


Because In our settings, we have enabled accounting of personal sales of sales floor managers; for each sale, not only a cashier, but also a seller must be selected:

After selecting a vendor, the workspace title changes. Now we can select goods for the receipt (using a scanner or manually through the selection form):


In the standard selection form, select the required products and transfer them to the document:


We encountered a problem - the price was not entered:


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


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


In order for it to appear in the RMK settings, let’s add an acquiring terminal:


Now the button has appeared, click 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 received amount of cash:

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


I fill in the goods, click payment by card:


The program asks whether the card payment went through on the terminal itself:


If it passes, then we punch the check:


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



If the client 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 deferred check:


The program immediately shows what pending checks are available:


Now we can accept payment by check:


After the store closes, you need to close the cash register shift (remove the canceled report, Z-report):


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


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


To analyze retail sales, there are the following reports:







Now let’s withdraw funds from the cash register cash register:


Enter the amount:

Now all that remains is to issue a cash receipt order (for posting the DS to the organization’s cash desk):




In the statement of funds we see that the movement of cash flows is reflected correctly:


Now, as an example, let’s reflect the deposit of money into the cash register cash register from the organization’s cash desk. To do this, we will create an expense cash order:



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


KKM offline

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

Let's open an exchange workplace with a cash register:


Let’s create a rule for uploading information about products:


We will only unload into the cash register goods that are in stock at the warehouse and for which the price has been 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:


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


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 of funds at 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.

For an accountant every day

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.

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 “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 with an automated sales accounting system, then you can generate a retail sales report 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 balances according to accounting data. 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 the selling price of the 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 download schedule depends on your store software. 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.

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

"Report on retail sales" can be entered on the basis of the document "Inventory of goods in warehouse", "Reflection of sales simultaneously with the receipt of retail revenue" (warehouse type "Wholesale" or "Retail"), "Reflection of sales based on previously accepted revenue" (warehouse with view "Manual point of sale").

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

  1. Menu: SalesSalesRetail 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 the technical support or the specifics of trading activities make it possible to daily generate a detailed report on goods sold for subsequent entry into an information base, for example, into the 1C: Accounting 8 program. If you select the document transaction type “Manual point of sale”, then the organization’s point of sale is considered manual, since daily registration of goods sold is not maintained there. Information on goods sold at a manual point of sale may be received with some delay based on inventory. In this case, the number of goods sold for each item is determined as the difference between the accounting data from the information base and the data obtained by inventory. In the case of keeping records in sales prices, it is possible to obtain information about goods sold only in total terms, without a detailed breakdown by item.
  3. Fill out the required document tabs that reflect the relevant sales or form of payment. The “Products” tab indicates the goods and services sold to the retail buyer. In this case, the fields “Price”, “Amount”, “% VAT”, “VAT”, “Total” will be filled in automatically based on retail prices and the specified quantity that need to be checked.
  4. In the "Accounting account" field, select account 41.11 "Goods in retail trade (in ATT at sales price)", if goods are accounted for at sales prices and using an automated point of sale. The choice of account depends on the accounting policy settings (Fig. 2).
  5. To call up the printed form "Cashier-operator's certificate-report" using the KM-6 form, you can use the "Cashier-operator's certificate-report (KM-6)" button.