Bank Statement Upload - Receipt reconciliation

Hi,

We are implementing Bank Statement upload for file format swift940. We did the mapping for Bank_Trx_Number to 61, 7 and its working fine for payments as the payment document number is coming in this column and are getting reconciled.

For Receipts, when we did the above mapping, customer reference is coming in this field. Now, we are using the bank reference number while entering receipts and so now they are not getting reconciled. I tried populating the bank reference number in Agent, Agent Bank Account and in Invoice column but its not getting reconciled.

I cannot change the above mapping or else payment will not get reconcilied and we cannot have different mapping for Recipts & Payments. Can you please help and let us know how we can get the receipts reconcile and where can we have the bank reference number so that they get reconciled.