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.
impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

My LLC recently sold one of the office condominiums that it has been leasing for the past 20 years. Herein I am asking how to enter this transaction in QB Desktop. Note: for calculation ease and privacy the following are not the actual dollar values. The sale amount is $100,000. The LLC is financing the sale. I would like to enter in QB as an installment sale. The buyer: earnest money $1000; downpayment $10,000; promissory note $89,000; monthly payments of $1000 for 5 years at which time a balloon payment is due. Seller paid real estate commission of $4,000. Accumulated depreciation is $ 25,000. If additional information is needed, please advise. Thank you.

Solved
Best answer September 12, 2024

Best Answers
Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

"1. According to your note you included the commission-paid of $4000 in the "Bank Account" debit entry and also as a "Commission Expense" debit of $4000, is this correct?"

 

Yes, correct.  I mentioned that because I assumed the $4K was withheld from your closing proceeds, thereby reducing the debit entry by $4K ($1K + $10K - $4K), as opposed to a separate $4K credit entry if you had paid the commission separately.  A debit to your bank account is a balance increase in accounting terms.  Unlike how when a bank takes money out of our account, they "debit" it.  Therefore, in accounting, when you credit your bank account, you are reducing the balance.  

 

"I follow all of your entries (except as noted in [1] above). The problem I have is that as you have shown, the "Gain on Sale of Asset" of $69,000 (the real number is much higher) would count as income in 2023; therefore, if I understand correctly, I would have to pay taxes on this total gain with my 2023 tax return. Since this was owner-financed I have not received any cash (other than the down payment), but only a promissory note. Is there a way to enter this transaction so that I pay taxes each year only on the monthly income received during each year from the purchaser as he pays off the loan?"

 

Great question and I should have mentioned it in my post.  The journal entry I gave you is the proper way to record it in terms of financial accounting.  That is different than the tax implications (tax basis) of the sale.  You are correct that the amount financed is not necessarily considered gain from a tax basis perspective since this will qualify as an installment sale.  Your CPA/tax accountant should handle the proper way to record this from a tax perspective.  Based on what you or I know, there is no way to properly record this in QB from a tax perspective at this point.  Most CPAs do not make adjusting entries that take into account the tax implications of the sale.  The gain is booked as per my journal entry and the adjustments are made on the tax return.  Presumably, you have a CPA/tax accountant?  I would not recommend trying to prepare a return containing an installment sale without professional help.  

 

If you prefer, you can change the account name used to record the "Gain on Asset Sale" to "Deferred Gain on Asset Sale".  However, this requires making a journal entry each month or at year-end to move the amount of deferred gain to gain by debiting "Deferred Gain on Asset Sale" and crediting  "Gain on Asset Sale".  That really is not necessary as your tax returns are what matter and it creates more work/more room for errors).  Hopefully, this all made sense.        

 

View solution in original post

Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

"Based on your solution (progress billing for installment sale) how would I remove in QB the condominium as an asset?"

 

The condo asset should have been removed at the time of the sale (see my journal entry above).  The condo's fixed asset account and accumulated depreciation should have been closed at the time of the sale since you no longer own the asset and you needed to remove the asset and corresponding accumulated depreciation to determine the gain.  The nature of the gain (whether deferred or not) is something you should not try to allocate yourself.  It is a calculation based on the gross profit percentage of the sale.  Your CPA will do that.  After you remove the asset and close the accumulated depreciation based on the journal entry above, you just need to allocate the payment received from the buyer to the Note Receivable asset account (the principal portion) and Interest Income (the interest portion).   

View solution in original post

Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

"and then make a journal entry transferring the principal amount paid that month from the "deferred gain on sale of asset" to the "gain on sale of asset" accounts."

 

Not all of the principal balance received is gain.  The amount of gain on the principal portion is determined based on the gross profit percentage of the sale:

GPP Image.JPG

 

 

View solution in original post

14 Comments 14
Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 


What is the original cost of the office condo recorded in the books?  That's the missing piece to complete the journal entry.

