Spreadsheet: 111909d1308154702-vlookup-balance-sheet
Sheet: ALL

 | [NAME] |  |  | 5.13.11
 | Payroll Total Hours | ADP Total Hours | DIFF | Payroll Total Earns | ADP Total Earns | DIFF
AUTOMATICALY PAID ITEMS / SALARY ITEMS
REGULAR | 60 | 60 | 0 | 5000 | 5000 | 0 |  |  | REGULAR
 |  |  | 0 |  |  | 0 |  |  | 911 - DPMED
 |  |  | 0 |  |  | 0 |  |  | 912 - DPDEN
 |  |  | 0 |  |  | 0 |  |  | OVERTIME
 |  |  | 0 |  |  | 0 |  |  | AL2 - CAR ALLOWANCE
 |  |  | 0 |  |  | 0 |  |  | AWARD
 |  |  | 0 |  |  | 0 |  |  | BEREAVMENT
 |  |  | 0 |  |  | 0 |  |  | JURY DUTY
 |  |  | 0 |  |  | 0 |  |  | BONUS - PERFORMANCE
 |  |  | 0 |  |  | 0 |  |  | BONUS - ANNUAL
TOTALS | 60 | 60 | 0 | 5000 | 5000 | 0 |  |  | BONUS - INCENTIVE
MANUAL CHECK BATCH |  |  |  |  |  |  |  |  | BONUS - REFERRAL
REGULAR | 80 | 80 | 0 | 2350 | 2350 | 0 |  |  | CAR
OVERTIME | 5 | 5 | 0 | 400 | 400 | 0 |  |  | CPK
COMMISSION |  |  | 0 | 200 | 200 | 0 |  |  | COMMISSION
 |  |  | 0 |  |  | 0 |  |  | DAY OFF AWARD
 |  |  | 0 |  |  | 0 |  |  | DBL TIME
 |  |  | 0 |  |  | 0 |  |  | DISABILITY
 |  |  | 0 |  |  | 0 |  |  | DRAW
 |  |  | 0 |  |  | 0 |  |  | FLOATING HOLIDAY
 |  |  | 0 |  |  | 0 |  |  | GTL (913)
 |  |  | 0 |  |  | 0 |  |  | GTL
TOTALS | 85 | 85 | 0 | 2950 | 2950 | 0 |  |  | HOLIDAY
BATCH 1 - |  |  |  |  |  |  |  |  | HOLIDAY OT
AL2 - CAR ALLOWANCE |  |  | 0 | 500 | 500 | 0 |  |  | INCENTIVE
 |  |  | 0 |  |  | 0 |  |  | MNT
 |  |  | 0 |  |  | 0 |  |  | MVT
 |  |  | 0 |  |  | 0 |  |  | ON CALL
 |  |  | 0 |  |  | 0 |  |  | HOLIDAY PREMIUM
 |  |  | 0 |  |  | 0 |  |  | OTHER
 |  |  | 0 |  |  | 0 |  |  | PERSONAL
 |  |  | 0 |  |  | 0 |  |  | RETRO PAY
 |  |  | 0 |  |  | 0 |  |  | RIDESHARE / PARKING
 |  |  | 0 |  |  | 0 |  |  | SEVERANCE
TOTALS | 0 | 0 | 0 | 500 | 500 | 0 |  |  | SF SICK
[NAME] |  |  |  |  |  |  |  |  | SHIFT
REGULAR | 40 | 40 | 0 | 600 | 600 | 0 |  |  | SHIFT OT
OVERTIME | 5 | 5 | 0 | 87 | 87 | 0 |  |  | SICK
 |  |  | 0 |  |  | 0 |  |  | STD
 |  |  | 0 |  |  | 0 |  |  | STO (Stock Opt Rest)
 |  |  | 0 |  |  | 0 |  |  | STOCK
 |  |  | 0 |  |  | 0 |  |  | SUPPLEMNTAL PAY
 |  |  | 0 |  |  | 0 |  |  | TRAINING
 |  |  | 0 |  |  | 0 |  |  | TRAVEL PAY
 |  |  | 0 |  |  | 0 |  |  | VACATION
 |  |  | 0 |  |  | 0
TOTALS | 45 | 45 | 0 | 687 | 687 | 0
BATCH 3 -
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
REGULAR | 9 | 9 | 0 | 500 |  | 500
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
TOTALS | 9 | 9 | 0 | 500 | 0 | 500
[NAME]
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
BEREAVMENT | 8 | 8 | 0 | 83 | 83 | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
TOTALS | 8 | 8 | 0 | 83 | 83 | 0
BATCH 5 -
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
REGULAR | 80 | 80 | 0 | 1600 | 1600 | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
TOTALS | 80 | 80 | 0 | 1600 | 1600 | 0
BATCH 6 -
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
REGULAR | 80 | 80 | 0 |  |  | 0
 |  |  | 0 |  |  | 0
 |  |  | 0 |  |  | 0
TOTALS | 80 | 80 | 0 | 0 | 0 | 0
ALWAYS INSERT ANY NEW BATCHES ABOVE THIS ROW
GRAND TOTALS
REGULAR | 60 | 60 | 0 | 5000 | 5000 | 0
911 - DPMED |  |  | 0 |  |  | 0
912 - DPDEN |  |  | 0 |  |  | 0
OVERTIME | 5 | 5 | 0 | 400 | 400 | 0
AL2 - CAR ALLOWANCE | 0 | 0 | 0 | 500 | 500 | 0
AWARD |  |  | 0 |  |  | 0
BEREAVMENT | 8 | 8 | 0 | 83 | 83 | 0
JURY DUTY |  |  | 0 |  |  | 0
BONUS - PERFORMANCE |  |  | 0 |  |  | 0
BONUS - ANNUAL |  |  | 0 |  |  | 0
BONUS - INCENTIVE |  |  | 0 |  |  | 0
BONUS - REFERRAL |  |  | 0 |  |  | 0
CAR |  |  | 0 |  |  | 0
CPK |  |  | 0 |  |  | 0
COMMISSION | 0 | 0 | 0 | 200 | 200 | 0
DAY OFF AWARD |  |  | 0 |  |  | 0
DBL TIME |  |  | 0 |  |  | 0
DISABILITY |  |  | 0 |  |  | 0
DRAW |  |  | 0 |  |  | 0
FLOATING HOLIDAY |  |  | 0 |  |  | 0
GTL (913) |  |  | 0 |  |  | 0
GTL |  |  | 0 |  |  | 0
HOLIDAY |  |  | 0 |  |  | 0
HOLIDAY OT |  |  | 0 |  |  | 0
INCENTIVE |  |  | 0 |  |  | 0
MNT |  |  | 0 |  |  | 0
MVT |  |  | 0 |  |  | 0
ON CALL |  |  | 0 |  |  | 0
HOLIDAY PREMIUM |  |  | 0 |  |  | 0
OTHER |  |  | 0 |  |  | 0
PERSONAL |  |  | 0 |  |  | 0
RETRO PAY |  |  | 0 |  |  | 0
RIDESHARE / PARKING |  |  | 0 |  |  | 0
SEVERANCE |  |  | 0 |  |  | 0
SF SICK |  |  | 0 |  |  | 0
SHIFT |  |  | 0 |  |  | 0
SHIFT OT |  |  | 0 |  |  | 0
SICK |  |  | 0 |  |  | 0
STD |  |  | 0 |  |  | 0
STO (Stock Opt Rest) |  |  | 0 |  |  | 0
STOCK |  |  | 0 |  |  | 0
SUPPLEMNTAL PAY |  |  | 0 |  |  | 0
TRAINING |  |  | 0 |  |  | 0
TRAVEL PAY |  |  | 0 |  |  | 0
VACATION |  |  | 0 |  |  | 0
GRAND TOTALS | 73 | 73 | 0 | 6183 | 6183 | 0
ADP GRAND TOTALS | 73 |  | -73 | 6183 |  | -6183