A landlord spreadsheet template can help you replace scattered notes, paper receipts, and mental math with one organized record. If you manage only a few rentals, a spreadsheet may be all you need to track rent, expenses, leases, and security deposits.
The key is setting it up correctly. A basic list of payments is not enough. Your spreadsheet should show what each tenant owes, what you collected, what you spent, and which tasks need attention.
This guide explains how to build a rental property spreadsheet column by column. There is no downloadable file yet, but you can use the layouts below to create your own workbook in Google Sheets, Microsoft Excel, or another spreadsheet program.
How to Set Up Your Landlord Spreadsheet
Start with one workbook for your rental business. Inside that workbook, create separate sheets for different types of information. Keeping everything on one crowded sheet makes errors harder to spot.
A practical workbook can include these five sheets:
- Properties: Basic information about each building or rental unit.
- Tenants and leases: Contact details, lease dates, rent amounts, and deposit records.
- Rent payments: Monthly charges, payments, balances, and late fees.
- Income and expenses: Money received and costs paid for each property.
- Tasks and maintenance: Repair requests, inspections, renewals, and other deadlines.
Use the same property name or unit code on every sheet. For example, you might use Oak-1 for Unit 1 at your Oak Street duplex. Consistent names make it easier to filter transactions and total the results for one rental.
Avoid creating a completely separate workbook for every month. That setup forces you to open several files to answer a simple question. One workbook per calendar year is usually easier to manage, with a separate row for each transaction or charge.
What a Landlord Spreadsheet Must Track
Your spreadsheet should help you answer basic questions without searching through emails or bank statements. How much rent is due this month? Who has paid? What did a repair cost? When does a lease expire? How much income did one property produce?
At a minimum, track the following information:
| Area | What to track | Why it matters |
|---|---|---|
| Property | Address, unit, and property code | Connects every payment and expense to the correct rental |
| Lease | Tenant, start date, end date, and monthly rent | Shows the current agreement and upcoming renewal dates |
| Rent | Due date, amount due, amount paid, and payment date | Reveals unpaid or late rent |
| Deposits | Amount collected, date received, and disposition | Keeps deposit records separate from rent |
| Income | Rent and other property-related income | Provides a complete record of money received |
| Expenses | Date, vendor, category, amount, and receipt location | Supports budgeting and year-end recordkeeping |
| Maintenance | Issue, report date, status, cost, and completion date | Helps prevent repair requests from being forgotten |
| Deadlines | Lease renewals, inspections, insurance, and recurring tasks | Reduces missed dates and last-minute surprises |
Do not mix security deposits with monthly rental income in your rent tracking spreadsheet. Record them in a dedicated section so you can see how much was collected and what happened when the tenant moved out. Deposit rules vary by state and sometimes by city, so your spreadsheet is only a recordkeeping tool—not a substitute for understanding local requirements.
Your rental income and expense worksheet should also separate expenses into useful categories. Examples include repairs, insurance, utilities, advertising, cleaning, supplies, professional services, and mortgage interest. Keep digital copies of receipts and invoices rather than relying on the spreadsheet entry alone.
Column-by-Column Template Layout
The following layouts give you a starting point for building your own landlord spreadsheet template. Each row should represent one property, lease, charge, payment, expense, or maintenance event, depending on the sheet.
Properties and leases sheet
| Column | What to enter |
|---|---|
| Property code | A short, unique name used throughout the workbook |
| Property address | Full street address, city, state, and ZIP code |
| Unit | Unit number or name, if applicable |
| Tenant name | Name shown on the lease |
| Tenant contact | Preferred phone number and email address |
| Lease start | Date the current lease begins |
| Lease end | Date the current lease ends |
| Monthly rent | Regular monthly rent charge |
| Rent due day | The day rent is due each month |
| Security deposit | Amount received from the tenant |
| Deposit received | Date the deposit was received |
| Lease document | Name or location of the saved lease file |
Rent tracking sheet
| Column | What to enter |
|---|---|
| Rental month | The month covered by the rent charge |
| Property code | The matching code from the properties sheet |
| Tenant | Tenant responsible for the charge |
| Due date | Exact date payment is due |
| Rent due | Regular rent charged for the month |
| Other charges | Allowed fees or other lease-based charges |
| Total due | Rent due plus other charges |
| Amount paid | Total payment received |
| Payment date | Date the payment arrived |
| Payment method | Check, bank transfer, online payment, or another method |
| Balance | Total due minus amount paid |
| Notes | Partial payment details or other useful context |
A simple balance formula can subtract the amount paid from the total due. You can also use conditional formatting to highlight balances above zero. Check your formulas after adding rows, because copied formulas may refer to the wrong cells.
Rental income and expense worksheet
| Column | What to enter |
|---|---|
| Date | Date money was received or paid |
| Property code | Rental connected to the transaction |
| Transaction type | Income or expense |
| Category | Rent, repairs, insurance, utilities, or another category |
| Payee or payer | Vendor, tenant, or other party |
| Description | Short explanation of the transaction |
| Amount | Transaction amount entered consistently |
| Payment account | Bank account, card, check, or other method |
| Receipt or document | File name, folder, or link for supporting records |
| Notes | Details you may need later |
Decide whether expenses will appear as negative numbers or as positive numbers filtered by transaction type. Either approach can work, but do not switch between them. Inconsistent signs can make totals unreliable.
Want an easier way to organize the same records? PropertyCtrl keeps rent, expenses, and property details together for landlords with 1–20 units. Start your free 14-day trial with no credit card required.
Common Landlord Spreadsheet Mistakes
A rental property spreadsheet is only useful when its records are complete and consistent. Most spreadsheet problems do not begin with a complicated formula. They begin with a missed entry or an unclear process.
Recording rent only when it is paid
If you record only completed payments, you cannot easily see unpaid rent. Create the monthly charge first, including its due date and amount. Then record the payment against that charge. This makes a remaining balance visible.
Combining personal and rental costs
A spreadsheet cannot fix mixed financial records. Use a dedicated account for rental activity when appropriate for your situation, and label every transaction with the correct property. If a purchase covers more than one property, note how you divided the cost.
Using vague expense descriptions
Entries such as store or repair may not mean much months later. Write a short but useful description, such as replacement kitchen faucet for Oak-1. Save the receipt or invoice with a matching file name.
Overwriting old information
Do not replace a former tenant's lease details with a new tenant's information in the same row. Add a new row for each lease so you keep the history. The same principle applies to rent increases and recurring charges.
Skipping regular reviews
Set a weekly time to enter expenses, match payments, save documents, and review overdue items. Waiting until the end of the year can turn a small recordkeeping job into days of cleanup.
Relying on one local copy
A lost laptop or damaged file can erase years of records. Keep protected backups. If you use a cloud spreadsheet, secure the account with a strong, unique password and multifactor authentication. Avoid sharing an unrestricted link to a file containing tenant information.
When Spreadsheets Stop Working
There is no exact number of units at which every landlord must leave spreadsheets behind. The breaking point arrives when maintaining the system takes too much time or when missing information creates real risk.
Watch for these warning signs:
- You enter the same tenant or payment information in several places.
- You regularly forget to update the spreadsheet after receiving rent.
- You cannot tell which balances are current without checking a bank account.
- You spend hours matching deposits to tenants each month.
- A formula error changes totals without being noticed.
- Receipts and lease documents live in unrelated folders or inboxes.
- Another person needs access, but you worry they may overwrite a formula.
- You miss lease renewals, maintenance follow-ups, or other important dates.
- Preparing year-end records requires rebuilding several months of activity.
Adding units can expose these weaknesses, but complexity matters as much as size. One duplex with two stable tenants may be simple to track. A few rentals with partial payments, frequent repairs, changing leases, or shared expenses can create much more work.
Spreadsheets also depend on you to design and enforce the process. They do not automatically connect a rent charge to a tenant, protect a formula from accidental edits, or remind you that a record is incomplete. Every improvement usually requires another column, formula, rule, or sheet.
Landlord Spreadsheet vs. Software
A spreadsheet is not a bad starting point. It is familiar, flexible, and inexpensive. Software becomes useful when you want a structured system that requires less manual upkeep.
| Task | Spreadsheet | Landlord software |
|---|---|---|
| Initial setup | Fast if you know what to track | Requires entering properties, leases, and balances |
| Customization | Highly flexible | Uses a more structured workflow |
| Rent tracking | Charges and payments are entered manually | Records are connected to tenants and units |
| Expense tracking | Flexible categories, but manual entry and review | Consistent property and category records |
| Documents | Stored separately or linked from cells | Can be organized with related property records |
| Reminders | Requires formulas, calendar entries, or manual checks | Structured dates and task workflows may reduce follow-up work |
| Error prevention | Formulas and rows can be changed accidentally | Defined fields reduce some entry and formula errors |
| Growth | Becomes harder to maintain as records multiply | Built to manage repeated records across units |
| Cost | Often free beyond your time | Monthly or annual subscription |
The best choice depends on what your time is worth and how confident you feel in your records. If your workbook is accurate, updated weekly, and easy to understand, there may be no urgent reason to replace it.
If you are maintaining many tabs, checking formulas, and searching for missing information, software can remove some of that work. Review our guide to the best property management software for small landlords to compare what matters for a small rental portfolio, or see our comparison of Stessa alternatives if a finance-first app is on your shortlist.
A Simple Upgrade Path
You do not need to wait until your spreadsheet becomes a disaster. A calm transition is easier than moving records during tax season, a tenant turnover, or a maintenance emergency.
- Clean the spreadsheet. Correct property names, tenant records, balances, and transaction categories.
- Choose a cutoff date. A new month or calendar year gives you a clear starting point.
- Save the original. Keep a read-only copy of the workbook for historical reference.
- Move current information first. Start with active properties, tenants, leases, balances, and recurring charges.
- Check the totals. Compare rent balances and year-to-date income and expenses between both systems.
- Use one primary system. Avoid maintaining the spreadsheet and software indefinitely, because duplicate entry creates new opportunities for differences.
Your spreadsheet work is not wasted when you upgrade. A well-organized workbook gives you the clean property, lease, income, and expense data needed to start using a structured system.
Ready to spend less time maintaining rows and formulas? PropertyCtrl helps small landlords track rent, expenses, deductions, and property records in one place. Try PropertyCtrl free for 14 days—no credit card required.
Frequently Asked Questions
What should be included in a landlord spreadsheet?
A landlord spreadsheet should include properties, tenants, lease dates, rent charges, payments, balances, security deposits, income, expenses, maintenance work, and important deadlines. Use separate sheets for major record types and connect them with a consistent property or unit code.
How do I make a rent tracking spreadsheet?
Create columns for the rental month, property, tenant, due date, rent due, other charges, total due, amount paid, payment date, payment method, and remaining balance. Add each rent charge even if it has not been paid so overdue balances remain visible.
Can I use Google Sheets to track rental property expenses?
Yes. Google Sheets can work for a small rental portfolio if you enter transactions consistently, store receipts, protect sensitive information, and review the file regularly. Use clear expense categories and identify the property connected to every transaction.
When should a landlord switch from a spreadsheet to software?
Consider switching when duplicate entry, missing payments, broken formulas, scattered documents, or missed deadlines become common. Software may also be worthwhile when maintaining the spreadsheet takes more time than reviewing and acting on the information it contains.
PropertyCtrl Team
Helping landlords and property managers simplify their operations with expert guidance on property management, legal compliance, and financial optimization.