cancel
Showing results for 
Search instead for 
Did you mean: 
prc6th
Level 2

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

Is there a field for checks & bill payments to indicate when the item was cleared in a reconciliation?  

 

Just had a four year old check hit the bank that QB Enterprise shows as cleared.  Luckily we found it cleared in a timely manner, but what if it hadn't?  What if past staffers simply "cleared" it at some point in 2018 though it never had?  How could we find the month it was reconciled without opening every previous reconciliation? 

 

Thanks.

-Pete

Solved
Best answer February 26, 2020

Best Answers
BigRedConsulting
Community Champion

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

QuickBooks does not track the date your transactions cleared.  Only if they did or not.

 

It is quite odd for a bank to honor a 4 year old check.  You may be able to ask them to not do that...

 

IMO reconciling is only user if you balance exactly. Adjustments to make reconciles balance defeat the whole purpose of reconciling.  One way to minimize what you are seeing here is to forbid their use and to review the reconciliations each month to ensure they're not used.

 

 

View solution in original post

11 Comments 11
IamjuViel
QuickBooks Team

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!

prc6th
Level 2

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

This reply completely ignores my question.  COMPLETELY.

JaneD
Moderator

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

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.

prc6th
Level 2

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

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.

BigRedConsulting
Community Champion

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

QuickBooks does not track the date your transactions cleared.  Only if they did or not.

 

It is quite odd for a bank to honor a 4 year old check.  You may be able to ask them to not do that...

 

IMO reconciling is only user if you balance exactly. Adjustments to make reconciles balance defeat the whole purpose of reconciling.  One way to minimize what you are seeing here is to forbid their use and to review the reconciliations each month to ensure they're not used.

 

 

daltonfiredist
Level 1

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

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.

Mark_R
QuickBooks Team

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

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.

bcurtis
Level 1

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

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.

 

 

Janetta Howson
Level 2

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

Thanks!  That was very helpful!

HollyOsburn
Level 3

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

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.

ChristieAnn
QuickBooks Team

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

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.

Need to get in touch?

Contact us