City of Dacono ERP RFP - Appendix A - System Requirements - FINAL.xlsx

XLSX spreadsheet 299 KB Posted

Attached to
Enterprise Resource Planning (ERP) System Acquisition State and local contract opportunity
Solicitation number
8-2025
Issued by
Weld County, Colorado

About this file

The document is a System Requirements spreadsheet (Appendix A) for the City of Dacono's Enterprise Resource Planning (ERP) System Acquisition. The comprehensive RFP seeks a modern ERP software solution with detailed functional requirements spanning multiple municipal operational areas including finance and accounting, permit and license management, code enforcement, tax billing and collection, utility billing, courts management, human resources, and payroll. The requirements document provides an exhaustive list of 209 specific system capabilities across these domains, with vendors expected to indicate how they will meet each requirement through out-of-the-box solutions, configuration, integrated add-on products, or custom development.

The ERP system procurement aims to replace the City's current system with a comprehensive municipal management platform that supports complex governmental functions such as fund accounting, budgeting, permit processing, code enforcement case management, utility billing, human resources, and payroll processing. The detailed requirements suggest the City seeks a highly configurable, integrated system with robust reporting, workflow, and self-service capabilities across departments. Key focus areas include support for fund accounting, multi-year budgeting, online citizen services, mobile access for field operations, automated compliance tracking, and comprehensive financial management tools that meet governmental accounting standards and reporting requirements.

View the file

Other files for this state and local contract opportunity

Other files attached to Enterprise Resource Planning (ERP) System Acquisition, newest first.
File Type Posted
ERP System and Implementation Services RFP - FINAL.pdf PDF
City of Dacono ERP RFP - Appendix B - Total Cost of Ownership - FINAL.xlsx XLSX spreadsheet

On GovTribe

Work with this file on GovTribe

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

Text version

Requirements

ERROR:#VALUE!APPENDIX A: SYSTEM REQUIREMENTS
Vendor/Solution:Optional: Please add any comments or points that will help us understand your software's functions, features or unique approaches related to the requirement.
IDFunctional AreaSub-AreaRequirementAdditional Detail (NO VENDOR COMMENTS HERE)REQUIREMENT

MET BY

VENDOR SOLUTION

