im trying to setup a custom matching rule for our ...
# accounting
c
im trying to setup a custom matching rule for our imported bank reconciliation. Our bank statement ofx file changed a bit recently to where its concatenating the payer/payee name with the transaction id so now the check numbers are all showing in the payer/payee field on the netsuite import. I wanted to make a rule that calls on the payer/payee field and ignore the prefix but the only options im able to call on are the date, memo and transaction id. Is there a way to set a rule against the payer/payee field?
p
Not that I'm aware of. From a recent issue I was investigating with NS support it appears that payer/payee field is only there to support MANUAL matching review if the auto-match rules didn't work. I'm assuming (being kind) that this is because they couldn't/didn't want to incorporate fuzzy matching logic (ie ABC Company Inc vs ABC Incorporated). You may need to play with the OFX file to separate the check number prior to uploading if you are able, or if not you'd probably need to look into using the CSV import template. There's also some new toys for bank statement imports in the 2019.2 release but I'm not sure any of them would help with your issue. Good luck!
c
ya i didnt think so. All of a sudden my bank switched to a new platform for their statements and their ofx files got all screwy. They are working on fixing it so the check numbers show in the separate field like they used to but i was hoping to resolve this with a quick rule in the meantime.
k
Corey - have you considered asking your bank about BAI2 files if you are in the United States? Safer all around over OFX files anyways.
c
they dont offer the bai2 file type. However i just noticed they do have QFX as well so im going to see if that has any different results.