How to Calculate and Process Payroll

Table of Contents
...

Below is a table of items that need to be paid, where to find the numbers, the description of the pay item and corresponding Paylocity codes.

‍

‍

Billing Supervisors.

  • Corbitt, Deb =
  • Hamm, Shannon =
  • Heise, Mallory =
  • Lundy, Tracey =
  • Machlan, Bonna =  
  • Matlock, Shannon =
  • Seas, Jenifer =
  • Wittman, Kristen =

Payroll Notes

  • Make Jenny Luttman, Gross $3,000 - $0 net pay - Apply as much as possible to 401k, then to Fed Taxes.  Jenny needs to make around $80,000 a year.
  • Pay Luttman Management Company LLC (monthly - $1,200).  Pay on the last pay run of the month.

How to calculate the hours of counselors

  1. Go to TN Billing
  2. Set the Dates of the Search to the pay period dates.
  3. Click Search
  4. Click Export to Excel
  5. In Excel, insert a new “I” column, label it “Hours,” and insert this formula.  Be sure that all payable services codes are accounted for in the formula:
=IF(F2="90791",1*H2,IF(F2="90832",0.5*H2,IF(F2="90834",0.7*H2,IF(F2="90837",1*H2,IF(F2="90839",1*H2,IF(F2="90846",0.8*H2,IF(F2="90847",1*H2,IF(F2="90853",0.2*H2,IF(F2="99404",0.7*H2,IF(F2="90840",0.5*H2,IF(F2="00000",0.1*H2,"na")))))))))))
  1. Add a column to insert clinicians’ last names so you can sort by the last name in the Pivot table.
  2. Create a Pivot table to Sum up the Hours.
  1. Add the Hours to Paylocity >> Regular Pay
  2. Create an additional Pivot Table to count up the number of:
    1. SUPERVISION service codes
    2. SUPERVISION-30 service codes
    3. 90785 service codes
    4. T1017 service codes
    5. Missed Appointment ‘types’
  3. Add the above count/sum into the corresponding Paylocity pay types.