INTERNSHIP DETAILS

Fiscal College Intern (PN 20093158)

CompanyOhio Department of Administrative Services
LocationColumbus
Work ModeOn Site
PostedApril 9, 2026
Internship Information
Core Responsibilities
The intern will assist in the preparation and submission of Medicaid cost reports and financial claims. They will also support revenue and expenditure tracking, perform bank reconciliations, and analyze fiscal data using advanced Excel and OAKS tools.
Internship Type
full time
Company Size
28250
Visa Sponsorship
No
Language
English
Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page

About The Company
Employment with the State of Ohio is more than ‘just a job’ – it is a privilege to serve our families, friends and neighbors who rely on us throughout our great state. We are a team of dedicated public servants committed to high performance, innovative thinking, and delivering excellent and efficient services. Our goal is to recruit and retain the best talent for our positions, because when we have the best talent, we get the best results for our community. We are #TeamOhio.
About the Role

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

 

 



Required Qualifications:

  • Must be enrolled in an accredited college or university   
Key Skills
Medicaid Cost ReportsFinancial AnalysisExcelQuickBooksBank ReconciliationData AnalysisRevenue TrackingExpenditure TrackingFinancial ReportingOAKS Business IntelligenceGeneral LedgerVouchersEncumbrancesCash Flow ForecastingTechnical Support
Categories
Finance & AccountingGovernment & Public SectorAdministrative