# Presentation: 538165

## The Reporting Center

*The Financial Manager’s Tool of Choice*
*Tuesday, May 25, 2004*
*Connie Constance                            Shelda Melancon*
*OCFO/Controller Operations Division/Financial Reporting Branch*

## The Reporting Center-The Financial Manager’s Tool of Choice-

- Objectives:
- To provide an overview of the Financial Statement Data Warehouse (FSDW) financial reports currently available and their relationships.
- To discuss output capabilities.
- To provide an overview of the job flow and updating process.
- To provide information on future enhancements.

## The Reporting Center-The Financial Manager’s Tool of Choice-

- 13 FSDW reports  currently available.
- Arranged alphabetically.
- All financial statements (fin. stmts.) and trial balances are available at the Mission, Agency or POD, Treasury Symbol, and/or Fund levels.

**Notes:**
POD- 
I will discuss the various reports in a logical order from the top down.

## The Reporting CenterConsolidated Financial Statements

- In millions.

**Notes:**
Five basic governmental financial statements.
The ultimate goal – an Unqualified opinion on the Consolidated USDA Financial Statements.
All other reports support and provide the details of the CFS.
Future: CR47080 June Release ...foot all sub-totals and totals...not simply a rounding.
Note that BS line 3 = $1,253.

##  The Reporting CenterConsolidated Financial Statements

- The final product includes the five basic financial statements (fin. stmts.) with comparative data at the USDA level.

**Notes:**
The ultimate goal – an Unqualified opinion on the Comparative Consolidated USDA Financial Statements.
All other reports support and provide the details of the CFS.
Future: CR47080 June Release ...foot all sub-totals and totals...not simply a rounding.
Note that BS line 3 = $1,253.
Required to select either Mission or Agency

## The Reporting CenterPreliminary Financial Statements

- The Reporting Center***Preliminary Financial Statements***

- Worksheet details of the Consolidated Financial Statements.
- Segregates FFIS data from Non-FFIS data.
- Identifies Adjustments, Intra-Mission (and Intra-Agency) Eliminations, and Inter-Mission Eliminations by Financial Statement line.

**Notes:**
The USDA to Financial Statements Crosswalks were provided to the financial community in March 2004 by Kevin Close.
CR 47078: Currently, intra-mission and intra-agency eliminations are provided in the intra-mission eliminations column.  In the June release, two additional columns are expected.  One to provide for intra-agency eliminations, and one for intra-mission eliminations. This is especially useful to agencies currently using FFIS and non-FFIS. Under the current scheme, 

## The Reporting CenterCrosswalk Trial Balance

- Details of the FFIS and Interfaced Non-FFIS columns by line number.
- Includes titles, account numbers, accounting periods, fund categories, and vendor types.

**Notes:**
The Fin Stmt Crosswalks which map the USDA accounts to SGL and to the Fin Stmt lines is distributed periodically via email.  The last distribution was in March 2004, and a revision is expected soon.
Note that if you’re reviewing a liability, then credits will be positive and debits will be negative.
Fin stmt exclusions are input into the CSSL table

## The Reporting CenterAdjustments Report

- The Reporting Center***Adjustments Report***

## The Reporting CenterEliminations Report

- The Reporting Center***Eliminations Report***

**Intra-Mission Eliminations**

**Inter-Mission Eliminations**

**Notes:**
Like the Adjustments Report...
Additionally,...
If were seeking the details of one column, specify the elimination type on the selection criteria screen.

## The Reporting CenterFinancial Statement Consistency Report

- Assists with quality review of the financial statements by identifying standard relationships and differences that exist.

**Notes:**
Discussed earlier by Dennis Jack.

## The Reporting CenterTrial Balance Reports

- Includes
- Abnormal Balance by Treasury Symbol
- Abnormal Balance by Fund
- GL Account Trial Balance
- Trial Balance
- Trial Balance by Treasury Symbol
- Does not consider CSSL exclusions.
- USDA general ledger account numbers.
- FFIS and Interfaced Non-FFIS data
- POD is a selection criteria which makes it possible to retrieve FFIS or Interfaced Non-FFIS data individually.

**Notes:**
FSET input will not show up as details are not available.

