Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

Quickbooks Account Setup

Matt Crowley

0
REIN Member
Joined
Dec 14, 2013
Messages
980
Does anyone have QuickBooks setup for property management / ownership they would be willing to share? Moving away from Excel to lower accounting fees. It doesn't need to be overly complicated. A couple properties held in a corporation. I would like each to have its own expenses and income recorded separately, if at all possible.

If you could send me the file, I would greatly appreciate it!

(Obviously I can search Google and find answers to obvious questions, I am looking for someone who is willing to share the setup they use).

Thanks
 

Tina Myrvang

Client Care Lead
Staff member
REIN Member
Joined
Nov 15, 2010
Messages
1,503
Hello Matt,
I have just sent you the Quickbooks link for Property Management. I hope this is what you are looking for.
 

Sherilynn

Real Estate Maven
REIN Member
Joined
Oct 22, 2007
Messages
2,803
I would like each to have its own expenses and income recorded separately, if at all possible.
This is the only way to go. :)

You will want to set up "classes." Give each property a nickname or use the house number or whatever suits you, and create a class for each property. For every transaction in or out, you assign the appropriate class.

For reporting, you can create P&L's by class or you can modify a report to include a filter showing only certain classes. Fantastic when you have multiple JV's.

I recommend consulting with a bookkeeper experienced in real estate in order to help you customize the template and give you a tour of the program. Your accountant may be able to give you a recommendation - then the books will be set up in a way that suits your accountant.
 

Matt Crowley

0
REIN Member
Joined
Dec 14, 2013
Messages
980
Thanks the template is a good start. Basically it is just a chart of accounts that is specialized with 10 or so unique accounts. I don't see any other special features to it. Is this correct?

For those interested, I would suggest at minimum you purchase QuickBooks pro. QuickBooks Easystart does not provide sufficient flexibility to create classes.

Thanks Sherilynn, I was familiar with the classes from some intro videos. The QuickBooks "free one hour consultation" is a total joke but the online tutorials and help section is actually quite useful.

As far as setup:
  • I've set up my online bank accounts and plan to do just cash-matching accounting and ignore the monthly accruals. (Aside: I know my properties cash flow healthily and it seems ridiculous to enter all rental revenue as unearned liabilities and property taxes as accrued expenses...these have already been budgeted for.) This seems like the easiest way to operate. Some GL (general ledger) entries are necessary...security deposits transformed to revenue for example.
Questions:
  • GST: what are you doing to record the ITC's? No GST charged on rent but are you just leaving the GST paid amounts to the accountant? I may be able to recover these credits in another owned business. I have selected "I do not charge GST" but consequently it appears that the GST paid account is not available. Should I set up GST paid as an item?
  • Recording rents: I am currently setting up "Items" - one for each lease and then booking these to the customer and property class. This makes more sense to me than using invoices. Do you use invoices for your rentals at all? I think invoices are only useful for one-off charges. (Also appear useful in the case of a partial payment)
  • Depreciation: are you just entering this manually at year end? If so, are you breaking out building and land? Obviously you can only depreciate the building (I am familiar with the CCA and UCC). It looks like the REIN template suggests a separate set of property accounts for each property which I think is a mistake (building, land, equipment, updates, closing costs). I think only one set of accounts should be used for this and then separated by classes.
Anyways, that would be a huge help to get a couple more questions answered, thanks.
 

Sherilynn

Real Estate Maven
REIN Member
Joined
Oct 22, 2007
Messages
2,803
For the most part, I use memorized sales receipts to record rent. The exception is when tenants have arranged to pay bi-weekly or have a special arrangement to pay late or split payments. I also have one tenant whose e-transfers are limited to $1000, so they pay in two chunks. In cases such as these I find invoices easier. I use items for rent for each suite, garage, and utility payment (for split utilities in up/down duplexes). These are detailed in the memorized sales receipt or invoice, so recording is easy.

I hated GST recording. My previous accountant set me up with a GST number, but my GST-taxable income was less than $30k and the rebate was a wash, so the CRA kindly deactivated my registration. Now I don't track GST at all. (I must reconsider it now because I am buying some new up/down's and will be able to recover GST.)

I leave depreciation until tax filing. I don't claim depreciation on my RTO's as they will be sold within a year or two. I decide at tax time whether I want to claim depreciation. It is only tax deferral, and depending on income and intentions for the property, it sometimes makes sense to not claim it.
This is the first year I have owned regular rentals within my corporation, so we'll see at tax time what my accountant recommends for depreciation within the corporation.
Either way, I don't account for depreciation on a monthly basis. If required, my accountant will make an adjusting entry at year end.
I do break out building, land, and appliances, but it's a bit of a moot point since it is usually completely subjective (and because depreciation tax breaks eventually get recovered, assuming one sells for a higher price than one buys).
 

bb2

0
Registered
Joined
Sep 10, 2007
Messages
121
For the most part, I use memorized sales receipts to record rent. The exception is when tenants have arranged to pay bi-weekly or have a special arrangement to pay late or split payments. I also have one tenant whose e-transfers are limited to $1000, so they pay in two chunks. In cases such as these I find invoices easier. I use items for rent for each suite, garage, and utility payment (for split utilities in up/down duplexes). These are detailed in the memorized sales receipt or invoice, so recording is easy.

