Highly rated Many readers found this article helpful.

Overview

By default every employee gets the same number of days for a type: the AnnualAllowance of the absence type, for example 20 days of Vacation. In real life the numbers differ: a long-serving employee has extra days, a new colleague has a pro-rata amount, and unused days may be carried over from last year.

For these cases Vitextra Absence & Coverage has the optional Balances list. A row in this list says: "this person has this entitlement of this type in this year". The row replaces the default allowance for exactly that combination, and the employee's balance card in My Absences uses it. This article shows how to fill the list.

📝 Note
The Balances list is optional. Without a row the allowance of the absence type applies, and without any allowance (0) the type has no limit and no balance card. The product does not calculate accruals or carry-over by itself: you enter the numbers.


Columns of the Balances list

ColumnWhat to enter
TitleAny label for people reading the list, for example "Anna Berzina - Vacation - 2026"
EmployeeThe employee as a person. Useful when reading the list; the web parts do not match on it
EmployeeEmailThe employee's e-mail address as text. The web parts match on this column
TypeIdThe item ID of the absence type in the AbsenceTypes list
YearThe calendar year, for example 2026
EntitlementThe days the person is entitled to in that year (one decimal)
CarryOverThe days carried over from the previous year (one decimal)

How a row is matched

My Absences looks for the row of the signed-in person and of the year it shows, and then takes the row of each absence type by TypeId. The entitlement shown is Entitlement plus CarryOver.

❗ Important
A row is found only if all three values agree: the e-mail address in EmployeeEmail, the TypeId and the Year. A typo in the address or a wrong ID means that the row is silently ignored and the default allowance of the type is used instead. Use the primary e-mail address of the account, the one shown in the user's profile.

Keep exactly one row per person, absence type and year. If there are two, only one of them is used and you cannot control which.


Find the TypeId

TypeId is the number that SharePoint gives to the row of the type in the AbsenceTypes list:

  1. Open the AbsenceTypes list on the product site.
  2. Show the ID column in the list view, or open the item and read the number after ID= in the address bar.
  3. Write this number into TypeId of the balance row.

In a list that was created by the product and not changed since, the seven default types normally have the IDs 1 to 7 in the order of the table in KB10352. How to Add and Configure Absence Types. Check the IDs in your list before you rely on that.


Add a row

  1. Open the Balances list on the product site and add a new item.
  2. Fill in Employee and EmployeeEmail for the same person.
  3. Enter the TypeId and the Year.
  4. Enter Entitlement, and CarryOver if there are days from the previous year.
  5. Save the item.

The Balances list with entitlements for 2026

The Balances list with entitlements for 2026

Examples

The examples assume the default Vacation type with AnnualAllowance 20.

Row in BalancesEntitlement on the cardComment
None20The type allowance applies
Entitlement 25, CarryOver 025The row replaces the allowance; it is not added to it
Entitlement 20, CarryOver 3.523.5Carry-over is added to the entitlement
Entitlement 0, CarryOver 00The row exists, so the allowance of 20 is no longer used
Row for 2026 only20 for 2027Rows are per year: add the next year's row in time

For a type without an allowance, such as Sick leave, a row with Entitlement 30 creates a card with 30 days and a limit where there was none.


What employees see

In the Balances section of My Absences each type with an allowance or a row gets a card. The large number is the days that remain; the caption reads "of 24 · used 5 · pending 2" in the language of the page. The progress bar shows used plus pending days in relation to the entitlement. Cards appear only for active types and when the Balances section is enabled. A zero entitlement leaves the progress bar empty.

Balance cards in My Absences

Balance cards in My Absences

Used days are those of approved requests that start in the year shown; a request is booked completely to the year of its start date. Pending days belong to requests waiting for a decision. Rejected and cancelled requests are not counted. The panel for a new request also shows the days that would remain after it. How the numbers are read is explained in KB10328. How to Read Your Absence Balances.

💡 Tip
At the end of each year, copy the rows to the next year and update Year, Entitlement and CarryOver. If you want to let people request more days than the balance, see KB10357. How to Allow Negative Balances.

Questions and answers

Ask a question about this article and get an official answer from our team.

No questions yet. Be the first to ask.

Featured Articles

My Tasks Data Sources: Planner, To Do, Outlook, SharePoint, Project Online and Azure DevOps

Reference for every data source of Vitextra My Tasks: which tasks are loaded from Planner, Microsoft To Do, Outlook flagged e-mails, SharePoint task lists, Project Online and Azure DevOps, what each source requires, how fields are mapped and which limits apply.

102 6 min
How to Add and Configure the Organizational Chart Web Part

Step-by-step guide to adding the Vitextra Organizational Chart web part to a SharePoint Online page and configuring it: approving Microsoft Graph permissions, choosing the chart mode and layout, selecting the attributes shown on employee cards, filtering and excluding employees, enabling export, and saving default settings for Microsoft Teams.

102 7 min
How to Create a Short URL for a SharePoint Page with Short URL

Learn how to create a shortened link to a SharePoint page with the Vitextra Short URL add-on: open the Short URL dialog from Site Actions, change the URL and set the expiration date and owner.

9.1k 2 min

Share