Page 5 - Financial Workbook December
P. 5
Date: Jan 19, 2018 Towne Square Care of Puryear - SNF
Time: 17:51:55 CT INCOME STATEMENT
User: Zach Bell 12/1/2017 to 12/31/2017 Page # 4
CURRENT PERIOD YEAR TO DATE
Actual $ Actual / Day Budget $ Var $ Actual $ Actual / Day Budget $ Var $
GENERAL AND ADMINISTRATIVE (con't)
Conferences & Seminars-ALF 0 0.00 15 (15) 525 0.05 160 365
Employee Function Expense 0 0.00 0 0 33 0.00 0 33
Employee Function Expense-ALF 0 0.00 0 0 7 0.00 0 7
Employee Screening & Hiring 0 0.00 37 (37) 326 0.03 401 (75)
Employee Screening & Hire-ALF 0 0.00 2 (2) 69 0.01 27 43
Late Fees & Finance Charges 4 0.00 65 (61) 1,210 0.10 701 509
Late Fee/Finance Charges-ALF 0 0.00 2 (2) 90 0.01 27 63
Licenses & Permits 0 0.00 279 (279) 2,825 0.24 3,006 (181)
Licenses & Permits-ALF 0 0.00 47 (47) 1,775 0.15 508 1,267
Marketing Expenses 0 0.00 9 (9) 65 0.01 100 (35)
Marketing Expense-ALF 0 0.00 0 0 3 0.00 0 3
Meals & Entertainment 0 0.00 0 0 48 0.00 0 48
Meals & Entertainment-ALF 0 0.00 0 0 10 0.00 0 10
Miscellaneous Expense 0 0.00 0 0 1,261 0.11 0 1,261
ADP Payroll Processing 0 0.00 149 (149) 1,483 0.13 1,603 (121)
ADP Payroll Processing - ALF 0 0.00 7 (7) 315 0.03 80 234
Payroll Exp - Payroll Taxes 0 0.00 0 0 (10,997) (0.95) 0 (10,997)
SUTA Taxes 0 0.00 883 (883) 8,774 0.76 9,517 (743)
SUTA Taxes ALF 0 0.00 22 (22) 822 0.07 240 582
FUTA Taxes 0 0.00 195 (195) 1,944 0.17 2,104 (161)
FUTA Taxes ALF 0 0.00 5 (5) 182 0.02 53 129
Rehab Director 0 0.00 0 0 400 0.03 0 400
Payroll Exp - Workers Comp 2,405 2.06 484 1,921 9,619 0.83 5,210 4,409
Postage & Delivery Expenses 0 0.00 84 (84) 801 0.07 902 (101)
Printing & Copier Expense 133 0.11 167 (34) 1,968 0.17 1,804 165
Printing & Copier Expense-ALF 28 0.02 2 26 120 0.01 27 93
Professional fees - Accounting 0 0.00 167 (167) 2,742 0.24 1,804 938
Professional fees-Account-ALF 0 0.00 10 (10) 582 0.05 107 475
Professional Fees - Architect 750 0.64 465 285 5,406 0.47 5,010 396
Professional Fees - Arch. ALF 0 0.00 12 (12) 425 0.04 134 292
Professional Fees - Other 0 0.00 233 (232) 2,298 0.20 2,505 (207)
Software Expense 854 0.73 1,004 (150) 11,735 1.01 10,822 913
Software Expense-ALF 146 0.12 10 136 646 0.06 107 539
Supplies - Office 0 0.00 233 (232) 2,326 0.20 2,505 (179)
Supplies - Office-ALF 0 0.00 12 (12) 494 0.04 134 360
Travel expenses - Mileage 0 0.00 74 (74) 781 0.07 802 (20)
Travel expenses - Mileage-ALF 0 0.00 5 (5) 166 0.01 53 112
Bank Charges 0 0.00 0 0 13 0.00 0 13
Insurance - General Liability 3,190 2.73 2,706 484 31,867 2.75 29,158 2,709
Insurance - General Liabil-ALF 677 0.58 146 530 6,801 0.59 1,576 5,224
Insurance - Workers Compensati 0 0.00 1,283 (1,283) 12,835 1.11 13,828 (993)
Insurance WC ALF 0 0.00 32 (32) 1,203 0.10 347 856
Late Fees & Finance Charges 23 0.02 167 (145) 1,691 0.15 1,816 (125)
Late Fees/Finance Charges-ALF 0 0.00 0 0 8 0.00 0 8
Licenses & Permits 0 0.00 93 (93) 900 0.08 1,002 (102)
Assessment Fees 7,183 6.14 6,352 831 77,731 6.71 68,437 9,295
Management Fees 14,438 12.35 1,123 13,315 140,875 12.15 100,818 40,057
Management Fees-ALF 3,063 2.62 749 2,314 34,125 2.94 8,069 26,056
Payroll Exp - Benefits 0 0.00 102 (102) 1,092 0.09 1,102 (10)
Payroll Exp - Payroll Taxes 3,845 3.29 7,059 (3,214) 82,026 7.08 76,052 5,974
Payroll Exp - Wages - PTO 276 0.24 1,014 (738) 12,814 1.11 10,922 1,893
Payroll Exp - Fac Admin 6,974 5.97 7,059 (85) 85,177 7.35 76,052 9,125
Payroll Exp-Admin Assist 2,345 2.01 2,399 (55) 28,582 2.47 25,852 2,730
Payroll Exp-Admin Assist-OT 287 0.25 288 (1) 3,302 0.28 3,106 195
Professional Fees - Accounting 2,200 1.88 1,265 935 14,799 1.28 13,627 1,172
Professional Fees- Account-ALF 0 0.00 62 (62) 2,306 0.20 668 1,638
Professional Fees - Legal 0 0.00 921 (921) 10,998 0.95 9,920 1,078
Professional Fees - Legal-ALF 0 0.00 52 (52) 1,940 0.17 961 979
Prof. Fees - Billing Services 0 0.00 144 (144) 1,464 0.13 1,598 (134)
Prof. Fees-Billing Serv-ALF 0 0.00 7 (7) 311 0.03 80 230
Professional Fees - Other 0 0.00 205 (205) 170 0.01 2,204 (2,035)
Professional Fees-Other-ALF 0 0.00 0 0 36 0.00 0 36
Rent Expense 21,000 17.96 12,639 8,361 168,000 14.50 136,172 31,828
Software Expense 550 0.47 493 57 6,050 0.52 5,311 739