Seniority program. Experience calculator. Calculation of work experience according to the work book

The calculation of work experience is different in different situations. Check if you correctly determine the number of years worked by an employee.

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 in different ways.

In some cases, special types of work experience are taken into account, which include activities in special conditions, including harmful and dangerous ones. The activity of a specialist associated with a risk to life and health gives the right to early retirement, extended leave,.

Seniority Calculator

Experience information example

Practical situation

Answered by Natalia Ulanova,
lawyer, expert of the magazine "Kadrovoe delo".

In order for the FSS to offset the expenses of the organization for paying sick leave, and for the employee not to receive less than the required leave, correctly calculate the length of service. We have prepared cheat sheets with which you will find out which periods are included in it and which are not. If in doubt, look at the material, and there will be fewer errors in the calculations ...

Ask your question to the experts

Calculation of work experience according to the work book

Experience can be calculated. You can do this yourself or an accountant can do the work. 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 correctly they are. If you find errors in it, make the correct entries or direct the employee to the organization that incorrectly entered the information in the document. In some cases, the length of service is confirmed by certificates from employers, labor agreements, extracts from the records of the personnel department, testimonies, archival papers.

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

The date of employment is March 15, 2010, and the date of dismissal is June 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 to standard units of calculation - years, months, days. Similarly, follow the 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 day of the month is not reflected, take the 15th day of the corresponding month as the date. This is stated in the Rules approved. The insurance period is determined in calendar order. To understand the rules, consider the following situation. The employee is employed under an employment contract...

Two ways to calculate seniority with examples

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

When the number of days turned out to be negative, reduce the number of months obtained by one. Add 30 to days, decrease them by a negative number. Keep in mind that when calculating in each period, a day is lost. Therefore, add to the resulting number exactly as many days as there were periods of admission and dismissal. It is this order that is established by the Instruction approved.

How to calculate seniority online?

To simplify the work, you can calculate the length of service online. So 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 their introduction, check the information again with what is available.

• In the columns, enter the dates of hiring, dismissal in the format day, month, year. Enter data manually or use a special calendar.
• If there are other periods that are counted as seniority, include them in the program.
• Click the "calculate" button. See how long the employee worked.
• If errors are found, re-enter the information.

Calculate seniority even novice personnel officers and accountants can use the program. Therefore, they began to be used much more often. Manual determination of the duration of work, if there are many entries, takes time.

Correctly calculate the length of service in order to avoid questions from the inspection authorities when submitting reports. Do not entrust work to inexperienced specialists who can make serious mistakes. Using online services, check if they count correctly. To do this, enter any few values, perform manual data control.

The time has come to calculate the length of service according to the work book. It's not as difficult as it might seem. There are several ways to calculate the total work experience: using the accounting program module, manually, using an online calculator, and using a free program for calculating work experience.

Free program for calculating seniority

If your work book has more than one entry, but several dozen, then it will be difficult to calculate the total work experience manually. Accounting programs usually have a seniority calculation module, but not everyone has a familiar accountant who can be approached with such a request.

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

Recently, I had to count the insurance experience for a pension. When the idea of ​​automating the process of calculating the total experience came to my mind, I began to think about how to write a program. Writing such an experience calculator is quite simple. A program for calculating seniority can even be made in MsWord. To write a program, it would be easier for me to use MSAccess, 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 limitations, I chose Excel for the seniority calculation program.

I suggest you download a simple program for calculating seniority for free. The proposed program is an Excel file - calculator.xls

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

Download for free calculator.xls file.

The program for calculating seniority is free, you can use it without any restrictions. It is forbidden to modify the free program and sell it.

To calculate the length of service, open the calculator.xls file and enter all periods of work on the work book in the cells with a yellow background, as seen in the screenshot below.

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

Dates are not controlled, that is, you yourself must monitor the correctness of the input. The order of the periods does not matter. If, when entering, you missed any period from the work book, 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 is 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 length of service.

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

Make sure in advance that you have enough pension experience under the new pension rules. After all you can earn seniority for retirement without working . Read the instruction.

Calculate the total work experience manually

The procedure for calculating the length of service according to the work book manually:

• write out all periods of work according to the work book,
• calculate 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.

An example of calculating seniority

Consider the calculation of seniority on an example.

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

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

But since the result is less than zero, you need to take 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 the unit when counting the days, that is, we need to subtract 1 from the months:
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 the unit when counting the months
1995 - 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 the days it would turn out 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 experience is determined according to the same rules by adding days, then months and years of experience for all periods.

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

Let's sum up the days first:
29 + 11 = 40.

Since a full month is considered 30 days, subtract 30 from the amount received
40 - 30 = 10 days.

Let's take into account that it will be necessary to add 1 to the number of months.

Sum up the months
11 + 1 + 1 = 13.

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

So, months will turn out
13 - 12 = 1 month

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

In total, the total length of service was 16 years 1 month 10 days.

As you can see, calculating the total length of service manually is quite time consuming, and it is easy to make a mistake.

Operating system: Windows 2000/XP
Size of the program (distribution kit): 226 Kb
License type: Freeware

Program website: seniority.narod.ru
Discuss the program: Seniority calculation on our software forum
Go to program download:

The program "Calculation of experience" was created to help a personnel officer or accountant to calculate the total length of service of employees based on records from work books.
The provision from the RULES for calculating the insurance period was taken into account, according to which every 30 days are converted into months, and every 12 months - into full years.
In this case, the user has the opportunity to determine the non-insurance experience by unchecking the corresponding checkbox.
Dates can be entered using either the keyboard or the mouse.
The transition between the input fields is carried out with the Tab keys (Shift-Tab - in the opposite direction) or Enter.
Has a date calculator.
Without installation.

When adding the program to the catalog of our site, the link to the Calculation of service was checked by antivirus, but since the file is located on the server of the developer or publisher of the software, it can be changed, we recommend that you check the files in the On mode before downloading the software to your computer -Line antivirus - will open in a new window and be scanned!

You can leave your opinion about the program Seniority calculation or comments, as well as report a broken download link.
If you have a question about working with the Seniority Calculator, you can ask it here, as many program authors and publishers track messages on this site!
All advertising messages off topic, as well as links and phone numbers will be deleted!

Purpose of the program for calculating the length of service

The program is designed to calculate the total length of service according to entries in the work book for filling out clause 8 of Form No. T-2 “Employee's Personal Card”, as well as the length of service for calculating benefits for disability certificates.

The program consists of two files: "Experience calculation.exe" and "data.xls". The "data.xls" file is used as a database that stores the names of employees, data on periods of work and dates of employment.

Employee names, seniority periods, and hiring dates are added in a clickable form "New". After saving the results, the new worker becomes available for selection in the drop-down list "Worker".

The length of service is calculated automatically when you select an employee in the drop-down list.

To get the length of service for calculating benefits, you must enter the starting date of the period of incapacity for work and click the button "Recalculate the length of service at the date of commencement of disability". To calculate the length of service for sick leave, the date of employment must also be filled out.

If you need to correct the name of the employee, periods of work, or you forgot to enter the date of employment, then select the employee in the list and click the button "Edit".

To remove the selected employee from the list, click the button "Delete".

Download the program "Calculation of experience" for free:

For Windows XP - Windows 7 (Windows 8 - Windows 10 will also work, but you will need to download Microsoft .NET Framework 3.5 SP1 if it is not installed).

For Windows 8 - Windows 10 (also suitable for Windows 7 if Microsoft .NET Framework 4.5 is installed).

I write programs for myself, I am not a trusted publisher, so browsers and some antiviruses may warn of danger before downloading. Programs are packaged in regular .zip archives (not self-extracting), if in doubt, check the downloaded archive before unpacking it with an antivirus. I use Kaspersky Internet Security, which confirms that there are no threats.

Seniority calculation algorithm

1. From each period, whole years are first distinguished, then whole months and separately days.
2. The years of all periods are added separately, the months of all periods separately and the days of all periods separately.
3. Every 30 days are converted to a month and added to months, every 12 months are converted to a year and added to years, the remaining days (less than 30) remain days.

Maksimova I.V.

You can watch a detailed analysis of all the subtleties and nuances of determining the length of service for calculating temporary disability benefits in the video recording of the seminar Dmitrishchuk S.A."Insurance Experience" . Before viewing the seminar, we recommend printingpresentation andHandout .

