Closed Projects with GL Balance
Last Updated: May 15, 2024 11:16:30 AM PDT
Give feedback
PPM allows for projects to be closed regardless of the balance of any chart string on the GL. This report displays projects that have been closed in PPM but still have a balance on one or more general ledger accounts.
The Closed Projects with GL Balance report is available from the Business Analytics Hub (bah.ucsd.edu) under the Exceptions and Reconciliation tab.Access
Access has been provisioned to anyone with the Oracle BI Consumer JR role. Staff who do not have access should request the Oracle role. Access failure appears as error "Unable to load requested view. Displaying home view instead."
- Navigate to bah.ucsd.edu.
- Select Budget & Finance.
- If using the List View, look for Closed Projects with GL Balance in the list or use the search bar at the top right and click the dashboard name
- If using the Card View, click the Exceptions and Reconciliation tab and click Launch on the Closed Projects with GL Balance tile
- Use your Active Directory credentials to sign in, if prompted.
Navigation
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Closed Projects with GL Balance
Business Scenarios
- PPM Closed Projects with GL Balances report includes balance sheet accounts (liabilities, accounts receivable, etc.). These accounts are not included on the GL Project Balances report.
- Normally balance sheet accounts are cleared through the natural course of business. However, if they are not, it is important for departments to address them as they are responsible for all financial activity on their FinU. For example, if there is a balance on an accounts receivable account, that generally means that a customer has not paid one of the invoices for this project. It is important to follow up and make sure the payment is made.
Report Views
- Results display in a default table with the ability to export the result set into a file
What To Do
Assets (1XXXXX)
-
Receivables (12XXXX): Ensure all customer invoices have been issued and paid.
- Review your Department AR aging report (BAH -> Accounts Receivable Panorama -> Receivables Aging Report)
- Search for unapplied cash for your department to claim (BAH -> Accounts Receivable Panorama -> Incoming Payments (Receipts))
- Submit a claim form to clear the balance (KBA: How to Claim Unidentified Payments (wires, ACHs & checks)
- For subledger corrections in the accounts receivable module for invoice chart of account changes, please complete and submit the Subledger Transaction Correction Form
- For any other AR inquires, please submit a ticket to Budget and Finance Support (Billing & Receivables -> Oracle Accounts Receivable).
- Capital Assets (16XXXX): Work with ICA to complete the capitalization process. If expenses were miscoded as capital assets, complete and submit the Subledger Transaction Correction Form to correct the account code or expenditure type. For additional help, Submit a ticket to Budget and Finance Support (Equipment Asset Management -> General Capital Equipment Questions -> Other Equipment Inquiries).
Liabilities (2XXXXX)
Refer to the journal source on the transactions causing a balance.
- Payables: Submit a ticket to Budget and Finance Support (Invoices & Payables -> Supplier Invoices -> Supplier Invoice Status)
- UCSD ISIS: Submit a ticket to Budget and Finance Support (Financial Accounting -> Student Accounting -> Account Reapplications)
- Receivables: Submit a ticket to Budget and Finance Support (Billing & Receivables -> Oracle Accounts Receivable -> AR Billing Other)
- Spreadsheet: Contact the journal creator.
Net Position and Changes in Net Position (300000 and higher)
Transfer resources or expenses to bring the balance to zero. If balances of accounts starting with 3 and higher net to zero, these can be disregarded. They will come off the report at the start of the next fiscal year.