Tax_Software_Matrix.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Tax Software
Solicitation number
RFP #27002
Issued by
Greenville County, South Carolina

About this file

This is a Tax Software Requirements Matrix for Greenville County, South Carolina, detailing comprehensive functional and technical specifications for a new tax and auditor software system to replace the county's aging platforms. The matrix documents mandatory and high-priority requirements across nine functional categories: General IT requirements, Auditor functions, Tax Collection operations, Real Property Services, Treasurer/Finance integration, Reporting capabilities, System Integrations, Technical & Security standards, and Training and Support services. The General category requires data migration, validation, entity maintenance, and audit logging. The Auditor section specifies search capabilities using multiple field types (VIN, account number, name, address, plate number, map number, permit number, and SCDOR reference ID), bill creation within 60 seconds, GIS integration, and unlimited remarks with operator history. The Tax Collection category encompasses 44 requirements including point-of-sale cashiering, multiple payment methods, tax sale functionality, bankruptcy processing, payment reporting, and real-time DMV interface capabilities.

The Real Property Services section contains 56 mandatory requirements addressing homestead processing, mobile home management, exemption handling, rollback file management, and value updates across multiple districts. The Treasurer/Finance requirements mandate integration with the Munis financial system for allocations, accounts payable, and refund processing, while Reporting requirements include entity collection reports, assessed value analysis, year-over-year comparisons, and GASB-77 automated reporting. Integration requirements specify mandatory connections to GIS, County Valuation System, Assessor System, Munis Financials, and DMV, with high-priority interfaces to receipt printers, posting companies, and newspaper publishers. Technical and Security standards require role-based security, encryption in transit and at rest, detailed audit logs, disaster recovery capabilities, and SOC 2 or ISO 27001 certification. Training and Support requirements mandate onsite administrator training, remote end-user training, 24x7 technical support with one-hour response time, dedicated support specialists, and defined Service Level Agreements.

View the file

Other files

