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.
Use these radio buttons to sort the report. With either selection, both the employee name and employee ID will display on the report.
Select this radio button to sort by the employee's displayed name, as set up in the Basic Employee Info screen in Costpoint Employee.
Select this radio button to sort by the employee's ID.
Use this group box to select the taxable entity and the date range for which you wish to print the report.
Enter, or use Lookup to select, the taxable entity you wish to print on the report. This is a required field.
Enter the starting check date you want to be included on this report.
Enter the ending check date you want to be included on this report.
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 |