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

Reconciliation Report

some transactions are showing cleared under "uncleared" portion of the reconciliation report

5 Comments
PreciousB
Moderator

Reconciliation Report

Thanks for visiting the Community, ALFaccounting.

 

I'm here to share some details about the cleared transactions that appear as uncleared.

 

Previously reconciled transactions might appear as unreconciled if:

  • The cleared transactions were unchecked (uncleared) in the account register.
  • The reconciled transactions were changed or deleted.
  • Funds were transferred from a previously reconciled bank account to its sub-account.

To check the current status of each cleared transaction, you can view the Previous Reconciliation report.

Here's how:

  1. On the top menu, select Reports.
  2. On the drop-down, select Banking and then click Previous Reconciliation.
  3. Select the correct Account and the Statement Ending Date.
  4. Choose the Type of Report.
  5. Select Transactions cleared plus any changes made to those transactions.
  6. Click Display

Then, compare this report to past statements from your financial institution. 

If it shows as reconciled, your data file may be damaged or corrupted. To fix this, you can try verifying and rebuilding your QuickBooks Desktop data once more.

 

If it shows as duplicate, you can just delete each transaction in the bank register. 

 

You can also give us a call if you'd like someone from our QuickBooks Phone Support Team to be with you as you go through these steps.

Here's how to reach us:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. If asked, choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.​​

I'd appreciate if you can update me on how it goes. I'll be here if there's anything else you need. Have a good one.

mdmccoy06
Level 2

Reconciliation Report

my reconciliation report is reporting all cleared transactions as uncleared.  I only have one uncleared transaction in the register.  why is this happening?

BettyJaneB
QuickBooks Team

Reconciliation Report

Glad to have you back here in the Community, @mdmccoy06.

 

I'm here to help you get this reconciliation issue sorted out and get you back on track.

 

If you've already tried performing the steps given above and the problem continues, I'd suggest repairing your QuickBooks. This is a good start when it comes to fixing program-related issues. 

 

To do that:

  1. Restart your computer to close unnecessary programs interfering with QuickBooks.
  2. Create a backup copy of your company file.
  3. Select Start and then Control Panel.
  4. Select Programs and Features. If necessary, choose Uninstall a program.
  5. Select QuickBooks in the list of programs and choose Uninstall/Change.
  6. Select Continue, then Next.
  7. Select Repair then Next. Wait for the Repair to complete.
  8. Choose Finish. Restart your computer if prompted.

Once done, download the latest QuickBooks release and the latest payroll tax table when you open QuickBooks. 

 

For complete details about this procedure, you may refer to this article: Fix QuickBooks Desktop.

 

You can also check out the following articles below about fixing reconciliation issues for your future reference:

If the issue persists after trying these steps, I'd suggest reaching out to our Customer Care Team. They have the ability to pull up your transactions securely and help investigate what's causing the issue.

 

Keep me posted how it goes. I'm just a post away should you need anything else with reconciliation or QuickBooks. Thanks for coming and have a good one!

mdmccoy06
Level 2

Reconciliation Report

I am using QBO

Anonymous
Not applicable

Reconciliation Report

Thanks for getting back in the thread, @mdmccoy06.

 

I can help provide clarification about the Reconciliation report that's reporting all cleared transactions as uncleared.

 

In your case, it seems you've reconciled the transactions before you marked them as cleared. Thus, even though you've already cleared all the transactions, it's still showing as uncleared on the Reconciliation report.

 

Another possibility is entering a future date in the reconciliation page. When you run a Reconciliation report, cleared transactions with a future date assigned to them can appear in the Uncleared Transactions section.

 

To help prevent this issue in the future, you need to ensure all items are cleared first before reconciling. Also, make sure the date does not occur in the future.

 

Should you need other references for future use, please don't hesitate to visit our help site: Help articles for QuickBooks Online.

 

Keep me posted if you have additional questions about your Reconciliation report. I'm here to help.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up