Transcript Slide 1

Coming Soon:
GTAS
Governmentwide Treasury Account Symbol
Adjusted Trial Balance System
ASMC June 2 2011
1
Presentation Agenda


GTAS Overview
Some Details




Super Master Account File (SMAF)
New Bulk File Format
Validations and Edits
Year-End Transactions
2
Why we need GTAS

From the CFO Act:

…provide for the production of complete,
reliable, timely, and consistent financial
information for use by the executive branch of
the Government and the Congress in the
financing, management, and evaluation of
Federal programs.
3
Why GTAS?





Streamlines reporting requirements for agencies
by replacing FACTS I, FACTS II, IRAS and IFCS
trial balance reporting systems
Integrates budgetary and proprietary reporting
Enforces USSGL as the foundation of
Governmentwide accounting
Facilitates data consistency and implements
editing with the central accounting system
Helps to address inconsistent financial statement
data
4
Things you should know about GTAS

ONE USSGL trial balance for each TAS








Budgetary and proprietary USSGL data with beginning
and ending balances
TAS include expenditure accounts, deposit funds,
clearing accounts, unavailable receipt accounts
No more fund family reporting (FACTS I)
Daily SMAF and FBWT $$ updates from GWA
System is open to users 24x7
Bulk File Only – no online data entry
Open for testing by agencies in July 2012
Implementation is January 2013 (1st Qtr. FY 2013)
5
Super Master Account File



The SMAF contains information about the TAS
and is provided by Treasury
The SMAF will be available to agencies via GTAS
on a daily basis
The information in the SMAF will be used to edit
and validate the trial balances.



Treasury Account Symbol (TAS)
Net Outlays $$, Fund Balance $$, Business Line $$
TAS Level Attributes
6
SMAF -TAS Level Attributes
The following are TAS level attributes currently used in FACTS II.
These attributes will also be on the GTAS SMAF.









Extended Disbursing Authority
Appropriation Flag
BEA Category Code
TAS Title
Budget Agency
Budget Bureau
Budget Account
Financing Account Indicator – Direct (D), Guaranteed (G), (N)
Neither
Fund Type
7
SMAF - TAS Level Attributes (cont)
The following are attributes that tell us information
about the status of the TAS:




TAS Status – Unexpired (U), Expired (E), Canceled (C)
TAS Status Transitioning Flag – Expiring (E), Canceling (K)
Is 1st Year – Yes (Y), No (N)
Authority Duration Code – No Year (X), Multi Year (M), Annual
(A), Receipt (R)
8
NEW TAS Attributes!!!

FR Entity: Defines a group of TAS that are reported in an agency’s financial statements,
which are included in the Financial Report of the United States Government. Used in
GFRS.
1200 Agriculture
1300 Commerce

Financial Receipt Type: Defines, at the TAS level, if the account activity is related to
non-Federal ownership interest or statutory dedication of specifically identified
revenues to designated activities.
Earmarked (E)
Fiduciary (F)
Undesignated (U)

Budget Sub-function: Sub-functions used in the classification of data according to major
purpose served (for example, income, security, or national defense). Classifications are
required by Congressional Budget Act of 1974.
9
Bulk File Highlights

GTAS is CGAC Compliant




Agency identifier is 3 digits (no more Dept 95)
Beginning period of availability is 4 digits
Ending period of availability is 4 digits
USSGL account is 6 digits (2 zeroes at the end)

Text for program reporting categories and category B programs will
be entered into a PRC/Cat B module in GTAS. The text will not be in
the bulk file.

Federal/Non Federal Code – Attribute that combines the transaction
partner (FACTS II ) with the federal/non federal code (FACTS I)




Federal (F)
Non-Federal (N)
Non-Federal Exception (E)
General Fund (G) {NEW}
10
Bulk File Highlights

DELETED: Advance Flag (FACTS II) is no longer a USSGL attribute. The domain values
have been added to the authority type attribute.

NEW! Program Cost Indicator – the amount of cost or revenue directly or indirectly
traceable to programs. Will be added to the Statement of Net Cost for FY 2011.
 Associated to Programs (P)
 Not associated to programs (Q)


