Bookkeeping - what's your approach?

Bookkeeping - what's your approach?

Residential Real Estate Broker · Grand Blanc, MI · Member since 2008 · 885 posts · 316 votes

As we acquire more and more (mostly buy and holds, but also some rehabs for a quick flip) it's becoming more and more of a hassle to keep the books.

I am yet to find an adequate piece of bookkeeping software which really lends itself to real estate investing. Quickbooks claims to be REI friendly, but it simply isn't. It's written on the premise of being service oriented with buying goods, selling the goods and or a service, then invoicing. I'm having a heck of a time forcing my transactions to fit that model.

At this point, I think I'd be better off with maintaining my old school way of just doing it all manually...but that's at the risk of missing something as our volume increases. Quite honestly, I'm very detailed with my manual bookkeeping and simply maintaining an accurate history is partially holding me back from doing more REI.

What methods do you employ?

1Reply
84 views

Most Popular Reply

Manhattan, NY · Member since 2008 · 801 posts · 61 votes
17y

The advantage an accounting system has over spreadsheets is up to date reporting.

How long would it take you to pull your spreadsheets together to give a complete balance sheet of your operation? It takes me about 10 seconds in QuickBooks.

If you do your own taxes, which I do then have them reviewed by my accountant, TurboTax will import the data from QuickBooks and if you have it set up correctly for your entity, it will put it on the right tax lines GUARANTEED. Can't get that from a spreadsheet.

BTW, I am not discouraging your use of spreadsheets to run your company. If it works for you, great. I'm just pointing out the benefits of a real accounting system go way beyond just tracking income and expenses.

See this reply in the discussion

25 Replies

