MPI_0501 FICA Tip Credit Report

This topic contains specific information about the MPI_0501 FICA Tip Credit report. It includes explanations about the Report Properties dialog pertaining to this report.

For more information, see The Report Properties Dialog.

Overview

This report displays the current, year-to-date, tip, and pay information. It also calculates and displays the FICA tip credit.

In this report:

  • The tip figures shown are the totals of all earning codes that have an earning type with the word “Tips” in it.
  • The current pay is calculated by subtracting the total tips from the gross pay.
  • The numbers for gross and hours are taken from the Gross and Hours fields in the Pay History (EPayHist).
  • The FICA rate used is obtained from the tax database based on the date range used for the report.
  • The value of the report’s Min Wage column is calculated using the total hours worked and the value you enter in the Minimum Wage (rate) additional formula. When the report is run for a:
  • Single pay period, the value is accurate
  • Range of dates, the value may not equal the sum of the individual pay periods because of rounding
  • Date range that exceeds 31 days, a warning message is displayed at the bottom of each page: “Running this report for date ranges over one month may return inaccurate results.”

You may choose to hide this message by enabling the "Hide Date Warning" additional formula in the report properties.

  • This report includes a Year-to-Date section. Only one year can be displayed in this section, and the year must be the same calendar year. If the year of the beginning date does not match the year of the ending date, the report terminates and an error message is printed.

Date Selection

In the Report Properties dialog, click on the Date Selection tab. The system displays the Date Selection page.

As explained in Date Selection, you can use Override Dates  to select specific check date/process number combinations. Millennium® bases most reports on one or the other: the date or the process number.

This report is based on the check date.

This report uses company-style default date ranges, which are:

  • Most Recent Pay Period
  • Current Month
  • Current Quarter
  • Year-to-Date
  • Override Dates
  • Quarters 1–4

Data Selection

In the Report Properties dialog, click on the Data Selection tab. The system displays the Data Selection page.

As explained in Data Selection, you can use this page to include company filters to narrow down the selected data for this report. If you want to create a filter, design it to access the following database tables:

  • CInfo—Company information.
  • EInfo—Employee information.

Subtotals/Breaks

In the Report Properties dialog, click on the Subtotals/Breaks tab. The system displays the Subtotals/Breaks page:

Figure 2-382: Subtotals/Breaks page

If you choose to customize groupings, you can select up to six levels.

The default Sort Order is DeptName. Available sorts include:

  • Dept Name
  • Dept ID
  • Name
  • ID

This report allows six categories in the Groups column. If you select Custom Sort Order , the groups in Table 1 are available:

Table 2-353: Available Groups

Employee ID

Workers’ Comp Code

Employee Tax Form

Employee Name

Employee Clock

Employee Union

Employee City

Employee Job

Employee User1

Employee State

Employee Position

Employee User2

Employee Zip

Employee Title

Employee User3

Employee SSN

Employee EEOCClosed Equal Employment Opportunity Commission Code

Employee User4

Employee SSN Mask

Employee Auto Pay

Employee User5

Employee SSN Last4

Employee Job

Employee User6

CC1

Employee Mail Stop

Employee User7

CC2

Supervisor

Employee User8

CC3

Employee Pay Frequency

Employment Type

CC4

Employee Pay Group

Full Department

CC5

Employee Position

Service Bureau

Company

Employee Status

 

This report allows four categories in the Sorts column. If you select Custom Sort Order , the sorts in Table 2 are available:

Table 2-354: Available Sorts

Employee SSN

Employment Type

Employee Position

Employee SSN Mask

Pay Group

Employee Title

Company

Hire Date

Employee EEO Class

Employee ID

Adjusted Seniority Date

Employee Mail Stop

Employee Name

Term Date

Employee Tax Form

Employee City

CC1

Employee Union

Employee State

CC2

Employee Supervisor

Employee Zip

CC3

Employee User1

Employee County

CC4

Employee User2

Employee Country

CC5

Employee User3

Employee SSN

Full Department

Employee User4

Employee SSN Mask

Workers’ Comp Code

Employee User5

Employee SSN Last4

Employee Clock Number

Employee User6

Employee Gender

Employee Pay Frequency

Employee User7

Employee Status

Employee Job

Employee User8

Additional Formulas

In the Report Properties dialog, click on the Additional Formulas tab. The system displays the Additional Formulas page:

Figure 2-383: DQ-16223 Additional Formulas page

Explanations of the additional formulas are as follows:

Minimum Wage

Enter the minimum wage that will be used to calculate the value of the report’s Min Wage column in the report. The calculation is:

  [value of Hours column] x [value of Minimum Wage formula]

Employee Line 1–2

Use these drop-down lists to add the first and second lines, respectively, of employee information to the report.

The valid entries include:

Company

Employee SSN Mask

CC5

Employee Tax Form

Employee ID

Employee SSN Last4

Full Department

Employee Union

Last Name

Employee Birth Date

Workers’ Comp Code

Employee Supervisor

First Name

Employee Gender

Employee Clock Number

Employee User 1

Middle Name

Employee Status

Employee Pay Frequency

Employee User 2

Full Name

Employment Type

Employee Job

Employee User 3

Employee Address 1

Pay Group

Employee Home Phone

Employee User 4

Employee Address 2

Hire Date

Employee Position

Employee User 5

Employee City

Adjusted Seniority Date

Employee Title

Employee User 6

Employee State

Term Date

Employee EEO Class

Employee User 7

Employee Zip

CC1

Employee Work Phone

Employee User 8

Employee County

CC2

Employee Extension

 

Employee Country

CC3

Employee Mail Stop

 

Employee SSN

CC4

Employee EMail

 
Show Tipped Only

Put a check in this check box to show employees with YTD tips only.

Hide Date Warning

Put a check in this check box to the warning that otherwise appears when the report is run over an extended date range.