Data Exports: NACHA

Modified on Tue, Aug 18 at 12:27 PM

TABLE OF CONTENTS

Export Details
What's Included in This Export
Terminology
Ingesting Exports Into Your Data Warehouse
Data Dictionary
Related Articles
Frequently Asked Questions

The NACHA Report provides an aggregated and enriched view of the transactions included in a specific NACHA file, aligned exactly with what was sent to partners.

Export Details

Frequency: Daily
Channel: SFTP or File Transfer API
Format: .csv, pipe-delimited, double-quoted

Important: The file uses a .csv extension, but fields are separated by pipes (|), not commas. Make sure your ingestion process is configured to parse it accordingly.

The data included follows a fixed, predetermined format that scales across 100+ credit unions.

What's Included in This Export

Each file contains transactions from NACHA files sent in the past 1 day.

File name (SFTP only): nacha-1-day_YYYYMMDDThhmmssZ_part-00000.csv

When using the File Transfer API, the .csv file is delivered inside a .zip archive.

This export covers transactions for both personal and business accounts. Use APPLICATION_TYPE to tell them apart.

Important: Business applications were previously excluded from this export. Now that they're included, expect your row counts to increase — not just the column count. If your ingestion logic assumes every record represents a personal account, or if you reconcile on row counts, review it before you next process this file.

Terminology

A business application opens an account for a business entity rather than an individual. Business applications are identified by APPLICATION_TYPE = business. On these records, MEMBER_NUMBER, APPLICANT_FULL_NAME, and APPLICANT_EMAIL refer to a single resolved authorized signer for the business — the controlling signer where one is designated, otherwise the earliest signer on the application.
A reversal is a document that reverts a previously sent NACHA file, either in part or in full. Reversals are identified by IS_REVERSAL = true, with ORIGINAL_NACHA_DOCUMENT_ID pointing back to the document being reverted.

Ingesting Exports Into Your Data Warehouse

Update: If a record already exists in your data warehouse as a row in a table, update the entire row. If it doesn't exist, create a new row.
Append: Always add new rows to the existing table.

Data Dictionary

New fields are always appended to the end of the file — existing fields are never renamed, reordered, or removed. If you enforce a strict schema on ingestion, allow for additional trailing columns.

Field Name	Description	Example
PARTNER_ID	String: partner identifier UUID.	0030dbe4-ead5-4543-afa1-61d24688b4ef
PARTNER_ALIAS	String: partner alias.	mycreditunion
NACHA_DOCUMENT_ID	String: document identifier UUID.	91290a0f-579d-4de0-824f-0a510a619a8c
NACHA_FILE_NAME	String: NACHA .txt file name.	2026-01-21:20-00-35-nacha-file.txt
NACHA_DOCUMENT_TYPE	String: NACHA or NACHA_REVERSAL.	NACHA_REVERSAL
IS_REVERSAL	Boolean: whether this is a reversal document.	false / true
ORIGINAL_NACHA_DOCUMENT_ID	String: the UUID identifier of the original document being reverted.	462d46f6-76a2-4d66-8716-4046ac0a6ee7
REVERSAL_TYPE	String: PARTIAL, FILE, or null.	FILE
NACHA_GENERATED_AT	Datetime: when the file was created.	2026-01-21T20:00:35.990+00:00
NACHA_TRANSACTION_COUNT	Integer: total transactions in the file.	3
NACHA_TOTAL_AMOUNT	Decimal(13,2): total amount in the file.	123.45
APPLICATION_ID	String: application identifier UUID.	5f2ff68e-fb74-4303-ad9a-2169cc0d543b
APPLICATION_NUMERIC_ID	Integer: human-readable application identifier.	1242840
APPLICATION_STATUS	String: application status.	accepted
APPLICATION_CREATED_AT	Datetime: when the application was created.	2026-01-21T18:08:12.815+00:00
MEMBER_NUMBER	Number: applicant's member number. On business records, the resolved authorized signer.	292470
APPLICANT_FULL_NAME	String: applicant's full name. On business records, the resolved authorized signer.	John Doe
APPLICANT_EMAIL	String: applicant's email. On business records, the resolved authorized signer.	john.doe@withclutch.com
FUNDING_CHARGE_ID	String: funding charge identifier UUID.	b176d767-6d34-4365-a9c2-ab4447a20bc8
FUNDING_CHARGE_AMOUNT	Decimal(13,2): funding amount.	567.80
FUNDING_CHARGE_TYPE	String: funding charge type.	ach
FUNDING_CHARGE_STATUS	String: funding charge status.	completed
NACHA_FILE_ELIGIBLE_TRANSACTION_ID	String: eligible transaction identifier UUID.	ef5b0ac5-9345-4f8a-ad06-8355192109dc
NACHA_FILE_ELIGIBLE_TRANSACTION_CREATED_AT	Datetime: when the transaction was added to the NACHA file.	2026-01-21T18:10:08.260+00:00
APPLICATION_TYPE	String: whether the underlying application is for a personal or a business account. Possible values: personal, business.	business
BUSINESS_ID	String: business entity identifier UUID. Null on personal records.	3f9a2c71-8d04-4e2b-9a17-b5c8e0f4a921
BUSINESS_NAME	String: legal or operating name of the business. Sourced from the entity's legal name, falling back to company name, then DBA name, then the authorized signer's name. Null on personal records.	Northgate Landscaping LLC

