X symbol on report

Hi there, bookie13. 

I'm glad you've reached out to us. Let me help provide some insights about the symbol X in Clr column in QuickBooks Desktop. 

The X symbol in the Clr column on the report, there are deleted transactions in your account. You can double-check it through an audit trail to verify if there was a transaction deleted or modified.  

In case you need more help regarding other tasks in QuickBooks Desktop, you can check our articles here. Make sure that the topic is set as "QuickBooks Desktop." 

Don't hesitate to leave a comment below if you have any other questions about the report. Have a good one.

They can't be deleted transactions, they are showing in the transaction report for the entire year but only in the CLR column of the bank account.  

The check mark in this column means the bank reconciliation are completed and this items are reconciled.

I don't know what the "X" in the CLR column on the transaction report for the bank account means.

Thank you,

Thanks for getting back to us, @bookie13.

You may be referring to the asterisk symbol (*) in the CLR column instead. If so, this means that someone has started a reconciliation and checkmarked this transaction but unable to finish it.

Other symbols that you might see in the report are:

• Lightning Bolt - means this transaction has been verified by the Banking Feeds download process.
• Checkmark - means that this transaction has been entered, verified, marked as Cleared, and the reconciliation was completed.

In case you want to learn about the available columns and filters in QuickBooks Desktop (QBDT) reports, I suggest checking out this article: Customize reports in QuickBooks Desktop.

Please leave a comment below if you're referring to something else or if you have any additional questions. I'll be happy to answer them. Have a wonderful day!

Hey there,

Not referring to a lightning bolt...looking at a bold X in the CLR column for the bank account in the transaction detail report...thinking someone started the bank reconciliation but did not reconcile.

Any other thoughts from someone who works with QB?

Thanks for getting back to us, bookie13.

Aside from the details provided by FritzF, those are the symbols that you can see under the CLR column.

Do you have screenshot of the bold X mark under the CLR column? What QuickBooks version are you using? What specific report did you pull up?

Meanwhile, we can do a few troubleshooting steps to ensure that your company file is in good condition.

1. Update the release version of QuickBooks.
2. Do the Verify and Rebuild process.
3. Close and reopen QuickBooks.

Feel free to provide additional details about it so we can review what else we can do. 

Hello,

I'm having the same issue in the same report " Reconciliation Detail" report.  I'm also getting other symbols.  Some of the transactions have the "X" or an "M" or a checkmark.  Please advise.

Thank you

Welcome to the QuickBooks Community, Mari10. I will love to assist you here. As mentioned earlier in the thread, when there is an X in the CLR column, this indicated that the transaction was deleted, and using your audit trail can help confirm this. When it comes to the checkmark, this means that the transaction has been entered, verified, marked as Cleared, and the reconciliation was completed. Whereas with the "M" symbol, is it possible that you can provide a screenshot to examine this further?

I would recommend following those same troubleshooting steps above if you haven't done so already to verify and rebuild your program to rule out data damage. Once that is isolated, and there is still an issue, we can find another way to resolve this. Please let me know how this goes. I will be here waiting for your update and the screenshot. Until then, take care!

Thank you for your quick reply.  I checked the rebuild data and it came back O.K.  I'm attaching a file with the "X" and "M" under the Clr. column.  It just can't possibly be that all of those transactions were deleted.  I ran other reports and those transactions show up and have a checkmark under the Clr. column. It seems like the Reconciliation Detail report is the only one with the symbol issues.  Thanks

Thanks for adding a screenshot of your Reconciliation Detail report, @Mari10.

I'm here to share some information about the X and M letters on your report.

Please take note that QuickBooks Desktop displays unique symbols to represent the status of your transactions. I've listed them below. Here are the signs that you'll see on the screen:
 

• Asterisk: Cleared, but not yet reconciled
• Checkmark: Reconciled
• Lightning bolt: Matched to an online bank statement

These are the symbols that you'll see on the printed reports:
 

• Asterisk: Cleared, but not yet reconciled
• Letter X: Reconciled
• Letter M: Matched to an online bank statement

In addition, I recommend reading these articles to ensure that you'll get the most out of QuickBooks' reporting capabilities:
 

• Create, access, and modify memorized reports
• Customize reports

You can always find me here if you have any other concerns or further questions about reports. Have a great rest of the weekend.

I have the same issue of an X in the cleared column on the most recent reconciliation.  They were not deleted transactions They do not show up on the locate discrepancy report.  They are all transactions a Journal entry was created to clear them.  A mini reconciliation did not work to clear them. They still show an X in the cleared column of the report listed in the uncleared transactions.  How can this be rectified?  We recently upgraded to Enterprise. This was not an issue in the past using Pro.  I don't want to see these reconciled transactions on every report going forward as it did in the last two.

Thank you for any help you can give.

Thanks for joining the conversation, @D3bM. I'd be glad to help you out.

To rectify this issue, I recommend performing some basic troubleshooting steps using verify and rebuild data tools. This finds common data issues in your company file. 

Let's begin by updating your QBDT program to bring in the new updates from the Intuit server. 
 

Once done, accept the option to install the new release, then restart the program. If the issue persists, you'll need to run the Verify and Rebuild Data process within your company file to fix the issue. 

Here's how:

   1. Go to the File menu.

   2. Select Utilities.

   3. Click Verify Data. Then, select OK to close all windows.

If the same thing happens, it would be best to contact our support team. They can pull your account securely and further investigate the issue. We can also have a screen-sharing session with them to determine the root cause. 

Here's how you can reach out to them: 

1. Open QuickBooks.
2. Go to Help, then select QuickBooks Desktop Help.
3. Select Contact Us.

To ensure that we address your concern timely, please consider checking our available hours. 
 

You can visit this article to learn about the available columns and filters in QBDT reports: Customize reports in QuickBooks Desktop. 

Keep me posted if you have any other questions about reports in QuickBooks Desktop. I'm always around to help. Stay safe!

I found the reason to be off cycle reconciliations to clear the transactions in question incorrectly dated in the future. Once the reconciliations were deleted and done with the correct date the problem was resolved.

It's good to have you back, D3bM.

I’m glad that you're able to resolve the issue about reconciliation. Please know that you can always reach out to us whenever you need help.

If you need more information about managing your company, visit our QuickBooks Help page. It contains ways and tips to make sure everything is accurate and organized.

Have a great day, and keep safe!