|
File Format - Standard Import File
FILE FORMAT - TRANSFER EXISTING LOANS
There are two ways to import existing information from an existing servicing system. The first way is to follow the directions below. This will allow your company to import loans directly into Trakker and with out any additional cost to you or your company. The second way is to contact our Trakker Support Group and request an Export/Import Excel file. This will allow your company to place the existing information into a format that our Support Group can import into data files that Trakker can use. This type of import will generate a fee, as our Support Group will have to review the data, convert it into Trakker data files, and test to guarantee that your company does not experience any problems. If you wish to utilize the second option for your import please contact our Trakker Support group at 850-559-9123 or by e-mail at support@thetrakker.com
The following is the file format for importing loans from an existing loan servicing system/program. This information should be in ASCII/Text format with ONE field to a line and each loan IMMEDIATELY following the last loan’s information. The program is designed to first read the entire file, determine if all information has been formatted correctly and, if not, indicating problems by line number with "on-screen" messages; thus, the reasoning for having information on separate lines. A Carriage Return Line Feed should also follow each line. If you wish to view an example of how this file should look please click on the appropriate link: Single Account Import File Example Multiple Account Import File Example
If you wish to import Escrow history please review: Importing Escrow Information
NOTE: Some fields have multiple choices. If so, then the second and third columns below will contain appropriate information to indicate what codes are needed to designate a certain choice.
NOTE: Need assistance in developing this ASCII/Text File? This can usually be accomplished on a consulting fee basis, time permitting. Please be aware that support calls and high priority projects must come first. Call our Support Group at 850-559-9123 for more details.
NOTE: If there is a Red * next to the Line number:
* = Required Field ** = Advised but not required *** = Escrow info is required if Line # 40 = 1 (yes)
Line Number Field Name Code Import File 1* Acct Type 1\2 Individual\Company 2 Blank 3 Blank 4 ** First Name First/First John/Sue 5 ** Last Name Last/Last Sam/Que 6 ** Collateral Addr 1 123 N. Main St 7 ** Collateral Addr 2 Apt 2 8 ** Collateral City Oz 9 ** Collateral State GA 10 ** Collateral Zip 99099-1234 11 ** County USA 12 Loan Class Code Alpha/Numeric Field ER or E4 13* 1st Borrower 1st Name First B John 14* 1st Borrower Last Name Last B Sam 15* SSN Do not use - 888776666 16* Mailing Addr 1 344 E. Broughton St. 17 Mailing Addr 2 Apt 8 18* Mailing City Birmingham 19* Mailing State AL 20* Mailing Zip 44944-3478 21 Phone Do not use - 8883332212 22 Sex 1/2/0 Unknown/Male/Female 23 Race 1/2/3/4/5/6/7/8 Unknown/Caucasian/African American/Native Indian/Asian/Hispanic/Other 24 2nd Borrower 1st Name First B Suzy 25 2nd Borrower Last Name Last B Que 26 SSN Do not use - 777665552 27 Phone Do not use - 3334442212 28 Sex 1/2/0 Unknown/Male/Female 29 Race 1/2/3/4/5/6/7/8 Unknown/Caucasian/African American/Native Indian/Asian/Hispanic/Other 30 Appraisal Numeric Field 78000.00 31 Collateral Description Alpha/Numeric Field This is the collateral description. 32* Grace Days Numeric Field 15 33* % of Payment Numeric Field 5 34* Service Fee Code For Fee Code 1 Dollar amount For Fee Code 2 =% 2.5 For Fee Code 3 =% 5.0 For Fee Code 0 Leave Blank 35* Service Fee Amt Numeric Field 10.00 36 Pre Payment % Numeric Field 25 37 Pre Payment Date MM/DD/YYYY 01/01/2004 38 Past Due Fee Numeric Field 100.00 39* Begin Servicing Date MM/DD/YYYY 01/01/2003 40*** Escrow Required 1/2 Yes/No 41*** Escrow Payment Numeric Field 25.00 42*** Escrow Balance Numeric Field 100.00 43 Maint. Escrow Req. 1/2 Yes/No 44 Maint. Escrow Balance Numeric Field 200.00 45 Maint. Escrow Payment Numeric Field 10.00 46 Maint. Escrow Cap Numeric Field 2000.00 47** Pre Paid Interest Numeric Field 125.00 48* Loan Type 1/2 Straight/Balloon 49* Payment Period 1/2/3/4 Annual/Semi-Annual/Quarterly/Monthly 50* Interest Type 1/2 Adjustable/Fixed 51* Original Balance Numeric Field 30000.00 52* Current Balance Numeric Field 25000.00 53* Interest Rate Numeric Field 12.375 54* Rate Type Numeric Field 1.00 55* P&I Amount Numeric Field 225.00 56* Term Numeric Field 360 57 Balloon Due Numeric Field 300 58 Balloon Amount Numeric Field 15000.00 59* Closing Date MM/DD/YYYY 01/01/2003 60* Last Payment Received MM/DD/YYYY 02/01/2003 61* Next Due Date MM/DD/YYYY 03/01/2003 62 Comment Alpha/Numeric Field This is the comment CONTINUE WITH NEXT BORROWER’S INFORMATION WITHOUT SKIPPING A LINE |