Reports in the configuration "1C: Retail. Gross profit with accounting price 1 with retail income statement

The report is designed to analyze sales and gross profit for goods and services in 1C: Trade Management rev.11, hereinafter 1C: UT 11 based on the documents "Sales of goods and services" and "Return of goods from the buyer" for a certain period. The uniqueness of the report lies in the fact that the calculation of the cost occurs without closing the month. The idea to make such a report came after a client contacted us in the middle of the year with a request to help calculate the cost and profit. Such data in automatic mode in 1C: UT 11 can be viewed only after the regulatory document “Closing the month” has been completed. At the first request of clients, we conducted an audit of the database and revealed that during the entire time of using 1C: Trade Management 11.1 (2 years), the operation to close the month was never performed. Because of this, customers could not calculate the cost. There are several ways to solve this problem, from competently setting up and correcting all the data, to moving to a new database with the transfer of all necessary directories. The company "Petersburg Business Solutions" offered a third option to solve the situation - to write a report " Gross profit enterprises".

The essence of the report is as follows, to fill in the cost in 1C: UT 11, data is taken not from the accumulation register "Cost of goods", as in a standard report (the register is filled after the close of the month), but directly from the documents "Receipt of goods and services". Thus, we bypassed the typical calculation mechanism.

The report implements filters by organization, manager, warehouse, and client.

Detailing to the items of the nomenclature. You can see the calculation of the cost for each item, and for the order as a whole.

Calculation of indicators:

Gross profit = Data taken from the document "Sales of goods and services"

· Cost price= The data is taken from the document "Receipt of goods and services". FIFO method.

· Revenue = This is the difference between gross profit and cost.

· Profit percentage = Revenue divided by gross profit multiplied by 100%.

Implemented the ability to save report options.

Each manager can view the report only for himself, except for a user with full rights - they can view the reports of each manager.

This report also has a second option for generating it in 1C: Trade Management 11. If in the first option, the detailing is initially carried out according to the document “Sales of goods and services” (or according to the Customer’s Order), and then you can expand it to the nomenclature, then here initially the main filter is the nomenclature , and then you can open the movement and see what document it was sold with.

If you have any questions, you can use any means of communication convenient for you.

Petersburg Business Solutions will be glad to see you among its clients!

Print (Ctrl+P)

Information about the cost of goods is stored in the periodic register of information "Nomenclature cost price". The register has 3 dimensions for analytics: stores, nomenclature and characteristics of the nomenclature. With a simplified method of cost accounting, information is recorded in the documents "Receipt of goods" and the cost is equated to the price of the last delivery, and with the method according to a weighted average estimate, information is recorded in the documents "Setting the cost". For more information on cost accounting, see

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. Estimated gross profit

The report displays information about the gross profit received from the sale of goods in the store. The report can be opened via the link Sales - Sales Reports - Gross Profit Estimation.

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

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

The report also displays two indicators for analyzing the efficiency and profitability of sales:

  • Sales performance. Calculated using the formula (Gross Profit / Cost) * 100%.
  • Profitability of sales. Calculated using the formula (Gross profit / Amount of sales) * 100%.

The report can be grouped by organizations, stores, item positions. You can also perform a more detailed analysis of the profitability of sales in terms of product characteristics, as well as drill down the report to the level of a sales document.

For comparative analysis personal selling sellers report can be grouped by product sellers. In addition, to compare sales in different periods, you can group the report by days, weeks, months, quarters, years.

2. Sales evaluation

Purpose of the report: analysis of the effectiveness of promotions aimed at increasing the number of customers, the average purchase amount, repeated visits to the store (reward sheets, discounts on a discount card, birthday discount, etc.). The report can be opened by following the link Marketing - Marketing Reports - Marketing Promotions - Sales Estimate.

The report indicators are displayed in the context of the store, warehouse (department), KKM Cashier.

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

  • Number of checks – the number of sale checks 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 receipt income, rub.: Income for the sub-period / Number of customers for the sub-period.
  • Average discount, %: Discount amount / (Sales amount + Discount amount).

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

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

Analytical indicator:

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

3. Product promotion evaluation

The purpose of the report is to analyze the effectiveness of a promotion aimed at increasing product sales, commodity group, brands and more. It should be taken into account that if the product promotion action is carried out, all other things being equal, then the report will really show the effectiveness of this action. Otherwise, other influencing factors will not be taken into account. 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 along 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 is opened by clicking the link Marketing - Marketing Reports - Marketing promotions - Evaluation of product promotion.

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

Absolute indicators:

  • Retail price, rub. is the average for the sub-period.
  • Quantity - the average for the sub-period sale of goods for an interval of in kind.
  • Amount of s / s, rub. - the average cost of selling goods for the period for the interval in rubles.
  • Actual amount, 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 action”:

  • Retail price, % – relative price change, discount percentage.
  • Quantity, %.
  • Amount of s / s,%.
  • Actual amount, %.

Final analytical indicators:

  • Additional income during the promotion, rub. = Earnings after stock – Earnings before stock.
  • Additional income after the action, rub. = Earnings after stock – Earnings before stock.
  • Price elasticity = Percentage of sales increase in physical terms / Percentage of price drop.

4. Evaluation of the sale

The main purpose of seasonal sales is to reduce the inventory balance. The report allows you to compare 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 the outgoing at the end of the sale. If the report period ends before the end of the promotion, you can get intermediate results of the sale. The report is opened by clicking the link Marketing - Marketing Reports - Marketing Promotions - Sales Estimation.

The indicators 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 - incoming balance of goods in physical terms.
  • UI is the basic unit of measure for the item.
  • Amount of s / s, rub. - the cost of the incoming balance of goods in rubles.
  • Retail amount, rub. - the amount of the balance of the incoming goods in the retail prices of the store.

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

  • Retail price, % – relative price change (% of final discount).
  • Quantity, %.
  • Amount of s / s,%.
  • Actual amount, %.

Sales before and during the promotion:

  • Actual price, rub. - average for the period the actual sale price of the goods
  • Quantity - the average sale of goods for the period for the interval in physical terms.
  • UI is the base unit of measurement.
  • Amount of s / s, rub. - the average cost of selling goods for the period for the interval in rubles.
  • Actual amount, 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 of the discount for the period for the goods for the interval in rubles.

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

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

5. Evaluation of the effectiveness of marketing activities

A report showing changes in key sales figures for the selected stock. The report is generated in the context of participating stores. The report is opened by clicking the link Marketing - Marketing reports - Marketing promotions - Evaluation of the effectiveness of marketing activities.

The following indicators are displayed in the report:

  • Sales Amount for promotional goods;
  • Cost of sales for promotional goods;
  • Profit, received during the sale of promotional goods;
  • Discount amount, provided when selling goods for a promotion;
  • Remains– assessment of the cost of promotional goods at cost;
  • Number of checks containing promotional goods;
  • Average amount of checks containing a promotional item.

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

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

  • Report Product promotion evaluation opens when you click on the field “Sales amount”, “Cost of sales”, “Profit”
  • Report Evaluation of the application of discounts– for the field “Discount amount”
  • Report Sale score– for the field “Remainders”
  • Report Sales estimate– for the fields “Number of checks” and “Average amount of checks”.

6. Reasons for returns from the buyer

Report Reasons for returns from the buyer provides information on the quantity and cost of goods returned by customers in the context of the reasons for returns (business transaction analyst Return from buyer). The report can be generated in various versions, oriented to different users. In those report options where information on returns is grouped, the share of returned goods in sales is calculated, which allows drawing conclusions about the quality of the products sold. The report can be opened from the link Sales - Sales reports - Reasons for returns from a customer.

Shopping– version of the report focused on directors retail chains. It is formed by those stores in which for reporting period There were returns from buyers.
Report indicators:

  • Number of returns- the number of items returned by the buyer;
  • Amount of refunds, rub.– at the prices indicated in the return documents from the buyer;
  • Number of sales- the number of units of the nomenclature sold during the reporting period;
  • Amount of sales, rub.- the actual amount of sales for the reporting period;
  • Share of return from sales, %- the ratio of the amount of returns to the amount of sales.

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

Detail– version of the report aimed at section heads trading floor. The report generates a list of goods returned by customers for the selected store and item group.

Report indicators:

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

7. Write-off reasons

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

Report Write-off reasons can be formed in three sections:
Shopping– an analytical section focused on network directors.
The report is generated for stores that had product write-offs during the reporting period.
Indicators:

By nomenclature groups

Indicators:

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

8. Warehouse valuation (Warehouse valuation)

The report allows you to get a valuation of goods in warehouses in quantitative terms, in prime cost prices, in retail prices. The report opens with a link. Warehouse - Warehouse Reports - Warehouse Valuation

Indicators:

  • Remaining stock.
  • Cost, rub.;
  • Cost (in retail prices)
literally stuffed with different goodies for data analytics. We will talk about one of these goodies in this publication - the gross profit report. The report is unique in its essence, because it provides information about the results of the trading company at the click of a mouse button. And this is not an exaggeration.

WHAT THE REPORT IS BASED ON

1. Lots of goods are your receipts of goods and services. Everyone knows that before you can sell something, you need to buy something. Accordingly, in each delivery note conducted in 1C, consignments of goods receipt are necessarily written off. In general, write-offs occur according to the FIFO method. We recommend checking the company's accounting policy settings.
2. Sales document- documents with which you make out the sale. Accordingly, your margin on goods will give the difference between the prices at which you bought the goods and at which you sold them. Simply put, income. The ongoing sale document in 1C just generates your income, and the gross profit report only displays the result. So we come to the last final indicator of the report - profitability.
3. Profitability- the main thing that the report shows. Profitability is formed according to the standard profitability formula:

Profitability = (Revenue - Cost) * 100 / Revenue

The report also shows gross profit . Gross profit is the difference between revenue and cost of transactions.
The beauty of the report is that, like in all reports, various groupings, selections, sorting, etc. are available in it. For example, if you are interested in the profitability of sales by product groups or by points of sale, by customers - everything can be configured. This, of course, requires the skills of working with reports, but believe me, once you have learned how to use sales analytics tools in 1C, you will no longer be able to refuse them. To deepen the topic of reports, we recommend a series of our articles on mastering the basics of generating reports in 1C.

ATTENTION! The report may show wrong 100% profitability for transactions, if: 1) in the settings of the accounting policy for writing off goods, the checkbox "Write off batches when posting documents" is not set; without a party. In this case, it is necessary to correct errors in posting goods in the negative and retransmit the accounting period by batch.

HOW TO GET THE RIGHT DATA

Highly important detail- setting up the program. Depending on whether or not VAT is included in the cost of lots, the return on sales will be considered differently. For example, if the flag "Do not include VAT in the cost of batches" is cleared, then you increase the profitability of sales by a percentage of the VAT rate.

And the second moment. Profitability of sales can be calculated by cost, or by revenue. Those. gross profit can be correlated to two values. For example:

Revenue Without VAT 128,434.81 Cost price 95,625.57 Gross profit 32,809.24 Profitability - 32,809.24 * 100 / 128,434.81 = 25.55%

Revenue Without VAT 128,434.81 Cost price 95,625.57 Gross profit 32,809.24 Profitability - 32,809.24 * 100 / 95,625.57 = 34.31%

As you can see, with the same revenue, different profitability is obtained. It's not a mistake. How to calculate profitability is a purely individual matter for each company, but the standard 1C report considers profitability according to the first option.
It happens that the report may contain indicators negative profitability. In this case, you need to individually check the assortment of goods sold at a loss. AT trading companies often with negative profitability, sale or promotional positions are revealed. For example, a sale of stale goods below cost can be arranged. In this case, a negative result is a normal result.
The report can change revenue and profitability indicators when documents are entered in the reporting period retroactively. For example, if a document with higher prices was retroactively included in the receipt of goods and services, then the profitability of sales should also decrease. But the trick is that 1C is designed in such a way that until you re-execute the implementation after the receipt, nothing will change in the report. Those. it is necessary, as it were, to rewrite commodity movements (update). It is clear that transferring a lot of implementation documents is a laborious task, so 1C has a standard tool called "Reposting by batches", which automatically updates the movement of batches for a period. To repost documents and restore sequences, you can also use the processing"Reposting Documents", which is located in the Operations menu. It is believed that the gross profit statement data will be more accurate after the batch reposting procedure.

Earlier, we talked about the design of retail sales in the 1C: Trade Management 8 program (rev. 11.3) - including software, and. Is it possible to know the gross profit from these sales? Let's consider this question.

Movements of the document "Report on retail sales"

To calculate profit, the cost of goods sold must be known.

The document that directly registers the sale (shipment) of goods in all cases of retail sales is the “Report on retail sales". Let's see if he calculates the cost price. Let's go to the journal:

Sales / Retail Sales / Retail Sales Reports

Let's open the conducted "Report on retail sales" and in it we will generate a report on the movements of this document (by clicking the "Reports - Document Movements" button).

In the form that appears, open the subgroup “Register of accumulation “Cost of goods”. We will see that there is no data on the cost of goods sold, only their quantity is displayed.

The illustration shows the movement of the document in this register during the retail sale of the product "Gyroscooter 1" (quantity - 2, the cell below is for the cost, but not filled):

That is, the document did not calculate the cost.

This is due to the fact that in the 1C: Trade Management program, the calculation of the cost of shipped goods is carried out deferred: not when posting a shipment document (both retail and wholesale), but at the scheduled closing of the month.

Until the cost price is calculated, it is impossible to know the profit. Therefore, to calculate the gross profit, you need to close the month.

Month-end cost calculation

Let's close the current month for our organization. Let's open the corresponding form.

Financial result and controlling / Month-end closing / Month-end closing

Specify the month, organization and click "Perform operations". The program will automatically perform the necessary routine operations to close the month. After that, marks will appear in the form about successful implementation operations, including costing.

Gross profit and retail profitability in the report

Sales / Sales Reports / Retail Sales / Retail Gross Profit by Division

We will generate a report on our organization for the required period. For each product and division, revenue, cost (including purchase cost and additional costs) are displayed, gross profit and profitability are calculated.

In our example, there were sales of goods of the same type - “Gyroscooter 1”, add. there were no expenses, the report was generated in the currency management accounting(US dollars).

The report allows you to analyze the following information on actually sold goods:
1. Cost of goods sold without built-in retail cost calculation.
(i.e. the report multiplies the last purchase price by the quantity actually sold)

2. The amount of goods actually sold in retail prices (Revenue)
(From the Retail Sales Reports, more specifically from the sales accumulation register)

3. Mark-up by amount and percentage

The report generates for the selected period data on the item in the hierarchy, selection by Stores and Item is implemented.

To connect a report:

1. Go to menu Administration - Printing forms, reports and processing - Additional reports and processing.

2. Click Create - Continue and select the downloaded file.

3. Specify in the Placement field the section in which you want it to be displayed, for example, Sales.

4. There must be at least one user in the database, in the quick access field you need to select users for which you want the report to be displayed.

5. Burn and close

The report will be in the menu of the selected section at step 3. by clicking the Additional reports button.


6. And if everything worked out and you liked it, put a star on this publication

The report has been tested on the configuration:

Retail, edition 2.2 (2.2.5.22) and Platform 1C: Enterprise 8.3 (8.3.9.2170).

Retail, edition 2.2 (2.2.6.28) and Platform 1C: Enterprise 8.3 (8.3.10.2466).

Retail, edition 2.2 (2.2.6.33) and Platform 1C: Enterprise 8.3 (8.3.10.2466).

The code is open.

Changes in version 0.2:

1. The choice of the period is implemented through standard periods

2. Ability to select the type of purchase price

3. Output of nomenclature with characteristics

4. Output of the item and highlighting, for which the purchase price is not assigned (tick: Do not display without the purchase price)

Changes in version 0.3:

1. Numerical indicators are given to two decimal places

2. Renamed fields in the report for more conceptual and minor cosmetic improvements

Changes in version 0.4:

1. Added standard buttons (find, collapse/expand groups, autosum, print, save, send by mail (mailing settings))

2. You can select by specific nomenclature and by group.

Changes in version 0.5:

1. The purchase price is displayed taking into account packages (For example, if a purchase price (100 rubles) is assigned to a package (10 pieces), and the sale is in pieces, then the price will be recalculated in pieces (10 rubles)).

2. The Purchase price parameter is mandatory.

3. Purchase price and Retail price in groupings are displayed as an average value.

4. Brought the unit of measurement and selection by characteristics

5. Cosmetic improvements

Changes in version 0.6:

Fixed percentage markup calculation

Before (Retail - Purchasing)/Retail *100

New (Retail - Purchasing)/Purchasing*100

To share with friends:
Similar posts