The History of the W2 Form by lni12175

VIEWS: 373 PAGES: 23

More Info
									                                                                                 2006 Payroll
                                                                                   Calendar
                                                                                   Year End
                                                                                  Procedures
                                                                                                                                             page
     Summary of Procedures Before you Begin the Close ……………………………..………………………………. 2
     Year End Menu ……………………………………………………………………..……………………………… 3
     Circular E …………………………………………………………………………..………………………………. 3
     W2 Process Menu Options ……………………………………………………….………………………………… 4
         Miscellaneous Codes Add-On Maintenance .……….........…………………................................................…. 4
         Miscellaneous Codes Add-On Report……..........................…………………............................................…….. 4
         W2 Reporting Process ...................………….....................…………………...............................................….. 5
             W2 Parameters ..........………………............................………………….......................................…..…... 5
              Build Working File .............………..............................………………….............................................….. 6
              Error/Warning Report ...................................................…………………...................................………… 6
             Totals Report ..........................………….......................…………………................................................... 7
             W2 Report ..…………...................................................………………….................................................... 7
              Print W2's .………........................................................………………….................................................... 8
              6559 Form ...................……..........................................…………………................................................... 8
                  IRS Addresses ...........……......................................…………………................................................... 9
             W3 Form ......................….............................................………………….................................................... 9
              Build Reporting File …...........………..........................…………………................................................... 9
     Other Year End Procedures .…......................................…......……………………................................................ 10
        Roll Leave ..........................…..........................……..........……………………................................................ 10
         Reset Process .....................….............................…….......……………………................................................ 10
         Select Circular E Year .............................……..................……………………................................................ 10
     Obtaining a PIN/Password ..............…....................................……………………................................................ 11
     Using a PIN/Password ........................…….............................……………………................................................ 11
     941 Report - Quarter 1 ............................….............................……...……………................................................ 12
     History Summary - Quarter 1 ...................…...........................……………………................................................ 13
     941 Report - Quarter 2 ......…….........................…..................……………………................................................ 14
     History Summary - Quarter 2 .......................….......................……………………................................................ 15
     941 Report - Quarter 3 .................................…........................……………………............................................... 16
     History Summary - Quarter 3 ................…..............................……………………................................................ 17
     941 Report - Quarter 4 ...........................…..............................……………………............................................... 18
     History Summary - Quarter 4 ................…..............................……………………................................................ 19
     History Summary ....................................................….............……………………............................................... 20
     W2 Totals .......................................................…......................……………………............................................... 21
     W2 Report .......................................................….....................……………………............................................... 22
     W2 Form ...........................................…...................................……………………............................................... 23




LGC 12-2006                                                                                                                                          1
Summary of Procedures Before you Begin the Close
1. Before you run the last payroll of the calendar year, be sure you have accounted for all taxable vehicle
   usage (fringe benefit), dependent care, and advanced earned income credit.

2. Be sure you have entered all manual payroll checks.

3. Be sure you have taken care of all voided payroll checks.

4. Be sure you have entered all third-party sick pay. For questions on entering third-party sick pay, copy the following
   link into your web browser: http://www.localgovcorp.com/faq/flexgen/w2_calendar_ye.htm

5. Balance and prepare your quarterly tax return for the fourth quarter.

6. Balance your calendar year-to-date totals with the sum totals of the four quarterly reports. (See pages 12-19 for an
   example of these reports and instruction on how to balance.) Use the summary history report. Access these reports
   from the main payroll menu.
               Reports
                  History
                       Summary
                          Summary

7. If you have differences between the sum of the quarterly reports and the history reports, you should first check your
   voided checks and manual checks.

8. Be sure you have the correct spelling for each employee’s name and their correct social security number entered into
   the payroll system.

9. Be sure you have the correct mailing address for each employee entered into the payroll system.

10. If you have employees who have left throughout the calendar year, be sure you have the correct mailing address for
    these people.

11. Visa SSN’ parameter has been added to Employee Master screen - If the ‘Visa SSN’ flag is ‘YES’, the edit
    check during the W-2 process will not exclude the employee. The employee WILL show up with a
    ‘WARNING’ on the W-2 Error/Warning Report. When the update is loaded, this field will automatically be
    updated to a ‘NO’ for all employees. If you have employees that have a Visa number as their Social Security
    Number, you need to change this flag to ‘YES’ before starting the W-2 process. Employee, Employee
    Master.


        After you have balanced your calendar year-to-date totals back to the totals of the four quarterly reports
        and you have completed the steps outlined above, you are ready to begin the process of preparing W-2
        forms for your employees.


        For complete instructions on filing W-2 and W-3 information, see www.irs.gov/forms_pubs/.




                Make a DAILY BACKUP and label it "Pre-Calendar Year End".
LGC 12-2006                                                                                                                2
Year End Menu
To begin the W-2 process, you will access the payroll main menu and use the year-end menu, which is found
under the period end section of the payroll menu.




The year-end menu options are shown below.




Circular E
Note: You must load the December update you received from LGC before you change the Circular E year.

Select the Circular E year. Use the 'Lookup' option to select the correct year. If you have run your last payroll
for 2006, choose 2007. Do not run this until you have completed all payrolls for 2006.




LGC 12-2006                                                                                                     3
W2 Process Menu Options
Each of the options on the W2 Process menu will be briefly explained below.

Misc Code Add-On Maint
       This option gives the opportunity to attach W-2 miscellaneous codes and non-qualified plan distributions
       to employees as shown below.
Misc Code Add-On Report
       This program will list the employees on the Miscellaneous Code Add-On File.
Reporting Process
       This option provides a step by step process for the W-2 process. Follow the steps in order to complete
       your W-2 forms.
Select W2 File To Copy
       This option allows a dated W-2 file to be copied to a diskette.
W2c Reporting Process
       This menu allows access to building the W2c file and the printing of the W-2c forms.


Miscellaneous Codes Add-On Maintenance                        This allows you to enter any miscellaneous codes.




There is a look up for the code.




Miscellaneous Codes Add-On Report
The miscellaneous code add-on report can be sorted by
name or by social security number.



LGC 12-2006                                                                                                       4
W2 Reporting Process
The W2 Process menu is shown below. A brief description of each option is included.




