1c data for calculating average earnings. Examples of the influence of deviations from the work schedule on the calculation of average earnings

As usual, the reason for writing this article was a problem that we had to solve: a document behaved strangely in the 1C: Salary and Personnel Management 2.5 database Accrual of vacation to employees of organizations. Namely, for some employees the average salary was calculated normally, but for others it was zero, although these employees definitely received wages for the entire year. But first things first.

What is average earnings and when does it apply?

Average earnings are the average salary of an employee for a certain period of time. It is used when paying:

  • sick leave;
  • maternity benefits, child care benefits up to 1.5 years;
  • vacation pay and compensation for unused vacation;
  • for days of blood donation, days off to care for a disabled child, etc.

We will leave the detailed methodology for calculating average earnings outside the scope of this article, but note that average earnings are calculated differently, depending on the purpose for which it is calculated. Next you will see how this is implemented in 1C: Salary and HR Management

Mechanism for calculating average earnings in 1C: Salaries and personnel management

To calculate average earnings in 1C: Salaries and personnel management, the following objects exist:

  • plan of calculation types Average earnings(available via menu ).
  • calculation register Calculation of average earnings.

The calculation register stores information about the calculated average earnings for each period by employee and type of calculation (average earnings can take into account not only salary, but also bonuses, vacation pay, travel allowances, etc.). In terms of calculation types, information is stored about what types of calculation are used when calculating average earnings in various situations (see figure).

Why is average earnings not calculated in 1C: Salaries and personnel management

In our case, the average earnings were calculated, but were equal to zero. After examining the database, it turned out that users had added a calculation type Salary by day (production and services), which was used to calculate salaries for individual employees. However, this calculation type was not added to the calculation types plan Average earnings, which means these payments were not taken into account when calculating average earnings.

In our case, the employee had no other payments, so the error was obvious - zero average earnings. However, situations often arise when the calculation does not include earnings that are not the only one. In this case, the average earnings will be calculated, the employee will receive vacation pay or sick leave, but the amount will be underestimated, because Not all payments were taken into account.

For example, an employee receives his basic salary according to a predefined type of calculation Salary by day, and an additional bonus - according to the type of calculation created by the user. There is a predefined type of calculation in terms of calculation types (if it has not been removed), but the bonus will have to be added manually, otherwise the calculation of average earnings will be erroneous.

How to add an accrual to the calculation of average earnings

  1. Open plan of calculation types Average earnings(available via menu Payroll calculation by organization - Payroll settings - Average earnings).
  2. Select the required section and open it.
  3. Add a calculation type to 2 columns at once: Calculation base And Leading accruals. The first column shows that the amounts for this type of calculation will be taken into account when calculating average earnings, and the second column shows that it is necessary to recalculate the average earnings when the accrued amounts change.

If you encounter other errors when calculating average earnings in 1C: Salary and HR Management, we will be grateful for this information in the comments. The article will be updated.

We talk about the nuances of calculating average earnings and give examples of setting up the base for calculating average earnings in “1C: Salary and Personnel Management 8” edition 3.

In cases determined by the legislation of the Russian Federation, the employee must be paid in the form of average earnings, and not wages. The procedure for calculating the average salary for sick leave and, for example, business trips and vacations, differs. 1C experts clarify what you need to know about calculating average earnings in accordance with Decree of the Government of the Russian Federation of December 24, 2007 No. 922 for cases provided for by the Labor Code of the Russian Federation, and also provide examples of setting up the base for calculating average earnings in “1C: Salary and Personnel Management 8” edition 3 and the impact of deviations from the employee’s work schedule on the calculation.

In what cases is average earnings calculated?

The term “average earnings” is used in regulatory documents to describe calculation rules in different cases. Sick days, vacations, business trips and others are paid based on average earnings. At the same time, average earnings are calculated in different ways. Thus, Federal Law No. 255-FZ dated December 29, 2006 and Government Decree No. 375 dated June 15, 2007 determine the procedure for calculating benefits for temporary disability, pregnancy and childbirth, and child care until the child reaches 1.5 years of age.

The general rules for calculating average earnings for cases where an employee was not at work, but according to the Labor Code such earnings were retained, are established in Article 139 of the Labor Code of the Russian Federation.

The calculation procedure is defined in Decree of the Government of the Russian Federation dated December 27, 2007 No. 922 (hereinafter referred to as Decree No. 922).

This article discusses the calculation of average earnings in accordance with Article 139 of the Labor Code of the Russian Federation and Resolution No. 922.

This resolution defines a different procedure for calculating average earnings for two cases:

1. Vacation and compensation for unused vacation.

2. Other cases provided for by the Labor Code of the Russian Federation (except for cases of determining the average earnings of workers for whom summarized recording of working time is established).

Cases named in the Labor Code of the Russian Federation when average earnings are maintained:

  • business trip (Article 167 of the Labor Code of the Russian Federation);
  • passing a medical examination (Article 185 of the Labor Code of the Russian Federation);
  • transfer of an employee to another job (Articles 72.2 and 182 of the Labor Code of the Russian Federation);
  • donation of blood and its components (Article 186 of the Labor Code of the Russian Federation);
  • employee participation in collective bargaining (Article 39 of the Labor Code of the Russian Federation);
  • failure to comply with labor standards, failure to fulfill labor (official) duties through the fault of the employer (Article 155 of the Labor Code of the Russian Federation);
  • etc.

The Labor Code of the Russian Federation establishes a non-closed list of cases of maintaining average earnings.

The formulas for calculating average earnings are different for the first and second cases, but in each of them you need to know the billing period, the number of days worked in the billing period, and the actual earnings of the employee received in the billing period.

Billing period

In general, the billing period consists of 12 months preceding the month in which average earnings were maintained (clause 4 of Resolution No. 922).

In accordance with Article 139 of the Labor Code of the Russian Federation, the employer may establish a different pay period if this does not worsen the situation of employees.

In the program "1C: Salary and Personnel Management 8" edition 3 in documents registering days of payment based on average earnings (for example, Vacation, Business trip), there is a pencil icon - Change data for calculating average earnings(Fig. 1).


Rice. 1. Changing the billing period

When you click on it, a window opens Entering data to calculate average earnings. Switch Calculation period of average earnings provides the ability to select a period: Standard, determined automatically And Set manually.

If local regulatory documents provide for a billing period other than 12 months, then when working with such documents in the program, the user should independently control that Average earnings, calculated according to the manually set billing period, was no less than according to the standard one. It is convenient to carry out control in the form , moving the switch.

The billing period includes the time of actual work. If, for example, an employment contract with an employee was concluded less than 12 months before calculating average earnings, then in the standard calculation period (12 previous months) the time before hiring will be excluded.

That is, the billing period does not change, but unworked time is allocated in it. The list of excluded periods is defined in paragraph 5 of Resolution No. 922.

Thus, the time when the employee:

  • received average earnings (excluding breaks to feed the child);
  • was on maternity leave and sick leave;
  • did not work due to downtime due to the fault of the employer or due to circumstances beyond the control of the parties;
  • could not work due to a strike in which he did not participate;
  • used additional paid days to care for a disabled child;
  • in other cases, he was released from work with full or partial retention of earnings or without it.

The 1C: Salaries and Personnel Management 8 program, edition 3, provides for the exclusion of such periods.

Setting up excluded periods is carried out in the calculation type card (menu Settings - Accruals) on the tab Average earnings.

If the flag is not established, then the period and earnings for this period are excluded from the calculation of the average.

When there are no days worked in the billing period, the calculation is made based on the current month.

For example, a business trip or vacation occurs in the month when an employment contract was concluded with the employee. In the shape of Entering data to calculate average earnings button Add according to payroll data fills in the data for calculating average earnings with information from the current month.

Actual earnings

When calculating average earnings, the employee’s actual earnings include all types of payments provided for by the remuneration system and accrued to the employee in the billing period, regardless of the source of funds. In other words, the calculation of the average includes all payments established by the employer in the remuneration system as wages.

In addition, the following are included in the calculation:

  • allowances and additional payments to tariff rates and salaries for professional skills, experience, knowledge of a foreign language, combining professions, increasing the volume of work, etc.;
  • payments related to working conditions (regional coefficients, additional payments for work in harmful, dangerous and difficult conditions, for working overtime at night, on days off);
  • bonuses and remunerations provided for by the remuneration system, fixed in local regulations;
  • other types of wage payments from the employer.

note, one-time bonuses that are not included in the remuneration system do not participate in the calculation of average earnings. In the program "1C: Salaries and Personnel Management 8" edition 3, all types of calculations that have Purpose of accrual - Bonus, are necessarily included in the calculation of average earnings.

Flag Include in the accrual base when calculating average earnings in the calculation type card on the tab Average earnings for such accruals is set by default and is not available for switching. For bonuses that are not included in average earnings, new types of calculation should be created with Purpose of accrual - Other accruals and payments.

Calculation of average earnings for...

...all cases except vacation

The calculation of average earnings for all cases, except vacation, is made using the same formula, but depends on the remuneration system, or more precisely, on the method of time recording.

If an employee is set to a summed working time regime, then the calculation is carried out by the hour, and the average hourly earnings of the SCHZ are calculated using the formula:

SchZ = ZP / FHF,

Where:
HPF- actual time worked in hours;
Salary- earnings accrued to the employee for the pay period.

If an employee does not have a summarized working time regime, then the calculation is carried out by day and the average daily earnings SDZ is calculated using the formula:

SDZ = ZP / FVd,

Where FVd- actual time worked in days.

To calculate the average earnings for the period, in this case, the average daily earnings are multiplied by the payable time on the employee’s schedule in days.

However, not in all cases the time subject to payment is calculated according to the schedule. The exception is payment for donor days. In letters dated 03/01/2017 No. 14-2/ОOG-1727 and dated 10/31/2016 No. 14-2/B-1087, the Russian Ministry of Labor explained that payment for days of donating blood and its components should be made based on an eight-hour working day, regardless of the schedule employee.

...vacations

When calculating average earnings for the purpose of calculating vacation, regardless of the method of recording working time, accounting is carried out by day.

The average daily earnings of SDZ is calculated using the formula:

SDZ = Salary / 29.3 x Month + Dnep,

Where:
Months
- number of complete calendar months worked;
Dnep- the number of days in incomplete calendar months, calculated by the formula:

Dnep = 29.3 / CD x OD,

Where:
KD
- number of calendar days in a month;
OD- number of days worked.

Examples of the influence of deviations from the work schedule on the calculation of average earnings

Let’s consider how the calculation of an employee’s average earnings is affected by deviations from his work schedule, for example, due to being on vacation, a business trip, etc.

Example 1

When calculating vacation (Fig. 2), the average daily earnings amounted to 1,022.68 rubles. (RUB 358,571.43/350.62 days). In November, one day was not worked, and earnings amounted to 28,571.43 rubles. The month of November is not fully taken into account - 28.32. In total, 358,571.43 rubles were accrued for the billing period. and 350.62 days are taken into account.


Rice. 2. Calculation of average earnings for vacation, Example 1

When calculating a business trip (Fig. 3), the average daily earnings amounted to 1,451.71 rubles. (RUB 358,571.43 / 247 days). In total, 358,571.43 rubles were accrued for the billing period. and 247 days worked were taken into account.


Rice. 3. Calculation of average earnings for a business trip, Example 1

Example 2

When calculating vacation (Fig. 4), the average daily earnings amounted to 1,019.83 rubles. (358,571.43 rubles / 351.6 days), which is less than in Example 1. The fact is that the time off affected the employee’s earnings - in November 28,571.43 rubles were accrued, as with any other absence . But time off does not reduce the number of days worked, and the month is considered fully worked. In total, 358,571.43 rubles were accrued for the billing period. and 351.6 days were taken into account.


Rice. 4. Calculation of average earnings for vacation, Example 2

However, when calculating a business trip, time off is not included in the number of days actually worked, and the average earnings are 1,451.71 rubles, as in Example 1 (see Fig. 3).

Example 3

When calculating vacation (Fig. 5), the average daily earnings amounted to 1,032.18 rubles. (362,914.98 rubles / 351.6 days), which is more than in Example 1. The fact is that working on a day off affected the employee’s earnings - 32,914.98 rubles were accrued in November. But working on a day off does not change the fact of a fully worked month, and a coefficient of 29.3 is used for calculation. In total, 362,914.98 rubles were accrued for the billing period. and 351.6 days were taken into account.


Rice. 5. Calculation of average earnings for vacation, Example 3

When calculating a business trip, working on a weekend increases the days actually worked, and the average earnings are 1,457.49 rubles. (RUB 362,914.98 / 249 days). In total, 362,914.98 rubles were accrued for the billing period. and 249 days worked were taken into account (Fig. 6).


Rice. 6. Calculation of average earnings for a business trip, Example 3

From the editor. Get even more information about the rules for calculating average earnings, about accounting for bonuses, about the indexation of average earnings when salaries increase, about the provisions on calculating average earnings in local documents, and also get acquainted with other examples of calculating average earnings in the 1C: Salary and Personnel Management program 8" edition 3 can be found from

According to current legislation, the calculation base for calculating average earnings includes all types of wages, with the exception of social and other payments (compensation for medical examinations, travel and food, training expenses, etc.). Depending on the settings of the information base, the above accruals can either be indexed or remain unchanged (the only exception is non-indexed accruals that are not tied to the employee’s salary, for example, an additional payment in the amount). This setting can be seen in the Settings – Payroll section – checkbox “Employee earnings are indexed”.

When the checkbox is enabled in the accrual type settings, the accrual indexation checkbox becomes active. This opportunity is provided just for such cases when you need to indicate whether the accrual is subject to indexation or not. (Section Settings – Accruals).

Compensatory payments are not taken into account when calculating average earnings. And if we create (or select from the list of available ones) an accrual, then when we select the accrual purpose “Compensation payments”, the Average Earnings section becomes unavailable for editing.

Some types of accruals make it possible to independently determine whether they are included in the base for calculating the average or not. For example, material assistance related to covering the needs of an employee is classified as social payments and is not taken into account in the calculation. And financial assistance for vacation (if stipulated in the collective agreement) refers to incentive payments and is taken into account when calculating average earnings. If in the form of an accrual, its inclusion in the calculation has been changed, then in order to update the accumulation register without resorting to re-posting all payroll documents, you can use the “Update data for calculating average earnings” service, which is located in the “Salary” section.

It is inconvenient to analyze the settings of the average earnings base through a separate accrual. Therefore, in the configuration it is possible to massively view all the accruals included in the database. To do this, in the Settings – Accruals section, click the button “Setting up personal income tax, average earnings, etc.”

As you can see in the figure, the setting consists of two columns: on the left are all charges that determine the base, on the right are all those not taken into account. To change the accounting order, simply move the accrual from one column to another. At the same time, here we can immediately change the order of indexation of accruals.

After setting up the base, we can go directly to the accruals themselves, calculated on the basis of average earnings. Such accruals include paid vacations, business trips, days of incapacity for work, days of caring for a disabled child, and paid downtime. By default, the accruals include a calculation period of 12 months (this norm is established by Article 139 of the Labor Code of the Russian Federation), but if a different period is specified in the collective agreement, setting up the accrual allows us to correct it.

In accrual documents (e.g. Business trip, Vacation, Sick leave, etc.) there is a separate data entry form for calculating average earnings. This form collects the entire employee’s earnings for all accruals that make up the average base, taking into account the number of days actually worked. Based on these data, the average daily (average hourly earnings of the employee) is calculated.

If you still have questions about calculating average earnings in 1C ZUP, we will be happy to answer them as part of a free consultation.

For example, in 1C salary accounting has been maintained since January 2013, but historical data for calculating average earnings has not been entered. When trying to accrue leave to an employee in July 2013, a corresponding information message is issued that the earnings data is incomplete and the missing data must be supplemented:

Accordingly, from January to June 2013 there is data for calculation, they are determined based on the results of calculations carried out in 1C ZUP, but the data from July to December 2012 must be added:

The data sections that need to be updated are determined dynamically.

  • If the checkbox is checked that a bonus is calculated, then the data must be entered separately by type of income: basic earnings, bonuses, annual bonuses. Because they are included in the average earnings base differently.
  • If the checkbox is checked that there is indexation, then you need to divide all income into indexed and non-indexed.

In our example there are no indexations or bonuses, so it is enough to enter:

  • the amount of accruals and information about hours worked,
  • the number of days worked is important.
  • The number of days worked on a six-day period must be entered if vacations are provided in working days.
  • Calendar days worked are very important; this is the basic information for vacation.
  • And the norms of days according to the production calendar can also be indicated; sometimes it is used:

The missing data can be entered manually, directly in the Data Entry form to calculate average earnings. But in the ZUP you can predict what income was paid to the employee for the missing period, based on his current personnel data - with the “Add” button:

After clicking the “Add” button in 1C, the necessary information is automatically filled in. The average earnings are calculated immediately based on the entered data:

Once the income is entered into this form, it can be used in the future if the employee is accrued subsequent leave, or, for example, payment for temporary stay on a business trip or in some other cases.

In addition, it is possible to check the box and use the same data for average earnings when calculating sick leave and child care benefits:

We save the entered data by clicking the “ok” button and post the vacation document:

Next, we register another vacation for the same employee, for example, from 09/01/2013 to 09/07/2013. In 1C ZUP, the average earnings were calculated automatically, and for the period from January 2013 to August 2013, information from the information base was used, based on the results of accruals . And for the period from September 2012 to December 2012, the following data was used when calculating the employee’s previous leave:

In this case, you will need to add data for 2012, starting in January. Also enter data for 2011, since for temporary disability payments the average income for the two previous calendar years is taken. Therefore, to calculate sick leave benefits, data on average earnings must be added:

Setting up the calculation of average earnings in 1C ZUP

In 1C ZUP it is possible to set up a base for calculating average earnings. When setting up any types of accruals, you can determine whether they will be included in the calculation of average earnings or not:

In addition, the program has a general form where you can view a list of all accruals that are included in the base for calculating average earnings, and which are not included in the base for calculating average earnings:

Full list of our offers:


Please rate this article: