Need a report to display in which period was a check was cleared / reconciled.

Hello, @prc6th.

You can generate and customize your Previous Reconciliation report so you'll be able to view your reconciled transactions in QuickBooks.

Here's how:

1. Go to Reports menu.
2. Select Banking.
3. Click on Previous Reconciliation.
4. In the Select Previous Reconciliation Report window, choose the appropriate Account and the Statement Ending Date.
5. Choose the Type of Report.
6. Choose the type of transactions to include in the report.
7. Click Display.

You can refer to this article for more detailed steps: View previous bank reconciliation reports.

Let me know if you have other questions about previous bank reconciliation, I'll be right here to help you. Have a great day ahead!

This reply completely ignores my question.  COMPLETELY.

Hi prc6th,

At this time, there isn't a report that shows transactions as cleared on a specific period in QuickBooks. You might want to run and customize a QuickReport of the account. I'll guide you how.

1. Go to Lists and choose Chart of Accounts.
2. Right-click on the account and select QuickReport.
3. Click on the Customize Report button.
4. Set the date under Report Date Range.
5. Type in Clr in the Columns field and mark to select Clr.
6. Click on OK.

You can check out this article to learn more about customizing reports in QuickBooks Desktop.

Let me also share this link about available reports you can run in QuickBooks: Understand reports.

Please let us know if you need anything else. We'll be here to keep helping.

Your first sentence is the answer.  Why did you not stop there?  I did not ask how to see whether something has cleared.

Corporations are afraid of saying "no" to customers these days.  If "no" is the simple answer say it and let us move on.

This might be something for the next update???  Unfortunately I have had several occasions where if i knew the date the check had actually cleared, not just that it had cleared, many hours of research would have been avoided.

We're taking note of your feedback and suggestion, @daltonfiredist.

Our product engineers are considering all suggestions based on the number of requests and their impacts on the user interface before they're rolled out.

I can see how beneficial for you and your company to run a report that shows cleared transactions on a specific period. At this time, you can consider following the workaround shared by my colleagues above.

Also, I want to let you know that your voice matters and I'm submitting feedback directly to our product engineers for consideration. For now, you can visit our blog site so you'll be able to get the latest news about QuickBooks and what our Product Care Team is working on. 

If you have other concerns, just comment below or post again. I'll be sure to get back to you. Have a good one.

I know this is an old thread but I went searching today to see if there was a better method of finding which statement periods transactions are cleared to. So far this is the best solution I have found.

Change the cleared transaction amount by .01 . Go to Reports>Banking>Previous Reconciliation Discrepancy Report. Select the reconciled account. The modified transaction will appear on the discrepancy report, below the statement date that it was reconciled with. Remember to change the transaction back to the cleared amount or the reconciliation will be out of balance.

Thanks!  That was very helpful!

I think this is now available in QB?  The Reconciliation Report records the date that the check cleared in my application, based on the date from the bank...I am trying to find a way to list the date the check was written, in the same reconciliation report.  So far, no luck.

Hi there, HollyOsburn.

Thank you for visiting again the QuickBooks Community and I'm glad to know that the Reconciliation report records the check date as to when the entry cleared in your application. I'll ensure to share details on how you can customize the date of the check to see the date created in the recon report.

In QuickBooks Desktop, the option to filter the reconciliation report to list the date of the check as to when it was written is not available. In the meantime, you can export the Reconciliation and Transaction List by Customer reports to Excel. You'll be able to manually customize the reconciliation report from there and use the other one to view the entry's details.

Here's how for Transaction List by Customer:

1. Go to the Reports menu at the top.
2. Choose Customers & Receivables and select Transaction List by Customer.
3. Select the Excel on the toolbar. You can also select Print or Email to save the report as a PDF.
4. To create a new Excel workbook, click Create New Worksheet. 
5. If you want to update an existing workbook with the data in the open report, choose Update Existing Worksheet. 
6. Click Browse and then find the workbook on your computer. Keep in mind, this overwrites the existing workbook.
7. When you’re ready to export, click OK. To open the report in Excel, you can also select Export.

To see further details, you can open this article: Export reports as Excel workbooks in QuickBooks Desktop. This also provides information on how you can get the latest version of the report from QuickBooks while you're in Excel.

Then, for the Reconciliation report, I've attached a screenshot below for visual reference.

Lastly, you may open this article to see various details on how QuickBooks Desktop provides different reports that cater to your business needs to display data from your company file: Understand reports.

Don't hesitate to visit the Community again if you need more help in managing your reports. Looking forward to assisting you again.