Skip to main content
June 8, 2021
Question

Reconciling Bank Accounts

  • June 8, 2021
  • 1 reply
  • 0 views

The business I'm working for has 99+ uncleared deposits from years back and has never reconciled their bank accounts. This is my first bookkeeping job out of school and I want to get them current but not sure where to start. They use a current Desktop Quickbooks program.

 

Any help will be appreciated. Thanks!

1 reply

June 8, 2021

Glad to see you in the Community, @nbleser.

 

In QuickBooks, there are several ways to fix reconciliation issues depending on the scenario. Based on the information, you can run any of these reports to find the transactions causing the discrepancy: Reconciliation Discrepancy, Audit Trail, and Previous Reconciliation.


Then, undo the previous reconciliation and reconcile again. Otherwise, let QuickBooks enter an offsetting adjustment.


For this one I’m using the Reconciliation Discrepancy, follow these steps to build it. Here’s how:

  1. Go to the Reports menu at the top to select Banking and Reconciliation Discrepancy.
  2. Select the closed account in the Specify Account drop-down and hit OK.

This will display all entries that were modified since the last reconciliation. From the list, look for the one that’s causing the difference. Once found, take note of the transaction date and the Entered/Last Modified.

 

When you’re ready, continue performing the troubleshooting in this article and proceed to Undo a previous reconciliation and redo it section: Fix beginning balance issues in QuickBooks Desktop.


I’m also adding some articles to help you in the future. From there, you’ll find the complete instructions on how to perform the following.

Keep me posted if you have any clarifications about the process or other QuickBooks concerns. I’m always ready to answer them for you. Take care and have a great day.