Rent Collection Dashboard — $47

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.

$47one-time · instant download · Excel & Google SheetsGet the dashboard — $47
Rent Collection Dashboard shown with sample data

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

  1. Check out and download the .xlsx file right away (it is also in your account)
  2. Open it in Excel, or upload it to Google Sheets
  3. Type your own numbers over the yellow sample cells
  4. 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.

Get the Rent Collection Dashboard

$47

Get the dashboard — $47
Editorial & AI Disclosure