SAM

1

• SAM
• Shared Accounting Module
• Overview

2
(No Transcript)
3
The Shared Accounting Module (SAM) is an
application developed by Financial Management
Service (FMS) in conjunction with the Federal
Reserve Bank of St. Louis (FRBSTL). SAM will
facilitate the process of validating or deriving
Treasury Account Symbol (TAS) / Business Event
Type Code (BETC) combinations to assist GWA in
classifying financial transactions as they occur.
SAM Background
4
The Business Problem

• Governmentwide Accounting (GWA) Modernization
  changes certain central accounting parameters
  (i.e., timing and information flow).
• Disbursement Collection transactions must be
  classified to a TAS/BETC combination as early as
  possible, thus eliminating the monthly FMS 224
  and 1219/1220 reporting cycle.
• GWA Master Enterprise Reference Data (Agency
  Location Codes (ALC), TAS, and BETCs) must be
  readily available to feeder systems for input
  validation.

5
The Technical Solution

• SAM will
• Leverage existing agency processes to derive a
  TAS/BETC.
• Serve as the Central Repository for Federal
  Program Agency (FPA) business accounting rules.
• Provide GWA Master Enterprise Reference Data (TAS
  and BETC) to FMS, FPA and the general public.
• Validate TAS/BETC data when submitted through a
  feeder system.

6
SAM Interfaces

• GWA/CAFE
• Direct Internet Access
• Downloading Service to acquire GWA Master Data
• Uploading Service to acquire Cash Flow Profiles
• ASAP
• TRS

7
Information Processing

• SAM operates in 3 different modes
• Validation IPAC, Disbursements, and Collections
• Translation Currently for Collections
• Default IPAC, Disbursements, and Collections

8
SAMs Validation Mode
SAM verifies the TAS/BETC information attached
to a Collection, Disbursement or IPAC transaction
by the FPA is valid per GWAs Master Enterprise
Reference TAS/BETC data.
9
SAMs Translation Mode
FPA internal accounting codes that cross walk to
a TAS are referred to as Classification Keys
(C-Keys). SAM will translate the C-Key attached
to a Collection transaction submitted by an FPA
to the appropriate TAS/BETC combination.
10
C-Key Example
Classification Key Definition Name Up to 25
alphanumeric characters C-Key Name LOCK BOX
ACCOUNT NUMBER Value (Optional Field) Up to
50 alphanumeric characters C-Key Value
123456
11
SAMs Default Mode
Collection, Disbursement, and IPAC transactions
that contain invalid TAS or C-Key information or
no information at all will be assigned to a
default TAS/BETC for GWA reporting purposes.
12
(No Transcript)
13
Benefits1

• SAM will provide FPAs with
• The ability to reduce the workload associated
  with dual reporting and multiple reconciliations
  as required under the current system (224 or
  1219/1220 end of month reporting and the
  Statement of Difference).
• The ability to maintain real-time control over
  account code translation rules.
• The ability to maintain a single database in
  which to enter accounting rules versus having to
  maintain the same rules in multiple collection
  feeder systems.

14
Benefits2

• SAM will provide FMS with
• A single source for maintaining similar
  TAS-related functionality across multiple feeder
  systems.
• An accurate, single touch point, to validate
  and/or derive TAS/BETC account codes for
  financial transactions. This process will
  facilitate the GWA system in classifying work on
  a daily basis thereby eliminating the need to
  perform month-end classifications (224 or
  1219/1220 process) when the system is fully
  implemented.

15
Access Group
A group created to relate ALC(s), in terms of
business commonality (i.e., similar accounting
rules and/or business practices), for which SAM
Users are granted permissions and Cash Flows and
Default Rules are defined. Access Groups can be
further divided into Sub Access Groups.
16
Example Access Group Sub Access Groups
17
SAM User Roles

• Users will be defined and will be granted
  permission to the
• Access Group.
• Security Administration
• Primary Local Administrator (PLSA)
• Local Security Administrator (LSA)
• Accounting Administration
• Cash Flow Administrator (CFA)
• Agency Viewer (AV)
• Data Download (DD)

18
Cash Flow Profile (CFP)1

• A grouping of business activities with a common
  set of
• central accounting rules.
• Identify how financial transactions should be
  distributed
