ATTACHMENT B - Req _ Preferred Features Worksheet.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Financial Software Systems
- Solicitation number
- 2610-001
- Issued by
- Travis County, Texas
About this file
This document is an Attachment B Requirements and Preferred Features Worksheet for a Financial Software Systems Request for Information (RFI) issued by Central Health in Texas. The RFI seeks comprehensive financial software capabilities across multiple operational domains including general system features, accounting, purchasing, accounts payable, accounts receivable, fixed assets, payroll, budgeting, and advanced technological integrations. Central Health aims to collect detailed information about potential financial software solutions to educate its Finance and Procurement departments, with the ultimate goal of developing a formal Request for Proposals process. Selected vendors may be invited to participate in quarterly demonstrations, and the RFI covers an extensive range of required and preferred system functionalities.
The worksheet details specific technical, security, and operational requirements for the financial software, emphasizing features like cloud-based storage, workflow management, role-based permissions, GASB and FASB compliance, integration capabilities, and advanced reporting functions. Key technical requirements include VPN access, disaster recovery, data center security standards, electronic signatures, API development capabilities, and compatibility with existing systems like UKG Payroll and Office 365. The document suggests Central Health is seeking a comprehensive, flexible financial management system that can support complex governmental accounting needs, offer robust security, enable detailed reporting, and provide seamless integration with existing technological infrastructure.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 2610-001 (RFI) Financial Software Systems.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| 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 .