## The Reporting CenterGL Account Trial Balance

- The Reporting Center***GL Account Trial Balance***

- Includes all FFIS data and Interfaced Non-FFIS data.
- Does not give consideration to exclusions.

**Notes:**
If agency has exclusions and the goal is to reconcile to the fin stmt, specify the appropriate treasury symbols during within the selection criteria.

## The Reporting CenterTrial Balance

- The Reporting Center***Trial Balance***

- Displays the *GL Account Trial Balance* with added details by budget fiscal years and fund.

## The Reporting CenterTrial Balance by Treasury Symbol

- The Reporting Center***Trial Balance by Treasury Symbol***

- Displays the *GL Account Trial Balance* with added details by vendor type.

## The Reporting CenterAbnormal Balance by Treasury Symbol

- The Reporting Center***Abnormal Balance by Treasury Symbol***

- Provides abnormal balances by treasury symbol.
- Abnormal balances greater than $1,000,000 must be explained.
- Significant audit issue.

**Notes:**
For example, cash normally has a debit balance but, for some funds, it is SOP to have credit balances. This is especially true for GL 1013 OPAC Disbursements.
Current POD’s available are USDA and Interfaced Program (PD07 and PDFA)
Debits and credits are net, and if the total is abnormal, it is displayed.

## The Reporting CenterAbnormal Balance by Treasury Symbol

| Month | Deliverable Due |
| --- | --- |
| March | May 7th |
| April | May 28th |
| May | June 30th |
| June | July 30th |
| July | August 31st |
| August | September 30th |
| September | October 28th |

**Past Due**

- Submit to OCFO a few days earlier to allow for the completion of quality reviews.

## The Reporting CenterAbnormal Balance by Fund

- The Reporting Center***Abnormal Balance by Fund***

- Provides abnormal balances by fund.
- If more than one fund...most likely will not reconcile to the Abnormal Balance by Treasury Symbol report.

**Notes:**
Use TS Selection Criteria.
Stand alone report.
If looking for details by fund of abnormal balances, recommend using the Trial Balance report.

## The Reporting CenterSF 133 – Unofficial Report on Budget Execution

- Budgetary Only for FACTS II Reporting.
- Unofficial representation of SF-133.
- Agencies are responsible for approving prior to FACTS II submission.
- Manually updated.
- _Reconciles_ to the Statement of Budgetary Resources by Treasury Symbol.

**Notes:**
The agency is expected to understand any differences between the official and this projected statement.
The SF-133 should closely resemble SBR by ts:
	 if the ts is not shared.
	 Known difference: All 4210 balances on unexpired ts appear in line 3C on the SBR.  Whereas, debit balances appear on line 3c of the 133 and credits appear on line 10.
The only known difference 

## The Reporting CenterFACTS II Reports

- Federal Agencies’ Centralized Trial Balance System.
- Submitted to Treasury.
- Quarterly process.
- Run only upon request by the Financial Reporting Branch.

**Notes:**
FSET input will not show up as details are not available.

## The Reporting CenterSF 133 – Unofficial Report on Budget Execution

- The Reporting Center***SF 133 – Unofficial Report on Budget Execution***

- Includes all FFIS data and Interfaced Non-FFIS data related to the treasury symbol.

**Notes:**
Shared treasury symbols with other USDA agencies in which NRCS is the child are not available for selection. Ex: 12X0500 (DA).

## The Reporting CenterSF 133 – Unofficial Report on Budget Execution

- The Reporting Center***SF 133 – Unofficial Report on Budget Execution***

- Includes all FFIS data and Interfaced Non-FFIS data related to the treasury symbol.

**Notes:**
Shared treasury symbols with other USDA agencies in which NRCS is the child are not available for selection. Ex: 12X0500 (DA).

## Fiscal Year-End report.
Unofficial representation of the FMS 2108.
Agencies are responsible for approving prior to FACTS II submission at fiscal year-end.
Reconciles to the SF-133 at fiscal year-end.

- Unofficial representation of the FMS 2108.
- Agencies are responsible for approving prior to FACTS II submission at **fiscal year-end.**
- Reconciles to the SF-133 at **fiscal year-end**.

