Civic Intelligence

Laulima Data Alliance

990 • Fiscal year 2021 • EIN 82-1726643

Jul 01, 2020 to Jun 30, 2021 • Filed on May 11, 2022

707 Richards Street No Ph2Honolulu, HI 96813

(808) 521-8961

Siviq Scores

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

Liabilities / Assets

72nd percentile

0.18x

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

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

Liabilities / Revenue

65th percentile

0.11x

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

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

Net Margin

44th percentile

8.7%

Higher net margin than 44% of similar nonprofits.

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

Top Officer Pay

99th percentile

$419,276

Higher top officer pay than 99% of similar nonprofits.

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

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

Asset Growth

44th percentile

6.6%

Faster asset growth than 44% of similar nonprofits.

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

Revenue Growth

36th percentile

1.0%

Faster revenue growth than 36% of similar nonprofits.

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

Assets

Up

$512,141

Up $31,668 (+6.6%) from 2020

Net Assets

Up

$422,122

Up $72,993 (+21%) from 2020

Liabilities

Down

$90,019

Down $41,325 (-31%) from 2020

Revenue

Up

$838,055

Up $8,496 (+1.0%) from 2020

Expenses

Down

$765,062

Down $21,613 (-2.7%) from 2020

Net Income

Up

$72,993

Up $30,109 (+70%) from 2020

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

2021

Assets$512,141
Liabilities$90,019
Net Assets$422,122

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

2021

Revenue$838,055
Expenses$765,062
Net Income$72,993
Jump To
Filing Snapshot
Filing Period
Jul 1, 2020 to Jun 30, 2021
Signed
May 11, 2022
Return Version
2020v4.2
Gross Receipts
$838,055
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$318,834$349,161▲ $30,327
Prepaid Expenses and Deferred Charges$142,911$140,566▼ $2,345
Land, Buildings, and Equipment, Net$14,513$14,342▼ $171
Accounts Receivable$4,215$8,072▲ $3,857
Total Assets$480,473$512,141▲ $31,668
Liabilities
Accounts Payable and Accrued Expenses$64,157$79,927▲ $15,770
Unsecured Notes Loans Payable$59,200$0▼ $59,200
Deferred Revenue$6,667$6,667→ $0
Other Liabilities$1,320$3,425▲ $2,105
Total Liabilities$131,344$90,019▼ $41,325
Net Assets / Fund Balance
Net Assets Without Donor Restrictions$349,129$422,122▲ $72,993
Total Net Assets Fund Balance$349,129$422,122▲ $72,993
Total Liabilities and Net Assets / Fund Balance$480,473$512,141▲ $31,668

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$14,272$191,114$205,386
Other Land Buildings$70$493$563
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Haley HsiehExecutive DirectorFT$191,227$60,689$251,916

Board Members and Trustees

NameTitle
Hilton RaethelPresident & CEO
Steve RobertsonVice Chair
David DobbsDirector
Gary KajiwaraDirector
Greg CarlsonDirector
Kris WilsonDirector
Libby CharDirector
Quin OgawaDirector
Tiffany LemmenDirector
Vince HuDirector
Brandon HargrettFormer Director
Kathy Fujihara-chongFormer Director
Wendy OdoChief Financial Officer
John Chen PhdSecretary

Highest Paid Contractors

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

Revenue Composition

Contributions and Grants
$59,200
Program Service Revenue
$778,753
Investment Income
$28
Other Revenue
$74
Change in Net Assets
$72,993
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$437,846
Other Expenses$327,216
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Current Officers, Directors, Trustees, and Key Employees$25,364$228,277-$253,641
Information Technology$196,794$49,198-$245,992
Other Salaries and Wages$12,415$111,735-$124,150
Payroll Taxes$22,679$5,670-$28,349
Other Employee Benefits$2,449$22,042-$24,491
Insurance$15,998$4,000-$19,998
Occupancy$10,599$2,650-$13,249
Depreciation Depletion$7,315$1,829-$9,144
Fees for Services Accounting-$7,778-$7,778
Pension Plan Contributions$722$6,493-$7,215
Fees for Services Other$2,538$635-$3,173
Office Expenses$814$203-$1,017
Other Expenses$287$72-$359
Conferences and Meetings$182$45-$227
All Other Expenses$36$9-$45
Total Functional Expenses$319,180$445,882$0$765,062
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$3,425
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
Yes
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
Yes
Compensation from other sources disclosed
No
CEO compensation reviewed
Yes
Other officer compensation reviewed
No
Conflict-of-interest policy
Yes
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Part VI, Section A, Line 4

The bylaws were amended for the following: 1. Change the health-related organizations on the board from non-voting to voting ex-officio directors. 2. Replaced the rotating ex-officio board member.

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 NO PH2, HONOLULU, HI 96813

Signing Officer

Name
Wendy Odo
Title
Chief Financial Officer
Phone
8085218961
Signed
2022-05-11
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
2
Volunteers
12

Preparer

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

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 year ended june 30, 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 602 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/AccountantCompileOrReviewInd01
IRS990/AccountsPayableAccrExpnssGrp/BOYAmt064157
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt079927
IRS990/AccountsReceivableGrp/BOYAmt04215
IRS990/AccountsReceivableGrp/EOYAmt08072
IRS990/AcctCompileOrReviewBasisGrp/ConsolidatedBasisFinclStmtInd0X
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/ManagementAndGeneralAmt09
IRS990/AllOtherExpensesGrp/ProgramServicesAmt036
IRS990/AllOtherExpensesGrp/TotalAmt045
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/BOYAmt0318834
IRS990/CashNonInterestBearingGrp/EOYAmt0349161
IRS990/ChangeToOrgDocumentsInd01
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt0228277
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt025364
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt0253641
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd00
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt045
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt0182
IRS990/ConferencesMeetingsGrp/TotalAmt0227
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0186417
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/CYContributionsGrantsAmt059200
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt028
IRS990/CYOtherExpensesAmt0327216
IRS990/CYOtherRevenueAmt074
IRS990/CYProgramServiceRevenueAmt0778753
IRS990/CYRevenuesLessExpensesAmt072993
IRS990/CYSalariesCompEmpBnftPaidAmt0437846
IRS990/CYTotalExpensesAmt0765062
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0838055
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/BOYAmt06667
IRS990/DeferredRevenueGrp/EOYAmt06667
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt01829
IRS990/DepreciationDepletionGrp/ProgramServicesAmt07315
IRS990/DepreciationDepletionGrp/TotalAmt09144
IRS990/Desc0DATA ANALYTICS AND REPORTING PLATFORM.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd01
IRS990/EmployeeCnt02
IRS990/EmploymentTaxReturnsFiledInd00
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0319180
IRS990/FamilyOrBusinessRlnInd00
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt07778
IRS990/FeesForServicesAccountingGrp/TotalAmt07778
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt0635
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt02538
IRS990/FeesForServicesOtherGrp/TotalAmt03173
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt037.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt12.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt236.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/AverageHoursPerWeekRt121.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt131.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt144.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/IndividualTrusteeOrDirectorInd12X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd13X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt035630
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt123776
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/OtherCompensationAmt120
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt130
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1413884
IRS990/Form990PartVIISectionAGrp/PersonNm0HALEY HSIEH
IRS990/Form990PartVIISectionAGrp/PersonNm1HILTON RAETHEL
IRS990/Form990PartVIISectionAGrp/PersonNm2STEVE ROBERTSON
IRS990/Form990PartVIISectionAGrp/PersonNm3JOHN CHEN PHD
IRS990/Form990PartVIISectionAGrp/PersonNm4GREG CARLSON
IRS990/Form990PartVIISectionAGrp/PersonNm5LIBBY CHAR
IRS990/Form990PartVIISectionAGrp/PersonNm6DAVID DOBBS
IRS990/Form990PartVIISectionAGrp/PersonNm7VINCE HU
IRS990/Form990PartVIISectionAGrp/PersonNm8QUIN OGAWA
IRS990/Form990PartVIISectionAGrp/PersonNm9KRIS WILSON
IRS990/Form990PartVIISectionAGrp/PersonNm10GARY KAJIWARA
IRS990/Form990PartVIISectionAGrp/PersonNm11TIFFANY LEMMEN
IRS990/Form990PartVIISectionAGrp/PersonNm12KATHY FUJIHARA-CHONG
IRS990/Form990PartVIISectionAGrp/PersonNm13BRANDON HARGRETT
IRS990/Form990PartVIISectionAGrp/PersonNm14WENDY ODO
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt0216286
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/ReportableCompFromOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt140
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt1395500
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/ReportableCompFromRltdOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt14222756
IRS990/Form990PartVIISectionAGrp/TitleTxt0EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt1PRESIDENT & CEO
IRS990/Form990PartVIISectionAGrp/TitleTxt2VICE CHAIR
IRS990/Form990PartVIISectionAGrp/TitleTxt3SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt4DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt5DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt8DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt9DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt10DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt11DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt12FORMER DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt13FORMER DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt14CHIEF FINANCIAL OFFICER
IRS990/Form990ProvidedToGvrnBodyInd00
IRS990/FormationYr02018
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedInd00
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt012
IRS990/GovernmentGrantsAmt059200
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt0838055
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd01
IRS990/IndependentAuditFinclStmtInd00
IRS990/IndependentVotingMemberCnt010
IRS990/IndivRcvdGreaterThan100KCnt01
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt049198
IRS990/InformationTechnologyGrp/ProgramServicesAmt0196794
IRS990/InformationTechnologyGrp/TotalAmt0245992
IRS990/InsuranceGrp/ManagementAndGeneralAmt04000
IRS990/InsuranceGrp/ProgramServicesAmt015998
IRS990/InsuranceGrp/TotalAmt019998
IRS990/InvestmentIncomeGrp/ExclusionAmt028
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt028
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt04
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0191607
IRS990/LandBldgEquipBasisNetGrp/BOYAmt014513
IRS990/LandBldgEquipBasisNetGrp/EOYAmt014342
IRS990/LandBldgEquipCostOrOtherBssAmt0205949
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/NetAssetsOrFundBalancesBOYAmt0349129
IRS990/NetAssetsOrFundBalancesEOYAmt0422122
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0349129
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0422122
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt02650
IRS990/OccupancyGrp/ProgramServicesAmt010599
IRS990/OccupancyGrp/TotalAmt013249
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt0203
IRS990/OfficeExpensesGrp/ProgramServicesAmt0814
IRS990/OfficeExpensesGrp/TotalAmt01017
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt022042
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt02449
IRS990/OtherEmployeeBenefitsGrp/TotalAmt024491
IRS990/OtherExpensesGrp/Desc0PROGRAMS
IRS990/OtherExpensesGrp/Desc1AUTOMOBILE AND PARKING
IRS990/OtherExpensesGrp/Desc2PUBLIC RELATIONS
IRS990/OtherExpensesGrp/Desc3EQUIPMENT RENT AND MAIN
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt04320
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt1765
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2161
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt372
IRS990/OtherExpensesGrp/ProgramServicesAmt017280
IRS990/OtherExpensesGrp/ProgramServicesAmt13061
IRS990/OtherExpensesGrp/ProgramServicesAmt2647
IRS990/OtherExpensesGrp/ProgramServicesAmt3287
IRS990/OtherExpensesGrp/TotalAmt021600
IRS990/OtherExpensesGrp/TotalAmt13826
IRS990/OtherExpensesGrp/TotalAmt2808
IRS990/OtherExpensesGrp/TotalAmt3359
IRS990/OtherLiabilitiesGrp/BOYAmt01320
IRS990/OtherLiabilitiesGrp/EOYAmt03425
IRS990/OtherRevenueMiscGrp/BusinessCd0900099
IRS990/OtherRevenueMiscGrp/Desc0OTHER INCOME
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt074
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt074
IRS990/OtherRevenueTotalAmt074
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt0111735
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt012415
IRS990/OtherSalariesAndWagesGrp/TotalAmt0124150
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt05670
IRS990/PayrollTaxesGrp/ProgramServicesAmt022679
IRS990/PayrollTaxesGrp/TotalAmt028349
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt06493
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt0722
IRS990/PensionPlanContributionsGrp/TotalAmt07215
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0142911
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0140566
IRS990/PrincipalOfficerNm0HILTON R RAETHEL
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0900099
IRS990/ProgramServiceRevenueGrp/BusinessCd1900099
IRS990/ProgramServiceRevenueGrp/Desc0MEMBERSHIP DUES
IRS990/ProgramServiceRevenueGrp/Desc1ALL OTHER PROGRAMS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0586253
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt1192500
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0586253
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt1192500
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt00
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt0-211
IRS990/PYOtherExpensesAmt0371867
IRS990/PYOtherRevenueAmt0792
IRS990/PYProgramServiceRevenueAmt0828978
IRS990/PYRevenuesLessExpensesAmt042884
IRS990/PYSalariesCompEmpBnftPaidAmt0414808
IRS990/PYTotalExpensesAmt0786675
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt0829559
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt072993
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt0778827
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0FEDERAL INCOME TAX REFUND - 2019 AMOUNT: $ 792. MISCELLANEOUS INCOME - 2020 AMOUNT: $ 74.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0SCHEDULE A, PART III, LINE 12, EXPLANATION OF OTHER INCOME:
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt059200
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt059200
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt028
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt028
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt0778753
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt0828978
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt0830657
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt0758465
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt03196853
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt028
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt028
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt074
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearMinus1YearAmt0792
IRS990ScheduleA/OtherIncome509Grp/TotalAmt0866
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportTotal509Amt03256053
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0837953
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0828978
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0830657
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt0758465
IRS990ScheduleA/Total509Grp/TotalAmt03256053
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0838055
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0829770
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0830657
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt0758465
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt03256947
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990/ScheduleBRequiredInd01
IRS990ScheduleD/EquipmentGrp/BookValueAmt014272
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0191114
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0205386
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt070
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt0493
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt0563
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt03425
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 YEAR ENDED JUNE 30, 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/TotalBookValueLandBuildingsAmt014342
IRS990ScheduleD/TotalLiabilityAmt03425
IRS990ScheduleJ/AnyNonFixedPaymentsInd00
IRS990ScheduleJ/BoardOrCommitteeApprovalInd0X
IRS990ScheduleJ/CompBasedOnRevenueOfFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsFlngOrgInd00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings