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 > Reports menu, click Standard Inquiries > Payroll > Deposit Summary.

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:

Click .
Click the Conditions tab.
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:

Tax
Employee
Date
Amount
940

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