<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@DengXian";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.m6484360314392493978msonospacing, li.m6484360314392493978msonospacing, div.m6484360314392493978msonospacing
{mso-style-name:m_6484360314392493978msonospacing;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:707489283;
mso-list-template-ids:1847908112;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:806892082;
mso-list-template-ids:-407054014;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Thank you Sergio, Steve. Davis is in the same position trying to decide what to do with these 2 scenarios. This is what we are trying to do now: scenario 1 if we can see the earning was pulled back in the following calendar year we do not
plan to report the earning so we don’t have to figure out what to do with negatives the following calendar year. For scenario 2, we plan to report in 2023 calendar year. We didn’t use I158. We got something similar to payroll ledger but with a check date (actual
pay date). I asked for award year 2122 and 2223 so I can look those special cases up. time permits, we decide to generally reconcile with FISAP in the end. With fast approaching deadlines and we are right in middle of transitioning to CoA and Oracle, this
is a pretty big challenge. But I’m afraid if we don’t tackle it now, it comes back to haunt us next year, so at least give it a try……<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I wonder if we should ask OP provide guidance as what UC wants to do consistently.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#001237">Catherine Li</span></b><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#001237">Associate Director</span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1D1D1D"> || </span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#001237">Financial
Aid and Scholarships</span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1D1D1D"> </span></b><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">p. 530-752-6904 | c. 530-400-6274 | w.
<a href="https://financialaid.ucdavis.edu/">financialaid.ucdavis.edu</a> | e. <a href="mailto:ycli@ucdavis.edu">
ycli@ucdavis.edu</a> </span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">One Shields Avenue, Davis, CA 95616 </span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> Steven McCabe <smccabe@berkeley.edu> <br>
<b>Sent:</b> Wednesday, October 4, 2023 4:04 PM<br>
<b>To:</b> UC WS and Fiscal Workgroup <ucwsfiscal@lists.ucmerced.edu><br>
<b>Subject:</b> Re: [Ucwsfiscal] Questions on reporting FWS earnings to COD<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Sergio,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Steve<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Oct 3, 2023 at 8:23 PM Sergio Ramirez <<a href="mailto:saramire@uci.edu">saramire@uci.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class="m6484360314392493978msonospacing">Hi everyone,<o:p></o:p></p>
<p class="m6484360314392493978msonospacing"> <o:p></o:p></p>
<p class="m6484360314392493978msonospacing">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:<o:p></o:p></p>
<p class="m6484360314392493978msonospacing"> <o:p></o:p></p>
<p class="m6484360314392493978msonospacing"><b>Scenario 1:</b><o:p></o:p></p>
<p class="m6484360314392493978msonospacing">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:<o:p></o:p></p>
<ul type="disc">
<li class="m6484360314392493978msonospacing" style="mso-list:l1 level1 lfo1">For the calendar year 2022 FWS reporting to COD, what will you report?<o:p></o:p></li></ul>
<ul type="disc">
<ul type="circle">
<li class="m6484360314392493978msonospacing" style="mso-list:l1 level2 lfo1">Would you report the original earnings paid out in calendar year 2022, as reflected on the employee’s 2022 W-2 form?<o:p></o:p></li></ul>
</ul>
<ul type="disc">
<ul type="circle">
<ul type="square">
<li class="m6484360314392493978msonospacing" style="mso-list:l1 level3 lfo1">If so, how will you handle the Direct Retro adjustment in 2024 for the calendar year 2023 earnings reporting?<o:p></o:p></li></ul>
</ul>
</ul>
<ul type="disc">
<ul type="circle">
<ul type="square">
<ul type="disc">
<li class="m6484360314392493978msonospacing" style="mso-list:l1 level4 lfo1">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?<o:p></o:p></li></ul>
</ul>
</ul>
</ul>
<ul type="disc">
<ul type="circle">
<li class="m6484360314392493978msonospacing" style="mso-list:l1 level2 lfo1"><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?<o:p></o:p></li></ul>
</ul>
<p class="m6484360314392493978msonospacing"> <o:p></o:p></p>
<p class="m6484360314392493978msonospacing"><b>Scenario 2</b><o:p></o:p></p>
<p class="m6484360314392493978msonospacing">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:<o:p></o:p></p>
<ul type="disc">
<li class="m6484360314392493978msonospacing" style="mso-list:l0 level1 lfo2">For the calendar year 2022 FWS reporting to COD, what will you report?<o:p></o:p></li></ul>
<ul type="disc">
<ul type="circle">
<li class="m6484360314392493978msonospacing" style="mso-list:l0 level2 lfo2">Will you exclude the $100 in earnings for 2022?<o:p></o:p></li></ul>
</ul>
<ul type="disc">
<ul type="circle">
<ul type="square">
<li class="m6484360314392493978msonospacing" style="mso-list:l0 level3 lfo2">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?<o:p></o:p></li></ul>
</ul>
</ul>
<ul type="disc">
<ul type="circle">
<li class="m6484360314392493978msonospacing" style="mso-list:l0 level2 lfo2"><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?<o:p></o:p></li></ul>
</ul>
<p class="m6484360314392493978msonospacing"> <o:p></o:p></p>
<p class="m6484360314392493978msonospacing">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.<o:p></o:p></p>
<p class="m6484360314392493978msonospacing"> <o:p></o:p></p>
<p class="m6484360314392493978msonospacing">Thanks,<o:p></o:p></p>
<p class="m6484360314392493978msonospacing">Sergio<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Sergio A. Ramirez<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Associate Director, Finance & Human Resources<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Office of Financial Aid & Scholarships<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">102 Aldrich Hall<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">University of California, Irvine<br>
Irvine, CA 92697-2825<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Phone: 949-824-5339<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">FAX: 949-824-4876<span style="font-size:10.0pt"><br>
</span>email: <a href="mailto:saramire@uci.edu" target="_blank"><span style="color:#0563C1">saramire@uci.edu</span></a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="http://www.ofas.uci.edu/" target="_blank"><span style="color:#0563C1">www.ofas.uci.edu</span></a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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" target="_blank">https://lists.ucmerced.edu/mailman/listinfo/ucwsfiscal</a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span class="gmailsignatureprefix">-- </span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Steve McCabe<br>
Senior Business Systems Analyst</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">University of California Berkeley</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Financial Aid and Scholarships Office</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="mailto:smccabe@berkeley.edu" target="_blank">smccabe@berkeley.edu</a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://financialaid.berkeley.edu/" target="_blank">financialaid.berkeley.edu/</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>