Civic Intelligence

Hawaii Data Collaborative C/O Cfm

990 • Fiscal year 2022 • EIN 85-1297961

Jan 01, 2022 to Dec 31, 2022 • Filed on Nov 15, 2023

827 Fort Street Mall 2nd FloorHonolulu, HI 96813

(408) 358-3316

Siviq Scores

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

Liabilities / Assets

78th percentile

0.34x

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

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

Liabilities / Revenue

71st percentile

0.27x

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

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

Net Margin

70th percentile

19%

Higher net margin than 70% of similar nonprofits.

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

Top Officer Pay

92nd percentile

$225,500

Higher top officer pay than 92% of similar nonprofits.

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

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

Asset Growth

95th percentile

113%

Faster asset growth than 95% of similar nonprofits.

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

Revenue Growth

74th percentile

31%

Faster revenue growth than 74% of similar nonprofits.

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

Assets

Up

$1,295,234

Up $686,363 (+113%) from 2021

Net Assets

Up

$853,044

Up $317,850 (+59%) from 2021

Liabilities

Up

$442,190

Up $368,513 (+500%) from 2021

Revenue

Up

$1,645,268

Up $389,748 (+31%) from 2021

Expenses

Up

$1,327,418

Up $149,663 (+13%) from 2021

Net Income

Up

$317,850

Up $240,085 (+309%) from 2021

Historical Trend

Balance Sheet Trend

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

$1.5M$1.0M$500K$0Assets 2020: $462,250Liabilities 2020: $4,821Net Assets 2020: $457,4292020Assets 2021: $608,871Liabilities 2021: $73,677Net Assets 2021: $535,1942021Assets 2022: $1,295,234Liabilities 2022: $442,190Net Assets 2022: $853,0442022Assets 2024: $1,351,382Liabilities 2024: $375,149Net Assets 2024: $976,2332024

Highlighted filing

2022

Assets$1,295,234
Liabilities$442,190
Net Assets$853,044

Operations Trend

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

$2.0M$1.5M$1.0M$500K$0Revenue 2020: $462,250Expenses 2020: $4,821Net Income 2020: $457,4292020Revenue 2021: $1,255,520Expenses 2021: $1,177,755Net Income 2021: $77,7652021Revenue 2022: $1,645,268Expenses 2022: $1,327,418Net Income 2022: $317,8502022Revenue 2024: $1,692,500Expenses 2024: $1,610,504Net Income 2024: $81,9962024

Highlighted filing

2022

Revenue$1,645,268
Expenses$1,327,418
Net Income$317,850
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Nov 15, 2023
Return Version
2022v5.0
Gross Receipts
$1,645,268
Mission and Program Overview

Mission

The Hawaii Data Collaborative partners with service-providing nonprofits, government and philanthropy to build data capacities alongside platforms for data sharing and collaboration that improve outcomes for Hawai'i's households and communities.

Balance Sheet Detail
LineBeginningEndChange
Assets
Cash and Non-Interest-Bearing Accounts$191,115$871,407▲ $680,292
Rtn Earn Endowment Incm Other Fnds$535,194$853,044▲ $317,850
Pledges and Grants Receivable$350,000$0▼ $350,000
Land, Buildings, and Equipment, Net$0$66,085▲ $66,085
Prepaid Expenses and Deferred Charges$37,003$33,939▼ $3,064
Accounts Receivable-$4,712-
Pd in Cap Srpls Land Bldg Eqp Fund$0$0→ $0
Cap Stk Tr Prin Current Funds$0$0→ $0
Total Assets$608,871$1,295,234▲ $686,363
Other Assets Total$30,753$319,091▲ $288,338
Liabilities
Other Liabilities$0$318,891▲ $318,891
Accounts Payable and Accrued Expenses$73,677$123,299▲ $49,622
Total Liabilities$73,677$442,190▲ $368,513
Net Assets / Fund Balance
Total Net Assets Fund Balance$535,194$853,044▲ $317,850
Total Liabilities and Net Assets / Fund Balance$608,871$1,295,234▲ $686,363

Asset Categories

AssetBook ValueDepreciationBasis
Other Land Buildings$66,085$4,183$70,268
Other Assets Org$318,891--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Nick ReddingExecutive DirectorFT$205,000$20,500$225,500
Thomas Ho Won LeeStrategic Partnerships SpecialistFT$132,659-$132,659
Adriann GinDirector of EngagementFT$102,874-$102,874
Kendrick LeongResearch SpecialistFT$102,546-$102,546
Tiana TranData & Visualization SpecialistFT$102,546-$102,546

