How To Set Up Rental Properties In Quickbooks Online

This mail will walk you through everything you demand to know to ready upwards QuickBooks for rental properties:

• Understanding the HUD-1 settlement sheet
• Setting up your rental property in QuickBooks
• Making the journal entry in QuickBooks

Later on purchasing an investment property, one of the virtually confusing parts of setting upwardly that belongings in QuickBooks is correctly recording the information that is contained on the HUD-1 Settlement Canvass. Typically, whatever real estate transaction is going to include a HUD-1 which details the transaction for both the heir-apparent (referred to equally the borrower on the HUD-i) and the seller.

For every real estate investor, properly accounting for the items included on the HUD-one argument is disquisitional. The HUD-1 includes all of the information necessary to properly become your new property set up and established in your accounting system. I'k going to show you lot the steps I take in guild to complete this task accurately. Let's go step past step through a real transaction.

One quick notation: This commodity was written based on using QuickBooks Desktop Pro for Windows. FYI, that's an Amazon Affiliate link — if you click on information technology and brand a purchase, a little flake of money comes back to me to aid keep this site going. Unrelated, I 100% recommend using and learning QuickBooks!

Understanding the HUD-i Settlement Sheet

The start thing nosotros need to do is walk through the HUD-1 so that nosotros sympathize exactly what is represented on this grade. Later we go through the grade, we'll have a look at how to brand the appropriate entry into our accounting system.

Here's an example of a real life HUD-one from a transaction that I participated in:

Every bit y'all tin can see, at that place is an awful lot of data included on the HUD-i. The heir-apparent's transaction is detailed on the left side of the form, and the seller'southward transaction is detailed on the right side of the form. Let's go through this transaction as the heir-apparent, which was true when I completed this transaction.

The commencement affair we notice is the gross amount due from the borrower. This number represents the amount of money that the heir-apparent needs to bring to the deal, before bookkeeping for whatever credits or amounts paid on behalf of the borrower.

This amount comprises several items, the bulk of which is the contract auction price, or the amount that was agreed to as the sales price for the property. After all negotiations, this is the final price that was agreed to past the heir-apparent and seller. In this case the price was $48,000. In addition to the contract sales price, whatever personal belongings that the heir-apparent is paying for (if furniture was included in the bargain, for example) would be detailed here, besides as whatsoever settlement charges that the buyer is paying — nosotros'll talk more about these later. Additionally, the buyer is responsible for reimbursing the seller for any items that the seller paid in advance. This is typically some sort of pro rata reimbursement for property taxes that the seller has paid. If the seller paid the full twelvemonth's taxes, the seller gets reimbursed for the portion of the yr which s/he will non own the belongings — the portion of the yr after the sale closes.

Using our real life case, the total gross corporeality of money I was required to bring to this deal was $50,662.79 — this is shown on line 120, here:

To recap, that amount includes the $48,000 sales price, the $817.08 in taxes I reimbursed to the seller, and $ane,845.71 in settlement charges that I paid.

Now, if we take a look at the seller'due south side of the transaction, nosotros'll come across a gross amount due to the seller of $48,817.08. This represents the contract sales price plus the reimbursement for taxes that the seller paid in accelerate. Here's what that looks similar:

So, at this indicate, we've established the gross amounts for the buyer and the seller. The heir-apparent in this transaction is required to bring $50,662.79 to the table (before bookkeeping for any credit) and the seller will receive $48,817.08 (before accounting for any reduction in the amount due to the seller). The difference between those amounts represents the total amount of settlement charges being paid by the buyer. Let'southward take a closer look at those charges now.

The $ane,845.71 in settlement charges being paid past the buyer largely consists of items such as recording fees, title insurance, transfer taxes, etc. These items are detailed on the second page of the HUD-ane, which yous tin see above. In this case, I was responsible for paying the following settlement charges:

• $500 for a broker's commission
• $698.96 for title insurance
• $166.75 in recording charges
• $480 for transfer taxes

At this point, we've essentially cleared all of the items represented in the Gross Amount Due from the Borrower and Gross Corporeality Due to the Seller sections of the HUD-1.

Now let's have a look at the amounts that affect the cyberspace amounts that are due from the buyer and due to the seller. These can be found in the 200 and 500 sections of the HUD-1:

Allow's showtime with the buyer's side of the transaction. These numbers effectively reduce the amount of money that the buyer is required to bring to the tabular array for endmost.