1. W2 Parameters
    This option allows you access to update information about your office as the employer who is filing the
    W-2 forms. If you have more than one EIN, the EIN entered here is the one that will be used in the
    heading on the W-2 diskette. All EIN's will be processed. See screen below for more information.

Note: You must have a PIN number. If you had a PIN last year, it is good indefinitely as long as you change
      your password once each year. To change your password, go to www.ssa.gov/bso/bsowelcome.htm.
      You should see a link you can use to change your password. If you do not have internet access, you
      cannot change your password. Instead, you can call 1-800-772-6270. You will have to register for a new
      password and PIN. (See page 11 for more information about obtaining a PIN or changing a
      password.)*** Be sure the W2 Tax Year is set to 2006. If not, change it on this screen before
      proceeding.

        Be sure the information on your screen is like the example shown for these fields:

        Assigned File Name         W2REPORT
        Inventory Number           1
        PIN                        Enter your unique PIN
        W2 Type                    01 W2ORIGINAL
        WFID                       blank
        W-2 Laser Ptr              If you are using a laser
                                   printer for your forms, it
                                   should be 01 YES. Otherwise,
                                   it should be 02 NO.
        w/4 W2's                   If you are using a laser printer
                                   for your forms and they are 4
                                   per sheet, this should be
                                   01 YES. Otherwise, it should
                                   be 02 NO

Note:   The address on the W-2 Parameter Maintenance
        Screen to the right, is not the address that prints on the
        W-2’s. The address that prints on the W-2’s comes from
        the Payroll Number Control under Other, Control,
        Control N-Z, Payroll Number

LGC 12-2006                                                                                                    5
2. Build Working File
   This option creates the work file for preparing the W-2 forms. You will be prompted for the year you are
   running and a beginning and ending date. If you only want one employee you can enter that in the 'Select
   One SSN:' line. Leave this field blank to select all employees. See screen below for more information. It is
   recommended that you have everyone out of the payroll system while you run Step 2.




NOTE: If you make changes to an employee after you have run this option, you will have to run the option again
to see those changes on the W-2 form.


3. Error/Warning Report
   This report shows all employees who may possibly have errors. It is important you review this report
   carefully before you proceed. If you need assistance with this, please contact LGC Phone Support. A sample
   of this report is shown below.




NOTE: Errors show first, warnings come last. Employees with a 'Warning' will still get a W-2 form. But, a
  form will not be printed if the employee shows with an 'Error' unless the error is corrected. If you correct
  errors, you must run Step 2 again. The E/W column reflects if the employee has an error or a warning.




LGC 12-2006                                                                                                       6
4. Totals Report
   This report shows summary totals for your W-2 processing. See sample report below. The totals should be
   checked against the History Summary Report totals.




5. W2 Report
   When you select this option, the screen to the right will be
   displayed. If you want ALL employees, press <enter> at
   the name fields. To select the range of employees for the
   report, press the ‘Lookup’ option key by each name field.
   When finished with the range selection, press <enter>.
   When prompted by “Is This Screen Correct?”, select ‘Yes’
   and then select ‘Continue’ to print the report.


   This report shows all of the information as it will be printed on the W-2 forms. This shows totals for each
   employee. It is important that you review this report carefully. If there are any errors, they need to be
   corrected before you proceed to the next step. (Call LGC phone support for assistance in making the
   corrections.). A portion of a sample report is shown below.




   Once you have reviewed this report and feel satisfied that it is correct, you should proceed to the next step.


LGC 12-2006                                                                                                         7
If LGC is printing your W-2 forms:
• Stop here, escape out of this menu, and do a daily backup.
• Review and initial the W-2 totals Report (Step 4) and send it with your backup.
    Send this backup to LGC at:     Attention: W-2 Printing
                                     714 Armstrong Lane, Columbia, TN 38401
• Await further instructions from LGC, which will be sent with your W-2 forms.
• It is OK to run payroll checks and proceed with business as normal as long as you have set your Circular E
    to 2007 (see page 3).

6. Print W2’s
   This is the option that will print the W-2 forms. You should be sure that everyone who uses the printer you
   are going to use knows that you are using the printer and not to print anything until you give notice that you
   are finished. The printer settings should be set to 10 CPI (characters per inch) and 6 LPI (lines per inch).
   Refer to your owner’s manual for your printer for assistance in making these changes. Call LGC Hardware
   Support Dept. if you need assistance.

Note: For Tally printers only, you will also need to set the page length to 75.

   You will have the option to run the alignment routine at the beginning. If you choose to do this, you will
   print one form with XXX’s and 99999’s to help you get the numbers and boxes aligned properly. After you
   choose to end the alignment routine, the system will finish the form it is on with XXX’s and 999’s. Then it
   will start printing the first real W-2 form!

   See page 22 for a sample W-2 Report. This report shows where each field will print on the W-2 forms.

7. 6559 Form – This form no longer applicable since the SSA no longer accepts diskettes
   This option would print the cover sheet you used to send in with your diskette when you file with the IRS.
   If you are not reporting on diskette, you will not have to run this option. It should have N/A out beside it.
   See sample form below.

              PYQ576    2006/12/15 13:58:54                      TOWN OF SAMPLEVILLE                       FlexGen4(6.1U)     Page:    1
                                                       Transmitter Report And Summary Of Magnetic Media
                                                               Please Submit Below Information On
                                                                 An Original Form 6559 Or 6559-A
                                                                       6559 Form
                                                                      Tax Year 2006
               1. Transmitter: LOCAL GOVERNMENT CITY SCHOOLS                       2. Transmitter EIN: 62-0123456
                                 P O BOX 123                                       3. Number Of Reporting Media This File
                                 COLUMBIA TN 38401                                        Magnetic Tape(s)
                                                                                        1 Diskette(s)
                                                                                          Cartridge(s)
               4. Contact Name: CONTACT NAME                                       5. Telephone Number: 931-381-1155
                                 714 CONTACT ADDRESS                               6. Inventory Number: 1
                                 COLUMBIA TN 38401                                 7. Type Of Data Being Reported
                                                                                      X   W-2 Original
                                                                                          W-2 Reconciliation
                                                                                          W-2 Resubmittal
                                                                                          W-2c For W-2
              ----------------------------------------------------------------------------------------------------------------------
                                                                             Affidavit
                           Under penalties of perjury, I declare that I have examined this return, including accompanying documents,
                           and to the best of my knowledge and belief it is true, correct and complete.
                              8. Signature:                                 9. Title:                             10. Date:
              ----------------------------------------------------------------------------------------------------------------------
               11. Employer Summary Of Wage And Tip Information
                   Employer Name                                       MQGE
                     CITY OF SPRING HILL
                   EIN
                     62-0692693
                   Total W2's:         2
                   SS Wages:
                   SS Tips:
                   Reg Wages:
                   FIT:                   98.80-
                   SS Tax:                10.00-
                   Medi Wages:
                   Medi Tax:
                   AEIC:
              * End of Report: Local Government Data Demo *




LGC 12-2006                                                                                                                                8
                                                                                 http://www.ssa.gov/employer/whereto.htm



IRS
Addresses




8. W3 Form
   This option prints the W-3 form that you will include with your W-2 copies when you report to the IRS. If
   you are reporting on diskette, this option will have N/A out beside it. See sample form below.




9. Build Reporting File
   This option builds the file you will send to the IRS and copies it to a diskette.

   Following is a suggested site for the transmitting of the W2REPORT file that can be sent electronically to
   the SSA/IRS:      http://www.socialsecurity.gov/employer/bsotut.htm


                         Congratulations! You have completed the W-2 process.
                           (See next page for "Other Year End Procedures".)


LGC 12-2006                                                                                                            9
Other Year End Procedures
   Roll Leave
      For the selected payroll(s), this option will add the
      number of days from the first leave type “total accu-
      mulated” field to the second leave type “total accu-
      mulated” field. The amount to add is determined by
      three options, (1) Total Accumulated, (2) Excess
      over a prompted amount, and (3) Up to a prompted
      amount. Only one option may be selected.




Reset Process
   This option will reset deductions, leave, times
   paid, W-2 miscellaneous file and increment
   teacher’s experience by one year. These items
   should be reset at least once per year. See
   screen to right.

NOTE: If you reset your deductions and leave
on a fiscal year basis, you will not execute
this option until the fiscal year end.



Select Circular E Year
    Use this option to copy the new calendar year’s Circular E data file into use. Circular E data will update the
    Social Security amounts, federal amounts, federal and state tax tables, AEIC tax table and amounts, and the
    TCRS base rates. (Refer to page 3 for the menu options.)

Note: If you are running a January payroll, you have to log in with a January date.




LGC 12-2005                                                                                                     10
Obtaining a PIN/Password
Must I get a Personal Identification Number (PIN) before I submit my file? Yes

How do I get a PIN/Password? Monday-Friday, 6:00 AM to 1:00 AM Eastern time Saturday, 6:00 AM to 8:00
PM Eastern Time or access the Internet at www.ssa.gov/employer, select 'Business Services Online', select
'Registration' or call 1-800-772-6270 Monday through Friday, 7:00 AM to 7:00 PM Eastern Time



What information do I have to provide to get a PIN?

1. The EIN of the company you work for. If you are a third party submitter, you need the EIN of your own company, not the EIN of
   the company(s) for which the wage report(s) is/are being submitted. If you are self-employed, you do not need to provide an EIN.
2. Your social security number (SSN), name (first, middle initial, or name and last name) as shown on your social security card, date
   of birth, your telephone number, E-mail address (optional), and/or FAX number (optional) to contact you, and your mailing
   address.
3. Company name, phone number, and address.

How do you approve my request? The IRS will match your name, date of birth, and SSN against our records and verify that you
   work for the company that will submit the file. If the information is verified, we issue a PIN immediately and mail you a
   password that you should receive within 10-14 days. Your employer will be notified of your registration.



Using a PIN/Password
How do I use the PIN I receive? There are two times when you can use your PIN:

     1.        As an electronic signature:
               Employer submitter: You will use the PIN as your signature for the file in the MMREF format; Insert your PIN into the file in
                   the Personal Identification Number (PIN) field in the RA record positions 12 – 28. This should be the PIN of the person
                   responsible for the file and attesting to its accuracy. It would generally be the same individual who would be signing the
                   attestation statement on the Form W-3. You will be attesting to that “under penalties of perjury, you declare that you
                   have examined this file’s data and that to the best of your knowledge and belief, it is true, correct, and complete”.
               Third-Party or Payroll Practitioner Submitter: You will use the PIN as your signature for the file in the Personal
                   Identification Number (PIN) field in the RA Record positions 12 – 28. This should be the PIN of the person
                   responsible for the file and attesting to its accuracy. This attestation is based on the information available and
                   assurances provided by the client. You should include as part of your standard business practices a provision in our
                   contractual agreement that requires your client to give assurances that the file you are attesting to is to the best of their
                   knowledge true, correct, and complete.

          2.     To use the Business Services Online (BSO) As a designated individual authorized by your company you will use your PIN
                 to use the Business Services Online to carry out various payroll activities. You’ll need your PIN (and password) to upload
                            files and to check the status of your file. The person uploading the file or checking the status of the file will use
                   his or her own PIN and password. This does not have to be the same person who is inserting their PIN in the file as
                   explained above.

How do I use the password I receive? Use the password with the PIN to use the BSO (see Section VII). You must change your
   password the first time you use the system. Your password is valid for one year. If you do not use the BSO, save the password
   you receive. Your password must be changed each year to retain your PIN. You may use your PIN and SSN to upload a file until
   you receive your password (not to exceed 30 days after you register).

When may I start using my PIN and password? Immediately, upon receipt.

How long may I use the PIN? Indefinitely, if you change your password once a year.


LGC 12-2005                                                                                                                                     11
                                      941 Report- Quarter 1


Name: LGC Training Center Date                            Quarter Ended: 03/31/2006
Adr: 714 Armstrong Lane
City: Columbia                                            Employer ID #: 62-6000744
State:TN
Zip: 38401                                                State Tax #:      06262770


1. Number Of Employees........................................           415
2. Total Wages & Tips Subject To Withholding..................           2,354,309.20
3. Total Income Tax Withheld From Wages & Tips................           259,801.56
4. Adj. Of Withheld Income Tax Withheld.......................
5. Adjusted Total Of Income Tax Withheld......................           259,801.56
6. Taxable Soc Sec Wages......... 2,518,557.88 * 0.1240 =                312,301.18
   Actual Soc Sec Taxes.......................................           312,301.38
   Difference.................................................           0.20-
7. Taxable Medicare Wages & Tips. 2,518,557.88 * 0.0290 =                73,038.18
   Actual Medicare Taxes......................................           73,038.52
   Difference.................................................           0.34-
8. Total FICA Taxes (Add Lines 6 & 7).........................           385,339.36
9. Adj. Of Soc Sec & Medicare.................................
10. Adj. Total Of Soc Sec & Medicare...........................          385,339.36
11.   Total Taxes (Add Lines 5 & 10).............................        645,140.92
12.   Advanced Earned Income Credit Payments Made................        0.00
13.   Net Taxes (Subtract Line 12 From Line 11)..................        645,140.92
14.   Total Deposits For Quarter.................................
15.   Balance Due................................................


First Month Liability:           214,162.80
Second Month Liability:          215,371.91
Third Month Liability:           215,606.21
Total Liability For Quarter:     645,140.92

* End of Report: Local Government Data Demo *




LGC 12-2005                                                                             12
LGC 12-2006   PYQ512 2006/12/03 12:44:32                                                        TOWN OF SAMPLEVILLE                                   FlexGen4 (6.1U) Page: 1
                                                                                                  History Summary
              Selected Date:      01/01/2006 to 03/31/2006
              Payrolls:                      0001 WEEKLY
                                             0002 BIWEEKLY
                                             0003 SEMI-MONTHLY
                                             0004 MONTHLY
                                             0007 QUARTERLY
                                             0009 ELECTION WORKERS
                                             0010 COMMITTEES
                                             0994 COUNTY COURT CLERK
                                             7028 CLERK & MASTER CHANCERY COURT
              —————————————————————————————-————— ———————————————————————————————————————————— ———————————————— ———————————————————————————————————
              Gross Salary:                                      2,556,721.55
              FIT Taxable Gross:                                 2,354,309.20
              Social Security Wage:                              2,518,557.88                   2,556,721.55
              Medicare Wage:                                     2,518,557.88                   (113,226.84)
              SIT Taxable Gross                                                                 (89,185.51)
              Retirement Gross:                                  2,261,881.79                   (NDNTB Emp)
              FIT:                                               259,801.56                     Fringe Benefits
              Social Security:                                   156,150.69
              Medicare:                                          36,519.26
              SI                                                                                2,354,309.20
              TCRS                Employee:                      113,226.84
                                  Employer:                      176,762.05
              Advanced Earned Income Credit:
              Other Deductions    Employee:                      110,554.07          2,556,721.55
                                  Employer:                      299,772.34          (38,163.67)
                                  Employer:
              Cafeteria Plan:                                    38,163.67           2,518,557.88
              Deductions ‘Sheltered From’ FIT:                   89,185.51
                                      Soc Sec:                   38,163.67




                                                                                                                                                                                History Summary – Quarter 1
                                      SIT:                       17,381.91
                                      Retirement:
                         Exempt From’ Soc Sec:
                                      Medicare:
              Net Pay:                                           1,880,469.13
              Employment Security Wage:                         2,321,031.59
              Employment Security:                              31,759.03
              —————————————————————————————-————————————————————————————————————————————————————————————————————————————————————————————————
              Deductions                    Employee             Employer            Adjustments                   Hrs/Days            Amount

              0002 AFLAC- S                 2,302.97                                 |   0001 OVERTIME              2,061.10             40,251.62
              0003 BC/BS OF TN              17,456.26            227,456.14          |   * Class 01 OVERTIME        2,061.10             40,251.62
              0005 AFLAC- NS                882.12                                   |   0003 BACK PAY                                   37.38
              0008 UWAY                     341.58                                   |   0006 OTHER PAY             539.00               5,441.80
              0009 DEFCOM                   50,188.56                                |   0009 OTHER/SHER            2,720.60             34,255.50
              0011 RELIANCE OPTION          3,262.32                                 |   0012 VAC PAY               505.00               6,398.85
              0012 DENTAL-NON-SHEL          136.90               102.12              |   0013 COMP PAY              36.50                505.53
              0014 DEF COMP (1ST)           624.96                                   |   * Class 02 OTHER PAY       3,801.10             46,639.06
              0018 DEF COMP (2ND)           208.32                                   |
              0021 USABLE - S               7,856.20                                 |
              0023 USABLE - NS              419.52                                   |
              0024 USABLE-STD-NS            3,643.78                                 |
              0034 MUTUAL SAV-NS            51.30                                    |
              0036 DENTAL-SHELTER           6,899.76             16,373.24           |
              0038 MUTUAL - S               322.98                                   |
              0040 GAP                      1,375.50             20,978.00           |
              0041 GAP                      735.00               6,460.00            |
              0042 GAP                      840.00               8,109.00            |
              0043 DISABILITY                                    12,678.04           |
              0054 RELIANCE-GROUP                                6,153.60            |
              0055 RELIANCE-GROUP                                67.20               |
              0063 PRESCRIPTION             375.00               1,395.00            |
              * Class 01 REGULAR VOL DED    97,923.03            299,772.34          |
              0057 MISC                     5,137.50                                 |
              0058 MISC                     519.25                                   |
              0059 MISC                     661.98                                   |
              0060 MISC                     5,992.80                                 |
              0061 MISC                     215.66                                   |
              0062 MISC                     103.85                                   |
              * Class 03 CRT ORDERED PAY    12,631.04                                |
13
                                     941 Report - Quarter 2



Name:         LGC Training Center                        Date Quarter Ended: 06/30/2006
Adr:          714 Armstrong Lane
City:         Columbia                                   Employer ID #: 62-6000744
State:        TN
Zip:          38401                                      State Tax #: 06262770


1.   Number Of Employees........................................    462
2.   Total Wages & Tips Subject To Withholding..................     2,774,469.57
3.   Total Income Tax Withheld From Wages & Tips................     296,397.88
4.   Adj. Of Withheld Income Tax Withheld.......................
5.   Adjusted Total Of Income Tax Withheld......................     296,397.88
6.   Taxable Soc Sec Wages......... 2,953,726.74 * 0.1240 =          366,262.12
     Actual Soc Sec Taxes.......................................     366,264.00
     Difference.................................................     1.88-
7.   Taxable Medicare Wages & Tips. 2,953,726.74 * 0.0290 =          85,658.08
     Actual Medicare Taxes......................................     85,658.48
     Difference.................................................     0.40-
