PRINT SOC SEC AND MED RECONCILIATION RPT

Use this screen to print a reconciliation report listing for each employee's paycheck within the selected date range, all employees' Social Security and Medicare eligible wages, the Social Security and Medicare liability on the Social Security and Medicare eligible wages, Social Security and Medicare Withheld, and any Social Security and Medicare differences. If a difference is printed for any employee, you should investigate it and make adjustments, if required. Some normal rounding differences can be expected, up to $.01 per paycheck per employee.

Print this report after each payroll is posted, whenever the social security and/or Medicare "Computed Employee's Withholding" and "Employee's Withholding from Earnings" on the Federal Quarterly Payroll Tax Report do not agree, and as part of the Close Payroll Year process.

Sort

Use these radio buttons to sort the report. With either selection, both the employee name and employee ID will display on the report.

Employee Name

Select this radio button to sort by the employee's displayed name, as set up in the Basic Employee Info screen in Costpoint Employee.

Employee ID

Select this radio button to sort by the employee's ID.

Select

Use this group box to select the taxable entity and the date range for which you wish to print the report.

Taxable Entity

Enter, or use Lookup to select, the taxable entity you wish to print on the report. This is a required field.

Date Range

From

Enter the starting check date you want to be included on this report.

To  

Enter the ending check date you want to be included on this report.

Note:  Both the From date and the To date must have the same year. Also, the To date must be later than the From date.

Report Sources

Report Columns

Column Source

Empl ID

EMPL_ID from EMPL_EARNINGS

Name

LAST_FIRST_NAME from EMPL

Soc Sec Eligible

SS_TXBL_AMT from EMPL_EARNINGS

Soc Sec Liability

EMPL_EARNINGS.SS_TXBL_AMT   

Soc Sec Employee Percent

FED_TAX_INFO.SS_EMPL_RT

Soc Sec Withheld

SS_WH_AMT from EMPL_EARNINGS

Soc Sec Difference

Soc Sec Withheld - Soc Sec Liability

Medicare Eligible

MDCR_TXBL_AMT from EMPL_EARNINGS

Medicare Liability

EMPL_EARNINGS.MDCR_TXBL_AMT   

Medicare Employee Percent

FED_TAX_INFO.MEDICR_EMPL_RT

Medicare Withheld

MEDICR _WH_AMT from EMPL_EARNINGS

Medicare Difference

Med Withheld - Med Liability