Unmatched Deposits are automatically showing as Sales on P&L

Hello Jonathan, let's correct the double income showing in your report.

QuickBooks Online and QuickBooks Desktop Enterprise are two different platforms. Each product has features and ways of handling the data recorded within the program. We expect to experience a few changes in the transactions, accounts, and other information after switching from QBO to QBDT. Here's an article for more details: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

We can fix the unmatched deposit by reassigning it to the correct category. By doing this, the Profit & Loss report will show accurate data. Here's how:

1. Go to the Lists menu.
2. Select Chart of Accounts.
3. Double-click on the bank account to see the register.
4. Find the downloaded transaction. Note: You can use the Find command tool to see the transactions easily. Just click the Go to button at the top left, then enter the desired filters. Click Back or Next to locate them.
5. Double-click to Edit the transaction.
6. Change the category or account to the appropriate one.
7. Hit Save & Close.

We can use these resources for guides when reconciling accounts and keeping our bank transactions accurate from time to time:

• Add and match Bank Feed transactions in QBDT.
• Reconcile an account.

Lastly, we can visit this article to learn other ways of recording customer transactions within your company file: Get started with customer transaction workflows.

If you need more help correcting details recorded from QBO to QBDT, please let me know by posting another one below. I'm always here if you have any other concerns related to QuickBooks. Take care and stay safe always.

Hi Sarah Ann,

I understand how to modify the transaction but something like this should be automated.  If there is no match for the deposit, I would want it to go to another account (Undeposited Funds or something), not sales as it is doubling income.  

How do we setup unmatched deposits to route to another account other than sales.  Routing deposits to sales makes zero sense, I can't imagine this is the only place it can go.

-Jonathan

Thanks for the clarification, @Jonathan. I'm here to provide additional information about this. 

QuickBooks will automatically tag the transaction as a match once it detects entries with similar amounts and details. Also, the transactions won't go to the register unless you manually add them. Thus, the income shouldn't be doubled. For more information, see this link: Add and match Bank Feed transactions in QuickBooks Desktop.

I know having the option to automatically route the unmatched deposits to Undeposited Funds or other accounts in QuickBooks Desktop (QBDT) will surely benefit you. I'd appreciate it if you took a moment to share this suggestion with our product engineers. They can review your suggestions and consider adding them to future releases.

Go as follows:

1. Go to the Help menu on the upper right side.
2. Select Send Feedback Online and choose Product Suggestions. 
3. Pick a Product Area in the drop-down. 
4. Enter your comments in the box and click Send Feedback. 

In addition, QuickBooks also has a website for users to vote on new feature suggestions and feedback. To access the page, visit this link: Customer Feedback for QuickBooks.

Moreover, don't forget to reconcile your bank account regularly to ensure your books are always accurate. 

Lastly, check out these articles below on how to use setup rules for your banking transactions and fix some reconciliation errors in QBDT: 

• Create rules to categorize transactions in QuickBooks Desktop
• Fix issues when you're reconciling in QuickBooks Desktop

If you ever need further assistance, do not hesitate to reply to this thread. I'll listen to you and give you my support. Keep safe.