Skip to main content
L
Lee71
December 13, 2020
Solved

Bank Reconciliation Report

  • December 13, 2020
  • 2 replies
  • 0 views

Is there a way to keep "New Transactions" from printing on the Bank Reconciliation Report?   Example, If the period ends on November 30th, transaction through the reconciliation date are shown.  

    Best answer by RenjolynC

    I've got you covered, Lee71.

     

    When you’re reconciling an account, make sure to review the bank statement period and the opening balance. This way, only transactions for that period shows up.

     

    You can also put a check mark on the Hide transactions after the statement's end date box in the Reconcile window.  

     

     

    I've got this article that you can use as a guide in balancing your account: Reconcile an account in QuickBooks Desktop

     

    After you finish reconciling, check if you see the new transactions by printing a Reconciliation report.

     

    1. In the Reconcile window, click Reconcile Now.

    2. You will get the Select Reconciliation Report window, choose the level of detail that you want in the report (Summary to summarize the account activity for the reconciliation period, Detail to list all the transactions cleared in the reconciliation period, or Both to run both types of reports).

    3. Click the Print. In the Print Lists window, choose whether you'd like to print this report to your printer or to a file.

    4. Hit Print.

    Here's a sample screenshot for a visual reference:

     

     

    If you've already finished reconciling, you can view the information from a prior reconciliation by clicking the Previous Reconciliation report link.

     

    Please feel free to get back to me if you are getting the same result. I'll be around to help you out again. Thanks.

    2 replies

    RenjolynC
    RenjolynCAnswer
    December 13, 2020

    I've got you covered, Lee71.

     

    When you’re reconciling an account, make sure to review the bank statement period and the opening balance. This way, only transactions for that period shows up.

     

    You can also put a check mark on the Hide transactions after the statement's end date box in the Reconcile window.  

     

     

    I've got this article that you can use as a guide in balancing your account: Reconcile an account in QuickBooks Desktop

     

    After you finish reconciling, check if you see the new transactions by printing a Reconciliation report.

     

    1. In the Reconcile window, click Reconcile Now.

    2. You will get the Select Reconciliation Report window, choose the level of detail that you want in the report (Summary to summarize the account activity for the reconciliation period, Detail to list all the transactions cleared in the reconciliation period, or Both to run both types of reports).

    3. Click the Print. In the Print Lists window, choose whether you'd like to print this report to your printer or to a file.

    4. Hit Print.

    Here's a sample screenshot for a visual reference:

     

     

    If you've already finished reconciling, you can view the information from a prior reconciliation by clicking the Previous Reconciliation report link.

     

    Please feel free to get back to me if you are getting the same result. I'll be around to help you out again. Thanks.

    L
    Lee71Author
    December 14, 2020

    Thanks for your prompt reply.  I guess I've been concentrating on the numbers and neglected to read!

    C
    Carrolp
    December 28, 2021

    The question was...

    "Is there a way to keep "New Transactions" from printing on the Bank Reconciliation Report? "

    These steps do not eliminate the NEW TRANSACTONS from being displayed on the reconciliation reports for the summary NOR the detail.

    Because when information is in the books for months on end it makes the reconciliation reports too long. Therefore... I am also looking for the answer to this question. 

    Thanks

     

      M
      Mark_R
      December 28, 2021

      Thank you for joining the thread, @Carrolp.

       

      I'm here to help exclude the new transactions when printing the reconciliation report.

       

      You'll want to display the Reconciliation report so you can customize the reporting date period before printing it. This way, you'll be able to eliminate the new transactions. Here's how:

       

      1. From the Select Reconciliation Report window, select Summary, Detail, or Both.
      2. Click the Display button.
      3. In the report window, click the Customize Report button.
      4. From the Report Date Range section, enter the date range of the report you want to show.
      5. Click OK.
      6. Then, select the Print button to print the report.

       

      I'm adding this article to learn more about customizing reports: Customize reports in QuickBooks Desktop.

       

      You might also want to learn more about the reconciliation workflow. This can help make sure the amounts match your real-life bank statements.

       

      It’s nice to work with you, @Carrolp. Don't hesitate to click the Reply button below if you need further assistance running reports.

      C
      Carrolp
      December 28, 2021

      Thanks for your reply. This action do eliminate the new transactions from the reconciliation reports, but then it eliminates the beginning balance as well as items reconciled in the current period but the date is outside of the current period. This throws off the numbers in the reconciliation detail so my summary and detail don't match. 

       

        Terms & ConditionsAccessibility statement