ERP Grants, Projects & Fixed Assets Accountant

Job Title Financial Services Accountant Job Summary Under minimal direct supervision, proactively perform accounting activities related to specific reporting and compliance requirements. Support and assist in the proper recording and reporting of general accounting activities. Demonstrate professionalism while coordinating and collaborating with schools, central departments, and outside entities. Using the enterprise resource planning (ERP) platform, monitor the proper accounting for and reporting of such programs for the district. Ability to interact and collaborate efficiently and effectively District wide. Provide support to the Controller and Assistant Controller. Assignments include Grant Funding, Projects and Bond, and Projects and Fixed Assets. Essential Duties and Responsibilities Utilizing the ERP platform, compile and analyze data, monitor coding and recording. Prepare and input correcting journal entries resulting from in depth ERP analysis of accounting information. Partner with Payroll specialists to facilitate payroll corrections as needed. Create and manage ERP report tracking documentation (i.e. spreadsheets) to assist in the monitoring, reporting, and recording of accounting activities. Prepare monthly reports and presentations as needed or requested for district administration, Superintendent’s Cabinet, and Board of Education. Maintain ERP accounting system databases, tables, and programs. Work in partnership with external auditors and provide data analysis as required, including work papers, schedules, and access to accounting records for federal, state, and private programs. Perform other duties as assigned or requested. Grant Funding Assignment Utilizing the ERP platform, compile, analyze, and monitor the coding, recording, and reporting of grant projects and activities through the Special Populations Department, Federal Projects Office, Cherry Creek Schools Foundation, and other relevant sources. Maintain the district’s Grants Activities reporting system in ERP platform to ensure the accurate accounting and reporting of grant projects and activities, including the monitoring and assistance in the tracking, recording and closing of multiple year grant accounts. Advise school bookkeepers and department staff of Generally Accepted Accounting Principles (GAAP) and other federal regulations and provide guidance for the proper accounting reporting for compliance with federal, state, and private requirements relating to the financial assistance programs. Advise and assist in formulating corrective action plans as needed. Maintain up-to-date information relating to the compliance requirements of federal, state, and private financial assistance programs. Distribute and communicate current results with appropriate district personnel. Perform monthly reconciliation on grant accounts, ensuring all transactions are posted to the general ledger. Utilizing the ERP platform, analyze detail, and compile data for selected federal, state, and private programs regularly scheduled reports. Prepare monthly, quarterly, and annual financial reports for other federal programs. Coordinate the timely filing of accurate reports to appropriate external agencies. Perform system development tests for ERP system patches and upgrades. Create and monitor ERP system case support tickets. Provide support and assistance in maintaining the accounting records and reports for the Cherry Creek Schools Foundation. Utilizing ERP system reports, assist with the preparation of the Foundation’s annual financial audit. Work in partnership with the Grants team in formulating budgets for the Grants programs. Provide accurate analysis and data collected from the ERP system, including calculated account totals. Forecast remaining grant activity and project balances for district administration and Grant personnel. Projects and Bond Assignment Manage the district’s capital projects activities system within the ERP platform to ensure the accurate accounting for the reporting of capital construction projects and capital assets and compliance with debt requirements and Board policies. Determine the value of capital asset additions, disposals, and adjustments, and record them in accordance with Generally Accepted Accounting Principles (GAAP). Stay abreast of the requirements and best practices of financial and accounting compliance related to capital project activities and capital assets. Keep department and school staff appraised of GAAP. Provides professional consulting, training, advising, directing, and mentoring services to district personnel related to capital/operating projects, fixed assets and debt related to such projects and/assets. Prepare monthly, quarterly and annual capital asset reports and end‑year capital asset financial audit schedules. Work in partnership with external auditors and provide data analysis as required, including work papers, schedules, and access to accounting records for federal, state, and private programs. Participate in formulating budgets for the capital project programs, including checking details and calculating account totals. Assist with forecasting remaining capital project activity and project balances for district administration and other personnel. Maintain ERP accounting system databases, tables, and programs. Test the ERP system patches and upgrades in relation to FA (Fixed Assets), PPM (Project Portfolio Management), and GL (General Ledger) modules. Create and monitor ERP system case support tickets. Perform monthly close process for the applicable modules in the ERP system. Maintain district’s financial leases. Perform monthly reconciliation on fixed asset accounts, ensuring all transactions are posted to the general ledger. Prepare and input correcting journal entries resulting from analysis of such accounting information. Monitor, analyze and report the capital project accounting activities. Create monthly reconciliation reports on capital project accounts, ensuring all transactions are posted to the general ledger. Assist district personnel with maintenance of physical inventory and tracking of assets. Projects and Fixed Assets Assignment Manage the district’s capital projects activities system within the ERP platform to ensure the accurate accounting for the reporting of capital construction projects and capital assets. Determine the value of capital asset additions, disposals, and adjustments, and record them in accordance with Generally Accepted Accounting Principles (GAAP). Stay abreast of the requirements and best practices of financial and accounting compliance related to capital project activities and capital assets. Keep department and school staff appraised of GAAP. Provides professional consulting, training, advising, directing, and mentoring services to district personnel related to capital/operating projects and fixed assets. Participate in formulating budgets for the capital project programs, including checking details and calculating account totals. Assist with forecasting remaining capital project activity and project balances for district administration and other personnel. Maintain ERP accounting system databases, tables, and programs. Test the ERP system patches and upgrades in relation to FA (Fixed Assets), PPM (Project Portfolio Management), and GL (General Ledger) modules. Create and monitor ERP system case support tickets. Perform monthly close process for the applicable modules in the ERP system. Maintain district’s financial leases. Perform monthly reconciliation on fixed asset accounts, ensuring all transactions are posted to the general ledger. Prepare and input correcting journal entries resulting from analysis of such accounting information. Monitor, analyze and report the capital project accounting activities. Create monthly reconciliation reports on capital project accounts, ensuring all transactions are posted to the general ledger. Assist district personnel with maintenance of physical inventory and tracking of assets. Prepare annual capital asset reports and end‑year capital asset financial audit schedules. Reporting Relationships This job has no direct supervisory responsibilities. Minimum Qualifications Criminal background check and fingerprinting required Bachelor's degree in accounting or similar field Three (3) years of accounting, accounts payable, accounts receivable, banking, bookkeeping, budget, or financial planning and analysis experience Demonstrated passion for education Intermediate knowledge of accounting (e.g., posting, account reconciliation, account analysis) Intermediate analytical skills, including statistical analysis and the use of spreadsheets Intermediate critical thinking, problem solving, and organizational skills Strong written and oral communication skills Intermediate Microsoft Office skills, with emphasis on Excel Ability to operate a ten-key adding machine Ability to be flexible and adjust to changing priorities Ability to work independently and collaboratively with others Physical Requirements and Working Conditions Light work strength level (lifting or carrying up to 25 pounds) Primarily works indoors Sedentary work Frequent bending, reaching, and lifting Eye/hand coordination (e.g., typing, ten key) Visual concentration on equipment Concentrated reading/writing/mathematics Normal office environment Normal school district environment Work location is subject to change to meet the requirements of the organization Desired Qualifications Experience working in public education Experience working with Oracle software Experience working directly with people from diverse racial, ethnic, and socioeconomic backgrounds Racially conscious and culturally competent with the skill, will, capacity, and knowledge to commit to a culture of continuous improvement Impeccable attention to detail #J-18808-Ljbffr Cherry Creek School District