Treasurer and Public Trustee of Morgan County, Colorado

Tax Roll Download

An ASCII text file is available that contains all Real Estate and Manufactured Housing Schedules, the Tax Due, Owner Name(s), Situs Address, and 5 lines of legal. The file is zipped for distribution. The fee for this file is $100.00. To order, please contact this office.

Record Layout

POSITION	LENGTH	DESCRIPTION
1-1	1	Account Type (R=Real)
2- 9	8	Account Number (numeric portion only-right justify, zero fill)
10- 19	10	Current Year Tax amount with 2 decimals implied
20-29	10	Current Year Delinquent amount, OR Amount paid with 2 decimals implied
30-30	1	Current Year Delinquent indicator('Y' or 'N')
31-31	1	Tax Sale Indicator('Y' or 'N')
32-71	40	Owner Name (Name-1)
72-109	38	Situs Address (Street #/Street Name)
110-159	50	1st Line of Legal
160-209	50	2nd Line of Legal
210-259	50	3rd Line of Legal
260-309	50	4th Line of Legal
310-359	50	5th Line of Legal
360-361	2	Carriage Return and Line Feed (Hex 0D0A)

Field Definitions

ACCOUNT TYPE: The alpha character identifying the record type (generally "R" for real).

ACCOUNT NUMBER : The numeric portion of the account number.

CURRENT YEAR TAX : This amount includes all computer recorded special assessments, Declaration Penalties, and TD1000 penalties.

DELINQUENT AMOUNT/AMOUNT PAID : If the CURRENT year taxes are delinquent, (ie whole payment past due, 2nd half past due, the delinquent amount will show here. It will NOT include interest since there is no way in determining when the taxes will be paid. The DELINQUENT INDICATOR will then be flagged as a Y. If the CURRENT YEAR taxes have been paid, the amount will be shown in this field. The DELINQUENT INDICATOR will have an N.

DELINQUENT INDICATOR: See DELINQUENT AMOUNT/AMOUNT PAID description:

TAX SALE INDICATOR : If there is an outstanding tax sale certificate on the schedule, this flag will be a Y. No totals are given as to the amount due for the tax sale certificate.

OWNER NAME : Name-1 from the Master File (AM MS1)

SITUS ADDRESS: Street Number /Street Name from the Master File (AM MS1)

1ST LINE LEGAL - 5TH LINE LEGAL : The download will post the first five lines of legal from the secondary files, in the same way that all legal is produced on all state required forms.

CARRIAGE RETURN/LINE FEED : This is used by the Tax Services to determine where a record ends.

Payment File Layout

The data should be provided in the following format:

Data should be provided by e-mail or on a 3 1/2 diskette in ASCII format.

File names SHOULD NOT BE THE SAME for each file.

File names should end with .TXT (e.g.. d3042703.txt)

POSITION	DESCRIPTION
DETAIL RECORD
1-1	Account Type (R=Real)
2-9	Account Number (numeric portion only-right justify, zero fill)
10-32	constant zeros
33-42	Payment Amount
43-45	1st Half '011', 2nd Half '021', Full '031'
46-47	Mortgage Code - From pos 1-2 of mortgage code field
48-65	Loan ID - Last 18 positions
66-70	Numeric Bill Number
71-72	HEX(0D0A) (carriage return/line feed)