Spreadsheet: 53df8e15-4552-4ac8-8425-33af2a546c70
Sheet: 4. Taxes and Receipting

Tax Collection & Receipting
Req # | Description of Requirement | Response | Comments
The system has the ability to maintain all aspects of Treasurer's System
TR.1 | Integration with Property Assessment and Tax Collection records so as not to have to duplicate entry of standard information
TR.2 | Ability to Change Addresses for One Specific Owner on Several Different Pieces of Property on Multiple Years |  | Also in Receipting Program
TR.3 | Ability to see Co-owners and Previous Owners. |  | Also on Delete PINs and show online
TR.4 | A printout for the public that includes: owner, address (both site and mailing), acreage, legal description from tax rolls, ratio, estimated fair market value, at least 11 year tax history, lottery credit, taxes paid, balance due |  | As one document "TAX STATEMENT" & showing 11 years (summary of payments per year)
TR.5 | Township Batch Processing for the First Half Taxes |  | City of Hartford - Upload MS Excel document to post
TR.6 | Complete January, February, April (Lottery Credit), August Municipal, and August Settlements, and Treasurers Settlement and Settlement Receipt, all by municipality, and save as pdf document for emailing to local municipality |  | Ability to manipulate if necessary for NSF payments received by local municipality & balance with Statement of Taxes
TR.7 | Crosschecks to ensure All Settlement Worksheets are in balance, including Treasurers Settlement and Settlement Receipt |  | February after upload of payments from local municipalities
TR.8 | Treasurer Settlement Summary - Total of all municipalities |  | February after upload of payments from local municipalities | See County StlmntRcpt tab of "Sample Settlement Summary.xls"
TR.9 | County Settlement Receipt Summary - Total of all muncipalities |  | February after upload of payments from local municipalities | See County TreasStlmnt tab of "Sample Settlement Summary.xls"
TR.10 | Create ALL Reports (shown on each tab of example document) |  |  | See "Sample Treasurer Reports.xls"
TR.11 | Tax Jurisdiction Payment Entry
TR.12 | Settlement Roll - Post/Delinquent Code Update
TR.13 | Spec Assess Payment Summary by Code
TR.14 | "Roll Over" Lottery Credit and First Dollar Credits from previous year for real estate and personal property
TR.15 | Real Estate & Personal Property Lottery Credit Entry or Deletion |  | Note field on this would be extremely helpful - to report to WDOR as well
TR.16 | Real Estate & Personal Property Late Claim or Deletion Entry |  | Uploaded from local municipality in February from tax software
TR.17 | Real Estate List for New Parcels that have improvements and no Lottery Credit claimed
TR.18 | Real Estate list of No Lottery Credit claimed on parcels with improvements where Site Address matches Mailing Address
TR.19 | Real Estate list of Lottery Credit claimed on parcel with little or No Improvements
TR.20 | Real Estate list of Lottery Credit claimed on parcel where site address is different then mailing address
TR.21 | Real Estate list of same owner receiving multiple Lottery Credit claims.
[NAME] | Apply Lottery Credit "Payment" to [NAME] |  | February (and August for the City of Watertown)
TR.23 | Ability to "flag" delinquent parcels in the system so interest and penalties are applied, and to manipulate parcels and not charge interest and penalties if necessary. |  | February (and August for the City of Watertown)
TR.24 | Ability to Code Tax Bills for Bankruptcy or other misc. reasons, so they won't print for Courtesy Letters |  | And possibly exclude from In Rem procedures and documents?
TR.25 | Produce and Update Tax Receipting Reports to Finance |  | History of Tax Collection; Top 10 Taxpayers Report; Etc.
TR.26 | Ability to create report of dog tags to export into [NAME] program |  |  | See "Sample Dog Report.xls"
TR.27 | City of Watertown upload of assessments and taxes due |  | They use GCS, the rest of the municipalities use the J. Mauel Tax program
TR.28 | Upload City of Watertown Lottery Credits Added/Deleted |  | August
TR.29 | City of Watertown Settlement which includes Upload of Real Estate and Personal Property Payments |  | August
TR.30 | Apply Lottery Credit "Payment" to [NAME] |  | August
TR.31 | Create list of real estate and personal property short paid less than $5.00 |  | February
TR.32 | System able to "force"  short payments less than $5.00 from delinquent to postponed
TR.33 | Ability to "auto receipt" credit card payments from outside vendor and manipulate receipt/payment if necessary |  | Currently utilize Official Payments Corporation
TR.34 | Each Special Assessment/Charge should be listed separately on-line so they can be easily identified. |  | On the tax information screen (or wherever they're shown)
[NAME] | Large Area for Payment Names (over 30 characters)
TR.36 | Daily Payment Summary Listing Report - Ability to enter by starting and ending receipt number (for balancing and entering into the GL thru receipting in JDE) |  | Need dollar amount paid by type (special assessment/charge, principal taxes paid, interest and penalty paid & Total Paid
TR.37 | Enter On-Line Daily Tax Receipts
TR.38 | Update On-Line Daily Tax Receipt Payments
[NAME] | Change an Updated Tax Payment without having to void the payment
TR.40 | Ability to manipulate and customize "look-see" screens for [NAME]'s Staff
[NAME] | On "look-see" screen, need to choose month and year for interest and penalties due on a delinquent parcel. |  | Also should have this ability on line
TR.42 | [NAME] and ability to Code for various reasons
TR.43 | Unpaid parcels  from Prior Years highlighted for easier identification
TR.44 | Enter payments for multiple parcels with running total screen capability.  Also be able to make partial payments on multiple parcels and shown on one receipt
TR.45 | Ability to reprint and e-mail receipts
TR.46 | Reprint receipts showing exactly as it was the day of the receipt; including balance due at that time (not the current date)
TR.47 | Ability to reprint one specific tax receipt or choose from a range by tax receipts number
TR.48 | Ability to print multiple copies of a "Tax Statement" for the same PIN (ie: choose number of copies to print, but set default to 1) - "Tax Statement" defined in TR.4
TR.49 | Ability to print screens
TR.50 | Ability to switch between different printers easily
TR.51 | Ability to not print receipts if not needed
TR.52 | Tax Receipts available on-line to public and ability for them to print
TR.53 | Sale Book
TR.54 | Certificate Roll
TR.55 | Ability to Assign Certificate Numbers
TR.56 | Ability to easily search and print each tax certificate separately
TR.57 | Create Delinquent and/or Postponded Tax Listings by Year by municipality and Grand Total of Report
TR.58 | Create Delinquent Tax Download File - Anytime
TR.59 | Ability to e-mail Delinquent/Postponed Tax Lists |  | Sort by PIN or [NAME] (last name)
TR.60 | Ability to create Courtesy Notice Statements at any time throughout the year and choose month, day and multiple years to apply Interest/Penalties |  | Must note on the Statement that county will begin foreclosure proceedings on any delinquent taxes due after three (3) years. | See "Sample Courtesy Notice.pdf"
TR.61 | Notice of Issuance Letters |  | Ability to print PDF versions of Tax Certificates | See "Sample Notice Issuance.pdf"
TR.62 | Ability to modify reports to manually add tax years and tax amount when needed
TR.63 | Notice of Commencement of Proceeding In Rem to Foreclose Tax Liens By Dodge County (for Circuit Court) |  |  | See "Sample of Commencement.pdf" and "Sample of Commencement for Newspaper.pdf"
TR.64 | Affidavit (for Circuit Court and Mailing of Certified Letters) (List of [NAME]) and field for entering Certified Mail Number (must be 25 characters) |  | More than one user may use this file at the same time. | See "Sample Affidavit.doc"
TR.65 | Create three (3) Copies of Mailing Labels for Affidavit
TR.66 | Notice of Commencement of Proceeding In Rem to Foreclose Tax Liens By Dodge County (List for Posting and that goes on the website and is mailed to all [NAME] holders) |  |  | See "Sample of Commencement.pdf"