First-Time House Hacker — Can Someone Review My Expense Sheet / Accounting Setup?

Question

I recently bought my first house hack, and I’m trying to get my accounting, expense tracking, and tax organization set up correctly from the beginning. I’m brand new to the accounting/tax side of real estate, so I’d really appreciate feedback from more experienced investors, landlords, CPAs, or anyone who has gone through this before.

A little context:

- I want to make sure I’m separating personal vs. rental/business expenses properly.

- I’m using an expense sheet to categorize repairs, supplies, mortgage/escrow items, utilities, closing costs, furnishings, etc.

I am trying to understand and figure out:

- Which expenses should be deductible now vs. capitalized/depreciated

- How to handle shared expenses

- How to treat closing costs

- How to handle the rental percentage

- What tabs/categories should my spreadsheet include

My main goal is to build a clean system now before the property gets messy financially. I’m not trying to replace a CPA, but I want to understand the basics well enough to keep accurate records and ask better questions when I do talk to one.

If anyone is willing to take a look at my spreadsheet or share what their first house hack accounting setup looked like, I’d really appreciate it.

Also, if there are any common beginner mistakes with house hack accounting/taxes that I should avoid, please point them out.

At the bottom, I linked my spreadsheet. Thanks in advance!

Expense Sheet.xlsx

Brett Rogers · Answer

@Ashish Acharya awesome! I appreciate your help

Brett Rogers · Answer

@Aaron Zimmerman that would be great!

Aaron Zimmerman · Answer

@Brett Rogers happy to help.

Would it  be helpful if I sent you a couple helpful links with the accounting setup and how to account for comment expenses? Just don't want to come across as spammy.

a lot depends on the PIS date for what expenses can be capitalized vs expensed.

Ashish Acharya · Answer

Hey Brett, you're approaching this the right way from the start. A few things to help you think through your questions. The rental percentage is really the foundation of everything with a house hack. However you determine that split, whether by square footage, number of units, or number of rooms, that percentage gets applied to all of your shared expenses like mortgage interest, property taxes, insurance, and utilities to determine what portion is deductible as a rental expense. Having that number clearly documented and consistently applied is really important.

On the deductible now versus capitalize question, true repairs and maintenance that keep the property in its current condition are generally deductible in the year you pay them. Improvements that add value or extend the life of the property typically need to be capitalized and depreciated over time. The line between the two can get blurry which is exactly where a CPA adds value, but keeping detailed records of every expense with receipts and descriptions of what the work was will put you in a great position.

Closing costs are a little nuanced. Some items like prepaid interest and property taxes are deductible in the year paid, others like loan origination fees get added to your basis, and some get depreciated. Don't try to sort all of those out yourself, just keep the closing disclosure and let your CPA handle the allocation.

For your spreadsheet categories I would say it looks pretty good. Just keep tracking it the way you currently are and keep a clean worksheet. The biggest beginner mistake I see is people either mixing personal and rental expenses together and not having a clean way to track income and expenses. Both are easy to fix now and painful to reconstruct later.

Happy to connect!