Skip to content
Personal Finance

User Stats

61
Posts
16
Votes
Garrett Blanchard
  • Rental Property Investor
  • Rutland, VT
16
Votes |
61
Posts

Balance sheet structure

Garrett Blanchard
  • Rental Property Investor
  • Rutland, VT
Posted May 10 2022, 07:14

I need to build a balance sheet for my properties. What I have so far... Assets, cash and the properties. Liabilities, balances owed on properties, credit cards and lines of credit. Am I missing anything there? Also, under the assets... how do I value the properties? I know they are all worth more then what I paid, but how do I figure this out for banking purposes? Local comps? Rents/expenses? Please help

User Stats

433
Posts
268
Votes
Carini Rochester
  • Investor
  • Rochester, NY
268
Votes |
433
Posts
Carini Rochester
  • Investor
  • Rochester, NY
Replied May 10 2022, 11:25

Bookkeeping can be done for two purposes. It has to be done for tax paying purposes. The balance sheet that will result from this would have the property as an asset, plus any improvements that have to be depreciated (like a new roof, for example.) The dollar values assigned for these assets are what you pay for them, not what you guess, suppose, theorize that they are worth today. The IRS will not care about what it's worth 'today' until the 'today' that you actually sell it and know for sure that that's what it's worth. Depreciation will get included (subtracted) each year (I always date that on December 31.)  You, or your bookkeeper, or accountant should be keeping track and their software can easily print a balance sheet.

Another purpose of bookkeeping is to give you an idea of what you're worth. The main things that will change from what I've stated above is that your properties have (hopefully) gone up in value. In my experience, banks are interested in my best estimate of how much equity I have in my properties. Another difference is that the properties probably have not gone down in value as the depreciation calculation assumes. So remove depreciation. 

I only produce the balance sheet using the bookkeeping required by the IRS. I can look at it and easily add an amount I think the properties have appreciated, subtract out the depreciation and get a rough idea of what I'm really worth (financially speaking.) 

User Stats

116
Posts
78
Votes
Kate Barry
Pro Member
  • Real Estate Agent
  • Vermont and New Hampshire
78
Votes |
116
Posts
Kate Barry
Pro Member
  • Real Estate Agent
  • Vermont and New Hampshire
Replied May 10 2022, 13:16

I would recommend a Profit First certified bookkeeper, I have been so happy with ours and because they work primarily with Real Estate professionals, they are doing everything that I need to do my taxes properly.  I also recommend using Cost Segregation Analysis 

eXp Realty Kate Barry Team Logo
BiggerPockets logo
BiggerPockets
|
Sponsored
Find an investor-friendly agent in your market TODAY Get matched with our network of trusted, local, investor friendly agents in under 2 minutes

User Stats

90
Posts
56
Votes
Todd Lennig
Pro Member
  • Accountant
  • New York
56
Votes |
90
Posts
Todd Lennig
Pro Member
  • Accountant
  • New York
Replied May 10 2022, 14:34

@Garrett Blanchard. I would be happy to chat with you and answer your questions about getting your balance sheet set up. 

User Stats

61
Posts
16
Votes
Garrett Blanchard
  • Rental Property Investor
  • Rutland, VT
16
Votes |
61
Posts
Garrett Blanchard
  • Rental Property Investor
  • Rutland, VT
Replied May 11 2022, 06:10
Quote from @Carini Rochester:

Bookkeeping can be done for two purposes. It has to be done for tax paying purposes. The balance sheet that will result from this would have the property as an asset, plus any improvements that have to be depreciated (like a new roof, for example.) The dollar values assigned for these assets are what you pay for them, not what you guess, suppose, theorize that they are worth today. The IRS will not care about what it's worth 'today' until the 'today' that you actually sell it and know for sure that that's what it's worth. Depreciation will get included (subtracted) each year (I always date that on December 31.)  You, or your bookkeeper, or accountant should be keeping track and their software can easily print a balance sheet.

Another purpose of bookkeeping is to give you an idea of what you're worth. The main things that will change from what I've stated above is that your properties have (hopefully) gone up in value. In my experience, banks are interested in my best estimate of how much equity I have in my properties. Another difference is that the properties probably have not gone down in value as the depreciation calculation assumes. So remove depreciation. 

I only produce the balance sheet using the bookkeeping required by the IRS. I can look at it and easily add an amount I think the properties have appreciated, subtract out the depreciation and get a rough idea of what I'm really worth (financially speaking.) 

At this time it's needed for renewal of biz line of credit...

User Stats

61
Posts
16
Votes
Garrett Blanchard
  • Rental Property Investor
  • Rutland, VT
16
Votes |
61
Posts
Garrett Blanchard
  • Rental Property Investor
  • Rutland, VT
Replied May 11 2022, 06:11
Quote from @Kate Barry:

I would recommend a Profit First certified bookkeeper, I have been so happy with ours and because they work primarily with Real Estate professionals, they are doing everything that I need to do my taxes properly.  I also recommend using Cost Segregation Analysis 


 Do you recommend anyone particular?

User Stats

433
Posts
268
Votes
Carini Rochester
  • Investor
  • Rochester, NY
268
Votes |
433
Posts
Carini Rochester
  • Investor
  • Rochester, NY
Replied May 11 2022, 08:22

@Garrett Blanchard

User Stats

143
Posts
76
Votes
Markus Shobe
  • Accountant
  • Indianapolis, IN
76
Votes |
143
Posts
Markus Shobe
  • Accountant
  • Indianapolis, IN
Replied May 13 2022, 15:46

You don't put the values of the properties on the balance sheet. Only what you have paid on the property and the improvements that have been made. It can get a little complicated than that. You are also missing the equity section. Assets have to equal liabilities+Equity. 

User Stats

7,477
Posts
3,059
Votes
Basit Siddiqi
Pro Member
#3 Tax, SDIRAs & Cost Segregation Contributor
  • Accountant
  • New York, NY
3,059
Votes |
7,477
Posts
Basit Siddiqi
Pro Member
#3 Tax, SDIRAs & Cost Segregation Contributor
  • Accountant
  • New York, NY
Replied May 26 2022, 10:22
Quote from @Markus Shobe:

You don't put the values of the properties on the balance sheet. Only what you have paid on the property and the improvements that have been made. It can get a little complicated than that. You are also missing the equity section. Assets have to equal liabilities+Equity. 

It really depends on the financial statement being provided. There are some financial statements where the balance sheet items are reported at FMV.

User Stats

7,477
Posts
3,059
Votes
Basit Siddiqi
Pro Member
#3 Tax, SDIRAs & Cost Segregation Contributor
  • Accountant
  • New York, NY
3,059
Votes |
7,477
Posts
Basit Siddiqi
Pro Member
#3 Tax, SDIRAs & Cost Segregation Contributor
  • Accountant
  • New York, NY
Replied May 26 2022, 10:25

If you haven't been doing your books in the past, it is hard to just 'create' a balance sheet.

A balance sheet is a picture of the company at a specific time. 

If the business in recent, you may be able to start from the start.
If the business is really old, you may want to start doing the books from the start of a year.

Asset items include items such as Cash, Real Estate, Land, Earnest Deposits, etc
Liabilities include items such as credit card payable, mortgage payable, security deposit
Equity items include items such as capital contributions, distributions to date, etc

Best of luck!