I hated GST recording. My previous accountant set me up with a GST number, but my GST-taxable income was less than $30k and the rebate was a wash, so the CRA kindly deactivated my registration. Now I don't track GST at all. (I must reconsider it now because I am buying some new up/down's and will be able to recover GST.)

I leave depreciation until tax filing. I don't claim depreciation on my RTO's as they will be sold within a year or two. I decide at tax time whether I want to claim depreciation. It is only tax deferral, and depending on income and intentions for the property, it sometimes makes sense to not claim it.
This is the first year I have owned regular rentals within my corporation, so we'll see at tax time what my accountant recommends for depreciation within the corporation.
Either way, I don't account for depreciation on a monthly basis. If required, my accountant will make an adjusting entry at year end.
I do break out building, land, and appliances, but it's a bit of a moot point since it is usually completely subjective (and because depreciation tax breaks eventually get recovered, assuming one sells for a higher price than one buys).
 

MatthewLee

MatthewLee
REIN Member
Joined
Apr 30, 2015
Messages
38
SweetZone, you may wish to consider checking out Dube & Cuttini's "Accounting-In-A-Box" system. It's a QB template and a instruction manual. I started out with it, and could see how it would have been a good solution had I decided to continue to do my own bookkeeping (I eventually hired a bookkeeper!). Tell them Matthew sent you! :)
 

JoeRagona

0
Registered
Joined
Jan 10, 2008
Messages
1,033
Accountant in a Box is THE WAY to go.

I'm a BIG advocate of it - have turned all my coaching clients on to it and have never looked back.

Short story - being FIVE years behind in taxes, I had 3 months to pull it all together. Without knowing how to input everything correctly, it would have cost me half my portfolio to PAY for accounting and bookkeepers to clean it all up.

Today, it takes me half a day once a month to "do the books".

I'm of course biased because I'm now an affiliate for the product...but before that, it changed my bookkeeping instantly and was the best investment I've made.

If you want a great deal on the program, visit my page here - you won't find a better deal on it : http://engagedinvestor.ca/aiab-2014/
 

Matt Crowley

0
REIN Member
Joined
Dec 14, 2013
Messages
980
To anyone interested, the online forums for QuickBooks are adequate enough that purchasing products like the above ^ are unnecessary. The Quickbooks forums are extremely well developed by a number of sophisticated bookkeepers and provide great advice on a number of topics. There are a multitude of videos on YouTube to get you up and started as well. It took about 2-3 weeks working with the program to become familiar with the system. Thanks to folks like Sherlynn and tinamyrvang I was able to come to a solution here.

99% of the time, these for purchase products as suggested by above are outdated and simply plagiarized and reassembled the same information you can get for free online. Don't bother with them. They are entirely unnecessary. Any eBook product for a software that is any good is available for free someone online. Plus, any reputable software developer is continually fixing bugs so the product you buy will be totally outdated.

it would have cost me half my portfolio to PAY for accounting and bookkeepers to clean it all up.

^ Above. That is exactly the sort of sales-copy garbage that I am trying to avoid by blogging on multiple forums and speaking to knowledgable individuals. Do you really think people buy into garbage like that? Either you were defrauding the government or you owned a mobile trailer as your entire portfolio. Seriously.

Bottom line: QuickBooks is a great product, but it has limitations as well:
- not a great forecasting tool
- subject to user error
- does not replace other financial analysis or due diligence activities ie. checking actuals for the year vs. budget for the year

Folks, please be skeptical of anyone suggesting this one product will save your life or make everything peaches and cream. QuickBooks is a fine product for a small business.

On another note, I have enough confidence in the product now that I would be happy to answer any questions you may have about it if you are interested in getting it set up for your business. It would take about 12 hours of working with the product to have enough confidence to do it yourself if you are willing to get over the initial learning curve.
 

JoeRagona

0
Registered
Joined
Jan 10, 2008
Messages
1,033
Sweetzone,

I appreciate your concern about "sales" talk - but honestly, you are way off base here.

First, Accountant in a Box is created by George Dube - who is THE REIN accountant...so I'm not "pushing" a product that is falsified.

I told my story for a reason - because I coach MANY real estate investors who are in similar situations...are overwhelmed with information and do not have the time to search and co-ordinate all of the "free" advice and information out there.

One could argue that ALL information products, personal development course, the stuff we are taught in REIN is ALL about there as well...

The benefit of programs and information products is that they help people solve their problems faster because they are specific to a problem...

Accountant in a Box is created from a real estate accountant's experience working with 1000's of investors and there are specific "methods" to deal with things like vacancy, first and last month deposits etc.

I can't really comment on the fact that "free" forums will have the same information because to be honest, I'd rather invest in something that will SAVE me time and money rather than spending my FREEDOM searching the internet.

How much is your time worth?

Have you ever done the simple exercise of testing what you're worth?

Most of my clients average at $50 per hour when they first do the exercise...

Time is the only valuable thing we have these days and Accountant in a Box has saved me and many others that time.

Avoid calling out a product that you have not tried yourself -

AIAB will allow users to get their Quickbooks in order in less than half of your 12 hours of trial and error.

I'm curios, how long have you been :

an entreprenuer
a real estate investor coach?
 
Last edited:
Top Bottom