Federal/State/Local Tax Report
Use the Federal/State/Local Tax Report page to generate detail or summary reports of federal, state, or local tax information for paychecks found in the Payroll Check History. This report allows users to analyze tax withholdings by employee or by check for a specified date range. For Ohio databases with multiple local taxes enabled, the report provides an additional breakdown by local tax type.
Menu path
From the Human Resources menu, select Reports. From the Payroll menu, select Federal/State/Local Tax Report.
On the Federal/State/Local Tax Report page, refer to the Field descriptions and select the report criteria.
Select Accept.
Select a Destination for the report file:
Select File to create the report in .rpt format. You can change the default file name.
The default file names are:Federal Tax Report: fedtax.rpt
State Tax Report: statetax.rpt
Local Tax Report: localtax.rpt
Select Screen to download the report in .pdf format.
The default file names are:Federal Tax Report: fedtax_<#####>.pdf
State Tax Report: statetax_<#####>.pdf
Local Tax Report: localtax_<#####>.pdf
Select Excel to download the report in .xlsx format. Select the required Excel Options.
The default file names are:Federal Tax Report: fedtaxrpt<####_#####>.xlsx
State Tax Report: statetaxrpt<####_#####>.xlsx
Local Tax Report: localtaxrpt<####_#####>.xlsx
Select OK.
Download the .rpt file from the View Files page.
Save the .pdf or .xlsx file.
For more information about the Print option, refer to Print Reports.
For detailed information about the report’s file layout, refer to Federal/State/Local Tax Report - File Layouts and Data Mapping.
Field descriptions
The Federal/State/Local Tax Report page consists of the following sections:
Tax Report Choice section
The following table describes the fields in the Tax Report Choice section of the Federal/State/Local Tax Report page.
Field | Description |
|---|---|
Federal Tax Report | This option generates a report on federal income tax withholdings, including the total for checks issued during the date range entered in the Selection Criteria section. |
State Tax Report | This option generates a report on state income tax withholdings. The state subtotals by state and report total are for checks issued during the date range entered in the Selection Criteria section. |
Local Tax Report | This option generates a report on local/municipal tax withholdings (includes multi-local tax breakdown for Ohio). The subtotals by locality and report total are for checks issued during the date range entered in the Selection Criteria section. Local tax withholdings are only calculated for employees whose local tax configuration passes precalculation validation. If an employee's Filing Status is missing or the Locality/Pay Frequency/Filing Status combination is not found in the local tax table, no local tax is withheld, and the employee may not appear on this report. Refer to Payroll Precalculation validation for details. |
Check Detail or Employee Detail section
The following table describes the fields in the Check Detail or Employee Detail section of the Federal/State/Local Tax Report page.
Field | Description |
|---|---|
Report by Employee | This option generates a summary for the selected tax report, including the employee number, employee name, taxable wages, and taxes paid. Wages and taxes are the total of all checks for an employee within the entered date range. |
Report by Employee w/Current Address | This option generates a summary report for the selected tax report, including employee number, employee name, taxable wages, taxes paid, and address. The taxable wages and taxes paid are the total of all checks for an employee within the entered date range. |
Report by Employee/Check | This option generates a detail report for the selected tax report, including employee number, employee name, check number, taxable wages, taxes paid, and date issued. The taxable wages and taxes paid are listed for each check issued to an employee within the entered date range. |
Issued and/or Voided Checks section
The following table describes the fields in the Issued and/or Voided Checks section of the Federal/State/Local Tax Report page.
Field | Description |
|---|---|
Issued Checks Only | This option generates a report of the taxable wages and taxes paid for regular and manual checks. |
Issued Checks and Voided Checks | This option generates a report of the taxable wages and taxes paid for regular, manual, and voided checks. |
Voided Checks Only | This option generates a report of the taxable wages and taxes paid for checks that were voided. |
Selection Criteria section
The following table describes the fields in the Selection Criteria section of the Federal/State/Local Tax Report page.
Field | Description |
|---|---|
Start Date | The beginning check issue date for the report period. |
Stop Date | The ending check issue date for the report period. |