STATE OF CONNECTICUT CoreCT Agenda Welcome John Harnick

  • Slides: 92
Download presentation
STATE OF CONNECTICUT Core-CT

STATE OF CONNECTICUT Core-CT

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ GL Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon

Welcome T Maintenance Packs T Need volunteers for testing in March T Go live

Welcome T Maintenance Packs T Need volunteers for testing in March T Go live is scheduled for April 5 th weekend T Core-10 Coming Soon T Fiscal Year End T Catalog Management Changes

Customer Service í Users can call the Help. Desk @ 860 -622 -2300, ext

Customer Service í Users can call the Help. Desk @ 860 -622 -2300, ext 1 í For complex issues, send email to: Core. [email protected] state. ct. us

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ GL Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon

EPM Enhancements Accounts Receivable/Billing Projects/Costing Module Fields Added õ õ õ õ ACTIVITY_ID ANALYSIS_TYPE

EPM Enhancements Accounts Receivable/Billing Projects/Costing Module Fields Added õ õ õ õ ACTIVITY_ID ANALYSIS_TYPE BUSINESS_UNIT_PC PC_DISTRIB_STATUS RESOURCE_CATEGORY RESOURCE_SUB_CAT RESOURCE_TYPE PC_DISTRIB_STATUS

EPM Enhancements Accounts Receivable/Billing Projects/Costing Fields Added to EPM Reporting Tables: õ õ õ

EPM Enhancements Accounts Receivable/Billing Projects/Costing Fields Added to EPM Reporting Tables: õ õ õ CT_POSTED_ITEM CT_DIR_JRNL_PAY CT_BI_ACCTENTRY CT_BI_AR_PNDITN CT_BI_INVOICE

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria õ Revised to

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria õ Revised to include additional reporting tables. õ All accurate table joins identified. http: //www. core-ct. state. ct. us/epm/docs/rptng_tbl_ndxs_in_crtr. doc

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria Acceptable Join Criteria

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria Acceptable Join Criteria

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria Inaccurate Join Criteria

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria Inaccurate Join Criteria Spreadsheet

EPM Job Aids Updated Reporting Table to Role Mapping T Updated to include all

EPM Job Aids Updated Reporting Table to Role Mapping T Updated to include all projects/costing module roles. http: //www. core-ct. state. ct. us/epm/

EPM Job Aids Updated Reporting Table to Role Mapping EPM REPORTING TABLE or SECURITY

EPM Job Aids Updated Reporting Table to Role Mapping EPM REPORTING TABLE or SECURITY ACCESS NODE ROLENAME CT_LEDG_KK_BAL CT ACCOUNT CODE PROCESSOR CT_LEDG_KK_BAL CT AGY GL APPROVER CT_LEDG_KK_BAL CT AGY GL REVIEWER CT_LEDG_KK_BAL CT AGY GL SYS TECH RESOURCE CT_LEDG_KK_BAL CT AGY MANUAL RECON PROCESSOR CT_LEDG_KK_BAL CT CNTRL GL APPROVER CT_LEDG_KK_BAL CT CNTRL GL REVIEWER CT_LEDG_KK_BAL CT CNTRL GL SYS TECH RESOURCE CT_LEDG_KK_BAL CT CNTRL PAYMENT REVIEWER CT_LEDG_KK_BAL CT CNTRL PAYMENT RPT INQUIRER CT_LEDG_KK_BAL CTGLREPORTING

Questions?

Questions?

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training õ GL Steve

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training õ GL Steve Perkins Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon

Core-CT Training – Manager Guides TSummarizes knowledge a supervisor or manager should have TAccounts

Core-CT Training – Manager Guides TSummarizes knowledge a supervisor or manager should have TAccounts Payable, Supply Chain, Inventory TAsset Management TAccounts Receivable / Billing TProject Costing / Customer Contracts THelp Desk, EPM TGeneral Ledger / Commitment Control

Core-CT Training – Manager Guides TSections of the Guide TOverview THigh level graphic view

Core-CT Training – Manager Guides TSections of the Guide TOverview THigh level graphic view TBulleted information TLinks to more detailed information TReports associated with the module TOther sections as needed

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ GL Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon

