vAccount ACH Receiving File Layout
v3.5
Overview
This file type delivers ACH transaction data for debits and credits received for the Platform's vAccounts and applied to the program's settlement account. This file type is provided several times a day. Every time the file is produced, entries only include records that have not been sent to the Platform in previous files.
File Name
VirtualAccounts_v3_5 CompanyShortName yyyyMMddHHmmss.json
VirtualAccounts_v3_5 CompanyShortName yyyyMMddHHmmss.csv
- VirtualAccounts_v3_5 indicates the file type and version.
- CompanyShortName is the short name assigned to the company by Evolve.
- yyyyMMddHHmmss is the timestamp for when the file is sent.
Format Options
This file type is available in both CSV and JSON format.
File Direction
This file is sent to the Platform from Evolve.
Delivery Location
These files are delivered by default into a 'vaccount' subfolder of the Platform's primary folder on Evolve Bank & Trust's sFTP server (sftp.getevolved.com). However, the Platform may choose a different subfolder if desired.
Delivery Window
The vAccount ACH Receiving file default delivery timeframe is every 30 minutes throughout the day. When the file is produced, entries only include records that have not been sent to the Platform in previous files.
Each file delivery looks 5 days back for undelivered files. Each Saturday file delivery looks 30 days back.
Best Practice
When designing automated processes to pick up data received from Evolve, always look for new files. Delivery window times are subject to change or to be added as needed.
File Size
This file will contain no more than 2,000 records. If there are more than 2,000 returns in a single delivery window, then multiple files will be provided.
Unique Identifiers
Use the following fields in your vAccount ACH Receiving v3.5 data extract to create unique transaction identification for ACH Receiving records:
- CoreBatch
- CoreFileKey
- CoreSeq
Additional information on these fields can be found in the vAccount ACH Receiving File Field Descriptions & Usage Table shown below.
REMINDER:
The CoreBatch, CoreFileKey and CoreSeq unique identifier fields are currently related to ACH Receiving transactions and may not be present for certain transaction types, including but not limited to:
- Memo Credit/Debit transactions
- Wire transactions
- Return Origination (ReturnGen) transactions
- Check transactions
- ACH Origination (CoreBatch and CoreFileKey present; no CoreSeq value)
Future iterations and enhancements will address these transaction types.
CSV Guidelines
- Each record is located on a separate line, delimited by a line break (CRLF).
- The last record in the file may not have an ending line break.
- There will be a header line appearing as the first line of the file with the same format as normal record lines. This header will contain names corresponding to the fields in the file and will contain the same number of fields as the records in the rest of the file.
- Within the header and each record, there will be one or more fields, separated by commas. Each line should contain the same number of fields throughout the file. Spaces are considered part of a field and should not be ignored.
- The last field in the record will not be followed by a comma.
- Fields containing line breaks (CRLF), double quotes, and commas will be enclosed in double-quotes.
vAccount ACH Receiving CSV Sample Data
Name,Amount,TranCode,ODFI_trace,AccountVirtual,AccountActual,Addenda,ODFIRT,ODFIAcct,tsACHReceived,CED,SEC,IIN,CID,DiscrData,PostingData,CIFGRP,EffectiveDate,CoreBatch,CoreFileKey,CoreSeq
93.63,32,55555015152762,1234567891232388,1234567890,SAMPLE ADDENDA,051000017,1234567891232388,2019-11-21T03:40:42,CORP PYMNT,CTX,615216510059518,C650000600,APIAP4::,123,2019-11-22T00:00:00,2204.0,0841234567890987654321012,1.0
Platform Inc.,1933.23,27,2222150006240,1234567891238264,1234567890,SAMPLE,DATA,026073150,1234567891238264,2019-11-21T01:48:00,CrossWise,PPD,7453233521,CrossWise Inc::Platform Inc.,123,2019-11-21T00:00:00,2545.0,0841234567890987654321012,1.0
John Smith,800,27,88000010367781,1234567891236983,1234567890,SAMPLE DATA,091000019,1234567891236983,2019-11-21T01:48:00,PAYPAL,WEB,770510487C,ANINN::John Smith,123, 019-11-21T00:00:00,2888.0,0841234567890987654321012,1.0
vAccount ACH Receiving JSON Sample Data
[
{
"CIFGRP": 123,
"Name": "",
"Amount": 93.63,
"TranCode": 32,
"ODFI_trace": "55555015152762",
"AccountVirtual": "1234567891232388",
"AccountActual": 1234567890,
"Addenda": "SAMPLE ADDENDA",
"ODFIRT": "051000017",
"ODFIAcct": "1234567891232388",
"tsACHReceived": "2019-11-21T03:40:42",
"CED": "CORP PYMNT",
"SEC": "CTX",
"IIN": "615216510059518",
"CID": "C650000600",
"DiscrData": "",
"PostingData": "APIAP4::",
"EffectiveDate": "2019-11-22T00:00:00",
"CoreBatch": 2204.0,
"CoreFileKey": "0841234567890987654321012",
"CoreSeq": 1.0
},
{
"CIFGRP": 123,
"Name": "Platform Inc.",
"Amount": 1933.23,
"TranCode": 27,
"ODFI_trace": "2222150006240",
"AccountVirtual": "1234567891238264",
"AccountActual": 1234567890,
"Addenda": "SAMPLE, ADDENDA",
"ODFIRT": "026073150",
"ODFIAcct": "1234567891238264",
"tsACHReceived": "2019-11-21T01:48:00",
"CED": "CrossWise",
"SEC": "PPD",
"IIN": "",
"CID": "7453233521",
"DiscrData": "",
"PostingData": "CrossWise Inc::Platform Inc.",
"EffectiveDate": "2019-11-21T00:00:00",
"CoreBatch": 2545.0,
"CoreFileKey": "0841234567890987654321012",
"CoreSeq": 1.0
},
{
"CIFGRP": 123,
"Name": "John Smith",
"Amount": 800,
"TranCode": 27,
"ODFI_trace": "88000010367781",
"AccountVirtual": "1234567891236983",
"AccountActual": 1234567890,
"Addenda": "SAMPLE ADDENDA",
"ODFIRT": "091000019",
"ODFIAcct": "1234567891236983",
"tsACHReceived": "2019-11-21T01:48:00",
"CED": "PAYPAL",
"SEC": "WEB",
"IIN": "",
"CID": "770510487C",
"DiscrData": "",
"PostingData": "ANINN::John Smith",
"EffectiveDate": "2019-11-21T00:00:00",
"CoreBatch": 2888.0,
"CoreFileKey": "0841234567890987654321012",
"CoreSeq": 1.0
}
]
vAccount ACH Receiving File Field Descriptions & Usage Table
Field Name | Data Type | Data Validation | Description |
---|---|---|---|
CIFGRP | int | Platform grouping for SaaS providers | |
Name | string | Name received from Originating Depository Financial Institution (“ODFI”) on incoming transaction. This name is intended to be the beneficiary of the transaction’s name and should generally match the name of the user onboarded to the Platform | |
Amount | numeric | Unsigned amount of the transaction | |
TranCode | numeric | 2 digit NACHA transaction code that describes what type of transaction was received. Valid Values: 22 Checking Deposit (Credit) 27 Checking Withdrawal (Debit) 23 Pre-Note: Checking Deposit (Credit) 28 Pre-Note: Checking Withdrawal (Debit) | |
ODFI_trace | string | Unique identifier created by ODFI for this transaction. Incoming Trace IDs are unique per ODFI, per Platform, per Effective Date. Note: Trace numbers may need to be 0 left filled up to 15 digits. | |
AccountVirtual | string | 10 to 16 digit vAccount number. This is the account number that was issued to the user. | |
AccountActual | decimal | vAccount Settlement Account number. This is the Evolve account number which received the debit or credit for the transaction. | |
Addenda | string | This record contains additional information relating to the transaction. This record combines all payment related addenda information from the 7 record into a single string with an 80 character maximum. | |
ODFIRT | string | Routing Number of ODFI | |
ODFIAcct | string | *Deprecated field – current value is an unnecessary duplicate vAccount Number (AccountVirtual) | |
tsACHReceived | string | yyyy-mm-ddThh:mm:ss | Timestamp or date only in timestamp format for when ACH was received at Evolve |
CED | string | Company Entry Description (CED) is intended to describe the purpose or intent of a transaction. | |
SEC | string | ACH Standard Entry Class code. Valid values for ACH Origination transactions are outlined here. For ACH Receiving transactions, valid Standard Entry Class may include those outlined on the NACHA ACH File Details page shown here. | |
IIN | string | Individual Identification Number is used by the originating business to identify the individual being debited or credited. | |
CID | string | Company ID is the numeric identifier of the ACH Originator. | |
DiscrData | string | Discretionary Data is the field used by the originator to describe a batch of transactions for internal purposes. | |
PostingData | string | Statement posting data. This information is generally displayed to the user on a statement. This contains the ACH Company Name, Company Discretionary Data, and Individual Name separated by ‘:’. • ACH Company Name is the name of the originator. • Company Discretionary Data is field used by the originator to describe a batch of transactions for internal purposes. • Individual Name is benefactor of the transaction. See note on ‘Name’ above. | |
EffectiveDate | date | yyyy-mm-ddThh:mm:ss | Date originator intended for transaction to be effective. Incoming transactions can be received up to two days in advance. See Release 2019.11 for more information. |
CoreBatch | numeric | Evolve Core System-assigned Batch number. | |
CoreFileKey | string | Evolve Core System-assigned File Key | |
CoreSeq | numeric | Evolve Core System-assigned Sequence number _Note: CoreSeq will not be visible for transactions where Evolve is the originating bank (ODFI), as origination transactions report at batch level. |
Statements
Posting Transactions
Transaction posting to a customer statement must be compliant with NACHA Operating Rules Subsection 3.1.5.1
An RDFI must provide or make available to each of its Receivers the following information concerning each credit and debit Entry to a Consumer Account of such Receiver:
- posting date to Receiver's account;
- dollar amount of the Entry;
- company name/Originator name (Note: For credit WEB Entries for P2P payments, the name of the consumer Originator is located within the Individual Identification Number field of the Entry Detail Record); for credit WEB Entries for Reversals the name of the Originator is located in the Company/Batch Header Record);
- company Entry description;
- account type;
- account number;
- amount of any charges assessed against the account for services related to the Entry;
- balances in the Receiver’s account at the beginning and at the close of the statement period;
- for an ARC, BOC, RCK, or XCK Entry, or an IAT Entry where the Transaction Type Code field contains a value of “ARC,” “BOC,” or “RCK,” the Check Serial Number;
- for an MTE, POS, or SHR Entry, or an IAT Entry where the Transaction Type Code field contains a value of “MTE,”
“POS,”
or “SHR,” the:
- terminal identification code and/or terminal location, as those terms are defined in Regulation E;
- terminal city, as that term is defined in Regulation E; and
- terminal state, as that term is defined in Regulation E;
- For a POP Entry, or an IAT Entry where the Transaction Type Code field contains a value of “POP,” the:
- Check Serial Number;
- terminal city, as that term is defined in Regulation E; and
- terminal state, as that term is defined in Regulation E;
- Address and telephone number to be used for inquiries or notices of errors preceded by “Direct Inquiries To” or similar language.
Release Notes - v3.5
- Added CSV file name example in "File Name" section
- Added CoreBatch, CoreSeq, and CoreFileKey
- Added CoreBatch, CoreSeq and CoreFileKey to CSV and JSON examples
- Updated File Size section to reflect 2,000 max records per file.
- Corrected file naming conventions ("File Name" section).
- Updated TranCode, Trace and Addenda field descriptions.
- Updated data types for tsACHReceived and EffectiveDate fields.
Updated 9 months ago