TomE2022
Level 2

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

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.