I have started experimenting with the Match Bank Data, but from what I am seeing it doesn't seem to give us a huge benefit - I was hoping to check here if I was missing something obvious.
This is the current process I am testing:
- Export transaction list from the bank (CSV)
- Go through a (relatively) complex process to re-organise the CSV data into the format required by NetSuite
- Upload the file into NetSuite
- Go to Match Bank Data screen
- As far as I can see, this will auto-match any bank transaction to a Payment record (if one is already present in NetSuite)
- If a Payment record is not present, we would need to create this in NetSuite, refresh the Match Bank Data page, and then match it.
This doesn't seem to be a huge improvement over our current process where we:
- Print out the bank statement
- Create Payments on the NetSuite customer accounts for each deposit
- Go through the Bank Rec process to tick off the payments included on each statement and reconcile the balance.
I guess we were assuming that the automated process would attempt to create Payment records (where it could match payments to a customer and/or invoice etc).
Are my assumptions correct, or is there more that the Match Bank Data process can do that I haven't seen?
Am I missing something, or