Rent Collection Tracker Spreadsheet, Tenant Ledger, Late Fee Calculator & Arrears, Rent Receipts, Landlord Excel Google Sheets, US Canada

Seller's description

Know who has paid, who is late and who owes what – in one rent tracker that works in Microsoft Excel AND Google Sheets. Works for landlords in the US, Canada and anywhere else (currency is just a label).

Built for small landlords and property managers with up to 30 tenants across 10 properties.

★ WHAT YOU GET
• RENT GRID – every tenant, every month, colour-coded automatically: Paid, Late, Partial, Unpaid, Due (within grace) or Upcoming
• TENANT LEDGER – pick a tenant and see rent charged, late fees, payments and a running balance month by month, plus their full payment history (great when a tenant asks for a statement)
• LATE-FEE CALCULATOR – set each tenant's due day, grace days and fee rule (flat amount and/or % of rent, or 0 where late fees aren't allowed); fees are assessed automatically and you can waive any
• ARREARS SUMMARY – total owing per tenant with ageing (0–30, 31–60, 61–90, 90+ days), months behind, opening balances carried from last year
• PAYMENTS & RECEIPTS LOG – 1,000 rows; every payment gets a receipt number automatically
• PRINTABLE RECEIPT – pick a receipt number, then print or save as PDF
• DASHBOARD – rent due vs collected, collection rate, total owing, late fees, this month's status, 2 charts
• "As-of" date – leave it blank for today, or type a past date to see where things stood
• START HERE guide – set up in about 10 minutes

★ HOW IT WORKS
1. Download the .xlsx file instantly after purchase (Etsy › Purchases › Download Files).
2. Open in Excel – or upload to Google Drive and choose File › Save as Google Sheets.
3. Delete the clearly marked SAMPLE data, add your tenants and log payments as they come in.

★ DETAILS
• Digital download – nothing will be shipped
• File: 1 × .xlsx (Excel 2010+ / Google Sheets; no macros, no add-ons)
• Tested formula-by-formula with sample data

★ AI DISCLOSURE
This template was designed by me with the help of AI tools (for drafting formulas, layout and text), then reviewed and tested before listing.

★ IMPORTANT
This is a record-keeping tool, not legal, tax or accounting advice. Late fees, grace periods, receipts and deposits are regulated differently in every state, province and city (some don't allow late fees at all). The tracker only does the maths for the rules you enter, so please check your local rules.

Personal-use licence: for your own properties. Please don't resell or share the file. Digital items can't be returned – but if anything doesn't work, message me and I'll fix it.