Federal Tax Worksheet

To access this report, go to Reports>Payroll>Tax Worksheets>Federal Tax Worksheet

Use this report to view summarized federal tax employee amounts, employer amounts, subject and gross taxable earnings in Period-to-Date (PTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) columns.

Tip: If you're not familiar with the MIP Cloud Report Builder interface, see Report Builder for an introduction.

Current Transaction dates are required to specify the date range for data included in the report. Enter these dates on the Setup tab.

 

The following fields are available to include in the report:

Tax Type

The tax type code (see Payroll Federal Taxes). A list of available codes are as follows:

FIT (Federal Income Tax)

SS (Social Security Tax)

MC (Medicare)

FUTA (Federal Unemployment Tax)

Processing Group

This is the processing group code assigned to the employee. The report shows the code's name, such as Admin or PartTime.

Class

The employee's job class that was assigned in Employee Information on the "Job and Pay Rate" tab.

Employee ID

The employee's ID.

Employee Last Name

The employee's last name.
Employee First Name The employee's first name.

First, MI Name

The employee's first name and middle initial.

Employee Name

The employee name associated with the Employee ID.

Employee Status

The status of the employee - Active, Inactive, or Terminated.

Social Security Number

The social security number. Note that only the last four digits of the number display.

  • To view the entire social security number, you must have been granted Display Sensitive Data rights for Payroll>System Setup>Employee Information. These rights are granted by the Administrator by going to Administration>Users>Manage Users, selecting the "Payroll" module, scrolling down to the "System Setup" section and selecting the checkbox under "Display Sensitive Data".

Tax Title

The title of the tax type—Federal Income Tax, Social Security Tax, Medicare, and Federal Unemployment Tax.

Employee Tax PTD

The period-to-date employee tax. This tax is based on the Current Transaction Dates entered on the Setup tab of the report.

Employer Tax PTD

The period-to-date employer tax. This tax is based on the Current Transaction Dates entered on the Setup tab of the report.

Subject Earnings PTD

The period-to-date subject earnings. This amount is based on the Current Transaction Dates entered on the Setup tab of the report.

Gross Taxable Earnings PTD

The period-to-date gross subject earnings. This amount is based on the Current Transaction Dates entered on the Setup tab of the report.

Employee Tax QTD

The quarter-to-date employee tax. This tax is based on the four quarters in a calendar year.

Employer Tax QTD

The quarter-to-date employer tax. This tax is based on the four quarters in a calendar year.

Subject Earnings QTD

The quarter-to-date subject earnings. This amount is based on the four quarters in a calendar year.

Gross Taxable Earnings QTD

The quarter-to-date gross subject earnings. This amount is based on the four quarters in a calendar year.

Employee Tax YTD

The year-to-date employee tax based on the current calendar year.

Employer Tax YTD

The year-to-date employer tax based on the current calendar year.

Subject Earnings YTD

The year-to-date subject earnings based on the current calendar year.

Gross Taxable Earnings YTD

The year-to-date gross subject earnings based on the current calendar year.

 

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, to implement security features, and more.

  • Select "Summarize Amounts" to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together

  • You can secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.

  • Select the "Year End Adjustments" option to include year end adjustments on the report. This entry type was designated during transaction entry.

  • Select the "Replace total debits and credits with Balance" option to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.

  • Select the "Total by Payroll" option to total processing group information, such as the hours taken and the hours accrued for the employees.

  • Select the "Employer Amounts" option if you entered employer amounts and would like to print them on the report.

Use the Layout tab to change the font and page setup for a report.