Browse categories
Explore
Fiverr Pro
English
$
USD
I will build a rental property spreadsheet with cash flow per property in google sheets
About this Gig
Own one rental or a few? I'll set up a spreadsheet that shows what each property earns after the costs you enter, month by month.
It starts from my own ready-made rental tracker, set up for your properties:
- Rent received and rent due, per property and per month
- Costs by category: insurance, repairs, agent fees and more, with mortgage payments kept on their own line
- Cash flow per property and for all of them together
- Vacant months shown at a glance
- Dashboard with a monthly chart and yearly totals
Standard adds more properties and up to 3 changes, such as a short-let nights tab. Premium adds lease dates with reminder flags and a one-page year-end report per property.
Your currency, your categories. Google Sheets or Excel, no macros, no add-ons, no subscription. Every file has a Start Here tab.
How it works:
- Tell me about your properties and what you want to track.
- I confirm the scope by message before starting.
- You get your file, tested with sample data.
Record keeping only: no investment or tax advice. Messages only, no calls.
Independent seller, not affiliated with Airbnb.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
Expertise:
Formulas
•
Functions
•
Dashboard
•
Charts
•
Data validation
My Portfolio
FAQ
Is this tax or investment advice?
No. It records your income and costs and adds them up. Mortgage payments are cash out, which is not the same as a tax-deductible expense. Your totals can help when you talk to your accountant; check what you can claim with them. The lease-dates tab does not work out legal notice periods.
Do you need my tenants' details?
No. Use a property nickname or unit number instead of addresses and tenant names. If you send an existing sheet, remove tenant names, contact details, bank details and full addresses first. I delete my downloaded copies when the order closes.
Does it work for short-term lets like Airbnb?
Yes, a short-let nights tab is one of the 3 changes in Standard.
Google Sheets or Excel?
Either, or both. Tell me which you use when you order.
Which countries does it work for?
Any currency; you name your own cost categories. It does not follow any country's tax forms.
Do you use AI tools?
Yes, AI-assisted tools help me build and check the formulas, and they may read the files you send, so remove personal details first. I review and test every file before delivery. Need work without AI tools? Message me before ordering and I will tell you honestly if I can take it on.
