CORe Introduction by Sue Losen 06/12/12

1
CORe IntroductionbySue Losen 06/12/12
2
CORe

• General Information
• CORe Website
• Agency Reporting Requirements
• Submitting Expenditures
• Reports
• Q A

3
CORe History Description

• A Grant Payment System
• Contract Control
• RMS Cost Allocation
• ACH Payments

4
CORe Cycle
5
http//dwd.wisconsin.gov/core/
6
CORe Helpful Resources
http//dwd.wisconsin.gov/core/resources/default.ht
m
7
Getting Started
http//dwd.wisconsin.gov/core/gettingstarted.htm
8
Reporting to DCF

• Data entered from agency books
• Submit via email
• No certification
• No paper
• CORe revisions are always replacements

9

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

10
Payment Process

• Daily Activities
• Expenditure Reports are uploaded to CORe system
• CORe website reports update overnight

11
Payment Process

• Monthly
• 28th - Expenditure Reports due by 430
• 2nd or 3rd- Bank Reconciliation Report should
  show scheduled payments
• 5th - ACH Deposit made to your agencys bank
  account

12
Numerous CORe Reports Available

• Contract Balance by Agency 
• Expenditure Information 
• Payment Information 

13
Numerous CORe Reports Available

• Special Program Reports
• RMS Cost Allocation (counties only)
• W-2 Monitoring

14
Numerous CORe Reports Available

• Reference
• Report Navigation and Printing Tips 
• Agency Code List 
• Chart of CORe Accounts

15
Numerous CORe Reports Available
16
Issues

• I dont have time to look at reports my internet
  is slow.
• I dont know what they mean and when to use each
  one.

17
Situations

• How much money is my agency receiving at the next
  payment date?
• Why didnt I receive the amount of money I
  requested?
• It is a long contract, what is my spending rate?

18
Payment Reconciliation

• Why spend the time?
• It is your money.
• If some thing can go, wrong it will.

19
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

20
CORe ReportsReconciliation Tools

• Monthly Expense Detail
• Contract Balance Report
• Bank Deposits Reconciliation
• Agency Contract Detail

21
Monthly Expense Detail Report

• The I hope my submission got there report
• If you have 2 minutes check this one out.

22
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

23
Example Monthly Exp. Detail
In this example, the Agency has not filed their
April report.
24
Bank Deposit Reconciliation Report

• The peace of mind for treasurers and auditors
  report.

25
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

26
Example Bank Reconciliation

• Default view is by date

27
Example Bank Reconciliation

• 2nd tab is by agency

28
Contract Balance by Agency Report

• The where am I financially report

29
Contract Balance by Agency

• Shows a snapshot of your agencys 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

30
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

31
Example Contract Balance

32
Agency Contract Detail - Monthly

• The what did Madison do to my numbers report?

33
Agency Contract Detail - Monthly

• For the selected month
• Shows Expenditure and Payment data side by side
• Includes column showing State Uploads/adjustments

34
Oops! Error Corrections

• Best method add correction on next regular
  report
• If you resubmit an expenditure report, the entire
  months 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

35
Contact Us

• CORe Accountants in DWD Finance
• Sue Losen 608/266-7915
• Sue.Losen_at_wisconsin.gov
• Rebecca Mogensen 608/267-1366
• Rebecca.Mogensen_at_wisconsin.gov

36
Core Information
Thank you for inviting me!

• Sue Losen
• 608 -266-7915
• sue.losen_at_wisconsin.gov