I need a payroll report that shows total earnings and deductions for each employee by date, what report would be best?

The Payroll Earnings and Hours report would work best, it is located under Payroll Transaction Reports.  You can set your report criteria by date range, detail or summary format, and for all employees, a selection list or for just one.