The first item to note is the earnest money amount. This is oft chosen a deposit or manus money. This amount is deposited with the broker when an offer is fabricated on a property and is used to essentially show good organized religion on the part of the buyer. When a buyer makes this deposit, the amount remains on the heir-apparent'south residue sail as an asset, it has but shifted from cash in a checking business relationship to money on deposit with the broker. This is an important point to recollect when we talk about making the entry in QuickBooks. For at present, it's important to know that the heir-apparent has previously given this coin to the banker — so at present at the closing table, this amount is credited to the buyer against the total amount required to bring to the closing. In this example, I fabricated a $one,000 hostage coin deposit and so at endmost I am being credited back that $one,000.

The next amounts beingness credited dorsum to the buyer are under the heading Adjustments for Items Unpaid past Seller. The buyer is responsible for paying all bills that are received after closing. In this department, the seller is reimbursing the buyer for charges that have been incurred merely did not yet require payment — this includes items such every bit partial twelvemonth's real manor taxes, any monthly bills, etc.

In our instance, the seller is reimbursing to the buyer the post-obit amounts:

• $26.73 for city/town taxes
• $xv.80 for county taxes
• $6.69 for annual assessments
• $515 for the tenant'due south security deposit the seller was holding
• $356.45 for a partial month's rent

These items total to $920.67. Taken in conjunction with the $1,000 earnest money deposit, I was credited back $1,920.67 which reduced the total corporeality of money I was required to bring to the endmost from $50,662.79 to $48,742.12.

If we accept a wait at the seller's side of the transaction, we'll notice several entries which similarly reduce the amount due to the seller. Much similar the buyer, the seller pays settlement charges related to the transaction. Typically, the seller pays the majority of these charges, and that is truthful for this transaction. The seller is paying a total of $5,771.31 in settlement charges, broken out as follows:

• $iv,200 for committee
• $150 for closing fee
• $200 for certificate prep
• $twenty for notary fee
• $110 for lien messages
• $15.50 for overnight post
• $480 for metropolis/county/stamp tax stamps
• $595.81 for a home warranty

The seller in this case also had an outstanding mortgage in the amount of $31,828.20, so this farther reduces the amount of money the seller volition receive. The side by side item nosotros see is the same $1,000 hostage coin deposit that showed upward on the buyer'south side. Afterwards this is a number of adjustments nether the heading Adjustments for Items Unpaid past Seller which mirror the items from the buyer's side — these entries substantially transfer these amounts from the seller to the buyer.

All told, the amount due to the seller was reduced from $48,817.08 to $9,296.xc. So fifty-fifty though they sold the house for $48,000, the seller walked away with less than $10,000 afterwards closing on the sale.

Ok. Tired yet? That was a lot of data just it'south important to understand what's happening on the HUD-1 statement and so nosotros can properly record it in QuickBooks.

Setting up your rental property in QuickBooks

Let's talk about QuickBooks now and how to make this entry.

We are going to enter all of this data on ane journal entry, but before we can do that we'll want to make certain nosotros have our holding set up in the system.

The first thing to exercise when setting upwardly the holding in QuickBooks is to create the needed account. More often than not speaking, a handful of fixed asset accounts volition need to exist set up for the belongings. In my case, I established the post-obit accounts:

• Real Estate Assets – this is a stock-still asset business relationship with sub-accounts for each property.
  • A edifice fixed asset sub-business relationship
    • A toll stock-still asset sub-account for the edifice
    • An accumulated depreciation stock-still asset contra account for the edifice
  • A country fixed asset sub-account
    • A fixed nugget sub-account for the land specific to the property

That might audio confusing, so let's look at what this actually looks like in QuickBooks. Open QuickBooks and press CTRL + A to open the Chart of Accounts. Here'due south what these accounts look like in my Chart of Accounts:

As y'all tin can see, the Total Real Manor Assets accounts encompasses both improvements (building) and state. It is necessary to interruption out the building from the state because the land associated with a rental property is not depreciable. The building will exist depreciated over a period of 27.v years, but the state cannot be depreciated and must be held on the balance sheet at toll.

The other main betoken I'd like to make most setting up the rental property in QuickBooks is about using classes equally a way to provide property-specific reporting. Here'south how to create classes in QuickBooks:

Click on the Edit menu and the select Preferences. That volition bring up a window that looks similar this:

