/
Quarter Report

Quarter Report

If an employee earns over $200,000, the employee pays more tax on wages above $200,000, but the employer does not. Under section 941, QTD Employees' Medicare Contributions exceed QTD Employer's Medicare Contributions.

Quarter report

The Quarter Report program generates quarter-to-date figures for employees and provides data to complete IRS Form 941 Quarterly statement.

The Save and Recall option 

, lets users create and save reports 
 for different runs per report option.  The Default option is the original SSDT report; Most Recent is the last report run by the user.  To delete a report, click 
. Default reports cannot be deleted. 

Medicare pickup 

To update an employee's Employer Pickup Taxable Gross, use Core>Adjustment>Applicable Gross (Taxable Gross)

Medicare Only - ‘Apply to Employer Pickup’ (Affects Quarter Report only)

Quarter Report - Updates Taxable Gross

  • Employee’s 692 Medicare Pickup *TD Taxable Gross

  • Deductions Items Summary 692 - Employer Pickup *TD Taxable

  • Form 941 - Line 5C) QTD Medicare Taxable Wages

Quarter report per employee

Quarter Report now shows Employer Pickup or Employee Contribution for Medicare per employee:

Quarter Report Deduction Items Summary

The Deduction Items Summary now shows the breakdown of the 692 Employee Contribution and Employer Pickup for Medicare

Quarter Report Form 941

Form 941 totals show QTD Employees' and QTD Employer's Medicare Contributions with Pickup amount added:

$145,901.19 + $1,284.22 (Picked up by board) = $147,185.41

Totals summary - difference in adjusted gross

The new info message 'Calculated Adjusted Gross Different than Total Adjusted Gross From Fw the breakdown of the 692 Employee Contribution and Employer Pickup for Medicare

Quarter Report Form 941

Form 941 totals will show QTD Employees' and QTD Employer's Medicare Contributions with the Pickup amount added in:

$145,901.19 + $1,284.22 (Picked up by board) = $147,185.41

Totals Summary - Difference in Adjusted Gross

Calculated Adjusted Gross = Total Gross - Total Annuities + Non-Cash Earnings
Total Adjusted Gross is taken from the totals on employees' Federal tax records

A difference could be from Adjustment Journals and/or Life Insurance and Taxable Benefits added AFTER last payroll using Adjustments

Look for Payroll Items Start and Stop dates that have been changed to the New Year before completing Quarter report balancing.  Changing dates too soon, the quarter report will then ignore those payroll items paid in the previous year.

If refunding a payroll item, make sure the Payroll Item Stop Date is not before the refund. This would cause for Quarter report to ignore the refund.

The Difference in Adjusted Gross and CALCULATED ADJUSTED GROSS DIFFERENT THAN TOTAL ADJUSTED GROSS FROM FEDERAL RECORDS *** lines will not appear if there is no difference in Adjusted Gross.

Deceased Employees adjustments to Total Gross to 001 Federal:

  • A warning on Quarter Report will occur stating ***CALCULATED ADJUSTED GROSS DIFFERENT THAN TOTAL ADJUSTED GROSS FROM FEDERAL RECORDS***

If Difference In Adjusted Gross, look for any Life Insurance adjustments entered AFTER last payroll of the year. 

Deceased Employee

  1. The total gross on Quarter Report will be short compared to the total gross from the USAS checks processed for the payrolls, by the gross paid to the estate.

    1. A Warning will occur: CALCULATED ADJUSTED GROSS DIFFERENT THAN TOTAL ADJUSTED GROSS FROM FEDERAL RECORDS 

    2. Quarter Report will include this amount in the Total Gross but not in Applicable (Taxable) amount

    3. W2 Report will not include this amount since no Federal tax was withheld

    4. Earnings Register will include this in the employee's Total Gross 

    5. Quarter Report and W2 report totals will not match

    6. Quarter Report pulls from Pay History and W2 pulls from Payroll items

If a redesign check was created in one quarter and voided in another, the void will still process in the quarter that it was created.  A 941X for the quarter the check was originally included in, should be filed.

Sample Quarter Report

Deductions Items Summary

Deduction Name uses the payroll Item configuration abbreviation.  If the payroll item configuration is blank, it will use the W2 abbreviation. 

DED column uses the Payroll Item Configuration code.

QTD Total used Payroll History and any Adjustments

YTD Total used Payroll History and any Adjustments

FTD Total used Payroll History and any Adjustments

QTD Taxable used Payroll History and any Adjustments

YTD Taxable used Payroll History and any Adjustments

Totals Summary Breakdown

QTD and YTD Total

Total Gross = Total gross of each Position paid (does not include NC payments, add in using the Non-Cash Earnings amount)

Total Annuities = Total Payroll Items and adjustments Journals

Non-Cash Earnings = Life Insurance (NC1)

Total Adjusted Gross = Sum of Adjusted Gross Totals of historical federal pay items 

Adjusted Gross Total = Sum of Applicable Gross type Journals + Sum of Applicable Gross of historical pay items

Calculated Adjusted Gross = Total Gross - Total Annuities + Non-Cash Earnings

Total Employees - Total employees paid in the Fiscal Year

  • Using the second quarter report would give districts the total employees paid in the fiscal year since it is the last quarter of the fiscal year.

Total Employee Count Per 941 Instructions - This total is the total employee count per 941 instructions. This count is determined by adding all the employees who have a pay from the last month of the quarter covering the 12th of the month. This count is what is needed to fill out line 1 on the 941 form. However, if there is a pay lag and it causes the pay that covers this period to not be paid until the next quarter, this count will be zero on QRTRPT.