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

 |  |  |  |  | QTR 1 |  |  |  |  |  | QTR 2 |  |  |  |  |  |  | QTR 1 & 2 |  |  |  |  |  | QTR 3
 |  |  |  |  | Jan 1 - Mar 30, 24 |  |  |  |  |  | Apr - Jun 24 |  |  |  |  |  |  | Jan - Jun 24 |  |  |  |  |  | Jul - Sep 24
 | Ordinary Income/Expense |  |  |  | 89832 |  | Ordinary Income/Expense |  |  |  | 155256 | add |  | Ordinary Income/Expense |  |  |  |  |  | Ordinary Income/Expense
 |  | Expense |  |  |  |  |  | Expense |  |  |  |  |  |  | Income |  |  | 155256 |  |  | Expense
 |  |  | Advertising and Promotion |  | 47.96 |  |  |  | Advertising and Promotion |  | 789.65 |  |  |  |  | Outpatient Services |  | 89832 |  |  |  | Advertising and Promotion |  | 403.42
 |  |  | Bank Service Charges |  |  |  |  |  | Bank Service Charges |  |  |  |  |  | Total Income |  |  |  |  |  |  | Bank Service Charges
 |  |  |  | Mastercard/Visa Transaction Fee | 252.01 |  |  |  |  | Mastercard/Visa Transaction Fee | 543.24 |  |  |  | Expense |  |  |  |  |  |  |  | Mastercard/Visa Transaction Fee | 535.25
 |  |  | Total Bank Service Charges |  |  |  |  |  | Total Bank Service Charges |  |  |  |  |  |  | Advertising and Promotion |  | 837.61 |  |  |  | Total Bank Service Charges
 |  |  | Billing Expense |  | 2238.47 |  |  |  | Billing Expense |  | 2071.47 |  |  |  |  | Bank Service Charges |  |  |  |  |  | Billing Expense |  | 2653.33
 |  |  | Cable, Internet & Telephone |  | 1108.65 |  |  |  | Cable, Internet & Telephone |  | 1118.55 |  |  |  |  |  | Mastercard/Visa Transaction Fee | 795.25 |  |  |  | Cable, Internet & Telephone |  | 701.33
 |  |  | Clinical Expense |  | 3550.64 |  |  |  | Clinical Expense |  | 4012.92 |  |  |  |  | Total Bank Service Charges |  |  |  |  |  | Charitable Contributions |  | 50
 |  |  | Copier Service Agreement |  | 141.16 |  |  |  | Computer Software |  | 109.57 |  |  |  |  | BENEFITS |  | 837 |  |  |  | Cleaning |  | 25
 |  |  | Health Insurance |  | 4093.19 |  |  |  | Copier Service Agreement |  | 95.57 |  |  |  |  | Billing Expense |  | 4309.94 |  |  |  | Clinical Expense |  | 5101.66
 |  |  | Health Savings Account |  | 300 |  |  |  | Gifts/Flowers |  | 20 |  |  |  |  | Cable, Internet & Telephone |  | 2227.2 |  |  |  | Computer Software |  | 230.29
 |  |  | Insurance Expense |  |  |  |  |  | Health Insurance |  | 7126.77 |  |  |  |  | Clinical Expense |  | 7902.48 |  |  |  | Copier Service Agreement |  | 145.09
 |  |  |  | Cyber | 105.73 |  |  |  | Health Savings Account |  | 465 |  |  |  |  | Computer Software |  | 109.57 |  |  |  | Dues and Subscriptions |  | 200
 |  |  |  | Liability | 183.66 |  |  |  | Insurance Expense |  |  |  |  |  |  | Copier Service Agreement |  | 236.73 |  |  |  | Gifts/Flowers |  | 20
 |  |  |  | Life | 226.11 |  |  |  |  | Cyber | 136.33 |  |  |  |  | Gifts/Flowers |  | 40 |  |  |  | Health Insurance |  | 7067.49
 |  |  |  | Insurance Expense - Other | 53.76 |  |  |  |  | Liability | 1745.46 |  |  |  |  | Health Insurance |  | 11219.96 |  |  |  | Health Savings Account |  | 480
 |  |  | Total Insurance Expense |  |  |  |  |  |  | Life | 226.11 |  |  |  |  | Health Savings Account |  | 765 |  |  |  | Insurance Expense
 |  |  | Internet |  | 202.92 |  |  |  |  | Workers Comp. | 261.54 |  |  |  |  | Insurance Expense |  |  |  |  |  |  | Cyber | 105.73
 |  |  | Lawn Services |  | 50 |  |  |  | Total Insurance Expense |  |  |  |  |  |  |  | Cyber | 242.06 |  |  |  |  | Liability | 346.9
 |  |  | Meals and Entertainment |  | 24.18 |  |  |  | Internet |  | 423.79 |  |  |  |  |  | Liability | 1929.12 |  |  |  |  | Life | 226.11
 |  |  | Mileage Expense |  | 562.08 |  |  |  | Lawn Services |  | 720 |  |  |  |  |  | Life | 452.22 |  |  |  |  | Workers Comp. | 196.23
 |  |  | Payroll Expenses |  | 58073.33 |  |  |  | Meals and Entertainment |  | 257.73 |  |  |  |  |  | Workers Comp. | 261.54 |  |  |  | Total Insurance Expense
 |  |  | Printing and Reproduction |  | 79.5 |  |  |  | Mileage Expense |  | 188.06 |  |  |  |  |  | Insurance Expense - Other | 53.76 |  |  |  | Internet |  | 612.95
 |  |  | Professional Development |  | 100 |  |  |  | Payroll Expenses |  | 66673.63 |  |  |  |  | Total Insurance Expense |  |  |  |  |  | Lawn Services |  | 745
 |  |  | Professional Fees |  |  |  |  |  | Professional Development |  | 19.95 |  |  |  |  | Internet |  | 626.71 |  |  |  | Meals and Entertainment |  | 139.61
 |  |  |  | Accounting | 5198 |  |  |  | Professional Fees |  |  |  |  |  |  | Lawn Services |  | 860 |  |  |  | Mileage Expense |  | 127.33
 |  |  |  | Fees - State | 306.87 |  |  |  |  | Accounting | 435 |  |  |  |  | Meals and Entertainment |  | 1013.95 |  |  |  | Payroll Expenses |  | 57124.84
 |  |  |  | Shredding Service | 40 |  |  |  |  | Shredding Service | 40 |  |  |  |  | Mileage Expense |  | 758.16 |  |  |  | PEST CONTROL |  | 105
 |  |  | Total Professional Fees |  |  |  |  |  | Total Professional Fees |  |  |  |  |  |  | Operational Expenses PTS |  | 2906 |  |  |  | Professional Development |  | 155.46
 |  |  | Rent Expense |  | 12300 |  |  |  | Rent Expense |  | 12300 |  |  |  |  | Payroll Expenses |  | 137357.42 |  |  |  | Professional Fees
 |  |  | Repairs and Maintenance |  |  |  |  |  | Taxes |  |  |  |  |  |  | PEST CONTROL |  | 105 |  |  |  |  | Shredding Service | 40
 |  |  |  | Building Repairs | 125 |  |  |  |  | Franchise Tax | 983 |  |  |  |  | Printing and Reproduction |  | 79.5 |  |  |  | Total Professional Fees
 |  |  |  | HVAC | 553 |  |  |  | Total Taxes |  |  |  |  |  |  | Professional Development |  | 119.95 |  |  |  | Rent Expense |  | 16400
 |  |  | Total Repairs and Maintenance |  |  |  |  |  | Telephone Expense |  | 58.82 |  |  |  |  | Professional Fees |  |  |  |  |  | Repairs and Maintenance
 |  |  | Telephone Expense |  | 116.9 |  |  |  | Travel Expense |  | 719.46 |  |  |  |  |  | Accounting | 5633 |  |  |  |  | Building Repairs | 19.83
 |  |  | Utilities |  |  |  |  |  | Uniforms |  | 45.85 |  |  |  |  |  | Fees - State | 306.87 |  |  |  | Total Repairs and Maintenance
 |  |  |  | Electric | 896.21 |  |  |  | Utilities |  |  |  |  |  |  |  | Shredding Service | 80 |  |  |  | Telephone Expense
 |  |  |  | Gas | 1528.15 |  |  |  |  | Electric | 480.25 |  |  |  |  | Total Professional Fees |  |  |  |  |  |  | CELL | 25.37
 |  |  |  | Water | 264.26 |  |  |  |  | Gas | 303.64 |  |  |  |  | Rent Expense |  | 24600 |  |  |  |  | Telephone Expense - Other | 113
 |  |  | Total Utilities |  |  |  |  |  |  | Water | 262.02 |  |  |  |  | Repairs and Maintenance |  |  |  |  |  | Total Telephone Expense
 |  |  | Water |  | 19.93 |  |  |  |  | Utilities - Other | 352.63 |  |  |  |  |  | Building Repairs | 125 |  |  |  | Utilities
 |  | Total Expense |  |  |  |  |  |  | Total Utilities |  |  |  |  |  |  |  | HVAC | 553 |  |  |  |  | Electric | 1121.6
 | Net Ordinary Income |  |  |  |  |  |  |  | Water |  |  |  |  |  |  | Total Repairs and Maintenance |  |  |  |  |  |  | Gas | 93.81
