Financial Assistance Systems WSFR Reports User Guides User

Financial Assistance Systems

WSFR Reports User Guides User guides were moved from TRACS to https: //fawiki. fws. gov/display/WRUG

WSFR Reports User Guides ● Report Team Members: ● Mary Kandar, Tarajoy Mihan, Sherry Martin, Stephen Lee, Donna Zanger, Ken Kuznia, Dwayne Cook ● All user guides have been completed ● Definitions and Acronyms page – any additions? ● Any Changes needed to guides?

FBMS Budget Transfers/Reconciliation ● ● Regional Process for Reconciling During FY Frequency FAS Compares Final Apportionment to FASR Ensure carryovers on FASR match funds carried over from previous FY ● Ensure new apportionment on FASR matches final apportionment ● Draft User Guide – Ken

Compare PY Carryovers to FASR ● Run Budget Entry Document Report ● 4201 Carryover without the R

Compare Final Apportionment to FASR ● Check total by program on final apportionment ● Compare to FASR monthly, quarterly, etc.

Next Steps • Draft User Guide – Ken • Review for negative amounts except carryovers • R 3 Funds Management Verification spreadsheet • Create a user guide on transfers allowed per the Acts

E-File Update • DOI will not implement E-file for Financial Assistance until 2018 • Proposed structure • Next steps?

ASAP Date Changes The Branch of Financial Assistance Systems (FAS) is responsible for reviewing and responding to ASAP account end date extension requests. A request must be sent to FAS to change the ASAP Account End Date ONLY when: • a) the current award/line period of performance end date has passed, • b) the recipient has requested more than 120 days past the period of performance end date to liquidate funds, and • c) the PRISM Milestone Plan has been updated to reflect the approved financial report due date extension, or, for awards not subject to the PRISM Milestone Plan requirement, the requestor provides a copy of the written financial report due date extension approval sent to the recipient. FAS will not take action in ASAP until all three conditions are met.

ASAP Date Changes Extending an ASAP Account End Date for Funds Liquidation

Site Code Non-WSFR Awards Various reports use site code to filter reports: • Milestone Plan Report • TRACS Extract Should Non-WSFR awards serviced by WSFR have a different site code?

Use of Estimated Award Amount Field and Application Received Date in PRISM • Email on 2/25/16 on date format • Date Application Received field is a PRISM date field • Format as MMDDYYYY • Completed Application Received Date – Total Estimated Award Amount field is a PRISM text field Format as YYYYMMDD

Use of Estimated Award Amount Field and Application Received Date in PRISM • Developed WEBI Report from the General PRISM Query Report to display: – Application Received Date – Completed Application Received Date (Est Award Amt Field) – Closed Date • Includes all FW site codes and FHQ • Includes award statuses: – – – Closed Approved Cancelled Complete Released • Report in Excel – Enter formula to calculate number of days until this can be done in WEBI

FBMS/PRISM Coming Updates Met with BIO and Compusearch 3/29/16

DATA Act • Federal Award Identification Number (FAIN) • CFDA • AAC

FAS Updates ● Developed WEBI Report to display award lines subject to availability ● Developing WEBI Report to display award without obligations to send to TRACS ● Originating/Sponsoring Office Codes ● Tableau

Modifying Converted Awards ● Eliminating Amendments for Converted Awards Memo – on hold ● FAPO Developing Amendment/Modification policy ● SF-424 Type of Application ● New – new award ● Continuation – new award ● Revision – amendment and possible modification in PRISM

Modifying Converted Awards ● System issues caused by continuing to modify converted awards: ● PRISM and SAP do not link for converted awards ● PRISM Line Dates do not transmit to SAP PO which will cause incorrect dates to be sent to ASAP ● Out of sync obligations if both systems are not changed – could result in deobligations not being sent to ASAP ● Invalid SAM registrations with converted vendors