Page 5 - Financial Workbook November
P. 5
Date: Dec 18, 2017 Towne Square Care of Puryear - SNF
Time: 16:41:19 CT INCOME STATEMENT
User: Zach Bell 11/1/2017 to 11/30/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 14 (14) 525 0.05 145 380
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 36 (36) 326 0.03 364 (37)
Employee Screening & Hire-ALF 0 0.00 2 (2) 69 0.01 24 45
Late Fees & Finance Charges 2 0.00 63 (61) 1,207 0.12 636 570
Late Fee/Finance Charges-ALF 0 0.00 2 (2) 89 0.01 24 65
Licenses & Permits 0 0.00 270 (270) 2,825 0.27 2,727 98
Licenses & Permits-ALF 0 0.00 46 (46) 1,775 0.17 461 1,314
Marketing Expenses 0 0.00 9 (9) 65 0.01 91 (26)
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.12 0 1,261
ADP Payroll Processing 0 0.00 144 (144) 1,483 0.14 1,454 28
ADP Payroll Processing - ALF 0 0.00 7 (7) 315 0.03 73 242
Payroll Exp - Payroll Taxes 0 0.00 0 0 (10,997) (1.06) 0 (10,997)
SUTA Taxes 0 0.00 855 (855) 8,774 0.84 8,634 140
SUTA Taxes ALF 0 0.00 22 (22) 822 0.08 218 604
FUTA Taxes 0 0.00 189 (189) 1,944 0.19 1,909 35
FUTA Taxes ALF 0 0.00 5 (5) 182 0.02 48 134
Payroll Exp - Workers Comp 2,405 2.10 468 1,937 7,214 0.69 4,727 2,487
Postage & Delivery Expenses 0 0.00 81 (81) 801 0.08 818 (17)
Printing & Copier Expense 144 0.13 162 (18) 1,835 0.18 1,636 199
Printing & Copier Expense-ALF 30 0.03 2 28 91 0.01 24 67
Professional fees - Accounting 1,114 0.97 162 952 2,742 0.26 1,636 1,106
Professional fees-Account-ALF 236 0.21 10 227 582 0.06 97 485
Professional Fees - Architect 0 0.00 450 (450) 4,656 0.45 4,545 111
Professional Fees - Arch. ALF 0 0.00 12 (12) 425 0.04 121 304
Professional Fees - Other 0 0.00 225 (225) 2,298 0.22 2,273 25
Software Expense 1,404 1.22 972 432 11,431 1.10 9,817 1,614
Software Expense-ALF 146 0.13 10 137 500 0.05 97 403
Supplies - Office 0 0.00 225 (225) 2,326 0.22 2,273 53
Supplies - Office-ALF 0 0.00 12 (12) 494 0.05 121 373
Travel expenses - Mileage 0 0.00 72 (72) 781 0.07 727 54
Travel expenses - Mileage-ALF 0 0.00 5 (5) 166 0.02 48 117
Bank Charges 0 0.00 0 0 13 0.00 0 13
Insurance - General Liability 3,190 2.78 2,619 571 28,677 2.75 26,452 2,225
Insurance - General Liabil-ALF 677 0.59 142 535 6,124 0.59 1,430 4,694
Insurance - Workers Compensati 0 0.00 1,242 (1,242) 12,835 1.23 12,544 291
Insurance WC ALF 0 0.00 31 (31) 1,203 0.12 315 888
Late Fees & Finance Charges 0 0.00 165 (165) 1,630 0.16 1,648 (18)
Licenses & Permits 0 0.00 90 (90) 900 0.09 909 (9)
Assessment Fees 7,183 6.26 6,147 1,036 70,548 6.77 62,085 8,464
Management Fees 14,438 12.59 10,872 3,566 126,438 12.13 99,695 26,743
Management Fees-ALF 3,063 2.67 725 2,338 31,063 2.98 7,320 23,742
Payroll Exp - Benefits 118 0.10 99 19 1,092 0.10 1,000 93
Payroll Exp - Payroll Taxes 7,835 6.83 6,831 1,004 78,181 7.50 68,993 9,188
Payroll Exp - Wages - PTO 2,432 2.12 981 1,451 12,538 1.20 9,908 2,630
Payroll Exp - Fac Admin 7,802 6.80 6,831 971 78,203 7.50 68,993 9,210
Payroll Exp-Admin Assist 2,321 2.02 2,322 (1) 26,237 2.52 23,452 2,785
Payroll Exp-Admin Assist-OT 163 0.14 279 (116) 3,015 0.29 2,818 197
Professional Fees - Accounting 0 0.00 1,224 (1,224) 12,599 1.21 12,362 236
Professional Fees- Account-ALF 0 0.00 60 (60) 2,306 0.22 606 1,700
Professional Fees - Legal 0 0.00 891 (891) 9,145 0.88 8,999 146
Professional Fees - Legal-ALF 0 0.00 450 (450) 1,940 0.19 909 1,031
Prof. Fees - Billing Services 0 0.00 149 (149) 1,464 0.14 1,454 10
Prof. Fees-Billing Serv-ALF 0 0.00 7 (7) 311 0.03 73 238
Professional Fees - Other 0 0.00 198 (198) 170 0.02 2,000 (1,830)
Professional Fees-Other-ALF 0 0.00 0 0 36 0.00 0 36
Rent Expense 21,000 18.31 12,231 8,769 147,000 14.11 123,533 23,467
Software Expense 550 0.48 477 73 5,500 0.53 4,818 682
Taxes - Personal Property 140 0.12 126 14 1,400 0.13 1,273 127
Taxes - Real Estate 1,848 1.61 1,611 237 18,480 1.77 16,271 2,209