kuali balance inquiries
DESCRIPTION
KUALI BALANCE INQUIRIES. Presented by Campus Services. Available Balances. Available Balance This report will display The Account Number Sub-Account Number Object Code Sub-Object Code Budget Amount Actuals Amount Encumbrance Amount - PowerPoint PPT PresentationTRANSCRIPT
KUALI BALANCE INQUIRIES
Presented by Campus Services
Available Balances
Available BalanceThis report will display
The Account Number Sub-Account Number Object Code Sub-Object Code Budget Amount Actuals Amount Encumbrance Amount Variance – Amount Available
This report is similar to screen 018 in FRS.
Purpose: Display available balances per account per object code Available balance is displayed as ‘variance’ and includes budget, less actual, less encumbrances.
Available Balances
In the object code field you may enter a greater than or less than symbol. Example, if you want to
search for balances in object codes >5999, input >5999 (no
space between symbol and value). >5999 is valid, > 5999 is not
valid.
Any item that has a Search symbol will display the options available for that field.
Available Balances
Consolidation Option: This option will consolidate the Sub-Account and any Sub-object code to the Account and Object code level.
Detail option will display the ‘subs’, (Sub-accounts and Sub-object codes)
Including Pending Ledger Entry will include any documents that are in process. Approved will include those entries approved as of today. All will
include any pending document, whether it is approved or waiting to be approved.
Any underlined item can be clicked on to display
additional information or to drill down further into transaction levels of data
detail.
Sort
By clicking on the amount $2413.00 in the previous screen the above is displayed. By clicking on 2,008.00 , a detailed transaction list will be displayed in the following screen, and from there you can drill down once again on the underlined Document number 340453 and the document will be displayed.
The transactions can easily be exported by using the options at the bottom of the page. Simply click on the underlined word “Spreadsheet” which is
just to the left of “Export options:” Click 'csv' to export the data as a comma delimited file, 'spreadsheet' to export the data as a spreadsheet, or
'xml' to export the data as xml.
EXAMPLES
Balances By Consolidation
Balances By Consolidation
This report will display
Account number Sub Account number Reporting Sort Code Consolidation Code Lookup By Level Budget Amount Actuals Amount Encumbrance Amount Variance – Available balance
Purpose: Displays the total income and total expenses on an account, rolled up by a consolidation code.
Drill down on “Lookup by Level”
Consolidation code CMPN = Compensation has level Codes for the various types of
compensation, such as Admin Pro ADMN, State Classifies SCLS, etc.
GENX = General Expenses has various types of general expenses in Level Code; Service SERV, Supplies SUPP, Personal Services
SERX
Object Code5011 Faculty
Salary
Object Level ACSA
(Faculty) will group similar
object codes into reporting
categories.
Consolidation code CMPN Consolidation
codes will group the various object
levels
If there were an entry in the routing process but not yet approved, by clicking on Drill Down under See ‘Pending
Entry’, the entry will be displayed. If there were an Encumbrance Amount against the object code it would be
displayed under ‘Encumbrance Amount’
EXAMPLES
Cash Balances
Cash Balance
This Report will include
Account Number Object Code 1100 “Cash” Beginning Balance Contracts Grants Beginning Balance Amount Account Line Annual Balance Amount Available Cash Balance
This is similar to screen 018 in FRS
Purpose: This report will only show the cash balance – object code 1100
Is the cash balance good or bad ?
General Ledger Balance
General Ledger Balance
This report will show
Chart Code Account Number Sub-Account Number Object Code Sub-object Code Balance Type Code Object Type Code Beginning Balance Line Amount Contracts Grants Beginning Balance Amount Account Line Annual Balance Amount
This screen is similar to screen 018 and 019 in FRS. When you use the drill down function, it will give you transaction detail similar to screen 023 in FRS
Purpose: Displays all object codes (unless specified) in an account. Using the Drill down capability, all transactions can be
displayed
The ‘Balance Type Codes’AC Actuals – default is ACA2 Not in UseBB Adjusted Base Budget- Original BudgetCB Current Budget – Budget withAdjustments – Revised BudgetCE Cost Share EncumbrancesEX External Encumbrance - obligation to pay vendors outside or external to CSUIE Internal Encumbrance – obligation to pay transactional document for goods or services provided
by one department to another department within CSU
MB Monthly Budget – section in Budgets that allows budget by monthNB Close Nominal Balance – Year end
process, close Revenues and Expenses balances into the Balance Sheet (Fund Balance)
PE Pre-EncumbranceRE Year End Budget ReversionTR Transfers
The ‘Object Type Code’
AS AssetCH Cash Not Income - ie depositsEE Expenditure not Expense Cost of Sales 700x, Capital purchases like equipment, vehicles and buildingsES Expense Not Expenditure Depreciation expense 6679, Doubtful accounts 6632, Cash over or short 6634 EX Expense Expenditure – General expense, salaries, suppliesFB Fund BalanceIC Income Not Cash – Gifts, Library Holdings, Gifts-Collectible objectsIN Income – CashLI LiabilityTE Transfer of Funds – ExpenseTI Transfer of Funds – Income
Below is a display of two different ‘Balance Type Codes’ AC for Actual
And IE for Internal Encumbrance
By selecting the type of ‘Balance Type Code’ the data displayed can be reduced by
the selection criteria.
Left Blank
The ‘Amount View Option’: Monthly will show the month’s activity total. Accumulate will show the accumulative total year to date.
For example, monthly is chosen and ‘July’ below is 670.59. This is the total for the month for the month of July and (225.64) for
‘August’ is the monthly amount for August. If ‘Accumulate had been chosen, July would still be 670.59 but August would show the
accumulative total of 444.95 ( 670.59 + (225.64) ) and Sept accumulative would be 790.00
The ‘Amount View Option’: Monthly will show the month’s activity total. Accumulate will show the accumulative total
year to date.For object code 6601 below, July is zero, August is 290.05 and the September amount is
the year to date (accumulative) total of Jul-Sept
340.95
Amount View Option: MONTHLY
The ‘Amount View Option’: Monthly will show the month’s activity total. Accumulate will show the accumulative total year to
date
Amount View Option: Accumulate
Month of July -0- Month of August 290.05Month of September 50.90Month of October -0-Month of November 140.00Total Year to Date 480.95
EXAMPLES
General Ledger Entry
General Ledger Entry This report will display Fiscal Year Organization Reference IdCart Code Reference Document Type CodeAccount Number Reference Origin CodeSub-Account Number Reference Document NumberObject Code Pending Entry Approved IndicatorSub-Object CodeBalance Type CodeObject Type CodeFiscal PeriodDocument TypeOrigin CodeDocument NumberTransaction Ledger Entry DescriptionTransaction Ledger Entry AmountDebit / Credit CodeTransaction DateOrganization Document NumberProject Code
Purpose: To display an original entry / document. This screen is similar to screen 023 in FRS
No required fields!!!!! - Not True !
By doing a search on only the Fiscal year, Chart code, Account Number, Balance Type Code, and
the Fiscal Period, all the documents will be displayed that
occurred in that fiscal period.
To complete this search, either University Fiscal year, chart of
accounts code, account number, and fiscal period must be specified,
Or the university fiscal year and document number must be specified.
Default entries are Fiscal Year, Balance Type Code: ‘AC’ and
the current Fiscal Period
Fiscal PeriodsJul 01Aug 02Sep 03Oct 04Nov 05Dec 06Jan 07Feb 08Mar 09Apr 10May 11
Jun 12
** may be input in the Fiscal
Period field to view all entries
for the fiscal year and also used in the Balance Type
Code Field to view all balance
types
Document Type: allows you to pull data by the type of
document. i.e. ‘CR’ would be a Cash Receipt Document and ‘IO’
an Internal Order. There are currently 379 document types listed. The following page lists
some of the most common document type codes.
Common Document Type codes:
Account ACCT Adjustment Voucher AV Advance Deposit AD Budget Adjustment BA Cash Receipt CR Disbursement Voucher DV Distribution of Income/Expense DI General Error Correction GEC Internal Billing IB Internal Order IO Payment Request PREQ Pre-Encumbrance PE Procurement Card PCDO Purchase Order PO Transfer of Funds TF Work Order Authorization WOA
Origin Code: allows you pull data by the means of the entry,( who entered the
document) i.e. ‘01’ is KFS entry, ‘T1’ is Telecomm, ‘F1’ Facilities The following slide
has a complete listing of Origin Codes
Origination Codes
01 Kuali Database name: KFS P3 Payroll Biweekly A2 Aries A/R P4 Payroll Salary A3 Campus Loan Manager PJ GLE A4 CashNet S1 Sponsored Programs A5 CSU Cashiers T1 Telecommunications A6 Business and Financial Services V1 Vet Hospital A7 ICR Encumbrance C1 Central Receiving D1 Diagnostic Lab D2 Division of Public Affairs F1 Facilities FS FRS MF IUIS GLE P1 Payroll-TPC P2 Payroll Adjustments
The Document Number is the originating document specific to each entry – (Another easy way is to do a
document search)
Organization Document number is optional to the department for
tracking documents
Project Code: allows you to look up data by the project code, most of
these would be Plant fund projects maintained in Facilities
Reference Document Type Code: allows a search by a disencumbrance document. ( Using this to do a search
would be seldom used)
Organization Reference ID is a reference identification number
assigned by an organization
By entering the items listed to the left and selecting ‘search’ the entries are listed on the following
screen
Using document 526296 found in the listing of transactions from the
previous screen, 2 items were retrieved. By clicking on the
underlined ‘Document Number’ the original document will be
displayed
EXAMPLES
General Ledger Pending Entry
General Ledger Pending Entry This report will display: Fiscal Year Organization Reference IdCart Code Reference Document Type CodeAccount Number Reference Origin CodeSub-Account Number Reference Document NumberObject CodeSub-Object CodeBalance Type CodeObject Type CodeFiscal PeriodDocument TypeOrigin CodeDocument NumberTransaction Ledger Entry DescriptionTransaction Ledger Entry AmountDebit / Credit CodeTransaction DateOrganization Document NumberProject Code
Purpose: Display Pending original entry / document. It will display pending entry documents by account and object code
This search option would be used to view entries
approved today, or those documents that are in
process.
This can also be done using the ‘General Ledger Entry’ screen and choosing
‘Pending entry”
This will display all Pending entries for account 2600010 by object code
Notice that this document is in “Pending Action Requests”
“Finalized” date is blank – once the document is completed this will be
date stamped
EXAMPLES
Open Encumbrances
OPEN ENCUMBRANCES
This report will display
Fiscal Year Chart Code Account Number Sub-Account Number Object Code Sub-object Code Balance Type Document Type Origin Code Document Number Description Open Amount Closed Amount Outstanding Amount Transaction Date
Purpose: To provide information on encumbrances. FRS has no similar screens No Required Fields - NOT True !!
To view all encumbrances, leave the balance type code blank. To display certain types of encumbrances, input
EX, IE or PE in the ‘Balance Type’ field.
Items that need to be entered are: Fiscal Year, Chart Code, and Account
Number OR Fiscal Year and Document Number
‘No required fields – Not true!’
BALANCE TYPE CODE
A2 A21 Balances – Labor Ledger onlyAC Actuals (Balance Sheet)BB Adjusted Base BudgetCB Current BudgetCE Cost Share EncumbrancesEX External EncumbranceIE Internal EncumbranceMB Monthly BudgetNB Close Nominal BalancePE Pre-EncumbranceRE Year End Budget ReversionTR Transfers
External Encumbrance ‘EX’
EXAMPLES
Contact your Campus Service Representative with Kuali questions
Valerie Monahan, Manager 491-3001 Janice Inman 491-6752
Heidi Barclay 491-4148David Leathers 491-5509Candice Hastings 491-7099
Questions ???