{"id":1232,"date":"2014-11-17T16:08:13","date_gmt":"2014-11-17T16:08:13","guid":{"rendered":"http:\/\/psws.glenbard.org\/index.php\/2014\/11\/17\/50-37-employee-reporting\/"},"modified":"2021-10-14T08:49:19","modified_gmt":"2021-10-14T13:49:19","slug":"50-37-employee-reporting","status":"publish","type":"post","link":"https:\/\/docs.glenbard.org\/index.php\/technology\/skyward\/business-office\/50-37-employee-reporting\/","title":{"rendered":"50-37 Employee Reporting"},"content":{"rendered":"<div class=\"nolwrap\"><p>The school must report wages per employee and amounts paid per vendor. \u00a0This is completed through 50-37 reporting.<!--more--><\/p>\n<ul style=\"list-style-type: square;\">\n<li><strong>Report<\/strong>: 50-37<\/li>\n<li><span style=\"line-height: 1.3em;\"><strong>Timing<\/strong>: Mid November<\/span><\/li>\n<li><span style=\"line-height: 1.3em;\"><strong>Receives Request\/Responsible for Delivery<\/strong>: Business Office<\/span><\/li>\n<li><span style=\"line-height: 1.3em;\"><strong>Responsible for Pulling Data<\/strong>: Glenbard Technology<\/span><\/li>\n<\/ul>\n<ol>\n<li><strong>State Reporting<\/strong> &gt; Reports &gt; 50-37 Employee Data (Glenbard)<\/li>\n<li>Download the report<\/li>\n<li>Use a listing of paycode categories from HR to determine which pay records are licensed versus non-licensed.<\/li>\n<li>Run a two pivots on that information: licensed and non-licensed.<\/li>\n<li>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: \u00a0<span style=\"font-size: 12.16px; line-height: 1.3em;\">=IF(<\/span><span class=\"s1\" style=\"font-size: 12.16px; line-height: 1.3em;\">B2<\/span><span style=\"font-size: 12.16px; line-height: 1.3em;\">&lt;25000,&#8221;Under $25,000&#8243;,IF<\/span><span class=\"s2\" style=\"font-size: 12.16px; line-height: 1.3em;\">(<\/span><span class=\"s1\" style=\"font-size: 12.16px; line-height: 1.3em;\">B2<\/span><span style=\"font-size: 12.16px; line-height: 1.3em;\">&lt;40001,&#8221;Between $25,001 &#8211; $40,000&#8243;,IF<\/span><span class=\"s3\" style=\"font-size: 12.16px; line-height: 1.3em;\">(<\/span><span class=\"s1\" style=\"font-size: 12.16px; line-height: 1.3em;\">B2<\/span><span style=\"font-size: 12.16px; line-height: 1.3em;\">&lt;60001,&#8221;Between $40,001 &#8211; $60,000&#8243;,IF<\/span><span class=\"s4\" style=\"font-size: 12.16px; line-height: 1.3em;\">(<\/span><span class=\"s1\" style=\"font-size: 12.16px; line-height: 1.3em;\">B2<\/span><span style=\"font-size: 12.16px; line-height: 1.3em;\">&lt;90001,&#8221;Between $60,001\u00a0<\/span><\/li>\n<\/ol>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The school must report wages per employee and amounts paid [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17],"tags":[592,591],"class_list":["post-1232","post","type-post","status-publish","format-standard","hentry","category-business-office","tag-50-37","tag-annual_reporting"],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/1232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/comments?post=1232"}],"version-history":[{"count":3,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/1232\/revisions"}],"predecessor-version":[{"id":5805,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/1232\/revisions\/5805"}],"wp:attachment":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media?parent=1232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/categories?post=1232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/tags?post=1232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}