Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyRental Property ManagementTenant Rent Ledger

SpreadsheetRental Property ManagementFree

Tenant Rent Ledger

Charges, payments and late fees for every tenant, with a balance per tenant and your collection rate.

Shown with sample data

Colour

Tenant Rent Ledger

Charges, payments and late fees for every tenant, with a balance per tenant and your collection rate.

Charged
$11,250
Collected
$9,300
Outstanding
$1,950
Collection rate
83%
Balance owed by tenant
  • M. Chen - Unit 2$1,300
  • R. Okafor - Unit 3$650

How to use it

  1. 1Post the rent charge on the day it falls due.
  2. 2Post each payment on the day it is received.
  3. 3Add late fees in line with the lease.
  4. 4Send a statement to anyone with a balance over a month’s rent.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

A rent roll shows what should be paid; a ledger shows what was. Post each rent charge, late fee and payment against the tenant; the Balances sheet shows who is up to date and who is in arrears, and the ledger gives you the dated history you need for a dispute or a reference.

Who it’s for

  • Tracking arrears and part-payments
  • Evidence for deposit disputes and court
  • Tenant payment histories for references

What’s included

  • Ledger sheet: One row per charge or payment.
  • Balances sheet: What each tenant has been charged, has paid and owes.

How to use it

  1. 1Post the rent charge on the day it falls due.
  2. 2Post each payment on the day it is received.
  3. 3Add late fees in line with the lease.
  4. 4Send a statement to anyone with a balance over a month’s rent.
Related searchestenant ledgerrent ledgerrent payment trackerrent arrearslandlord ledger

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetRental Property ManagementFree

Tenant Rent Ledger

Charges, payments and late fees for every tenant, with a balance per tenant and your collection rate.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More rental property management templates

View all
Rent Roll
Task
JunJulAugSepOct
12 Oak Street
12 Oak Street
12 Oak Street
48 Elm Avenue
7 Pine Court
SpreadsheetRental Property Management

Rent Roll

Units, tenants, lease dates, rent, deposits and payment status across your portfolio.

10 min setupPreview
Rental Property Income & Expenses2 sheets

Income

$7,575

Expenses

$2,577

Net cash flow

$4,998

Net cash flow by property
$3,485
$913
$600
12 Oak Street7 Pine Court48 Elm Avenue
SpreadsheetRental Property Management

Rental Property Income & Expenses

Track rent and property expenses by category for cash flow and tax time.

10 min setupPreview
Property Maintenance Request Log2 sheets

Open jobs

2

Avg days to resolve

2.7

Repair spend

$487

ABCD
1ReportedProperty / unitIssuePriority
2Oct 212 Oak St 1BNo hot water: boiler faultEmergency
3Oct 948 Elm AveLeaking kitchen tapRoutine
4Oct 217 Pine CtWindow latch brokenUrgent
5Oct 3012 Oak St 2BMould in bathroomUrgent
Requests
SpreadsheetRental Property Management

Property Maintenance Request Log

Log tenant repair requests with priority, contractor, cost and resolution time.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