ESBD_458420_1759263835081_ATTACHMENT B - Req & Preferred Features Worksheet.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Financial Software Systems State and local contract opportunity
- Solicitation number
- 2610-001
- Issued by
- Texas
About this file
This document is a Requirements and Preferred Features Worksheet for a comprehensive financial management system procurement. The spreadsheet details an extensive list of required (R) and preferred (P) system capabilities across multiple functional areas including general system features, accounts payable, general ledger, purchasing, receiving, accounts receivable, fixed assets, payroll, budgeting, and potential AI integration. The document appears to outline technical specifications for a government financial software solution with robust requirements for governmental accounting standards, cloud-based storage, workflow management, security protocols, reporting capabilities, and system integrations.
The worksheet emphasizes critical financial management needs such as GASB and FASB compliance, multi-user access, role-based permissions, data security standards, disaster recovery capabilities, and integration with existing systems like UKG Payroll, Office 365, and banking vendors. Key technical requirements include electronic document storage, workflow management, customizable data fields, comprehensive reporting tools, vendor management features, purchase order processing, invoice management, budget tracking, and financial reporting. The procurement seems focused on replacing an existing financial management system with a more advanced, integrated solution that supports complex governmental financial operations while providing enhanced security, reporting, and operational efficiency.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| ESBD_458420_1759263769033_2610-001 (RFI) Financial Software Systems.pdf |
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
Sheet1
| General System Features | R (Required) or P (Preferred) | Notes |
| Prior Period Data | R | |
| Chart of account structure | R | |
| System must comply with Governmental Accounting, Auditing and Financial Reporting guidelines. | R | |
| Electronic File Storage for documentation/support Cloud based | R | |
| Unlimited Document Storage | R | |
| Workflow Management | R | |
| Customized data fields | R | |
| Email Alerts requisitions, approvers, and POs | R | |
| Archive and retention schedule | P | |
| Prohibit multiple users from updating the same record simultaneously | R | |
| Allow simultaneous access of the same data by many users without compromising data integrity | R | |
| Integration with secure banking vendor | R | |
| Accounts Payable- electronic approval | R | |
| General Ledger - electronic storage and approval | R | |
| Business segments that support complex reporting | R | |
| Intercompany transaction mapping | P | |
| Statistic GL codes | R | |
| Ability to reconcile bank transactions | R |
| Automatic assignment of Journal Entry numbers | R |
| Auto reverse entries | R |
| Excel Journal upload template | R |
| Scheduled journal entries | R |
| Create template entries | R |
| Track Investments P&I payments | P |
| Track Certificate of Obligations | P |
| Security | |
| Requires a minimium of 12 character for password | R |
| Secure documents by controlling access | R |
| Role based permissions | R |
| User privileges individuals or groups | R |
| Data center security standards | R |
| Data Center HIPAA Compliance | R |
| VPN Access | R |
| Audit Trail | R |
| Disaster Recovery | R |
| Compatible with anti-virus software | R |
| SOC (annual report) | R |
| Technical | |
| Allow Workstation Requirements | P |
| Routine Maintenance/ Updates process | R |
| Upload documents (Journal entries and support) | R |
| Remote Support | R |
| Data import/export (into excel and PDF for text files) | R |
| Create Checklists | P |
| Single-Sign On/Integration with Office 365 | R |
| Migration Process | R |
| Integration with CLM/Agiloft | P |
| Ability to develop API | R |
| Electronic Signatures | R |
| Ongoing Support after Go live | R |
| training offered through vendor | P |
| memorize transactions | R |
| recurring journal entries (easier than MIP) | R |
| 1099 Processing Services | R |
| Reporting | |
| GASB and FASB Compliant Reporting | R |
| Create standardized and custom reports/forms (column, sorting, totaling) | R |
| Save Reports | R |
| Automate Reports | P |
| Reports that allow user to preview effect of unposted transactions on financial reports before posting | P |
| Comparative reporting by designated period (month, quarter, year) | R |
| Cross fiscal year reports to match funding source reporting cycles | P |
| Reporting templates in excel that can be refreshed after updates to criteria (ex. periods, departments, accounts) | R |
| project tracking | P |
| Computational Fields (more than MIP!!!) | R |
| Drill down commonly (ex. drillpoint) | P |
| Missed check in sequence | P |
| New vendors for the month | P |
| Report to inform when GL/business segement are established | P |
| Grant tracking/module | P |
| Process automation to reconcile accounts. Real-time syncing. | P |
| Conduct data analysis, assist with audits, summarizes financial data based on prompts. | P |
| Purchasing | |
| Create an item file | R |
| EDI Capabilities | P |
| Ability to edit prior to approval (ex. 2.99 emission charge) | R |
| Ability to process Change Order PO after approval | R |
| Change Logs on Purchase Requisitions and Purchase Orders | R |
| Create role-specific workflows with approvals/Abilty to change workflows for unique situations | R |
| Charge code integration to item master | R |
| Inventory Management | P |
| Manage Backorders | P |
| Plug-in to manage electronic auctions | P |
| Vendor Management | R |
| View electronic purchase orders | R |
| Drill down on transactions | P |
| New vendor request | R |
| Record and report on specific vendor classifications (i.e.HUB/SUB HUB certified) | R |
| Change Order capabilities | R |
| Professional Purchase Order document | R |
| Reports | R |
| Functionality like Microix- requisitions and status | P |
| Receiving | |
| Track receipts by packing slip | R |
| Scan packing slips and attach to PO | P |
| Interaction with purchasing software to insure complete recieving without Central recieving capabilities | R |
| Accounts Payable | |
| Electronic 3-way document match (PO, receipt, Invoice) | R |
| Auto process vendor payables record once 3 way match is satisfied | P |
| Pre-populated GL codes (business segments) | P |
| Pre-populated distributions code | P |
| Transmit voucher invoices into accounting system for payment | R |
| Receive electronic invoice through software | P |
| Access invoices electronically in the system | R |
| Able to assign NAICS code at transaction level | P |
| Able to track HUB vendors (HUB type and class) | R |
| Similar reporting tracking as B2Gnow | P |
| OCR scan invoices | P |
| Scheduled transactions | R |
| Expense report module (upload receipts to software, route to supervisor) | P |
| T&E mobile app | P |
| AP aging report | R |
| UDF that tracks contract labor/hours | P |
| Accounts Receivable | |
| Interface with EPIC | R |
| Able to 3rd party billing (operating costs) | R |
| update to meet CMS requirements | R |
| medical claims billing | R |
| Grant tracking | P |
| Electronic invoice | R |
| AR forward report | P |
| AR aging report | R |
| zero balance account report | R |
| hindsight analysis | R |
| Fixed Assets | |
| depreciation computation and posting interface to GL | R |
| project tracking software (capital projects, budget to actual) | P |
| Asset destruction/loss or decomissioning and reporting | R |
| Fixed Asset Roll forward report | P |
| master fixed asset list report | R |
| barcode scanning | P |
| Tracking warranty tied to inventory | R |
| Tracking Equipment leases | R |
| Payroll/Benefits | |
| FTE/PCN tracking to GL | R |
| Interface with UKG / Payroll 360 | R |
| Budget | |
| Budget Management | R |
| Budget vs. Actual analysis (trends, over under) | R |
| Allow various users to access their budget information online | R |
| Allow users to input budget directly into the system | R |
| Easy interface for loading budget | R |
| Forecasting capabilities | R |
| Budget versions (for mid-year adjustments) | R |
| Incorporate FTE data into forecasting and budgeting | R |
| Encumbrances | R |
| On demand report (year to date expenses, encumbrances, pre-encumbrances, available balance by budget catergory) | R |
| Budget User Training | P |
| AI Capabilities | |
| Describe areas of existing AI integration | P |
| Opportunities for AI workflows and agentic AI | P |
File details come from the government source that posted it. Updated .