Can NetSuite's Intelligent Transaction Matching for Bank Data match One-to-Many transactions automatically?
j
Jon Kears
11/11/2020, 11:38 PM
we generally do the "many" transactions in a bank clearing account (which must be zero at the end of each day), then move them with a single transfer to create the "one" on the bank. Would be interested to know if there's a way to get around this
m
michoel
11/12/2020, 2:00 AM
@Jon Kears We used a clearing account like that at my previous job and I've suggested doing that at my current company. Are you facing any issues with this that you are looking to change?
m
Matt
11/12/2020, 2:03 AM
Yes the issue is that our process results in one transaction that is sent to the bank, but two transactions in NetSuite with different transaction no./IDs. I know that many bank:1 NetSuite transaction can be auto-matched with NetSuite bank reconciliation, but not sure if 1 bank: NetSuite many transactions can be
Matt
11/12/2020, 2:03 AM
And there could be hundreds of these types of transactions daily
j
Jon Kears
11/12/2020, 4:25 AM
@michoel it works ok: it's mainly process issues... we've had a few instances with people ignoring our alerts on the account not being cleared down, or treating it as a cash in transit account, or hiding reconciling items in there.
Jon Kears
11/12/2020, 4:25 AM
And whenever we have a new starter the fun and games begin again