How to Identify and Correct Costed and Accounted PPM Adjusted Costs (Central Office Guide)


Overview


This article, intended for central offices (also referred to as business owners), explains:

Critical Concepts


Steps to Take


Currently issues are identified by end users on the GL to PPM reconciliation report, when reviewing transactions, etc. and are reported through multiple channels including the chancellor advisory committee, Services & Support, office hours, CoP, etc. 

Business owners are responsible for researching, validating errors and taking the appropriate action to correct PPM cost entry transactions by following these steps: 

Step 1. Run report to identify multiple errors for a larger population (proactively) of entries or review individual transactions as requested by end user (submitted through a ticket)

    1. Navigate to https://bah.ucsd.edu/financial/index.html
    2. Click on the Central Office Panorama Tab
    3. Locate the Project Cost Adjustments on Costed and Accounted Report
    4. Run the report
      1. Reversal Accounting Date From and Reversal Accounting Date To is the accounting period the adjustment/reversal was done in
      2. Transaction Date From and Transaction Date To is the Expenditure Item date
      3. Transaction Source is the source systems outside of OFC where the cost was imported from
    5. Review the Reversal Raw Cost COA and Reversal Raw Cost Clearing COA

Tip: Run the data for the smallest data set possible, no more than 1 month of reversal data, to avoid a long report run time. Or, schedule the report to be delivered to your email

 To schedule the report:


  1. Go to the gear wheel icon
  2. Scroll down and select Schedule
  3. Enter your parameters  
  4. Enter the export format and email address
  5. Click Submit
  6. Name your report
  7. Click OK
  8. Click OK on the popup message that indicates the report was successfully scheduled
 

Step 2. Review the Reversal Raw Cost COA and Reversal Raw Cost Clearing COA

    •  If they are incorrect, continue to step 3

Step 3. Identify incorrect accounting strings 

    • Example below of reversal error from an AR Receipt
1

Original posting in PPM (did not go to GL)

DR 16120.20000.2000021.405401.000.2006417.000.00000.000000

CR 16120.20000.2000021.405401.000.2006417.000.00000.000000

1

Original posting in the GL

DR 16120.20000.2000021.405401.000.2006417.000.00000.000000

CR 19196.13391.96999092.110000.000.00000.00000.0000.0000

2

A reversal in PPM (cost transfer or other adjustment done)

DR 16120.20000.2000021.405401.000.2006417.000.00000.000000

CR 16120.20000.2000021.405401.000.2006417.000.00000.000000

 

2

Correlating entries in GL

DR 16120.20000.2000021.405401.000.2006417.000.00000.000000

CR 16120.20000.2000021.405401.000.2006417.000.00000.000000

 

3

