Move verified attendance into QuickBooks payroll — export the Total Work Hours report as CSV, convert it to IIF and import as Timer Activities.
In the Total Work Hours report select Daily in Sum by, set the start and end dates, and choose Hours and minutes in Show time.
Click Export and choose CSV.
Combine first and last name into a new EMP column, rename Work hour to DURATION, set the To column to DD/MM/YY and rename it DATE, then delete the remaining columns.
Download the sample IIF file, export a “Timer List” IIF from QuickBooks (File → Utilities → Export) and copy its first four header lines into the sample. Fill in TIMEACT rows: DATE, JOB, EMP, DURATION, ITEM, payroll item and billing status.
Import via File → Utilities → Import → Timer Activities, then review the Timer Import Data report to confirm everything landed correctly.
