Spreadsheet: 879636d1727206327-extracting-data-from-profit-and-loss-statement-p-and-ls-qtr-2
Sheet: PTS 7-1-23 TO 6-30-24

 |  |  |  |  |  | Jul '23 - Jun 24
 | Ordinary Income/Expense
 |  |  | Income
 |  |  |  | Fee Refunds |  |  |  |  | Mileage | School | 3404.4
 |  |  |  |  | Overpayment | -266.77 |  |  | Outpatient Services | School | 317405
 |  |  |  |  | Patient Fees | -29752.71 |  |  | Advertising-PTS | Advertising - School | 2094.27
 |  |  |  | Total Fee Refunds |  | -30019.48 |  |  | Billing expense | School | 6840.92
 |  |  |  | Interest |  | -547.86 |  |  | Clinical Expenses | School | 4297.3
 |  |  |  | Mileage |  |  |  |  | Computer Software | School | 129.2
 |  |  |  |  | School | 3404.4 |  |  | Gifts/Flowers | SCHOOL | 10
 |  |  |  |  | Mileage - Other | -489.75 |  |  | Health Insurance | School | 4905.1
 |  |  |  | Total Mileage |  | 2914.65 |  |  | Health Savings Account | School | 1800
 |  |  |  | Outpatient Services |  |  |  |  |  | Cyber - School | 120.98
 |  |  |  |  | School | 317405 |  |  |  | Liability Insurance - School | 1488.02
 |  |  |  |  | Senior Center/PJ Parkinsons | 875 |  |  |  | Life Insurance - School | 718.29
 |  |  |  |  | Outpatient Services - Other | 4247613.46 |  |  |  | Work Comp- School | 458.34
 |  |  |  | Total Outpatient Services |  | 4565893.46 |  |  | Internet | School | 1305.61
 |  |  |  | WAKEFIELD |  | 590.29 |  |  | Mileage Expense-PTS | School | 4733.5
 |  |  | Total Income |  |  | 4538831.06 |  |  | Payroll Expenses | School | 266821.01
 |  | Gross Profit |  |  |  | 4538831.06 |  |  | Printing and Reproduction | Schools | 84.19
 |  |  | Expense |  |  |  |  |  | Professional Development | School | 2123.19
 |  |  |  | Advertising-PTS |  |  |  |  | Professional Fees | Accounting-School | 741.5
 |  |  |  |  | Advertising-Gatlinburg | 4118.99 |  |  | Telephone | School | 180.01
 |  |  |  |  | Advertising-Pigeon Forge | 3402.43 |  |  | Travel & Ent | Lodging - School | 969.29
 |  |  |  |  | Advertising-Sevierville | 10534.84 |  |  |  | Meals - School | 685.1
 |  |  |  |  |  |  |  |  |  | Travel-School | 560.15
 |  |  |  |  | Advertising-Seymour | 10382.92 |  |  | Uniforms | School | 110.5
 |  |  |  |  | Advertising - LeConte | 0 |  |  | Charitable Contributions | School | 47.5
 |  |  |  |  | Advertising - School | 2094.27 |  |  | Postage and Delivery | School | 30.41
 |  |  |  |  | Veterans | 200
 |  |  |  |  | Advertising-PTS - Other | 431.34
 |  |  |  | Total Advertising-PTS |  | 31164.79
 |  |  |  | Bank Service Charges
 |  |  |  |  | [NAME] | 256.43
 |  |  |  |  | Handling Fee | 46.9
 |  |  |  |  | Mastercard/Visa Transaction Fee | 39024.9
 |  |  |  |  | Stop Payment Fee | 35
 |  |  |  |  | Bank Service Charges - Other | 245.76
 |  |  |  | Total Bank Service Charges |  | 39608.99
 |  |  |  | BENEFITS |  | 2344
 |  |  |  | Billing expense
 |  |  |  |  | Gatlinburg | 8995.89
 |  |  |  |  | [NAME] | 8995.89
 |  |  |  |  | School | 6840.92
 |  |  |  |  | Sevierville | 26737.32
 |  |  |  |  | [NAME] | 16574.24
 |  |  |  | Total Billing expense |  | 68144.26
 |  |  |  | Cable
 |  |  |  |  | [NAME] | 375.15
 |  |  |  |  | [NAME] | 727.52
 |  |  |  |  | Veterans Blvd. | 543.74
 |  |  |  | Total Cable |  | 1646.41
 |  |  |  | Cable/Internet/Telephone
 |  |  |  |  | Gatlinburg | 2795.27
 |  |  |  |  | [NAME] | 4620.12
 |  |  |  |  | Sevierville | 5278.51
 |  |  |  |  | [NAME] | 3447.67
 |  |  |  | Total Cable/Internet/Telephone |  | 16141.57
 |  |  |  | Charitable Contributions
 |  |  |  |  | Gatlinburg Clinic | 47.5
 |  |  |  |  | Pigeon Forge Clinic | 47.5
 |  |  |  |  | School | 47.5
 |  |  |  |  | Sevierville Clinic | 145
 |  |  |  |  | Seymour Clinic | 327.68
 |  |  |  |  | Charitable Contributions - Other | 100
 |  |  |  | Total Charitable Contributions |  | 715.18
 |  |  |  | Cleaning
 |  |  |  |  | Gatlinburg | 350
 |  |  |  |  | Pigeon Forge Clinic | 350
 |  |  |  |  | Sevierville Clinic | 9855
 |  |  |  |  | Seymour Clinic | 3520
 |  |  |  | Total Cleaning |  | 14075
 |  |  |  | Clinical Expenses
 |  |  |  |  | Gatlinburg | 11778.48
 |  |  |  |  | [NAME] | 13617.78
 |  |  |  |  | School | 4297.3
 |  |  |  |  | Sevierville | 44714.71
 |  |  |  |  | [NAME] | 28859.8
 |  |  |  |  | Veterans | 1338.28
 |  |  |  |  | Clinical Expenses - Other | 1441.87
 |  |  |  | Total Clinical Expenses |  | 106048.22
 |  |  |  | Computer Software
 |  |  |  |  | Business Office | 2961.11
 |  |  |  |  | Gatlinburg | 213.76
 |  |  |  |  | [NAME] | 258.38
 |  |  |  |  | School | 129.2
 |  |  |  |  | Sevierville | 1837.79
 |  |  |  |  | [NAME] | 1215.46
 |  |  |  | Total Computer Software |  | 6615.7
 |  |  |  | Copier Service Agreement
 |  |  |  |  | Business Office | 721.28
 |  |  |  |  | Gatlinburg Clinic | 1021.05
 |  |  |  |  | Pigeon Forge Clinic | 965.43
 |  |  |  |  | Sevierville Clinic | 3293.7
 |  |  |  |  | Seymour Clinic | 1636.27
 |  |  |  | Total Copier Service Agreement |  | 7637.73
 |  |  |  | Distribution |  | 122244
 |  |  |  | Due to Kodak |  | -105663.75
 |  |  |  | Due to Veterans |  | -202623.53
 |  |  |  | Dues and Subscriptions
 |  |  |  |  | Sevierville Clinic | 742.32
 |  |  |  |  | Seymour Clinic | 710.91
 |  |  |  | Total Dues and Subscriptions |  | 1453.23
 |  |  |  | Fraud |  | -89.25
 |  |  |  | Gifts/Flowers
 |  |  |  |  | Business Gift Cards | 2595.69
 |  |  |  |  | Donations | 710
 |  |  |  |  | GATLINBURG | 20
 |  |  |  |  | PIGEON FORGE | 20
 |  |  |  |  | SCHOOL | 10
 |  |  |  |  | SEVIERVILLE | 56.02
 |  |  |  |  | [NAME] | 97.75
 |  |  |  |  | Gifts/Flowers - Other | 347.45
 |  |  |  | Total Gifts/Flowers |  | 3856.91
 |  |  |  | Health Insurance
 |  |  |  |  | Business Office | 21168.64
 |  |  |  |  | Gatlinburg | 25895.99
 |  |  |  |  | [NAME] | 18384.69
 |  |  |  |  | School | 4905.1
 |  |  |  |  | Sevierville | 83228.79
 |  |  |  |  | [NAME] | 53877.14
 |  |  |  | Total Health Insurance |  | 207460.35
 |  |  |  | Health Savings Account
 |  |  |  |  | Business Office | 1050
 |  |  |  |  | Gatlinburg clinic | 5400
 |  |  |  |  | Pigeon Forge Clinic | 3900
 |  |  |  |  | School | 1800
 |  |  |  |  | Sevierville Clinic | 14850
 |  |  |  |  | Seymour Clinic | 7350
 |  |  |  | Total Health Savings Account |  | 34350
 |  |  |  | Human Resources
 |  |  |  |  | [NAME] | 39.99
 |  |  |  | Total Human Resources |  | 39.99
 |  |  |  | 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 | 8718.11
 |  |  |  |  | Liability Insurance-Gatlinburg | 2452.56
 |  |  |  |  | Liability Insurance-Pigeon Forg | 2452.56
 |  |  |  |  | Liability Insurance-Sevierville | 6999.32
 |  |  |  |  | Liability Insurance-Seymour | 4602
 |  |  |  |  | Liability Insurance - School | 1488.02
 |  |  |  |  | Life insurance-Seymour | 1642.36
 |  |  |  |  | Life insurance - Business Offic | 343.21
 |  |  |  |  | Life Insurance - Gatlinburg | 669.32
 |  |  |  |  | Life Insurance - Pigeon Forge | 886.05
 |  |  |  |  | Life Insurance - School | 718.29
 |  |  |  |  | Life insurance - Sevierville | 2774.44
 |  |  |  |  | Refund | 28.48
 |  |  |  |  | Work Comp- School | 458.34
 |  |  |  |  | Work Comp-Gatlinburg | 589.1
 |  |  |  |  | Work Comp-Pigeon Forge | 589.1
 |  |  |  |  | Work Comp-Sevierville | 1732.32
 |  |  |  |  | Work Comp-Seymour | 1083.13
 |  |  |  | Total Insurance |  | 39969.45
 |  |  |  | Interest Expense
 |  |  |  |  | Finance Charge | 42.48
 |  |  |  |  | Line of Credit | 56684.93
 |  |  |  | Total Interest Expense |  | 56727.41
 |  |  |  | Internet
 |  |  |  |  | Business Office | 2108.2
 |  |  |  |  | Gatlinburg Clinic | 1557.3
 |  |  |  |  | [NAME] | 1557.3
 |  |  |  |  | School | 1305.61
 |  |  |  |  | Sevierville Clinic | 6403.55
 |  |  |  |  | Seymour Clinic | 4660.06
 |  |  |  | Total Internet |  | 17592.02
 |  |  |  | Lawn Services
 |  |  |  |  | [NAME] | 0
 |  |  |  |  | Lawn - Kodak | 1340
 |  |  |  |  | Lawn - Pigeon Forge | 275
 |  |  |  |  | [NAME] | 2289.56
 |  |  |  |  | Lawn Services - Other | 100
 |  |  |  | Total Lawn Services |  | 4004.56
 |  |  |  | Mileage Expense-PTS
 |  |  |  |  | Gatlinburg | 426.73
 |  |  |  |  | LeConte | 0
 |  |  |  |  | Mileage-Kodak | 8.02
 |  |  |  |  | [NAME] | 614.87
 |  |  |  |  | School | 4733.5
 |  |  |  |  | Sevierville | 1819.72
 |  |  |  |  | [NAME] | 892.13
 |  |  |  |  | Veterans | 8.02
 |  |  |  |  | Mileage Expense-PTS - Other | 8.02
 |  |  |  | Total Mileage Expense-PTS |  | 8511.01
 |  |  |  | Miscellaneous Expense |  | 5
 |  |  |  | Office Supplies
 |  |  |  |  | Business Office | 276.57
 |  |  |  |  | Sevierville | 146.15
 |  |  |  | Total Office Supplies |  | 422.72
 |  |  |  | Operational Expenses PTS |  | 14111
 |  |  |  | Payroll Expenses
 |  |  |  |  | Administrative | 0
 |  |  |  |  | Business Office | 288720.05
 |  |  |  |  | Gatlinburg Clinic | 333828.24
 |  |  |  |  | Pigeon Forge Clinic | 233587.6
 |  |  |  |  | School | 266821.01
 |  |  |  |  | Sevierville Clinic | 985523.18
 |  |  |  |  | Seymour Clinic | 589835.47
 |  |  |  |  | Payroll Expenses - Other | 14108.92
 |  |  |  | Total Payroll Expenses |  | 2712424.47
 |  |  |  | Pest Control
 |  |  |  |  | [NAME] | 250
 |  |  |  |  | Pest Control - Other | 105
 |  |  |  | Total Pest Control |  | 355
 |  |  |  | Postage and Delivery
 |  |  |  |  | Business Office | 583.38
 |  |  |  |  | Gatlinburg | 131.93
 |  |  |  |  | [NAME] | 120.36
 |  |  |  |  | school | 30.41
 |  |  |  |  | Sevierville | 478.5
 |  |  |  |  | [NAME] | 232.89
 |  |  |  |  | Postage and Delivery - Other | 170.45
 |  |  |  | Total Postage and Delivery |  | 1747.92
 |  |  |  | Printing and Reproduction
 |  |  |  |  | Business Office | 368.79
 |  |  |  |  | Gatlinburg | 161.49
 |  |  |  |  | [NAME] | 113.51
 |  |  |  |  | Schools | 84.19
 |  |  |  |  | Sevierville | 884.67
 |  |  |  |  | [NAME] | 905.89
 |  |  |  | Total Printing and Reproduction |  | 2518.54
 |  |  |  | Professional Development
 |  |  |  |  | Gatlinburg Clinic | 2466.1
 |  |  |  |  | Pigeon Forge Clinic | 1096.59
 |  |  |  |  | School | 2123.19
 |  |  |  |  | Sevierville Clinic | 6780.24
 |  |  |  |  | Seymour Clinic | 3698.35
 |  |  |  |  | Veterans | 39.9
 |  |  |  |  | Professional Development - Other | 19.95
 |  |  |  | Total Professional Development |  | 16224.32
 |  |  |  | Professional Fees
 |  |  |  |  | Accounting-Gatlinburg | 1483
 |  |  |  |  | Accounting-Pigeon Forge | 1483
 |  |  |  |  | Accounting-School | 741.5
 |  |  |  |  | Accounting-Sevierville | 4502.4
 |  |  |  |  | Accounting-Seymour | 3267.7
 |  |  |  |  | Notary Public Fee | 360.58
 |  |  |  |  | Shredding Service | 2575.29
 |  |  |  | Total Professional Fees |  | 14413.47
 |  |  |  | Rent
 |  |  |  |  | 1107 Village Drive | 9600
 |  |  |  |  | Gatlinburg | 19500
 |  |  |  |  | [NAME] | 45972
 |  |  |  |  | Sevierville | 196416
 |  |  |  |  | [NAME] | 33600
 |  |  |  |  | Rent - Other | 2031.25
 |  |  |  | Total Rent |  | 307119.25
 |  |  |  | Repairs
 |  |  |  |  | Aquatic Pool-Sevierville | 5102
 |  |  |  |  | Building Repairs-Gatlinburg | 30.7
 |  |  |  |  | Building Repairs-Pigeon Forge | 279.7
 |  |  |  |  | Building Repairs-Sevierville | 7674.25
 |  |  |  |  | Building Repairs-Seymour | 283.38
 |  |  |  |  | Equipment Repairs-Gatlinburg | 0
 |  |  |  |  | Fire Ext- Pigeon Forge | 55
 |  |  |  |  | Fire Ext- Sevierville | 142.02
 |  |  |  |  | HVAC | 767
 |  |  |  | Total Repairs |  | 14334.05
 |  |  |  | Taxes
 |  |  |  |  | Franchise Tax | 5891.28
 |  |  |  |  | Property | 429
 |  |  |  |  | Sales | 1072
 |  |  |  |  | State | 20.46
 |  |  |  | Total Taxes |  | 7412.74
 |  |  |  | Telephone
 |  |  |  |  | Gatlinburg Clinic | 238.64
 |  |  |  |  | Pigeon Forge Clinic | 238.6
 |  |  |  |  | School | 180.01
 |  |  |  |  | Sevierville Clinic | 698.85
 |  |  |  |  | Seymour Clinic | 2205.13
 |  |  |  | Total Telephone |  | 3561.23
 |  |  |  | Telephone-cell
 |  |  |  |  | Sevierville Clinic-Chuck | 314.72
 |  |  |  |  | Sevierville Clinic-Joel's | 430.09
 |  |  |  |  | Seymour Clinic - Travis | 565.44
 |  |  |  | Total Telephone-cell |  | 1310.25
 |  |  |  | Travel & Ent
 |  |  |  |  | Anniversary Party | 14223.95
 |  |  |  |  | Entertainment | 13.13
 |  |  |  |  | Lodging-Gatlinburg | 88
 |  |  |  |  | Lodging-Sevierville | 1535.3
 |  |  |  |  | Lodging-Veterans | 476.64
 |  |  |  |  | Lodging - School | 969.29
 |  |  |  |  | Lodging - Seymour | 935
 |  |  |  |  | Meal-Owner's Meeting | 829.47
 |  |  |  |  | Meals- Kodak | 732.04
 |  |  |  |  | Meals-Business Office | 1374.5
 |  |  |  |  | Meals-Gatlinburg | 888.02
 |  |  |  |  | Meals-Pigeon Forge | 1161.91
 |  |  |  |  | Meals-Sevierville | 2610.61
 |  |  |  |  | Meals-Seymour | 3086.43
 |  |  |  |  | Meals-Staff Meeting | -1287.72
 |  |  |  |  | Meals-Veterans | 2465.18
 |  |  |  |  | Meals - School | 685.1
 |  |  |  |  | Travel - Pigeon Forge | 45.45
 |  |  |  |  | Travel - School | 560.15
 |  |  |  |  | Travel - Sevierville | 481.4
 |  |  |  |  | Travel - Seymour | 864.4
 |  |  |  | Total Travel & Ent |  | 32738.25
 |  |  |  | Uniforms
 |  |  |  |  | Business Office | 131.07
 |  |  |  |  | Gatlinburg | 151.1
 |  |  |  |  | [NAME] | 1372.9
 |  |  |  |  | School | 110.5
 |  |  |  |  | Sevierville | 726.99
 |  |  |  |  | [NAME] | 3183.49
 |  |  |  |  | Uniforms - Other | 18.44
 |  |  |  | Total Uniforms |  | 5694.49
 |  |  |  | Utilities
 |  |  |  |  | Electric-1107 Village Drive | 2047
 |  |  |  |  | Electric-Gatlinburg | 2074
 |  |  |  |  | Electric-Pigeon Forge | 2227.2
 |  |  |  |  | Electric-Sevierville | 15459
 |  |  |  |  | Electric - Seymour | 4888.6
 |  |  |  |  | Gas-Pigeon Forge | 599.93
 |  |  |  |  | Gas-Sevierville Clinic | 5071.41
 |  |  |  |  | Gas-Seymour | 381.74
 |  |  |  |  | Water-1107 Village Drive | 468.51
 |  |  |  |  | Water-Gatlinburg | 333.98
 |  |  |  |  | Water-Sevierville | 3299.12
 |  |  |  |  | Water - Pigeon Forge | 647.08
 |  |  |  |  | Water Seymour | 15
 |  |  |  | Total Utilities |  | 37512.57
 |  |  |  | Water
 |  |  |  |  | Gatlinburg-Bottled | 371.17
 |  |  |  |  | KODAK | 20.1
 |  |  |  |  | [NAME] | 428.19
 |  |  |  |  | [NAME] | 736.55
 |  |  |  | Total Water |  | 1556.01
 |  |  | Total Expense |  |  | 3655435.53
 | Net Ordinary Income |  |  |  |  | 883395.53
Net Income |  |  |  |  |  | 883395.53