Skip to main content
L
lakassociates
July 14, 2021
Question

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

  • July 14, 2021
  • 1 reply
  • 0 views

I recently connected to my bank account (I had previously manually recorded all deposits) when I connected to Quickbooks Cash - but now my bank register is double counting the received payments.  


For example - if I go to the bank to deposit five separate checks for a total amount of $5,000 - later Quickbooks will show the deposit as DEPOSIT REF #0 for the amount of $5,000.  But then I have to confirm that the five invoices were received (manually recording which invoices were depoisted, etc - to show payment received) - which then shows a manual deposit in the register of an additional $5,000.  

 

How do I confirm "payment received" without also inputting an additional amount? Otherwise, if I don't manually input that the payment was received - Quickbooks will show all those invoices as overdue?

1 reply

J
jamespaul
July 14, 2021

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. 

 

K
kim217
May 9, 2022

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

A
AileneA
May 9, 2022

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!

 

Terms & ConditionsAccessibility statement