OBJECTIVE/OVERVIEW: Perform all accounting duties to include, but not limited to: preparing financial statements, reviewing general ledgers, payroll, financial analysis, and various financial reports for external regulatory agencies. Work with the development team, SPA, and SFR to complete all designated tasks dealing with grants, as well as the effort coordinator for effort certification. Work out of the multiple accounting systems at the University in order to complete all tasks involved in reconciliations, budget preparations, spreadsheet utilizations, and payroll information. Work with multiple departments to fulfill the University’s and the Community-University Health Care Center’s missions.
Spreadsheets/Charts/Other Projects (25%) • Compile, prepare and submit the Medicare Cost report (CMS-224-14). • Work with senior management in the development of payroll and operational expense budgets. • Prepare and submit the annual Peoplesoft budget for non-sponsored transactions. • Assist with the compilation, preparation and submission of the Uniform Data Systems report required of Federally Qualified Health Care Centers. • Create spreadsheets for tracking monthly/yearly visit counts for the clinic, and create charts representing the monthly visits • Run the lab reports for customer bills to identify which customers have insurance or do not and work with billing to administer the correct invoices to customers • Work with external systems required for completing various projects or monthly activities due to CUHCC working with external sales. These systems include but are not limited to Data Link, Instamed, and 340B Prime Vendor Program.
Reconciliations (25%) • Update records and auditing/balancing multiple entities including but not limited to: proof of cash, non-sponsored fund accounts, projects, payroll (monetary value, sick/vacation balances), cost of operations, other income, and other various items that come up from daily operations • Ensure all items are being accounted for properly, identity problems and resolve them, check for inappropriate activity including kiting, and identifying items affecting incorrect accounts • Proof of cash – balancing all bank statements, lockbox, batch statuses, payment information, and physical deposits to each other to ensure all items are clearing correctly and to identify any errors that can be missed intentionally or unintentionally. Work with billing and scheduling throughout process • Fund accounts – monthly reconciliation of the multiple fund accounts used by CUHCC
Grants/Projects (25%) • Work with sponsored projects from proposal to closure. This includes working with the development team to find individuals available to work on the project, create budget, maintain the integrity of the project for the duration of the project by monitoring the efforts given to the projects by the employees working on it, identifying the correct expenses are being made, making sure the grants are being spent down correctly and timely, and then at the conclusion of the project period, making sure all items attributed to the project are correctly applied and the project has the appropriate balance • Working with SPA regarding opening of new budgets in PeopleSoft, account field discrepancies, and the closing processes of projects • Effort Coordinator – maintaining the ethics of each sponsored projects’ requirements involving the efforts given towards each projects’ goals. This includes working with each projects’ coordinators to ensure that all efforts are given towards each project is accurate and if it is indeed not, then take necessary avenues to correct discrepancies
Financial Reporting/Charts (15%) • At month end closings, pull reports out of various accounting systems and mold them into one spreadsheet to create the financial reports for the health care center. Reconcile the month’s end entries and identify if there are any abnormalities from month to month. Look through the general ledger to identify items recorded in incorrect chart strings and notify the appropriate individuals to have the items corrected • Assist with the creation of the financial statements and upon completion, review and create distribution copies for all parties interested • The reports come from UM Reports, Data Warehouse, EFS-Financial Reporting, Image Now
Other duties as assigned (10%)
All required qualifications must be documented on application materials.
Required Qualifications: -BA/BS plus at least four years of professional work experience or a combination of related education and work experience to equal eight years.
Preferred Qualifications: -Strong technical skills that will facilitate creative processes that will promote the efficiencies needed to manage increased responsibilities and demanding workload. -Experience with PeopleSoft -Experience with Sponsored Project Administration
Internal Number: 339379
About University of Minnesota, Twin Cities
The University of Minnesota, founded in the belief that all people are enriched by understanding, is dedicated to the advancement of learning and the search for truth; to the sharing of this knowledge through education for a diverse community; and to the application of this knowledge to benefit the people of the state, the nation, and the world.