Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Chris_Accounting_20231
Level 1

Partial Security Deposit Refund

I need to zero out a rental security deposit account. Tenant moved out with some damage so I am only doing a partial refund. 

 

I tried doing the credit memo and invoice route for the remaining amount not being refunded, but those two just cancel each other out. 

 

EX: security deposit was $1,000 (sales receipt type from checking account). I Zelled $750 back to the tenant which shows as expense. Created a credit memo and invoice of $250 against this tenant (customer) for the amount that won't be refunded to them. QBO shows all these transaction rows but still has $250 in security deposit account. Please advise on how to resolve correctly. 

 

I watched a few videos where people recommended recording the $250 as income on P&L but that does not make sense to me. Thanks

6 Comments 6
Jelayca V
QuickBooks Team

Partial Security Deposit Refund

Hi there, Chris. The core issue is likely that the original sales receipt incorrectly recorded the deposit as income rather than as a liability, which is why the account won't balance properly.

 

A security deposit from a landlord’s perspective is set up as an Other Current Liability, since it represents money held on behalf of the tenant.  It’s a good idea to review the security deposit account register to ensure that the original deposit, any refunds, and any adjustments are consistently posted to the same account.

 

You'll also want to ensure that the Product/Service item used for the security deposit is mapped to your security deposit liability account. This way, any transactions involving that item will correctly increase or decrease the liability balance as intended.

 

In cases where everything is set up correctly, the balance will only clear when the transactions are properly offset against that same account. If different items or accounts are used, it can result in amounts remaining in the security deposit account. I also recommend consulting your accountant to ensure everything is accurate.

 

To enhance your experience with QuickBooks, our QuickBooks Live Expert Assisted team is available to help you manage your deposits and refunds.

 

If you have further questions, please don't hesitate to reply below. I'm here to help.

Chris_Accounting_2023
Level 2

Partial Security Deposit Refund

Hi @Jelayca V 

 

From what I can tell, the product item, sales receipt, credit memo and invoice all use the same account. 

 

Can you tell from the uploaded screenshot what I'm doing wrong, or are there additional things that would be helpful? I'll share another screenshot in a separate post since the max is one file. These are actual numbers in screenshot rather than the fictitious amounts shared earlier today. 

 

I have two rental deposits (so ignore the $1350). The one I'm asking about now had the deposit of $2,200. I returned 1725 and kept 475 to fix damages. 

 

Thanks

Chris_Accounting_2023
Level 2

Partial Security Deposit Refund

screenshot #2 @Jelayca V 

Chris_Accounting_2023
Level 2

Partial Security Deposit Refund

screenshot #3 @Jelayca V 

BonJulius_G
QuickBooks Team

Partial Security Deposit Refund

Hi, Chris. On behalf of my colleague, I'll be taking over from here. The reason your account did not zero out is that your transactions offset each other in Accounts Receivable. To fix this, create a Non-inventory item, set the Security Deposit account as a liability, assign it to both the income and expense accounts, then record a Sales receipt and an Expense to properly clear the balance.

 

Go to Gear Icon > Products and Services > New Product/Service. Create a Non-inventory item named "Security Deposit" and assign both its income and expense accounts to the Security Deposit liability account. Then create another item called "Return Damages" and assign the appropriate income account. Set the cost value to zero for both items so they will not appear when recording expenses later.

 

Once the service items are set up, create a Sales receipt to record the security deposit collected from the customer and any return damage amount. Then, create an Expense using the same details as the sales receipt.

 

image.png

 

image.png

 

Once you save the transactions, the Security Deposit liability account will be fully zeroed out, and all related amounts will be properly allocated to their respective accounts.
 
If you have questions, feel free to reply. We’re here to help.
Chris_Accounting_2023
Level 2

Partial Security Deposit Refund

Thank you so much for the detailed response and screenshots. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us