Week groups link 0 1 2 3 4 5 6 7 8 0.009 YEARLY QUARTER
10 11 12 13 CURRENCY PLANE 1
0.00 1/4 EQUALS 0 WEEKS PAYROLL HOUR INVENTORY PLANE Calendar setting 2
Week No►. 0 of 52 WEEKS Weeks remaining cell► 52 Pay Location Queens ◄Week addition► 1 0 3
Hide and unhide 1 2 3
0 MARITAL STATUS4 5 6 8
7 2010 US 9FICA10 11
TAX IRS 13
12 CALCULATOR
Employee address MARITAL STATUS► HEAD OF HOUSEHOLD CLAIM 1 3,700 Employer address 8
Name MIKE RIVERS SINGLE JOURNAL EXAMPLE Employee ELIUD ORTIZ 9
Address 111-10 ROCKAWAY BEACH BLVD Employee ID =Tel. (718) 000- 1111.01 ID 109-18 98TH ST. 10
ROCKAWAY PARK, NY 11604 Add and Subtract Maritime unit as require OZONE PARK, NY 11417 11
Email 0 TIME SCHEDULE 0.01 eliud@eliudortiz.com 12
Tele. (718) 000- 1111 Pay Date ► 12/25/10 718-845-5075 13
0 $3,700.00 $0.00 $0.00 1 AM AM LUNCH TOTAL Automatic F and S tax This week & YTD 14
Date 12/19/10 NAME IN OUT OUT IN DURATION worked Hour Rate S. Security Income earned columns 15
Sun 12/19 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 0.00 0.00 0.1040 #DIV/0! 0.00 0.00 16
Mon 12/20 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 8.00 0.00 0.0290 0.0000 0.00 0.00 17
Tue 12/21 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 8.00 0.00 Long term capital gain 0.00 0.00 18
Wed 12/22 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 8.00 0.00 0.0097 0.0000 0.00 0.00 19
Thu 12/23 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 8.00 0.00 0.0000 0.0000 0.00 0.00 20
Fri 12/24 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 8.00 0.00 0.0000 0.0000 0.00 0.00 21
Sat 12/25 MIKE RIVERS 9.00 6.00 12.00 13.00 1.00 8.00 0.00 0.0000 0.0000 0.00 0.00 22
WEEKLY EXEMPTION DISTRIBUTION AMONG ID WEEKLY DEDUCTION TAX AFTER HOURS ID NET TAX BEFORE %----ID GROSS PAID 23
EMPLOYEES Allowance Deduction YTD Quarterly allowance Reg/Otime PAID allowance ADD---Weekly and Up to date 24
Week 0.4248 1.0000 0.5752 0.00 0.00 0.00 0.00 0.00 25
Total Weekly remain
Claims YTD exemption der
YTD 0.00 0.00 0.00 0.00 0.00 0.00 0 0.0097 ◄LTCG 26
exemption exemption 10g: remaining
27b distributed 39 0.00 0.00 0.00 0.00 40.00 0.00 0.00 #DIV/0! 0 0.00 27
29b 40a Count exemption:
down . to 0.00 0.00 0.00 0.00 8.00 0.00 0 0.1330 0 0.00 28
distribute.
0 0.00 0.00 0.00 52 0.00 0.00 0.00 0.00 0.00 48.00 0.00 0 #DIV/0! 0 0.00 29
Hide or unhide Auto- 0.00 0 1 2
71.15 3 ◄Employee exemption allowance
4 5 6 7 8 9 10 11 12 13
CHECK MADE TO THE ORDER OF 1st starting point cell A13. 30
made check as ◄YTD exemption distributed 39 Exemption number 27a: Enter family size
0.00 0.00 Internal Revenue Service 31
indicated in the hide number including you self. Warning! If employer
and unhide link 0.00 71.15 ◄Remaining or tax return Account► 12345678901 32
is distributing exemptions stop entering claim
For salary► MIKE RIVERS Four hundreds ninety-six dollars********************* and43/100 $0.00 33
when the "ID net paid" becomes greater (Over
For IRS MIKE RIVERS One thousand two hundred thirty-one dollars*** and 46/100 $0.00 34
35
2011 US FICA TAX IRS CALCULATOR 36
0 1 2 3
Calculate tables4 5 7 8 10 11 12 13
6 EMPLOYEE/ER9SHARE TAX PERCENTAGE FINDER TABLE FOR
IRS PAY DATE'S
Hide and unhide Weeks Date's Amount…….Weekly and Up to date
Week Date finder Calendar FEDERAL INSURANCE CONTRIBUTION TAX ACT (FICA) 1-13 3/26/11 0 0.00 0.00
Sun Mon Tue Wed Thu Fri Sat FICA Percent ross salary nnual Tax %tage decimal 1.0000
G A % splitter 14-26 6/25/11 0 0.00 0.00
3/20 3/21 3/22 3/23 3/24 3/25 3/26 0.1330 27,040 3,596.16 0.5751 ◄Employer share 27-39 9/24/11 0 0.00 0.00
Weeks Find IRS pay day 1/4 in terns or weeks X Employee half► 1528.00 0.4249 ◄Employee allowance 40-52 12/24/11 0 0.00 0.00
13 12/26/10 3/20/11 91 7 Annual payment► 0 0.00 0.00
Hide and unhide Verified by addition and multiplication
By addition►►
TRACKING THIS
0.00 0.00 0.00 0.00 0.00 48.00 0.00 0 #DIV/0! 0.00 0.00
THIS WEEK
TRACKING
WEEK ERROR
ERROR
Tracking for this week error►► 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #DIV/0! #DIV/0! 0.00 0.00
1 2 3 4 5 6 8 9 10------------11------------12
By multiplication and division► 0.00 0.00 0.00 0.00 0.00 48.00 0.00 #DIV/0! #DIV/0! 0.00 0.00
Hide and unhide Yearly Quarters
Fallow quarters weekly links
24/7 PAYROLL
First yearly quarter
0 1 2 3 4 5 6
7 8 9 10 11 12 13
Example of yearly quarter folders. 24/7 Ex.
Second yearly quarter
0 14 15 16 17 18 19
20 21 22 23 24 25 26
Example of yearly quarter folders. 24/7 Ex.
Third yearly quarter
0 27 28 29 30 31 32
33 34 35 36 37 38 39
Example of yearly quarter folders. 24/7 Ex.
Fourth yearly quarter
0 40 41 42 43 44 45
46 47 48 49 50 51 52
Example of yearly quarter folders. 24/7 Ex.
Hide and unhide link Protect W-2 form Print instruction
MIKE RIVERS ID 0.01
Employee Social security b employer Identification
a number number (EIN)
OMB Number
222-00-4444 10-2368971 1545-0006
1 Wages, tips other composition
c Employer's name address and zip code
0.00
ELIUD ORTIZ 3 Social Security wages
109-18 98TH ST. 0.00
OZONE PARK, NY 11417 5 Wages, tips other composition
0.00
7 Social Security tips
9 Advance EIC payments
d Control Number
Employee's first name middle initial and last 11 Nonqualified plan
e name
MIKE RIVERS 13 Statuary Retirement
Employee plan
111-10 ROCKAWAY BEACH BLVD 401k
ROCKAWAY PARK, NY 11604 14 Other
15 State Employer's state ID number 17 State
16 State wages, tip, etc. income tax 18 local wage's, tip, etc.
Wage and tax Copy B-To be filed With Employee's FE
Form W-2 Statement 2011 This information is being furnished to the In
Hide and unhide calendar table's Weeks Date;s Quarterly
Week Date finder Calendar 13 3/26/11 0.00
Sun Mon Tue Wed Thu Fri Sat 26 6/25/11 0.00
3/20 3/21 3/22 3/23 3/24 3/25 3/26 39 9/24/11 0.00
Weeks Find IRS pay day 1/4 in terns or weeks 0 52 12/24/11 0.00
13 12/26/10 3/20/11 91 7 0 Annual payment► 0.00
Week addition► 1 0
Safe accurate Visit the IRS AT
FAST Use www.irs.gov/file
http://www.irs.gov/file
on 2 Federal income tax withheld
0.00 0.00
4 Social Security tax withheld
0.00 0.00
on 6 Medicare tax withheld
0.00 0.00
8 Allocated tip
10 Dependent care benefits
12a code See instruction for box 12
Third-party 12b code
sick pay
0.00
12c code
12d code
0.00
18 local wage's, tip, etc. 19 Local income tax 20 Locality name
be filed With Employee's FEDERAL Tax Return.
on is being furnished to the Internal Revenue Service.
Quarterly Weekly Up to date
IRS PAY DATE'S
0.00 0.00 0.00 0
0.00 0.00 0.00 0
0.00 0.00 0.00 0
0.00 0.00 0.00 0
0.00 0.00 0.00 0
Hide and unhide link Print instruction
ID WEEKLY DEDUCTION
WEEKLY EXEMPTION DISTRIBUTION AMONG EMPLOYEES
Allowance Deduction YTD
Week 0.4248 1.0000 0.5752
Total remain YTD
YTD exemption Weekly der
0.00 0.00
Claims 27b exemption remaining
distributed 39 exemption 40a 10g: exemption: to 0.00 0.00
29b
Count distribute. 0.00 0.00
0 0.00 0.00 0.00 down .
52 0.00 0.00 0.00
PAID LOCATION Queens 0 0 12/25/10
109-18 98TH ST. Quarter Week Pay Date
OZONE PARK, NY 11417
Email eliud@eliudortiz.com
Tele 718-845-5075 Pay to the order of MIKE RIVERS
BANK NAME AND LOGO NAME
۩
Queens Community Bank
Address Four hundreds ninety-six dollars******************
108-05 ROCKAWAY BEACH BLVD. AMOUNT
ROCKAWAY PARK NY 11694
Email 0
Tele. 0 12345678901
ACCOUNT
MIKE RIVERS
2010 US FICA TAX
ID WEEKLY DEDUCTION
WEEKLY EXEMPTION DISTRIBUTION AMONG EMPLOYEES
Allowance Deduction YTD
Week 0.4248 1.0000 0.5752
Total remain
YTD exemption Weekly der YTD 0.00 0.00
Claims 27b exemption remaining
distributed 39 exemption 40a 10g: 0.00 0.00
29b Count exemption: to
distribute.
down . 0.00 0.00
0 0.00 0.00 0.00 52 0.00 0.00 0.00
Tax payer name MIKE RIVERS
PAID LOCATION Queens 0 0 12/25/10
109-18 98TH ST. Quarter Week Pay Date
OZONE PARK, NY 11417
Email eliud@eliudortiz.com
Tele 718-845-5075 Pay to the order of Internal Revenue Serv
BANK NAME AND LOGO NAME
۩
Queens Community Bank
Address One thousand two hundred thirty-one dollars
108-05 ROCKAWAY BEACH BLVD. AMOUNT
ROCKAWAY PARK NY 11694
Email 0.00
Tele. 0.00 12345678901
ACCOUNT
Internal Revenue Service
2010 US FICA TAX
Hide and unhide Calculate tables Weeks Date's Amount
Week Date finder Calendar 1-13 3/26/11 0
Sun Mon Tue Wed Thu Fri Sat 14-26 6/25/11 0
3/20 3/21 3/22 3/23 3/24 3/25 3/26 27-39 9/24/11 0
Weeks Find IRS pay day 1/4 in terns or weeks X 40-52 12/24/11 0
13 12/26/10 3/20/11 91 7 Annual payment► 0
0 0 0.0000 0.0000 0 0 0 0.00 0.00 0.00
Week addition► 1 0
DEDUCTION TAX AFTER HOURS 0 %----ID GROSS PAID
ID NET
Quarterly allowance Reg/Otime 0 PAID ADD---Weekly and Up to date
0.00 0.00 0.00 0 0.00 0.00
0.00 0.00 0.00 0 0.00 ◄LTCG
0.00 0.00 40.00 0 0.00 0.00 0.00
0.00 0.00 8.00 0 0.00 0 0.00
0.00 0.00 48.00 0 0.00 0 0.00
WEEKLY TAX RATE
12/25/10 1111.01
Pay Date Check No. 0.0012 Social Security
0.0003 Medicare
#VALUE! Other
MIKE RIVERS 0.0002 Long Term Capital gain (LTCG)
0.0000 Other
0.0000 Other
0.0000 Other
six dollars*********************
and43/100 0.00 #DIV/0! Earned income tax: (EIT)
0.0000 Other
0.0000 Other
0.0000 Other
0.0000 Other
0.0000 Other
0.0000 Other
IRS CALCULATOR
DEDUCTION TAX AFTER HOURS 0 ID NET %----ID GROSS PAID
Quarterly allowance Reg/Otime 0 PAID ADD---Weekly and Up to date
0.00 0.00 0.00 0 0.00 0.00
0.00 0.00 0.00 0 0.00 ◄LTCG
0.00 0.00 40.00 0 0.00 0.00 0.00
0.00 0.00 8.00 0 0.00 0 0.00
0.00 0.00 48.00 0 0.00 0 0.00
WEEKLY TAX RATE
12/25/10 1111.01
Pay Date Check No. 0.0012 Social Security
0.0003 Medicare
#VALUE! Other
Internal Revenue Service 0.0002 Long Term Capital gain (LTCG)
0.0000 Other
0.0000 Other
0.0000 Other
undred thirty-one dollars*** 46/100 $0.00
and #DIV/0! Earned income tax: (EIT)
0.0000 Other
0.0000 Other
0.0000 Other
0.0000 Other
0.0000 Other
0.0000 Other
IRS CALCULATOR
IRS PAY DATE'S
Weekly Up to date 0
0.00 0.00 0
0.00 0.00 0
0.00 0.00 0
0.00 0.00 0
0.00 0.00 0
0.0000 0
MARITIME TABLE Use the maritime table to convert regular minutes to maritime minutes; simply, "Copy and
Regular Maritime Paste" the mertime decimal to the cell in process.
Minutes hour Minutes
If you go out for lunch at 12.00 O’clock us the maritime hour to configure the time out
1 13.00 0.02 duration. For example 13.00 minus 12.00 equal 1.00.
2 14.00 0.03
3 15.00 0.05 Now you don’t have to round of every fifteen minutes as in the previous system to
4 16.00 0.07 configure an accurate payroll.
5 17.00 0.08
6 18.00 0.10 Use the maritime hour when working around the clock; for axample, from 9 to 9 equals
7 19.00 0.12 9 to 21
8 20.00 0.13
9 21.00 0.15
10 22.00 0.17
11 23.00 0.18
12 24.00 0.20
13 0.22
14 0.23
15 0.25
16 0.27
17 0.28
18 0.30
19 0.32
20 0.33
21 0.35
22 0.37
23 0.38
24 0.40
25 0.42
26 0.43
27 0.45
28 0.47
29 0.48
30 0.50
31 0.52
32 0.53
33 0.55
34 0.57
35 0.58
36 0.60
37 0.62
38 0.63
39 0.65
40 0.67
41 0.68
42 0.70
43 0.72
44 0.73
45 0.75
46 0.77
47 0.78
48 0.80
49 0.82
50 0.83
51 0.85
52 0.87
53 0.88
54 0.90
55 0.92
56 0.93
57 0.95
58 0.97
59 0.98
60 1.00
ritime minutes; simply, "Copy and
hour to configure the time out
in the previous system to
or axample, from 9 to 9 equals
Protect W-2 form
When filing electronically
Use: "What's my mother's maiden last name" to open
columns A through E to reveal key word question
to password protect employee and employer (ID)
identification number.