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

Deposit Summary inquiry

unavailable in ajeraCore unless you have the Payroll add-on

Use this inquiry to see the amounts deposited to accounts for withholding on employee paychecks.

Using the inquiry

From the Inquiry menu, click Payroll > Deposit Summary.

To Do this

Change the cutoff date

Click the link for it, which appears under the inquiry title, and select a different date.

For example, if you want to report totals as of last month, you change the cutoff date to last month.

See detail by employee

Drill down to it by clicking the plus sign next to the type of deposit

Show data for a previous year

Change the condition as follows:

  1. Click .
  2. Click the Conditions tab.
  3. In the Payroll Year condition, enter the year you want to report on in the field on the right.

Audience

Accounting staff

Inquiry conditions

The inquiry automatically contains a condition to show only data for the current payroll year. You can always add, change, or delete conditions on an inquiry.

Groups

The inquiry is grouped by Group and Description. You can always group or ungroup columns, as needed.

Standard columns

Column Links to this inquiry Description Date range available

Type

 

The type of tax

 

Description

 

The name of the tax

 

Employee

Employee

The full name of the employee

 

Payroll Year

 

The year the payroll occurs

 

Employee Contribution

 

The amount of taxes paid by the employee

The database name/formula is:

CASE WHEN [Is Employee]=1 THEN [Tax] END

 

Employee Taxable

 

The amount of wages taxable for employee taxes

The database name/formula is:

CASE WHEN [Is Employee]=1 THEN [Taxable] END

 

Employee Subject-To

 

The amount of wages subject to employee taxes

The database name/formula is:

CASE WHEN [Is Employee]=1 THEN [SubjectTo] END

 

Employer Contribution

 

The amount of taxes paid by the employer

The database name/formula is:

CASE WHEN [Is Employer]=1 THEN [Tax] END

 

Employer Taxable

 

The amount of wages taxable for employer taxes

The database name/formula is:

CASE WHEN [Is Employer]=1 THEN [Taxable] END

 

Employer Subject-To

 

The amount of wages subject to employer taxes

The database name/formula is:

CASE WHEN [Is Employer]=1 THEN [SubjectTo] END

 

Total Contribution

 

The total tax contribution

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

Tax:

Tax Key

 

The database identifier of the tax

 

Order

 

The position of the tax on the check

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

 

Group

 

The group associated with the deposit

 

Supervisor Key

Employee

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

 

Supervisor

Employee

The supervisor of the employee associated with this check

 

Department Key

Employee

unavailable in ajeraCore unless you have the Departments add-on

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

 

Department

Employee

unavailable in ajeraCore unless you have the Departments add-on

The department of the employee associated with this check

 

Employee:

Employee Company Key

 

Multi-company only. The database identifier of the company linked to the employee associated with the check

 

Employee Company Name

 

Multi-company only. The name of the company linked to the employee associated with the check

 

Employee Key

Employee

The database identifier of the employee associated with the 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

 

Social Security Number

 

The employee's Social Security Number

 

Is Employer

 

It identifies if the tax is an employer tax.

 

Is Employee

 

It identifies if the tax is an employee tax.

 

Date:

Termination Date

 

The date the employee is terminated

 

Hire Date

 

The date the employee is hired

 

Amount

Weeks

 

The total number of weeks worked for the year to-date

 

Hours

 

The total number of hours worked for the year-to-date

x

Gross Amount

 

The amount of the employee's pay before any taxes or deductions

x

Taxable

 

The total amount deducted for taxes from the employee's pay

x

Subject To

 

The total pay subject to tax, based on the wage limit for the tax

x

Tax

 

The amount paid for tax

x

940:

SUI Rate

 

The rate paid for state unemployment insurance

x

Contribution

 

The Subject-To amount multiplied by a standard rate of 5.4%

x

Contribution Expected Rate

 

The amount withheld based on the rate setup for the tax

x

Additional Credit

 

The difference between the Contribution amount and the actual amount withheld based on the employer’s rate

x

Is 940 Part I

 

It indicates if this tax included on the 940 Part I inquiry

 

Is 940 Part II

 

It indicates if this tax included on the 940 Part II inquiry

 

See also

About key fields

About standard inquiries

Adding a predefined inquiry column

Creating a new inquiry column

Displaying inquiry data for a specific time period

 

 

© 2015 Deltek Inc. All rights reserved.