Business Management

5 Steps to Successful Real Estate Accounting for Investing Newbies

Expertise: Landlording & Rental Properties, Personal Development, Real Estate News & Commentary, Business Management, Flipping Houses, Mortgages & Creative Financing, Real Estate Deal Analysis & Advice, Real Estate Wholesaling, Personal Finance, Real Estate Marketing, AskBP, Real Estate Investing Basics
594 Articles Written
real estate accounting header image

The goal of real estate accounting—or “doing the books”—is keeping an accurate record of all the money going in and out of your business. Bookkeeping is a vital task for your real estate business, and there are several benefits to staying organized, such as freedom, legality, and profitability. When you know exactly how your business is doing at any given time, you are able to make better decisions and sleep soundly at night.

Want more articles like this?

Create an account today to get BiggerPocket's best blog articles delivered to your inbox

Sign up for free

You don’t need to be a professional accountant to keep accurate records. Just make sure to begin bookkeeping early before your business gets too big. Your future self will thank you.

Related: Why You Definitely Need a Real Estate Accountant

Why Organized Books Are Essential for Real Estate Investors

Bookkeeping is not the game of real estate itself. It’s the scoreboard and the game film. An organized, timely, and easy-to-use real estate accounting system serves many practical purposes. It helps you:

  • Track key performance measurements like cash flow, profit and loss, and net worth
  • Compare your growth (or lack of growth) from year to year
  • Manage your cash so that you don’t run out
  • Know whether novel business strategies succeeded
  • Analyze which rental properties performed best
  • Prepare for yearly tax returns
  • Save money on tax preparation because your CPA doesn’t bill you for time spent correctly organizing your information
  • Avoid extra time and stress digging up information for an IRS audit
  • Steer clear of IRS tax penalties or back taxes because you can’t defend deductions you claimed
  • Pay all of your bills and financial obligations on time as agreed
  • Raise capital with lenders and partners using real data from your past performance

Good books help you meet your obligations to outside parties—and make better business decisions.

A Quick Breakdown

Before diving into the five steps to successful real estate accounting, let’s cover the basic terminology. The bookkeeping system is divided into two separate buckets.

The books

This is a paper or digital record of all financial transactions coming through your business bank account(s). With everything in one place, you can easily track every transaction by entering your bank statements into the spreadsheet and organizing them. Your spreadsheet might look something like this:

Basic Bookkeeping Spreadsheet For Real Estate Investors

Your “Account” column categorizes each transaction with simple labels. The “Memo” column describes in more detail what the transaction is. This is handy when you have to look back over transactions months or years later. And the “Property” column is self-explanatory—for which property did you incur the expense?

The supporting documents

This paperwork proves or supports all of the financial transactions. It could be:

These two systems are two sides of the same coin, working in tandem. Books without the paperwork mean an IRS auditor may never believe your claimed expenses. But if you have paperwork and no records, you’ll never have a clear, easy-to-understand summary of the financial happenings of your business.

1. Keep Things Separate

The first rule of real estate accounting is keeping your personal expenses completely separate from your business expenses. This not only makes bookkeeping easier but keeps you out of legal hot water. It's a bad idea to commingle personal and business funds—especially if you are using (or plan to use) an LLC or other legal entity. The bank account, savings account, and credit cards should all be separate from personal finances.

Related: Do Landlords Need an LLC for Rental Property?

Also, be sure to have a primary account for travel, memberships, dues, and initial due diligence costs for investing opportunities. Tracking these expenses properly prevents the IRS from taking money it's not entitled to.

Investors with large portfolios: Real estate accounting tips

As you start to invest in more properties, you might ask yourself, “Should I use just one bank account for all my rental properties or one bank account per property?” When you’re first starting out, setting up a bank account for each rental property works wonders.

But as you gain units, you will likely want to begin using one “management” account for simplicity. You don’t want to have to deal with 40 checking accounts when you have 40 properties! However, the bookkeeping becomes a little more time-consuming, as you will still need to run the numbers separately for each property.

