eReporting - PowerPoint PPT Presentation

ereporting n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
eReporting PowerPoint Presentation
play fullscreen
1 / 70
eReporting
131 Views
Download Presentation
jennifer-silva
Download Presentation

eReporting

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. eReporting 2011

  2. School Systems use eReporting to: The Basics • Report Budget and Financial information at Year-End • Report Financial information quarterly for Fund 142 (Federal) • Report Non-Licensed Personnel • Report Trustee/Fiscal Agent information • Certify Reports

  3. Web Address: https://www.k-12.state.tn.us/ereporting

  4. Logon to eReporting Enter User ID and Password

  5. On the Available Applications screen, select the appropriate eReporting access

  6. Home Page for eReporting

  7. Home Page (Continued)

  8. View • View • View will be used to view any information you have previously loaded on the system • View can also be used to print a report. Edit • Edit • Edit will be used to enter your data manually or edit the data you uploaded.

  9. In Local Government, go to:ACCOUNTINGREPORTSBOE Annual Financial report From Create/Load, Select Create SDE file from GL (or from History if books have been closed at year-end) Screen appears: ENTER by each fund that applies (141, 142, etc.) Then, hit Escape Screen appears: Shows total # of Selected Funds Check: YEAR Select Annual Financial Report, Original Budget, or Budget Amendment by putting X Check: Thru Month; then, ENTER (Hit OK when error message pops up) If the screen is correct, select YES Select Load SDE Accounts to SDE.TXTGo to primary server to send the file to eReporting Creating CSV file in Local Government For Uploading to eReporting

  10. Uploading into eReporting From eReporting and logged in as District User, click on Send File Link at Top.

  11. Uploading into eReporting Click the Browse button to look for the SDE.TXT file

  12. Uploading into eReporting This dialogue box will come up. You will need to choose the L: drive from the dropdown. Further drill down to the Files folder and click on the SDE.TXT file. NOTE: You will need to be at the server to get your file.

  13. Uploading into eReporting L:\Files\SDE.TXT You should now have L:\Files\SDE.TXT or something similar containing SDE.TXT in the box next to Browse.

  14. Uploading into eReporting L:\Files\SDE.TXT Click Send File to transmit.

  15. Uploading into eReporting Print your Error report. If Maximum Number of Errors (50) is reached, you most likely have not uncertified the report. You will need to uncertify and re-upload the report.

  16. Manually Entering Data Select Edit for the appropriate report.

  17. Manually Entering Data Select correct reporting period from dropdown.

  18. Manually Entering Data Select appropriate fund from dropdown

  19. Manually Entering Data If editing Fund 142, you must select the appropriate subfund from the dropdown.

  20. Enter (or edit) amounts in the appropriate lines. IMPORTANT: Enter amounts in whole dollars. DO NOT enter cents—this will cause rounding issues when you balance your report. Manually Entering Data

  21. Manually Entering Data To save the data you have entered or edited, click on the Save button at the bottom left of the screen. Continue this process until all data is entered.

  22. Click onCreate Adjustment. • Fill in: • Date • Description • Amount • Then Save Beginning of Year Equity Adjustments

  23. Transfers for AFR and Budget Enter amounts and Save. If using 49800 or 49810, then Add Documentation will appear.

  24. Transfers for AFR and Budget (Continued) • From dropdown, select the fund from which it was transferred. • Enter a brief description. • The amount should already be showing in the Amount box. • Click Save and Add Documentation is complete.

  25. Balancing Your AFR Report From the Reports list, Select the AFR (Summary Report).

  26. Balancing Your AFR Report Select the appropriate year from the dropdown.

  27. Balancing Your AFR Report On Summary 1, “Total Assets” (11000)should equal “Liabilities, Reserves & Fund Balance” (31000).

  28. Balancing Your AFR Report To move to the next page, select Summary 2 from the dropdown or click on >>Next>>

  29. Balancing Your AFR Report On Summary 2, “Tot. Funds” should equal “Tot. Exp.”

  30. Balancing Your AFR Report Remember to balance Fund 142 by subfund. Click on Show Subfunds in the upper right-hand corner.

  31. Each subfund should balance on both Summary 1 and Summary 2. Balancing Your AFR Report

  32. Balancing Your Budget or Budget Amendments From the Reports home page, select View in either the Budget Detail Report or Budget Amendments.

  33. Balancing Your Budget or Budget Amendments After selecting the correct year, use the account function dropdown to select the “EXPENSE-Expenditure Summary” near the bottom of the list.

  34. Balancing Your Budget or Budget Amendments Scroll to the bottom and write down your “Grand Total Expenditures” by Fund.

  35. Balancing Your Budget or Budget Amendments Repeat the process for the Revenue Summary. Write down the “Grand Total Available Funds” by Fund.

  36. Your “Grand Total Available Funds” should be greater than or equal to your “Grand Total Expenditures”. This process should be repeated for Fund 142 by subfund. Balancing Your Budget or Budget Amendments

  37. Report Certifications To certify a report in eReporting, you must first Logon as the appropriate role.

  38. Report Certifications Select Report Certifications from the top bar.

  39. Report Certifications Select correct District Period and Report using the dropdown boxes.

  40. HINT: If you do not select an “Application Role” from the dropdown, you will see who needs to certify the report. Click on the Edit command at the far left of the row for the appropriate role. Report Certifications

  41. Report Certifications To certify the report, check the box and click Save.

  42. When correctly certified, your name and the date will appear in the Certification box. NOTE: To uncertify a report, repeat the process and uncheck the box. Report Certifications

  43. Brief Overview of eReporting Reports

  44. Report Due Dates

  45. No data entry required. Report pulls information from the PY AFR and the CY Budget Detail

  46. Information is entered by CSV upload or manually. Summary Report is used for the purpose of balancing your report.

  47. HINT: You must add a description of the expenditure or the amount will not save.

  48. This schedule is used to report expenditures paid by other agencies not reported anywhere else. Examples include: Central Finance, SRO’s, Capital Projects paid by City/County. IMPORTANT NOTE: Expenditures reported in functions 71100-73100 are included in Per Pupil costs for the Report Card. AFR Expenditures by Other Agencies (Continued)

  49. Data will be enter for Bonded Debt,Capitalized Leases, Other Loans Payable, & Notes Payable. Information should include all debt related to school property.

  50. Enter data and save.