Jump to latestLatest
  • Manhattan, NY · Member since 2008 · 801 posts · 61 votes
    17y

    When setup correctly, QB is an excellent accounting choice for landlords as well as wholesalers, rehabbers and the like.

    If you are having to "force" your transactions then it is just setup wrong. One very common mistake is setting up tenants as "customers".

  • Real Estate Investor · Milwaukee, WI · Member since 2008 · 1k+ posts · 671 votes
    17y

    Is there a tutorial about using it for REI?

  • Property Manager · Passaic, NJ · Member since 2008 · 369 posts · 83 votes
    17y

    Mark, I set up my tenants as customers. I then set up my charges as memorized monthly recurring charges so they hit on the first of each month automatically each month; then simply enter the receipts and deposit them. I used to use Quicken but have found that changing over to QB Pro was not difficult at all. You can post late fees automatically too for anyone not paid on time etc. If you are stuck on something PM me and I'll try to direct you.

  • Residential Real Estate Broker · Grand Blanc, MI · Member since 2008 · 885 posts · 316 votes
    17y

    Thanks for the replies. Maybe I haven't given QB a fair shot so far...

    To take my question to the next level... What do you for rehabs, specifically? Do you simply log all the receipts for Home Depot, contractors, etc.? Then, how about the initial cost of the property? What is that classified as? Then, what about loans and loan payments? And...when resell on land contract, what is that considered? It's not rent, that's for sure. QB seems too shallow when it comes to handling loans.

  • Accountant · Honolulu, HI · Member since 2008 · 27 posts · 0 votes
    17y

    I am not too familar with QB, but I would think that it should have a fixed asset module. I would enter the purchase price of the property here, and the invoices for any additions to the basis for rehabs etc. I would break out the cost of the land with and the improvements/buildings into different accounts as there are different depreciation/tax rules for these. I am not sure if there is a depreciation module, but if not you will have to calculate the depreciation on a spreadsheet, and set up the amount as a monthly occurring entry.
    As for loans, there should be a debt section/module where you can enter in the amount. You should be able to charge your debt payments through this module and it should ask you to classify the interest and principal payments accordingly or similar to the depreciation, you could run an amortization schedule in a spreadsheet and enter in this as a monthly occurring entry (this way is probably not the best method as there is no paper trail).
    I am not sure what a resll on land contract is.

  • Manhattan, NY · Member since 2008 · 801 posts · 61 votes
    17y
    Originally posted by Jeffrey Koenig:
    Is there a tutorial about using it for REI?
    I am in the process of creating an interactive one for a private site. Unfortunately, I can't make it available here. But, I will answer any questions and help here independently of the content on the other site.
    Originally posted by Mark Yuschak:
    Thanks for the replies. Maybe I haven't given QB a fair shot so far...

    To take my question to the next level... What do you for rehabs, specifically? Do you simply log all the receipts for Home Depot, contractors, etc.? Then, how about the initial cost of the property? What is that classified as?

    Let's take it in steps.

    First, a property purchase is entered into an asset account. That is where you record the initial purchase price with a corresponding entry in either a cash account, if you paid cash, or a liability account tracking any financing on the property. Obviously, I am leaving out some of the double entry minutia here but if needed we can get on the phone and walk through it together.

    By definition a "rehab" is a capital improvement that increases the cost basis of the asset. Home Depot and the others are vendors who will give you invoices or receipts. The payments will be applied to the property asset account as a debit, increasing the balance.


    Loans you owe are liability accounts joined at the hip to the property asset account. Well, not really, but double entry accounting makes it act that way. The interest is an expense account as well as things like PMI, property taxes, etc. This is where it gets fun. The borrower is setup as a customer and the loan is a job for handling payments and it is also an asset so it ends up in an asset account too. The payments are applied to the appropriate accounts when they are received. Interest ends up in income, principal gets applied to the asset account reducing it and a corresponding entry to track the income part of the principal as income and another entry in the asset account of the property for the part of the cost you recovered in the payment. If you escrow funds for things like property taxes, insurance, etc, then it gets applied to the appropriate escrow account and then entries are made when the actual expenses are paid.

    Set up this way, the reports are actually accurate without adjustment and your CPA will love you.

    By the way, most of the movement between accounts should be setup as memorized transactions so that you just enter the receipt of a payment from your buyer for example and the other stuff flows through automatically.

  • Will BarnardPro Member
    Moderator
    Developer · Santa Clarita, CA · Member since 2008 · 15k+ posts · 10k+ votes
    17y

    Looks like Taz is your go-to guy for assistance in QB.
    QBooks is, IMHO, the best software for RE and any other biz. It is difficult to learn at first as there are many different faucets to it, but if set-up correctly as Taz is describing, it is a wonderful tool. The problem is, many CPA's don't even know who to set it up properly for a real estate biz, so finding one that does is half the battle.

  • Residential Real Estate Broker · Grand Blanc, MI · Member since 2008 · 885 posts · 316 votes
    17y

    Taz, thank you for the detailed reply! Sounds like I just need to spend more time with it. In the worst case....are you for hire for QB configuration?! I can setup a webex or something! :lol:

    What do we have to do to gain access to the tutorial you're authoring? I'd be more than happy to pay for such a lesson.

  • Contractor · Philadelphia, PA · Member since 2008 · 183 posts · 17 votes
    17y

    Mark,

    I hate to admit this but our accounts have gotten so complicated I am no longer qualified to do them. I'm very lucky to have a partner who actually likes these puzzels and computers.

    For the investment property we use GnuCash which is free ware. For the remodeling company we use QB and Goldenseal so as to check these two accounts against each other, and to generate easy project accountings for customers to see.

    We are considering taking on a PT book keeper soon to help with the load. I would always suggest delegating when you can, so you can stick to what you do well.

    Of course you have a CPA look at all the accounts to make sure its kosher and working for you. He/she works with the book keeper to keep it all tuned up.

    Maybe a book keeper is an option for you? Lots of talent looking for work now.

    Best
    Diane

  • Real Estate Investor · OH · Member since 2008 · 4k+ posts · 1k+ votes
    17y

    I am a big believer in the KISS principle. To that end, I run all my income and expenses through a checkbook for each company. Then, it's just a matter of entering the checkbook data into Quickbooks Pro and it's all done.

    For setting up your accounts, I would strongly suggest talking with your CPA. Your CPA should already have a chart of accounts for the rental businesses he/she handles and can assist you in initially setting up the accounts in Quickbooks. Some accountants use account numbers and some don't (I do). There is a standardized numbering system for accounts and your account would probably be happy if your account numbers matched his/hers - just to make things easy and uniform.

    Basically, you should have a folder in your file cabinet with receipts for each of your accounts. For example, you're have a folder for all your deposit tickets and a folder for each of your expense items. It is all very common sense once you understand how it works.

    Good Luck,

    Mike

  • Residential Real Estate Broker · Grand Blanc, MI · Member since 2008 · 885 posts · 316 votes
    17y

    Mike - Yes, I currently have a file folder for each property. Within that is a sub folder for receipts, utility bills (if applicable), etc. At the end of the year I tally up all those expenses and categorize them according to how our accountant requires. I just want to make it all electronic to avoid mistakes.

    Last night I talked to a couple members of the local REIA that I belong to regarding how they keep their books. All of them really like QB. Come to find out on of a different member's spouse has configured QB for several people for a small fee. From what I hear, she's able to configure it to do everything just as I need it. It sounds like I now have my answer! I plan to get in contact with her today.

    How do you guys handle vehicle expenses? Is your vehicle owned by the company or do you record all your mileage if you're using a personal vehicle? I've always recorded my mileage, but even that is becoming a small chore!

  • Real Estate Investor · CO · Member since 2008 · 66 posts · 0 votes
    17y

    Mark - in my other "life" I am an accountant and software consultant (QB proadvisor). Quickbooks will definitely work for RE investing/landlording - it just needs to be set up correctly.

    My advice is find a proadvisor that has experience with RE investors or construction and have them help you with your setup.

    QB is a great software when set up correctly - it is a major pain in the a** when it isn't! And will ultimately cost you more money to get it "cleaned up" at tax time - believe me, I have done it for too many clients!

  • Manhattan, NY · Member since 2008 · 801 posts · 61 votes
    17y
    Originally posted by Mark Yuschak:
    Taz, thank you for the detailed reply! Sounds like I just need to spend more time with it. In the worst case....are you for hire for QB configuration?! I can setup a webex or something! :lol:

    What do we have to do to gain access to the tutorial you're authoring? I'd be more than happy to pay for such a lesson.

    It sounds like you found a great local resource but if it doesn't work out let me know. I charge a flat $100 to review and fix a QB setup for landlords.

  • Real Estate Investor · Baroda, MI · Member since 2008 · 204 posts · 2 votes
    17y

    i use spreadsheets...i got sick of the accounting software and all the info it wanted so I enter every receipt onto a master data file and extract what i need, when i need it.

  • Manhattan, NY · Member since 2008 · 801 posts · 61 votes
    17y

    The advantage an accounting system has over spreadsheets is up to date reporting.

    How long would it take you to pull your spreadsheets together to give a complete balance sheet of your operation? It takes me about 10 seconds in QuickBooks.

    If you do your own taxes, which I do then have them reviewed by my accountant, TurboTax will import the data from QuickBooks and if you have it set up correctly for your entity, it will put it on the right tax lines GUARANTEED. Can't get that from a spreadsheet.

    BTW, I am not discouraging your use of spreadsheets to run your company. If it works for you, great. I'm just pointing out the benefits of a real accounting system go way beyond just tracking income and expenses.

  • Rental Property Investor · Oakley, MI · Member since 2008 · 15 posts · 0 votes
    17y

    Check out www.landlordaccounting.com

    I purchased the software for $99. It comes with a pre-loaded sample "company" set up. You follow the template, use the chart of accounts to set up your own accounts and customize it. The PDF instruction books walks you through examples of every kind of transaction you're talking about.

    I have 2 rental properties and am currently working on 2 rehab projects. Pretty slick, run reports by property, keep track of loans, keep track of bills due, send rent invoices, etc.

    If you're familiar with double entry accounting and already know how to run QB, this has worked for me. Send me an email, we can hook up and I will let you preview the 200 page instruction book that comes with it.

  • Lincoln, NE · Member since 2008 · 249 posts · 46 votes
    17y

    Is anyone else here using this landlordaccounting program? And about the QB-PRO ...how much does it cost?

  • Residential Real Estate Broker · Grand Blanc, MI · Member since 2008 · 885 posts · 316 votes
    17y

    Mark D. is using the landlordingaccounting program. I'm checking into it and will likely buy it since the lady from the local REIA isn't responding...

    The retail price of QuickBooks Pro 2009 is about $150.

  • Manhattan, NY · Member since 2008 · 801 posts · 61 votes
    17y

    The stuff from landlordaccounting.com is very good. I have recommended them many times.

  • Boonies, PA · Member since 2008 · 333 posts · 15 votes
    17y

    I use Quiken Home & Business. I picked it up on Ebay for $30 shipped. Any new software is confusing to me. My Millage is on an Excel sheet.

    If I remember right my local SBA or College offered QB classes. not sure of the price.

    Hope this helps some.

  • Select a State · Member since 2009 · 156 posts · 17 votes
    17y

    I use QuickBooks Pro at work. One of my goals is to use QuickBooks for myself and my wife's very small rental business starting this year. I am in the middle of setting everything up so I thought I would try to contribute here and maybe get soem help too.

    I searched and searched the interent for a free and useful template on how to set up a buy and hold landlording real estate company, I never found one that is free, but there are some books that you can buy. Since we only have 4 units, I can't justify spending $$$ on a book right now.

    What I did find was several troubleshooting questions and answers. Getting started seems to be the hardest part. The following three items may help get you started. I cannot verify that these steps are the best way for you to set up your own books. It would be nice if an expert verified these steps here.

    1) Set up one company for every LLC you own. If everything is in your name, just set up one company.
    2) Customers are not tenants, they are...... APARTMENTS (each unit is its own customer).
    3) Tenants are JOBS.

    Ok so I haven't gotten very far with this other than setting up the tenants and units as i described above. I'll continue to work on this and if I can find anyhting else that might helpful I will pass it along. Hopefully someone will correct me if I am wrong or add more to the list. Maybe we can cooperatively come up with a informal guide.

    Here is my next set of questions to figure out/get answered:
    1) Set up a monthly recurring invoice for each unit/job.
    2) Make/use a system of which payables fall into which accounts so I can accurately evaluate properties and/or units over time.
    3) I think class tracking is used to track each Property. Need to verify this.
    4) Whether interest and principle need to be charged to different accounts for each property.
    5) I have a foggy idea of how to set up depreciation. Need to figure that one out.

  • Manhattan, NY · Member since 2008 · 801 posts · 61 votes
    17y
    Originally posted by Kirk Beckley:
    1) Set up a monthly recurring invoice for each unit/job.
    You do this with memorized transactions. You can also have late payments apply automatically as well.
    You do this with classes.
    Classes let you group things for easy reporting a data mining.
    You mean interest you pay on the mortgage? Or interest a buyer pays to you as a note holder? Principal will apply to the asset account tracking the note you owe or hold, interest will track to either interest paid as an expense or received as income.
    You will need an accumulated depreciation sub-account for each property.
  • Real Estate Investor · Amarillo, TX · Member since 2008 · 173 posts · 15 votes
    17y

    Quick question to follow an earlier reply, How do you settle the chart of accounts after a home is sold?
    How is closing costs, warranty, fees, etc associated and used in the chart of accounts?

    Thanks for any info.

  • Investor · Round Rock, TX · Member since 2010 · 8k+ posts · 4k+ votes
    16y

    When our portfolio got around 18 units we just let our accounting firm take care of the books. There isn't a hand off come tax time and life is much easier. It isn't cheap to do it this way, but it is worth it IMO...especially if you ever have to defend an audit.

  • Landlord · Seattle, WA · Member since 2010 · 3k+ posts · 1k+ votes
    16y

    QuickBooks can work very well for the average real estate investor. It can easily handle multiple properties and track income and expenses for multiple units at a property. Once QuickBooks is setup it can be fairly easy to record day to day transactions.

    If QuickBooks is not setup right it can be quite a mess and digging information can be a challenge.

    I work with many construction companies, property managers and other real estate related clients and would not always recommend QuckBooks, but would often recommend it. The size of your business makes a difference, the information you need makes a difference, how you invest in real estate can make a difference.

    In my opinion QuickBooks is cumbersome for inventory unless the inventory item count is not to large and doesn't change to often.

    QuickBooks can track work orders but doesn't do a great job again it goes back to QuickBooks poor handling of inventory IMO.

    I currently use QuickBooks for many companies and have used it for many years. I have also used many other accounting programs some of which were designed specifically for property managers and contractors.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.