1 / 45

Auxiliary Financial Statement Training Session

Auxiliary Financial Statement Training Session. For Fiscal Year 2010-2011 Presented by: Finance and Accounting General Accounting. Agenda. Agenda. Discuss the detailed steps required for preparing and submitting financial statements for auxiliaries, including:

hume
Download Presentation

Auxiliary Financial Statement Training Session

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Auxiliary Financial StatementTraining Session For Fiscal Year 2010-2011 Presented by: Finance and Accounting General Accounting

  2. Agenda

  3. Agenda • Discuss the detailed steps required for preparing and submitting financial statements for auxiliaries, including: • The accrual information – Adjusting Entries • nVision Reports • Adjusted Trial Balance • Notes to SNA and SRECNA

  4. Reporting Criteria • Only auxiliaries with annual revenues greater than one million dollars are required to submit quarterly and annual (year-end) financial statements to General Accounting.

  5. Auxiliary Financial Statements vs. UF Fund Level Financial Statements UF Fund Level Financial Statements consolidate an entire fund: • Does not include assets (Funds 801-802) • Accruals related to ID Sales are not recorded • Inventory and Compensated Absences are often posted in a generic DeptID • Substantial supporting documentation is required

  6. Auxiliary Financial Statements vs. UF Fund Level Financial Statements Auxiliary Financial Statements: Auxiliary considered as a self-standing entity • Includes assets • Accruals related to ID Sales are recorded • Inventory and Compensated Absences are posted in specific auxiliary DeptID • Use as reference for preparation of UF Fund Level Financial Statements and for Auxiliary Enterprise Committee meeting

  7. Preparing Financial Statements:Process Overview

  8. Process Overview • Collect accrual information • Prepare adjusting entries • Submit adjusting journals to General Accounting • Run nVision and copy report in the workbook • Run Trial Balance query and format TB • Provide details for the Accounts Receivable and Accounts Payable • Explain any significant variations on the SNA and SRECNA in comparison to prior period.

  9. PROCESS→ Adjusting Entries - Accruals

  10. Adjusting Entries – Journal template All adjusting entries must be prepared on a journal template using PeopleSoft chartfield values to be posted to the adjustment ledger. Note: The journal template has been changed following MyUFL upgrade.

  11. Adjusting Entries – Debits and Credits

  12. Possible Adjusting Entries

  13. Adjusting Entries All adjusting entries can be posted to one single department ID in your auxiliary range. All adjusting entries will be automatically reversed on the first day of the following period except the Compensated Absences Liability and the year-end Capital Assets reconciliation.

  14. Adjusting EntriesCompensated Absences Liability $190,000.00 The entire amount of the liability must be adjusted since the prior year amount will be reversed by General Accounting. This adjustment is only required at year end and the same balance will be carried over until next fiscal year. Enter on a separate journal. The entry will not be reversed as of 07/01/2011. Note: Please refer to separate instructions on how to retrieve the report.

  15. Adjusting Entries - Capital Asset Reconciliation Complete the Capital Assets tab in the workbook (yellow highlighted cells):

  16. Adjusting Entries - Capital Asset Reconciliation • Keep the Capital Assets reconciliation entries on a separate journal. The tab includes a journal template that will be automatically populated:

  17. Adjusting Entries - Capital Asset Reconciliation The entry will not be reversed as of 07/01/2011. After adjustment for capital assets all 78xxxx accounts on the Adjusted Balance column should be zero except for Depreciation Expense:

  18. Adjusting Entries – Journal Mask Use the appropriate journal mask (3 letters) followed by AJ, year, month and 1 thru 9: JRUAJ11061 JRUAJ11062

  19. Adjusting Entries – Posting Submit your journal templates to UAS-Auxiliary@admin.ufl.edu General Accounting will post them and notify you. Once all your adjusting entries are posted, you can run the nVision report.

  20. PROCESS→ nVision Report

  21. nVision Report • In MyUFL ,navigate to People Soft and Financials PeopleTools. • In the new window, navigate to Reporting Tools / PS/nVision / Define Report Request.

  22. nVision Report • On the Report Request page, search for report ID AUX_REP • On the nVision Report Request page, select the appropriate date: 06/30/2011 for year-end. • Click on Scope and Delivery Templates.

  23. nVision Report • Search for Report Scope starting with AUX. Each auxiliary has its own scope. Select the appropriate scope and click OK to return to prior page.

  24. nVision Report • Click Run Report on the nVision Report Request page. • Click OK on the Process Scheduler page.

  25. nVision Report • Click Process Monitor on the nVision Report Request page. • On Process Request page, click refresh to update the status • Wait for Success and Posted

  26. nVision Report • Navigate to Report Manager either through the nVision Report Request page or the top menu. • On the Report Manager page click on Administration tab and retrieve the report.

  27. nVision Report – Copy to workbook • Copy the SNA and the SRECNA for both years To do so: • Copy separately each of the 4 blocks: SNA current and prior period, SRECNA current and prior period. • Paste each in the appropriate area of the workbook (SNA&SRECNA tab) using paste special value

  28. PROCESS→ Trial Balance – ACTUALS + UF_AUX_ADJ

  29. Trial Balance – ACTUAL and UF_AUX_ADJ Run trial balance query: UF_AUX_TB_FS with the appropriate prompts: Download in Excel: Note: The same query is used to pull the balances from both ledgers.

  30. Trial Balance – ACTUAL and UF_AUX_ADJ 1 3 Save the file. Format using Excel pivot table tool. Remove any subtotals from the Pivot Table. 2

  31. Trial Balance – ACTUAL and UF_AUX_ADJ Copy the entire pivot table (excluding the headers) in the workbook under tab - Adjusted Trial Balance: Pivot Table Workbook

  32. PROCESS→ Accounts Receivable Detail

  33. Accounts Receivable Accrued accounts receivable should be categorized between interdepartmental sales (ID Sales) & Non UF Sales, then by age. Provide the status of any receivables over 120 days.

  34. Accounts Receivable

  35. PROCESS→ Accounts Payables Detail

  36. Reconciliation – Recap of Accrued AP • Accrued accounts payable should be listed by vendors and categorized by age. • Provide the status of any payables over 60 days.

  37. Accrued Accounts Payable

  38. Accrued Accounts Payable • If no record is available the following query can be used: FR_VOUCHER_LOOKUP2

  39. PROCESS→ Notes to SNA and SRECNA

  40. Notes to SNA and SRECNA • Provide a brief explanation for any significant variations on the SNA and SRECNA in comparison to prior period. • Pay special attention to the following lines: Cash & Investments, Accounts Receivable, Operating Revenues, Employee Compensation and Benefits and Services & Supplies.

  41. Available Queries

  42. Available Queries • UF_AUX_TB_FS • Trial Balance for ACTUALS and UF_AUX_ADJ ledger • UF_GL_TB_BY_FUND_DEPT_AUX_QRY • Trial Balance for ACTUALS ledger • UF_GL_JOURNAL_DETAIL_QUERY2 • Provides the entries making up the ACTUALS Trial Balance • UF_AUX_ADJ_JRNL_DETAIL • Provides the entries making up the UF_AUX_ADJ Trial Balance • FIT Cube

  43. Financial Statement Due Date Submit your completed workbook to UAS-Auxiliary@admin.ufl.edu no later than: August 5, 2011

  44. Any Questions?

  45. Contacts We are happy to assist you! • Patrice Lecomte • plecomte@ufl.edu • 392-1326 ext. 303 • Jennifer Lu • jennifer.lu@ufl.edu • 392-1326 ext. 403 • Sheela Moudgil • moudgils@ufl.edu • 392-1326 ext. 410

More Related