8.   Total FICA Taxes (Add Lines 6 & 7).........................     451,920.20
9.   Adj. Of Soc Sec & Medicare.................................
10. Adj. Total Of Soc Sec & Medicare...........................      451,920.20
11. Total Taxes (Add Lines 5 & 10).............................      748,318.08
12. Advanced Earned Income Credit Payments Made................      0.00
13. Net Taxes (Subtract Line 12 From Line 11)..................      748,318.08
14. Total Deposits For Quarter.................................
15. Balance Due................................................



First Month Liability:          223,230.66
Second Month Liability:         304,531.88
Third Month Liability:          220,555.54
Total Liability For Quarter:    748,318.08

* End of Report: Local Government Data Demo *




LGC 12-2006                                                                               14
LGC 12-2006
              PYQ512    2006/12/03 12:45:04                                                               TOWN OF SAMPLEVILLE                      FlexGen4(6.1U) Page: 1
                                                                                                            History Summary
              Selected Date:       04/01/2006 to 06/30/2006
                   Payrolls:       0001 WEEKLY
                                   0002 BIWEEKLY
                                   0003 SEMI-MONTHLY
                                   0004 MONTHLY
                                   0007 QUARTERLY
                                   0009 ELECTION WORKERS
                                   0010 COMMITTEES
                                   0994 COUNTY COURT CLERK
                                   7028 CLERK & MASTER CHANCERY COURT
              —————————————————————————————-————————————————————————————————————————————————————————————————————————————————————————————————————
              Gross Salary:                                       2,998,985.75
              FIT Taxable Gross:                                  2,774,469.57                 2,998,985.75
              Social Security Wage:                               2,953,726.74                 (127,873.57)
              Medicare Wage:                                      2,953,726.74                 (NDNTB EMP
              SIT Taxable Gross:                                                               (96,642.61)
              Retirement Gross:                                   2,554,809.81                 Fringe Benefits
              FIT:                                                296,397.88
              Social Security:                                    183,132.00
              Medicare:                                          42,829.24                     2,774,469.57
              SIT:
              TCRS              Employee:                        127,873.57
                                Employer:                        200,079.10
              Advanced Earned Income Credit:                                         2,998,985.75
              Other Deductions Employee:                         123,649.08          (45,259.01)
                                Employer:                        399,633.83
              NDNTB             Employee:
                                Employer:                                            2,953,726.74
              Cafeteria Plan:                                    45,259.01
              Deductions ‘Sheltered From’ FIT:                   96,642.61




                                                                                                                                                                            History Summary – Quarter 2
                                       Soc Sec:                  45,259.01
                                      Medicare:                  45,259.01
                                           SIT:                  20,245.21
                                    Retirement:
                        ‘Exempt From’ Soc Sec:
                                      Medicare:
              Net Pay:                                           2,225,103.98
              Employment Security Wage:                         2,737,531.44
              Employment Security:                              7,238.65
              —————————————————————————————-————————————————————————————————————————————————————————————————————————————————————————————————————
              Deductions                    Employee             Employer            Adjustments                   Hrs/Days             Amount

              0002 AFLAC - S                2,141.77                                |   0001 OVERTIME              3,605.75            67,756.49
              0003 BC/BS OF TN              19,025.80 3         17,176.08           | * Class 01 OVERTIME          3,605.75            67,756.49
              0005 AFLAC - NS               832.92                                  |   0003 BACK PAY                                  82.80
              0008 UWAY                     345.72                                  |   0005 COMM MEET             817.00              20,425.00
              0009 DEFCOM                   50,550.32                               |   0006 OTHER PAY             1,078.60            16,121.20
              0011 RELIANCE OPTION          3,845.79                                |   0008 IN-SERVICE                                32,400.00
              0012 DENTAL-NON-SHEL                              25.53               |   0009 OTHER/SHER            1,285.30            16,283.77
              0014 DEF COMP (1ST)           624.96                                  |   0012 VAC PAY               144.00              1,640.16
              0018 DEF COMP (2ND)           208.32                                  | * Class 02 OTHER PAY         3,324.90            86,952.93
              0021 USABLE - S               9,821.44                                |
              0023 USABLE - NS              1,104.20                                |
              0024 USABLE-STD-NS            4,212.18                                |
              0034 MUTUAL SAV-NS            59.85                                   |
              0036 DENTAL-SHELTER           7,953.87            18,832.63           |
              0038 MUTUAL - S               328.13                                  |
              0040 GAP                      194.50              187.00              |
              0041 GAP                      147.00              102.00              |
              0042 GAP                      120.00              102.00              |
              0043 DISABILITY                                   12,649.99           |
              0054 RELIANCE-GROUP                               6,179.20            |
              0055 RELIANCE-GROUP                               54.40               |
              0063 PRESCRIPTION             5,526.50            44,325.00           |
              * Class 01 REGULAR VOL DED    107,043.27          399,633.83          |
              0057 MISC                     7,295.75                                |
              0059 MISC                     772.31                                  |
              0060 MISC                     7,810.80                                |
              0062 MISC                     726.95                                  |
              * Class 03 CRT ORDERED PAY    16,605.81                               |
              * = Class Totals* = Class Totals
15
                                    941 Report – Quarter 3



Name:         LGC Training Center                             Date Quarter Ended: 09/30/2006
Adr:          714 Armstrong Lane
City:         Columbia                                        Employer ID #: 62-6000744
State:        TN
Zip:          38401                                           State Tax #: 06262770


1.   Number Of Employees........................................    454
2.   Total Wages & Tips Subject To Withholding..................    2,485,344.34
3.   Total Income Tax Withheld From Wages & Tips................    256,036.40
4.   Adj. Of Withheld Income Tax Withheld.......................
5.   Adjusted Total Of Income Tax Withheld......................    256,036.40
6.   Taxable Soc Sec Wages......... 2,649,705.75 * 0.1240 =         328,563.51
     Actual Soc Sec Taxes.......................................    328,561.38
     Difference.................................................    2.13
7.   Taxable Medicare Wages & Tips. 2,649,705.75 * 0.0290 =         76,841.47
     Actual Medicare Taxes......................................    76,840.76
     Difference.................................................    0.71
8.   Total FICA Taxes (Add Lines 6 & 7).........................    405,404.98
9.   Adj. Of Soc Sec & Medicare.................................
10. Adj. Total Of Soc Sec & Medicare...........................     405,404.98
11. Total Taxes (Add Lines 5 & 10).............................     661,441.38
12. Advanced Earned Income Credit Payments Made................     0.00
13. Net Taxes (Subtract Line 12 From Line 11)..................     661,441.38
14. Total Deposits For Quarter.................................
15. Balance Due................................................




First Month Liability: 221,659.83
Second Month Liability: 219,964.05
Third Month Liability: 219,817.50
Total Liability For Quarter: 661,441.38

* End of Report: Local Government Data Demo *




LGC 12-2006                                                                               16
LGC 12-2006
              PYQ512    2006/12/03 12:45:38                                                    TOWN OF SAMPLEVILLE                                 FlexGen4(6.1U) Page: 1
                                                                                                  History Summary
              Selected Date:      07/01/2006 to 09/30/2006
                   Payrolls:      0001 WEEKLY
                                  0002 BIWEEKLY
                                  0003 SEMI-MONTHLY
                                  0004 MONTHLY
                                  0007 QUARTERLY
                                  0009 ELECTION WORKERS
                                  0010 COMMITTEES
                                  0994 COUNTY COURT CLERK
                                  7028 CLERK & MASTER CHANCERY COURT
              —————————————————————————————-————————————————————————————————————————————————————————————————————————————————————————————————————
              Gross Salary:                                     2,687,618.50
              FIT Taxable Gross:                                2,485,344.34                   2,687,618.50
              Social Security Wage:                             2,649,705.75                   (116,250.75)
              Medicare Wage:                                    2,649,705.75                   (86,023.41)
              SIT Taxable Gross:                                                               (NDNTB Emp)
              Retirement Gross:                                 2,322,310.93                   Fringe Benefits
              FIT:                                              256,036.40
              Social Security:                                  164,280.69
              Medicare:                                         38,420.38                      2,485,344.34
              SIT:
              TCRS                Employee:                      116,250.75
                                  Employer:                      181,509.21
              Advanced Earned Income Credit:                                         2,687,618.50




                                                                                                                                                                            History Summary – Quarter 3
              Other Deductions    Employee:                     113,749.84           (37,912.75)
                                  Employer:                     389,332.90
              NDNTB               Employee:
                                  Employer:                                          2,649,705.75
              Cafeteria Plan:                                   37,912.75
              Deductions‘Sheltered From’ FIT:                   86,023.41
                                       Soc Sec:                 37,912.75
                                      Medicare:                 37,912.75
                                           SIT:                 17,470.45
                                    Retirement:
                        ‘Exempt From’ Soc Sec:
                                      Medicare:
              Net Pay:                                          1,998,880.44

              Employment Security Wage:                         2,435,382.54
              Employment Security:                              3,033.24
              —————————————————————————————-————————————————————————————————————————————————————————————————————————————————————————————————————
              Deductions                    Employee             Employer            Adjustments                   Hrs/Days            Amount

              0002 AFLAC - S                1,916.64                                |   0001 OVERTIME              2,132.75            40,312.08
              0003 BC/BS OF TN              16,316.40           279,962.28          |   * Class 01 OVERTIME        2,132.75            40,312.08
              0005 AFLAC - NS               776.52                                  |   0003 BACK PAY                                  1,498.06
              0008 UWAY                     311.58                                  |   0005 COMM MEET                                 3,675.00
              0009 DEFCOM                   47,277.38                               |   0006 OTHER PAY             202.50              6,481.01
              0011 RELIANCE OPTION          3,639.38                                |   0009 OTHER/SHER            1,235.00            16,469.40
              0014 DEF COMP (1ST)           624.96                                  |   0012 VAC PAY               61.00               519.11
              0018 DEF COMP (2ND)           208.32                                  |   * Class 02 OTHER PAY       1,498.50            28,642.58
              0021 USABLE - S               8,489.43                                |
              0023 USABLE - NS              1,034.28                                |
              0024 USABLE-STD-NS            3,603.88                                |
              0034 MUTUAL SAV-NS            51.30                                   |
              0036 DENTAL-SHELTER           6,790.24            16,688.11           |
              0038 MUTUAL - S               274.14                                  |
              0043 DISABILITY                                   13,215.11           |
              0054 RELIANCE-GROUP                               6,294.40            |
              0055 RELIANCE-GROUP                               48.00               |
              0063 PRESCRIPTION             4,125.90            73,125.00           |
              * Class 01 REGULAR VOL DED    95,440.35           389,332.90          |
              0057 MISC                     9,749.50                                |
              0059 MISC                     661.98                                  |
              0060 MISC                     7,274.91                                |
              0062 MISC                     623.10                                  |
              * Class 03 CRT ORDERED PAY    18,309.49                               |
              * = Class Totals* = Class Totals
17
                                     941 Report – Quarter 4



Name:         LGC Training Center                             Date Quarter Ended: 12/31/2006
Adr:          714 Armstrong Lane
City:         Columbia                                        Employer ID #: 62-6000744
State:        TN
Zip:          38401                                           State Tax #: 06262770


1.   Number Of Employees........................................    430
2.   Total Wages & Tips Subject To Withholding..................    2,060,509.66
3.   Total Income Tax Withheld From Wages & Tips................    228,887.53
4.   Adj. Of Withheld Income Tax Withheld.......................
5.   Adjusted Total Of Income Tax Withheld......................    228,887.53
6.   Taxable Soc Sec Wages......... 2,177,482.58 * 0.1240 =         270,007.84
     Actual Soc Sec Taxes.......................................    270,007.98
     Difference.................................................    0.14-
7.   Taxable Medicare Wages & Tips. 2,194,852.64 * 0.0290 =         63,650.73
     Actual Medicare Taxes......................................    63,650.78
     Difference.................................................    0.05-
8.   Total FICA Taxes (Add Lines 6 & 7).........................    333,658.57
9.   Adj. Of Soc Sec & Medicare.................................
10. Adj. Total Of Soc Sec & Medicare...........................     333,658.57
11. Total Taxes (Add Lines 5 & 10).............................     562,546.10
12. Advanced Earned Income Credit Payments Made................     0.00
13. Net Taxes (Subtract Line 12 From Line 11)..................     562,546.10
14. Total Deposits For Quarter.................................
15. Balance Due................................................




First Month Liability:          303,277.80
Second Month Liability:         259,268.30
Third Month Liability:          0.00
Total Liability For Quarter:    562,546.10

* End of Report: Local Government Data Demo *




LGC 12-2006                                                                               18
LGC 12-2006
              PYQ512    2006/12/03 11:32:48                                                     TOWN OF SAMPLEVILLE                                   FlexGen4(6.1U) Page: 1
                                                                                                  History Summary
              Selected Date:       10/01/2006 to 12/31/2006
                   Payrolls:       0001 WEEKLY
                                   0002 BIWEEKLY
                                   0003 SEMI-MONTHLY
                                   0004 MONTHLY
                                   0007 QUARTERLY
                                   0009 ELECTION WORKERS
                                   0010 COMMITTEES
                                   0994 COUNTY COURT CLERK
                                   7028 CLERK & MASTER CHANCERY COURT
              —————————————————————————————-————— ———————————————————————————————————————————— ———————————————— ———————————————————————————————————
              Gross Salary:                                      2,220,937.54
              FIT Taxable Gross:                                 2,060,509.66                   2,220,937.54
              Social Security Wage:                              2,177,482.58                   (97,258.00)
              Medicare Wage:                                     2,194,852.64                   (63,169.88)
              SIT Taxable Gross:                                                                (NDNTB Emp)
              Retirement Gross:                                  1,940,377.36                   Fringe Benefits
              FIT:                                               228,887.53
              Social Security:                                   135,003.99
              Medicare:                                          31,825.39                      2,060,509.66
              SIT:
              TCRS              Employee:                        97,258.00
                                Employer:                        152,222.73
              Advanced Earned Income Credit:                                         2,220,937.54
              Other Deductions Employee:                         85,396.84           (26,084.90)
                                Employer:                        260,089.30
                         NDNTB Employee:
                                Employer:                                            2,194,852.64




                                                                                                                                                                               History Summary – Quarter 4
              Cafeteria Plan:                                    26,084.90
              Deductions ‘Sheltered From’ FIT:                   63,169.88
                                       Soc Sec:                  26,084.90
                                      Medicare:                  26,084.90
                                           SIT:                  11,676.94
                                    Retirement:
                        ‘Exempt From’ Soc Sec:
                                      Medicare:
              Net Pay:                                           1,642,565.79
              Employment Security Wage:                         2,059,706.90
              Employment Security:                              1,345.72
              —————————————————————————————-————————————————————————————————————————————————————————————————————————————————————————————————————
              Deductions                    Employee             Employer            Adjustments                   Hrs/Days            Amount

              0002 AFLAC - S                1,262.81                                 |   0001 OVERTIME              1,628.60             32,644.41
              0003 BC/BS OF TN              11,507.36            185,782.74          |   * Class 01 OVERTIME        1,628.60             32,644.41
              0005 AFLAC - NS               517.68                                   |   0003 BACK PAY                                   17.16
              0008 UWAY                     251.02                                   |   0006 OTHER PAY             325.25               4,532.26
              0009 DEFCOM                   36,529.46                                |   0009 OTHER/SHER            775.15               10,378.56
              0011 RELIANCE OPTION          2,407.12                                 |   0012 VAC PAY               21.00                263.97
              0014 DEF COMP (1ST)           416.64                                   |   0013 COMP PAY              0.75                 9.43
              0018 DEF COMP (2ND)           138.88                                   |   * Class 02 OTHER PAY       1,122.15             15,201.38
              0021 USABLE - S               5,604.17                                 |   0004 LONGEVITY                                  105,800.00
              0023 USABLE - NS              689.52                                   |   * Class 05 LONGEVITY PAY                        105,800.00
              0024 USABLE-STD-NS            2,319.16                                 |
              0034 MUTUAL SAV-NS            34.20                                    |
              0036 DENTAL-SHELTER           4,627.20             11,097.04           |
              0038 MUTUAL - S               182.76                                   |
              0043 DISABILITY                                    10,479.72           |
              0054 RELIANCE-GROUP                                4,172.80            |
              0055 RELIANCE-GROUP                                32.00               |
              0063 PRESCRIPTION             2,900.60             48,525.00           |
              * Class 01 REGULAR VOL DED    69,388.58            260,089.30          |
              0057 MISC                     9,326.25                                 |
              0059 MISC                     757.79                                   |
              0060 MISC                     5,035.77                                 |
              0062 MISC                     519.25                                   |
              0064 MISC                     369.20                                   |
              * Class 03 CRT ORDERED PAY    16,008.26                                |
              * = Class Totals* = Class Totals
19
LGC 12-2006
              PYQ512       2006/01/16 08:32:54                                                         Local Government Data Demo                                                          FlexGen4(5.3U) Page: 1
                                                                                                            History Summary
              Selected Date:         01/01/2006 to 12/28/2006                                                  Take gross salary minus TCRS (employee), minus deductions sheltered from FIT, plus Fringe Benefits.
                   Payrolls:         0001 GENERAL HOURLY
                                     0002 GENERAL HOURLY                                                                 3502.00 – 175.10 – 147.53 + 1500 = 4679.37
                                     0003 WATER & SEWER HOURLY
              Name: DOE, JOHN        SSN 123-45-6789
                                                                                                               Take gross salary minus deductions sheltered from
                                                                                                              ___________________________________________            Soc Sec. Plus Fringe Benefits.
              Gross Salary:                                                      3,502.00                                  3502.00 - 95.00 + 1500.00 = 4907.00
              FIT Taxable Gross:                                                 4,679.37
              Social Security Wage:                                              4,907.00
              Medicare Wage:                                                     4,907.00
              SIT Taxable Gross:                                                                               Take gross salary minus deductions sheltered from Medicare. Plus Fringe Benefits.
              Retirement Gross:                                                  3,502.00                                3502.00 - 95.00 + 1500.00 = 4907.00
              FIT:                                                               647.55
              Social Security:                                                   304.23
              Medicare:                                                          71.15                          Take the Retirement Gross and multiply by the % that the employees pay in.
              SIT:
              TCRS              Employee:                                        175.10
                                Employer:
              Advanced Earned Income Credit:                                                                    Take the Retirement Gross and multiply by the % that the employer pays. in.
              Other Deductions Employee:                                         147.53
                                Employer:
              NDNTB             Employee:
                                Employer:                                                                       Total of all deductions listed at bottom of this report.
              Cafeteria Plan:                                                    95
              Deductions ‘Sheltered From’ FIT:        Reads check history for    147.53
                                        Soc Sec:
                                                      all wages being marked     95                             Total of only those deductions with the Cafeteria Plan field set to 01 (Yes) on the deduction
                                       Medicare:                                 95
                                             SIT:     as subject to Emp. Sec.                                   control. It doesn't matter how they were marked for being sheltered or not.
                                     Retirement:
              Net Pay:                                                           2,331.54
                                                                                                                Reads check history for all deductions marked as
              Employment Security Wage:                                          3,502.00
                                                                                                                being sheltered from Social Security.




                                                                                                                                                                                                                     History Summary
              Employment Security:                                               21.02

              Deductions                         Employee             Employer                         Adjustments                        Hrs/Days                Amount
              0005 LICOA HEART              95                                                         | 0004 AUTO-FRING                                          1,500.00
              0012 RETIREMENT (TSA)         52.53                                                      | * Class 03 FRINGE BENEFIT                                1,500.00
              * Class 01 REGULAR VOL DED    147.53                                                     |
              * = Class Totals
              * End of Report: Local Government Data Demo
                                                                                                                Reads check history for all deductions marked as
                                                                                                                being sheltered from Medicare.




                                                                  If the "Cafeteria Plan:" field is different than the "Deductions 'Sheltered from' FIT:", the difference should be your
                                                                  TSA amounts. If there are still differences, you should run the "Ded Flag Comparison" report from history to show
                                                                  you which deductions were marked differently than the control file.

                                                                  To run this report, you should access the Payroll Main Menu: 4. Reports, B. History, 5. Other, A. Ded Flag
                                                                  Comparison.
                                                                  Use the date range of 01/01/2006 through 12/31/2006. Select all deductions that might be affected by the cafeteria
                                                                  plan flag. If you are unsure, you can select all deductions.

                                                                  Note: If you find differences on this report that you don't know how to correct, call LGC phone support for
                                                                  Assistance.
20
LGC 12-2006




              PYQ572        2006/10/30 12:57:10                                  CUSTOMER NAME                                FlexGen4(5.3U) Page: 1

                                                                                   W2 Totals

              EIN: 62-0692693       Employer: CITY OF ANYWHERE

              Total W2’s:           67

              FIT Wages:             893,124.09     FIT:           102,932.22            SS Wage:       953,138.00     SS Tax:        59,094.56
              Medi Wage:             953,138.00     Medi Tax:      13,820.51             AEIC:                         Dep Care:
              Non-Q: Benefits:
              TCRS:                  43,807.55      DDNTB:         11,042.70             NDNTB:         1,200.00
              ————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————-——————
              Total W2’s:           67

              FIT Wages:            893,124.09     FIT:           102,932.22             SS Wage:       953,138.00     SS Tax:        59,094.56
              Medi Wage:            953,138.00     Medi Tax:      13,820.51              AEIC:                         Dep Care:




                                                                                                                                                       W2 Totals
              Non-Q:                               Benefits:
              TCRS:                 43,807.55      DDNTB:         11,042.70              NDNTB:         1,200.00

              ———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

              * End of Report: Local Government Data Demo *




              This should match the totals from a history summary report for the whole calendar year.
21
LGC 12-2006




              PYQ570        2006/ 10/30/2006 13:00                             CUSTOMER NAME                                 FlexGen4(5.3U) Page: 1


                                                                                   W2 REPORT


              EIN:   62-0692693    Employer: CITY OF ANYWHERE

              SSN:   123-45-6789   JOHN M DOE                                         Retirement Plan: X   Box 13



              FIT Wages:           17,486.66   Box1     FIT:      Box 2 1,937.68      SS Wage:      20,405.68       Box 3    SS Tax:       1,265.15   Box 4

              Medi Wage:           20,405.68   Box 5    Medi Tax: Box 6 295.88        AEIC:                         Box 9    Dep Care:                Box 10

              Non-Q:                           Box 11   Benefits: Box 12
              TCRS:                1,020.30    Box 14   DDNTB: Box 14 218.72          NDNTB:        1,200.00        Box 14




                                                                                                                                                               W2 Report
              * End of Report: Local Government Data Demo *
22
                                                                                   W2 Form
a. Control Number                                                              For Official Use Only
                                              22222            Void
                                                                               OMB No. 1545-0008
   1234567890
 b   Employer’s identification number                                                                  1     Wages, tips, other compensation              2     Federal income tax withheld
                                                                                                                             17486.66                                        1937.68
c    Employer’s name, address, and ZIP code                                                              3   Social security wages                        4     Social security tax withheld
                                                                                                                              20405.68                                       1265.15
      ABC COMPANY
                                                                                                         5   Medicare wages and tips                      6     Medicare tax withheld
      123 ELM STREET
                                                                                                                              20405.68                                         295.88
      COLUMBIA, TN
                                                                                                         7   Social security tips                        8    Allocated tips

d    Employee’s social security number                                                                   9   Advance EIC payment                         10 Dependent care benefits
     1234567890
e    Employee’s first name and initial         Last name                                                 11 Nonqualified plans                           12a See instructions for box 12
     JOHN M                                    DOE                                                                                                                          17486.66
                                                                                                       13    Statutory       Retirement   Third-party     12b
                                                                                                             employee         plan         sick pay
     201 EASY STREET
     COLUMBIA, TN 38401                                                                                  14 Other                                         12c
                                                                                                              TCRS  1020.30
                                                                                                              NDNTB 1200.00                               12d
                                                                                                              DDDNTB 218.72
f Employee’s address and ZIP code
15 State   Employer’s state ID number                 16 State wages, tips, etc.   17 State income tax                   18 Local wages, tips, etc.     19 Local income tax             20 Locality name




                         Wage and Tax                                                                                                     Department of the Treasury – Internal Revenue Service
Form      W-2 Statement
Copy A For Social Security Administration – Send this
entire page with Form W-3 to the Social Security
                                                                                        2005                                                      For Privacy Act and Paperwork Reduction
                                                                                                                                                                Act Notice, see back of Copy D


Administration; photocopies are not acceptable.
            Do Not Cut, Fold, or Staple Forms on This Page – Do Not Cut, Fold, or Staple Forms on This Page




LGC 12-2006                                                                                                                                                                                         23

								
To top