New and Updated KFS Decision Support Reports

[Accounting and Fiscal Services]

New Report!  Revenue & Expense Object Code Balance Report This brand-new report lets you review revenue and expense object code balances – and automatically flags abnormal balances for your attention. Drill through directly to GL entry details to investigate from within the report. Abnormal balances are evaluated at the KFS Account level with no materiality threshold applied. A flagged balance does not automatically indicate an error; it simply signifies an item that needs further evaluation. The existing Object Code Balance Report remains available. It focuses on expense object codes with multiple criteria. Financial Management Support is reviewing whether the new report can fully replace it.  Find both reports at: 📁 UCI Decision Support → KFS → General Ledger - Campus Reports   New Report!  Chart of Accounts (COA) Lookup Dashboard  The new Chart of Accounts Lookup Dashboard (Power BI) consolidates all COA lookup information into one convenient place. COA information is organized into three categories: KFS Account, Object Code, and Project. Replaces the need to bounce between multiple legacy Cognos reports. Faster and easier to navigate.   Heads up: All legacy COA lookup reports will still be accessible for the time being, but we plan to decommission them by January 2027. We encourage you to start using the new dashboard. Access the dashboard at: 📁 UCI Decision Support → KFS → Chart of Accounts   Updated! AR Aging Report We've updated how invoices are aged — the AR (Accounts Receivable) Aging Report now uses Due Date instead of Billing Date (the creation date in KFS AR).  More accurate cash flow visibility: aging by due date reflects when payments are expected, providing a clearer picture of current and upcoming overdue balances. Better collections prioritization: truly delinquent invoices are surfaced, helping teams focus on accounts that need immediate follow-up. Alignment with payment terms: negotiated terms (e.g., Net 30 or Net 60), avoiding misleading classifications that can arise when aging from the invoice date. Access this report at: 📁 UCI Decision Support → KFS → Accounts Receivable (Campus Users)   Enhanced! AR Outstanding Invoice Report We've made several enhancements to make this report more useful for day-to-day collections work: Age in Days is now based on Due Date - consistent with the updated AR Aging Report Invoice Notes are now displayed directly on the report face for faster reference The report can now be extracted to Excel and includes additional data fields to support further analysis  Access this report at: 📁 UCI Decision Support → KFS → Accounts Receivable (Campus Users)   News and Announcements Get Updates and Alerts About Report Availability The UCI-DWH mailing list is the best way to stay up to date on what’s happening with the UC Irvine campus data warehouse and the many reports that draw from it. Join this mailing list to get updates about data delays, system maintenance, and unplanned outages. To join this list, send an email to uci-dwh+...@uci.edu and reply to the automated join request when you will receive it. You can also manage your subscription on Google Groups (make sure you’re logged in with your UCI email address) or contact the OIT Help Desk for assistance.

UC Irvine Accounting & Fiscal Services 228 Aldrich Hall | Irvine, CA 92697-1050 | accounting.uci.edu

Want to Join this Mailing List? Send an email to afs-update...@uci.edu and reply to the automated join request to confirm your subscription. Send an unsubscribe request to leave the list. Send an email to a...@uci.edu for help.     Privacy Notice