Report this item to Etsy

Dual-Household Records Excel 2027 | Accommodation Costs, Journeys Home and Main-Household Contributions [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.

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

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Sep 11, 2026