ML22195A114

Reconciliation Between Cars and Obi

ML22195A114
Person / Time
Issue date:	07/15/2022
From:	Clay Johnson NRC/OCFO
To:	Rivera E NRC/OIG/AIGA
cyl2
Shared Package
ML22195A104	List: ML22195A107 ML22195A114
References
Download: ML22195A114 (8)

Text

Office of the Chief Financial Officer / Division of the Comptroller Financial Services and Operations Branch Process Reconciliation of OBI and CARS

1) Purpose and Background The purpose of the Office of the Chief Financial Officer (OCFO) Travel Team process description is to document the processes for accessing and reconciling the Central Accounting Reporting System (CARS) and Treasury Oracle Business Intelligence (OBI) for Change of Station (COS).

2) Scope and Applicability This Process Description applies to staff and supervisor for COS.

3) Definitions / Acronyms CARS - Central Accounting Reporting System COS - Change of Station OBI - Oracle Business Intelligence

4) Procedures Accessing OBI

1. Go to Treasury https://arc.fiscal.treasury.gov/about-arc/quality-and-value/

2. Click the Log In button 1

3. From the list provided select Nuclear Regulatory Commission

4. A popup will occur that requires the following:

a. User: ARC

b. Password: 1Source*

5. New screen will open, select OBI.

6. New screen will open select PIV/CAC and enter your personal PIV credentials.

7.

2

8. Select OBI Report

9. Select Oracle BI Dashboards 3

10. Once the new screen opens, seclect the CARS Reconciliation Report Tab 4

11. From the next screen select report Expenditures by Paid Date

12. Select your date ranges a

13. Scroll to the bottom of the new page and click on Export and select Excell

14. Scroll to the bottom of the column marked Amount

15. Log the total from the Amount onto the CARS/OBI reconciliation form. Sign the section as the reviewer and then forward to MGMT for signature under Supervisory Reviewer.

5

To access Cars:

1. https://cars.for.fiscal.treasury.gov/esso/smfmsloginesso.fcc?SMQUERYDATA=-SM-XnzxXyboxahkEqkWwBerrWrqccEHhWuRkvreUSsNM8HY4z5rL0txma%2bB32vpwoXa CrZxdBOopOYezuvgHypNZoVOEJUH4nvaFjGRwutr6e%2b%2bPp9m5nDxwe%2bJPuh VPeM9D4IwmbaX%2bH%2fOPtm5j55TZvvCJmgtOSNarvAeT4MMzjbpzxZhYVo%2fioz1 VayvI2X4fEB2ZNqWabJCWPiDenNxwyvfQW%2fSUPtrUuZfVozj0XG4lVRJ3fS%2b6B97 quzQyJ9Mi%2fAelbiAFlGOXD6Qanyl5mXa3yIc%2b6AWJ%2fwFV20Q8monxnx9PpbPH O6HTC5RDr2XgrUmbsWsRp72COJSVe0OuI7cHwU1pkNw0doipo3asZT4v56RqKnBHz BO9pwvYr%2bPzE6ZCm4wH1V0rggngQqklZoxhWscGfNp

2. Enter

a. User:

b. Password:

3. Click Reports

4. Under Account Statement select:

a. Expenditure Activity b.

i. Select accounting Pd and month New Screen A. Click Hide Zero Balance Button B. Look for Treasury Account Symbol for 31x0200 6

C. Under View Transaction Select piece of paper button New Screen

a. Under ALC organize it - Pick out just ALC-20450000

b. Click Download

c. Click Download

d. Once it opens in Excel, you will need to filter the ALC column for 20450000

e. You will then total two columns

a. Increase of Balance

b. Decrease of Balance 7

f. You will then subtract from the decrease line the increase line and that is your total that should match OBI.

g. Log the total from the Amount onto the CARS/OBI reconciliation form. Sign the section as the reviewer and then forward to MGMT for signature under Supervisory Reviewer.

CARS/OBI Reconciliation form Month CARS OBI Total Difference Reviewers Supervisors Total Signature Signature 8