cash draw and expenditure reporting overvie 12, 2013 · voucher draw data appears on the cash ......
TRANSCRIPT
![Page 1: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/1.jpg)
Cash Draw and Expenditure Reporting
Overview
Presented by TWC Finance September 12, 2013
![Page 2: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/2.jpg)
Agenda • Welcome (Anson Green) • Overview (Kimberly Emmerich) • Cash Draw and Expenditure Reporting (CDER) System
Security (Kimberly Emmerich) • Cash Draw Functionality and Requirements (Thomas
Manning) • Financial Reporting Functionality and Requirements (Tim
Urbanovksy) • Contract Closeout Functionality and Requirements
(Thomas Manning) • Questions and Answers
2
![Page 3: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/3.jpg)
OVERVIEW
Presented by: Kimberly Emmerich Budget Management Director (512) 936-3054
3
![Page 4: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/4.jpg)
Transition of Adult Ed to TWC • The effective date of the Adult Education and Family
Literacy Act program from the Texas Education Agency (TEA) to the Texas Workforce Commission (TWC) is September 1, 2013.
• 2012-2013 Local Provider Contracts were extended to September 15, 2013, with TEA.
• 2013-2014 Local Provider Contracts have an effective date of September 1, 2013, with TWC.
4
![Page 5: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/5.jpg)
Transition of Adult Ed to TWC (continued)
• Utilize funding in the 2012-2013 Local Provider Contracts through September 15, 2013.
• If funding is exhausted in the 2012-2013 Local Provider Contracts prior to September 3, 2013, Local Providers must use State General Revenue funds for expenditures incurred on September 1 & 2, 2013.
5
![Page 6: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/6.jpg)
CDER SYSTEM SECURITY
Presented by: Kimberly Emmerich Budget Management Director (512) 936-3054
6
![Page 7: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/7.jpg)
Logging In • Go to the TWC Web site at
http://www.twc.state.tx.us
• Click on the “Community & Workforce Partners” link
• Click on “TWC Financial & Grant Information” link at the bottom of the webpage
• Click on the “Cash Draw & Expenditure Reporting (CDER) System” link located in the right column
• Click ‘Logon’ or ‘Request an Account’
7
![Page 8: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/8.jpg)
Security • Security will be administered by TWC staff.
• Each Grantee will designate a Security Coordinator. The Security Coordinator determines who needs access and the level of security.
• Each user must request an account before security will be granted.
• A Cash Draw Operator Security Request form must be completed prior to any user having access. The Grantee’s Security Coordinator will submit the form to [email protected].
• Grantees should have at least two individuals with security access.
8
![Page 9: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/9.jpg)
Security (continued)
• Depending on vendor requirements, separation of duties can be accomplished by security.
• TWC limits some security permissions to Grantee Finance staff only, as follows:
o “Submit” and “Certify” – Finance staff only
o “View” and “Edit” – any Grantee staff
9
![Page 10: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/10.jpg)
Home Page
10
![Page 11: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/11.jpg)
Vendor Profile Page
111111111 State of Texas (512) 462-2222 101 E. 15th St. Austin, Texas 78744
11
![Page 12: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/12.jpg)
CASH DRAW FUNCTIONALITY AND REQUIREMENTS
Presented by: Thomas Manning Payables Manager (512) 463-1671
12
![Page 13: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/13.jpg)
CDER Cash Draw Process DAY "0" "Cash Request"
made in the CDER System
Data interfaces to ISAS overnight and a Voucher is created.
DAY "1" Voucher draw data
appears on the Cash Management database at
a summary level.
Accountant reviews data for accuracy and requests summary draw amounts from the Federal/State
fund source.
Deposit journal created in ISAS, to be interfaced to
USAS.
Vouchers and deposit journal are interfaced to
USAS overnight.
DAY "2" Federal/State fund source
wires money to USAS/Treasury.
(late evening) USAS deposit journal is matched to the wire. If it matches, the deposit is accepted.
Vouchers from Day 1 are processed for payment. If
the deposit is unsuccessful, the cash is
not available and voucher is not processed.
Voucher and deposit data is interfaced from USAS to
ISAS, then from ISAS to CDER overnight.
DAY "3" Early morning, money is
transferred from USAS/Treasury to Grantee’s
bank.
Key: ISAS: Integrated Statewide Accounting System (TWC’s accounting system) USAS: Uniform Statewide Accounting System (Texas Comptroller’s Office)
13
![Page 14: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/14.jpg)
Cash Draw Request
2907SDF000 2907SDF001 2907WPB001
14
![Page 15: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/15.jpg)
Cash Draw Requests • After selecting the appropriate contract, the Cash
Draw Worksheet will appear.
o Next slide shows a sample Cash Draw Worksheet.
• Grantees will enter the appropriate amount on each contract line and save the request.
• Each cash draw request can only be for one contract at a time. However, multiple cash draw requests can be entered on any given day.
15
![Page 16: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/16.jpg)
Cash Draw Worksheet
2907SDF000
16
![Page 17: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/17.jpg)
Cash Draw Requests (continued)
• Only contracts with an Available Balance and prior to 90 days after contract end date will be available for Cash Draw Requests.
• Grantees will select a contract from the list and enter a service date. The service date cannot be a future date.
17
![Page 18: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/18.jpg)
Cash Draw Edits • The Service Date entered must be between the
contract begin and end dates. • The Service Date entered and the current date
determine which contract lines are available for draw requests.
18
![Page 19: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/19.jpg)
Cash Draw Edits (continued)
• The system will not allow cash draw requests for more than the available balance.
• The system will not allow more than 20% of the total contract amount to be drawn on any given day.
• The system will not allow the total of all draws submitted during three consecutive calendar days to exceed the Grantee’s fidelity bond.
19
![Page 20: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/20.jpg)
Fidelity Bond • Grantees must have fidelity bonds • Exceptions:
o Public colleges o Public universities o Consolidated school districts o Independent school districts
20
![Page 21: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/21.jpg)
Fidelity Bond Amount • Greater of:
o largest cumulative amount of all cash requests submitted on a given day, or
o cumulative amount of funds on hand at any given point.
• Establishes a CDER cash draw limit.
21
![Page 22: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/22.jpg)
Submit a Copy of the Bond to: • TWC Payables at [email protected] or
(512) 936-3299 (fax) o No cash will be disbursed until TWC receives the bond.
• Immediately notify if:
o Surety loses authority to do business in Texas
o Bond is cancelled, reduced or otherwise amended
22
![Page 23: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/23.jpg)
Review and Submit • Each cash draw request is assigned a sequential
transaction number.
• The Grantee will review and submit each transaction by checking the submit box and entering a submit date.
• The submit date can be a future date.
23
![Page 24: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/24.jpg)
Help System
24
![Page 25: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/25.jpg)
Contract Detail • The Contract Detail page gives detailed contract
information.
• Displays PO line detail information.
• Displays Cash Draw transactions that have been created against the contract.
25
![Page 26: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/26.jpg)
Contract Detail (continued)
2907SDF000
26
![Page 27: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/27.jpg)
FINANCIAL REPORTING FUNCTIONALITY AND REQUIREMENTS
27
Presented by: Tim Urbanovsky Financial Reporting Supervisor (512) 463-2480
![Page 28: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/28.jpg)
Expenditure Reporting Overview
Grantee personnel enter reported expenditures
System compares to budget and performs basic edits Expenditure Report is
certified by Grantee
Is the Expenditure Report LATE?
Email sent to Grantee and TWC
staff
NO Expenditure Report sent
to TWC’s internal accounting system (ISAS)
Expenditure Report Posted
28
![Page 29: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/29.jpg)
What to Report • Accrued Expenditures
• Obligations
• Program Income
Monthly reporting is mandatory.
29
![Page 30: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/30.jpg)
Types of Expenditure Reports • Monthly Reports
• Final Reports
• Revised Final Reports
30
![Page 31: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/31.jpg)
Monthly Expenditure Reports • On the 1st of every month, new Expenditure Reports
are created for the previous month.
• The previous month’s Expenditure Reports are due on the 20th of every month.
• Creation and due dates are irrespective of weekends and holidays
31
![Page 32: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/32.jpg)
Monthly Expenditure Reports (continued)
• If a report has not been submitted by the 20th, TWC can initiate a ‘zero report’ for the month.
• Grantees use an Expenditure Report Worklist that lets them know what reports are due and which kind they are: Monthly, Final, and Revised Final.
• Grantees can continue to modify reports until the report is posted.
• A sample Expenditure Report Worklist, Worksheet, and Certification are provided in later slides.
32
![Page 33: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/33.jpg)
Final Expenditure Reports • Final Expenditure Reports are due 60 days after the
contract end date.
• Grantees may create a Final Expenditure Report from a Monthly Expenditure Report for a contract that has not expired.
• They are uploaded nightly into ISAS after certification.
• Must have a zero ($0) Due to/Due from.
33
![Page 34: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/34.jpg)
Revised Expenditure Reports • Only TWC personnel can create Revised Final
Expenditure reports.
• These reports can have a Due to/Due from amount, if authorized by TWC.
• The due dates for these reports are determined by TWC staff.
• They are uploaded nightly into ISAS.
34
![Page 35: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/35.jpg)
Expenditure Report Worklist
2907SDF000
2907SDF001
2907WPB001
35
![Page 36: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/36.jpg)
Expenditure Report Worksheet
36
![Page 37: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/37.jpg)
Expenditure Report Worksheet (continued, slide 2/3)
37
![Page 38: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/38.jpg)
Expenditure Report Worksheet (continued 3/3)
38
![Page 39: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/39.jpg)
Expenditure Report Certification
2907SDF001
2907WPB001
2907SDF000
39
![Page 40: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/40.jpg)
CDER System Edits • Requires explanation if expenditures for any
given month are less than 5% of the grant contract.
• Expenditures + Obligations </= Budget • Administrative Expenditures </=
Administrative Cost Cap
40
![Page 41: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/41.jpg)
Monthly Expenditure Report • Report obligations and expenditures.
o Also include any adjustments for prior periods’ errors or omissions.
• Enter $0.00 if no activity during month. • Due on 20th calendar day by 11:59 p.m.
41
![Page 42: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/42.jpg)
Late Notifications • Issued by e-mail to personnel designated by the
reporting entity.
o TWC Finance staff receive a copy of notice.
• Email does not specify late report(s).
o Use “Expenditure Report Worklist” in CDER system to identify late reports.
42
![Page 43: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/43.jpg)
Cash Draw Cutoff • Cash draw access turned off at 12 a.m. on the 5th
calendar day that a report is past due. o Affects all active grant award contracts (not just
the one with the late report). • No notice when cash access is restored.
o Can e-mail [email protected] to verify cash draw access.
43
![Page 44: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/44.jpg)
CONTRACT CLOSEOUT FUNCTIONALITY AND REQUIREMENTS
Presented by: Thomas Manning Payables Manager (512) 463-1671
44
![Page 45: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/45.jpg)
Contract Closeout Overview • Contract Closeout Package (CCP) due within
60 days following the end of the contract period.
• CCP accessed from Home page. • In order to submit the CCP:
o Must certify final expenditure report o Must complete all CCP components
• CCP components shown on next slide
o Amounts Due to/Due from TWC must be zero ($0)
45
![Page 46: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/46.jpg)
CCP Components
Schedule of Unpaid Liabilities and Other Claims Outstanding
Property Inventory
Certification of Use and Disposition of Non-
Expendable Personal Property
Contract Release Agreement
46
![Page 47: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/47.jpg)
Review CCP
State of Texas 101 E. 15th Street Austin, Texas 78744 2907WPB000
47
![Page 48: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/48.jpg)
CDER System CCP Edits • Grantees must complete all CCP components and
certify final expenditure report (or revised final expenditure report) to certify the Contract Release Agreement.
• Late CCPs will be displayed on the Home Page • If Contract Release Agreement is not certified by the
CCP due date, late notifications are e-mailed • If not certified by the 5th day after the CCP due date,
Grantee’s ability to draw cash is turned off for all active TWC grant contracts.
48
![Page 49: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/49.jpg)
FINAL WORDS
49
![Page 50: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/50.jpg)
TIPS • All pages can be printed to a local printer, but
margins must be set at ¼ inch. • Any item that is in blue and underlined is a
link that will take you to another page. • Tables and grids can be copied and pasted into
an Excel spreadsheet. This is useful for search results and summing amounts.
50
![Page 51: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/51.jpg)
TIPS (continued)
• All column headers that are in blue can be sorted by clicking on the column header.
• Every page has a Page Help link which provides useful information and instructions for that page.
• Do not use the ‘Back’ button on your Internet browser; it will not work.
51
![Page 52: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/52.jpg)
Contact Information • CDER Setup and Password Reset
o [email protected] o Dolph Lesak, (512) 463-8114 or Tracy Curles, (512) 463-8554
• Cash Draw and Closeout o [email protected] o Thomas Manning, (512) 463-1671 or Monica Jimenez, (512)
936-3571
• Financial Reporting o [email protected] o Tim Urbanovsky, (512) 463-2480 or Tim Alvarez, (512) 475-4024
52
![Page 53: Cash Draw and Expenditure Reporting Overvie 12, 2013 · Voucher draw data appears on the Cash ... • A sample Expenditure Report Worklist, Worksheet, ... Cash Draw and Expenditure](https://reader034.vdocuments.us/reader034/viewer/2022051723/5ab64fe67f8b9a156d8da8cc/html5/thumbnails/53.jpg)
Questions?
53