How do I handle a Concentration account Bank Reconciliation?
Summary: Concentration account reconciliation match between a sub-system (BAI bank file) and a source system (JDE Transactions file) in total by day.
Details: I have a Corporate Concentration bank account that needs to be matched in total where the debits and credits for the day match between the sub-system (BAI file) and the source system (JDE Transactional record). The transactions do not need to be matched one for one.
How would you solve this requirement?