Spreadsheet: 882245d1730520039-extracting-pnl-data-from-excel-pnl-3b
Sheet: PTS Q1

 |  |  |  |  |  | Jan 1 - Mar 30, 24
 | Ordinary Income/Expense
 |  |  | Income
 |  |  |  | Fee Refunds
 |  |  |  |  | Patient Fees | -6437.74
 |  |  |  | Total Fee Refunds
 |  |  |  | Interest |  | 37.32
 |  |  |  | Mileage
 |  |  |  |  | School | 970.66
 |  |  |  | Total Mileage
 |  |  |  | Outpatient Services
 |  |  |  |  | School | 78815
 |  |  |  |  | Outpatient Services - Other | 993497.97
 |  |  |  | Total Outpatient Services
 |  |  | Total Income
 |  | Gross Profit
 |  |  | Expense
 |  |  |  | Advertising-PTS
 |  |  |  |  | Advertising-Gatlinburg | 451.61
 |  |  |  |  | Advertising-Pigeon Forge | 81.61
 |  |  |  |  | Advertising-Sevierville | 1076.85
 |  |  |  |  | Advertising-Seymour | 1787.39
 |  |  |  |  | Advertising - School | 299.27
 |  |  |  |  | Advertising-PTS - Other | 346.34
 |  |  |  | Total Advertising-PTS
 |  |  |  | Bank Service Charges
 |  |  |  |  | Mastercard/Visa Transaction Fee | 11025.78
 |  |  |  |  | Bank Service Charges - Other | 96.96
 |  |  |  | Total Bank Service Charges
 |  |  |  | Billing expense
 |  |  |  |  | Gatlinburg | 2238.47
 |  |  |  |  | [NAME] | 2238.47
 |  |  |  |  | School | 1119.23
 |  |  |  |  | Sevierville | 6355.57
 |  |  |  |  | [NAME] | 4253.08
 |  |  |  | Total Billing expense
 |  |  |  | Cable
 |  |  |  |  | [NAME] | 235.87
 |  |  |  |  | Veterans Blvd. | 271.87
 |  |  |  | Total Cable
 |  |  |  | Cable/Internet/Telephone
 |  |  |  |  | Gatlinburg | 700.43
 |  |  |  |  | [NAME] | 1193.78
 |  |  |  |  | Sevierville | 1302.66
 |  |  |  |  | [NAME] | 989.87
 |  |  |  | Total Cable/Internet/Telephone
 |  |  |  | Charitable Contributions |  | 100
 |  |  |  | Cleaning
 |  |  |  |  | Gatlinburg | 70
 |  |  |  |  | Pigeon Forge Clinic | 70
 |  |  |  |  | Sevierville Clinic | 1790
 |  |  |  |  | Seymour Clinic | 840
 |  |  |  | Total Cleaning
 |  |  |  | Clinical Expenses
 |  |  |  |  | Gatlinburg | 3840.56
 |  |  |  |  | [NAME] | 4724.92
 |  |  |  |  | School | 1344.78
 |  |  |  |  | Sevierville | 13827.8
 |  |  |  |  | [NAME] | 8667.51
 |  |  |  |  | Veterans | 1102.95
 |  |  |  | Total Clinical Expenses
 |  |  |  | Computer Software
 |  |  |  |  | Business Office | 1093.11
 |  |  |  |  | Sevierville | 576.52
 |  |  |  |  | [NAME] | 59.79
 |  |  |  | Total Computer Software
 |  |  |  | Copier Service Agreement
 |  |  |  |  | Business Office | 721.28
 |  |  |  |  | Gatlinburg Clinic | 159.72
 |  |  |  |  | Sevierville Clinic | 560.95
 |  |  |  |  | Seymour Clinic | 409.02
 |  |  |  | Total Copier Service Agreement
 |  |  |  | Dues and Subscriptions
 |  |  |  |  | Sevierville Clinic | 450
 |  |  |  | Total Dues and Subscriptions
 |  |  |  | Gifts/Flowers
 |  |  |  |  | Business Gift Cards | 2158
 |  |  |  |  | Donations | 610
 |  |  |  |  | GATLINBURG | 20
 |  |  |  |  | PIGEON FORGE | 20
 |  |  |  |  | SCHOOL | 10
 |  |  |  |  | SEVIERVILLE | 56.02
 |  |  |  |  | [NAME] | 38
 |  |  |  | Total Gifts/Flowers
 |  |  |  | Health Insurance
 |  |  |  |  | Business Office | 7851.15
 |  |  |  |  | Gatlinburg | 8464.64
 |  |  |  |  | [NAME] | 4947.79
 |  |  |  |  | School | 1512.7
 |  |  |  |  | Sevierville | 26611.1
 |  |  |  |  | [NAME] | 17606.09
 |  |  |  | Total Health Insurance
 |  |  |  | Health Savings Account
 |  |  |  |  | Business Office | 450
 |  |  |  |  | Gatlinburg clinic | 1350
 |  |  |  |  | Pigeon Forge Clinic | 1200
 |  |  |  |  | School | 450
 |  |  |  |  | Sevierville Clinic | 3600
 |  |  |  |  | Seymour Clinic | 1800
 |  |  |  | Total Health Savings Account
 |  |  |  | Human Resources
 |  |  |  |  | [NAME] | 39.99
 |  |  |  | Total Human Resources
 |  |  |  | Insurance
 |  |  |  |  | Cyber - Gatlinburg | 105.73
 |  |  |  |  | Cyber - Pigeon Forge | 105.73
 |  |  |  |  | Cyber - School | 52.84
 |  |  |  |  | Cyber - Sevierville | 296.03
 |  |  |  |  | Cyber - Seymour | 200.88
 |  |  |  |  | Key Man Insurance | 2750.09
 |  |  |  |  | Liability Insurance-Gatlinburg | 183.66
 |  |  |  |  | Liability Insurance-Pigeon Forg | 183.66
 |  |  |  |  | Liability Insurance-Sevierville | 514.24
 |  |  |  |  | Liability Insurance-Seymour | 348.96
 |  |  |  |  | Liability Insurance - School | 91.84
 |  |  |  |  | Life insurance-Seymour | 466.95
 |  |  |  |  | Life insurance - Business Offic | 71.18
 |  |  |  |  | Life Insurance - Gatlinburg | 186.6
 |  |  |  |  | Life Insurance - Pigeon Forge | 342.75
 |  |  |  |  | Life Insurance - School | 225.47
 |  |  |  |  | Life insurance - Sevierville | 759.48
 |  |  |  |  | Refund | 28.48
 |  |  |  | Total Insurance
 |  |  |  | Interest Expense
 |  |  |  |  | Line of Credit | 3720.83
 |  |  |  | Total Interest Expense
 |  |  |  | Internet
 |  |  |  |  | Business Office | 22.17
 |  |  |  |  | Gatlinburg Clinic | 261.37
 |  |  |  |  | [NAME] | 261.37
 |  |  |  |  | School | 130.69
 |  |  |  |  | Sevierville Clinic | 2508.82
 |  |  |  |  | Seymour Clinic | 496.6
 |  |  |  | Total Internet
 |  |  |  | Lawn Services
 |  |  |  |  | Lawn - Kodak | 90
 |  |  |  |  | Lawn - Pigeon Forge | 60
 |  |  |  | Total Lawn Services
 |  |  |  | Mileage Expense-PTS
 |  |  |  |  | Gatlinburg | 167.56
 |  |  |  |  | Mileage-Kodak | 8.02
 |  |  |  |  | [NAME] | 206.41
 |  |  |  |  | School | 1028.5
 |  |  |  |  | Sevierville | 425.8
 |  |  |  |  | [NAME] | 412.8
 |  |  |  |  | Veterans | 8.02
 |  |  |  | Total Mileage Expense-PTS
 |  |  |  | Miscellaneous Expense |  | 5
 |  |  |  | Office Supplies
 |  |  |  |  | Business Office | 174.47
 |  |  |  | Total Office Supplies
 |  |  |  | Payroll Expenses
 |  |  |  |  | Business Office | 55564.56
 |  |  |  |  | Gatlinburg Clinic | 50910.39
 |  |  |  |  | Pigeon Forge Clinic | 44231.44
 |  |  |  |  | School | 61084.93
 |  |  |  |  | Sevierville Clinic | 205770.39
 |  |  |  |  | Seymour Clinic | 120242.99
 |  |  |  |  | Payroll Expenses - Other | 7054.46
 |  |  |  | Total Payroll Expenses
 |  |  |  | Postage and Delivery
 |  |  |  |  | Business Office | 239.5
 |  |  |  |  | Sevierville | 42.74
 |  |  |  |  | Postage and Delivery - Other | 100
 |  |  |  | Total Postage and Delivery
 |  |  |  | Printing and Reproduction
 |  |  |  |  | Business Office | 368.79
 |  |  |  |  | Gatlinburg | 39.6
 |  |  |  |  | [NAME] | 39.6
 |  |  |  |  | Schools | 19.8
 |  |  |  |  | Sevierville | 390.83
 |  |  |  |  | [NAME] | 125.73
 |  |  |  | Total Printing and Reproduction
 |  |  |  | Professional Development
 |  |  |  |  | Gatlinburg Clinic | 704.75
 |  |  |  |  | Pigeon Forge Clinic | 19.95
 |  |  |  |  | School | 19.95
 |  |  |  |  | Sevierville Clinic | 193.99
 |  |  |  |  | Seymour Clinic | 729.9
 |  |  |  |  | Veterans | 19.95
 |  |  |  |  | Professional Development - Other | 19.95
 |  |  |  | Total Professional Development
 |  |  |  | Professional Fees
 |  |  |  |  | Accounting-Gatlinburg | 1048
 |  |  |  |  | Accounting-Pigeon Forge | 1048
 |  |  |  |  | Accounting-School | 524
 |  |  |  |  | Accounting-Sevierville | 2934.4
 |  |  |  |  | Accounting-Seymour | 1991.2
 |  |  |  |  | Shredding Service | 689.54
 |  |  |  | Total Professional Fees
 |  |  |  | Rent
 |  |  |  |  | 1107 Village Drive | 2400
 |  |  |  |  | Gatlinburg | 4875
 |  |  |  |  | [NAME] | 11550
 |  |  |  |  | Sevierville | 49200
 |  |  |  |  | [NAME] | 8400
 |  |  |  |  | Rent - Other | 2031.25
 |  |  |  | Total Rent
 |  |  |  | Repairs
 |  |  |  |  | Aquatic Pool-Sevierville | 141.83
 |  |  |  |  | Building Repairs-Pigeon Forge | 243
 |  |  |  |  | Building Repairs-Sevierville | 5336.65
 |  |  |  |  | Building Repairs-Seymour | 175.42
 |  |  |  |  | Fire Ext- Sevierville | 142.02
 |  |  |  | Total Repairs
 |  |  |  | Taxes
 |  |  |  |  | Sales | 199
 |  |  |  |  | State | 20.46
 |  |  |  | Total Taxes
 |  |  |  | Telephone
 |  |  |  |  | Gatlinburg Clinic | 58.45
 |  |  |  |  | Pigeon Forge Clinic | 58.45
 |  |  |  |  | School | 29.23
 |  |  |  |  | Sevierville Clinic | 163.66
 |  |  |  |  | Seymour Clinic | 111.06
 |  |  |  | Total Telephone
 |  |  |  | Travel & Ent
 |  |  |  |  | Lodging-Gatlinburg | 88
 |  |  |  |  | Lodging-Veterans | 238.32
 |  |  |  |  | Meal-Owner's Meeting | 53.92
 |  |  |  |  | Meals-Business Office | 1130.96
 |  |  |  |  | Meals-Gatlinburg | 620.52
 |  |  |  |  | Meals-Pigeon Forge | 378.69
 |  |  |  |  | Meals-Sevierville | 2116.43
 |  |  |  |  | Meals-Seymour | 1364.33
 |  |  |  |  | Meals-Veterans | 1232.59
 |  |  |  |  | Meals - School | 435.94
 |  |  |  | Total Travel & Ent
 |  |  |  | Uniforms
 |  |  |  |  | School | 26.22
 |  |  |  |  | Sevierville | 340.05
 |  |  |  | Total Uniforms
 |  |  |  | Utilities
 |  |  |  |  | Electric-1107 Village Drive | 779
 |  |  |  |  | Electric-Gatlinburg | 531
 |  |  |  |  | Electric-Pigeon Forge | 564
 |  |  |  |  | Electric-Sevierville | 3252
 |  |  |  |  | Electric - Seymour | 969
 |  |  |  |  | Gas-Pigeon Forge | 355.27
 |  |  |  |  | Gas-Sevierville Clinic | 2398.54
 |  |  |  |  | Gas-Seymour | 201.18
 |  |  |  |  | Water-1107 Village Drive | 62.34
 |  |  |  |  | Water-Gatlinburg | 86.8
 |  |  |  |  | Water-Sevierville | 732.96
 |  |  |  |  | Water - Pigeon Forge | 159.39
 |  |  |  | Total Utilities
 |  |  |  | Water
 |  |  |  |  | Gatlinburg-Bottled | 65.12
 |  |  |  |  | [NAME] | 82.68
 |  |  |  |  | [NAME] | 233.95
 |  |  |  | Total Water
 |  |  | Total Expense
 | Net Ordinary Income
Net Income