NetSuite Bank Reconciliations

No NetSuite tool is more troublesome than Bank Feeds. In this video, I walk you through several different options that you can use to ensure you successfully achieve your bank reconciliation despite all the possible issues.
If you're interested in other content and updates, follow me on my other social media channels:
Facebook: / netsuite.supersuite
LinkedIn: / supersuite
Instagram: / netsuite.supersuite
Video Chapters:
Intro - 00:00
Match Bank Data Tool - 00:20
Manual Match Method - 01:50
Reconciling Discrepancies - 06:29
Bank Feeds Method - 08:18
Import Statement Method - 11:37
Deprecated Method - 13:46
Outro - 16:30

[@JeanineBender]

Great video and explanations of all procedures! Great speaker. Clear and concise.

[@SuperSuiteCris]

Thanks Jeanine!

[@user-ij5yi9oy3x]

Highly informative, Great Presentation

[@SuperSuiteCris]

Thanks man!

[@dylinkuni]

Excellent overview!

[@SuperSuiteCris]

Thanks!

[@mghector6430]

Thanks for detail explained NS reconciliation steps.

[@SuperSuiteCris]

You're very welcome Hector!

[@luckykumar638]

Nice explanation. Keep going😊

[@SuperSuiteCris]

Will do!

[@richardray6345]

Thanks. Does the bank feed use Open Banking or imports from SFTP transfer?

[@SuperSuiteCris]

They use an SFTP connection. This article has all kinds of FAQs regarding Bank Feeds:
docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_159010939426.html#Bank-Feeds-SuiteApp-FAQ

[@rajeshvatturu6609]

Good cris, can u pls use CSV imports also ..

[@SuperSuiteCris]

Hi Raj, please clarify your question. Are you asking for a whole video on CSV imports (which I've done already) or a video on how to do an import for a bank rec?

[@cliffclairespicyreviews3502]

How do I undo Group Matches? it keep showing match group view inside recon window.

[@SuperSuiteCris]

Yeah it's kind of a pain, you have to unapprove them and then resubmit them from the match bank data side.

[@satyamchourey6120]

Hi There ,
Do you know if there is any criteria of the transactions appearing on right (the ones from the Netsuite instance). We do the manual reconciliations and the thing is I want to give some users to only view the page Match Bank Data, no actions for them !!! I am trying to create a saved search for it but the number of records are different in the Match Bank Data and my Saved Search . I am getting 53 Checks in Match Bank Data and 94 checks in Saved Search. Following is the criteria I used in the search :
1 Type = Check
2 Cleared = "F"
Account = "XYZ"
Please suggest !!!
PS Once I add the following criteria , it comes down to 83 records in search :
Voided is false (87 records)
Date is not before ninety days ago (83 records)

[@SuperSuiteCris]

Hi Satyam, unfortunately I'm not aware of a Saved Search Criteria that specifically looks for checks that are Matched. The action of being matched in the Match Bank Data tool doesn't necessary attach to the record as a piece of data (which would then be searchable). There might be some workaround, but I don't believe there's an easy solution.

[@satyamchourey6120]

@@SuperSuiteCris thanks for the quick response but is there a way to atleast tweak up the permissions so that certain users can only view that page but not be able to clear , add or submit anything?

[@SuperSuiteCris]

Hi Satyam. I haven't tried it myself but you should be able to achieve that by setting the Permission levels for the required roles to "View" instead of Create, Edit or Full.

[@navyagangadhar691]

please make a video on period close process explained each task

[@SuperSuiteCris]

Hi Navy, I have a video doing just that in my NetSuite for Accountants Course (supertraining.supersync.cloud/courses/accountants-course)
I just haven't made a TH-cam version of that video yet. I'll put it in the queue!

[@navyagangadhar691]

@@SuperSuiteCris Thank you Cris! Also, can you make videos on Intercompany Cross charge and Amortization with Accruals please.

[@SuperSuiteCris]

No problem. At some point a bit later I'll make a more advanced accounting course and I'll include those in it.