Civic Intelligence

Laulima Data Alliance

990 • Fiscal year 2022 • EIN 82-1726643

Jul 01, 2021 to Jun 30, 2022 • Filed on May 15, 2023

707 Richards Street Ph2Honolulu, HI 96813

(808) 521-8961

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

73rd percentile

0.16x

Higher debt load relative to assets than 73% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Liabilities / Revenue

69th percentile

0.11x

Higher debt load relative to revenue than 69% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Net Margin

60th percentile

12%

Higher net margin than 60% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Top Officer Pay

99th percentile

$490,052

Higher top officer pay than 99% of similar nonprofits.

Top officer pay equals 53.4% of source-year revenue.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Source year 2022

Asset Growth

77th percentile

24%

Faster asset growth than 77% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2021 to 2022

Revenue Growth

52nd percentile

9.5%

Faster revenue growth than 52% of similar nonprofits.

2022 filings • 501(c)3 • $500k-$1M nonprofits • Annualized from 2021 to 2022

Assets

Up

$636,215

Up $124,074 (+24%) from 2021

Net Assets

Up

$531,335

Up $109,213 (+26%) from 2021

Liabilities

Up

$104,880

Up $14,861 (+17%) from 2021

Revenue

Up

$917,900

Up $79,845 (+9.5%) from 2021

Expenses

Up

$808,687

Up $43,625 (+5.7%) from 2021

Net Income

Up

$109,213

Up $36,220 (+50%) from 2021

Historical Trend

Balance Sheet Trend

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$1.0M$500K$0Assets 2018: $464,157Liabilities 2018: $268,777Net Assets 2018: $195,3802018Assets 2019: $374,689Liabilities 2019: $68,444Net Assets 2019: $306,2452019Assets 2020: $480,473Liabilities 2020: $131,344Net Assets 2020: $349,1292020Assets 2021: $512,141Liabilities 2021: $90,019Net Assets 2021: $422,1222021Assets 2022: $636,215Liabilities 2022: $104,880Net Assets 2022: $531,3352022Assets 2023: $806,081Liabilities 2023: $188,261Net Assets 2023: $617,8202023

Highlighted filing

2022

Assets$636,215
Liabilities$104,880
Net Assets$531,335

Operations Trend

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$1.0M$500K$0Revenue 2018: $758,465Expenses 2018: $563,085Net Income 2018: $195,3802018Revenue 2019: $830,657Expenses 2019: $805,484Net Income 2019: $25,1732019Revenue 2020: $829,559Expenses 2020: $786,675Net Income 2020: $42,8842020Revenue 2021: $838,055Expenses 2021: $765,062Net Income 2021: $72,9932021Revenue 2022: $917,900Expenses 2022: $808,687Net Income 2022: $109,2132022Revenue 2023: $981,366Expenses 2023: $898,964Net Income 2023: $82,4022023

Highlighted filing

2022

Revenue$917,900
Expenses$808,687
Net Income$109,213
Jump To
Filing Snapshot
Filing Period
Jul 1, 2021 to Jun 30, 2022
Signed
May 15, 2023
Return Version
2021v4.2
Gross Receipts
$917,900
Mission and Program Overview

Mission

To provide a comprehensive data analytics and reporting platform that hospitals, healthcare leaders, policymakers, researchers, and community leaders can access to support decision making and policy in creating sustainable healthcare solutions for hawaii's communities.

Balance Sheet Detail
LineBeginningEndChange
Assets
Cash and Non-Interest-Bearing Accounts$349,161$487,286▲ $138,125
Prepaid Expenses and Deferred Charges$140,566$134,407▼ $6,159
Land, Buildings, and Equipment, Net$14,342$11,522▼ $2,820
Accounts Receivable$8,072$3,000▼ $5,072
Total Assets$512,141$636,215▲ $124,074
Liabilities
Accounts Payable and Accrued Expenses$79,927$91,634▲ $11,707
Deferred Revenue$6,667$6,666▼ $1
Other Liabilities$3,425$6,580▲ $3,155
Total Liabilities$90,019$104,880▲ $14,861
Net Assets / Fund Balance
Net Assets Without Donor Restrictions$422,122$531,335▲ $109,213
Total Net Assets Fund Balance$422,122$531,335▲ $109,213
Total Liabilities and Net Assets / Fund Balance$512,141$636,215▲ $124,074

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$11,522$199,294$210,816
Other Land Buildings$0$563$563
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Haley HsiehExecutive DirectorFT$202,932$54,815$257,747

