Hey @jpfieber!
This is really cool. You’ve stitched together a really great solution… and I agree that the TCS Statements solution can be tedious.
Some thoughts and observations:
- I like how the solution is forward looking without getting bogged down in logging all past statements.
- I like the grouped debug tools you’ve implemented to problem solve— since that is an essential part of statement reconciliation workflows.
- I like your prepend & extend features to quickly expand the date range and identify missed transactions.
- I really like your
ReconcileDatesolution for moving stray transactions into the correct statement period— super clever! (I just wish you included a note about adding that column toTransactionsin the Setup instructions since my worksheet wasn’t functional until it was in place.) - The enable/disable dropdown is a great performance optimization. We had considered implementing something similar in our TCS sheets long ago but never quite settled on a solution. (I just wish Excel made it more clear that it is a dropdown… or offered an in-cell checkbox.)
- I’m curious if you can leverage
Balance Historyfor the balance comparisons… or if the erratic timestamps leave too much to chance… - It is AWESOME
that you continue to build and support your creations with Excel and Google Sheets versions!!!
It took me a little bit to get my head around this but it is great and I think it will help a lot community members interested in statement reconciliation.
We are excited to award you a $300 gift certificate 
as part of our 2022 Microsoft Excel Builders Challenge . (Thanks for your patience with this review. Had hoped to dig into it closer to posting.)