Skip to main content
T
TomE2022
June 15, 2022
Question

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

  • June 15, 2022
  • 1 reply
  • 0 views

I have to reconcile several past months of bank statements. My problem is that QB (Contractor 21.0/PC version) is including all future dated transactions past my reconciliation statement month.

 

For example: I want to reconcile May 1, 2022 - May 31, 2022. A cash deposit posted on 6/3/2022 (nothing to do with May 2022!) is showing up as "New Transactions" and therefore Ending Balance is as of 6/3/2022. This gets very long and messy as I have to go back prior months and rec.

 

Can I get a nice clean "Month-only as of that month-end" bank rec report? Without all that extra post reconciliation dated "New Transaction" noise on the report? Yes, I have used the check box in the reconciliation window of "Hide transactions after the statement's end date" and it just seems to affect the available entries to show for clearing. The "New" transactions will still show up on that month's rec report.

    1 reply

    P
    Pete_Mc
    June 15, 2022

    Confirm when you're Reconciling that you've put in the Statement Closing Date, not just letting QBs default to the current date.  Then if the Closing Balance is also per the Statement and you've got all the correct transactions checked off, the Reconciliation Balance should be $0/Balanced. 

     

    All of the transactions prior to the Statement Date that have not cleared the Bank should not be checked.  Also any transactions that happened after the Statement Date should also not be checked.  There should also be a little Check Box (it's at the top on QB Desktop) where you can "Hide transactions after the statement's end date."  That should hide all of the newer transactions you're seeing.

     

    T
    TomE2022Author
    June 16, 2022

    I am including a screenshot to best show exactly what I mean, with the items in YELLOW that I do not need or want to see. (a short version of one account, I have many others that are many months old)

     

    I did mention that I used the checkbox for "Hide transactions after the statement's end date" and all this appears to do is just not have the transaction show up in the box while you are selecting entries to mark cleared. This report was created both ways and with same results.

      A
      Archie_B
      June 16, 2022

      Thank you for following up and sharing the details, TomE2022.

       

      I agree with @Pete_Mc, the statement date is filled automatically in QuickBooks. Make sure to change the statement date to May 31st since it needs to match your bank statement. 

       

      Just to make sure we're not missing anything, I'll show you the detailed steps on how to start reconciling an account in QuickBooks Desktop.

       

      Here's how:
       

      1. Go to the Banking menu, then choose Reconcile.
      2. Pick the bank or credit card account you want to reconcile in the Account field.
      3. Select the Statement Date (May 31, 2022).
      4. QuickBooks also automatically enters the Beginning Balance. It uses the ending balance from your last reconciliation to get this number.
      5. Enter the Ending Balance based on your bank statement.
      6. Enter the Service Charge and Interest Earned based on your bank statement. Don't enter charges you've already entered in QuickBooks.
      7. Review the fields. If the info is correct, select Continue or OK.

       

      Once you're done reviewing the details and checked the option Hide transactions after the statement's end date, it should now exclude the new transactions for your reconciliation. Here's an article for more information: Reconcile an account in QuickBooks Desktop.

       

      I'm adding this link in case you'll need to fix issues when you're reconciling in QuickBooks Desktop.

       

      I'm always here if you need further assistance with your bank reconciliation. Take care and have a great day!

      Terms & ConditionsAccessibility statement