What exactly are the end-to-end business processes that you are trying to automate within the Cash and Bank management module in AX2012? What data is it that you are not finding accurate, where is this data been generated in AX2012?
What subledger and ledger entries are you're reconciling in the system?
It will be helpful if you would elaborate on the issue and what exactly you are looking for as set up to run an automated business process in AX2012.
If you've found this thread useful, dive deeper into User Group community content by role