1099 Independent Non Profit Contractor Agreement by vad49754

VIEWS: 60 PAGES: 33

More Info
									                       State of Connecticut
                   Financials Requirements Checklist

General Accounting                                                  Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

        Chart of Accounts
COA1    Ability to provide a single unitary key that
        standardizes the chart of accounts (COA)
        segments and record keeping across all
        business functions
COA2    Ability to provide common validation rules across
        all modules
        Ability to have several versions of a COA coding
COA3    string
COA4    Ability to designate COA code strings through
        discrete COA segments rather than a single field
        containing concatenated values
COA5    Ability to provide flexible number and field size of
        COA segments
COA6    Ability to maintain information about all
        segments of the COA structure including specific
        definitions and other characteristics
COA7    Ability to accommodate at least 100,000 COA
        values in each segment of the COA
COA8    Ability to add, change, or delete COA values in
        an active or inactive status
COA9    Ability to group chart of accounts (COA) values
        through user-defined categories
COA10   Ability to assign and define account types
        Budgeting (Appropriations / Allotment Distributions)
BU1     Ability to set up and adjust multiple budgets
        (spending plans)
BU2     Ability to set up and adjust multiple types of
        budgets (spending plans)
BU3     Ability to set up and adjust multiple levels of
        budgets (spending plans) in hierarchical
        relationship
BU4     Ability to accommodate multi-year budgets
BU5     Ability to enter non-budgeted appropriations
BU6     Ability to set for each appropriation, its specific
        length of availability and lapsing characteristics -
        (i.e. one year, two year, six year)

BU7     Ability to reserve funds without creating a pre-
        encumbrance


                                                                                       Appendix C - 1 of 33
                        State of Connecticut
                   Financials Requirements Checklist

General Accounting                                                Proposer's Response
   ID    Requirement Definition                              Delivered Configured Modified

BU8      Ability to post adjustments to any budget at any
         time in the budget lifecycle
BU9      Ability to set up and adjust budgets by fixed
         amounts or user-specified percentages for
         designated periods
BU10     Ability to monitor the following balances: Bond
         authorization, allocated, allotted, unallotted,
         encumbered, unencumbered, liquidated,
         unliquidated, expended, and prior years' activity
         summaries. Bond Accounts can last more than
         20 years.
         Accounting Methods / Journal Processing
AMJP1  Ability to define multiple ledgers
AMJP2  Ability to handle full accrual, modified accrual,
       cash, and modified cash accounting
AMJP3 Ability to post a journal entry
AMJP4 Ability to post journal entries in a set sequence
       to prevent transaction rejections
AMJP5 Ability to record accounting transactions using
       double entry bookkeeping
AMJP6 Ability to transfer amounts across multiple
       agencies or across multiple funds on one
       document/transaction
AMJP7 Ability to automate the reversal of any journal
       entry transfers as defined by user
AMJP8 Ability to automatically post any journal entry
       based on user defined criteria
AMJP9 Ability to adjust prior accounting periods through
       current period journal entries only
AMJP10 Ability to maintain, edit and resubmit rejected
       journal entries online
AMJP11 Ability to identify interest accrued based on
       average daily balance and to apply that amount
       to the account
AMJP12 Ability to comply with GAAP and GASB-34
       requirements
         Cost Allocation / Roll-Up
CAR1     Ability to create and modify COA segment roll-
         ups (hierarchical relationships)




                                                                                     Appendix C - 2 of 33
                       State of Connecticut
                   Financials Requirements Checklist

General Accounting                                                   Proposer's Response
  ID    Requirement Definition                                  Delivered Configured Modified

CAR2    Ability to have multiple allocation methods
        (single step & multi-step)
CAR3    Ability to define multiple targets, sources, basis
        types (i.e. fringe rate, statistical, fair market
        value) for allocations
        Period Closing
PDC1    Ability to perform period end closings
        Ability to close separate ledgers at different
PDC2    times
PDC3    Ability to close by fund group or by fund
PDC4    Ability to post closing adjustments at any point
        during the closing period
PDC5    Ability to keep a period open for a user-specified
        value, but closed for all others
PDC6    Ability to hold more than one period open
PDC7    Ability to reopen a closed period with proper
        authority to make required adjustments/additions
        within a specified time
PDC8    Ability to automatically carry forward lapsing and
        non-lapsing items
PDC9    Ability to allow new year inputs to be entered
        before the old year's preliminary closing
PDC10   Ability to initiate year-end processing at any point
        in time after the end of the fiscal year
PDC11   Ability to initialize user specified fields to a user
        specified value regarding carry forwards
        (specifically commitment documents)
PDC12   Ability to hold a period open during a user-
        defined interval (specifically current and the next
        month) before closing
PDC13   Ability to monitor summary balances by monthly
        periods including adjustment/closing period




                                                                                        Appendix C - 3 of 33
                      State of Connecticut
                 Financials Requirements Checklist

Purchasing                                                        Proposer's Response
  ID   Requirement Definition                                Delivered Configured Modified

       Vendor File Maintenance
VM1    Ability to add or update vendor file records
       without losing pertinent historical information on
       purchase orders, invoices, etc.
VM2    Ability to assign a single vendor multiple
       classification codes or type codes
VM3    Ability to identify "set-aside" vendors (vendors
       who have received small business, woman
       owned or minority owned enterprise certification)
       and distinguish between Federal and State set-
       aside vendors
VM4    Ability to capture set-aside certification period

VM5    Ability to identify non-profit entities
VM6    Ability to capture vendor's fiscal year information

VM7    Ability to maintain multiple names, Federal
       Employer Identification Numbers, addresses,
       contacts, e-mail addresses, fax numbers, etc. for
       a single vendor
VM8    Ability to distinguish a Federal Employer
       Identification Number from Social Security
       Number
VM9    Ability to have automatic links and cross
       references for changed names and/or Federal
       Employer Identification Numbers (i.e. see
       XXXXX, previously XXXXXX)
VM10   Ability to distinguish between vendors that have
       been debarred or disqualified by the State or
       Federal Government and associated periods

