I'm beginning the process of creating an EFT file format for our NatWest account here in the UK and realised one of the community may have already created and EFT Format ID to for this bank. If so, would you be happy to export is and share with me to save me many hours of strife?
Thanks :)
*This post is locked for comments
thank you I will try that.
Hi, like everything, I didn't have much time and so ended up making a bit of a bodge in the system which works for our purposes, effectively making it mirror the EFT format we'd previously used. Here's a link to the Export file: https://vtctuk-my.sharepoint.com/personal/dunderwood_vtct_org_uk/_layouts/15/guestaccess.aspx?docid=0a161a07c2768401385912f52671d561d&authkey=AUO7GugI_FfuIb33IL50wKo
If you open with notepad, you should see similar to the below but tab delimited. You'll need to change the YYYYYYXXXXXXXX to the sort and account code.
It's messy but works.
EFT File Format Maintenance
NatWest 12 1 2 0 0 0 0 0 0 4 0 0 1
3 16384.00000 1 Header1 1 ,,,08,,,N,,SUPPLIERS,,,,YYYYYYXXXXXXXX,,,,,, 44 0 0 0 4 1 0 0 0 0
3 32768.00000 2 Batch Date 3 8 0 0 0 18 1 0 0 8 0
3 49152.00000 3 Header2 1 ,,,,,,,,,,,,,,,,,,CompanyName,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 65 0 0 0 4 1 0 0 0 0
5 16384.00000 1 Detail1 1 ,,,09,,,,,,,,,,,,GBP, 21 0 0 0 4 1 0 0 0 0
5 32768.00000 2 ChequeBook Amount 2 cmTransactionEFT Checkbook Amount 10 0 0 0 2 2 0 2 0 0 0
5 49152.00000 3 Detail2 1 ,,,,,,,, 8 0 0 0 4 1 0 0 0 0
5 65536.00000 4 Sort Code 2 cmTransactionEFT EFT Bank Code 6 0 0 0 4 1 0 0 0 0 0
5 81920.00000 5 Detail3 1 ,,,,,, 6 0 0 0 4 1 0 0 0 0
5 98304.00000 6 Account Code 2 cmTransactionEFT EFT Bank Account 8 0 0 0 4 1 0 0 0 0 0
5 114688.00000 7 Detail4 1 ,, 2 0 0 0 4 1 0 0 0 0 0
5 131072.00000 8 Vendor Name 2 PM_Vendor_MSTR Vendor Name 13 0 0 0 4 1 0 0 0 0 0
5 147456.00000 9 Detail5 1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 47 0 0 0 4 1 0 0 0 0
Hi Daniel
Did anyone come back to you on this with a format? as I need one for one of my clients?
Laura
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (