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

USPS-R Calendar Year End Preparation - Life Insurance Premiums Over $50,000 (NC1 Reporting)

Life Insurance Premium (Formerly-NC1) The Life Insurance Premium pay type is used  when processing  the taxable amount of life insurance premiums on W2's for coverage in excess of $50,000.  Any Life insurance amounts are taxed by Medicare and Social Security, as applicable. No Federal, state, or OSDI tax is deducted from this amount during the payroll process . The USPS-R software provides the ability to withhold city tax on non-cash earnings. This can be activated by checking the "Tax Non-Cash Earn" box on the city tax record in the Core>Payroll Item Configuration option.  *Note:  Please verify with your specific municipalities for their requirements.

Click here for IRS link for reporting Group-Term Life Insurance.  In “Publication 15-B”, click on the Group-Term  Life Insurance Coverage section.  You will find the tables for rates on Page 14 of this documentation.

USPS-R gives you options on how you can report Taxable Amounts of Life Insurance Premiums over $50,000 for the calendar year.  The best option is reporting these amounts before the final payment for the employee for the calendar year or at time of termination of employment through the Payroll-Current or Payroll-Future area using the Pay Type of “Life Insurance Premium”.

If the Life Insurance Premium Pay Type was NOT USED prior to the last pay of the calendar year, you may use the Core>Adjustments area to add the Life insurance Premium amount for W2 reporting purposes.  Under  Core>Adjustments you would  click Create, find the Employee, choose the Payroll Item- 001 Federal Tax,  choose the Type of “Life Insurance” enter in the Transaction Date and enter the Amount to show correctly on the W2 form and to ensure that the Quarter balances.  When the record is saved this amount will automatically adjust the Federal, State, OSDI,  City  and Medicare total and taxable gross amounts for  W2 reporting purposes.  No manual adjustments are needed for the Gross and Taxable Gross amounts.  Medicare withholding on this amount MUST be paid.  If the Medicare withholding is paid by the employee, employer or employee and employer, adjustments will be made using Core>Adjustments/Type-692/693 Medicare Tax to the Amount Withheld and also the Board Amount of Payroll Item. If Medicare is fully board paid (Pickup), then the total Adjustment should be made to the Board Amount of Payroll Item.  *Note: The city is only adjusted when the Payroll Item Configuration setup for the city payroll item is checked to Tax Non-Cash Earnings. 

Five Year Forecast

The Five-Year Forecast is included in Redesign. The USASFF report from classic can be found under REPORTS or the HOME page.  It is called SSDT Financial Report by Line Number.reporting period is open through November 30th of this year in EMIS-R.  Five Year Forecast extracts and reports are available in USAS-R. 

Extracts:

The user-friendly Five-Year Forecast that districts used in Classic extracts can be found under the PERIODIC dropdown in Redesign. (Insert Screenshot)The UI Grid is showing Periodic>Five Year Forecast .  The grid displays the Forecast Line number, the three years actual revenues and expenditures, the average percentage of change and in the last column the current fiscal year estimates. (Insert Screenshot)By  

Image Added

• When selecting the CSV

• option,

• the grid will be pulled into an EXCEL spreadsheet for district use.  This option is similar to the CSV file generated in Classic's USASFF program and can be used as is or uploaded into another forecast software.
• When selecting the Excel option, it automatically uploads the forecast data into SSDT's Five Year Forecast spreadsheet.  There are several tabs in SSDT's forecast spreadsheet, 
  • The Parameters tab will appear when opening the spreadsheet and will pre-fill the district info and Fiscal year.   
  • Click on the Data to view the data pulled from USAS-R.   
  • The Forecast

• • tab will pull the amounts from the data tab into an easy-to-read spreadsheet allowing you to enter the forecasted amount. Once complete, you can save the Forecast tab in CSV format and upload it into EMISFFE.
  • The SSDT Forecast spreadsheet also include a tabs with Instructions on how to use it as well as additional features under the Extras, Summary View, Percentage View and

• • Charts tabs.

Image Added

Reports

The SSDT Financial Report by Forecast Line Number is similar to the USASFF report from Classic can be found under Reports>Report Manager or the Home page. 

The district can compare the current fiscal year estimates with actual figures by using the Spending Plan reports which generate in a forecast format listing each monthly actual amount for each line number and a FYTD total.

Instructions for EMIS submission can be found on the Instructions Tab and by contacting your ITC.