1c retail 2.2 report on retail sales. Description of work with the document "retail sales report". Estimating gross profit

Print (Ctrl + P)

Information about the cost of goods is stored in the "Item cost" periodic information register. The register has 3 dimensions for analytics: stores, item, and item characteristic. With the simplified cost accounting method, the information is registered with the "Goods receipt" documents and the cost price is equated to the price of the last delivery, and with the weighted average valuation method, the information is registered with the "Cost price setting" documents. More information about cost accounting can be found

In this article, I describe typical configuration reports that use item cost. All these reports are located in the subsystem "Sales reports", "Marketing reports" and "Warehouse reports".

1. Estimation of gross profit

The report displays information about the gross profit received from the sale of goods in the store. The report can be opened by clicking the link Sales - Sales reports - Estimated gross profit.

The report displays the number of products sold, the amount of sales, the cost of sales and the amount of gross profit received from the sale of products. The sales amount is always displayed including VAT. The cost of goods can be displayed both with and without VAT. It depends on the selected checkbox in the accounting settings.

Gross profit is calculated as the difference between the amount sold and the cost price.

The report also displays two metrics for analyzing the effectiveness and profitability of sales:

• Sales efficiency... Calculated using the formula (Gross Profit / Cost) * 100%.
• Return on sales... Calculated using the formula (Gross Profit / Total Sales) * 100%.

The report can be grouped by organizations, stores, stock items. You can make a more detailed analysis of the profitability of sales in the context of product characteristics, as well as drill down to the level of the sales document.

For comparative analysis Personal sales of sellers report can be grouped by sellers of goods. In addition, to compare sales in different periods, you can group the report by day, week, month, quarter, year.

2. Assessment of sales

Purpose of the report: analysis of the performance of promotions aimed at increasing the number of buyers, the average purchase amount, repeat visits to the store (bonus sheets, discounts on a discount card, birthday discounts, etc.). The report can be opened by following the link Marketing - Marketing reports - Marketing promotions - Sales estimation.

Report indicators are displayed in the context of a store, warehouse (department), cash register cash register.

Absolute sales figures for the periods preceding the promotion and during the promotion:

• Number of receipts - the number of sales receipts for the interval, averaged over the period.
• Average check amount, RUB - the amount of the check, taking into account the discount, averaged over the period.
• Average income per check, rubles: Income per period / Number of buyers per period.
• Average discount,%: Discount amount / (Sales amount + Discount amount).

Changes in indicators are calculated relative to the corresponding indicator of the "Before the promotion" period.

• Amount fact.,%.
• Income,%.
• Number of checks,%.
• Average check amount,%.
• Average income per check,%.

Analytical indicator:

· Additional income, rub. - the difference in average income for the interval before and after the start of the promotion.

3. Evaluation of product promotion

The purpose of the report is to analyze the effectiveness of a promotion aimed at increasing product sales, commodity group, brands and so on. It should be taken into account that if the promotion of a product is carried out, all other things being equal, the report will really show the effectiveness of this promotion. Otherwise, other influencing factors will not be considered. That is, if an action is planned to temporarily reduce the price of a new product that has just appeared on the market, then this action should not be carried out together with a mass sale of other goods. In this case, the effect of the promotion action will be blurred, and the report will show distorted data. The report opens by clicking the link Marketing - Marketing reports - Marketing promotions - Product promotion evaluation.

The indicators are displayed for the stock item taking into account the characteristics in the context of stores and warehouses (store departments). The absolute indicators of the report are displayed in three groups: "Before the action", "During the action" and "After the action". Relative - respectively in two groups, located after the groups absolute indicators “During the promotion” and “After the promotion” and are calculated relative to the level “Before the promotion”. The last columns display analytical indicators for the whole stock.

Absolute indicators:

• Retail price, rub. - average for the period.
• Quantity - the average for a sub-period sale of goods for an interval in physical terms.
• Amount s / s, rub. - the average cost of sales of goods for the period in rubles.
• Amount fact., Rub. - the average for the period the actual amount of the sale of goods for the interval in rubles (including discounts)
• Income, rub. - the difference between the previous two indicators.

The increase in indicators is calculated relative to the level "Before the stock":

• Retail price,% - relative price change, discount percentage.
• Amount,%.
• Amount s / s,%.
• Amount fact.,%.

Final analytical indicators:

• Additional income during the promotion, rub. \u003d Earnings after stock - Earnings before stock.
• Additional income after the action, rub. \u003d Earnings after stock - Earnings before stock.
• Price elasticity \u003d Percentage of sales growth in physical terms / Percentage of price drop.

4. Evaluation of the sale

The main purpose of the seasonal sales is to reduce the inventory. The report allows you to compare the sales figures before the promotion and during the promotion, as well as the indicators of the incoming inventory at the time of the start of the sale and outgoing at the time of completion. If the reporting period ends before the end of the promotion, you can get interim results of the sale. The report can be opened by clicking the link Marketing - Marketing reports - Marketing promotions - Estimation of sales.

The key figures are displayed for the stock item taking into account the characteristics in the context of stores and warehouses (store departments).

Incoming and outgoing balances of the promotion period:

• Retail price, rub. - retail price in the store at the beginning of the promotion.
• Quantity - the incoming balance of goods in kind.
• UU is the basic unit of measure for an item.
• Amount s / s, rub. - the cost of the incoming balance of goods in rubles.
• Retail amount, rub. - the sum of the remainder of the incoming goods in the retail prices of the store.

Change in stock balances. The indicators are calculated in relation to the corresponding indicator of the opening balance:

• Retail price,% - relative price change (% of the final discount).
• Amount,%.
• Amount s / s,%.
• Amount fact.,%.

Sales before and during the promotion:

• Price fact., Rub. - average for the period the actual selling price of the goods
• Quantity - the average sales of goods for the period in physical terms.
• UU is the basic unit of measurement.
• Amount s / s, rub. - the average cost of sales of goods for the period in rubles.
• Amount fact., Rub. - the average for the period the actual amount of the sale of goods for the interval in rubles (including discounts)
• Income, rub. - the difference between the previous two indicators.
• Discount, rub. - the average amount for the period of the discount provided for the goods for the interval in rubles.

Changes in sales figures relative to the corresponding indicator Before the promotion:

• Sale price,% - relative price change (% discount).
• Amount,%.
• Price elasticity: Percentage of sales growth in physical terms / Percentage of price drop.
• Amount s / s,%.
• Amount fact.,%.

5. Evaluation of the effectiveness of marketing activities

A report showing changes in key sales indicators for a selected promotion. The report is formed in the context of the stores participating in the promotion. The report opens by clicking the link Marketing - Marketing reports - Marketing campaigns - Evaluation of the effectiveness of marketing activities.

The following indicators are displayed in the report:

• Sales amount on promotional goods;
• Cost of saleson promotional goods;
• Profitreceived when selling a promotional product;
• Discount amount, provided when selling goods for a promotion;
• Leftovers - evaluation of the cost of promotional goods at cost;
• Number of checkscontaining promotional goods;
• Average amount of checkscontaining promotional goods.

The indicators are calculated only for the goods indicated in the discount segments for this promotion, or for all goods, if there is no explicit indication, and are displayed in three columns: before the promotion, for the period of the promotion (in the second column) and the change in the indicator during the promotion relative to the initial level as a percentage.

The report allows you to make decryptions of indicators, formed taking into account the selection and for the same periods as the general report displayed on the screen:

• Report Product promotion evaluationopens by clicking on the field "Sales amount", "Cost of sales", "Profit"
• Report Assessment of discounts application- for the field "Discount Amount"
• Report Sale estimate- for the field "Remains"
• Report Sales evaluation - for the fields “Number of checks” and “Average amount of checks”.

6. Reasons for Buyer Returns

Report Reasons for Buyer Returnsprovides information on the quantity and value of goods returned by customers in the context of the reasons for the returns (business transaction analyst Return from buyer). The report can be generated in different versions, targeting different users. In those versions of the report, where information on returns is grouped, the share of returned goods in sales is calculated, which makes it possible to draw conclusions about the quality of the products sold. The report can be opened by the link Sales - Sales reports - Reasons for customer returns.

Shopping - a version of the report aimed at directors retail chains... Formed by those stores in which for reporting period were refunds from buyers.
Report indicators:

