Gross profit report 1 s retail. Gross margin with accounting price

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. In the Placement field, specify 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

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 the button "Reports - Document Movements").

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 on the successful completion of operations, including the calculation of the cost price, will appear in the form.

Gross profit and retail profitability in the report

Sales / Sales Reports / Retail Sales / Gross profit retail 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 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 it is possible to view only after the regulatory document “Closing of the month” has been carried out. 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, competent settings and correcting all data, before moving to a new database with the transfer of all necessary directories. The company "Petersburg Business Solutions" offered a third option for solving the situation - to write a report "Gross profit of the enterprise."

The essence of the report is as follows, to fill in the cost in 1C: UT 11, the 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!

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 your settings. accounting policy companies.
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

A very important detail is the program setting. 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 point. 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. In trading companies, sale or promotional positions often come to light with negative profitability. 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 entering documents into reporting period backdating. For example, if a document with more than high prices, which means that the profitability of sales should 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.

and how the customer wanted to see this report. I decided to write a post on this topic and submit a report.

So I'll write what this report displays:

Cost price for 1 unit with VAT = (Amount of Goods + Additional Costs) / Quantity.

In the standard report, the cost price is calculated without VAT.

Gross profit for 1 unit = Cost of sales (including VAT) - Cost per 1 unit. VAT included.

Accounting price - as close as possible to the purchase price from the document "Receipt of goods and services".

Accounting price= (VAT/Cost without VAT+1)*Cost without VAT.

I applied this method because. there is no purchase price in the Sales Cost register, and he considered it superfluous to drag it from another register.

Other indicators:

The percentage of markup, aka efficiency and margin (profitability), left unchanged,
but since the calculation of the Cost and Gross Profit has changed, these indicators will also have a different percentage.

Sales performance= ("Gross profit" / "Cost") * 100%.

Profitability of sales= ("Gross profit" / "Cost of sales (including VAT)")*100%.

NOTE TO THE REPORT!

At what price do we do "Goods posting"?
If posting is done at the sales price, then the cost price will not be displayed, because. will be equal to the cost.

We do “receipt of goods” at the purchase price!

The report programmatically contains the accounting policy parameter Do not include VAT in the cost of consignments = False.

The report was made for Trade Administration 10.3, the figure shows a test on a demo base.