Federal Tax Worksheet
Access this report using Reports>Payroll>Payroll Tax Worksheets>Federal. It is only available with the Payroll module; it is not available for Payroll Link users. |
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.
Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.
- Current Transaction Dates are required to specify the date range for the data included in the report.
Use this tab to determine what data to include in the report and to define the report layout.
- By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
- By selecting Available Columns, the data that appears in the body of the report is determined.
Column |
Description |
Tax Type |
The tax type code (Maintain>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 using the Maintain>Payroll>Employee Information form. The report shows the code's name, such as Admin or Parttime. |
Class |
The employee's job class that was assigned using the Maintain>Payroll>Employee Information>Job and Pay 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 employee's 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 Maintain>Payroll>Employee Information. These rights are granted by the Administrator using Security>Set Up Organization Menus form. |
Tax Title |
The title of the tax type—Federal Income Tax, Social Security Tax, Medicare, and Federal Unemployment Tax (Maintain>Payroll>Federal Taxes). |
Employee Tax PTD |
The period-to-date employee tax. This tax is based on the Current Transaction Dates entered on the Setup tab. |
Employer Tax PTD |
The period-to-date employer tax. This tax is based on the Current Transaction Dates entered on the Setup tab. |
Subject Earnings PTD |
The period-to-date subject earnings. This amount is based on the Current Transaction Dates entered on the Setup tab. |
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. |
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 this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.
Use this tab to change the font and page setup for a report.
Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.