Login  |  Help      
    Tuesday, December 11, 2018 11:25:21 pm MST

Tyler Technologies Account Balance Extract Import Specification

(updated July 30, 2015)

The file definition for importing balances from Tyler Technologies are as follows. The filename has a suffix of ".txt". The fixed-length extract file contains one account per record with no header record. The file may contain Account Numbers for both Treasurer and Assessor accounts. The Treasurer account numbers are all numeric and the Assessor account numbers contain at least one letter. When importing the file the only the appropriate account numbers are imported based on the name of the merchant as defined in Secure Instant Payments. If the merchant name contains the word "Treasurer" only all numeric accounts will be imported and if the merchant name contains the word "Assessor" only account numbers that contain at least one letter will be imported. The fields in each record are fixed length as follows:

Account Balance Extract (fixed length)
Used to provide a breakdown of charges outstanding on a set of accounts
Field Name Len Start End Description
1 ACCOUNT NUMBER 14 1 14 Account Number (Treasurer account numbers are all numeric, Assessor's contain at least one letter)
2 OWNER NAME 34 15 48 Owner Name
3 CARE OF 34 49 82 Owner Care Of
4 ADDRESS 1 34 83 116 Owner Address Line 1
5 ADDRESS 2 34 117 150 Owner Address Line 2
6 CITY 20 151 170 Owner City
7 STATE 2 171 172 Owner State
8 ZIPCODE 5 173 177 Owner Zip Code
9 ZIPCODE ADD ON 4 178 181 Owner Zip Code +4
10 PRIOR YEAR DUE 1 182 182 "Y" if the account has unpaid prior year charges, "N" otherwise
11 TAX YEAR 4 183 186 The current tax year
12 FIRST HALF BILLED 9 187 195 First Half Principle Billed (Two decimal place assumed)
13 FIRST HALF PAID 9 196 204 First Half Principle Paid (Two decimal place assumed)
14 FIRST HALF LATE FEES 9 205 213 All first half interest, penalty, and miscellaneous charges (Two decimal place assumed) 
15 DELINQUENT FIRST HALF DUE 9 214 222 Total delinquent charges due for the first half (Two decimal place assumed)
16 FIRST HALF TOTAL 9 223 231 Total due for the first half (Two decimal place assumed)
17 SECOND HALF BILLED 9 232 240 Second Half Principle Billed (Two decimal place assumed)
18 SECOND HALF PAID 9 241 249 Second Half Principle Paid (Two decimal place assumed)
19 SECOND HALF LATE FEES 9 250 258 All second half interest, penalty, and miscellaneous charges (Two decimal place assumed)
20 DELINQUENT SECOND HALF DUE 9 259 267 Total delinquent charges due for the second half (Two decimal place assumed)
21 SECOND HALF TOTAL 9 268 276 Total due for the second half (Two decimal place assumed)
22 TOTAL BILLED 9 277 285 Total Principle Billed (Two decimal place assumed)
23 TOTAL PAID 9 286 294 Total Principle Paid (Two decimal place assumed)
24 TOTAL LATE FEES 9 295 303 All interest, penalty, and miscellaneous charges (Two decimal place assumed)
25 DELINQUENT TOTAL DUE 9 304 312 Total delinquent charges due (Two decimal place assumed)
26 TOTAL DUE 9 313 321 Total due (Two decimal place assumed)
27 PARCEL NUMBER 19 322 340 The parcel number for the account
28 LEGAL 175 341 515 The account's legal description

Tyler Technologies Easy File Payment Import Export Specification

The file definition for exporting payments to Tyler Technologies follows their Easy File Payment Import Specification. The filename has a suffix of ".txt". The tab delimited and contains one account per record with no header record. The fields in each record are tab delimited as follows:

Field Name Format Description
1 Account Number string Account number used in Tyler Technologies software and SIP
2 Amount Paid fixed point number Amount paid as a fixed point number with two decimal places - may be negative for returned payments
3 Type char (optional) Method of payment (C:Checking, S:Savings, B:Business checking, V:Visa, M:Mastercard, D:Discover, or A:Amex)
4 Memo string (optional) Memo provided by payor
5 Reference Number string Payment ID from SIP to reference payment

Use Instant Payments to accept payments for your business.
SIP Program & Data © 2006-2018 Instant Payments All rights reserved.
~ Terms & Conditions ~ Privacy Policy ~ Contact Us ~
SIP Version 2.18; API: 2.5
RSI Security Instant Payments, Payment Processing Service, Clinton, UT Get Help