STATE OF CONNECTICUT CoreCT Agenda Welcome John Harnick
- Slides: 92
STATE OF CONNECTICUT Core-CT
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 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 1 í For complex issues, send email to: Core. Support@po. state. ct. us
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 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: õ õ õ 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 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 Inaccurate Join Criteria Spreadsheet
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 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?
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 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 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 õ GL Donna Braga Joan Skripol õ Billing Chris Marchese õ AR Lynn Sheldon
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 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
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 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 Job Aids > Ledgers
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 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 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 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 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 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 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 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 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 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 õ Detail and Summary Revenue Report
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 MOD_ACCRL + MOD_CASH = collected revenues and collected refunds of expenditure.
GL Mini-Training Detail and Summary Revenue Report
Questions?
Coffee Break
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 BATCH Processing Schedule õ Mini-Training õ Adjust Entire Bill vs. Adjust Selected Bill Lines õ Online Inquiries
ET/ST Distribution Coding
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 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
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 & 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: 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 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: 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: 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?
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 Deposits õ AR Mini-Training õ Incorrect GIRO payments
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 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 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 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 This is blank because the invoice number is not recognized
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 OSCIP Deposits This is a deposit from the Central Payroll Interface
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 to this agency.
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 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 invoice number on the voucher
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 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 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?
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
- Ct state comptroller
- John haynes connecticut
- Common core state standards ct
- Southern connecticut state university public health
- Sexting laws in ct
- Agenda sistemica y agenda institucional
- Uconn corect
- Inscriete sau inscrie-te corect
- Choose correct item
- Choose the correct item look he has
- Cum circulam
- Corect
- Alegeti litera din dreptul raspunsului corect
- Corect time
- Scrieti prin enumerarea elementelor multimea literelor
- Choose. the. correct. answer
- Trasaturi asemanatoare si diferite pentru praslea si zmeu
- Testul familiei interpretare
- Mvp corect ltd
- Meeting agenda welcome and introductions
- Agenda welcome and introductions
- Agenda welcome and introductions
- Agenda welcome and introductions
- Agenda welcome and introductions
- Agenda welcome
- Agenda welcome and introductions
- Welcome session agenda
- Meeting agenda welcome and introductions
- Agenda welcome and introductions
- Welcome agenda
- Agenda welcome and introductions
- Agenda for parent orientation
- Agenda welcome and introductions
- Agenda welcome and introductions
- Wise men three clever are we
- Ex post facto law
- Decd
- Connecticut college transfer
- Megan kanka
- Willimantic ct map
- Statewide automated victim information notification
- New haven connecticut
- Ct j1 waiver
- Ctsecurebrowser
- Ct mandated reporter training
- Connecticut plumbing license
- Boddie v connecticut
- Connecticut early childhood education cabinet
- Maine coastline length
- Connecticut sales tax exemptions
- Connecticut judicial branch
- Ct educator certification lookup
- Connecticut surplus lines tax
- Wic approved juice
- Connecticut judicial districts
- Tcs connecticut
- Started an all-female academy in hartford, connecticut.
- Dow safety training
- Properties of liquid state
- State to state regionalism
- Sr ff excitation table
- Encoding bugs in software testing
- Svjetlana kalanj bognar
- Define shell and subshell
- Difference between hemoglobin and myoglobin
- Absorptive state vs postabsorptive state
- Absorptive state vs postabsorptive state
- Age of consent per state
- Current state vs future state diagram
- Equivalent state
- New state drink
- State graphs in software testing
- What is initial state + goal state in search terminology?
- Tasscc state of the state
- Submachine state in state diagram
- Preseason coaches meeting agenda
- Meet and greet agenda
- Housekeeping meeting agenda
- Gregory bateson framing theory
- Football coaches meeting agenda
- Kick off møde agenda
- Agenda web tag questions
- Belinda doyle
- Cft meeting questions
- Tonights agenda
- Q class agenda
- Agenda modal verbs
- What does smh mean
- The wieners agenda
- Kelebihan agenda setting
- Tender briefing agenda
- The standard agenda
- Meeting objective