<div dir="ltr">Hi Sergio,<div><br></div><div>At UCB we can't rely on the I-158 file because many of our DR/SCTs did not produce ALTACCT codes and as such did not make it into the I-158. So, we are using our Labor Leger and General Ledger to source the data. We have decided to report earnings in the month they hit the ledger, so SCTs and/or late pays will be counted in the month they are processed, not in the month for the associated pay period. We realize we may be out of sync with the W2, but short of doing a detailed review of each student it does not seem avoidable. We populate our FISAP report in a similar manner, so our COD report should mimic the FISAP. We are currently running our COD methodology by semester so we can combine Spring22 and following Fall22 reports and then compare to our corresponding FISAP. This is messy. </div><div><br></div><div>Steve<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Oct 3, 2023 at 8:23 PM Sergio Ramirez <<a href="mailto:saramire@uci.edu">saramire@uci.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg6484360314392493978">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_6484360314392493978WordSection1">
<p class="m_6484360314392493978MsoNoSpacing">Hi everyone,<u></u><u></u></p>
<p class="m_6484360314392493978MsoNoSpacing"><u></u> <u></u></p>
<p class="m_6484360314392493978MsoNoSpacing">I apologize in advance for this lengthy inquiry. I wanted to circle back to a couple of scenarios I brought up at the last WS and FISCAL meeting regarding the reporting of 2022 work-study earnings to COD. At Irvine, we are using the
data from the I-158 UCPath payroll file and isolating applicable pay periods & associated federal work-study earnings that will be reported on an employee’s 2022 W-2 form. For campuses that are using the same method for the COD reporting, how are you handling
Direct Retro/late reporting transactions that impact earnings from a 2022 calendar year pay period, but the Direct Retro/late reporting was processed in calendar year 2023? For example:<u></u><u></u></p>
<p class="m_6484360314392493978MsoNoSpacing"><u></u> <u></u></p>
<p class="m_6484360314392493978MsoNoSpacing"><b>Scenario 1:<u></u><u></u></b></p>
<p class="m_6484360314392493978MsoNoSpacing">A student employee has a federal work-study award and was paid $100 for the bi-weekly pay period ending on 11/26/2022. On their 2022 W-2 form, these $100 in work-study earnings are accounted for. In March of 2023, still within the same
fiscal/academic year of 2022-23, the hiring department process a Direct Retro. The Direct Retro reverses the initial transaction for the pay period ending on 11/26/2022 and credits the work-study fund and charges the entire earnings of $100 on department accounts.
My questions are:<u></u><u></u></p>
<ul style="margin-top:0in" type="disc">
<li class="m_6484360314392493978MsoNoSpacing">For the calendar year 2022 FWS reporting to COD, what will you report?<u></u><u></u></li><ul style="margin-top:0in" type="circle">
<li class="m_6484360314392493978MsoNoSpacing">Would you report the original earnings paid out in calendar year 2022, as reflected on the employee’s 2022 W-2 form?<u></u><u></u></li><ul style="margin-top:0in" type="square">
<li class="m_6484360314392493978MsoNoSpacing">If so, how will you handle the Direct Retro adjustment in 2024 for the calendar year 2023 earnings reporting?<u></u><u></u></li><ul style="margin-top:0in" type="disc">
<li class="m_6484360314392493978MsoNoSpacing">Will the student’s status (i.e., continuing) determine if you report the DR entry in CY2023? What if the final reporting is a negative amount due to the DR if there are no other work-study earnings in
CY2023 for the student?<u></u><u></u></li></ul>
</ul>
<li class="m_6484360314392493978MsoNoSpacing"><b>OR</b> do you take into account the Direct Retro processed in 2023 and backout the amount from your calendar year 2022 federal work-study earnings you will report to COD?<u></u><u></u></li></ul>
</ul>
<p class="m_6484360314392493978MsoNoSpacing"><u></u> <u></u></p>
<p class="m_6484360314392493978MsoNoSpacing"><b>Scenario 2<u></u><u></u></b></p>
<p class="m_6484360314392493978MsoNoSpacing">A student employee forgot to submit their timesheet for hours worked for the bi-weekly pay period ending on 11/26/2022. It is now March 2023, still within the same fiscal/academic year of 2022-23, and the hiring department process $100
in earnings for the missing hours in November of 2022. Since these earnings were not paid to the employee in 2022, the earnings will not appear on the employee’s 2022 W-2 form. In this scenario, my questions are:<u></u><u></u></p>
<ul style="margin-top:0in" type="disc">
<li class="m_6484360314392493978MsoNoSpacing">For the calendar year 2022 FWS reporting to COD, what will you report?<u></u><u></u></li><ul style="margin-top:0in" type="circle">
<li class="m_6484360314392493978MsoNoSpacing">Will you exclude the $100 in earnings for 2022?<u></u><u></u></li><ul style="margin-top:0in" type="square">
<li class="m_6484360314392493978MsoNoSpacing">If so, will you then report the earnings in the calendar year 2023 submission since the earnings were paid to the student employee in 2023 for the hours worked in 2022?<u></u><u></u></li></ul>
<li class="m_6484360314392493978MsoNoSpacing"><b>OR</b> do you include the 2022 earnings with your 2022 calendar year work-study earnings COD submission despite the earnings not appearing on the employee’s 2022 W-2 form?<u></u><u></u></li></ul>
</ul>
<p class="m_6484360314392493978MsoNoSpacing"><u></u> <u></u></p>
<p class="m_6484360314392493978MsoNoSpacing">These scenarios came up during our internal meetings and we are having conflicting opinions on how to approach these scenarios that are taking place. We wanted to check in with the group to see if similar scenarios were discussed at
other campuses and what approach was taken.<u></u><u></u></p>
<p class="m_6484360314392493978MsoNoSpacing"><u></u> <u></u></p>
<p class="m_6484360314392493978MsoNoSpacing">Thanks,<u></u><u></u></p>
<p class="m_6484360314392493978MsoNoSpacing">Sergio<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span>Sergio A. Ramirez<u></u><u></u></span></p>
<p class="MsoNormal"><span>Associate Director, Finance & Human Resources<u></u><u></u></span></p>
<p class="MsoNormal"><span>Office of Financial Aid & Scholarships<u></u><u></u></span></p>
<p class="MsoNormal"><span>102 Aldrich Hall<u></u><u></u></span></p>
<p class="MsoNormal"><span>University of California, Irvine<br>
Irvine, CA 92697-2825<u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><span>Phone: 949-824-5339<u></u><u></u></span></p>
<p class="MsoNormal"><span>FAX: 949-824-4876</span><span style="font-size:10pt"><br>
</span><span>email: <a href="mailto:saramire@uci.edu" target="_blank">
<span style="color:rgb(5,99,193)">saramire@uci.edu</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span><a href="http://www.ofas.uci.edu/" target="_blank"><span style="color:rgb(5,99,193)">www.ofas.uci.edu</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
</div>
</div>
_______________________________________________<br>
Ucwsfiscal mailing list<br>
<a href="mailto:Ucwsfiscal@lists.ucmerced.edu" target="_blank">Ucwsfiscal@lists.ucmerced.edu</a><br>
<a href="https://lists.ucmerced.edu/mailman/listinfo/ucwsfiscal" rel="noreferrer" target="_blank">https://lists.ucmerced.edu/mailman/listinfo/ucwsfiscal</a><br>
</div></blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><font size="2">Steve McCabe<br>Senior Business Systems Analyst</font></div><div><font size="2">University of California Berkeley</font></div><div><font size="2">Financial Aid and Scholarships Office</font></div><div><font size="2"><a href="mailto:smccabe@berkeley.edu" target="_blank">smccabe@berkeley.edu</a><span title="Call with Google Voice"><span title="Call with Google Voice"><span title="Call with Google Voice"><br></span></span></span></font></div><div><a href="http://financialaid.berkeley.edu/" target="_blank">financialaid.berkeley.edu/</a><br></div><div><br></div><div><font size="2"><span title="Call with Google Voice"><br></span></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>