cancel
Showing results for 
Search instead for 
Did you mean: 
office157
Level 1

There was a bank reconciliation done in January. When I try to start February it indicates that there are issues with six bank deposits. What can I do to resolve issue

 
1 Comment 1
RaymondJayO
Moderator

There was a bank reconciliation done in January. When I try to start February it indicates that there are issues with six bank deposits. What can I do to resolve issue

You're on the right track in figuring out the six bank deposits when starting the reconciliation for February, @office157. Rest assured that I've got the additional steps to resolve this issue. 

 

Here are some of the possible reasons the six transactions are causing a reconciliation difference: 

  • The deposits are left uncleared during the reconciliation period. 
  • You may have missed entering those transactions. 
  • The deposits are duplicate entries. 

 

First, let's run the Reconciliation report. This way, you can check if those six transactions are cleared or left uncleared when you reconciled the account last January. I'd suggest getting your bank statement ready before performing the steps below. 

  1. Go to Reports from the left menu. 
  2. Enter Reconciliation Report in the Search box and click it. 
  3. Choose the Account for the reconciliation report you want to view.
  4. Select Since 365 Days Ago from the Report period drop-down. 
  5. Hit View Report from the Action column. 
  6. Go to the Uncleared deposits and other credits after 01-31-2020 section to review the six bank deposits. 
  7. If left uncleared, manually unreconcile the transactions. Then, reconcile the account again. 

 

The screenshots below show you the third to sixth steps. 

ViewReconciliationReport.PNG

 

UnclearedDepositsAndOtherCreditsSection.PNG

 

Second, let's make sure you've entered those six bank deposits in the program. Go to the Sales menu and locate them. If you're connected to online banking, review and categorize them. If not, manually add them. Then, reconcile the account for January again.  

 

Third, let's ensure the deposits are not duplicates. Just sort the lists by date, customer, vendor, or amount from the Sales menu. If you've verified that they are duplicates, I recommend deleting them. I'll guide you how. 

  1. Go to Accounting from the left menu.
  2. Select Chart of Accounts.
  3. Locate the account you’re reconciling. 
  4. Click View register from the Action column. 
  5. Find the transaction and select it to expand the view.
  6. Hit Delete and then Yes to confirm.
  7. Repeat the process for the other five deposits. 

 

For more details, see the fourth to sixth steps through this article: Fix Issues When You're Reconciling Accounts In QuickBooks Online (QBO)

 

Once fixed, you can proceed with reconciling the account for February. It helps you ensure the account in QBO matches your bank statement. 

 

As always, you can visit this website: Reconcile Workflow. It provides you more information about starting, fixing any differences, and completing the reconciliation process. Just click the links beside QuickBooks Online

 

Don't hesitate to leave a comment below if you need anything else. Enjoy the rest of your day, @office157.

Need to get in touch?

Contact us