Skip to main content
P
prc6th
February 25, 2020
Solved

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

  • February 25, 2020
  • 4 replies
  • 0 views

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

    Best answer by BigRedConsulting

    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.

     

     

    4 replies

    IamjuViel
    IamjuViel
    February 25, 2020

    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!

      P
      prc6thAuthor
      February 25, 2020

      This reply completely ignores my question.  COMPLETELY.

        JaneD
        JaneD
        February 25, 2020

        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.

        BigRedConsulting
        BigRedConsultingAnswer
        February 26, 2020

        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.

         

         

          D
          daltonfiredist
          March 11, 2020

          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.

            M
            Mark_R
            March 11, 2020

            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.

              B
              bcurtis
              November 17, 2020

              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.

               

               

                J
                Janetta Howson
                May 13, 2021

                Thanks!  That was very helpful!

                Terms & ConditionsAccessibility statement