child support directors dialogue n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Child Support Directors’ Dialogue PowerPoint Presentation
Download Presentation
Child Support Directors’ Dialogue

Loading in 2 Seconds...

play fullscreen
1 / 36

Child Support Directors’ Dialogue - PowerPoint PPT Presentation


  • 87 Views
  • Uploaded on

Child Support Directors’ Dialogue. CORe Reporting & Reconciling April 15 th 2011. Child Support Directors’ Dialogue. CORe Reporting & Reconciling. Agenda. Using the CORe Website Submitting Your Reports CORe Reporting Reconciling CORe to Your Books. CORe Cycle.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Child Support Directors’ Dialogue' - jam


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
child support directors dialogue

Child Support Directors’ Dialogue

CORe Reporting & Reconciling

April 15th 2011

agenda
Agenda
  • Using the CORe Website
  • Submitting Your Reports
  • CORe Reporting
  • Reconciling CORe to Your Books
getting started
Getting Started

http://dwd.wisconsin.gov/core/gettingstarted.htm

core helpful resources
CORe Helpful Resources

http://dwd.wisconsin.gov/core/resources/default.htm

cs allocation map
CS Allocation Map

http://dwd.wisconsin.gov/core/program_descriptions/child_support.htm

submitting expenditure reports
Submitting Expenditure Reports
  • Resources if you have questions about how to report expenditures:
    • Child Support Bulletinhttp://dcf.wisconsin.gov/bcs/bulletins/
    • CORe Definitions pagehttp://dwd.wisconsin.gov/core/program_descriptions/default.htm
submitting expenditure reports1
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.

slide12

Submitting Expenditure Reports Monthly

  • Save completed report using thestandard file name format:County # County Name Program Month YearFor example: 99 Badger CS 05 2011.xls
  • Newer version of Excel?
    • No problem
  • Email file to DCFDESFinanceGrants@wisconsin.gov
core reports
CORe Reports
  • Contract Balance Report
  • Agency Contract Detail
  • Monthly expense Detail
  • Bank Deposits Reconciliation
core reports1
CORe Reports

http://dwd.wisconsin.gov/core/reports.htm

contract balance by agency report
Contract Balance by Agency Report
  • The where am I financially report
contract balance by agency
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
agency contract detail monthly
Agency Contract Detail - Monthly
  • The “what did Madison do to my numbers report?”
agency contract detail monthly1
Agency Contract Detail - Monthly
  • For the selected month:
    • Shows Expenditure and Payment data “side by side”
    • Includes column showing State Uploads/adjustments
monthly expense detail report
Monthly Expense Detail Report
  • The I hope my submission got there report and more
monthly expense detail report1
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
Example: Monthly Exp. Detail

In this example, the State upload file has not been processed for March, but the CS Agency has filed their March report.

bank deposit reconciliation report
Bank Deposit Reconciliation Report
  • The peace of mind for treasurers and auditors report.
bank deposit reconciliation report1
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
Example: Bank Reconciliation
  • Default view is ‘by date’
example bank reconciliation1
Example: Bank Reconciliation
  • 2nd tab is ‘by agency’
payment process
Payment Process

Daily Activities

  • Expenditure Reports are uploaded to CORe system
  • CORe website reports update overnight
payment process1
Payment Process

Quarterly

  • 23rd - Expenditure Reports due by 4:30 PM of April (25th), July(25th), October (24th), January
  • 28th or 28th - Bank Reconciliation Report should show scheduled payments
  • 30th - ACH Deposit made to your agency’s bank account
payment process2
Payment Process

Quarterly

  • MSL -7333 and FPLS uploaded to last month of quarter-March, June, September, December (7332)
  • 7463 Mixed Child support cleared quarter-March, June, September, December
payment process3
Payment Process

Quarterly

For CS agencies part of Human services Allocated AMSO 7468 uploaded to last month of quarter-March, June, September, December

May be later since agencies have a 28th deadline

payment reconciliation
Payment Reconciliation

RMS process depends on manual intervention, formulas.

100% Prepayment means recognizing earned income.

It is your money.

oops error corrections
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
Contact Us

CORe Accountants in DWD Finance:

Sue Losen 608/266-7915

Sue.Losen@wisconsin.gov

Madhu Dharma 608/267-1366

Madhu.Dharma@wisconsin.gov

BCS Accountant:

Dianne Bahr 608/261-4412

Dianne.Bahr@wisconsin.gov

any questions
Thank you for inviting me today.

Feel free to contact me with your questions at any time.

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

Any questions?