• One to One
• One to Many
• Identify the ALCs and collection mechanisms to
  which a C-Key applies.

19
Cash Flow Profile (CFP) 2

• Distribution Rule
• One to One
• C-Key Name LOCK BOX ACCOUNT NUMBER
• C-Key Value 123456
• Rule LOCK BOX ACCOUNT NUMBER 123456
• Dr 100 20X1234 COLLAJ
• Cr 100 20X1234 COLL

20
Cash Flow Profile (CFP) 3
Distribution Rule One to Many C-Key Name LOCK
BOX ACCOUNT NUMBER C-Key Value 654321 Rule LOCK
BOX ACCOUNT NUMBER 654321 Dr
75 20X1234 COLLAJ Dr 25
20X1235 COLLAJ Cr 75
20X1234 COLL Cr 25 20X1235
COLL
21
Cash Flow Profile (CFP) 4
22
The Default Process1
99 of the time SAM will receive valid TAS/BETC
information on IPAC or Payment Transactions.
On the rare occasion a TAS/BETC is invalid, SAM
will default the transaction to a FPAs
Acceptable Default TAS and Before Classification
Account (BCA) BETC. Example of an Acceptable
Default Account for an IPAC transaction TAS
BETC 20F3502 DISBBCA
23
The Default Process2

• A TAS/BETC could be invalid because of
• A timing issue Ex TAS/BETC was valid in IPAC
  when the transaction was processed, but was
  inactive in the SAM database at the time of
  validation.
• An expired C-Key Value Ex C-Key value points
  to an expired TAS/BETC.
• An invalid C-Key Ex C-Key not listed on CFP.

24
The Default Process3

• GWA Operations assigns an Acceptable Default TAS
  by Agency (F3500 for Disbursements, F3502
  IPAC/Collections).
• FPA Cash Flow Administrator (CFA) selects
• System Type IPC, Disbursement or Collection
• Access Group
• Acceptable Default TAS and Before Classification
  Account BETC for both the Debit and Credit rules

25
The Default Process4
Ex System Type IPC Agency 20 Department
of Treasury Access Group Bureau of Public
Debt ALC 20123456 Default Account Debit
Rule 20F3502 DISBBCA Credit Rule 20F3502
COLLBCA
26
SAM Public Website

• https//www.sam.gov/sampublic/default.htm 
• Provides GWA Master Enterprise Reference TAS/BETC
  data.
• TAS/BETC data is available by System Type
  Disbursements or Collections.
• Data is available in three formats XML, CSV, and
  CSV for Excel.

27
Summary

• The Shared Accounting Module (SAM) was developed
  to
• Support GWAs strategy of capturing TAS/BETC data
  when a transaction is reported, thereby
  facilitating the timely and accurate reporting of
  Federal Program Agency (FPA) financial
  transaction information.
• Support the implementation of new, more efficient
  and effective business processes for central
  accounting.
• Eliminate the need to modify up to 30 collections
  processing systems to support GWA modernization.

28
Current Activities1

• Cash Flow Profile Information Gathering
• In order to collect Cash Flow Profile (CFP)
  information the SAM
• Conversion Team has partnered with Agency
  Relationship
• Management (ARM) to contact FPAs and discuss the
  224 or
• 1219/1220 reporting process.
• To create a CFP the SAM Conversion Team will need
  to
• Discuss each collection mechanism used by an FPA
• Determine the of TASs associated with
  Collections
• Identify internal accounting codes to be used as
  C-Keys

29
Current Activities2

• GWA Pilot Reporter Set Up within SAM
• The SAM Conversion Team as partnered with GWA to
  contact
• those FPAs identified as a GWA Pilot Reporter.
  During the
• conference call with the SAM Team, FPAs will be
  given an
• overview of the SAM application as well as
  information on
• Access Group Set-Up
• SAM User Roles
• SAM PLSA User Authorization Form
• Default Rule Set-Up
• User Training

30
SAM Contact Information
Becky Theis SAM Project Coordinator (314)
444-8667 Rebecca.S.Theis_at_stls.frb.org Ray Speed
SAM Conversion Analyst (314)
444-8371 Raymel.G.Speed_at_stls.frb.org Kevin
Julius SAM Conversion Analyst (314)
444-4238 Kevin.R.Julius_at_stls.frb.org