has anyone had experience with intelligent transac...
# accountingj
jglovsky
05/12/2020, 6:14 PMhas anyone had experience with intelligent transaction matching in netsuite for bank recs? I'm trying to make a rule to match our bank ACH batch (multiple ACHs are pulled in one bulk draw from the bank) to Netsuite where each payment is an individual line and I'm not really sure where to start.
On a side note if you all havent checked out the new netsuite bank app its great, automatically pulls in bank balances and transacitons
k
KevinJ of Kansas
05/12/2020, 7:02 PMif you record your ACH transactions to undeposited funds, you can record a deposit transactions for the total value, and it really makes the bank rec process much easier
j
jglovsky
05/12/2020, 7:59 PMWould this be for vendor bill payments? I thought undeposited was just for money in
jglovsky
05/12/2020, 8:00 PMWe’re basically trying to match vendor payments that come out from the electronic payments app, the money is pulled from our bank account as one batch and we have to tediously click each payment to match on the bank Rec
👀 1
k
KevinJ of Kansas
05/12/2020, 8:48 PMWait - so in this case you have vendor payments that go out, but only one value clears the bank? Not sure I've seen it that way before
KevinJ of Kansas
05/12/2020, 8:51 PMi might be more tempted to use a "clearing" bank account for the outgoing payment, and then record bank transfers. for the ACH amount that was actually withdrawn in aggregate
j
jglovsky
05/12/2020, 9:01 PMYeah, we have multiple payments to vendors that go out but we drop the NACHA file to our bank which pulls it as one amount. So we have to go through and click match for each vendor bill payment
jglovsky
05/12/2020, 9:01 PMOk, that might work. I'll check it out, thank you
j
Jon Kears
05/13/2020, 12:44 AMthat's what we do; works ok. Just need to create some alerts to tell you when your clearing account is not 0
2 Views