240 likes | 343 Views
On the Hunt for CORe Information Being a CORe Power User by Sue Losen 05/08/14. http://dwd.wisconsin.gov/core/. Quick Links. Quick Links CORe Reports Contacts for CORe Helpful Resources Dept. of Children & Families. Reporting to DCF. Data entered from agency books Submit via email
E N D
On the Hunt for CORe Information Being a CORe Power UserbySue Losen05/08/14
Quick Links • Quick Links • CORe Reports • Contacts for CORe • Helpful Resources • Dept. of Children & Families
Reporting to DCF Data entered from agency books Submit via email No certification No paper CORe revisions are always replacements
Reporting to DCF File name and email subject line Found on Form County # County Name Report Month Year • 06 Buffalo Cty 05 14 • 13 Dane Shared 05 14 • 05 Brown EC Q2 14
Program Specific • 2013 State County Contract for Social or Human Services • October DocuSign • Child Support
Payment Process Daily Activities • Expenditure Reports are uploaded to CORe system • CORe website reports update overnight
Payment Process Monthly • 28th - Expenditure Reports due by 4:30 • 2nd or 3rd- Bank Reconciliation Report should show scheduled payments • 5th - ACH Deposit made to your agency’s bank account
Numerous CORe Reports Available Contract Balance by Agency Expenditure Information Payment Information Special Program Reports
Situations How much money is my agency receiving at the next payment date? Why didn’t I receive the amount of money I requested? It is a long contract, what is my spending rate?
Payment Reconciliation • Agency user and email errors • Forgot to hit send • Caught by spam filter • State agency and email errors • Spam filters • Missed processor • Code causing reject • Special character
CORe Reports“Reconciliation Tools” • Monthly Expense Detail • Contract Balance Report • Bank Deposits Reconciliation • Agency Contract Detail
Monthly Expense Detail Report Best place to verify if DWD/DCF 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 Agency has not filed their April report.
Bank Deposit Reconciliation ReportPeace of Mind for Treasures and Auditors 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’
Contract Balance by Agency Where am I financially? Shows a ‘snapshot’ of your agency’s status through the month you select. Shows: Contract Amounts (Zero if “non capped”) Total expenditures reported to date Total reimbursements received to date Any pending payments
Contract Code Contract Name Start Period End Period Contract Amount Expenditure Amount Amount Spent % Prepayment Reimbursement Exp not reimbursed Over Contract Contract Balance Cash Position Example: Contract Balance
Agency Contract Detail - Monthly • The “what did Madison do to my numbers report?”
Agency Contract Detail - Monthly • For the selected month: • Shows Expenditure and Payment data “side by side” • Includes column showing State Uploads/adjustments
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
Any Questions ???? Thank you for inviting me! Wishing You A Successful Hunt • Sue Losen • 608 -266-7915 • sue.losen@wisconsin.gov • http://dwd.wisconsin.gov/core/