My parents own 3 rentals in the Chicago area (a two-flat and two single families). My dad self-manages and has always done the books himself with a spreadsheet, a notebook, and a pile of Home Depot receipts. I’m trying to help him get more organized before tax season.
For those of you who self-manage a handful of units:
What do you use to track income and expenses? Spreadsheet, an app, a bookkeeper?
If you tried an app and stopped using it, what made you quit?
What’s the most annoying or time-consuming part of keeping your own books?
Happy to help since this is exactly the work I do, @Liam Sultana.
Spreadsheet and notebook usually holds up fine until something changes. A refinance, a big repair, or needing per-property numbers.
As for why apps get abandoned, it's rarely the software itself. Categorizing 200 transactions takes longer than expected, so the app sits untouched for months and then feels impossible to restart.
The most time-consuming part is matching expenses to the right property when everything runs through one account. At three doors, that tagging becomes a job of its own.
Whatever tool he lands on, splitting income and expenses by property now is worth doing. It saves him from reconstructing everything later.
For a small portfolio, one rental-only account plus a simple property-by-property ledger can be easier to maintain than a feature-heavy app. Log date, payee, property, category, amount, and a receipt copy, then reconcile monthly; a tax preparer can confirm the categories that fit his situation. General info only.
Liam, three rentals is still small enough that the setup matters more than the software. What I'd put in place for him before tax season:
One bank account used only for the rentals. Then the bank statement is already most of the books, and nothing personal gets mixed in.
One line per dollar in or out: date, property, who, category, amount. Use the Schedule E names as the categories (repairs, supplies, cleaning and maintenance, utilities, insurance, mortgage interest, taxes) so his preparer can total it without a single question.
Receipts photographed the day he buys, named with the date and the address. The Home Depot pile is where most deductions get lost, and it is the hardest thing to rebuild in March.
Mark repairs apart from improvements (a new roof, a new furnace). Improvements are usually written off over years, not all at once. That is the one question worth asking his preparer up front.
Ten minutes on the 1st: did every rent come in, and does the account match the sheet.
On why people quit apps: too much setup, and bank feeds that pull personal charges into the rental books. If he tries one, test it on a month with a repair and a late rent before moving everything over.
I built my own for my room rentals (RentCaddie), so I'm biased. A separate account and a clean sheet will get your dad most of the way.
Liam, with your dad’s two-flat and two single-family rentals, I’d keep rental money separate from personal and put a property column on every ledger entry. I save each receipt in a folder named for that property and spend ten minutes at month-end checking the ledger against the bank statement. I’d have his tax preparer confirm the repair-versus-improvement split before filing.
Three properties is the sweet spot for a simple setup, and the spreadsheet isn't really the problem. The missing piece is usually the routine around it.
Start with one rental-only bank account, nothing personal in it. Track each property separately, whether that's tabs in a spreadsheet or classes in an app, so a per-property P&L falls out without re-sorting at tax time. Every receipt gets photographed the day it arrives, not at month end. And tag each repair as repair or improvement when it's spent, because that tag decides whether it comes off this year's taxes or gets depreciated, and nobody remembers the difference in April.
Then run a short monthly close, twenty minutes or so: reconcile the bank account, match rent to the leases, and clear the uncategorized pile to zero. That's the habit that keeps it from becoming a shoebox again.
Apps usually get abandoned for the same reason spreadsheets do: nothing gets reconciled, so the numbers stop meaning anything and people stop opening it. The tool matters less than the monthly habit.
It's really nice that you're helping your dad with this, and Rachel and Harrison have covered the monthly routine really well.
One thing I'd add is to start from his notebook rather than replacing it. Sit down with him and go through last year's pages together. The categories he already uses become the columns in the spreadsheet, so it feels like his system, just tidier, and he's far more likely to stick with it.
While you're at it, I'd also make a one-page file for each property: the lease dates, the insurance policy, the tax bill, and roughly how old the roof, furnace and water heater are. Right now a lot of that probably lives in your dad's head, and having it written down makes tax season, and any big repair, much easier for both of you.
Kiss! keep it super simple. Have an excel sheet with details for expenses. Use an online rental collection such as rent Redi or schedulemyrent to collect the rent payments. I would not over complicate it. I will say the more detailed your books the better it will be for tax time.
Happy to help since this is exactly the work I do, @Liam Sultana.
Spreadsheet and notebook usually holds up fine until something changes. A refinance, a big repair, or needing per-property numbers.
As for why apps get abandoned, it's rarely the software itself. Categorizing 200 transactions takes longer than expected, so the app sits untouched for months and then feels impossible to restart.
The most time-consuming part is matching expenses to the right property when everything runs through one account. At three doors, that tagging becomes a job of its own.
Whatever tool he lands on, splitting income and expenses by property now is worth doing. It saves him from reconstructing everything later.
Liam, three rentals is a good size to set this up cleanly. A few things to add to what others said:
Keep security deposits separate from operating money. Chicago's RLTO has its own rules on how deposits are held and on interest, so it's worth having his preparer or an attorney confirm he's handling that correctly.
Keep a simple asset list per property (roof, furnace, water heater, appliances, flooring) with date and cost. It feeds the depreciation schedule and doubles as a capex plan.
Tag each expense as repair or improvement when it's paid, not in March.
Keep a mileage log for trips to the properties.
One page per property per month: rent collected, expenses, net, open items. What takes him the most time today: receipts, or deciding categories?
@Liam Sultana The biggest win is habits, not tools. I'd open a separate bank account and one credit card just for the rentals, so the statements become the record and the pile of receipts shrinks.
A spreadsheet can work for three properties if he's consistent, but an app that pulls in bank feeds and tags transactions by property is easier, especially for the two-flat. People usually quit apps that need too much manual categorizing. The most annoying part is catching up at year-end, so a 15-minute weekly check-in helps.
I'd recommend keeping rental income and expenses clearly categorized, saving digital copies of all receipts, and reconciling your accounts every month rather than waiting until the end of the year. It's also helpful to keep separate records for each property so you can easily see which ones are actually performing better financially.
Liam, the best setup here is the one your dad will actually keep using, so I would build around his notebook instead of replacing it all at once.
Sit with him for one month and watch how he records things now. Then put that same flow into a simple sheet, one tab per property, with the same columns he already uses. If the new system feels like extra work, he will quietly go back to the notebook.
Add two habits that cost almost nothing. First, a shared folder, one per property, where every receipt and lease goes the day it arrives, so nothing lives only in a drawer. Second, a short note at the end of each month listing what was fixed and what is still open. That note is what makes tax time and a handyman visit much easier later.
1. A separate checking account just for the rentals. Mixing personal and rental money is what makes year-end painful.
2. Categories that match the Schedule E lines: rent, repairs, insurance, mortgage interest, taxes, utilities, management, supplies. If every transaction gets one of those as it happens, tax prep is basically a printout.
3. Photo every receipt the same day, into a folder by property and month. Missing receipts are where repair deductions get lost.
4. A 20-minute monthly close: match the bank statement to the records and note who paid late.
For 2-4 units a spreadsheet works if he sticks to it. Where people usually give up is step 4. That's the point where software that pulls in bank transactions and tracks rent by tenant earns its keep. How many doors does he have and what's he using now?
Hi Liam, a helpful way to approach this is to treat it as a transition, not a replacement — the notebook and spreadsheet have worked for your dad so far, so the goal is to keep what works and remove the pile of receipts.
Experienced landlords recommend starting with one property as a pilot for a month. Keep the same notebook flow, but add three habits: photograph each receipt the same day into a folder for that property and month, log rent on a simple rent roll showing due date, amount received and any balance, and write down contractor payments as they happen, with a note to collect a W-9 before paying a new vendor.
A system that works well is one shared folder per property holding the lease, insurance, tax bills, receipts and a one-page asset list for the roof, furnace, water heater and appliances. That makes the two-flat and the single-family homes easy to tell apart at tax time, without rebuilding everything at once.
At the end of the pilot month, the test is practical: can the rent for that property be reconciled in about twenty minutes? If yes, roll the same routine out to the other two. If not, simplify the categories before trying a new app.
As a fellow small owner (a 5-unit and a rental house), here's the setup I'd use for three rentals so tax time is a filter, not a project: 1. One checking account and one card used only for the rentals. Export the bank CSV each month instead of typing entries. 2. One sheet, one row per transaction: date, amount, property (Two-flat, House A, House B, or Shared), Schedule E category, receipt link. A pivot table gives each property's Schedule E. 3. Anything that covers all three (an umbrella policy, tools, mileage) goes to Shared and gets split at year end by a fixed rule, like share of rent. Same rule every year. 4. Mortgage payments get split into principal, interest and escrow using the lender's year-end statement. Principal isn't deductible. 5. Receipt photos go into a folder per property the same day, named date-amount-store. 6. Keep security deposits out of income entirely. Chicago's RLTO has its own rules for holding them, so confirm with his preparer.
Open an online data storage platform(Dropbox, Google Drive, Apply Drive, etc) where you can save your receipts / invoices
Open a separate bank account(if not already done) for your rental activities. Export the banking information into excel and create two columns Column A will indicate what property it relates to Column B will indicate the classification(income, repair, improvement, etc) You can refer to the invoices / receipts to determine what the expense relates to.
You can use a sumifs formula to provide you a good profit and loss statement.
If this is too difficult, you may want to engage with an accountant to help you.
One thing I'd consider is organizing the records by property from the beginning, regardless of whether you use a spreadsheet or an app. That way, you're not just tracking total income and expenses, but can actually see how each rental is performing financially. Over time, it also becomes easier to identify recurring expenses, compare maintenance costs, and spot changes that might otherwise get buried in a pile of receipts.