Specifications include, but are not limited to: Vendor will provide financial reporting software to produce the City’s Annual Comprehensive Financial Report (ACFR). This will be an accumulation of the various components required in the ACFR and will include data from the City’s general ledger and other template documents, to help streamline the gathering of financial data, address rounding issues, and correlate the numerous inputs into the various schedules that make up the ACFR, including both Excel spreadsheets and Word documents, plus tables and charts. Scope of Service and Software Requirements: 1. Vendor must have ability to integrate data from/within City’s financial software (CentralSquare NaviLine, Select Version 9.1.21.1). 2. The software must allow the City to import data from its general ledger, including the City’s Trial Balance in Excel spreadsheet format. 3. The software must have ability to utilize City’s chart of accounts structure for mapping purposes (including project master codes). The City’s chart of accounts is made up of 7 segments. a. 3-digit Fund b. 2-digit Department c. 2-digit Division d. 2-digit Activity basic e. 1-digit Sub activity f. 2-digit Element g. 2-digit Object h. Project codes are not required on each account number, but are required for multi-year funds. The project codes are 6-digits and can be alpha-numeric. 4. The software must have ability to accommodate a large number of funds a. FY2023 - City had 32 Governmental Funds (General Fund, 13 Special Revenue Funds, 18 Capital Projects Funds) b. FY2023 – City had 7 Enterprise Funds c. FY2023 – City had 3 Internal Service Funds d. FY2023 – City had 2 Discretely Presented Component Units
