CodeLeaf› Templates› RentFlow Pro
Google Sheets Template

Manage your properties.
Not the paperwork.

A complete rental management system built on Google Sheets. Track tenants, chase rent automatically, log maintenance, and generate tax-ready summaries — for 1 to 50 units.

✓ Tenant & lease tracking ✓ Auto rent reminders ✓ Maintenance log ✓ Tax-ready reports Up to 50 units Lease expiry alerts Net income per unit
$49 one-time · no renewals
Buy Now — $49 See What's Inside
RentFlow Pro
Available Now
Rent Tracking Auto Reminders Tax Summary
Features

What's inside

Four core views covering everything this template does — built on Google Sheets, accessed from anywhere.

codeleaf
01 / 04
All your units,
one dashboard.
Portfolio overview — occupancy rate, total rent collected, and vacancies at a glance
Rent due tracker — see who has paid and who is outstanding this month
Lease expiry alerts — 90, 60, and 30-day warnings before leases end
Property Dashboard
Rental Dashboard
June 2026 · 5 units
Occupancy
4 / 5 units
Rent Collected
$3,200
Outstanding
$800
Units
Unit A · Ali Hassan
Lease ends Dec 2026
Paid
Unit B · Mei Ling
Lease ends Aug 2026
Paid
Unit C · Raj Kumar
Lease ends Jul 2026 ⚠️
Due
Unit D · Vacant
Since Jun 1
Empty
codeleaf
02 / 04
Every payment,
tracked automatically.
Monthly payment history — full record per tenant, per unit, per month
Auto Gmail reminders — tenants get a payment reminder on the 1st automatically
Outstanding balance log — track partial payments and arrears across months
Payment Log · Auto Reminders
Payment Log
Unit C · Raj Kumar
Monthly Rent
$800 / month
Payment History
Jun 2026
Pending
May 2026
✓ $800
Apr 2026
✓ $800
Mar 2026
Short $200
Feb 2026
✓ $800
Arrears Balance
Total Outstanding
$1,000
📧 SEND PAYMENT REMINDER
codeleaf
03 / 04
No more missed
maintenance requests.
Maintenance request log — tenants submit, you track status per unit
Priority flagging — urgent issues (leaks, electrical) surface to the top automatically
Repair cost log — track what you've spent per unit for tax purposes
Maintenance Log
Maintenance Log
All Units · Open Issues
Open Requests
Unit B · Water leak
Reported Jun 19
Urgent
Unit A · AC fault
Reported Jun 17
High
Unit C · Door lock
Reported Jun 12
Normal
Repair Costs · June
Plumbing (Unit A)
$120
Electrical (Unit E)
$85
Total this month
$205
codeleaf
04 / 04
Tax time.
Ready.
Property expense tracking — maintenance, insurance, quit rent, assessment all logged
Net income per unit — rent collected minus expenses, calculated automatically
Annual tax-ready summary — one export with everything your accountant needs
Expense & Tax Summary
Tax Summary
2026 · All Properties
Total Rent Income
$38,400
Total Expenses
$6,240
Net Rental Income
$32,160
Expense Breakdown
Maintenance
$4,060
Insurance
$1,560
Quit Rent
$620
📊 EXPORT TAX REPORT
Included

Everything in the box

Everything a small landlord needs — without expensive property management software or monthly subscriptions.

🏘️
Portfolio Dashboard
All units on one screen — occupancy, rent collected, outstanding balances, and lease expiry warnings.
📋
Tenant Profiles
Store tenant names, contact details, lease start/end dates, rental amounts, and deposit records per unit.
📧
Auto Rent Reminders
Tenants receive an automatic Gmail reminder on the 1st of each month. Overdue tenants get escalating follow-ups.
🔧
Maintenance Request Log
Log repair requests per unit, assign priority levels, track status, and record repair costs.
📊
Tax-Ready Annual Report
Net income per unit, total expenses by category, and a one-page summary export for your accountant.
⏰
Lease Expiry Alerts
Automatic 90, 60, and 30-day warnings before any lease expires — so you're never caught off guard.
Technical Specs
PlatformGoogle Sheets + Apps Script
Units supported1–50 rental units
Rent remindersVia your own Gmail · auto monthly
Lease alerts90 / 60 / 30-day warnings
Maintenance logPer-unit · priority-flagged
ReportsMonthly · Annual · Per-unit net income
Tax exportOne-page summary · accountant-ready
Data storageYour Google Drive · 100% private
Setup time~25 minutes
Price$49 · one-time · no renewals
Getting Started

Up and running in 20 minutes

No coding. No complex setup. Copy, customise, deploy — done.

1
Purchase

Buy once on Gumroad. Receive your Google Sheets link by email instantly.

2
Copy to Drive

Click 'Make a Copy' to save the sheet and Apps Script to your Google account.

3
Add Your Units

Enter each unit's details, tenant info, lease dates, and rental amounts. Takes 10–15 minutes.

4
Activate Reminders

Deploy the Apps Script trigger. Rent reminders and lease alerts now run automatically every month.

FAQ

Common questions

How many units can I manage? +
The template is designed and optimised for 1–50 units. Each unit gets its own sheet and is reflected in the portfolio dashboard.
Do the rent reminders actually send from my email? +
Yes. Google Apps Script sends the reminders using your own Gmail account so they look professional and come from a real address your tenants recognise.
Can I track partial payments and arrears? +
Yes. The payment log supports partial payments and carries forward outstanding balances month to month automatically.
How does the tax summary work? +
At year end, a summary sheet calculates total rent income, total expenses by category (maintenance, insurance, rates), and net income per unit — formatted for your accountant.
What if a tenant moves out mid-lease? +
Simply update the lease end date and mark the unit as vacant. The dashboard updates to reflect the change immediately.
Is my tenant data private? +
Completely. Everything is stored only in your Google Drive. No property management platform, no third party, and no monthly fee.
Available Now

Less chasing.
More collecting.

Tenant management, automated rent reminders, maintenance tracking, and tax-ready reports — in one Google Sheet you own forever.

$49 one-time · no renewals
Portfolio dashboardTenant & lease profilesAuto rent remindersMaintenance request logLease expiry alertsTax-ready annual reportFree future updates
Buy Now — $49 Browse Other Templates

Instant delivery · Secure checkout via Gumroad