Child Support Directors’ Dialogue CORe Reporting

1. Child Support Directors’ DialogueCORe Reporting Stevens Point – April 25, 2008

2. Agenda • CORe Website • CORe Reporting

3. CORe Cycle

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

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

6. Four reports to highlight: • Contract Balance by Agency • Agency Contract Detail - Monthly • Monthly Expense Detail • Bank Deposits Reconciliation CORe Reports http://dwd.wisconsin.gov/core/reports.htm

7. 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

8. Example: Contract Balance “Badger” County’s March 2008 Contract Balance report • Badger County has $35,000 in Regular Expenses to report for April. • Which line(s) should they report on? • What amount(s)?

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

10. 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

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

12. 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

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

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

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

16. CS Allocation Map http://dwd.wisconsin.gov/core/resources/cs_allocation_map.htm

17. 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.

18. Submitting Expenditure Reports • Resources if you have questions about how to report expenditures: • Child Support Bulletinhttp://dwd.wisconsin.gov/bcs/bulletins/2008/CSB08-01r.pdf • CORe Definitions pagehttp://dwd.wisconsin.gov/core/program_descriptions/default.htm

19. Submitting Expenditure Reports • Save completed report using thestandard file name format:County # County Name Program Month YearFor example: 99 Badger CS 03 2008.xls • Newer version of Excel?: • save as .xls format (Microsoft Excel 5.0/95 Workbook). • Email file to dwdgrants@dwd.state.wi.us.

20. Payment Process Daily • Expenditure Reports uploaded to CORe system • CORe website reports update overnight

21. Payment Process Monthly • 23rd - Expenditure Reports due by 4:30 PM • 28th - Bank Reconciliation Report should show scheduled payments • 30th - ACH Deposit made to your agency’s bank account

22. Oops! Error Corrections What to do if you notice an error after you file a report? • 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

23. Contact Us CORe Accountants in DWD Finance: Sue Losen 608/266-7915 Sue.Losen@dwd.state.wi.us Amy Johnson 608/266-7847 Amy.Johnson@dwd.state.wi.us BCS Accountant: Dianne Bahr 608/261-4412 Dianne.Bahr@dwd.state.wi.us

24. Any questions? http://dwd.wisconsin.gov/core/