Standard AQ - Check Register AQ

Report Description

This report is a good resource to crosscheck with payroll before submission.

mceclip0.png

 

 

Parameters

mceclip1.png

 

Parameter Name

Options

Description

Branch (Payment Check)

 

Paycheck’s Branch

Date Type

Check Date, Accounting Period Date, ACH Generated Date, Positive Pay Generated Date

 

Start Date

 

 

End Date

 

 

SSN Ends with

 

Filters results by Employee’s SSN

Show Earnings Details

Yes, No

 

Show Deductions Details

Yes, No

 

Show Benefits Details

Yes, No

 

Payment Bank

 

List outs all the “Bank ID | Bank Names”

Customer Name

 

 

Customer ID

   

 

 

Report Fields

mceclip2.png

 

Field Name

Description

Staffing Company

Paycheck’s Supplier

Branch

Paycheck’s Branch

Payment Bank ID

Payment Bank’s ID

Payment Bank Name

Payment Bank’s Name

Payment Batch ID

ID of the Payroll Batch

Check Date

Paycheck’s Check Date

Accounting Period Date

Paycheck’s Accounting Period Date

ACH Generated Date and Time

Paycheck’s ACH Generated Date and Time

Positive Pay Generated Date and Time

Paycheck’s Positive Pay Generated Date and Time

Date Cleared

Paycheck’s Cleared Date

Check Number

Paycheck’s Check Number

Check Delivery

Paycheck’s Check Delivery

Employee ID

Employee’s ID

BoldTalentID

Employee ID in AviontéBOLD (Front Office)

Agency ID

Agency’s ID

Payee Name

Employee’s Name

SSN

Employee’s SSN

Employee Status

Employee Status

EmailAddress

The employee's email address

PrimaryPhone

The employee's primary phone number

RegPayRate

Reg Pay Rate associated with the check. If there are more than one Reg, then it displays the reg rate of the one that has the most hours.

Gross Amount

Paycheck’s Total Gross Amount

Total EE Taxes

Paycheck’s Total Employee’s Taxes

Total Deductions

Paycheck’s Total Deduction Amount

Total Benefits

Paycheck’s Total Benefit Amount

Net Amount

Paycheck’s Total Net Amount

Is W2

Is W2 or not? (check-box)

Is Direct Deposit,

Is Direct Deposit or not? (check-box)

Federal Tax

Total Federal Tax Amount); VertexTaxId = 400

States

Name of the state whose tax is calculated

State WH

Total State WH Tax Amount; VertexTaxId = 450

FICAEE

Total FICAEE Tax Amount (Employee Tax); VertexTaxId = 403

MEDEE

Total MEDEE Tax Amount (Employee Tax) ); VertexTaxId = 406

LOCALEE

Total LOCALEE Tax Amount (Employee Tax) ); VertexTaxId = 405, 408, 410, 411, 412, 415, 451, 456, 470, 501, 530, 536, 537, 538

SUIEE

Total SUIEE Tax Amount (Employee Tax) ); VertexTaxId = 458, 468

SDIEE

Total SDIEE Tax Amount (Employee Tax) ); VertexTaxId = 466, 481

Statewide Transit

The statewide transit tax is calculated based on the employee's wages as defined in ORS 316.162. Employees who aren't subject to regular income tax withholding due to high exemptions, wages below the threshold for income tax withholding, or other factors are subject to statewide transit tax withholding. (Oregon)

FICAER

Total FICAER Tax Amount (Employer Tax) ); VertexTaxId = 404

MEDER

Total MEDER Tax Amount (Employer Tax) ); VertexTaxId = 407

SUIER

Total SUIER Tax Amount (Employer Tax) ); VertexTaxId = 459

SUIER Additional

Total SUIER Tax Amount (Employer Tax) ); VertexTaxId = 465, 463, 461, 453

SDIER

Total SDIER Tax Amount (Employer Tax) ); VertexTaxId = 467

FUTAER

Total FUTAER Tax Amount (Employer Tax) ); TaxName like ‘%FUTA ER’

LOCALER

Total LOCALER Tax Amount (Employer Tax) ); VertexTaxId = 101,457,502,531,533,101,103,409,413,457,471 and taxname not containing words, PFML or PAID FAMILY

Earn: Vac – Units, Earn: Vac,

Earn: Salary – Units, Earn: Salary, etc.

These Earnings, Deductions, and Benefits fields are dynamically pulled from your settings.

These columns also depends on the parameters – “Show Earnings Details, Show Deductions Details, Show Benefits Details” value.

If set to Yes, then the columns display.

StatePFMLEE

Total PFML Tax Amount (Employee Tax) ); VertexTaxId = 456

StatePFMLER

Total PFML Tax Amount (Employer Tax) ); VertexTaxId = 455, 457 and tax name containing words, PFML or PAID FAMILY

ADPFileStatus

ADP File Status

ADPFileGeneratedBy

User Description of the user who generates the ADP File

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.