GL Agenda õ Reminders / Hot Topics õ Budget Ledger Review õ GL Mini-Training

GL Agenda õ Reminders / Hot Topics õ Budget Ledger Review õ GL Mini-Training õ Detail and Summary Revenue Report

GL Reminders & Hot Topics Reminders T MP 8 Upgrade T FIN Reporting Tools

GL Reminders & Hot Topics Reminders T MP 8 Upgrade T FIN Reporting Tools vs. EPM/HR Reporting Tools T CFSR Navigation in Report Manager Hot Topics T Reports for Multiple Ledgers T Updated Ledger Job Aid

CFSR Report Manager Navigation: FIN Reporting Tools > Report Manager: Administration Tab

CFSR Report Manager Navigation: FIN Reporting Tools > Report Manager: Administration Tab

GL Reminders & Hot Topics Reminders T MP 8 Upgrade T FIN Reporting Tools

GL Reminders & Hot Topics Reminders T MP 8 Upgrade T FIN Reporting Tools vs. EPM/HR Reporting Tools T CFSR Navigation in Report Manager Hot Topics T Reports for Multiple Ledgers T Updated Ledger Job Aid

Reports for Multiple Ledgers T General Ledger>… T Flexible Ledger Analysis T Ledger Activity

Reports for Multiple Ledgers T General Ledger>… T Flexible Ledger Analysis T Ledger Activity T Trial Balance T Expenditure Report by Object T Detail and Summary Revenue T Cash Ledger

Ledger Job Aid Financials User Support > General Ledger/Chart of Accounts > General Ledger

Ledger Job Aid Financials User Support > General Ledger/Chart of Accounts > General Ledger Job Aids > Ledgers

GL Agenda õ Reminders / Hot Topics õ Budget Ledger Review õ GL Mini-Training

GL Agenda õ Reminders / Hot Topics õ Budget Ledger Review õ GL Mini-Training õ Detail and Summary Revenue Report

Control vs. Track Budgets T Control: Agencies post budget journals. Transactions must fall within

Control vs. Track Budgets T Control: Agencies post budget journals. Transactions must fall within the available budget to pass budget check. T Track: Agencies do not post budget journals. All transactions pass budget check for this ledger, and are recorded/tracked for reporting purposes. T Track w/Budget: Agencies can post budget journals. All transactions pass budget check for this ledger, and are recorded/tracked against the budgeted amount for reporting purposes only.

Agency Budgets break down Allotment budgets into lower, Department and/or Account levels of detail

Agency Budgets break down Allotment budgets into lower, Department and/or Account levels of detail for controlling spending and/or reporting. Agency Budgets may differ from appropriated. However, budget control will ultimately always reside at Appropriation/Allotment.

Agency Budgets Agency 1 (KK_AGY 1): T Agencies can control and/or report on funds

Agency Budgets Agency 1 (KK_AGY 1): T Agencies can control and/or report on funds based on agency defined departments, usually higher levels such as divisions, bureaus, facilities, etc. T May be established as control or track. T Agency Fiscal Administrative Reviewers must create and maintain agency budgets. T Non-Lapsing Funds carried forward at FYE

Agency Budgets Agency 2 (KK_AGY 2): T Agencies can report on funds based on

Agency Budgets Agency 2 (KK_AGY 2): T Agencies can report on funds based on agency defined departments, usually lower levels, such units, cost center, etc. T Agencies can also report on expenditures at the detail account level, just as they are posted in GL. T Established as track budget. It is used for reporting purposes only. T FYE balances are not carried forward

Project Budgets (KK_PRJ) are based on agency defined Project ID values. Budgets may differ

Project Budgets (KK_PRJ) are based on agency defined Project ID values. Budgets may differ from the Appropriation. However, budget control will ultimately always reside at Appropriation/Allotment. Project IDs ending in NONPROJECT are NOT RECORDED here. They are tracked on the Agency 1 and/or Agency 2 budget structures.

Project Budgets Project 1 (KK_PRJ 1): T Agencies can control and/or report on funds

Project Budgets Project 1 (KK_PRJ 1): T Agencies can control and/or report on funds based on agency defined Project IDs. T May be established as control or track. T Agency Fiscal Administrative Reviewers must create and maintain project budgets. T Non-Lapsing Funds carried forward at FYE

Project Budgets Project 2 (KK_PRJ 2): T Agencies can control and/or report on funds

Project Budgets Project 2 (KK_PRJ 2): T Agencies can control and/or report on funds based on agency defined Project IDs, along with the detail account level, just as they are posted in GL. T May be established as control or track. T Agency Fiscal Administrative Reviewers must create and maintain project budgets. T FYE balances are not carried forward

Project Budgets Project 3 (KK_PRJ 3): T Agencies can control and/or report on funds

Project Budgets Project 3 (KK_PRJ 3): T Agencies can control and/or report on funds based on agency defined Project IDs, along with agency defined Chartfield 1 values. T May be established as control or track. T Agency Fiscal Administrative Reviewers must create and maintain project budgets. T FYE balances are not carried forward

Project Costing Budgets Project Costing module (KK_PC) budgets are ONLY used by those Agencies

Project Costing Budgets Project Costing module (KK_PC) budgets are ONLY used by those Agencies that participate in Core-CT Project Costing. Project Budgets may differ from the Appropriation. However, budget control will ultimately always reside at Appropriation/Allotment. Project IDs that are not used in the Project Costing module are NOT RECORDED here. They are tracked on the AGY or PRJ budget structures.

GL Agenda õ Reminders / Hot Topics õ Budget Ledger Review õ GL Mini-Training

GL Agenda õ Reminders / Hot Topics õ Budget Ledger Review õ GL Mini-Training õ Detail and Summary Revenue Report

GL Mini-Training Detail and Summary Revenue Report Navigation: General Ledger > General Reports> Detail

GL Mini-Training Detail and Summary Revenue Report Navigation: General Ledger > General Reports> Detail and Summary Revenue

GL Mini-Training Detail and Summary Revenue Report

GL Mini-Training Detail and Summary Revenue Report

GL Mini-Training Detail and Summary Revenue Report MOD_ACCRL + MOD_CASH = collected revenues and

GL Mini-Training Detail and Summary Revenue Report MOD_ACCRL + MOD_CASH = collected revenues and collected refunds of expenditure.

GL Mini-Training Detail and Summary Revenue Report

GL Mini-Training Detail and Summary Revenue Report

Questions?

Questions?

Coffee Break

Coffee Break

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ GL Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon

Billing Agenda õ Reminders / Hot Topics õ ET/ST Bill Type Distribution Coding õ

Billing Agenda õ Reminders / Hot Topics õ ET/ST Bill Type Distribution Coding õ Billing BATCH Processing Schedule õ Mini-Training õ Adjust Entire Bill vs. Adjust Selected Bill Lines õ Online Inquiries

ET/ST Distribution Coding

ET/ST Distribution Coding

ET/ST Distribution Coding Option 1: Change your account code Option 2: Change your Bill

ET/ST Distribution Coding Option 1: Change your account code Option 2: Change your Bill Type

Billing BATCH Processes BIJOB 01 BICURCNV BIPRELD Finalize and Print Invoice Convert Currency Amounts

Billing BATCH Processes BIJOB 01 BICURCNV BIPRELD Finalize and Print Invoice Convert Currency Amounts Pre-Load Process Run Anytime 10 AM, 12 Noon, 2 PM, Nightly BILDAR 01 Load Invoices to AR FS_BP BILDGL 01 Request Budget Check Create Accounting Entries 10 AM, 12 Noon, 2 PM, Nightly ARUPDATE CTARB 272 PS/AR Receivables Update AR Revenue Reversal Generate Journals 12 Noon, Nightly 3 PM, Nightly FS_JGEN

Billing Summary T NAVIGATION: Billing Review Billing Information Summary Bill Summary Info 2 tab

Billing Summary T NAVIGATION: Billing Review Billing Information Summary Bill Summary Info 2 tab

MINI-TRAINING: Adjustments T NAVIGATION: Billing Maintain Bills Adjust Entire Bill OR Adjust Selected Bill

MINI-TRAINING: Adjustments T NAVIGATION: Billing Maintain Bills Adjust Entire Bill OR Adjust Selected Bill Lines T Prerequisites T Adjust Entire Bill T Bill must be Invoiced T Bill must not have been previously adjusted T Adjust Selected Bill Lines T Bill must be Invoiced T Bill must not have been previously adjusted T Bill should contain multiple Bill Lines

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit Entire Bill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjust Entire Bill T Credit & Rebill

MINI-TRAINING: Adjustment History T NAVIGATION: Billing Review Billing Information Adjustment History

MINI-TRAINING: Adjustment History T NAVIGATION: Billing Review Billing Information Adjustment History

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line 1) Select Radio Button. 3) Choose

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line 1) Select Radio Button. 3) Choose Credit Line. 4) Select Bill Line to Adjust. 2) Click OK.

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line

MINI-TRAINING: Adjust Selected Bill Lines T Credit Line

MINI-TRAINING: Adjust Selected Bill Lines 1) Select Radio Button. T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines 1) Select Radio Button. T Create Reversal and Rebill 3) Choose Create Reversal and Rebill. 4) Select Bill Line to Adjust. 2) Click OK.

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Adjust Selected Bill Lines T Create Reversal and Rebill

MINI-TRAINING: Review Line History T NAVIGATION: Billing Review Billing Information Review Line History T

MINI-TRAINING: Review Line History T NAVIGATION: Billing Review Billing Information Review Line History T Adjustment Line Summary

MINI-TRAINING: Review Line History T Adjustment Line History

MINI-TRAINING: Review Line History T Adjustment Line History

MINI-TRAINING: Adjustments T Adjust Entire Bill T Credit Entire Bill T 1 Credit Invoice

MINI-TRAINING: Adjustments T Adjust Entire Bill T Credit Entire Bill T 1 Credit Invoice Created T Set to RDY Status T Cannot Modify T Credit and Rebill T Adjust Selected Bill Lines T Credit Line T 1 Credit Invoice Created T Set to NEW Status T Cannot Modify T Create Reversal and Rebill T 2 Invoices Created T 1 Credit Invoice T 1 Rebill Invoice T Bill Line 1 consists of Credit Line T Bill Line 2 consists of Rebill Line T Can Modify Rebill Invoice Only T Can Modify Rebill Line Only

Questions?

Questions?

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training Steve Perkins õ GL Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon

AR Agenda õ Reminders / Hot Topics õ Case Sensitive Bill Numbers õ OSCIP

AR Agenda õ Reminders / Hot Topics õ Case Sensitive Bill Numbers õ OSCIP Deposits õ AR Mini-Training õ Incorrect GIRO payments

AR Reminders & Hot Topics T Reminder T Clear your deposit pick list daily

AR Reminders & Hot Topics T Reminder T Clear your deposit pick list daily T Deposits need to be applied or direct journaled daily T Call the Helpdesk for help to clean up your deposits T Do not wait until the end of the month – this leaves little time to troubleshoot

AR Reminders & Hot Topics Case Sensitive Bill Numbers T When you are applying

AR Reminders & Hot Topics Case Sensitive Bill Numbers T When you are applying a payment from a voucher T the payment reference # is entered exactly as it is on the voucher T if you use upper or lower case letters or put spaces then, Payment Predictor will not match up the voucher and the bill T a payment worksheet that will not build due to mismatch of letters, then it needs to be deleted and the payment ID on the deposit corrected

AR Reminders & Hot Topics T If the debtor agency does not enter your

AR Reminders & Hot Topics T If the debtor agency does not enter your billing invoice number the same way you have billed them for, Payment Predictor will not pick it up.

AR Reminders & Hot Topics This invoice number needs to match the bill number

AR Reminders & Hot Topics This invoice number needs to match the bill number

AR Reminders & Hot Topics This reference number comes in from the invoice number

AR Reminders & Hot Topics This reference number comes in from the invoice number of the voucher

AR Reminders & Hot Topics Note the same reference number from the voucher

