Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I’m not really sure how to ask my question. I’m doing a Year End on a rental property and a few of my rental payments are dropping off my report - P&L by class. Each month I create a sales receipt for each tenant for the month and include the class. The type of payment is “rent”. When I receive the payment, I use Make Deposits and apply it to my account. Most show up under the correct class, but the some are being listed as “unclassified”. I can’t figure out what is causing this. There could be something wrong with my “Undeposited Funds” but I have been confused on how that account is supposed to work. I’m not creating Sales Receipts for any other reason other than rents. Tenants are my only customers. This seems more like a Banking question than a Reports question but let me know if I'm wrong.
Any input is appreciated.
Hello, skibumps90.
The amount you see in the Unclassified column are those line items or transactions that QuickBooks can't classify the correct classes for some transactions in the P&L by Class report resulting in unclassified amounts.
To know more about those unsupported transactions, see this article: What transactions are not supported by Profit and Loss by Class in QuickBooks Desktop? From there, you can see transactions that may cause the issue and check what you should do to clean up your report.
Regarding the unspecified amounts on your Profit and Loss, you'll want to classify transactions at the item level, not just the transaction level. In this way, the amounts are reported in their respective classes. You can find more details in this article: Why does my Profit and Loss by Class report have unclassified amounts?
In addition, I've added these articles to learn more insights about creating reports:
Please know that our doors are always open to help you with any QuickBooks-related concern.
The unclassified ones are showing on the Transaction Report, but I'm not sure if they are line or transaction. I will read the articles that you supplied. Thanks!
But 90% of these are reporting correctly and I input the same way every time. So not sure why these few would be different.
So I discovered that the problem deposits have a common issue. On the Customer Balance Detail report all the correct ones have a Sales Receipt with the account Undeposited Funds, and also a Sales Receipt with the account Rental Payment. Then when I make the deposit, the transaction shows as a Deposit with the account Undeposited Funds. On the problem transactions QB isn’t generating the Sales Receipt with the account Rental Payment. See the 9/2022 & 12/2022 transaction I attached as an example. I can’t figure out what is causing this.
Hello, skibumps90.
I appreciate the screenshot you've shared with us. When you make an actual deposits, we make sure we pick the actual bank accounts. QuickBooks uses the undeposited funds as a temporary account or for a specific purpose to keep received payments before you deposit them into the actual bank.
With your case, I suggest to check with your accountant to record this properly and keep your books accurate.
If you don’t have one yet, you can visit our ProAdvisor website to find an expert. They can provide hands-on support from technical and accounting perspectives. Simply enter your city or ZIP code.
Once your transactions categorized, we can now reconcile your account in QuickBooks. We can check out this article: Reconcile an account in QuickBooks Desktop.
For additional resources, our self-help articles contain topics that will guide you on how to handle any payment related-tasks, payroll, banking and reports.
Keep me posted below if you have any clarifications about your deposit or other customer-related concerns. I’ll be glad to assist further. Have a good one.
Thanks. So how are these few recording differently? I pick the actual bank account every time under “Deposit to” in the Make Deposits screen. I reconcile every month so the deposits are going in the correct account. I’m missing what I’m doing wrong, because I do it the same way every time.
In general, once the deposit is made, should the account change from undeposited funds to something else? As you can see from the screen shot, all of my transactions are staying in undeposited funds.
Hi there, skibumps.
Yes, you're correct. Once you make a deposit and selected an account, the transactions under Undeposited funds will move to the new one.
When making a deposit, make sure to select the linked transaction under the SELECT PAYMENTS TO DEPOSIT field.
When you're ready to reconcile the transaction, you can check this reference: Reconcile an account in QuickBooks Desktop.
I'm just around the forum if you need help with the reconciliation process.
What normally should the account change to after the deposit? Is that something I have to set up to make it work going forward?
The linked transaction automatically is selected (checked) when I click on the deposits to make. I can’t sure that is causing any issues. See attached.
Hello there, @skibumps90.
Allow me to chime in on this conversation and share some additional information regarding bank deposits in QuickBooks Desktop (QBDT).
I have read the thread and based on the information you provided, your income has been overstated due to potential duplicate transactions.
With this, I suggest reviewing the sales receipt that was deposited directly under the Rental Payment account. I recommend making sure it is recorded under the Undeposited funds account. After which, link it to the bank deposit or create a bank deposit if necessary.
With this, you'll know if there really is a duplicate in the register. If you found a duplicate, you can go ahead and delete it. You can check your deposits by:
Additionally, I've included an article that'll help you avoid duplicate transactions downloaded in the bank feeds: Add and match bank feed transactions in QuickBooks Desktop.
Keep your post coming if you've got additional questions about deposits in QBDT. I'll be right here to assist you further. Take care.
Thank you for the reply QC. I went through my Deposit Detail report for 2022. I don’t have any duplicates, and every month has been reconciled. I also don’t download my transactions from the bank.
I also ran a report on my Undeposited Funds and everything seems in order to my eye. I attached this report and a couple of pages of my Deposit Detail if you want to look and tell me what I’m not seeing please.
Thanks
Hello there, @skibumps90. I'll point you in the right direction to get this sorted out to complete your tasks inside QuickBooks Desktop (QBDT).
Since your deposits are still not classified after following the recommendation provided by previous representatives, I'd recommend reaching out to our Customer Care Team. They have the tools to check on your end and determine the root cause of the problem. This way, you can classify those deposits and fix your Profit and Loss report. I'll input the steps below to get you going. Here's how:
6. We'll email you a single use code. Enter your code and select Continue.
7. Select to chat with us or Have us call you.
For more details, please feel free to see this page: Contact QuickBooks Desktop support.
Also, I've got you this article to help you keep your current report settings inside QBDT: Memorize a report.
If you wish to create and send reports inside your company, see this page: Set schedule and email information for a memorized report.
@skibumps90, I appreciate you for dropping by here again. If you have any additional QuickBooks-related concerns, feel free to let us know here in the Community. Stay safe, and enjoy the rest of the day!
I’ve been digging into this some more and discovered that this classification problem happens before I make the deposit.
I entered two sales receipts with both having the same classifications. On my P&L the 2nd one shows as not having a classification and I doubled checked the sales receipt and it is classified. The transactions are in my Transactional Detail in the Split column as Undeposited Funds. Neither entry has been deposited at this point. I delete the sales receipt of the 2nd one, and enter a new receipt. This time it shows correctly as classified.
All my tenants sales receipts are staying in undeposited funds, even after they have been deposited.
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