Free Notion Template for Property Manager Rent Tracker 2026 - Monthly Collection Dashboard

Track every rent payment, late fee, and collection action across your entire property portfolio in one dashboard that auto-flags overdue accounts and generates monthly rent rolls. This template replaces manual spreadsheets and scattered payment records with a system that shows you exactly which tenants need follow-up calls every Monday morning. Not for landlords managing 1-2 properties — built for property managers handling 15+ units who need weekly collection reports.

What this template does

Eliminates the manual process of checking multiple bank accounts, payment apps, and paper records to reconcile monthly rent collection. When you open it on day one, you see a pre-built database with sample tenant records and payment tracking fields. After one week of logging payments as they arrive, the Overdue Payments view automatically surfaces tenants who are 3+ days late, and the Monthly Rent Roll view generates a complete collection report you can send to property owners. Tracks up to 200 active leases with automatic late fee calculations.

Template structure

Tenants Database

• Tenant Name (Title): Full name as it appears on lease. Keep this field updated when tenants move out or you lose referencing data in payment records.
• Unit (Text): Property address and unit number like “123 Oak St #2A”. Required field — payment tracking breaks without a unit identifier.
• Monthly Rent (Number): Base rent amount before utilities or fees. Enter as whole number like 1850. Late fee calculations depend on this being accurate.
• Due Date (Date): Day of month rent is due, formatted as 2026-07-01. Set to the 1st for most leases, but adjust for mid-month move-ins.
• Payment Status (Select): Not received / Partial / Paid in full / Late with notice sent / In collections
• Amount Received (Number): Total payments received for current month. Reset to 0 on the 1st of each month.
• Balance Due (Formula): Automatically calculates Monthly Rent minus Amount Received. Shows 0 when fully paid.
• Days Late (Formula): Auto-counts days past due date when payment status is not “Paid in full”. Drives the overdue flagging system.
• Late Fee Applied (Checkbox): Check when you’ve added late fees to tenant ledger. Prevents double-charging fees on the same month.
• Payment Method (Select): Check / ACH / Cash / Money order / Venmo / Zelle
• Last Contact Date (Date): Most recent collection call or notice sent. Update immediately after any tenant communication to track follow-up timing.
• Notes (Text): Payment arrangements, partial payment schedules, or collection agency referrals. Keep current month only — archive old notes quarterly.

How to use it week by week

1. Every Monday morning: Open the Overdue Payments view to see tenants 3+ days late. Call each tenant on this list before 10 AM and update Last Contact Date immediately after each call.

2. As payments arrive daily: Log the amount in Amount Received and update Payment Status. For partial payments, leave status as “Partial” and note the arrangement in the Notes field.

3. Every Friday afternoon: Review the Late Fee Review view for tenants 5+ days overdue without late fees applied. Apply fees in your property management software and check the Late Fee Applied box.

4. Month-end (last business day): Generate the Monthly Rent Roll report from the Rent Roll view. Export this view as PDF and send to property owners by 5 PM on the last day of the month.

5. First of each month: Reset all Amount Received fields to 0, change all Payment Status fields to “Not received”, and uncheck all Late Fee Applied boxes to start the new collection cycle.

Get your free copy

Duplicate this template for free — opens in your workspace in under 30 seconds. Rename the top-level database to match your property management company name before adding any tenant records.

Frequently Asked Questions

How do I handle tenants who pay rent in multiple installments throughout the month?

Update the Amount Received field each time a partial payment arrives, but keep Payment Status as “Partial” until the full Monthly Rent amount is received. Use the Notes field to track the payment schedule like “Pays $900 on 1st, $950 on 15th”. The Balance Due formula will automatically show the remaining amount owed.

Can I track security deposits and other fees in this template?

This template focuses specifically on monthly rent collection. Security deposits and one-time fees require different tracking since they don’t reset monthly. Add those to a separate “Other Charges” database or use your property management software’s ledger system to avoid confusing monthly rent data.

What happens when tenants move out mid-month?

Change the Monthly Rent field to the prorated amount for that month and update Payment Status to reflect actual collection. Archive the tenant record by moving it to the “Former Tenants” view after final reconciliation. Don’t delete records — you need the payment history for year-end reporting and potential collection actions.

Want 20 more templates built for Property Managers? The full pack is on Gumroad — includes every template on this site plus setup video walkthroughs.