has anyone started using the new match data and re...
# accountings
suitedev
03/25/2021, 5:10 PMhas anyone started using the new match data and reconcile account statement? I find it deeply troubling that NetSuite is forcing the use of bank integrations or manual uploads to start a reconciliation when all transactions are already in NetSuite.
m
Marc Reicher
03/25/2021, 5:13 PMI am curious to hear your preferred workflow
s
suitedev
03/25/2021, 5:41 PMNetSuite has deprecated the original reconciliation page as of 2021.1, so they are pushing people toward the integration now.
m
Marc Reicher
03/25/2021, 5:44 PMSo you just want to mark transactions as cleared without bringing any bank data into NetSuite?
s
suitedev
03/25/2021, 5:53 PMRight. We are already adding transactions to NetSuite from our bank so we only need to clear the transactions that exist.
suitedev
03/25/2021, 5:53 PMThe new Bank Reconciliation requires that you Match Bank Data first.
suitedev
03/25/2021, 5:54 PMand the only way to get ‘bank data’ is to import or set up the recurring institution import.
m
Marc Reicher
03/25/2021, 5:57 PMYeah it's interesting to me that they deprecated the old functionality. So is your team's process to just enter the transaction manually into NetSuite after reading it off of the bank statement, and then marking it as cleared?
s
suitedev
03/25/2021, 5:58 PMno way man! 😄 I built an app that creates the transactions from a bai2 or csv or xml file that is downloaded directly from the bank’s SFTP server.
suitedev
03/25/2021, 5:59 PMIt supports custom rules and all sorts of things that the NetSuite system is not capable of handling with the ‘auto create rules’
suitedev
03/25/2021, 6:01 PMwe’ve been using it for a year and it’s great.. but with NS bulldozing the reconciliation page, it seems we’ll be stuck back at adopting the bank integration step to do our reconciliation.
m
Marc Reicher
03/25/2021, 6:13 PMOhhhhh gotcha
Marc Reicher
03/25/2021, 6:16 PMOof that is frustrating. And even if the new tool gives you the bank integrations for free, it won't get you the custom rules you set up probably
Marc Reicher
03/25/2021, 6:17 PMHave you ever used FastFour?
s
suitedev
03/25/2021, 6:17 PMright.. it would be OK too if NetSuite provided access to the bank import records, but they are hidden away.
n
Netsuite Tragic
03/26/2021, 6:59 AMLooking at a 2021.1 upgraded account as of today the older style bank reconciliation is still available.