<div dir="ltr"><div><font size="4">Hello,</font></div><div><font size="4"><br></font></div><div><font size="4">FYI that we have noticed some Labor Leger (an associated GL) issues related to an attempt by UCOP in late December to pull back some FICA charges for CY23:</font></div><div><ul><li style="margin-left:15px"><font size="4">In same cases, if two chartstrings were originally used for a single employee for an impacted pay period (e.g. a Department line and a Workstudy line), the reversal step of the  "Special YE Run FICA" process reversed the two original debits but only created a single credit for the sum of the two; then the reissue part of the process created two new debits using the original chartstrings and amounts</font></li><ul><li style="margin-left:15px"><font size="4">this appears to have created fund balances out of sync with the beginning state</font></li><li style="margin-left:15px"><font size="4">not all of reversals behaved this way it appears, so thats good </font></li></ul></ul><div><font size="4">Here is another review of one use case:</font></div></div><div><span id="m_5748217832151347684gmail-docs-internal-guid-a0f3a109-7fff-eb17-a685-a0bdc72b0364"><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:circle;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">PayPeriod 7/23/23 - 8/5/23 (for a single student)</span></p></li><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:square;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Earnings Total = $36.14</span></p></li><li style="margin-left:36pt;list-style-type:square;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Original LL lines that reflect a Workstudy split</span></p></li><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">$10.84 on the department fund (55931)</span></p></li><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">$25.30 on the workstudy fund (23505)</span></p></li><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="background-color:transparent;font-size:11pt">These have the </span>ALTACCT<span style="background-color:transparent;font-size:11pt"> codes and did update the WS balance in UCPath</span></p></li><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="background-color:transparent;font-size:11pt">Posted to GL 8/31/23 as part of normal pay compute</span><br></p></li></ul><li style="margin-left:36pt;list-style-type:square;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">New LL lines generated per “Special YE Run FICA” (</span><span style="background-color:transparent;font-size:11pt">part of the same 'journal'</span><span style="background-color:transparent;font-size:11pt">)</span></p></li><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Paycheck reversal</span></p></li><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:circle;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">-$36.14 on the department fund (55931)</span></p></li><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:square;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">No ALTACCT Codes so did NOT update the WS balance in UCPath</span></p></li></ul></ul><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Paycheck re-issue</span></p></li><ul style="margin-top:0px;margin-bottom:0px"><li style="margin-left:36pt;list-style-type:circle;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">$10.84 on the department fund (55931)</span></p></li><li style="margin-left:36pt;list-style-type:circle;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">$25.30 on the workstudy fund (23505)</span></p></li><li style="margin-left:36pt;list-style-type:circle;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">These have the ALTACCT codes so did update the WS balance (again)</span></p></li></ul><li style="margin-left:36pt;list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><p role="presentation" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Both the reversal and reissue were Posted to GL 1/1/24</span></p></li></ul></ul></ul></span></div><div><br></div><div><span style="font-size:large">We will open a case but it does not sound like there are plans for a systematic fix, so we are going to prepare journals to recoup the workstudy funds, as well as sending "true up" amounts to fix the workstudy award balances in UCPath.  In some cases the check reissue resulted in a partial split because there was not enough available balance so we will likely have to do some DR/SCT transactions.  Specific "how to fix" details are TBD.</span></div><div><span style="font-size:large"><br></span></div><div><span style="font-size:large">Best,</span></div><div><span style="font-size:large">Steve</span></div><div><br></div><div><br></div><div>--</div><div dir="ltr" class="gmail_signature" data-smartmail="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></div>