Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(tick) 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:

RedesignClassicSample ReportDescription
Appropriation ResolutionAPPRESClick HereReport of the district's temporary resolution prior to fiscal year closing or as a final resolution
Certificate of Available BalancesCERTBALClick HereA certificate of available balances which is to be submitted to the county auditor at the beginning of the fiscal year
Amended Official Certificate of Estimated ResourcesAMDCERTClick HereReport to be submitted to the county auditor when there have been changes made to estimated resources.

Prior to running one of the above reports. fund levels for reporting can be set up under CORE>Accounts' Fund tab.  This is a one-time setup.  The 'Resolution Levels' and 'Include in Resolution' checkbox pertain to the Appropriation Resolution report.  By default,  all funds and all resolution levels are included of which you can modify.  The 'Certificate Reporting' pertains to the Certification reports.  You can choose between Fund/SCC or Fund reporting for each Fund.

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

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.   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 Fundenter 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 that were entered in 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 is receipt code 1130 and Other Taxes is receipt code 1190.   

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 in program
  • Taxes and Other Sources Columns: 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



How does the "operationCondensed version of "config options" table in Reports and use of report button in grid...

In USAS-R, when creating a custom report from scratch or taking an existing template report and 'tweaking it' to create a custom report, the 'Configure Filters' tab is the behind-the scenes-mastermind that creates the report prompts under the 'Query Options" tab when generating a report.


Screenshot of configure filters in cash summ.. .and screensshot of query option when generating cash summary


  1. Pull a property from the list of properties provided into the 'Display Name'
  2. Select an Operation
  3. Enter a specific filter value or set up a parameter value so the report prompts you to enter a value when generating the report

Please use the table below to assist in creating your report filters.


OperationDefinitionSpecific Filter Value Example in Configure Filters (parameter will not display when generating report)Parameter Value Example in Configure Filters (parameter will display when generating report)How Parameter Value display when generating report
EqualsMatch an exact value (i.e. account filter)

Image Modified

Image Modified

Image Modified

One ofAble to enter multiple values with commas (i.e. several ven. #s)

Image Modified

Image Modified

Image Modified

Not EqualsExclude a value (i.e. exclude 1099 type)

Image Modified

Image Modified

Image Modified

LikeBegins with (i.e. all object codes starting with 1)

Image Modified

Image Modified

Image Modified

ContainsEntered Value Anywhere in the Field (i.e. contains part of vendor name)

Image Modified

Image Modified

Image Modified

BetweenBetween two Values

Image Modified

Image Modified

Image Modified

Is NullNull looks for blank fields



Not NullExcludes blank fields


Greater ThanGreater than value entered

Image Modified

Image Modified

Image Modified

Greater Or EqualGreater than or equal to value entered

Image Modified

Image Modified

Image Modified

Less ThanLess than value entered


Less Than or EqualLess than or equal to value entered

Image Modified

Image Modified


Not One OfExclude multiple values separated by commas

Image Modified


Sort



Type



Match Any of the FollowingMatch any of the value entered





  1. Select the desired Operation from the drop down.  




Follow us: 

HTML
<script src="https://apis.google.com/js/platform.js" async defer></script> <div class="g-ytsubscribe" data-channelid="UC4lKt932l0a5Y1FQ8L2cBIg" data-layout="default" data-count="hidden"></div> <!-- Place this tag where you want the widget to render. --> <div class="g-follow" data-annotation="none" data-height="24" data-href="https://plus.google.com/115871184068522638430" data-rel="publisher"></div> <div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.5"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> <div class="fb-follow" data-href="https://www.facebook.com/ohiossdt" data-height="24" data-layout="button" data-show-faces="false" style="vertical-align:top;zoom:1;*display:inline"></div> <a href="https://twitter.com/SSDTAnswers" class="twitter-follow-button" data-show-count="false">Follow @SSDTAnswers</a> <script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');</script>


Useful links:



Panel
borderColor#CECECE
titleColorgraphite
titleBGColor#26abff
titleDid You Know?

New Contract Checklist Available







Panel
borderColor#CECECE
titleColorGRAPHITE
titleBGColor#26abff
titleCustom Direct Deposit NoticesSTRS Advance Changes

STRS has made changes to how part-time employees service credit is calculated.  This is effective for the current STRSAD in July 2020.  There are NO changes for full-time employees.  STRSAD determines whether an employee is full-time or part-time by the drop down box on the 450 Payroll Item record. 

To view the changes online, go to the STRS website:   https://www.strsoh.org/employer/_pdfs/guides/50-380.pdf  

Please click on the link below for a printable doc of the calculation of Part-Time Employees:

STRS service credit calculation.docx

  • Here are the new calculations for Part-time employees:
    • If less than 90 days worked.  Calculate days/180 and calculate actual compensation/$12,000.  The Service Credit is the LESSER of the two calculations.
    • If greater than 89 and less than 120 days worked.  Calculate days/180 and calculate actual compensation/$12,000.   The Service Credit is the LESSER of the two calculations.
    • If greater than 119 days and salary is less than the state minimum of $30,000.  Calculate days/180 and calculate actual compensation/$12,000.  The service Credit is the LESSER of the two calculations.
    • If greater than 119 days and salary is greater than the state minimum of $30,000.  The Service Credit is 1.00 or 100%.






REDESIGN STATUS

129

Sites Live on Redesign

114

Total Wave 5 Sites

17

Participating ITCs

235

Total Districts Participating


Please view the Current List of Districts & Status to see a comprehensive list of school districts along with their ITC, implementation status and the wave they are scheduled to migrate from Classic to Redesign.

The following terminology is used to determine where in the implementation process the entity is currently at:

  • Implementing: The ITC is running test imports and balancing reports on the entity.  The district and ITC are working to schedule dates to begin dual processing and go live.

  • Paralleling: The entity is inputting all production transactions into both Classic and Redesign.

  • Live: The entity is using Redesign for production processing; no parallel processing is being performed;  Classic is available in 'read-only' mode.


Panel
borderColor#CECECE
titleColorgraphite
titleBGColor#26abff
titleDid You Know?

SSDT Session at OASBO