Ns State Tax Table - Download as Excel

Document Sample
Ns State Tax Table - Download as Excel Powered By Docstoc
					                                                                                                                                                                                        021e9de5-74b8-4dd2-986e-f76bd7893085.xls


Net Pay Estimation for NC School Payroll Checks for Calendar Year                                                                                    2010                           Tables effective   1/1/2010

ESTIMATION FOR:                                Employee Name                                                                Soc. Sec #:              (Soc. Sec. No.)
GROSS PAY SUMMARY (PER MONTH INCOME):                                 SUBJECT TO                    Miscellaneous NON-TAX, NON-RETIREMENT Deductions:
LIST EACH GROSS PAY ITEM:                             AMOUNT          RETIREMENT?                   PRE-TAX PAYROLL DEDUCTIONS:                                                                             AMOUNT
Gross Pay Amount #1                               $            -     YES                                 Health Insurance Deduction #1                                                                 $               -
Gross Pay Amount #2                               $            -      YES                                Health Insurance Deduction #2                                                                 $               -
Gross Pay Amount #3                               $            -      YES                                Cafeteria Benefits Deduction #1                                                               $               -
Gross Pay Amount #4                               $            -      YES                                Cafeteria Benefits Deduction #2                                                               $               -
Gross Pay Amount #5                               $            -      YES                                Cafeteria Benefits Deduction #3                                                               $               -
Gross Pay Amount #6                               $            -      YES                                Tax-sheltered Annuity Deduction #1 *                                                          $               -
Gross Pay Amount #7                               $            -      YES                                Tax-sheltered Annuity Deduction #2 *                                                          $               -
TOTAL GROSS PAY                                   $            -                                         Tax-sheltered Annuity Deduction #3 *                                                          $               -
                                                                                                    SUBTOTAL PRE-TAX DEDUCTIONS………………..                                                                $               -
RETIREMENT DEDUCTION RATE:                                                  6.00%                   AFTER-TAX DEDUCTIONS (do not affect taxes withheld) :
                                                                                                         State Employees' Credit Union                                                                 $               -
                                                         ALLOWANCES CLAIMED                              United Way Gifts                                                                              $               -
FEDERAL TABLE CHOICE:     MARRIED                                                         4              Other After-Tax Deduction #1                                                                  $               -
PLUS EXTRA FEDERAL TAX TO BE WITHHELD:                                $               -                  Other After-Tax Deduction #2                                                                  $               -
                                                                                                         Other After-Tax Deduction #3                                                                  $               -
STATE TAX TABLE CHOICE:   MARRIED                                                         4              Other After-Tax Deduction #4                                                                  $               -
PLUS EXTRA STATE TAX TO BE WITHHELD:                                  $               -                  Other After-Tax Deduction #5                                                                  $               -
                                                                                                    SUBTOTAL AFTER-TAX DEDUCTIONS…………….                                                                              $0.00
EARNED INCOME CREDIT?                    NO (NOT FILING)                                            GRAND TOTAL NON-TAX, NON-RETIREMENT DED'NS……………………..                                                             $0.00
                                                                                                    * TSA's are sheltered from Federal & State Income Tax Only.
MAKE ALL DETAIL ENTRIES ABOVE THIS LINE

GROSS PAY SUBJECT TO RETIREMENT:                                                  $0.00             FEDERAL WITHHOLDING TAX TABLE USED:                                       MARRIED (MONTHLY)
                                                                                                    Value of EACH W-4 Allowance:                                                            $         304.17
FEDERAL TAXABLE SALARY:                                                                             UP TO AMT:      Flat Amount  Percentage                                    Taxable Amt.     Tax Amt.
Gross Pay..............................................................…………………
                                                                           $         -               $           1,146.00 $         -                0.0%                      $              -        $               -
                                                                                                     $           2,042.00 $         -               10.0%                      $              -        $               -
LESS:                                                                                                $           6,313.00 $       89.60             15.0%                      $              -        $               -
~Retirement Withheld @ 6% of Gross Pay.................        $                 -                   $           7,838.00 $     730.25              25.0%                      $              -        $               -
~Tax-Sheltered (PRE-TAX) Annuity Deductions:                   $                 -                   $        10,338.00 $     1,111.50              27.0%                      $              -        $               -
~Health Insurance Deductions…………………….                          $                 -                   $        12,088.00 $     1,786.50              25.0%                      $              -        $               -
~Cafeteria Benefits Deductions………………….                         $                 -                   $        18,083.00 $     2,224.00              28.0%                      $              -        $               -
                                                               $                 -                   $        31,783.00 $
Subtotal Taxable Salaries Before Allowances.....................................................................              3,902.60              33.0%                      $              -        $               -
                                                                                                     $ 999,999.00 $           8,423.60              35.0%                      $              -        $               -
