240 likes | 355 Vues
This document outlines essential reporting guidelines and resources for Child Support Directors, focusing on CORe reporting and expenditure submission. Key reports include the Contract Balance by Agency, Monthly Expense Detail, and Bank Deposits Reconciliation, which provide insights into agency financial status and expenditure tracking. Steps for submitting expenditure reports are detailed, including templates and file naming conventions. Contact information for CORe accountants is provided for any queries. Ensure accurate reporting and compliance with the outlined timelines.
E N D
Child Support Directors’ DialogueCORe Reporting Stevens Point – April 25, 2008
Agenda • CORe Website • CORe Reporting
Getting Started http://dwd.wisconsin.gov/core/gettingstarted.htm
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
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
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)?
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:
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
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.
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
Example: Bank Reconciliation • Default view is ‘by date’
Example: Bank Reconciliation • 2nd tab is ‘by agency’
CORe Helpful Resources http://dwd.wisconsin.gov/core/resources/default.htm
CS Allocation Map http://dwd.wisconsin.gov/core/resources/cs_allocation_map.htm
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.
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
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.
Payment Process Daily • Expenditure Reports uploaded to CORe system • CORe website reports update overnight
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
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
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
Any questions? http://dwd.wisconsin.gov/core/