50-37 Employee Reporting

The school must report wages per employee and amounts paid per vendor.  This is completed through 50-37 reporting.

  • Report: 50-37
  • Timing: Mid November
  • Receives Request/Responsible for Delivery: Business Office
  • Responsible for Pulling Data: Glenbard Technology
  1. Click Employee > Data Mining
  2. Select the 50-37 Employee Reporting report.
  3. Click the Edit button.
  4. Click the Ranges button and then Edit.
  5. Scroll down to the FTD Calendar Year field.
  6. For the Low/High Ranges enter the first year in the fiscal year for both fields. (i.e. Put 2014 in both the high and low for the 2014-2015 fiscal year.)
  7. Click the Save button.
  8. Click the Excel button.
  9. Use a listing of paycode categories from HR to determine which pay records are licensed versus non-licensed.
  10. Run a two pivots on that information: licensed and non-licensed.
  11. Copy the results of the pivots into a new tab and use a formula like this one to assign ranges to each employees licensed and non-licensed pays:  =IF(B2<25000,”Under $25,000″,IF(B2<40001,”Between $25,001 – $40,000″,IF(B2<60001,”Between $40,001 – $60,000″,IF(B2<90001,”Between $60,001 

You may also like...