Tips for Correction Agents
Related to RP-5217 Sales Reporting & Correcting
|GENERAL SALES INFO
|Importance of Sales Reporting & Correcting
|Timely verification/correction and reporting of RP-5217 sales data in the first instance is critical to meet ORPTS needs and ultimately the needs of local government. The period of time between the occurrence of a sale and its use for a product is compressed. Sales are generally used within the year.
|The RP-5217 Sales Database supports many State processes: Establishment of Equalization Rates, Level of Assessment verifications, Real Property Market Trends, Supplemental Appraisals (Residential Class only), Sales ratios for equity and uniformity analysis, RAR and COD, State Aid eligibility criteria and Annual Reassessment programs.
|Comprehensive Sales Reporting Information on ORPTS Web Site
|Go to: Sales Data Management - RP-5217 Reporting
Then choose specific topics from left hand menu.
|The topic 'Managing RP-5217 Data' contains a wealth of information regarding sales reporting & correcting.
|Sales-related Contacts & Telephone Numbers
|Contact Regional Office for the following sales related issues:
|Central Regional Office -
Northern Regional Office -
Ray Brook Satellite Office -
Southern Regional Office -
Western Regional Office -
|Contact Data Management - Sales Reporting staff for the following sales related issues:
Data Management Unit -
Contact ORPTS Solutions Center regarding support for the following:
ORPTS Solutions Center -
Contact Equalization Support Services (ESS) for information regarding sales-related issues:
Equalization Support Services -
|Mailing & E-mail Addresses
|Send correspondence, RPS035 transmittals, RP-5217 ACR Correction Forms and SalesNet files to the Data Management Unit.
NYS Department of Taxation and Finance
Office of Real Property Tax Services - Data Management Unit
WA Harriman State Campus, Bldg. 8A
Albany, NY 12227
|RPS Transmittal Schedules & Online Sales Report Review
|An 'Application for RPS Sales Transmittals' should be filed with ORPTS Data Management Unit. RPS Reporting via RPS035 should occur at least 'Quarterly'. Other options are 'Bimonthly', 'Monthly' or 'Other' as follows:
|If a new assessor has been appointed/elected or a new sale correction agent designated, a new 'Application for RPS Sales Transmittals' should be completed and sent to ORPTS Data Management Unit. Go to the ORPTS website under the topics 'RP-5217/Sales', 'Managing Sales Data', then 'RPS035 Transmittals'.
|For Quarterly Reporters, transmit RPS035 by:
February 15 - with October, November, December sales
May 15 - with January, February, March sales
August 15 - with April, May, June sales
November 15 - with July, August, September sales
(This schedule applies unless otherwise approved for monthly, bimonthly or other reporting schedule - in which case, check transmittal agreements.
|ORPTS Online Sales Reports:
The Online Sales Report application will provide assessors and their staff the ability to produce/access reports at their convenience. From the application, the user can review/verify the RP-5217 data and confirm the data they provided to ORPTS (via RPS035 transmittals or paper corrections) is reflected accurately.
For Bimonthly Reporters, transmit RPS035 by:
For Monthly Reporters, transmit RPS035 by:
For Other Reporters, a schedule other than described above, would need to be specified, justified and agreed upon with ORPTS.
|By using the Secure Assessment Community Account, users can access the Online Sales Reports application. County Directors and their staff will have rights to access the data for all municipalities within their county. Assessors and their staff will have rights to access the data for only the municipalities for which they have been granted access. For more information regarding accessing the Online Sales Reports Application, please go to the ORPTS website:
|RPS035 Transmittal Checklist
|Every sale must be entered into RPS: Valuation Usable-Yes/No, Arms length & Non-arms length sales (See topics RPS Valuation Usable, ORPTS Arms Length and Ratio Exclusion, below.)
|For details on how to add sales to RPS, run RPS035 transmittals or related to RPS processing in general, refer to the RPSv4 online help or contact your ORPTS regional CRM or County Director of RPTS.
|Run Accumulated Sale Report (RPS035P3) before extracting the transmittal file.
|Compare the number of sales on this report to the totals on the RPS035P1 report after the transmittal file has been run, to ensure all sales are being transmitted.
|Check electronic media (diskettes, CD's) before transmitting.
|Make sure files and sales are present and contain data. For questions on RPS035 file transmittal - refer to Vol. 8 Part 1 of Assessor's Manual or call Regional RPS liaison.
|Sign the transmittal form (RPS035P1).
|Keep a copy of the RPS035P1 report in assessor's office for troubleshooting, if a problem occurs.
|E-mail or mail RPS035 transmittals to address on front sheet of 'Tips'
|The files needed include: RPS035T1 to process and RPS035P1 to print report of sales. Most files received are zipped files.
|Contact ORPTS if you do not receive notification regarding the processing of your RPS035 file.
|Within 2 weeks of transmitting, you will be notified that your file has been processed. Notification will be in the form of:
|COMMON REPORTING ISSUES
|RPS Valuation Usable (V4)
|Do NOT use "Valuation Usable" for including/excluding sales for ORPTS purposes. This is for local use only to exclude sales from local sales analysis products. It is not used by the ORPTS Data Management Unit to include or exclude sales data from any sales-related product.
|ORPTS Arms length determinations are based on: 'Condition of Transfer', Full Sale Price minus Personal Property or a calculated difference between Contract Date and Date of Sale.
ORPTS Ratio usability is based on: Part of Parcel, Multiple Parcels, Multiple Towns, Condo, Significant Change, Full Sale Price minus Personal Property and Total AV.
|ORPTS Arms Length Exclusion Criteria
|ORPTS will exclude a sale as non-arms-length if:
|Sales are included or excluded for various ORPTS purposes based on Sales Exclusion Criteria.
Condition Code 'I' requires an acceptable explanation (see 'Condition Code I' below).
|ORPTS Ratio Exclusion Criteria
|ORPTS will exclude an arms length sale for ratio purposes if:
|Condition Code 'I'
|A Condition Code "I" correction will NOT be made without an acceptable explanation. (See explanations on the right.)
Indicate Condition Code 'I' on RPS V4 file and provide an acceptable explanation in the dropdown Memo field.
V3 Users & Paper Correctors:
Use a paper correction form, and provide an explanation / rationale to accompany a correction to Condition Code 'I', even if the change is made on the RPS file.
|Acceptable Condition Code 'I' explanations include:
*Estate Sales that have been excluded can also be made usable, if ORPTS is notified by assessor, and as long as the sale meets the other conditions of market value. 'Guardian' sales may also fall into this category.
|Sales identified as 'Timeshares' that need to be excluded as NOT Arms Length should be coded as Condition Code 'F' - Sale of Fractional or Less Than Fee Interest. Do NOT use Condition Code 'I'.
|Sales identified as 'Significant Change' are excluded for ratio purposes (i.e., RAR, COD, Sales Ratios). In order to be eliminated, the sale must meet the requirements of, and be identified as 'Significant Change':
|'Significant Change' means that the physical change occurred between the taxable status date for the preceding final assessment roll and the date of sale. (This does NOT mean that the improvement was discovered within this time frame.)
The value of the physical change is 10% or more of the total market value of the property (not assessed value). (The assessment should change on the next appropriate roll.)
The physical change to the property is due to either construction or demolition and must be reflected on the assessor's annual report. (Equalization changes do NOT support this correction.)
|Change in Use
|Identify sales as 'Significant Change' if the primary use of the parcel will change after the sale and the sale price for this new use is representative of the market. This allows the sale to remain arms length, but excluded for ratio purposes.
|Examples of change in use include:
Residential vacant lot or residence is purchased for commercial development.
A hospital acquires residences to expand hospital parking. Agricultural vacant land is purchased for residential subdivision.
|Book / Page
|Enter this information carefully on a correction form or the local file. This 'key' must be identical to the Book and Page as entered on the RP-5217 by the County Clerk in items C3 and C4.
If correction is required to ORPTS file:
|SBL is NOT used to match to the ORPTS sales database. The County Code, Book & Page are used as the 'key' and the unique identifier used to match the local corrections (paper and RPS) to the ORPTS sales database. If the book/page is incorrect, the sale will not be updated until fixed or the wrong sale may be updated.
|Part of Parcel
|If 'Part of Parcel' is NOT entered in RPS and on the RPS035, where appropriate, the part of parcel information on the ORPTS database will be erased and overlaid with the number of parcels indicated on the RPS035 file. (The RPS default for number of parcels is one.)
|Part of Parcel sales should be identified. When Part of Parcel is incorrectly omitted a sale is then improperly included for ratio purposes.
|Multiple Towns Sales
|Multiple Town sales must be identified in RPS and on the RPS035 file. A sale is considered to be in Multiple Towns when the 1st four positions of SWIS code are different for the parcels in question.
Paper Correctors: Please indicate a multiple town sale via the check box on the RP-5217-ACR correction form.
|When a sale is not correctly identified as being in multiple towns it is improperly included for ratio purposes.
|Date of Sale v. Date Deed Recorded
|Correct entry of:
Date of Sale = date of transfer (item 12 on RP-5217) and is labeled 'Sale Date' on the RPS sales update screen.
Date Deed Recorded = date the deed was recorded with the County Clerk (item C2 on RP-5217) and is labeled 'Deed Date' on the RPS sale update screen.
|Dates should be entered in the correct fields. ORPTS uses Date of Sale for extracting sales for reports, RARs, Equalization Rates, State Aid, STAR, etc. since the Date of Sale is tied to the Sale Price.
|Full Sale Price
|In some cases '100% Financing - No Money Down' transactions' have a Full Sale Price that includes not only the total amount paid for the property, but also the value of the concessions. A correction can be made by deducting the value of concessions and report the corrected Full Sale Price to ORPTS. The corrected Full Sale Price will then be used in calculating a new Sale Price (Full Sale Price minus Personal Property) used in any ORPTS products.
|Keep in mind that the Total AV used for a sale must always reflect the latest final roll at the time of sale.
|AV's need attention/correction for sales that are identified as "Not Roll Matched" or "Not RPS Updated" on the Online Sales Report "List of Arms Length Sales" (see ORPTS Reports , below), or where a court-ordered AV change was required and the assessment is different from the update from the 15-C file
|Correction Forms (RP-5217 ACR) - Who sends and what corrections should be made
|Uses of the RP-5217 ACR correction form should be limited to the following:
|Corrections submitted directly to ORPTS on the Online Sales Reports may be returned unprocessed.
For questions related to paper corrections - contact Data Management staff.
See 'Common Reporting Issues'', regarding 'Multiple SWIS' corrections.
|Entries on the RP-5217 ACR: Enter SWIS Code, Book, Page and SBL/Roll ID.
Enter 'RP-5217 Item No. for Correction' and 'Correct Information'.Check the box 'Property in more than one SWIS' or 'Significant Change...' only if correcting this data.**Note: All data that can be corrected within the RPS system should be and transmitted via RPS035. A paper correction transmitted to ORPTS on the RP-5217 ACR form/paper, but NOT indicated/made on the RPS file could result in that correction being 'undone' if/when a subsequent RPS035 transmittal is applied to the ORPTS sales database.
The Book & Page is the key to the ORPTS sales database. See 'Common Reporting Issues'', regarding 'Book/Page' corrections.
The 'Item No.' correlates to the item number on the RP-5217 form. 'Correction Information' reflects the new information/data for update of the ORPTS sales database.
|Online Sales Reports: 'List of Arm's Length Sales'
|Review the arms length sales data for accuracy, with particular attention to:
|The list provided displays the sort sequence used under the center heading at the top of each page (i.e., SWIS, Property Use and Parcel ID.)
|'Not Updated' indicates a sale has not been updated with a paper correction or via RPS035. For RPS reporters, this indicates that we have not received or we were unable to update our database with the local RPS information. Review the sale, determine if sale data is reflected accurately and correct as needed.
|Check sale status on the local file. If a sale appears on List of Arms Length Sales as 'Not Updated' but carries a 'T' on the RPS file, check date of local transmittal compared to the date on the report to determine if timing is an issue. If timing is NOT an issue, check for differences between Book and Page (see this Topic above) that may be creating a matching/update problem. Fix if necessary, change RPS flag from 'T' to 'R' and retransmit or contact staff in the regional office or Data Management Unit for further investigation/direction.
|'RPS Updated' or 'Paper Corrected' indicates that an RPS transaction or paper correction, respectively, has been applied to the sale. If both have been applied to a specific sale, only 'RPS Update' is displayed.
|'Not Roll Matched' indicates that ORPTS was unable to match to the 15-C Assessment Roll to update the sales database with assessment information. Therefore, this data may need review & correcting. However, if 'RPS Updated' is indicated, then assessment information would have been updated/corrected from the RPS035 transaction.
|After sales are loaded to the ORPTS' sales database, they are updated within the week with the 15-C assessment roll information - from the latest final roll at time of sale. Fields that are updated include Total AV, Property Class, Roll ID, Lot size, School District, Grids. The 15-C roll matching/update utilizes the respective city or town roll. Therefore, assessing unit villages should continue to provide corrections to village assessments, where necessary.
|Online Sales Report: 'Sales Excluded from Agency Use Based on Buyer and Seller Name'
|Sales found on this report have been flagged on our database as Non-Arms Length and excluded from any agency use - RAR, COD and FVM/Survey. Corrections are NOT necessary unless there is disagreement with our exclusions. However, please update local file with correct information. For details on correcting, see "Non Arms Length Sales Corrected to Arms Length" below.
|Identification of sales has been made via a computer search in the buyer and seller names. This report displays sales transactions where:
|Online Sales Reports: 'Sales with Potential Contradictions in Data Entered on RP-5217'
|This report displays sales with potential contradictions. They are identified on our database as Arms Length sales and will be included for RAR and COD purposes (unless they had been excluded for other reasons). However, corrections to these sales must be made if the 'Relative' sale should be excluded or the AV or Sale Price is incorrect.
|This report displays sales transactions where: