You are here: Ajera Help (A-Z) > Inquiries > Inquiry descriptions > Check Summary inquiry

Check Summary inquiry

unavailable in ajeraCore unless you have the Payroll add-on

Use this inquiry to see totals for the detail that appears on paid employee paychecks and then drill down to detail for each check. The inquiry initially shows checks for the current year by employee. Use this inquiry to see the transactions and GL entries associated with a paycheck.

Using the inquiry

From the Inquiry menu, click Payroll > Check Summary.

Audience

Accounting staff

Employee

Inquiry conditions

The inquiry automatically contains conditions to show only data from this current payroll year and to exclude voided checks. You can always add, change, or delete conditions on an inquiry.

Groups

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

Standard columns

Column	Links to this inquiry	Description
Payroll Year		The year the payroll occurs
Employee		The full name of the employee
Check Status		The status of the paycheck
Check Number	Check Detail	The number of the paycheck
Pay Date		The date of the payroll
Check Pay Period		The pay period for the pay included on the check
Regular Hours	Check Detail	The number of hours worked at the employee's regular pay rate
Regular Amount	Check Detail	The amount of pay earned at the employee's regular pay rate
Overtime Hours	Check Detail	The number of hours worked at the employee's overtime pay rate
Overtime Amount	Check Detail	The amount of pay earned at the employee's overtime pay rate
Other Type Hours	Check Detail	The number of hours worked by the employee for a pay with a type of Other (as defined when setting up the pay)
Other Type Amount	Check Detail	The amount of pay earned by the employee for a pay with a type of Other (as defined when setting up the pay)
Total Hours	Check Detail	The total hours worked
Gross Pay Amount	Check Detail	The amount of the employee's pay before any taxes or deductions
Deduction Amount	Check Detail	The total amount deducted from the employee's gross pay
Employee Tax Amount	Check Detail	The total amount deducted for taxes from the employee's pay
Net Pay Amount	Check Detail	The employee's pay after deductions and taxes
Employer Tax Amount	Check Detail	The amount the employer pays in taxes
Fringe Amount	Check Detail	The amount of fringe benefits included in the paycheck
Defined links:
Transaction- Labor	Transaction - Labor	A link to the Transaction - Labor inquiry

Predefined columns

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

Payroll
Paycheck
Defined links

Column	Links to this inquiry	Description	Date range available
Payroll:
Payroll Key		The database identifier of the payroll associated with this check
Status		The status of the payroll
Description		The description of the payroll
Period Beginning Date		The first date of the payroll period	x
Period Ending Date		The last date of the payroll period	x
Payroll Quarter		The quarter the payroll occurs
Payroll Company Key		Multi-company only. The name 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		The database identifier of the paycheck associated with this check
Employee Key	Employee	The database identifier of the employee associated with this check
First Name	Employee	The employee's first name
Middle Name	Employee	The employee's middle name
Last Name	Employee	The employee's last name
Employee Status		The status of the employee associated with this check
Covered by HIRE Act	Employee	Applies only if your are running payroll for 2010 Indicates if the employee is covered by the HIRE Act
Bank Entry Key	Bank Entry	The database identifier of the bank entry associated with this check
Direct Deposit Bank Entry Key	Bank Entry	The database identifier of the direct deposit bank entry associated with this check
Pay Key		The database identifier of the pay associated with the check
Supervisor Key	Employee	The database identifier for the supervisor of the employee associated with this check
Supervisor	Employee	The supervisor for the employee associated with this check
Department Key	Department	unavailable in ajeraCore unless you have the Departments add-on The database identifier for the department of the employee associated with this check
Department	Department	unavailable in ajeraCore unless you have the Departments add-on The department for the employee associated with this check
Session Key	Session	The database identifier for the session associated with this check
FWH Taxable		The amount of pay in the paycheck that is taxable
FWH Withheld		The amount withheld for Federal withholding
Social Security Subject To		The amount of pay in the paycheck subject to Social Security withholding
Medicare Subject To		The amount of pay in the paycheck subject to Medicare withholding
Social Security Withheld		The amount withheld for Social Security
Medicare Withheld		The amount withheld for Medicare
Total Tax Withheld		The total amount deducted for taxes from the employee's pay
Earned Income Credit		The amount of Earned Income Credit tax associated with this check
Employer Social Security		The amount paid by the employer for Social Security
Employer Medicare		The amount paid by the employer for Medicare
Defined links:
Check Detail	Check Detail	A link to the Check Detail inquiry
Bank Entry	Bank Entry	A link to the Bank Entry inquiry
Transaction Labor	Transaction Labor	A link to the Transaction Labor inquiry
Direct Deposit Bank Entry	Direct Deposit Bank Entry	A link to the Direct Deposit Bank Entry inquiry
Session	Session	A link to the Session inquiry
GL Entry	GL Entry	A link to the GL Entry inquiry