An honest look at when DIY tools stop scaling — and the moment we realized our own founders' spreadsheet had earned its retirement.
In the beginning there was one spreadsheet. It had twelve columns: date, amount, category, property, vendor, notes, receipt (Y/N), reimbursable (Y/N), tax-deductible (Y/N), basis-adding (Y/N), and two columns whose purpose I have now forgotten.
The spreadsheet worked fine for one property. It worked fine for two. We bought a third property in 2021 and the spreadsheet began its slow decline.
How it breaks
The problem with spreadsheets for this use case is not that they are inexpressive — you can make a spreadsheet do almost anything — it is that they require you to maintain the structure yourself. Every time you add a property, you update the dropdown validation. Every time you add a vendor, you add it to the vendor list. Every time you want a new summary view, you write a new pivot table.
Over time, the maintenance cost of the spreadsheet becomes non-trivial. More importantly, the spreadsheet starts to accumulate debt: old categories that no longer apply, vendor names that are slightly inconsistent ('Bob's Plumbing' vs 'Bobs Plumbing' vs 'Robert Hanley Plumbing Inc.'), formulas that break when you copy a row from one tab to another.
The tax-time problem
The worst version of this is at tax time. We would spend two to three evenings each February doing reconciliation work — matching receipts to spreadsheet entries, finding duplicates, un-breaking formulas, and explaining to our accountant why the 'totals' tab showed a different number than the sum of the 'by property' tabs.
One year we found a $3,400 expense that had been entered twice in the basis column but only once in the deductions column. We had been calculating our tax-basis number incorrectly for 18 months. These are exactly the kinds of errors that spreadsheets create and that nobody catches until the number matters.
What made us build something
The moment of clarity was a Saturday in March 2022. We had three properties, a fourth pending, and an accountant who had just sent a list of 34 questions about our 2021 expenses. Most of the questions were answerable, but answering them required opening the spreadsheet, cross-referencing the folder of scanned receipts, and in several cases genuinely not knowing the answer.
We wanted something that attached receipts to individual expenses at the time of entry. That kept vendor history automatically. That calculated the tax-basis running total without manual formula maintenance. That let us hand an accountant a clean summary at year end instead of a Google Sheet and a folder of PDFs.
What we built and why we kept it simple
We built TrackMyHomeCosts for ourselves, and the feature set reflects that. It does not try to replace your accountant or your bank. It does not have a dashboard with 15 widgets. It tracks expenses, organizes them, attaches receipts, and tells you things that are genuinely useful — how much you've spent on a property, what your tax basis looks like, which vendors you use most.
The spreadsheet still exists. We open it occasionally for nostalgic reasons and find it has grown to 1,847 rows. It is, in its way, a monument to the limits of DIY tooling for problems that have more structure than a spreadsheet is built to hold.
