Bank Reconciliation and Bank Data Import
I am very new to NetSuite. I have been tasked with doing bank reconciliations.
-
- When doing a bank data import, does it only load those items found as a bank transaction but not in NetSuite, or will it load all transactions from the bank into NetSuite?
- Is there any way to completely clear the queue and start fresh with last month reconciled?
- Is there a procedure or a contact person anyone can share?
- Can I connect NetSuite to my bank and run a script nightly to upload all new transactions?
When I look at my controller dashboard, I need to see the amount in the bank in real time along with showing the bank reconciled through the end of last month.
My email is stacyn@swagoe.com
Any help is appreciated.
thanks
Stacy Nivens
- When doing a bank data import, does it only load those items found as a bank transaction but not in NetSuite, or will it load all transactions from the bank into NetSuite?
– Will load the transactions included in the statement file from the bank - Is there any way to completely clear the queue and start fresh with last month reconciled?
you should be able to do that in the Match Bank Data page (Suitelet) - Is there a procedure or a contact person anyone can share?
SuiteAnswers have extensive articles on this subject - Can I connect NetSuite to my bank and run a script nightly to upload all new transactions?
Setup ABSI (Auto Bank Statement Import) and Bank statement parser suiteapp, then work with your bank to setup SFTP connection to fetch EOD statement files (BAI2. MT490) on a schedule. https://suiteanswers.custhelp.com/app/answers/detail/a_id/93721/loc/en_US. Also you can use Bank Feed suite for the same purpose but it is quite clunky though easier than SFTP method. You can also look into https://fispan.com/ – a complete banking solution quite a few major banks are reselling this solution as their own (JP Morgan, SVB, Wells Fargo, BMO etc)
