<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)">
<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 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:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial",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:1244413260;
mso-list-type:hybrid;
mso-list-template-ids:-1178558640 1752079402 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;
mso-ascii-font-family:Arial;
mso-fareast-font-family:Calibri;
mso-hansi-font-family:Arial;
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.75in;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:3.25in;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.75in;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1509901486;
mso-list-type:hybrid;
mso-list-template-ids:1123735196 1436874616 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.75in;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:3.25in;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.75in;
text-indent:-9.0pt;}
@list l2
{mso-list-id:2012684157;
mso-list-type:hybrid;
mso-list-template-ids:-1217112634 125068844 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
mso-ascii-font-family:Arial;
mso-fareast-font-family:Calibri;
mso-hansi-font-family:Arial;
mso-bidi-font-family:"Times New Roman";}
@list l2: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 l2: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 l2: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 l2: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 l2: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 l2: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 l2: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 l2: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;}
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"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Hello ACFR Contacts,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">A financial reporting item that arose from the unprecedented federal awards that state and local governments received in response to the COVID pandemic is that when federal awards
are moved between agencies, or between GAAP Funds if within an agency, <b><u>and</u></b> the amounts are material, the federal revenue should be reported by the agency and/or GAAP Fund that expends the federal award rather than the agency that received the
federal award. State agency practice has been to record the movement of federal awards between agencies, or GAAP funds if within an agency, as a transfer or a distribution to state agencies, depending upon how it was budgeted. This treatment is consistent
with paragraph 116 of <a href="https://www.oregon.gov/das/Financial/Acctng/Documents/15.42.00.pdf">
OAM 15.42.00</a> <i>Accounting and Financial Reporting: Federal Grants</i>. For those items that are material (more below), agencies must make additional entries using GAAP Offsets to accommodate financial reporting requirements. In developing this approach,
I consulted with the Secretary of State Audits Division and they agreed with the necessity of making the entries and the materiality threshold. SARS will update the OAM to reflect these changes after the issuance of the FY 2022 ACFR.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Process:
<o:p></o:p></span></u></b></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p><span style="text-decoration:none"> </span></o:p></span></u></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Steps 1 – 3 are current practice, Step 4 is the new step necessary to report the ACFR in accordance with GAAP.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level1 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">The agency that receives the federal award (“Prime Agency”) would record the receipt of the grant as federal revenue for
budget purposes. <o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level1 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Upon sending all or a portion of the grant to another agency, the Prime Agency would record a transfer out or distribution
to state agencies, depending upon how the transaction was budgeted. <o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level1 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">The agency receiving all or a portion of the federal award from the Prime Agency (“Secondary Agency”) would record a transfer-in
budgetarily to offset the transfer-out / distribution to state agencies recorded by the Prime Agency as noted in Step 2.<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level1 lfo1"><b><i><span style="font-size:10.0pt;font-family:"Arial",sans-serif">If the amount in Steps 2 and 3 exceed the materiality threshold</span></i></b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">
(defined below), using GAAP Offsets, the Prime Agency would debit federal revenue and credit transfer-out / distribution to state agencies. The Secondary Agency would debit transfer-in and credit federal revenue. Utilizing G38 codes, we have assurance the
transfer transactions between the Prime Agency and Secondary Agency are in balance.
<span style="color:red">The Prime Agency would have responsibility for initiating Step 4</span>.<o:p></o:p></span></li><ul style="margin-top:0in" type="circle">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level2 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Recommended Tcodes for Prime Agency:<o:p></o:p></span></li><ul style="margin-top:0in" type="square">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level3 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">TC 113 with CO 0300 and GL 3060.<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level3 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">If actual movement of federal awards was recorded as a distribution to state agencies:
<o:p></o:p></span></li><ul style="margin-top:0in" type="disc">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level4 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">TC 119 with CO 6XXX (unique for agency) and GL 3060. Requires G38 code.<o:p></o:p></span></li></ul>
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level3 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">If actual movement of federal awards was recorded as transfer out:
<o:p></o:p></span></li><ul style="margin-top:0in" type="disc">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level4 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">TC 125 with CO 1XXX (unique for agency / operating transfer) and GL 3060. Requires G38 code.<o:p></o:p></span></li></ul>
</ul>
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level2 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Recommend Tcodes for Secondary Agency:<o:p></o:p></span></li><ul style="margin-top:0in" type="square">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level3 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">TC 124 with CO 1XXX (unique for agency / operating transfer) and GL 3060. Requires G38 code.
<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l2 level3 lfo1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">TC 113R with CO 0300 or 0370 (applicable for governmental funds and proprietary funds, respectively) and GL 3060<o:p></o:p></span></li></ul>
</ul>
</ol>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">When moving applicable federal awards within an agency but amongst GAAP Funds, terminology for the above process would be “Prime GAAP Fund” and Secondary GAAP Fund”, replacing
“Prime Agency” and “Secondary Agency”, respectively, but the process would be the same.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">This process would apply even if the actual cash had not yet been moved at year-end but resulted in an accrual (due to/from).
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Materiality Threshold</span></u></b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">:
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">$20 million. Applied to the amount sent
<b><i>and</i></b> at the Assistance Listing Number level. If the Assistance Listing is part of a program cluster, the threshold would apply to the entire cluster. Even if the amount initially received by the Prime Agency exceeds $20 million but the amount sent
to another agency, or to another GAAP Fund if within an agency, is less than $20 million, Step 4 outlined in the process above would
<b><i>not</i></b> occur. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Note: If there are multiple transactions sending the same Assistance Listing to the same Secondary Agency / Secondary GAAP Fund, the materiality threshold should be applied for
the entire fiscal year, not each individual transaction. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Illustrative Examples (Step 4 only):<o:p></o:p></span></u></b></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p><span style="text-decoration:none"> </span></o:p></span></u></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Example 1: DAS received State Fiscal Recovery Fund (Assistance Listing number 21.027) in GAAP Fund 0054 and the Legislature directs DAS to send $50 million of this federal award
to OHCS, budgeted as a distribution to state agencies. OHCS recorded the $50 million from DAS as a transfer-in within GAAP Fund 1112.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:.25in;mso-list:l0 level1 lfo2"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">DAS initiates Step 4 communicating with OHCS about the pending entry, then records TC 113 with CO 0300 and GL 3060 for
$50 million and next entering a corresponding TC 119 with CO 6196 and GL 3060 for $50 million, with a G38 code of 914XXXX0.
<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:.25in;mso-list:l0 level1 lfo2"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">OHCS enters TC 124 with CO 1306 and GL 3060 for $50 million, with a G38 code of 107XXXX0. Then it records TC 113R with
CO 0300 and GL 3060 for $50 million.<o:p></o:p></span></li></ol>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Example 2: Similar scenario as Example 1 but the Legislature directs DAS to send $15 million to ODHS, budgeted as a distribution to state agencies. ODHS records the $15 million
from DAS as a transfer-in within GAAP Fund 1108.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:.25in;mso-list:l1 level1 lfo3"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Step 4 is not required because the materiality threshold has not been exceeded.
<o:p></o:p></span></li></ol>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif">SEFA Impacts<o:p></o:p></span></u></b></p>
<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p><span style="text-decoration:none"> </span></o:p></span></u></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">None. Regardless of the amount, this movement of funds can continue to be reported as a transfer for the SEFA. No SEFA Corrections will be needed related to Step 4.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Thank you for your efforts to make these entries in order for the ACFR to be reported in compliance with GAAP. By employing this materiality threshold, we believe it will reduce
the affected federal awards and agencies. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">If you have any questions, please reach out to your SARS analyst.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Rob</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#353535">Robert W. Hamilton, CPA</span></b><b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#353535"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#353535">Statewide Accounting and Reporting Services Manager</span></b><b><span style="font-family:"Verdana",sans-serif;color:#353535"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif">Chief Financial Office</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif">Department of Administrative Services</span><span style="font-size:8.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif">Cell: (971) 719-3031<o:p></o:p></span></p>
<p class="MsoNormal"><a href="http://www.oregon.gov/DAS/financial/acctng"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:blue">http://www.oregon.gov/DAS/financial/acctng</span></a><span style="font-size:8.0pt;font-family:"Verdana",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt"> </span><span style="font-size:8.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#353535">Data Classification: Level 1 - Published</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>