1 / 36

Child Support Directors’ Dialogue

Child Support Directors’ Dialogue. CORe Reporting & Reconciling April 15 th 2011. Child Support Directors’ Dialogue. CORe Reporting & Reconciling. Agenda. Using the CORe Website Submitting Your Reports CORe Reporting Reconciling CORe to Your Books. CORe Cycle.

jam
Download Presentation

Child Support Directors’ Dialogue

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. Child Support Directors’ Dialogue CORe Reporting & Reconciling April 15th 2011

  2. Child Support Directors’ Dialogue

  3. CORe Reporting & Reconciling

  4. Agenda • Using the CORe Website • Submitting Your Reports • CORe Reporting • Reconciling CORe to Your Books

  5. CORe Cycle

  6. http://dwd.wisconsin.gov/core/

  7. Getting Started http://dwd.wisconsin.gov/core/gettingstarted.htm

  8. CORe Helpful Resources http://dwd.wisconsin.gov/core/resources/default.htm

  9. CS Allocation Map http://dwd.wisconsin.gov/core/program_descriptions/child_support.htm

  10. Submitting Expenditure Reports • Resources if you have questions about how to report expenditures: • Child Support Bulletinhttp://dcf.wisconsin.gov/bcs/bulletins/ • CORe Definitions pagehttp://dwd.wisconsin.gov/core/program_descriptions/default.htm

  11. Submitting Expenditure Reports • Start by selecting Child Support from the Forms page: http://dwd.wisconsin.gov/core/forms.htm Click attachment link to download and save Excel report form.

  12. Submitting Expenditure Reports Monthly • Save completed report using thestandard file name format:County # County Name Program Month YearFor example: 99 Badger CS 05 2011.xls • Newer version of Excel? • No problem • Email file to DCFDESFinanceGrants@wisconsin.gov

  13. CORe Reports • Contract Balance Report • Agency Contract Detail • Monthly expense Detail • Bank Deposits Reconciliation

  14. CORe Reports http://dwd.wisconsin.gov/core/reports.htm

  15. Contract Balance by Agency Report • The where am I financially report

  16. Contract Balance by Agency • Shows a ‘snapshot’ of your agency’s status though the month you select. • Shows: • Contract Amounts (Zero if “non capped”) • Total expenditures reported to date • Total reimbursements received to date • Any pending payments

  17. Example: Contract Balance

  18. Agency Contract Detail - Monthly • The “what did Madison do to my numbers report?”

  19. Agency Contract Detail - Monthly • For the selected month: • Shows Expenditure and Payment data “side by side” • Includes column showing State Uploads/adjustments

  20. Monthly Expense Detail Report • The I hope my submission got there report and more

  21. Monthly Expense Detail Report • Best place to verify if DWD has received and processed your expense report for the month • Summarizes all expenditures reported by your agency for the calendar year

  22. Example: Monthly Exp. Detail In this example, the State upload file has not been processed for March, but the CS Agency has filed their March report.

  23. Bank Deposit Reconciliation Report • The peace of mind for treasurers and auditors report.

  24. Bank Deposit Reconciliation Report • Shows payments sorted: • by deposit date, or • by agency • May take place of audit confirmation • PDF files available for ease of printing

  25. Example: Bank Reconciliation • Default view is ‘by date’

  26. Example: Bank Reconciliation • 2nd tab is ‘by agency’

  27. Payment Process Daily Activities • Expenditure Reports are uploaded to CORe system • CORe website reports update overnight

  28. Payment Process Quarterly • 23rd - Expenditure Reports due by 4:30 PM of April (25th), July(25th), October (24th), January • 28th or 28th - Bank Reconciliation Report should show scheduled payments • 30th - ACH Deposit made to your agency’s bank account

  29. Payment Process Quarterly • MSL -7333 and FPLS uploaded to last month of quarter-March, June, September, December (7332) • 7463 Mixed Child support cleared quarter-March, June, September, December

  30. Payment Process Quarterly For CS agencies part of Human services Allocated AMSO 7468 uploaded to last month of quarter-March, June, September, December May be later since agencies have a 28th deadline

  31. Payment Reconciliation RMS process depends on manual intervention, formulas. 100% Prepayment means recognizing earned income. It is your money.

  32. Payment Reconciliation

  33. Oops! Error Corrections • Best method – add correction on next regular report • If you resubmit an expenditure report, the entire month’s report must be resubmitted (original report plus the change). • NOTE: Instructions are same as for year-end closeout: http://dwd.wisconsin.gov/core/resources/report_after_grant_end.htm

  34. Contact Us CORe Accountants in DWD Finance: Sue Losen 608/266-7915 Sue.Losen@wisconsin.gov Madhu Dharma 608/267-1366 Madhu.Dharma@wisconsin.gov BCS Accountant: Dianne Bahr 608/261-4412 Dianne.Bahr@wisconsin.gov

  35. Thank you for inviting me today. Feel free to contact me with your questions at any time. http://dwd.wisconsin.gov/core/ Any questions?

  36. Have a peaceful and calming weekend

More Related