Fiscal College Intern (PN 20093158)

Ohio Department of Administrative ServicesColumbus, OH

About The Position

What will you do? Assist in preparation and submission of Medicaid Cost Reports, including interim and final rate calculations Collaborate with the Department of Medicaid to incorporate audit adjustments and negotiate final settlements Support developmental center cost report settlements and related financial processes Retrieve and process monthly remittance advices using MITS Prepare and submit Medicaid claims via Excel and MITS for payment processing Assist with review and analysis of fiscal records and financial data Provide technical support for QuickBooks, including managing internal funds and accounts Support revenue and expenditure tracking, analysis, and reporting for internal accounts Help prepare and submit required state and federal financial reports Reconcile QuickBooks balances with legacy systems (DCIMS/Excel) and bank statements Prepare bank reconciliation reports across multiple accounts Generate and balance financial reports using OAKS Business Intelligence tools (e.g., general ledger, vouchers, encumbrances, cash balances) Use advanced Excel functions to create reports, analyze data, and forecast revenue, expenditures, and cash flow

Requirements

  • Must be enrolled in an accredited college or university

Responsibilities

  • Assist in preparation and submission of Medicaid Cost Reports, including interim and final rate calculations
  • Collaborate with the Department of Medicaid to incorporate audit adjustments and negotiate final settlements
  • Support developmental center cost report settlements and related financial processes
  • Retrieve and process monthly remittance advices using MITS
  • Prepare and submit Medicaid claims via Excel and MITS for payment processing
  • Assist with review and analysis of fiscal records and financial data
  • Provide technical support for QuickBooks, including managing internal funds and accounts
  • Support revenue and expenditure tracking, analysis, and reporting for internal accounts
  • Help prepare and submit required state and federal financial reports
  • Reconcile QuickBooks balances with legacy systems (DCIMS/Excel) and bank statements
  • Prepare bank reconciliation reports across multiple accounts
  • Generate and balance financial reports using OAKS Business Intelligence tools (e.g., general ledger, vouchers, encumbrances, cash balances)
  • Use advanced Excel functions to create reports, analyze data, and forecast revenue, expenditures, and cash flow
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service