Excell spreadsheet payroll expense calculation/ integration

To be able to easily calculate payroll expenses for contracting work (1099 contractors) with integration into the general income and expense spreadsheet. Please find: Outdated 2018 in and out sheet format which was used in the past Attempted 2019 in and out sheet format to accomplish the following: 1) get Total treatments or evaluations rendered by each therapist per month 2) use those totals calculate the monthly payroll expense based on their individual pay rate structure for either regular treatments rendered (lower pay) versus evaluation and treatment rendered (higher pay) 3) calculate total expenses outgoing by month 4) calculate gross revenue by month and year 5) show monthly positive versus negative balance