spreadsheets

January Financial Update

mrsonedollarallowanceLeave a comment

Life is different these days. Our 3rd child was born on Thanksgiving, and we’ve been finishing up some projects around the house. We’ve had a few things happen with rentals, and, basically, I’m just tapped out to keep up with blogging. Mr. ODA asked me what our net worth is at these days, and so I’m updating our spreadsheet.

“JANUARY”

It’s January, so that means I have to create my two main Excel workbooks for the year: the paycheck to paycheck monitoring of our expected income and expenses, and the management of each rental property. The paycheck to paycheck spreadsheet is where I have a line item for each house’s rental income each month, each house’s mortgage payment (where applicable), and then all our bills owed (credit cards, utilities, investments). I break this down by paycheck because that’s the easiest way for me to make sure I have enough income to offset the bills owed during that two-week period. That worksheet in that workbook feeds my net worth calculations, where I also update loan balances. There is actually several tabs in this workbook, but those are the main two. I finally got that all set up today. I haven’t even started creating the investment property workbook.

January also means I have to go through last year’s investment property workbook to verify all the expenses listed are supported by receipts, that all receipts I have are recorded, and that my income is accurate. Then I read off the data to Mr. ODA, who enters it into an online tax portal to file our taxes. I haven’t started that daunting task either.

RENTALS

We had one of our properties flooded by a burst pipe. That’s a mess and is hardly making progress because the tenant’s renters insurance can’t get the tenant property out of the house. We had an electrical issue with a hot water heater in another property. That got fixed, but now I am in a position where I have to fight Home Depot about their shoddy installation a year ago and have them reimburse the cost of rewiring. I finally moved forward with the judgement against a tenant for destruction of property, and our attorney established that collections account.

Surprisingly, we didn’t have any issues with rent payments in December or January. Usually I hear from one or two houses that they need a couple of weeks to pay all of rent. While not everyone was on time, they communicated well and were only a few days late. One tenant reached out and asked if they could pay rent on the 6th (since that’s Friday, and pay day); I told them not to worry about the late fee and that would be fine. Little gestures like that can make a big difference for your tenant’s life.

I sent a letter to our property manager for the KY houses that we’re releasing them at the end of this month, so that’s a new development that is taking my time as well. You’d think my property management company would have a way to communicate this change with the tenants, but alas, that would be too logical. Wish me luck while I add 3 more houses under my own purview. While we moved to KY two years ago, it was easier to maintain status quo with having a property manager. Unfortunately, it has taken too much of my effort to manage the property manager and to fight for our money.

PERSONAL

We finished our master bathroom in the home we bought over the summer (and the room we gutted immediately… only took 6 months to get us to the finish line… and by finish line, there’s still paint touch ups to be had). We bought all the supplies to gut and renovate the basement bathroom in this house. Mr. ODA built a bench for our kitchen table so that we have more seating easier. We made the plans to get the mudroom bench and shelves in, and hopefully those supplies will be bought this weekend.

Truthfully, while I updated most of my net worth spreadsheet in December, I never posted it because I don’t even know where all our money is. When we sold our personal residence at the beginning of November, we were handed a large check. In the past, that check type mostly went towards a downpayment on a new house, but that wasn’t the case this time. Mr. ODA immediately started investing that money in short term treasury accounts that I can’t even begin to explain. Between that account, another savings type account, and our regular investment account, I can update what I see online, but I don’t know what I may be missing. I’m hoping Mr. ODA will chime in soon to describe the type of investment decisions he’s made.

NET WORTH

Several property value assessments declined over the last couple of months. So while our investments are on the upswing from November’s update, those updates to property values have caused a decrease to our net worth.

Doing Your Own Taxes: Set Yourself Up for Success

mrsonedollarallowanceLeave a comment

I manage all the financials for my family. Mr. ODA makes the maneuvers, and I record them. Excel is where our organization lives and dies. Sure, I have a degree in Finance and Information Technology Management (i.e., Excel), but it doesn’t need to be complicated or difficult to make tax prep easy for you.

This level of organization allows us to do our own taxes. After the first year of purchasing rental properties, we thought we’d have to hire someone to do our taxes because it would be complicated. It’s not any different than filing your own personal taxes. The software systems available online walk you through the entire process. Each property’s income and expenses have to be entered separately, which is time consuming if you have several properties, but it isn’t difficult.

The most important thing to be ready for your taxes is to make it a whole year activity. If you record income and expenses as they occur, it’s less of a hurdle when the year is over. By recording the activity all year, it then becomes a verification process when the year is over, thereby reducing the possibility of missing something or recording something wrong.

At the beginning of each year, I create a projection of income and expenses, which helps Mr. ODA adjust his W2 tax bracket throughout the year so that we break as close to even or owe very little when it comes to tax filing. Let me dive into that aside quickly.

Go back to Mr. ODA’s tax posts:
– TAXES! Part 1 – What are Marginal Tax Brackets?
– TAXES! Part 2 – Is Your Bonus at Work “Really” taxed more?

Taxes Part 2 is what I’m particularly referring to, but you may need the lesson in Part 1 to know what that means. There are IRS penalties if you fail to pay your proper estimated tax (when you don’t pay enough taxes due for the year with your quarterly estimated tax payments, or through withholding, when required). Title 26 of the United States Code covers the penalties. Essentially, the IRS is saying, “You have to estimate your annual taxes owed, and you’re not allowed to only pay us taxes on April 15th every year, but you have to pay the taxes over the course of the year.” People get excited to receive a refund from their taxes, but really that’s just an interest-free loan you’ve given the government. Perhaps some people do need that forced savings, but wouldn’t it be nicer to have that extra money in your pocket throughout the year?

Back to the point…

I create a new workbook every year with each house having its own spreadsheet. Schedule E is going to require you to put your income and expenses, per property, not as a whole, so it’s important to have expenses assigned to a particular house. I set up each spreadsheet in an Excel workbook to identify all known costs for the coming year. Not all of these apply, but these are typically the categories of my known costs for each year: property management, HOA, utilities (City of Richmond bills the owner (not tenant) for sewer fees), property taxes, insurance, annual mortgage interest, cost basis depreciation, and prepaid points depreciation. There’s also a chance that you’re carrying appliance depreciation costs (meaning, the purchase of a washer, dryer, refrigerator, etc. aren’t recorded as an actual expense in the year purchased, but are required to be depreciated over its useful life).

As the year goes on, I record any mileage (record the actual miles along with the mileage cost) and maintenance costs. The IRS posts the standard mileage rate for each year here. If a roundtrip to a rental property is 40 miles, then the expense is calculated as 40 miles multiplied by the standard mileage rate, which is $0.56 for 2021. I’ve learned over the years that the software systems just request your miles and do the calculation for you (which is smart and safer on the calculation side), but we want to know what the calculation is going to be, so I enter it as $22.40 in my spreadsheet.

You’ll be expected to input the days your property was vacant, so record that once it’s known.

Each spreadsheet is linked to a master sheet at the beginning of the workbook that shows the net income and expenses for each property. The difference of these amounts are what Mr. ODA uses to adjust his W4 deductions.

I personally assign costs month by month so I can keep track of them, but it doesn’t even need to be that fancy. A running list of these expenses are enough.

The categories are based on what’s going to be requested through Schedule E.

Then in January/February of the following year, I go through my filing cabinet and my email to ensure I’ve captured all of the expenses that I have receipts for, and vice versa to ensure that if I’ve recorded an expense, I have a receipt for it. Having already captured the expenses throughout the year serves as ‘checks and balances’ and doesn’t make the task feel too overwhelming.