Help on Tele2, tariffs, questions

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 skills in 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 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 entering documents into reporting period backdating. 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.

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.

With this article, we complete the cycle of publications devoted to working with management reports in the 1C: Enterprise Accounting 8 edition 3.0 program, and consider the key forms that summarize information about the company's activities. It will be about the analysis of revenue and profitability of goods, as well as the income and expenses of the organization - key indicators for the business owner.

An informative report that reflects the revenue and profitability of goods in the context of the nomenclature is called "Gross Profit". Its greatness lies in the fact that you can see the profitability of sales for each stock item for the selected period. The report data is generated on the basis of primary sales documents (without VAT).

Set (or check) the settings:

"Administration" - "Accounting parameters" - "Setting up the chart of accounts" - "Inventory accounting" - "Inventory accounting is carried out by warehouses by quantity and amount".

Now let's move on to the report: section "For Manager" - "Sales" - "Gross Profit".

Important: the report is not generated for works, services, products. analyzes only the cost of goods sold.

As you can see in the figure, in the “Cost” column for services and products, empty values ​​remain, that is, the profitability indicator is formed incorrectly. this report is not intended for costing in such cases.

We form the report "Gross profit" for the period by sold goods and analyze sales. Information is reflected correctly if accounting is kept according to all the rules.

At the same time, one more important nuance should be taken into account: if the checkbox “Allow inventory write-off in the absence of balances according to accounting data” is checked in the “Administration” - “Document posting” accounting settings, the program will not be able to determine the profitability for positions for which such a write-off was made.

If a company applies different pricing policy, the report can be generated in the context of buyers.

An example of the analysis of product sales by customers.

And at the end of the cycle, let's consider another report - "Income and expenses" ("To the head" - "General indicators" - "Income and expenses").

This report actually reflects the direction of business movement and helps to quickly take management decisions. The report is universal for any type of business.

As in previous reports, each column of the chart and figures can be decrypted to primary documents with a double click of the mouse. The report is simple and easy to understand even by unprepared 1C users.

Dear colleagues! We hope that working with an additional set of analysis tools from the Executive Monitor will open up new reserves for you in your business. This will certainly happen. you look at the activities of the company from a different position, and this position is strategic.

In this article, we will consider new opportunity UT release 11.1.4 (and older versions) – preliminary assessment of the profitability of sales.

This report is very useful as it gives us information about:

• Marginal profit and profitability of the sale
• Sales markup ratio
• Least/Most Profitable Items on Sale
• How the manager's sales profitability will change for the current month, taking into account the current sale.

Applicability

The article was written for the editors of UT 11.1 . If you use this edition, great - read the article and implement the considered functionality.

If you work with older versions of UT 11, then this functionality is relevant. The most notable difference between UT 11.3/11.4 and version 11.1 is the Taxi interface. Therefore, in order to master the material of the article, reproduce the presented example on your base UT 11. Thus, you will consolidate the material with practice :)

Implementation of a report for analysis and preliminary assessment of sales profitability

The report is called only from document forms:

• Commercial offer to the client.
• Customer order.
• Realization of goods and services.
• Request for return of goods from a customer

Those. when conducting, for example, the document “Sales of goods and services”, we can immediately see the profitability of this sale by going to the item “Sales profitability assessment” of the navigation panel of the document form.

The necessary settings for calculating the preliminary profitability are set on the "Administration" - "CRM and sales" tab.

The program can use one of two ways to evaluate the profitability of sales:

1. Determined by the estimated cost. In this option, the cost is determined by the results of the calculations of the document "Calculation of the cost of goods".

   Profitability of sale = Selling price - Cost price

2. It is determined by the normative type of price. When using this method, the cost is determined by the specified price type (for example, by the “Purchase” price type).

   Those. when selling a product, its profitability is calculated as:

For example, let's set the first option "Determined by the estimated cost" in the program settings.

• Table at a price of 1,000 rubles.
• Wardrobe at a price of 4,000 rubles.

Click on the image to enlarge.

Let's perform the "Closing of the month" processing.

