Good afternoon, thank you for the add! I posted this in Reddit and then saw the Join Slack Group 🙂 Implementation Jun 2021. Location: Toronto, Canada We bank solely with HSBC. We have only been able to make EFT payments to our Canadian vendors using NetSuite and HSBC and this is done via a .txt. file to upload as our implementation team says direct connect is not possible with our bank. Anyways, not a problem, we generally only pay suppliers and vendors 1x a month so we work with it. US suppliers/vendors = cheque. However, we just had a US vendor rip up our CDN cheque because their banks 'won't accept it'. This is a long term vendor, so I don't think they're lying. We don't use CC to make any type of payments except for admin purchases and while we can do priority payments, my boss HATES them because it is manual. While we don't have a lot of US vendors, it is becoming a headache. We recently got a new rep at HSBC and he asked us if we needed anything and we brought up the US vendor payment issues. He pointed us to and gave us literature for "US Cross Border ACH". I'm pretty adept and I'd like to create this file myself but have a couple of questions. 1. Is it possible to do this ones self? 2. Does anyone know what file format the HSBC US CB ACH resembles so I can use that to edit; I have 61 templates and not sure which one to use to start off of (currently looking at my CPA-005. 3. If I cannot do this myself is there an average cost for someone else to do this? We are okay to pay and actually are looking for NetSuite scripting/workflow sub-contractors to work with us on other customizations we need in the near future. Thank you!

In my experience the bank needs to tell you the file format. It’s up to their technology team to know what format their system will accept

Hi all, sorry for the silence. I went on vacation shortly after the post and then of course life in the Controller/NS world took over. We did have the Advanced Electronic Payments module, that was good. Then HSBC provided the XML format they required and I was able to used the HSBC ISO 20022 (Singapore) payment file format template (opened a lot of templates to see similarities to the HSBC XML file I was provided) to create what I needed. It was fun (I love learning new things and taught myself HTML/XML/CSS years ago for a hobby). I am also thankful that my role allows for learning/playing in NetSuite as well do my Controller function. The biggest issue was not NetSuite but HSBC sending me TWO wrong files before giving me the right one (after working on both). We got it to work finally yesterday and I learned a lot of things.