© 2009 Spreadsheet123.com. All rights reserved by Ken's Talk & Spreadsheet123.com http://www.spreadsheet123.com/ExcelTemplates/excel-payroll-2010.html http://abravermancan.com/forum/showthread.php
Employee List
# 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Fed W-4 State Allow Married? Exemp 1 1 2 3 4 5 6 7 8 9 10 Yes No Yes No No Yes No Yes No Yes Yes Yes 1 0 Exempt Exempt 3 4 5 6 7 8 9 10 Add'l State Exemp 0 1 2 3 4 0 1 2 3 4 0 1 0.0126 County Tax Rate 0.008 State IN CO TX OK MD IN CO VA DC VA DC TX Last Name Tesla Franklin Newton Howe Hasek Kahn Montana Kupowski Oppenheimer Szilard Von Braun Newman 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 First Name Nikola Ben Isaac Gordie Dominik Gengis Hannah Dupa Dr Rob Leo Werner Paul Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp Emp SS# 000-00-0000 001-01-0001 002-02-0002 000-00-0001 001-01-0002 002-02-0003 000-00-0002 001-01-0003 002-02-0004 000-00-0003 001-01-0004 002-02-0005
Disclaimer: This template is for educational purposes only. We do not guarantee the results. Use this template at your own risk. You should seek the advice of qualified professionals regarding your company payroll and other financial decisions.
2 Exempt
© 2009 Spreadsheet123.com. All rights reserved by Ken's Talk & Spreadsheet123.com http://www.spreadsheet123.com/ExcelTemplates/excel-payroll-2010.html http://abravermancan.com/forum/showthread.php
Period Ending
2/28/10
Choose Employee
PaulNewman
Newman SS #: Hours This Period Current Per Diem Expenses Current Period Commission Gross Pay: 401(k) Current TAXABLE GROSS: FED TAX: FICA: MM FICA STATE:TX Net Pay:
Paul 002-02-0005 35.00 0.00 0.00 4,340.00 0.00 4,340.00 306.33 269.08 62.93 0.00 3,701.66
PERIOD ENDING: Hourly Rate YTD Hours YTD Per Diem Expenses YTD Commission YTD Gross Pay: 401(k) YTD YTD TAXABLE: YTD FED TAX: YTD FICA: YTD MM FICA: YTD STATE:TX YTD Net Pay:
2/28/10 124 175.00 0.00 0.00 21,700.00 0.00 21,700.00 1,531.65 1,345.40 314.65 0.00 18,508.30
Disclaimer: This template is for educational purposes only. We do not guarantee the results. Use this template at your own risk. You should seek the advice of qualified professionals regarding your company payroll and other financial decisions.
Total Check/Deposit Amount
$
3,701.66
Newman SS #: Hours This Period Current Per Diem Expenses Current Period Commission Gross Pay: 401(k) Current TAXABLE GROSS: FED TAX: FICA: MM FICA STATE:TX Net Pay:
Paul 002-02-0005 35.00 0.00 0.00 4,340.00 0.00 4,340.00 306.33 269.08 62.93 0.00 3,701.66
PERIOD ENDING: Hourly Rate YTD Hours YTD Per Diem Expenses YTD Commission YTD Gross Pay: 401(k) YTD YTD TAXABLE: YTD FED TAX: YTD FICA: YTD MM FICA: YTD STATE:TX YTD Net Pay:
1/0/00 124 175.00 0.00 0.00 21,700.00 0.00 21,700.00 1,531.65 1,345.40 314.65 0.00 18,508.30
Total Check/Deposit Amount
$
3,701.66
State
Last Name
First Name
SS#
Additional Federal Tax Withheld
Period Hours 117.00 117.00 117.00 117.00 117.00 117.00 117.00 117.00 117.00 117.00 117.00 117.00 117.00
Hourly Rate Commission
401K %
Per Diem Actual Check Hourly Amount Rate
IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN IN
Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla Tesla
Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola Nikola
000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000
50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00 75.00
$
1,200.00
Form 941 for Period Ending --->
# 1 2 3 4 5 6 7 8 9 10 11 12 Employee Name NikolaTesla BenFranklin IsaacNewton GordieHowe DominikHasek GengisKahn HannahMontana DupaKupowski Dr RobOppenheimer LeoSzilard WernerVon Braun PaulNewman SS# 000-00-0000 001-01-0001 002-02-0002 000-00-0001 001-01-0002 002-02-0003 000-00-0002 001-01-0003 002-02-0004 000-00-0003 001-01-0004 002-02-0005 Gross Pay 5,850.00 960.00 100.00 2,730.00 1,342.00 50,000.00 360.00 2,900.00 7,280.00 1,027.00 4,340.00 Taxable Gross 5,850.00 960.00 100.00 2,457.00 1,342.00 50,000.00 360.00 2,900.00 7,280.00 1,027.00 4,340.00 Fed Tax 1,016.01 75.00 335.86 81.31 16,274.20 256.51 1,118.33 306.33
2/15/10
FICA 362.70 59.52 6.20 169.26 83.20 1,723.60 22.32 179.80 451.36 63.67 269.08 MM FICA 84.83 13.92 1.45 39.59 19.46 725.00 5.22 42.05 105.56 14.89 62.93 Total 941 Tax 1,911.07 221.88 15.30 753.56 286.63 21,171.40 55.08 700.21 2,232.17 157.12 970.35
Totals
11
Employees
$
76,889.00
$
76,616.00
$ 19,463.55
$
3,390.71
$
1,114.90
$
28,474.77
End Period Start Period
# Employee Name 1 NikolaTesla 2 BenFranklin 3 IsaacNewton 4 GordieHowe 5 DominikHasek 6 GengisKahn 7 HannahMontana 8 DupaKupowski 9 Dr RobOppenheimer 10 LeoSzilard 11 WernerVon Braun 12 PaulNewman
3/31/10 12/31/09
SS# 000-00-0000 001-01-0001 002-02-0002 000-00-0001 001-01-0002 002-02-0003 000-00-0002 001-01-0003 002-02-0004 000-00-0003 001-01-0004 002-02-0005
State Tax Reports
State IN CO TX OK MD IN CO VA DC VA DC TX Current Period State Tax $ 243.95 $ 41.00 $ $ $ 51.60 $ $ 1,118.00 $ $ 146.00 $ 375.19 $ 8.00 $ YTD State Tax $ 243.95 $ 41.00 $ $ $ 51.60 $ $ 1,118.00 $ $ 146.00 $ 375.19 $ 8.00 $ Errors?
0 Current Period State Tax $ 243.95 $ 41.00 $ $ $ 51.60 $ 31.46 $ 1,118.00 $ $ 146.00 $ 375.19 $ 8.00 $ -
# Employee Name 1 NikolaTesla 2 BenFranklin 3 IsaacNewton 4 GordieHowe 5 DominikHasek 6 GengisKahn 7 HannahMontana 8 DupaKupowski 9 Dr RobOppenheimer 10 LeoSzilard 11 WernerVon Braun 12 PaulNewman
SS# 000-00-0000 001-01-0001 002-02-0002 000-00-0001 001-01-0002 002-02-0003 000-00-0002 001-01-0003 002-02-0004 000-00-0003 001-01-0004 002-02-0005
State IN CO TX OK MD IN CO VA DC VA DC TX
YTD State Tax $ 1,707.65 $ 293.00 $ $ $ 361.20 $ 94.38 $ 9,170.00 $ $ 1,022.00 $ 2,626.33 $ 56.00 $ -
Errors?
0
Period Reports
Employee Name NikolaTesla BenFranklin IsaacNewton GordieHowe DominikHasek GengisKahn HannahMontana DupaKupowski Dr RobOppenheimer LeoSzilard WernerVon Braun PaulNewman SS# 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 000-00-0000 State IN CO TX OK MD IN CO VA DC VA DC TX YTD State Tax $ 1,463.70 $ 252.00 $ $ $ 309.60 $ 94.38 $ 8,052.00 $ $ 876.00 $ 2,251.14 $ 48.00 $ -
State
CO DC OK TX VA MD IN $ $ $ $ $
Max/yr
10,000 9,000 14,200 9,000 8,000
Rate
11.02% 6.20% 0.10% 0.10% 0.18%
# Name 1 NikolaTesla 2 BenFranklin 3 IsaacNewton 4 GordieHowe 5 DominikHasek 6 GengisKahn 7 HannahMontana 8 DupaKupowski 9 Dr RobOppenheimer 10 LeoSzilard 11 WernerVon Braun 12 PaulNewman 13 Emp13 14 Emp14 15 Emp15 16 Emp16 17 Emp17 18 Emp18 19 Emp19 20 Emp20 21 Emp21 22 Emp22 23 Emp23 24 Emp24 25 Emp25 26 Emp26 27 Emp27 28 Emp28 29 Emp29 30 Emp30 31 Emp31 32 Emp32
State for UI CO OK TX DC TX VA DC OK DC OK CO TX
Yr Tax Max 10,000 14,200 9,000 9,000 9,000 8,000 9,000 14,200 9,000 14,200 10,000 9,000 -
3/15 YTD Gross Q1 Wages Subject Pay to UI Tax -
Totals
$
-
$
-
Q1 UI Tax Due -
Q1 Excess NOT Subject to UI Tax -
6/15 YTD Gross Pay
Q2 Gross Wages -
UI Wages Remaining 10,000.00 14,200.00 9,000.00 9,000.00 9,000.00 8,000.00 9,000.00 14,200.00 9,000.00 14,200.00 10,000.00 9,000.00 -
Q2 UI Wages Subject to Tax -
$
-
$
-
$
-
$
-
$ 124,600.00
$
-
Q2 UI Tax Due -
Q2 Excess Wages -
9/15 YTD Gross Pay
Q3 Gross Wages -
UI Wages Remaining 10,000.00 14,200.00 9,000.00 9,000.00 9,000.00 8,000.00 9,000.00 14,200.00 9,000.00 14,200.00 10,000.00 9,000.00 -
Q3 UI Wages Subject to Tax -
$
-
$
-
$
-
$
-
$ 124,600.00
$
-
Q3 UI Tax Due -
Q3 Excess Wages -
12/15 YTD Gross Pay
Q4 Gross Wages -
UI Wages Remaining 10,000.00 14,200.00 9,000.00 9,000.00 9,000.00 8,000.00 9,000.00 14,200.00 9,000.00 14,200.00 10,000.00 9,000.00 -
Q4 UI Wages Subject to Tax -
$
-
$
-
$
-
$
-
$ 124,600.00
$
-
Q4 UI Tax Due -
Q4 Excess Wages -
$
-
$
-
Form 940 for 2010 Pick your Quarter or Year End Report -->
3) Total Payments to all Employees 4) Payments exempt from FUTA Tax 5) Total payments in excess of $7,000 6) Subtotal 7) Total FUTA Wages 8) FUTA Tax Before Adjustment Were all FUTA wages exempt from state UI? 9) Adj if wages are exempt from state UI 10) Some FUTA exempt? 11) Credit Reduction 12) Total FUTA tax after Adjustments 13) FUTA Deposited this year 14) Balance Due 15) Overpayment $ $ $ $ $ $ No $ -
1
Q1
# 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
Name
NikolaTesla BenFranklin IsaacNewton GordieHowe DominikHasek GengisKahn HannahMontana DupaKupowski Dr RobOppenheimer LeoSzilard WernerVon Braun PaulNewman Emp13 Emp14 Emp15 Emp16 Emp17 Emp18 Emp19 Emp20 Emp21 Emp22 Emp23 Totals
$ $ $
-
2
3
4
5
State for UI
3/15 YTD Gross Pay
$
-
Q1 Wages Subject to UI Q1 UI Tax Tax Due $ $ -
6 7 Q1 Excess Wages NOT Subject to UI 6/15 YTD Tax Gross Pay $ $ -
8
Q2 Gross Wages $ -
9
10
11
12
13
14
15
UI Wages Remaining 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 $ 224,000.00
Q2 UI Wages Subject to Q2 UI Tax Tax Due $ $ -
Q2 Excess Wages $ -
9/15 YTD Gross Pay
$
-
Q3 Gross Wages $ -
UI Wages Remaining 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 #########
16
17
18
19
20
21
22 Q4 UI Wages Subject to Tax $ -
Q3 UI Wages Subject to Q3 UI Tax Tax Due $ $ -
Q3 Excess Wages $ -
12/15 YTD Gross Pay
$
-
Q4 Gross Wages $ -
UI Wages Remaining 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 $ 224,000.00
23
24
25
Q4 UI Tax Due $ -
Q4 Excess Wages $ -
YR Excess Payments $ -
END-USER LICENSE AGREEMENT
For more Payroll Templates visit: Spreadsheet123.com © 2009 Spreadsheet123.com.All rights reserved
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made or distributed by Spreadsheet123.com. By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the terms of this EULA.
TEMPLATES LICENSE
This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. Each TEMPLATE is licensed, not sold.
1. GRANT OF LICENSE.
This EULA grants you the right to download the TEMPLATES free of charge for personal use or for your company use. You may customize this Payroll Template with you personal or company information and use it for your business requirements and with your employees but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use or other proprietary notices within the TEMPLATES. You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value without written permission of SPREADSHEET123.COM
2. TERMINATION.
Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.
3. NOTICE SPECIFIC TO TEMPLATES.
SPREADSHEET123.COM MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
4. MISCELLANEOUS.
Some states do not allow the limitation or exclusion of liability for incidental or consequential damages, so the above limitation may not apply to you.
cidental or consequential damages, so the above limitation may not apply to you.