Skip to content
Nonprofiteer
← LAULIMA DATA ALLIANCE

Form 990 for tax year 2022

Filed by LAULIMA DATA ALLIANCE.

Totals

Total revenue
$981,366
Total expenses
$898,964
Contributions and grants received
$0
Grants paid
$0
Program service revenue
$981,116
Investment income
$13
Other revenue
$237
Total assets, end of year
$806,081
Total liabilities, end of year
$188,261
Net assets or fund balances, end of year
$617,820
Program services expenses (Part IX)
$501,981
Management and general expenses
$396,983
Fundraising expenses
$0
Program service expenses (Part III)
$501,981

Program services were 55.8% of total expenses calculated — Part IX's program-services column over total expenses, both as filed.

Line items

Every line the filer filed in Parts VIII, IX and X, as filed and in filed order. Blank columns are left out, and the lines are not forced to add up to the totals above.

Revenue

Part VIII, the statement of revenue.

  • 2a · Program service revenue: MEMBERSHIP DUES

    total $893,026 · related or exempt $893,026

  • 2b · Program service revenue: ALL OTHER PROGRAMS

    total $88,090 · related or exempt $88,090

  • 3 · Investment income

    total $13 · excluded $13

  • 11a · Other revenue: OTHER INCOME

    total $237 · related or exempt $237

  • 11e · Other revenue, total

    $237

Functional expenses

Part IX, the statement of functional expenses.

  • 5 · Compensation of officers, directors and key employees

    total $293,514 · program services $29,351 · management and general $264,163

  • 7 · Other salaries and wages

    total $143,740 · program services $114,992 · management and general $28,748

  • 8 · Pension plan contributions

    total $7,924 · program services $6,339 · management and general $1,585

  • 9 · Other employee benefits

    total $21,396 · program services $17,117 · management and general $4,279

  • 10 · Payroll taxes

    total $36,959 · program services $29,567 · management and general $7,392

  • 11b · Fees: legal

    total $2,897 · management and general $2,897

  • 11c · Fees: accounting

    total $11,765 · management and general $11,765

  • 11g · Fees: other

    total $259,169 · program services $207,335 · management and general $51,834

  • 13 · Office expenses

    total $738 · program services $590 · management and general $148

  • 14 · Information technology

    total $3,576 · program services $2,861 · management and general $715

  • 16 · Occupancy

    total $14,682 · program services $11,746 · management and general $2,936

  • 17 · Travel

    total $8,020 · program services $6,416 · management and general $1,604

  • 19 · Conferences, conventions and meetings

    total $3,380 · program services $2,704 · management and general $676

  • 22 · Depreciation, depletion and amortization

    total $11,526 · program services $9,221 · management and general $2,305

  • 23 · Insurance

    total $25,998 · program services $20,798 · management and general $5,200

  • 24a · Other expenses: PROGRAMS

    total $34,404 · program services $27,523 · management and general $6,881

  • 24b · Other expenses: TAXES

    total $13,666 · program services $10,933 · management and general $2,733

  • 24c · Other expenses: AUTOMOBILE AND PARKING

    total $3,836 · program services $3,069 · management and general $767

  • 24d · Other expenses: PUBLIC RELATIONS

    total $1,750 · program services $1,400 · management and general $350

  • 24e · All other expenses

    total $24 · program services $19 · management and general $5

Balance sheet

Part X, book values.

  • 1 · Cash, non-interest-bearing

    beginning of year $487,286 · end of year $252,831

  • 2 · Savings and temporary cash investments

    end of year $3,028

  • 4 · Accounts receivable

    beginning of year $3,000 · end of year $7,500

  • 9 · Prepaid expenses and deferred charges

    beginning of year $134,407 · end of year $179,078

  • 10a · Land, buildings and equipment: cost or other basis

    $248,879

  • 10b · Land, buildings and equipment: accumulated depreciation

    $211,383

  • 10c · Land, buildings and equipment, net

    beginning of year $11,522 · end of year $37,496

  • 11 · Investments: publicly traded securities

    end of year $300,855

  • 15 · Other assets

    beginning of year $0 · end of year $25,293

  • 17 · Accounts payable and accrued expenses

    beginning of year $91,634 · end of year $110,576

  • 19 · Deferred revenue

    beginning of year $6,666 · end of year $51,666

  • 25 · Other liabilities

    beginning of year $6,580 · end of year $26,019

  • 27 · Net assets without donor restrictions

    beginning of year $531,335 · end of year $617,820

Mission and programs · 2022

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.

  • DATA ANALYTICS AND REPORTING PLATFORM.

    Expenses $501,981 · Revenue $981,353

As filed on the 2022 return.

