web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / HSBC BACS File
Small and medium business | Business Central, N...
Suggested Answer

HSBC BACS File

(6) ShareShare
ReportReport
Posted on by VL-22011630-0 12
HI,
 
Wondering if anyone can help me, I am trying to set up our system so we can export our payment run to HSBC. I have tried looking for screenshots of the system and headings we need to use but can't, Below are the headdings we need to be using:
 
VOL1HSBC03                     HSBC                                            1
HDR1A      S         HSBC0300010001       23340 24006 000000                    
HDR2F0200000100                                   00                            
UHL1 23341999999    000000001 DAILY  001                                        
38-82-1151996809912345612345678    00001284925Tec            Tec            MID SUSSEX DISTRIC 23341
38-82-1151996809912345612345678    00000179640Tec            Tec            MID SUSSEX DISTRIC 23341
38-82-1151996809912345612345678    00000404190Tec            Tec            MID SUSSEX DISTRIC 23341
1234561234567801712345612345678    00001868755                  CONTRA            Tecman             23341
EOF1A      S         HSBC0300010001       23340 24006                           
EOF2F0200000100                                   00                            
UTL10000001868755000000186875500000010000003                                    
 
Any help would be much appreciated
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,876 Super User 2026 Season 1 on at
     
    You can use the Generate EFT File function of Business Central to generate the variable text file.
     
     
    However you need to setup the data exchange definition for your bank in the required format.
     
     
    If this does not work out, you can customize the export based on some action.
     
    Regards,
    Dhiren.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,242 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Dynamics 365 Business Central Blog Series: Import and Export data
     
    Thanks.
    ZHU
  • Suggested answer
    Assisted by AI
    OussamaSabbouh Profile Picture
    OussamaSabbouh 11,394 Super User 2026 Season 1 on at
    Hello,
     
    What you’re trying to generate is not a set of headings you configure in Business Central — it’s a fixed-width UK BACS Standard 18 payment file (HSBC-specific) where records like VOL1, HDR, UHL, EOF, etc. are produced automatically by BC based on a Data Exchange Definition + Bank Export Format. You won’t find screenshots or editable columns for this. If your output doesn’t match HSBC’s spec, it usually means you’re using the wrong or missing HSBC BACS Data Exchange Definition. The fix is to verify or import an HSBC-compliant BACS definition, link it to your Bank Account → Payment Export Format, and export payments from the Payment Journal. Many customers rely on a partner-provided HSBC format because character positions must be exact and are not configurable via UI.
     
    Regards,
    Oussama Sabbouh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans