Calculation of wages for various categories of employees at the enterprise. Calculation of additional wages Video lesson “The procedure for paying wages to employees of an organization”

Hello dear readers. Today I would like to talk about a set of very interesting and useful ZUP 3.0 configuration features using the example of solving a specific problem. The set of tools that will be discussed is already helped many of my clients automate quite complex accounting issues. In the previous version of the ZUP program, in edition 2.5, this would probably require modification of the standard configuration (you can read about the differences between ZUP 3.0 and ZUP 2.5 in).

So that you can immediately decide whether this material is worth reading, in this introduction I will give the conditions of the example under consideration. We will consider the situation in some organization where drivers work. Their basic payment is made at an hourly rate for the number of hours worked in a month (i.e., according to actual Attendance - I). Also, there may be hours in a month (or there may not be any) worked on repairs, which are paid at a different rate depending on the complexity of the repair - 3 levels of complexity.

In this example, I will offer two options for solving the problem, we will see how ZUP 3.0 formulas are created, are created and custom indicators can be configured, and also talk about the mechanism Initial data entry templates, with which you can create forms for entering indicator values ​​(I already mentioned this mechanism in the article about). I’ll also tell you about two new ways to perform calculations:

• Only if an indicator value is entered
• Only if time tracking type is entered

Perhaps all these words sound quite menacing and confusing, so I will try to explain what’s what as simply as possible.

Setting and entering the value of a constant indicator in 1C ZUP 3.0. What is a “Source Data Entry Template”?

✅

✅

✅

I have already stated the conditions of the example under consideration, so let’s immediately proceed to solving it. So, we have an employee Ivan Petrovich Frolov, who is a driver and has a planned standard accrual "Payment at an hourly rate" with a rate of 150 rubles/hour. It is also worth noting that the employee has a standard five-day, 40-hour week as his main schedule.

Now we need to set up a program to pay an employee for hours spent in repairs. Configure in the most convenient way for the calculator. By the most convenient I mean this method, when the calculator enters only the number of hours in repair, and the program does the rest itself. Let's begin.

Firstly, we need to enter into the program information about the rate for 1 hour of repair work for each of the 3 levels of repair complexity. To do this, open the “Payroll Indicators” directory, which is located in the “Settings” section of the main menu.

When creating it, it is important to understand the indicator settings. There is nothing complicated with the names, we add them as shown in the figure below or come up with our own more original name. Let's look at the remaining fields in more detail:

• Indicator purposes– in our case, hourly rates for repairs will not relate to a specific employee, but will apply to employees of the entire organization, so we select the value "For organization";
• Indicator type– hourly rate is "Monetary indicator";
• Accuracy– if the hourly rate is indicated to the nearest kopeck, then you must indicate the number 2 (this means two decimal places);
• Is the tariff rate– yes, in our case this is so. In the next field select "Hourly rate";
• Used– it is important to understand that this indicator is not entered monthly, it is a conditionally constant value. Why conditional? Because once every year or two this rate may still change. Therefore we specify the switch "In all months, after entering a value (constant use)". A comment appears at the bottom: “Changes periodically as circumstances change.”

In the same spirit, we create two more indicators with similar settings: “Rate (repair 2)” and “Rate (repair 3)”.

Now we need to enter specific values ​​for these indicators. We will create a form with which we will enter the values. I already wrote about this mechanism in the article. If it is not yet entirely clear what we are talking about, then just do what I am writing about and in a few paragraphs everything will become clear.

In the “Settings” section of the main menu, select the “Initial data entry templates” item and create a new element of this directory (in other words, click the “Create” button). In this new element set the name, for example, “Entering hourly repair rates for drivers.” Just below we indicate that using this template we will enter the values ​​of constant indicators - check the box "Permanent". Next, we directly select for which specific indicators values ​​will be entered using this template - check the boxes opposite the indicators created in the previous step. These settings will be enough for us for now.

As a result, a window will open in which we need to set the rates for each level of repair complexity and indicate the date from which these indicators will be valid. For our example, the following hourly rates for repairs will be:

• Level 1 difficulty – 120 RUR/hour
• Difficulty level 2 – 130 RUR/hour
• Difficulty level 3 – 140 rub./hour

These indicators are valid from 04/01/2015. The input principle is shown in the picture.

