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

If I do a quick report of a COA and add the filter of Cleared (y/n), the CLR column on the report never shows if something was actually cleared - its always blank, why?

 
1 Comment 1
BettyJaneB
QuickBooks Team

If I do a quick report of a COA and add the filter of Cleared (y/n), the CLR column on the report never shows if something was actually cleared - its always blank, why?

Hi there, @yogadoll.

 

If there are no cleared statuses on the register, the CLR column will always show as blank.When pulling up a QuickReport of any bank accounts in the Chart of Accounts section, the CLR column will display those transactions that were marked as Cleared and Reconciled. I've attached some sample screenshots for your reference: 

 

Once verified that the transactions were cleared and the issue persists, I recommend verifying and rebuilding your data. It can help fix data-related problems on your company file.

 

To do that:

  1. Click on the File menu, then hover over Utilities.
  2. Select on Rebuild Data.
  3. On the QuickBooks Information window, select OK. Follow the onscreen steps to save a backup.
  4. Let the tool repair your file. 
  5. When the tool finishes, select OK.
  6. Go to the File menu. Then hover over Utilities and select Verify Data.
  7. Let the tool check your file for data issues.

To give you the complete details about resolving damage data in QuickBooks Desktop, please check out this link: Fix data damage on your QuickBooks Desktop company file.

 

I'm also adding here some resources that you can visit about reconciling accounts and customizing financial reports in QuickBooks Desktop: 

You can always find me here if you have any other questions. I'll make sure you're all set. Take care!

Need to get in touch?

Contact us