I will build a custom rental property income and expense tracker in excel
Custom Budget, Finance and Rental Property Spreadsheets in Excel
About this Gig
Get a rental property income & expense tracker built around YOUR portfolio, not a generic template.
I start from a tracker whose every formula has been machine-verified against an independent calculation engine (14 of 14 checks, to the cent), then set it up for your exact properties, categories, currency and workflow.
Every build includes: per-property income, expenses and NOI dashboard; year-end expense category totals per property; a rent-check grid that shows a missed month as a zero you can spot instantly; dropdown pickers so property names always match; no macros.
What I need from you: your property list (names and monthly rents), preferred expense categories (or use my 13 standard rental recordkeeping categories), currency and date format, and any branding.
Honest boundaries: this is an organizational bookkeeping tool, not tax, accounting or legal advice. Built and tested in Microsoft Excel. Google Sheets only if your specific build is tested there first. No tax preparation, no bookkeeping services, no financial advice.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
My Portfolio
FAQ
Is this a template or custom work?
Custom. I start from a verified base tracker and set it up for your exact properties, categories, currency and workflow, so your file matches your portfolio.
Do you build in Excel or Google Sheets?
Microsoft Excel, where every build is tested. Google Sheets only on request, and only if your specific build is tested there first.
Do you do my bookkeeping or taxes?
No. I build the organizational tool; you or your professional use it. This is not tax, accounting or legal advice, and no tax preparation, bookkeeping service or financial advice is included.
Can it handle more properties than that?
Up to 8 properties is covered by the Premium package. Larger portfolios, historical cleanup, tenant ledgers or multi-owner reporting go beyond these packages - message me with your setup and I will send a custom offer scoped and priced for that work.