Monthly indicators in 1C ZUP 3.0

✅ Seminar “Lifehacks for 1C ZUP 3.1”
Analysis of 15 life hacks for accounting in 1C ZUP 3.1:

✅ CHECKLIST for checking payroll calculations in 1C ZUP 3.1
VIDEO - monthly self-check of accounting:

✅ Payroll calculation in 1C ZUP 3.1
Step-by-step instructions for beginners:

Now we need to create 3 more indicators, according to which information will be entered on how many hours the driver spent on repairs in the current month. These will already be monthly indicators.

So, open the reference book “Payroll Indicators”. In ZUP 3.0 it is located in the “Settings” section of the main menu. Let's create a new indicator. You can come up with a name yourself or borrow my version of the name. Let's go through the rest of the settings:

• Indicator purposes– this indicator is already individual for a specific person, so we select the value "For an employee";
• Indicator type– the thing is that there is no such option as time, so you have to choose a type "Numerical", but for ourselves we understand that in fact this indicator stores the values ​​of hours worked;
• Accuracy– theoretically, using this setting, you can configure the entry of an indicator with an accuracy of up to a minute. To do this, you need to select precision 2, i.e. two decimal places. At the same time, we must not forget that 1 hour 30 minutes is not 1.3, but 1.5.
• Used – firstly we need to set the switch "Only in the month in which the value is entered (one-time use)" since our indicator is entered monthly. Secondly, since we are going to enter the total value of hours worked during the month on repairs using the “Data for salary calculation” document, we need to set the switch “Inputted at one time by a data entry document for payroll calculation.”

With exactly the same settings, you need to enter two more indicators: “Hours under repair 2” and “Hours under repair 3”.

The next step is to create a template with which the calculator will monthly enter information about hours worked during repairs. In the “Settings” section of the main menu of the program, select the item "Templates for entering initial data" and create a new element, a new template. The settings will be as follows:

• Name- For example, “Entering hours worked on repairs”;
• Salary calculation indicators are entered– choose "One-time use (only used in one month);
• Select the three indicators that we created in the last step. By the way, please note that indicators can be created not only from the corresponding directory (this is what we did), but also directly from the document “Templates for entering initial data” - the “Add indicator” button.

And the final touch. It will most likely be convenient for the calculator to enter the number of hours worked for several employees at once, so open the tab "Additionally" and check the box "The document uses several: employees". If you look closely, there are several more additional settings on the “Advanced” tab. There is no reason to consider them within the framework of this example, but if you think that they are needed for your situation, then you can, and we will consider them.

Well, now let’s indicate how many hours our employee Frolov worked on repairs in April 2015. In the “Salary” section of the main menu, select the “Data for salary calculation” item and enter a new document of the form “Entering hours worked on repairs.” Be sure to indicate the accrual month “April 2015” and indicate how many hours our employee worked on repairs for each level of complexity:

• Level 1 repair – 2 hours;
• Level 2 repair – 4 hours;
• Level 3 repair – 0 hours (i.e. we just don’t enter anything, we leave the field empty).

Creating a “Accrual Type” with an arbitrary formula and using your own indicators in 1C ZUP 3.0

✅ Seminar “Lifehacks for 1C ZUP 3.1”
Analysis of 15 life hacks for accounting in 1C ZUP 3.1:

✅ CHECKLIST for checking payroll calculations in 1C ZUP 3.1
VIDEO - monthly self-check of accounting:

✅ Payroll calculation in 1C ZUP 3.1
Step-by-step instructions for beginners:

Now we need to create an accrual type that will use the data entered through the indicators in the previous step. In the “Settings” section of the main menu, look for the “Accruals” item - this is a list of all types of program accruals. In it we create a new type of accrual. Let's call it, for example, “Payment for hours during repairs”. Now let's go through the settings of our new calculation type:

