Fringe inquiry

unavailable in ajeraCore unless you have the Payroll add-on

Use this inquiry to see all fringe benefits on paychecks for employees.

Using the inquiry

From the > Reports menu, click Standard Inquiries > Payroll > Fringe.

To

Do this

Change the cutoff date

Click the link for it, which appears under the inquiry title, and select the date you want.

See information for an employee

Expand the employee row by clicking the plus sign.

Audience

Accounting staff

Inquiry conditions

The inquiry automatically contains conditions to show only data for fringes from paid checks in the current payroll year. You can always add, change, or delete conditions on an inquiry.

Groups

This inquiry is grouped by Item Description and Employee. You can always group or ungroup columns, as needed.

Standard columns

Column Links to this inquiry Description Date range available

Payroll Year

 

The year the payroll occurs

 

Check Status

 

The status of the paycheck

 

GL Account Description

GL Account

The name of the associated General Ledger account

 

Pay Date

 

The date of the payroll

 

MTD Amount

Check Summary

The month-to-date deductions made to the employee's pay

x

QTD Amount

Check Summary

The quarter-to-date deductions made to the employee's pay

x

YTD Amount

Check Summary

The year-to-date deductions made to the employee's pay

x

Predefined columns

You can add predefined columns to this inquiry. Many columns are available, organized in these categories:

Column Links to this inquiry Description Date range available

Payroll:

Pay Detail Key

 

The database identifier of the pay detail associated with the check

 

Payroll Key

 

The database identifier for the payroll associated with the check

 

Description

 

The name of the tax

 

Payroll Status

 

The status of the payroll

 

Payroll Quarter

 

The quarter the payroll occurs

 

Current Year

 

The current year

 

Payroll Company Key

 

Multi-company only. The database identifier of the company associated with the payroll

 

Payroll Company Name

 

Multi-company only. The name of the company associated with the payroll

 

Paycheck:

Pay Check Key

Check Summary

The database identifier of the paycheck associated with the check

 

Check Number

Check Summary

The number on the paycheck

 

Is Employer

 

Indicates if it is an employer tax

 

Pay Key

 

The database identifier of the pay associated with the check

 

Order

 

The position of the fringe on the check

Example: You may sort the inquiry by order so it mirrors the order of the check.

 

Item Type

 

The type of item on the paycheck

Example: Fringes

 

Item Description

 

The description of the item

Example: 401(k), Employee Loan

 

Accrual Pay Description

 

The description of the accrual pay

Example: Vacation, Sick

 

GL account:

GL Department Key

 

unavailable in ajeraCore unless you have the Departments add-on

The database identifier of the GL department associated with the check

 

GL Department

 

unavailable in ajeraCore unless you have the Departments add-on

The name of the GL department associated with the check

 

GL Account Key

 

The database identifier of the GL account

 

GL Account ID

 

The account ID of the GL account associated with the check

 

GL Account Description

GL Account

The name of the GL account associated with the check

 

Supervisor Key

Employee

The database identifier of the supervisor of the employee associated with the check

 

Supervisor

Employee

The supervisor of the employee associated with the check

 

Department Key

Department

unavailable in ajeraCore unless you have the Departments add-on

The database identifier of the department of the employee associated with the check

 

Department

Department

unavailable in ajeraCore unless you have the Departments add-on

The department of the employee associated with the check

 

GL Company Key

 

Multi-company only. The database identifier of the GL company associated with the check

 

GL Company Name

 

Multi-company only. The name of the GL company associated with the check

 

Employee:

Employee Key

Employee

The employee's name

 

Employee

Employee

The full name of the employee

 

First Name

 

The employee's first name

 

Middle Name

 

The employee's middle name

 

Last Name

 

The employee's last name

 

Employee Status

 

The status of the employee

 

Accrual Hours

 

The number of hours accrued for the pay type

x

Hours

 

The hours worked

x

Employee Amount

 

The amount of the deduction paid by the employee

x

Employer Amount

Check Summary

The amount of the deduction paid by the employer

x

Session Key

 

The database identifier for the session associated with this check

 

Defined links:

Link - Transaction Labor

Transaction Labor

A link to the Transaction Labor inquiry

 

Link - Session

Session

A link to the Session inquiry