Skip to Content
Oct 22, 2020 at 01:18 AM

Credit and debit card settlement reconciliation

148 Views Last edit Nov 01, 2020 at 05:13 PM 2 rev


  • 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.