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

 |  |  |  |  | QTR 1 |  |  |  |  | QTR 2 |  |  |  |  |  | QTR 1 & 2 |  |  |  |  | QTR 3 |  |  |  |  |  | QTR 1-3
 |  |  |  |  | Jan - Mar 24 |  |  |  |  | Apr - Jun 24 |  |  |  |  |  | Jan - Jun 24 |  |  |  |  | [NAME] 30, 24 |  |  |  |  |  | Jan - Sep 24
 |  |  |  |  |  |  | Income |  | CRAIG ADD THIS | 245375
 |  | Income |  |  |  |  | Expense |  |  |  |  |  | Income |  |  | 245375 |  | Expense |  |  |  |  |  | Income
 |  |  | Outpatient Services |  | 186954 |  |  | Advertising |  | 1696.37 |  |  |  | Outpatient Services |  | 186954 |  |  | Advertising |  | 1722.75 |  |  |  | Outpatient Services |  | 186954
 |  | Total Income |  |  |  |  |  | Bank Service Charges |  |  |  |  | Total Income |  |  |  |  |  | Bank Service Charges |  |  |  |  | Total Income
 | Gross Profit |  |  |  |  |  |  |  | Mastercard/Visa Transaction Fee | 781.03 |  | Gross Profit |  |  |  |  |  |  |  | Mastercard/Visa Transaction Fee | 807.46 |  | Gross Profit
 |  | Expense |  |  |  |  |  | Total Bank Service Charges |  |  |  |  | Expense |  |  |  |  |  | Total Bank Service Charges |  |  |  |  | Expense
 |  |  | Advertising |  | 322.57 |  |  | Billing expense |  | 3728.64 |  |  |  | Advertising |  | 2018.94 |  |  | Billing expense |  | 4776 |  |  |  | Advertising |  | 3741.69
 |  |  | Bank Service Charges |  |  |  |  | Cable, Phone & Internet |  | 837.93 |  |  |  | Bank Service Charges |  |  |  |  | Cable, Phone & Internet |  | 834.5 |  |  |  | Bank Service Charges
 |  |  |  | Mastercard/Visa Transaction Fee | 915.54 |  |  | Clinical Expense |  | 7720.88 |  |  |  |  | Mastercard/Visa Transaction Fee | 1696.57 |  |  | Charitable Contributions |  | 90 |  |  |  |  | Mastercard/Visa Transaction Fee | 2504.03
 |  |  | Total Bank Service Charges |  |  |  |  | Computer Software |  | 524.44 |  |  |  | Total Bank Service Charges |  |  |  |  | Clinical Expense |  | 9843.49 |  |  |  | Total Bank Service Charges
 |  |  | BENEFITS |  | 1507 |  |  | Copier Service Agreement |  | 242.72 |  |  |  | BENEFITS |  | 1507 |  |  | Computer Software |  | 414.51 |  |  |  | BENEFITS |  | 1507
 |  |  | Billing expense |  | 4029.23 |  |  | Health Savings Account |  | 450 |  |  |  | Billing expense |  | 7757.87 |  |  | Dues and Subscriptions |  | 240 |  |  |  | Billing expense |  | 12533.87
 |  |  | Cable, Phone & Internet |  | 1630.7 |  |  | Insurance Expense |  |  |  |  |  | Cable, Phone & Internet |  | 2468.63 |  |  | Gifts/Flowers |  | 36 |  |  |  | Cable, Phone & Internet |  | 3303.13
 |  |  | Clinical Expense |  | 10494.18 |  |  |  | Cyber | 245.39 |  |  |  | Clinical Expense |  | 18215.06 |  |  | Health Savings Account |  | 450 |  |  |  | Charitable Contributions |  | 90
 |  |  | Copier Service Agreement |  | 21.74 |  |  |  | General Liability | 3141.82 |  |  |  | Computer Software |  | 524.44 |  |  | Insurance Expense |  |  |  |  |  | Clinical Expense |  | 28058.55
 |  |  | Gifts/Flowers |  | 72 |  |  |  | Life Insurance | 401.55 |  |  |  | Copier Service Agreement |  | 264.46 |  |  |  | Cyber | 190.31 |  |  |  | Computer Software |  | 938.95
 |  |  | Health Savings Account |  | 750 |  |  |  | Work Comp. | 470.78 |  |  |  | Gifts/Flowers |  | 72 |  |  |  | General Liability | 624.42 |  |  |  | Copier Service Agreement |  | 264.46 |  |  |  |  |  | Rent | 10200 |  | Smartbank | 11458
 |  |  | Insurance Expense |  |  |  |  | Total Insurance Expense |  |  |  |  |  | Health Savings Account |  | 1200 |  |  |  | Life Insurance | 531.69 |  |  |  | Dues and Subscriptions |  | 240 |  |  |  |  |  | payroll ded | 20508
 |  |  |  | Cyber | 190.31 |  |  | Interest Expense |  | 108.3 |  |  |  | Insurance Expense |  |  |  |  |  | Work Comp. | 353.22 |  |  |  | Gifts/Flowers |  | 108 |  |  |  |  |  | payroll | 103063.95
 |  |  |  | General Liability | 330.58 |  |  | Internet |  | 435.64 |  |  |  |  | Cyber | 435.7 |  |  | Total Insurance Expense |  |  |  |  |  | Health Savings Account |  | 1650
 |  |  |  | Life Insurance | 372.46 |  |  | Meals and Entertainment |  | 359.1 |  |  |  |  | General Liability | 3472.4 |  |  | Interest Expense |  |  |  |  |  | Insurance Expense |  |  |  |  |  |  |  |  | 168669 | QB  expenses
 |  |  | Total Insurance Expense |  |  |  |  | Mileage |  | 288.16 |  |  |  |  | Life Insurance | 774.01 |  |  |  | Loan Interest | 9.64 |  |  |  |  | Cyber | 626.01 |  |  |  |  |  |  |  | net expenses (minus payroll, payroll ded, & rent
 |  |  | Interest Expense |  |  |  |  | Payroll Deductions |  |  |  |  |  |  | Work Comp. | 470.78 |  |  |  | Interest Expense - Other | 60.32 |  |  |  |  | General Liability | 4096.82 |  |  |  |  |  |  |  | net  expenses taking off "SmartBank"
 |  |  |  | Loan Interest | 62.88 |  |  |  | Health Insurance | 16384.22 |  |  |  | Total Insurance Expense |  |  |  |  | Total Interest Expense |  |  |  |  |  |  | Life Insurance | 1305.7
 |  |  |  | Interest Expense - Other | 166.26 |  |  |  | Health Saving Account | 4881.8 |  |  |  | Interest Expense |  |  |  |  | Internet |  | 1103.32 |  |  |  |  | Work Comp. | 824
 |  |  | Total Interest Expense |  |  |  |  | Total Payroll Deductions |  |  |  |  |  |  | Loan Interest | 62.88 |  |  | Meals and Entertainment |  | 483.49 |  |  |  | Total Insurance Expense
 |  |  | Internet |  | 365.24 |  |  | Payroll Expenses |  | 107695.35 |  |  |  |  | Interest Expense - Other | 274.56 |  |  | Mileage |  | 181.83 |  |  |  | Interest Expense
 |  |  | Meals and Entertainment |  | 1487.5 |  |  | Professional Fees |  |  |  |  |  | Total Interest Expense |  |  |  |  | Payroll Deductions |  |  |  |  |  |  | Loan Interest | 72.52
 |  |  | Mileage |  | 278.94 |  |  |  | Accounting | 783 |  |  |  | Internet |  | 800.88 |  |  |  | Health Insurance | 20508.24 |  |  |  |  | Interest Expense - Other | 334.88
 |  |  | Operational Expenses PTS |  | 5232 |  |  | Total Professional Fees |  |  |  |  |  | Meals and Entertainment |  | 1846.6 |  |  | Total Payroll Deductions |  |  |  |  |  | Total Interest Expense
 |  |  | Payroll Deductions |  |  |  |  | Rent Expense |  | 10200 |  |  |  | Mileage |  | 567.1 |  |  | Payroll Expenses |  | 103063.95 |  |  |  | Internet |  | 1904.2
 |  |  |  | Health Insurance | 14869.84 |  |  | Repairs |  |  |  |  |  | Operational Expenses PTS |  | 5232 |  |  | Professional Development |  | 270.26 |  |  |  | Meals and Entertainment |  | 2330.09
 |  |  | Total Payroll Deductions |  |  |  |  |  | Equiptment Repairs | 219.46 |  |  |  | Payroll Deductions |  |  |  |  | Rent Expense |  | 10200 |  |  |  | Mileage |  | 748.93
 |  |  | Payroll Expenses |  | 102273.26 |  |  | Total Repairs |  |  |  |  |  |  | Health Insurance | 31254.06 |  |  | Repairs |  |  |  |  |  | Operational Expenses PTS |  | 5232
 |  |  | Printing and Reproduction |  | 121.78 |  |  | Taxes |  |  |  |  |  |  | Health Saving Account | 4881.8 |  |  |  | Building Repairs | 21.52 |  |  |  | Payroll Deductions
 |  |  | Professional Development |  | 39.9 |  |  |  | Excise | 1288 |  |  |  | Total Payroll Deductions |  |  |  |  |  | Repairs - Other | 14.19 |  |  |  |  | Health Insurance | 51762.3
 |  |  | Professional Fees |  |  |  |  | Total Taxes |  |  |  |  |  | Payroll Expenses |  | 209968.61 |  |  | Total Repairs |  |  |  |  |  |  | Health Saving Account | 4881.8
 |  |  |  | Accounting | 6036.4 |  |  | Telephone |  | 105.88 |  |  |  | Printing and Reproduction |  | 121.78 |  |  | SmartBank |  | 11458 |  |  |  | Total Payroll Deductions
 |  |  | Total Professional Fees |  |  |  |  | Uniforms |  | 82.53 |  |  |  | Professional Development |  | 39.9 |  |  | Telephone |  |  |  |  |  | Payroll Expenses |  | 313032.56
 |  |  | Rent Expense |  | 10200 |  |  | Utilities |  |  |  |  |  | Professional Fees |  |  |  |  |  | CELL | 45.66 |  |  |  | Printing and Reproduction |  | 121.78
 |  |  | SmartBank |  | 732.37 |  |  |  | Electric | 605.64 |  |  |  |  | Accounting | 6819.4 |  |  |  | Telephone - Other | 203.38 |  |  |  | Professional Development |  | 310.16
 |  |  | Taxes |  |  |  |  |  | Gas | 156.63 |  |  |  | Total Professional Fees |  |  |  |  | Total Telephone |  |  |  |  |  | Professional Fees
 |  |  |  | State | 313.54 |  |  |  | Water | 288.81 |  |  |  | Rent Expense |  | 20400 |  |  | Water |  |  |  |  |  |  | Accounting | 6819.4
 |  |  | Total Taxes |  |  |  |  | Total Utilities |  |  |  |  |  | Repairs |  |  |  |  |  | Bottled | 119.37 |  |  |  | Total Professional Fees
 |  |  | Telephone |  | 105.22 |  |  | Water |  |  |  |  |  |  | Equiptment Repairs | 219.46 |  |  |  | Water - Other | 11.52 |  |  |  | Rent Expense |  | 30600
 |  |  | Travel & Entertainment |  | 1324.97 |  |  |  | Bottled | 73.07 |  |  |  | Total Repairs |  |  |  |  | Total Water |  |  |  |  |  | Repairs
 |  |  | Travel Expense |  | 238.32 |  |  |  | Water - Other | 204.94 |  |  |  | SmartBank |  | 732.37 |  | Total Expense |  |  |  |  |  |  |  | Building Repairs | 21.52
 |  |  | Utilities |  |  |  |  | Total Water |  |  |  |  |  | Taxes |  |  |  |  |  |  |  |  |  |  |  | Equiptment Repairs | 219.46
 |  |  |  | Electric | 678.99 |  |  |  |  |  |  |  |  |  | Excise | 1288 |  |  |  |  |  |  |  |  |  | Repairs - Other | 14.19
 |  |  |  | Gas | 707.41 |  |  |  |  |  |  |  |  |  | State | 313.54 |  |  |  |  |  |  |  |  | Total Repairs
 |  |  |  | Water | 254.17 |  | Total Expense |  |  | 164402 |  |  |  | Total Taxes |  |  |  |  |  |  | -168669 |  |  |  | SmartBank |  | 12190.37
 |  |  | Total Utilities |  |  |  |  |  |  |  |  |  |  | Telephone |  | 211.1 |  |  |  |  | 11458 |  |  |  | Taxes
 |  |  | Water |  |  |  |  |  | Net Income |  |  |  |  | Travel & Entertainment |  | 1324.97 |  |  |  |  |  |  |  |  |  | Excise | 1288
 |  |  |  | Bottled | 102.29 |  |  |  |  |  |  |  |  | Travel Expense |  | 238.32 |  |  |  |  |  |  |  |  |  | State | 313.54
 |  |  |  | Water - Other | 84.27 |  |  |  | adjustments CRAIG ADD THIS | 26672 |  |  |  | Uniforms |  | 82.53 |  |  |  |  |  |  |  |  | Total Taxes
 |  |  | Total Water |  |  |  |  |  | I HAVE ON THE DOC CALLED QB ADJ |  |  |  |  | Utilities |  |  |  |  |  |  |  |  |  |  | Telephone
 |  | Total Expense |  |  |  |  |  |  | Net Income |  |  |  |  |  | Electric | 1284.63 |  |  |  |  |  |  |  |  |  | CELL | 45.66
Net Income |  |  |  |  |  |  |  |  |  | 57290 | this is what P&L had |  |  |  | Gas | 864.04 |  |  |  |  |  |  |  |  |  | Telephone - Other | 414.48
 |  |  |  |  |  |  |  |  | OFF I NEED TO FIGURE OUT THIS |  |  |  |  |  | Water | 542.98 |  |  |  |  |  |  |  |  | Total Telephone
 |  |  |  |  | correct |  |  |  | THINK IT CARRIED OVER FROM Q1 AS UNASSIGNED |  |  |  |  | Total Utilities |  |  |  |  |  |  |  |  |  |  | Travel & Entertainment |  | 1324.97
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Water |  |  |  |  |  |  |  |  |  |  | Travel Expense |  | 238.32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bottled | 175.36 |  |  |  |  |  |  |  |  | Uniforms |  | 82.53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Water - Other | 289.21 |  |  |  |  |  |  |  |  | Utilities
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Water |  |  |  |  |  |  |  |  |  |  |  | Electric | 1284.63
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Expense |  |  |  |  |  |  |  |  |  |  |  |  | Gas | 864.04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Water | 542.98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Utilities
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | adjustment | 26672 |  |  |  |  |  |  |  |  | Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77931 | this is what P&L had |  |  |  |  |  |  |  |  | Bottled | 294.73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF | 2989 |  |  |  |  |  |  |  |  |  | Water - Other | 300.73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expense