TPAF Reimbursement Report

Rows

Each row is an entry in the PayrollStaff table where pensionCode1 or pensionCode2 is TPAF for the given payroll.

How Each Column is calculated

Staff Id

The current staff Id of the Staff Member at the time the report is generated.   It is retrieved from the Staff table.

Name

The current last and first name of the Staff Member at the time the report is generated.  It is retrieved from the Staff table.

Total Wage

Gross Pay Medicare value on the PayrollStaff table.

Extra Comp / Imputed

Sum of non pensionable casual earnings (PayrollStaffCasualEarning).

+

The imputed amount on the PayrollStaff object.

Total Base Wage

= Total Wage - Extra Comp / Imputed

SS + Medi Base Wages

SS Medi Base Wages = Sum of applied wages on the Medicare deduction

Extra Comp is subtracted out of the SS Medi Base Wages if Extra Comp is a non zero value (+ or -) and SS Medi Base Wages is a non zero value (+ or -)

Medi Only Base Wage

Medi Only Base Wages = Total Base Wage - SS + Medi Base Wages

State Share Payable

Combined Rate = Rate of Medicare + Rate of Social Security (These values are looked up from the Payroll.Setup.Deductions screen).  For 2018 the values are 1.45 + 6.2 = 7.65

Value1 = SS + Medi Base Wages * Combined Rate.  Value1 is  0 if there are no Medi Base Wages.

Value 2 = Medi Only Base Wage * Rate of Medicare (In 2018 this is 1.45.  This value is looked up from the Payroll.Setup.Deductions screen).  Value2 is 0 if there are no Medi Only Base Wages

State Share Payable = Value1 + Value2

State Share Payable = Employee Share if If Xxtra Comp / Imputed = 0 and Total Base Wage > 0 and SS + Medi Base Wages > 0

Employee Share

Employee Share = Sum of Amount on Social Security and Medicare deductions

Board Share

Board Share = Employee Share - State Share Payable

Total to be Remitted by Board

Total Remit = Employee Share + Board Share + State Share Payable

The data for each staff member used in this report can be viewed on the Payroll Audit tab