Submit a ticket

Standard AQ - Processed Transaction Summary

Updated on Follow
0 out of 0 found this helpful

 

Report Description

Gives detailed information of all processed transactions. (This report shows an extremely comprehensive view of all processed transactions during a specific time period.)

ProcessedTransactionSummary.png

 

 

 

Parameters

Parameter Name

Options

Description

Branch (Transaction)

All available branches.

Transaction’s Branch.

SSN

 

Filters results by Social Security Number.

Date Type

Accounting Period Date, Week Worked, Check Date, Invoice Date

Transaction’s Accounting Period or Week Worked or Check Date or Invoice Date

Start Date

 

 

End Date

 

 

Customer Name

 

Filters results by Customer name.

 

 

 

 

Report Fields

Field Name

Description

StaffingSupplierDesc

Supplier Name from Transaction.

TransactionBranch

Transaction’s Branch

AccountingPeriodDate

Transaction’s Accounting Period Date

WeekWorked

Transaction’s Week Worked Date

TimeEntryBatchID

Batch ID from Transaction.

TransactionID

Transaction ID from Transaction.

CustomerID

Customer ID of customer associated with Transaction.

BillToName

Customer name associated with Transaction.

DepartmentName

Department Name associated with Transaction.

EmployeeID

Employee ID from transaction

SSN

Social Security number of employee from transaction.

EmployeeName

Name of employee from transaction.

Is W2

Indicates whether the transaction is a W2 Transaction or Non-W2 Transaction.

StaffingOrderID

Order ID associated with Transaction

OrderType

Order Type from Order associated with Transaction

WcCode

Worker compensation Code.

For e.g. MN7854 where MN is the state and 7854 is the WcCode.

Wc Code Rate

Rate associated with the Wc Code.

JobPosition

Job Position from transaction

AssignmentID

Assignment Id associated with Transaction

AssignmentStartDate

Assignment Start Date

AssignmentEndDate

Assignment End Date

CheckAccountingPeriodDate

Accounting Period associated with the check.

CheckDate

Check Date from the check associated with the transaction

CheckNumber

Check number.

CheckBranch

Check’s branch

IsDirectDeposit

Shows if check is direct deposit or not.

InvoiceAccountingPeriodDate

Accounting Period associated with the Invoice.

InvoiceDate

Date of invoice associated with transaction

InvoiceNumber

Invoice number of invoice associated with Transaction

InvoiceBranch

Branch of Invoice

TotalPay

Total Pay from transaction

TotalBill

Total Bill from transaction

BillAmount

Bill Amount from transaction

GrossWages

Gross Wages from transaction

TotalAdjustmentPay

Total Adjustment Pay from Transaction

TotalAdjustmentBill

Total Adjustment Bill from Transaction

WorkerCompCost

WorkerCompCost from Transaction

CostWorkerCompCost

CostWorkerCompCost from Transaction

Agency Name

Agency Name associated with non W2 transaction

AgencyCost

AgencyCost from transaction

PaymentCost

PaymentCost from Transaction

Burden

Burden from Transaction

GrossProfit

Gross Profit from Transaction

GrossProfitPercent

GrossProfitPercent from Transaction

GrossMargin

Difference of Total Bill and Total Pay from transaction

 

Formula: Gross Margin = Total Bill – Total Pay

EmployerTaxes

EmployerTaxes from transaction

EmployerContribution

EmployerContribution from transaction

PayRTHours

Pay Hours from transaction for “REG” pay code

PayOTHours

Pay Hours from transaction for “OT” pay code

PayDTHours

Pay Hours from transaction for “DT” pay code

PayOtherHours

PayOtherHours from transaction.

PayTotalHours

PayTotalHours from transaction

BillRTHours

Bill Hours from transaction for “REG” pay code

BillOTHours

Bill Hours from transaction for “OT” pay code

BillDTHours

Bill Hours from transaction for “DT” pay code

BillOtherHours

BillOtherHours from transaction

BillTotalHours

BillTotalHours from transaction

RTPay

Total Pay from transaction for “REG” pay code

OTPay

Total Pay from transaction for “OT” pay code

DTPay

Total Pay from transaction for “DT” pay code

RTBill

Total Bill from transaction for “REG” pay code

OTBill

Total Bill from transaction for “OT” pay code

DTBill

Total Bill from transaction for “DT” pay code

TotalAdjustmentCost

Total Adjustment cost from Transaction

GPAdjustmentPay

GPAdjustmentPay from transaction

GPAdjustmentBill

GPAdjustmentBill from transaction

GPAdjustmentCost

GPAdjustmentCost from transaction

SalesTaxAmount

Sum of total SalesTaxAmount from transaction.

WorkerCompWage

WorkerCompWage from transaction

CreditCardFee

CreditCardFee from transaction

DiscountAmount

DiscountAmount  from transaction

RebateAmount

RebateAmount from transaction

PONumber

Purchase Order number from transaction

FederalIncomeTax

Federal Income Tax from payment check associated with transaction.

*The tax amount is calculated as Tax Amount present in the check multiplied by PayPercentOFTransaction.

Formula = tax amount * PayPercentOFTransaction.

Where PayPercentofTransaction is the proportion of transaction in a check

StateTax

State Tax from payment check associated with transaction.

FICAEE

FICAEE from payment check associated with transaction.

MEDEE

MEDEE from payment check associated with transaction.

OtherTaxes

Sum of all tax amounts present in the check associated with transaction (excluding Federal Income Tax, State Tax, FICAEE, MEDEE)

 

After the column ‘OtherTaxes, if there are users of particular categories present in the transaction extra for transaction, then the names of the user along with their respective category are displayed. (These columns are pulled dynamically so these columns would be displayed only if there are users present in transaction extra)

 

For e.g. In a particular transaction, if John Doe is a Service Rep of category “CustomerUser” then his name will be displayed in the dynamic column CustomerUser: Service Rep

 

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.