• Purpose of accrual– it is quite difficult to describe the purpose of this field in a few lines. In short, in this field you can select options predefined by the developers, which generally affect the settings, and sometimes the formula for a particular type of calculation. To understand this more fully, you can select each value in turn and see how the settings for the accrual type will change. For our example, we indicate the value “Other accruals and payments”.
• Calculation and indicators– select “The result is calculated”, i.e. we will enter the formula;
• Formula– in the formula we will use the indicators created in the previous steps. The formula will look like: RateRepair1*HoursOnRepair1 + RateRepair2*HoursOnRepair2 + RateRepair3*HoursOnRepair3 ;
• Accrual is in progress– you should select an option “Only if an indicator value is entered.” This means that accrual using this calculation method will be carried out in the current month only if the employee had repair hours in the current month, i.e. if the value of at least one of the indicators is entered: HoursOnRepair1 or HoursOnRepair2 or HoursOnRepair3. Just below you must check the boxes next to these indicators.

Now we can try to calculate the salary of employee Frolov for April 2015. Let me remind you that the document “Data for calculating wages” for April included information about hours worked during repairs: 2 hours at the level 1 rate - 120 rubles / hour and 4 hours at the rate 2 level – 130 rub/hour. We expect the following amount for repairs: 2*120 + 4*130 = 760 rubles. Open the document "Payroll" and fill it with selection by employee Frolov. We see that in addition to the main “Payment at an hourly rate”, the employee now has a line with the accrual type “Payment for hours during repairs” with the amount that we expected.

To see the values ​​of the indicators that participated in the calculation of these 760 rubles. You can click on the “Show calculation details” button.

At the same time, I would like to draw your attention to one subtle point. We did not assign the “Payment for hours during repairs” accrual to the employee as a planned one. The program itself tracked that the indicators used in this type of calculation were entered into the database for April and created the required line when calculating. This was made possible thanks to the settings “Accrual is performed: only if the indicator value is entered”, which we did in the calculation itself.

Thus, if, for example, in May an employee did not have hours for repair, then we will not enter hours for repair in the “Data for salary calculation” document and therefore, when filling out the “Payroll” document for May 2015, there will be only one line “ Pay at an hourly rate."

There was no such option in ZUP 2.5. In any case, we would have to assign this accrual to the employee as a planned accrual, and if there were no hours for repairs, there would be an empty line with the type of accrual “Payment for hours during repairs” (you can read about other differences between Zup 3.0 and Zup 2.5 in).

That's all for today! In one of the following articles I will show another very interesting solution to the same problem, namely, I will show how the mechanism for using ZUP 3.0 works several types of time in the work schedule. Follow site updates.

To be the first to know about new publications, subscribe to my blog updates:

Today we will consolidate the previously written information in practice, consider an example of payroll.

Payroll example

We have five employees at our enterprise; we need to calculate and pay their salaries, for example, for the month of May, which has 21 working days.

To calculate wages, we will need data on the salary established for each employee, personal income tax deductions due to them and the number of days worked in May. In addition, information about the total salary accrued since the beginning of the year will be useful.

Employee data: (click to expand)

Starting from the beginning of the year until the month of May, all employees worked all months in full; the regional coefficient in our salary calculation example will be taken equal to 15%. Let me remind you that data on days worked is taken from the working time sheet; a sample of this document can be found.

Let's consider the first employee Ivanov.

1) Determine the salary for the time worked

In May, he worked 20 days out of the required 21.

Salary for hours worked is determined as Salary * Days worked / 21 = 70,000 *

Ivanov received a salary = 70,000 * 20 / 21 = 66,667 rubles.

2) Determine the required deductions

Since the beginning of the year, he has been accrued a salary of 322,000 rubles, so he is no longer entitled to deductions for children. Let me remind you that children’s deductions are valid until the employee’s salary, calculated from the beginning of the calendar year, has not reached the value of 280,000 rubles.

3) We calculate wages taking into account the regional coefficient

Salary = 66667 + 66667 * 15% = 76667 rub.

4) We calculate personal income tax

Personal income tax = (Accrued salary - Deductions) * 13% = (76667 - 0) * 13% = 9967 rub.

5) We calculate the salary that we will pay to the employee:

Salary payable = Accrued salary - personal income tax = 76667 - 9967 = 66700 rub.

Calculations are carried out similarly for all other employees.

All calculations for calculating and calculating salaries for all five employees are summarized in the table below: (click to expand)

In practice, when calculating and calculating wages, a primary document is filled out - payroll form T51, a sample of which can be downloaded.

Based on the results of calculations, the total amount of the accrued salary and the salary intended for payment is calculated.

Calculation of insurance premiums

In the following articles, we will look at how vacation pay is calculated at an enterprise and provide examples of calculation.

Video lesson “The procedure for paying wages to employees of an organization”

Video lesson from the teacher of the training center “Accounting and tax accounting for dummies”, chief accountant Gandeva N.V. To watch the video click below ⇓

Question: ZUP 3.1. Salary calculation indicators

People, please help me with the ZUP 3 .1 conf. Didn't work there. There is a task from the “tyzhprogrammer” area - to do in this one the same as in that one (the confs are the same) the formula in one is payment based on salary = Salary * TimeInHours / NormHours in the other, when I press edit the formula, there is no display of the indicator “TimeInHours” Where is which checkbox do I need to set it for it to appear? (and in general there are more predefined ones displayed in one conf than in another)
- in this one it is in the “TimeInHours” indicators, in the other it is not

Like a blind kitten I poke at the candy (((
Thank you

Answer:() Thank you. didn't stand. there wasn't one there at all
() I didn’t do the initial setup, etc. sat and compared :)

Thank you

Question: Pass the indicator into the formula

#If Server Or ThickClientNormalApplication Or ExternalConnection Then
Procedure Processing Posting (Failure, Posting Mode) Posting Server. Prepare Sets of Movement Registration Records (This Object); DataForProcessing = GetDataForProcessing(); Salary Calculation.Generate Movements of Planned Accruals (ThisObject, Movements, Data for Posting); EndProcedure Function GetDataForConduct() Request = New Request; Query.Text = "SELECT | Work ScheduleAllowancesWorkAllowances.Date AS DateEvents, | ADD TO DATE (END OF PERIOD (Work Schedule Supplements Work Supplements. Date, DAY), SECOND, 1) HOW TO, | Work ScheduleAllowancesWorkAllowances.Employee.Individual AS Individual, | Work ScheduleAllowancesWorkAllowances.Employee.HeadOrganization AS HeadOrganization, | Work ScheduleAllowancesWorkAllowances.Employee AS Employee, | Work ScheduleAllowancesWorkAllowances.Link.Accrual HOW Accrual, | TRUTH HOW USED, | Work ScheduleAllowancesWorkAllowances.Link AS DocumentBase |FROM | Document.Work ScheduleAllowances.WorkAllowances AS Work ScheduleAllowancesWorkAllowances |WHERE | Work ScheduleAllowancesWorkAllowances.Link = &Link |; | //////////////////////////////////////////////////////////////////////////////// |SELECT | Work ScheduleAllowancesWorkAllowances.Date AS DateEvents, | ADD TO DATE (END OF PERIOD (Work Schedule Supplements Work Supplements. Date, DAY), SECOND, 1) HOW Operates Before, | Work ScheduleAllowancesWorkAllowances.Link.Organization AS Organization, | Work ScheduleAllowancesWorkAllowances.Employee.Individual AS Individual, | Work ScheduleAllowancesWorkAllowances.Employee AS Employee, | Work ScheduleAllowancesWorkAllowances.Link.Indicator AS Indicator, | Percentage of Surcharges.Percentage of Surcharges AS Value |FROM | Document.Work ScheduleAllowances.WorkAllowances AS Work ScheduleAllowancesWorkAllowances | LEFT CONNECTION RegisterInformation.PercentagesSurcharges AS PercentagesSurcharges | BY Work ScheduleAllowancesWorkAllowances.Degree of Allowances = Percentage of Allowances.Degree of Allowances |WHERE | Work ScheduleAllowancesWorkAllowances.Link = &Link"; Request.SetParameter("Link", Link); Request Result = Request.ExecutePackage(); DataForExecution = New Structure;   // Data set for generating planned accruals PlannedAccruals = Query Result.Unload(); DataFor Posting.Insert("DataOnPlannedAccruals",PlannedAccruals);   // Data set for generating indicators IndicatorValues ​​= RequestResult.Unload(); DataForConduct.Insert("IndicatorValues",IndicatorValues); Return DataForConduct; EndFunction; #EndIf
When posting a document, in the Values ​​of periodic salary calculation indicators (for employees) register, the employee enters the required percentage, i.e. registered. When creating a Payroll document: a bonus accrual is created, the specified day is entered, the calculation base for the required day is taken, but the indicator does not arrive there, i.e. zero.
Please tell me where to look for the error.

Answer: Thanks, I'm just learning.

Question: ZUP 3.1 Pay slip, output of the indicator + personal income tax.

Answer:() Ok, I won’t say that I have chosen the best tool, besides, ZUP 3.1 is still a bit difficult for me, especially in subtleties. Please advise what is the best way, while we are training in the transition, we can change our shoes.
1. Why does the bonus depend on the time worked? In fact, I simplified the formula somewhat; it is not essential to resolve my questions. For salaried employees, the bonus is calculated as Bonus Amount * Percentage of Completion / Standard Days * Days Worked. For hourly workers, it is calculated as Amount of bonus per hour * Percentage of completion * hours worked. This is more like part of a salary or tariff than a bonus, but according to all personnel documents it passes as a bonus.
2. Why one-time charges? The problem is that the “Percentage of Completion” indicator is calculated in some cases quite difficult; the accounting personnel simply do not have time to collect the data. Therefore, the calculation of the “premium” is timed to coincide with the advance payment, i.e. by the last days of the month following the billing month. For example, on February 25, the bonus for January results was calculated and paid. In 2.5, in the one-time accrual document, the accrual month = February, the income date for personal income tax = February, but the start and end date in the calculations = January. What document in 3.1 can calculate such a payment taking into account personal income tax?

Question: Working time accounting in the form of calculation

Good afternoon Please tell me what could be the matter. Created a calculation type “hazard premium”. Formula - hours worked * tariff * percentage. When calculating, I noticed that for some reason he was also given a bonus for the hours he was on vacation (1 day, 7.2 hours). I checked the “working time accounting classifier” in the reference book - everything is fine there, opposite the vacation there is no checkbox “working time” by itself. What can be wrong? Configuration - Payroll and Personnel Management, edition 2.5 (2.5.103.2)

--- Message merging, June 21, 2016 ---

And an additional follow-up question: does anyone know what the difference is between the indicators “time worked in hours” and “time in hours”? Yesterday I also set up a type of calculation, an allowance, which worked only on standard hours and should not have taken into account overtime and work on holidays/weekends - it didn’t work with the first indicator, it captured hours of overtime and weekends, but with the second - everything was fine.

Answer:

Can't anyone tell me? How are calculation types configured for bonuses that take into account attendance, overtime, and holidays?

Question: ZUP 2.5 incorrectly takes into account the time worked in the form of calculation.

Answer:() How many times have we discussed that such a brilliant idea will not take off in ZUP 2.5.
To use indicators of standard time and time worked, accrual must be described in the Basics. In 2.5, you cannot assign more than one main accrual to an employee. As soon as you assign such a bonus, payment based on salary will no longer be considered automatically.
Conclusion: let the paymasters stop with the drug-addicted bonus schemes

Question: Budgeting. Derived indicators. Sum of products

At the moment, I have resolved the issue by directly registering all the works, but I don’t like the fact that when adding a new position, it will be necessary to rewrite the formula.

In Excel, it is possible to use the SUMPRODUCT function for this. How can you achieve a similar result when setting up a budget type?

Answer: 1. Making detailed budget items is not the best solution. Why, I wrote here:
2. If instead of the articles Manager and General Director there is an article with the “position” analytics, then putting together the required structure is quite simple - add another calculated column with the product and simply sum it up.
3. The ERP contains the document “Process of Budget Preparation”. Using this document and setting up the budget process, you can transfer intermediate calculations to a background job.

Question: Payroll, types of calculation with values

The report was made using SCD and additional. layout that is filled in programmatically
Confa ZiK 8, release 1.0

Answer: Ahaaaaand that’s it, that’s why all the rest are zeros, and then another number in the same indicator, for the same employee, thank you very much for your answer, now it’s more clear

Question: ERP Budgeting. Budget indicator - get DS balances

I set everything up as in the articles, as in the video courses, it works for them, but not for me.

In a nutshell - Created the budget indicator "Cash", indicated the rules for obtaining actual data - Operational accounting - Cash (cash) and Operational accounting - Cash (non-cash). Set up connections between the indicator and budgeting items. I entered the bank and cash balances at the beginning of the year. Budgeting model - there are no checkboxes for the organization and department.

I add an indicator in the form of a budget (without the “used for input” checkbox - budget report), click “View report type” - the indicator is empty. When actual movements on the VA appear in the middle of the year, the indicator acquires values ​​- the influence of items on the indicator works (not correctly - the expense is indicated, but the items are added).

1. How to get the balance of DS in the budget report (In the form of a budget indicator, if you go to the “Rules for obtaining actual data” tab and click “Result of the rules” - everything is shown correctly - all balances, by dates of entering balances, all balances after write-offs and etc.). I do not have an indicator in the budget type used to enter data.

2. If in the budget indicator in the rules for obtaining actual data you indicate only “Cash (cash)” - although it works correctly in the “Result of the rules”, when generating the budget report it gives the error “Field not found at the BEGINNING OF PERIOD” - just like that, in caps .

3. The influence of items on the indicator - even if it is “Expense” - in the budget report - adds

Answer:() in the ERP, budget indicators can be conditionally called balance sheet items. But budget indicators also allow you to analyze income/expenses by item. Therefore, depending on the task, they can be used anyway. But, of course, when planning net turnover, budget items are sufficient.

Question: How can I make a metric in a report unselectable?

Answer: it worked) here, maybe it will be useful to someone:
I just commented out the line where the indicator is added, i.e.
UniversalReport.AddIndicator("Gross ProfitPrices", "Gross Profit", False, "NPV=15; NPV=2");
and where the FieldRepresentation structure is for the same indicator (not necessary, but why transfer unnecessary things to the settings)
In general, this was the first attempt from the very beginning, and it worked successfully on the database from another client, but on the client database the report did not open and displayed something like this error: "(Report.UniversalReport.ObjectModule(5040)): Error when calling the context method (Shift) Receiver.Rows.Shift(FoundIndicator, Source.Rows.Index(CurrentIndicator) - Receiver.Rows.Index(FoundIndicator)); for the reason: Incorrect offset within the collection"

Yes, it was necessary to understand the essence of the error, but the task seemed so simple, and the builder was an unloved and unexplored mechanism) Intuitively I renamed the report (not the file name, but the report name, in the same place as the synonym), saved it, it worked). At the first launch, I configured groupings for the user, additional. fields, etc., and for this setting to remain, click “Save settings”, indicating the user name and both checkboxes (save, open). I wrote in detail, because... I often forget about this button myself)
Thank you everyone, have a nice day)

Question: ZUP When you select Displayed indicators, the indicator values ​​are cleared

Answer: Has anyone encountered this? How to fight? Just remove the flag from “Displayed indicators” that are overwritten?

There are several good articles on using calculation types with arbitrary formulas in ZUP 2.5. In ZUP 3.0 this scheme has undergone some changes. This will be discussed in the publication.

This article will talk about how to set this up in ZUP 3.0. Tested on version 3.0.19.71.

The organization uses several types of bonuses for employees of different departments. Some departments use one type of bonus, while others use another. There are employees who are awarded certain bonuses on an individual basis. Each of the bonuses has two indicators - the bonus percentage and the production coefficient. Indicator values ​​change periodically.

To implement such a scheme in ZUP 3.0, you need to do the following:

1. We hire an employee and assign him a salary.

2. Go to “Settings” - “Payroll calculation indicators” and create indicators there for calculating our bonuses.

3. Go to “Settings” - “Accruals” and create new types of calculation. Select “Calculate using formula” and include the necessary indicators in the formula.

Setting up the calculation base.

4. Now you need to make sure that these accruals are calculated automatically every month. To do this, we will use the document “Change of planned accruals” (“Salary” - “Change of employee pay”).

The document contains selection, auto-completion by department and the ability to add accrual to everyone at once, which is what is required in our case. In addition, here you can immediately set the values ​​of indicators, but only used constantly by employee.

To enter one-time indicators for employees And permanent by department and organization 1C suggests using another document - “Data for salary calculation” (“Salary” - “Data for salary calculation”). To use a document to enter your own indicators, you must first configure the appropriate templates ("Settings" - "Templates for entering initial data").

You can also specify the values ​​of indicators directly in the document

5. Well, in fact, the result is that our bonus was automatically included in “Payroll” and calculated. By clicking the "Show calculation details" button, you can admire the indicators used in the calculation.