Prowadzisz firmę w Norwegii i zastanawiasz się, czy personallisteA staff register showing who is actually at work at a location, with start and end times. Mandatory in certain Norwegian industries. możesz prowadzić w Excelu? Krótka odpowiedź brzmi: personalliste can be manual or electronic, but a regular spreadsheet usually does not meet the requirements.
In this article, we explain when electronic personalliste is allowed, why Excel is risky, and how to choose a system that is ready for an inspection from SkatteetatenThe Norwegian Tax Administration, which among other things inspects personalliste. or Arbeidstilsynet.
Short answer: personalliste does not have to be electronic
Personalliste (a list of people actually present at work) can be kept manually or electronically. This follows from bokføringsforskriftenThe Norwegian bookkeeping regulation that, among other things, governs the duty to keep a personalliste. § 8-5-6, available in Lovdata. In practice, Skatteetaten accepts both formats as long as the list meets inspection requirements.
| Format for keeping personalliste | What must be satisfied |
|---|---|
| Manual personalliste | Must be kept at the workplace in a bound book with pre-numbered pages. |
| Electronic personalliste | Must make the list available during an inspection, for example through immediate printing or by showing it on a screen if the list can be transferred electronically. |
For an employer, the most important thing is that personalliste is up to date at the workplace and ready to be shown during an inspection by Skatteetaten. If you want to check first whether your industry has this obligation, see the article What is personalliste and which industries must keep it?.
In your company, you can have digital timelisteA timesheet recording actual working hours, breaks and overtime per employee. (time tracking), an electronic vaktplanA shift plan showing planned working hours – who works when. (work schedule), and a separate electronic personalliste at the same time. Each document serves a different purpose. Timelista helps calculate working time and pay, vaktplan plans shift coverage, and personalliste shows who is actually present at work at a given moment.
Does Excel work for personalliste? Usually not
Personalliste can be kept electronically, but the system must protect entries from easy changes. Skatteetaten states this clearly on the Personalliste page: a spreadsheet or word processor is not acceptable if it allows already recorded data to be edited or deleted directly. A standard Excel file usually allows exactly that, so it is risky as an electronic personalliste.
The main issue is the lack of a secure revisjonsspor (an audit trail showing what was changed, who made the change, and when). For personalliste, corrections must show who and when made them, and the system should be protected against easy data changes. A plain .xlsx file with clock-in and clock-out times usually does not provide that level of control.
| Requirement for an electronic personalliste | Why standard Excel usually falls short |
|---|---|
| No direct editing or deletion of recorded data. | Users can edit cells, change a time, or delete a row. |
| Corrections must show who and when made them. | A standard spreadsheet does not provide a full, secure revisjonsspor. |
| The list must be complete and available in date order, not only through separate employee searches. | Spreadsheets are easy to filter and overwrite, which makes it harder to control the full history of the day. |
| During an inspection, you must be able to show the list on screen, print it immediately, or transfer it electronically if printing is not possible. | A printout from Excel does not solve the lack of control over changes in the source data. |
The rules in bokføringsforskriften § 8-5-6 require personalliste to be kept at the workplace and to include, among other things, the company name, organisasjonsnummer, the people working there, full name, fødselsnummerThe 11-digit Norwegian national identity number. or D-nummerA temporary identity number for people without a Norwegian national identity number., and the start and end time of work each day. The entry must be created immediately when work starts and ends, not in advance and not after a few days of cleaning up a spreadsheet.
If you want to reduce the risk of errors, choose a dedicated system instead of a file. Timelista keeps electronic personalliste with change history, works on phone, tablet, and computer, and helps prepare data for inspections by Skatteetaten and Arbeidstilsynet.
What kind of electronic personalliste is a safe choice?
A safe electronic personalliste is a system that can be checked easily. During an inspection, you must be able to show it on screen, print it immediately, or transfer it electronically, for example by email or on a USB drive.
The most important requirements are practical:
- Controllable system - the list must be available at the workplace and show full data in date order, not only individual searches by employee.
- Change history - every correction must show who and when made it. This lets the inspector see that the entry was not quietly changed later.
- No easy deletion of data - a spreadsheet or word processor is not acceptable if it allows recorded data to be changed or deleted directly.
- Inspection readiness - during an inspection, you must be able to show or print the electronic personalliste immediately.
In practice, the system should record clock-ins and clock-outs as they happen. Bokføringsforskriften requires that the start and end time of work be visible for each workday, and that the entry be made directly when work starts and ends.
Timelista provides electronic personalliste with change history and inspection readiness. In one system, you can also organize digital timeliste, electronic vaktplan, holidays, absences, and data export to lønn (payroll). That means less manual work and fewer errors in daily administration.
Frequently asked questions
Is Excel always forbidden for personalliste?
Excel is a problem when it works like a regular spreadsheet and allows recorded data in personalliste to be edited or deleted directly. Such spreadsheets and word processors may not be used for personalliste.
In practice, choose a system that blocks simple overwriting of entries and keeps a change history. A digital timeliste or an electronic vaktplan in Excel does not meet the requirements for personalliste.
Does personalliste have to be electronic?
No. Bokføringsforskriften § 8-5-6 allows two formats: manual or electronic. An electronic personalliste must allow immediate printing during an inspection, and in practice it can also be shown on screen and transferred electronically if printing is not possible.
The rules are also described by Skatteetaten on the personalliste page.
Is a manual book still allowed?
Yes. A manual personalliste is still allowed if you keep it in an innbundet bok med forhåndsnummererte sider, that is, a bound book with pre-numbered pages.
Entries should be created immediately when work starts and ends. The point is to record attendance as it happens, not to fill in the list later.
What must an electronic system for personalliste show?
An electronic system must show the full personalliste in a controllable way. At minimum, it should include:
- company name and organisasjonsnummer,
- people working in the company, including ulønnet and innleid personale (unpaid and hired-in staff),
- full name and fødselsnummer or D-nummer,
- start and end time of work for each day,
- corrections with information about who and when made them,
- the full list in date order, not only separate searches by employee.
The legal basis is bokføringsforskriften § 8-5-6, which is the Norwegian regulation on bookkeeping and control documentation.
Timelista brings electronic timeliste, personalliste and vaktplan together in one place - 100% compliant with Norwegian law. Create a free account and see for yourself.