OSAS Payroll – Reconciling Federal State and Local Pay

Employee history contains monthly totals for all earnings codes and tax withholdings. To check federal, state and local totals print the following reports:

Periodic Processing

Quarterly Withholding Report

Gross and Summary Options

Generally the Federal, State and Local Wages should

agree. If they don’t agree, tax exclusion in your Codes Maintenance – Withholdings needs to be updated. If you need assistance getting the wages to agree, we can send you a program that will make them all agree based on the federal wages.

Quarterly Employers Tax report

Summary Option

SUI wages seem to vary from state to state.

Gross wages should equal

SUI Earnings + Excess SUI in some states.

Gross Wages – Cafeteria Amounts should

equal SUI Earnings + Excess SUI in other states.

Gross Wages – Cafeteria Amounts should

equal FUTA Earnings + Excess FUTA.

If you need assistance getting the wages to agree, we can send you a program that will make them all agree based on the gross wages.

??????????????????????????????

These totals are updated and summarized by the following:

+ REG

+ OVT

+ BON

+ COM

+ ALL OTHER PAY CODES

_________________________

= GROSS PAY

+ GROSS PAY

- DEDUCTIONS FEDERAL EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

FEDERAL - FWH)

_________________________

= FWH FEDERAL PAY

+ GROSS PAY

- DEDUCTIONS OASDI EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

FEDERAL - OAS)

_________________________

= OAS EMPLOYEE OASDI PAY

+ GROSS PAY

- DEDUCTIONS MEDICARE EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

FEDERAL - MED)

_________________________

= OAS EMPLOYEE MEDICARE PAY

+ GROSS PAY

- DEDUCTIONS EOA EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

FEDERAL - EOA)

_________________________

= OAS EMPLOYER OASDI PAY

+ GROSS PAY

- DEDUCTIONS EME EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

FEDERAL - EME)

_________________________

= EME EMPLOYER MEDICARE PAY

+ GROSS PAY

- DEDUCTIONS FUTA EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

FEDERAL - FUT)

_________________________

= FUT EMPLOYER FEDERAL UNEMPLOYMENT PAY

+ GROSS PAY

- DEDUCTIONS STATE EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

STATE - SWH)

_________________________

= SWH STATE PAY

+ GROSS PAY

- DEDUCTIONS SUTA EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

STATE - SUI)

_________________________

= SUI EMPLOYER STATE UNEMPLOYMENT PAY

+ GROSS PAY

- DEDUCTIONS LOCAL EXCLUSIONS (CODES MAINTENANCE – WITHOLDINGS EXCLUSION

LOCAL - LWH)

_________________________

= SWH LOCAL PAY

GENERAL RULE