Dividing up hundreds (or thousands) of transactions into separate properties takes some additional work. When you get to this point, you will likely want to use a more professional bookkeeping system like QuickBooks or even hire a professional.

However, take note that multifamily properties are considered one property. You may have 20 units, but if that is made up of five fourplexes spread across town, you only need five accounts.

2. Track Receipts

Keep every receipt and designate which property the receipt was for. You can even write the property and the purpose on the receipt. This is not only helpful for deducting the right amount at tax time—and proving to the IRS that you are legit—but it will keep you financially organized.

When you first start, the most important habit is to track and categorize everything, even if it’s through a simple spreadsheet. This builds a firm foundation to expand upon when you choose to get more advanced. You can do this by hand or using Excel or Google Docs. As your business grows, you may consider accounting software.

Related: The Investor’s Complete Guide to Finding & Hiring a Perfect CPA Match

What records should you keep?

All receipts over $75 should be kept per IRS standards—however, receipts do not need to be kept in a hard copy format. Take a photo of the receipt and recycle the paper.

There are two categories we always recommend keeping receipts for, even if the amount is less than $75:

  1. Meals and entertainment
  2. Travel

These two categories are commonly examined during IRS reviews and audits.

3. Itemize Income and Expenses

Every dollar that flows in or out of your business must be categorized and tracked. This is when the aforementioned receipts come in handy. Keep accounting software updated semi-daily as income is received or bills are paid, and make sure you’re using the correct debit or credit card for each property’s expenses.

If you are using a spreadsheet, you may decide to wait until the end of the month to categorize each item—but don’t wait too long. The longer you wait to categorize the dollars going in and out of your business, the greater the chance of error. This is the benefit of itemizing your income and expenses on a regular basis, which is much easier to do with professional accounting software such as QuickBooks or Xero. As you gain more properties, you may even consider hiring an accountant.

When itemizing the income and expenses, it’s best to categorize them in the same categories that the IRS lists on Schedule E, the form you’ll need to fill out each year at tax time. The expense categories that the IRS defines are:

  • Advertising
  • Auto and travel expenses
  • Cleaning and maintenance
  • Commissions
  • Insurance
  • Legal and other professional fees
  • Management fees
  • Mortgage interest paid to banks, etc.
  • Other interest
  • Repairs
  • Supplies
  • Taxes
  • Utilities
  • Depreciation expense or depletion (at BiggerPockets, we call this capital improvements)
  • Other

Typically, finances are tracked on a monthly basis—e.g., January 1 through January 31 and February 1 through February 28. If you are using a spreadsheet, you can simply list the above categories on the lefthand side of the screen and make one column for each month.

4. Reconcile with Your Bank

Compare what should be to what actually is. Again, the goal of real estate accounting is to make the numbers line up perfectly—or “reconcile”—between your bookkeeping and bank account statement. The purpose of bank reconciliation is to double-check everything to make sure your books are accurate. Sometimes banks or businesses mess up and you’ll be charged for things you didn’t buy. You could also get double-charged.

When reconciling with your bank, pay attention to the starting and ending balance of your bank account, which should match your own books. If you started with $1,000 in your account and you received $800 and spent $700, you should be left with $1,100 in your account at the end of the month (because you “made” an extra $100 during the month). This is an incredibly simple example, but the same concept applies no matter the size of your operation.

5. Create Accurate Reports

Lastly, after entering in all this data for the property, you now will be able to generate reports on the success of your property. With professional accounting software, this can be as simple as clicking a button. If you are doing the books by hand, though, you will be slightly limited in the kinds of reports you can generate.

The most common report is a profit-loss statement, which shows all the property’s income streams, expenses, and cash flow. If you are bookkeeping in a spreadsheet, you essentially create the profit-loss statement each month while entering the income and expenses.

These statements provide an accurate snapshot of how your business is running. Want to know how much cash flow your business generated in the past month? You can find that out easily. Perhaps you’re interested in a graph of your expenses over the past three years? A report can show you that trend. Again, unless you are a pro with spreadsheets, this will be much easier using accounting software.

