Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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:
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!
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.?
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:
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:
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!
Thank you!
Thank you! I will try that. I figured out another solution before I saw this but will try this out too.
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here