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

 |  |  |  |  |  | Jan - Jun 24
 | Ordinary Income/Expense
 |  |  | Income
 |  |  |  | Fee Refunds
 |  |  |  |  | Overpayment | -266.77
 |  |  |  |  | Patient Fees | -18412.42
 |  |  |  | Total Fee Refunds
 |  |  |  | Interest |  | -656.6
 |  |  |  | Mileage
 |  |  |  |  | School | 1760.63
 |  |  |  |  | Mileage - Other | -489.75
 |  |  |  | Total Mileage
 |  |  |  | Outpatient Services
 |  |  |  |  | School | 148060
 |  |  |  |  | Senior Center/PJ Parkinsons | 280
 |  |  |  |  | Outpatient Services - Other | 2154643.71
 |  |  |  | Total Outpatient Services
 |  |  |  | WAKEFIELD |  | 590.29
 |  |  | Total Income
 |  | Gross Profit
 |  |  | Expense
 |  |  |  | Advertising-PTS
 |  |  |  |  | Advertising-Gatlinburg | 1460.57
 |  |  |  |  | Advertising-Pigeon Forge | 2376.66
 |  |  |  |  | Advertising-Sevierville | 4212.07
 |  |  |  |  | Advertising-Seymour | 6971.69
 |  |  |  |  | Advertising - School | 703.76
 |  |  |  |  | Veterans | 200
 |  |  |  |  | Advertising-PTS - Other | 431.34
 |  |  |  | Total Advertising-PTS
 |  |  |  | Bank Service Charges
 |  |  |  |  | [NAME] | 91.43
 |  |  |  |  | Handling Fee | 22.9
 |  |  |  |  | Mastercard/Visa Transaction Fee | 20673.8
 |  |  |  |  | Bank Service Charges - Other | 245.76
 |  |  |  | Total Bank Service Charges
 |  |  |  | BENEFITS |  | 2344
 |  |  |  | Billing expense
 |  |  |  |  | Gatlinburg | 4309.94
 |  |  |  |  | [NAME] | 4309.94
 |  |  |  |  | School | 2154.97
 |  |  |  |  | Sevierville | 12251.63
 |  |  |  |  | [NAME] | 8188.88
 |  |  |  | Total Billing expense
 |  |  |  | Cable
 |  |  |  |  | [NAME] | 449.71
 |  |  |  |  | Veterans Blvd. | 543.74
 |  |  |  | Total Cable
 |  |  |  | Cable/Internet/Telephone
 |  |  |  |  | Gatlinburg | 1409.21
 |  |  |  |  | [NAME] | 2379.91
 |  |  |  |  | Sevierville | 2618.79
 |  |  |  |  | [NAME] | 1957.57
 |  |  |  | Total Cable/Internet/Telephone
 |  |  |  | Charitable Contributions
 |  |  |  |  | Seymour Clinic | 100
 |  |  |  |  | Charitable Contributions - Other | 100
 |  |  |  | Total Charitable Contributions
 |  |  |  | Cleaning
 |  |  |  |  | Gatlinburg | 175
 |  |  |  |  | Pigeon Forge Clinic | 175
 |  |  |  |  | Sevierville Clinic | 3715
 |  |  |  |  | Seymour Clinic | 1560
 |  |  |  | Total Cleaning
 |  |  |  | Clinical Expenses
 |  |  |  |  | Gatlinburg | 6552.24
 |  |  |  |  | [NAME] | 8725.59
 |  |  |  |  | School | 2145.21
 |  |  |  |  | Sevierville | 24385.16
 |  |  |  |  | [NAME] | 17509.9
 |  |  |  |  | Veterans | 1338.28
 |  |  |  |  | Clinical Expenses - Other | 1451.09
 |  |  |  | Total Clinical Expenses
 |  |  |  | Computer Software
 |  |  |  |  | Business Office | 2017.8
 |  |  |  |  | Gatlinburg | 258.38
 |  |  |  |  | [NAME] | 258.38
 |  |  |  |  | School | 129.2
 |  |  |  |  | Sevierville | 1300.02
 |  |  |  |  | [NAME] | 632.4
 |  |  |  | Total Computer Software
 |  |  |  | Copier Service Agreement
 |  |  |  |  | Business Office | 721.28
 |  |  |  |  | Gatlinburg Clinic | 266.2
 |  |  |  |  | Sevierville Clinic | 1620.62
 |  |  |  |  | Seymour Clinic | 686.36
 |  |  |  | Total Copier Service Agreement
 |  |  |  | Distribution |  | 22244
 |  |  |  | Due to Kodak |  | -107479.44
 |  |  |  | Due to Veterans |  | -206604.7
 |  |  |  | Dues and Subscriptions
 |  |  |  |  | Sevierville Clinic | 450
 |  |  |  | Total Dues and Subscriptions
 |  |  |  | Gifts/Flowers
 |  |  |  |  | Business Gift Cards | 2466.7
 |  |  |  |  | Donations | 710
 |  |  |  |  | GATLINBURG | 20
 |  |  |  |  | PIGEON FORGE | 20
 |  |  |  |  | SCHOOL | 10
 |  |  |  |  | SEVIERVILLE | 56.02
 |  |  |  |  | [NAME] | 97.75
 |  |  |  |  | Gifts/Flowers - Other | 56
 |  |  |  | Total Gifts/Flowers
 |  |  |  | Health Insurance
 |  |  |  |  | Business Office | 15623.63
 |  |  |  |  | Gatlinburg | 17055.62
 |  |  |  |  | [NAME] | 12028.21
 |  |  |  |  | School | 3115.24
 |  |  |  |  | Sevierville | 54833.56
 |  |  |  |  | [NAME] | 35393.86
 |  |  |  | Total Health Insurance
 |  |  |  | Health Savings Account
 |  |  |  |  | Business Office | 900
 |  |  |  |  | Gatlinburg clinic | 2700
 |  |  |  |  | Pigeon Forge Clinic | 2100
 |  |  |  |  | School | 900
 |  |  |  |  | Sevierville Clinic | 7800
 |  |  |  |  | Seymour Clinic | 3600
 |  |  |  | Total Health Savings Account
 |  |  |  | Human Resources
 |  |  |  |  | [NAME] | 39.99
 |  |  |  | Total Human Resources
 |  |  |  | Insurance
 |  |  |  |  | Cyber - Gatlinburg | 242.06
 |  |  |  |  | Cyber - Pigeon Forge | 242.06
 |  |  |  |  | Cyber - School | 120.98
 |  |  |  |  | Cyber - Sevierville | 677.74
 |  |  |  |  | Cyber - Seymour | 459.9
 |  |  |  |  | Key Man Insurance | 4924.22
 |  |  |  |  | Liability Insurance-Gatlinburg | 1929.12
 |  |  |  |  | Liability Insurance-Pigeon Forg | 1929.12
 |  |  |  |  | Liability Insurance-Sevierville | 5401.52
 |  |  |  |  | Liability Insurance-Seymour | 3665.34
 |  |  |  |  | Liability Insurance - School | 964.58
 |  |  |  |  | Life insurance-Seymour | 903.99
 |  |  |  |  | Life insurance - Business Offic | 137.06
 |  |  |  |  | Life Insurance - Gatlinburg | 373.2
 |  |  |  |  | Life Insurance - Pigeon Forge | 565.83
 |  |  |  |  | Life Insurance - School | 395.84
 |  |  |  |  | Life insurance - Sevierville | 1518.96
 |  |  |  |  | Refund | 28.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 | 56135.41
 |  |  |  | Total Interest Expense
 |  |  |  | Internet
 |  |  |  |  | Business Office | 2108.2
 |  |  |  |  | Gatlinburg Clinic | 503.39
 |  |  |  |  | [NAME] | 503.39
 |  |  |  |  | School | 251.7
 |  |  |  |  | Sevierville Clinic | 3186.49
 |  |  |  |  | Seymour Clinic | 2774.19
 |  |  |  | Total Internet
 |  |  |  | Lawn Services
 |  |  |  |  | Lawn - Kodak | 855
 |  |  |  |  | Lawn - Pigeon Forge | 150
 |  |  |  |  | [NAME] | 1380
 |  |  |  |  | Lawn Services - Other | 100
 |  |  |  | Total Lawn Services
 |  |  |  | Mileage Expense-PTS
 |  |  |  |  | Gatlinburg | 220.81
 |  |  |  |  | Mileage-Kodak | 8.02
 |  |  |  |  | [NAME] | 358.04
 |  |  |  |  | School | 2170.43
 |  |  |  |  | Sevierville | 526.12
 |  |  |  |  | [NAME] | 676.14
 |  |  |  |  | Veterans | 8.02
 |  |  |  |  | Mileage Expense-PTS - Other | 8.02
 |  |  |  | Total Mileage Expense-PTS
 |  |  |  | Miscellaneous Expense |  | 5
 |  |  |  | Office Supplies
 |  |  |  |  | Business Office | 174.47
 |  |  |  |  | Sevierville | 146.15
 |  |  |  | Total Office Supplies
 |  |  |  | Operational Expenses PTS |  | 8138
 |  |  |  | Payroll Expenses
 |  |  |  |  | Business Office | 135077.47
 |  |  |  |  | Gatlinburg Clinic | 115874.86
 |  |  |  |  | Pigeon Forge Clinic | 104077.01
 |  |  |  |  | School | 124634.88
 |  |  |  |  | Sevierville Clinic | 421839.51
 |  |  |  |  | Seymour Clinic | 259336.21
 |  |  |  |  | Payroll Expenses - Other | 14108.92
 |  |  |  | Total Payroll Expenses
 |  |  |  | Pest Control |  | 105
 |  |  |  | Postage and Delivery
 |  |  |  |  | Business Office | 583.38
 |  |  |  |  | Gatlinburg | 10.43
 |  |  |  |  | Sevierville | 42.74
 |  |  |  |  | Postage and Delivery - Other | 170.45
 |  |  |  | Total Postage and Delivery
 |  |  |  | Printing and Reproduction
 |  |  |  |  | Business Office | 368.79
 |  |  |  |  | Gatlinburg | 39.6
 |  |  |  |  | [NAME] | 39.6
 |  |  |  |  | Schools | 19.8
 |  |  |  |  | Sevierville | 390.83
 |  |  |  |  | [NAME] | 484.4
 |  |  |  | Total Printing and Reproduction
 |  |  |  | Professional Development
 |  |  |  |  | Gatlinburg Clinic | 704.75
 |  |  |  |  | Pigeon Forge Clinic | 19.95
 |  |  |  |  | School | 315.59
 |  |  |  |  | Sevierville Clinic | 1379.63
 |  |  |  |  | Seymour Clinic | 729.9
 |  |  |  |  | Veterans | 39.9
 |  |  |  |  | Professional Development - Other | 19.95
 |  |  |  | Total Professional Development
 |  |  |  | Professional Fees
 |  |  |  |  | Accounting-Gatlinburg | 1483
 |  |  |  |  | Accounting-Pigeon Forge | 1483
 |  |  |  |  | Accounting-School | 741.5
 |  |  |  |  | Accounting-Sevierville | 4152.4
 |  |  |  |  | Accounting-Seymour | 2817.7
 |  |  |  |  | Shredding Service | 1334.54
 |  |  |  | Total Professional Fees
 |  |  |  | Rent
 |  |  |  |  | 1107 Village Drive | 4800
 |  |  |  |  | Gatlinburg | 9750
 |  |  |  |  | [NAME] | 23100
 |  |  |  |  | Sevierville | 98400
 |  |  |  |  | [NAME] | 16800
 |  |  |  |  | Rent - Other | 2031.25
 |  |  |  | Total Rent
 |  |  |  | Repairs
 |  |  |  |  | Aquatic Pool-Sevierville | 239.67
 |  |  |  |  | Building Repairs-Gatlinburg | 30.7
 |  |  |  |  | Building Repairs-Pigeon Forge | 243
 |  |  |  |  | Building Repairs-Sevierville | 6123.85
 |  |  |  |  | Building Repairs-Seymour | 190.77
 |  |  |  |  | Fire Ext- Pigeon Forge | 55
 |  |  |  |  | Fire Ext- Sevierville | 142.02
 |  |  |  |  | HVAC | 767
 |  |  |  | Total Repairs
 |  |  |  | Taxes
 |  |  |  |  | Franchise Tax | 3000
 |  |  |  |  | Sales | 478
 |  |  |  |  | State | 20.46
 |  |  |  | Total Taxes
 |  |  |  | Telephone
 |  |  |  |  | Gatlinburg Clinic | 117.27
 |  |  |  |  | Pigeon Forge Clinic | 117.27
 |  |  |  |  | School | 58.64
 |  |  |  |  | Sevierville Clinic | 328.38
 |  |  |  |  | Seymour Clinic | 1987.95
 |  |  |  | Total Telephone
 |  |  |  | Telephone-cell
 |  |  |  |  | Seymour Clinic - Travis | 203.84
 |  |  |  | Total Telephone-cell
 |  |  |  | Travel & Ent
 |  |  |  |  | Entertainment | 13.13
 |  |  |  |  | Lodging-Gatlinburg | 88
 |  |  |  |  | Lodging-Veterans | 476.64
 |  |  |  |  | Lodging - School | 389.75
 |  |  |  |  | Meal-Owner's Meeting | 1077.3
 |  |  |  |  | Meals- Kodak | 732.04
 |  |  |  |  | Meals-Business Office | 1374.5
 |  |  |  |  | Meals-Gatlinburg | 780.71
 |  |  |  |  | Meals-Pigeon Forge | 587.24
 |  |  |  |  | Meals-Sevierville | 2231.06
 |  |  |  |  | Meals-Seymour | 2176.73
 |  |  |  |  | Meals-Veterans | 2465.18
 |  |  |  |  | Meals - School | 485.1
 |  |  |  |  | Travel - Seymour | 383
 |  |  |  | Total Travel & Ent
 |  |  |  | Uniforms
 |  |  |  |  | Business Office | 131.07
 |  |  |  |  | Gatlinburg | 45.85
 |  |  |  |  | [NAME] | 45.85
 |  |  |  |  | School | 49.15
 |  |  |  |  | Sevierville | 539.73
 |  |  |  |  | [NAME] | 218.19
 |  |  |  | Total Uniforms
 |  |  |  | Utilities
 |  |  |  |  | Electric-1107 Village Drive | 1190
 |  |  |  |  | Electric-Gatlinburg | 976
 |  |  |  |  | Electric-Pigeon Forge | 1173
 |  |  |  |  | Electric-Sevierville | 6634
 |  |  |  |  | Electric - Seymour | 2114
 |  |  |  |  | Gas-Pigeon Forge | 450.53
 |  |  |  |  | Gas-Sevierville Clinic | 3452.12
 |  |  |  |  | Gas-Seymour | 265.62
 |  |  |  |  | Water-1107 Village Drive | 62.34
 |  |  |  |  | Water-Gatlinburg | 184.83
 |  |  |  |  | Water-Sevierville | 1734.76
 |  |  |  |  | Water - Pigeon Forge | 324.22
 |  |  |  |  | Water Seymour | 15
 |  |  |  | Total Utilities
 |  |  |  | Water
 |  |  |  |  | Gatlinburg-Bottled | 122.83
 |  |  |  |  | KODAK | 20.1
 |  |  |  |  | [NAME] | 216.75
 |  |  |  |  | [NAME] | 414.98
 |  |  |  | Total Water
 |  |  | Total Expense
 | Net Ordinary Income
Net Income