Net Income |  |  |  |  |  |  |  |  |  | Bottled | 40.03 |  |  |  |  | Taxes |  |  |  |  |  |  | Water | 398.28
 |  |  |  |  |  |  |  |  |  | Water - Other | 35.94 |  |  |  |  |  | Franchise Tax | 983 |  |  |  | Total Utilities
 |  |  |  |  |  |  |  |  | Total Water |  |  |  |  |  |  | Total Taxes |  |  |  |  | Total Expense
 |  |  |  | adjustments | 17647 |  |  | Total Expense |  |  |  |  |  |  |  | Telephone Expense |  | 175.72 |  | Net Ordinary Income
 |  |  |  |  |  |  | Net Ordinary Income |  |  |  |  |  |  |  |  | Travel Expense |  | 719.46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uniforms |  | 45.85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities
 |  |  |  |  |  |  |  |  |  |  | 39784 | what P & L |  |  |  |  | Electric | 1376.46
 |  |  |  |  |  |  |  |  |  | adjustments | 14819 | what I had as an adj |  |  |  |  | Gas | 1831.79 |  |  |  |  | -95710
 |  |  |  |  |  |  |  |  |  |  | 12410 | true adjustment |  |  |  |  | Water | 526.28
 |  |  |  |  |  |  |  |  |  |  |  | OFF |  |  |  |  | Utilities - Other | 352.63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Utilities
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bottled | 40.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Water - Other | 55.87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expense
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Ordinary Income
 |  |  |  |  |  |  |  |  |  |  |  |  | Net Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | with 2nd qtr adjustment | -12410
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19226 | correct