Standard AQ - Processed Transaction Summary

Purpose: This report gives a comprehensive view of all processed transactions over a specific time period, providing detailed information on every transaction element, from employee details to payment specifics.

Why It Matters: Tracking all processed transactions is crucial for maintaining accurate financial records and ensuring compliance. This report helps organizations keep an eye on every financial transaction, verifying that all payments and invoices are processed correctly.

Efficiency Drivers:

• Comprehensive Data Access: Quickly access all transaction details in one place, saving time compared to checking multiple sources.
• Error Identification: Identify discrepancies or errors in transactions early, minimizing the risk of costly mistakes and financial inaccuracies.
• Streamlined Audits: Simplify the auditing process by having a detailed record of all transactions readily available.

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

Parameters

Parameter Name	Options	Description
Branch (Transaction)	All available branches.	Transaction’s Branch.
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.
SSN		Filters results by Social Security Number.
Employee ID	Field to enter a value	Filters results by Employee ID.

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.
RootCustomerID	Customer ID of the Root Customer for the associated Transaction
Company Type	The organizational classification of the customer company.
BillToName	Customer name associated with Transaction.
DepartmentName	Department Name associated with Transaction.
Parent Account	The parent account associated with the customer, if the customer is a subsidiary or child account of a larger organization.
EmployeeID	Employee ID from transaction
BoldTalentID	Employee ID from AviontéBOLD (Front Office)
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
WorksiteAddress1	Customer’s Worksite address 1
WorksiteAddress2	Customer’s Worksite address 2
WorksiteCity	Customer’s Worksite City Name
WorksiteState	Customer’s Worksite State Abbreviation
WorksiteZipCode	Customer’s Worksite Zip Code
WorksiteCountry	Customer’s Worksite country name
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
BoldJobID	The identifier for Job in AviontéBOLD (Front Office)
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
NonAdjustmentCost	Shows Item Cost value for the Adjustment Pay codes. Otherwise, it is 0.
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)
BoldCompanyID	Identifier for Company in AviontéBOLD (Front Office)
BoldTimeSheetApprovedBy	Name of the user who has approved the Timesheet from AviontéBOLD
BoldTimeSheetApprovedDate	Date on which the Timesheet was approved from AviontéBOLD
BoldSavedBy	Name of the user who has saved the Timesheet from AviontéBOLD
BoldSavedTime	Date on which the Timesheet was saved from AviontéBOLD
BoldSubmittedBy	Name of the user who has submitted the Timesheet from AviontéBOLD
BoldSubmittedTime	Date on which the Timesheet was submitted from AviontéBOLD
Dynamic fields	After the column ‘BoldSubmittedTime', 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

Actionable Insights:

• Regular Monitoring: Consistently monitor this report to stay on top of all financial activities and ensure accuracy.
• Use Filters Effectively: Apply filters (e.g., by branch, date, employee) to quickly narrow down data and focus on specific areas of interest or concern.
• Data-Driven Decisions: Use the insights from this report to inform financial decisions and strategies, ensuring your organization remains compliant and financially healthy.

Effectively utilizing this report means improved accuracy in financial reporting, reduced errors, and streamlined processes that free up resources to focus on strategic growth and client satisfaction