2010 W 2 Employee Forms - Excel

W
Description

2010 W 2 Employee Forms document sample

Shared by: pxy16519
-
Stats
views:
34
posted:
11/30/2010
language:
English
pages:
15
Document Sample
scope of work template
							                                                    General Directions

Hello,

Welcome to the new 2010 Quarterly Withholding Fees and Annual Reconciliation report. As you may be aware the State
Law now requires an "Annual Reconciliation". In order to make this process easier, this Excel spreadsheet and a PDF
version was developed to assist you in meeting State reconciliation of withholdings.

If using the EXCEL version:
There are tabs at the bottom labeled as follows: Directions, Annual Reconciliation, Qtr 1, Qtr 2, Qtr 3, Qtr 4, Employee List
Annual Recon and Variables (used for calculations). Only the cells hi-lighted in green will accept information. All other
cells are titles or formulas that calculate the amounts entered.

The tab labeled “Annual Reconciliation” allows for entering withholdings for each quarter in Section A, then it is totaled
and automatically posted to Section B (below Section A). All company and contact information is entered once. It is then
automatically posted to the other similar cells. To print all pages in this file (all tabs below), select File (in the menu line),
select Print, select Entire Workbook (in lower corner), select Preview or Print.

If using the PDF version:
Note that the PDF version is only a blank form requiring data to be hand printed on to the forms. The form titled “2010
Annual Reconciliation” is 2 pages (Section A & B). Withholdings for each quarter must be entered in Section A, then total
and post to Section B (below Section A). Enter company, contact information and be sure to enter your Kenton County
Account number.... if you do not know it or need help (call 859-392-1440).

 Due Dates: 1st Quarter due 04/30, 2nd Quarter due 07/31, 3rd Quarter due 10/31 and 4th Quarter due 01/31. The Annual
Reconciliation is due on February 28 of the following year and must include a detailed employee listing with all W-2
information.

Be sure to double check calculations as you are responsible for the accuracy of the reports.

Thank you,




  11/30/2010                    d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Directions                                             1
                                                          General Directions

    INSTRUCTIONS FOR ANNUAL RECONCILIATION OF EMPLOYER QUARTERLY
                             WITHHOLDING

GENERAL INFORMATION:
Each employer shall on or before February 28 of each year complete and file an Annual Reconciliation of Employer
Quarterly Withholding. Provide a detailed employee listing with equivalentW-2 information. All employers must file
this Annual Reconciliation regardless of when their payroll ceased during the year.

Required information: Business Name, Address, Kenton County Tax Account Number and Federal Employer
Identification Number or Social Security Number. Preparer and Owner shall sign and date the reconciliation and provide
his/her title and contact information.

HOW TO RECONCILE YOUR PAYROLL AND WITHHOLDINGS:

SECTION A
      Enter the total “Payroll Withholding Fees” paid for each quarter of the tax year for each entity.

SECTION B
      COLUMN 2: Titled “W2 Gross Earnings per Entity.” Enter the total gross earnings for all employees for
      Kenton County and each City.

          COLUMN 3: Titled “Amount Earnings More than FICA Cap.” Enter the earnings paid to employees in
          excess of the FICA Cap per Individual for each employee for the calendar year.

          COLUMN 4: Titled “Amount Earnings Outside Kenton County.” Enter the earnings paid to employees
          earned outside of Kenton County.

          COLUMN 5: Titled “Total Taxable Earnings” If using the spreadsheet in Excel, it will automatically calculate
          the amount. (Column 2 minus Column 3 and Column 4) This is the amount of earnings subject to tax.

          COLUMN 6: Titled “Tax Rate” is rate per entity.

          COLUMN 7: Titled “WITHHOLDING FEES DUE.” If using the spreadsheet in Excel, it will automatically
          calculate the amount. Multiply the result in column 5 (Total Taxable Earnings) times payroll withholding rate for
          Kenton County and each City.

          COLUMN 8: Titled “TOTAL FEES REMITTED FOR TAX YEAR.” If using the spreadsheet in Excel, it will
          automatically post the amounts from Section A. Or enter the result from Section A for Kenton County and each
          City.

          COLUMN 9: Titled “Fees Remitted minus Fees Due.” If using the spreadsheet in Excel, it will automatically
          post at the bottom of column 9 the calculated total….if blank, then the wording “No Adjustment Due” will be
          under the cell. However if the wording “Attach Payment” is at the bottom of column 9; send payment to address
          below. (No payment necessary if balance due is less than $5.00).

                     No refunds or credit will result from entries made on this form. Submit a copy of the original
                     quarterly return, marked “Amended Return” and show the corrected withholding amounts, for any
                     quarter that has been overpaid. Call the occupational license office with questions.

