Report this item to Etsy

Company Car Home Charging Excel 2026 & 2027 | 80 Charging Rows, Meter Readings, Costs and Monthly Payroll Records [DE]

NowPrice:$4.15

Original Price: $6.91

Loading

40% off

•

Sale ends in 4 days

You can only make an offer when buying a single item

Highlights

Product language: German.

Prepare reimbursement evidence for company-car charging at home. Enter people, vehicles, meter types and each session's date, opening and closing meter readings, electricity price and charging location. The workbook calculates kWh from the difference, the applied price and the amount. Monthly summaries match employee ID and year-month key and distinguish total costs from amounts passing the workbook's reimbursement checks.

USE IN 2026 AND 2027
You receive the complete original workbook as an example and a blank file. Use a separate working copy for each calendar year with the relevant dates, month keys and prices. The editable accounting-year field in Einstellungen!D11 is a label, not a year filter. Actual charging dates and the entered year-month key drive monthly matching, for example 202701 for January 2027. Grand totals include all entered rows in the file. Changing the year label alone does not update existing records.

Both price methods remain available: actual electricity price and annual flat electricity rate. The actual-price method uses the documented price per kWh entered for each session. The flat-rate method uses the annual value entered in settings. The preset EUR 0.34/kWh is the existing 2026 value only. No currently verified official 2027 flat rate is included. Establish and enter the correct annual value before using that alternative; the actual-price method does not depend on it. Apply the selected method consistently throughout the calendar year. The German START_HIER note explains year use, pricing and evidence.

COMPLETE CONTENTS
Each workbook retains 14 original sheets: Start, Einstellungen, Schnellstart, Fahrer & Fahrzeuge, Regeln ab 2026, Ladevorgänge, Monatsauswertung, Erstattung & Nachweis, Was sich ändert, Übersicht, Beispiel, Anleitung, Quellen & Stand and Lizenz. There are 24 prepared driver/vehicle rows, 80 charging-session rows and 40 monthly-summary rows. Enter data in the white fields; the original calculations, checks and design are preserved.

One ZIP contains exactly seven files:
• Schattenspiel-Heimladen-Dienstwagen-LEER.xlsx – original blank file for your data.
• Schattenspiel-Heimladen-Dienstwagen-BEISPIEL-2026.xlsx – original example with 2026 data.
• Anleitung_Heimladen-Dienstwagen.pdf – complete four-page original German guide.
• Lizenz_Heimladen-Dienstwagen-Nachweis.pdf – complete one-page original licence.
• LICENSE.txt – complete supplementary German licence terms.
• Visitenkarte.jpg – original Schattenspiel business card.
• START_HIER_2026-2027.txt – German delivery list and detailed year/pricing instructions.

Original workbook and PDF contents remain unchanged. Original years, examples, historical source dates and copyright notices stay visible. The supplementary TXT licence has the previously corrected 2027 product heading; its full terms contain no expiry at the end of 2026 or restriction to one accounting year. The note explains this without claiming a newly confirmed future legal position or automatic updates. The existing gallery image shows the original design and its 2026 label.

SCOPE AND LIMITS
No wallbox connection or charging-data import. This is not payroll software and it does not calculate the 0.25% private-use benefit. German scope only. Meter, tariff and reimbursement evidence must come from your own records. Public charging is marked for separate evidence and is not automatically included in home-charging reimbursement. The file does not guarantee tax exemption for an individual payment. It does not automatically allocate fixed electricity charges.

German-language, macro-free XLSX and PDF files for Microsoft Excel on a computer. No separate Google Sheets file or sharing link is supplied. Digital download only; no physical delivery. Extract the ZIP, read START_HIER first and use your own annual copy of the blank file.

Single-user licence for personal and own-business use. Your completed reports may be shared with authorities, advisers or auditors as permitted by the licence. The template may not be shared, resold, published, re-uploaded, offered as someone else's product or used for AI/ML training. Full terms are included. Questions and support: hallo [!at] schattenspiel.eu.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Sep 11, 2026