This article covers how to import ACH Debit transactions into advance(s) in bulk. Currently, only ACH Debit transactions are supported for import.
Assumptions:
Importing user is a Super Admin or has the Import ACH Debits permission enabled for their role.
Setting up your CSV file
Below is a list of fields that should be listed as columns in your CSV file
| Field Name | Required/Optional | Description |
| Advance ID | Required | ID of the Advance |
| Amount | Required | Transaction Amount |
| Process Date | Required | Target Processing Date (can be future or past) |
| Status | Optional |
Open Pending Cleared Returned/NSF |
| Returned Date | Optional (required for transactions with Returned/NSF Status) |
Date of transaction return |
| Return Code | Optional (required for transactions with Returned/NSF Status) |
ACH Return Code (ex: R01) |
| Cleared Date | Optional (required for transactions with Cleared Status) |
Date of transaction clearing |
| Transaction Type | Optional |
Only accepts "ACH Client Debit" |
| Transaction Sub Type | Optional |
Subtype for transaction |
| External ID | Optional |
Transaction ID from external processor |
| Account Number | Optional |
Borrower's Bank Account Number |
| Routing Number | Optional |
Borrower's Bank Routing Number |
| Gateway ID | Optional |
ID of Processing Gateway 6 - Other (no gateway) 39 - ACHWorks 74 - ACH Processing Company 79 - Actum 141 - ACHBanking.com 159 - Cuttlefish Payments |
| Active | Optional |
0 - Inactive 1 - Active |
| Memo | Optional |
Transaction memo |
Here is an example of what your CSV File could look like.
Importing the ACH Debits
Navigate to the Advances Tab, and find the "Import ACH Debits" button.
In the modal that opens, click to browse your computer for the CSV file or simply drag and drop it onto the page:
Under the "Mapped CRM Field" column, select the CRM Field that corresponds to the appropriate column on your CSV file.
Click on Submit to import the debits. This feature supports multiple debits on multiple advances in a single file.
Not Supported
This actions are not currently supported by the ACH debit importer.
- Importing non-debit transactions
- Updating existing transactions
- Creating syndicate splits from cleared debits