cancel
Showing results for 
Search instead for 
Did you mean: 
Raeka8
Level 2

How can I show old deposits on my tenant balance summary in a new quickbooks account

I'm a landlord and just started using quickbooks last month. I wanted to have my balance sheet show the accurate amount for my tenant deposits and also my tenant  detail and summary reports. So I added the old old deposits to my checking register. But even when I set my dates to last fiscal year, my bank register shows more than it should because its including the old deposits. How do I keep the amounts in my tenant balance summary & balance sheet if I delete them from my bank register?

 

Thank you for any help

6 Comments 6
MarsStephanieL
QuickBooks Team

How can I show old deposits on my tenant balance summary in a new quickbooks account

Welcome to the QuickBooks family, @35476390. I can help you show the balance of your tenant in the balance summary report in QuickBooks Desktop (QBDT).
 

You can enter the invoice individually and match the deposits to record each transaction. Or you can create a journal entry, and collate all the paid transactions with the opening balance of the tenant.
 

Before doing so, I recommend speaking with an accountant to set up the previous transactions and assign them to the correct accounts. It will help you avoid getting issues in the future, especially with the taxes.

 

Here's how to create a journal entry:

 

  1. Go to the Company menu and choose Make General Journal Entries.
  2. Enter the date, amount, and description on each line item. Ensure that the debits equal your credits when you're done.
  3. Click Save or Save & Close.

 

For more details about the first option I've mentioned, you can check out this article: Get started with customer transaction workflows in QuickBooks Desktop.
 

Once you're ready, you can now create a billing statement for your tenant. I've got an article about this process: Create a billing statement.
 

Please don't hesitate to let me know if you have any QuickBooks-related concerns. I'm here to back you up. Take care always!

Raeka8
Level 2

How can I show old deposits on my tenant balance summary in a new quickbooks account

I'm sorry but I don't follow. To be clear, I'm talking about a 2019 security deposit that I want to show on my Tenant Balance Detail report for End of Year 2021. I've reconciled my 2021 bank register and I want to include these old security deposits in my balance sheet and tenant balances. I use cash method of accounting so use sales receipts. (I don't use unearned/earned income accounting). I don't understand why I'd be creating a customer billing statement since this is a security deposit. I will be re-paying her at some point in the future less any deductions. Since I will be paying it out someday, I thought there would be another way rather than entering it as a journal entry.?

RoseJillB
QuickBooks Team

How can I show old deposits on my tenant balance summary in a new quickbooks account

Thanks for getting back, @Raeka8. I’ll help you with recording the security deposit in QuickBooks Desktop (QBDT).

 

To start with, let’s create an item for the security deposit, then link them to a liability account. Here’s how:

 

  1. Go to List from the top menu and select Item List.
  2. On the Item List window, click Item, then New.
  3. Select Service on the Type drop-down.
  4. Enter the Item name and fill in other necessary fields.
  5. On the Account drop-down, select a Liability account.
  6. Click OK to save the item.

 

 

Check out this article for more information about adding, editing, and deleting items.

 

Once done, we can now record the payment by using a sales receipt. Kindly follow the steps outlined below:

 

  1. Go to Customers menu and select Enter Sales Receipts.
  2. Select the tenant on the Customer: Job drop-down. 
  3. Fill in the relevant information at the top of the form like the Date and Sale No.
  4. On the first line item, choose the security deposit.
  5. Enter the amount of the item.
  6. Click Save & Close.

 

 

Refer to this article for reference when creating sales receipts.

 

Feel free to reply if you need further assistance with recording your transactions. The Community always has your back. Have a great day!

Raeka8
Level 2

How can I show old deposits on my tenant balance summary in a new quickbooks account

Thank you!

Raeka8
Level 2

How can I show old deposits on my tenant balance summary in a new quickbooks account

Thank you! I will try that. I figured out another solution before I saw this but will try this out too.

Kevin_C
QuickBooks Team

How can I show old deposits on my tenant balance summary in a new quickbooks account

Hello there, @Raeka8.

 

Thanks for getting back to this thread and for considering the solution provided by my colleague.

 

If you need more information about managing your company, you can seek self-help video tutorials on our video tutorials for QuickBooks Desktop to help you get your QuickBooks tasks done in no time.

 

Please feel free to get back to me here with any additional questions about QuickBooks. We always have your back. Enjoy the rest of the day!

Need to get in touch?

Contact us