...
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. The Certificate reports will be based on the fiscal year for the current period and the Amended Certificate reports will be based on the current period.
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 reports will include amounts based on the fiscal year of the current posting period. The program offers both detail and summary report options. By 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 the Fund Levels for Reporting section of this chapter for further information.
Fiscal Year
- Drop down fiscal year should not be changed. The fiscal year will populate with the current posting period’s fiscal year and will process the current period’s data. For example, if you need FY2022 data, make the Current posting period July 2021.
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.
...
- It is necessary to enter any advances from the prior fiscal year 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.
...
Select the desired output format and click on 'Generate'.
Snapshot of the Summary Report in PDF format:
Snapshot of the Summary Report in Excel format:
Report Columns Calculations
...
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 and will be run for the current posting period. 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
...
...
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.
...
- It is necessary to enter any advances from the prior fiscal year 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.
...
- Select the desired output format and click on 'Generate'.
Snapshot of Report on PDF format:
Snapshot of Report in Excel format:
Report Columns Calculations
...