Skip to Search
Skip to Navigation
Skip to Content

University of Connecticut Kuali Financial Data Mart

KFDM Reports

GL_CURRENT Reports

Account Balances - The Account Balances report shows the Current Budget, Actuals, Encumbrances, and Variances by account separately for Income and Expense summarized at the Object Level. This report is valid for accounts in all sub fund groups. Only Object Levels with activity should show up on this report. This report shows balances as of the close of the prior business day.

Summarized at the bottom of the report is an Expense Available Balance total which represents the account's spending authority. Expense Available Balance consists of Transfers Out and Expense object codes with the exception of Indirect Cost. Income activity does not affect spending authority unless a SSBA (Single Sided Budget Adjustment) for the Expense Budget is submitted and approved.

Account Balances Summary - The Account Balances Summary report shows the Expense Available Balance for all selected accounts. In addition it shows the Account Supervisor/PI and the Effective/Expiration dates for the account.

Account Balances by Object Code – The Account Balances by Object Code report shows Current Budget, Actuals, Encumbrances, and Variances summarized by Object Code.

Account Transactions – The Account Transactions report shows detailed transactions including the Date, eDoc #, eDoc Description, Object Code, and Amount by Account or Org based on a user specified date range.

Budget Balance by Account – The Budget Balance by Account report displays the Base, Carry Forward, One-Time, and Current Budgets for an Account by Object Level.

Expense Balances by Organization - The Expense Balance by Organization report shows all accounts belonging to a user specified parent organization and their corresponding Expense Budget, Encumbrance, and Actual balances.

Expense Transactions by Account - The Expense Transactions by Account report shows expense tranactions on a user specified account. The report displays the Fiscal Period, Object Code and Description, E-doc Number, User Description and the associated Amount.

Budget Balances by Object Code - The Budget Balances by Object Code report displays Base Budget, Carry Forward Budget, One-Time Budget, and Current Budget by Account and Object Code.

Carry Forward Summary - The Carry Forward Summary report is a summary by Organization of the Carry Forward Detail report.

Carry Forward Detail - The Carry Forward Summary report displays the 2.5% Carry Forward Amount for University Supported accounts along with Current Budget, Actual Expenses, Personal Services Encumbrances, Expense Encumbrances, Avaiable Balance, and Amount Over or Under the cap.

Organizational Fund Balance - The Organizational Fund Balance report displays a summary of the Current Funds Avaiable for and account by Fund Group. It does not include University Supported or Bond Fund Accounts.

ProCard Transactions - Detailed Procurement Card transaction information sorted by cardholder.

Base Budget vs. Committed Salaries - Account based comparison of the Base Budget versus Annual Salary and Fringe.

Multi-Year Budget vs. Actuals -This report allows a user to select multiple fiscal years to compare of Budget and/or Actuals by Account and Object Code.

 

 

PAYROLL_DISTRIBUTION Reports

Payroll Summary by Account – The Payroll Summary by Account report shows the Actual Expense, Remaining Encumbrance, and Total Committed amounts for all employees within an account by Object Code.

Payroll Summary by Employee – The Payroll Summary by Employee report shows the Actual Expense, Remaining Encumbrance, and Total Committed amounts across all accounts by employee.

Payroll Transactions - Detailed payroll transactions are displayed by organization, account or employee. Transaction output can be limted to a specific date range or fiscal period.

 

JOB_FUNDING Reports

Filled Position Summary – The Filled Position Summary Report is a summary of the Filled Position Detail Report containing Organization, Account, Object Code, and Employee Type.

Filled Position Detail – The Filled Position Detail Report pulls from Genesys and displays funded employee compensation broken down by Organization, Account(s), Object Code, Employee. Since this is an Account-based report, employees with multiple funding sources will be listed under each account they are funded by. This report is a combination of the BDM Filled Position and Fringe Benefit/Workers Comp reports.

 

PURCHASE_ORDER_ACCOUNTING Reports

Recurring Purchase Orders - The Recurring Purchase Orders report displays all recurring PO's including, Blanket Orders, Central Stores-Renewalble, Dues & Memberships, Food Renewable, Lease Orders, Printing Order-Renewable, Software Licensing, Standing Orders, Standing Maintenance Orders. It includes recurring PO's for Fiscal Accounts for the selected fiscal year, and project accounts with begin or end dates during the selected fiscal year.

Remaining PO Encumbrances - The Remaining PO Encumbrances report displays PO lines with open encumbrances. Any PO line that has been fully liquidated will not be shown.

 

REQUISITION Reports

Requisition Detail - The Requisition Detail report displays the Requestor, Vendor, Line Item Description, and Line Amount for requisitions within a specified date range and status.

 

REQUISITION_ACCOUNTING Reports

Requisition Accounting Detail - The Requisition Accounting Detail report displays the Requestor, Vendor, Line Item Description, Account, Object Code, Line Allocation Percent and Line Amount for requisitions within a specified date range and status.

 

PAYMENT_REQUEST Reports

Payment Request Detail - Listing of Payment Requests for a user-selected status and date range. This version of the report focuses on the Item, Quantity and Unit Price information.

 

PAYMENT_REQUEST_ACCOUNTING Reports

Payment Request Accounting Detail - Listing of Payment Requests for a user-selected status and date range. This version of the report focuses on the Item, Account, Object Code and Allocation Amount.

Payment Request Awaiting Status -Listing of Payment Requests by Department and Status. This report also includes a direct hyperlink back to the PREQ in KFS.

 

DISBURSEMENT_ACCOUNTING Reports

Vendor Spend Summary - Summary of University-wide Purchase Orders, Payment Requests and Disbursements by Vendor and Contract. The Vendor Header ID field groups together all divisions of a vendor.

 

AR_INVOICE Reports

Aging by Account - Summarizes the outstanding receivables by account and categorizes the age of the receivables.

Aging by Customer - Summarizes the outstanding receivables by customer and categorizes the age of the receivables.

 

Misc Reports

Account Info - The Account Info report shows the Account Name, Organization, Account Status, Fiscal Officer, and Account Supervisor

Accounts by Organization - The Accounts by Organization report shows the Organization, Account, Account Name, Sub Fund Group, Fiscal Officer, and Account Supervisor for all accounts within a user specified parent organization.