VM11   Ability to maintain special payment terms and
       shipping information for each vendor
VM12   Ability for vendors to view contracts, invoices
       and payment information via the Internet
VM13   Ability to capture vendor file information and
       necessary documentation electronically
VM14   Ability to identify preferred payment method for a
       particular vendor (EFT, check, etc)




                                                                                     Appendix C - 4 of 33
                        State of Connecticut
                   Financials Requirements Checklist

Purchasing                                                            Proposer's Response
  ID    Requirement Definition                                   Delivered Configured Modified

VM15    Ability to identify vendors that are EDI capable

VM16    Ability to capture multiple bank accounts for EFT
        processing
VM17    Ability to enter garnishments to vendor payments
        with effective dating, future and past
VM18    Ability to distinguish between liens and levies
        (garnishments) and process accordingly

VM19    Ability to distinguish payments made to a single
        employee as an employee versus a "contractor"
        Requisition Processing
RQP1    Ability to create a requisition for a vendor not yet
        stored on the system
RQP2    Ability to electronically process stock, non-stock,
        multi-delivery, direct ship and blanket
        requisitions
RQP3    Ability to have at least 500 lines of input per
        requisition
RQP4    Ability to have multiple vendors for a single
        requisition or for a single line on the requisition

RQP5    Ability to have a requisition linked to a single
        purchase order or specific line items on a
        purchase order
RQP6    Ability to enter a "receipt of requisition" date prior
        to the requisition/purchase order creation date

RQP7    Ability to define requisition buyer and status
        codes
RQP8    Ability to cross reference purchase orders,
        requisitions and oral competitive bids
RQP9    Ability to order an item from a contract award
        (but pay/receive outside contract award period)

RQP10   Ability to support pre-encumbrance control
RQP11   Ability to provide stock status information during
        the requisition entry process




                                                                                         Appendix C - 5 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Purchasing                                                         Proposer's Response
  ID    Requirement Definition                                Delivered Configured Modified

RQP12   Ability to create a requisition from inventory
        control or project scheduling notification as
        defined by user
        Purchase Order Processing
POP1    Ability to handle blanket purchase orders
POP2    Ability to allow for annual automatic processing
        or renewal of on-going blanket purchase orders

POP3    Ability to generate one purchase order from
        information on one or more requisitions or lines
        on a requisition without re-keying common data

POP4    Ability to process multiple types of purchase
        mediums (i.e. purchase orders for goods and/or
        services, personal service agreements,
        purchase of service contracts, and real property
        leases)
POP5    Ability to process credit/adjustment forms
POP6    Ability to have a change order document
POP7    Ability to have multiple "ship to" locations
POP8    Ability to provide for and override three way
        matching
POP9    Ability to provide for two way matching
POP10   Ability to purchase by description, cross
        referencing stock number and vendor name
POP11   Ability to calculate multiple types of taxes (i.e.
        federal oil usage and disposal, gross receipts,
        and variance taxes)
POP12   Ability to capture freight information by line item

POP13   Ability to have one or more delivery schedules
        per line item
POP14   Ability to convert purchased unit of measure to
        stocked/delivered unit of measure
POP15   Ability to make and track modifications applied to
        ship dates, prices, open quantities and ship-via
        information
POP16   Ability to automatically trigger the fixed asset
        process when relevant purchases are made




                                                                                      Appendix C - 6 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Purchasing                                                         Proposer's Response
  ID    Requirement Definition                                Delivered Configured Modified

POP17   Ability to automatically alert users when a
        purchase order is about to expire
POP18   Ability to capture terms and conditions for each
        type of purchase medium
        Purchase Card Processing
PCP1    Ability to facilitate the use of purchasing cards

PCP2    Ability to electronically receive detail purchasing
        card transactions and link chart of accounts
        coding strings
PCP3    Ability to consolidate all invoices into one
        payment by user defined criteria (i.e. indicator on
        vendor file)
PCP4    Ability to record purchasing card transactions to
        vendor file for set-aside reporting

PCP5    Ability to associate requisitions to detail
        purchase card transactions
PCP6    Ability to liquidate any pre-encumbrance
        amounts associated with purchase card
        requisitions upon payment
        Solicitation Processing
SP1     Ability to create and modify solicitations and
        contract awards
SP2     Ability to create solicitations from requisitions
        without re-keying common data
SP3     Ability to link quotes with requisition numbers
SP4     Ability to have multiple quotes linked to a single
        requisition
SP5     Ability to link multiple purchase requisitions to
        solicitation and/or contract awards
SP6     Ability to electronically solicit and receive
        competitive bids
SP7     Ability to alert a user when selecting a vendor
        with a complaint against it
SP8     Ability to automatically generate a solicitation or
        notice of expiration when contract award is about
        to expire
SP9     Ability to provide a facility for standard and
        prototype bids with multiple vendors



                                                                                      Appendix C - 7 of 33
                      State of Connecticut
                  Financials Requirements Checklist

Purchasing                                                        Proposer's Response
  ID   Requirement Definition                                Delivered Configured Modified

SP10   Ability to change solicitation during process and
       re-post to original recipients
SP11   Ability to enter and tabulate bids received on-line

SP12   Ability to define a library, include imaging
       documents, standard terms and conditions and
       other standard information
SP13   Ability to send solicitations to potential vendors
       by accessing a commodity code based list of
       email addresses self maintained by potential
       vendors through the Internet

SP14   Ability to define, receive, and process pre-
       itemized requisitions for bidding process from a
       consolidation of multiple state agencies

SP15   Ability to handle sole source solicitations
SP16   Ability to establish criteria for vendors during
       contract award and intervals (i.e. insurance,
       bond, certifications, and licensing)
       Item Maintenance
IM1    Ability to classify commodities under multiple
       categories (hazardous materials, firearms,
       medical supplies, etc.)
IM2    Ability to have multiple items linked to specific
       vendors
IM3    Ability to have multiple vendors linked to one
       item
IM4    Ability to set agency specific delivery
       requirements by item
IM5    Ability to inquire on items by type or vendor
IM6    Ability to view required items in a "tabulation"
       form to easily view the best price