(OUT-OF-THE-BOX OR VIA CONFIGURATION)REQUIREMENT MET BY A FULLY INTEGRATED
PROPOSED ADD-ON PRODUCTREQUIREMENT MET BY A NON-INTEGRATED PROPOSED ADD-ON PRODUCT AND/OR REQUIRES DEVELOPMENTNOT
SUPPORTED OR PROPOSEDVENDOR COMMENTSX
1Cross-FunctionalSystem UsageUser-configurable dashboards.0
2Cross-FunctionalSystem UsageUser-configurable workflows and approvals.0
3Cross-FunctionalSystem UsageImport of business transactions from Excel, export of system reports to Excel.0
4Cross-FunctionalIntegrationsIntegration with OpenGov Cartegraph for all system functions where GIS data is relevant.0
5Finance & AccountingGeneral LedgerSupport for fund accounting.0
6Finance & AccountingGeneral LedgerMulti-segment chart of accounts structure with dimensional capabilities.Dimensions for projects, employees, etc.0
7Finance & AccountingGeneral LedgerAccrual, cash, and modified accrual basis support.0
8Finance & AccountingGeneral LedgerAutomatic creation of due-to and due-from entries across funds.0
9Finance & AccountingGeneral LedgerReal-time financial reporting.0
10Finance & AccountingGeneral LedgerAllocation templates to distribute revenue and expenses to multiple funds/departments.Example: some revenues are split between 2+ funds.0
11Finance & AccountingGeneral LedgerSupport for accumulating costs by project via Project Accounting capabilities.0
12Finance & AccountingBudgetingBudget planning & formulation with historical data integration.0
13Finance & AccountingBudgetingCollaborative budget preparation support.Distribution and roll-up of budgets governed by system-driven workflows.0
14Finance & AccountingBudgetingRolling forecasts for long-term capital and operational planning.0
15Finance & AccountingBudgetingPredefined budgeting templates by fund/department.0
16Finance & AccountingBudgetingLabor expense budgeting models prefilled with current headcount information.0
17Finance & AccountingBudgetingBudget modeling tools and functions.Formulas, ratios, dependent values, etc.0
18Finance & AccountingBudgetingBudget adjustments and amendments, including full auditability of changes.0
19Finance & AccountingBudgetingMulti-year budgeting capability.0
20Finance & AccountingBudgetingSupport for multiple budget versions.E.g., preliminary, recommended, adopted.0
21Finance & AccountingBudgetingProject-based budgeting for capital projects.0
22Finance & AccountingBudgetingRestricted fund budgeting for grants.0
23Finance & AccountingBudgetingAllocation of budgets to funding sources.E.g., general fund, grants, bonds, etc.0
24Finance & AccountingBudgetingIntra- and inter-departmental budget transfers.0
25Finance & AccountingBudgetingVariance analysis (actuals vs. budget) with commentary fields.0
26Finance & AccountingBudgetingVariance analysis comparing actuals to multiple budget versions.E.g., adopted vs. amended.0
27Finance & AccountingAccount ManagementShared account management, including parcel numbers, for any City services that are billed or collected: licenses, permits, utility billing, tax payments, code enforcement, etc.0
28Finance & AccountingAccount ManagementParent-child relationships for customer accounts.A development company (i.e., a parent account) may have multiple developments (i.e., child accounts).0
29Finance & AccountingAccount ManagementSupport for a "trading partner" concept where a customer (i.e., receive monies from) may be the same entity as a vendor (i.e., pay monies to).AR tied to AP.0
30Finance & AccountingCash ReceiptsSupport for cash receipts via cash, check, credit card.0
31Finance & AccountingCash ReceiptsOnline payment portal for credit card and ACH payments.0
32Finance & AccountingCash ReceiptsReal-time receipt generation with unique receipt numbers.0
33Finance & AccountingCash ReceiptsMulti-tender support (e.g., part cash, part credit card).0
34Finance & AccountingCash ReceiptsPayment void/reversal with logging and supervisor override.0
35Finance & AccountingCash ReceiptsAuto distribution of payments to appropriate GL funds/accounts.0
36Finance & AccountingCash ReceiptsSupport for physical cash drawers and receipt printers.0
37Finance & AccountingCash ReceiptsCash drawer balancing (daily open/close with reconciliation).0
38Finance & AccountingCash ReceiptsPayment reminders via text/email.0
39Finance & AccountingAccounts ReceivableAR balances at the customer child level.Example: each development project must maintain its AR balance, even though multiple development projects are under a parent development company.0
40Finance & AccountingAccounts ReceivableInvoice creation: multiple use cases.Liens, special assessments, code enforcement fines, etc.0
41Finance & AccountingProcurementRequisitioning and purchase orders.0
42Finance & AccountingProcurementTracking of vendor contract and insurance expirations.0
43Finance & AccountingProcurementExpense management for purchases made on credit cards.0
44Finance & AccountingAccounts PayableOCR scanning of AP invoices received.0
45Finance & AccountingAccounts PayableElectronic submission of AP invoices (via a portal).0
46Finance & AccountingAccounts PayableDistribution of invoice expenses across multiple funds, departments, grants, or projects.0
47Finance & AccountingAccounts PayableFlagging of AP invoice line items as "pass-throughs" with automatic creation of corresponding AR invoices to pass-through entity.0
48Finance & AccountingAccounts PayableFlagging of AP invoice line items with project codes for project cost accumulation.0
49Finance & AccountingAccounts PayableInvoice approvals via workflow.0
50Finance & AccountingAccounts PayableAutomated 2- and 3-way matching.0
51Finance & AccountingAccounts PayableDuplicate invoice detection.0
52Finance & AccountingAccounts PayableSupport for payment of recurring invoices.Rent, recurring service contracts, etc.0
53Finance & AccountingAccounts PayableSupport for check, ACH, wire, and credit card payments.0
54Finance & AccountingAccounts PayableP-card/credit card statement import, coding, and reconciliation.0
55Finance & AccountingAccounts PayableDue date tracking and payment scheduling that enables early payment discounts.0
56Finance & AccountingAccounts PayableEmail, print, or online vendor remittance statements.0
57Finance & AccountingAccounts PayableValidation of sufficient budget before invoice approval or payment.0
58Finance & AccountingAccounts PayableTrack and generate IRS-compliant vendor tax forms (1099, 1098, 1042-S, etc.).0
59Finance & AccountingAccounts PayableDigital archiving of invoices and supporting documentation.0
60Finance & AccountingFixed AssetsCustomizable/configurable asset categories/classes/types.0
61Finance & AccountingFixed AssetsAutomated asset ID generation.Including barcodes where appropriate.0
62Finance & AccountingFixed AssetsSupport for fixed asset creation via purchase, project/construction, or donation.0
63Finance & AccountingFixed AssetsIntegration with procurement/AP systems to auto-create assets upon purchase/payment.0
64Finance & AccountingFixed AssetsTracking of asset class, acquisition date, cost, fund, location, department, custodian, useful life.0
65Finance & AccountingFixed AssetsSupport for multiple depreciation methods.Straight line, declining balance, sum of years digits.0
66Finance & AccountingFixed AssetsGASB-compliant depreciation.0
67Finance & AccountingFixed AssetsDepreciation rules by asset class, department, or funding source.0
68Finance & AccountingFixed AssetsAuto-posting to GL of acquisition, depreciation, disposal, and transfer entries.0
69Finance & AccountingFixed AssetsAsset physical inventory management and auditing.0
70Finance & AccountingFixed AssetsSupport for asset improvements/enhancements and revaluations.0
71Finance & AccountingFixed AssetsSupport for asset disposals and write-offs.0
72Finance & AccountingFixed AssetsTrack improvement guarantees on asset improvements0
73Finance & AccountingBank ManagementManage multiple bank accounts across departments, funds, and uses (e.g., general fund, utilities, grants).Checking, savings, and investment accounts.0
74Finance & AccountingBank ManagementLink bank accounts to specific funds, departments, or GL cash accounts.0
75Finance & AccountingBank ManagementBank reconciliation via bank statement import (BAI2, MT940, CSV).0
76Finance & AccountingBank ManagementAuto-match bank transactions to system records (e.g., AP, AR, Payroll, cash receipts).0
77Finance & AccountingBank ManagementSupport for reconciling unmatched transactions manually with tagging and notes.0
78Finance & AccountingBank ManagementPartial and split matching: match one bank entry to multiple system entries and vice versa.0
79Finance & AccountingBank ManagementGeneration of NACHA (ACH) and wire transfer files for bank submission.0
80Finance & AccountingBank ManagementSupport for voiding, stop-payment requests, and check replacement workflows.0
81Finance & AccountingBank ManagementAutomated positive pay file generation.0
82Permit & License ManagementApplication ManagementOnline permit/license applications.0
83Permit & License ManagementApplication ManagementCustomizable forms by permit/license type.Building permit, event license, etc.0
84Permit & License ManagementApplication ManagementOnline payments with integration to payment processor.0
85Permit & License ManagementApplication ManagementSecure upload of supporting documentation for license applications.Site plans, bonds, certificates of insurance, etc.0
86Permit & License ManagementApplication ManagementConfigurable (by permit/license type) routing of applications to appropriate departments for review & approval.0
87Permit & License ManagementApplication ManagementStatus tracking of applications and automated communications to applicant.0
88Permit & License ManagementIssuance & RenewalGeneration of digital and printable permits/licenses with QR or barcodes.0
89Permit & License ManagementIssuance & RenewalConfigurable expiration dates and renewal periods.Example: daily/weekly/monthly food truck licenses.0
90Permit & License ManagementIssuance & RenewalAutomated reminders and renewal notices via letter, email, or text.Based on customer/account communication preferences0
91Permit & License ManagementIssuance & RenewalOnline renewals with updated information submission.0
92Permit & License ManagementPayment & Fee ManagementConfigurable permit/license fee schedules (flat, tiered, percentage, etc.).0
93Permit & License ManagementPayment & Fee ManagementAutomated permit/license fee calculations based on permit/license type and application data.0
94Permit & License ManagementPayment & Fee ManagementOnline payments with integration to payment processor.0
95Permit & License ManagementPayment & Fee ManagementIssuance of receipts and payment tracking.0
96Permit & License ManagementIntegrationIntegration with CommunityCore for building permits submitted and managed in that platform.0
97Code EnforcementCode Enforcement Case ManagementCreation, tracking, and management of code violations, from complaint/creation to resolution.Case workflows that include first notification, subsequent follow-ups, to liens, abatements, and other resolutions through closure.0
98Code EnforcementCode Enforcement Case ManagementSupport for multiple case types, with workflows and process steps by case type.Property violations, zoning issues, nuisance complaints, etc.0
99Code EnforcementCode Enforcement Case ManagementCitizen portal that allows citizens to report violations (photos and locations) and track progress of complaints.0
100Code EnforcementCode Enforcement Case ManagementNotice generation, issuance, and management: physical notices and digital notice delivery.0
101Code EnforcementCode Enforcement Case ManagementGeneration of printed notices and citations via mobile device.Issuance of notices or citations while in the field.0
102Code EnforcementCode Enforcement Case ManagementScheduling and tracking of inspections, enforcement actions, and follow-up actions.0
103Code EnforcementCode Enforcement Case ManagementMobile access for code enforcement officers to log notes, upload photos, and update status in real time.0
104Code EnforcementCode Enforcement Case ManagementTracking of all fines, revocations, or corrective action deadlines.0
105Code EnforcementCode Enforcement Case ManagementSystem-driven link to court scheduling for unresolved citations.0
106Code EnforcementFines & PaymentsCustomizable fines by case type and enforcement action.0
107Code EnforcementFines & PaymentsPayment processing for citations and recordings, including payment receipts.Multiple payment options, including online and in-person (i.e., cashier), with real-time update of monies collected.0
108Code EnforcementFines & PaymentsCreation and management of payment plans.0
109Code EnforcementCode Enforcement ReportingViolation tracking by property ID, address, owner, violation type, and status to enable proactive enforcement efforts.0
110Code EnforcementCode Enforcement ReportingReporting: track violation rates, types, resolution times, and compliance levels.0
111Code EnforcementCode Enforcement ReportingManage compliance audits and visits.0
112Tax Billing & CollectionTaxpayer RegistrationTaxpayer database/account management.0
113Tax Billing & CollectionTaxpayer RegistrationOnline registration for new taxpayers.0
114Tax Billing & CollectionTaxpayer RegistrationMultiple tax types per taxpayer with license details, filing frequency, etc. for each.0
115Tax Billing & CollectionTax Filing & BillingOnline tax filings with configurable forms for tax type.0
116Tax Billing & CollectionTax Filing & BillingAutomated ingestion of paper-based tax filings via OCR.0
117Tax Billing & CollectionTax Filing & BillingSupport for special/miscellaneous fees, e.g., paper filing fees.0
118Tax Billing & CollectionTax Filing & BillingAutomated calculation of taxes due.0
119Tax Billing & CollectionTax Filing & BillingSecure upload of supporting documentation.0
120Tax Billing & CollectionTax Filing & BillingBilling notices and filing reminders based on taxpayer schedules.0
121Tax Billing & CollectionTax Filing & BillingSupport for retroactive and amended returns.0
122Tax Billing & CollectionTax Payment ProcessingOnline payments with integration to payment processor.0
123Tax Billing & CollectionTax Payment ProcessingReal time payment confirmations and updates of taxpayer account.0
124Tax Billing & CollectionTax Compliance & EnforcementMonitoring of filings and payment compliance.0
125Tax Billing & CollectionTax Compliance & EnforcementAutomated delinquency notices, penalty and interest calculations.0
126Tax Billing & CollectionTax Compliance & EnforcementSupport for payment plans.0
127Tax Billing & CollectionTax Compliance & EnforcementSupport for liens and special assessments.0
128Utility BillingCustomer Account ManagementCustomer provisioning (starts/stops/transfers).0
129Utility BillingCustomer Account ManagementLinking of customer accounts to (multiple) service addresses and meter IDs.0
130Utility BillingCustomer Account ManagementTenant vs. owner occupancy tracking.0
131Utility BillingCustomer Account ManagementSupport for no-bill accounts.Providing water to City properties.0
132Utility BillingMeter ManagementSupport for manual and automated meter readings.Currently using Metron.0
133Utility BillingMeter ManagementConfigurable meter reading cycles.0
134Utility BillingMeter ManagementStore meter reading history.0
135Utility BillingMeter ManagementIdentification of usage anomalies (leaks, pikes).0
136Utility BillingMeter ManagementWater acquisition tracking.Water is purchased.0
137Utility BillingBilling & Rate ManagementSupport for tiered, flat, or usage-based rates.0
138Utility BillingBilling & Rate ManagementMultiple rate structures based use (residential, commercial), meter size.0
139Utility BillingBilling & Rate ManagementMultiple billing cycles.0
140Utility BillingBilling & Rate ManagementConsolidated billing across multiple meters.0
141Utility BillingBilling & Rate ManagementOption for email or printed bills per customer preference.Printed bills sent to outside printing/mailing service.0
142Utility BillingBilling & Rate ManagementGeneration of file for printed bills (outsourced function).0
143Utility BillingBilling & Rate ManagementProration of bills for partial billing periods.0
144Utility BillingBilling & Rate ManagementDelinquency and aging reports.0
145Utility BillingBilling & Rate ManagementLate payment management: penalties, interest.0
146Utility BillingBilling & Rate ManagementPast due notices/shut-off warnings.0
147Utility BillingBilling & Rate ManagementSupport for final bills.0
148Utility BillingPayment ProcessingOnline portal for credit card/ACH payments.0
149Utility BillingPayment ProcessingSupport for in-office payments (check, cash, card).0
150Utility BillingPayment ProcessingAutopay/recurring payment option.0
151Utility BillingPayment ProcessingIntegrated credit card processing.0
152Utility BillingPayment ProcessingReal-time payment posting.0
153Utility BillingPayment ProcessingReceipt generation.0
154Courts ManagementCourts Case ManagementCreate and track cases (traffic & code violations).0
155Courts ManagementCourts Case ManagementTrack case status, events, and dispositions.0
156Courts ManagementCourts Case ManagementSupport for multiple charges per case.0
157Courts ManagementCourts Case ManagementCitation import for case creation.0
158Courts ManagementScheduling & DocketingCalendar management for court hearings.0
159Courts ManagementScheduling & DocketingGenerate and manage court documents: summonses, warrants, notices.0
160Courts ManagementScheduling & DocketingAuto-generation of dockets.0
161Courts ManagementScheduling & DocketingRescheduling, continuances, and time-stamping.0
162Courts ManagementAdjudicationTemplate-based judgments, orders, letters.0
163Courts ManagementAdjudicationFine management: fines, fees, restitution, court costs.0
164Courts ManagementAdjudicationPayment plans and installment tracking.0
165Courts ManagementAdjudicationPayment integration with payment processors.0
166Courts ManagementAdjudicationState and local required reports: DMV, other.0
167Human ResourcesPosition ManagementPosition Control, pay rate, and job description repository.Position Control including partial-year positions.0
168Human ResourcesPosition ManagementJob requisition management and workflow.Including validation against Position Control.0
169Human ResourcesPosition ManagementAutomated posting of approved job requisitions to major job boards (e.g., Indeed, LinkedIn).0
170Human ResourcesRecruitingOnline candidate registration and job applications.0
171Human ResourcesRecruitingConfigurable knock-out questions and automated filtering of unqualified candidates.0
172Human ResourcesRecruitingCandidate self-service interview scheduling integrated with Outlook calendars.0
173Human ResourcesRecruitingTemplate-based and system-generated offer and rejection letters.0
174Human ResourcesRecruitingAutomated candidate communications via SMS/text and emails.0
175Human ResourcesCore HRISEmployee master records (demographics, preferences, job history, certifications).New employee information pre-populated from candidate information.0
176Human ResourcesCore HRISConfigurable onboarding checklists and workflows.0
177Human ResourcesCore HRISE-Verify integration via web services API.0
178Human ResourcesCore HRISEmployee self-service with workflow review and approvals of information provided.Uploading of documents, maintain employee information, skills/certifications.0
179Human ResourcesCore HRISSystem-generated organization charts.0
180Human ResourcesCore HRISEmployee/manager self-service.0
181Human ResourcesCore HRISRecertification reminders.0
182Human ResourcesCore HRISTrack city-owned property by employee.0
183Human ResourcesCore HRISPerformance management tools (goals, appraisals).0
184Human ResourcesCore HRISSupport for employee exit process: offboarding checklists, exit interviews, asset recovery.0
185Human ResourcesTime & AttendanceLeave & accruals management (vacation, sick, FMLA, other).Vacation, sick time, FMLA, Colorado paid leave.0
186Human ResourcesTime & AttendanceLeave requests and approvals.0
187Human ResourcesTime & AttendancePension fund accruals.Example: correct accumulation of base hours/base pay for police officers in pay periods with holidays.0
188Human ResourcesTime & AttendanceConfigurable overtime rules by job/position.0
189Human ResourcesTime & AttendanceLabor scheduling.Applies to select employee populations, e.g., police.0
190Human ResourcesTime & AttendanceTime reporting (mobile and desktop).Mandatory for hourly, by exception for salaried.0
191Human ResourcesTime & AttendanceGeofencing for mobile time reporting.0
192Human ResourcesTime & AttendanceSupervisor review, edit, and approval of time reported.0
193Human ResourcesTime & AttendanceSupport for cross-midnight and multi-day shifts in scheduling and time reporting.Automatic allocation of hours to correct pay period, rules for correct accrual of leave, overtime, or other premium pay.0
194Human ResourcesTime & AttendanceTracking and pay handling of standby and on-call hours.0
195Human ResourcesTime & AttendanceAlerts for attendance violations/exceptions.Tardiness, early departures, overtime.0
196Human ResourcesPayroll & BenefitsSupport for multiple payroll cycles/schedules.Weekly, bi-weekly, semi-monthly, monthly (currently only bi-weekly).0
197Human ResourcesPayroll & BenefitsCalculation of gross-to-net pay.0
198Human ResourcesPayroll & BenefitsAutomatic tax calculations.Specifically for Colorado.0
199Human ResourcesPayroll & BenefitsDirect deposit processing.0
200Human ResourcesPayroll & BenefitsPayroll adjustment and retroactive pay handling.0
201Human ResourcesPayroll & BenefitsLeave pay, overtime, and shift differentials.Examples: referral bonus, relocation.0
202Human ResourcesPayroll & BenefitsSupport for temporary pay increases.0
203Human ResourcesPayroll & BenefitsSupport for multiple types of payments.Distribution of bonus pools, recognition & awards.0
204Human ResourcesPayroll & BenefitsBenefits administration (insurance, retirement plans).Including reconciliation of payments to carriers to employee deductions.0
205Human ResourcesPayroll & BenefitsSupport for benefits open enrollment process.0
206Human ResourcesHR Compliance & ReportingACA, FLSA, FMLA, COBRA, and EEOC compliance.0
207Human ResourcesHR Compliance & Reporting941, Colorado payroll tax, City retirement, FPPA (police pension) forms and filings.Bi-weekly.0
208Human ResourcesHR Compliance & Reporting1099s, W-2s, W-4s, and other required tax forms and filings.Year-end.0
209Human ResourcesHR Compliance & ReportingGrant & fund tracking for funded positions.0

&G &G

&12&P of &N &12&D

Instructions

RFP Appendix A - System Requirements - Instructions for Completion
• For each requirement listed in the Requirements tab, please specify in which way your solution meets the requirement by placing an "X" in the appropriate column (F through I).
• Feel free to add comments in column J to provide additional clarity.
• Make sure you specify one (and only one) "X" for each requirement. Choose the category that best fits.

Page &P image2.png image3.jpeg image4.jpeg

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