• Number of returns - the number of items returned by the customer;
• Refunds, RUB - at the prices indicated in the return documents from the buyer;
• Number of sales - the number of items sold during the reporting period;
• Sales amount, rub.- the actual amount of sales for the reporting period;
• Share of return on sales,% - the ratio of the amount of refunds to the amount of sales.

By item groups and By product categories - report options targeted at category managers. The report is generated by item groups or product categories in which there were returns from customers. The metrics are similar to the store report option.

In detail - version of the report aimed at section heads trading floor... The report generates a list of the goods returned by customers for the selected store and product group.

Report indicators:

• - the average cost is calculated depending on the cost accounting settings;
• Average selling price - the average actual selling price for the period, taking into account the discount;
• amount - the number of items of the item returned by the buyer;
• Amount - the amount of the returned goods at the prices indicated in the return documents from the buyer.

7. Reasons for writing off

Report Reasons for writing off used as an analytical tool for the process of writing off goods from the warehouse. For a summarized and detailed assessment of write-offs in the context of stores and nomenclature, and the reasons for write-offs specified by the user in the Business Analytics directory
The report form can be called by following the link Warehouse - Warehouse reports - Warehouse operations - Reasons for writing off.

Report Reasons for writing offcan be formed in three sections:
Shopping - an analytical view focused on network directors.
The report is generated for the stores in which the goods were written off for the reporting period.
Indicators:

By item groups

Indicators:

• Write-off quantity
• The cost of writing off, rub.
• Number of sales
• Sales amount
• Gross profit, RUB
• Share of write-offs from sales,%
• Share of profit write-off,%
• Write-off quantity - the number of units of the decommissioned nomenclature;
• Write-off cost, rub. - unit cost of the written-off item;
• Write-off amount in retail prices, rub. - the amount of the write-off at the retail prices established at the time of the write-off;
• Number of sales, the number of units of the sold item;
• Sales amount - the amount of the item sold at the actual selling price
• Gross profit, rub. - the difference between the amount of sales and the estimated cost of sales;
• Share of sales write-off,% - the ratio of the write-off amount in retail prices to the amount of sales in percent;
• Profit write-off share,% - the ratio of the write-off cost to the gross profit as a percentage;
• By item groups - an analytical view focused on the category manager and store director.
  The report is generated by item groups in which there were write-offs of goods for the reporting period.
  Indicators:
• In detail - an analytical section focused on the heads of sections.
  The report is generated only for written-off items.
  Indicators:
• Write-off quantity - the number of units of the decommissioned nomenclature;
• The cost of writing off, rub. - unit cost of the written off item;
• Write-off amount in retail prices, rub. - the amount of the write-off at the retail prices established at the time of the write-off;
• Number of sales, the number of units of the sold item;
• Sales amount - the amount of the item sold at the actual selling price
• Gross profit, RUB - the difference between the amount of sales and the estimated cost of sales;
• Share of write-offs from sales,% - the ratio of the write-off amount in retail prices to the amount of sales in percent;
• Share of profit write-off,% - the ratio of the cost of write-off to gross profit as a percentage.
• Average unit cost, rub. - the average cost of the item for the reporting period;
• Average retail price, rub. - average retail price of the item for the reporting period;
• Write-off quantity, - the number of units of the decommissioned nomenclature;
• Write-off cost, rubles - estimate of the cost of the written off item;
• Amount in retail prices, rub. - the amount of the item write-off at the retail price.
• Warehouse valuation (Warehouse valuation)

8. Warehouse valuation (Warehouse valuation)

The report allows you to get the cost estimate of goods in warehouses in quantitative terms, in prime cost prices, in retail prices. The report is opened by the link Warehouse - Warehouse reports - Warehouse valuation

Indicators:

• Remaining stock.
• Cost price, rubles;
• Cost (retail prices)

Sales ® Retail Sales Report

The document is used to generate retail sales. It is permissible to fill in the document based on the document
Inventory of goods in the warehouse.

Formation of the sale at the same time with the receipt of retail proceeds (warehouses with the "Wholesale" or "Retail" type)
Formation of sales before received proceeds (warehouses with the "NTT" view)

Versions for print
Input based

When filling out the document at the top, it is imperative to determine the following parameters:

* Storage location is a point of sale where retail sales are formed.
* Price type - the price of the product at which the sale is created. It is set from several prices allowed for the item. The price type is entered automatically by the price type 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 article is an item of money movement, which will display the receipt of retail proceeds to the organization's cash desk.

Formation of sale at the same time with the receipt of retail proceeds

To form retail sales with wholesale warehouse or from a warehouse with the "Retail" type, you need to specify the POS printer operation. After selecting an operation, you need to fill in the bookmarks:

* Agency services

* Payment cards and bank loans

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

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

(principal) ".

The Payment cards and bank loans panel displays the purchaser's payments made by a payment card or with bank loans.

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

Formation of a sale based on previously accepted revenue

To generate retail sales from a warehouse with the "NTT" type, you must specify the NTT operation. After selecting an operation, you need to fill in the bookmarks:

* Agency services

The Goods panel displays goods and services sold to a retail consumer. The panel is entered based on the results of the inventory at the outlet 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 - entered automatically when specifying an item on the basis of the Item Accounting Account register.

* Subconto - the contents of the nomenclature group of the specified product or service are inserted.

* Income Account and Expense Account - set whether this sales line is related to activities with a special taxation procedure. It is inadmissible to define for income and expenses of accounts related to different types activities.

The Agency services panel reflects the services in the implementation of which our organization acts as an agent.

* Counterparty - a 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 have the form "With the principal
(principal) ".

* Settlement account - the account of settlements with the principal under the agency agreement is selected, which will reflect the principal's revenue from the sold agency services.

Versions for print

A print form has been implemented for the Retail Sales Report document:

* KM-6 (Help-report of the cashier-operator)

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 accrual

A point of sale is considered automated if it is possible to generate a daily detailed report on goods sold at retail in the context of their name, quantity and sale price.

• If the implementation is carried out through notautomated point of sale (NTT), then when creating the document "Retail Sales Report"the type of operation is selected NTT.Information about the sale of goods is not entered into the database, but information about the remains of the goods as a result of inventory using the document "" is indicated.

In this case, in 1C 8.2 (8.3) for the posting of proceeds to the cashier, the document "" is used, on the basis of which the posting on Dt 50 "Cashier" is formed.

A point of sale is considered non-automated if retail trade is carried out without daily registration of the name, quantity of goods sold.

In our example, an automated point of sale (ATT) is used to carry out retail sales.

STEP-BY-STEP INSTRUCTION

Create a document via the menu: Sales - Retail Sales Report - button "Add" - type of operation KKM.

Fill in the header of the document (Fig. 379):

• In line From- the date of registration of the retail sale;
• In line Cash account- score accounting, on which, as a result of the document, the funds from the sale will be capitalized;
• In line Warehousethe warehouse or storage location from which the goods are shipped is indicated. Warehouse type should be Retailotherwise the document will not be posted;
• In line DDS articleif necessary, you need to indicate the article of the movement money;

Checking the parameters for entering amounts in the tabular section (Fig. 378):

• Because if the sale is retail, then the price type must be retail. In our example, choose Retail (TKD).

Filling in the bookmark Products(Fig. 379):

• Enter the nomenclature - products(as a rule, the choice is made from the group Products) using the button "Selection"... In the opened form Selection of items in the documentselect the required item. Check the boxes at the bottom of the form Request Quantityand The price, then the name of the goods, quantity and price will be immediately added to the tabular section;
• Check the quantity, set price, amount,% VAT and VAT amount. In our example % VATindicated as Without VAT,since the organization uses the simplified tax system;
• In the graph Accounting account you need to check the account. In our example, it is retail, so there should be account 41.02 “Goods in retail (at purchase price) ";
• In the graph Income accountaccount 90.01 is indicated. 1 "Revenue from activities with the main tax system";
• In the graph Subconto - type of goods (activity) from the directory Nomenclature groups;
• In the graph VAT account - account 90.03 "Value added tax";
• In the graph Expense account the account 90.02.1 "Cost of sales for activities with the main taxation system" is indicated.

As a result of document 1C 8.2, postings were made to write off the cost of goods accounted for in retail at the purchase price. And also formed transactions to reflect the proceeds received during retail sales at the cash desk of the organization.