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

 |  |  |  |  |  | Apr - Jun 24
 | Ordinary Income/Expense
 |  |  | Income
 |  |  |  | Fee Refunds
 |  |  |  |  | Overpayment | -266.77
 |  |  |  |  | Patient Fees | -11974.68
 |  |  |  | Total Fee Refunds
 |  |  |  | Interest |  | -693.92
 |  |  |  | Mileage
 |  |  |  |  | School | 789.97
 |  |  |  |  | Mileage - Other | -481.73
 |  |  |  | Total Mileage
 |  |  |  | Outpatient Services
 |  |  |  |  | School | 69245
 |  |  |  |  | Senior Center/PJ Parkinsons | 280
 |  |  |  |  | Outpatient Services - Other | 1437931.74
 |  |  |  | Total Outpatient Services
 |  |  |  | WAKEFIELD |  | 590.29
 |  |  | Total Income
 |  | Gross Profit
 |  |  | Expense
 |  |  |  | Advertising-PTS
 |  |  |  |  | Advertising-Gatlinburg | 1008.96
 |  |  |  |  | Advertising-Pigeon Forge | 2295.05
 |  |  |  |  | Advertising-Sevierville | 3135.22
 |  |  |  |  | Advertising-Seymour | 5184.3
 |  |  |  |  | Advertising - School | 404.49
 |  |  |  |  | Veterans | 200
 |  |  |  |  | Advertising-PTS - Other | 85
 |  |  |  | Total Advertising-PTS
 |  |  |  | Bank Service Charges
 |  |  |  |  | [NAME] | 91.43
 |  |  |  |  | Handling Fee | 22.9
 |  |  |  |  | Mastercard/Visa Transaction Fee | 9648.02
 |  |  |  |  | Bank Service Charges - Other | 148.8
 |  |  |  | Total Bank Service Charges
 |  |  |  | Billing expense
 |  |  |  |  | Gatlinburg | 2071.47
 |  |  |  |  | [NAME] | 2071.47
 |  |  |  |  | School | 1035.74
 |  |  |  |  | Sevierville | 5896.06
 |  |  |  |  | [NAME] | 3935.8
 |  |  |  | Total Billing expense
 |  |  |  | Cable
 |  |  |  |  | [NAME] | 213.84
 |  |  |  | Total Cable
 |  |  |  | Cable/Internet/Telephone
 |  |  |  |  | Gatlinburg | 708.78
 |  |  |  |  | [NAME] | 1186.13
 |  |  |  |  | Sevierville | 1316.13
 |  |  |  |  | [NAME] | 967.7
 |  |  |  | Total Cable/Internet/Telephone
 |  |  |  | Charitable Contributions
 |  |  |  |  | Seymour Clinic | 100
 |  |  |  | Total Charitable Contributions
 |  |  |  | Cleaning |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  | Gatlinburg | 105
 |  |  |  |  | Pigeon Forge Clinic | 105
 |  |  |  |  | Sevierville Clinic | 1925
 |  |  |  |  | Seymour Clinic | 720
 |  |  |  | Total Cleaning
 |  |  |  | Clinical Expenses
 |  |  |  |  | Gatlinburg | 2711.68
 |  |  |  |  | [NAME] | 4000.67
 |  |  |  |  | School | 800.43
 |  |  |  |  | Sevierville | 10557.36
 |  |  |  |  | [NAME] | 8842.39
 |  |  |  |  | Veterans | 235.33
 |  |  |  |  | Clinical Expenses - Other | 9.22
 |  |  |  | Total Clinical Expenses
 |  |  |  | Computer Software
 |  |  |  |  | Business Office | 924.69
 |  |  |  |  | Gatlinburg | 258.38
 |  |  |  |  | [NAME] | 258.38
 |  |  |  |  | School | 129.2
 |  |  |  |  | Sevierville | 723.5
 |  |  |  |  | [NAME] | 572.61
 |  |  |  | Total Computer Software
 |  |  |  | Copier Service Agreement
 |  |  |  |  | Gatlinburg Clinic | 106.48
 |  |  |  |  | Sevierville Clinic | 1059.67
 |  |  |  |  | Seymour Clinic | 277.34
 |  |  |  | Total Copier Service Agreement
 |  |  |  | Distribution |  | 22244
 |  |  |  | Gifts/Flowers
 |  |  |  |  | Business Gift Cards | 308.7
 |  |  |  |  | Donations | 100
 |  |  |  |  | [NAME] | 59.75
 |  |  |  | Total Gifts/Flowers
 |  |  |  | Health Insurance
 |  |  |  |  | Business Office | 7772.48
 |  |  |  |  | Gatlinburg | 8590.98
 |  |  |  |  | [NAME] | 7080.42
 |  |  |  |  | School | 1602.54
 |  |  |  |  | Sevierville | 28222.46
 |  |  |  |  | [NAME] | 17787.77
 |  |  |  | Total Health Insurance
 |  |  |  | Health Savings Account
 |  |  |  |  | Business Office | 450
 |  |  |  |  | Gatlinburg clinic | 1350
 |  |  |  |  | Pigeon Forge Clinic | 900
 |  |  |  |  | School | 450
 |  |  |  |  | Sevierville Clinic | 4200
 |  |  |  |  | Seymour Clinic | 1800
 |  |  |  | Total Health Savings Account
 |  |  |  | Insurance
 |  |  |  |  | Cyber - Gatlinburg | 136.33
 |  |  |  |  | Cyber - Pigeon Forge | 136.33
 |  |  |  |  | Cyber - School | 68.14
 |  |  |  |  | Cyber - Sevierville | 381.71
 |  |  |  |  | Cyber - Seymour | 259.02
 |  |  |  |  | Key Man Insurance | 2174.13
 |  |  |  |  | Liability Insurance-Gatlinburg | 1745.46
 |  |  |  |  | Liability Insurance-Pigeon Forg | 1745.46
 |  |  |  |  | Liability Insurance-Sevierville | 4887.28
 |  |  |  |  | Liability Insurance-Seymour | 3316.38
 |  |  |  |  | Liability Insurance - School | 872.74
 |  |  |  |  | Life insurance-Seymour | 437.04
 |  |  |  |  | Life insurance - Business Offic | 65.88
 |  |  |  |  | Life Insurance - Gatlinburg | 186.6
 |  |  |  |  | Life Insurance - Pigeon Forge | 223.08
 |  |  |  |  | Life Insurance - School | 170.37
 |  |  |  |  | Life insurance - Sevierville | 759.48
 |  |  |  |  | Work Comp- School | 130.78
 |  |  |  |  | Work Comp-Gatlinburg | 261.54
 |  |  |  |  | Work Comp-Pigeon Forge | 261.54
 |  |  |  |  | Work Comp-Sevierville | 732.29
 |  |  |  |  | Work Comp-Seymour | 496.93
 |  |  |  | Total Insurance
 |  |  |  | Interest Expense
 |  |  |  |  | Line of Credit | 52414.58
 |  |  |  | Total Interest Expense
 |  |  |  | Internet
 |  |  |  |  | Business Office | 2086.03
 |  |  |  |  | Gatlinburg Clinic | 242.02
 |  |  |  |  | [NAME] | 242.02
 |  |  |  |  | School | 121.01
 |  |  |  |  | Sevierville Clinic | 677.67
 |  |  |  |  | Seymour Clinic | 2277.59
 |  |  |  | Total Internet
 |  |  |  | Lawn Services
 |  |  |  |  | Lawn - Kodak | 675
 |  |  |  |  | Lawn - Pigeon Forge | 90
 |  |  |  |  | [NAME] | 1380
 |  |  |  |  | Lawn Services - Other | 100
 |  |  |  | Total Lawn Services
 |  |  |  | Mileage Expense-PTS
 |  |  |  |  | Gatlinburg | 53.25
 |  |  |  |  | [NAME] | 151.63
 |  |  |  |  | School | 1141.93
 |  |  |  |  | Sevierville | 100.32
 |  |  |  |  | [NAME] | 263.34
 |  |  |  | Total Mileage Expense-PTS
 |  |  |  | Office Supplies
 |  |  |  |  | Sevierville | 146.15
 |  |  |  | Total Office Supplies
 |  |  |  | Payroll Expenses
 |  |  |  |  | Business Office | 63954.91
 |  |  |  |  | Gatlinburg Clinic | 64964.47
 |  |  |  |  | Pigeon Forge Clinic | 59845.57
 |  |  |  |  | School | 63549.95
 |  |  |  |  | Sevierville Clinic | 216069.12
 |  |  |  |  | Seymour Clinic | 139093.22
 |  |  |  | Total Payroll Expenses
 |  |  |  | Postage and Delivery
 |  |  |  |  | Business Office | 343.88
 |  |  |  |  | Gatlinburg | 10.43
 |  |  |  |  | Postage and Delivery - Other | 70.45
 |  |  |  | Total Postage and Delivery
 |  |  |  | Printing and Reproduction
 |  |  |  |  | [NAME] | 358.67
 |  |  |  | Total Printing and Reproduction
 |  |  |  | Professional Development
 |  |  |  |  | School | 295.64
 |  |  |  |  | Sevierville Clinic | 1185.64
 |  |  |  | Total Professional Development
 |  |  |  | Professional Fees
 |  |  |  |  | Accounting-Gatlinburg | 435
 |  |  |  |  | Accounting-Pigeon Forge | 435
 |  |  |  |  | Accounting-School | 217.5
 |  |  |  |  | Accounting-Sevierville | 1218
 |  |  |  |  | Accounting-Seymour | 826.5
 |  |  |  |  | Shredding Service | 645
 |  |  |  | Total Professional Fees
 |  |  |  | Rent
 |  |  |  |  | 1107 Village Drive | 2400
 |  |  |  |  | Gatlinburg | 4875
 |  |  |  |  | [NAME] | 11550
 |  |  |  |  | Sevierville | 49200
 |  |  |  |  | [NAME] | 8400
 |  |  |  | Total Rent
 |  |  |  | Repairs
 |  |  |  |  | Aquatic Pool-Sevierville | 97.84
 |  |  |  |  | Building Repairs-Gatlinburg | 30.7
 |  |  |  |  | Building Repairs-Sevierville | 787.2
 |  |  |  |  | Building Repairs-Seymour | 15.35
 |  |  |  |  | Fire Ext- Pigeon Forge | 55
 |  |  |  |  | HVAC | 767
 |  |  |  | Total Repairs
 |  |  |  | Taxes
 |  |  |  |  | Franchise Tax | 3000
 |  |  |  |  | Sales | 279
 |  |  |  | Total Taxes
 |  |  |  | Telephone
 |  |  |  |  | Gatlinburg Clinic | 58.82
 |  |  |  |  | Pigeon Forge Clinic | 58.82
 |  |  |  |  | School | 29.41
 |  |  |  |  | Sevierville Clinic | 164.72
 |  |  |  |  | Seymour Clinic | 1876.89
 |  |  |  | Total Telephone
 |  |  |  | Telephone-cell
 |  |  |  |  | Seymour Clinic - Travis | 203.84
 |  |  |  | Total Telephone-cell
 |  |  |  | Travel & Ent
 |  |  |  |  | Entertainment | 13.13
 |  |  |  |  | Lodging - School | 389.75
 |  |  |  |  | Meal-Owner's Meeting | 1023.38
 |  |  |  |  | Meals-Business Office | 243.54
 |  |  |  |  | Meals-Gatlinburg | 160.19
 |  |  |  |  | Meals-Pigeon Forge | 208.55
 |  |  |  |  | Meals-Sevierville | 114.63
 |  |  |  |  | Meals-Seymour | 812.4
 |  |  |  |  | Meals - School | 49.16
 |  |  |  |  | Travel - Seymour | 383
 |  |  |  | Total Travel & Ent
 |  |  |  | Uniforms
 |  |  |  |  | Business Office | 131.07
 |  |  |  |  | Gatlinburg | 45.85
 |  |  |  |  | [NAME] | 45.85
 |  |  |  |  | School | 22.93
 |  |  |  |  | Sevierville | 199.68
 |  |  |  |  | [NAME] | 218.19
 |  |  |  | Total Uniforms
 |  |  |  | Utilities
 |  |  |  |  | Electric-1107 Village Drive | 411
 |  |  |  |  | Electric-Gatlinburg | 445
 |  |  |  |  | Electric-Pigeon Forge | 609
 |  |  |  |  | Electric-Sevierville | 3382
 |  |  |  |  | Electric - Seymour | 1145
 |  |  |  |  | Gas-Pigeon Forge | 95.26
 |  |  |  |  | Gas-Sevierville Clinic | 1053.58
 |  |  |  |  | Gas-Seymour | 64.44
 |  |  |  |  | Water-Gatlinburg | 98.03
 |  |  |  |  | Water-Sevierville | 1001.8
 |  |  |  |  | Water - Pigeon Forge | 164.83
 |  |  |  |  | Water Seymour | 15
 |  |  |  | Total Utilities
 |  |  |  | Water
 |  |  |  |  | Gatlinburg-Bottled | 57.71
 |  |  |  |  | KODAK | 20.1
 |  |  |  |  | [NAME] | 134.07
 |  |  |  |  | [NAME] | 181.03
 |  |  |  | Total Water
 |  |  | Total Expense
 | Net Ordinary Income
Net Income