Real estate bookkeeping can seem overwhelming at first, but the process quickly becomes routine. If you don’t feel comfortable doing it or don’t have the time, consider hiring a bookkeeper to help you make sense of everything.

You may also want to sit down with the CPA who will be doing your taxes and have them explain exactly how they want you to do the books to make their job easier. (Plus, organizing your finances however they prefer may make their services cheaper come tax time.)

Easily Distracted? Don’t Feel Bad

Staying on top of your transactions is harder than it may seem. Real estate accounting can be hard, so don’t beat yourself up. Regardless of how meticulous you are, there’s no doubt that you’ll miss expenses. Here are a few tips to help minimize the amount of missed and improperly recorded transactions:

  • Place some sort of indicator on your debit cards to tell you which property it belongs to—like writing the property address in Sharpie.
  • Use self-checkout so that you don’t feel guilty when you check out multiple times at once. You might be buying pipes for your duplex and window sills for your multiplex. Don’t get the two confused.
  • Use a smartphone application to snap photos of receipts and upload them in real-time.
  • If you accidentally pay for an expense out of your personal account, simply transfer money out of the respective rental account and into your personal account. By transferring money from your rental property’s account and into your personal account, you will, in effect, see an “expense” when you reconcile your bank statements at year-end. For the transfer’s memo, input a brief description of what the expense was for.
  • Remind yourself every day via a sticky note or some other indicator to keep track of transactions on an ongoing basis.

What process do you use to keep your records straight?

Comment below!

