1 / 79

STATE OF CONNECTICUT Core-CT Project

STATE OF CONNECTICUT Core-CT Project. Financials User Group Meeting AR / GL / Billing April 2005. Agenda. GL Critical Reminders & Hot Topics Running CFSR Reports Encumbrance Balance Report Combining Mod_Accrl and Mod_Cash for reporting New GL Activity EPM Query AR/Billing

fischere
Download Presentation

STATE OF CONNECTICUT Core-CT Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. STATE OF CONNECTICUTCore-CT Project Financials User Group MeetingAR / GL / Billing April 2005

  2. Agenda • GL • Critical Reminders & Hot Topics • Running CFSR Reports • Encumbrance Balance Report • Combining Mod_Accrl and Mod_Cash for reporting • New GL Activity EPM Query • AR/Billing • ET, ST, GT – What to use and when? • Proper Account Code and Revenue Distributions • Useful AR Reports & Queries • Year End Cleanup • EPM Updates

  3. Agenda • GL • Critical Reminders and Hot Topics • Running CFSR Reports • Encumbrance Balance Report • Combining MOD_ACCRL and MOD_CASH for reporting • New GL Activity Query

  4. Reminders & Topics GL Critical Reminders • Budget Journal Date • Report Processing • Carry-Forward Budgets • Payment Acctg Date Hot Topics • CFSR Reports

  5. Budget Journal Date The Budget Journal Date must fall within the appropriate Budget Period.

  6. Budget Journal Date

  7. Report Processing • Fin PeopleTools> Process Scheduler> Process Monitor

  8. Report Processing

  9. Carry-Forward Budgets • Control Budgets Only • APPROP • ALLOT • AGY1 • PRJ1

  10. These will now be the same. Payment Accounting Date

  11. CFSR Reports • Distributed last business day of the month. • CFSRs can be run Ad-Hoc at any time, for any month-end.

  12. Ad-Hoc CFSR Request

  13. Ad-Hoc CFSR Request This actually works!

  14. Ad-Hoc CFSR Request Scope Required Scope = AGY

  15. Core-CT – Financial User Support – GL Job Aids • Updated CFSR Job Aid ! • Add New Report Request • Scope Value Required

  16. Encumbrance Report

  17. Encumbrance Report

  18. 18,243.27 Pre-Encumbrance Report

  19. Budget Details

  20. Rolled POs show 2 Transaction IDs Encumbrance Report

  21. Look for Closed POs encumbering funds. Encumbrance Report

  22. Encumbrance Report • Documents that make up encumbrance balance • Rolled POs may show twice • Use to research Encumbrance Balances • Closed POs • POs in Error • Change Orders Not Checked

  23. New EPM GL Queries • CT_CORE_FIN_GL_MODACCR_MODCASH • CT_CORE_FIN_MOD_ACCR_CSH_JRN • CT_CORE_FIN_GL_ACTIVITY

  24. CT_CORE_FIN_GL_MODACCR_MODCASH • Ledger balances • Research data on Collected Revenue • Analyze deposits posted to GL • Reconcile Billed expenses between GL and KK ledgers

  25. Analyze Data in Excel

  26. Revenue Collected?

  27. Expense Accounts on Bills? KK_Ledger is not updated until payment is applied.

  28. CT_CORE_FIN_MOD_ACCR_CSH_JRN • Similar to MODACCR_MODCASH Query • Specific Journal ID/Source information • Specific Department ID will improve performance • Schedule Query

  29. Journal and Source Information

  30. CT_CORE_FIN_GL_ACTIVITY • List of Journal IDs that make up a particular General Ledger balance • Posted Amount by Period

  31. Schedule Query to run to Excel CT_CORE_FIN_GL_ACTIVITY

  32. Use Pivot Tables to analyze the data. CT_CORE_FIN_GL_ACTIVITY

  33. 10-Minute Break

  34. AR/Billing • Billing Types - ET, ST, GT • Correct Accounting Codes • Payment Predictor Can Work for You • Auto Maintenance Creates $0 Deposits • Useful Reports & EPM Queries • Year End Cleanup

  35. Critical Reminders • Start Cleanup Now • AR / Billing Labs • Aging Reports • Pending Receipts • Credits • On Account Payments • Maintenance Worksheets Hot Topics • Splitting Deposits - Workaround • Credit/New Bill vs. Credit/Rebill

  36. Bill Types - Guidelines

  37. Bill Types - Guidelines

  38. Is this a problem?

  39. Is this a problem?

  40. Is this a problem?

  41. Is this a problem?

  42. This should be an ET

  43. GT’s are between State agencies

  44. So far so good…..

  45. Proper use of account code

  46. Is this a problem?

  47. AR> Collection> Item Information> Item Status

  48. AR> Collections> Aging Reports> Aging Detail by Unit Sales Person = Business Category

  49. AR> Collections> Aging Reports> Aging Detail by Unit Choosing a value in this field allows you to filter your Aging Reports for a single Business Category

  50. AR> Collections> Aging Reports> Aging Detail by Unit

More Related