Credit and debit card settlement reconciliation

[former_member698817]

Hello,

• we ingest transactions from the bank with a BAI2 file
• each day we receive a bulk amount of credit and debit card payments (e.g. $100,000) in our bank
• in a separate system we have a breakdown of the individual transactions that constitute that $100,000
• since the individual transactions can be for different things, we need to reconcile that $100,000 using those transactions

Is there some process that we can follow so that we can reconcile the bulk transaction, using all those individual transactions?

We have tried to put all the transactions into a separate BAI2 file (generated from our separate system) and uploaded that but then we are doubling up on the amounts.