Ozaukee - Vendor Response System Selection Proposal Workbook 05.02.2025.xlsx
XLSX spreadsheet 192 KB Posted
- Solicitation number
- ERP-1
- Issued by
- Ozaukee County, Wisconsin
About this file
This document is a comprehensive Vendor Response System Selection Proposal Workbook for Ozaukee County, Wisconsin, detailing a robust Request for Proposal (RFP) for an integrated enterprise resource planning (ERP) system. The proposal encompasses a detailed examination of functional requirements across multiple critical business modules including general ledger, accounts receivable, accounts payable, fixed assets, financial planning and analysis, treasury and cash management, grant and program management, human resources, payroll, and time management. The RFP seeks a comprehensive, cloud-based system with advanced capabilities such as multi-tenant architecture, single sign-on, role-based access controls, AI integration, workflow automation, and extensive reporting capabilities.
The document outlines an extensive evaluation process where vendors must respond to numerous functional requirements using specific response codes indicating standard functionality, add-on modules, integrated applications, or custom solutions. While specific cost details are not explicitly stated, the RFP indicates a multi-year implementation approach with considerations for initial implementation, training, and ongoing support costs. The system selection appears to be driven by the county's need for enhanced financial management, improved interdepartmental integration, compliance requirements, and the ability to track complex funding sources such as grants, programs, and multiple budget cycles. The county emphasizes requirements around security, data management, reporting flexibility, and the potential for future technological enhancements, particularly around AI and automation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Ozaukee - System Selection RFP 05.02.2025.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
Instructions
| Document Overview and Instructions |
| Client expects the Proposal Worksheets to be provided in their original Excel format when completed. A PDF version of the proposal can also be included within the RFP response. |
| Note: There are multiple worksheets present within this workbook. See below for additional details. |
| Proposal Worksheets |
| Vendor Profile: Include relevant information about your company such as history and organizational structure. |
| General Requirements: Please provide relevant information on general system and implementation requirements, including training, support, and security. |
| Client Functional Requirements: Functional requirements are organized by functional area and/or related areas. Please respond to each functional requirements tab, using the following response options: |
| S - Standard functionality within core system |
AM - Functionality exists in an add-on module API - Functionality exists in an integrated app APS - A separate stand-alone app is required for functionality CR - Custom report must be created for functionality C - Functionality can be achieved with a custom enhancement NW - A procedure is required to achieve functionality NA - Functionality is not available within this system
Cost Summary: Please provide estimated initial 1-year and 5-year total costs of ownership
Vendor Profile
| VENDOR COMPANY | VENDOR RESPONSE |
| Vendor Name | |
| Vendor Headquarters Location | |
| # of Years In Business (Division) | |
| Parent Corporation Name | |
| # of Years in Business (Parent Corp) | |
| # of Total Clients on Proposed System | |
| Website | |
| Primary Contact Name for Proposal | |
| Primary Contact Email | |
| Primary Contact Phone Number | |
| If the proposed solution includes a separate organization for implementation, please provide the following, as well: | |
| IMPLEMENTER PARTNER COMPANY | VENDOR RESPONSE |
| Implementer Company Name | |
| Implementer Headquarters Location | |
| # of Years In Business (Division) | |
| Parent Corporation Name | |
| # of Years in Business (Parent Corp) | |
| # of Total Clients Implemented | |
| Website | |
| PLEASE PROVIDE ANY LINKS TO DEMOS OR WHITEPAPERS |
&A CliftonLarsonAllen Confidential &P
Non-Functional Requirements
| VENDOR STAFF | VENDOR RESPONSE |
| # of Total Employees | |
| # on Implementation Team | |
| # of Trainers | |
| # in Support |
| MAINTAINABILITY & SCALABILITY | VENDOR RESPONSE |
| Describe Process for Upgrades/Updates | |
| Describe platform's current AI enhancements | |
| Outline roadmap for future integration of AI technology | |
| Is System True Cloud Multi-Tenant Architecture? | |
| Browser Based Access? | |
| Does System Support SSO? | |
| Are APIs Published? |
| IMPLEMENTATION | VENDOR RESPONSE |
| Describe Implementation Approach | |
| Approximate Timeline for Implementation | |
| Any Additional Considerations for Integration |
| TRAINING & TESTING | VENDOR RESPONSE |
| Describe Training Approach | |
| Approximate Timeline for Training | |
| Is Sandbox Provided for Testing? |
| SUPPORT | VENDOR RESPONSE |
| Primary Support Center Location | |
| Support Hours | |
| Support Contact Method | |
| Estimated Support Costs |
| COMPLIANCE & SECURITY | VENDOR RESPONSE |
| Where is Data Housed? | |
| What is the Structure for Data Redundancy? | |
| Please List Security Protocols | |
| Please List Compliance Certifications and Audits | |
| Do You Require Multi-Factor Authentication? |
General System
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Integration | Ability to integrate as needed with HHS Case Management and Billing - HIPPA compliant | S - Show Stopper | Choose | ||
| 2 | Integration | Ability to schedule reports and/or import data from outside/ancillary systems for processing (i.e. eWisacwis) | S - Show Stopper | Choose | ||
| 3 | Integration | Alternative comparable module for Highway cost accounting and consolidation | S - Show Stopper | Choose | ||
| 4 | Integration | Alternative comparable module for time reporting and related cost accounting | S - Show Stopper | Choose | ||
| 5 | Integration | Integrated document management | S - Show Stopper | Choose | ||
| 6 | Integration | Integrated workflow management | S - Show Stopper | Choose | ||
| 7 | Security | Ability to protect application security administrator functions from general user access | S - Show Stopper | Choose | ||
| 8 | Security | Ability to limit who is authorized to update/changes to system records | S - Show Stopper | Choose | ||
| 9 | Security | Ability to support role-based access control and user permissions | S - Show Stopper | Choose | ||
| 10 | Security | Ability to administer multiple levels of user access controls | R - Required | Choose | ||
| 11 | Security | Alerts and notifications functionality | R - Required | Choose | ||
| 12 | Security | Ability to create user defined alerts throughout the system | R - Required | Choose | ||
| 13 | Security | Ability to have two factor authentication and single sign on capabilities | R - Required | Choose | ||
| 14 | Security | Ability to include security certificates for government reporting processes | R - Required | Choose | ||
| 15 | Security | Ability to support secure authentication and data encryption | R - Required | Choose | ||
| 16 | Security | Capability to establish user profiles for employees outlining access authorizations and restrictions. (edit, read only, etc.) | R - Required | Choose | ||
| 17 | Workflow | Ability to attach notes, documents and files to transactions throughout the system | S - Show Stopper | Choose | ||
| 18 | Workflow | Ability to generate critical alert notifications | R - Required | Choose | ||
| 19 | Workflow | Ability to identify which fields are required or optional as part of the data collection process | R - Required | Choose | ||
| 20 | Workflow | Capability to assign workflows to user role | R - Required | Choose | ||
| 21 | Workflow | Capability to incorporate AI technology throughout the system with a plan for future implementation | S - Show Stopper | Choose |
General Ledger
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Account Structure | Ability to add, change, or inactivate/delete (if no records in the account) G/L accounts at any time with audit trail of all changes | S - Show Stopper | Choose | ||
| 2 | Account Structure | Ability to maintain the account type (asset, liability, income, expense) within the account master file | S - Show Stopper | Choose | ||
| 3 | Account Structure | Ability to establish a “short” description for a G/L account for searching and sorting capabilities | R - Required | Choose | ||
| 4 | Account Structure | Ability to indicate a debit or credit indicator for normal balance of the account | R - Required | Choose | ||
| 5 | Account Structure | Ability to maintain month-end actual balances for all accounts for all periods | R - Required | Choose | ||
| 6 | Administrative Tools | Ability to copy a range of G/L accounts to establish a new entity without manually building each G/L account | R - Required | Choose | ||
| 7 | Administrative Tools | Ability to provide help screens when establishing a G/L account including category and account type | R - Required | Choose | ||
| 8 | Administrative Tools | Ability to generate an audit trail of all G/L entries including all components of transaction and location | R - Required | Choose | ||
| 9 | Allocations | Ability to automate allocation for income and expenses | S - Show Stopper | Choose | ||
| 10 | Allocations | Ability to establish recurring entries to be posted with variable amount fields | R - Required | Choose | ||
| 11 | G/L Architecture | Ability to restrict G/L account maintenance based on security levels | S - Show Stopper | Choose | ||
| 12 | G/L Architecture | Ability to establish a suspense account for automatic entry of invalid account postings | R - Required | Choose | ||
| 13 | G/L Architecture | Ability to establish and maintain user-defined fields in G/L master file | R - Required | Choose | ||
| 14 | G/L Architecture | Ability to establish multiple dimensions within the chart of accounts | R - Required | Choose | ||
| 15 | G/L Architecture | Ability to merge G/L account information to another G/L account, moving all historical data related to those accounts | R - Required | Choose | ||
| 16 | G/L Architecture | Ability to support both calendar year and fiscal year accounting that start with different calendar months | R - Required | Choose | ||
| 17 | Inquiry | Ability to search by dollar amount and description | R - Required | Choose | ||
| 18 | Inquiry | Ability to search G/L and drill to original transaction | R - Required | Choose | ||
| 19 | Integration | Ability to download G/L to spreadsheets with source notation | R - Required | Choose | ||
| 20 | Integration | Ability to upload transactions and G/L field information | R - Required | Choose | ||
| 21 | Journal Entries | Ability to automatically create and upload journal entries from spreadsheets | R - Required | Choose | ||
| 22 | Journal Entries | Ability to edit multi-page journal entries during entry by line - required edit to include void of recorded entry | R - Required | Choose | ||
| 23 | Journal Entries | Ability to establish and maintain the posting (actual) date of a journal entry | R - Required | Choose | ||
| 24 | Journal Entries | Ability to establish and maintain the transaction (effective) date of a journal entry | R - Required | Choose | ||
| 25 | Journal Entries | Ability to generate a warning when an error occurs in the journal entry posting process | R - Required | Choose | ||
| 26 | Journal Entries | Ability to generate an automated notification when journal entry exceeds a defined dollar threshold | R - Required | Choose | ||
| 27 | Journal Entries | Ability to support an automated workflow for review and approval of journal entries prior to posting | R - Required | Choose | ||
| 28 | Journal Entries | Ability to set default posting period | R - Required | Choose | ||
| 29 | Month-End | Capability to setup a close-out workflow/process | R - Required | Choose | ||
| 30 | Month-End | Automate the release of restricted revenue (By category, corporate, individual, foundation, or for specified purpose) | D - Desired | Choose | ||
| 31 | Month-End | Capability to restrict posting of journal entries to a specific general ledger account numbers by employee (user) or role | R - Required | Choose | ||
| 32 | Recurring Entries | Ability to identify a journal entry to automatically generate a reversing entry | R - Required | Choose | ||
| 33 | Recurring Entries | Ability to post recurring entries to future periods without closing prior periods | R - Required | Choose | ||
| 34 | Recurring Entries | Ability to revise recurring entries with options to adjust amount | R - Required | Choose | ||
| 35 | Recurring Entries | Ability to support the processing of recurring journal entries (vouchers) with amounts that change each period | R - Required | Choose | ||
| 36 | Recurring Entries | Ability to support the processing of recurring, fixed amount journal entries (vouchers), i.e. for fixed leases | R - Required | Choose | ||
| 37 | Recurring Entries | Ability to establish a recurring entry | R - Required | Choose | ||
| 38 | Reporting | Ability to build financial statements and financial analysis reports using menu driven selection of accounts for inclusion | S - Show Stopper | Choose | ||
| 39 | Reporting | Ability to create comparative analysis reports using financial data | S - Show Stopper | Choose | ||
| 40 | Reporting | Ability to generate an audit report for all file maintenance on the G/L, accounts payable or payroll modules | S - Show Stopper | Choose | ||
| 41 | Reporting | Ability to generate reports based on selection of a desired range of data | S - Show Stopper | Choose | ||
| 42 | Reporting | Ability to maintain G/L transaction history for a user-defined period of time | R - Required | Choose | ||
| 43 | Reporting | Ability to automatically distribute reports to specific individuals based on a distribution table or profile | R - Required | Choose | ||
| 44 | Reporting | Ability to generate G/L accounts or master file listing including: Active; Inactive; Both | R - Required | Choose | ||
| 45 | Reporting | Ability to generate reports on G/L master file in different sort sequences | R - Required | Choose | ||
| 46 | Reporting | Ability to generate the G/L report in detail or summary by entity | R - Required | Choose | ||
| 47 | Reporting | Ability to generate reports based on trends over a user-defined period | D - Desired | Choose | ||
| 48 | Reporting | Ability to generate reports that use non-financial information (units; staff, equipment, etc.) for comparative analysis purposes | R - Required | Choose | ||
| 49 | Security Architecture | Ability to limit who is authorized to establish new G/L records | S - Show Stopper | Choose | ||
| 50 | Security Architecture | Ability to limit who is authorized to update/change an established G/L record | S - Show Stopper | Choose | ||
| 51 | Security Architecture | Ability to restrict material requisitions journal entries to a specific (or range) G/L account | R - Required | Choose | ||
| 52 | Security Architecture | Ability to restrict posting of journal entries to a specific (or range) G/L accounts by employee (user) or role | R - Required | Choose |
AR
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Integrations | Ability to import data from other systems (i.e., ancillary external systems and portals) | S - Show Stopper | Choose | ||
| 2 | Integrations | Ability to integrate with current HHS system | S - Show Stopper | Choose | ||
| 3 | Invoicing | Ability to track progress and billings by program / project during the lifecycle | S - Show Stopper | Choose | ||
| 4 | Invoicing | Ability to view and/or print posted invoices | S - Show Stopper | Choose | ||
| 5 | Invoicing | Capability to automate transaction posting to G/L | S - Show Stopper | Choose | ||
| 6 | Invoicing | Capability to generate customer invoices based on specific customer information (customized invoice based on customer) | S - Show Stopper | Choose | ||
| 7 | Invoicing | Ability to bill by project number for state jobs and track payments against contracts | S - Show Stopper | Choose | ||
| 8 | Invoicing | Ability to generate bills through project accounting and use the sales module; need for contract-specific billing for state projects | S - Show Stopper | Choose | ||
| 9 | Invoicing | Ability to associate invoice numbers to specific projects or departments | R - Required | Choose | ||
| 10 | Invoicing | Ability to generate an invoice from different entities/departments | R - Required | Choose | ||
| 11 | Invoicing | Ability to generate different invoice types (i.e., HHS, license fees, other statutory fees) | R - Required | Choose | ||
| 12 | Invoicing | Ability to recognize revenue over life of project/contract (e.g., ability to spread revenue based on project/contact terms) | R - Required | Choose | ||
| 13 | Invoicing | Ability to route an invoice for approval (automated workflow) | R - Required | Choose | ||
| 14 | Invoicing | Ability to view the approval status of an invoice | R - Required | Choose | ||
| 15 | Invoicing | Capability to automate invoicing and approval workflow | R - Required | Choose | ||
| 16 | Invoicing | Includes approval workflow for processing AR invoices | R - Required | Choose | ||
| 17 | Invoicing | Ability to invoice partially as work is completed to maintain cash flow and accurate billing | R - Required | Choose | ||
| 18 | Invoicing | Ability to send a notification when invoice status changes (generated, routed, approved/rejected, sent) | R - Required | Choose | ||
| 19 | Maintenance | Ability to accept multiple types of deposits (checks, wire, ACH, PayPal, other electronic) | S - Show Stopper | Choose | ||
| 20 | Maintenance | Ability to assign customers to specific departments and code accordingly | S - Show Stopper | Choose | ||
| 21 | Maintenance | System to be HIPAA compliant as required | S - Show Stopper | Choose | ||
| 22 | Maintenance | Ability to limit who is authorized to update/change an established customer record | R - Required | Choose | ||
| 23 | Maintenance | Ability to split and track incoming payments to different funds/departments/projects/contracts/etc. and code accordingly | R - Required | Choose | ||
| 24 | Maintenance | Ability to assign vendors to specific departments to prevent client ID misuse | R - Required | Choose | ||
| 25 | Maintenance | Ability to set up and maintain client information with an approval process for changes | R - Required | Choose | ||
| 26 | Reporting | Capability to generate a monthly cash receipts journal | S - Show Stopper | Choose | ||
| 27 | Reporting | Capability to generate customer history reports based on multiple selection criteria (i.e., fund, grant, project, contract, etc.) | S - Show Stopper | Choose | ||
| 28 | Reporting | Capability to generate transaction reports based specific criteria (i.e., fund, grant, project, contract, etc.) | S - Show Stopper | Choose | ||
| 29 | Reporting | Ability to track time based on projects to ensure all project-related work is recorded and billed | S - Show Stopper | Choose | ||
| 30 | Reporting | Capability to create an aged receivable reporting | R - Required | Choose | ||
| 31 | Reporting | Capability to send month-end statements to customer/vendors | R - Required | Choose |
AP, Exp Mgmt & Purchasing
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Approvals | Ability to allow for flexible approval hierarchies (dollar limits, program, wire payments, back-up, reminders) | R - Required | Choose | ||
| 2 | Approvals | Ability to centralize tracking of approval status within the AP module | R - Required | Choose | ||
| 3 | Approvals | Capability for automated approval workflow (to include user defined rules for check signers, approvers, etc. ) | R - Required | Choose | ||
| 4 | Approvals | Capability to “hold” processing of invoices without proper approval | R - Required | Choose | ||
| 5 | Approvals | Capability to create additional approvals to the workflow for a given transactions | R - Required | Choose | ||
| 6 | Approvals | Capability to include approval workflow for fixed asset purchases | R - Required | Choose | ||
| 7 | Approvals | Include approval workflow for allowable cost documented approvals (grant management) | R - Required | Choose | ||
| 8 | Approvals | Ability to approve via mobile device (e.g., smartphone) | D - Desired | Choose | ||
| 9 | Bid Process | Ability to automate and integrate and update bid process with G/L and PO process | R - Required | Choose | ||
| 10 | Bid Process | Ability to track and update contracts including milestones and deliverables | R - Required | Choose | ||
| 11 | Contract Management | Ability to automate and integrate RFP approval process and PO tracking | R - Required | Choose | ||
| 12 | Contract Management | Ability to automate contract creation and approval workflow | R - Required | Choose | ||
| 13 | Credit Cards/P-Cards | Ability for approval workflow for user limit increase/decrease requests | R - Required | Choose | ||
| 14 | Credit Cards/P-Cards | Ability to automate credit card/P-card expense reconciliation to the credit card statement(s) prior to payment of account | R - Required | Choose | ||
| 15 | Credit Cards/P-Cards | Ability to integrate AP transaction detail from a credit card / purchase card issuer to general ledger | R - Required | Choose | ||
| 16 | Credit Cards/P-Cards | Ability to set individual user limits on corporate cards / purchase cards | R - Required | Choose | ||
| 17 | Credit Cards/P-Cards | Capability for purchase card and/or credit card tracking, reporting, and maintenance | R - Required | Choose | ||
| 18 | Credit Cards/P-Cards | Ability to upload and track receipts for credit card/purchase card reporting via a variety of user interfaces including mobile devices | D - Desired | Choose | ||
| 19 | Expense Management | Ability to automate the employee expense reporting process (workflow) | S - Show Stopper | Choose | ||
| 20 | Expense Management | Ability to configure workflow for expenses not requiring receipt (i.e. per diem, invoices under predetermined dollar threshold, etc.) | R - Required | Choose | ||
| 21 | Expense Management | Ability to route expenses for approval using various workflows based on billable vs. non-billable (pass through to various jurisdictions) | D - Desired | Choose | ||
| 22 | Payables | Ability to associate costs to a specific program, project, and/or department | S - Show Stopper | Choose | ||
| 23 | Payables | Ability to automatically code recurring transactions | S - Show Stopper | Choose | ||
| 24 | Payables | Ability to drill down to the originating source document from the GL (e.g., revenue to AR invoice, expense to AP invoice, etc.) | S - Show Stopper | Choose | ||
| 25 | Payables | Ability to identify possible duplicate invoices and report / display for review | S - Show Stopper | Choose | ||
| 26 | Payables | Ability to override the payment terms of the vendor at the individual invoice level | S - Show Stopper | Choose | ||
| 27 | Payables | Ability to search for a specific invoice based on multiple criteria | S - Show Stopper | Choose | ||
| 28 | Payables | Ability to assign GL coding to an expense based upon multiple criteria (e.g., vendor name, invoice description, project, department) | R - Required | Choose | ||
| 29 | Payables | Ability to automate amortization of prepaids and ability to select amortization periods (duration) with correct G/L account | R - Required | Choose | ||
| 30 | Payables | Ability to automate invoice / PO matching process | R - Required | Choose | ||
| 31 | Payables | Ability to flag expenses that are out of policy compliance | R - Required | Choose | ||
| 32 | Payables | Ability to flag expenses that are not budgeted or exceed approved budget | R - Required | Choose | ||
| 33 | Payables | Ability to generate fixed asset record through accounts payable transaction | R - Required | Choose | ||
| 34 | Payables | Ability to have multiple AP transactions against a single purchase order | R - Required | Choose | ||
| 35 | Payables | Ability to import vendor invoices from external vendor portal (e.g., FedEx invoices, etc.) | R - Required | Choose | ||
| 36 | Payables | Ability to match invoices to pre-defined/approved threshold (i.e. department spending limits and/or approval requirements) | R - Required | Choose | ||
| 37 | Payables | Ability to notify if fixed asset record should be created based on dollar amount | R - Required | Choose | ||
| 38 | Payables | Ability to process a partial payment against an outstanding invoice | R - Required | Choose | ||
| 39 | Payables | Ability to setup recurring invoices (e.g., monthly service contracts) | R - Required | Choose | ||
| 40 | Payables | Ability to validate against policy at the time of entry or approval | R - Required | Choose | ||
| 41 | Payables | Capability to allow attachments (i.e. documents, emails, associated invoices, notes) to transactions | R - Required | Choose | ||
| 42 | Payables | Capability to segregate line items within a single invoice for different departments, and/or programs for tracking/reporting | R - Required | Choose | ||
| 43 | Payments | Ability to generate and print physical check run | S - Show Stopper | Choose | ||
| 44 | Payments | Capability to select multiple invoices for inclusion on one check to vendor | S - Show Stopper | Choose | ||
| 45 | Payments | Ability for system to alert vendors when ACH payments have been made | R - Required | Choose | ||
| 46 | Payments | Ability to create/send remittance advice for ACH payments | R - Required | Choose | ||
| 47 | Payments | Ability to designate special handling procedures (i.e. return to company, do not mail; manual review, etc.) to invoice (voucher) record | R - Required | Choose | ||
| 48 | Payments | Ability to integrate Positive Pay functionality | R - Required | Choose | ||
| 49 | Payments | Capability to flag invoices as do not pay | R - Required | Choose | ||
| 50 | Payments | Capability to generate checks and remittance detail separately | R - Required | Choose | ||
| 51 | Payments | Capability to print the applied credit memo on the stub of the check | R - Required | Choose | ||
| 52 | Payments | Capability to review and edit check run PRIOR to the payment process | R - Required | Choose | ||
| 53 | Payments | Capability to schedule posting to G/L for recurring payments and selection of periods that will be impacted | R - Required | Choose | ||
| 54 | Payments | Capability to support multiple payment methods per vendor including check, ACH, credit card, wire payments | R - Required | Choose | ||
| 55 | Payments | Ability to manage ACH payments via AP software integration (eliminate duplicate bank and accounting software entry) | D - Desired | Choose | ||
| 56 | Purchase Orders | Ability to flag when purchase order is out of compliance with policy (i.e. non-approved vendor, over spending limit/budget, etc.) | R - Required | Choose | ||
| 57 | Purchase Orders | Ability to have rules based policies with automatic compliance checking | R - Required | Choose | ||
| 58 | Purchase Orders | Ability to provide and attach additional explanation, information, or documentation to purchase order / invoice | R - Required | Choose | ||
| 59 | Purchase Orders | Ability to submit purchase orders for pre-approval prior to purchase | R - Required | Choose | ||
| 60 | Purchase Orders | Ability to validate against policy at the time of entry | R - Required | Choose | ||
| 61 | Purchase Orders | Capability for the system to generate an alert when an invoice has not been received for an approved requisition | R - Required | Choose | ||
| 62 | Purchase Orders | Capability to limit who is authorized to submit purchase requests | R - Required | Choose | ||
| 63 | Reporting | Ability to analyze expense by department, employee, project, etc. | S - Show Stopper | Choose | ||
| 64 | Reporting | Ability to generate an "aged" accounts payable report on unpaid invoices | S - Show Stopper | Choose | ||
| 65 | Reporting | Ability to set work flows that remind staff of missing documentation/actions needed | R - Required | Choose | ||
| 66 | Reporting | Capability to monitor invoice aging, workflow routing, and time at each step | R - Required | Choose | ||
| 67 | Reporting | Ability to generate a report of outstanding transactions based on specific criteria, i.e. period of time, department, program, etc. | R - Required | Choose | ||
| 68 | Vendor Quote | Ability to generate quote information by vendor or multiple vendors | R - Required | Choose | ||
| 69 | Vendor Reports | Ability to automate exceptions report | S - Show Stopper | Choose | ||
| 70 | Vendor Reports | Ability to report purchases by vendor | S - Show Stopper | Choose | ||
| 71 | Vendor Reports | Ability to generate new purchase requirements report | R - Required | Choose | ||
| 72 | Vendor Reports | Ability to have repository for quote information received from vendors in paper or electronic format | D - Desired | Choose | ||
| 73 | Vendors | Ability to setup a new vendor setup and approval process workflow | S - Show Stopper | Choose | ||
| 74 | Vendors | Ability to associate a vendor status with a specific vendor including: Active, Inactive, Temporary, Hold, etc. | R - Required | Choose | ||
| 75 | Vendors | Ability to establish and assign category / type / department / program to a vendor and update as needed | R - Required | Choose | ||
| 76 | Vendors | Ability to establish payment terms at the vendor level for all invoices | R - Required | Choose | ||
| 77 | Vendors | Ability to have an approved/preferred vendors list with search access by purchasers | R - Required | Choose | ||
| 78 | Vendors | Ability to limit who is authorized to update/change an established vendor record | R - Required | Choose | ||
| 79 | Vendors | Certificate of Insurance process (automated annual tracking and related requests) | R - Required | Choose | ||
| 80 | Vendors - W-9/1099 Tracking | Ability to designate vendor as 1099 vendor at the time of setup | S - Show Stopper | Choose | ||
| 81 | Vendors - W-9/1099 Tracking | Ability to differentiate taxable amounts vs. reimbursements for vendor 1099's | S - Show Stopper | Choose | ||
| 82 | Vendors - W-9/1099 Tracking | Ability to automate the W-9 delivery process | R - Required | Choose | ||
| 83 | Vendors - W-9/1099 Tracking | Ability to generate 1099 file for electronic transmission to reporting agency | R - Required | Choose | ||
| 84 | Vendors - W-9/1099 Tracking | Ability to update designate vendor as 1099 vendor at any time and have all previous entries automatically reset the 1099 amount | R - Required | Choose | ||
| 85 | Workflow | Ability to automate invoice entry with OCR (Optical Character Recognition) and AI machine learning to reduce manual data entry | R - Required | Choose | ||
| 86 | Workflow | Ability to automate Purchase Orders for approved requisitions | R - Required | Choose | ||
| 87 | Workflow | Ability to integrate approvals and signoffs within the requisition and purchasing process(es) | R - Required | Choose | ||
| 88 | Workflow | Ability to sort vendors by criteria when more than one available | R - Required | Choose | ||
| 89 | Workflow | Ability to automate approval/management purchase orders workflow | R - Required | Choose | ||
| 90 | Workflow | Ability to automate vendor returns processing | D - Desired | Choose | ||
| 91 | Workflow | Ability to prompt or email alert when user has requisition awaiting approval | R - Required | Choose | ||
| 92 | Workflow | Ability to submit Requests for Purchases electronically and route based on business rules | R - Required | Choose |
Fixed Assets
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Depreciation | Ability to automate depreciation detail tracking | S - Show Stopper | Choose | ||
| 2 | Depreciation | Ability to automate depreciation calculations and records | S - Show Stopper | Choose | ||
| 3 | Depreciation | Ability to tag projects as fixed assets and ensure depreciation starts when the asset is in service | S - Show Stopper | Choose | ||
| 4 | Depreciation | Ability to customize depreciation methods by asset | R - Required | Choose | ||
| 5 | Fixed Asset Tracking | Ability to establish, maintain and track FA based on FA ID (i.e., description, acquisition and disposal date, serial number, etc.) | S - Show Stopper | Choose | ||
| 6 | Fixed Asset Tracking | Ability to establish, maintain and track FA financial information (i.e., hourly rate, acquisition cost, etc.) | S - Show Stopper | Choose | ||
| 7 | Fixed Asset Tracking | Ability to track all fleet assets as separate FA (i.e., description, acquisition and disposal date, VIN, registrations, etc.) | S - Show Stopper | Choose | ||
| 8 | Fixed Asset Tracking | Ability to capture all relevant data for state compliance | S - Show Stopper | Choose | ||
| 9 | Fixed Asset Tracking | Ability to handle specific state report categories, salvage value, equipment class, and CAMS compliance | S - Show Stopper | Choose | ||
| 10 | Fixed Asset Tracking | Ability to track all costs associated with a project, including labor, materials, and other expenses | S - Show Stopper | Choose | ||
| 11 | Fixed Asset Tracking | Ability to use project numbers to track expenses and ensure accurate reporting and depreciation | S - Show Stopper | Choose | ||
| 12 | Fixed Asset Tracking | Ability to track customer billing information for FA/inventory (i.e., bill rate, FA type (internal/external), OH rate, etc.) | R - Required | Choose | ||
| 13 | Fixed Asset Tracking | Ability to track insurance by FA (i.e., insurance certificate, damage claims, claims payments) | R - Required | Choose | ||
| 14 | Fixed Asset Tracking | Capability to track and integrate material tonnage data (scale charges) | R - Required | Choose | ||
| 15 | Fixed Assets | Ability to calculate gain/loss on disposals/sales of FA | S - Show Stopper | Choose | ||
| 16 | Fixed Assets | Ability to track assets by user-defined category | S - Show Stopper | Choose | ||
| 17 | Fixed Assets | Ability to attach copies of AP invoice or other documentation to asset record | R - Required | Choose | ||
| 18 | Fixed Assets | Ability to generate a report to notify the Maintenance Staff in advance that a piece of FA is due to be serviced or repaired | R - Required | Choose | ||
| 19 | Fixed Assets | Ability to setup and track lease agreements for FA | R - Required | Choose | ||
| 20 | Fixed Assets | Ability to track and report on useful life of assets (i.e. computers) | R - Required | Choose | ||
| 21 | Fixed Assets | Ability to capitalize assets annually and transition to capitalizing as assets are acquired | R - Required | Choose | ||
| 22 | Fixed Assets | Ability to assign FA to a grant/program and notate any special grant/program and disposal requirements | D - Desired | Choose | ||
| 23 | Fixed Assets | Ability to notify if an asset record should be created based on dollar amount | R - Required | Choose | ||
| 24 | Inventory Tracking | Ability to track non-reusable materials (i.e., lubricants, etc.) as inventory and integrate with G/L | S - Show Stopper | Choose | ||
| 25 | Inventory Tracking | Ability to track parts and materials as inventory and integrate with G/L | S - Show Stopper | Choose | ||
| 26 | Inventory Tracking | Ability to track "small tools" as non-inventory asset | R - Required | Choose | ||
| 27 | Maintenance | Ability to establish and maintain FA service/repair documentation | R - Required | Choose | ||
| 28 | Maintenance | Ability to establish, maintain and track FA service/repair information (i.e., service/repair date, service/repair schedule, costs, etc.) | R - Required | Choose | ||
| 29 | Maintenance | Ability to support FA maintenance tracking | R - Required | Choose | ||
| 30 | Rent/Lease | Ability to comply with lease reporting (i.e., ASC 842) | R - Required | Choose | ||
| 31 | Rent/Lease | Ability to establish and maintain term (short or long term) of lease or rental | R - Required | Choose | ||
| 32 | Reporting | Ability to track and report the allocation of assets, including those purchased with grants | R - Required | Choose | ||
| 33 | Reporting | Ability to report grant funded FA by grant | D - Desired | Choose | ||
| 34 | Security Architecture | Ability to limit who is authorized to establish or update FA record | R - Required | Choose | ||
| 35 | System Architecture | Ability to transfer FA history to a new FA ID | R - Required | Choose | ||
| 36 | System Architecture | Ability to support FA bar coding | R - Required | Choose |
FP&A and Reporting
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Budget Development | Ability to access detailed information system wide such as invoices and contracts in reports | R - Required | Choose | ||
| 2 | Budget Development | Ability to accommodate multiple rounds of budget submissions and provide a streamlined review process | R - Required | Choose | ||
| 3 | Budget Development | Ability to export budget information to spreadsheet for additional analysis | S - Show Stopper | Choose | ||
| 4 | Budget Development | Ability to generate a budget by department/grant/program/etc. | S - Show Stopper | Choose | ||
| 5 | Budget Development | Ability to implement a system to track capital budgets and projects, ensuring accurate monitoring of expenditures | R - Required | Choose | ||
| 6 | Budget Development | Ability to import budget information from spreadsheet or other sources | S - Show Stopper | Choose | ||
| 7 | Budget Development | Ability to provide departments with a template for budget entry that includes prior year data and restricts changes to certain fields | S - Show Stopper | Choose | ||
| 8 | Budget Development | Ability to route budget/budget segment to department for approval prior to finalization | R - Required | Choose | ||
| 9 | Budget Maintenance | Ability to add notes to individual line items in budget | R - Required | Choose | ||
| 10 | Budget Maintenance | Ability to integrate HRIS for workforce planning and analysis | S - Show Stopper | Choose | ||
| 11 | Budget Maintenance | Ability to maintain multiple versions of budgets | S - Show Stopper | Choose | ||
| 12 | Budget Maintenance | Ability to modify the budget throughout the year and view modified vs initial budget | S - Show Stopper | Choose | ||
| 13 | Budget Maintenance | Ability to send automated reminders for submission due dates | R - Required | Choose | ||
| 14 | Budget Maintenance | Allows for department-level ability for scenario planning prior to submission | R - Required | Choose | ||
| 15 | Budgeting | Ability to establish a budget based on user defined variables (i.e., percent of actual; percent of previous year budget, etc.) | R - Required | Choose | ||
| 16 | Budgeting | Ability to generate templates based on program / fund / grant / capital plan | S - Show Stopper | Choose | ||
| 17 | Budgeting | Ability to support capital expenditure budgeting | R - Required | Choose | ||
| 18 | Budgeting | Ability to support multiple budget versions, allowing authorized users to create, compare, and analyze different iterations of the budget | R - Required | Choose | ||
| 19 | Budgeting | Capability to budget statistical data (i.e., FTE, tonnage, FA counts, etc.) | R - Required | Choose | ||
| 20 | Budgeting | Capability to define and monitor KPIs related to financial performance, program effectiveness, and other relevant metrics | S - Show Stopper | Choose | ||
| 21 | Financial Statements | Ability to generate combined financial statements | S - Show Stopper | Choose | ||
| 22 | Financial Statements | Ability to generate financial statement identifying the variance amount of mtd and ytd amount comparing current year to previous year | S - Show Stopper | Choose | ||
| 23 | Financial Statements | Ability to generate financial statements based on various levels of detail with the option to include roll up items | S - Show Stopper | Choose | ||
| 24 | Financial Statements | Ability to generate financial statements for a user-defined periods | S - Show Stopper | Choose | ||
| 25 | Financial Statements | Ability to generate financial statements for current period or prior year end even if prior period is not closed | S - Show Stopper | Choose | ||
| 26 | Financial Statements | Ability to generate financial statements identifying the variance amount of mtd and ytd balances to budget | S - Show Stopper | Choose | ||
| 27 | Financial Statements | Ability to generate financial statements with mtd and ytd balances compared to previous periods | R - Required | Choose | ||
| 28 | Financial Statements | Ability to generate financial statements with mtd and ytd percent of total revenue for any income account | S - Show Stopper | Choose | ||
| 29 | Financial Statements | Ability to report percent of total income or total expense for each account | R - Required | Choose | ||
| 30 | Forecasting | Ability to allocate forecasted revenues to a project lifecycle (i.e., apply revenue recognition to forecasted revenues) | R - Required | Choose | ||
| 31 | Forecasting | Ability to compare current year (CY) budget to CY forecast to budget year budget by budget group | R - Required | Choose | ||
| 32 | Forecasting | Ability to create a forecasting model that includes a five-year financial plan with detailed projections | R - Required | Choose | ||
| 33 | Forecasting | Ability to update budget using actual results and latest forecast | D - Desired | Choose | ||
| 34 | Forecasting | Capability to have multiple versions/scenarios of budgets simultaneously | R - Required | Choose | ||
| 35 | Grant/Program Budgeting | Ability to assign a budgeted cost to a grant/program task | S - Show Stopper | Choose | ||
| 36 | Grant/Program Budgeting | Ability to manage a detail budget for grants with a roll up amount for financial system | R - Required | Choose | ||
| 37 | Grant/Program Budgeting | Ability to manage grant budgets, track spending against grants, and generate grant-specific financial reporting | R - Required | Choose | ||
| 38 | Grant/Program Budgeting | Ability to manage more than one budget year at a time (2 or 3 year budget) | S - Show Stopper | Choose | Washington County does a 2-year budget which forces Public Health to think this way | |
| 39 | Grant/Program Budgeting | Ability to monitor and manage cash flow, ensuring the availability of funds to meet financial obligations | R - Required | Choose | ||
| 40 | Grant/Program Budgeting | Ability to track and monitor compliance with grant requirements, including spending restrictions and reporting obligations | R - Required | Choose | ||
| 41 | Grant/Program Budgeting | Capability to assign and track costs associated with specific programs, projects or funds | S - Show Stopper | Choose | ||
| 42 | Grant/Program Budgeting | Capability to budget grant payments in cash flow budget based on grant terms. Both for grants received and grants paid | R - Required | Choose | ||
| 43 | Grant/Program Budgeting | Capability to track and manage funds (i.e., restricted, unrestricted, grant, projects, etc.) | R - Required | Choose | ||
| 44 | Integration | Ability to pull data from multiple sources and provide a unified view of financial information | S - Show Stopper | Choose | ||
| 45 | Reporting | Ability to create custom reports based on multiple user defined fields | S - Show Stopper | Choose | ||
| 46 | Reporting | Ability to create reports based on multiple variables (department, grant, location, program, staff) | S - Show Stopper | Choose | ||
| 47 | Reporting | Ability to develop a comprehensive dashboard that includes budget, actuals, and key metrics for better visualization and reporting | S - Show Stopper | Choose | ||
| 48 | Reporting | Ability to enable drill down from budget line items to underlying assumptions and details | S - Show Stopper | Choose | ||
| 49 | Reporting | Ability to establish dashboard views specific to each user ID that include data from multiple functional areas | S - Show Stopper | Choose | ||
| 50 | Reporting | Ability to generate a comparative financial statements at consolidated level including: Month-to-Date actual (current year vs previous year); Year-to-Date actual (current year vs previous year); Month-to-Date actual vs budget amounts; Year-to-Date actual vs budget amounts | S - Show Stopper | Choose | ||
| 51 | Reporting | Ability to generate ad hoc reports based on user determined data range | S - Show Stopper | Choose | ||
| 52 | Reporting | Ability to generate customized reports based on specific needs and criteria | S - Show Stopper | Choose | ||
| 53 | Reporting | Ability to generate financial reports and dashboards specifically tailored for county board meetings and presentations | R - Required | Choose | ||
| 54 | Reporting | Ability to generate financial statements based on various levels of detail | S - Show Stopper | Choose | ||
| 55 | Reporting | Ability to generate financial statements to meet the reporting requirements of individual grants/programs | S - Show Stopper | Choose | ||
| 56 | Reporting | Ability to generate reports by grant/program/department that are selected by the user(s) | S - Show Stopper | Choose | ||
| 57 | Reporting | Ability to have an advanced reporting tool that allows combining data from any source within the ERP (with user defined user permissions) | S - Show Stopper | Choose | ||
| 58 | Reporting | Ability to integrate dashboards with other systems for real-time data visualization and accurate reporting | S - Show Stopper | Choose | ||
| 59 | Reporting | Ability to run reports using both approved and pending-approval postings | D - Desired | Choose | ||
| 60 | Reporting | Ability to set up automated reporting that updates text and numbers dynamically to reduce manual updates | S - Show Stopper | Choose | ||
| 61 | Reporting | Ability to sort a report by various dimensions | S - Show Stopper | Choose | ||
| 62 | Reporting | Ability to track project progress and ensure accurate budgeting for capital projects | R - Required | Choose | ||
| 63 | Reporting | Allow downloading of financial statement information to spreadsheets for further analysis | S - Show Stopper | Choose | ||
| 64 | Reporting | Capability to create ad hoc comparative analysis reports using financial data | R - Required | Choose | ||
| 65 | Reporting | Capability to generate reports that use non-financial data for comparative analysis purposes | R - Required | Choose | ||
| 66 | Reporting | Generate a statement of financial position for a user-defined time periods and dimentions | R - Required | Choose | ||
| 67 | Security | Ability to ensure data security within the financial system | S - Show Stopper | Choose | ||
| 68 | Workflow | Ability to allocate shared costs, such as administrative expenses, programs based on predefined allocation methodologies | S - Show Stopper | Choose | ||
| 69 | Workflow | Ability to assign tasks, set deadlines, and track the progress of budget-related activities | R - Required | Choose | ||
| 70 | Workflow | Ability to automate distribution of budget templates to users | R - Required | Choose | ||
| 71 | Workflow | Ability to export data for further analysis and visualization | S - Show Stopper | Choose | ||
| 72 | Workflow | Ability to formalize the monthly close process with defined workflows, responsibilities, and deadlines | S - Show Stopper | Choose | ||
| 73 | Workflow | Ability to integrate AI in the financial system for automating reporting and improving data accuracy | R - Required | Choose | ||
| 74 | Workflow | Ability to manage budget approval through workflow | R - Required | Choose | ||
| 75 | Workflow | Ability to set up alerts when an account exceeds budget or certain threshold, based on business rules | R - Required | Choose | ||
| 76 | Workflow | Capability to allocate expenses to specific programs, projects, funds, etc. | S - Show Stopper | Choose |
Treasury & Cash Mgmt
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Integration | Capability to interface with bank to aid in cash reconciliation | S - Show Stopper | Choose | ||
| 2 | Integration | Ability to auto-generate bank feeds matching deposits and payments | S - Show Stopper | Choose | ||
| 3 | Integration | Ability to have multiple bank accounts that will tie to specific programs/funds | R - Required | Choose | ||
| 4 | Integration | Ability to automate investment tracking process, including journal entries and tracking returns and yields | R - Required | Choose | ||
| 5 | Integration | Ability to integrate Ascent software to automate tax collection information | R - Required | Choose | ||
| 6 | Integration | Ability to integrate cash management reporting needs, including tax collection from RSN software | R - Required | Choose | ||
| 7 | Integration | Ability to integrate manual reconciliation process into the new system | R - Required | Choose | ||
| 8 | Reporting | Capability to generate a report of uncleared items | R - Required | Choose | ||
| 9 | Workflow | Ability to automate due to/due from transactions (between fund types) | S - Show Stopper | Choose | ||
| 10 | Workflow | Automatically update outstanding checks with clearing information provided by bank | S - Show Stopper | Choose | ||
| 11 | Workflow | Capability to automate reconciliation of bank accounts | S - Show Stopper | Choose | ||
| 12 | Workflow | Ability to match incoming deposits to AR items | R - Required | Choose | ||
| 13 | Workflow | Capability to automatically reverse entries for checks that were printed in error | R - Required | Choose | ||
| 14 | Workflow | Capability to edit check batch during the check run | R - Required | Choose | ||
| 15 | Workflow | Capability to support multiple payment methods including check, ACH, credit card, wire payments | R - Required | Choose | ||
| 16 | Workflow | Ability to streamline ACH and check processes, including use of blank check stock | R - Required | Choose | ||
| 17 | Workflow | Ability to track payments and automate processes | R - Required | Choose | ||
| 18 | Workflow | Capability to easily reconcile revenue recognition between multiple systems | R - Required | Choose | ||
| 19 | Workflow | Capability to have automatic notification of incoming wires, EFT and ACH | R - Required | Choose | ||
| 20 | Workflow | Capability to support the processing of AP checks from multiple checking accounts | D - Desired | Choose |
Grant & Program Mgmt
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Grants | Ability to assign grant/profile IDs to accounts | S - Show Stopper | Choose | ||
| 2 | Grants | Ability to track matching funds for grants, ensuring all contributions are documented and reported accurately | S - Show Stopper | Choose | ||
| 3 | Grants | Ability to associate invoicing/billing schedule with a grant/project | R - Required | Choose | ||
| 4 | Grants | Ability to automate revenue recognition for grants / programs / projects | R - Required | Choose | ||
| 5 | Grants | Ability to generate a progress report for grant cycles | R - Required | Choose | ||
| 6 | Grants | Ability to setup grant renewals and cycle dates | R - Required | Choose | ||
| 7 | Grants | Ability to track and manage grant proposal timeline, submissions and response | R - Required | Choose | ||
| 8 | Grants | Ability to track funding expiration dates (in order to reallocate funds) | R - Required | Choose | ||
| 9 | Grants | Ability to track open and available grants | R - Required | Choose | ||
| 10 | Grants | Ability to track compliance with grant requirements, adhering to reporting deadlines and conditions set by the grantor | R - Required | Choose | ||
| 11 | Grants | Ability to track grant applications, submissions, and responses to manage the grant lifecycle efficiently | R - Required | Choose | ||
| 12 | Grants | Ability to track grant applications, submissions, and responses, capturing all relevant data for reporting | R - Required | Choose | ||
| 13 | Grants | Ability to track payments (future due requirements and actual) by grant | R - Required | Choose | ||
| 14 | Grants | Ability to search online for grant opportunities and capture all relevant data during the application phase | R - Required | Choose | ||
| 15 | Integration | Capability to integrate with AP, Payroll, etc. for reporting purposes | S - Show Stopper | Choose | ||
| 16 | Program Management | Ability to associate time tracking with grant / project | S - Show Stopper | Choose | ||
| 17 | Program Management | Ability to assign users to a grant/project | R - Required | Choose | ||
| 18 | Program Management | Ability to identify funding source for a specific project | R - Required | Choose | ||
| 19 | Program Management | Ability to manage and report on project activity | R - Required | Choose | ||
| 20 | Program Management | Ability to support multiple billing and payment methods for grants / programs | R - Required | Choose | ||
| 21 | Program Management | Document management capabilities by grant / project / program | R - Required | Choose | ||
| 22 | Program Management | Ability to automate grant close outs | R - Required | Choose | ||
| 23 | Program Management | Capability to track grant submission timing | R - Required | Choose | ||
| 24 | Reporting | Ability to automate indirect costs entries | S - Show Stopper | Choose | ||
| 25 | Reporting | Ability to generate periodic financial reports for each grant/program/department | S - Show Stopper | Choose | ||
| 26 | Reporting | Ability to manage and report on projects for current fiscal year or over multiple fiscal years (multi-year budgets) | S - Show Stopper | Choose | ||
| 27 | Reporting | Ability to project cash flow by grant (tie a grant to AP) | S - Show Stopper | Choose | ||
| 28 | Reporting | Ability to automate grant reporting and compliance processes | S - Show Stopper | Choose | ||
| 29 | Reporting | Ability to capture all relevant data for reporting purposes, including tracking expenses, matching funding, and ensuring compliance | S - Show Stopper | Choose | ||
| 30 | Reporting | Ability to apply overhead percentages across grants/programs/departments | R - Required | Choose | ||
| 31 | Reporting | Ability to automate and export reporting files | R - Required | Choose | ||
| 32 | Reporting | Ability to drill down into report values | R - Required | Choose | ||
| 33 | Reporting | Ability to have user defined dashboards showing grant balances, actual expenses versus budget, etc. | R - Required | Choose | ||
| 34 | Reporting | Ability to manage both direct and indirect program costs and allocations | R - Required | Choose | ||
| 35 | Reporting | Ability to provide an annual reconciliation of grant reporting to the GL, for defined accounts for SEFA/SESA reporting | R - Required | Choose | ||
| 36 | Reporting | Ability to run reports with source of designated funds | R - Required | Choose | ||
| 37 | Reporting | Ability to see budget vs actual reporting at the grant/program level | R - Required | Choose | ||
| 38 | Reporting | Ability to create a workflow for grant/program management (Grant reporting requirements, budget adjustments, etc.) | R - Required | Choose |
HRIS & Payroll
| Process | Functional Requirements | Client Mandate | Vendor Response | System Module | Notes | |
| 1 | Benefits Management | Ability to establish and maintain employee benefit records and documentation | S - Show Stopper | Choose | ||
| 2 | Benefits Management | Ability to establish, maintain and track benefit accrual calculations by employees (i.e., PTO, sick leave, etc.) | S - Show Stopper | Choose | ||
| 3 | Benefits Management | Ability to track and maintain health care, dental, and flex spending information (i.e., date of eligibility, deduction, reimbursements, etc.) | S - Show Stopper | Choose | ||
| 4 | Benefits Management | Ability to post date benefit effective date (i.e. enter benefit information upon hiring with benefit date of 30 - 60 days later) for benefit eligibility and benefit deductions | S - Show Stopper | Choose | ||
| 5 | Benefits Management | Ability to roll forward year end benefit elections and accruals including benefit caps | R - Required | Choose | ||
| 6 | Benefits Management | Ability to automate the management of annual open enrollment for new benefits selections and renewals | R - Required | Choose | ||
| 7 | Benefits Management | Capability to automate leave requests and approvals | R - Required | Choose | ||
| 8 | Benefits Management | Capability to display appropriate leave balances and leave activity in employee portal | R - Required | Choose | ||
| 9 | Benefits Management | Ability for the system to check FMLA eligibility based on hours worked | R - Required | Choose | ||
| 10 | Benefits Management | Ability to automate FMLA tracking, including eligibility checks, request submissions, and attendance tracking | R - Required | Choose | ||
| 11 | Employee Profile | Ability to establish and maintain position information (i.e., position, date of hire, date of termination, date of rehire, etc.) | S - Show Stopper | Choose |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .