Manager has long had the ability to import bank statements. Read the Guide at Importing bank statements.
The rest of what you request points to unnecessary work, where you are keeping parallel accounting systems. What is your purpose for doing that?