The Employee Payroll Data – Partner Quote AQ is a standard Advanced Query report in Avionté Classic that consolidates employee payroll data and tax setup information into a single, check-level export. Use it to compile and share employee payroll details with external partners for quoting purposes, without pulling from multiple sources or reformatting exports manually.
On This Page
Report Description
The Employee Payroll Data – Partner Quote AQ returns one row per paycheck for each employee within the selected check date range. Each row combines paycheck totals (gross, deductions, taxes) with the employee's tax setup (W-4 type, federal filing status, state filing status), giving external partners a complete picture of payroll obligations in a single export.
The report includes a Grand Summaries row at the bottom showing totals for GrossAmount, TotalDeductions, and TotalTaxes across all returned records.
Parameters
Use the parameters below to filter report results before running the query.
| Parameter Name | Options | Description |
| Branch (Paycheck) | All available branches, or ALL | Filter results by the branch on the paycheck. Select ALL to include paychecks from every branch. |
| Start Date (Check Date) | Date entry | Beginning of the check date range for the report. |
| End Date (Check Date) | Date entry | End of the check date range for the report. |
Report Fields
The table below describes each field returned in the Employee Payroll Data – Partner Quote AQ. Results are returned at the check level — one row per paycheck per employee.
| Field Name | Description |
| EmployeeID | The employee's ID from Classic Back Office. |
| ResidentState | The state where the employee resides. |
| CheckDate | The date of the paycheck. |
| GrossAmount | The total gross wages for the paycheck. |
| TotalDeductions | The total deductions applied to the paycheck. |
| TotalTaxes | The total taxes withheld from the paycheck. |
| IsW2 | Indicates whether the employee is classified as a W-2 employee. Checked = Yes. |
| PayFrequency | The employee's pay frequency (for example, Weekly). |
| Is2020W4 | Indicates whether the employee has a 2020 or later W-4 on file. Checked = Yes. |
| FedFilingStatus | The employee's federal tax filing status (for example, Single, Married Filing Jointly, Head of Household). |
| Dependents | The dependent amount from the employee's W-4. |
| StateFilingStatus | The employee's state tax filing status. For employees with tax setup in multiple states, all state statuses are concatenated into this field (for example, IA Single, MI N/A). |
Comments
0 commentsPlease sign in to leave a comment.