Civic Intelligence

Laulima Data Alliance

990 • Fiscal year 2020 • EIN 82-1726643

Jul 01, 2019 to Jun 30, 2020 • Filed on Apr 20, 2021

Organization ProfileN/A
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

74th percentile

0.27x

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

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

Liabilities / Revenue

65th percentile

0.16x

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

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

Net Margin

48th percentile

5.2%

Higher net margin than 48% of similar nonprofits.

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

Top Officer Pay

98th percentile

$327,921

Higher top officer pay than 98% of similar nonprofits.

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

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

Asset Growth

74th percentile

28%

Faster asset growth than 74% of similar nonprofits.

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

Revenue Growth

51st percentile

-0.1%

Faster revenue growth than 51% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets74th percentile

Assets

Up

$480,473

Up $105,784 (+28%) from 2019

Net Assets

Up

$349,129

Up $42,884 (+14%) from 2019

Liabilities

Up

$131,344

Up $62,900 (+92%) from 2019

Revenue And Expenses
Liabilities / Revenue65th percentileNet Margin48th percentile

Revenue

Down

$829,559

Down $1,098 (-0.1%) from 2019

Expenses

Down

$786,675

Down $18,809 (-2.3%) from 2019

Net Income

Up

$42,884

Up $17,711 (+70%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth74th percentile

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

2020

Assets$480,473
Liabilities$131,344
Net Assets$349,129
Open 2020 Filing

Operations Trend

Revenue Growth51st percentile

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

2020

Revenue$829,559
Expenses$786,675
Net Income$42,884
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020
Signed
Apr 20, 2021
Return Version
2019v5.2
Gross Receipts
$829,770
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$181,452$318,834▲ $137,382
Prepaid Expenses and Deferred Charges$136,882$142,911▲ $6,029
Land, Buildings, and Equipment, Net$48,293$14,513▼ $33,780
Accounts Receivable$8,062$4,215▼ $3,847
Total Assets$374,689$480,473▲ $105,784
Liabilities
Accounts Payable and Accrued Expenses$66,510$64,157▼ $2,353
Unsecured Notes Loans Payable-$59,200-
Deferred Revenue-$6,667-
Other Liabilities$1,934$1,320▼ $614
Total Liabilities$68,444$131,344▲ $62,900
Net Assets / Fund Balance
Net Assets Without Donor Restrictions$306,245$349,129▲ $42,884
Total Net Assets Fund Balance$306,245$349,129▲ $42,884
Total Liabilities and Net Assets / Fund Balance$374,689$480,473▲ $105,784

Asset Categories

AssetBook ValueDepreciationBasis
Equipment$14,302$182,112$196,414
Other Land Buildings$211$351$562
Compensation and Service Providers
Top Officer Pay98th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Haley HsiehExecutive DirectorFT$165,437$55,700$221,137
Wendy OdoChief Financial Officer--$8,333$8,333

Board Members and Trustees

NameTitle
Hilton RaethelPresident & CEO
Steve RobertsonVice Chair
Brandon HargrettDirector
Bruce Anderson PhdDirector
Dan BrinkmanDirector
Donna ScannellDirector
Gary KajiwaraDirector
Kathy Fujihara-chongDirector
Scott MorimotoDirector
Tiffany LemmenDirector
Colbert SetoFormer Director
Bess HayashiFormer Chief Financial Officer
John Chen PhdSecretary

Highest Paid Contractors

ContractorServicesLocationCompensation
Iowa Hospital AssociationData Collection Services & Software100 E GRAND AVE STE 100, Des Moines, IA 50309$198,368
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$828,978
Investment Income
$-211
Other Revenue
$792
Change in Net Assets
$42,884
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$414,808
Other Expenses$371,867
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Information Technology$234,844$3,211-$238,055
Current Officers, Directors, Trustees, and Key Employees$22,430$201,874-$224,304
Other Salaries and Wages$101,616$33,670-$135,286
Depreciation Depletion$20,245$16,564-$36,809
Other Employee Benefits$15,744$10,858-$26,602
Payroll Taxes$7,811$13,300-$21,111
Occupancy$11,018$9,015-$20,033
Insurance$10,791$8,829-$19,620
Fees for Services Other$13,534$1,832-$15,366
Fees for Services Accounting-$12,111-$12,111
Travel$9,471--$9,471
Pension Plan Contributions$5,878$1,627-$7,505
Fees for Services Legal$4,965--$4,965
Conferences and Meetings$1,332$1,090-$2,422
Office Expenses$1,481$624-$2,105
Other Expenses$1,056$1,118-$1,118
Total Functional Expenses$464,607$322,068$0$786,675
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$1,320
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
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
No
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.”

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

“The compensation of the executive director was determined by the president/ceo along with the use of the salary review of the executive director position that was conducted in spring 2019. The review was performed by an independent consultant. In determining the compensation, the compensation for a similar position in a comparable organization was considered. 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
Hilton R Raethel
Title
President & Board Chair
Phone
8085218961
Signed
2021-04-20
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:

“Accounting principles generally accepted in the united states of america require 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 and laulima's tax positions as of and for the years ended june 30, 2020 and 2019 by reviewing their income tax returns and conferring with their tax advisors, and determined that hah and laulima had no uncertain tax positions required to be reported in accordance with such generally accepted accounting principles. Hah 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 576 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/BOYAmt066510
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt064157
IRS990/AccountsReceivableGrp/BOYAmt08062
IRS990/AccountsReceivableGrp/EOYAmt04215
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/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/BOYAmt0181452
IRS990/CashNonInterestBearingGrp/EOYAmt0318834
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt01
IRS990/CollectionsOfArtInd00
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt0201874
IRS990/CompCurrentOfcrDirectorsGrp/ProgramServicesAmt022430
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt0224304
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd00
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt01090
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt01332
IRS990/ConferencesMeetingsGrp/TotalAmt02422
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/ContractorCompensationGrp/CompensationAmt0198368
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 & SOFTWARE
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt0-211
IRS990/CYOtherExpensesAmt0371867
IRS990/CYOtherRevenueAmt0792
IRS990/CYProgramServiceRevenueAmt0828978
IRS990/CYRevenuesLessExpensesAmt042884
IRS990/CYSalariesCompEmpBnftPaidAmt0414808
IRS990/CYTotalExpensesAmt0786675
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0829559
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DeferredRevenueGrp/EOYAmt06667
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt016564
IRS990/DepreciationDepletionGrp/ProgramServicesAmt020245
IRS990/DepreciationDepletionGrp/TotalAmt036809
IRS990/Desc0DATA ANALYTICS AND REPORTING PLATFORM.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd00
IRS990/DonorAdvisedFundInd00
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd01
IRS990/EmployeeCnt02
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0464607
IRS990/FamilyOrBusinessRlnInd00
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt012111
IRS990/FeesForServicesAccountingGrp/TotalAmt012111
IRS990/FeesForServicesLegalGrp/ProgramServicesAmt04965
IRS990/FeesForServicesLegalGrp/TotalAmt04965
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt01832
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt013534
IRS990/FeesForServicesOtherGrp/TotalAmt015366
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt02.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt11.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt234.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt337.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRltdOrgRt437.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt01.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt11.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/AverageHoursPerWeekRt86.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt91.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt101.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt1140.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt121.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt133.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt143.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/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OfficerInd3X
IRS990/Form990PartVIISectionAGrp/OfficerInd4X
IRS990/Form990PartVIISectionAGrp/OfficerInd5X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt823291
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt100
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1132956
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt120
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt130
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt1424217
IRS990/Form990PartVIISectionAGrp/PersonNm0BRUCE ANDERSON PHD
IRS990/Form990PartVIISectionAGrp/PersonNm1DAN BRINKMAN
IRS990/Form990PartVIISectionAGrp/PersonNm2KATHY FUJIHARA-CHONG
IRS990/Form990PartVIISectionAGrp/PersonNm3BRANDON HARGRETT
IRS990/Form990PartVIISectionAGrp/PersonNm4GARY KAJIWARA
IRS990/Form990PartVIISectionAGrp/PersonNm5TIFFANY LEMMEN
IRS990/Form990PartVIISectionAGrp/PersonNm6SCOTT MORIMOTO
IRS990/Form990PartVIISectionAGrp/PersonNm7DONNA SCANNELL
IRS990/Form990PartVIISectionAGrp/PersonNm8HILTON RAETHEL
IRS990/Form990PartVIISectionAGrp/PersonNm9STEVE ROBERTSON
IRS990/Form990PartVIISectionAGrp/PersonNm10JOHN CHEN PHD
IRS990/Form990PartVIISectionAGrp/PersonNm11HALEY HSIEH
IRS990/Form990PartVIISectionAGrp/PersonNm12COLBERT SETO
IRS990/Form990PartVIISectionAGrp/PersonNm13WENDY ODO
IRS990/Form990PartVIISectionAGrp/PersonNm14BESS HAYASHI
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
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/ReportableCompFromOrgAmt11188181
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt130
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt140
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt8304630
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt100
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt110
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt120
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt138333
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt14158075
IRS990/Form990PartVIISectionAGrp/TitleTxt0DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt1DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt2DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt3DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt4DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt5DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt6DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt7DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt8PRESIDENT & CEO
IRS990/Form990PartVIISectionAGrp/TitleTxt9VICE CHAIR
IRS990/Form990PartVIISectionAGrp/TitleTxt10SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt11EXECUTIVE DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt12FORMER DIRECTOR
IRS990/Form990PartVIISectionAGrp/TitleTxt13CHIEF FINANCIAL OFFICER
IRS990/Form990PartVIISectionAGrp/TitleTxt14FORMER CHIEF FINANCIAL OFFICER
IRS990/Form990ProvidedToGvrnBodyInd00
IRS990/FormationYr02018
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedInd00
IRS990/FundraisingActivitiesInd00
IRS990/GainOrLossGrp/OtherAmt0-211
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt012
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt0829770
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd01
IRS990/IndependentAuditFinclStmtInd00
IRS990/IndependentVotingMemberCnt010
IRS990/IndivRcvdGreaterThan100KCnt01
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InformationTechnologyGrp/ManagementAndGeneralAmt03211
IRS990/InformationTechnologyGrp/ProgramServicesAmt0234844
IRS990/InformationTechnologyGrp/TotalAmt0238055
IRS990/InsuranceGrp/ManagementAndGeneralAmt08829
IRS990/InsuranceGrp/ProgramServicesAmt010791
IRS990/InsuranceGrp/TotalAmt019620
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt05
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt0182463
IRS990/LandBldgEquipBasisNetGrp/BOYAmt048293
IRS990/LandBldgEquipBasisNetGrp/EOYAmt014513
IRS990/LandBldgEquipCostOrOtherBssAmt0196976
IRS990/LegalDomicileStateCd0HI
IRS990/LessCostOthBasisSalesExpnssGrp/OtherAmt0211
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/NetAssetsOrFundBalancesBOYAmt0306245
IRS990/NetAssetsOrFundBalancesEOYAmt0349129
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt0-211
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt0-211
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoDonorRestrictionNetAssetsGrp/BOYAmt0306245
IRS990/NoDonorRestrictionNetAssetsGrp/EOYAmt0349129
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt09015
IRS990/OccupancyGrp/ProgramServicesAmt011018
IRS990/OccupancyGrp/TotalAmt020033
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt0624
IRS990/OfficeExpensesGrp/ProgramServicesAmt01481
IRS990/OfficeExpensesGrp/TotalAmt02105
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsFASB117Ind0X
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt010858
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt015744
IRS990/OtherEmployeeBenefitsGrp/TotalAmt026602
IRS990/OtherExpensesGrp/Desc0AUTOMOBILE AND PARKING
IRS990/OtherExpensesGrp/Desc1MISCELLANEOUS
IRS990/OtherExpensesGrp/Desc2EQUIPMENT RENT AND MAIN
IRS990/OtherExpensesGrp/Desc3PUBLIC RELATIONS
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt01956
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt13525
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt2864
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt31118
IRS990/OtherExpensesGrp/ProgramServicesAmt02391
IRS990/OtherExpensesGrp/ProgramServicesAmt11056
IRS990/OtherExpensesGrp/TotalAmt04347
IRS990/OtherExpensesGrp/TotalAmt13525
IRS990/OtherExpensesGrp/TotalAmt21920
IRS990/OtherExpensesGrp/TotalAmt31118
IRS990/OtherLiabilitiesGrp/BOYAmt01934
IRS990/OtherLiabilitiesGrp/EOYAmt01320
IRS990/OtherRevenueMiscGrp/BusinessCd0900099
IRS990/OtherRevenueMiscGrp/Desc0FEDERAL INCOME TAX REF
IRS990/OtherRevenueMiscGrp/RelatedOrExemptFuncIncomeAmt0792
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt0792
IRS990/OtherRevenueTotalAmt0792
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt033670
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0101616
IRS990/OtherSalariesAndWagesGrp/TotalAmt0135286
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PayrollTaxesGrp/ManagementAndGeneralAmt013300
IRS990/PayrollTaxesGrp/ProgramServicesAmt07811
IRS990/PayrollTaxesGrp/TotalAmt021111
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt01627
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt05878
IRS990/PensionPlanContributionsGrp/TotalAmt07505
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt0136882
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt0142911
IRS990/PrincipalOfficerNm0HILTON R RAETHEL
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0900099
IRS990/ProgramServiceRevenueGrp/BusinessCd1900099
IRS990/ProgramServiceRevenueGrp/Desc0MEMBERSHIP DUES
IRS990/ProgramServiceRevenueGrp/Desc1ALL OTHER PROGRAMS
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0586086
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt1242892
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0586086
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt1242892
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt00
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt00
IRS990/PYOtherExpensesAmt0419629
IRS990/PYOtherRevenueAmt00
IRS990/PYProgramServiceRevenueAmt0830657
IRS990/PYRevenuesLessExpensesAmt025173
IRS990/PYSalariesCompEmpBnftPaidAmt0385855
IRS990/PYTotalExpensesAmt0805484
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt0830657
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt042884
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd01
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd00
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RevenueAmt0829770
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0FEDERAL INCOME TAX REFUND - 2019 AMOUNT: $ 792.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0SCHEDULE A, PART III, LINE 12, EXPLANATION OF OTHER INCOME:
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt0828978
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt0830657
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt0758465
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt02418100
IRS990ScheduleA/OtherIncome509Grp/CurrentTaxYearAmt0792
IRS990ScheduleA/OtherIncome509Grp/TotalAmt0792
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportTotal509Amt02418100
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt0828978
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0830657
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0758465
IRS990ScheduleA/Total509Grp/TotalAmt02418100
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt0829770
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0830657
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0758465
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt02418892
IRS990/ScheduleBRequiredInd00
IRS990ScheduleD/EquipmentGrp/BookValueAmt014302
IRS990ScheduleD/EquipmentGrp/DepreciationAmt0182112
IRS990ScheduleD/EquipmentGrp/OtherCostOrOtherBasisAmt0196414
IRS990ScheduleD/FootnoteTextInd0X
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt0211
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt0351
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt0562
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt01320
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0DUE TO HAH
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0ACCOUNTING PRINCIPLES GENERALLY ACCEPTED IN THE UNITED STATES OF AMERICA REQUIRE 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 AND LAULIMA'S TAX POSITIONS AS OF AND FOR THE YEARS ENDED JUNE 30, 2020 AND 2019 BY REVIEWING THEIR INCOME TAX RETURNS AND CONFERRING WITH THEIR TAX ADVISORS, AND DETERMINED THAT HAH AND LAULIMA HAD NO UNCERTAIN TAX POSITIONS REQUIRED TO BE REPORTED IN ACCORDANCE WITH SUCH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. HAH 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/TotalBookValueLandBuildingsAmt014513
IRS990ScheduleD/TotalLiabilityAmt01320
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/BaseCompensationFilingOrgAmt1165437
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount118540
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt042488
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt20
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt0245090
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt10
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt2153907

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2020 • Form 990Detailed filing. Detailed filing data is available for this year.

Open filing
Assets
$480,473
Liabilities
$131,344
Net assets
$349,129
Revenue
$829,559
Expenses
$786,675
Net income
$42,884
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Summary only. Only limited summary data is available for this year.$8.06$1.88$6.18$9.81$8.99$0.82
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.36$1.05$5.31$9.18$8.09$1.09
2021Facts available. Structured filing facts are available, but richer extracted sections are limited.$5.12$0.90$4.22$8.38$7.65$0.73
2020Detailed filing. Detailed filing data is available for this year.$4.80$1.31$3.49$8.30$7.87$0.43
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.75$0.68$3.06$8.31$8.05$0.25
2018Summary only. Only limited summary data is available for this year.$4.64$2.69$1.95$7.58$5.63$1.95