360 likes | 519 Views
CORe Introduction by Sue Losen 06/12/12. CORe. General Information CORe Website Agency Reporting Requirements Submitting Expenditures Reports Q & A. CORe History & Description. A Grant Payment System Contract Control RMS Cost Allocation ACH Payments . CORe Cycle.
E N D
CORe General Information CORe Website Agency Reporting Requirements Submitting Expenditures Reports Q & A
CORe History & Description • A Grant Payment System • Contract Control • RMS Cost Allocation • ACH Payments
CORe Helpful Resources http://dwd.wisconsin.gov/core/resources/default.htm
Getting Started http://dwd.wisconsin.gov/core/gettingstarted.htm
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 County # County Name Report Month Year • 06 Buffalo Cty 06 12 • 13 Dane Shared 06 12 • 05 Brown EC Q2 12
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
Numerous CORe Reports Available Special Program Reports RMS Cost Allocation (counties only) W-2 Monitoring
Reference Report Navigation and Printing Tips Agency Code List Chart of CORe Accounts Numerous CORe Reports Available
Issues I don’t have time to look at reports; my internet is slow. I don’t know what they mean and when to use each one.
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 Why spend the time? It is your money. If some thing can go, wrong it will.
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 “The I hope my submission got there report” If you have 2 minutes check this one out.
Monthly Expense Detail Report Best place to verify if 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 Report “The peace of mind for treasurers and auditors 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’
Contract Balance by Agency Report • The “where am I financially” report
Contract Balance by Agency 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
Example: Contract Balance • 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
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
Contact Us CORe Accountants in DWD Finance: Sue Losen 608/266-7915 Sue.Losen@wisconsin.gov Rebecca Mogensen 608/267-1366 Rebecca.Mogensen@wisconsin.gov
Core Information Thank you for inviting me! • Sue Losen • 608 -266-7915 • sue.losen@wisconsin.gov