SirielJeaB
Moderator

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Thanks for sharing your detailed concern in the Community space, impedance19.

 

I acknowledge the relevance of recording your transactions accurately in QuickBooks Desktop (QBDT). To track the sale of the office condominium, let's utilize the progress invoicing within the program. It allows you to split an estimate into as many invoices as you need because instead of asking for the entire amount, you can invoice customers for partial payments. Here's how:

 

Step 1: Turn on progress invoicing

Step 2: Create an estimate of $100,000

Step 3: Create progress invoices of earnest money of $1,000 and a downpayment of $10,000

Step 4: Receive the payments of each invoice to get an open balance of $89,000.

 

Please note that for the monthly payments of $1,000 for 5 years, simply continue creating progress invoices from the estimate. 

 

For detailed instructions on each step, please refer to this article: Set up and send progress invoices in QuickBooks Desktop.

 

You can set up the real estate as a Sales Rep, then generate a check to record the commission of $4,000. And create a journal entry to track the accumulated depreciation of $ 25,000.

 

I'd also recommend reaching out to your account for further guidance and maintain the accuracy of books.

 

You'll want to remind your customers about their invoice due dates. Check out this article: Send invoice reminders automatically or manually in QuickBooks Online.

 

Just leave a comment below if you have further questions about handling sales transactions. I'm prepared to help you. Have a successful business venture.

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Thank you for replying. The original cost was $50,000. Improvements over the years total $6,000.

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Thank you very much for your comprehensive reply. I will review it and let you know if I have any additional comments.

Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

The journal entry to record the sale is below.  I combined the cash into one $7K debit entry - that total is the earnest money + down payment - commission paid.  You may need to break out the $7K into separate debits depending on how you received funds at closing/received the earnest money for reconciliation purposes.  Also, I combined the asset credit into one $56K entry which includes the original cost plus improvements.  If you have separate asset accounts for the improvements, you will need to enter the original cost and improvements as separate credits.  There is no entry to be made for payments on the loan until they are received.  

 

 DebitCredit
Bank Account 7,000 
Note Receivable89,000 
Accumulated Depreciation25,000 
Commission Expense4,000 
     Fixed Asset (to remove original cost and improvements) 56,000
     Gain on Asset Sale  69,000

 

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Rainflurry, thank you very much for your response. I have a couple of follow-up questions:

1. According to your note you included the commission-paid of $4000 in the "Bank Account" debit entry and also as a "Commission Expense" debit of $4000, is this correct?

2. I follow all of your entries (except as noted in [1] above). The problem I have is that as you have shown, the "Gain on Sale of Asset" of $69,000 (the real number is much higher) would count as income in 2023; therefore, if I understand correctly, I would have to pay taxes on this total gain with my 2023 tax return. Since this was owner-financed I have not received any cash (other than the down payment), but only a promissory note. Is there a way to enter this transaction so that I pay taxes each year only on the monthly income received during each year from the purchaser as he pays off the loan?

 

Thank you!

Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

"1. According to your note you included the commission-paid of $4000 in the "Bank Account" debit entry and also as a "Commission Expense" debit of $4000, is this correct?"

 

Yes, correct.  I mentioned that because I assumed the $4K was withheld from your closing proceeds, thereby reducing the debit entry by $4K ($1K + $10K - $4K), as opposed to a separate $4K credit entry if you had paid the commission separately.  A debit to your bank account is a balance increase in accounting terms.  Unlike how when a bank takes money out of our account, they "debit" it.  Therefore, in accounting, when you credit your bank account, you are reducing the balance.  

 

"I follow all of your entries (except as noted in [1] above). The problem I have is that as you have shown, the "Gain on Sale of Asset" of $69,000 (the real number is much higher) would count as income in 2023; therefore, if I understand correctly, I would have to pay taxes on this total gain with my 2023 tax return. Since this was owner-financed I have not received any cash (other than the down payment), but only a promissory note. Is there a way to enter this transaction so that I pay taxes each year only on the monthly income received during each year from the purchaser as he pays off the loan?"

 

Great question and I should have mentioned it in my post.  The journal entry I gave you is the proper way to record it in terms of financial accounting.  That is different than the tax implications (tax basis) of the sale.  You are correct that the amount financed is not necessarily considered gain from a tax basis perspective since this will qualify as an installment sale.  Your CPA/tax accountant should handle the proper way to record this from a tax perspective.  Based on what you or I know, there is no way to properly record this in QB from a tax perspective at this point.  Most CPAs do not make adjusting entries that take into account the tax implications of the sale.  The gain is booked as per my journal entry and the adjustments are made on the tax return.  Presumably, you have a CPA/tax accountant?  I would not recommend trying to prepare a return containing an installment sale without professional help.  

 

If you prefer, you can change the account name used to record the "Gain on Asset Sale" to "Deferred Gain on Asset Sale".  However, this requires making a journal entry each month or at year-end to move the amount of deferred gain to gain by debiting "Deferred Gain on Asset Sale" and crediting  "Gain on Asset Sale".  That really is not necessary as your tax returns are what matter and it creates more work/more room for errors).  Hopefully, this all made sense.        

 

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Hi Rainflurry,

 

Thank you very much for your answers. I need some time to process your comprehensive answer to my second question including a discussion with my tax attorney (who is unfortunately in the process of retiring). I will either get back to you with more questions or "Accept" your solution. Either way thank you very much for all your help. 

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Based on your solution (progress billing for installment sale) how would I remove in QB the condominium as an asset? That is, if this were a full sale (vs installment), using a journal entry I would debit the "checking" account and "buildings accumulated depreciation" account while crediting the asset account "buildings costs" and the income account "gain/loss on sale of assets". So I am not sure how to do this when payments from the buyer come in monthly versus all payment up front. Would I make a journal entry each month as the payments come in?

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Based on your solution (progress billing for installment sale) how would I remove in QB the condominium as an asset? That is, if this were a full sale (vs installment), using a journal entry I would debit the "checking" account and "buildings accumulated depreciation" account while crediting the asset account "buildings costs" and the income account "gain/loss on sale of assets". So I am not sure how to do this when payments from the buyer come in monthly versus all payment up front. Would I make a journal entry each month as the payments come in?

Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

"Based on your solution (progress billing for installment sale) how would I remove in QB the condominium as an asset?"

 

The condo asset should have been removed at the time of the sale (see my journal entry above).  The condo's fixed asset account and accumulated depreciation should have been closed at the time of the sale since you no longer own the asset and you needed to remove the asset and corresponding accumulated depreciation to determine the gain.  The nature of the gain (whether deferred or not) is something you should not try to allocate yourself.  It is a calculation based on the gross profit percentage of the sale.  Your CPA will do that.  After you remove the asset and close the accumulated depreciation based on the journal entry above, you just need to allocate the payment received from the buyer to the Note Receivable asset account (the principal portion) and Interest Income (the interest portion).   

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Got it. Looks like this works. Thank you! That is, I followed your earlier example showing a completed sale. As you suggested, I added both a "gain on sale of asset" and "deferred gain on sale of asset" account. So now for monthly payments I record the payment in the proper amounts (under "interest income" and "promissory note receivable") and then make a journal entry transferring the principal amount paid that month from the "deferred gain on sale of asset" to the "gain on sale of asset" accounts.

Rainflurry
Level 14

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

@impedance19 

 

"and then make a journal entry transferring the principal amount paid that month from the "deferred gain on sale of asset" to the "gain on sale of asset" accounts."

 

Not all of the principal balance received is gain.  The amount of gain on the principal portion is determined based on the gross profit percentage of the sale:

GPP Image.JPG

 

 

impedance19
Level 2

How to Enter in Quickbooks Desktop Sale of an Asset with Owner Financing and Promissory Note

Thanks for the reminder. As I calculated and TurboTax confirmed, my gross profit percentage is 67.9%.

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

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up