The Certification/Appropriation Reports allows the user to generate an Amended Certificate of Estimated Resources summary or detail report or a Certificate of Available Balances summary or detail report.
Certificate of Available Balances
The Certificate of Available Balances program produces a report which is to be submitted to the county auditor at the beginning of the fiscal year. The program offers both detail and summary report options. By default, all funds will be reported at the Fund/SCC level. However, you can choose to enter ranges of fund numbers and specify a reporting level of either Fund or Fund/SCC. Please refer to the Fund Levels for Reporting section of this chapter for further information.
Fiscal Year
- The user selects the fiscal year to report on.
Exclude Fund/SCC
- You may also enter Fund/SCCs you wish to exclude from the report. This might be utilized when it becomes necessary to exclude a budget reserve fund, student activity funds, or auxiliary service funds, etc.
Principal Amounts for Permanent Funds
- Allows the user to enter the fund and special cost center along with the associated principal amount for any permanent funds. Reporting requirements state that only interest earnings are supposed to be considered available for expenditure when certifying year-end balances of a permanent fund to the county auditor. NOTE: The amount entered for each Fund/SCC will be subtracted from the beginning cash balance reported for the fund.
Advances Not Repaid
- It is necessary to enter any advances that have not been repaid as of July 1st. NOTE: A positive amount should be entered for the fund that made the advance and a negative amount entered for the fund that will be making the reimbursement.
- Use the + to add principal amounts for permanent funds. You will be prompted to enter the permanent Fund/SCC and Principal amount. The SCC will default to '0000' if an SCC isn't entered.
Format
- Select the desired output format and click on 'Generate'.
Narrative Data for Certificate of Available Balances
The Certificate of the Total Amount from All Sources Available for Expenditures, and Balances narrative from Classic's CERTBAL program, which included the date/time/location, explanation of the report, as well as signature lines for County Auditor officials is not available in the Redesign report. A separate document (i.e. Word document) will need to be created. Click here for a sample narrative (in Word format) in which you can then save and customize with your district information.
Amended Official Certificate of Estimated Resources
The "Amended Official Certificate of Estimated Resources" report is to be submitted to the county auditor when there have been changes made to estimated resources. By default, all funds will be reported at the Fund/SCC level. However, you can choose to enter ranges of fund numbers and specify a reporting level of either Fund or Fund/SCC. Please refer to the Fund Levels for Reporting section of this chapter for further information.
Fiscal Year
- The user selects the fiscal year to report on.
Tax Options
- By default, values listed will be included in the "Taxes" column on the report unless you place a checkmark next to the Property Tax Allocation (3131, 3132, 3133, 3134, 3135, 3139), Income Tax (1130) or Other Taxes (1190) options.
Exclude Fund/SCC
- You may also enter Fund/SCCs you wish to exclude from the report. This might be utilized when it becomes necessary to exclude a budget reserve fund, student activity funds, or auxiliary service funds, etc.
Principal Amounts for Permanent Funds
- Allows the user to enter the fund and special cost center along with the associated principal amount for any permanent funds. Reporting requirements state that only interest earnings are supposed to be considered available for expenditure when certifying year-end balances of a permanent fund to the county auditor. NOTE: The amount entered for each Fund/SCC will be subtracted from the beginning cash balance reported for the fund.
Advances Not Repaid
- It is necessary to enter any advances that have not been repaid as of July 1st. NOTE: A positive amount should be entered for the fund that made the advance and a negative amount entered for the fund that will be making the reimbursement.
- Use the + to add principal amounts for permanent funds. You will be prompted to enter the permanent Fund/SCC and Principal amount. The SCC will default to '0000' if an SCC isn't entered.
Format
- Select the desired output format and click on 'Generate'.
Narrative Data for Estimated Resources
The Amended Official Certificate of Estimated Resources narrative from Classic's AMDCERT program, which included the district name, date/time/location and signature lines for the Budget Commission is not available in the Redesign report. A separate document (i.e. Word document) will need to be created. Click here for a sample narrative (in Word format) in which you can then save and customize with your district information.
Fund Levels for Reporting
The report subtotals are based on reporting levels that can be specified on the associated Fund.
- Under Core/Accounts, click on the the tab to display the Fund grid.
- Click on to edit an existing Fund.
- Select the 'Certification Reporting' level for the fund and the Certification/Appropriation reporst will be based on that fund level. You can choose from 'Fund' or 'Fund/SCC'.
- Select the resolution reporting levels for the Appropriation Resolution report.
- Click on to save changes.