Click on the "Company Preferences" tab. In the Class section, cheque the box adjacent to "Use class tracking for transactions". I besides like to cheque "Prompt to assign class". That way, if I forget to assign a class, the program will prompt me to do so.

Next, you'll need to go to the Lists and select Class List:

This volition bring upward the Form List dialogue box. When this box appears, printing CTRL + N to enter a New Class. You should see the post-obit box:

At this point simply blazon the name of the class and click OK. This will create the class in QuickBooks. Now the next time you make any entry related to that course, in this example our class is a specific property, brand sure that you lot include that grade in the expense entry. This volition permit y'all to run class-level, specific reporting. Trust me, it'due south a super handy feature and you'll be glad you set information technology upwards from the beginning.

Now that we have our accounts set up up and have established a form for the property in QuickBooks, information technology'south time to become to the point: how am I supposed to make this entry into QuickBooks to properly tape all of the activity on the HUD-1 settlement canvass? Let's talk nigh how to make the journal entry.

Making the journal entry in QuickBooks

Now we've finally come to the heart of the matter: how do nosotros record all this information in QuickBooks? Get ready to brand friends with the journal entry.

To beingness making this periodical entry, click on the Visitor menu and then select "Brand Full general Journal Entries". This will bring up a window that looks like this:

This journal entry window is fairly simple only includes all of the items we need to make certain the HUD-one gets recorded correctly. In order to assistance make the process a picayune more than understandable, let's await at the actual periodical entry I completed to record the HUD-1 for the buy nosotros've been discussing:

Looking at this periodical entry from left to right, the first thing we find is the list of accounts that are impacted. There are seven accounts in total that are impacted in some manner by this single journal entry. Nosotros've already discussed some of these accounts when nosotros talked about setting upward QuickBooks for rental properties higher up (land, edifice, etc.). The other accounts we have non explicitly discussed, but similar accounts will probable need to exist established (operating account, taxes, security eolith, etc.). Some of these will be asset or liability accounts, some will be income or expense accounts. The first one to talk almost is the checking account.

We'll talk virtually debits and credits in another postal service, but for today y'all need to understand that the checking account is an nugget account and that asset accounts are increased with a debit entry and decreased with a credit entry. The credit entry for $48,742.12 exactly matches the amount from the HUD-1 that was owed from the buyer. This is the money that I brought to the endmost. In this entry I am recording that coin leaving my checking account.

The adjacent three entries are likewise existence made to nugget accounts: land, buildings, earnest money deposits. We are debit the land account in the amount of $9,200. This amount was taken from the county assessor's website. You lot'll need to make up one's mind how yous want to get in at a fair value for the land portion of your existent estate. Using the assessed amount from the county is i reasonable approach. The building account is beingness debited in the amount of $41,462.79. This amount includes the purchase toll less the amount for land, as well every bit some other initial expenses that tin can be included in the toll of the building and depreciated over the same 27.v year period. More on that in another post.

The last entry to an asset business relationship is a credit for $one,000 to the earnest money deposit account. If you'll recollect earlier, I mentioned that we made a $ane,000 eolith for earnest coin, or manus money. This money was held in trust by the broker until closing. When that money left my checking business relationship and went to the banker, I credited my checking account for $1,000 and debited the earnest money account for $1,000 – this created a balance of $1,000 in the earnest money account on the balance sheet. Past crediting the earnest money account for $1,000 here, I am recognizing that the money has left my balance sheet and gone to the seller – I've zeroed out the account on the balance sheet.

Adjacent we see three credit entries for tax expenses. These might look a footling funny, after all a credit entry decreases an expense account. But if you recall from the HUD-one, I received credit from the seller for these tax expenses. Past credit the tax expense account, I am recognizing that "income". Essentially, we are showing a negative expense. Later on in the year when I pay the full tax corporeality, the cyberspace is what my property tax deduction should exist.

After the tax entries, there is an entry to credit the security deposits held account. Security deposits are a liability and liability accounts are increased with a credit. So this entry increases the security deposits liability on the remainder canvas.

Finally, we have a credit to increase the rental income business relationship by the corporeality received from the seller for part of the month.

There yous have it! Y'all should now have a basic understanding of how to sympathise a HUD-1 settlement sheet, how to prepare up QuickBooks for rental backdrop, and how to make the journal entry to record the information on the HUD-1. Every situation is unique and each purchase volition be a little flake different, merely this should allow you lot to have a solid foundation.

Source: http://sundrymiscellanea.com/quickbooks-for-rental-properties/

Share this post