cancel
Showing results for 
Search instead for 
Did you mean: 
skibumps90
Level 3

Some deposits not classified correctly.

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.

11 Comments 11
AileneA
QuickBooks Team

Some deposits not classified correctly.

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. 

skibumps90
Level 3

Some deposits not classified correctly.

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.

skibumps90
Level 3

Some deposits not classified correctly.

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.

AileneA
QuickBooks Team

Some deposits not classified correctly.

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.

skibumps90
Level 3

Some deposits not classified correctly.

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.

Adrian_A
Moderator

Some deposits not classified correctly.

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.

skibumps90
Level 3

Some deposits not classified correctly.

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.

QueenC
Moderator

Some deposits not classified correctly.

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:

 

  1. Going to the Reports menu and selecting Report Center.
  2. Select the Banking section.
  3. Find the Deposit Detail report, then select the Run icon.

 

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.

skibumps90
Level 3

Some deposits not classified correctly.

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

Kurt_M
QuickBooks Team

Some deposits not classified correctly.

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:

 

 

  1. Open QuickBooks.
  2. Go to Help, then select QuickBooks Desktop Help/Contact Us.
  3. Select Contact Us.
  4. Give a brief description of your issue, then select Continue.
  5. Sign in to your Intuit account and select Continue and then Continue with my account.
  • If you don't already have an account, make sure to Create a new account.

      6. We'll email you a single use code. Enter your code and select Continue.

  • If you have more than one account, select the account you want to use and then 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!

skibumps90
Level 3

Some deposits not classified correctly.

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.

Need to get in touch?

Contact us