How to Use QuickBooks Online to Record a HUD 1 Final Settlement Statement

Рет қаралды 36,952

8 жыл бұрын

I can get you 50% off QuickBooks online for the first year.
Sign up here → quickbooks.intuit.com/partner...
Index
1:40 Checklist for entering a Hud 1
2:30 Start of Video on sample file
3:23 Settlement with hard money loans not bank loan example
4:00 Quick create plus sign to journal entry to enter debits and credits
5:27 Break up the settlement charges
5:50 Start with loan fees
7:00 Add lines to journal entry to add in loan fees
7:27 Add in the chart of accounts for it
8:00 Adding a fixed asset, home price, and subcategory
8:53 Next section to add in to journal entry is interest expense
9:12 Adding in the chart of accounts for interest expense
9:24 Title charges, add them into journal entry
10:24 Recording fees, government charges adding into journal entry
10:53 Additional settlement charges
11:04 Assignment fee 22,000 , an additional amount that goes to the purchase price
11:46 Off by $10 in the journal entry, so Seth auditing his work
13:00 Adding into Escrow Deposits
13:28 Changed location tab in the journal entry to property, or you can add the property
address to the customer
14:16 Property tab can only be assigned to one level globally, can't be split
15:32 How does the fees get offset in the entry, in the bank account
16:15 Should not be doing journal entry on bank accounts, instead Escrow Deposits
17:08 Recording a check to Escrow Deposits for the 49.55
18:07 Adding a bank deposit, putting it to the Loan Escrow
20:17 Overview of the recording of check and deposit on the transaction report
This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Nerd Enterprises, Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Nerd Enterprises, Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Пікірлер: 52

@juannegrete4029 3 жыл бұрын

You are amazing I was struggling and stressing so much in my work because I couldn’t understand this I’m an accounting intern with only taking two accounting classes so you helped immensely

@nerdenterprises 3 жыл бұрын

Thank you so much! I am so glad this helped!

@denisesnapology3296 2 жыл бұрын

Thank you! This is great!

@graceh3701 7 жыл бұрын

Hi Seth, Thanks for the HUD 1 help. How would I go about recording a HUD Real Estate Sale of the same property in Quickbooks? For example, we purchased the property through a hard money lender, I inputted the journal entry for the purchase settlement statement. Now I need to have my balance sheet show the sale of that same property. I work in home flips. Help!

@christinpriceeacpb6443 7 жыл бұрын

You mentioned that you would make the checklist available for download. Where is that check list available at?

@edenpagani1243 4 жыл бұрын

Thank you I have I client that has 35 huds on 1 year. Thank you for the GJE. Do you teach QB? I'm doing this in Excel. Yikes!

@user-qg9kg8on6n 9 ай бұрын

Thank you for this video it really helped me. I am a student. I have a question on the Hud Paid for by seller how do I journal commissions paid by seller. Would it go under misc. expense and offset with Accumulation Depr.? thank for any advise you can give.

@thetaxadvisors7382 4 жыл бұрын

Great video! It was extremely helpful to see your approach and hear your thought process. A few quick technical question... Is their a reason the fees / costs associated with the loan are not capitalized and amortized over the loan's life? It looks like you are taking these costs directly to expense. Also, should the title / recording fees adjust the asset's basis? It looks like these fees are also being recorded as expenses. I am using IRS pub 527 (Residential Rental Property) as guidance. You mentioned that the property is being treated as inventory not investment property. Is that the reason behind taking these costs as an expense when incurred? If the property is treated as inventory, I was under the impression that the uniform capitalize rules would require direct costs (i.e. materials, labor, direct carrying costs, etc.) and a portion of indirect costs (i.e. administrative costs like business insurance, rent, repairs, taxes, utilities, interest, etc.) to be capitalized until the property is placed into service (IRS Pub 551, 535 & 538). Once placed into service, the costs would be picked up through depreciation. Thank you again for taking the time to make make this video and addressing these questions / comments. PostScript Starting in 2018 I believe the latest IRS guidance noted that business with $25 million or less in average gross receipts for the proceeding three years are now exempt from the uniform capitalization rules. If this is true, would it now be appropriate to expense the loan and other settlement costs as incurred or should the loan costs still be amortized and only the settlement costs expensed? I would appreciate your thoughts regarding a tax/accounting position in the unlikely case there was an audit (i.e. materiality, industry best practice, specific tax/accounting guidance, etc.) Finally, it was not clear if you were using a Closing Disclosure (CD) Statement or HUD-1 Settlement Statement & TILA (Truth-in-Lending Act) document. I think the HUD-1 & TILA were replaced by the CD in October of 2015. The CD and HUD-1 are similar in nature but I think sections and the line numbers are a bit different. If you were using a HUD-1, is there anything pertinent on the CD that you would like to highlight?

@nerdenterprises 4 жыл бұрын

Hi! Thanks for the very detailed comment! You are correct. A lot of the costs could be capitalized. Same process as the video shows, just a different account / type that you would use to record these. It's true that the form used is supposed to be the Closing Disclosure. Not much difference. Same information, just laid out a bit differently. Amazingly many title companies are still using the old form. I guess they missed the memo.

@sanjayvideo01 6 жыл бұрын

Thanks for Nice video. Do you have similar for showing when you are selling and balancing out loan, fixed assets

@jamesw.harrellii7298 6 жыл бұрын

nerdenterprises.com/use-quickbooks-online-record-hud-1-final-settlement-statement/

@jbmflooring407 7 жыл бұрын

Thanks for the info. Do you have a video showing the steps for entering a HUD 1 that is a financed construction loan?

@nerdenterprises 7 жыл бұрын

Hi, sorry I don't have that specifically, but a construction loan normally happens after the purchase. If you drew anything down in escrow, then there would be a credit for the amount borrowed. I can help you with construction loans in a 1:1 - new.nerdenterprises.com/consulting

@NOREALESTATEINVESTORLEFTBEHIND 7 жыл бұрын

great explanation on the HUD1, quick question where would the assignment fee be added on the HUD1.

@nerdenterprises 7 жыл бұрын

Hi! That would most likely be under loan fees, or settlement fees.

@ianderama8017 Ай бұрын

Great info thank you for this! btw, how do you add them so fast just by looking at the numbers? unless it's an excel.

@nerdenterprises Ай бұрын

Hey thanks! Not sure what you mean about adding them fast? I key the numbers in from the HUD-1 and you can use your arrow keys to quickly navigate between numeric fields in QBO. So that's how I advance quickly to the next or previous line (with the up and down arrows).

@lauralightlerealtor 7 жыл бұрын

Thank you for this video, it was very helpful! If you pay cash for the property and do not have a loan, what account would you put for the purchase price (or cash due at closing) in the journal entry for the HUD1? Then would you write a check to the attorney's office to show the transaction?

@nerdenterprises 7 жыл бұрын

Two different things. The purchase price, is still the purchase price, regardless of how you paid for it. That part doesn't change. If the amount due at closing was paid in cash, then it's a credit to owner / shareholder / member contributions. You've effectively contributed money into the business by paying cash.

@lauralightlerealtor 7 жыл бұрын

So do I need to create an expense account called "Member Contributions" for this? Or do I use the existing equity account called Members Equity?

@nerdenterprises 7 жыл бұрын

Laura Lightle if anything you'd create an equity account called member contributions.

@themedspaaccountant 6 жыл бұрын

I've read other posts on setting up each property as an asset and create sub accounts for the expenses related to that property. Is that what you did here or you did it differently b/c you used the location feature? Does it matter which way you do it?

@nerdenterprises 6 жыл бұрын

Hi! If you are doing a flip / rehab then that is the way to do it. You still have to be sure about what costs can be capitalized vs expensed - talk to your tax pro about that. Otherwise that is how you should do it. In this video I do have you record the property as a Fixed Asset - that ALWAYS needs to be done that way. Then you can create another fixed asset account for "improvements" to capture the money you spend fixing the place up.

@marissamcgee1399 3 жыл бұрын

I just started doing bookkeeping for a land developer. Do you have a video explaining how to record a shareholder contribution taken from one of his LLCs and deposited into another one of his LLCs?

@nerdenterprises 3 жыл бұрын

Hi! I would treat each one separately. In LLC 1 he records a distribution to himself. In LLC 2 he records a contribution from himself.

@carolynpeppers8339 7 жыл бұрын

Do you have this for QB desktop?

@nerdenterprises 7 жыл бұрын

I don't, but it works the exact same way. In Desktop you click Company, then make General Journal Entries. From there it looks a little different, but works exactly the same. You have your debits and your credits, and accounts etc..

@ramehkhazen2223 2 жыл бұрын

Maybe a dumb question. After inputting the settlement statement using journal entries do I just exclude the transaction that pulls automatically from the online banking records?

@nerdenterprises 2 жыл бұрын

Never a dumb question! If done correctly the transaction you post should match up. In fact if there is banking activity, it usually winds up posting through your escrow account, and that's how the escrow account zero's out.

@sanjayvideo01 6 жыл бұрын

where is checklist document located RestoraHouse one ?

@nerdenterprises 6 жыл бұрын

Hi. See link in the description above.

@keshadiaz886 4 жыл бұрын

How do you go about showing the sale of this property?

@nerdenterprises 4 жыл бұрын

That side of it is a little more complex. Something I generally reserve for 1:1 support, because you have to zero out the assets related to the property (eg) Land, Building, and improvements. Then you have to recapture depreciation, and of course figure the gain / loss on sale.

@mindysheldon5101 7 жыл бұрын

why don't you book settlement fees to COGS since they get added to the basis?

@nerdenterprises 7 жыл бұрын

Mindy Sheldon you could do that. it's all going to figure into your gain or loss on sale. if you want to show them as added to the basis, then on s purchase it should actually go on the balance sheet, not COGS or expense.

@michelecoonce6585 5 жыл бұрын

I am a little confused & I am probably over thinking it but on my hud I received a $45k credit towards my down payment & am unsure of how to enter that entry. Can you please advise

@nerdenterprises 5 жыл бұрын

Hi Michele. It depends on what the credit was for. So if you made a payment into Escrow prior to closing, and the credit is from that, then that payment has to be somewhere on your books. You would book that payment to the Escrow asset account, and then book the credit in your HUD-1 Journal entry through that same account. It will zero out. if the credit is for something like property taxes, then you book it to the property tax expense account.

@michelecoonce6585 5 жыл бұрын

Thank you. The lender gave me a $45k credit towards my down payment for all the work I did on the building prior to buying it. so would that credit go under building maintenance? @@nerdenterprises

@nerdenterprises 5 жыл бұрын

@@michelecoonce6585 Yes, or if it's a lot of money it goes to Improvements (asset), so it increases the value of the building. Check with your tax pro on that.

@jamesw.harrellii7298 6 жыл бұрын

Question...how do you save a journal when the balance sheet does not balance? Example: HARD MONEY LOAN and the Borrower receives a lesser amount of cash after all fees and costs and the seller receives a larger amount of cash at closing. Quickbooks Online will not allow me to Save the journal and view the balance sheet. Am I missing something?

@nerdenterprises 6 жыл бұрын

Yeah, there's always a way to balance the entry. So The difference between the total loan, and the cash received is the fees. So you credit loan payable for the full amount of the loan, debit cash received, and debit fees. The entry should balance that way.

@jamesw.harrellii7298 6 жыл бұрын

Thank you

@jamesw.harrellii7298 6 жыл бұрын

By the way..great videos. I'm a novice but am learning a great deal from the videos.

@nerdenterprises 6 жыл бұрын

Thank you James. That is music to my ears!!!

@shoegum7362 4 жыл бұрын

Why not use classes for property addresses; what advantages of using customer name or location?

@nerdenterprises 4 жыл бұрын

If we are talking about a rental property you can do classes too (different reporting) but you need them as customers so you can post invoices to capture the rents and know who has / hasn't paid rent each month.

@shoegum7362 4 жыл бұрын

@@nerdenterprises sub'd and will check out your site. awesome work and help. thanks

@nerdenterprises 4 жыл бұрын

@@shoegum7362 Thanks! I'm easy to find if you ever have any questions.

@ellaloyola4110 9 ай бұрын

can i have the checklist?

@nerdenterprises 9 ай бұрын

Hey I looked around for it, but it's been so long (apparently) that I can't seem to track it down. I'll keep digging, It has to be in my files somewhere. It's just not where I would normally put it now.