Loading...
HomeMy WebLinkAbout11172025 Laydown 11B1 Providence Q3ACCOUNT Sept 2025 ACTUAL August 2025 LAST MONTH Dec 2024 LAST YEAR END ASSETS: CURRENT ASSETS: CASH & CASH EQUIVALENTS 100100-CHECKING GENERAL 3,101,905 2,008,969 878,791 100400-PETTY CASH IMPREST 500 500 500 TOTAL CASH & CASH EQUIVALENTS 3,102,405 2,009,469 879,291 SYSTEM POOLED CASH: 100901-VIRTUAL CASH BALANCES (2,171,694)(3,189,472)(5,876,577) TOTAL SYSTEM POOLED CASH (2,171,694)(3,189,472)(5,876,577) ACCOUNTS RECEIVABLE: 102010-PATIENT AR EPIC HB 13,753,008 14,440,205 8,080,822 102020-Patient AR Epic PB 0 0 964 102060-PATIENT AR OTHER 11,879,247 11,879,247 16,824,867 102110-PATIENT AR CR CONTRA EPIC HB 1,127,583 354,893 1,136,716 102130-PATIENT AR CR CONTRA OTH AR SYS 156,480 156,480 71,419 102810-CASH CLEARING EPIC HB 314,040 620,776 (844,993) 102820-CASH CLEARING EPIC PB 169 169 0 102830-CASH CLEARING OTHER AR SYS (13,433)(13,433)5,765 102811-AR CLEAR EPIC SUSPENSE HB 16,023 16,023 16,023 TOTAL ACCOUNTS RECEIVABLE 27,233,116 27,454,359 25,291,583 LESS ALL FOR DBTFL ACT: 104110-BAD DEBT AR EPIC HB 995,168 995,168 995,168 104210-BAD DEBT AR CONTRA EPIC HB (249,991)(249,991)(249,991) 104220-BAD DEBT AR CONTRA EPIC PB 0 0 40,136 104330-ALLOW FOR BAD DEBTS OTHER AR (5,076,004)(5,023,714)(3,858,549) 104410-BAD DEBT RECOVERIES EPIC HB AR (745,177)(745,177)(745,177) TOTAL ALLOW FOR DOUBTFUL ACCTS (5,076,004)(5,023,714)(3,818,413) Providence GL Balance Sheet Detail Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12 2025 @ 9:30 Printed By: benjamin.carver@providence.org Page No: 1 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER Laydown 11B1 Providence Quarter 3 Report on Nov 17, 2025 Agenda ACCOUNT Sept 2025 ACTUAL August 2025 LAST MONTH Dec 2024 LAST YEAR END Providence GL Balance Sheet Detail Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12 2025 @ 9:30 Printed By: benjamin.carver@providence.org Page No: 1 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER LESS ALLOW FOR CONTRACTUALS: 104910-ALLOW FOR CONTRACT ADJ EPIC HB (5,082,366) (5,244,726) (4,844,882) 104930-ALLOW FOR CONTRACT ADJ OTHER (5,358,977) (5,137,076) (4,157,336) TOTAL ALLOW FOR CONTRACTUALS (10,441,343) (10,381,802) (9,002,218) NET ACCOUNTS RECEIVABLE 11,715,770 12,048,843 12,470,953 OTHER RECEIVABLES: 105100-COST REPORT SETTLES MCARE 1,595,822 1,595,822 818,980 106300-GRANTS RECEIVABLE 125,817 125,817 104,749 106916-AR OTHER 0 (48,009) 1,485,191 106923-NONPATIENT AR ORACLE 12,519 15,425 26,316 TOTAL OTHER RECEIVABLES 1,734,158 1,689,056 2,435,235 SUPPLIES INVENTORY AT COST: 108100-INVENTORY 47,371 43,374 47,338 108103-INVENTORY PHARMACY 88,387 88,387 88,387 TOTAL SUPPLIES INVENTORY 135,758 131,761 135,726 OTHER CURRENT ASSETS: 112900-LIMITED USE CURRENT INVESTMENTS 12,800 - - 112901-DEPOSITS 1,700 1,700 0 TOTAL OTHER CURRENT ASSETS 14,500 1,700 0 TOTAL CURRENT ASSETS 14,530,897 12,691,357 10,044,628 ASSETS WHOSE USE IS LIMITED: PROPERTY, PLANT & EQUIPMENT GROSS PROPERTY, PLANT & EQUIP: 123009-Leasehold Improvements Non Genesis (18,594) (18,594) (18,594) 122100-BUILDINGS 436,285 436,285 417,513 122500-FIXED EQUIPMENT 108,935 108,935 33,251 ACCOUNT Sept 2025 ACTUAL August 2025 LAST MONTH Dec 2024 LAST YEAR END Providence GL Balance Sheet Detail Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12 2025 @ 9:30 Printed By: benjamin.carver@providence.org Page No: 1 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER 124100-MOVABLE EQUIPMENT 1,468,980 1,468,980 1,313,891 124101-MOVABLE EQUIPMENT LEASED 482,581 482,581 487,300 124109-Movable Equipment Non Genesis (895,047) (895,047) (895,047) 125000-CONSTRUCTION IN PROGRESS 790,270 836,696 791,462 TOTAL GROSS PROP PLANT & EQUIP 2,373,410 2,419,836 2,129,776 LESS: ACCUMULATED DEPRECIATION 127500-ACCUM DEPREC FIXED EQUIP 0 0 (739) 129100-ACCUM DEPREC MOVABLE EQUIP (301,248) (301,248) (301,248) 129101-ACCUM DEPREC MOVABLE EQUIP LEASED (443,625) (435,565) (370,955) TOTAL ACCUMULATED DEPRECIATION (744,873) (736,813) (672,942) NET PROPERTY, PLANT & EQUIP 1,628,537 1,683,022 1,456,834 OTHER ASSETS: OTHER (INCL. LT INVESTMENTS): 135008-OTHER LONG TERM ASSETS 1,700,641 1,699,751 2,116,037 135003-BENEFICIAL INTEREST IN CHARIT FOUND 38,101 37,901 46,833 135201-ROU ASSET OPER LEASES BLDG 1,453,039 1,453,039 1,271,814 135203-ACCUMULATED AMORTIZATION BUILDING (402,635) (377,682) (176,831) TOTAL OTHER (INCL LT INVEST)2,789,145 2,813,009 3,257,853 TOTAL ASSETS 18,948,580 17,187,388 14,759,315 LIABILITIES & NET ASSETS: CURRENT LIABILITIES: ACCOUNTS PAYABLE: 202010-AR CREDIT BAL EPIC HB 1,127,583 354,893 1,136,716 202030-AR CREDIT BAL OTHER 156,480 156,480 71,419 202100-AP TRADE PAYABLES 437,144 343,225 458,956 ACCOUNT Sept 2025 ACTUAL August 2025 LAST MONTH Dec 2024 LAST YEAR END Providence GL Balance Sheet Detail Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12 2025 @ 9:30 Printed By: benjamin.carver@providence.org Page No: 1 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER 202110-AP MAN ACCR AGENCY 96,645 59,927 200,859 202111-AP MAN ACCR BENEFITS 0 12,461 0 202113-AP MAN ACCR SUPPLIES 6,974 22,542 5,138 202114-AP MAN ACCR PURCH SVCS 21,772 31,191 43,789 202115-AP MAN ACCR UTILTIES 32,090 43,682 35,460 202910-AP SYS ACCR PO RECEIPT 76,127 70,635 46,952 202911-INVENTORY MATCHED NOT RECEIVED 3,302 4,038 2,747 202914-PATIENT REFUNDS EPIC HB 0 0 21,867 202915-PATIENT REFUNDS EPIC PB 0 0 (169) 202917-PATIENT REFUNDS OTHER 162,776 162,776 162,776 TOTAL ACCOUNTS PAYABLE 2,120,892 1,261,850 2,186,510 ACCRUED COMPENSATION: 203200-ACCRUED VACATION HOLIDAY SICK PAY 652,964 686,757 630,535 203301-ACCRUED PERFORMANCE AWARDS 207,196 162,567 140,739 203800-UNEMPLOYMENT PAYABLE 7,967 5,311 0 203911-OTHER PAYROLL DEDUCTIONS (4,973) (4,973) (4,973) TOTAL ACCRUED COMPENSATION 863,154 849,662 766,300 PAY TO CONTRACTUAL AGENCIES: 206100-REIMB SETTLE DUE MCARE 101,307 (913,293) (1,202,093) 206301-REIMB UNALLOCATED 17,000 17,000 17,000 TOTAL PAYABLE TO CONTRACTUALS 118,307 (896,293) (1,185,093) DEFERRED/UNEARNED REVENUE: 210300-DEFERRED REV MISC (298,167) (298,167) (304,205) 210304-DEFERRED REV GRANTS 341,039 341,039 341,039 TOTAL DEFERRED/UNEARNED REVENUE 42,872 42,872 36,834 OTHER CURRENT LIABILITIES: 204301-SALES AND USE TAX PAYABLE 163 108 151 ACCOUNT Sept 2025 ACTUAL August 2025 LAST MONTH Dec 2024 LAST YEAR END Providence GL Balance Sheet Detail Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12 2025 @ 9:30 Printed By: benjamin.carver@providence.org Page No: 1 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER 210950-CP OF LT�OPERATING�LEASES 231,738 172,216 - 210913-OTHER CURRENT LIABILITIES 277,236 277,236 277,236 210941-OPERATING LEASE CLEARING 0 7,000 (6,800) 210942-FINANCE LEASE CLEARING (15,395) (23,196) (14,958) TOTAL OTHER CUR LIABILITIES 493,742 433,364 255,629 CURRENT PORTION OF LT DEBT: 210917-CURRENT PORTION MASTER TRUST DEBT --- 210918-CURRENT PORTION LEASES 41,869 96,795 (70,713) TOTAL CUR PORTION OF LT DEBT 41,869 96,795 (70,713) TOTAL CURRENT LIABILITIES 3,680,835 1,788,250 1,989,469 LONG-TERM DEBT: OTHER: 227404-FINANCE LEASE OBLIG EQUIPMENT 0 (46,459) 193,047 TOTAL OTHER 0 (46,459) 193,047 TOTAL LONG-TERM DEBT 0 (46,459) 193,047 OTHER LONG-TERM LIABILITIES: 227400-LT PORTION OPERATING LEASES 812,942 883,704 1,036,130 227900-OTHER LONG TERM LIABILITIES 1,917,578 1,916,688 1,908,331 TOTAL OTHER L-T LIABILITIES 2,730,520 2,800,392 2,944,461 TOTAL LIABILITIES 6,411,355 4,542,184 5,126,977 NET ASSETS: UNRESTRICTED NET ASSETS: 271000-UR NET ASSETS (24,154,370) (24,154,370) (20,476,375) 271500-RETAINED EARNINGS 33,732,909 33,732,909 28,621,365 4000AA-Net Income 3,027,954 3,136,135 5,111,487 271903-UR OTHER ITEMS (107,370) (107,370) (3,678,001) ACCOUNT Sept 2025 ACTUAL August 2025 LAST MONTH Dec 2024 LAST YEAR END Providence GL Balance Sheet Detail Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12 2025 @ 9:30 Printed By: benjamin.carver@providence.org Page No: 1 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER TOTAL UNRESTRICTED NET ASSETS 12,499,124 12,607,304 9,578,476 TEMPORARILY RESTRICTED NA: 280000-TR NET ASSETS OTHER 46,833 46,833 45,282 280015-TR NET ASSETS INC FROM RECIPT ORG (8,732) (8,932) 1,551 TOTAL TEMP RESTRICTED NET ASTS 38,101 37,901 46,833 TOTAL NET ASSETS 12,537,224 12,645,204 9,625,308 TOTAL LIABILITIES & NET ASSETS 18,948,580 17,187,388 14,752,285 Actual Budget Variance Actual Budget Variance Pr. Year Variance 4000EA-Gross Service Revenues 4,953,797 4,505,888 447,910 41,561,752 38,456,782 3,104,970 38,147,240 3,414,511 5000EF-Deductions From Revenue (2,789,598) (1,646,780) (1,142,817) (17,417,621) (13,402,462) (4,015,159) (14,421,359) (2,996,262) Net Service Revenue 2,164,200 2,859,107 (694,907) 24,144,131 25,054,320 (910,189) 23,725,882 418,249 4900EA-Capitation Revenue - - ------ 4900EF-Premium Revenue - - ------ 4900EK-Other Operating Rev 11,951 23,805 (11,854) 141,423 216,627 (75,204) 195,164 (53,741) Total Net Operating Revenues 2,176,151 2,882,912 (706,761) 24,285,554 25,270,947 (985,394) 23,921,046 364,508 Expenses from Operations: 6000DA-Purchased Healthcare Expenses 0 - 0 0 - 0 0 0 Other Expenses from Operations: 7000FA-Salaries and Wages 1,354,627 1,400,262 (45,636) 12,717,796 12,660,200 57,596 12,191,370 526,426 7100FB-Employee Benefits 334,035 277,352 56,683 3,464,949 2,526,399 938,550 2,339,398 1,125,551 7200EG-Professional Fees Expense 5,970 1,900 4,070 24,020 17,291 6,729 15,963 8,057 7300EJ-Supplies Expense 103,598 126,592 (22,994) 1,104,689 1,107,211 (2,522) 1,051,744 52,945 7600EM-Purchased Services Expense 248,071 319,274 (71,202) 2,295,426 2,905,407 (609,981) 2,767,419 (471,993) 7700FA-Depreciation Expense 8,059 6,927 1,132 71,931 63,036 8,895 64,572 7,359 7750FA-Interest and Amortization 124 352 (227) 1,584 3,200 (1,616) 3,041 (1,457) 7750EV-BAD DEBTS - - ------ 7750EY-Other Expenses 229,846 133,813 96,033 1,577,142 1,217,701 359,442 1,136,906 440,236 Other Expenses from Operations 2,284,332 2,266,472 17,859 21,257,538 20,500,446 757,092 19,570,414 1,687,124 Total Operating Expenses 2,284,332 2,266,472 17,859 21,257,538 20,500,446 757,092 19,570,414 1,687,124 Net Operating Income (108,180) 616,440 (724,621) 3,028,016 4,770,502 (1,742,486) 4,350,631 (1,322,616) 8000BF-Non Operating Gains Losses 0 - 0 (61) - (61) 0 (61) Net Income (108,180) 616,440 (724,621) 3,027,954 4,770,502 (1,742,547) 4,350,631 (1,322,677) 2710GK-UR Net Assets Other Activities 0 - 0 (107,370) - (107,370) (3,678,112) 3,570,743 Increase (Decrease) in UR Net Assets (108,180) 616,440 (724,621) 2,920,585 4,770,502 (1,849,917) 672,519 2,248,066 PROV Care Delivery Ledger 1000-SEWARD MEDICAL CENTER Providence GL Income Statement Summary Report Reported as of September 2025 All Department Values All Location Values Printed On:11 12,2025 @9:29 Printed By: benjamin.carver@providence.org Page No: 1 Month-To-Date Year-To-Date