Headquarter, Department of the Army
Located on 8th Floor, Zachary Taylor Building, 2530 Jefferson Davis Hwy, Arlington VA
Managerial Accounting Assistance: Phone: 703-602-1953 or 703-602-2004 / DSN 332-1953 or 332-2004
The Managerial Accounting Division (MAD) recognizes that we are a cohesive team, working together to satisfy customer requirements by using all available resources to deliver a quality product, efficiently and on time.
Through competence and integrity, we ensure efficient and cost-effective use of all resources, people, technology, and dollars.
MAD encourages a highly motivated and professional workforce committed to employee development, growth and welfare, and dedicated to upholding army values and ethical standards.
We meet our ultimate goal of providing customer satisfaction by listening, educating, and consistently working to improve our services.
MAD recognizes and supports the Resource Services, OAA and Army's Vision, Mission, Values and Goals.
RSW-Online (dbCAS) - Input & Reports= This system is Resources Services Washington’s modernized version of dbCAS. "The Database Commitment Accounting System (dbCAS) is a commitment ledger system that runs on a stand-alone computer. This system records and manages committed funds and funding data and passes obligation candidates to STANFINS. The dbCAS system administrator runs the Split Operation, which is the liaison between dbCAS and STANFINS. The dbCAS ledger/user will send commitment data to Split to be forwarded to STANFINS for obligation. The records are obligated, sent back to Split, and returned to the user for updating of commitment/obligation records and status of funds." RS-W's version is available via the web and contains modules to process budget data from POM-Build through Obligation Phase. (Source: DFAS-Rome)
OLRV (On-Line Report View) = “is the DFAS standard paperless initiative. The process uses a commercial off the shelf (COTS) software product called Report web. The primary goal of OLRV is to reduce and/or eliminate hard copy output (paper and microfiche) and associated costs while improving the timeliness of obtaining financial reports and information. It provides customized management reports and report data can be extracted and manipulated through other desktop applications. It is user-friendly, and provides readily accessible electronic reports through a web browser on a desktop PC. The archival capability provides for long term storage of all reports for complying with all Federal Record Retention Requirements. OLRV takes the data normally printed out of STANFINS and generates an electronic copy of the report that can be viewed on your desktop PC through a web browser. This is a useful tool to view the non-stock fund status and other reports generated from the STANFINS daily cycles.” (Source: DFAS-Rome)
STANFINS (STANDARD FINANCE SYSTEM) Type Actions (TA)/Tables = This session will focus on the most commonly used STANFINS Type Action Codes as well as seven major STANFINS Tables that are used to generate reports in OLRV, STANFINS DQRY, ATLAS, ODS, DARS, etc.
STANFINS DQRY (DataQuery) = “is a menu-driven program in a database format that provides you a means of extracting and viewing financial and accounting data from the STANFINS computer files. A query resembles a "mini-program" that is designed to extract information from the ASIMS finance and accounting files. To access STANFINS Dataquery, a user id and password are needed. In addition, you will need to have access to the dataquery production database where your accounting records are maintained.” (Source: DFAS-Rome)
ATLAS (Accounting Transaction Ledger Archival System) = “is the original data warehouse for STANFINS data. ATLAS provides a longer history of data than what is available from STANFINS. STANFINS database only holds the history for six months. Queries can also be performed on multiple databases. The data can easily be turned back into STANFINS input.” (Source: DFAS-Rome)
ODS (Operational Data Store) = “is a useful tool in querying many data elements. ODS is a single data base interfacing information for entitlement transactions, payment information and accounting information. It includes all such transactions made by the Deputy Director for Central Disbursing (DDCD), DFAS Columbus and other DFAS centers. Data is stored at the transaction level.” ODS is a more enhanced version of ATLAS.” (Source: DFAS-Rome)
DARS (Database Accounting Reconciliation System) = “is a PC based group of Accounting Reconciliation Tools to detect errors in the STANFINS database and provide an automated means of making input/corrections. It is designed for the Accounting Office or the Budget Office. It primarily uses existing data in STANFINS and requires only corrections to erroneous data to make the input resulting in a significant reduction of re-work. If it has been typed once, it doesn’t need to be typed again. Many modules have manual input screens for creating original input. This serves as a backup to STANFINS in case the system is down.” (Source: DFAS-Rome)
EDA (Electronic Document Access) = “is a world wide web (WWW) based document repository system that supports information needs of DFAS and the CINCS/Service Agencies of the DoD. EDA combines internet and web technologies with electronic document management to eliminate paper files. EDA facilitates information sharing among DoD communities and provides secure access to single source DoD official documents. EDA is a reference archive that provides the user a read-only view of various documents such as contracts and contract modifications, vouchers, Government Bills of Lading (GBLs), Material Acceptance and Accounts Payable Reports (MAAPRs), including recently added document types, non-automated GBL and Government Transportation Requests (GTRs). The system provides users with an efficient method for storing, sharing and retrieving documents.” (Source: DFAS-Rome)
ELECTRA (Electronic Error Correction and Transaction Analysis) = “Electra is an umbrella name for a set of three utilities that save processing time and make applications a "push button concept". The desktop utilities are menu driven user interfaces that greatly simplify the user training. These utilities include: "Error Correction", "Tabs", "EdVer", and "QLPs". The Edit Error Correction module provides users the ability to correct Edit Errors, create new records, or delete bad records. This module mirrors the mainframe's process. Tabs are a set of equations that verify the relationships between transactions. The "EdVer" report contains all records that have passed the HQARS mainframe edit routine. This report is used in the verification and analysis portion of the monthly report cycles (i.e. 112, 218). The My QLP module is a set of predesigned queries named after the Unisys Query Language Processor (QLP). These reports were formerly designed, maintained, updated and run on a nightly basis. Today one query file is downloaded from the mainframe and made available for use through Electra. Using the Electra menu, the accountant can specify not only the operating agency but also the Fiscal Station of their data.” (Source: DFAS-IN)
Joint Review/Reimbursables = Joint Review requirements, processes, issues and references along with an overview about reimbursable programs as they relate to STANFINS will be highlighted during this session.
SOMARDS DQRY (STANDARD OPERATION MAINTENANCE ARMY RESEARCH AND DEVELOPMENT SYSTEM) = “is a menu-driven program in a database format that provides you a means of extracting and viewing AMC financial and accounting data from the SOMARDS computer files. A query resembles a "mini-program" that is designed to extract information from the ASIMS (AMC) finance and accounting files. To access SOMARDS Dataquery, a user id and password are needed. In addition, you will need to have access to the dataquery production database where your accounting records are maintained.” (Source: DFAS-St. Louis)
|Joint Review Information|
FY05 Joint Review Guidance provided by HQDA Resource Management
Phase II Joint Review Checklist provided by HQDA Resource Management
|Major Annual MAD Milestones|
|OCT-JAN||Phase I - Joint Review Process|
|FEB-MAY||Phase II - Joint Review Process|
|JUN-SEP||Phase III - Joint Review Process|
|NOV||Year End Mods must be reversed|
|JUN||Recover Cancelling Appropriation Unliquidated Obligation balances|
|SEP||Subcertification Memorandum due|