Board Members and Trustees

NameTitle
Randall K H ChingDirector, Board Chair
Lisa MaruyamaDirector
Micah KaneDirector
Jill TokudaDirector, Secretary
Michael G MohrDirector, Treasurer
Revenue and Support

Revenue Composition

Contributions and Grants
$1,495,268
Program Service Revenue
$150,000
Investment Income
$0
Other Revenue
$0
All Other Contributions
$1,495,268
Change in Net Assets
$317,850

Audited Revenue Reconciliation

Revenue per Audited Statements
$1,645,268
Revenue Not Reported on Financial Statements
$0
Revenue Not Reported on Form 990
$67,000
Total Revenue per Audited Statements
$1,712,268
Total Revenue per Form 990
$1,645,268
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Salaries, Compensation, and Employee Benefits$922,480
Other Expenses$404,938
Grants and Similar Amounts Paid$0
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Other Salaries and Wages$693,689$24,274-$717,963
Fees for Services Other$109,840$54,000-$163,840
Other Employee Benefits$130,129$14,553-$144,682
Pension Plan Contributions$52,777$7,058-$59,835
Fees for Services Accounting$2,063$44,880-$46,943
Occupancy$39,784$5,070-$44,854
All Other Expenses$10,973$12,038-$23,011
Fees for Service Investment Mgmnt Fees-$13,000-$13,000
Travel$6$12,308-$12,314
Office Expenses-$6,222-$6,222
Depreciation Depletion-$4,183-$4,183
Other Expenses$4,000$3,932-$4,000
Insurance-$1,797-$1,797
Conferences and Meetings$209$910-$1,119
Total Functional Expenses$1,123,193$204,225$0$1,327,418

Audited Expense Reconciliation

Line ItemAmount
Total Expenses per Audited Statements$1,394,418
Expenses per Audited Statements$1,327,418
Total Expenses per Form 990$1,327,418
Expenses Not Reported on Form 990$67,000
Expenses Not Reported on Financial Statements$0
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
Lease Liability$318,891
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Annual disclosure for covered persons
Yes
Audit committee
Yes
Backup withholding compliance
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
Yes
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 8B

Board meetings are documented and the meeting minutes are approved at the next board meeting. Currently there are no committees with authority to act on behalf of the governing body, thus there are no committee meetings to document. If and when committees may be formed, they will be documented in the same manner as governing body meetings.

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

Submitted to directors for review and comment. Any questions to be answered and the forms updated for final signature.

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

Hawaii Data Collaborative monitors and enforces its conflict of interest policy by annually reviewing potential conflicts with the trustees, officers, directors and key employees. The policy outlines a process by which Hawaii Data Collaborative evaluates and protects against undue influence by any person who may have a conflict of interest as well as outlines a process if there is a potential violation. The Board reviews the policy on a periodic basis.

Form 990, Part VI, Section B, line 15

The process that Hawaii Data Collaborative conducts in determining compensation for officers and key employees (board members are not compensated) includes conducting a compensation benchmark study and analysis for each compensated officer and key employee. The analysis of the study is reviewed for approval of the appropriate compensation.

Form 990, Part VI, Section C, line 19

Hawaii Data Collaborative's governing documents, policies and financial statements are available to the public upon request.

Filing and Contact Details

Filer

Filer Name
Hawaii Data Collaborative
EIN
85-1297961
Phone
4083583316
Address
827 Fort Street Mall 2nd Floor, Honolulu, HI 96813

Signing Officer

Name
Michael G Mohr
Title
Treasurer & Board Chair
Phone
4083583316
Signed
2023-11-15
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Michael G Mohr
Formed
2020
Legal Domicile
Hi
Voting Board Members
4
Independent Board Members
4
Employees
8
Volunteers
0

Preparer

Firm
Comprehensive Financial Management
Address
720 University Ave 200, Los Gatos, CA 95032
Preparer
Roger V Hansen
Phone
4083583316
Supplemental Narrative

Additional Explanations

Form 990, Part III, line 2

New programs include (1) Human Services Organizations Data Capacity Support and (2) Hawai'i Community Foundation.

Form 990, Part III, line 3

Programs that ceased operating in 2022 include: (1) Aloha United Way (AUW) 211 partnership and (2) Ko'olau Eviction Prevention Program.