IM7    Ability to utilize third party item codes which
       numerically identify commodities and services
       (i.e. the National Institute of Governmental
       Purchasing (NIGP) Commodity/Services Codes.)

IM8    Ability to check stock levels at time of ordering




                                                                                     Appendix C - 8 of 33
                         State of Connecticut
                     Financials Requirements Checklist

Purchasing                                                          Proposer's Response
     ID   Requirement Definition                               Delivered Configured Modified

IM9       Ability to maintain variable pricing for vendor
          goods and provide automated updates of current
          prices
          Receiving
R1        Ability to receive multiple receiving reports
          against any item on a purchase order
R2        Ability to generate payment voucher from a
          receiving document
R3        Ability to accept (on-line or remotely) partial or
          full shipments or substitutions
R4        Ability to automatically notify receiving staff of
          over due receiving reports
R5        Ability to allow return codes for any portion of a
          shipment
R6        Ability to post receipts and changes on agency
          inventory control system

          Close & Reconcile Purchase Mediums
CR1       Ability to close a purchase order based on user
          defined criteria
CR2       Ability to release purchase orders and obligation
          balances at close
CR3       Ability to designate purchase orders as inactive
          when fully liquidated (and override, as needed)

          eProcurement
EPR1      Ability to establish a purchasing catalog for
          vendors (with an index containing contract
          information)
EPR2      Ability to receive and convert external vendor
          information files in various formats such as
          HTML, MS Access, MS Excel, and ASCII

EPR3      Ability to process orders through eProcurement
          on all state purchasing mediums (i.e. blanket
          purchase orders, non-blanket purchase orders,
          and purchasing cards)

EPR4      Ability to establish a search engine for demand
          ordering by user defined criteria


                                                                                       Appendix C - 9 of 33
                       State of Connecticut
                  Financials Requirements Checklist

Purchasing                                                   Proposer's Response
  ID   Requirement Definition                           Delivered Configured Modified

EPR5   Ability to interface with municipalities (i.e.
       schools, towns, and districts) through the
       Internet




                                                                               Appendix C - 10 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Accounts Payable                                                     Proposer's Response
  ID    Requirement Definition                                  Delivered Configured Modified

        Invoice and Transfer Processing
ITP1    Ability to process garnishments against vendor
        payments
ITP2    Ability to process credit and debit memos
ITP3    Ability to comply with IRS backup withholding
        requirements
ITP4    Ability to default and/or override 1099 data for
        each chart of account coding string
ITP5    Ability to receive invoices by EDI (Electronic
        Data Interchange)
ITP6    Ability to calculate and enter discounts, credits,
        and penalties issued on invoice by line item(s)

ITP7    Ability to match multiple invoices against one
        purchase order and multiple purchase orders to
        one invoice
ITP8    Ability to "flag", notify, and override any
        exceptions in the three way matching process

ITP9    Ability to allow for expenditures to exceed
        encumbrances (tolerances) based on a user-
        defined percentage or dollar amount
ITP10   Ability to reject transactions for insufficient funds
        and override funds availability check
ITP11   Ability to schedule or defer invoices for payment
        based on user defined criteria
ITP12   Ability to validate and apply escalation/de-
        escalation costs
ITP13   Ability to capture quantities and rates information
        on invoices
ITP14   Ability to liquidate or decommit purchase orders
        upon final payment
ITP15   Ability to calculate the tax relief subsidies for the
        elderly and process check payments
ITP16   Ability to default payment method based on
        vendor file indicators
ITP17   Ability to override defaulted payment method
ITP18   Ability to make partial payments on an invoice




                                                                                       Appendix C - 11 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Accounts Payable                                                    Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

ITP19   Ability to pay vendor against various types of
        commitments on one invoice
ITP20   Ability to process advance payments
ITP21   Ability to expedite payment for an individual
        invoice
ITP22   Ability to post transfer invoice
ITP23   Ability to modify invoice variance from purchase
        medium based on receipt
ITP24   Ability to retrieve up-to-date unit pricing from
        contract awards and supplements from DAS at
        time of payment
ITP25   Ability to withhold retainage by percent and
        amount per line item on the receiver and invoice
        per indicators on the commitment document

        Non-Invoice Processing
NIP1    Ability to process any payment without an invoice
        and/or commitment
NIP2    Ability to prevent duplicate payments based on
        user defined criteria (i.e.; attorney's court dates)

NIP3    Ability to access chart of account coding strings
        when processing a payment voucher
NIP4    Ability to maintain and release recurring
NIP5    payments
        Ability to process employee reimbursements
        Payment Processing
PP1     Ability to support multiple payment methods
PP2     Ability to change the bank account information
        such as bank address or account number

PP3     Ability to schedule payment dates to maximize
        discounts and cash flow
PP4     Ability to change or override scheduled payment
        dates
PP5     Ability to hold payments with automated payment
        schedule
PP6     Ability to automate check numbering and
        manually assign check numbers




                                                                                      Appendix C - 12 of 33
                      State of Connecticut
                 Financials Requirements Checklist

Accounts Payable                                                 Proposer's Response
  ID   Requirement Definition                               Delivered Configured Modified

PP7    Ability to modify system generated check
       numbers when check printing errors occur
PP8    Ability to create check runs by user defined
       criteria
PP9    Ability to produce checks on-line using multiple
       check stocks, MICR-encoding and signature
       cartridges
PP10   Ability to print checks remotely
PP11   Ability to allow other feeder systems to use the
       check printing mechanism
PP12   Ability to process stop payments
PP13   Ability to process/account for voided checks and
       automatically post to appropriate accounts

PP14   Ability to reroute check based on user defined
       criteria
PP15   Ability to print checks and use a signature writer

PP16   Ability to generate checks using dual signature
       writer based on user defined criteria

PP17   Ability to pay multiple invoices for a single
       vendor using either a single or multiple checks
       based on user defined criteria
PP18   Ability to control and prevent duplicate payments
       with user defined criteria
PP19   Ability to set up a one-time vendor to process a
       one-time payment
PP20   Ability to apply vendor payments to an alternate
       or same Federal Employer Identification Number
       as well as any other user defined parameter (i.e.
       legal documents)

PP21   Ability to have vendor check cancellations
       against a purchase medium and credit the
       purchase medium so all affected balances are
       accurate
PP22   Ability to reverse a posted transaction whether or
       not a check has been generated providing it has
       not cleared


                                                                                   Appendix C - 13 of 33
                      State of Connecticut
                  Financials Requirements Checklist

Accounts Payable                                                 Proposer's Response
  ID   Requirement Definition                               Delivered Configured Modified

PP23   Ability to create 1099-S forms when required by
       payment type
       Petty Cash Processing
PTY1   Ability to support special functions for entering
       and reimbursing employee advances and
       expenses
PTY2   Ability to handle all types of employee advances
       or reimbursements (i.e. travel, mileage, and
       meals)
PTY3   Ability to maintain employee expense history
PTY4   Ability to handle replenishment to one or more
       agency bank accounts
PTY5   Ability to have mileage from town to town on-line

PTY6   Ability to maintain travel advances, insurance
       payments, regular petty cash balance, etc.
       separately (subaccounts) within the petty cash
       account
PTY7   Ability to print petty cash checks on demand and
       remotely
       Bank Reconciliation
BKR1   Ability to perform automated and manual bank
       reconciliations
BKR2   Ability to perform bank reconciliations for
       multiple accounts
BKR3   Ability to transmit check reconciliation data in a
       form specified by the bank
BKR4   Ability to receive, accept, and verify cleared
       checks electronically
BKR5   Ability to accept/transfer bank deposit
       information to/from the Treasurer's office
BKR6   Ability to produce a list of outstanding checks




                                                                                   Appendix C - 14 of 33
                         State of Connecticut
                     Financials Requirements Checklist

Revenue & Receipts                                                    Proposer's Response
     ID   Requirement Definition                                 Delivered Configured Modified

          Customer Maintenance
CM1       Ability to maintain multiple names, federal
          employer identification numbers, contact names,
          e-mail and addresses for one customer

CM2       Ability to have multiple customer types and
          accounts
CM3       Ability to have customer status, priority ratings,
          and credit terms
CM4       Ability to identify/track customer accounts for
          settlement processing (i.e. court actions/court
          case docket number/payment schedule) by
          establishing a link to the vendor file and the
          accounts payable module
CM5       Ability to classify billing requirements by
          customer
CM6       Ability to identify customers with special payment
          terms (zero ability to pay/partial or no payment)

CM7       Ability to have proration of multiple benefits
          across multiple payers
          Sales Order Processing
SOP1      Ability to process sales orders for multiple
          businesses operated by one agency
SOP2      Ability to generate a receipt for goods or services
          sold
SOP3      Ability to automatically process recurring orders

SOP4      Ability to create and establish commodity codes
          and rate tables by user defined criteria for goods
          or services
SOP5      Ability to automatically create a
          requisition/purchase order for items which are on
          back order in the sales order system
          Billing
B1        Ability to enter or adjust bills
B2        Ability to produce ready to mail or electronic bills

B3        Ability to produce interagency or external bills
          based on customer file indicators


                                                                                        Appendix C - 15 of 33
                          State of Connecticut
                     Financials Requirements Checklist

Revenue & Receipts                                                      Proposer's Response
     ID   Requirement Definition                                   Delivered Configured Modified

B4        Ability to bill minimum or maximum charge
          amounts according to an agreed upon payment
          schedule and override if necessary
B5        Ability to bill with predetermined rates
B6        Ability to exclude/include billing detail data
          elements, allowable charges and overhead on
          specific bills or all bills
B7        Ability to define multiple billing calculation tables
          (i.e. percentages, rates, receipts, contractual
          allowances, and write offs)
B8        Ability to calculate and record finance, interest,
          and/or late charges
B9        Ability to generate bills with multiple line items

B10       Ability to accrue receivables based on a
          receiving schedule without generating a bill
B11       Ability to view customer balances during billing
          process (drill-down)
B12       Ability to cancel bills
B13       Ability to correct bills and reprint them without
          affecting balances
B14       Ability to apply credit memos to related bills or
          line items on a bill
B15       Ability to generate multiple types of billing and
          receivables with multiple formats
B16       Ability to issue a series of bills to multiple
          customers for the same receivable (so that the
          amount of each subsequent bill is the difference
          between the total receivable amount and the
          sum of all previous amounts received)

B17       Ability to perform or conduct eligibility verification
          before billing
B18       Ability to suppress generation of bills
B19       Ability to generate bills based on agency specific
          criteria
          Deposits & Receivables Processing
DRP1      Ability to establish default chart of account
          coding strings for each receivable




                                                                                          Appendix C - 16 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Revenue & Receipts                                                  Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

DRP2    Ability to post all revenue regardless of source

DRP3    Ability to post full or partial payments
DRP4    Ability to post demand deposits and letter of
        credit receivables to appropriate accounts
DRP5    Ability to process receipts without invoicing and
        capture the monies received as "trust fund"

DRP6    Ability to post receivables before or after
        depositing money in the bank, and automatically
        generate appropriate entries in the general
        ledger
DRP7    Ability to identify and post non-revenue and
        revenue receipts
DRP8    Ability to have multiple receipt types
DRP9    Ability to account for, monitor, and track all daily
        deposits generated from remote locations (i.e.
        court revenue, juvenile restitution, and adult
        restitution)
DRP10   Ability to process miscellaneous cash receipts
        without posting to a receivable
DRP11   Ability to process a receipt against multiple bills

DRP12   Ability to allow for collection of deferred revenue
        and/or unearned revenue
DRP13   Ability to set up one-time customers for purpose
        of processing a one-time receivable
DRP14   Ability to automatically apply or allocate receipts
        on a predetermined basis depending on the
        priority or the type of outstanding receivable

DRP15   Ability to generate an outstanding payable for
        overpayments and notify the payment unit of the
        outstanding payable
DRP16   Ability to write off discrepancies between billed
        amounts and amounts received within a user
DRP17   defined tolerance a credit memo
        Ability to produce
DRP18   Ability to carry forward receivables with either
        current or new year account codes




                                                                                      Appendix C - 17 of 33
                        State of Connecticut
                   Financials Requirements Checklist

Revenue & Receipts                                                    Proposer's Response
  ID    Requirement Definition                                   Delivered Configured Modified

DRP19   Ability to select a bill, and/or a group of bills, and
        generate a non-banking revenue transaction
        (transfer certificate)
DRP20   Ability to generate/process EFT, credit and debit
        card transactions on-line or electronically

DRP21   Ability to process checks returned for insufficient
        funds and re-establish the receivable

DRP22   Ability to post full payment on partial receipt for
        federal and state tax intercepts
DRP23   Ability to retroactively accept receipts beyond
        amounts that were billed over multiple years due
        to retroactive rate adjustments
DRP24   Ability to apply unidentified cash receipts to a
        pending receipt account and reverse from
        pending upon resolution
DRP25   Ability to record deposits made to multiple bank
        accounts via lock boxes
        Aging & Collections
AC1     Ability to age receivables as defined by user (i.e.
        date or services)
AC2     Ability to process accounts with extended
        payment terms
AC3     Ability to set up standard dunning message
        codes
AC4     Ability to set dates and/or default time frames to
        produce final notices
AC5     Ability to place services on hold for past due
        receivables from debtors
AC6     Ability to receive notification of collection status
        (i.e. payment in full and satisfaction of
        judgement)
AC7     Ability to produce "withdrawal in full" upon
        payment of judgement




                                                                                        Appendix C - 18 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Projects & Grants                                                   Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

        Projects / Grants Maintenance
PGM1    Ability to maintain capital historical data as well
        as subgrants for projects/grants independent of
        G/L data (across multiple fiscal years)

PGM2    Ability to manage several sub-projects under one
        controlling project
PGM3    Ability to provide a user defined ‘low funding’
        limit or budget percentage indicator to denote
        when there is a need for funds to be transferred
        to the project fund account
PGM4    Ability to identify allotments, encumbrances, and
        expenditures by grant number, project number,
        Catalog of Federal Domestic Assistance
        (CFDA), federal appropriations, sources of funds
        (revenue), and coding string
PGM5    Ability to create cost and revenue pools by user
        defined formulas/algorithms/groups/categories
PGM6    Ability to define cost or revenue data type(s) (i.e.
        hours, wage rate, and percentages)
PGM7    Ability to define and prioritize the project/grant
        task sequence
PGM8    Ability to enter descriptive information about a
        project (i.e. project description, low bid, hold
        information, and fixed asset agreement
        comments)
PGM9    Ability to provide an automated cross reference
        to all internal and external project numbers
PGM10   Ability to maintain multiple levels of project
        completions/statuses (i.e. milestones or
        performance)
PGM11   Ability to prevent charges from being allocated to
        an inactive project, sub-project, or phase based
        on user-defined criteria
PGM12   Ability to calculate cost base information (i.e.
        General and Administrative or Overhead to
        Labor) to projects/grants
PGM13   Ability to reference project numbers by a user
        defined criteria




                                                                                      Appendix C - 19 of 33
                        State of Connecticut
                    Financials Requirements Checklist

Projects & Grants                                                  Proposer's Response
   ID    Requirement Definition                               Delivered Configured Modified

PGM14 Ability to set up authorized users by job title or
      name to charge labor to a project
PGM15 Ability to compute labor distribution methods
      (include schedules) to include indirect labor
      costs, overhead and burden rates for single or
      multiple agencies
PGM16 Ability to apply multiple or split funding sources
      to individual or multiple phases within projects
      with the option to appropriate/allocate by
      percentage
PGM17 Ability to recognize charge backs (i.e. employee
      in one organization working on a project in a
      different organization)
PGM18 Ability to assign provisional rates to actual rates
      which can process adjustments from provisional
      to actual revenue
PGM19 Ability to provide an award list for special
      compliance issues that are unique for a
      project/award
PGM20 Ability to configure an agency's projects to
      record contract terms and funding limits
PGM21 Ability to budget to multiple tasks and subtasks
      within a grant award
PGM22 Ability to establish rules and regulations based
      on type of project or grant to comply with federal
      regulations
PGM23 Ability to create uniform expenditure types that
      coincide with federal budgets
PGM24 Ability to close out a portion of a grant, by project

PGM25 Ability to inactivate awards after all award
      requirements have been met
PGM26 Ability to monitor all sub-recipients' grants and
      contracts that are awarded as pass thrus of
      grants funded by multiple funding sources and or
      agencies
PGM27 Ability to identify and track federal, state, and
      third party (local, private) funding shares by total
      amount, percentage, and/or budget items




                                                                                     Appendix C - 20 of 33
                        State of Connecticut
                    Financials Requirements Checklist

Projects & Grants                                                  Proposer's Response
   ID    Requirement Definition                               Delivered Configured Modified

PGM28 Ability to create and maintain grant applications
      and proposals
PGM29 Ability to define project types as they relate to
      agencies' activities
PGM30 Ability to record approved demand deposits and
      letters of credit to a project
PGM31 Ability to define projects/grants at multiple
      hierarchical levels and funding sources (i.e.
      grant, contract/funding, projects, providers,
      tasks, subtasks, phase, activity, function,
      account, cost center, units) by state or federal
      fiscal year
PGM32 Ability to track contract award obligations and
      provide alerts/triggers for date and invoicing
PGM33 Ability to apply various funding adjustments
      through receipts, expenses, and other adjusting
      transactions
PGM34 Ability to establish funds eligibility for
      expenditures as defined by users
PGM35 Ability to perform roll-ups and drill-downs at
      multiple levels (i.e. activities)
PGM36 Ability to track all financial transactions per
      project, phase, and activity by fund
PGM37 Ability to facilitate transfers between federal
      programs and/or between state and federal
      funding sources
PGM38 Ability to accumulate expenditures by user
      defined criteria and generate billings in the
      appropriate formats
PGM39 Ability to track term dates on projects and trigger
      a warning when the project reaches 90 days
      prior to the termination date
PGM40 Ability to create an automatic warning message
      when more than one federal fund modification is
      entered for one project within the same month

PGM41 Ability to create detailed estimates (i.e. collective
      bargaining unit increases) for multiple projected
      years




                                                                                     Appendix C - 21 of 33
                        State of Connecticut
                   Financials Requirements Checklist

Projects & Grants                                                Proposer's Response
   ID    Requirement Definition                             Delivered Configured Modified

PGM42 Ability to apply horizontal or vertical adjustments
      as prescribed by federal, state, private funding
      source
PGM43 Ability to identify grant expenditures by function
      and activity
PGM44 Ability to identify and track federally funded
      projects awarded to disadvantaged business
      enterprises (DBEs)
PGM45 Ability to view statewide vendor information as it
      relates to a single audit act
PGM46 Ability to allocate a single asset to multiple
      projects
PGM47 Ability to identify final audit at the State and
      Federal levels
         Projects / Grants General Accounting
PGGA1 Ability to account for projects that may cross
      funds or budget units
PGGA2 Ability to disseminate costs by funding source

PGGA3 Ability to identify/track matching or retained
      funds and baseline ("maintenance of effort")
      expenses for drawdowns of federal money
      across multiple agencies
PGGA4 Ability to maintain independent hierarchies in the
      account structure to support different account
      roll-ups
PGGA5 Ability to accommodate and modify project
      budgeting and produce allocation schedules
PGGA6 Ability to distribute the annual project budget by
      month based on user specified percentages
PGGA7 Ability to calculate or accumulate funding for
      direct and indirect cost allocation types as
      defined by the users with the option to apply
      effective dates
PGGA8 Ability to apply cost modeling to various
      accounting methods using current, past, and
      future data
PGGA9 Ability to distribute personnel services and
      benefits cost to grants and projects based upon
      time and other user-defined formulas



                                                                                   Appendix C - 22 of 33
                        State of Connecticut
                    Financials Requirements Checklist

Projects & Grants                                                   Proposer's Response
   ID     Requirement Definition                               Delivered Configured Modified

PGGA1    Ability to identify projects lacking activity for a
0        specified time period
PGGA1    Ability to provide user defined project and grant
1        coding summaries at completion of a project
PGGA1 Ability to allow for input, adjustment, and transfer
2     of costs and revenues as defined by users

PGGA1 Ability to reverse the allocation process for
3     specific set of transactions or all transactions in
      a specific period
PGGA1 Ability to provide offsetting benefits and
4     overhead clearing accounts with automatic
      variance rates and distribution procedures
PGGA1 Ability to support charge-back project cost data
5
PGGA1 Ability to have spending control at the line item
6     or activity level
PGGA1 Ability to do time phased budgeting for multiple
7     year awards where funding is received in
      installments
PGGA1 Ability to enter funding from multiple funding
8     sources and for multiple fiscal years at one time
PGGA1 Ability to provide one uniform grant/project code
9     structure to be used by all agencies statewide
      with the ability to differentiate at the agency level

PGGA2 Ability to allocate costs between agreements and
0     further allocate by sub-elements
PGGA2 Ability to adjust cost allocation methods as
1     needed
PGGA2 Ability to provide cost allocation plan by
2     project/task/subtask/activity
PGGA2 Ability to reallocate grant fundings from one
3     project to another (block grants)
PGGA2 Ability to identify matching funds (by percent,
4     monetary versus in-kind contributions, and
      specific accounts of matching funds)
PGGA2 Ability to override and enter certain financial
5     transactions after end date of award



                                                                                      Appendix C - 23 of 33
                         State of Connecticut
                    Financials Requirements Checklist

Projects & Grants                                                   Proposer's Response
   ID     Requirement Definition                               Delivered Configured Modified

PGGA2 Ability to track grant/project activity over multiple
6     and varying fiscal years
PGGA2 Ability to track grant/project fiscal activity after a
7     grant/project has expired
PGGA2 Ability to separate expenditures by functional
8     classification(s), improvement type(s), and
      activities
PGGA2 Ability to assign expenditures in a state project to
9     a federal project by state appropriation code (this
      would allow expenditures on a given state
      project to be charged to multiple federal project
      numbers based upon the state program where
      expenditures are incurred)
PGGA3 Ability to maintain and monitor transactions for
0     federal aid project numbers by appropriation
      code
PGGA3 Ability to request (Bond Authorizations)
1     allocations and allotments when necessary
PGGA3 Ability to identify expenditures for other agencies
2     which meet baseline ("set asides/maintenance of
      effort") entitlement requirements

PGGA3 Ability to carry forward balance of funding
3     available for projects/grants and show accrual
      against monies not yet spent
          Work Orders
WO1       Ability to assign work orders (encumbrances) to
          a project and job number
WO2       Ability to itemize expenses in work orders (i.e.
          materials, labor, contract)
WO3       Ability to generate work orders in different
          formats based on work order type(s)
WO4       Ability to provide a history of work order routing
          and work order status
WO5       Ability to have project number referenced in the
          work order
WO6       Ability to close work orders by quantity, hours,
          labor dollars and total dollars
WO7       Ability to create work orders from Work
          Breakdown Structure (WBS)


                                                                                      Appendix C - 24 of 33
                       State of Connecticut
                  Financials Requirements Checklist

Projects & Grants                                                  Proposer's Response
  ID    Requirement Definition                                Delivered Configured Modified

WO8     Ability to create work orders from a remote site
WO9     Ability to create work orders for preventative and
        ad-hoc maintenance of fixed & moveable assets

WO10    Ability to create work orders for improvements or
        betterments of fixed assets
WO11    Ability to track materials used, labor expended,
        and contracted expenses through work
        performed
WO12    Ability to have work orders under a project
        scheduled and billed independently of each other

        Projects / Grants Costing
PGC1    Ability to include or exclude equipment
        depreciation rate from equipment costs
PGC2    Ability to accumulate equipment usage and
        maintenance cost history
PGC3    Ability to monitor all costs categories
PGC4    Ability to validate employee time records for cost
        allocation purposes
PGC5    Ability to post cost base (i.e. labor and overhead
        costs) to project phases based on the timecard
        task codes
PGC6    Ability to post labor costs based on user defined
        time period (i.e. paydays, pay periods, weeks, or
        months)
PGC7    Ability to track contract retention and funding for
        activities as defined by user
PGC8    Ability to adjust timecards, expense, asset
        utilization and vendor invoices to all projects
PGC9    Ability to limit project charges to task by
        employee, expenditure category, expenditure
        type, and non-labor resource
PGC10   Ability to define a cost plus build-up rate for
        internal costs, revenue accruals and billing to
        include cost base and indirect cost codes
PGC11   Ability to allow cost schedules for restricted
        grants/projects to comply with award
        requirements




                                                                                     Appendix C - 25 of 33
                        State of Connecticut
                   Financials Requirements Checklist

Projects & Grants                                                     Proposer's Response
  ID    Requirement Definition                                   Delivered Configured Modified

PGC12   Ability to calculate and adjust costs, revenue and
        invoice amounts
PGC13   Ability to reclassify billable status of transactions

PGC14   Ability to split transactions into two or more
        activities that can be processed differently
PGC15   Ability to support revenue and receivable write-
        offs
PGC16   Ability to establish user-defined controls as to
        which items can transfer between projects
PGC17   Ability to monitor disbursements by both project
        and bond issue
PGC18   Ability to charge salary cost based on actual time
        worked
PGC19   Ability to calculate equipment costs asset
        threshold
PGC20   Ability to itemize costs by labor, usage, expense
        and/or goods and services
PGC21   Ability to track build out allowances and costs

PGC22   Ability to create cost pools to additive rate to
        project for direct and indirect costs
PGC23   Ability to selectively identify project building costs
        for cost recovery
PGC24   Ability to adjust cost pools
PGC25   Ability to estimate project costs for labor and
        materials
PGC26   Ability to charge off overhead costs based on
        cost center time charges during a particular time
        period
PGC27   Ability to calculate and adjust costs (i.e.
        raw/burden) as prescribed by Federal and State
        regulations across multiple facilities/units
        Federal Funds Processing
FFP1    Ability to comply with the Cash Management
        Improvement Act (CMIA) standards for
        processing of federal drawdowns
FFP2    Ability to conform to federal single audit
        requirements




                                                                                        Appendix C - 26 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Projects & Grants                                                   Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

FFP3    Ability to identify the Catalog of Federal
        Domestic Assistance Number (CFDA) by
        projects and expenditures
FFP4    Ability to enter non-budgeted appropriations to
        the spending control level
FFP5    Ability to cross reference letters of credit with
        federal fund expenditures
FFP6    Ability to generate establishment/adjustment of
        receivables form(s) and record authorization(s)
FFP7    Ability to define and establish project/grant
        baselines and/or thresholds at multiple levels
        from multiple funding sources
FFP8    Ability to create an indicator as it relates to
        subgrantees' fiscal year
FFP9    Ability to automate the drawdown process
FFP10   Ability to track expenditures or obligated funds
        against receivables and identify when
        threshold(s) defined by the users have been met

        Projects / Grants Revenue (Billing)
PGR1    Ability to generate bills based on defined
        milestones
PGR2    Ability to accrue revenue and generate bills
        using agency specific or general algorithms
PGR3    Ability to generate multiple calculation/rate tables

PGR4    Ability to define override rates, skills and billing
        tables by project and task
PGR5    Ability to define flexible billing formats by tasks
        and/or user defined types
PGR6    Ability to drill-down from billing document to
        detail transactions
PGR7    Ability to define billing holds
PGR8    Ability to support unbilled and unearned revenue

PGR9    Ability to support borrowed and transferred
        revenue transactions
PGR10   Ability to generate billing to comply with federal
        requirements




                                                                                      Appendix C - 27 of 33
                        State of Connecticut
                   Financials Requirements Checklist

Projects & Grants                                                    Proposer's Response
  ID    Requirement Definition                                  Delivered Configured Modified

PGR11   Ability to establish benchmark controls for
        project billing
PGR12   Ability to modify the length of a billing cycle or
        set different billing cycles by funding source

PGR13   Ability to produce a bill that meets the billing
        requirements for each funding source
PGR14   Ability to code expenditures as federally or non-
        federally participating
PGR15   Ability to generate message to specific users
        that an accrued unbilled federal charge has
        occurred
PGR16   Ability to post billing on appropriate agency
        forms (records)
PGR17   Ability to pro-rate bills
PGR18   Ability to produce Federal voucher based on
        required parameters
PGR19   Ability to automatically generate bills from
        finalized budget data
PGR20   Ability to track disability funds (i.e. Title 19) for
        transaction payment and bank reconciliation
PGR21   Ability to adjust prior project billings and
        payments
PGR22   Ability to maintain project and fund accounts
        over multiple state and federal fiscal years




                                                                                       Appendix C - 28 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Asset & Inventory Management                                        Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

        Asset & Inventory Acquisition
AIA1    Ability to establish and enter fixed asset
        categories and sub-categories such as: land,
        buildings, leasehold improvements, equipment,
        furniture, fixtures, vehicles, capitalized leases,
        construction-in-progress, infrastructure,
        improvements (modifications), betterments, fine
        arts, and site improvements
AIA2    Ability to create a record for each item
        purchased and assign it an acquisition category
        (i.e. purchase, transfer, gift, escheat,
        foreclosure, and eminent domain)
AIA3    Ability to assign specific tag number or multiple
        asset numbers by agency
AIA4    Ability to provide user defined major asset type
        codes
AIA5    Ability to provide a schedule of assets grouped
        by GAAFR function and/or departments

AIA6    Ability to define, for equipment with
        subcomponents, either a hierarchical
        relationship or a common asset class
AIA7    Ability to enter different types of leases as fixed
        assets, including capitalized leases
AIA8    Ability to define rules to classify assets based on
        individual agency criteria
AIA9    Ability to define valuation techniques and GASB
        asset depreciation methods
AIA10   Ability to associate a particular fund or source of
        funds with fixed assets and percentage for each
        funding participation
AIA11   Ability to depreciate according to schedules and
        methods and allow for agency level override
        capabilities
AIA12   Ability to prorate an asset in the month acquired
        (delivered and accepted)
AIA13   Ability to provide alphanumeric bar code labeling
        for direct or remote asset entry with the ability to
        print or reprint asset labels on demand




                                                                                      Appendix C - 29 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Asset & Inventory Management                                       Proposer's Response
  ID    Requirement Definition                                Delivered Configured Modified

AIA14   Ability to capture and change the useful life of an
        asset and reset depreciation counter
AIA15   Ability to allow some assets to be designated as
        nondepreciable (i.e. land, site improvements,
        artwork and nondepreciable structures)

AIA16   Ability to maintain asset information such as
        warranty, extended warranty, maintenance
        history, class of asset and
        equipment/subcomponent relationships
        information
AIA17   Ability to calculate the payment schedule of a
        capital lease using an implicit interest rate, and
        show the interest and principle amounts
        separately in the payment schedule
AIA18   Ability to specify the location of an asset
        including surface/subsurface, address, building,
        etc.
AIA19   Ability to cross-reference Manufacturers’ part
        numbers to the inventory commodity code
        structure
AIA20   Ability to capture the asset's condition, date of
        delivery, and salvage value
AIA21   Ability to match reference number to map index
        and capture data relevant to the purchase of
        land
AIA22   Ability to capture current asset and insurable
        values
AIA23   Ability to provide information for Manufacturer
        Year, Make, Model, Equipment Rental Rate, Tax
        Town Number
AIA24   Ability to capture appraisal dates of artwork
        assets and allow entry of adjusted values based
        on appraisals
AIA25   Ability to automatically notify a user of the need
        to schedule a new appraisal for artwork based
        on user defined interval
AIA26   Ability to recognize a receiving transaction as a
        new asset or adjustment to the cost of an
        existing asset



                                                                                     Appendix C - 30 of 33
                        State of Connecticut
                   Financials Requirements Checklist

Asset & Inventory Management                                        Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

AIA27   Ability to create mass acquisition entries of the
        same properties
AIA28   Ability to do bar code scanning using handheld
        equipment
AIA29   Ability to record assets based on purchases
        made by other agencies
AIA30   Ability to identify controllable items
AIA31   Ability to calculate the cost of an asset based on
        raw materials and production costs
AIA32   Ability to establish sales price for manufactured
        goods (including overhead and burden) as cost
        of an asset
AIA33   Ability to enter the value of an asset including
        infrastructures
AIA34   Ability to create item templates to define major
        item attributes
        Asset & Inventory Maintenance
AIM1    Ability to transfer, dispose, or re-instate an asset
        or a group of assets by a user defined criteria

AIM2    Ability to maintain accounts for capital leases
        and leasehold improvements
AIM3    Ability to account for split, consolidated, partial
        retirement, and full retirement of assets

AIM4    Ability to record asset transfers between funds,
        departments, agencies, other governments, or
        external sources, as an acquisition and/or
        disposition, using internal checks and balances

AIM5    Ability to calculate accumulated depreciation and
        book value on a user-defined basis
AIM6    Ability to record and accumulate multiple
        betterments for individual fixed assets
AIM7    Ability to perform adjustments on fixed asset
        records
AIM8    Ability to calculate periodic and accumulated
        amortization and determine the net book value
        as of the current date or lease termination




                                                                                      Appendix C - 31 of 33
                       State of Connecticut
                   Financials Requirements Checklist

Asset & Inventory Management                                        Proposer's Response
  ID    Requirement Definition                                 Delivered Configured Modified

AIM9    Ability to determine variances for gains and
        losses
AIM10   Ability to flag assets with disposal restrictions
        and display the restriction message for user
        handling
AIM11   Ability to monitor usage of an asset based on
        funding source
AIM12   Ability to monitor fixed asset status
AIM13   Ability to maintain complete maintenance and
        repair history log identifying person performing
        inspections and service
AIM14   Ability to forecast capital asset improvements
        and replacement based on agency defined
        planning criteria
AIM15   Ability to track item quantities using pre-specified
        or dynamic stock locators
        Asset & Inventory Processing
AIP1    Ability to receive assets into inventory and
        expense when used
AIP2    Ability to generate location data before doing an
        inventory as defined by the agency
AIP3    Ability to record physical inventory count of
        assets and reconcile to system maintained
        inventory counts and values
AIP4    Ability to create and reference substitute items

AIP5    Ability to maintain multiple units of measure(s)

AIP6    Ability to track location of any item at multiple
        levels as defined by user (i.e. rack and bin,
        building, room)
AIP7    Ability to identify receipt of material from
        suppliers and reference the purchase orders
AIP8    Ability to automatically generate purchase
        requisitions and alert Purchasing Department
        that a replenishment order is required
AIP9    Ability to summarize inventory transactions and
        transfer associated charge-back cost information
        to accounts




                                                                                      Appendix C - 32 of 33
                       State of Connecticut
                  Financials Requirements Checklist

Asset & Inventory Management                                     Proposer's Response
  ID    Requirement Definition                              Delivered Configured Modified

AIP10   Ability to identify an asset as part of the
        moveable item inventory
AIP11   Ability to identify receipt and inspection of all
        materials returned by a customer
AIP12   Ability to capture the movement of materials to
        and from shop floor
AIP13   Ability to transfer material inventory and
        associated costs between departments or
        agencies
AIP14   Ability to maintain a store inventory (warehouse)
        system including but not limited to stock
        transfers, ordering, recovering, withdrawals,
        defective items and returns - with online
        capabilities and automatic posting
AIP15   Ability to trigger an equipment replacement
        schedule for budget management and planning

AIP16   Ability to maintain fair market value (FMV) costs
        as it relates to depreciation and maintain actual
        cost (AC) as it relates to surplus

        Software Inventory
SIM1    Ability to manage software inventory
SIM2    Ability to associate software with hardware asset
        inventory number




                                                                                   Appendix C - 33 of 33

								
To top