Listed in Part VII

  • Haley Hsieh

    EXECUTIVE DIRECTOR

    Total calculated
    $272,820
    From this org
    $239,346
    From related orgs
    $0
    Other
    $33,474
    Hours/week
    40

    Schedule J breakdown matched by us

    Base
    $216,842
    Bonus
    $20,161
    Other
    $2,343
    Deferred
    $13,509
    Nontaxable benefits
    $19,965
    Filer's total
    $272,820
  • Hilton Raethel

    PRESIDENT & CEO

    Total calculated
    $582,191
    From this org
    $0
    From related orgs
    $553,007
    Other
    $29,184
    Hours/week
    3 + 37 related

    Schedule J breakdown matched by us

    Base
    $0 + $470,140 related
    Bonus
    $0 + $68,400 related
    Other
    $0 + $14,467 related
    Deferred
    $0 + $17,400 related
    Nontaxable benefits
    $0 + $11,784 related
    Filer's total
    $0 + $582,191 related
  • Greg Carlson

    SECRETARY

    Total calculated
    $0
    Hours/week
    1
  • Steve Robertson

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Gary Kajiwara

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Tiffany Lemmen

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Derek Vale

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Kenny Fink

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Mark Linscott

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Kris Wilson

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • John Chen

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Vince Hu

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • David Dobbs

    DIRECTOR

    Total calculated
    $0
    Hours/week
    1
  • Wendy Odo

    CHIEF FINANCIAL OFFICER

    Total calculated
    $299,322
    From this org
    $0
    From related orgs
    $271,876
    Other
    $27,446
    Hours/week
    4 + 36 related

    Schedule J breakdown matched by us

    Base
    $0 + $235,126 related
    Bonus
    $0 + $30,115 related
    Other
    $0 + $6,635 related
    Deferred
    $0 + $15,662 related
    Nontaxable benefits
    $0 + $11,784 related
    Filer's total
    $0 + $299,322 related
  • Tang Song

    SENIOR DATA ANALYST

    Total calculated
    $160,227
    From this org
    $133,069
    From related orgs
    $0
    Other
    $27,158
    Hours/week
    40

    Schedule J breakdown matched by us

    Base
    $129,195
    Bonus
    $1,000
    Other
    $2,874
    Deferred
    $7,250
    Nontaxable benefits
    $19,908
    Filer's total
    $160,227

Compensation is as filed in Part VII: reportable pay from this organization and from related organizations, other compensation, and hours per week. The total, marked calculated, is our sum of the three dollar columns, with a blank column counted as $0; the form itself has no total. On a Form 990-EZ the columns are Part IV's instead, and on a Form 990-PF Part VIII's — compensation, contributions to benefit plans, and expense account — and the total sums those. A Schedule J breakdown is as filed: base pay, bonus, other, deferred compensation and nontaxable benefits from this organization, with any from related organizations beside each, and the filer's own total. It is shown with the Part VII listing of the same name on the same return. The form gives no key between the two, so that pairing is ours, and is marked matched by us.

Schedule J

Answered yes

  • 3 · Independent compensation consultant
  • 3 · Compensation survey or study
  • 3 · Approval by the board or compensation committee

Answered no

  • 4a · Severance or change-of-control payment
  • 4b · Supplemental nonqualified retirement plan
  • 4c · Equity-based compensation arrangement
  • 5a · Pay contingent on this organization's revenues
  • 5b · Pay contingent on a related organization's revenues
  • 6a · Pay contingent on this organization's net earnings
  • 6b · Pay contingent on a related organization's net earnings
  • 7 · Other non-fixed payments
  • 8 · Paid under the initial-contract exception

The filer's explanations (Part III)

PART I, LINE 3
THE PRESIDENT/CEO AND CFO ARE COMPENSATED BY A RELATED ORGANIZATION. A SALARY REVIEW OF THE PRESIDENT/CEO AND CFO IS PERFORMED BIANNUALLY BY AN INDEPENDENT CONSULTANT. PERIODICALLY, THE EXECUTIVE DIRECTOR IS ALSO INCLUDED. THE LAST REVIEW WAS CONDUCTED IN SUMMER 2023 AND THE EXECUTIVE DIRECTOR WAS INCLUDED IN THE REVIEW. THE COMPENSATION COMMITTEE UTILIZES THE REVIEW AS A BASIS TO DETERMINE THE COMPENSATION FOR THE PRESIDENT/CEO. THIS IS DOCUMENTED IN A MEMORANDUM FROM THE COMPENSATION COMMITTEE CHAIR.

Part I's answers as filed. A line not listed was left unanswered; on lines 1a and 3 that means the box was not checked.

Grants on this return

No itemized grants to organizations on this return.

Related organizations on this return

Schedule R Part II: tax-exempt organizations related to the filer by control. It does not record shared board members or money.

Provenance

Return type
form_990
Tax year
2022
Filed
10 April 2024
IRS schema version
2022v5.0
Source object
202441019349300204

Check it against the return as filed: the GivingTuesday Data Lake hosts a public copy of the original XML.

The source document this was parsed from is served over the API, which is where bulk and document access live.