AR Reminders & Hot Topics Note the same reference number from the voucher

AR Reminders & Hot Topics This is blank because the invoice number is not

AR Reminders & Hot Topics This is blank because the invoice number is not recognized

AR Reminders & Hot Topics First, hit the minus button to delete the row

AR Reminders & Hot Topics First, hit the minus button to delete the row Second, add in the correct reference number

AR Reminders & Hot Topics Now you see the bill info

AR Reminders & Hot Topics Now you see the bill info

AR Reminders & Hot Topics OSCIP Deposits This is a deposit from the Central

AR Reminders & Hot Topics OSCIP Deposits This is a deposit from the Central Payroll Interface

AR Reminders & Hot Topics Note the location, reference number and the payment predictor

AR Reminders & Hot Topics Note the location, reference number and the payment predictor checkbox

AR Mini-Training INCORRECT GIRO DEPOSITS Note the DOT GIRO Deposit. It should not go

AR Mini-Training INCORRECT GIRO DEPOSITS Note the DOT GIRO Deposit. It should not go to this agency.

AR Mini Training 1. DPH determines that this is not a payment that they

AR Mini Training 1. DPH determines that this is not a payment that they had billed for. They research and find out the funds do not belong to them. They put in a ticket to the CORE Helpdesk with all the information about the deposit. 2. The Helpdesk will be able to find the original voucher and will call back the agency with all the information they need to contact the originating agency and make arrangements to send the funds back by using a NONPO Voucher. 3. The receiving agency, in this case, DPH, will direct journal this deposit with all the proper coding for Funds Awaiting Distribution (Pending Receipts). 4. This coding is: FUND: 34003, SID: 42350, and ACCOUNT: 20920

AR Mini Training 5. After the journal has been completed, a copy needs to

AR Mini Training 5. After the journal has been completed, a copy needs to go to the Accounts Payable department so they can create a NON-PO Voucher. They will use the correct address for the originating agency so it will go back to them as a GIRO. The Invoice on the voucher must use “GIRO” followed by the Payment ID on the deposit. They will put the information about the incorrect GIRO in the “Comments Link” and “Description” of the voucher so there will be an audit trail. Accounts Payable will use the same coding string that is on the direct journal. 6. This will be a wash for the incorrect deposit. It will not be in the receiving agency’s budget. It will show in the Pending Receipts account in the General Ledger as a debit and a credit, netting to -0 -.

AR Mini-Training The Payment ID on the deposit needs to be inserted as the

AR Mini-Training The Payment ID on the deposit needs to be inserted as the invoice number on the voucher

AR Mini-Training Look at the invoice number on this voucher, it HAS TO BE

AR Mini-Training Look at the invoice number on this voucher, it HAS TO BE the Payment ID from the deposit.

AR Mini-Training The originating agency will now be getting the funds back in their

AR Mini-Training The originating agency will now be getting the funds back in their deposit list as a GIRO. It is up to them to ensure they direct journal the deposit with the same expenditure coding as they had on the original incorrect voucher. Once this is done, the cycle has been completed. The agency can now process their payment correctly. They should add a comment on the new voucher to tie the new payment to the incorrect one for an audit trail.

AR Mini-Training T A CO-790 S must be completed and sent to the Office

AR Mini-Training T A CO-790 S must be completed and sent to the Office of the State Comptroller's Accounts Payable Division. A payment sent in error constitutes an overpayment and therefore requires a CO-790 S, which must identify 1) the procedures that led to the issuance of the overpayment, 2) the internal controls in place at the time the overpayment was made, and 3) a description of how a recurrence will be prevented; this form must be signed by the agency head or deputy. The CO-790 will not be sent with the required CO-790 S.

Questions?

Questions?

Closing Thank You for your participation today. We hope this information proved helpful… í

Closing Thank You for your participation today. We hope this information proved helpful… í Look for this presentation and meeting Q & A’s on the Core-CT Website www. core-ct. state. ct. us í Next Meeting GL/AR/BI User Group Meeting is on January 29 th ***(DON’T FORGET TO SIGN UP) í AP/PO User Group Meeting on January 31 st & February 5 th