# Arbeitszeiterfassung Vorlage

**Last Updated:** 2026-03-19

Template documentation for the Arbeitszeiterfassung Vorlage Google Sheets template. This template is registered as an **external sheet** – it was created manually and is not synced from an Excel definition.

## Overview

- **Template ID:** `arbeitszeiterfassung-vorlage`
- **Primary Keyword:** Arbeitszeiterfassung Vorlage
- **Category:** time_tracking
- **Source:** external (manual Google Sheet, not generated from Excel definition)

## Copy URL

```
https://docs.google.com/spreadsheets/d/1heRpytpGFo79NzBmUDrnp18AOxkd2H3NWiS8HCceGXw/copy
```

**Usage:** When a user opens this URL while signed into Google, a copy of the template is created in their Drive. The sheet must be shared with "Anyone with link can view" (or equivalent) for the copy flow to work.

## Sheet Structure

The Excel definition (`arbeitszeiterfassung-vorlage.json`) includes an **Ordio CTA**: Anleitung info_cell and Ordio sheet (ordio_cta) with headline "Zeiterfassung mit Ordio digitalisieren" and CTA link to https://ordio.com/arbeitszeiterfassung. See [IN_TEMPLATE_ORDIO_CTA_GUIDE.md](../../../../guides/templates/IN_TEMPLATE_ORDIO_CTA_GUIDE.md).

**Note:** This template is registered as external – the Google Sheet is not synced from the definition. If synced in future, it would include the Ordio CTA structure.

The Google Sheet was created externally. Structure details should be verified by opening the sheet directly. Typical Arbeitszeiterfassung templates include:

- **Anleitung / Instructions** – Usage instructions
- **Zeiterfassung / Time tracking** – Main data entry (Datum, Start, Ende, Pause, Gesamtstunden)
- **Gleitzeitkonto** – Overtime balance if applicable
- **Feiertage** – Public holidays reference

Best practices (BAG 2022 ruling, Arbeitszeiterfassung requirements):

- Use hh:mm format for times
- Mark editable fields clearly (e.g. green background)
- Include Gleitzeitkonto for flexible working
- Include Feiertage for accurate calculations

## Difference from Stundenzettel

- **Stundenzettel** – Specific document format (Stundenzettel = timesheet document)
- **Arbeitszeiterfassung** – Broader process of recording working hours; the Vorlage supports this process

The Stundenzettel Excel Vorlage (`stundenzettel-excel-vorlage`) is generated from an Excel definition and synced to Google Sheets. This Arbeitszeiterfassung Vorlage is an external sheet only.

## Registry and Mapping

- **Registry:** `v2/systems/excel-template-generator/data/template-registry.json` (status: draft)
- **Google Sheets mapping:** `v2/data/google-sheets-template-ids.json` with `source: "external"`
- **Sync behavior:** The sync script skips this template – it will never overwrite the external sheet

## Competitor Context

Competitor templates in this space include: Workwise, TimePunch, Clockodo, absence.io. This template provides a free, self-hosted alternative for basic Arbeitszeiterfassung.