Submit a ticket

Standard Canadian AQ - Processed Transaction Summary CA AQ

Updated on Follow
0 out of 0 found this helpful

Report Description

This AQ is a replacement of Processed Transaction Summary AQ created for Canadian clients. The only difference between US and Canadian version are the Tax details.

 

Processed Transaction Summary CA shows Canadian clients.

 

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

 

Processed_Transaction_Summary_CA.png

 

 

Parameters

Parameter Name

Options

Explanation

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

Explanation

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 the customer associated with Transaction.

BillToName

Customer name associated with Transaction.

DepartmentName

Department Name associated with Transaction.

EmployeeID

Employee ID from transaction

SIN

SIN of the employee.

EmployeeName

Name of the employee.

IsT4

Indicates whether the transaction is a T4 Transaction or Non-T4Transaction.

StaffingOrderID

Order ID associated with Transaction

OrderType

Order Type from Order associated with Transaction

WcCode

Worker Comp Code.

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.

ChequeDate

Check Date from the check associated with transaction

ChequeNumber

Check number.

ChequeBranch

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

AgencyName

Agency Name associated with non-T4 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

Fed Taxes

Canadian Federal Withholding 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

Prov Taxes

Canadian Province Tax from payment check associated with transaction.

EIEE

Canadian EI EE Tax from payment check associated with transaction.

CPPEE

Canadian CPP EE (Quebec Pension Plan EE) Tax  from payment check associated with transaction.

PPIEE

Canadian PPI  EE Tax from payment check associated with transaction.

OtherTaxesEE

Sum of all tax amounts present in the check associated with transaction (excluding  Fed Taxes, Prov Taxes, EIEE, CPPEE and PPIEE)

Job Position

Job Position from Order associated with Transaction

 

After the column ‘Job Position, 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.