Has anyone come across a good solution for matching bank transactions. I have a client that has their own software for calculating loan payments. They want to integrate this into Netsuite thereby creating bank payment entries. When they do the bank rec they need these to match automatically as there could be 1000s of entries. Anyone have experience around this? How did you achieve a good solution? Could you potentially but the transaction number in the cheque or memo field on the NS bank transaction and then have this same number as the reference when you pay the amounts out? I am coming across this more and more with clients that have large numbers of transactions coming in from banks or payment gateways like paypal and need a good way to reconcile them.