Home Tooth pain Program to calculate work experience. Calculation of insurance period according to work book

Tooth pain

Program to calculate work experience. Calculation of insurance period according to work book

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 about this kind of software and we'll talk 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 version, Counting length of service 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 to any text editor for subsequent 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— 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.

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 experience calculator” in the search bar. 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 the 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 made contributions from his salary to the Pension Fund of the Russian Federation, and added other periods are legally justified for 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 of 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.

Important feature calculation 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 dates of acceptance and dismissal from employment.

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 its work and give it the desired appearance. This report can then be copied into any text editor for further processing.

READ ALSO: MILITARY INSURANCE COMPANY BRANCH - Kemerovo

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 to calculate the insurance period. 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, which means you must ensure that the entries are correct. 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 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 next period 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 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 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) .

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

Free program for calculating work experience

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.

Recently I had to count the insurance period for my pension. When the idea of automating the process of calculating total length of service 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 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 for free calculator.xls file.

The program for calculating work experience is free, you can use it without any restrictions. It is prohibited to modify the 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, which means you must ensure that the entries are correct. 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 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.

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.

Calculate total length of service manually

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 08/04/1984,
dismissed 08/02/1996.

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 one when counting 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 one 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.

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
hired - 08/04/1984, dismissed - 08/02/1996 (service for a period of 11 years 11 months 29 days)
accepted - 09.15.1997, dismissed - 10.25.2001 (service 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 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 months
11 + 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, it will be months
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.

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?

Maksimova I.V.

You can watch a detailed analysis of all the subtleties and nuances of determining the insurance period for calculating temporary disability benefits in the video recording of the seminar Dmitrishchuk S.A."Insurance experience" . Before viewing the seminar, we recommend that you printpresentation AndHandout .

Today, the assignment and payment of temporary disability benefits to insured persons is 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 maternity” (hereinafter referred to as Law No. 255-FZ);

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

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

To determine the amount of sick leave, you first need to calculate employee's insurance period.

Amount of temporary disability benefits depends on the employee’s insurance coverage. When calculating the insurance period, breaks in work do not matter. Periods of labor and other activities are summed up. 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 21 of the Rules). In order to facilitate the procedure for calculating the insurance length of employees, a program for calculating the length of service was developed, which is used to calculate the accrual of benefits for temporary disability.

The second step in calculating temporary disability benefits 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 after-care in health resort institutions immediately after inpatient treatment is paid in the following amount:

If you have 8 or more years of insurance experience - 100 percent of average earnings;

If you have an insurance period of 5 to 8 years - 80 percent of average earnings;

If you have an insurance period of 6 months to 5 years - 60 percent of average earnings.

If the employee’s insurance period is less than six months, the amount of temporary disability benefits cannot exceed a full calendar month minimum wage, and in regions and localities in which regional coefficients are applied to wages, the benefit is paid in an amount not exceeding the minimum wage, taking into account these coefficients (Clause 6, Article 7 of Law No. 255-FZ).

The personnel officer indicates the duration of the insurance period on the certificate of incapacity for work. When calculating and confirming the insurance period, you must be guided by the Rules.

NOTE!!!

1.According to Art. 11 of Law N 255-FZ, maternity benefits are paid to a woman in the amount of 100 percent of average earnings if she has an insurance period of at least 6 months

2. Since 2011, temporary disability benefits are paid at the expense of the organization for the first three days of temporary disability, and for the remaining period, starting from fourth day temporary disability, at the expense of the Social Insurance Fund of the Russian Federation (clause 1, part 2, article 3 of Law No. 255-FZ)

3. In accordance with Part 3.1 of Art. 14 of Law N 255-FZ, temporary disability benefits, maternity benefits and monthly child care benefits are calculated based on average earnings. In this case, the average earnings are taken into account for each calendar year in an amount not exceeding the established maximum value of the base for calculating insurance contributions to the Fund social insurance RF. This is provided Federal law"On insurance premiums in Pension Fund Russian Federation, Social Insurance Fund of the Russian Federation, Federal Mandatory Fund health insurance and territorial compulsory health insurance funds.”

Online work experience calculator

The program “On-line Work Experience Calculator” is designed to make it easier to calculate 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 02/06/2007 No. 91 “On approval of the rules for calculating and confirming insurance experience to determine the amount of benefits for temporary disability, pregnancy and childbirth” were taken into account. The calculation is made in calendar order, taking into account that every 30 days are converted into full months, and every 12 months - into full years.

The dates of hiring and dismissal from work are entered into the table based on the work book or other documents confirming the length of service. Data must be entered 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 period.

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