Subscribe to the SSDT Newsletter by clicking here.  Your email will be added to a distribution list.                                                             

Certification Reports Available in USAS-R

Classic's USACERT programs are available in the Redesign.  They are all located under the Periodic menu and include the following:

Appropriation Resolution

You can choose one of the following 'amounts to use' depending on whether a temporary resolution or permanent resolution report is needed.   The selected amounts will appear on the report.

• Beginning Balances Only (July 1st Cash balance)
• Next Year Proposed
• FTD Appropriation, Carryover, and Totals
• FTD Appropriation minus Carryover Encumbrances

Fund levels for reporting can be set up under CORE>Accounts' Fund tab prior to running the Appropriation Resolution report.  This is a one-time setup.  By default it will include all funds and all resolution levels of which you can modify.

The Appropriation Resolution narrative from Classic's APPRES program, which includes the the date/time/location and the listing of Board members adopting the Resolution, is not available within the Redesign.  Instead, a sample narrative (in Word format) is available in the documentation which you can then save and customize with your district information. 

Certificate of Available Balances and the Amended Official Certificate of Estimated Resources

Separate summary and detail report options are available for both reports.  By default, all funds will be reported at the FUND/SCC level.  However, you can access the Fund tab under CORE>Accounts to modify it.   Like the Appropriation Resolution report, the Certificate and Amended Certificate programs have sample narratives available in the documentation you can save and customize.

Certificate of Available Balances Options and Calculations

Fiscal Year: Enter the fiscal year to report on.  

Exclude Fund/SCC: enter Fund/SCCs you want to exclude from the report. 

Principal Amounts for Permanent Fund: enter the Fund/SCC 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.  The principal amount entered for each Fund/SCC will be subtracted from the beginning cash balance listed on the report.

Advances Not Repaid: enter advances that have not been repaid as of July 1st.  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.

The resulting report contains the following columns.  Included is how the amounts are calculated:

• Cash Balance June 30: Cash Balance as of June 30 of the prior year
• Encumbrances June 30: all outstanding encumbrances as of June 30 which have been carried over into the new year
• Advances not Repaid: Advances not repaid have to be entered into the program
• Carryover Balance Available for Appropriation: Column 1 – Column 2 +/- Column 3.
• Total Amount From all Sources Available for Expenditures: Pulled from the receivable amounts stored on the revenue accounts.  For example, the total in this column for the general fund should equal the total sum of all receivable amounts for general fund revenue accounts  If you did not enter temporary or permanent appropriations to your revenue accounts, this amount will be zero.
• Total Amount Available Plus Balances: Column 4 + 5

Amended Official Certificate of Estimates Resources Options and Calculations

Fiscal Year: enter the fiscal year to report on.  

Tax Options: By default, values listed will be included in the "Taxes" column on the report unless you check them. NOTE: Income Tax (1130) and Other Taxes (1190) options.   

Exclude Fund/SCC: enter Fund/SCCs you wish to exclude from the report. 

Principal Amounts for Permanent Funds: enter the FUND/SCC along with the associated principal amount for any permanent funds. (Same as Certificate report) 

Advances Not Repaid: enter advances that have not been repaid as of July 1st. (same as Certificate report)

The resulting report contains the following columns. Included is how the amounts are calculated

• Unencumbered Balance July 1: calculated for each fund by taking the July 1 cash balance - Prior year carryover encumbered + Advances not repaid - Principal entered on screen
• Taxes and Other Sources: are the receivable amounts; these are the final receivables at the time which would include any additions or deductions made.  If you did not enter temporary or permanent appropriations to your revenue accounts, this amount will be zero.
• Total:  total of Column 1 + Column 2 + Column 3

Condensed version of "config options" table in Reports and use of report button in grid...