cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Ugur01
Level 4

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

Hello,

Customers send money to the real estate agent's bank account to purchase real estate (land, house, etc.), and the real estate agent sends the money to the property owner. In short, it is an intermediary between the seller and the buyer.
How can I categorize money coming in and out of a realtor bank account in Quickbooks? What category should I put it under?
Note: Realtor takes commission separately. There is no commission in the relevant amount.

Solved
Best answer January 31, 2023

Best Answers
Rainflurry
Level 14

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

@Ugur01 

 

Create an Other Current Liability account called 'Escrow - Seller/Buyer' or something similar for these deposits and use that account for the category when you record the deposit of the buyer's funds.  Then, when you pay the seller, use that same liability account as the category on the check/expense entry.  That will increase the liability account when you receive the funds and reduce it when you pay the seller.

View solution in original post

8 Comments 8
Rainflurry
Level 14

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

@Ugur01 

 

Create an Other Current Liability account called 'Escrow - Seller/Buyer' or something similar for these deposits and use that account for the category when you record the deposit of the buyer's funds.  Then, when you pay the seller, use that same liability account as the category on the check/expense entry.  That will increase the liability account when you receive the funds and reduce it when you pay the seller.

Ugur01
Level 4

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

@Rainflurry 

 

Thank you a lot. 

FritzF
Moderator

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

Hello again, Rainflurry.

 

I appreciate you for always sharing your knowledge about QuickBooks. This will definitely help other users as well in the future. Please keep on posting here in the Community.

 

Keep safe and have a great rest of the day.

NoDucksNoRowsJustSquirrels
Level 1

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

what if you are the buyer receiving the escrow account in full just a one-time payment? my CPA said to set it up as a contribution but I am unsure how to do this as I can not find what would be close to something like this. 

ZackE
Moderator

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

Thanks for joining the Community and getting involved with this thread, NoDucksNoRowsJustSquirrels.

 

To verify my understanding, are you trying to record an owner's contribution, capital investment, charitable contribution, or a company-paid contribution to an employee's retirement or health insurance plan?

 

Once I have this information, I'll be able to do further research on my end.

 

I'll be looking forward to your reply. Have a lovely day!

adriennemarkes
Level 1

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

Hello,

Hoping you can help with a slightly different scenario.  I received $2600 from the buyer (placed in escrow acct via journal entry thanks to above instructions).  I will retain $1040 as commission for a lease and send the balance to the owner. 

What is the best way to enter this? I usually use an invoice to bill the owner. On my invoice, lease commission is linked to an income account. How do I clear the escrow account to pay the owner and record the income without recording income twice? See attached screen shots.

Thank you!

Rainflurry
Level 14

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

@adriennemarkes 

 

On the invoice, use the Commission Income Lease item per your screenshot as line item #1.  Then, create a service item called 'Payment From Escrow' or something similar and link that item to the 'Escrow - Seller/Buyer' liability account.  Enter the 'Payment From Escrow' service item as line item #2 on the invoice for -$1,040.  That records the income and reduces the amount in escrow to $1,560 ($2,600 - $1,040) and the invoice is paid.  If the $1,560 escrow balance is due to the owner, write a check for $1,560 and assign the 'Escrow - Seller/Buyer' liability account to the check.  The escrow account is now $0, you have $1,040 in income, and you refunded the owner the balance of $1,560.  Hope that helps.   

adriennemarkes
Level 1

Categorizing Funds in and out of a Real Estate Agent's Bank Account.

This worked perfectly! Thank you so much!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us