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.
| 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:
|
. 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 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 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. |
||
|
Termination Date |
The date the employee is terminated |
||
|
Hire Date |
The date the employee is hired |
||
|
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 |
|
|
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 |
||