In total, the cost of the table is 1000 rubles, and the cabinet - 4000 rubles.

• Table at a price of 5,000 rubles.
• Wardrobe at a price of 10,000 rubles.

Click on the image to enlarge.

Since we specified the option “Determined by the estimated cost” in the program settings, we need to process the “Closing of the month” so that the program generates the necessary movements in revenue and cost of sales.

Now let's go to the item of the navigation panel "Evaluation of the profitability of the sale" of the form of our document "Sales of goods and services". A profitability assessment report will open in front of us.

Click on the image to enlarge.

So we have two tables.
The first table shows us information about revenue, cost and profit from sales of goods (not only those indicated in this document) as a whole for a particular manager, which is indicated in the document on the "Additional" tab.

The report columns show the following information:
• According to the document - all indicators are calculated according to the tabular section "Goods" of the document.
• For a month excluding sales - the indicators are calculated by the document manager on an accrual basis from the beginning of the month (sales from the beginning of the month). The current document is ignored.
• For the month, including the sale - the indicators are calculated by the document manager on an accrual basis from the beginning of the month, taking into account the current document.
• Change, % – the difference between the columns “During the month including the sale” and “During the month excluding the sale” is calculated to assess the impact of the current sale on the results of the manager for the month.

As you can see, the column "For the month excluding sales" is not filled in, since this is our first sale of these goods in this month.

The second table of the report shows us information about the result of the sale in the context of each item of this document "Sales of goods and services".

Now let's move on to the settings of this report - the "Quick Settings" button.

In the "Regulatory profitability" field, we can indicate the required profitability (in percentage terms) that we expect to receive from the sale of goods.

In this case, the report will indicate problem areas in color.

For example, let's specify a value of 70%. Let's create a report.

Click on the image to enlarge.

We will see red numbers in the report. Because the overall profitability is 66.67% (less than our required 70%). The program indicates the table in green, since its profitability suits us. As for the cabinet, its profitability, as well as the overall sales of the document manager, is also less than 70%.

If you check the "Sales by orders without realizations" checkbox in the report settings, then in the first table of the report in the columns "Per month excluding sales" and "Per month including sales" the program will also take into account Customer Orders, on the basis of which there is no posted document " Realization of goods and services”.

Those. we will be able to see the expected profit that we will receive if, based on our Orders, we carry out Realizations in the database.

All in all, a very interesting setup. For example, now our document is posted with the price type " Retail price” and we received a marginal profit of 10,000 rubles.

Let's indicate in the quick settings of the report to specify a different type of price (for example, "Wholesale price"). We will report the marginal profit that we could have received if we had made a sale at the specified price type (“Wholesale Price”).

Click on the image to enlarge.

Additionally, we can specify the sorting of the report and select the fields to display or not display in the report.

Now let's go back to the tab of the program "Administration" - "CRM and sales" and indicate the second option for assessing the profitability of sales "Determined by the normative type of price.

We will see a field for selecting the type of price by which the cost of the goods will be determined.

That is, as I mentioned at the beginning of the article, when selling a product, its profitability is calculated as:

Profitability of sale = Sale price - Standard price type

Specify the type of price "Purchase price".

I already have a posted Goods and Services Receipt document. According to this document, goods Desk and Wardrobe were received at a price of 1,000 rubles. and 4,000 rubles. respectively.

But I will set the “Purchase Price”, for example, on the Table 1,500 rubles, and on the Cabinet 4,500 rubles, so that you and I can see the difference in the report “Evaluation of the profitability of the sale”.

Now let's open our implementation and open the return on sales report.

Click on the image to enlarge.

As you can see, our profitability is already different than it was when using the “Determined by the estimated cost” option.

Well, we have considered the functionality of the analysis and preliminary assessment of the profitability of sales when preparing documents. The functionality, I would say, is very useful, because it allows you to quickly receive information about the current sale of goods and the sales results of the manager as a whole. Which of the two possible options to use is up to you.

In the first option, the program should have movements at cost (the processing of the “Closing of the month” has been completed).

In the second option, a price must be set for the product, which will be the cost of the product when viewing the preliminary profitability.