- The Reporting Center***FMS 2108 Year-End Closing Statement***

## The Reporting Center

*Output Capabilities*

**Notes:**
Five options.

## The Reporting CenterMost Common Output

***Run the Report***:
- Fastest run time.
- Provides immediate online results.
- Hard copy prints are not formatted to fit on the page properly.
***Save Output as PDF***:
- Takes longer to run.
- Provides almost immediate results.
- Online view of full page with zooming capabilities.
- Hard copy prints are professionally formatted.
- Can be saved for later retrieval.

## Save report as a spreadsheet:
Opens or saves as a Microsoft Excel                 document.
Allows for alteration of the results. 
May be saved for later use.
Longest run time...still short. 
Best for analysis.
Totals and sub-totals are text.
Generally requires formatting                             within Excel.
Invaluable to the experienced Excel user.

- Opens or saves as a Microsoft Excel                 document.
- Allows for alteration of the results.
- May be saved for later use.
- Longest run time...still short.
- Best for analysis.
- Totals and sub-totals are text.
- Generally requires formatting                             within Excel.
- Invaluable to the experienced Excel user.

- The Reporting Center***Best Analytical Output***

## Save Output in a Folder:
Opens or saves as a Microsoft Word document.
Allows for alteration of the results. 
May be saved for later use.

Save in my Reports folder:
The intent is to save the output within the user’s Reporting Center viewing for quick retrieval at a later date or time.

- Opens or saves as a Microsoft Word document.
- Allows for alteration of the results.
- May be saved for later use.
***Save in my Reports folder***:
- The intent is to save the output within the user’s Reporting Center viewing for quick retrieval at a later date or time.

- The Reporting Center***Least Common Output***

## The Reporting Center

- Notes:
- It is essential to understand the relationships of the reports to take advantage of their benefits.
- By using the CONTROL key on the keyboard, more than one variable may be included within a selection criteria.
- The SF-133 and SF-2108 include parent and child data.

## Overview of FSDW II Statement Generation Process

## FSDW II FACTS I

## FSDW II FACTS II

## FSDW TABLES

## FSDW Job Cycle

- Financial Reporting Branch (FRB) updates the FSDW Report Update Pending (CSUP) table
- FRB e-mails request to the Accounting Processing Branch Functional Administrators (FA) to run either or all of the  FSDW jobs CSRS/CSXE/CSW1/CSF1 or CSF2
- FA prepares job sheet and delivers to AMS, Inc Cycle Support staff
- AMS, Inc. Cycle Support staff delivers to Scheduling
- Scheduling submits jobs to run
- CSRS, CSXE, and CSW1 must all complete before the next begins.  FACTS I and FACTS II jobs may run at the same time upon completion of CSRS or CSXE.

## FSDWApproximate Job Time

- CSRS – Crosswalk table – 3 hours
- CSXE – Adjustment table – 1 hour
- CSW1 – Summary Table – 30 minutes
- CSF1 – FACTS I report – 30 minutes
- CSF2 – FACTS II report – 30 minutes

## Reporting CenterUpdate Time

- Trial Balances – automatically updates Tuesday through Saturday mornings after completion of the CSSL job.  Approximately 5:30am CST.
- Financial Statements – automatically updates Tuesday through Saturday mornings after completion of the CSW1 job.  Approximately 7:00am CST.
- SF-133 and FMS-2108 – FRB sends e-mail to the WEB team to manually update after completion of the FACTS II CSF2 job

## Reporting CenterUpcoming Changes

- Trial Balance by Vendor Type
- Trial Balance by Direct vs. Reimbursable
- Comparative statement with variance columns
- Comparative trial balance with variance columns
- Add additional column to the preliminary statements for the intra-agency eliminations
- A Consolidated Report for each statement
- New consistency checks on the Financial Statement Consistency Report

## The Reporting Center

- Summary:
- The Reporting Center puts financial information at your fingertips.
- The Reporting Center allows various options of output...tailored to your circumstances.
- The Reporting Center is an invaluable tool and improves with each change.

## The Reporting Center

***Be Sure to:***
**Make the**
**most of it!!!**

## Questions