Rental Property Operating Tracker | Excel Starter Workbook

Keep rent due and rent received in view.

Small rental operators tracking property cash receipts and operating expenses.

WHAT YOU CAN DO

- Record properties and occupied-unit snapshots

- Match separate rent receipts to charges

- Review arrears as of your cutoff date

- Separate operating, debt-service and capital cash costs

WHAT YOU RECEIVE

Includes a clean Excel workbook, a fictional guided practice workbook, a four-page Quick Start PDF, README and use terms. 250 prepared records per input sheet. Macro-free .xlsx files. Microsoft Excel and a desktop or laptop are required; software is not included. One currency per file. No integrations, automatic imports or ongoing data service.

SETUP

Set Overview B6 to the reporting cutoff and B7 to your currency. Add properties and opening unit counts. Enter rent charges and each receipt separately.

SCOPE & REQUIREMENTS

Cash operating view only. No lease generation, payment collection, depreciation, tax filing or investment-return calculation. Occupancy is a manually entered current snapshot.

Google Sheets, Apple Numbers and mobile use are not supported release targets. A single business may make internal working copies; resale or redistribution of the template is not included.

Start with the guided practice file, then enter your own records in the clean file. Contact Bear Digital through Payhip for file support.