3/20/09 UPDATE:  This will now accept input without typing the colon in the time format.



When we started our catering business, I was frustrated with trying to calculate hours worked by employees based on the times on the timecards. Rounding off to the nearest 15 minutes didn't seem fair to me, so I assembled an Excel workbook (a set of 6 connected spreadsheets) in a single file. I've been using it for a couple of years now, and have added features as I saw a need for them.

Features of the current version include:

First tab - Employee Data

• Name
• Address
• Rate per Hour
• Overtime Multiplier (default is 1.5 but you can change it)

Second tab - Timecard Data

• Timecard Data should be entered on this page, as shown on the timecards, for up to a two week pay period.
• Employee Names are automatically filled in from the first tab.
• Start Day should be entered here - ALL other dates are calculated automatically based on the start day. The start day must be a Monday in the current version, but I could customize that for you.
• Lunch period durations are calculated and displayed for each day.
• Time In, Out/In for Lunch period, then Time Out for the day. Additional work periods in the same day are customizable at additional cost.

Third and Fourth tabs summarize times organized by employee for each week.

• Hours:Minutes worked are totaled for each employee each day.
• Total hours worked are calculated for the week
• Rate per Hour is read from the first tab, and used to calculate a "gross pay" dollar amount for the week, accounting for overtime hours and the overtime multiplier.
• Overtime is calculated, based on any hours worked in excess of 8 hours in a single day.
• Total Payroll dollar amount is calculated based on hours and rate.

Fifth Tab - summarizes all weekly totals

Sixth Tab - provides a convenient summary formatted specifically to send as a fax to your accountant or payroll service, such as PayChex, ADP, Bank of America, etc.

If this interests you, give it a try!  See it in action!  Here is a youtube demo of the full new version:

http://www.youtube.com/watch?v=rW2xlf0eyb0

Download your sample:

I wanted to make this sample free, but PayLoadz won't process a zero amount transaction. The cost for the sample is one cent, all of which will go to PayPal fees. I'll try to put a completely free sample up soon.  I'm also working on a working sample of the new version 2.0.

Price: $0.01 for the Sample

Price: $49.95 for the full Workbook, including customization. THIS IS THE NEW VERSION 2.0 that does not need the colon in the time entry.  THIS SAVES SO MUCH TIME!  You will receive my phone number when you purchase, so we can talk about what features you would like to customize.