文档介绍：Auxiliary Financial Statement Training Session
For Fiscal Year 2007-2008
Presented by:
General Accounting
Finance and Accounting
1
Agenda
2
Agenda
Discuss the general flow of information related to preparing year-end financial statements for auxiliaries.
Discuss the detail steps required for preparing and submitting financial statements for auxiliaries, including
Identifying and reconciling the data
Preparing the financial statements in the proper format
Review available queries
Discuss due date - August 08, 2008
3
New this Year
Only auxiliaries with annual revenues greater than one million dollars will be required to submit quarterly and annual (year end) financial statements to General Accounting.
New Financial Statement template
Some minor modifications on the A and the SNA
One single sheet with all the reconciliations and adjustments
4
Process Overview
5
Process Overview
Run a trial balance query, download to Excel, anize the data with a pivot table.
Transfer the numbers from the trial balance pivot table to the Trial Balance Reconciliation sheet.
Enter the numbers from the prior year Statement Assets (SNA) to the Trial Balance Reconciliation sheet.
Reverse prior year accruals – Reversing Entries.
6
Process Overview (cont)
Prepare current year accruals on the Trial Balance Reconciliation sheet.
Input information from Depreciation Report.
The last column of the Trial Balance Reconciliation sheet will automatically populate the Financial Statements - A & SNA.
Complete A for prior year: Comparative information only.
Provide details for the accrued Accounts Receivable and accrued Accounts Payable.
7
PROCESS → Trial Balance
8
Trial Balance Query – Navigation
Security Roles Needed:
UF_FI_FUNC_USER
UF_GL_RESEARCH_REPORTING
PeopleSoft>Financials People Tools>Reporting Tools> Query>
Query Viewer
9
Search for query
UF_GL_TB_BY_FUND_DEPT_AUX_QRY
Aux year end TB by Fund & Dept  
Run to HTML
Trial Balance Query – Procedures
10