Brandon Turner is an active real estate investor, entrepreneur, writer, and co-host of the BiggerPockets Podcast. He is a nationally recognized leader in the real estate education space and has taught millions of people how to find, finance, and manage real estate investments. Brandon began buying rental properties and flipping houses at age 21, discovering he didn’t need to work 40 years at a corporate job to have “the good life.” Today, Brandon is the managing member at Open Door Capital. With nearly 300 units across four states under his belt, he continues to invest in real estate while also showing others the power and impact of financial freedom.
    Lauren C. Rental Property Investor from Hamilton Township, NJ
    Replied over 3 years ago
    Great post Brandon! I’m currently rehabbing my first investment property and have been trying to create some sort of book keeping system so this is super timely. Right now, I scan, file and record every receipt and bill but it’s not much more than an excel spreadsheet. Works for me right now, but I can imagine it will become a mess once we start to acquire more units. Thanks again!
    Terrence Moore Investor from Gwinnet, Georgia
    Replied over 3 years ago
    Great Post Brandon! You guys and the entire biggerpockets team rock! I had to take a pause from things because of a major family lost (My Grandma passed) but I recently started things up again and re did the business model (business approach) and now it’s time to go. Look out for me to engage with you all more in the future. Hey, Lauren, Congrats on your ability to start in this exciting world. I have been in real estate for four years and it’s great. Have you considered maybe getting a bookkeeper to handle everything? You can keep up with your receipts and so forth scanning them with the neatdesk tool and then sending them to a bookkeeper to keep up with things. This will help you focus on your best skill set and time spent. Again congrats on what you are doing
    Soh Tanaka
    Replied over 3 years ago
    I think done right, it’s OK to use Excel only for quite a long time.
    Nathan Richmond Rental Property Investor from Visalia, CA
    Replied over 3 years ago
    I need to improve in this area a lot. No excuse when mom is a bookkeeper for a CPA. Lol
    Christy Browning Real Estate Investor from Denver, Colorado
    Replied over 3 years ago
    Thanks for an awesome post! I am delving into Quickbooks for the first time, it is more complicated than I thought. Glad to be getting into it now ahead of tax season. Also, great advice to reach out to our CPA to confirm how they would like things entered.
    Soh Tanaka
    Replied over 3 years ago
    I would suggest to get a “How to use QuickBooks for a real estate investor” type of book. There are several of them out there. It’s very difficult to use QuickBooks without a book like that, but once you have it, it’s pretty nice.
    Michael Lee Investor from Coppell, TX
    Replied over 3 years ago
    You are correct. Thanks for your reminder. I have probably read all of your books. Keep up the good work and honesty. Too many people just want to make more money by misleading others.
    Cathie Kovacs Rental Property Investor from Stamford, CT
    Replied over 3 years ago
    Nice post! As the owner of a remote bookkeeping firm, I only wish more business owners (and REI is a business) understood that bookkeeping is more than just about compliance. You’re supposed to use the financial data to make better business decisions. Aside from that, I’d suggest skipping the Excel spreadsheets. Unless you’re great with Excel, you’re going to have a hard time getting useful financials out of there. Quickbooks now has an online option called Quickbooks Self Employed. I’d recommend giving that a try. It’s ~$10/mo. & is super simple. It even tracks mileage automagically. So while you’re out driving-for-dollars, you might as well get the tax deduction.
    LaVonne Eaton Investor from Phoenix, AZ
    Replied 7 months ago
    Hello Cathie, Does Quickbooks for self employed allow for 4-5 rentals? Thanks, LaVonne
    Dede Heiman
    Replied 7 months ago
    Quickbooks is great! I’ve used it for three Rentals.
    Christi Hawkins from Columbus, Ohio
    Replied over 3 years ago
    Great advice for newbies like me!!! Thank you so much for sharing your valuable experience
    Karen Young Investor from Greenville South Carolina and Lihue, HI
    Replied 7 months ago
    I really like
    Steve Hyzny Investor from West and south of Chicago
    Replied 7 months ago
    I like Stessa and so does my accountant, this is the 1st full year I used it and it made sending my accountant the info so easy. Great for starting out, I have 5 properties and it worked great. FOR FREE its a great tool. I coupled it with COZY.CO to collect rents and saved me tons of work and hassles. Both I learned from BP podcasts. I listen as I travel to my properties to do work. I self manage. Steve
    Sisee Adams Rental Property Investor
    Replied 7 months ago
    Personally, I like Stessa better than Quickbooks.
    Dede Heiman
    Replied 7 months ago
    Exact plan. This is essential for landlords, especially if someone received an EIDL or PPP loan.
    Aaron Smith from Deer Park, WA
    Replied 7 months ago
    Why is it important to have separate debit accounts for each property? I presume it's more for tracking property performance and not so much for tax purposes.
    Brooke Clifton
    Replied 5 months ago
    This article is very helpful. The one thing I’d like to better understand is how to tackle financial contributions from different parties. For example, my mom and I are each putting money into the bank account so that we have cash on hand to use for rehabbing. This isn’t revenue and it isn’t being used for just a single expense. At the end of a project we’d like to be able to clearly see who contributed what so that we can pay ourselves back. Thoughts?
    Amy Grams
    Replied 24 days ago
    I'm assuming you've each contributed those funds as a "capital contribution" to the property. As such, it would be recorded as a credit to the balance sheet, under equity. Equity is essentially the funds you contribute as an owner plus any retained earnings (net profits from the property), less any distributions of profits you've paid to each owner. The balance sheet is called a balance sheet because your assets (in most cases, this would be the cost basis of the property you purchased, plus any improvements made, plus any cash held) equals the sum of your liabilities (any bills owed by the property plus the amount of the mortgage) + equity. I hope that helps!
    Zev J. CPA from Denver, CO
    Replied about 2 months ago
    It depends whether you've loaned to, or invested in your company - which will be an increase to liability or to equity accounts, respectively.
    Nicholas Gallinot Rental Property Investor from Elysburg, PA
    Replied 14 days ago
    I’m wondering what the best system is for our LLC as we own 1 rental and we are currently flipping another property. We plan to work on both types of investments for the foreseeable future. It seems when I get one excel setup figured out for the rental, it doesn’t quite work exactly the same for the flip and vice versa. Has anyone else run into this problem?