Team

Desert Demo Electric

Team

Payroll

Hours added up for each pay period, with overtime, ready to send to your payroll company.

Aestar doesn't pay anyone or file taxes.

Aug 24 – Sep 6This pay period · payday Fri, Sep 11 · paid every other week
Ava

  • Sam didn't clock out Saturday. No job is on the schedule after that; the shop closed at 5:00 PM. Set the clock-out to 5:00 PM?

    That makes it 9h 30m for the day, clocked in at 7:30 AM. Payroll reads the timesheet. Until then that shift isn't in these hours.

  • Pat is on the clock now. Today's hours count once they clock out.

  • Pat has 1.50 hours of overtime (over 40 in a week), paid at 1.5 times the rate.

  • Heads up for payroll on Fri, Sep 11: it's about $5,400, and only $629 is due in before then.

    Three things close the gap: ask for the deposit on 1 approved job ($3,840), remind the unpaid invoice ($1,000), and fill next week's open time.
    See the fixes on Today
Gross pay · Aug 24 – Sep 6
$3,528So far this period, before taxes

The math: 79.00 hours at each person's rate, 1.50 of them overtime at 1.5×.

Regular $3,420Overtime $108

  1. Mon, Aug 24Period starts
  2. Sun, Aug 30Today
  3. Sun, Sep 6Period ends
  4. Fri, Sep 11Payday

For your payroll company

One line per person with regular and overtime hours, rate and pay before taxes. Payroll services that import a spreadsheet of hours can take this file; or type the totals in.

Overtime here is hours over 40 in a Monday–Sunday week. Your payroll service applies your state's rules, taxes and deductions.

PersonHoursOvertimeRateGrossAva
Pat Nelson
Day by day
  • Mon, Aug 248.50 h
  • Tue, Aug 258.00 h
  • Wed, Aug 269.00 h
  • Thu, Aug 278.00 h
  • Fri, Aug 288.00 h
41.50 h1.50 habout $2,028Overtime this period
Sam Ortiz
Day by day
  • Mon, Aug 248.00 h
  • Tue, Aug 258.00 h
  • Wed, Aug 267.50 h
  • Thu, Aug 278.00 h
  • Sat, Aug 296.00 h
37.50 h–about $1,500Missed clock-out
Total79.00 h1.50 h$3,528