The deposit file lists out all ACH deposits across all merchant accounts under an account ID and includes the below fields.
File Name: PaymentDepositReport-CCYYMMDD-CorporateID.txt
| Field # | Field Name | Format | Required? | Min | Max | Comment |
|---|---|---|---|---|---|---|
| 1 | Record ID | "IMPDF20"y | Y | 7 | 7 | |
| 2 | Merchant ID | AN | Y | 1 | 50 | The unique ID associated with your merchant processing account, which will be given by your Implementations Manager. |
| 3 | Merchant DBA Name | AN | Y | 1 | 50 | |
| 4 | Funding Date | DT | Y | 14 | 14 | Date/time in CCYYMMDDHHMMSS format. |
| 5 | Effective Date | DT | Y | 14 | 14 | Date/time in CCYYMMDDHHMMSS format. |
| 6 | Sales Volume | DEC | Y | Dollar Amount | ||
| 7 | Refund Volume | DEC | Y | Dollar Amount | ||
| 8 | Chargeback Volume | DEC | Y | Dollar Amount | ||
| 9 | Fees | DEC | Y | Dollar Amount | ||
| 10 | Trace Number | AN | Y | 1 | 50 | |
| 11 | Routing Number | AN | Y | 1 | 50 | |
| 12 | Account Number (DDA Last Four) | AN | Y | 4 | 4 | Example: 1234 |
| 13 | Total Deposit | DEC | Y |