Landlord Annual Property Summary Excel 2026 and 2027 | Rental Income, Expenses and Depreciation [DE]
NowPrice:$4.13
Original Price: $6.88
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
Be the first to review this item
More from this shop
Visit shop-
Digital download
Liquidity Warning Tracker Excel | Weekly Actual Figures, Warning Levels and Action Plan | Undated [DE]
Sale Price $14.64
Original Price $24.40
-
Digital download
Business Bundle of 8 Excel Templates 2027 | Sales, Finance and Task Planning [DE]
Sale Price $88.16
Original Price $146.93
-
Digital download
E-Invoice Transition Planner Excel 2027/2028 | Tasks, Target Dates and Software Matrix [DE]
Sale Price $20.53
Original Price $34.21
-
Digital download
600 Digital Product Ideas 2027 | Compendium, Excel Calculator and Offline Tools [DE/EN]
Sale Price $11.70
Original Price $19.50
-
Digital download
Rental Property Income and Expenses Excel Template
Sale Price $14.96
Original Price $19.95
-
Digital download
Excel Investment Property Template for Short and Long Term Rentals, Income & Deductible Expense Tracker, AirBNB Property, Landlord, VRBO
$11.02
-
Digital download
Rental Property Management Excel | Income, Expenses, ROI Tracker
$5.99
-
Digital download
Rental Property Bookkeeping Google Sheets Landlord Spreadsheet Multi Property Income and Expense Tracker Excel Tenant Tracker Rent Payment
Sale Price $8.59
Original Price $17.18
-
Digital download
Excel & Google Sheets Loan Calculator | Debt Planner and Amortization Schedule for up to 50 Loans
Sale Price $3.44
Original Price $6.88
-
Digital download
Landlord Rental Property Income & Expense Tracker Excel Template – Property Management Spreadsheet for 24 Properties
$12.90
-
Digital download
Excel Rental Property Income & Expense Tracker | Schedule E Summary | Mortgage Split + Escrow Tracking | Depreciation | Landlord Template
$19.99
-
Digital download
Rental Property ROI & Cap Rate Calculator | Real Estate Investment Spreadsheet | Digital Download
$5.00
-
Digital download
Rental Property Accounting Spreadsheet for Excel and Google Sheets, Rental Property Income Statement, Rental Income and Expense Tracker
$9.99
-
Digital download
Rental Property ROI Cap Rate Spreadsheet Calculator Template. Rental Comparison Excel Google Sheets. Income Property. Real Estate Investment
Sale Price $3.50
Original Price $7.00
-
Digital download
Rental Property Template Landlord Spreadsheet Income and Expense Tracker Rental Bookkeeping, Excel & Google Sheets Real Estate Management
Sale Price $9.33
Original Price $18.66
-
Digital download
Airbnb GST/HST Tax Tracker | Canadian Excel Template (Google Sheets)
Sale Price $6.81
Original Price $9.73
Shoppers with similar taste loved these
-
Digital download
Rental Property Management Template Excel & Google Sheets: Track Income, Expenses and Maximize ROI
Sale Price $1.65
Original Price $6.60
-
Digital download
Airbnb Spreadsheet Vacation Rental Property Tracker Bookkeeping Template Google Sheets Booking Calendar Excel Short-Term Rental Management
Sale Price $8.98
Original Price $17.96
-
Digital download
Rental Property Tracker Landlord Spreadsheet Multi Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $8.98
Original Price $17.96
-
Digital download
Rental Property Bookkeeping Google Sheets Landlord Spreadsheet Multi Property Income and Expense Tracker Excel Tenant Tracker Rent Payment
Sale Price $8.59
Original Price $17.18
-
Digital download
Real Estate Investment Financial Performance Dashboard | Rental Property Analysis Spreadsheet | Cash Flow & ROI Calculator
$19.99
-
Digital download
Rental Property Calculator | Real Estate Investment Tool | Landlord Spreadsheet | Rental Cashflow Tracker | Google Sheets Template
$14.96
-
Digital download
Rental Property Tracker Landlord Spreadsheet simple Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $5.50
Original Price $11.00
-
Digital download
Rental Property Bookkeeping Spreadsheet: 10-Year Summary (Google Sheet)
Sale Price $20.21
Original Price $33.68
-
Digital download
Rental Property Income & Expense Tracker, Google Sheets Template (Digital Download)
Sale Price $23.80
Original Price $28.00
-
Digital download
WORD COUNT TRACKER | Spreadsheet for writers | Novel Word Count Spreadsheet | NaNoWriMo Tracker | Google Sheets Template
$11.08
-
Digital download
Real Estate Business Spreadsheet Bundle: House Flip Airbnb Calculator Bookkeeping Password Tracker Excel & Google Sheets Digital Download
$34.97
-
Digital download
Client Tracker, CRM Dashboard, Google Sheets, Small Business Template, Lead Tracker, Customer Seller Spreadsheet
Sale Price $13.91
Original Price $23.19