Description of the formulas that are used to produce the information on the Payroll 941 Worksheet in Microsoft Dynamics SL

INTRODUCTION
This document explains what each line of the 941 Quarterly Federal Tax Worksheet (02.750.00) report displays. In addition, it describes what field from the 941 work table is used to display the value and how that field is calculated. This process can potentially print up to three separate reports. The following three reports are described in this article:
  • Employer’s 941 Quarterly Federal Tax Worksheet (02750.rpt)
  • 941 Supplemental Report (02751.rpt)
  • Employer’s Quarterly Federal Tax Return Schedule B (02752.rpt)
Note References are made to fields such as QTDEarndedXX and QtdRptEarnSubjDedXX. In this case, XX is just a placeholder for one of the following four values, depending on what quarter the 941 is being run:
  • Quarter 1 = QTDEarnded00 and QtdRptEarnSubjDed00
  • Quarter 2 = QTDEarnded01 and QtdRptEarnSubjDed02
  • Quarter 3 = QTDEarnded02 and QtdRptEarnSubjDed03
  • Quarter 4 = QTDEarnded03 and QtdRptEarnSubjDed04
More information

Employer’s 941 Quarterly Federal Tax Worksheet (02750.rpt)

Line 1 – Number of Employees

Description: Shows the number of employees with earnings in the quarter.

Stored In: Wrk941R.NbrOfEmployees

Calculated By: Check the QTDEarnDedXX field in the Earnded record for the earnings types to see whether it is greater than 0 (zero) for each employee.

Line 2 – Wages, tips, and other compensation

Description: Total amount of quarterly earnings subject to federal deductions.

Stored In: Wrk941R.TotSubjWithHold

Calculated By:
  1. Add up the earnings from the QTDEarndedXX field in the Earnded table for the following earnings types:
    1. Regular (earntype.ettype=R)
    2. Benefit Usage (earntype.ettype=B)
    3. Reported Tips (earntype.ettype=T)
    4. Net Check (earntype.ettype=G)
  2. Add in Non-Wage earnings if there is a employee-paid federal deduction that is attached to the earnings type:
    1. Earntype.ettype=N
    2. Deduction.dedtype=F and deduction.empleeded=1
  3. Subtract off the QTD pension deduction amounts (earnded.QTDEarndedXX) regardless of what earnings type they are attached to or whether they are set up as pre-tax deductions:
    1. Earnded.earndedtype=C
    2. Earnded.edtype=D

Line 3 – Total Income tax withheld

Description: Shows the total amount withheld from employees for federal taxes.

Stored In: Wrk941R.TotFedWithHeld

Calculated By: Sum the QTDEarndedXX field for all Earnded records where earnded.edtype = D, earnded.earndedtype = F, and deduction.empleeded = 1.

Line 5a – Taxable Soc. Sec. wages

Description: Shows the total wages subject to social security, the social security tax rate, and the social security tax amount. Number is based on Employee Paid portion of FICA.

Stored In:
  • Wages: Wrk941R.TotSSWaes
  • Rate: Wrk941R.TotSSTaxRate * 100
  • Tax: Wrk941R.TotSSWTax
Wages Calculated By:
  1. Add up the earnings subject to the FICA deduction (employee paid). Sum the QtdRptEarnSubjDedXX field in Earnded where earnded.edtype=D, earnded.eandedtype=I, deduction.empleeded=1, and deduction.boxnbr<>6.
  2. Add in any Regular, Reported Tips, or Net Check earnings types that have NO deductions attached (deductions grid is blank in Earnings Type maintenance). Sum the QtdEarnDedXX field in Earnded where edtype=E, earntype.ettype in (‘R’,’T’,’G’), and valearnded has no records for this earnings type.
  3. Subtract off earnings from Reported Tips. This is calculated by summing the QTDEarndedXX field for all Earnded records where earnded.edtype = E and EarnType.ETType = “T”.
  4. Check whether the earnings exceed the limit, and adjust if it is necessary. To do this, follow these steps:
    1. Add up the YTDRptEarnSubjDed value from Earnded by using the same criteria as steps 1 through 3 in this section.
    2. If the YTD wages are greater than the Social Security Wage Limit value that is entered on the 941 screen, you must adjust the QTD Soc. Sec. wages.
    3. Adjusted wages = QTD SS wages + SS wage Limit – YTD SS wages. If the number is negative, print $0 instead.
Rate Calculated By: Adds the Employer Social Security Percent and the Employee Social Security Percent values that are entered on the 941 Quarterly Federal Tax Worksheet screen. Then, it divides this number by 100.

Tax Calculated By: Multiples the Wages by the Rate and rounds to the currency decimal places.

Line 5b – Taxable Soc. Sec. tips

Description: Shows the total wages from Reported Tips earnings types subject to social security, the social security tax rate, and the social security tax amount. Number is based on Employee Paid portion of FICA.

Stored In:
  • Wages: Wrk941R.TotSSTips
  • Rate: Wrk941R.TotSSTaxRate * 100
  • Tax: Wrk941R.TotSSTtax
Wages Calculated By:
  1. Sum the QTDEarndedXX field for all Earnded records where earnded.edtype = E and EarnType.ETType = “T”.
  2. Check whether the earnings exceed the limit, and adjust if it is necessary. To do this, follow these steps:
  1. If Taxable Soc. Sec. wages from Line 5a exceeded the limit, then no adjustment is made to the Soc Sec Tips number.
  2. If Taxable Soc. Sec. wages from Line 5a did not exceed the limit, then add the YTD Taxable Soc. Sec. wages plus the YTD Taxable Soc. Sec. tips, and see whether that exceeds the limit.
  3. If the YTD SS Tips + YTD SS Wages are greater than the Social Security Wage Limit value entered on the 941 screen, you must adjust the QTD Soc. Sec. Tips.
  4. Adjusted Tips = QTD SS Tips + SS wage Limit – YTD SS Tips – YTD SS Wages. If the number is negative, print $0 instead.
Rate Calculated By: Adds the Employer Social Security Percent and the Employee Social Security Percent values that are entered on the 941 Quarterly Federal Tax Worksheet screen. Then, it divides this number by 100.

Tax Calculated By: Multiples the Wages by the Rate and rounds to the currency decimal places.

Line 5c – Taxable Medicare wages and tips

Description: Shows the total wages subject to Medicare, the medicare tax rate, and the medicare tax amount. Number is based on Employee Paid portion of FICA-Medicare.

Stored In:
  • Wages: Wrk941R.TotMedWagesTips
  • Rate: Wrk941R.TotMedRate * 100
  • Tax: Wrk941R.TotMedtax
Wages Calculated By:
  1. Add up the earnings subject to the FICA Medicare deduction (employee paid). Sum the QtdRptEarnSubjDedXX field in Earnded, where earnded.edtype=D, earnded.eandedtype=I, deduction.empleeded=1, and deduction.boxnbr=6.
  2. Add in any Regular, Reported Tips, or Net Check earnings types that have NO deductions attached (deductions grid is blank in Earnings Type maintenance). Sum the QtdEarnDedXX field in Earnded, where edtype=E, earntype.ettype in (‘R’,’T’,’G’), and valearnded has no records for this earnings type.
  3. Check whether the earnings exceed the limit, and adjust if it is necessary.
Rate Calculated By: Adds the Employer Medicare Percent and the Employee Medicare Percent values that are entered on the 941 Quarterly Federal Tax Worksheet screen. Then, it divides this number by 100.

Tax Calculated By: Multiples the Wages by the Rate and rounds to the currency decimal places.

Line 5d – Total Soc. Sec. and Medicare taxes

Description: Total of Social Security and Medicare taxes.

Stored In: Wrk941R.TotFICATaxes

Calculated By: Add total of taxes from line 5a, 5b, and 5c. Then, subtract off any amounts from checks in this quarter that are dated in a different quarter (This should never occur. See the "941 Supplemental Report (02751.rpt)" section for more information).

Line 6 – Total taxes before adjustments

Description: Total of federal taxes withheld from the employees plus the total Social Security and Medicare taxes (both employee and employer).

Stored In: {Wrk941R.TotFedWithHeld} + {Wrk941R.TotFICATaxes}

Calculated By: Add total from Line 3 plus Line 5d.

Line 9 – Advance earned income credit (EIC) payments made to employees

Description: Shows the total amount of Earned Income Payments earnings that are paid to employees in the quarter.

Stored In: Wrk941R.AdvEICPayments

Calculated By: Sum the Earnded.QTDEearnDedXX value for any Earnded Income Payments earnings-type records. Earnded.EDType=E, EarnType.ETType=E.

941 Supplemental Report (02751.rpt)

Description: This is a separate report that will automatically print if the process finds PayDate records where the CalYr field matches the Report Year, the CalQtr field matches the Report Quarter, and the CheckDate is for a date outside that quarter and year. This should never occur in the current versions of Microsoft Dynamics SL. It would have only occurred in Solomon III.
Check Date: Printed from Wrk941S.ChkDate, which is populated from the PayDate.ChkDate field.
FIT Withholding (line 4): Printed from Wrk941S.FedWithhold, which is populated from the PayDate.EmpleFederal field.
FICA Taxes (line 9): Printed from Wrk941S.FicaWithhold, which is populated from PayDate.EmpleFICA + PayDate.EmplrFICA fields.

Employer’s Quarterly Federal Tax Return Schedule B (02752.rpt)

Description: Breaks down the total tax liability for the quarter by month and day.

Stored In: Wrk941R table

Calculated By:
  1. Scans the PayDate table for records in the current CalQtr and CalYr. For each record, it adds the Employee’s Federal tax, the Employee’s FICA amount (includes both Social Security and Medicare), and the Employer’s FICA amount. Then, it updates the appropriate Daily and Monthly buckets based on the CheckDate.Tax Liability = PayDate.EmpleFederal + PayDate.EmpleFICA + PayDate.EmplrFICA.
  2. Then, it scans for current quarter non-voided checks (PRDOC) that have Advanced EIC Payments earnings (earntype.ettype=E), and it subtracts the Advanced EIC amount from the tax liability for that day's bucket (based on check date). The amount comes from PRTRAN.Tranamt.
120569, 866547, 84179, 941, Schedule B, Quarter, Close, PR
Properties

Article ID: 845021 - Last Review: 05/27/2016 20:31:00 - Revision: 5.0

Microsoft Dynamics SL 2011, Microsoft Dynamics SL 7.0, Microsoft Dynamics SL 6.5

  • kbnosurvey kbsurveynew kbexpertiseinter kbexpertisebeginner kbmbsmigrate KB845021
Feedback