Experience conversion program. Calculation of insurance period according to work book

The calculation of length of service differs in different situations. Check whether you are correctly determining the number of years an employee has worked.

From this article you will learn

What is meant by work experience?

In personnel practice, several terms are used that relate to the concept. Therefore, the calculation of years worked is carried out differently.

In some cases, special types are taken into account length of service, which include activities in special conditions, including harmful and dangerous ones. Activities of a specialist associated with risks to life and health give the right to early retirement, increased leave, etc.

Calculator for calculating length of service

Example of information about experience

Practical situation

Natalya Ulanova answers,
lawyer, expert of the magazine “Personnel Affairs”.

To ensure that the Social Insurance Fund offsets the organization’s expenses for sick leave, and the employee does not receive less than the required vacation, correctly calculate the length of service. We have prepared cheat sheets that will help you figure out which periods are included in it and which are not. If in doubt, look into the material, and there will be fewer errors in calculations...

Ask your question to the experts

Calculation of work experience using a work book

You can calculate the length of service. You can do this yourself or an accountant can do the job. To manually determine the duration of the period, you will need a copy of the work book and insert, a calculator, a sheet of paper, and a pen.

Note! Future social payments depend on how correct it is. If you find errors in it, make the correct entries or send the employee to the organization that entered the information incorrectly into the document. In some cases, length of service is confirmed by certificates from employers, employment agreements, extracts from HR department records, testimony, and archival papers.

To do it manually, write down the periods of work on a separate sheet of paper. chronological order. Subtract the date of hiring from the date of dismissal at the enterprise. Write out the data separately. Do not try to add up periods of work in all organizations at once - this will lead to errors. What periods to consider?

The date of hiring was 03/15/2010, and the date of dismissal was 06/16/2014. Work experience - 4 years 3 months 1 day. For clarity, make the following entry: 06/16/2014 - 03/15/2010. Write down all the periods of work in different organizations, and then add up the numbers. Convert the data into standard units - years, months, days. Proceed in the same way work book, if you determine the duration of work in your specialty. But in this case, take into account the time periods when the employee worked in the professional field.

In this case, take July 1 of the year as the date. If the date of the month is not reflected, take the 15th of the corresponding month as the date. This is stated in the Rules approved. Determine the insurance period in calendar order. To understand the rules, consider this situation. The employee got a job at employment contract…

Two ways to calculate length of service with examples

If the calculation results in a negative number of months or days, proceed as follows. When only the number of months turns out to be negative, reduce the resulting value by one, and add 12 to the number of months. Then reduce 12 by the negative number of months.

When the number of days turns out to be negative, reduce the resulting number of months by one. Add 30 to days, reduce them by a negative amount. Keep in mind that when counting, a day is lost in each period. Therefore, add to the resulting number exactly as many days as there were periods of hiring and dismissal. It is this procedure that is established by the Instructions approved.

How to calculate experience online?

To simplify your work, you can calculate your experience online. This way you will avoid mistakes, because the program rarely crashes. It is designed in such a way that every 30 days are automatically converted into a month, and 12 months into a calendar year. But this does not mean that you do not need to check the entered data. After entering them, check the information again with what is available.

• Enter the dates of hiring and dismissal in the columns in the format day, month, year. Enter data manually or use a special calendar.
• If there are other periods that count toward your work experience, add them to the program.
• Click the "calculate" button. Look at how long the employee worked.
• If errors are found, re-enter the information.

Calculate seniority Even novice HR specialists and accountants can use the program. Therefore, they began to be used much more often. Manually determining the duration of work, if a lot of records have been made, takes time.

Correctly calculate your length of service to avoid questions from inspection authorities when submitting reports. Do not entrust the work to inexperienced specialists who may make serious mistakes. When using online services, check that they count correctly. To do this, enter any number of values ​​and perform manual data control.

Excel allows you not only to perform operations with numbers, but also to calculate intervals between dates and time periods. This makes it very convenient to calculate work experience. Therefore, if an accountant masters this simple procedure, then in the future it will be very easy for him to carry out calculations.

Automated table for calculating employee length of service

The future table in which seniority calculations will be made must have a certain heading. It should indicate the columns in which intermediate and final calculations will be carried out. The hat looks like this.

The columns of YEARS, MONTHS and DAYS are highlighted in color, because it is in them that the final results that the accountant will need will be calculated.

Let's create several positions by filling out part of the table. With your full name, everything is clear, but when filling out the ACCEPTED and FIRED columns, you will need to change the format of the cells. In new versions of Excel, they change automatically if you enter the date in the standard way: HH.MM.YYYY. Just in case, it is better to change the format in advance. To do this, select all the cells in the “Accepted” and “Dismissed” columns (except for the table header), right-click to open the context menu and select CELL FORMAT (CTRL+1) – DATE.

At the same time, we see that the date format can also be selected. Some people like it in numerical equivalent, others prefer that the month be written in words, etc. We will choose a partially verbal format.

Enter the start date of employees and their dismissal. Let them all get a job at different days and years, but quit in one.

Formula in Excel for calculating RAZNDAT length of service

Let's calculate the number of days that employees worked. Because length of service is taken into account regardless of breaks (weekends, sick leave and holidays), you just need to subtract the start date from the end date. Excel allows you to do this. Write the formula =C2-B2 in cell D2.

It turned out to be 6580 days. Let's convert them into years; it is not enough to simply divide by 365, because there can be 366 days in a year. Also, when we convert to the number of full months without taking into account years, we should take into account the fact that one month can have 30 and 31 days. Therefore, for accurate analysis you should use a special function RAZNDAT:

• for cell E2(Years): =DATEDAT(B2,C2,"y");
• for cell F2(Months): =DATEDAT(B2,C2,"ym");
• for cell G2(Days): =DATEDAT(B2,C2,"md");

Attention! This function is not contained in the function wizard, so it must be entered manually.

Table of parameters of the RAZNDAT function:

Note! How can you elegantly calculate the total length of service by summing up all periods of work at different jobs?

You need to start the process with preparing documents. These include:

• employment history;
• labor contract;
• collective agreement.

Take the dates when you started working at a particular place, as well as the end dates labor activity, enter it into calculation programs and get the result online.

Currently, this is a truly convenient and accessible resource for everyone.

Its undoubted advantages are:

• simplicity;
• lack of special knowledge;
• counting speed;
• automatic operating mode.

All the user needs to do is enter the data known to him in special fields, and then click on the “Calculate” button. Next, the calculator will do everything itself and provide the finished result.

You can use any calculator by entering “ Online calculator experience." Information about it can be found on the first pages of search engine results. You can also use the sites listed above.

Citizens Russian Federation calculate their work experience according to Federal Law“On labor pensions in the Russian Federation” No. 173, which entered into force on January 1, 2002.

Currently, the law does not contain the concept of “work experience”; since December 31, 2001, it has been replaced by the clarified term “insurance period”, that is, the period during which a working citizen carried out his or her wages contributions to the Pension Fund of the Russian Federation, and other legally justified periods added to them.

However, the phrase “seniority” is often used synonymously.

The insurance period is the duration of periods of work and other activities during which payments were made. insurance premiums to the Pension Fund of the Russian Federation.

In addition to periods of work, the insurance period includes the following periods:

• period military service;
• caring for a child up to 1.5 years (if there are several periods, then the maximum period is 4.5 years);
• period of temporary incapacity with registration sick leave(see → example of calculating sick leave);
• registration period at employment agencies when receiving unemployment benefits;
• care for disabled people, elderly people over 80 years of age (guardianship);
• period of illegal detention in places of deprivation of liberty.

An important feature of calculating the insurance period is engaging in the type of activity that pays insurance premiums to the Pension Fund. It doesn't have to be an organization, so individual entrepreneur independently transfers funds to the Pension Fund.

Study time in educational institutions, postgraduate studies, courses are not included in the insurance experience, because Insurance premiums are not paid to the Pension Fund. The figure shows an example of calculating seniority.

The main parameters of the calculation are the date of acceptance and dismissal from employment.

This is a small program that performs only one function - calculating work experience. It produces results based only on the date of admission and dismissal. With its help, you can also find out the total length of service by summing up all periods.

Download OK | Seniority

Compared to the previous option, Calculating Work Experience provides much more options for the user. In addition to calculating the working period, this program creates some kind of report in the results.

In addition, the user can easily edit the field with the results of her work and give it the right type. This report can then be copied into any text editor for further processing.

READ ALSO: MILITARY INSURANCE COMPANY BRANCH - Kemerovo

Another feature is that with the help of this application you can make calculations of the working period, indicating one year of work for several years of experience. Unfortunately, to obtain the total length of work using Calculating Work Experience, you will have to arm yourself with a calculator, since the program itself does not indicate this data.

Download Calculation of work experience

If your work book contains not one entry, but several dozen, then it will be difficult to manually calculate the total length of service. Accounting programs usually have a module for calculating length of service, but not everyone has a familiar accountant to whom they can turn with such a request.

There are also various online calculators for calculating insurance coverage. But it would be more convenient for me to have such a calculator on my computer.

Writing such an experience calculator is quite simple. A program for calculating length of service can even be made in MsWord.

It would be easier for me to use MSAccess to write a program, but not everyone has it. I also did not consider the final format of the exe file, since many are afraid to download and run unknown files on their computer.

Therefore, taking into account all these restrictions, I chose Excel for the program for calculating experience.

I suggest you download a simple program for calculating experience for free. The proposed program is a file in Excel format - calculator.xls

The file is located on Yandex disk, which prevents the receipt of any viruses.

Download the calculator.xls file for free here.

The program for calculating work experience is free, you can use it without any restrictions. It is forbidden to change free program and sell it.

To calculate your work experience, open the calculator.xls file and enter all periods of work according to your work book in the cells with a yellow background, as seen in the screenshot below.

Enter dates in the format DD.MM.YYYY (after entering they are displayed as DD.MM.YY).

There is no date control, that is, you must ensure that the entries are correct. The order of the periods does not matter. If you missed any period from the work book when entering, there is no need to insert it in the middle. This period can be inserted at the end of the list.

When calculating, every 30 days are considered as a month, and 12 months as a year. It is also taken into account that the day of dismissal is included in the insurance period.

In cells on a green background, as you enter, data on length of service for each period will appear, and on a light turquoise background under the inscription “total years months days” - total length of service.

Make sure in advance that you have enough retirement experience according to the new pension rules. After all, you can earn work experience for a pension without working. Read the instructions on how to get work experience for a pension without working.

READ ALSO: Contributions to the Pension Fund in 2018 for lawyers

The procedure for manually calculating length of service from a work book:

• write down all periods of work according to the work book,
• count the number of days, months and years for each individual period of service,
• calculate the total length of service by summing the length of service for all periods.

Example of calculating length of service

Let's look at calculating work experience using an example.

Let’s take the following period of work according to the work book: hired on 08/04/1984, fired on 08/02/1996.

You need to start calculating your experience with days. From the day of dismissal, we subtract the day of hiring and add one, since the day of dismissal is also considered a working day, that is, 2 - 4 1 = -1.

But since the result less than zero, you need to borrow a unit of months, and this unit of months is equal to 30 days.

We get 30 2 - 4 1 = 29 days

Now let's count the months, remembering that we took one when counting the days, that is, from the months we need to subtract 1: 8 - 8 - 1 = -1.

Since the result is again less than zero, you need to take one from the number of years, that is, take 12 months.

As a result, we get 12 8 - 8 -1 = 11 months

Now we count the years, remembering that we took one when counting the months1995 - 1984 -1 = 11 years

As a result of the calculations, it turned out that the length of service for the period was 11 years 11 months 29 days.

If, when calculating days, it would turn out to be 30 or 31, in this case it would be necessary to convert this number of days into full months, that is, subtract 30 days and add one to the number of months.

The total length of service is determined according to the same rules by adding days, then months and years of experience for all periods.

For example, let’s take 2 periods: accepted - 08/04/1984, dismissed - 08/02/1996 (experience for a period of 11 years 11 months 29 days) hired - 09/15/1997, dismissed - 10/25/2001 (experience for a period of 4 years 1 month 11 days).

First we sum up the days: 29 11 = 40.

Since a full month is considered to be 30 days, subtract 30 from the resulting amount: 40 - 30 = 10 days.

Keep in mind that you will need to add 1 to the number of months.

Let's sum up the months11 1 1 = 13.

The months turned out to be more than 12. Since a full year is considered 12 months, subtract 12 from the number of months and add one to the number of years.

So, the months will be 13 - 12 = 1 month

Let's sum up the years: 11 4 1 = 16 years.

In total, the total work experience was 16 years 1 month 10 days.

As you can see, manually calculating the total length of service is quite labor-intensive, and it is easy to make mistakes.

CALCULATION OF EXPERIENCE

To calculate work experience, you can use different ways.

Each of them is convenient and has its own characteristics. Among them:

Calculation of periods of work (service, activity) is carried out in calendar order based on full months (30 days) and a full year (12 months). In this case, every 30 days of these periods are converted into full months, and every 12 months of these periods are converted into full years(clause 2, section III of the Rules for calculating and confirming the insurance period).

If the periods of work (service, activity) included in the insurance period coincide in time, one of such periods is taken into account at the choice of the insured person, confirmed by an application indicating the period selected for inclusion in the insurance period (clause 22 of the Rules for calculating the insurance period) .

There are a number of programs for calculating length of service that can greatly simplify this process. They provide the user with the opportunity to quickly find out the duration of the working period, significantly saving time. It is this kind of software that will be discussed in this article.

This is a small program that performs only one function - calculating work experience. It produces results based only on the date of admission and dismissal. With its help, you can also find out the total length of service by summing up all periods.

Calculation of work experience

Compared to the previous option, Calculating Work Experience provides much more options for the user. In addition to calculating the working period, this program creates some kind of report in the results. In addition, the user can easily edit the field with the results of its work and give it the desired appearance. This report can then be copied into any text editor for further processing.

Another feature is that with the help of this application you can make calculations of the working period, indicating one year of work for several years of experience. Unfortunately, to obtain the total length of work using Calculating Work Experience, you will have to arm yourself with a calculator, since the program itself does not indicate this data.

Calculation of experience

Calculation of length of service is the most multifunctional program of all those we reviewed in the article. In addition to the main function of calculating the work period, it can also save entered data into a separate file, providing the ability to reuse it. Important positive quality is the function of printing the created document on a printer. Another nice bonus is that the application provides information about the total and longest continuous working period.

This article reviewed the best software tools that can easily calculate work experience. Some of them provide the user with a number of additional features, such as printing, importing and exporting, calculating a year in two, etc. All the programs described are distributed absolutely free of charge and translated into Russian.