Skip to main content
prc6th
Feb 25, 2020 4:15 PM UTC
Solved

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

    BigRedConsulting
    BigRedConsultingAnswer
    Feb 26, 2020 8:22 PM UTC

    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 in thread

    11 replies

    IamjuViel
    IamjuViel
    Feb 25, 2020 5:08 PM UTC

    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!

      prc6thAuthor
      Feb 25, 2020 5:13 PM UTC

      This reply completely ignores my question.  COMPLETELY.

        JaneD
        JaneD
        Feb 25, 2020 6:58 PM UTC

        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
        Feb 26, 2020 8:22 PM UTC

        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
          Mar 11, 2020 6:39 PM UTC

          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
            Mar 11, 2020 8:55 PM UTC

            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
              Nov 17, 2020 5:52 PM UTC

              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
                May 13, 2021 1:15 PM UTC

                Thanks!  That was very helpful!

                Terms & ConditionsAccessibility statement