NEW! Budgetary Impact Indicator – indicates if there is a budgetary impact. Will be
added to the Statement of Changes in Net Position crosswalk for FY 2011.
 No budgetary impact (E)
 Budgetary impact (D)

UPDATED! Trading Partner Main Account – required wherever the Trading Partner is
required. This is currently a requirement in FACTS II but not FACTS I.
11
Bulk File Highlights
If an attribute is required for a USSGL
account, it MUST be on the bulk file. No
more derived values!!

Prior Year Adjustment Attribute: GTAS will not derive
domain value X. Domain value X must be on the bulk file
for the applicable USSGL accounts.

Fed/NonFederal: GTAS will not derive domain value F for
the budgetary transfer USSGL accounts. Domain value F
must be on the bulk file for the applicable USSGL
accounts.
12
Validations and Edits

Data Validations
Checks each attribute included in a row on the bulk file
ensuring that the attributes reported are valid for the
USSGL account (per the Attribute table).

Edits



Verifies balances between two or more USSGL accounts
Compare USSGL account balances with data in central accounting
50+ edits will run in GTAS but only 18 will be fatal. The number of
fatal edits will increase to include any new fatal edits added to
FACTS I and FACTS II between now and FY 2012 qtr. 4.
13
GTAS Attributes Table - SIMPLE
Simple validation (involves 1 attribute only) See Attribute Table
14
Special Validations

A special validation involves 2 or more attributes (TAS or
USSGL attributes) to validate that certain combinations
are allowed or disallowed. Examples are:





If the Fed/NFed code is “F”, then trading partner agency identifier and
trading partner main account code are both required. Trading partner
main account is a new requirement for proprietary. We want a value
but if you don’t give us a value, the trial balance will still pass.
If the balance is B (beginning), then the prior year adjustment value must
be X.
If the financing account indicator is direct (D) or guaranteed (G) AND the
account is budgetary, then the cohort attribute is required.
If the BEA code is valid with the USSGL account, then the BEA code used
with the USSGL account must agree with the TAS level BEA code.
If the 1st year indicator is yes (Y), then the PYA must be X.
15
Miscellaneous Receipts



FMS will sweep general fund miscellaneous receipt
account balances as a pre closing entry.
The sweep transaction will appear on the GWA account
statement.
Agencies are to record the sweep as a pre closing entry.
16
Year End Transaction Processing




Cancellations and balance adjustments related to
indefinite appropriation authority will be initiated and
completed by the agency in the GWA Authority
Transaction Module (ATM).
Does not include cancellation of balances for TAS with
the X availability type, partial cancellations, or TAS with
extended disbursing authority
GWA ATM will be available for year end transactions for
fiscal 2013 in October 2013. The window will open after
the 224 reporting for September has been completed.
If the year end transactions are not completed before the
GTAS ATB is submitted, the GTAS ATB will fail edits.
17
Cancellation Transaction
GWA/ATM Screenshot
Continuous
Balance
Updates
Select one,
two or all
accounts
18
Proprietary Balances in a Canceled TAS–
GTAS



GTAS will create a canceled TAS for reporting assets related to
canceled accounts.
The GTAS SMAF will contain a canceled TAS for every fund family
the first year GTAS is in production. After the first year, a canceled
TAS will be created for each fund family based on the proprietary
USSGL accounts reported in the ATB at the time of cancellation and
verification that a canceled TAS does not already exist at the fund
family level.
Beg and End POA are removed. FBWT is $0. All other TAS attributes
remain unchanged.
One Canceled TAS
Per Fund Family
020 2003 2003 1234
020 2004 2004 1234
020 2005 2005 1234
020 C 1234
19
Long Term Objectives


Prepare U. S. financial statements and agency
statements from same set of trial balances.
Build a central repository of quality data that generates
these statements and can be queried for information that
aids decision-making.
20
Additional Questions?
Questions:
Rita Cronley 202-874-9902
[email protected]
Beth Angerman 202-874-1544
[email protected]
Jeff Hoge 202-874-6179
[email protected]
http://www.fms.treas.gov/gtas
21