REQUIRED: The preparer and owner shall sign the report and include a detailed employee listing with equivalent W-2 information
along with any remittance to:

                     KENTON COUNTY FISCAL COURT
                     Occupational License Office
                     303 Court St Rm207
                     Covington KY 41011

If you have questions about the forms and instructions, contact:
         Kenton County Fiscal Court
         Occupational License Office
         303 Court St Room 207
         Covington KY 41011

Phone: (859) 392-1440 Fax: (859) 392-1459
(All tax forms are available at http://www.kentoncounty.org/county_departments/county_finance/occupational_license/index.html )




    11/30/2010                      d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Directions                                      2
                                              Kenton County and Cities, Kentucky
                                                       Employees' Quarterly Withholding
Business Name:                                                      DBA:                                          Acct #      Quarter       Year
Mailing Address:                                                 Address:                                                          1        2010
           City:                                                    City:                                         Federal Employer ID or SSN #
          State:                                                   State:
            Zip:                                                     Zip:                                               Accessed Date       11/30/10
                                                                                                                              Date Due      04/30/10

              1                2                     3             4                5                6                  Official Use Only
                                                 Excluded        Subject
  City or County       Total Earnings                                           Tax Rate
                                                 Earnings       Earnings                      Fee Due                       Rec. Date
Kenton County
first $25,000                                                            -      0.007097                 -
Kenton County
over $25,000                                                             -      0.001097                 -
Bromley                                                                  -      0.010000                 -   ADJ              AM         CT1A
Covington                     MUST FILE COVINGTON TAX DIRECT WITH THE CITY OF COVINGTON.                     EL               EM         OOB

Crescent Springs                                                         -      0.010000                 -   PI               RAE        TERM
Crestview Hills                                                          -      0.010000                 -
Edgewood                                                                 -      0.010000                 -
Elsmere                                                                  -      0.012500                 -
Erlanger                                                                 -      0.010000                 -
Fort Mitchell                                                            -      0.010000                 -
Fort Wright                                                              -      0.010000                 -
Independence                                                             -      0.012500                 -
Lakeside Park                                                            -      0.010000                 -        Refer to Instructions for
                                                                                                                   Penalty and Interest
Ludlow                                                                   -      0.015000                 -
                                                                                                                       Assessment.
Park Hills                                                               -      0.010000                 -
Taylor Mill                                                              -      0.020000                 -        Penalty
Villa Hills                                                              -      0.010000                 -     Interest
                                                                                                              Amount w/
                                                                                                              Penalty &
                                                                   Total Fee Due                         -     Interest

                                                              # Employees
   # Employees             Employee Wage Range
                                                              Next Quarter
                                    $25,000 or less                            Must include employee list.
                             $25,001 up to the FICA Cap
                                More than FICA Cap
                  -   Total Employees                                    -     Projected Employees

      Preparer                     Phone:                                        E-mail:
    Information                     Title:                             Date:                Print Name:
I declare under penalty of perjury that this return has been examined by me and to the
best of my knowledge and belief is true, correct and a complete return.                     Signature: Stop! Must Enter Acct #
       Owner                       Phone:                                        E-mail:
    Information                     Title:                             Date:               Print Name:
Sign Completed Form and Remit to:
Kenton County Fiscal Court                                                                  Signature: Stop! Must Enter Acct #
PO BOX 643966
CINCINNATI OH 45264-3966
                                                              Stop! Must Enter Acct #

         11/30/2010; 1:08 PM                 d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Qtr 1                                            3
                                              Kenton County and Cities, Kentucky
                                                       Employees' Quarterly Withholding
Business Name:                                                      DBA:                                          Acct #      Quarter       Year
Mailing Address:                                                 Address:                                                          2        2010
           City:                                                    City:                                         Federal Employer ID or SSN #
          State:                                                   State:
            Zip:                                                     Zip:                                               Accessed Date       11/30/10
                                                                                                                              Date Due      07/31/10

              1                2                     3             4                5                6                  Official Use Only
                                                 Excluded        Subject
  City or County       Total Earnings                                           Tax Rate
                                                 Earnings       Earnings                      Fee Due                       Rec. Date
Kenton County
first $25,000                                                            -      0.007097                 -
Kenton County
over $25,000                                                             -      0.001097                 -
Bromley                                                                  -      0.010000                 -   ADJ              AM         CT1A
Covington                     MUST FILE COVINGTON TAX DIRECT WITH THE CITY OF COVINGTON.                     EL               EM         OOB

Crescent Springs                                                         -      0.010000                 -   PI               RAE        TERM
Crestview Hills                                                          -      0.010000                 -
Edgewood                                                                 -      0.010000                 -
Elsmere                                                                  -      0.012500                 -
Erlanger                                                                 -      0.010000                 -
Fort Mitchell                                                            -      0.010000                 -
Fort Wright                                                              -      0.010000                 -
Independence                                                             -      0.012500                 -
Lakeside Park                                                            -      0.010000                 -        Refer to Instructions for
                                                                                                                   Penalty and Interest
Ludlow                                                                   -      0.015000                 -
                                                                                                                       Assessment.
Park Hills                                                               -      0.010000                 -
Taylor Mill                                                              -      0.020000                 -        Penalty
Villa Hills                                                              -      0.010000                 -     Interest
                                                                                                              Amount w/
                                                                                                              Penalty &
                                                                   Total Fee Due                         -     Interest

                                                              # Employees
   # Employees             Employee Wage Range
                                                              Next Quarter
                                    $25,000 or less                            Must include employee wage list.
                             $25,001 up to the FICA Cap
                                More than FICA Cap
                  -   Total Employees                                    -     Projected Employees

      Preparer                     Phone:                                        E-mail:
    Information                     Title:                             Date:                Print Name:
I declare under penalty of perjury that this return has been examined by me and to the
best of my knowledge and belief is true, correct and a complete return.                     Signature: Stop! Must Enter Acct #
       Owner                       Phone:                                        E-mail:
    Information                     Title:                             Date:               Print Name:
Sign Completed Form and Remit to:
Kenton County Fiscal Court                                                                  Signature: Stop! Must Enter Acct #
PO BOX 643966
CINCINNATI OH 45264-3966
                                                              Stop! Must Enter Acct #

         11/30/2010; 1:08 PM                 d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Qtr 2                                            4
                                              Kenton County and Cities, Kentucky
                                                       Employees' Quarterly Withholding
Business Name:                                                      DBA:                                          Acct #      Quarter       Year
Mailing Address:                                                 Address:                                                          3        2010
           City:                                                    City:                                         Federal Employer ID or SSN #
          State:                                                   State:
            Zip:                                                     Zip:                                               Accessed Date       11/30/10
                                                                                                                              Date Due      10/31/10

              1                2                     3             4                5                6                  Official Use Only
                                                 Excluded        Subject
  City or County       Total Earnings                                           Tax Rate
                                                 Earnings       Earnings                      Fee Due                       Rec. Date
Kenton County
first $25,000                                                            -      0.007097                 -
Kenton County
over $25,000                                                             -      0.001097                 -
Bromley                                                                  -      0.010000                 -   ADJ              AM         CT1A
Covington                     MUST FILE COVINGTON TAX DIRECT WITH THE CITY OF COVINGTON.                     EL               EM         OOB

Crescent Springs                                                         -      0.010000                 -   PI               RAE        TERM
Crestview Hills                                                          -      0.010000                 -
Edgewood                                                                 -      0.010000                 -
Elsmere                                                                  -      0.012500                 -
Erlanger                                                                 -      0.015000                 -
Fort Mitchell                                                            -      0.010000                 -
Fort Wright                                                              -      0.010000                 -
Independence                                                             -      0.012500                 -
Lakeside Park                                                            -      0.010000                 -        Refer to Instructions for
                                                                                                                   Penalty and Interest
Ludlow                                                                   -      0.015000                 -
                                                                                                                       Assessment.
Park Hills                                                               -      0.010000                 -
Taylor Mill                                                              -      0.020000                 -        Penalty
Villa Hills                                                              -      0.010000                 -     Interest
                                                                                                              Amount w/
                                                                                                              Penalty &
                                                                   Total Fee Due                         -     Interest

                                                              # Employees
   # Employees             Employee Wage Range
                                                              Next Quarter
                                    $25,000 or less                            Must include employee wage list.
                             $25,001 up to the FICA Cap
                                More than FICA Cap
                  -   Total Employees                                    -     Projected Employees

      Preparer                     Phone:                                        E-mail:
    Information                     Title:                             Date:                Print Name:
I declare under penalty of perjury that this return has been examined by me and to the
best of my knowledge and belief is true, correct and a complete return.                     Signature: Stop! Must Enter Acct #
       Owner                       Phone:                                        E-mail:
    Information                     Title:                             Date:               Print Name:
Sign Completed Form and Remit to:
Kenton County Fiscal Court                                                                  Signature: Stop! Must Enter Acct #
PO BOX 643966
CINCINNATI OH 45264-3966
                                                              Stop! Must Enter Acct #

         11/30/2010; 1:08 PM                 d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Qtr 3                                            5
                                              Kenton County and Cities, Kentucky
                                                       Employees' Quarterly Withholding
Business Name:                                                      DBA:                                          Acct #      Quarter       Year
Mailing Address:                                                 Address:                                                          4        2010
           City:                                                    City:                                         Federal Employer ID or SSN #
          State:                                                   State:
            Zip:                                                     Zip:                                               Accessed Date       11/30/10
                                                                                                                              Date Due      01/31/11

              1                2                     3             4                5                6                  Official Use Only
                                                 Excluded        Subject
  City or County       Total Earnings                                           Tax Rate
                                                 Earnings       Earnings                      Fee Due                       Rec. Date
Kenton County
first $25,000                                                            -      0.007097                 -
Kenton County
over $25,000                                                             -      0.001097                 -
Bromley                                                                  -      0.010000                 -   ADJ              AM         CT1A
Covington                     MUST FILE COVINGTON TAX DIRECT WITH THE CITY OF COVINGTON.                     EL               EM         OOB

Crescent Springs                                                         -      0.010000                 -   PI               RAE        TERM
Crestview Hills                                                          -      0.010000                 -
Edgewood                                                                 -      0.010000                 -
Elsmere                                                                  -      0.012500                 -
Erlanger                                                                 -      0.015000                 -
Fort Mitchell                                                            -      0.010000                 -
Fort Wright                                                              -      0.010000                 -
Independence                                                             -      0.012500                 -
Lakeside Park                                                            -      0.010000                 -        Refer to Instructions for
                                                                                                                   Penalty and Interest
Ludlow                                                                   -      0.015000                 -
                                                                                                                       Assessment.
Park Hills                                                               -      0.015000                 -
Taylor Mill                                                              -      0.020000                 -        Penalty
Villa Hills                                                              -      0.010000                 -     Interest
                                                                                                              Amount w/
                                                                                                              Penalty &
                                                                   Total Fee Due                         -     Interest

                                                              # Employees
   # Employees             Employee Wage Range
                                                              Next Quarter
                                    $25,000 or less                            Must include employee wage list.
                             $25,001 up to the FICA Cap
                                More than FICA Cap
                  -   Total Employees                                    -     Projected Employees

      Preparer                     Phone:                                        E-mail:
    Information                     Title:                             Date:                Print Name:
I declare under penalty of perjury that this return has been examined by me and to the
best of my knowledge and belief is true, correct and a complete return.                     Signature: Stop! Must Enter Acct #
       Owner                       Phone:                                        E-mail:
    Information                     Title:                             Date:               Print Name:
Sign Completed Form and Remit to:
KENTON COUNTY FISCAL COURT                                                                  Signature: Stop! Must Enter Acct #
PO BOX 643966
CINCINNATI OH 45264-3966
                                                              Stop! Must Enter Acct #

         11/30/2010; 1:08 PM                 d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Qtr 4                                            6
                                                           Kenton County and Cities, Kentucky
                                                                     Annual Payroll License Fees Withheld

 Business Name:                                                     DBA:                                                                  SECTION A
 Mailing Address:                                               Address:                                            Account #                                        Year
            City:                                                    City:                                                                                           2010
           State:                                                  State:                                                      Federal Employer ID or SSN #
             Zip:                                                     Zip:
   SECTION A:                         Payroll Withholding Fees per QUARTER
                                Qtr 1           Qtr 2           Qtr 3       Qtr 4                                                   DIRECTIONS:
   City or County              Ending          Ending          Ending      Ending                               Total Fees Remitted If using Excel: Complete Section A by
                               Mar 31          Jun 30          Sep 30      Dec 31                                                   filling in all green cells, then scroll down
Kenton County                                                                                                                       and place data in the appropriate green
first $25,000                        -               -                  -                   -          =                      -     cells.
Kenton County
over $25,000                         -               -                  -                   -          =                        -     Basic data from Section A will
                                                                                                                                      automatically fill in Section B, below.
Bromley                              -               -                  -                   -          =                        -
Crescent Springs                     -               -                  -                   -          =                        -     To change data in a green cell just select
Crestview Hills                      -               -                  -                   -          =                        -     it then type over it or double click the cell
                                                                                                                                      and use the backspace key to delete the
Covington                            MUST FILE COVINGTON TAX DIRECT WITH THE CITY OF COVINGTON.
                                                                                                                                      data.
Edgewood                             -               -                  -                   -          =                        -
Elsmere                              -               -                  -                   -          =                        -     Cities in Kenton County: Bromley,
                                                                                                                                      Crescent Springs, Crestview Hills,
Erlanger Q1 & Q2                     -               -                                                 =                        -     Covington, Edgewood, Elsmere,
Erlanger Q3 & Q4                                                        -                   -          =                        -     Erlanger, Fort Mitchell, Fort Wright,
                                                                                                                                      Independence, Lakeside Park, Ludlow,
Fort Mitchell                        -               -                  -                   -          =                        -     Park Hills, Taylor Mill, Villa Hills; plus the
Fort Wright                          -               -                  -                   -          =                        -     un-incorporated areas.
Independence                         -               -                  -                   -          =                        -
                                                                                                                                      After completing the forms, place the
Lakeside Park                        -               -                  -                   -          =                        -     signature page (Section B) on top of all
Ludlow                               -               -                  -                   -          =                        -     supporting documentation, such as,
                                                                                                                                      employee list with W-2 data (see Tab or
Park Hills                           -               -                  -                   -          =                        -
                                                                                                                                      Sheet titled "Employee List Annual
Taylor Mill                          -               -                  -                   -          =                        -     Recon").
Villa Hills                          -               -                  -                   -          =                        -
       Totals                        -               -                 -                   -           =                        -     If you have any questions, call (859) 392-
                                                                                                                                      1440.
                         # Employees                                           # Employees
                                              Employee Wage Range
                           Last Year                                             Next Year
                                                   $25,000 or less
                                             $25,001 up to the FICA Cap
                                                 More than FICA Cap
                                     -    Total Employees                                   -    Projected Employees

          11/30/2010;1:08 PM                             d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Annual Reconciliation                                                  7
                       Kenton County and Cities, Kentucky
                                 Annual Payroll License Fees Withheld




11/30/2010;1:08 PM   d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Annual Reconciliation   8
                                                               Kenton County and Cities, Kentucky
                                                                          Annual Payroll License Fees Withheld
 Business Name:                                                           DBA:                                                               SECTION B
       Address:                                                        Address:                                        Account #                                       Year
           City:                                                          City:                                                                                        2010
          State:                                                         State:                                                    Federal Employer ID or SSN #
            Zip:                                                           Zip:

    SECTION B                   2                    3              4                    5                 6                  7                  8                       9
                                                  Amount                           Total Taxable                                                              Fees Remitted minus Fees
                            W2 Gross                             Amount                                             Withholding Fees
                                              Earnings More                          Earnings                                                Total Fees                 Due
   City or County          Earnings per                      Earnings Outside                           Tax Rate         Due
                                              Than FICA Cap                        (Col 2 minus Col 3                                        Remitted               (Col. 7 minus
                              Entity                          Kenton County            and Col 4)
                                                                                                                    (Col 5 times Tax Rate)
                                                                                                                                                                       Col. 8)
                                              in Kenton Cnty
Kenton County
first $25,000                                                                                    -       0.7097%                      -                   -                             -
Kenton County
over $25,000                                                                                  -      0.1097%            -              -                                                -
Bromley                                                                                       -      1.0000%            -              -                                                -
Covington                                                                                   MUST FILE COVINGTON TAX DIRECT WITH THE CITY OF COVINGTON.
Crescent Springs                                                                                 -       1.0000%                      -                   -                             -
Crestview Hills                                                                                  -       1.0000%                      -                   -                             -
Edgewood                                                                                         -       1.0000%                      -                   -                             -
Elsmere                                                                                          -       1.2500%                      -                   -                             -
Erlanger (Q1 & Q2)                                                                               -       1.0000%                      -                   -                             -
Erlanger (Q3 & Q4)                                                                               -       1.5000%                      -                   -                             -
Fort Mitchell                                                                                    -       1.0000%                      -                   -                             -
Fort Wright                                                                                      -       1.0000%                      -                   -                             -
Independence                                                                                     -       1.2500%                      -                   -                             -
Lakeside Park                                                                                    -       1.0000%                      -                   -                             -
Ludlow                                                                                           -       1.5000%                      -                   -                             -
Park Hills                                                                                       -       1.0000%                      -                   -                             -
Taylor Mill                                                                                      -       2.0000%                      -               -                  -
Villa Hills                                                                                      -       1.0000%                      -               -                  -
       Totals                                                                                    -                                   Total of Column 9 $                 -
                  If claiming any excluded wages provide a listing by City.                                         No Action if within $5.00 +/- of zero No Adjustment Due
Enclose Copies of Federal Forms W-2 and W-3, Transmittal of Wage and Tax Statements, or a Detailed Employee Listing with the Required Equivalent Information…..DUE
February 28. Remit to: Kenton County Fiscal Court, Occupational License Office, 303 Court St Rm207, Covington, KY 41011.

      Preparer                      Phone:                   E-mail:                                                          Print Name
    Information                      Title:                                Date:                                           Signature: Stop! Must Enter Acct #
       Owner                        Phone:                   E-mail:                                                          Print Name
    Information                      Title:                                Date:                                           Signature: Stop! Must Enter Acct #
           11/30/2010;1:08 PM                               d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Annual Reconciliation                                                     9
                             Kenton County and Cities, Kentucky
                                       Annual Payroll License Fees Withheld




ect
ell
he




he




  -




      11/30/2010;1:08 PM   d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Annual Reconciliation   10
                                                Employee Wages List - Earned in Kenton County and City(ies)
                      Employee Earnings and Withholdings
                                                            Employee 1     Employee 2    Employee 3   Employee 4    Employee 5   Employee 6    Employee 7   Employee 8       Employee 9
   Year                              Data

   2010                          First Name                   Sample
Sub Total of                     Last Name                     Name
  Rows
(Col F thru Col IU)
                         Social Security Number             123-45-6789

  120,000.00             Gross Earnings per W-2               120,000.00
    10,000.00             Earnings Outside KC                  10,000.00
                             Kenton County
    25,000.00                  first $25,000                   25,000.00           -             -            -             -            -             -            -                -
                             Kenton County
    81,800.00            Between $25,001 to FICA               81,800.00           -             -            -             -            -             -            -                -
                        Earnings in Kenton County
      3,200.00             more than FICA Cap                   3,200.00           -             -            -             -            -             -            -                -
               -       Excluded Wages (provide list)
               -                   Bromley
               -                 Covington
               -             Crescent Springs
               -       Crestview Hills (click for info)
               -                 Edgewood
               -                   Elsmere
               -                   Erlanger
               -                Fort Mitchell
               -                 Fort Wright
               -               Independence
               -               Lakeside Park
               -                   Ludlow
               -           Park Hills (click for info)
               -                 Taylor Mill
               -                  Villa Hills
                                                           To Print: select the area with data by using the mouse pointer and placing it in cell D1 (top left corner), then
                                   #VALUE!                 press and hold the left mouse button while dragging over area to print, click "File" on the menu above, click
                                                           "Print Area", then click "Set Print Area" print.

                                                           At this time, the print area is set for 29 employess (3 pages); to view print area, click: print, then preview.




         11/30/2010; 1:08 PM                         d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Employee List Annual Recon.                                                  11
                                          Employee Wages List - Earned in Kenton County and City(ies)
Employee Earnings and Withholdings
                                     Employee 10 Employee 11 Employee 12 Employee 13 Employee 14 Employee 15 Employee 16 Employee 17 Employee 18 Employee 19
               Data
           First Name
           Last Name
   Social Security Number
   Gross Earnings per W-2
    Earnings Outside KC
       Kenton County
         first $25,000                        -             -             -         -            -            -            -            -            -   -
       Kenton County
   Between $25,001 to FICA                    -             -             -         -            -            -            -            -            -   -
  Earnings in Kenton County
     more than FICA Cap                       -             -             -         -            -            -            -            -            -   -
 Excluded Wages (provide list)
             Bromley
           Covington
       Crescent Springs
 Crestview Hills (click for info)
           Edgewood
             Elsmere
             Erlanger
          Fort Mitchell
           Fort Wright
         Independence
         Lakeside Park
             Ludlow
     Park Hills (click for info)
           Taylor Mill
            Villa Hills
                                     To Print: select the area with data by using the mouse pointer and placing it in cell D
             #VALUE!                 press and hold the left mouse button while dragging over area to print, click "File" on the menu above, click
                                     "Print Area", then click "Set Print Area" print.

                                     At this time, the print area is set for




        11/30/2010; 1:08 PM                       d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Employee List Annual Recon.                                  12
                                          Employee Wages List - Earned in Kenton County and City(ies)
Employee Earnings and Withholdings
                                     Employee 20 Employee 21 Employee 22 Employee 23 Employee 24 Employee 25 Employee 26 Employee 27 Employee 28 Employee 29
               Data
           First Name
           Last Name
   Social Security Number
   Gross Earnings per W-2
    Earnings Outside KC
       Kenton County
         first $25,000                        -             -             -         -            -            -            -            -            -   -
       Kenton County
   Between $25,001 to FICA                    -             -             -         -            -            -            -            -            -   -
  Earnings in Kenton County
     more than FICA Cap                       -             -             -         -            -            -            -            -            -   -
 Excluded Wages (provide list)
             Bromley
           Covington
       Crescent Springs
 Crestview Hills (click for info)
           Edgewood
             Elsmere
             Erlanger
          Fort Mitchell
           Fort Wright
         Independence
         Lakeside Park
             Ludlow
     Park Hills (click for info)
           Taylor Mill
            Villa Hills
                                     To Print: select the area with data by using the mouse pointer and placing it in cell D
             #VALUE!                 press and hold the left mouse button while dragging over area to print, click "File" on the menu above, click
                                     "Print Area", then click "Set Print Area" print.

                                     At this time, the print area is set for




        11/30/2010; 1:08 PM                       d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Employee List Annual Recon.                                  13
                                  Variables Used in Calculations

                        Year                 2010
                  FICA Cap        $    106,800.00
               KC 1st $25k        $     25,000.00
         Max KCtax 1st $25k       $        177.43
                                                                        In 2010, FICA is $106,800
 Amount between $25k & Cap        $     81,800.00
  Max KCFC $25,001 to FICA        $         89.73                       Consider opening this page to all users to change like F
        Max KCFC COLT tax         $        267.16                       Tax Rates, Year and Caps.
                                      Due Dates
                      Quarter 1           04/30/10
                      Quarter 2           07/31/10
                      Quarter 3           10/31/10
                      Quarter 4           01/31/11
                                                                     Tax Rate Q3 and Q4
      City or County                  Tax Rate          Caps           (Erlanger Only)
       Kenton County
        first $25,000                    0.007097    $ 25,000.00
       Kenton County
        over $25,000                    0.001097 $ 106,800.00
           Bromley                      0.010000
         Covington                Covington collects its tax rate.
      Crescent Springs                  0.010000
       Crestview Hills                  0.010000 $ 106,800.00
         Edgewood                       0.010000
           Elsmere                      0.012500
           Erlanger                     0.010000                                       0.015
        Fort Mitchell                   0.010000
         Fort Wright                    0.010000
       Independence                     0.012500
       Lakeside Park                    0.010000
           Ludlow                       0.015000
          Park Hills                    0.010000 $ 50,000.00
         Taylor Mill                    0.020000
          Villa Hills                   0.010000


*Note: The City of Erlanger has enacted legislation which increases the City's payroll license fee
from one percent (1.00%) of wages to one and one half percent (1.5%) of wages. This change is
effective July 1, 2010. Any wages paid for work conducted in the City of Erlanger on or after
that date are subject to the 1.5% rate.

**The City of Park Hills has enacted legislation which increases the City's payroll license fee
from one percent (1.00%) of wages to one and one half percent (1.5%) of wages. This change is
effective October 1, 2010. Any wages paid for work conducted in the City of Park Hills with a check date on or after
October 1, 2010 are subject to the 1.5% rate.




11/30/2010; 1:08 PM      d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Variables                                14
                                               Variables Used in Calculations

                      Cells will update all Tabs
            Must be updated by KCFC.


        106,800

opening this page to all users to change like FICA,
s, Year and Caps.




                  Tax Rate Q4
                (Park Hills Only)




            *




                              0.015 **




s payroll license fee
ges. This change is
 nger on or after


yroll license fee
ges. This change is
 Park Hills with a check date on or after




             11/30/2010; 1:08 PM         d40dde02-d981-41ba-82f6-b873b80911b3.xls; TAB:Variables   15

						
Related docs