Report this item to Etsy

Landlord Annual Property Summary Excel 2026 and 2027 | Rental Income, Expenses and Depreciation [DE]

NowPrice:$4.13

Original Price: $6.88

Loading

40% off

•

Sale ends in 3 days

You can only make an offer when buying a single item

Highlights

Product language: German.

Bring together rental income, expenses, property data and depreciation assumptions for 2026 and 2027 in separate annual files. Monthly receipts and individual invoices form the basis of your year-end records and preparation for German tax advice and Anlage V.

WHAT IS INCLUDED
One completed example workbook and one blank workbook, each with 13 German-language sheets: Start, Einstellungen, Objekte, Mieteinnahmen, Ausgaben, Abschreibung, Anschaffungsnahe Kosten, Jahresergebnis, Übersicht, Beispiel, Anleitung, Quellen & Stand and Lizenz. You also receive the full eight-page PDF guide, the original full licence terms in PDF and TXT format, the original business card and a short annual-use and delivery note. All seven files are supplied in one ZIP archive.

WORKBOOK SCOPE
Record property information and the building share, rent and service-charge receipts, vacancy days and expenses with supporting records, categories, net amounts and VAT. The workbook includes depreciation calculations and the 15% assessment for acquisition-related improvement costs. Indicators and input checks support your records. Each workbook provides 12 property rows, 14 rental rows in total and 16 expense rows. Depreciation and the annual result use one selected property at a time; automatic consolidation of all individual property depreciation is not included.

USING 2026 AND 2027
Create a separate copy of the blank workbook for each year. Set the year in Einstellungen!D32. This field labels the annual result; it does not filter transactions by date. Enter only that year's actual receipts and expenses in each annual copy. The example file retains its complete historical 2026 example. Original internal titles and default year settings remain those of the 2026 edition; the guide explains use for both years.

Keep the actual acquisition, completion and construction/contract dates. Update the remaining depreciation value, relative §7b year and relevant three-year costs for the particular property and year. Starting a new annual file does not restart the three-year period. Compare previous-year figures using the separate previous-year file.

USE AND LIMITS
German-language files for Microsoft Excel on a computer, with no macros. The guide also describes import into Google Sheets and explains that Excel worksheet protection does not transfer. Additional rows are not automatically included in the existing calculation ranges. Depreciation is calculated as a full-year amount; partial-year depreciation and automatic method changes are not included. The construction-cost and efficiency conditions for §7b are not fully checked. The workbook does not complete a tax return or transmit data to ELSTER. Determine applicable tax treatment and transfer final figures separately.

Tax assumptions and historical example figures retain their documented 2026 source date. Use for 2027 is not a promise of future tax law. Check the decisive legal requirements against current official sources for your case. This is an organisational and calculation aid, not individual tax advice.

Digital download with no physical delivery. Personal and own-business use under the complete included licence; these usage rights are not restricted to calendar year 2026. No sharing, publishing, resale or AI/ML training use. Questions, ideas and support: hallo [!at] schattenspiel.eu. Schattenspiel · 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 Oct 6, 2026