GTAS and GFRS – FR System 

Consolidation Phase 1

Luke Sheppard

May 17, 2016
2 L EAD ∙ T RANSFORM ∙ D ELIVER

GFRS and GTAS Overviews
3 L EAD ∙ T RANSFORM ∙ D ELIVER

• Oracle Based Internet Application

• Closing Package Submission

• Represent Federal Agencies’ comparative, 

audited, consolidated, and department level 

Financial Statements

• Produces Financial Report of the US 

Government

GFRS Overview
4 L EAD ∙ T RANSFORM ∙ D ELIVER

• Government Wide Treasury Account Symbol Adjusted Trial 

Balance System (GTAS)

• Full Set of USSGLS submitted per TAS

• Both Budgetary and Proprietary data

• Data submitted at the USSGL/ Individual TAS level

• USSGL TFM contained within GTAS

• SF 133 Crosswalks

• Reclassified Crosswalks

• Edits and Validations

• Replaced/Replacing several legacy systems

• IRAS (2014)

• IFCS (2014)

• FACTS I (2014)

• FACTS II (Partially 2014, Completed 2015)

• SID (2014)

• GFRS (scheduled over the next few years)

GTAS Overview
5 L EAD ∙ T RANSFORM ∙ D ELIVER

GTAS and GFRS Big Picture 

Perspective
6 L EAD ∙ T RANSFORM ∙ D ELIVER

Benefits of Merging GTAS and GFRS

• Reporting Agency

• Elimination of Redundant Data Entry

• Elimination of Manual Data entry in GFRS for Reclassified Statements

• One Established System

• Less time spent training new employees for different systems

• GTAS allows for more opportunities to automate previously manual 

processes from GFRS

• Fiscal Service

• One TFM for all Financial Reporting

• GTAS produces the USSGL TFM (Potential Disconnect between 

published guidance and software implementation virtually eliminated)

• One system to capture ALL Budgetary and Proprietary data in the same 

format

• Potential Elimination of a large percentage of Top Level JV’s to produce 

the Financial Report of the US Govt.
7 L EAD ∙ T RANSFORM ∙ D ELIVER

• New Enhancements/Fixes for GTAS – Release 2.8

• Proposed Roadmap of GFRS/GTAS functionality 

merger

• Phase 1(FY 2016)

• Phase 2 (FY 2017-??)

GTAS and GFRS – Big Picture Perspective
8 L EAD ∙ T RANSFORM ∙ D ELIVER

• GF001 – Financial Template (Significant Entities)

• GF002 – Audited Financial Statements (Significant 

Entities)

• GF003 – Reclassification (Significant Entities)

• GF004 – Federal Trading Partner Note

• GF006 – Financial Report Notes

– Tied to the Balance Sheet

• GF007 – Other Financial Report Data (RSI)

• GF008 – Completions and Approvals (Significant 

Entities)

GFRS Modules FY 2016
9 L EAD ∙ T RANSFORM ∙ D ELIVER

Significant Entities:

• All significant entities manually load their financial data in 

GFRS Modules 1,2,3,4,6,7, and verify submission and sign 

off in Module 8

Other Entities (formerly Non Verifying) 

• GFRS reclassified financial statement data created from 

GTAS, ie. GTAS data automatically populates for applicable 

modules via the GTAS USSGL Crosswalks (process 

detailed on next slide)

How did my data get into GFRS previously (FY15)?
10 L EAD ∙ T RANSFORM ∙ D ELIVER

Explanation of How GTAS Crosswalks Data

• Bulk File is loaded

o Passes Validations

o GTAS checks each line of the bulk file

 Looks for attribute match on crosswalk

 Matches create statement lines

 All Statement lines are written

 GTAS then calculates totals based on crosswalk logic

• Attributes on Reclassified Crosswalks

o Begin/End Indicator

o Fed/Non Fed Indicator

o Fund Type Code

o Reporting Type Code

o Exchange Non Exchange Code (RSCNP)
11 L EAD ∙ T RANSFORM ∙ D ELIVER

Significant Entities Flow Chart: GFRS only – Previous 

Flow
12 L EAD ∙ T RANSFORM ∙ D ELIVER

Other Entity Flow Chart: GTAS to GFRS – Current
13 L EAD ∙ T RANSFORM ∙ D ELIVER

• Significant Entity data will flow from GTAS to GFRS

exactly like Other Entity data

• GTAS data, including any applicable manual adjustments, must be 

certified to populate GFRS

• Near real time updates from GTAS to GFRS

• Manual Adjustments (Reclassified Statements)

• Allows Agency to adjust GTAS ATB Data (rolled up by FR entity) at 

line level at Year End (Audit Adjustments and TP Breakouts)

• For Significant Agencies Only

• Phase out over a few years after implementation

• Feedback needed

Elimination of Dual Data Entry (Phase 1) FYE 2016
14 L EAD ∙ T RANSFORM ∙ D ELIVER

Communications – GTAS to GFRS Analysis

• Emails sent out at end of Feb 2016

• Document Significant Differences between GTAS Reclassified 

Statements and GFRS Submissions (FY14)

• Asking for Feedback/Analysis to determine cause

• Verify GTAS handles and crosswalks ATB data appropriately

• Analysis could uncover needed changes to crosswalks

• Feedback and collaboration is vital to ensure transition is as 

smooth as possible

• Reminder Emails

• Vast majority of Agencies have responded

• More participation means more coverage of potential issues 
15 L EAD ∙ T RANSFORM ∙ D ELIVER

GFRS to GTAS – Reconciliation

• Reconciliation still needed to verify Agency Audited 

Financial Statements tie back to Reclassified Financial 

Statements

• TFM 2-4700 Appendix 2 

• Email Attachment verifying reconciliation

• Template with instructions and reconciliation example

• New Reclassified Reconciliation report will be provided 

in GTAS
16 L EAD ∙ T RANSFORM ∙ D ELIVER

More to Come

Keys to Success – GTAS to GFRS

• Communication

• Agency Feedback

• Web demos of new proposed functionality

• Newsletters/Emails

• Deliver enhancements on time and defect free

• Address System Issues timely

• Mitigate Future Issues

• Lessons Learned
L EAD ∙ T RANSFORM ∙ D ELIVER

Contact Information

17

Luke Sheppard

Phone: 304 480-5104

Email: Luke.Sheppard@fiscal.treasury.gov