Managing Collections

1
Kansas City Customer Advisory Board Briefing
December 12, 2006
2
How is GWA going to accomplish this?

• Fundamental Changes to the current process
• Developing a New Database
• Developing the infrastructure to Support GWA
  Players
• ATM, Account Statement, CAFÉ, P224, SAM, IPAC,
  Collections, Payments
• Automated Enrollment User-based Access Control
• Phase in GWA Players
• Streamline GWAs Architecture
• Provide Agencies with GWA initiated Account
  Statement
• Support NTDO GWA Players
• Fully Replace Legacy Accounting System

3
GWA User Enrollment Getting Started

• Web-based user enrollment links available on
  the GWA website and will be available on the GWA
  System login page by the end of this month
• Certifying supervisors must be enrolled first
  paper process
• User enrollment time frame has been reduced from
  2-3 weeks to 2-3 days
• Agency users will also be able to reset their own
  passwords
• All Account Statement users are currently in the
  user provisioning system
• Current Release1 users (approx. 1200) will start
  enrolling for ATM beginning in June.

4
TAS Definition
GWA Standard Transaction Classification

• Acronym for Treasury Account Symbol (TAS)
• The receipt, appropriation, expenditure and other
  fund account symbols and titles as assigned by
  the Department of the Treasury
• A 27-character field with 24 currently
  identified characters
• Supercedes 21 position TAS and any other
  suggested formats

5
BETC Definition
GWA Standard Transaction Classification (cont)

• Acronym for Business Event Type Code
• An 8-character code that indicates the type of
  activity being reported (e.g. receipt,
  disbursement, etc)
• BETC determines the transaction effect on the
  Treasury Account Symbols FBWT.
• BETC replaces transaction codes and standard
  sub-classes but at a more intuitive level of
  detail

6
Shared Accounting ModuleSAM
7
SAM

• Utility responsible to ensure a valid TAS/BETC
  is posted
• to all transactions entering the GWA System
• Developed to assist agencies in complying with
  GWA
• standard transaction classification
• GWA will provide SAM with a table of valid
  TAS/BETCs
• Agencies will define in SAM valid TAS/BETCs
  for
• Default rules and
• Classification (Ckey) translations

8
SAM

• CAFE will send SAM transactions with
• TAS/BETCs or
• CKeys
• SAM will
• Validate TAS/BETC or
• Derive valid TAS/BETC from Ckey or
• Default a valid TAS/BETC
• Return transactions to GWA w/valid TAS/BETC.
• Provide valid TAS/BETC reference lists for
  Agencies

9
IPAC Impact
10
IPAC Agency Impact

• IPAC has required sender TAS since October 2003
• Effective October 1, 2006 IPAC will accept only
  TASs that are valid and appropriate for use
  through IPAC
• Note Most F Accounts are not valid for use
  through IPAC.
• A list of valid IPAC TAS and BETC is available on
  the GWA website http//www.fms.treas.gov/gwa

11
IPAC Agency Impact

• GWA Player and Player Trading Partner
  Requirements
• Effective Immediately
• For GWA Players, a valid TAS/BETC combination
  must be reported for both the sender and receiver
  sides of the transaction.
• Trading Partners conducting business with GWA
  Player Agencies must report a valid TAS/BETC
  combination for the receiver side of the
  transaction.
• Only for transactions with the Players.
• All other IPAC transactions follow current
  reporting requirements.

12
IPAC Agency Impact
IPAC Reporting Cheat Sheet
13
IPAC Agency Impact

• The Bottom Line
• Must work with your trading partners now.
• Establish Trading Partner Agreements (TPAs)
• Communication is essential
• All Agencies will transition to TAS/BETC
  reporting during October 2006 through August
  2008.
• The transition to a Single Standard TAS format
  instead of the current 6 formats available today
  is coming.
• F-Account Issue Treasury will continue to work
  with Agencies to identify alternatives to using F
  Accounts.

14
Partial 224Agency Implementation
15
Partial 224

• Web based application
• Ability to turn off sections of the P224
• Provides for reclassification capability by using
  only section I of the P224.
• GWA Reporters by
• ALC
• Source system
• Categories

16
GWAAccount Statement
17
The GWA Account Statement

• Definition
• An online, daily refreshed, query based
  application designed to provide each Federal
  Program Agency with a central location for
  retrieving information relating to its Fund
  Balances with Treasury.
• Objective
• Designed to assist Agencies with their
  reconciliation processes.
• Replaces the Monthly Undisbursed Ledgers and
  Trial Balance reports. (FMS 6653, 6654, 6655)
  
• Benefits
• Access Online at the Department level
• Timeliness Refreshed daily
• Flexibility Full query capability at both TAS
  and ALC level
• Clarity Clear description of balance and
  transaction data

18

• The GWA Player
• Membership Has Its Advantages

19
GWA Player Current

• GWA Available Components and User Benefits
• GWA User Official Implementation
• Café 1.3 Full Utilization
• Acceptance of daily transactions with TAS/BETC
  validation and processing
• Authority Transactions Module (ATM)
• Implements Warrant Journal Vouchers
  functionality
• Transitions Release 1 components from BPD to
  TWAI
• Account Statement
• Self Enrollment
• Shared Accounting Module (SAM)

20
GWA Player First/Second Quarter 07

• GWA Available Components and User Benefits
• GWA User Additional roll out to IPAC users
• Partial 224 Rollout to multifaceted Pilot
  ALCs
• IPAC New GWA Way of reporting
• Payments/Collections Old 224 reporting
• Begin Payments Pilot with agencies
• Account Statement enhancements

21
GWA Player Third/Fourth Quarter 07

• GWA Available Components and User Benefits
• GWA User Official Implementation of Payment
  agencies
• Roll out of additional IPAC GWA Players
• Partial 224 Rollout to multifaceted Pilot ALCs
• Payments New GWA Way of reporting
• IPAC/Collections Old 224 reporting
• Account Statement (GWA TAS) 3.0
• Work with FSIO on GWA TAS/BETC testing
• Implement ATM 2.0 (appropriation warrants)
• Begin working with Collection Pilot agencies

22
GWA Player 2008

• GWA Available Components and User Benefits
• GWA Unofficial Account Statement
• Daily updated view of Fund Balance with Treasury
  showing impacts of GWA Way submitted
  transactions with TAS/BETC
• Begin Working with NTDOs
• Implement Mandatory use of GWA TAS/BETC
• Implement GWA Player(s) for Collections
• Pilot and Implement Full GWA Player with all
  transaction types

23
GWA Player Payments - 2007

• Work with PAM/PACER to incorporate short term
  changes
• PACER sends new consolidated file format
• Begin Payment Pilots with Denali, Agriculture,
  Bureau of Prisons
• Begin SSI Pilot

24
GWA Player Payments (continued)

• Modifications to SPS and PAM - 2009
• 100 TAS/BETCs per Payment
• 100 TAS/BETCs per Schedule
• Routine to roll up Bulk File data by TAS and
  Amounts.
• Out of Balance Reports
• Aftermath
• Level of Detail on Account Statement
• Schedule level

25
GWAMP Roll out Strategy
26
GWAMP Roll out Strategy
27
GWAMP Roll out Strategy