How-to: Import a Recovery File (Merchant Portal)

Procedure

Log in
- Log into the reporting website with your user credentials.
Access the Recovery Section
- Navigate to the Main Menu and select Recovery.
Navigate to Import Files
- Click the Import Files option.
Upload the Recovery File
- Click Upload File button.
Select the Record Type
- Select Recovery Item Batch as the record type that you are uploading.
(Optional) Select the Field Mapping Configuration
- Select the Field Mapping Configuration that you are using. This is only necessary if you had a need to map fields from your system to our system.
Select the File
- Click Browse Files or drag and drop the file you want to upload.
Confirm Upload
- Click the Upload button once the file is selected.
Complete the Process
- Click Done after the upload is complete.
Close the Upload Window
- Click the Close button to exit the upload interface.
Review the Status
- Check the Status column:
  - Processed means the file successfully created one or more payments.
  - Failed indicates an issue with processing; download the response file for more details.
Check the Results
- Review the Results column to see the number of payments created.
(Optional) Download the Response File
Tip: If the file failed or not all records were successfully created, download the Response File for detailed information.
- Click Actions and then select Download Response File to view line-by-line results and any error messages.

File Upload Formats

Our system accepts files in .zip, .pdf, .ach, .x937, .x9, .937, .dat, and .icl formats.

Related Files

PaymentFile-Sample.xlsx - This example file shows you what the payment file should look like.

PaymentFile-Empty.xlsx - This is an empty file that you can use for uploading your payments.

Fields

The following table provides clarification on the fields contained in a payment file.

Field	Required	Description
MerchantId	Always	The unique Id of the originating Merchant to associate this transaction with. This value will be provided to you when your Merchant account is setup.
Name	Required when Face_Transaction is PPD, CCD, TEL, WEB, RCK and Draft.	The name of the receiver. This is the person who wrote the original check or authorized the original payment.
Face_Amount	Always	The amount of the original item.
Original_Item_Date	Always	The date of the original item. This is the date on the original check or the date the original payment was authorized.
Return_Date	Always	The date the item was returned.
Route_Number	Always	The nine digit routing number of the financial institution.
Account_Number	Always	The account number at the financial institution.
Account_Type	Always	The type of account at the financial institution. Values: GeneralLedger, BusinessChecking, BusinessSavings, PersonalChecking, PersonalSavings
Face_Transaction	Always	The NACHA Standard Entry Class Code for the ACH payment. Values: CCD - Use this code for business accounts EXCEPT if it was a business check PPD - Use this code for debits to personal accounts when authorization was provided by signed agreement or when sending a credit to a personal account RCK - Use this code if there was a personal check that was originally deposited at the bank and has since returned TEL - Use this code for debits to personal accounts when oral authorization was obtained over the telephone WEB - Use this code for debits to personal accounts when authorization was obtained in accordance with the requirements for internet-initiated entries
Return_Reason	Always
Check_Number	Required when Face_Transaction is ARC, BOC, POP, RCK or Draft.
Identification_Number	Optional	Typically this indicates an account number or identifier in the original system of record. The value in this field may be shown on the receivers bank statement.
ACH_Payment_Type_Code	Required when Face_Transaction is TEL or WEB.	Used to indicate additional information regarding TEL or WEB payments. Values: S, R. S = Authorization was for a single payment R = Authorization was for a recurring payment