Custom Rental Payment Ledger

I’m putting together a straightforward ledger that lets me record every rent payment for each unit I manage and instantly see who is up to date and who is behind. The file should live either in Excel or Google Sheets—whichever you feel gives the cleanest formulas—and I want it laid out so it is painless for anyone on my team to maintain.

Core data
• Tenant name, phone / email, and lease start–end dates sit at the top of each tenant’s section.
• Below that, a running table lists each scheduled rent date alongside the amount due, the amount received, the payment date, and the resulting balance.

Functionality
• When I enter a payment, the sheet automatically updates the balance and flags any overdue amounts in red.
• A summary view aggregates totals across all tenants so I can see monthly income and outstanding balances at a glance.
• Basic protection is applied to formula cells so accidental edits don’t break anything.

Deliverables
• The finished, unlocked spreadsheet/template.
• A brief one-page guide explaining where to input new tenants, how to log payments, and how the alerts work.

Acceptance
The ledger must handle at least 100 tenants without slowing down, and all formulas should recalculate correctly after duplicating a tenant block for a new lease.