Data for calculating the average to ZUP 3.0. all cases other than vacation
In this article, I will tell another way of starting working with "1C: Salary and Human Resources Management 3.0" (ZUP 3.0) - Enter the initial residues. This method is used in cases where the company already performs its activities for some time, but the base ZUP 3.0 was not conducted (for example, another software was used) or for some reason it is impossible to transfer data from the old configuration.
The latter often happens if the database is damaged or it was carried out with rude errors, as a result, it is easier to start all the new database, than to correct the many years of "jambs" of unskilled employees. After all, most mistakes lies in the long time of closed periods, and the attempt to correct them leads to the emergence of new problems.
By the way, one of the global advantages "1C: Salary and personnel management 3.0" and "1C: Accounting 3.0" is protection against erroneous actions. The program controls the documents that the user is trying to hold and does not give it if the document is incorrect. And when data with errors are imported into the base ZUP 3.0, these errors are immediately flourished in a lush color in the warnings window.
Most recently, in my practice there was a characteristic case. It was necessary to transfer data to an organization that worked with the program "1C: salary and frames 7.7" for more than fifteen years - almost from the moment this configuration appears. The number of errors identified after transferring errors and caused an obsessive desire to throw the server into the fire. It was incorrectly executed vacation, mistakenly decorated personnel orders and a lot more. It was just unreal to correct all this. But since the state of the organization contained only about twenty people, the problem was very simply solved by the introduction of initial balances.
So let's see how it is done. To begin, it is necessary to conduct initial configuration configuration using the wizard, as described in the articles and "Setup. The process will populate information about the organization and configure recruitment, as well as payroll.
After filling, all settings need to be checked and adjusted and supplementable if necessary. About where to look for these settings in the program, I told in the articles, and. There was also said, for which each of these settings is responsible.
If you need to create new accruals or hold, it's time to do this at this stage.
Then you need to fill out lists of divisions, positions, work schedules and staffing, if you assume it.
When all this is done, you need to put in the database of all individuals and employees.
When entering the initial remnants of employees, you can add not documents to work, but a special document "Data on the start of operation of the program", which is in the "Frames" section.
In this document, working periods for each employee and leave remains are recorded.
At the same stage, there is an existing child care vacation, other lack, loans, as well as executive sheets, if available.
If at the time of entering the initial balances between the organization and employees there are wage arrears, they must be fixed by the "Salary Initial Debt" document, which is in the "Payments" section. If I do not change my memory, earlier this document was in the "Salary" section.
Debt should be indicated at the end of the month. Moreover, if an employee must be an enterprise, then the amount in the relevant column must be negative.
The size of the average earnings in the documents using the calculation on average earnings can be adjusted directly in these documents when creating them.
If the entry of the initial residues is carried out at the beginning of the year, it is also necessary to make information about taxes and contributions.
Information on NDFL is made using the NDFL Accounting Operation Document (previously called "Tax Accounting Operation on NFFL"), which is in the "Taxes and Contributions" section.
Transitions to a new edition 3.1 Program 1C: ZUP and 1C: ZSU is now in full swing. So, the new base is created, and the data is automatically transferred from the previous version. What must be checked first and where in the new program find the cherished documents with the data? We have prepared a small crib for you.
1. Basic information on employees
Section "Main" - "Data on the start of operation"
Document type:
- Initial staffing: Planned accruals and the amount of advance, the position and division of the employee, the remains of the vacation.
- Salary: remnants of mutual settlements (+ debt for the organization, - debt per employee).
- Periods paid before the start of operation: Vacation paid in the previous program to transfer, falling for the current period.
2. Executive lists
Section "Salary" - "Alimony and other retention".
3. The right to deduct ndfl
Section "Taxes and contributions".
Document type:
- Application for deductions on personal income tax - Standard deductions;
- Notification But about the right to deduct - property deductions, notification But you need to enter manually.
4. Estimated data (average earnings)
The "Administration" tab - "Data Transfer" (Middle for FSS is transferred over the 3 previous years, to calculate leave for the 15 preceding months).
To view the average employee, you need to use "Reports" - "Universal Report". Also the amount and number of days that are taken when calculating leave can be seen directly in the document, for example, "vacation".
5. If there are loan agreements with an employee ("Salary" tab - "loans to employees"), then they need to be administered manually. Also, if there is a child care leave ("Salary" - "child care leave"), information also needs to be introduced manually.
For example, in 1C records of salary from January 2013, and historical data for the calculation of average earnings are not made. When attempting to accrual the employment of employee in July 2013, an appropriate information message is issued that the earnings data is incomplete and the missing data is necessary to supplement:
Accordingly, from January to June 2013, data for the calculation is, they are determined by the results of calculations carried out in 1C ZUP, but the data from July to December 2012 must be checked:
Cuts of data that must be done is determined dynamically.
- If the checkbox is checked, which is charged a premium, then the data should be made separately by type of income: main earnings, awards, annual awards. Because they are different in the base of the average earnings.
- If the checkbox is selected that there is indexation, it means you need to share all income to indexed and not indexed.
In our example there are no indexations, no awards, so enough to make:
- the amount of accruals and accepted information
- the number of days spent, it is important.
- The number of spent days on six days must be made if vacation is available in working days.
- Explosive calendar days is very important, it is for the holidays of basic information.
- And the norms of days according to the manufacturing calendar can also be specified, sometimes used:
The missing data can be made manually, directly in the form of data entry to calculate the average earnings. But in ZUP, you can predict what income was paid by an employee for the missing period, based on its current personnel data - the "Addition" button:
After pressing the "Add" button in 1C, the necessary information is automatically filled. Immediately on the introduced data, average earnings are calculated:
Once the income introduced in this form can be used in the future if the employee is charged to the subsequent leave, or, for example, payment for temporary finding on a business trip or in some other cases.
In addition, it is possible to check the check box and use the same data and for the average earnings when calculating the hospital sheets and child care benefits:
We save the entered data by clicking the "OK" button and conduct a vacation document:
Next, register another vacation for the same employee, for example, from 01.09.2013 to 07.09.2013. In 1C ZUP, average earnings were calculated automatically, and for the period from January 2013 to August 2013, information from the information base was used, according to the results of accruals . And for the period from September 2012 to December 2012, data used when the employee's previous holiday is accrued:
In this case, it will be necessary to make data for 2012, starting from January of the month. Also to make data for 2011, since the average income for the two preceding calendar years is taken to pay for temporary disability. Therefore, to calculate the benefit on the Hospital data on the average earnings, you need to do:
Setting the calculation of the average earnings in 1C ZUP
In 1C ZPE, there is the ability to customize the base for calculating the average earnings. When setting up any types of accruals, you can install whether they will be included in the calculation of the average earnings or will not be included:
In addition, the program has a common form where you can view a list of all charges that are included in the database to calculate the average earnings, and which cannot be in the database for calculating the average earnings:
Full list of our suggestions:
Put your assessment this article:
According to the current legislation, in the estimated base for the calculation of the average earnings include all types of wages, with the exception of payments of social and other nature (compensation for the physical examination, travel and nutrition, training costs and others). Depending on the settings of the information base, the above charges can be indexed, and remain unchanged (the exception is only non-indexed accruals that are not tied to the magnitude of the Oklade of the employee, for example. Supplement amount). This setting can be seen in the Setup section - the calculation of the salary checkbox "The earnings indexing is performed."
When the checkbox is turned on, the accrual type option becomes an active accrual indexing check mark. This feature is provided for such cases when it is necessary to indicate whether indexing is subject to, or not. (Section Setting - accrual).
Compensation payments are not taken into account when calculating average earnings. And if we create (or choose from the list of available) accrual, then when you select the compensation payments assignment, the Middle Earnings section becomes inaccessible for editing.
Some types of accruals make it possible to independently determine whether they enter the base to calculate the average or not. For example, material assistance associated with the needs of the employee relates to social payments and is not taken into account when calculating. And material assistance to vacation (if specifically stipulated in the collective agreement) refers to the payments of a stimulating nature and is taken into account when calculating the average earnings. If the calculation is changed in the form of inclusion in the calculation, then to update the accumulation register, without resorting to the recovery of all wage calculation documents, you can use the "Update data to calculate the average earnings" service, which is in the Salary section.
Analyzing the base settings of the average earnings after a separate accrual is inconvenient. Therefore, in the configuration it is possible to massively view all the accruals included in the database. To do this, in the Adjustment - Accrual section, click the "Settings of Ndfl, Middle Earnings, etc."
As can be seen in the figure, the setting consists of two columns: in the left, all the accruals defining the database, in the right - all not taken into account. To change the accounting order, it suffices to move the accrual from one column to another. At the same time, here we can immediately change the procedure for indexing accruals.
After setting up the base, we can go directly to the accrual themselves calculated based on the average earnings. Such accruals include paid leave, business trip, disability days, child-friendly child care days, paid downtime. By default, the calculation is worth the calculation period of 12 months (this norm is established by Art. 139 of the Labor Code of the Russian Federation), but if another period is specified in the collective agreement, the accrual setting allows us to fix it.
In the accrual documents (eg, business trip, leave, sick leave, etc.) There is a separate form of data entry to calculate the average earnings. In this form, all the earnings of the employee are collected in all charges constituting the average base, the number of actually spent days is taken into account. Based on these data and is calculated by the average daily (mid-hour earnings of the employee).
If you have any questions about calculating the average earnings in 1C ZPE, we will be happy to answer them as part of the free consultation.
We are talking about the nuances of calculating the average earnings and give examples of setting the base of the calculation of the average earnings in "1C: wages and managing staff 8" edition 3.
In certain laws of the Russian Federation, the employee should be paid in the form of a mean earnings, and not a wage. The procedure for calculating the average wage for hospitals and, for example, travel and vacations, differs. Experts 1C clarify that it is necessary to know about the calculation of the average earnings in accordance with the Decree of the Government of the Russian Federation of December 24, 2007 No. 922 for the cases provided for by the Labor Code of the Russian Federation, and also give examples of the setting of the calculation of the average earnings in "1C: Salary and Personnel Management 8" Edition 3 and the influence of deviations from the employee's work schedule for the calculation.
In what cases is the average earnings calculated
The term "average earnings" is used in regulatory documents to describe the calculation rules in different cases. At the rate of average, the days of illness, vacations, business trips and others are paid. At the same time, the average earnings are calculated in different ways. Thus, the Federal Law of December 29, 2006 No. 255-FZ and the Decree of the Government of the Russian Federation of June 15, 2007 No. 375 determine the procedure for calculating temporary disability benefits, for pregnancy and childbirth and child care before reaching for them 1.5 years.
The general rules for calculating the average earnings for cases where the employee was not in the workplace, but such earnings remained under the Labor Code, established in Article 139 of the Labor Code of the Russian Federation.
The calculation procedure is defined in the Decree of the Government of the Russian Federation of December 27, 2007 No. 922 (hereinafter referred to - Resolution No. 922).
This article discusses the calculation of the average earnings in accordance with Article 139 of the Labor Code of the Russian Federation and Decree No. 922.
The specified resolution determines the various procedure for calculating the 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 the definition of the average earnings of employees who are set to summarized working hours).
Cases named in the Labor Code of the Russian Federation, when average earnings remain:
- business trip (Art. 167 of the Labor Code of the Russian Federation);
- passage of the medical examination (Art. 185 of the Labor Code of the Russian Federation);
- translation of the employee to another job (Art. 72.2 and 182 of the Labor Code of the Russian Federation);
- delivery of blood and its components (Art. 186 of the Labor Code of the Russian Federation);
- participation of an employee in collective bargaining (Art. 39 of the Labor Code of the Russian Federation);
- non-fulfillment of labor standards, non-fulfillment of labor (official) responsibilities for the fault of the employer (Art. 155 of the Labor Code of the Russian Federation);
- etc.
The Labor Code of the Russian Federation established not a closed list of cases of conservation of average earnings.
The formulas for calculating the average earnings are different for the first and second cases, but in each of them you need to know the estimated period, the number of days spent in the estimated period, and the actual earnings of the employee obtained in the settlement period.
Estimated period
In general, the estimated period consists of 12 months preceding the month of preserving the average earnings (clause 4 of the Resolution No. 922).
In accordance with Article 139 of the Labor Code of the Russian Federation, the employer may establish a different settlement period if it does not worsens the position of employees.
In the program "1C: salary and personnel management 8" editors 3 in documents registering days of payment on average earnings (for example, Vacation, Business trip), there is an icon in the form of a pencil - Change average earnings calculation data (Fig. 1).
Fig. 1. Changing the estimated period
When you click on it opens a window Entering data to calculate the average earnings. Switch Ras-even period of average earnings Provides the ability to select a period: Standard, determined automatically and Specified manually.
If local regulatory documents provide for the estimated period from 12 months, then when working with such documents in the program, the user should independently control to Middle earnings, calculated by manually set by the estimated period, was no less than standard. Control convenient to produce in the form , Rearming the switch.
At the current period, the time of actual work is included. If, for example, with an employee, the employment contract has been concluded in less than 12 months before calculating the average earnings, then in the standard settlement period (12 months) the time before acceptance will be excluded.
That is, the estimated period does not change, but it is distinguished in it. The list of excluded periods is defined in paragraph 5 of Resolution No. 922.
So, from the settlement period, the time is excluded when the employee:
- received average earnings (with the exception of baby feeding breaks);
- was on maternity leave, hospital;
- did not work in connection with the downtime due to the fault of the employer or on the circumstances independent of the parties;
- could not work because of the strike, in which he himself did not participate;
- used additional paid days of care for a disabled child;
- in other cases, it was released from working with full or partial maintenance of earnings or without any.
The program "1C: Salary and Personnel Management 8" editors 3 provides for the exception of such periods.
Setting the excluded periods is carried out in the calculation type card (Menu Setting - Accrual) On the tab Middle earnings.
If the flag Not installed, then the period and earnings for this period are excluded at the calculation of the average.
When the spent days in the settlement period are missing period, the calculation is made at the current month.
For example, a business trip or vacation comes in that month when an employment contract was concluded with an employee. In the shape of Data entry to calculate the average earnings button Add according to the photo Fills the data for calculating the average earnings of the current month information.
Actual earnings
When calculating the average earnings in the actual earnings of the employee include all the paid payments, accrued employee in the estimated period, regardless of the source of funds. In other words, all payments installed by the employer in the wage system are included in the calculation of the average.
In addition, it is included in the calculation:
- surcharges and surcharges for tariff rates and salaries for professional mind, experience, foreign language, combining occupations, an increase in the volume of work, etc.;
- payments related to working conditions (district coefficients, surcharges for work in harmful, dangerous and difficult conditions, for the work overtime at night, on a day off);
- premiums and remuneration provided for by the wage system fixed in local regulations;
- other types of salary payments have an employer.
note, one-time premiums that are not included in the wage system are not involved in the calculation of the average earnings. In the program "1C: Salary and personnel management 8" Editing 3 All types of calculation that have been established Appointment of accrual - Prize, be sure to calculate the average earnings.
Flag Include in the database of accruals when calculating the average earnings In the Card Calculation Card on the tab Middle earnings For such accruals, the default is not available for switching. For premiums that are not included in the average earnings should create new types of calculation with Assignment of accruals - other accruals and payments.
Calculation of average earnings for ...
... all cases other than vacation
The calculation of the average earnings for all cases other than vacation is made at the same formula, but depends on the wage system, more precisely, from the method of taking into account time.
If the employee is set to the mode of summary working time, then the calculation is carried out on the clock, and the average hourly earnings of the SCS is calculated by the formula:
CIDS \u003d SP / FVCH,
where:
FVCH - actually spent time in the clock;
Zp. - Earnings accrued by an employee for the estimated period.
If the employee does not have a summary working time regime, then the calculation is carried out by day and the average daytime earnings of the SDZ is calculated by the formula:
SDZ \u003d SP / FVD,
where FVD. - In fact, spent time in the days.
To calculate the average earnings for the period in this case, the average day earnings is multiplied by the time to pay for the employee schedule in the days.
However, not in all cases the time to be paid is calculated according to the schedule. The exception is the payment of donor days. In letters from 01.03.2017 № 14-2 / \u200b\u200bOOG-1727 and from 10/31/2016 No. 14-2 / \u200b\u200bin 1087, Russian Ministry of Internal Affairs explained that it should be paid for the days of blood delivery and its components based on the eight-hour working day, regardless of the schedule Employee.
... holidays
When calculating the average earnings for the purpose of calculating leave, regardless of the method of accounting for working time, accounting is carried out by day.
The average daytime earnings of the SDZ is considered by the formula:
SDZ \u003d sn / 29.3 x month + Dnieper,
where:
Mes - the number of full spent calendar months;
Dniece - Number of days in incomplete calendar months, calculated by the formula:
Dniep \u200b\u200b\u003d 29.3 / cd x od,
where:
CD - the number of calendar days in the month;
OD - The number of worked days.
Examples of the effects of deviations from the work schedule for the calculation of the average earnings
Consider how to calculate the average earnings of the employee affect the deviations from its working chart, for example, because of finding on vacation, business trip, etc.
Example 1.
When calculating leave (Fig. 2), the average day earnings amounted to 1,022,68 rubles. (358 571.43 rubles / 350.62 days). In November, one day was not worked out, and earnings amounted to 28,571,43 rubles. Month November is not fully taken into account - 28.32. In total for the estimated period, $ 358,571.43 rubles were calculated. and taken into account 350.62 days.
Fig. 2. Calculation of medium earnings for vacation, Example 1
When calculating a business trip (Fig. 3), the average day earnings amounted to 1,451,71 rubles. (358 571.43 rubles / 247 days). In total for the estimated period, $ 358,571.43 rubles were calculated. And 247 spent days taken into account.
Fig. 3. Calculation of medium earnings for a business trip, Example 1
Example 2.
When calculating vacation (Fig. 4), the average day 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 ration has influenced the earnings of the employee - in November, it is accrued $ 28,571.43 rubles, as with any other non-appearance . But the ration does not reduce the number of worked days, and the month is considered to be fully spent. In total for the estimated period, $ 358,571.43 rubles were calculated. and taken into account 351.6 days.
Fig. 4. Calculation of medium earnings for vacation, Example 2
However, when calculating the communation of the ration is not one of the actually spent days, and the average earnings is 1,451,71 rubles., As in Example 1 (see Fig. 3).
Example 3.
When calculating leave (Fig. 5), the average day earnings amounted to 1,032,18 rubles. (362 914.98 rubles / 351.6 days.), What is more than in Example 1. The fact is that work on the day off has influenced the earnings of the employee - accrued in November 32,914, 98 rubles. But the work on the day off does not change the fact of a fully spent month, and the ratio of 29.3 is used to calculate. In total for the estimated period, $ 362,914.98 rubles were accrued. and taken into account 351.6 days.
Fig. 5. Calculation of average earnings for vacation, Example 3
When calculating a business trip, work on the weekend increases actually spent days, and the average earnings is 1,457,49 rubles. (362 914.98 rubles / 249 days). In total for the estimated period, $ 362,914.98 rubles were accrued. and taken into account 249 worked days (Fig. 6).
Fig. 6. Calculation of average earnings for a business trip, Example 3
From the editorial Receive even more information on the rules for calculating the average earnings, about the accounting of premiums, on the indexation of the average earnings with increasing salaries, on the situation of the average earnings in local documents, and also familiarize themselves with other examples of the calculation of the average earnings in the program "1C: Salary and Human Resources Program 8 "Edition 3 can be from
