Small and medium business | Business Central, N...

Chase Bank NACHA Data Exchange Definition

(7) Share

Report

Posted on by DS-07072328-0

Hello,

In D365 Business Central (cloud--version 26.1), I am needing to create a Data Exchange Definition for JPMorgan Chase Bank using their NACHA standards (attached specs from Chase).

This is for exporting the EFT file on a Payment Journal to upload ACH payments to Chase Bank.

Does anyone have any experience with building the Data Exchange Definition out for Chase Bank, or have a working XML import file? The need is urgent for the client.

Thanks for your help!

Categories:

Dynamics 365 Business Central

cbo_nacha_filespe...

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (1)

Report
Hi

BC (cloud, version 26.1) supports Data Exchange Definitions for EFT exports, and Chase’s specifications follow standard NACHA formatting with a few institution-specific requirements.

Here’s how you can configure the definition correctly:

1. Create a New Data Exchange Definition

Navigate to Data Exchange Definitions

Configure a new definition with:

Direction: Export

File Type: Fixed Text

Encoding: ASCII

Processing Codeunit: 1221 (US EFT Export)

Format Name: CHASE_NACHA

2. Define Required Line Types Based on Chase’s Format: Your export file must include:

File Header Record (Type 1)

Batch Header Record (Type 5)

Entry Detail Record (Type 6)

Addenda Record (Type 7) – optional, for remittance/memo data

Batch Control Record (Type 8)

File Control Record (Type 9)

Ensure each line definition matches field positions and required values per the Chase spec. For example, use Service Class Code 220 for credits or 225 for debits, and set Immediate Destination Name as "JPMORGAN CHASE".

3. Column Definitions & Field Mapping
Each record type requires fixed-length fields with proper alignment:

Numeric fields: right-justified, zero-padded

Alphanumeric fields: left-justified, space-filled

Mandatory fields include routing numbers, account numbers, and company identifiers

Map fields to journal values (Vendor Name, Bank Account No., Routing No., Payment Amount, Memo fields, etc.)

4. Assign Format in Bank Export Setup

Go to Bank Export/Import Setup

Create a new entry linked to your data exchange definition

Assign the format to the relevant Bank Account Card to ensure it’s used during EFT export

Additional Tips

Do not include offset records or pre-note transactions—Chase does not accept balanced files

Company Discretionary Data must contain the Chase account number in a 20-digit zero-padded format

Ensure Effective Entry Date is set at least one business day ahead of the file creation date

Helpful Reference and Sample Guide
Microsoft Learn – Configure Data Exchange Definitions for EFT
ACH Export Guide for JPMorgan Chase

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

A How-to Video on Configuring the Data Exchange File for EFT

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (1)

Report

Adding more details

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (1)

Report

I actually just did this for another client. Chase's documentation is good, so took about two hours to build it out. I can't provide client content for free, but feel free to reach out directly if you want to discuss options.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No