Track Property Loans, Depreciation & Asset Value in Xentra

You bought a vacation apartment for €280,000 with a 20-year mortgage. You've furnished it with €15,000 of furniture and appliances. Your accountant asks for the Anlageverzeichnis (asset register) and depreciation schedules. You stare at a spreadsheet with 47 line items, half of which are missing purchase dates.

Xentra's Tax & Export module handles financing tracking, depreciation calculation, and tax-ready exports - all connected to your units and integrated with P&L reports.

Bank Loan Tracking

Add loans per property: principal amount, interest rate, monthly payment, start date, and term in months. Xentra calculates:

• Current remaining balance
• Total interest paid to date
• Monthly interest vs. principal split
• Remaining payments until payoff

Loan interest feeds directly into your P&L reports as a financing cost - so you see true profitability after debt service.

Asset Registration & Depreciation

Record every cost associated with a unit - furniture, appliances, renovations, repairs. Each entry includes purchase date, amount, category, and depreciation method. Xentra applies German AfA (Absetzung für Abnutzung) rules automatically:

• GWG (under €800) → immediate deduction in the year of purchase
• Pool depreciation (€250-€1,000) → spread over 5 years
• Linear depreciation (over €1,000) → based on useful life from AfA tables (e.g., furniture 13 years, computers 3 years, buildings 33-50 years)

Tax-Ready Exports

EÜR (Einnahmenüberschussrechnung)

The standard German income-surplus calculation for small businesses. Xentra generates the EÜR with all income and expense categories pre-filled from actual booking and invoice data. Print, review, hand to your accountant - or file directly.

DATEV Export

One-click export in DATEV format - configurable for SKR03 or SKR04 chart of accounts. Includes booking references, account assignments, and VAT codes. Your accountant imports the file directly into their system.

Anlageverzeichnis

Complete register of all depreciable assets: name, purchase date, value, depreciation method, useful life, annual depreciation, accumulated depreciation, and current book value. Export for tax filing or audit preparation.

VAT Report

Quarterly VAT summary: output VAT at 7% (accommodation) and 19% (services), input VAT from expenses, and net VAT payable. Ready for Elster submission or handoff to your tax advisor.

Real-Life Example: Year-End Tax Preparation

December 31st. You manage 10 apartments with combined assets worth €120,000. Your accountant needs:

1. EÜR → generated in one click from Xentra
2. Anlageverzeichnis → exported as PDF with all 87 assets
3. DATEV file → exported and emailed to the accountant
4. VAT summary → ready for Q4 submission

Total time: 10 minutes. Your accountant charges less because the data arrives clean and structured.

Key Benefits

• Loan tracking shows real financing costs per property
• Automatic depreciation calculation using German AfA rules
• DATEV export saves your accountant time (and you money)
• EÜR and VAT reports are generated from real data, not estimates
• Per-property reporting supports multi-owner and multi-entity structures

"Your EÜR is pre-filled from actual data. DATEV export means your accountant gets clean, structured data they can import directly."

Start your free trial and simplify your next tax season.