Transcript Usps calendar year end checklist

USPS RELEASE NOTES
• SEPTEMBER 2014 - USPS RELEASE SEPT 2014
• DECEMBER 2014 - USPS RELEASE DEC 2014
2
FRINGE BENEFITS/OTHER
IT IS PREFERABLE TO REVIEW/ENTER THESE ITEMS PRIOR TO
FINALIZING THE LAST PAYROLL OF THE YEAR.
____LIFE INSURANCE > $50,000 –ENTER AS NC1 WITH LAST PAYROLL OF THE YEAR *
____3RD PARTY SICK PAY. DO YOU HAVE A TAXABLE OR NON-TAXABLE PLAN? *
____REVIEW EMPLOYEE REIMBURSEMENTS HANDOUT *
____HSA PLANS – COMBINED EMPLOYEE/BD. SIDE AMTS. WILL PRINT TO BOX 12, CODE W.
DEDNAM MUST BE DEFINED AS TYPE “I”. EMPLOYER SPONSORED HEALTH CARE = N
____PPO PLANS – COMBINE EMPLOYEE/BD. SIDE AMTS. WILL PRINT TO BOX 12, CODE DD.
DEDNAM MUST BE DEFINED AS TYPE “D”. EMPLOYER SPONSORED HEALTH CARE = Y, IF APPLICABLE
____EMPLOYER SPONSORED HEALTH PLANS - IF PRINTING >250 W2’S, COMBINED
EMPLOYEE/BD/SIDE AMTS. WILL NEED TO PRINT IN BOX 12, CODE DD . IN DEDNAM, SET FLAG
“INCLUDE AS EMPLOYER-SPONSORED HEALTH COVERAGE” TO Y. RUN YTDDED REPORT.
____OTHER FRINGES – ADD TO DEDSCN 001 – EX. - MOVING EXPENSE, VEHICLE LEASE
____ACTIVE MILITARY *
____TERMINATED EMPLOYEES *
____DECEASED EMPLOYEES *
*DOCS ARE AVAILABLE ON ABOVE TOPICS FURTHER IN CHECKLIST AND ON OUR WEBSITE UNDER CY DOCUMENTATION
3
MONTH END CLOSING
____COMPLETE LAST PAYROLL OF THE YEAR
____RUN BENACC TO ACCUMULATE SICK/VACATION LEAVE.
____CHECK YOUR NEGOTIATED AGREEMENT PER HB 153, IF YOU ARE REQUIRED TO ACCRUE 4.6 HRS.
SICK PER >80 HRS WORKED. IF REQUIRED, SET BIOSCN PART-TIME FLAG TO Y. RUN MASCHG/MASSICK*
____RUN BRDDIS TO COLLECT BD. SIDE AMTS. FROM DEDSCN’S.
____RUN RETIRE FOR SERSREG AND STRSREG IN P MODE. VERIFY TOTALS EQUAL DEDUCTION OR
ELECTRONIC CHECKS. CORRECT DAYS IN ATDSCN USING AD RE AND/OR AD RH ENTRY. CREATE TAPE.
____RUN STRS_SEND TO AUTO E-MAIL STRSREG TO STRS.
____MDECA SENDS THE SERS TAPE FILE TO SERS BY THE 15TH OF THE NEXT MONTH
____RUN STRSMONTH WITH EACH PAYROLL TO CLEAR MTD TOTALS FROM 591/450/691 DEDSCN’S.
____RUN STRSHIRE/SERSHIRE/NEWHIRE TO COLLECT NEW EMPLOYEES FOR REPORTING. *
FOR OPTIONS IN SENDING THESE THREE NEW HIRE REPORTS.
___ RECONCILE CHECKS VIA THE CHKSTA PROGRAM.
____OPTIONALLY, RUN LEVPRO TO CHARGE SICK,VACATION,PERSONAL LEAVE TO BENEFIT ACCTS.
____IN AUTOPOST, ENSURE BATCHES HAVE BEEN POSTED: PAYROLL, VOID PAYROLL, BRDDIS, LEVPRO
____E-MAIL MDECA IF YOU HAVE OLD AUTOPOST BATCHES NEEDING DELETED.
4
QUARTER AND YEAREND BALANCING
___RUN PAYDED IN P MODE WITH NO CYCLES/DED. CODES TO CHECK FRO UNPAID BALANCES. DEDUCTIONS MUST BE PAID
IN YEAR INCURRED.
____RUN QRTRPT FOR INDIVIDUALS, OPTION N (DEMAND=DO NOT CLEAR). DEDUCTION TOTALS MUST EQUAL DEDUCTION
CHECKS/ELECTRONIC CHECKS AND CORRESPONDING WIRE TRANSFERS.
____RUN W2PROC. BALANCE TOTALS FROM QRTRPT AND W2REPT TO YOUR SPREADSHEET.
*
QRTRPT MUST BE BALANCED TO W2REPT PRIOR TO CREATING ADMOLD BACKUP DIRECTORY.
____THE (4) 941’S FOR THE YEAR MUST EQUAL W2REPT TO AVOID IRS PENALTIES.
____OPTIONALLY, FROM USPS_LCL, RUN PROGRAM BAL_QRTRPT. VIEW DEDGROSS.TXT AND JOBGROSS.TXT TO FURTHER ASSIST
WITH BALANCING. AUDRPT CAN BE RUN TO LOCATE MANUAL CHANGES.
____RECONCILE CHECKS USING CHKSTA PROGRAM. CHKSTA UNRECONCILED CAN BE USED IF A CHECK RECONCILED IN ERROR.
____RUN CHKSTS TO VERIFY ALL CHECKS STATUSES MATCH YOUR BANK STATEMENT.
____RUN CHKSTS IN VARIOUS FORMATS. RUN FOR P (OUTSTANDING) CHECKS. THIS IS ESPECIALLY HELPFUL IF SORTED BY
DEDUCTION CODE BY DATE TO ASSIST IN BALANCING.
____RUN ODJFSRPT WITH N TO CREATE TAPE. VERIFY TOTALS AND WEEKS. IN ATDSCN, AD OB +/- ENTRY CAN BE ENTERED TO
CORRECT WEEKS. *
____RUN ODJFSRPT WITH Y TO CREATE TAPE FILE. MDECA SUBMITS ALL DISTRICTS ODJFS TAPE FILES QUARTERLY.
5
CREATE ADMOLD BACKUP DIRECTORY
•
ONCE ALL TOTALS ARE IN BALANCE, GO TO USPS_LCL AND RUN CPY2ADMOLD TO CREATE
THE BACKUP DIRECTORY “ADMOLD.” THIS STEP CAN ONLY BE RUN ONCE.
•
•
IMMEDIATELY OPEN A NEW SESSION AND LOG INTO ADMOLD.
•
RUN A REPORT, EXAMPLE QRTRPT, IN ADMOLD TO VERIFY TOTALS FROM THE CURRENT
DIRECTORY AND ADMOLD DIRECTORY ARE THE SAME.
•
•
•
•
DO NOT CLEAR THE QRTRPT IN ADMOLD!
ADMOLD USERNAME = XXADMOLD, PASSWORD = XX_TREAS. (XX=2-DIGIT DISTRICT NAME)
YOU’LL THEN BE PROMPTED TO CHANGE THE PASSWORD. IF USAS STAFF CREATED ADMOLD
FIRST THE PASSWORD HAS ALREADY BEEN CHANGED. ASK THEM FOR P/W.
ADMOLD DIRECTORY IS NOW AVAILABLE FOR USE IN CREATING W2’S.
ADMOLD WILL BE MOVED TO USPS_HIST AFTER 4/15/15, THEN ADMOLD WILL BE DELETED.
ONLY COSMETIC CHANGES SHOULD BE DONE IN ADMOLD.
6
WHAT TO DO IN THE CURRENT DIRECTORY
•
AFTER YOU HAVE VERIFIED ADMOLD HAS BEEN SUCCESSFULLY CREATED, LOG INTO THE
CURRENT DIRECTORY AND CLEAR QRTRPT.
•
QRTRPT SHOULD BE RUN, OPTION Y TO CLEAR QTR/YTD. YOU CAN RERUN CHOOSING OPTION
N TO ENSURE ALL YTD’S ARE ZERO. DO NOT CLEAR FYTD.
•
CHKSTA CAN BE RUN TO CLEAR RECONCILED CHECKS. MDECA PURGES CHECKS FROM THE
CURRENT DIRECTORY EACH SEPTEMBER. SEPTEMBER 2015, CHECKS WILL BE PURGED THRU
6/30/14.
•
PAYDEL CAN BE RUN TO MASS DELETE OLD PAY ACCOUNTS. RUN IN PROJECTION MODE
BEFORE MASS DELETING PAYSCN’S. IT IS BEST TO RUN PAYACC PRIOR TO PAYDEL
THERE ARE 4 SELECTION CRITERIA OPTIONS IN PAYDEL PROGRAM:
DELETE PAY ACCOUNTS WITH AN INACTIVE PAY ACCOUNT STATUS (Y/N)
DELETE PAY ACCOUNTS THAT DO NOT HAVE A USAS BUDGET ACCOUNT? (Y/N)
DELETE PAY ACCOUNTS THAT ARE NO LONGER ACTIVE IN USAS? (Y/N)
DELETE PAY ACCOUNTS BASED ON THE FOLLOWING STOP DATE?__/__/__
•
CHGDED PROGRAM CAN BE USED TO DO MASS CHANGES TO DEDSCN’S.
7
PRIOR TO STARTING A 2015 PAYROLL …
1. ENTER CHANGES IN TAX WITHHOLDING RATES EFFECTIVE JANUARY 1, 2015
CITY TAX RATES
OSDI TAXES
2. CHECK FOR CHANGES IN PAYEE NAMES/ADDRESSES. CHANGE IN DEDNAM
3. RUN CHGDED PROGRAM TO MASS CHANGE OLD/NEW VALUES ON DEDSCN’S
4. UNSURE IF EMPLOYEE SHOULD BE TAXED? USE OHIO DEPT. OF TAXATIONS
THE FINDER TO LOOKUP BY ADDRESS, ZIP OR LATITUDE/LONGITUDE. LINK:
READY, SET, GO! YOU ARE NOW READY TO BEGIN A JANUARY PAYROLL
8
SIGN INTO ADMOLD WHEN READY TO WORK ON W2’S
PRE-W2 CLEANUP
•
•
•
•
•
•
•
•
WHEN LOGGING INTO ADMOLD IN REFLECTIONS, THE SCREEN MAY CHANGE
COLOR. CTRL/F3 TO SET COLOR BACK.
IF LOGGING INTO ADMOLD IN USPSWEB AFTER ENTERING ADMOLD’S
USERNAME/PASSWORD, USE THE DROP DOWN BOX TO CHOOSE ADMOLD
DIRECTORY OTHERWISE YOU WILL BE IN THE CURRENT DIRECTORY.
VERIFY EMPLOYEE NAMES/SSN’S.
VERIFYING SOCIAL SECURITY CARD NAME
DO NOT ENTER PUNCTUATION AS IRS WILL NOT ACCEPT.
SUFFIX = JR, SR, I,II,III, IV,V, MD, CPA, ESQ (NOT MR./MRS./MS)
NO HYPENS IN LAST NAMES
ENSURE NEW SOCIAL SECURITY CARD WAS PROVIDED IF EMPLOYEE CHANGED
NAMES SO THAT W2 PRINTS TO NAME ON SS CARD.
THERE ARE 3 MASS CHANGE PROGRAMS IN USPS:
MASCHG, USPCHG AND CHGDED. ACCESS TO SEE VARIOUS OPTIONS
9
PRE-W2PROC – OSDI ABBREVIATIONS
• INCLUDE 4-DIGIT OSDI CODE NUMBER IN FIRST PART OF DESCRIPTION IN
USPSDAT/DEDNAM – ONLY THE FIRST 6 WILL APPEAR ON W2.
10
PRE-W2PROC - CITIES
•
•
•
•
•
VERIFY ABBREV FOR CITY IS NOT “CITY”, AS THE CITY NAME NEEDS TO
PRINT ON W2.
START/STOP DATES SHOULD BE ENTERED IN DEDSCN IF CHANGES
OCCURRED MID-YEAR
VERIFY HONOR-ANNUITY CODES ARE ALL EXCEPT FOR SECTION 125
PLANS IN DEDNAM
VERIFY ‘ENTITY CODE’ IN DEDNAM IS ACCURATE FOR CITIES FILING BY
TAPE.
MDECA CREATES CITY TAPE FILES FOR.
DAYTON – ENTITIY CODE MUST BE DAYTO
ENGLEWOOD – ENTITY CODE MUST BE ENGLE
TROY – ENTITIY CODE MUST BE TROY
11
PRE-W2PROC – RITA TAPE FILE REQUIREMENTS
• VERIFY DEDSCN “EMPLOY/RESIDENCE” VALUE MUST BE ON ALL CITY DEDUCTIONS THAT
REPORT TO RITA
• IS THIS CITY TAX RECORD REQUIRED BECAUSE OF THE EMPLOYEES PLACE OF:
C = EMPLOYMENT
R = RESIDENCE
** IF THE EMPLOYEE LIVES AND WORKS IN THE SAME CITY, ENTER AS “C”.
12
PRE-W2PROC – USPSDAT/DEDNAM
VERIFY RITA CODES ARE SETUP CORRECTLY IF YOU PLAN TO BE ON RITA’S TAPE FILE
SEE WEBSITE: TAX RATES TABLES - REGIONAL INCOME TAX AGENCY WEB SITE
13
PRE-W2PROC
• VERIFY THE PENSION PLAN BOX IS DEFINED IN 001 DEDSCN
THIS WILL DETERMINE IF AN “X” WILL PRINT TO BOX 13 OF W2’S
A=AUTOMATICALLY CHECK IF ACTIVE RETIREMENT RECORD IS FOUND
Y=ALWAYS CHECK THE PENSION PLAN BOX
N=DO NOT CHECK THE PENSION PLAN BOX
14
PRE-W2PROC
–
HSA ACCOUNTS
• HSA’S NEED TO BE TYPE I” IN DEDNAM . COMBINED EMPLOYEE/BD. AMOUNTS WILL
PRINT TO BOX 12 CODE W. EMPLOYER SPONSOR PLAN SHOULD BE “N.”
• MDECA CAN ASSIST WITH SETUP, BUT YOU WILL NEED TO PROVIDE EXACT DETAILS ON
YOUR PLANS – 125’S OR HSAS AND Y/N TO EMPLOYER SPONSORED.
15
PRE-W2PROC – EMPLOYEE EXPENSE REIMBURSEMENTS
• IF AMOUNTS PAID THROUGH WARRANT CHECK DOES IT NEED TO APPEAR ON
THE W2 FORM AS WAGES?
• SPECIAL PROCESSING/MANUAL CHANGES MAY BE NEEDED
SEE DOC EXPENSE REIMBURSE 2014
16
PRE-W2PROC – EXCLUDABLE MOVING EXPENSES
- CONTACT LEGAL ADVISOR WITH QUESTIONS
- MANUALLY ENTER EXCLUDABLE AMOUNTS INTO 001 RECORD.
- CONTACT LEGAL ADVISOR WITH QUESTIONS
- MANUALLY ENTER EXCLUDABLE AMOUNTS INTO 001 RECORD.
17
PRE-W2PROC – FRINGE BENEFITS
• Fringe benefit amount- will increase gross/taxable gross on w2
- Contact legal advisor with questions
*Enter taxable amount in fringe benefit field on the federal tax record
18
PRE-W2PROC – DEPENDENT CARE
THIS SHOULD ONLY BE ENTERED IN THE 001 RECORD IF YOU DO
NOT HAVE A DEDNAM RECORD, TYPE DPCARE ALREADY ASSIGNED
AND BEING COLLECTED AS A WITHHOLDING.
19
PRE-W2PROC – USE OF COMPANY VEHICLE
-
- CALCULATE LEASED VEHICLE VALUE
- MANUALLY ENTER LEASED VEHICLE VALUE AMOUNT INTO THE FEDERAL TAX FIELD.
•
- WILL INCREASE GROSS/TAXABLE GROSS ON W2
20
PRE-W2PROC – LIFE INSURANCE >$50,000
ALSO SEE LINK - LIFE INS COST
•
•
•
•
•
•
•
IT IS BEST TO ENTER WITH A LAST PAYROLL OF THESE YEAR AS PAY TYPE “NC1”.
NC1 TYPE CAN BE ENTERED IN USPSCN/UPDCAL_CUR OR USPSCN/UPDCAL_FUT
PROGRAM.
THIS PAY TYPE REPRESENTS ONE KIND OF NON-CASH EARNINGS FOR THE EMPLOYEE.
DO NOT ENTER AMOUNT IN LIFE INS FIELD ON 001 DEDUCTION RECORD.
THIS PAY TYPE WILL BE TREATED DIFFERENTLY FOR TAXATION PURPOSES. USING THIS
NON-CASH EARNINGS AMOUNT. THE TAX AMOUNTS FOR MEDICARE AND SOCIAL
SECURITY WILL BE CALCULATED DURING THE CALCPAY AND UPDCAL_CUR PROGRAMS.
NO FEDERAL, OHIO, OR OSDI TAX AMOUNTS WILL BE CALCULATED. ALL OF THESE WILL BE
TREATED ACCORDING TO THE FEDERAL RULES. THE SOFTWARE PROVIDES THE ABILITY
TO WITHHOLD CITY TAX ON NON-CASH EARNINGS. THIS CAN BE ACTIVATED BY SETTING
THE "TAX NON-CASH EARNINGS" FLAG TO Y (YES) ON THE CITY TAX RECORD IN THE
USPSDAT/DEDNAM PROGRAM.
SEE IRS PUBLICATION 15-B FOR MORE INFORMATION
21
LIFE INSURANCE
OOPS…FORGOT TO ENTER AS AN NC1 WITH THE LAST PAYROLL
ENTER HERE…AND UPDATE YTD’S (SEE DOC)
22
PRE-W2PROC –
SEE LINK:
THIRD PARTY SICK PLANS
THIRD PARTY SICK - TAXABLE PLAN
THESE TOTALS WILL NEED TO BE ADDED MANUALLY BY INCREASING THE TOTAL AND
TAXABLE GROSS FIELDS ON THE FEDERAL, OHIO, OSDI AND MEDICARE RECORDS
THIRD PARTY SICK - NON-TAXABLE PLAN
23
EMPLOYER SPONSORED HEALTH CARE COST ON W2
IF PRINTING >250 W2’S COMBINED EMPLOYEE/BOARD SPONSORED INSURANCE MUST
BE REPORTED ON THE W2, BOX 12 CODE DD. MARK THE BELOW FIELD AS Y IF THE PLAN
SHOULD BE REPORTED ON THE W2.
HSA PLANS SHOULD NOT BE MARKED Y.
24
EMPLOYER SPONSORED HEALTH CARE COST ON W2
AND
HOW TO OVERRIDE THE DEDSCN’S YTD FIELDS
•
•
•
•
•
W2PROC WILL COLLECT THE COMBINED YTD VALUES FROM DEDSCN’S FLAGGED IN DEDNAM AS EMPLOYER
SPONSORED PLANS.
IF AN EMPLOYEE IS PAYING FOR INSURANCE OUT OF POCKET, THIS WILL NEED TO BE MANUALLY ADDED TO THE
‘EMPLR HTH’ FIELD ON THE EMPLOYEE’S 001 DEDUCTION RECORD. DO NOT INCREASE GROSS/TAXABLE GROSS ON
DEDSCNS.
IF THE EMPLOYEE IS PAID HALF A YEAR OUT OF POCKET AND THE OTHER HALF THROUGH PAYROLL, THESE TWO
AMOUNTS WILL NEED TO BE ADDED TOGETHER AND REPORTED ON FIELD ‘EMPLR HTH’ IN DEDSCN CODE 001.
IMPORTANT - RUN YTDDED TO VERIFY THE EMPLOYEE/BD. SIDE YTD TOTALS BY DEDUCTION CODE. VERIFY THE
COMBINED TOTAL FROM THE YTD FIELD ON DEDSCN’S SHOWN. IF YOU NEED TO OVERRIDE THESE VALUES, ENTER
THE COMBINED CORRECTED TOTAL ON THE 001 DEDSCN IN FIELD “EMPLR HTH’.
BOTTOM LINE – WHAT IS IN THE EMPLR HTH FIELD WILL THEN PRINT TO THE W-2 INSTEAD OF THE TOTALS FROM
THE YTD DEDSCN FIELDS. VERIFY ON W2REPT
25
W2PROC – EXPLANATION OF PROMPTS
DID ANOTHER ENTITY REPORT TAXES WITHHELD FOR 3RD PARTY SICK PAYMENTS?
THIS WOULD BE THE TAXABLE PLAN.
26
W2PROC – NEW FIELDS IN 2013
• 5 PROMPTS WERE ADDED TO W2PROC WHEN “Y” IS SELECTED TO CREATE THE
TAPE FILE FIELD:
• CONTACT NAME
• CONTACT PHONE NUMBER
• CONTACT PHONE EXTENSION
• CONTACT FAX NUMBER
• CONTACT E-MAIL ADDRESS
THESE FIELDS ARE NOT REQUIRED TO BE FILLED OUT , BUT IT IS HIGHLY
RECOMMENDED THAT THEY BE POPULATED SO THE DATA IS INCLUDED ON THE
W2TAPE FILE.
27
W2PROC – DEFINE DISTRICT, ANNUITY WARNING, FRINGES…
• ANSWER PROMPTS RELATING TO DISTRICT NAME, FEDERAL STATE ID’S - OR TAKE THE DEFAULT VALUES AS ENTERED IN USPCON SETUP SCREEN.
• DEFINE KIND OF EMPLOYER – IF UNSURE ASK YOUR TREASURER. VIEW
PAYROLLCD TO SEE LAST YEAR’S W2REPT IF NEEDED. SCHOOLS ARE S OR Y
• IF AN ANNUITY RECORD WARNING APPEARS DUE TO ANNUITY TYPE NOT
DEFINED, YOU MUST DEFINE IN DEDNAM RECORD .
• DO YOU WANT BOX 14 TO PRINT FRINGE BENEFITS IF THERE ARE ANY?
28
W2PROC – ADDITIONAL DEDUCTIONS ON W2
•
•
ALLOWS DISTRICTS TO PRINT ADDITIONAL INFORMATION IN BOX 14, “OTHER”
OPTIONAL - ADDITIONAL DEDUCTIONS NOT REQUIRED BY THE IRS
EX-RETIREMENT, UNION DUES
•
SIX CAN BE ENTERED
•
•
•
•
LEASED VEHICLE VALUE IS ALWAYS INCLUDED
OTHER USER VALUES ARE SECONDARY
PRINTS THE FIRST 3 FOR EACH EMPLOYEE IN THE ORDER ENTERED
DO NOT ENTER EMPLOYER SPONSORED HEALTH CARE OR HSA CODES HERE!
• ALIGNMENT FORMS-WOULD YOU LIKE TO PRINT A DUMMY W2 FOR FORM
ALIGNMENT? ANSWER N, AS THIS IS NOT REQUIRED FOR EDGE PRINTING
29
W2 BALANCING-IMPORTANT!
• INFORMATION ON W2REPT.TXT SHOULD BALANCE TO:
• QRTRPT AS QRTRPT TOTALS ARE USED TO COMPLETE 941
• ERNREG/ERNSUM FIGURES
•
REPRESENTS AMOUNTS AS WITHHELD FROM EMPLOYEES
• BALANCE FEDERAL, OHIO, AND CITY TAXES AND GROSS AMTS.
• ALL DEDUCTION CHECKS/WIRES MUST BALANCE
• MOST DISTRICTS ALSO KEEP A SPREADSHEET OF EACH PAYROLLS
•
•
•
TOTALS AND BALANCE THE SPREADSHEET TO QRTRPT/W2REPT
IT IS BEST TO FOLLOW THIS PROCESS EACH PAYROLL ESPECIALLY
IF CORRECTIONS HAVE BEEN MADE TO EMPLOYEE RECORDS.
AUDRPT SHOULD ALWAYS BE RUN TO LOOK FOR MANUAL CHANGES
ALL 4 941’S MUST EQUAL THE FINAL W2REPT
30
W2 BALANCING – VIEW END OF QRTRPT.TXT
31
Amounts in this column on
QRTRPT should be using
for balancing
W2 BALANCING – VIEW END OF W2REPT.TXT
32
Amounts in this column on
balancingW2REPT.TXT should be used
for
W2 BALANCING
•
•
ITEMS THAT AFFECT BALANCING BETWEEN W2PROC & QRTRPT
•
•
•
•
•
•
DEPENDENT CARE BENEFITS OVER LIMIT
FRINGE BENEFITS
MEDICARE PICKUP AMOUNTS
TAXABLE THIRD PARTY SICK PAY
USE OF COMPANY VEHICLE
EMPLOYEE EXPENSE REIMBURSEMENTS PAID THROUGH WARRANT
DEPENDENT CARE BENEFITS
•
•
•
AMOUNTS OVER LIMIT ($5,000.00) ADDED TO TOTAL AND TAXABLE GROSS AMOUNTS ON
FEDERAL, OHIO AND CITY TOTAL AND TAXABLE GROSS FIELDS ON THE W2REPT
EXAMPLE-IF $6000.00 IS ADDED TO DEPENDENT CARE FIELD ON 001 RECORD $1000.00
WILL BE ADDED TO TOTAL AND TAXABLE GROSS FIELDS. DO NOT ADD $ HERE IS YOU HAVE A
DEDNAM CODE, TYPE DPCARE
WILL CAUSE GROSS AMOUNTS ON W2REPT TO BE HIGHER.
33
W2 BALANCING
34
W2 BALANCING
FOR CITY OF “WORK” DEDNAM RECORDS- EMPLOYEES WITH PICKUPS:
•
IF THE “TAX BOARD AMOUNT “ FLAG IS SET TO N:
•
•
•
NO CITY TAX IS WITHHOLD WITH EACH PAYROLL
EMPLOYEE WILL OWE WHEN THEY FILE TAXES WITH THE CITY
TAX MED/FICA PICKUP SHOULD BE “Y” IF THE CITY TAXES THE MEDICARE PICKUP,
THEN ADD THE DED. CODE IN THE BLANK FIELDS BELOW: EXAMPLE : 690, 691, 694
•
•
IF THE ‘TAX BOARD AMOUNT’ IS SET TO Y:
•
•
THE TAX IS WITHHELD DURING THE PAYROLL
NO MEDICARE PICKUP IS ADDED TO THE CITY WAGES ON THE W2REPT. EVEN IF THE ‘TAX MED/FICA
PICKUP’ FLAG IS “Y”
USE OF COMPANY VEHICLE FIELD
•
ADDS THE VEHICLE LEASE AMOUNT FROM THE 001 FEDERAL RECORD TO THE TOTAL AND TAXABLE GROSS
FIELDS ON THE FEDERAL, AND OHIO TOTAL AND TAXABLE GROSS FIELDS ON THE W2 REPORT.
•
WILL CAUSE THE GROSS AMOUNTS ON W2REPT TO BE HIGHER
35
EMPLOYEE EXPENSE REIMBURSEMENTS
• IF YOU ADDED EMPLOYEE REIMBURSEMENTS ORIGINALLY PAID THROUGH
WARRANT CHECKS MANUALLY TO THE DEDSCN’S SO TOTALS WOULD APPEAR
ON THE W2 AS WAGES, THIS WILL CREATE A BALANCING DIFFERENCE
BETWEEN QRTRPT AND W2PROC
• MAY CAUSE W2PROC TO SHOW HIGHER GROSS AMOUNTS THAN ACTUALLY
PAID THROUGH USPS
36
W2/W2REPT BALANCING PROBLEMS
• VOIDED CHECKS FROM PRIOR CALENDAR YEAR
• RUN CHKSTS REPORT
• REFUND OF ANNUITY WITHHELD IN PRIOR CALENDAR YEAR
• RUN AUDRPT
• RUN W2PROC TO CHECK FOR W2ERR’S ON ANNUITIES
• MANUAL UPDATES
• RUN AUDRPT
•
DO A FIND ON QTD AND YTD TO LOCATE OLD/NEW VALUES
37
W2PROC REPORT
Special amounts
for W2s
Descriptions for
W2 boxes from
DEDNAM
Calculated gross
minus taxable gross
From
DEDSCN
38
COMMON W2PROC MESSAGES
• FATAL ERRORS MUST BE RESOLVED .
• A TAPE FILE CAN NOT BE SENT WITH FATALS.
• REVIEW THIS LINK FOR A COMPLETE LISTING OF W2ERR’S
• SEE LINK
- W2PROC ERRORS WARNINGS
39
W2 INSTRUCTIONS REVIEWED
• DECEASED EMPLOYEE’S WAGES
SEE IRS.GOV - INSTRUCTIONS FOR FORMS W-2 AND W-3
• IF PAYMENT IS MADE IN YEAR EMPLOYEE DIED
•
•
W2 REPORTING REQUIRED
•
1099 REPORTING REQUIRED
1099 REPORTING REQUIRED
• IF PAYMENT IS MADE IN YEAR AFTER THE DEATH OF EMPLOYEE
40
W2 INSTRUCTIONS REVIEWED
• DESIGNATED ROTH IRA AMOUNTS- DEDNAM TYPE “REG”, THEN FURTHER
DEFINE THE TYPE OF DESIGNATED ROTH FLAG CHOICES.
• EDUCATIONAL ASSISTANCE
• VERIFY TAXABILITY WITH LEGAL ADVISOR
• EMPLOYEE BUSINESS EXPENSE REIMBURSEMENTS
– 2014 INSTRUCTIONS FOR FORMS W-2 AND W-3
• VERIFY TAXABILITY WITH LEGAL ADVISOR
41
W2 INSTRUCTIONS REVIEWED
• SEE IRS.GOV, PUBLICATION 15-B
• EMPLOYEE TAXES PAID BY EMPLOYER - MEDICARE PICKUP
•
FRINGE BENEFITS
• VERIFY TAXABILITY WITH LEGAL ADVISOR
•
GROUP-TERM LIFE INSURANCE
• OVER $50,000 PROVIDED
• MUST USE PUBLICATION 15-B TABLE AND CALCULATE TAXABLE
VALUE OF PREMIUM
• NOTE: PRINT 15-B NOW – IRS UPDATES EARLY FOR NEW TAX YEAR
42
W2 INSTRUCTIONS REVIEWED
• BOX A
-2014 INSTRUCTIONS FOR FORMS W-2 AND W-3
EMPLOYEE SSN AS ENTERED IN BIOSCN
• BOX B - 2014 INSTRUCTIONS FOR FORMS W-2 AND W-3
FEDERAL EIN
• BOX C - 2014 INSTRUCTIONS FOR FORMS W-2 AND W-3
EMPLOYER INFORMATION AS ENTERED IN W2PROC
• BOXES E & F - SEE INSTRUCTIONS FOR FORMS W-2 AND W-3
• EMPLOYEE’S NAME AND ADDRESS
•
DATA FROM BIOSCN
•
•
USES LEGAL NAME IF A DIFFERENT NAME IS ENTERED ON BIOSCN SCREEN 2
OTHERWISE, USER NAME FROM BIOSCN SCREEN 1
43
W2 INSTRUCTIONS REVIEWED
BOX 1 – WAGES FROM FEDERAL TAXABLE GROSS - FROM FEDERAL 001 RECORD
BOX 2 -SEE 2014 INSTRUCTIONS FOR FORMS W-2 AND W-3
TAX WITHHELD FROM YTD FIELD ON FEDERAL 001 RECORD
BOX 3 –SEE 2014 INSTRUCTIONS FOR FORMS W-2 AND W-3
SOCIAL SECURITY WAGES FROM 692/693 RECORDS FLAGGED WITH DEDUCTION
CATEGORY “F”
BOX 4 – SEE INSTRUCTIONS FOR FORMS W-2 AND W-3
FICA TAXES WITHHELD FROM 692/693 AND 694/694 FLAGGED WITH DED. CATEGORY “F”
BOX 5 – INSTRUCTION FOR FORMS W-2 AND W-3
MEDICARE WAGES FROM 692/693 RECORDS FLAGGED WITH DED. CATEGORY OF “M”
44
•
W2 INSTRUCTIONS REVIEWED
BOX 12-CODES - SEE INSTRUCTIONS FOR FORMS W-2 & W-3
CODE C- GROUP-TERM LIFE OVER $50,000 COST
CODE D - 401(K) AMOUNTS
CODE E - 403(B)
CODE F – 408 (K) (6)
CODE G – 457 (B) 457 (F)
CODE H – 501 C(18) (D)
CODE J – NON TAXABLE SICK PAY
CODE P - EXCLUDABLE MOVING EXPENSES
CODE T - ADOPTION BENEFITS
CODE W - EMPLOYER /EMPLOYEE EXTRA CONTRIBUTIONS TO HSA’S
**EMPLOYER CONTRIBUTIONS INCLUDE SECTION 125 ANNUITY AMOUNTS THE EMPLOYEE CONTRIBUTES
CODE AA - DESIGNATED ROTH - SECTION 401(K)
CODE BB – DESIGNATED ROTH CONTRIBUTIONS – 403(B) PLAN
CODE DD – COST OF EMPLOYER SPONSORED HEALTH COVERAGE
CODE EE – DESIGNATED ROTH - 457 (B) PLAN
45
W2 INSTRUCTIONS REVIEWED
• BOX 13 – SEE 2013 INSTRUCTIONS FOR FORMS W-2 AND W-3
•
•
RETIREMENT PLAN
•
•
•
•
•
401(A)
401(K)
403(B)
408(K)
501C(18)
•
NOTICE 87-16 DEFINES “ACTIVE PARTICIPANT”
BOX 14 - OTHER – SEE 2014 INSTRUCTIONS FOR FORMS W-2 & W-3
•
•
VALUE OF VEHICLE LEASE FROM FEDERAL TAX RECORD
THE ADDITIONAL DEDUCTIONS ENTERED IN W2PROC
•
OPTIONAL POSSIBILITIES INCLUDE
•
•
UNION DUES
RETIREMENT
46
W3 INSTRUCTIONS
• W3 FORM, NOT REQUIRED TO BE SENT TO IRS UNLESS FILING ON PAPER
• MDECA ELECTRONICALLY FILES FOR ALL DISTRICTS IN FEBRUARY
• W2TAPE.SEQ TAPE FILE TOTALS (W2 SUBMISSION FILE) IS THE SUBSTITUTE
FOR W3
• NO W3 NEEDS TO BE SUBMITTED TO MDECA.
47
RUN W2PROC AND CREATE TAPE FILE “Y”
•
YOU ARE NOW READY TO RUN W2PROC AGAIN THIS TIME ANSWERING Y TO CREATE
TAPE FILE .
(MDECA WILL ALWAYS USE THE LATEST .SEQ TAPE FILES CREATED)
•
YOU WILL SEE THE FOLLOWING FILES CREATED:
W2FORM.TXT
W2REPT.TXT
W2CITY.DAT (IF DEDNAM ENTITIY CODE IS DEFINED, FOR DAYTON, TROY, ENGLEWOOD)
W2BREAK.TXT (ONLY IF SORT IS OTHER THAN S OR N) SORT ORDER IS YOUR CHOICE
W2ERR.TXT
W2RITA.SEQ (IF DEDNAM ENTITY AND RITA CODE ARE DEFINED)
W2TAPE.SEQ
•
RUN EMAIL_PDF TO CONVERT ANY .TXT REPORT TO .PDF AND AUTO E-MAIL YOURSELF
THE PDF..
•
OPTIONALLY, RUN YTDRPT, A REPORT OF YTD EARNINGS/BENEFIT STATEMENTS.
48
INFORM MDECA W2’S ARE READY!
•
E-MAIL [email protected] WHEN READY TO HAVE W2’S PRINTED
PLEASE CC: [email protected], [email protected]
•
•
•
•
INDICATE IF YOU NEED ONE OR TWO SETS OF EMPLOYEE W2’S
•
MDECA CAN REPRINT SPECIFIC W2’S AND 1099’S UPON REQUEST
DEADLINE FOR PRINTING IS 1/29/15.
MDECA WILL E-MAIL YOU WHEN FORMS ARE READY FOR PICKUP.
REPRINTS – IF ON KIOSK, EMPLOYEES CAN VIEW THEIR OWN FORMS OR
AN EMPLOYER COPY CAN BE GIVEN. MDECA POSTS W2’S TO KIOSK MIDFEBRUARY AFTER THE TAPE FILE HAS BEEN SENT TO THE IRS/SSA.
49
REPORTS,
TAPE FILES AND FORMS
•
STATE OF INDIANA. IF YOU HAVE >25 W2’S, YOU MUST FILE ELECTRONICALLY.
REGISTER PRIOR TO 12/31/XX. VISIT INDIANA DEPT. OF REVENUE’S WEBPAGE FOR
INSTRUCTIONS.
•
•
IT-941, IT-942 AND SD141 SHOULD BE FILED VIA OHIO BUSINESS GATEWAY.
•
FILE WITH CITIES - DETERMINE WHICH CITIES NEED COPIES OF W2’S, WHICH WILL
ACCEPT REPORT DEDW2CITY OR IF YOU PLAN TO BE INCLUDED ON A TAPE FILE.
•
VANDALIA TAX HUB PROCESSES VANDALIA, UNION, BROOKVILLE, CLAYTON AND W.
MILTON
•
•
HAMILTON TAX HUB PROCESSES PHILLIPSBURG
MDECA WILL SUBMIT W2 FILE TO THE STATE OF OHIO.
FAX/E-MAIL/MAIL AN IT-3 FORM TO MDECA BY 2/7/14.
ALL DISTRICTS MUST
TAPE FILES ARE AVAILABLE FOR:
DAYTON REQUIRED IF >100 W2’S, SUBMIT FORM DW-3 TO MDECA BY 2/7/14
TROY, SUBMIT FORM TW1 TO MDECA BY 2/7/14
ENGLEWOOD, SUBMIT FORM W-3 TO MDECA BY 2/7/14.
RITA, REQUIRED IF >250 W2’S, SUBMIT FORM 17 TO MDECA BY 2/7/14.
•
ALL OTHER CITES WILL NEED TO BE FILED MANUALLY.
50
W2 FOLLOWUP/ CALENDARCD
•
IN ADMOLD, UNDER USPS_ANN, DISTRICTS MUST RUN PROGRAM
CALENDARCD TO PLACE CY END REPORTS AND W2’S ON PAYROLLCD.
•
IF YOU SHOULD FIND ERRORS IN W2’S PRIOR TO MID-FEBRUARY,
CORRECTIONS CAN BE MADE IN ADMOLD AND A NEW W2TAPE FILE
CREATED. EMPLOYEE(S) WITH CORRECTIONS ONLY CAN BE RE-PRINTED.
CONTACT MDECA
•
IF YOU SHOULD FIND ERRORS IN W2’S AFTER MID-FEBRUARY AND MDECA
HAS ALREADY SENT THE TAPE FILE TO THE IRS/SSA. YOU WILL NEED TO
COMPLETE A MANUAL W2-C. CONTACT MDECA SHOULD THIS ARISE.
51
AND THAT IS IT FOR 2014 W2’S!
•
•
•
OPEN A HELPDESK TICKET IF YOU HAVE QUESTIONS.
QUESTIONS WILL BE ANSWERED IN ORDER OF SEVERITY
IF THE CALL CANNOT WAIT, CONTACT FISCAL SERVICE AT
937-223-1112
DECEMBER 2014
52