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 > Reports menu, click Standard Inquiries > 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

Date range available

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:

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