New Cost in PPM and GL (derived based on the SLA’s in PPM (Refer to the PPM User Guide) Not balancing

DR 16120.20000.2000021.405401.000.2001234.000.00000.000000

CR 16196.16000.9699911.773046.000.000.000000.0000000.000000.00000.000000.000000

 

 

The original PPM file should have been

DR 16120.20000.2000021.405401.000.2006417.000.00000.000000

CR 16196.16000.9699911.773046.000.000.000000.0000000.000000.00000.000000.000000

Reversal would have then been:

CR 16120.20000.2000021.405401.000.2006417.000.00000.000000

DR 16196.16000.9699911.773046.000.000.000000.0000000.000000.00000.000000.000000

Step 4. Determine correct accounting strings

    • Original Transactions posted are not leveraging PPM SLAs as they are posted as costed and accounted
    • New transactions do leverage PPM SLAs, and the SLAs use the original PPM cost chart strings
    • Central office initiated the original transaction and should know the correct accounting based on proper accounting rules

Once you have identified the errors and have determined the correct accounting strings proceed to the following

Step 5. Route to Project Portfolio Management Strategic Design (PPM SD) Team with transactions and correct accounting strings (Raw Cost and/or Raw Cost Clearing strings) that need to be corrected

Note: In the case that the reversal entry is preventing close, PPM SD will fix the data element(s) causing a close issue, but the above steps still required for full resolution of accounting

 

How to Route Between Central Offices


Use the table below as your guide for filling out the form

The Project Portfolio Management (PPM) Team is responsible for:

  • Requesting the release of cross-validation rules (CVRs) if reversal entry is preventing close
  • Fixing the fund on both Dr./Cr.
  • Re-enabling the CVRs
  • This team is part of Financial Operations (FO), please see how to contact below

Business Owners are responsible for:

  • Identifying any entries that need to be corrected
  • Researching & validating the error and correct PPM cost entry transactions
  • Submitting tickets to update the PPM cost entries, and provides the correct accounting to the PPM team (central office to central office) or initiates the update in PPM directly

Business Owners at UC San Diego:

**The business owner is determined by the transaction source and documents as listed below.
 
Transaction SourceDocumentsBusiness OwnerHow to Route
UCSD ISISUCSD ISISStudent Financial Solutions (SFS)About: Financial Accounting
Related to (Service): Student Accounting
More Specifically (Service Offering): Account Reapplications
UCSD Accounts ReceivableMisc Receipts
Sales Invoice
Financial Operations (FO)About: Financial Accounting
Related to: Resource and Cost Transfers
More Specifically: Cost Transfer Inquiries
UCSD General Ledger 
UCSD Pinnacle Dept 
UCSD Pinnacle Various Recharges
UCSD Premier Supply Chain
UCSD TMA
UCSD EPIC
HealthHealth System

You can submit as follows and our team will redirect to the Health team for support

About: Financial Accounting
Related to: Resource and Cost Transfers
More Specifically: Cost Transfer Inquiries

UCSD General LedgerFinancial Control
GL PPM Transfer
Mass Allocations
Internal Loan Program
Internal Controls & Accounting (ICA)About: Financial Accounting
Related to: Resource and Cost Transfers
More Specifically: Resource Transfer Inquiries
UCSD IFIS Conversion (Capital Projects)AllInternal Controls & Accounting (ICA)See above
UCSD IFIS Conversion (Sponsored Projects)AllSponsored Projects Finance (SPF)About: Awards & Sponsored Projects
Related to: Resource and Cost Transfers
More Specifically: Award Resource and Cost Transfer Inquiries
 

Example Transactions


Example 1: 

Costed 2. Accounted Transactions with incorrect Strings  

3. Reversal cost created as part of a transfers (the “from” transaction) 

 

Example 2: Project 1009209

  • Move credit to expense receipt from task 1 to 31
  • Original trans: 16159168
  • PPM C&A

  • Original GL accounting:
    • On receipt
    • CR 16120.12100.2000020.539100.431.000.000000.1009209.000000.00000.000000.000000https://ekgs.fa.us2.oraclecloud.com/fscmUI/adf/images/t.gif
    • DR CAMPUS CASH STRING
    • Reversal/from 16854270
  • Accounting in PPM and GL:

  • New/to trans 16854271

Right now,

Net trans:

$124k CR 16120.12100.2000020.539100.431.000.000000.1009209.000000.00000.000000.000000https://ekgs.fa.us2.oraclecloud.com/fscmUI/adf/images/t.gif

$62k DR CAMPUS CASH STRING

$62k DR: 16196.16000.9699911.773046.000.000.000000.0000000.000000.00000.000000.000000

 

Need to update the reversal so that the net trans are:

$62k DR CAMPUS CASH STRING

$62k CR 16120.12100.2000020.539100.431.000.000000.1009209.000000.00000.000000.000000

 

Examle 3: Health

In the original journal in the GL:

DR 16130.20700.3000013.535100.440.000.000000.1001418.000000.00000.000000.000000

CR 16242.12000.4200100.125010.000.000.000000.0000000.000000.00000.000000.000000---I think?????

 

The original PPM MCI load—trans 12726465 as costed and accounted—reflection of above:

DR 16130.20700.3000013.535100.440.000.000000.1001418.000000.00000.000000.000000

CR 16130.20700.3000013.535100.440.000.000000.1001418.000000.00000.000000.000000

 

Transfer off (trans 16997079)—PPM accounting to GL based on original transaction:

DR 16130.20700.3000013.535100.440.000.000000.1001418.000000.00000.000000.000000

CR 16130.20700.3000013.535100.440.000.000000.1001418.000000.00000.000000.000000

 

Transfer To (trans—16997080)

DR 16130.20700.3000013.535100.440.000.000000.2002418.000000.00000.000000.000000

CR 16196.16000.9699911.773046.000.000.000000.0000000.000000.00000.000000.000000

Can you see how trans 16997079 isn’t actually doing anything accounting wise?

The line in red needs to be updated to match the green so that the transactions net out.