1. Download LenderExportCSV.zip file that you want and save on your desktop.
2. Click here: LenderLookup to to download LenderLookup.zip file. We suggest that you keep this file in a folder for future use.
3. Unzip the LenderLookup file and drag to desktop. A smiley-face icon will appear.
4. Double click the smiley-face icon. A box will appear for you to browse for the Lender file and Lookup file.
5. Lender file: Browse your desktop for the LenderExportCSV.zip file from step 1 above.
6. Lookup file: Browse for your Escrow file, which must be a TXT file of correctly formatted parcel numbers (with punctuation), and/or you can type parcel numbers, one per line, in the "List" box.
7. Determine which installment you wish to get information for.
8. Click "Process" and verify total amount.
9. Three files will be created on your desktop; a lender export file with payment details for only the imported escrow parcels; a full county file with payment details; and a "lockbox" payment file for your use in submitting payment to the county office.

Fld  Field Name   Width  Description
  1  PARCELNUM      30  Parcel Number
  2  OWNER          80  Deeded Owner
  3  PROPERTY1      12  Property Tax Due, 1st Installment
  4  PROPPREV1      12  Property Tax Due, 1st Installment, Previous Years
  5  PROPPEN1       12  Property Tax Due, 1st Installment, Penalties
  6  PROPFEE1       12  Property Tax Due, 1st Installment, Fees
  7  SPECIAL1       12  Special Assessment, 1st Installment
  8  SPECPREV1      12  Special Assessment, 1st Installment, Previous Years
  9  SPECPEN1       12  Special Assessment, 1st Installment, Penalties
 10  SPECFEE1       12  Special Assessment, 1st Installment, Fees
 11  SPECINT1       12  Special Assessment, 1st Installment, Interest
 12  PROPERTY2      12  Property Tax Due, 2nd Installment
 13  PROPPEN2       12  Property Tax Due, 2nd Installment, Penalties
 14  SPECIAL2       12  Special Assessment, 2nd Installment
 15  SPECPEN2       12  Special Assessment, 2nd Installment, Penalties
 16  SPECINT2       12  Special Assessment, 2nd Installment, Interest
 17  RECHRG         12  Recharge
 18  RECHRGINT      12  Recharge Interest
 19  RECHRGCOST     12  Recharge Cost
 20  OTHERCOST      12  Other Cost
 21  TOTALDUE       12  Total Due
 22  DUPLICATE      11  Tax Duplicate Number
 23  LENDERNAME     45  Lender Name
     Total         394

Fld  Field Name   Width  Description
  1  PARCELNUM      30  Parcel Number
  2  OWNER          80  Deeded Owner
  3  PROPERTY1      12  Property Tax Due, 1st Installment
  4  PROPPREV1      12  Property Tax Due, 1st Installment, Previous Years
  5  PROPPEN1       12  Property Tax Due, 1st Installment, Penalties
  6  PROPFEE1       12  Property Tax Due, 1st Installment, Fees
  7  SPECIAL1       12  Special Assessment, 1st Installment
  8  SPECPREV1      12  Special Assessment, 1st Installment, Previous Years
  9  SPECPEN1       12  Special Assessment, 1st Installment, Penalties
 10  SPECFEE1       12  Special Assessment, 1st Installment, Fees
 11  SPECINT1       12  Special Assessment, 1st Installment, Interest
 12  PROPERTY2      12  Property Tax Due, 2nd Installment
 13  PROPPEN2       12  Property Tax Due, 2nd Installment, Penalties
 14  SPECIAL2       12  Special Assessment, 2nd Installment
 15  SPECPEN2       12  Special Assessment, 2nd Installment, Penalties
 16  SPECINT2       12  Special Assessment, 2nd Installment, Interest
 17  RECHRG         12  Recharge
 18  RECHRGINT      12  Recharge Interest
 19  RECHRGCOST     12  Recharge Cost
 20  OTHERCOST      12  Other Cost
 21  TOTALDUE       12  Total Due
 22  DUPLICATE      11  Tax Duplicate Number
 23  LENDERNAME     45  Lender Name
     Total         394

Fld  Field Name   Width  Description
  1  PARCELNUM      30  Parcel Number
  2  TAXID          30  Tax Id Number
  3  DUPLICATE      11  Tax Duplicate Number
  4  OWNER          80  Deeded Owner
  5  PROPERTY1      12  Property Tax Due, 1st Installment
  6  PROPPREV1      12  Property Tax Due, 1st Installment, Previous Years
  7  PROPPEN1       12  Property Tax Due, 1st Installment, Penalties
  8  PROPFEE1       12  Property Tax Due, 1st Installment, Fees
  9  SPECIAL1       12  Special Assessment, 1st Installment
 10  SPECPREV1      12  Special Assessment, 1st Installment, Previous Years
 11  SPECPEN1       12  Special Assessment, 1st Installment, Penalties
 12  SPECFEE1       12  Special Assessment, 1st Installment, Fees
 13  PROPERTY2      12  Property Tax Due, 2nd Installment
 14  PROPPREV2      12  Property Tax Due, 2nd Installment, Previous Years
 15  PROPPEN2       12  Property Tax Due, 2nd Installment, Penalties
 16  PROPFEE2       12  Property Tax Due, 2nd Installment, Fees
 17  SPECIAL2       12  Special Assessment, 2nd Installment
 18  SPECPREV2      12  Special Assessment, 2nd Installment, Previous Years
 19  SPECPEN2       12  Special Assessment, 2nd Installment, Penalties
 20  SPECFEE2       12  Special Assessment, 2nd Installment, Fees
 21  TOTALDUE       12  Total Due
 22  PREVFEES       12  Previous Fees
 23  SURPLUS        12  Surplus Payments
 24  RECHARGE       12  Taxes put back on Tax Roll from the courts
 25  JUDGMENT       12  Taxes removed from Tax Roll and sent to courts
 26  DEMAND          1  "X" shows a demand flag
 27  TAXSALE         1  "X" shows a Tax Sale flag
 28  SHERIFF         1  "X" shows a Sheriff flag
 29  LENDERNAME     45  Lender Name
     Total         451