Overview
This article explains:
- Costed and Accounted Project Costs
- How to identify and correct reversed transactions with incorrect accounting
- Who to contact to request a correction
Critical Concepts
- Project Portfolio Management (PPM) creates accounting for costs imported from outside Oracle Fusion Payables through Subledger Accounting rules (SLAs). Examples of expenses processed this way include UCPath and recharge facilities' internal billing
- An expense (cost) is an item requiring an outflow of money, or any form of fortune in general, to another person or group as payment for an item, service, or other category of costs
- Cost transactions created from source systems outside of OFC and PPM include, but are not limited to; Student Information System (ISIS), EPIC, and Financial Control
- Entries will import into the general ledger (GL) via journal entry
- Transactions are subsequently posted to PPM-Project Costs through an import file with a Transaction Source Document that makes the transactions "costed and accounted" to avoid a duplicate journal entry in the GL
- Costed and accounted transactions only post to the PPM sub-ledger; they do not impact the GL
- The import file data contains the POETAF + chart strings. The chart strings should represent the original GL journal entry
- PPM adjustments such as a transfer, split, etc., impact the GL. Note: As of August 2021, the SLAs use the chart strings from the original transaction instead of the project setup information to derive the accounting entries
- PPM adjustments generally have three transactions: original, reversal, and new. The accounting of the reversed transaction now originates from the initial transaction and uses the accounting string from the initial cost transaction
- The new transaction uses the data elements in the project setup to derive the accounting chart strings
- Initiators of costed and accounted entries may have provided “dummy” accounting chart strings instead of the chart strings loaded in the GL journal, especially at go-live
- If any of those transactions are adjusted, the accounting on the reversal transaction will be incorrect. An exception report is available to help identify erroneous transactions
Steps to Take
This section will walk you through the steps to identify and correct reversed transactions with incorrect accounting
- Navigate to https://bah.ucsd.edu/financial/index.html
- Click on the Central Office Panorama Tab
- Locate the Project Cost Adjustments on Costed and Accounted Report
- Run the report
- Reversal Accounting Date From and Reversal Accounting Date To is the accounting period the adjustment/reversal was done in
- Transaction Date From and Transaction Date To is the Expenditure Item date
- Transaction Source is the source systems outside of OFC where the cost was imported from
- Review the Reversal Raw Cost COA and Reversal Raw Cost Clearing COA
- If they are incorrect, submit a ticket to the data business owner to request a correction
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:
- Go to the gear wheel icon
- Scroll down and select Schedule
- Enter your parameters
- Enter the export format and email address
- Click Submit
- Name your report
- Click OK
- Click OK on the popup message that indicates the report was successfully scheduled
|
Contact Information
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 Source | Documents | Business Owner | How to Contact |
UCSD ISIS | UCSD ISIS | Student Financial Solutions (SFS) | About: Financial Accounting Related to: Student Accounting More Specifically: Account Reapplications |
UCSD Accounts Receivable | Misc 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 | Health | Health 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 Ledger | Financial 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) | All | Internal Controls & Accounting (ICA) | See above |
UCSD IFIS Conversion (Sponsored Projects) | All | Sponsored Projects Finance (SPF) | About: Awards & Sponsored Projects Related to: Resource and Cost Transfers More Specifically: Award Resource and Cost Transfer Inquiries |