LV · RU · EN Try for free
Free template · Excel

Timesheet template 2026

An Excel timesheet for all 12 months: Latvian public holidays 2026, shortened pre-holiday days and transferred working days already marked. Hours worked, norm and hours above norm are calculated for you.

✓ No sign-up
✓ Excel, LibreOffice, Google Sheets
✓ Print-ready A4
Features

What is inside

One file for the whole year. The formulas are in place — just enter the hours.

12 monthly sheets

Each month has its own sheet with dates and weekdays, up to 20 workers per sheet. Rows can be copied.

Holidays marked

Weekends and holidays are grey, pre-holiday days (7 h) yellow, transferred working Saturdays green.

Totals calculate themselves

Hours worked, individual norm, hours above norm, hours on public holidays and days worked for each worker.

Codes A, B, BA, K, N

Leave, sick leave, unpaid leave, business trip and absence — the sheet counts them and reduces the norm.

Calendar sheet

Working days and hours by month and for the year, with holidays and pre-holiday days — taken from the monthly sheets.

Ready to print

A4 landscape, header on every page, space for a signature. Input check: 0–24 h or a code.

Working-time calendar 2026 (Latvia)

Five-day week, 8 hours a day (40 hours a week). On a pre-holiday day working time is one hour shorter.

MonthWorking daysHoursPublic holidaysPre-holiday days
January211681 — New Year—
February20160——
March22176——
April201583 — Good Friday; 5, 6 — Easter2, 30
May191521 — Labour Day; 4 — Restoration of Independence; 24 — Whit Sunday—
June2015923 — Līgo; 24 — Jāņi27 (Sat)
July23184——
August21168——
September22176——
October22176——
November2015918 — Proclamation Day17
December2015824–26 — Christmas; 31 — New Year's Eve23, 30
Year2501994

Transferred days under Cabinet Order No. 330 of 12.06.2025: Friday 2 January moved to Saturday 17 January; Monday 22 June to Saturday 27 June (shortened, 7 h). Mandatory for state institutions, a recommendation for companies; the annual number of working days and hours does not change. Based on Labour Law Sections 131 and 135.

How it works

How to fill in the timesheet

01

Set up the month

Enter the company, project or department and the workers' names. Copy the sheet for each project.

02

Fill it in daily

Against each day — hours worked (8; 7.5) or a code: A, B, BA, K, N. Best on the same day, not from memory at month end.

03

Hand it to payroll

At month end the totals are ready: hours, norm, above norm and on holidays. Sign it and pass it on for payroll.

What to know about working time in 2026

  • Normal working time is 8 hours a day and 40 hours a week (Labour Law Section 131).
  • On a pre-holiday day working time is one hour shorter (Section 135). There are 6 such days in 2026.
  • Overtime and work on public holidays are paid with a supplement of at least 100 % (Section 68).
  • Summarised working time (Section 140) is common in construction: the norm is counted over the reference period, not per day. The «Above norm» column shows exactly that difference.
  • Records must be kept: the employer must record each worker's hours, including overtime and work on public holidays (Section 136).

The template is not legal advice. If your company has a collective agreement or a different reference period, follow it.

Sound familiar?

Why an Excel timesheet fails on site

A spreadsheet works for an office and a small team. Once crews are on several sites, Excel becomes guesswork.

Filled in from memory

Hours are entered on Friday or at month end. Nobody remembers exactly who arrived when.

Several sites

One file, several foremen, different versions. Hours per site have to be pieced together.

Pay disputes

If the sheet does not match the worker's notes, there is nothing to prove who is right.

FAQ

Frequently asked questions

Is the timesheet free?
Yes. The Excel file is free with no sign-up. Open it in Excel, LibreOffice Calc or Google Sheets and change it as you like.
How many working days and hours are there in 2026?
On a five-day week 2026 has 250 working days and 1,994 working hours (40-hour week, with six shortened pre-holiday days). Monthly figures are in the table above.
How do I mark leave and sick leave?
In the day cell enter A (annual leave), B (sick leave), BA (unpaid leave), K (business trip) or N (unexcused absence). A, B and BA days reduce the worker's norm.
How does the sheet count overtime?
The «Above norm» column shows hours worked minus the individual monthly norm — the way summarised working time is counted. On a daily schedule, overtime is counted per day above 8 (7 before a holiday) hours.
Can the timesheet fill itself in?
Yes, with MeistarPro GPS tracking: the worker starts a shift on site on the phone and the hours go into the timesheet by themselves. The timesheet is in every plan — from €19/mo + VAT, 14 days free.

Want the timesheet to fill itself in?

GPS shift on site, hours in the timesheet and payroll from them — MeistarPro. 14 days free.

Try 14 days free
No contract · Cancel anytime