~LESS FEDERAL TAX ALLOWANCE AMOUNT:                            $       1,216.68                     PLUS: ADDITIONAL FLAT AMOUNT FROM EMPLOYEE W-4:                                                    $               -
                                                                                                    TOTALS                                                                                 $0.00                    $0.00
EQUALS: (Must be equal to or greater than zero)                                                     (TAX equals (TAXABLE AMOUNT MINUS LOWER LIMIT) X PERCENT PLUS
FEDERAL Taxable Salary..............                                              $0.00             FLAT AMOUNT.)

STATE TAXABLE SALARY:                                                                               EARNED INCOME CREDIT TABLE FOR:                                           (NOT FILING)
                                                               $                 -                           UP
Subtotal Taxable Salaries Before Allowances..................................................................... TO AMT:            Flat Amount               Percentage        Qualifying Amt.              Tax Adj. Calc'n
                                                                                                     $               -       $                -                   0.000% $                    -        $               -
~LESS STATE TAX ALLOWANCES AMOUNT:                                     $         833.32              $               -       $                -                   0.000% $                    -        $               -
                                                                                                     $               -       $                -                   0.000% $                    -        $               -
EQUALS: (Must be equal to or greater than zero)                                                     TOTALS (CANNOT BE LESS THAN ZERO)                                                      $0.00                    $0.00
STATE Taxable Salary..............                                                $0.00
                                                                                                    STATE WITHHOLDING TAX TABLE USED:                     MARRIED (MONTHLY)
FICA/MEDICARE TAXABLE SALARY:                                                                       Income Limit for Change in Allowance Amount:                          $                                        4,166.67
Gross Pay......................................                        $             -              Value of ONE NC-4 Allowance:         (UNDER Income Limit Value)       $                                          208.33
                                                                                                         UP TO AMT:          Flat Amount       Percentage    Taxable Amt.                                          Tax Amt.
LESS FICA-EXEMPT DEDUCTIONS:                                                                         $        250.00                                                0.00%      $              -        $               -
~Health Insurance Contributions                                        $             -               $      1,135.42         $             15.00                    6.00%      $              -        $               -
~Cafeteria Benefits TOTAL                                              $             -               $      4,416.67         $             26.35                    7.00%      $              -        $               -
                                                                                                     $    999,999.00         $             59.48                    7.75%      $              -        $               -
FICA/Medicare Taxable Salary...........                                           $0.00            PLUS: ADDITIONAL FLAT AMOUNT FROM EMPLOYEE NC-4:                                                    $               -
                                                                                                    TOTALS                                                                                 $0.00                    $0.00
(Calculation assumes that FICA YTD maximum has NOT yet been reached.)                               (TAX equals (TAXABLE AMOUNT X PERCENT) MINUS FLAT AMOUNT.)
CURRENT FICA MAXIMUM SUBJECT TO TAX:               $ 106,800.00
                                                                                                    FICA/MEDICARE TAX CALCULATION:
                                                                                                    FICA Tax Rate:                                          6.20% $                                                    -
                                                                                                    Medicare Tax Rate:                                      1.45% $                                                    -
                                                                                                    TOTAL Tax Rate Applied:                                 7.65%
                                                                                                    TOTAL FICA/Medicare Deduction (Taxable Amt Shown at left):                                                      $0.00
NET PAY ESTIMATION FOR THIS PAYROLL CHECK:
                                GROSS PAY              RETIREMENT             FICA/MDCR                        FED'L TAX               STATE TAX           PRE-TAX DED'S            OTHER DED'S                     NET PAY

                                    $0.00                 $0.00                  $0.00                           $0.00                    $0.00                    $0.00                  $0.00                    $0.00
DISCLAIMER: This NET PAY ESTIMATE only APPROXIMATES the results you may expect when the factors shown above are used by the school district's
payroll computer to calculate payroll checks. Small variations may occur in tax calculations due to rounding and other computing considerations. We
recommend that you consult with your tax preparation professional before making any significant changes to your Federal or State withholding allowances.


              This NET PAY ESTIMATION Prepared By:                                            Payroll Department                                                                          Date:             22-Nov-10

                   Source: Winston-Salem/Forsyth County Schools, NC. Permission is granted to use this tool "as is" and to make unlimited copies of this file provided that it is made available free of charge.
                                                                                                 Fed & State Tax & EIC Tables




TAX TABLES USED IN THE WORKSHEET CALCULATIONS
(Make your changes here for the worksheet on the previous tab.)
IMPORTANT: TYPE IN ALL VALUES - DO NOT COPY & PASTE OR MOVE VALUES. FORMULAS MAY BE MADE INACCURATE.


                                                                              TAX TABLES BELOW ARE FOR:                          2010             EFFECTIVE:                        January 1, 2010