Board Members and Trustees

NameTitle
Hilton RaethelPresident & CEO
David DobbsDirector
Gary KajiwaraDirector
Greg CarlsonDirector
Kris WilsonDirector
Libby CharDirector
Quin OgawaDirector
Steve RobertsonDirector
Tiffany LemmenDirector
Vince HuDirector
Wendy OdoChief Financial Officer
John ChenSecretary

Highest Paid Contractors

ContractorServicesLocationCompensation
Iowa Hospital AssociationData Collection Services100 E GRAND AVE STE 100, Des Moines, IA 50309$205,517
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$910,479
Investment Income
$0
Other Revenue
$7,421
Change in Net Assets
$109,213
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$452,157
Other Expenses$356,530
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Fees for Services Other$199,463$49,866-$249,329
Current Officers, Directors, Trustees, and Key Employees$24,695$222,251-$246,946
Other Salaries and Wages$11,943$107,486-$119,429
Other Employee Benefits$5,115$46,031-$51,146
Payroll Taxes$25,890$6,473-$32,363
Insurance$17,772$4,443-$22,215
Occupancy$10,933$2,733-$13,666
Depreciation Depletion$6,600$1,649-$8,249
Fees for Services Accounting-$7,597-$7,597
Travel$3,733$933-$4,666
Information Technology$2,746$686-$3,432
Conferences and Meetings$1,901$475-$2,376
Pension Plan Contributions$227$2,046-$2,273
Office Expenses$1,272$318-$1,590
Other Expenses$1,085$271-$1,356
Fees for Services Legal-$157-$157
All Other Expenses$42$12-$54
Total Functional Expenses$346,892$461,795$0$808,687
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Debt and Bond Financing

Other Reported Liabilities

LiabilityAmount
Due to Hah$6,580
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Business relationship with 35% controlled entity
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
Yes
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Part VI, Section A, Line 6

The healthcare association of hawaii is the sole initial member.

Form 990, Part VI, Section A, Line 7A

The governing body is made up of representatives of six designated hospitals or hospital systems, one rotating hospital not part of the first six, state of hawaii department of health, hawaii medical service association, the john a. Burns school of medicine/university of hawaii, the president and ceo of the healthcare association of hawaii and the executive director of laulima data alliance.

Form 990, Part VI, Section B, Line 11B

All 990 reporting was reviewed internally by senior management. All questions and changes were addressed prior to filing of the 990.

Form 990, Part VI, Section B, Line 12C

Laulima data alliance adopted a conflict of interest policy in fye 6/30/19. The policy is sent out on an annual basis to the current board of directors, officers and key employees. The responses are summarized, reviewed and analyzed for reporting. A conflicting interest with a party or a transaction shall be fully disclosed as soon as recognized. The board shall determine whether a conflict exists. If so, the conflicted party is excluded from the discussion and/or approval of a transaction.

Form 990, Part VI, Section B, Line 15A

The executive director's compensation is reviewed and approved by the president/ceo. Comparable data, such as a salary review by an independent consultant, is used, and compensation for a similar position in a comparable organization is also considered. The executive director's salary review was last conducted in spring 2019. This is documented in the personnel files.

Form 990, Part VI, Section C, Line 19

Laulima data alliance does not make its governing documents, conflict of interest policy, and financial statements available to the public.

Filing and Contact Details

Filer

Filer Name
Laulima Data Alliance
EIN
82-1726643
Phone
8085218961
Address
707 RICHARDS STREET PH2, HONOLULU, HI 96813

Signing Officer

Name
Wendy Odo
Title
Chief Financial Officer
Phone
8085218961
Signed
2023-05-15
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Hilton R Raethel
Formed
2018
Legal Domicile
Hi
Voting Board Members
12
Independent Board Members
10
Employees
0
Volunteers
11

Preparer

Firm
Cw Associates Cpas
Address
700 BISHOP STREET SUITE 1040, HONOLULU, HI 96813
Preparer
Melanie a King
Phone
8085311040
Supplemental Narrative

Additional Explanations

Form 990, Part IX, Line 11G

Other professional fees: program service expenses 199,463. Management and general expenses 49,866. Fundraising expenses 0. Total expenses 249,329.

Financial Statement Notes

PART X, LINE 2:

U.s. Gaap requires uncertain tax positions to be recognized in the consolidated financial statements if they are more likely than not to fail upon regulatory examination. Management evaluated hah's, hherf's, and laulima's tax positions as of and for the years ended june 30, 2022 and 2021, and determined that hah, hherf, and laulima had no uncertain tax positions required to be reported in accordance with u.s. Gaap. Hah, hherf, and laulima are subject to routine audits by taxing jurisdictions; however, there are currently no audits in progress for any open tax periods.

Raw XML AppendixShowing 400 of 581 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReviewInd00
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt079927
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt091634
IRS990/AccountsReceivableGrp/BOYAmt08072
IRS990/AccountsReceivableGrp/EOYAmt03000
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0TO PROVIDE A COMPREHENSIVE DATA ANALYTICS AND REPORTING PLATFORM THAT HOSPITALS, HEALTHCARE LEADERS, POLICYMAKERS, RESEARCHERS, AND COMMUNITY LEADERS CAN ACCESS TO SUPPORT DECISION MAKING AND POLICY IN CREATING SUSTAINABLE HEALTHCARE SOLUTIONS FOR HAWAII'S COMMUNITIES.
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt012
IRS990/AllOtherExpensesGrp/ProgramServicesAmt042
IRS990/AllOtherExpensesGrp/TotalAmt054
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0WENDY ODO
IRS990/BooksInCareOfDetail/PhoneNum08085218961
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0707 RICHARDS STREET PH2
IRS990/BooksInCareOfDetail/USAddress/CityNm0HONOLULU
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0HI
IRS990/BooksInCareOfDetail/USAddress/ZIPCd096813
IRS990/BusinessRlnWith35CtrlEntInd00
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CashNonInterestBearingGrp/BOYAmt0349161
IRS990/CashNonInterestBearingGrp/EOYAmt0487286
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt0222251
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt024695
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt0246946
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd00
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt0475
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt01901
IRS990/ConferencesMeetingsGrp/TotalAmt02376
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd01
IRS990/ContractorCompensationGrp/CompensationAmt0205517
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/AddressLine1Txt0100 E GRAND AVE STE 100
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/CityNm0DES MOINES
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/StateAbbreviationCd0IA
IRS990/ContractorCompensationGrp/ContractorAddress/USAddress/ZIPCd050309
IRS990/ContractorCompensationGrp/ContractorName/BusinessName/BusinessNameLine1Txt0IOWA HOSPITAL ASSOCIATION
IRS990/ContractorCompensationGrp/ServicesDesc0DATA COLLECTION SERVICES
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt0356530
IRS990/CYOtherRevenueAmt07421
IRS990/CYProgramServiceRevenueAmt0910479
IRS990/CYRevenuesLessExpensesAmt0109213
IRS990/CYSalariesCompEmpBnftPaidAmt0452157
IRS990/CYTotalExpensesAmt0808687
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0917900
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt06667
IRS990/DeferredRevenueGrp/EOYAmt06666
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt01649
IRS990/DepreciationDepletionGrp/ProgramServicesAmt06600
IRS990/DepreciationDepletionGrp/TotalAmt08249
IRS990/Desc0DATA ANALYTICS AND REPORTING PLATFORM.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd01
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0346892
IRS990/FamilyOrBusinessRlnInd00
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt07597
IRS990/FeesForServicesAccountingGrp/TotalAmt07597
IRS990/FeesForServicesLegalGrp/ManagementAndGeneralAmt0157
IRS990/FeesForServicesLegalGrp/TotalAmt0157
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt049866
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0199463
IRS990/FeesForServicesOtherGrp/TotalAmt0249329
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt037.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt136.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt040.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt13.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt31.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt41.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt51.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt61.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt71.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt81.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt101.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt111.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt124.00
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd8X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd9X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd10X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd11X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt032822
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt128085
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt100
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt110
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1225741
IRS990/Form990PartVIISectionAGrp/PersonNm0HALEY HSIEH
IRS990/Form990PartVIISectionAGrp/PersonNm1HILTON RAETHEL
IRS990/Form990PartVIISectionAGrp/PersonNm2GREG CARLSON
IRS990/Form990PartVIISectionAGrp/PersonNm3LIBBY CHAR
IRS990/Form990PartVIISectionAGrp/PersonNm4JOHN CHEN
IRS990/Form990PartVIISectionAGrp/PersonNm5DAVID DOBBS
IRS990/Form990PartVIISectionAGrp/PersonNm6VINCE HU
IRS990/Form990PartVIISectionAGrp/PersonNm7GARY KAJIWARA
IRS990/Form990PartVIISectionAGrp/PersonNm8TIFFANY LEMMEN
IRS990/Form990PartVIISectionAGrp/PersonNm9QUIN OGAWA
IRS990/Form990PartVIISectionAGrp/PersonNm10STEVE ROBERTSON
IRS990/Form990PartVIISectionAGrp/PersonNm11KRIS WILSON
IRS990/Form990PartVIISectionAGrp/PersonNm12WENDY ODO
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0224925
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt1461967
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt12261990
IRS990/Form990PartVIISectionAGrp/TitleTxt0EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt1PRESIDENT & CEO
IRS990/Form990PartVIISectionAGrp/TitleTxt2DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt3DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt4SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt5DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt8DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt9DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt10DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt11DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt12CHIEF FINANCIAL OFFICER
IRS990/Form990ProvidedToGvrnBodyInd00
IRS990/FormationYr02018
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/ConsolidatedBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt012
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt0917900
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd01
IRS990/IndependentAuditFinclStmtInd00
IRS990/IndependentVotingMemberCnt010
IRS990/IndivRcvdGreaterThan100KCnt01
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt0686
IRS990/InformationTechnologyGrp/ProgramServicesAmt02746
IRS990/InformationTechnologyGrp/TotalAmt03432
IRS990/InsuranceGrp/ManagementAndGeneralAmt04443
IRS990/InsuranceGrp/ProgramServicesAmt017772
IRS990/InsuranceGrp/TotalAmt022215
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt03
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0199857
IRS990/LandBldgEquipBasisNetGrp/BOYAmt014342
IRS990/LandBldgEquipBasisNetGrp/EOYAmt011522
IRS990/LandBldgEquipCostOrOtherBssAmt0211379
IRS990/LegalDomicileStateCd0HI
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd01
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd01
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0TO PROVIDE A COMPREHENSIVE DATA ANALYTICS AND REPORTING PLATFORM THAT HOSPITALS, HEALTHCARE LEADERS, POLICYMAKERS, RESEARCHERS, AND COMMUNITY LEADERS CAN ACCESS TO SUPPORT DECISION MAKING AND POLICY IN CREATING SUSTAINABLE HEALTHCARE SOLUTIONS FOR HAWAII'S COMMUNITIES.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/NetAssetsOrFundBalancesBOYAmt0422122
IRS990/NetAssetsOrFundBalancesEOYAmt0531335
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0422122
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0531335
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt02733
IRS990/OccupancyGrp/ProgramServicesAmt010933
IRS990/OccupancyGrp/TotalAmt013666
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt0318
IRS990/OfficeExpensesGrp/ProgramServicesAmt01272
IRS990/OfficeExpensesGrp/TotalAmt01590
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt046031
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt05115
IRS990/OtherEmployeeBenefitsGrp/TotalAmt051146
IRS990/OtherExpensesGrp/Desc0PROGRAMS
IRS990/OtherExpensesGrp/Desc1TAXES
IRS990/OtherExpensesGrp/Desc2AUTOMOBILE AND PARKING
IRS990/OtherExpensesGrp/Desc3PUBLIC RELATIONS
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt05929
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt11674
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2765
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt3271
IRS990/OtherExpensesGrp/ProgramServicesAmt023716
IRS990/OtherExpensesGrp/ProgramServicesAmt16698
IRS990/OtherExpensesGrp/ProgramServicesAmt23061
IRS990/OtherExpensesGrp/ProgramServicesAmt31085
IRS990/OtherExpensesGrp/TotalAmt029645
IRS990/OtherExpensesGrp/TotalAmt18372
IRS990/OtherExpensesGrp/TotalAmt23826
IRS990/OtherExpensesGrp/TotalAmt31356
IRS990/OtherLiabilitiesGrp/BOYAmt03425
IRS990/OtherLiabilitiesGrp/EOYAmt06580
IRS990/OtherRevenueMiscGrp/BusinessCd0900099
IRS990/OtherRevenueMiscGrp/Desc0OTHER INCOME
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt07421
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt07421
IRS990/OtherRevenueTotalAmt07421
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0107486
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt011943
IRS990/OtherSalariesAndWagesGrp/TotalAmt0119429
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt06473
IRS990/PayrollTaxesGrp/ProgramServicesAmt025890
IRS990/PayrollTaxesGrp/TotalAmt032363
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt02046
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0227
IRS990/PensionPlanContributionsGrp/TotalAmt02273
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0140566
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0134407
IRS990/PrincipalOfficerNm0HILTON R RAETHEL
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0900099
IRS990/ProgramServiceRevenueGrp/BusinessCd1900099
IRS990/ProgramServiceRevenueGrp/Desc0MEMBERSHIP DUES
IRS990/ProgramServiceRevenueGrp/Desc1ALL OTHER PROGRAMS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0833479
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt177000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0833479
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt177000
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt059200
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt028
IRS990/PYOtherExpensesAmt0327216
IRS990/PYOtherRevenueAmt074
IRS990/PYProgramServiceRevenueAmt0778753
IRS990/PYRevenuesLessExpensesAmt072993
IRS990/PYSalariesCompEmpBnftPaidAmt0437846
IRS990/PYTotalExpensesAmt0765062
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt0838055
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0109213
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt0917900
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0FEDERAL INCOME TAX REFUND - 2019 AMOUNT: $ 792. MISCELLANEOUS INCOME - 2020 AMOUNT: $ 74. 2021 AMOUNT: $ 7,421.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0SCHEDULE A, PART III, LINE 12, EXPLANATION OF OTHER INCOME:
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt059200
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt059200
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt028
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt028
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt0910479
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt0778753
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt0828978
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt0830657
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt0758465
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt04107332
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt028
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt028
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt07421
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus1YearAmt074
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus2YearsAmt0792
IRS990ScheduleA/OtherIncome509Grp/TotalAmt08287
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportTotal509Amt04166532
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0910479
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0837953
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0828978
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0830657
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt0758465
IRS990ScheduleA/Total509Grp/TotalAmt04166532
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0917900
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0838055
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0829770
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0830657
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt0758465
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt04174847
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/EquipmentGrp/BookValueAmt011522
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0199294
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0210816
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt00
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt0563
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt0563
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt06580
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0DUE TO HAH
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0U.S. GAAP REQUIRES UNCERTAIN TAX POSITIONS TO BE RECOGNIZED IN THE CONSOLIDATED FINANCIAL STATEMENTS IF THEY ARE MORE LIKELY THAN NOT TO FAIL UPON REGULATORY EXAMINATION. MANAGEMENT EVALUATED HAH'S, HHERF'S, AND LAULIMA'S TAX POSITIONS AS OF AND FOR THE YEARS ENDED JUNE 30, 2022 AND 2021, AND DETERMINED THAT HAH, HHERF, AND LAULIMA HAD NO UNCERTAIN TAX POSITIONS REQUIRED TO BE REPORTED IN ACCORDANCE WITH U.S. GAAP. HAH, HHERF, AND LAULIMA ARE SUBJECT TO ROUTINE AUDITS BY TAXING JURISDICTIONS; HOWEVER, THERE ARE CURRENTLY NO AUDITS IN PROGRESS FOR ANY OPEN TAX PERIODS.
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0PART X, LINE 2:
IRS990ScheduleD/TotalBookValueLandBuildingsAmt011522
IRS990ScheduleD/TotalLiabilityAmt06580
IRS990ScheduleJ/AnyNonFixedPaymentsInd00
IRS990ScheduleJ/BoardOrCommitteeApprovalInd0X
IRS990ScheduleJ/CompBasedOnRevenueOfFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsRltdOrgsInd00
IRS990ScheduleJ/CompBsdOnRevRelatedOrgsInd00
IRS990ScheduleJ/CompensationSurveyInd0X
IRS990ScheduleJ/EquityBasedCompArrngmInd00
IRS990ScheduleJ/IndependentConsultantInd0X
IRS990ScheduleJ/InitialContractExceptionInd00
IRS990/ScheduleJRequiredInd01
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt2202932
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount219669
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt050367
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt129380
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt0395890
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt1225495
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt20

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings