Based on your initial post of what you’re trying to accomplish “take the reported bank balances, and subtract off any manually entered transactions that marked to be cleared. My goal is to give a clear projected future cash flow”, I wanted to do this as well so I created this sheet- Near-Term Account Balance Forecast.
This may accomplish what you want.