To date, the appointment and payment of temporary disability benefits to insured persons are regulated by the following regulations:

Federal Law No. 255-FZ of December 29, 2006 "On Compulsory Social Insurance in Case of Temporary Disability and in Connection with Motherhood" (hereinafter - Law No. 255-FZ);

Regulations on the peculiarities of the procedure for calculating benefits for temporary disability, for pregnancy and childbirth for citizens subject to compulsory social insurance, approved. Decree of the Government of the Russian Federation of June 15, 2007 N 375;

• The rules for calculating and confirming the insurance period for determining the amount of benefits for temporary disability, for pregnancy and childbirth, approved by Order of the Ministry of Health and Social Development of Russia dated February 6, 2007 N 91 (hereinafter referred to as the Rules).

To determine the size of the sick leave, it is first necessary to calculate worker's insurance record.

The amount of benefits for temporary disability depends on the insurance experience of the employee. When calculating the insurance period, breaks in work do not matter. The periods of labor and other activities are summarized. 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). At the same time, every 30 days of these periods are converted into full months, and every 12 months of these periods are converted into full years (paragraph 21 of the Rules). In order to facilitate the procedure for calculating the insurance period of employees, a program for calculating the period of service was developed, which is used to calculate the calculation of benefits for temporary disability.

The second step in calculating the temporary disability benefit is to determine the amount of the benefit itself.

According to paragraph 1 of Art. 7 of Law N 255-FZ, temporary disability benefits due to illness or injury, during quarantine, prosthetics for medical reasons and aftercare in sanatorium-resort institutions immediately after inpatient treatment are paid in the following amount:

In the presence of insurance experience of 8 years or more - 100 percent of average earnings;

In the presence of insurance experience from 5 to 8 years - 80 percent of average earnings;

In the presence of insurance experience from 6 months to 5 years - 60 percent of average earnings.

If the insurance period of the employee is less than six months, the amount of the temporary disability benefit cannot exceed the minimum wage for a full calendar month, and in areas and localities where regional wage coefficients are applied, the benefit is paid in an amount not exceeding the minimum wage. remuneration, taking into account these coefficients (clause 6, article 7 of Law N 255-FZ).

The personnel officer indicates the duration of the insurance period on the disability certificate. When calculating and confirming the insurance period, it is necessary to be guided by the Rules.

NOTE!!!

1.According to Art. 11 of Law N 255-FZ, a pregnancy and childbirth benefit is paid to a woman in the amount of 100 percent of average earnings with an insurance period of at least 6 months

2. Since 2011, temporary disability benefits have been paid at the expense of the organization for the first three days of temporary disability, and for the rest of the period, starting from the fourth day of temporary disability, at the expense of the FSS of the Russian Federation (clause 1, part 2, article 3 of the Law N 255-FZ)

3. In accordance with Part 3.1 of Art. 14 of Law N 255-FZ, benefits for temporary disability, for pregnancy and childbirth, and a monthly allowance for child care are calculated based on average earnings. At the same time, average earnings are taken into account for each calendar year in an amount not exceeding the established maximum base for calculating insurance premiums to the Social Insurance Fund of the Russian Federation. This is provided for by the Federal Law "On Insurance Contributions to the Pension Fund of the Russian Federation, the Social Insurance Fund of the Russian Federation, the Federal Compulsory Medical Insurance Fund and Territorial Compulsory Medical Insurance Funds."

Online work experience calculator

The program "On-line work experience calculation calculator" is designed to facilitate the calculation of insurance (and other work experience). When creating it, the requirements of the ORDER of the Ministry of Health and Social Development of the Russian Federation dated February 6, 2007 No. 91 “On approval of the rules for calculating and confirming the insurance period for determining the amount of benefits for temporary disability, pregnancy and childbirth” were taken into account. The calculation is made in calendar order, it is taken into account that every 30 days are converted into full months, and every 12 months into full years.

The table includes the dates of hiring and dismissal from it on the basis of a work book or other documents confirming the length of service. Data entry must be carried out in the format: DD.MM.YYYY, or use the built-in calendar.

After entering all the data, you must click the "Calculate" button and get the total insurance experience.

We hope that this program will be able to facilitate such a time-consuming and routine operation as calculating the length of service, and free up time for more important tasks.