Form 990, Part IX, line 11G

Consulting: Program service expenses 109,840. Management and general expenses 0. Fundraising expenses 0. Total expenses 109,840. TOGS Allocated Expenses: Program service expenses 0. Management and general expenses 54,000. Fundraising expenses 0. Total expenses 54,000.

Form 990, Part IX, line 24E

Telephone - Cellular & Data: Program service expenses 3,265. Management and general expenses 299. Fundraising expenses 0. Total expenses 3,564. License and Fees: Program service expenses 2,698. Management and general expenses 678. Fundraising expenses 0. Total expenses 3,376. Computer Hardware & Devices: Program service expenses 0. Management and general expenses 2,899. Fundraising expenses 0. Total expenses 2,899. Printing and Reproduction: Program service expenses 0. Management and general expenses 2,433. Fundraising expenses 0. Total expenses 2,433. Books, Publications & Subscriptions: Program service expenses 2,144. Management and general expenses 0. Fundraising expenses 0. Total expenses 2,144. Gifts & appreciation: Program service expenses 0. Management and general expenses 1,727. Fundraising expenses 0. Total expenses 1,727. Professional Development and Education: Program service expenses 1,035. Management and general expenses 430. Fundraising expenses 0. Total expenses 1,465. Computer Supplies and Tech: Program service expenses 0. Management and general expenses 1,177. Fundraising expenses 0. Total expenses 1,177. Staff Personal Development: Program service expenses 0. Management and general expenses 980. Fundraising expenses 0. Total expenses 980. Excise Tax: Program service expenses 908. Management and general expenses 61. Fundraising expenses 0. Total expenses 969. Bank & Broker Fees: Program service expenses 0. Management and general expenses 835. Fundraising expenses 0. Total expenses 835. Memberships & Dues: Program service expenses 500. Management and general expenses 0. Fundraising expenses 0. Total expenses 500. Miscellaneous Expenses: Program service expenses 0. Management and general expenses 287. Fundraising expenses 0. Total expenses 287. Postage and Delivery: Program service expenses 0. Management and general expenses 232. Fundraising expenses 0. Total expenses 232. Identity, Communications and PR: Program service expenses 210. Management and general expenses 0. Fundraising expenses 0. Total expenses 210. Association Memberships: Program service expenses 147. Management and general expenses 0. Fundraising expenses 0. Total expenses 147. Research Tools/Subscriptions: Program service expenses 66. Management and general expenses 0. Fundraising expenses 0. Total expenses 66.

