| Department/Area: GL/Accounts Receivable/Budget | ||||||||
| SYSTEM MUST HAVES | ||||||||
| MET? | (Place a 0, 1, or 2 in the box next to each item to indicate how the vendor meets the requirement.) | |||||||
| 0 = No | ||||||||
| 1 = Yes - with difficulty | ||||||||
| 2 = Yes | ||||||||
| Note: All items in list for each category determined to be required and not rankable | ||||||||
| General Ledger | ||||||||
| Flexible GL account structure (including alphanumeric) to tract by various elements (desire >=5) and to drill down | ||||||||
| Notes: | ||||||||
| Ability to control posting to a GL account by module | ||||||||
| Notes: | ||||||||
| For reporting, way to link together related account numbers | ||||||||
| Notes: | ||||||||
| Ability to terminate and reopen inactive GL accounts | ||||||||
| Notes: | ||||||||
| Friendly method to manage and report FASB116/117/124 etc. | ||||||||
| Notes: | ||||||||
| Ability to efficiently process recurring journal entries and reversals--accts remain same but amounts and descriptions may change | ||||||||
| Notes: | ||||||||
| Ability to perform data query & drill down in a transparent manner into multiple data sources | ||||||||
| Notes: | ||||||||
| On-line interface for processing (entries, approvals), Macintosh support | ||||||||
| Notes: | ||||||||
| Accept and send data to all other modules (internally and third party) (gl, registration, other) seamlessly in real time--an integrated system | ||||||||
| Notes: | ||||||||
| More flexibility and ease of use in any GL field selection/defining for reporting/querying | ||||||||
| Notes: | ||||||||
| Interface to support posting of interdepartmental charging for functions such as printing, telecom, post office, book store, catering, food service, lodging in an automated way. | ||||||||
| Notes: | ||||||||
| Fiscal agent for writing checks as separate tax entities | ||||||||
| Notes: | ||||||||
| Ability to perform accounting functions for multiple fiscal entities | ||||||||
| Notes: | ||||||||
| Ability to track (from purchase to disposal) fixed assets and depreciation | ||||||||
| Notes: | ||||||||
| Account reconciliation, interface with banks in real time and batch | ||||||||
| Notes: | ||||||||
| Friendly interface for non-accounting users for variance analysis etc (Macintosh support) | ||||||||
| Notes: | ||||||||
| Custom report writer that enables extraction of desired fields | ||||||||
| Notes: | ||||||||
| Be able to export/import and merge data to/with other applications | ||||||||
| Notes: | ||||||||
| Provide support for all govt mandated requirements/reporting (990(T), 1099, 1042, 941, 1098(T,E)) | ||||||||
| Notes: | ||||||||
| GL field level validation across all modules and fiscal periods at point of data entry | ||||||||
| Notes: | ||||||||
| Prepost reporting for error identification and summary of the entry | ||||||||
| Notes: | ||||||||
| Ability to process multiple time periods simultaneously | ||||||||
| Notes: | ||||||||
| To have solid audit trail for all accounting transactions | ||||||||
| Notes: | ||||||||
| Ability to post totals or balances from subsidiary to the general ledger resulting in details being stored in the sublevel | ||||||||
| Notes: | ||||||||
| Quickly review history for at least 7 years | ||||||||
| Notes: | ||||||||
| Flexible and easy GL closing and balance forwarding, multiple times | ||||||||
| Notes: | ||||||||
| Ability to have site assigned numbers as opposed to auto-assigned | ||||||||
| Notes: | ||||||||
| Report by non-fiscal year periods | ||||||||
| Notes: | ||||||||
| Ability to compare budget to actual in data entry process, by line item and groups of line items | ||||||||
| Notes: | ||||||||
| Allocation | ||||||||
| Ability to automatically allocate expenses (e.g., overhead) prior to printing the financial statements. | ||||||||
| Notes: | ||||||||
| Ability to use a formula or percentage to compute the required allocation of expenses to various cost centers. | ||||||||
| Notes: | ||||||||
| Ability to define allocations for major groups of data | ||||||||
| Notes: | ||||||||
| Ability to have the system maintain department totals and allocate from them. | ||||||||
| Notes: | ||||||||
| Ability to have allocations performed by the system as the transactions are entered. | ||||||||
| Notes: | ||||||||
| Accounts Receivable | ||||||||
| Invoicing (ability to adjust), subsidiary ledger, including recurring invoices | ||||||||
| Notes: | ||||||||
| Ability for aging reporting with reminder tickler system, ability to generate collection letters and labels | ||||||||
| Notes: | ||||||||
| Production of sales orders that in some cases drive invoicing | ||||||||
| Notes: | ||||||||
| Web-based invoicing and payment of invoices (sending links via email for external viewing) and integration of web-based retail sales | ||||||||
| Notes: | ||||||||
| Ability to charge late fees or interest by customer type | ||||||||
| Notes: | ||||||||
| Maintain separate accounting entities within AR | ||||||||
| Notes: | ||||||||
| Multilevel user access (permissions) | ||||||||
| Notes: | ||||||||
| Forms/invoices that fully customizable including logos, font sizes, etc | ||||||||
| Notes: | ||||||||
| Import/export capability from external applications such as bank lock box | ||||||||
| Notes: | ||||||||
| Comment field both on the screen and in reports | ||||||||
| Notes: | ||||||||
| Multilevel (by customer ) set up with subprojects or jobs and the ability to deliniate customer types | ||||||||
| Notes: | ||||||||
| Print forms or reports by single or multiple customers, with various output options (e.g., fax and email) | ||||||||
| Notes: | ||||||||
| Budgeting | ||||||||
| Ability to accommodate a zero-based and activity-based budget approach | ||||||||
| Notes: | ||||||||
| Budget for non-fiscal period and for multi-years | ||||||||
| Notes: | ||||||||
| On-line reporting that is available to budget manager for inputing and comparison to historical budget | ||||||||
| Notes: | ||||||||
| Able to do modeling at account code level, place to store explanatory notes | ||||||||
| Notes: | ||||||||
| Ability to differentiate budget types/categories (e.g., capital | ||||||||
| Notes: | ||||||||
| Ability to spread annual budget amounts to months, quarters | ||||||||
| Notes: | ||||||||
| Budget wages, salaries, and benefits according to current run rate and open position | ||||||||
| Notes: | ||||||||
| Reporting rollups by departments and responsible persons | ||||||||
| Notes: | ||||||||
| On-line buget approval process, budget adjustments with audit trail | ||||||||
| Notes: | ||||||||
| Ability to budget and report according to key indicators (FTE, FTE/depart, number of SS, revenue by major,etc) | ||||||||
| Notes: | ||||||||
| Budget at balance sheet level | ||||||||
| Notes: | ||||||||
| Reporting | ||||||||
| On cost and market value | ||||||||
| Notes: | ||||||||
| Ad hoc query/reporting capability | ||||||||
| Notes: | ||||||||
| Web-based reporting capability to enable remote report generation | ||||||||
| Notes: | ||||||||
| Other | ||||||||
| Vendor support, online documentation, technical bulletins, training | ||||||||
| Notes: | ||||||||
| Appropriate security such as permissions strength and flexibility. Must be manageable by appropriate persons, preferably by departmental staff | ||||||||
| Notes: | ||||||||
| Tie in of permissions records with ldap database | ||||||||
| Notes: | ||||||||
| Easy to maintain administratively | ||||||||
| Notes: | ||||||||
| Site selectable data migration | ||||||||
| Notes: | ||||||||
| Work order processing capability | ||||||||
| Notes: | ||||||||
| Additional Functionality--minimally tell us 'yes' or 'no' | ||||||||
| Fixed Assests/Depreciation | ||||||||
| Notes: | ||||||||
| Account reconcilation | ||||||||
| Notes: | ||||||||
| Pledge receivable module, including ability to satisfy FASB requirements | ||||||||
| Notes: | ||||||||
| Grant accounting | ||||||||
| Notes: | ||||||||
| Invoicing | ||||||||
| Notes: | ||||||||
| E-commerce | ||||||||
| Notes: | ||||||||
| Work Order Processing | ||||||||
| Notes: | ||||||||
| Unitized endowment tracking and support | ||||||||
| Notes: | ||||||||
| DEMO TOP RANKED IN PART BY SHOWING THE FOLLOWING | ||||||||
| No specific requests | ||||||||