Spreadsheet: 119894d1314828870-excel-2008-exporting-quickbooks-p-and-ls-to-excel-p-and-l-excel-forum
Sheet: Sheet6

 |  |  |  |  | Jan 1 - Jul 30, 11 |  | Jan 1 - Jul 30, 11
 | Ordinary Income/Expense
 |  | Income
 |  |  | Patient Fees |  | 1190422.1 |  | 1190422.1
 |  |  | Medicare/Medicaid/Workers Comp |  | 1482743.74 |  | 1482743.74
 |  |  | Tricare |  | 7472.28 |  | 7472.28
 |  |  | Forest [NAME] |  | 411486.04 |  | 411486.04
 |  |  | Subsidy |  | 12000 |  | 12000
 |  |  | Refunds |  | -6383.22 |  | -6383.22
 |  |  | NSF Checks |  | -121.13 |  | -121.13
 |  | Total Income |  |  | 3097619.81 |  | 3097619.81
 |  | Expense
 |  |  | Admin Reimbursement |  | -91.79 |  | -91.79
 |  |  | Bank Service Charges |  | 1064.72 |  | 1064.72
 |  |  | Billing Fees |  | 110299.73 |  | 110299.73
 |  |  | Business Meals & Entertainment |  | 124.35 |  | 124.35
 |  |  | Collection Fees |  | 2223.07 |  | 2223.07
 |  |  | Delivery & Freight |  | 1016.5 |  | 1016.5
 |  |  | Dues and Subscriptions |  | 398.67 |  | 398.67
 |  |  | Fees Expense |  | 3710 |  | 3710
 |  |  | Insurance - Health |  | 86233.54 |  | 86233.54
 |  |  | Insurance - Malpractice |  | 61532.51 |  | 61532.51
 |  |  | Insurance - Overhead |  | 333.75 |  | 333.75
 |  |  | Legal Expense |  | 1950.92 |  | 1950.92
 |  |  | Manager's Salary |  | 64750 |  | 64750
 |  |  | Office Supplies |  | 1744.78 |  | 1744.78
 |  |  | Online Services |  | 90.65 |  | 90.65
 |  |  | Outside Services |  | 2038 |  | 2038
 |  |  | Payroll Expenses
 |  |  |  | Managing Director [NAME] | 17500 |  | 17500
 |  |  |  | Nurse Prac Salary | 16666.68 |  | 16666.68
 |  |  |  | Admin Salary Expense | 50022.94 |  | 50022.94
 |  |  |  | Health Ins Stipend - Staff | 746.9 |  | 746.9
 |  |  |  | Health Insurance - Staff | 5074.79 |  | 5074.79
 |  |  |  | Less Reimbursement | -11527.55 |  | -11527.55
 |  |  |  | Mileage Reimbursement | 240 |  | 240
 |  |  |  | Payroll Tax Expense | 7002.44 |  | 7002.44
 |  |  |  | [NAME] | 10153.97 |  | 10153.97
 |  |  |  | Payroll Expenses - Other | 178.39 |  | 178.39
 |  |  | Total Payroll Expenses |  | 96058.56 |  | 96058.56
 |  |  | Postage and Delivery |  | 1993.93 |  | 1993.93
 |  |  | Professional Fees |  | 27926.77 |  | 27926.77
 |  |  | Recruiting Expense |  | 9500 |  | 9500
 |  |  | Rent |  | 7000 |  | 7000
 |  |  | Repairs & Maintenance |  | 42.76 |  | 42.76
 |  |  | Signing Bonus-Dr's |  | 11000 |  | 11000
 |  |  | [NAME] |  | 18295 |  | 18295
 |  |  | Telephone & Pagers |  | 6050.91 |  | 6050.91
 |  |  | Travel |  | 640.28 |  | 640.28
 |  |  | Voice Mail System |  | 6068.2 |  | 6068.2
 |  |  | Void Checks |  | 0 |  | 0
 |  |  | Allocable Expenses |  | 0 |  | 0
 |  | Total Expense |  |  | 521995.81 |  | 521995.81
 | Net Ordinary Income |  |  |  | 2575624 |  | 2575624
 | Other Income/Expense
 |  | Other Expense
 |  |  | Contract Labor-Doctors' |  | 1078084 |  | 1078084
 |  |  | Guaranteed Payments-Members
 |  |  |  | Base Pay | 883686.34 |  | 883686.34
 |  |  |  | 10% Allocation | 60031.73 |  | 60031.73
 |  |  |  | Partner Allocation | 168911.22 |  | 168911.22
 |  |  |  | Guaranteed Payments-Members - Other | 0 |  | 0
 |  |  | Total Guaranteed Payments-Members |  | 1112629.29 |  | 1112629.29
 |  | Total Other Expense |  |  | 2190713.29 |  | 2190713.29
 | Net Other Income |  |  |  | -2190713.29 |  | -2190713.29
Net Income |  |  |  |  | 384910.71 |  | 384910.71