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.