RebateByACH Batch File Processing RebateByACH transactions are transactions which are sent from a business to another business or person in the form of an electronic credit to a checking account. If you already have a Professional account, then there are no setup fees or additional monthly fees to use the Batch service. Just let us know when you want to start by sending an email to support@itinternet.net. You will then be ask to send at least one test file prior to going live. RebateByACH Batch File Processing uses two separate file formats: one format for posting new payments and a second format for our system's responses. Additionally, RebateByACH is an ACH Network service and therefore payments are subject to being returned or rejected for various reasons by the payees bank. Therefore, ITI prepares a returns file for each day that returns or rejects are received for the client's account. For RebateByACH Batch Processing, formatted files are uploaded to our secure FTP server ftps://ftp.secure.itinternet.net/rebatebyach/ using your MerchantID as the username. This requires an FTP client capable of FTP over SSL (FTPS) using either standard: Explicit SSL on port 21 Implicit SSL on port 990 Compatible File Formats: .csv (comma delimited) .crt (caret delimited) File 1. (for making payments) Header Record format Format csv: "id","batch number","process","count","total","toprow","bottomrow","message","reference" Format crt: id^batch number^process^count^total^toprow^bottomrow^message^reference Position Data field Description Type/Size/Notes 1 id ITI or PayByCheck account id alphanumeric, 1 - 20 characters 2 batch number Unique batch identifier assigned by client for input files. ITI uses the same identifier in response files. ITI assigns the batch numbers for files of returns alphanumeric, 3 - 20 characters 3 process ITI batch service type, should always be rebatebyach alphanumeric, 1 - 20 characters, should always be rebatebyach 4 count Total number of detail records in file. Do not include header or trailer records in detail record count. numeric, 1 - 10 characters 5 total Total dollar amount sum of all records in file. Use decimal format. numeric, decimal format e.g. 0.00, no commas, 1 - 10 characters 6 toprow The row (Unique Client Identifier/Tag) of the first record in the file alphanumeric, 1 - 20 characters 7 bottomrow The row (Unique Client Identifier/Tag) of the last record in the file alphanumeric, 1 - 20 characters 8 message Reserved Data is optional, but the field must be present in each record even if the field is empty! Field Use Reserved. 9 reference Reference field for optional client use e.g. notes regarding the file, archive information, etc. Data is optional, but the field must be present in each record even if the field is empty! Alphanumeric, 1 - 150 characters Detail Record format Format csv: "row" , "process date" , "name" , "aba" , "acc" , "amount" , "currency" , "reference" , "bankacctype" Format crt: row^process date^name^aba^acc^amount^currency^reference^bankacctype Position Data field Description Type/Size/Notes 1 row Unique Client Identifier/Tag alphanumeric, 1 - 20 characters 2 process date Date to settle / process to the ACH Network mm/dd/yyyy numeric, 10 characters including "/", optional defaults to today's date 3 name Name of payee on bank account alphanumeric, 1 - 25 characters, optional 4 aba Payee Bank Routing Transit Number numeric, 9 characters 5 acc Payee Bank Account Number numeric, 5 - 20 characters 6 amount Amount in decimal notation numeric with decimal (e.g. 9.95), no dollar sign, per-transaction limit set in Utilities 7 currency Currency Type alpha, 3 characters, optional, defaults to USD 8 reference Optional use additional reference field alphanumeric, 1 - 50 characters 9 bankacctype Code indicating Payee's (receiver's) bank account type:     checking: 22     savings: 32 numeric, 2 characters Trailer Record format Format csv: "End of File" Format crt: End of File Position Data field Description Type/Size/Notes 1 End of File End of File alpha, 11 characters Processed Response File File 2. (confirmation of payments made) Header Record format Format csv: "id","batch number","process","count","total","toprow","bottomrow","message","reference" Format crt: id^batch number^process^count^total^toprow^bottomrow^message^reference Position Data field Description Type/Size/Notes 1 id ITI or PayByCheck account id alphanumeric, 1 - 20 characters 2 batch number Unique batch identifier assigned by client for input files. ITI uses the same identifier in response files. ITI assigns the batch numbers for files of returns alphanumeric, 3 - 20 characters 3 process ITI batch service type, should always be rebatebyach alphanumeric, 1 - 20 characters, should always be rebatebyach 4 count Total number of detail records in file. Do not include header or trailer records in detail record count. numeric, 1 - 10 characters 5 total Total dollar amount sum of all records in file. Use decimal format. numeric, decimal format e.g. 0.00, no commas, 1 - 10 characters 6 toprow The row (Unique Client Identifier/Tag) of the first record in the file alphanumeric, 1 - 20 characters 7 bottomrow The row (Unique Client Identifier/Tag) of the last record in the file alphanumeric, 1 - 20 characters 8 message Reserved Data is optional, but the field must be present in each record even if the field is empty! Field Use Reserved. 9 reference Reference field for optional client use e.g. notes regarding the file, archive information, etc. Data is optional, but the field must be present in each record even if the field is empty! Alphanumeric, 1 - 150 characters Detail Record format Format csv: "row" , "ref" , "status" , "reference" Format crt: row^ref^status^reference Position Data field Description Type/Size/Notes 1 row Unique Client Identifier/Tag alphanumeric, 1 - 20 characters 2 ref Unique ITI assigned transaction reference number numeric, 1 - 20 characters 3 status Confirmation of payment status: APPROVED INVALID INVALID ROW NUMBER INVALID ACCOUNT INVALID ROUTING NUMBER INVALID AMOUNT alphanumeric, 1 - 50 characters 4 reference Optional use additional reference field alphanumeric, 1 - 50 characters Trailer Record format Format csv: "End of File" Format crt: End of File Position Data field Description Type/Size/Notes 1 End of File End of File alpha, 11 characters File 3: ACH Returns File (reporting) Returns are reported each banking day that the ACH Network has returned any transactions. Returns files will be located in ftp.secure.itinternet.net/rebatebyach/returns/ and will be named with the date that the returns were received e.g. 20020831.returns.csv Header Record format Format csv: "id","batch number","process","count","total","toprow","bottomrow","message","reference" Format crt: id^batch number^process^count^total^toprow^bottomrow^message^reference Position Data field Description Type/Size/Notes 1 id ITI or PayByCheck account id alphanumeric, 1 - 20 characters 2 batch number Unique batch identifier assigned by client for input files. ITI uses the same identifier in response files. ITI assigns the batch numbers for files of returns alphanumeric, 3 - 20 characters 3 process ITI batch service type, should always be rebatebyach alphanumeric, 1 - 20 characters, should always be rebatebyach 4 count Total number of detail records in file. Do not include header or trailer records in detail record count. numeric, 1 - 10 characters 5 total Total dollar amount sum of all records in file. Use decimal format. numeric, decimal format e.g. 0.00, no commas, 1 - 10 characters 6 toprow The row (Unique Client Identifier/Tag) of the first record in the file alphanumeric, 1 - 20 characters 7 bottomrow The row (Unique Client Identifier/Tag) of the last record in the file alphanumeric, 1 - 20 characters 8 message Reserved Data is optional, but the field must be present in each record even if the field is empty! Field Use Reserved. 9 reference Reference field for optional client use e.g. notes regarding the file, archive information, etc. Data is optional, but the field must be present in each record even if the field is empty! Alphanumeric, 1 - 150 characters Detail Record format Format csv: "ref" , "reason returned" Format crt: ref^reason returned Position Data field Description Type/Size/Notes 1 ref Unique ITI assigned transaction reference number numeric, 1 - 20 characters 2 reason returned Returned Status of Transaction from ACH Network ("NSF", "ACCOUNT CLOSED", "INVALID ACCOUNT", "ACCOUNT FROZEN", "CUSTOMER ADVISES NOT AUTHORIZED", etc.) alpha, 1 - 50 characters Trailer Record format Format csv: "End of File" Format crt: End of File Position Data field Description Type/Size/Notes 1 End of File End of File alpha, 11 characters FTP   [ Top ] The FTP address for batch file processing is ftp.secure.itinternet.net Set your FTP client software to active mode, set firewall for FTP client The FTP user id is the same as the ITI Account ID and the FTP password is the same as the ITI Account password. The FTP directory is divided into folders specific to each ITI service as follows: /paybycheck /rebatebycheck /rebatebyach /rcklockbox /clickpaiddone /phonetrace /checktrace /banktrace /addresstrace /newaccounts Then each of these folders contains another folder: /processed The RebateByACH service is an ACH Network product and thus subject to return or rejection by the customer's (receiver's) bank. Therefore the RebateByACH FTP service folder will also contains a folder for return files: /returns New files uploaded for processing should be placed into the folder named with the service being used. Once the file has been processed, the response file will be found in the service's processed folder. Example: Upload your file named examplefile.csv for RebateByACH processing to: ftp.secure.itinternet.net/rebatebyach/ Pick up the response file in: ftp.secure.itinternet.net/rebatebyach/processed/ The response file will be in the same format as the original uploaded file and will be named examplefile.response.csv Returns are reported each banking day that the ACH Network returns any transactions for the client's account. Pick up the return file in: ftp.secure.itinternet.net/rebatebyach/returns/ The file will be named with the date the returns were received: 20020831.returns.csv Secure   [ Top ] For secure FTP connection we recommend WS_FTP Pro. CSV   [ Top ] Data elements or fields in the csv file format are delimited by commas ( , ) and each data field should begin and end with quotation marks ( " ). Empty fields are represented by a comma, two quotation marks carets, and a comma. Following is an example csv record with one empty field: "ref" , "" , "name" , "and so on" For the RebateByACH service, the csv format for Option 1. processing is as follows: "row" , "settlement date" , "customer id" , "amount" , "currency" , "reference" For the RebateByACH service, the csv format for Option 2. processing is as follows: "row" , "settlement date" , "name" , "aba" , "acc" , "amount" , "currency" , "reference" CRT   [ Top ] Data elements or fields in the crt file format are delimited by carets ( ^ ). Empty fields are represented by two carets next to each other. Following is an example crt record with one empty field: ref^^name^and so on For the RebateByACH service, the crt format for Option 1. processing is as follows: row^settlement date^customer id^amount^currency^reference For the RebateByACH service, the crt format for Option 2. processing is as follows: row^settlement date^name^aba^acc^amount^currency^reference Home - F A Q - Fees - File Specifications - Sign Up - Contact - Privacy Legal Notice Copyright � 1995-2005 ITI Services, Inc. All rights reserved. i-Check, PayByCheck and the PayByCheck.com logo are trademarks or registered trademarks of ITI Services, Inc.