Data Exports: Funding — funding transactions across all methods, not just ACH.
Data Exports: Account Opening — application-level detail for the accounts these transactions fund.
Data Exports: API vs SFTP Delivery — how exports are delivered, and how to choose between the API and SFTP.

Frequently Asked Questions

How Can I Get Started With Data Exports?

Ask your Implementation team or Customer Success Manager to turn it on for you. We recommend querying files through the File Transfer API, which makes it easy to build automations, set retries, or pull retroactive files. Alternatively, you can use SFTP, which requires setting up a connection (and may involve your IT team) and hosting your own server.

Why Should I Use Clutch's Data Exports?

Data exports keep your team informed without needing to request ad hoc reports. They work for both operations and IT teams: operations can open the .csv file in Excel or Google Sheets, while IT can ingest the data directly into your data warehouse to build reports on top of it.

What's the Cost?

Clutch does not charge any additional fees. If you choose SFTP, you'll need to host your own SFTP server. If you use the File Transfer API, only minor configuration is required on your side.

How Long Are the Exports Available for Download?

With SFTP, retention is up to you, since you host the server. If you need retroactive files, submit a ticket with our support team. With the File Transfer API, new exports are generated daily and remain available for one week, so you can query them whenever you need to.

What Should I Do if I Didn't Receive My Daily File?

Contact our support team at support@withclutch.com for assistance.

I Lost Access to a File and Need to Recover a Copy. How Can I Get It?

If you're using the File Transfer API, you can re-query the file using its reference date. If you're using SFTP, contact your Customer Success Manager to arrange a recovery.

I Need a Data Export for Sandbox Data. How Do I Get It?

Sandbox environments only contain test users and can be misleading for data interpretation, so we do not support sandbox data exports.

How Can I Request a New Data Export to Answer New Business Questions?

Let us know what you're trying to achieve. Your Implementation team can guide you on whether an existing export already answers your question, or share your request with our product team.

What Should I Do if I Want Additional Fields in My Data Export?

Custom fields per credit union aren't currently supported, and new fields are typically added on a quarterly basis. Contact your Implementation team or Customer Success Manager to let them know which fields you need.

What Should I Do if I Want to Report Inconsistencies in the Data?

Let your Implementation team or Customer Success Manager know, or submit a ticket to our support team at support@withclutch.com, and we'll assign an engineer to investigate right away.