Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
205x Filetype XLS File size 0.09 MB Source: www.core-ct.state.ct.us
Catalog of On-Line Reports
Reports Summary
Category Number Name Purpose Navigation Path Comments Comments
General Ledger CTF17593 Projected Cash Status by Fund The report is designed to meet reporting requirements specified under Section 10 (c) of General Ledger > General Reports > Projected new 1/11/2012
Public Act 09-07 of the September Special Session. The Act requires each budgeted state Cash Status by Fund Updated 9/16/2013
agency to submit a monthly status report on any non-appropriated moneys to the Office of
Fiscal Analysis. The report is an accounting of moneys received or held by the agency that
are authorized or received by any manner other than as an appropriation.
General Ledger CTGL7986 Expenditure Report by Object Report is used to monitor and review expenditure account code ledger balances. General Ledger > General Reports > Expenditure Report displays account balances for each period
Report by Object (month) in separate columns. User can specify
expenditure accounts only.
Updated 9/16/2013
General Ledger CTGLR128 Available Cash Trial Balance Report is used to monitor and review account code ledger balances. General Ledger > General Reports > Available Updated 9/16/2013
Cash Trial Balance
General Ledger CTGLR17174 Non-Appropriated Cash Status Report The report is designed to meet reporting requirements specified under Section 10 (c) of Fin Reporting Tools > PS nVision > Define Report New 8/10/2010
Public Act 09-07. The Act requires each budgeted state agency to submit a monthly status Request Updated 9/20/2011
report on any non-appropriated moneys to the Office of Fiscal Analysis. The report displays Updated 9/16/2013
expenditures, encumbrances, liabilities, reimbursements and revenues for each non-
appropriated fund/SID combination.
General Ledger ctglr17269 Budgeted Fund Cash Status Report The report is an accounting of moneys received or held by the agency for budgeted funds. Fin Reporting Tools > PS nVision > Define Report New 9/23/2010
The report displays expenditures, encumbrances, liabilities, reimbursements and revenues Request > Add a New Value. Updated 9/16/2013
for each budgeted fund/SID combination. The data presented in this report represents data
posted in Core-CT only (not information posted to other agency legacy systems).
General Ledger CTGLR315 Cash Ledger Report This report provides cash balance information including the payments, receipts, and General Ledger > Journals > Process Journals > Updated 9/16/2013
transfers that affect the State's cash account balances for all Funds and Agencies on a Cash Ledger Report
monthly and yearly basis.
General Ledger CTGLR316 Detail & Summary Revenue This report creates a summary or detailed level report capturing the beginning and ending General Ledger > General Reports > Detail and Updated 7/17/2008 to require the use of both Fund
balances, the revenue activity, and the refund of expenditures of the State. The report Summary Revenue and Account fields in Include CF
captures revenue balances based on the Fund and Account specified by the user. It also Updated 8/13/2008 to include Department
generates the current period activity and year-to-date amount for that designated chartfield functionality
combination. It can be run showing detailed activity, or in summary format. Updated 9/16/2013
General Ledger CTGLR317 Flexible Ledger Analysis The CFSR runs in batch monthly, at the beginning of the month. These reports should a General Ledger > General Reports > Flexible User can specify balance sheet accounts (assets,
Ledger Analysis liabilities, fund balance) and operating statement
accounts (revenues and expenditures). Added
functionality v8.9
Updated 9/16/2013
General Ledger FIN2001 Journal Entry Detail This report is used to investigate potential problems with journal accounting entries. General Ledger > General Reports > Journal Updated 9/16/2013
Entry Detail
General Ledger GLS7002 General Ledger Activity The report lists the beginning and ending ledger balances with summary or detailed ledger General Ledger > General Reports > Ledger Updated 9/16/2013
activity by selected Chartfield combinations for one or multiple periods. The detailed ledger Activity
activity is a list of journal lDs for each unique chartfield combination and period(s) specified.
The report can be sorted and subtotaled by chartfield. It can be run in PDF or CSV format.
General Ledger GLS7003 General Ledger Summary The report is used to monitor and review ledger balances and journal line activity. It is a tool General Ledger > General Reports > Ledger Updated 9/16/2013
to investigate problems and issues discovered when running other General Ledger reports Summary
(e.g. Trial Balance).
General Ledger GLS7012 Trial Balance This report is used to review expenditures posted to the General Ledger by Account and General Ledger > General Reports > Trial Updated 9/16/2013
Special ID, for a cumulative period, by fiscal year. The report example (last page) is sorted Balance
and sub-totaled by account.
eProcurement POY1100 Requisition to PO Xref This report is used to monitor and review requisition and PO data. Core-CT Financials > Purchasing > Purchase Updated 5/15/2013
Orders > Reports > PO/Requisition Xref
eProcurement PVY1000 Requisition Costing Summary This report provides information about the accounting distribution for each requisition. For Main Menu > Core-CT Financials > New 5/18/2015
each requisition, the accounting distribution lines are summarized by GL (general ledger) eProcurement > Reports > Requisition Costing
business unit, account, and department. This report also lists the requisition name, Summary
requester, amount, and date.
Category Number Name Purpose Navigation Path Comments Comments
eProcurement PVY1100 Requisition Cost Distribution Detail This report provides information about the accounting distribution for each requisition down Main Menu > Core-CT Financials > New 5/18/2015
to the distribution level. By requisition distribution line, each accounting distribution is listed, eProcurement > Reports > Requisition Cost
including GL business unit, account, department, and amount. Distribution Detail
eProcurement PVY2000 Catalog Item Usage Provides information about the items ordered on requisitions. Sorted by business unit and Main Menu > Core-CT Financials > New 5/18/2015
item catalog, this report lists the items ordered and other information, including quantity eProcurement > Reports > Catalog Item Usage
ordered (descending order), average price, currency, and number of requisitions ordering
this item.
Commitment Control CTF15435 Fund Balance The report is used to monitor and review Budget, Encumbrance and Expenditure Commitment Control > Budget Reports > Fund New 11/17/2008; updated 2/9/2010; updated
information by fund.The report displays summary level budget information by fiscal year and Balance 11/1/2013
accounting period. The user can specify fund, SID, and department (agency). The report
can be subtotaled by chartfield. The amounts represented on the report include: Initial
Appropriation, Budget, Obligated, Expenditures and Available Balance. It is based on
balances from the Appropriation and Bond Authorization budget ledger groups
(KK_APPROP and KK_BD_AUTH).
Commitment Control CTF16057 Trended Fund Analysis The report displays the posted total budget amounts for specified funds (user may select Commitment Control > Budget Reports > Trended New 05/8/2009; updated 11/1/2013
either bond funds or appropriated funds). Regardless of the funds specified, the report Fund Analysis
displays pre-encumbered/encumbered balances, expenditure amounts, and available
allotted balances. User can specify one or multiple fiscal years.
Commitment Control CTGLR118 Negative Balance The Negative Balance report is used to identify budgets that have been exceeded. Agencies Commitment Control > Review Budget Activities > updated 11/1/2013
can then take appropriate corrective action. Budget Reports > Negative Balance Report
Commitment Control CTGLR122 Federal Programs Appropriations The report is used to monitor and review budgetary activity for Federal Grants by allowing Commitment Control > Budget Reports > Federal The report shows the carry forward, adjustments to
Report users to specify a range of CFDA numbers within a Federal Fund. It can be used as a tool to Program Appropriations appropriation, total appropriation, expenditures, and
validate against other General Ledger reports (e.g. Trial Balance, Expenditure Detail, and continued appropriation, subtotaled by SID for a
GL Activity). CFDA or range of CFDAs. The report can be sorted
and subtotaled by chartfield. It runs in both PDF and
CSV (MS Excel) format simultaneously. Updated
11/1/2013
Commitment Control/ CTGLR140 Comprehensive Financial Status Report The CFSR is a monthly report prepared by state agencies. It incorporates the Appropriation http://www.core- These reports should appear each month in the
General Ledger (A,B,C,D) Budget, Allotment Budget, the combined Agency Level and Project Budgets, and the ct.state.ct.us/user/finjobaids/docs/how_to_run_cfs Report Manager portion of the Portal page for all
Expenditures, Encumbrances, and Pre-Encumbrances year-to-date. It is run at the parent r.doc users with the CT GL REPORT_AGY, CNTRL GL
agency level. There is also a column for Projected Expenditures, which must be completed APPROVER, or CNTRL GL SYS TECH RESOURCE
th
by the agency and delivered to OPM by the 10 of each month for the prior month’s budget roles. They will appear in both Excel and HTML
status. The CFSR runs in batch monthly, at the beginning of the month. formats. Updated 11/1/2013
Commitment Control CTGLR311 Trial Balance of Appropriation This report is used to create a summary level report containing budget versus actual Commitment Control > Budget Reports > Trial Updated 11/1/2013
information on a monthly/yearly basis. The report is a trial balance of appropriations by Balance of Appropriation
agency. It will allow the users to group the data by Budget Period, Fund, SID, and
Department (Agency).
Commitment Control CTGLR319 Budget Lapse and Carry Forward This report displays summary level budget information by chartfield combination (fund, Commitment Control > Budget Reports > Budget New 11/17/2008; updated 11/1/2013
agency, SID). The amounts represented on the report include the closing amount (closing Lapse and Carry Forward
fiscal year), carry forward amount (new fiscal year) and amount of lapsing funds (if
applicable).
Commitment Control CTGLR341_GTGLPre-Encumbrance / Encumbrance The Pre-Encumbrance Detail Report (CTGLR341) or Encumbrance Detail Report Commitment Control > Budget Reports > Revised 9/24/2009
Detail (CTGLR342) displays the status of requisitions (pre-encumbrances) that have been PreEnc/Enc Budget Report Revised 3/22/2010; updated 11/1/2013
approved and budget checked. The data presented on the report includes: requisition ID,
requisition amount, pre-encumbered amount, PO reversed amount, balance, PO ID, PO
status. It is reported for each outstanding requisition Line, Schedule and Distribution line
(L/S/D).
Commitment Control CTGLR343_CTGLPre-Encumbrance / Encumbrance The Pre-Encumbrance Summary Report (CTGLR343) or Encumbrance Summary Report Commitment Control > Budget Reports > New 3/22/2010; updated 11/1/2013
Summary (CTGLR344) displays the status of requisitions (pre-encumbrances) that have been PreEnc/Enc Budget Report
approved and budget checked. The data presented on the report includes: requisition ID,
requisition amount, pre-encumbered amount, PO reversed amount, balance, PO ID, PO
status. It is reported for each requisition.
Commitment Control GLS8005 Budget Transaction Detail This report is used to investigate potential issues and problems found when running Commitment Control > Budget Reports > Budget updated 11/1/2013
summary level reports (e.g. Budget Status). Transaction Detail
Commitment Control GLS8020 Budget Status Report is used to monitor and review budget, pre-encumbrance, encumbrance, expense Commitment Control > Budget Reports > Budget updated 11/1/2013
and remaining balances. Status
Category Number Name Purpose Navigation Path Comments Comments
Purchasing CTF14968 Consultant Volume Listing This report is used to monitor and review contractor usage. The report displays summary Core-CT Financials > Procurement Contracts > New 12/4/2008
and detailed data regarding consulting contracts for a specified date range. This report Reports > Consultant Volume Listing Updated 5/10/2013
ranks the consultants by the dollar volume (from high to low) for work performed and
calculates a percentage of total work assigned by the agency. The report is available in both
PDF and CSV Format.
Purchasing CTPOR313 PO Balance Report This report is used to monitor and review PO balance data. Core-CT Financials > Purchasing > Purchase formerly POY313
Orders > Reports > PO Balance Report Updated 5/10/2013
Purchasing CTS14967 Flexible Contract Procurement The report displays a detail or summary listing of contract information by agency PO and PC Core-CT Financials > Procurement Contracts > Updated 5/13/2013
Business Unit. The report can be run for a selected vendor, by contract type, by project, or Reports > Flexible Contract Procurement New 7/13/2009
by procurement contract(s). The run control page allows the user to select chartfield
combinations and to specify whether the report should be based on tree nodes or detail
values for each chartfield. User can specify account, fund, project ID, program code and
SID.The report provides a complete picture of contract activity (POs, receivers, vouchers)
and can be used to reconcile contracts in Core-CT.
Purchasing POPO009 PO Activity Summary This report is used to monitor and review PO activity data. Core-CT Financials > Purchasing > Purchase updated 5/13/2013
Orders > Reports > Activity
Purchasing POY4006 Expediting Report [by Buyer] This report is used to determine which POs may require expediting. Core-CT Financials > Purchasing > Purchase Updated 5/15/2013
Orders > Reports > Expediting
Purchasing POY4007 Expediting Report [by Vendor] This report is used to determine which POs may require expediting. Core-CT Financials > Purchasing > Purchase Updated 5/15/2013
Orders > Reports > Expediting
Purchasing POY4008 Expediting Report [by Due Date] This report is used to determine which POs may require expediting. Core-CT Financials > Purchasing > Purchase Updated 5/15/2013
Orders > Reports > Expediting
Purchasing POY4010 PO Listing [by PO Date] This report is used to monitor and review PO data by PO date Core-Ct Financials > Purchasing > Purchase Updated 5/16/2013
Orders > Reports > Listings
Purchasing POY4011 PO Listing [by Vendor] This report is used to monitor and review PO data by vendor ID Core-Ct Financials > Purchasing > Purchase Updated 5/16/2013
Orders > Reports > Listings
Purchasing POY4012 PO Listing [by Buyer] This report is used to monitor and review PO data by buyer. Core-Ct Financials > Purchasing > Purchase Updated 5/16/2013
Orders > Reports > Listings
Purchasing POY4013 PO Listing [by PO Status] This report is used to monitor and review PO data by PO status Core-Ct Financials > Purchasing > Purchase Updated 5/16/2013
Orders > Reports > Listings
Purchasing POY4030 PO Detail Listing [by PO Date] This report is used to monitor and review PO detail data by PO date. Main Menu > Core-CT Financials > Purchasing > Updated 6/13/2013
Purchase Orders > Reports / Detail Listings
Purchasing POY4031 PO Detail Listing [by Vendor ID] This report is used to monitor and review PO detail data by vendor. Main Menu > Core-CT Financials > Purchasing > Updated 6/13/2013
Purchase Orders > Reports / Detail Listings
Purchasing POY4032 PO Detail Listing [by Buyer] This report is used to monitor and review PO detail data by buyer. Main Menu > Core-CT Financials > Purchasing > Updated 6/13/2013
Purchase Orders > Reports / Detail Listings
Purchasing POY4100 PO to Requisition Xref This report is used to provide a cross-reference between requisitions and the purchase Main Menu > Core-CT Financials > Purchasing > Updated 6/20/2013
orders created from those requisitions Purchase Orders > Reports > Requisition/PO
Xref
Purchasing PVY4000 PO Item Category Usage [by Category] This report is used to monitor and review PO item data Main Menu > Core-CT Financials > Updated 6/20/2013
eProcurement > Reports > PO Item Category
Usage
Purchasing PVY4001 PO Item Category Usage [by Vendor] This report is used to monitor and review PO item data Main Menu > Core-CT Financials > Updated 6/20/2013
eProcurement > Reports > PO Item Category
Usage
Chart of Accounts FIN0010 Account This report is used to monitor and review valid account values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Account
Chart of Accounts FIN0011 Department This report is used to monitor and review valid department values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Department
Chart of Accounts FIN0013 Project This report is used to monitor and review valid project values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Project
Chart of Accounts FIN0024 Budget Reference This report is used to monitor and review valid budget reference values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Budget Reference
Category Number Name Purpose Navigation Path Comments Comments
Chart of Accounts FIN0037 Chartfield 1 This report is used to monitor and review valid chartfield1 values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Chartfield1
Chart of Accounts FIN0038 Chartfield 2 This report is used to monitor and review valid chartfield2 values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Chartfield2
Chart of Accounts FIN0050 Fund Code This report is used to monitor and review valid fund values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Fund Code
Chart of Accounts FIN0052 Program Code This report is used to monitor and review valid program values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Program Code
Chart of Accounts FIN0053 Special ID This report is used to monitor and review valid special ID values in Core-CT. Set Up Financials/Supply Chain > Common Updated 12/9/2013
Definitions > Design Chartfields > Reports >
Chartfield Reports > Special ID
Accounts Payable AP18139 Voucher Verification Report This report lists vouchers (by distribution line) that are coded to Dept IDs not beginning with Accounts Payable > Reports > Voucher New 9/29/2011
your business unit prefix (i.e. DEP). This is a good month-end management report to locate Reconciliation > Voucher Verification Report Updated 12/2/2013
voucher lines coded to your Dept IDs in order to quickly process corrective journal
vouchers.
Accounts Payable AP18324 Voucher Dept ID Report This report reveals a listing of vouchers from other business units (by distribution line) that Accounts Payable > Reports > Voucher New 9/29/2011
are coded to Dept IDs with your business unit’s prefix. Once located, you can proactively Reconciliation > Voucher DeptID Report Updated 12/2/2013
research the coding to ensure it is correct, or contact that agency to inform them of the
error. This report is especially helpful after a consolidation or reorganization of business
units. This report does not include interfaced payroll vouchers that are processed on a bi-
weekly basis.
Accounts Payable APS8001J Voucher Activity This report is used to investigate potential issues and problems found when running Accounts Payable > Reports > Vouchers > Updated 6/3/2015
summary level reports (e.g. Trial Balance). Voucher Activity
Accounts Payable APY1010 Voucher Register This report presents a detail listing, by voucher, for all vouchers created by accounting date. Accounts Payable> Reports> Vouchers> Voucher Updated 12/2/2013
Register
Accounts Payable APY1011 Control Group Register This report is used to monitor and review control group data Accounts Payable> Reports> Vouchers> Control Updated 12/2/2013
Group Register
Accounts Payable APY1020 Posted Voucher Listing This report is used to monitor and review posted voucher data. Accounts Payable> Reports> Vouchers> Posted Updated 12/2/2013
Voucher
Accounts Payable APY1090 Match Exception This report is used to investigate reasons why a voucher is not being paid. Accounts Payable > Reports > Vouchers > Match Updated 12/2/2013
Exceptions
Accounts Payable APY2000 Payment History by Vendor This report presents a detail or summary listing for vendor(s) payment(s) made during an Accounts Payable >Reports > Vendor > Payment Updated 10/16/2014
inclusive time period. History by Vendor
Accounts Payable CTAPR199 Vendor Payment History This report is used to investigate all statewide payments made to a particular vendor. Accounts Payable > Reports > Vendor > Vendor Updated 12/2/2013
Payment Report
Accounts Receivable AR11001 Group Control by Entry Date This report is used to review daily activity by AR Business Unit processed through either the Accounts Receivable > Pending Items > Reports updated 2/19/2014
Billing Module or Accounts Receivable. > Group Control by Entry Date
Accounts Receivable AR11002 Pending Item by Entry Date This report is used to review pending items by a specified date range Accounts Receivable > Pending Items > Reports updated 2/19/2014
> Pending item by Entry Date
Accounts Receivable AR20001 Deposit Control by Entry Date Report is used to monitor and review deposits entered into Core-CT. Accounts Receivable > Payments > Reports > updated 2/19/2014
Deposit Control by Entry Date
Accounts Receivable AR20002 Payment Detail Report is a research tool to be run as needed to investigate deposit activity. Accounts Receivable > Payments > Reports > The report captures the entire deposit and provides
Payment Detail specific detail for what has been directly journaled
and what has been applied to open items.
updated 2/19/2014
Accounts Receivable AR20003 Payment Summary This report is used to review deposits in summary fashion. Separate page(s) by each Accounts Receivable> Payments> Reports> updated 2/19/2014
accounting date. Payment Summary
Accounts Receivable AR20005 Receivables Activity Report is a research tool to be run as needed to investigate customer account activity Accounts Receivable > Receivables Update > The report can capture all of the detail for a
Posting Results – Upd Items > Receivables customer, including items already paid (which does
Activity Report not appear on the Aging Report).
updated 2/19/2014
Accounts Receivable AR21001 Payment Predictor Detail This report is used to review payments automatically posted to outstanding Billing items. Accounts Receivable > Payments > Reports > updated 2/19/2014
Payment Predictor Detail
Accounts Receivable AR21002 Payment Predictor Summary This report is used to review a summary of payments automatically posted to outstanding Accounts Receivable > Payments > Reports > updated 2/19/2014
Billing items. Payment Predictor Summary
Accounts Receivable AR30003 Aging Detail by Business Unit This report is used to review the aging of receivables. Accounts Receivable > Receivable Analysis > formerly CTARR101
Aging > Aging_Detail_by_Unit_Rpt updated 2/19/2014
no reviews yet
Please Login to review.