File Type Posted
Tax_Software_(Addendum_#1_Revision).pdf PDF
Tax_Software.pdf PDF
COG_Sub_W9_.pdf PDF
Sample_Services_Agreement.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

Vendor Response Key
ResponseDefinition
CCompliant – Meets requirement without customization
CCCompliant with Configuration
CUCompliant with Customization
TPMeets requirement through Third-Party Integration
PCPartially Compliant
NCNot Compliant
NANot Applicable
IT Software Requirements Matrix
IDCategoryPriorityVendor ResponseDescription/Comments
G-1General - Migrate historical and current tax billing dataMandatory
G-2General - Validate migrated data prior to productionMandatory
G-3General - Maintain tax entities and fee schedules internallyMandatory
G-4General - Workflow approvals with configurable routingMandatory
G-5General - Complete audit logs for all transactionsMandatory
Auditor Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
A-1Search using VINMandatory
A-2Search using Account NumberMandatory
A-3Search using NameMandatory
A-4Search using AddressMandatory
A-5Search using Plate NumberMandatory
A-6Search using Map NumberMandatory
A-7Search using Permit NumberMandatory
A-8Search using SCDOR Reference IDMandatory
A-9Search using combinations of search fieldsMandatory
A-10Accept annual County work filesMandatory
A-11Accept monthly County work filesMandatory
A-12Access historical tax data during processingMandatory
A-13Link multiple bill types to one taxpayerMandatory
A-14Unlimited addresses per customerMandatory
A-15Create tax bills in ≤10 stepsMandatory
A-16Create bills within 60 secondsMandatory
A-17GIS integration for tax districtsMandatory
A-18Interface with County valuation systemMandatory
A-19Print bills within 10 secondsHigh
A-20Support three addresses on billMandatory
A-21Edit existing tax billsMandatory
A-22Automatically recalculate taxes after editsMandatory
A-23Attach electronic documentsMandatory
A-24Print/email/mail forms with auto-populated dataHigh
A-25Fee-in-Lieu tax billingMandatory
A-26Copy existing tax billsHigh
A-27Complete bill history with timestamps and userMandatory
A-28Convert BPP Item Type 18 to Item Type 15Mandatory
A-29Generate Excel-format billsHigh
A-30Unlimited remarks with operator historyMandatory
Tax Collection Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
T-1Import Assessor recordsMandatory
T-2Import Auditor recordsMandatory
T-3Full GIS integrationMandatory
T-4Tax Sale functionalityMandatory
T-5Unlimited event/note logMandatory
T-6Point-of-sale cashieringMandatory
T-7Multiple payment methodsMandatory
T-8Single tap/swipe/insert for bill and fee paymentsMandatory
T-9Receipt printingMandatory
T-10Interest and penalty calculationsMandatory
T-11Batch processingMandatory
T-12Write-off processingMandatory
T-13Bankruptcy processingMandatory
T-14Bill presentmentMandatory
T-15Payment reporting by payment typeMandatory
T-16Multi-field account lookupMandatory
T-17DMV payment interfaceMandatory
T-18Force oldest bills paid firstMandatory
T-19Single payment for multiple billsMandatory
T-20Real-time payment verification APIMandatory
T-21Interface with third-party receipt printersHigh
T-22Interface with posting companiesHigh
T-23Interface with newspapers for legal noticesHigh
T-24Ability to have unlimited number of addresses of varying types (i.e. mailing, location, etc.Mandatory
T-25Unlimited or dynamic character limit for longer customer/address namesMandatory
T-26Split payment functionalityHigh
T-27Internal tax sale cost table that can be modified & expandedMandatory
T-28Tax sale cost table automated functionality to add costs at a specified date/eventHigh
T-29Search by transaction dateHigh
T-30Search by amount paidHigh
T-31Search by payment typeHigh
T-32Search by taxpayerHigh
T-33Search by tax typeHigh
T-34Ability to correct erroneous payments via transferring to correct account, voiding or refundingMandatory
T-35Ability to pull past due balances automatically into the taxpayer's cart online and at the counterHigh
T-36Ownership history file with unlimited owner capacityHigh
T-37Ability to report to posting vendor account updates on an by-minute basisHigh
T-38Ability to print tax sale history by multiple criteria (date range/tms number/owner)High
T-39Ability to automate report creation of current and historical overage amountsMandatory
T-40Ability to load/build/maintain a tax sale exemption fileHigh
T-41Tax Sale auction screen that can be displayed during the tax saleHigh
T-42Tax Sale auction collection screen with capability to collect paymentsMandatory
T-43Ability to print tax sale items list for biddersMandatory
T-44Ability to calculate deep stamp cost based on bid amountMandatory
T-45Ability to create bidder cardsMandatory
T-46Ability to track unpaid bids and log through judicial process for collectionHigh
T-47Ability to create a public tax sale fileMandatory
T-48Ability to create files for posting/advertising/demand and certified notices independentlyMandatory
T-49Ability to Nulla Bona accounts of all tax typesMandatory
T-50Ability to access notes from a scheduled report or directly in the accountMandatory
T-51Ability to load bankruptcy documentation directly to impacted accountsHigh
T-52Ability to flag bankruptcy accounts in the general tax inquiryMandatory
T-53Ability to access the original tax notice and reprint/email to taxpayerMandatory
T-54Ability to reprint paid tax receipt valid for SCDMVMandatory
T-55Ability to create automated payment reports for any duration by tax type or payment mediumHigh
T-56Ability to add functionality as legislation/operational changes dictateMandatory
T-57Ability to update, in real-time, vehicle property tax payments with SCDMVMandatory
T-58Ability to integrate with Kiosk vendors to allow for payments/late fees/ decal printing off-siteMandatory
Real Property Services Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
RPS-1Ability to update bill information for legal residence/homestead/addressesMandatory
RPS-2Ability to process refunds for value changes resulting in a reduction of the tax burdenMandatory
RPS-3Ability to update acres > 5.0 at 4% ratioMandatory
RPS-4Ability to update jurisdiction (1) and values (0)Mandatory
RPS-5Ability to update mobile homes with invalid jurisdiction or tax districtMandatory
RPS-6Ability to updated access value to 0 for exempt propertiesMandatory
RPS-7Ability to define multi-district % errorsMandatory
RPS-8Ability to categorize property as low value - tax bill calculation will not processMandatory
RPS-9Ability to update invalid TMS#s for real property and mobile homesMandatory
RPS-10Ability to categorize property at 4% without land assessmentMandatory
RPS-11Ability to categorize agricultural use properties not at 4%Mandatory
RPS-12Ability to allocate a % of value between split districtsMandatory
RPS-13Ability to automatically pull GIS data from RPS files nightly - administrative dateMandatory
RPS-14Ability to automatically pull GIS data from RPS files nightly - mapping and appraisal dataMandatory
RPS-15Ability to update fees for at least 28 different entitiesMandatory
RPS-16Ability to pull data and send to specified entity for TY fee updateMandatory
RPS-17Ability to automate process to load fees to tax softwareMandatory
RPS-18Mobile Home master file functionalityMandatory
RPS-19Mobile Home moving permit functionMandatory
RPS-20Mobile Home parking listing functionMandatory
RPS-21Ability to maintain assessment change codesMandatory
RPS-22Ability to update RP and PC with GAMA data automaticallyMandatory
RPS-23Ability to manually change a valueMandatory
RPS-24Tax estimator on the public facing portion of the County's websiteMandatory
RPS-25Ability to build file for GIS ownership and assessment historyMandatory
RPS-26Ability to create/edit a standard report for fire districtsMandatory
RPS-27Ability to create real property assessment noticesMandatory
RPS-28Ability to apply stormwater exemptions in batches or individuallyMandatory
RPS-29Ability to note accounts with USPS Undeliverable in tax softwareMandatory
RPS-30Ability to update Rollback file before tax bills are createdMandatory
RPS-31Ability to update market and assessed value per district/real estate/ mobile homesMandatory
RPS-32Ability to create a value report by entityMandatory
RPS-33Ability to pull/upload data from Codes department's lien file for tax bill corrections/updatesMandatory
RPS-34Ability to pull/upload DOR exempt file for stormwater abatementsMandatory
RPS-35Rollback add and correction screen accessible by real property staffMandatory
RPS-36Ability to bring up yearly rollback adds in massMandatory
RPS-37Ability to manually edit exempt properties/exemptionsMandatory
RPS-38Ability to create a report that notes parcels on DOR exempt file not on RPISMandatory
RPS-39Ability to create a report that notes parcels on RPIS exempt file not on DOR exempt fileMandatory
RPS-40Report of history of inactive homestead parcels at 4%Mandatory
RPS-41Ability to run a yearly program to edit file and submit to DOR for reimbursementMandatory
RPS-42Ability to pay records when DOR reimbursement check is receivedMandatory
RPS-43Ability to check for jurisdiction 'M' -- adds mobile home and land together for homestead purposesMandatory
RPS-44Ability to update land values for item code 85 -- mobile home and land charged togetherMandatory
RPS-45Ability to automatically process decals for mobile homes with zero balanceMandatory
RPS-46Ability to process real estate accounts with zero balanceMandatory
RPS-47Ability to update name overlay on tax billsMandatory
RPS-48Ability to update district on mobile home file for tax billsMandatory
RPS-49Ability to update rollback file on tax bills -- add a year and drop a yearMandatory
RPS-50Ability to apply homestead on tax billsMandatory
RPS-51Ability to update account # on mobile home file for tax billsMandatory
RPS-52Control file maintenance capability to update assessment yearMandatory
RPS-53Control file maintenance capability to update current mobile home yearMandatory
RPS-54Control file maintenance capability to update current BR yearMandatory
RPS-55Control file maintenance capability to update current yearMandatory
RPS-56Ability to create adhoc reports as neededMandatory
Treasurer / Finance Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
F-1Unlimited allocation percentagesMandatory
F-2GL account mapping tablesMandatory
F-3Interface with Munis deposit journalsMandatory
F-4Interface with Munis allocation journalsMandatory
F-5Interface with Munis Accounts PayableMandatory
F-6Create AP refundsMandatory
F-7Interface issued refund checksMandatory
F-8Interface voided refund checksMandatory
F-9FILOT allocationsMandatory
Reporting Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
R-1Entity collection reportsMandatory
R-2Top taxpayer reportsMandatory
R-3Assessed value reportsMandatory
R-4Year-over-year reportingMandatory
R-5Operator transaction reportsMandatory
R-6Transaction type reportsMandatory
R-7Period activity reportsMandatory
R-8Refund reportsMandatory
R-9Refund historyMandatory
R-10In-house reporting/data accessMandatory
R-11GASB-77 Automated reportingMandatory
R-12Automated yearly report for Administration of Total Municipal Vehicle Collections by period for specific entitiesMandatory
Integration Requirements
IDIntegrationPriorityVendor ResponseInterface Method
I-1GISMandatoryAPI/File
I-2County Valuation SystemMandatoryAPI/File
I-3Assessor SystemMandatoryAPI/File
I-4Munis FinancialsMandatoryAPI
I-5DMVMandatoryAPI
I-6Internet Payment VendorMandatoryAPI
I-7Receipt PrintersHighDriver/API
I-8Posting CompaniesHighFile/API
I-9Newspaper PublishingHighElectronic Export
Technical & Security Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
TS-1Role-based securityMandatory
TS-2Multi-factor AuthenticationHigh
TS-3Single Sign-On (Active Directory/Entra ID/SAML)High
TS-4Encryption in transitMandatory
TS-5Encryption at restMandatory
TS-6Detailed audit logsMandatory
TS-7Disaster Recovery capabilitiesMandatory
TS-8Backup and restore proceduresMandatory
TS-9SOC 2, ISO 27001, or equivalent security certificationHigh
TS-10REST APIs for integrationsMandatory
TS-11Browser-based interfacePreferred
TS-12Mobile compatibilityPreferred
Training Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
TR-1Onsite administrator trainingMandatory
TR-2Remote end-user trainingMandatory
TR-3Role-based trainingMandatory
TR-4Go-live onsite supportMandatory
TR-5Training documentationMandatory
Support Requirements
IDRequirementPriorityVendor ResponseDescription/Comments
S-124x7 Technical SupportMandatory
S-2One-hour response timeMandatory
S-3Dedicated support specialistsMandatory
S-4Software enhancements includedMandatory
S-5Online support portalPreferred
S-6Knowledge base/documentationPreferred
S-7Defined Service Level Agreements (SLAs)Mandatory

Sheet2

File details come from the government source that posted it. Updated .