FEDERAL TAX TABLES                                                                                                                                               (type in with leading apostrophe)
MONTHLY PAYROLL PERIOD
FEDERAL TAX TABLES PER CIRCULAR E:                      VALUE OF A SINGLE ALLOWANCE:                           $    304.17

A: SINGLE PERSON (INCLUDING HEAD OF HOUSEHOLD)                                B: MARRIED PERSON

"BUT NOT OVER" COLUMN:           DOLLAR VAL             PERCENT               "BUT NOT OVER" COLUMN:                         DOLLAR VAL           PERCENT
                         $504                  $0.00               0%                              $1,146                                 $0.00             0%
(leave blank)                                                                 (leave blank)
                      $869                       $0              10%                              $2,042                                   $0           10%
                     $3,004                     $37              15%                              $6,313                                  $90           15%
                     $5,642                   $357               25%                              $7,838                                $730            25%
                     $7,038                  $1,016              27%                             $10,338                               $1,112           27%
                     $7,308                  $1,393              30%                             $12,088                               $1,787           25%
                    $14,492                  $1,474              28%                             $18,083                               $2,224           28%
                    $31,308                  $3,486              33%                             $31,783                               $3,903           33%
                   $999,999                  $9,035              35%                            $999,999                               $8,424           35%



FEDERAL "EIC PAYMENT" TABLES PER CIRCULAR E:

A: SINGLE PERSON OR HEAD OF HOUSEHOLD                                         B: MARRIED WITHOUT SPOUSE FILING CERTIFICATE                                       C: MARRIED WITH BOTH SPOUSES FILING CERTIFICATE

"BUT NOT OVER" COLUMN:           DOLLAR VAL             PERCENT                                    DOLLAR VAL PERCENT
                                                                              "BUT NOT OVER" COLUMN:                                                             "BUT NOT OVER" COLUMN:                 DOLLAR VAL PERCENT
                       $747                   $0.00         20.40%                  $747                             $0.00             20.40%                                                    $373       $0.00             20.40%
                      $1,370                $152.00          0.00%                 $1,788                          $152.00              0.00%                                                    $894      $76.00              0.00%
OVER FIGURE                                 $152.00        -9.588% * OVER FIGURE                                   $152.00            -9.588% *                  OVER FIGURE                               $76.00            -9.588% *
SHOWN ABOVE:                                            (LESS FROM    SHOWN ABOVE:                                           (LESS FROM                          SHOWN ABOVE:                                       (LESS FROM
                                                        EXCESS WAGES)                                                        EXCESS WAGES)                                                                          EXCESS WAGES)

* MUST BE ENTERED AS NEGATIVE FIGURE                                          * MUST BE ENTERED AS NEGATIVE FIGURE                                               * MUST BE ENTERED AS NEGATIVE FIGURE




                                                                                                                                                                 MAXIMUM SOC SECURITY
STATE TAX TABLES                                                                                                                                                 EARNINGS FIGURE FOR

                                                                                                                                                                               2010
MONTHLY PAYROLL PERIOD           SINGLE
                                                                                                                                                                  $                106,800.00
If the wage in excess of allowance amount is:   St Tx w/h is
OVER                               BUT NOT OVER OF SUCH WAGE FROM PRODUCT

$                       -    $           250.00                               $                         -
$                    250.00 $          1,312.50                  6% less $                           15.00
$                  1,312.50 $          5,250.00                  7% less $                           28.13
$                  5,250.00 $       999,999.00              7.75% less $                             67.51
$                999,999.00 --------------------------------------------------------------------------------


MONTHLY PAYROLL PERIOD           HEAD OF HOUSEHOLD

If the wage in excess of allowance amount is:   St Tx w/h is
OVER                               BUT NOT OVER OF SUCH WAGE FROM PRODUCT

$                       -    $           366.67                               $                         -
$                    366.67 $          1,783.33                  6% less $                           22.00
$                  1,783.33 $          7,033.33                  7% less $                           39.83
$                  7,033.33 $       999,999.00              7.75% less $                             92.58
$                999,999.00 --------------------------------------------------------------------------------


MONTHLY PAYROLL PERIOD           MARRIED PERSON OR QUALIFYING WIDOW(ER)

If the wage in excess of allowance amount is:   St Tx w/h is
OVER                               BUT NOT OVER OF SUCH WAGE FROM PRODUCT

$                       -    $           250.00                               $                         -
$                    250.00 $          1,135.42                  6% less $                           15.00
$                  1,135.42 $          4,416.67                  7% less $                           26.35
$                  4,416.67 $       999,999.00              7.75% less $                             59.48
$                999,999.00 --------------------------------------------------------------------------------




                                                                                                               Page 2

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:29
posted:11/22/2010
language:English
pages:2
Description: Ns State Tax Table document sample