ODJFS Report
ODJFS Report Overview
If the ODJFS Reportable box was not checked on the Employee Screen before the employee was paid, an adjustment will need to be made in order for them to be included on the report. Using the CORE/Adjustments, add the ODJFS Total Gross and ODJFS Weeks.
The ODJFS Report program generates a report of the number of weeks worked, wages, and ODJFS taxable wages for each employee for the quarter. This information is required for unemployment wages reporting. Run this program as part of the quarter end processing procedure. This report should be run first and the information verified before a submission file is created.
This program is used by the System Manager to generate the ODJFS Form JFS 66117, Transmitter Report of Magnetic Media. This report along with the ODJFS magnetic media is forwarded to the Ohio Department of Job and Family Services on or before the 28th day of the month following the end of the quarter being processed.
The files created by districts using the ODJFS Report program are named ODJFS.YYQ#, where YY refers to the last two digits of the reporting year and Q# refers to the quarter number being processed. For example, the file for the First quarter of the 2018 reporting year would be called ODJFS.18Q1.
The ODJFS taxable wage base is $9,000.00 beginning 2020 to current.
Report uses Legal Name on Employee screen, if entered. If no Legal Name is entered, it uses the Name fields.
Creating an ODJFS Report for ITC's to submit
The Save and Recall option , allows the users to create and save certain reports for different report runs for each report option. The Default option is the original SSDT report and the Most Recent is the last report that was ran by the user. If the report is no longer needed, click on to delete the report. The Default reports cannot be deleted.
Select a Report Output Format from the drop-down option:
PDF (download)
Comma Separated Values
Excel-Data
Select correct Year from drop down option
Select Quarter from drop down option
1st Quarter (January - March)
2nd Quarter (April - June)
3rd Quarter (July - September)
4th Quarter (October - December)
Choose how you want to Sort By the report from the drop down option
Employee ID
Employee Name
Click the
button
How to correct an employee's QTD ODJFS Wages and # of Weeks
Verify employee wages and weeks. If corrections are needed, go to CORE/ADJUSTMENT and use the Type ODJFS Total Gross to correct the employee's QTD ODJFS Wages and YTD Taxable Wages and ODJFS Weeks to correct the # of Weeks. Once corrected, run ODJFS Report again.
Once all data has been verified, click on to create the ODJFS Submission File to be uploaded to ERIC
Example of Ohio Department of Job and Family Services Quarterly Wage Report
Example of ODJFSxxQx for ITC's to submit file for districts
District creating and submitting own ODJFS Submission File
If district is submitting own submission file, enter in information and click on . When submitting through the SOURCE, you will want to choose ICESA source option.
Enter in the required fields:
Transmitter's Name
Transmitter's Phone Number
Transmitter's Email
Example of ODJFSxxQx.TXT file for Districts to submit
How ODJFS calculates Weeks for Reporting
The Job Calendars for employees which correspond to the calendar date range of the quarter are entered into blank working calendars. Blank working calendars are used internally by the system and cannot be viewed. The Attendance transaction types AT or AB for the same date range are marked on working calendars appropriately for each day. The calendars are "modified" inside the program to reflect the days from the calendars plus days from Attendance. So, you can think of Attendance records as modifying the calendars on a per employee (or job) basis.
After the working calendars are built, the system counts the weeks for the quarter and that is the total unadjusted qualifying weeks. A qualifying week is any week in which an employee has worked at least part of a day. For ODJFS purposes, a week is counted if the Saturday following it falls within the reporting quarter. The maximum number of weeks for any quarter is the number of Saturdays contained within it. This maximum may vary for each quarter of the year.
The Quarter date range is calculated by:
To find the Start date, they system starts with the quarter date range and finds the first Saturday of the quarter. The Start date is then set to the preceding Sunday of the first Saturday of the month.
To find the Stop date, the system uses the last Saturday of the month of the stop date of the quarter.
Example:
1st Quarter 2019: 01/01/2019 - 03/31/19. The system will use the date range of 12/30/2019 - 03/30/19 to locate the count of weeks.
Once it has the date range then it finds the ODJFS days from calendars, attendance, and all docks. The system then goes through all entries and adds the week of the year to a list checking for duplicates. This ensures no two weeks are counted twice. Then the system adds any Core>Adjustments>ODJFS Weeks to arrive at the final total. Adjustment transactions entered can be considered manual adjustments to what the system would calculate. Note that "manual adjustment" transactions are picked up based on the reporting quarter. Any Adjustment dated within the quarter will be applied. The manual adjustment records are a bit different than attendance day entries because they are not for specific weeks. In this case, you are just adjusting the total qualifying weeks for the quarter. The Adjustments (if any) are added to or subtracted from the total unadjusted qualifying weeks. These are the total qualifying weeks that will appear on ODJFS Report.
Items to Consider:
ODJFS Report does not look at the Archive status of an employee. Archived employees will still be reported.
ODJFS Report looks at the Compensation>Historical Context>Calendar Start Date and Calendar Stop Date to determine week counts.
A Calendar Stop Date should be entered once the employee is no longer employed.
If an employee's Compensation>Compensation Start Date and Compensation Stop Date fall within the quarter being reported, the employee will be included.
If one or both dates are missing and the employee is on a Job Calendar and no Calendar Stop date is entered, they can be included on the ODJFS report with weeks. Verify each employee's position and add a Calendar Stop Date.