Raw XML AppendixShowing 400 of 476 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/BOYAmt073677
IRS990/AccountsPayableAccrExpnssGrp/EOYAmt0123299
IRS990/AccountsReceivableGrp/EOYAmt04712
IRS990/ActivitiesConductedPrtshpInd00
IRS990/ActivityOrMissionDesc0The Hawaii Data Collaborative partners with service-providing nonprofits, government and philanthropy to build data capacities alongside platforms for data sharing and collaboration that improve outcomes for Hawai'i's households and communities.
IRS990/AllOtherContributionsAmt01495268
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt012038
IRS990/AllOtherExpensesGrp/ProgramServicesAmt010973
IRS990/AllOtherExpensesGrp/TotalAmt023011
IRS990/AnnualDisclosureCoveredPrsnInd01
IRS990/AuditCommitteeInd01
IRS990/BackupWthldComplianceInd01
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0Michelle Green
IRS990/BooksInCareOfDetail/PhoneNum04083583316
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt0720 University Ave Ste 200
IRS990/BooksInCareOfDetail/USAddress/CityNm0Los Gatos
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0CA
IRS990/BooksInCareOfDetail/USAddress/ZIPCd095032
IRS990/BusinessRlnWith35CtrlEntInd00
IRS990/BusinessRlnWithFamMemInd00
IRS990/BusinessRlnWithOrgMemInd00
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt00
IRS990/CapStkTrPrinCurrentFundsGrp/EOYAmt00
IRS990/CashNonInterestBearingGrp/BOYAmt0191115
IRS990/CashNonInterestBearingGrp/EOYAmt0871407
IRS990/ChangeToOrgDocumentsInd00
IRS990/CntrctRcvdGreaterThan100KCnt00
IRS990/CollectionsOfArtInd00
IRS990/CompensationFromOtherSrcsInd00
IRS990/CompensationProcessCEOInd01
IRS990/CompensationProcessOtherInd01
IRS990/ConferencesMeetingsGrp/ManagementAndGeneralAmt0910
IRS990/ConferencesMeetingsGrp/ProgramServicesAmt0209
IRS990/ConferencesMeetingsGrp/TotalAmt01119
IRS990/ConflictOfInterestPolicyInd01
IRS990/ConservationEasementsInd00
IRS990/ConsolidatedAuditFinclStmtInd00
IRS990/CreditCounselingInd00
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt01495268
IRS990/CYGrantsAndSimilarPaidAmt00
IRS990/CYInvestmentIncomeAmt00
IRS990/CYOtherExpensesAmt0404938
IRS990/CYOtherRevenueAmt00
IRS990/CYProgramServiceRevenueAmt0150000
IRS990/CYRevenuesLessExpensesAmt0317850
IRS990/CYSalariesCompEmpBnftPaidAmt0922480
IRS990/CYTotalExpensesAmt01327418
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt01645268
IRS990/DecisionsSubjectToApprovaInd00
IRS990/DeductibleArtContributionInd00
IRS990/DeductibleNonCashContriInd00
IRS990/DelegationOfMgmtDutiesInd00
IRS990/DepreciationDepletionGrp/ManagementAndGeneralAmt04183
IRS990/DepreciationDepletionGrp/TotalAmt04183
IRS990/Desc0Human Services Organizations Data Capacity Support: HDC developed relationships with multiple Hawai'i-focused human services organizations to develop strategies for making more effective use of data, and to build sustainable data capacities with those organizations to more effectively serve households and inform the broader community about issues and opportunities with the organization's service domain.
IRS990/DescribedInSection501c3Ind01
IRS990/DisregardedEntityInd00
IRS990/DocumentRetentionPolicyInd01
IRS990/DonorAdvisedFundInd00
IRS990/DonorRstrOrQuasiEndowmentsInd00
IRS990/ElectionOfBoardMembersInd00
IRS990/EmployeeCnt08
IRS990/EmploymentTaxReturnsFiledInd01
IRS990/EngagedInExcessBenefitTransInd00
IRS990/ExpenseAmt0786235
IRS990/FamilyOrBusinessRlnInd00
IRS990/FederalGrantAuditRequiredInd00
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt044880
IRS990/FeesForServicesAccountingGrp/ProgramServicesAmt02063
IRS990/FeesForServicesAccountingGrp/TotalAmt046943
IRS990/FeesForServicesOtherGrp/ManagementAndGeneralAmt054000
IRS990/FeesForServicesOtherGrp/ProgramServicesAmt0109840
IRS990/FeesForServicesOtherGrp/TotalAmt0163840
IRS990/FeesForSrvcInvstMgmntFeesGrp/ManagementAndGeneralAmt013000
IRS990/FeesForSrvcInvstMgmntFeesGrp/TotalAmt013000
IRS990/ForeignActivitiesInd00
IRS990/ForeignFinancialAccountInd00
IRS990/ForeignOfficeInd00
IRS990/Form8282PropertyDisposedOfInd00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt00.58
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt10.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt21.54
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt30.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt40.25
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt540.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt640.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt740.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt840.00
IRS990/Form990PartVIISectionAGrp/AverageHoursPerWeekRt940.00
IRS990/Form990PartVIISectionAGrp/HighestCompensatedEmployeeInd0X
IRS990/Form990PartVIISectionAGrp/HighestCompensatedEmployeeInd1X
IRS990/Form990PartVIISectionAGrp/HighestCompensatedEmployeeInd2X
IRS990/Form990PartVIISectionAGrp/HighestCompensatedEmployeeInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/KeyEmployeeInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
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/OtherCompensationAmt80
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt90
IRS990/Form990PartVIISectionAGrp/PersonNm0Randall K H Ching
IRS990/Form990PartVIISectionAGrp/PersonNm1Jill Tokuda
IRS990/Form990PartVIISectionAGrp/PersonNm2Michael G Mohr
IRS990/Form990PartVIISectionAGrp/PersonNm3Micah Kane
IRS990/Form990PartVIISectionAGrp/PersonNm4Lisa Maruyama
IRS990/Form990PartVIISectionAGrp/PersonNm5Nick Redding
IRS990/Form990PartVIISectionAGrp/PersonNm6Kendrick Leong
IRS990/Form990PartVIISectionAGrp/PersonNm7Tiana Tran
IRS990/Form990PartVIISectionAGrp/PersonNm8Thomas Ho Won Lee
IRS990/Form990PartVIISectionAGrp/PersonNm9Adriann Gin
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt5225500
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt6102546
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt7102546
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt8132659
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt9102874
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/ReportableCompFromRltdOrgAmt80
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt90
IRS990/Form990PartVIISectionAGrp/TitleTxt0Director, Board Chair
IRS990/Form990PartVIISectionAGrp/TitleTxt1Director, Secretary
IRS990/Form990PartVIISectionAGrp/TitleTxt2Director, Treasurer
IRS990/Form990PartVIISectionAGrp/TitleTxt3Director
IRS990/Form990PartVIISectionAGrp/TitleTxt4Director
IRS990/Form990PartVIISectionAGrp/TitleTxt5Executive Director
IRS990/Form990PartVIISectionAGrp/TitleTxt6Research Specialist
IRS990/Form990PartVIISectionAGrp/TitleTxt7Data & Visualization Specialist
IRS990/Form990PartVIISectionAGrp/TitleTxt8Strategic Partnerships Specialist
IRS990/Form990PartVIISectionAGrp/TitleTxt9Director of Engagement
IRS990/Form990ProvidedToGvrnBodyInd01
IRS990/FormationYr02020
IRS990/FormerOfcrEmployeesListedInd00
IRS990/FSAuditedBasisGrp/SeparateBasisFinclStmtInd0X
IRS990/FSAuditedInd01
IRS990/FundraisingActivitiesInd00
IRS990/GamingActivitiesInd00
IRS990/GoverningBodyVotingMembersCnt04
IRS990/GrantsToIndividualsInd00
IRS990/GrantsToOrganizationsInd00
IRS990/GrantToRelatedPersonInd00
IRS990/GrossReceiptsAmt01645268
IRS990/GroupReturnForAffiliatesInd00
IRS990/IncludeFIN48FootnoteInd00
IRS990/IndependentAuditFinclStmtInd01
IRS990/IndependentVotingMemberCnt04
IRS990/IndivRcvdGreaterThan100KCnt05
IRS990/IndoorTanningServicesInd00
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartIXInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InsuranceGrp/ManagementAndGeneralAmt01797
IRS990/InsuranceGrp/TotalAmt01797
IRS990/InvestmentInJointVentureInd00
IRS990/IRPDocumentCnt08
IRS990/IRPDocumentW2GCnt00
IRS990/LandBldgEquipAccumDeprecAmt04183
IRS990/LandBldgEquipBasisNetGrp/BOYAmt00
IRS990/LandBldgEquipBasisNetGrp/EOYAmt066085
IRS990/LandBldgEquipCostOrOtherBssAmt070268
IRS990/LegalDomicileStateCd0HI
IRS990/LoanOutstandingInd00
IRS990/LobbyingActivitiesInd00
IRS990/LocalChaptersInd00
IRS990/MaterialDiversionOrMisuseInd00
IRS990/MembersOrStockholdersInd00
IRS990/MethodOfAccountingAccrualInd0X
IRS990/MinutesOfCommitteesInd00
IRS990/MinutesOfGoverningBodyInd01
IRS990/MissionDesc0The Hawaii Data Collaborative partners with service-providing nonprofits, government and philanthropy to build data capacities alongside platforms for data sharing and collaboration that improve outcomes for Hawai'i's households and communities.
IRS990/MoreThan5000KToIndividualsInd00
IRS990/MoreThan5000KToOrgInd00
IRS990/NetAssetsOrFundBalancesBOYAmt0535194
IRS990/NetAssetsOrFundBalancesEOYAmt0853044
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd00
IRS990/OccupancyGrp/ManagementAndGeneralAmt05070
IRS990/OccupancyGrp/ProgramServicesAmt039784
IRS990/OccupancyGrp/TotalAmt044854
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt06222
IRS990/OfficeExpensesGrp/TotalAmt06222
IRS990/OfficerMailingAddressInd00
IRS990/OperateHospitalInd00
IRS990/Organization501c3Ind0X
IRS990/OrgDoesNotFollowFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt030753
IRS990/OtherAssetsTotalGrp/EOYAmt0319091
IRS990/OtherChangesInNetAssetsAmt00
IRS990/OtherEmployeeBenefitsGrp/ManagementAndGeneralAmt014553
IRS990/OtherEmployeeBenefitsGrp/ProgramServicesAmt0130129
IRS990/OtherEmployeeBenefitsGrp/TotalAmt0144682
IRS990/OtherExpensesGrp/Desc0Online Connection, Serv
IRS990/OtherExpensesGrp/Desc1Computer Software
IRS990/OtherExpensesGrp/Desc2Computer Software - Dat
IRS990/OtherExpensesGrp/Desc3Donations, Grants & Gif
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt03932
IRS990/OtherExpensesGrp/ProgramServicesAmt040582
IRS990/OtherExpensesGrp/ProgramServicesAmt125461
IRS990/OtherExpensesGrp/ProgramServicesAmt213680
IRS990/OtherExpensesGrp/ProgramServicesAmt34000
IRS990/OtherExpensesGrp/TotalAmt044514
IRS990/OtherExpensesGrp/TotalAmt125461
IRS990/OtherExpensesGrp/TotalAmt213680
IRS990/OtherExpensesGrp/TotalAmt34000
IRS990/OtherLiabilitiesGrp/BOYAmt00
IRS990/OtherLiabilitiesGrp/EOYAmt0318891
IRS990/OtherSalariesAndWagesGrp/ManagementAndGeneralAmt024274
IRS990/OtherSalariesAndWagesGrp/ProgramServicesAmt0693689
IRS990/OtherSalariesAndWagesGrp/TotalAmt0717963
IRS990/PartialLiquidationInd00
IRS990/PayPremiumsPrsnlBnftCntrctInd00
IRS990/PdInCapSrplsLandBldgEqpFundGrp/BOYAmt00
IRS990/PdInCapSrplsLandBldgEqpFundGrp/EOYAmt00
IRS990/PensionPlanContributionsGrp/ManagementAndGeneralAmt07058
IRS990/PensionPlanContributionsGrp/ProgramServicesAmt052777
IRS990/PensionPlanContributionsGrp/TotalAmt059835
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt0350000
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt00
IRS990/PoliticalCampaignActyInd00
IRS990/PrepaidExpensesDefrdChargesGrp/BOYAmt037003
IRS990/PrepaidExpensesDefrdChargesGrp/EOYAmt033939
IRS990/PrincipalOfficerNm0Michael G Mohr
IRS990/ProfessionalFundraisingInd00
IRS990/ProgramServiceRevenueGrp/BusinessCd0541610
IRS990/ProgramServiceRevenueGrp/Desc0Consulting Services
IRS990/ProgramServiceRevenueGrp/RelatedOrExemptFuncIncomeAmt0150000
IRS990/ProgramServiceRevenueGrp/TotalRevenueColumnAmt0150000
IRS990/ProgSrvcAccomActy2Grp/Desc0Government Data Partnerships: HDC conducted a comprehensive review of Hawaii State Government data capacities and opportunities to develop internal strategies for agencies to more effectively use and share data for the broadest benefit. Activities include advisement and consultation with agency leadership, education and training with agency staff, and general advocacy for improvements in Hawaii State Government data processes.
IRS990/ProgSrvcAccomActy2Grp/ExpenseAmt0112319
IRS990/ProgSrvcAccomActy3Grp/Desc0Hawai'i Community Foundation: HDC provided general data advisement, analysis and visualization services to the Hawai'i Community Foundation CHANGE Initiative in support of the grant-making process, from developing grant programs to assessing the impacts of grants distributed.
IRS990/ProgSrvcAccomActy3Grp/ExpenseAmt0224639
IRS990/ProgSrvcAccomActy3Grp/RevenueAmt0150000
IRS990/ProhibitedTaxShelterTransInd00
IRS990/PYBenefitsPaidToMembersAmt00
IRS990/PYContributionsGrantsAmt01255520
IRS990/PYExcessBenefitTransInd00
IRS990/PYGrantsAndSimilarPaidAmt00
IRS990/PYInvestmentIncomeAmt00
IRS990/PYOtherExpensesAmt0528816
IRS990/PYOtherRevenueAmt00
IRS990/PYProgramServiceRevenueAmt00
IRS990/PYRevenuesLessExpensesAmt077765
IRS990/PYSalariesCompEmpBnftPaidAmt0648939
IRS990/PYTotalExpensesAmt01177755
IRS990/PYTotalProfFndrsngExpnsAmt00
IRS990/PYTotalRevenueAmt01255520
IRS990/QuidProQuoContributionsInd00
IRS990/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990/ReconcilationRevenueExpnssAmt0317850
IRS990/RegularMonitoringEnfrcInd01
IRS990/RelatedEntityInd00
IRS990/RelatedOrganizationCtrlEntInd00
IRS990/ReportInvestmentsOtherSecInd00
IRS990/ReportLandBuildingEquipmentInd01
IRS990/ReportOtherAssetsInd01
IRS990/ReportOtherLiabilitiesInd01
IRS990/ReportProgramRelatedInvstInd00
IRS990/RtnEarnEndowmentIncmOthFndsGrp/BOYAmt0535194
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt0853044
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0Hawaii Data Collaborative was formed in June of 2020, thus tax year 2020 was a short year.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0Part III, Short Year Explanation:
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt01495268
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt01255520
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt0462250
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt03213038
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt0150000
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0150000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportTotal509Amt03363038
IRS990ScheduleA/SubstAndDsqlfyPrsnsTotGrp/TotalAmt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt01645268
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt01255520
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt0462250
IRS990ScheduleA/Total509Grp/TotalAmt03363038
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt01645268
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt01255520
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt0462250
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt03363038
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/DonatedServicesAndUseFcltsAmt067000
IRS990ScheduleD/DonatedServicesUseFcltsAmt067000
IRS990ScheduleD/ExpensesNotReportedAmt067000
IRS990ScheduleD/ExpensesNotRptFinclStmtAmt00
IRS990ScheduleD/ExpensesSubtotalAmt01327418
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt0200
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt1318891
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0Security Deposit
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1Right of Use Asset
IRS990ScheduleD/OtherLandBuildingsGrp/BookValueAmt066085
IRS990ScheduleD/OtherLandBuildingsGrp/DepreciationAmt04183
IRS990ScheduleD/OtherLandBuildingsGrp/OtherCostOrOtherBasisAmt070268
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Amt0318891
IRS990ScheduleD/OtherLiabilitiesOrgGrp/Desc0Lease Liability
IRS990ScheduleD/RevenueNotReportedAmt067000
IRS990ScheduleD/RevenueNotReportedFinclStmtAmt00
IRS990ScheduleD/RevenueSubtotalAmt01645268
IRS990ScheduleD/TotalBookValueLandBuildingsAmt066085
IRS990ScheduleD/TotalBookValueOtherAssetsAmt0319091
IRS990ScheduleD/TotalExpensesPerForm990Amt01327418
IRS990ScheduleD/TotalLiabilityAmt0318891
IRS990ScheduleD/TotalRevenuePerForm990Amt01645268
IRS990ScheduleD/TotalRevEtcAuditedFinclStmtAmt01712268
IRS990ScheduleD/TotExpnsEtcAuditedFinclStmtAmt01394418
IRS990ScheduleJ/AnyNonFixedPaymentsInd00
IRS990ScheduleJ/BoardOrCommitteeApprovalInd0X
IRS990ScheduleJ/CompBasedOnRevenueOfFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsFlngOrgInd00
IRS990ScheduleJ/CompBsdNetEarnsRltdOrgsInd00
IRS990ScheduleJ/CompBsdOnRevRelatedOrgsInd00
IRS990ScheduleJ/EquityBasedCompArrngmInd00
IRS990ScheduleJ/InitialContractExceptionInd00
IRS990/ScheduleJRequiredInd01
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BaseCompensationFilingOrgAmt0205000
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusFilingOrganizationAmount020500
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BonusRelatedOrganizationsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompensationBasedOnRltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990FilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/CompReportPrior990RltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompensationFlngOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/DeferredCompRltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/NontaxableBenefitsRltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/OtherCompensationFilingOrgAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/OtherCompensationRltdOrgsAmt00
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/PersonNm0Nick Redding
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/TitleTxt0Executive Director
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/TotalCompensationFilingOrgAmt0225500
IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/TotalCompensationRltdOrgsAmt00
IRS990ScheduleJ/SeverancePaymentInd00
IRS990ScheduleJ/SupplementalNonqualRtrPlanInd00
IRS990ScheduleJ/WrittenEmploymentContractInd0X
IRS990/ScheduleORequiredInd01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0New programs include (1) Human Services Organizations Data Capacity Support and (2) Hawai'i Community Foundation.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Programs that ceased operating in 2022 include: (1) Aloha United Way (AUW) 211 partnership and (2) Ko'olau Eviction Prevention Program.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Board meetings are documented and the meeting minutes are approved at the next board meeting. Currently there are no committees with authority to act on behalf of the governing body, thus there are no committee meetings to document. If and when committees may be formed, they will be documented in the same manner as governing body meetings.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Submitted to directors for review and comment. Any questions to be answered and the forms updated for final signature.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Hawaii Data Collaborative monitors and enforces its conflict of interest policy by annually reviewing potential conflicts with the trustees, officers, directors and key employees. The policy outlines a process by which Hawaii Data Collaborative evaluates and protects against undue influence by any person who may have a conflict of interest as well as outlines a process if there is a potential violation. The Board reviews the policy on a periodic basis.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5The process that Hawaii Data Collaborative conducts in determining compensation for officers and key employees (board members are not compensated) includes conducting a compensation benchmark study and analysis for each compensated officer and key employee. The analysis of the study is reviewed for approval of the appropriate compensation.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Hawaii Data Collaborative's governing documents, policies and financial statements are available to the public upon request.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Consulting: Program service expenses 109,840. Management and general expenses 0. Fundraising expenses 0. Total expenses 109,840. TOGS Allocated Expenses: Program service expenses 0. Management and general expenses 54,000. Fundraising expenses 0. Total expenses 54,000.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Telephone - Cellular & Data: Program service expenses 3,265. Management and general expenses 299. Fundraising expenses 0. Total expenses 3,564. License and Fees: Program service expenses 2,698. Management and general expenses 678. Fundraising expenses 0. Total expenses 3,376. Computer Hardware & Devices: Program service expenses 0. Management and general expenses 2,899. Fundraising expenses 0. Total expenses 2,899. Printing and Reproduction: Program service expenses 0. Management and general expenses 2,433. Fundraising expenses 0. Total expenses 2,433. Books, Publications & Subscriptions: Program service expenses 2,144. Management and general expenses 0. Fundraising expenses 0. Total expenses 2,144. Gifts & appreciation: Program service expenses 0. Management and general expenses 1,727. Fundraising expenses 0. Total expenses 1,727. Professional Development and Education: Program service expenses 1,035. Management and general expenses 430. Fundraising expenses 0. Total expenses 1,465. Computer Supplies and Tech: Program service expenses 0. Management and general expenses 1,177. Fundraising expenses 0. Total expenses 1,177. Staff Personal Development: Program service expenses 0. Management and general expenses 980. Fundraising expenses 0. Total expenses 980. Excise Tax: Program service expenses 908. Management and general expenses 61. Fundraising expenses 0. Total expenses 969. Bank & Broker Fees: Program service expenses 0. Management and general expenses 835. Fundraising expenses 0. Total expenses 835. Memberships & Dues: Program service expenses 500. Management and general expenses 0. Fundraising expenses 0. Total expenses 500. Miscellaneous Expenses: Program service expenses 0. Management and general expenses 287. Fundraising expenses 0. Total expenses 287. Postage and Delivery: Program service expenses 0. Management and general expenses 232. Fundraising expenses 0. Total expenses 232. Identity, Communications and PR: Program service expenses 210. Management and general expenses 0. Fundraising expenses 0. Total expenses 210. Association Memberships: Program service expenses 147. Management and general expenses 0. Fundraising expenses 0. Total expenses 147. Research Tools/Subscriptions: Program service expenses 66. Management and general expenses 0. Fundraising expenses 0. Total expenses 66.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990, Part III, line 2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990, Part III, line 3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990, Part VI, Section A, line 8b
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990, Part VI, Section B, line 11b
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990, Part VI, Section B, line 12c
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990, Part VI, Section B, line 15
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990, Part VI, Section C, line 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990, Part IX, line 11g
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990, Part IX, line 24e
IRS990/SchoolOperatingInd00
IRS990/SignificantChangeInd01
IRS990/SignificantNewProgramSrvcInd01
IRS990/StatesWhereCopyOfReturnIsFldCd0HI
IRS990/SubjectToExcsTaxNetInvstIncInd00
IRS990/SubjectToProxyTaxInd00
IRS990/SubjToTaxRmnrtnExPrchtPymtInd00
IRS990/TaxablePartyNotificationInd00
IRS990/TaxExemptBondsInd00
IRS990/TerminateOperationsInd00
IRS990/TotalAssetsBOYAmt0608871
IRS990/TotalAssetsEOYAmt01295234

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings