Skip to main content
Business Central forum
Suggested answer

Business Central - Balanced Nacha File

editSubscribe (0) ShareShare
ReportReport
Posted on by 5
Hello, 
 
I have seen several posts regarding issues creating a balanced Nacha File in the data exchange definitions, but nobody has been able to answer these questions with helpful information (I see video links, links to other websites, etc. but none of them cover this issue). 
 
I have three clients who are using the same bank (Coastal Community), which notified me they will now require a Balanced Nacha File. We have used the unbalanced Nacha file from Business Central for years, but I have to figure out how to add a single offsetting line to the Detail Lines (lines that start with a 6), and somehow get Business Central to recognize it as a credit rather than a debit.
 
I have been able to add a second Detail to the data exchange definition, but it adds a new line after each payment rather than a single line at the bottom of the detail. Additionally, it is not being recognized as a Credit, so the total batch/file Debits are increased by these amounts (not affecting total batch/file credits). We were able to achieve this in Dynamics NAV, so I find it hard to believe there's no option for this in Business Central.
 
If anyone has had any luck creating a data exchange definition for a balanced Nacha file, I would love to hear what has worked. 
 
Balanced Nacha File: 
 
  • Offsetting line as the final Detail Line (representing the amount coming out of the client's bank account). 
    • Record Type: 6
    • Transaction Code: 27
    • Amount: Credit amount that is equal to the sum of all Debits in the batch
  • Debits and Credits should be equal.
    • The Batch Footer 
      • Record Type: 8
      • Total Debit and Total Credit amounts should be equal
    • The File Footer
      • Record Type: 9
      • Total Debit and Total Credit amounts should be equal
 
Let me know if there's further information that could help with this. The bank has indicated that they do not have a sample file for comparison (just further complicating things).
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 3,539 Super User on at
    Business Central - Balanced Nacha File
    I don't believe bank doesn't have a sample file. without it, it would be impossible to mimic the format. Banks won't talk to partner directly so ask your customers to pest them for one. 
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,415 UG Leader on at
    Business Central - Balanced Nacha File
    Did you try using the CCD Default data definition, you should not have to make any changes.
  • Business Central - Balanced Nacha File
    Hi there, did you ever come up with a resolution? We have a customer
    with this exact same issue

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans