Archive | November, 2011

Investment Property Bookkeeping, Part 1

28 Nov

Happy Thanksgiving weekend… this holiday we’re thankful for our first rent checks!

This post details how we’re organizing the income we collect from our investment property to properly anticipate future expenses.

I should start by stating for the record one of my personal rental property goals: everything we spend on the duplex after the initial purchase should come from income generated by the duplex.

Put another way, with careful planning and a little luck, we won’t have to apply another cent of our work income towards the duplex. Future mortgage pre-payment would be an acceptable exception – but I’ll ignore that issue for today’s purposes.

First, I needed a new checking and savings account exclusively for rental property income/expenses. There are several good reasons to separate personal and investment funds:

  1. It’s easier to report your expenses and deductions at tax time.
  2. In the event of an audit, they want to see that you’re treating this property as a business.
  3. If I slacked a bit on our record keeping, we can still easily eyeball whether we’re making money or not.

I opened an ING DIRECT checking and savings accounts for our rental funds. I was already a customer of ING DIRECT, and I really like the savings sub-accounts where you can name each pool of money differently. The most annoying part about using ING DIRECT is that I have to mail my rent checks to deposit them, but hopefully that will be a short-term problem.

So now I have 1 checking account and 4 savings sub-accounts: Variable Expenses, Security Deposit A, Security Depsoit B, and Income Taxes. Some details about each of these accounts:

  • Checking Account – where all rent is initally deposited, and always holds the budgeted funds for PITI ($1,104), repairs ($87.50), and excess cash flow ($200). Cash flow we can apply to anything we want, like mortgage pre-payment, upgrades, miscellaneous expenses like office supplies, or saving for the next duplex. In the short term I’m going to use excess the cash flow to beef up our repair fund just in case something large breaks soon.
  • Variable Expenses – this savings account includes the budgeted funds for things that are irregularly paid, including: future vancancies ($87.50), HOA dues ($50), and professional fees ($25). This savings account is automatically funded $162.50 from our checking account each month. Because I’m a nerd, I then use Quicken to further allocate the money to each sub-category.
  • Income Taxes – I need to dig deeper into this, but my git-r-done way of estimating our tax burden was to start with total rent minus deductions for HOA dues, insurance, property taxes, and 75% of the principal/interest payment (only the interest is deductable). Then I take 25% of that number to get an estimated amount to save for each month, which comes out to $192.47. Rounded up, this savings account is automatically funded $195 from our checking account.
  • Security Deposit A & B – these were transferred to us at closing, and we named each one in ING as Security Deposit + the name of the address the security deposit applies to. I’m leaving those alone until a tenant moves out.

The amount allocated to each fund is directly related to the balance sheet I created previously, with roughtly half of the positive cash flow money being allocated to income taxes.

Update: be sure to check out part 2 and part 3 of my investment property bookkeeping series.


“Landlording is probably the world’s second oldest profession and certainly the most lucrative.” -How to Buy & Manage Rental Properties, 1986

Want to be notified of new posts?

Join 172 other subscribers

Our Investment Property Balance Sheet

10 Nov

We’ve officially closed on our duplex!

investment property closing

At Closing for Our First Investment Property

The Complete Guide to Investing in Rental PropertiesThe primary purpose of this post is to share the (expected) financial breakdown of this property’s cash flow. Every property will have different financial pros and cons, and I’m sure the details vary wildly based on geographic location – but this will provide others interested in investment property a data point to compare their opportunities against.  This analysis was done before we made an offer, and is largely based on advice from The Complete Guide to Investing in Rental Properties (thanks for the recommendation, Daniel!).

Total cost: $181,350
 Down Payment: $45,350 (min 25% required)
Mortgage: $136,000

Revenue Monthly Annually
Rental Income $1,750 $21,000
Vacancy Rate (5%) $87.50 $1,050
Net Income $1,662.50 $19,950
Expenses Monthly Annually
Principle & Interest $699.29 $8,391.48
Taxes $348.31 $4,179.72
Insurance $57.33 $688
Repairs (5%) $87.50 $1,050
Professional Fees $25 $300
HOA $50 $600
Total Expenses $1,267.43 $15,209.20
Cash Flow $395.07 $4,740.80

A few explainations about the above chart:

  • Vacancy Rate – this is an assumed average, taking into consideration rent loss between tenants.
  • Insurance – we have a 2% deductable on $215,000 of “landlord” insurance coverage – i.e everything but the tenants’ possessions.
  • Repairs – also an assumed average, using rules of thumb. Time will tell how accurate they are long-term, but it probably depends greatly on the age of the property, etc.  Luckily ours was built in 2009, which is probably newer than average for a rental.  I’m planning on making this more sophisticated with a “major expected repairs” fund for the big ticket items – roof, a/c units, water heaters, etc which I’ll detail in a future post.
  • Professional Fees – lawyers, accountants, etc. No immediate plans for this fund, but I would expect it will be needed eventually.

If you own an investment property and want to share your balance sheet on this blog – send me a note!

Want to be notified of new posts?

Join 172 other subscribers