Property management dashboard
Rent Collection Dashboard: know who has paid, who is late and what is owed
An Excel and Google Sheets dashboard for rent collection: rent billed vs. collected, collection rate, outstanding balance, late payments, an aging chart and a tenant ledger.

Shown with sample data. Your numbers replace the sample numbers.
What is inside
- Rent billed vs. collected by month
- Collection rate and outstanding balance calculated for you
- Late payments and late fees tracked
- Balances-by-age chart
- Tenant ledger with paid, balance and status
- Tabs: Dashboard, Monthly Data, Breakdown, Log and How to Use
- Pick any month (1 to 12) and every card updates
Who it is for
Landlords and property managers who collect rent from several units and want late payments caught early.
How it works
- Check out and download the .xlsx file right away (it is also in your account)
- Open it in Excel, or upload it to Google Sheets
- Type your own numbers over the yellow sample cells
- Set the month on the Dashboard tab and review your numbers
Questions
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. Formulas and charts carry over; chart styling may look slightly different.
Does it connect to my software automatically?
No. It is a spreadsheet: you type or paste your monthly numbers into the input tabs. That keeps it simple and private.
Are the numbers in the file real?
No. The file ships with sample data so you can see how it works. Replace it with your own.
Want it built and connected to live data instead?
Contact us about a custom dashboard build.
More property management dashboards

Rental Property Portfolio Dashboard
Every property, unit and dollar on one screen
$47 · See the dashboard →
Maintenance & Work Order Dashboard
Every repair request tracked from open to closed
$47 · See the dashboard →
Owner Financial Dashboard (NOI & Cash Flow)
NOI, cash flow and expenses for owner reports
$47 · See the dashboard →