Skip to content

Keep each property in a clearer picture

Track the rent.
Understand the property.

Rental Income & Expense Tracker PRO

Microsoft ExcelEnglishPDF guide included

14,90 €

One-time purchase

Organise properties, units, tenants and leases. Review rent collection, operating expenses, arrears, deposits and cash flow in one Excel workbook.

  • Create connected rental records
  • Separate unlike cash movements
  • Review performance and collection
Excel workbook + PDF guideDigital download. Access is provided after confirmed payment.
SKU: BKB-RENTAL-INCOME-EXPENSE-TRACKER-PRO Category:
27connected worksheets
XLSXExcel workbook
PDFEnglish user guide

Made for your everyday work

Track the rent.
Understand the property.

Organise properties, units, tenants and leases. Review rent collection, operating expenses, arrears, deposits and cash flow in one Excel workbook.

Illustrative business scene for Rental Income & Expense Tracker PRO

Keep each property in a clearer picture

Understand the property.

Organise properties, units, tenants and leases. Review rent collection, operating expenses, arrears, deposits and cash flow in one Excel workbook.

Illustrative lifestyle image

Give your next decision more context

Create connected rental records

Keep properties, units, tenants and leases together before recording activity.

Track deposits, debt and capital expenditure apart from operating income and expenses.

Rent ChargesProperty SummaryArrears
Actual Rent Charges cells from BusinessKitBase_Rental_Income_Expense_Tracker_PRO_EN_v2.0.xlsx with the included example data
Actual worksheet crop. Included example data.
1

Create connected rental records

Keep properties, units, tenants and leases together before recording activity.

2

Separate unlike cash movements

Track deposits, debt and capital expenditure apart from operating income and expenses.

3

Review performance and collection

Inspect property summaries, arrears, occupancy, rent roll and a 12-month forecast.

Inside your download

Open Excel.
Meet your workbook.

One English Excel workbook and its PDF guide, together in a ZIP file.

XLSX

Rental Income & Expense Tracker PROMicrosoft Excel · English · Version 2.0
PDF

English user guideSetup, workflow and calculation notes

A connected workbook, with a place to start.

  • Rent ChargesIncluded worksheet
  • Property SummaryIncluded worksheet
  • ArrearsIncluded worksheet
  • NOI AnalysisIncluded worksheet
See all 27 worksheet names

Start Here · Settings · Properties · Units · Tenants · Leases · Transactions · Rent Charges · Deposit Ledger · Debt & Loans · Capex Projects · Property Summary · Unit Summary · Tenant Summary · Monthly Summary · NOI Analysis · Rent Roll · Occupancy · Arrears · Expense Analysis · Scenario Planner · 12-Month Forecast · Dashboard · Report · QA Checks · Import Mapping · Rental Notes

From download to your first review

Set up. Record. Review.

01

Open and set up

Save an untouched master copy. Read the included guide and replace the example settings.

02

Add your own records

Use the editable input areas and the workflow described in the PDF guide.

03

Review the connected views

Check your inputs, then read the summaries and planning views. Save a copy for your records.

A few essentials

Microsoft Excel. English. Digital download.

Microsoft Excel is required and is not included. This is an .xlsx workbook. Google Sheets compatibility has not been verified for this edition.

Keep the context with the numbers.The workbook is a manual record and planning tool. Its operating and cash-flow views do not replace tax, accounting or tenancy advice.

Before you start

A few good
questions.

The details that help you decide whether this workbook fits your day.

Are tenant deposits treated as rental income?

No. The workbook uses a separate Deposit Ledger, as described in the supplied guide.

What do I receive after purchase?

A ZIP file containing the English Excel workbook and its PDF user guide. Download access is provided after confirmed payment.

Is this a physical product?

No. This is a digital download. No physical item is shipped.

Do I need an online account inside the workbook?

The supplied file is a standalone Excel workbook. Follow the included guide for setup and use your own copy of Microsoft Excel.

Understand the property.

Your records and planning views, together in Excel.

View purchase options