Hello is anyone familiar with the Electronic Bank Payment in NetSuite? It's something we aren't familiar with the process and it's something we are starting to look into.

Yes. Plenty of people here will have experience with it

Well we're just trying to figure out how complex it would be to start to make templates and etc out of it. From what I have already gathered is that the bank we are needing to set up isn't in that. so we're just not sure how complex it is to make adjustments to fit what that bank would require.

Yes it’s worked fairly well. The hardest part was getting the bank to share their specifics for the bank setup

I know it's not connected to the bank.

Basically there's a handful of templates that end up covering 95% of banks, and you just need a tweak here & there. To be honest, the most difficult bit about setting it all up is dealing with the bank & getting them to sort themselves out. They're not the best

I'm needing to know how complex it is to build the template for a bank, as the bank we are working with isn't in the preexisting templates.

Interesting. I’ve heard you can build a custom file template but I have no idea how hard it is. I’ve never run into a bank that didn’t support one of the file formats

I've done this in the past, but for a different ERP system that wasn't cloud based, so we did C# to handle it.

My guess is it’s fairly complex but could be done

So most have just been lucky with the out of the box templates working is what I'm gathering it seems so far.

Just because the bank is not listed by name, does not mean it is not supported. It's likely they use a standard file format that already has a template. I'd be amazed if it wasn't the case

Yes. I’m not sure I would say lucky. NetSuite provides a ton of pre existing formats that cover 95% of situations so it’s more strange to find a bank that doesn’t support it

In the first instance I'd reach out to them and ask

It does happen, again ran into it with a different ERP, and also it can also happen if your company is also banking with ROW as well.

What type of NACHA file does your bank support?

anyone dealt with US Bank with this process?

Yes, 40+ bank accounts scattered round the world

and so you didn't have to make any adjustments then is what you're saying?

I'm saying what I have already said. Tweaks to existing templates

okay so i'm asking what kind of tweaks is it in that segment of NS or script codes for the output of the data.

When you first setup your bank details you need to select what file format the bank accepts. (This will most likely be CCD/PPD, which is a commonly used file format). Then you need to add "tweaks" to it specific to your bank. For example Immediate Origin, Company ID, Check Digit, Add Pad Block, Balanced Files. and so on

We are currently going through this process. With the paid version of EBP, you can modify existing templates for your bank. The templates use Freemarker. Once you understand the file specs from your bank (ACH/EFT and Positive Pay) you will be able to adjust the templates accordingly. As mentioned by others, the biggest issue is timely, accurate communication with your bank for file validation.

Are you using SFTP module to communicate with the bank or just generating payment file and manually processing the file through bank's portal. As @Ryan B said without the paid EBP you are limited to only single currency and country payment. I am attaching the EBP guide - it will help you understand the whole process

we've written a template from scratch before, it's not too bad. From memory our issues were getting the counters to auto-increment, as our bank checks your identifier on the past seven submissions to see if it's a repeated file. Once we figured out a way to generate these uniquely, we were fine