Landlords: How Do You Keep Your Rental Books Tax-Ready?

Question

For rental property owners, how are you keeping your income and expenses organized throughout the year so tax season doesn't become a scramble?

Do you:

• Keep everything in spreadsheets
• Use QuickBooks or other accounting software
• Have a bookkeeper handle it
• Send everything to your accountant at tax time
• Keep receipts/invoices in folders and organize them later

Keep everything in spreadsheets

Use QuickBooks or other accounting software

Have a bookkeeper handle it

Send everything to your accountant at tax time

Keep receipts/invoices in folders and organize them later

I'm especially curious about the manual work behind the bookkeeping — categorizing expenses, matching receipts to properties, organizing vendor invoices, tracking mileage, etc.

What's the bookkeeping task you find most frustrating or time-consuming?

Israel Oluwaseun · Answer

That makes sense. If you’ve got a dozen properties and it’s only taking an hour or so a month, that’s pretty manageable. I think a lot of it probably comes down to having the right system in place from the beginning instead of letting everything pile up.

The year-end part is interesting too — sounds like most of the work at that point is really just catching the occasional mistake.

At what point did you feel like Quicken became worth using for your properties

Bill B. · Answer

Quicken is over kill until you exceed 20 properties. Plus it auto downloads bank and credit card transactions. So every time you run it your prompted to input that $200 Home Depot charge or that $2,500 deposit. It literally takes less than an hour a month with a dozen properties. Shouldn’t take 10 minutes with a few properties.

At year end it might take another hour or two for tax prep, mostly looking for user error and printing reports.

Richard (Ryszard) Cieplechowicz · Answer

Separate account or card for the rentals, so the property is known before you categorize anything. Then once a week go through new transactions and attach the receipt. Batching a quarter at a time is where it turns into guessing. The most annoying piece for me was vendor invoices arriving by email, text and paper. Pick one inbox for all of them and tell vendors that's where invoices go.

Israel Oluwaseun · Answer

Richard, yeah, the vendor invoice part is a big one. It’s easy for things to get messy when one invoice is in email, another is in a text, and another is sitting in a folder somewhere. Having one place for everything definitely makes it easier to stay on top of it.

I’ve also found that keeping the records updated as things come in is a lot easier than trying to clean everything up months later.

Do you still have to manually chase vendors for invoices sometimes, or has having one inbox mostly solved that for you?

Harrison C. · Answer

Simon's weekly habit is the right one. With rooms, the part that got me was the shared bills. One power bill for four people has to be split by room, and if you do that in April you're guessing again. I split each bill the day it comes in, so the expense and what each person owes are on the books the same week.

Two things I'd add. Security deposits aren't income, so keep them off the rent line or your numbers look better than they are. And one checking account per house, so every rent payment and every repair already says which house it belongs to.

Still the most annoying part for me is matching receipts to the right house. I take a photo of the receipt right there and name the file with the house first.

Israel Oluwaseun · Answer

Simon, that’s a great point about categorizing expenses in small pieces instead of trying to reconstruct everything months later. The Home Depot example really shows how quickly the details can get lost when transactions pile up.

I also like your point about mileage. That’s one of those things that seems easy to track later until you actually have to remember months of trips.

This is actually an area I’m interested in supporting investors with remotely — keeping receipts and transactions organized by property, maintaining expense records, and helping keep the documentation current so the owner isn’t trying to reconstruct everything at tax time.

For the owners you’ve worked with, would you say the bigger problem is keeping up with the weekly transaction/receipt organization, or knowing how to categorize and assign expenses to the correct property?

Simon W. · Answer

The most frustrating part for most owners is categorizing in a batch. When you do three months at once you're guessing what a $212 Home Depot charge was for and which property it went to.

What fixes most of it is doing it in small pieces. If each property has its own account or card, the property is already known. Go through new transactions once a week, attach the receipt, and pick the category while you still remember. Then once a month reconcile to the bank statement so you know nothing is missing.

Mileage is the one people lose almost every time, because nobody can rebuild a mileage log in April. Log trips as you go, even if it's just a note on your phone with the date, the property, and why you went.

Landlords: How Do You Keep Your Rental Books Tax-Ready?

7 Replies