# Presentation: 090524

## The Reporting Center

*The Financial Manager’s Tool of Choice*** **
**Wednesday, May 4, 2005**
**Shelda Melancon**

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

**Objectives:**
**To encourage use of the Reporting Center.**
**To provide an overview of the reports available in the Reporting Center.**
**To provide information on future enhancements.**

## Every financial transaction impacts your financial statements.

## The Financial Hierarchy

**The Financial Hierarchy**

**Departmental**
**financial**
**statements. **
**Mission financial statements.**
**Agency financial statements.**
**FSDW details by fund and budget fiscal year**
**within general ledger accounts.**
**Extract summarization from FFIS or program interfaces.**
**General ledger postings to general ledger accounts. **
**Direct-entered documents or subsidiary system interfaces.**
**Detailed financial transactions.**

**Unqualified Opinion**

**Notes:**
Every financial transaction must be reported.
The ultimate goal is an “unqualified audit” opinion and it all begins with you.  The accuracy and importance of the detailed transactions cannot be over-emphasized. Your every decision including vendor code, accounting code, transaction code, etc. makes a direct impact on your agency and the Department’s financial statements and reports.  From most detailed to most summarized.

## FSDW = Financial Statement Data Warehouse
SOURCE:   
FFIS transactions (FDW details)
Program Interfaces 
FSET (Financial Statement Entry Tool)
CSXE Adjustments

- SOURCE:
- FFIS transactions (FDW details)
- Program Interfaces
- FSET (Financial Statement Entry Tool)
- CSXE Adjustments

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

## Each report has specific selection criteria.
Report Year = Fiscal year...not calendar year.
Report Period = Usually fiscal month; 13 = fiscal year-end adjustment period.
Beginning Fiscal Year = Budget Fiscal Year not Reporting Fiscal Year.
Comparative Statements show two reporting periods side-by-side.
Variance reports provide the change in two periods and the percentage increase or increase. 

- Report Year = Fiscal year...not calendar year.
- Report Period = Usually fiscal month; 13 = fiscal year-end adjustment period.
- Beginning Fiscal Year = _**Budget**_ Fiscal Year not Reporting Fiscal Year.
- Comparative Statements show two reporting periods side-by-side.
- Variance reports provide the change in two periods and the percentage increase or increase.

**The Reporting Center**** ****Selection Criteria**

**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 Reports

- Includes
- GL Account Trial Balance
- Trial Balance by Treasury Symbol
- Trial Balance
- Abnormal Balance by Treasury Symbol
- Abnormal Balance by Fund
- Does not consider CSSL exclusions.
- USDA general ledger account numbers.
- Includes all FFIS data and Interfaced Non-FFIS data.

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

## Provides balances by general ledger account for the criteria specified. 
Includes Comparative & Variance options.

- Includes **Comparative & Variance** options.

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

**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**

**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 by Treasury Symbol

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

**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 Abnormal Balance by Treasury Symbol

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

- For details by fund, use the Trial Balance.

**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 Fund

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

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

## Trial balance data is    cross-walked to the financial statements.

**Trial balance data is    cross-walked to the financial statements.**

## The Reporting CenterPreliminary Financial Statements

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

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

**FFIS**

**Non-FFIS**

**Inter-Mission Eliminations**

**Intra-Mission Eliminations**

**Adj.**

**Intra-Agency Eliminations**

**Notes:**
The USDA to Financial Statements Crosswalks are provided to the financial community by Kevin Close.
Adjustments are signed USDA adjustments approved by OCFO Headquarters, John Brewer.

## The Reporting CenterCrosswalk Trial Balance

**The Reporting Center****Crosswalk Trial Balance**

**FFIS**

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

**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**

**Adj.**

## The Reporting CenterEliminations Report

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

- Provides details by financial statement and line number.

**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Consolidating Financial Statements

**The Reporting Center****Consolidating Financial Statements**

**Notes:**
Not rounded.
Where do these figures come from?

## The Reporting CenterConsolidated Financial Statements

**The Reporting Center****Consolidated*** ***Financial Statements**

- After eliminations and adjustments.

**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Consolidated Financial Statements

**The Reporting Center is the official record of the Department’s Financial Statements.**

**The Reporting Center****Consolidated Financial Statements**

**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.
The Department’s financial statements are the consolidated totals of all agency reported financial transactions.  

## The Reporting CenterFinancial Statement Consistency Report

**The Reporting Center****Financial Statement Consistency Report**

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

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

- Budgetary Only.
- Unlike all other reports, the source is the FACTS II adjusted trial balance.
- Unofficial representation (USDA cross-walk) of the expected SF-133.
- Manually updated.
- _Reconciles_ to the Statement of Budgetary Resources (SBR) 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 

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

- Reconciling Items:
**USDA Shared Treasury Symbols-**combined activity reported on the SF133 of the parent agency; SBR shows agency only.
**Allocation Transfers**-excluded from the SBR.

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

**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**

**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 reviewing 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 reviewing 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

***Run the Report***:
- Fastest run time.
- Provides fastest 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 or email attachment.

## 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. (Unmerge cells.)
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. (Unmerge cells.)
- Invaluable to the experienced Excel user.

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

## The Reporting Center Future Enhancements

- Trial balances that reflect three following columns:
- 	FFIS – Exclusions = Reported
- Adjustments module to eliminate calculating financial statement line impact.
- Comparison of the SF-133 to the SBR.

## The Reporting Center

- Summary:
- The Reporting Center is the official record of the Department’s Financial Statements.
- The Reporting Center puts financial information at your fingertips.
- The Reporting Center allows various options of output...tailored to your circumstances.
- The Reporting is an invaluable tool and improves with each change.