Staff Accountant

University of Minnesota Twin Cities; Minneapolis (MN); Remote; USD 55,000 - 75,000; Full time

Job summary

The University of Minnesota Twin Cities seeks a Staff Accountant to manage financial oversight and analysis for their Community University Health Care Center. This remote position involves reviewing expenses, reconciling accounts, and ensuring compliance with policies, suitable for someone with strong accounting skills and attention to detail.

Qualifications

• BA/BS plus 4 years in accounting/finance or 8 years of related experience.
• Proficiency with Excel including formulas and pivot tables.
• High level financial customer service experience.

Responsibilities

• Approve financial transactions and maintain charts of accounts.
• Collaborate on annual budget preparation and run fiscal year-end close accounting.
• Prepare comprehensive and ad hoc reporting for various stakeholders.

Skills

Proficiency in Microsoft Excel

Customer service

Detail orientation

Education

BA/BS in Accounting or Finance

Job description

Position Overview
The Staff Accountant will provide financial management, oversight, analysis, and guidance to the Community University Health Care Center (CUHCC). Located in south Minneapolis, CUHCC is the first and oldest community health center, providing medical care, dental care, mental health care and social services to people of all ages and income levels.

Job duties include: review and approval of expenses, assigning payroll allocations, advising clinical and administrative staff on policy and processes, creating reports, reconciling and forecasting financials, resolving discrepancies, and post-award grant and foundation accounting. A self-starter with in-depth knowledge of accounting principles and the ability to interpret contracts and University policies will thrive in this role.

This position is a primarily remote position, with the occasional need to work in-person. This may change in the future based on business needs.

Job Responsibilities
ACCOUNTING ACTIVITIES â“ 55%

• Maintain CUHCC's chart of accounts in accordance with University and College policy, clearly communicating chartfield strings to relevant staff and regularly reviewing transactions to resolve discrepancies and process corrections.
• Approve financial transactions in PeopleSoft, ensuring accuracy and adherence to University policies and procedures.
• Request invoices to ensure accurate, timely billings to customers for non-sponsored receivables.
• Convert modified accrual-based accounting from PeopleSoft to accrual-based accounting for month-end financial reporting, maintaining documentation to be used by the organization for reporting and compliance needs.
• Review all revenue accounts on a monthly basis to make sure revenue is recognized accurately based on revenue recognition principles and deferred revenue (unearned) is well documented and tracked for future revenue recognition.
• Monthly reconciliation of OCHIN Epic and PeopleSoft financial systems, identifying any discrepancies, making corrections and improving workflows as needed.
• Collaborate with Accounts Receivable to make the necessary journal entries and reconciliations for Bad Debt, the Allowance for Uncollectible Accounts and Write Offs, ensuring that OCHIN Epic aligns with the General Ledger in EFS.
• Run fiscal year end close accounting processes, reconciling revenue and expense accounts for accuracy, and testing for discrepancies between source system (PeopleSoft) and finalized financial reports.
• Work with financial analyst on annual budget preparation, inputting the detailed and position budgets into EFS and closing out chartfield strings as needed.
  Special projects as assigned.

FUND ACCOUNTING â“ 25%

• Maintain monthly tracking of all grant awards that would demonstrate the grant amount awarded, expenses and encumbrances to date, remaining balances related to the awarded amount within the grant period, and the amount of revenue to be recognized in the accounting period, fiscal year to date, and award to date.
• Serve as the point person / liaison to SPA, SFR and PIs/CUHCC grant project managers for accounting during post-award, developing PS-friendly budgets, rebudgets, processing retro distributions and payroll distribution changes in EFS, preparing manual statements and approving effort in ECRT.
• Work closely with finance and development to ensure that all grant awards and gifts are accurately stated for financial presentation and recognition, and monitor expenditures for donor, sponsor and University compliance.
• Maintain foundation chart of accounts, requesting foundation billings, closing foundation funds in DMS and creating new CFS for new foundation funds as needed.

OTHER REPORTING â“ 20%

• Prepare comprehensive, customized, routine, and ad hoc reporting and forecasting from a variety of sources for University, college, and unit leadership, PIs and Grant Managers, as needed. Collaborate with partners to interpret data and to make recommendations and observations.
• Analyze financial data for anomalies, identify gaps in revenue and/or expenses, investigate and recommend solutions. Develop and present projections, forecasting and trending to inform and advise key partners.
• Support 340B oversight team with reconciliations and reporting related to drug costs and associated revenue.
• Support the financial reporting for the completion of the Uniform Data System annual report (calendar year) based on accrual based accounting.
• Prepare revenue/expense schedules to support Medicare Cost Report completion (fiscal year) based on accrual based accounting and provide ongoing support for Medicare Cost
• Report completion.
• Other reporting as needed.

All required qualifications must be included in the application materials

Required Qualifications:

• BA/BS plus at least 4 years of work experience in an accounting/finance setting or a combination of related education and work experience totaling eight (8) years.
• Proficiency/experience with Microsoft Excel (formulas, pivot tables, vlookup, etc.).
• At least two years of work experience delivering high level financial customer service including proactive communication and ability to troubleshoot and resolve issues.

Preferred Qualifications:

• Certified approver or equivalent experience working with grants.
• High level of attention to detail and capability to handle several tasks with overlapping deadlines; can re-prioritize tasks as needed.
• Experience to include reconciliations, fund accounting, and web-based enterprise financial and payroll systems.
• Advanced computer skills including spreadsheet development and maintenance using Microsoft Excel and web database reporting.
• Self-starter, able to work independently in a dynamic team environment that requires flexibility and excellent problem solving skills.