What it does
- Up to 10 properties or rooms with rent, tenant, lease dates, deposit, property type (editable list), tenant contact, and notes
- Rent roll: rent received vs. due for every unit and month, unpaid months in red
- Expense log with landlord categories (loan interest, property tax / council rates, insurance, repairs, agent fees, HOA / strata fees...) and a Tax-deductible? flag on every cost
- Tax Summary: gross rent, deductible expenses, other deductions (depreciation, allowances), and net rental income per property
- Tax set-aside at the % you choose, per year and per month (estimate only, not tax advice)
- Lease status: Active, Ends soon (60 days), Ended, Vacant
- Dashboard: income, expenses, net cash flow, rent collected, tax set-aside, results per property
Who it's for
Landlords anywhere with 1 to 10 apartments, houses, rooms, or condos who want clean records without property-management software.
What's inside
Two .xlsx files (a blank copy and a filled-in example copy) with these tabs:
- Start Here
- Dashboard
- Properties
- Income
- Expenses
- Rent Roll
- Tax Summary
Works with
Microsoft Excel 2010 or newer (Windows & Mac) and Google Sheets. No macros.
Licence
For your own personal or business use. Please don't resell or share the file.
Questions
Do I need Microsoft Excel?
No. The file also works in Google Sheets, which is free: upload it to Google Drive and open it with Google Sheets. In Excel it works in Excel 2010 or newer on Windows and Mac.
How do I get the file?
Right after payment you land on your download page. Your personal download link works for 30 days. If you close the page by accident, open My downloads: enter your PayPal email and the order number (Invoice ID) from your PayPal receipt to get your files again.
Which currency does it use?
Any. Amounts are plain numbers, so type them in dollars, pounds, euros, ringgit, pesos, or your own currency. Tax and fee settings are editable for your country.
Can I use it on my phone?
You can view and edit it in the Google Sheets or Excel app, but it is easiest to set up on a computer.
How do I pay?
Checkout is handled by PayPal. You can pay with your PayPal balance or a debit/credit card. We never see your card details.
How do I contact you?
Message us on WhatsApp at +62 851-2802-8406. We usually reply within one business day. Please include your order number (it starts with BDT- and appears as Invoice ID on your PayPal receipt).
What if the file does not work for me?
Message us on WhatsApp (+62 851-2802-8406) within 14 days of your purchase. We will help you get it working, and if we can't, we will refund you.
You might also like
All templates →
Etsy Seller Profit Tracker
Etsy fees on every order, profit per product, a monthly dashboard, and a tax set-aside you can tune to your country.
Reseller Inventory & Profit Tracker
Real profit per item after fees and shipping, money tied up in stock, ROI, and days to sell.
Small Business Bookkeeping Spreadsheet
Log income and expenses. Get a 12-month profit & loss and a tax set-aside estimate (flat % or your own brackets) that update by themselves.
Social Media Content Calendar
Content plan with status, a monthly calendar view, pillar balance, and engagement rate per platform.