Office of the Chief Financial Officer AIS Certification

Office of the Chief Financial Officer AIS Certification

MISSION To provide service to City of Detroit citizens, Elected Officials, and departments through ensuring fiscal stability, providing sound business advice, and maintaining data integrity. We accomplish this through researching and implementing leading practices in financial management, strong internal controls, and accurate and transparent information and data analysis. We will provide Elected Officials and departments with accurate information in a form that enables priority-oriented, data-driven decision making about the efficiency and effectiveness of service and program delivery. VISION To be a service-oriented organization to City of Detroit citizens, Elected Officials, and departments. We aim to provide seamless services to citizens in a simple, clear, professional, and honest manner. We strive to become the trusted business advisors of each City department and anticipate their needs and solutions. CORE VALUES INQUISITIVE CONTINUOUSLY IMPROVING ACTING ON ROOT CAUSE COLLABORATIVE ACTIVELY SUPPORTIVE EMPOWERED

OCFO Org Chart CFO’s Office of the Assessor Office of Departmental Financial Services Office of Budget Office of Contracting & Procurement Office of the Controller Office of Development & Grants Office of Financial Planning & Analysis Office of the Treasury Office of the Chief Financial Officer 6

OCFO Lifecycles Lifecycle Assess to Collect Budget Cycle Cash Management Debt Issuance Development & Grants Income Tax Other Revenue (not Property or Income Tax) Procure to Pay Record to Report Release to Upgrade Description Property assessment and tax process, including property assessment, property tax billing, remittance and delinquent collections Resource planning (including procurement, grant, IT, and staffing planning) to budget and four-year financial plan development, execution, and monitoring Providing banking services, managing cash, reconciling transactions, forecasting future cash position, and investing funds Planning, issuing, managing and compliance of debt, including relationship with credit rating agencies and investors Grant identification, application, management, and close out, including grant reporting Managing MOU with the State of Michigan, receiving and recording income tax revenue, and income tax compliance and audit activities Collection process for wagering tax, utility users tax, state revenue sharing, and departmental revenues including inter-agency revenues, fees and fines Procuring goods and services including procurement planning, purchasing, invoicing, payment and contract monitoring Accounting for and recording revenue/expenses, monthly/annual close, and financial reporting including Single Audit and CAFR preparation Preparing for new ERP releases, implementing new ERP releases, and maintaining the current ERP release including issue resolution Office of the Chief Financial Officer 20

OCFO Lifecycles by Division OCFO Major Lifecycles by Division Assess to Collect Budget Assessor X X Budget X X X X Departmental Financial Services X X Development & Grants X X Financial Planning & Analysis X OCFO Division Contracting & Procurement Controller Treasury X X X Cash X Debt X Revenue Procure to Release to Record to Pay Upgrade Report X X X X X X X Grants X Income Tax X X X X X 4

Inputs OCFO Lifecycles - Template Input 1 Input 2 Input 3 Input 4 Input 5 Input 6 Authorities & Policies Outputs Workstreams CFO Directive Major Work Stream • Process 1 • Process 2 • …. Output 1 Output 2 Major Work Stream 2 • Process 1 • Process 2 • …. Output 3 Output 4 Major Work Stream 3 • Process 1 • Process 2 • …. Output 5 Output 6 State Law Stakeholders OCFO City Council Departments Residents Modules and Systems Oracle Etc Office of the Chief Financial Officer 21

OCFO AIS Objectiv Policy e All authorities, functions, policies, procedures, statements, opinions, and other governance of the OCFO shall be established and disseminated through a Document. Assessor Objective Treasury Budget OCFO AIS FPA ODFS OCP Controller To provide for the efficient, effective, and transparent management through the standardized administration of CFO authority, functions, policies, procedures, statements, opinions, and other governance. ODG 6

OCFO AIS – CFO Documents CFO Administrative Order • Establishes, revises, or retracts a rule or guideline that is issued solely by the CFO Directive • Establishes, revises, or retracts policies and/or procedures that have an action associated with them and are to be carried out by the OCFO as authorized by local, state, or federal law. CFO Memorandum • Statements, opinions, interpretations, and/or analyses on active or proposed laws, rules, regulations, contracts or other similar documents. 7

OCFO AIS – Select CFO Documents by Lifecycle OCFO Documents by Major Lifecycles Revenue Cash Debt Grants Procure to Pay Budget X X X X General Fund Budget Reserve X X X Use of Non-Recurring Resources X X X CFO Document Title OCFO Administrative Issuance System Assess to Income Collect Tax X X X Comprehensive Financial Planning Debt Issuance and Management X Investments and Investment Management Retiree Protection Fund Investment Advisory Group Release to Record to Upgrade Report X X X X X Fiscal Sustainability Working Group Financial Reporting X X X X X Performance Management in the OCFO Responsibilities related to City Pension Obligations X X X X Budget Development, Execution and Monitoring X X X X Cash Management X X Accounts Payable X X X 8

OCFO AIS – Select CFO Documents by Lifecycle (cont. ) OCFO Documents by Major Lifecycles (cont. ) CFO Document Title Enterprise Resource Planning Governance Assess to Income Revenue Collect Tax X X X Procure Budget to Pay Release Record to to Report Upgrade X X Cash Debt Grants X X X X X Contracting and Procurement Revenues and Revenue Management X X X User Fees and Charges X X X X X X X Fiscal Impact Statements Proposed City Ordinances and Resolutions with a Budgetary Impact Cash Handling Accounting X X X X X Capital Planning and Capital Assets Chart of Accounts X X X X Cost Allocation Development and Grants Management X X X X Internal Controls X X X X X Manual Journal Entries X X X X X Period Close X X X X Risk Management Tax and Revenue Clearances X X X 9

AIS Certification All OCFO Employees must certify they have read and understand each of the CFO Documents listed on the OCFO webpage here: https: //detroitmi. gov/departments/office-chief-financialofficer/administrative-issuance-system Office of the Chief Financial Officer 10