cancel
Showing results for 
Search instead for 
Did you mean: 
marie20
Level 3

bank reconciliations

I reconcile our chase account each month, but something strange is happening.  When I go to reconcile a new month, there are DOZENS of vendors showing up (a lot from the beginning of the year) as 'uncleared'.  However, when I run a bank reconciliation report I can CLEARLY SEE THESE ITEMS as reconciled.  Please help!  How do I mark these items as CLEARED as they should be marked so they no longer show up in my bank rec??

Attached is where you can see the 'checks and payments' still in the bank rec, but these have already been cleared...

4 Comments 4
Aldren18
QuickBooks Team

bank reconciliations

I value your effort in attaching the screenshot, Marie. I'm committed to helping you resolve the balancing issue in your QuickBooks Desktop (QBDT). Let's dive into the details and ensure everything is in place for your financial clarity.

 

There are two possible reasons why these vendor transactions still appear on the reconciliation page in your QBDT. First, these entries are duplicates, which can cause them to show as uncleared. Secondly, if other users modify the reconciled transactions, adjustments like these won't be reflected in the reconciliation report. This is because the report only captures the status of transactions at the time of reconciliation.

 

To ensure accuracy, let's start by reviewing your account register. This will allow us to identify any potential duplicate entries and decide whether to delete or retain them in the records.

 
Here's how:

 

  1. Go to the Banking menu.
  2. Select Use Register.
  3. Choose the appropriate account from the dropdown list and click OK.
  4. Scroll through the list of transactions in the register.
  5. Look for entries that appear multiple times with the same dateamount, and vendor name.
  6. To delete the duplicate transactions, right-click on it and select to delete the transaction.
  7. Confirm the deletion when prompted.

 

If those vendor transactions are not duplicates, I recommend running an audit trail to investigate any modifications made by other users. It will help us gain a comprehensive understanding of the transaction history. 


For detailed steps, here's how:

  1. Click Reports at the top menu bar and choose Account & Taxes.
  2. Select Audit Trail.
  3. On the report screen, filter the dates to cover the relevant periods.

To further assist you in reconciling your account, I’m sharing these articles that address common reconciliation issues. These resources will guide you through troubleshooting and help ensure a smooth reconciliation process:

 

 

Additionally, I encourage you to customize any reports you generate in QBDT. Personalizing these reports empowers you to extract the most relevant insights to your business, enhancing clarity and focus: Customize reports in QuickBooks Desktop.

 

I’ll be here to help with any questions or concerns about balancing your account in QBDT. Leave a comment below. I'm ready to provide tailored support and insights to help you navigate our software effectively.

marie20
Level 3

bank reconciliations

Thank you.  Unfortunately that is not the issue.  These definitely are not duplicates.  These are items that were reconciled, show on the reconciled reports currently, and are showing up as 'not reconciled'.  I can't reconcile them now, that would be incorrect.  I just need them gone from the Reconcile page.  I am working on August for our account and there are dozens of items dating back to over a year ago.   

LollyNino_C
QuickBooks Team

bank reconciliations

Thanks for the update, @marie20. I'm here to help fix the issue of reconciled transactions appearing as unreconciled. Let's determine why and remove them without affecting their status.

 

As my colleague mentions about it, it's possible that these transactions have been entered more than once in your system. When this happens, the duplicate entries can appear as uncleared, even if the original entries were reconciled.

 

If other users have made changes to transactions after they were reconciled, these adjustments won't show up in the reconciliation report. This is because the reconciliation report only reflects the status of transactions at the moment they were reconciled, not any subsequent changes.

 

Based on the information you provided in your post. To maintain data accuracy, I recommend utilizing the Verify and Rebuild tool. The Verify tool identifies common issues within a company file, while the Rebuild tool addresses and corrects them.

 

To verify your company data, follow these steps:

 

  1. Go to Window and select Close All.
  2. Click File and then click Utilities.
  3. Choose Verify Data.

 

Then, here's how to rebuild your company file data:

 

  1. Go to File, then Utilities, and click Rebuild Data.
  2. Follow the prompts and select OK.
  3. Choose where you want to save your backup and click OK.
  4. Enter a new name in the File name and click Save.

 

Visit this article for more detailed information: Verify and Rebuild Data in QuickBooks Desktop.

 

If you're experiencing discrepancies between your QuickBooks Desktop accounts and your bank statements after reconciliation, you can check out this article: Fix issues when you're reconciling in QuickBooks Desktop.

 

If you need any more help with your account reconciliation, don't hesitate to leave a comment below. I'm committed to finding a solution for you. Have a nice day!

marie20
Level 3

bank reconciliations

Nope not the issue.  I am on the phone with quickbooks now, but unfortunately they have no idea either and are just reading articles.  This is a huge issue for our company and we are not able to get any answers.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us