How to Use QuickBooks to Track Real Estate Properties

Accurate record keeping helps you to see how well your company is doing, but also is a way to bring in more investors or get loans from banks. How do you track real estate in QuickBooks? Specifically, how do you track properties that are being leased out to tenants?

Using classes to track expenses and income for properties is a great way to manage your business. Here is how you could setup your classes.

Tracking invoices, bills, even line items using classes will help generate specific reports that can help an investor. Classes allow a user to see P/L (Premier can show balance sheet for classes) for each class, this can be invaluable for the investor who would like to see which property is profitable and which isn’t. This is a great way to track property if you are a property manager or you manage property for others. Follow this template to see how to setup your class list:

Name of Owner of Property:

Address of Property:

Unit 1 (2nd floor etc...)

Unit 2

OR

Address of Property:

Unit 1

Unit 2

Setting up your customer list also allows you to pull additional reports and helps during tax time. If you rent properties out, you can structure your customer list like this:

Name Of Tenant:

Address of Property

OR

Name of Owner:

Address Of Property:

Name of Tenant and Unit/Floor #

Vacant and Unit/Floor #

Address of Property:

Name of Tenant

Vacant (this tracks what is spent to maintain house when vacant)

It all depends on your personal preference. Please consult with your accountant to determine what tax information you need to record and track. Using Jobs and Classes are sure fire ways to improve accounting and managing of your company’s finances.

Using YNAB for Small Business Finances

I've used YNAB for a while now, and as you can see from my blog, I like the program. My wife and I are not perfect and sometimes we hit financial setbacks that are beyond our control; however, each time we do we stick with our budget. What we see is that we always have enough to pay for bills and get food. YNAB does work, and it works well for personal finances. 

However, what about small businesses? Does YNAB work for a business owner? 

The answer is... It depends.

It depends on your business. YNAB does extremely well for cash flow budgeting and cash based businesses. If you use a cash based accounting system (you get paid when a product/service is rendered and you pay bills when you receive them) then YNAB is great for you. If you need to have an accrual system, YNAB may not be the best choice.

I have a small company that I run part-time, I sell items online and also do some consulting work. I have QuickBooks Pro (since I am a QuickBooks consultant), but I find myself using YNAB more often. Even though I use both systems, there isn't a lot of work since both programs are able to import and categorize transactions. 

I use YNAB to help me keep my cash flow steady and also keep my spending under control. It has the same effect on my company's finances like it does on my personal finances. There are some things that QuickBooks does that YNAB doesn't, like track and manage taxes. Also, YNAB doesn't track inventory. Lastly, the reporting features are lacking when it comes to business reporting, and it cannot do a balance sheet yet.

However, Jesse (the creator of YNAB) is working on improving YNAB for small business owners, so I believe these features will be available eventually. 

If you want more information follow these links:

YNAB for Small Business

Different businesses who use YNAB

Video about YNAB for small business