<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:8.0pt;
margin-left:.5in;
mso-add-space:auto;
line-height:105%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
mso-add-space:auto;
line-height:105%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
mso-add-space:auto;
line-height:105%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:8.0pt;
margin-left:.5in;
mso-add-space:auto;
line-height:105%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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:235550084;
mso-list-type:hybrid;
mso-list-template-ids:2059450984 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:273173245;
mso-list-template-ids:499310178;}
@list l1:level2
{mso-level-start-at:3;
mso-level-number-format:alpha-lower;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2
{mso-list-id:989021474;
mso-list-template-ids:-1087367490;}
@list l2:level1
{mso-level-start-at:3;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l3
{mso-list-id:1391810400;
mso-list-template-ids:-1302977582;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3: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 l3:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4
{mso-list-id:1508474388;
mso-list-type:hybrid;
mso-list-template-ids:270452948 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:40.75pt;
text-indent:-.25in;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:76.75pt;
text-indent:-.25in;
font-family:"Courier New";}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:112.75pt;
text-indent:-.25in;
font-family:Wingdings;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:148.75pt;
text-indent:-.25in;
font-family:Symbol;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:184.75pt;
text-indent:-.25in;
font-family:"Courier New";}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:220.75pt;
text-indent:-.25in;
font-family:Wingdings;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:256.75pt;
text-indent:-.25in;
font-family:Symbol;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:292.75pt;
text-indent:-.25in;
font-family:"Courier New";}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:328.75pt;
text-indent:-.25in;
font-family:Wingdings;}
@list l5
{mso-list-id:2022853303;
mso-list-template-ids:1226107762;}
@list l5:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6
{mso-list-id:2040621854;
mso-list-type:hybrid;
mso-list-template-ids:-532014124 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l6:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l6:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l6:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l6:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
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="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Dear Colleagues,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The August 2023 month end ledgers are now officially closed. The related Financial Transaction Detail Reports (FTDR) for 2023-08 have been published and are available in RSpace under the Tools section “<a href="https://finwebreports.ucr.edu/">Financial
Web Reports</a>”. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Some notes and reminders about the August ledgers:<u><o:p></o:p></u></p>
<p class="MsoNormal"><u><o:p><span style="text-decoration:none"> </span></o:p></u></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoListParagraphCxSpFirst" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
The deployment of the Ledger Reconciliation and Storage Systems for FY2024 is pending.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
Prime PI Summary pre-run reports are available as a separate tab under the <a href="https://finwebreports.ucr.edu/">
Financial Web Reports</a>. These reports are organized by Organization and Department values; please note the reports are not organized by Prime PI. The reports can be run ad hoc in Oracle by Prime PI, while the program team is working on this change for
future reports. <o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
Regular posting of the PO Encumbrance Report on the Financial Web Reports page is still pending. The report can be run ad hoc in Oracle.
<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
When reconciling non-zero projects for July and August, please focus on the Actuals for non-zero projects.
<o:p></o:p></li><ul style="margin-top:0in" type="circle">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Corrections to the carryforward on non-zero projects were processed in September; therefore, the true non-zero project carryforward will not be reflected on the FTDR until the September reports.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Non-zero project Inception to Date Budgets and the Prime PI Summary reports in the Report & Analytics Tool menu accurately reflect the data entered in PPM.
<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Note there are a few situations on converted awards where there were multiple UCRFS funds, one or more funds were closed so that portion of the award did not convert, AND a new increment of funding was received after conversion. In these circumstances, the
budget in PPM may be overstated. A permanent resolution is pending.<o:p></o:p></li></ul>
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
Budget data associated with BC75, BC76 and BC77 in Looker Financials is still pending.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
July Payroll and Suspense Funding. <o:p></o:p></li><ul style="margin-top:0in" type="circle">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Per 9/11/2023 notice to MSOADM, due to the conversion from the old Chart of Account structure (aka FAU) to the new Chart of Accounts, payroll transactions associated with the dates prior to July 1<sup>st</sup> were redirected to the Suspense fund 69993. Proposed
manual corrections will be distributed to ORG CFAOs this week.<o:p></o:p></li></ul>
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
July and August benefits costs are accurately reflected in the GL, FTDR, Looker Financials and Looker Payroll. In PPM only, the vast majority of benefits costs have been corrected as of the August ledgers.
<o:p></o:p></li><li class="MsoListParagraphCxSpLast" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
Corrections of purchase order and accounts payable related transactions originally recorded to the GL chart string equivalent of the POETAF instead of POETAF were corrected.<o:p></o:p></li></ul>
<p class="MsoNormal">Tips for reconciliation using Journal Source:<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoListParagraphCxSpFirst" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level1 lfo9">
On the FTDR, the Journal Source, Journal Line Description, Journal Reference and/or Acct Seq # columns provide key data to trace the transaction back to the source system and transaction. For example,<o:p></o:p></li><ul style="margin-top:0in" type="circle">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Payables, if the Journal Line Description references a PO, use the Journal Reference to look up the supplier’s invoice and see a copy of the invoice in Oracle.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Payables, if Journal Line Description does not reference a PO and the Journal References is 8 characters and starts with a P or M, use ePay to look up the transaction source.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Payables, if Journal Line Description does not reference a PO and the Journal Reference is 7 characters long, use Concur to look up the transaction source.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Purchasing, use the Journal Reference to look up the purchase order details in Oracle.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Payroll Labor Distribution or Salary Cost Transfer, use Looker to access payroll distribution details. Remember that payroll should be reconciled to source documents such as timesheets, offer letters, position funding, etc.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Banner/SIS, use iReport to access General Operating-SIS Monthly Activity pre-run reports. The Looker Banner data cube deployment is pending.<o:p></o:p></li><li class="MsoListParagraphCxSpLast" style="margin-left:0in;mso-add-space:auto;mso-list:l0 level2 lfo9">
Source equals Spreadsheet or Manual, use General Ledger inquiry, add the Acct Seq # to the search criteria fields, enter the Acct Seq # to look up the journal and related attachments.<o:p></o:p></li></ul>
</ul>
<p class="MsoNormal" style="margin-left:58.75pt"><o:p> </o:p></p>
<p class="MsoNormal">Please proceed with unit ledger reconciliations and report any concerns by submitting a ticket using the Impact23 support site:
<a href="https://ucrsupport.service-now.com/finadmin_portal">https://ucrsupport.service-now.com/finadmin_portal</a>
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">September payroll will be posting soon, and the September ledgers will be closing over the next week. Thanks for your continued patience and support.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sincerely,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bobbi<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Associate Vice Chancellor and Controller (retiring)<o:p></o:p></p>
<p class="MsoNormal">Business & Financial Services<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="http://bfs.ucr.edu/"><b><span lang="EN">http://bfs.ucr.edu/</span></b></a></span><b><u><span lang="EN" style="color:#383838"><o:p></o:p></span></u></b></p>
<p class="MsoNormal"><img border="0" width="157" height="48" style="width:1.6333in;height:.5in" id="Picture_x0020_3" src="cid:image001.png@01D9FACA.A36E1A60" alt="signature_2034439392"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Bobbi McCracken <br>
<b>Sent:</b> Wednesday, September 20, 2023 10:29 AM<br>
<b>To:</b> lrss_users@lists.ucr.edu; msoadm@scotmail.ucr.edu<br>
<b>Cc:</b> Impact23 <impact23@ucr.edu>; Asirra Suguitan <asirra.suguitan@ucr.edu>; Stephanie L Flores <stephanie.flores@ucr.edu>; Jerry Monahan <jerry.monahan@ucr.edu><br>
<b>Subject:</b> July 2023 Period Close Reports Re-published<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Dear Colleagues,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks again for your continued patience as the Impact23 team works through challenges with the initial implementation of the financial systems and integrations. The July 2023 Financial Transaction Detail Reports (FTDR) have been re-published
are available in RSpace under the Tools section “<a href="https://finwebreports.ucr.edu/">Financial Web Reports</a>”. In addition to the notes and reminders from the initial announcement (highlighted below), there are a few known issues:<u><o:p></o:p></u></p>
<p class="MsoNormal"><u><o:p><span style="text-decoration:none"> </span></o:p></u></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoListParagraphCxSpFirst" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
Carryforward on non-zero Projects for July 2023 and August 2023 FTDR: <o:p></o:p></li><ul style="margin-top:0in" type="circle">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
The Financial Transaction Detail Report is a fiscal year based report<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Carryforward balances are generated from Oracle Budget. Oracle Budget is an annual budget. When Budget data is synchronized with the General Ledger, it is a complete replacement.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Corrections to the carryforward on non-zero projects were processed in September; therefore, the true non-zero project carryforward will not be reflected on the FTDR until the September reports<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
When reconciling non-zero projects for July and August, please focus on the Actuals<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Non-zero project Inception to Date Budgets in PPM are accurate <o:p></o:p></li><ul style="margin-top:0in" type="square">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level3 lfo3">
Note there are a few situations on converted awards where there were multiple UCRFS funds, one or more funds were closed so that portion of the award did not convert, AND a new increment of funding was received after conversion. The budget in PPM may be overstated.<o:p></o:p></li></ul>
</ul>
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
Budgets associated with BC75, BC76 and BC77 have been corrected on the FTDR. However, the resolution of the issue in Looker Financials is still pending.<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level1 lfo3">
July Payroll and Suspense Funding. <o:p></o:p></li><ul style="margin-top:0in" type="circle">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
Per 9/11/2023 notice to MSOADM, due to the conversion from the old Chart of Account structure (aka FAU) to the new Chart of Accounts, payroll transactions associated with the dates prior to July 1<sup>st</sup> were redirected to the Suspense fund 69993. Manual
corrections are in process.<o:p></o:p></li><li class="MsoListParagraphCxSpLast" style="margin-left:4.75pt;mso-add-space:auto;mso-list:l4 level2 lfo3">
July salary and benefits are accurately reflected in the GL, FTDR, Looker Financials and Looker Payroll. In PPM only, a small number of projects do not reflect the full benefit amounts for July; corrections are pending.
<o:p></o:p></li></ul>
</ul>
<p class="MsoNormal" style="margin-left:58.75pt"><o:p> </o:p></p>
<p class="MsoNormal">Please proceed with unit ledger reconciliations and report any concerns per guidelines below.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sincerely,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bobbi<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Associate Vice Chancellor and Controller<o:p></o:p></p>
<p class="MsoNormal">Business & Financial Services<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="http://bfs.ucr.edu/"><b><span lang="EN">http://bfs.ucr.edu/</span></b></a></span><b><u><span lang="EN" style="color:#383838"><o:p></o:p></span></u></b></p>
<p class="MsoNormal"><img border="0" width="157" height="48" style="width:1.6333in;height:.5in" id="Picture_x0020_2" src="cid:image001.png@01D9FACA.A36E1A60" alt="signature_2034439392"><o:p></o:p></p>
<p class="MsoListParagraph" style="margin-left:40.75pt;mso-add-space:auto"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Msoadm <<a href="mailto:msoadm-bounces@scotmail.ucr.edu">msoadm-bounces@scotmail.ucr.edu</a>>
<b>On Behalf Of </b>Bobbi McCracken<br>
<b>Sent:</b> Wednesday, September 6, 2023 12:46 PM<br>
<b>To:</b> <a href="mailto:lrss_users@lists.ucr.edu">lrss_users@lists.ucr.edu</a>;
<a href="mailto:msoadm@scotmail.ucr.edu">msoadm@scotmail.ucr.edu</a><br>
<b>Cc:</b> Impact23 <<a href="mailto:impact23@ucr.edu">impact23@ucr.edu</a>>; Stephanie L Flores <<a href="mailto:stephanie.flores@ucr.edu">stephanie.flores@ucr.edu</a>>; Jerry Monahan <<a href="mailto:jerry.monahan@ucr.edu">jerry.monahan@ucr.edu</a>><br>
<b>Subject:</b> [Msoadm] Retracted July 2023 Period Close Reports<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Dear Colleagues,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for your thorough and prompt review of the July 2023 Financial Transaction Detail Reports (FTDR). Several issues were identified requiring the reports to be revised and regenerated (e.g., BC75/76/77, C&G Project carryforward budgets,
etc.). As the FTDR are the official campus ledgers, the July reports generated on 9/5/2023 must be retracted. An additional communication will be distributed once the new July reports are available. I apologize for the inconvenience.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bobbi<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Bobbi McCracken <br>
<b>Sent:</b> Tuesday, September 5, 2023 3:22 PM<br>
<b>To:</b> <a href="mailto:lrss_users@lists.ucr.edu">lrss_users@lists.ucr.edu</a>;
<a href="mailto:msoadm@scotmail.ucr.edu">msoadm@scotmail.ucr.edu</a><br>
<b>Cc:</b> Asirra Suguitan <<a href="mailto:asirra.suguitan@ucr.edu">asirra.suguitan@ucr.edu</a>>;
<a href="mailto:jerry.monahan@ucr.edu">jerry.monahan@ucr.edu</a>; Impact23 <<a href="mailto:impact23@ucr.edu">impact23@ucr.edu</a>><br>
<b>Subject:</b> July 2023 Period is Closed in Oracle Financials<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Dear Colleagues,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The first Accounting Period, July 2023, under the new Oracle Financial system has been closed. Financial Transaction Detail Reports are now available in RSpace under the Tools section “<a href="https://finwebreports.ucr.edu/">Financial
Web Reports</a><span style="background:yellow;mso-highlight:yellow">”. A few notes and reminders:<o:p></o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraphCxSpFirst" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level1 lfo6">
<span style="background:yellow;mso-highlight:yellow">Regardless of the process used to reconcile your monthly ledgers, the Financial Transaction Detail Report (FTDR) should be used as the basis to ensure completeness of the data being reconciled<o:p></o:p></span></li><ol style="margin-top:0in" start="1" type="a">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">The FTDR is a fiscal year-based report. At this time reconcilers are asked to reconcile PPM project costs against the FTDR.<o:p></o:p></span></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">Reconcilers must be provisioned inquiry access to the related systems for the transactions they are responsible for reconciling.
<o:p></o:p></span></li></ol>
</ol>
<p class="MsoListParagraphCxSpMiddle" style="margin-left:1.5in;mso-add-space:auto;text-indent:-1.5in;mso-text-indent-alt:-9.0pt;mso-list:l6 level3 lfo6">
<![if !supportLists]><span style="background:yellow;mso-highlight:yellow"><span style="mso-list:Ignore"><span style="font:7.0pt "Times New Roman"">
</span>i.<span style="font:7.0pt "Times New Roman""> </span></span></span><![endif]><span style="background:yellow;mso-highlight:yellow">Reconcilers should be provisioned the Oracle Financials UCR Inquiry role at a minimum.
<o:p></o:p></span></p>
<p class="MsoListParagraphCxSpMiddle" style="margin-left:1.5in;mso-add-space:auto;text-indent:-1.5in;mso-text-indent-alt:-9.0pt;mso-list:l6 level3 lfo6">
<![if !supportLists]><span style="background:yellow;mso-highlight:yellow"><span style="mso-list:Ignore"><span style="font:7.0pt "Times New Roman"">
</span>ii.<span style="font:7.0pt "Times New Roman""> </span></span></span><![endif]><span style="background:yellow;mso-highlight:yellow">Individual reconciling payroll transactions will need to complete the Gender Recognition and Live Name training in
LMS, sign the Non-Disclosure agreement, and be provisioned access to Looker-Finance-Payroll Distribution role.<o:p></o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<ol style="margin-top:0in" start="3" type="a">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">Reconciliations should be to source documents (such as purchase orders, invoices, etc.) When reconciling payroll transactions, the user should be validating against source documents (e.g., signed offer letters,
promotion letters, leave notices, etc.) and the Time & Attendance Reporting System (TARS). A reconciliation of the FTDR to the Payroll Distribution Database is insufficient.<o:p></o:p></span></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">If errors in the data are identified, the departments must have established procedures to ensure corrections are tracked and confirmed.<o:p></o:p></span></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">Please review UCR Policies and Procedure-<a href="https://fboapps.ucr.edu/policies/index.php?path=viewPolicies.php&policy=200-97">Ledger Reconciliation & Review Guidelines 200-97</a>. Although updates are
required to address the new systems, the objectives are the same. <o:p></o:p></span></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">If a system error is identified, please submit a ticket using the Impact23 support site:
<a href="https://ucrsupport.service-now.com/finadmin_portal">https://ucrsupport.service-now.com/finadmin_portal</a>
<o:p></o:p></span></li></ol>
<li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level1 lfo6">
<span style="background:yellow;mso-highlight:yellow">The updated Ledger Reconciliation and Storage System (LRSS) under the new COA is not yet available. Ledgers should continue to be reviewed and reconciled. Once the updated LRSS is deployed, users will be
asked to mark the July ledgers as reconcile and certify in LRSS<o:p></o:p></span></li></ol>
<p class="MsoListParagraphCxSpMiddle"><span style="background:yellow;mso-highlight:yellow">Note: Department SAA will need to recreate the LRSS matrixes once the replacement system is deployed. Additional guidance will be provided upon deployments, so please
begin evaluating if changes in roles are necessary. <o:p></o:p></span></p>
<ol style="margin-top:0in" start="3" type="1">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level1 lfo6">
<span style="background:yellow;mso-highlight:yellow">Please work with your department financial manager to evaluate your reconciliation procedures under the new financial systems and Chart of Accounts. As you are aware, most transactions are processed using
workflow approval (versus the Post Audit Notification (PAN)). <o:p></o:p></span></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level1 lfo6">
<span style="background:yellow;mso-highlight:yellow">At this time, the <a href="https://finwebreports.ucr.edu/">
Financial Web Reports</a> only contain the FTDR. In the near future, the monthly PI Summary Reports by PI and the Encumbrance Reports will be housed at this site.<o:p></o:p></span></li><li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level1 lfo6">
<span style="background:yellow;mso-highlight:yellow">Payroll journals for July:<o:p></o:p></span></li><ol style="margin-top:0in" start="1" type="a">
<li class="MsoListParagraphCxSpMiddle" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">Please note you will see the posting and reversal of several journals. This situation will not re-occur after the August ledgers<o:p></o:p></span></li><li class="MsoListParagraphCxSpLast" style="margin-left:0in;mso-add-space:auto;mso-list:l6 level2 lfo6">
<span style="background:yellow;mso-highlight:yellow">July payroll journals are mislabeled “August”; this situation has been corrected going forward.<o:p></o:p></span></li></ol>
</ol>
<p class="MsoNormal">Thank you for your patience during the system transitions. <o:p>
</o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sincerely,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bobbi McCracken<o:p></o:p></p>
<p class="MsoNormal">Associate Vice Chancellor and Controller<o:p></o:p></p>
<p class="MsoNormal">Business & Financial Services<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="http://bfs.ucr.edu/"><b><span lang="EN">http://bfs.ucr.edu/</span></b></a></span><b><u><span lang="EN" style="color:#383838"><o:p></o:p></span></u></b></p>
<p class="MsoNormal"><img border="0" width="157" height="48" style="width:1.6333in;height:.5in" id="Picture_x0020_1" src="cid:image001.png@01D9FACA.A36E1A60" alt="signature_2034439392"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>