Employees and payroll

Using your example, the employee's last pay stub for the year will have a line item on it for Overtime and the YTD column will show $6,000. True, it won't tell the employee to divide by 3 to get $2,000, but that seems like a small step.

Even so, you can create a report in QuickBooks with the total overtime per employee and then send it to excel as you suggest.

To do this, start with the Employee Earnings Summary report.  Then filter it for the payroll item or items that are overtime, and you'll get a report like this:

Then send it to Excel and add a column that calculates the Qualified Overtime with a formula: