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
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
Be the first to review this item
More from this shop
Visit shop-
Digital download
Business Templates for Notion | CRM, Projects, Finances and Content | Duplicate Link or CSV Import [DE]
Sale Price $25.92
Original Price $43.21
-
Digital download
Product Database Excel Template | Items, Prices, Margins and Stock [DE]
Sale Price $22.81
Original Price $38.01
-
Digital download
Swiss Freelancer Bookkeeping Excel 2027 | Income, Expenses and Quarterly VAT Summary [DE]
Sale Price $19.54
Original Price $32.57
-
Digital download
Creator Income and Tax Reserve Tracker Excel 2027 | Platform Earnings, Products Received and Expenses [DE]
Sale Price $4.15
Original Price $6.91
-
Digital download
Calculating profits for a holiday home using Excel. Download the finished Excel template
$9.84
-
Digital download
Haushaltsbuch Excel Vorlage Deutsch – Dark Mode Budgetplaner + Dashboard – Einnahmen Ausgaben Tracker
$5.71
-
Digital download
Inheritance tax simulator
$6.03
-
Digital download
Ziel Tracker l Finanzverfolgung und -planung l Budgetüberwachung l Excel-Vorlage
$6.87
-
Digital download
Compare electricity and gas prices from up to 3 providers quickly and easily. Ready-made Excel template for immediate download.
$7.03
-
Digital download
Excel Monthly Budget Planner for Couples USD | Editable Spreadsheet (Digital Download)
$5.89
-
Digital download
Modern Excel template for creating utility bills and automated cover letters with intuitive operation WITHOUT SHEET PROTECTION
$17.55
-
Digital download
Excel template for small businesses – income and expense tracker | Profit, accounting & surplus calculation for self-employed individuals
Sale Price $5.82
Original Price $8.31
-
Digital download
Modern Excel template for creating utility bills and automated cover letters with intuitive operation
$12.18
-
Digital download
Income statement - EÜR - profit determination | Excel template
$6.87
-
Digital download
Excel & Google Sheets Loan Calculator | Debt Planner and Amortization Schedule for up to 50 Loans
Sale Price $3.45
Original Price $6.91
-
Digital download
Simple utility bill Operating costs bill - Excel template for landlords
$9.79
Shoppers with similar taste loved these
-
Digital download
2026 & 2025 Advanced Payroll Calculator with Pay Stubs | Quarterly, Monthly, Weekly Remittance Records
$34.00
-
Digital download
Bookkeeping Template for Small Business Easy Income Tracker | Expense Tracker | Accounting Spreadsheet for Google Sheets
Sale Price $11.07
Original Price $22.13
-
Digital download
Small Business Tax Deductions Cheat Sheet Tax Write Offs List Side Hustle Tax Deductions General Tax Tips Deductible Self Employed Expenses
$1.49
-
Digital download
Small Business Tax Deduction Checklist: Expense Tracker (Digital Download)
$1.49
-
Digital download
Paycheck Calculator Spreadsheet | Payroll & Salary Estimator | Google Sheets Pay Stub Template
Sale Price $7.49
Original Price $9.99
-
Digital download
Payroll Templates Bundle 2026: Pay Stub, Time Sheet, Direct Deposit (Digital Download)
$12.00
-
Digital download
Mileage Log/Reimbursement Form | CUSTOMISABLE | Editable for Interior Designers + Beyond | Mileage Tracking | Excel Spreadsheet
$7.35
-
Digital download
Employee Expense Reimbursement Form, Employee Expense Claim Form, Expense Reimbursement Request Form, Employee Expense Report Form
$2.80
-
Digital download
Editable Expense Reimbursement Form Template, Reimbursement Form, Expense Form Template, Excel Template, Simple Reimbursement
Sale Price $2.25
Original Price $3.00
-
Digital download
Employee Expense Reimbursement Form | Employee Expense Request Form | Employee Expense Report | Employee Expense Claim Form
$4.85
-
Digital download
Employee Expense Reporting Template. Expense Report Form. HR Templates. Employee Expense Reimbursement Form. Editable & Printable PDF, Word
$1.99
-
Digital download
Employee Expense Reimbursement, Excel, Editable, Download, HR, Accounting
$5.00