DevelopmentPayment protectionDetails
- Revisions within the package are free.
- If you do not respond within 3 days of delivery, the work is accepted automatically.
The money is reserved when you pay and released only once you accept the work.

Example result
Rental tracker: six apartments, rent, deposits and repairs
Sheet: Rent log (November, excerpt)
| Unit | Tenant | Rent | Due | Paid on | Status |
|---|---|---|---|---|---|
| A1 | J. Moreno | $1,250 | 1 Nov | 1 Nov | Paid |
| A2 | K. Liu | $1,180 | 1 Nov | 9 Nov | Paid late |
| B1 | S. Owusu | $1,400 | 1 Nov | — | Late, 15 days |
Formula in "Status": =IF(E2="",IF(TODAY()>D2+5,"Late, "&(TODAY()-D2)&" days","Due"),IF(E2>D2+5,"Paid late","Paid")). The 5-day grace period is a setting in one cell.
Sheet: Repairs
| Date | Unit | Job | Who | Cost |
|---|---|---|---|---|
| 03.10 | B2 | Water heater replaced | Plumber | $1,150 |
| 21.10 | A1 | New smoke detector | Owner | $35 |
Summary
- Rent collected this month:
=SUMIFS(C:C,F:F,"Paid*")→ $6,030 of $7,430 - Repair costs per unit for the year, and deposits held: $7,300 in total
- Leases ending in the next 60 days turn orange: A2 (31 December)
Delivered
The file, an Excel version and a one-page guide: how to add a tenant and close a month.
Client: a landlord with 6 apartments in two buildings who tracked rent in a notebook and a banking app Task: a Google Sheets tracker that shows who paid, who is late, deposits held, repair costs per apartment and leases ending soon
The client and all details are made up.
About this service
Landlords with a few flats often track rent in a notebook, deposits in an email and repairs in their head, until tax time or a dispute with a tenant. We lay out a rental property tracker in Excel or Google Sheets: properties and tenants, lease dates, rent due and received with arrears, deposits and repair costs per property. Formulas show who is late, which leases end soon and the net income of each property; it is a record-keeping tool, not tax advice.
What is included
- What you getFormulas, the tracker layout (sheets, columns, headers and sample rows as CSV text) and setup steps; in Premium also Apps Script or VBA code that lists overdue rents in one click. Everything comes as text on the order page; we do not send a ready spreadsheet file.
- Rent and arrearsDue, received and balance per tenant
- Lease datesFlags for leases ending soon
- DepositsHeld, returned and deductions
- Repairs and costsBy property and category
- Net incomePer property and per year
How it works
- 1BriefYou describe properties and payments
- 2TrackerWe write layout and formulas
- 3FixesIf something fails on your data, we fix it within your package
What we need from you
How many properties and tenants, how rent is paid (monthly, weekly), Excel or Google Sheets and which costs you want to record.
We will ask you:
- How many properties and tenants do you have?
- How and when is rent paid?
- Which costs should the tracker record?
- Do you use Excel or Google Sheets?
Compare packages
| Packages | Basic$10 | Standard$25 | Premium$49 |
|---|---|---|---|
| What is included | Rent formulas | Rental tracker | Tracker with script |
| Deadline | 1 day | 2 days | 3 days |
| Revisions | 1 | 2 | 3 |
| Formulas | up to 3 | up to 10 | up to 15 |
| Tracker template | No | Yes | Yes |
| Script code | No | No | Apps Script or VBA |
| Order Basic | Order Standard | Order Premium |
Payment protection
You pay when you order, but the money is released only for accepted work.
- Fixed priceThe package price does not change after you pay.
- The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
- Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
- Free revisionsAsk for changes within your brief as many times as the package allows.
- Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
- Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
Questions and answers
Will it calculate my tax?
It totals income and costs by year, which helps your tax return, but tax rules are yours or your accountant's to apply. This is not tax advice.
Can it send reminders to tenants?
Not in this offer. The Premium script lists overdue rents for you; sending messages stays with you.
Can I add more properties later?
Yes, the layout is built so a new property is a new row, and the formulas pick it up.
Did not find your answer?


