Running other people’s properties means your income is a percentage of five different stories at once. This tracker keeps the whole book in one place: every owner, every door, each client’s fee %, the monthly fee income they actually produce, and the owner statements you owe — with a countdown that flags OVERDUE before your clients notice.
The sample book (14 properties, 5 owners) produces $1,838.39 a month in fees — $22,060.68 a year. The Fee Summary exposes the number most managers never compute: Sunset Rentals Inc alone generates $699.39, 38.0% of all fee income, so losing that one client is a business event, not a bad week. One vacant unit sits visible the whole time: $1,375 of rent and $110 a month of fees earning nothing until it turns.
What it does for you:
– Registers every property with its owner, rent, that client’s management fee % and statement day
– Calculates fees on occupied rent only — a vacant row earns $0 and its idle rent and lost fee stay on the page
– Rolls fee income up per client with each client’s share of your total, plus annualized figures
– Counts down to every owner’s statement date (with your grace days) and flags OVERDUE statements
– Names your top client and their concentration share, and tracks business spending alongside
What’s inside (.xlsx, works in Excel AND Google Sheets):
– Start Here — setup steps, statement grace days and your fee-income target
– Client Register — one row per property with live fees and statement status
– Fee Summary — per-client properties, vacancies, rent roll, fees, share and annualized income
– Expense Log, Monthly Budget, Dashboard, Monthly Summary
Instant download. Type only in the yellow cells — formula cells are locked (password: sheetdaily, disclosed on the Start Here tab). Sample book is pre-filled; clear the yellow cells and register your own doors. Business tracking tool only — your management agreements govern actual fees, statements and duties.
Reviews
There are no reviews yet.