How do I reconcile bank recorded deposits with the manually deposited invoices

Hello, lakassociates. 

I appreciate adding the details about your scenario. I'm happy to share with you some steps on how to fix the duplicate transactions. 

Adding the amount from QuickBooks Cash and manually recording the payments will duplicate your payment transactions. 

Since you connected the bank through our Online Banking feature, you'll want to remove them from your bank register and exclude these payments. Here's how: 

1. Go to the Banking page. 
2. Click the Categorized tab. 
3. Find the added deposits.
4. Click Undo (you can also check each transaction, then click the Undo button). 
5. Go back to the For review tab, 
6. Check the transactions again, then click Exclude. 

Next, you'll want to manually clear those deposits from your bank register. This indicates that they have been cleared from the bank and transferred successfully from QuickBooks Cash. 

Here's how: 

1. Go to your Chart of Accounts.
2. Find your bank account, then click the View register link.
3. Locate and select the deposits.
4. Under the Check mark column, click the blank box until a "C" appears. 
5. Click Save 

Moving forward, you'll just want to match those deposits with the invoices to avoid duplicate income. On the Banking page, select the deposits then click the Find match radio button.

QuickBooks will also suggest a match automatically. All you have to do is to click the Match button (provided that the matched transaction is correct). 

Need help with the bank reconciliation? This article can guide you on how to do it: Reconcile an account in QuickBooks Online. 

If you need help seeing your total sales, you can run a bunch of reports in the program. Check this article for a guide: Run reports in QuickBooks Online.

Feel free to comment your replies below if you have more concerns about managing your QuickBooks Cash transactions (or any other concerns). I'm here to help. 

I have the same problem as the original poster.

My issue is I cannot find the View Register under theChart of Accounts.

1. Find your bank account, then click the View register link.
2. Locate and select the deposits.
3. Under the Check mark column, click the blank box until a "C" appears. 
4. Click Save 

Please advise

Hello, kim217. 

Thank you for posting here in the Community. I'm here to help you get this sorted out. You can locate the View Register under Action column. However, If you are still unable to find the View register, you can log in and out to QuickBooks to narrow down the result. Then, open the QuickBooks through a private window. This browser prevents any virus infections that can cause unexpected behavior when using QuickBooks, and this mode doesn't save your web searches and site data.  

To save you time, use either of these keyboard shortcuts:

• Google Chrome: Ctrl + Shift + N
• Safari 11 or newer: ⌘ + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + P 

If it works fine, go back to your original browser and clear its cache to start fresh. In addition, you may use other supported browsers. The one you're currently using may have a temporary issue with QuickBooks.  

In case you need to learn about reconciling workflow, you can check this article to ensure you'll reconcile your account successfully: Learn the Reconcile Workflow in QuickBooks.

Should you have any additional questions or concerns, the Community will have you covered. Have a good one. Take care!

Mine says Account history instead of View register

Mine says Account history instead of View register

See attached

Hello there, @kim217.

Thanks for joining this conversation. Allow me to chime in the share information about view accounts in the Chart of Accounts (COA) in QuickBooks Online (QBO).

The View Register and Account History under the Action column is the same. Users who are seeing View Register have the old interface, while the users getting Account History have the new interface or use the international version of QBO.

For more information about managing COA in QBO, consider checking out this article: Learn about the chart of accounts in QuickBooks Online.

Once done, you may now follow the steps shared by my colleagues above to reconcile your account. Or refer to this article for further guidance: Reconcile an account in QuickBooks Online.

I also recommend visiting our website for more tips and other resources you can use in the future: Self-help articles.

Let me know if you have follow-up questions about this or anything else. I'll be more than happy to assist. Stay safe and have a good one.