The vendor required to provide to implement integrated financial modules within its selected ERP platform, microsoft dynamics 365 business central, modules include, but are not limited to:
- Phase i:
• General ledger
o Requires chart of account overhaul, potential change from one-to-many accounts, and historical data load integration
o Follow public sector accounting standards (PSAS)
o Support financial information return (FIR)
o Integration with active net
o Integration with city wide
• Accounts payable (eft, cheques and wires)
• Purchase orders
o Assign a project
o Allocate against a budget
o Display purchase lifecycle
• Cash receipts (property tax, water billing, misc.)
o Direct integration with A/R
• Accounts receivable (inclusive of all billings)
o Each customer is tied to a single account to centralize all updates and communications. Direct integration with cash receipting
o Lookup all billing types and receivables within an account
o Dunning; payment reminders and audit transactions
o Email and paper delivery; with audit
• Bank reconciliations
o Bank import
o Auto matching
• Property taxation, assessment, and land management – based on state standards
o Automated arrears transfer from other receivables
o Compiled transactional history and audit
o 2-3 tax bill (interim, final and supplemental)
o Support the posting of future levy assessments directly to the accounts receivable ledger
• Utilities (water, wastewater)
o Water statement (transaction history)
o Integration with senses
• Report creation (specifically details regarding “can” vs customizable reporting features)
o Identify license requirements for creating vs. manipulation of power BI reports
o Identify any other report writing requirements
o Fir reporting
• Licensing (pet, lottery (optional))
o Annual workflow for pet renewals
• Grant management
o Workflow
o Lifecycle reporting
• Projects (operations, capital, other types)
o Option of time tracking with and without use of a time sheet
o WBS structure; create templates for different project types
o Track original budget and amendments and changes
• Budget
o Budget owners create their budget direct in the system
o Retain budget details
o Scenario planning
• Attachments and file repository in all modules
• Language requirements to be in english only
- Optional and phase ii
• Payroll
o Different pay periods
o Hourly and salaried employees
• Time and attendance
o Timesheets are optional for employees, have exception-based reporting and approvals
o Time off requests and tracking
o Scheduling
• Human resources
o Integrated with payroll
o Onboarding and offboarding
o Employee and manager self-service portal
o License tracking
o Performance management
o Pay grids
o Vacation entitlement
• Expense management
o Company credit cards
o Employee expense reports
• Purchase requisition
o Add to po process
o Linked to budget
• Citizen portal
o Bill review
o Bill payments
• CRM
o Citizen raised concerns
o Internal issues
o Internal raised concerns from external sources
o Concerns and complaints by citizens and employees.
- The township’s fiscal year is January 1 – December 31 and its 2025 gross operating budget is ~$29 million, and the capital budget is ~$12 million.
- Questions/Inquires Deadline: February 2, 2026