Dual-Household Records Excel 2027 | Accommodation Costs, Journeys Home and Main-Household Contributions [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.
Organise supporting records for a German dual-household tax claim. This workbook records residences, accommodation costs, journeys home, meal-allowance days and financial contributions to the main household. The overview brings together recorded amounts and review indicators. Eligibility and tax deductibility depend on the individual circumstances and supporting evidence.
Each accommodation cost is explicitly linked to its second residence. Extend the existing position ID with the exact residence ID, for example K-01/W-2. The monthly check uses costs assigned to the same residence and the matching domestic or foreign parameter, with standard amounts of EUR 1,000 and EUR 2,000 per month. Unknown, duplicate or main-residence links produce an error indicator. The presence of another foreign residence does not switch all costs to the foreign limit. Statutory exceptions for certain mandatory employer/service accommodation are not decided automatically.
Journeys home use the entered distance allowance; the historical standard since 2026 is EUR 0.38 from the first kilometre. The meal period starts on the actual recorded start date and ends before that date plus the configured number of months. Earlier days are excluded. The supplied EUR 28/14 parameters are domestic rates; there is no automatic foreign meal-rate table. Main-household contributions are recorded with payment method and evidence. The described 10% administrative guideline is not a fixed statutory threshold.
2027 edition: both files carry the year label 2027 and the example start date 1 February 2027. D11 is a label, not an automatic date filter. D10 is the actual start of the dual household; enter your true start and preserve earlier occupancy dates. Fictional example activities were individually rebased to 2027, while the main residence since 2019 and all example amounts were retained. The July 2026 source date and historical law changes remain accurate; no future legal update is claimed.
Scope: twelve worksheets, with input ranges for twelve residences, 40 cost items, 60 journeys home, 45 meal days and 40 household contribution payments. The existing summaries cover these ranges; adding rows does not automatically extend them. No macros are required. The workbook does not complete a tax return or submit information to ELSTER.
Included: a blank and an example XLSX workbook, the complete seven-page PDF guide, the full original licence in PDF and TXT formats, the original contact card and a short getting-started/delivery note. Product content is in German. Digital download only; no physical item is shipped. The example workbook contains a fictional worked case specifically rebased to 2027.
Desktop use: use a PC or Mac with Microsoft Excel, or follow the German guide to import the file into Google Sheets. Mobile use is limited. Preserve formulas and check residence links and calculations after import; the original sheet protection is not transferred in the same way.
Licence: personal use and use within your own business under the complete included terms. Do not resell, share, publish or use the files for AI training.
This template is an organisational and calculation aid, not individual tax advice. Check the current rules applicable to your circumstances. We welcome ideas and provide support after purchase. Questions: 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
Household Budget Excel 2027 | 12 Monthly Sheets and Comparison with 2026 | Light and Dark, No Macros [DE]
Sale Price $5.55
Original Price $9.25
-
Digital download
Biweekly Budget Planner Excel and Google Sheets 2027 | 26 Pay Periods, Bills and Sinking Funds [DE/EN]
Sale Price $16.28
Original Price $27.13
-
Digital download
Annual Budget Planner Nobilis Excel 2027 | Budget, Tasks, Kanban and Gantt [DE/EN]
Sale Price $23.56
Original Price $39.26
-
Digital download
Debt Snowball Tracker Excel | Balances, Repayment Order, Payments and Released Instalments | Undated [DE]
Sale Price $5.26
Original Price $8.76
-
Digital download
Simple utility bill Operating costs bill - Excel template for landlords
$9.79
-
Digital download
Hotel Email Inquiries Cover Letter Template Content Creator Template Application Media Kit in German Media Kit Freelance
$7.01
-
Digital download
Mortgage Calculator Excel Template | Home Loan Amortization & Refinance Tool | Compare Fixed and Adjustable Rates
$7.03
-
Digital download
Class A Extensions Guide | UK Permitted Development Rules Explained | Rear, Side & Two-Storey Extension Checklist PDF
$9.79
-
Digital download
Tax tips for individuals (2023)
$8.84
-
Digital download
FHA Mortgage Calculator | Loan Payment, Amortization Excel Tool (Instant Download)
$9.99
-
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
UK Home Planning Guide: Permitted Development Flowchart & Checklist (PDF Download)
$8.39
-
Digital download
Landlord Management System Access Database/Template
$7.00
-
Digital download
ISO 9001 Audit Checklist | Internal Audit Templates | PDF & Word | Quality Management IMS Tool | Safety Guide Templates
$12.79
-
Digital download
Mortgage Calculator Excel: Home Affordability & Loan Comparison (Instant Download
$7.03
-
Digital download
Ultimate Airbnb Host Guide: Digital Bundle for Vacation Rental Success & Hospitality Management
$9.99
Shoppers with similar taste loved these
-
Digital download
Monthly Planner | Budget Sheet, Expense Tracker, Financial Organizer, Personal Finance Printable, Savings & Debt Tracker
$1.50
-
Digital download
Spending Journal: Budgeting, Money Management, Self-Reflection | Mental Health PDF, Therapy Journal, Self-Reflection, Guided Prompts
$4.80
-
Digital download
Debt Processing Workbook: Financial Future Planner (PDF Download)
$3.00
-
Digital download
Personal Finance Journal Prompts: Smart Spending, Savings Strategies | Mental Health PDF, Therapy Journal, Self-Reflection, Guided Prompts
$2.80
-
Digital download
Bank Balance Sheet Printable: Budget & Expense Tracker (PDF Download)
Sale Price $1.94
Original Price $5.55
-
Digital download
Editable Monthly Expense Tracker Printable, Fillable Expense Tracker, Spending Tracker, Business Expense Tracker, Transaction Log A4, Letter
Sale Price $1.68
Original Price $2.10
-
Digital download
Pre-Marital Financial Prompts: Conversation Starters (PDF Download)
$1.50
-
Digital download
Finance Planner Printable PDF, 2025 Budget Planner Bundle, Budget Binder, Paycheck Budget Planner, Bi Weekly Budget, Budgeting, PRINTABLE
Sale Price $0.96
Original Price $3.84
-
Digital download
Bank Balance Sheet Printable: Budget Tracker Template (Digital Download)
Sale Price $1.94
Original Price $5.55
-
Digital download
Small Business Tax Deduction Checklist: Expense Tracker (Digital Download)
$1.49
-
Digital download
Realtor Tax Deduction Checklist: 75+ Expenses (US Taxes ONLY) (Digital Download)
$0.99
-
Digital download
Small Business Tax Deductions Cheat Sheet List | Deductible Expenses | Tax Write Offs List | Tax Deductions Checklist| Editable Tax List
$3.99