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
Comments
0 commentsPlease sign in to leave a comment.