The URL can be used to link to this page

Home My WebLink About2022-COH - OHCD Independent Auditor's Report on Supplementary InformationCOUNTY OF HAWAII OFFICE OF HOUSING AND COMMUNITY DEVELOPMENT INDEPENDENT AUDITOR'S REPORT ON SUPPLEMENTARY INFORMATION Fiscal Year Ended June 30, 2022 N&KCPAs, Inc. ACCOUNTANTSICONSULTANTS 999 BISHOP STREET, SUITE 2200 I HONOLULU, HAWAII 96813 T (808) 524-2255 F (808) 523-2090 nkcpa.com COUNTY OF HAWAII OFFICE OF HOUSING AND COMMUNITY DEVELOPMENT TABLE OF CONTENTS Page INDEPENDENT AUDITOR'S REPORT ON SUPPLEMENTARY INFORMATION 3 FINANCIAL DATA SCHEDULE 4-5 N&K CPAs, Inc. ACCOUNTANTS I CONSULTANTS 999 BISHOP STREET, SUITE 2200 HONOLULU, HAWAII 96813 T (808) 524-2255 F (808) 523-2090 INDEPENDENT AUDITOR'S REPORT ON SUPPLEMENTARY INFORMATION To the Chair and Members of the County Council County of Hawaii, State of Hawaii We have audited the financial statements of the governmental activities, the business -type activities, the discretely presented component unit, each major fund, and the aggregate remaining fund information of the County of Hawaii, State of Hawaii (County), as of and for the fiscal year ended June 30, 2022, and the related notes to the basic financial statements, which collectively comprise the County's basic financial statements. We issued our report thereon dated January 27, 2023, which contained unmodified opinions on those financial statements. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the County's basic financial statements. The accompanying Financial Data Schedule (FDS) is presented for purposes of additional analysis and is not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the basic financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the FDS is fairly stated in all material respects in relation to the basic financial statements as a whole. This report is intended solely for the information and use of the County of Hawai'i Office of Housing and Community Development, the County Council of the County of Hawaii, and the U.S. Department of Housing and Urban Development, and is not intended to be and should not be used by anyone other than these specified parties. N&K CPAs, Inc. Honolulu, Hawaii June 2, 2023 County of Hawaii Office of Housing and Community Development FINANCIAL DATA SCHEDULE June 30, 2022 Line Item; Account Description; PIH Family Self -Sufficiency Program; Mainstream Vouchers Program; Section 8 Housing Choice Vouchers Program; HCC HCV CARES Act Funding; EHV Emergency Housing Voucher; Total. 111 Cash -unrestricted; $ -; $ 79,551; $ 742,984; $ -; $ 54,683; $877,218. 113 Cash -other restricted; $3,942; $88,921; $533,398; $ -; $603,745; $1,230,006. 115 Cash -restricted for payment of current liabilities; $ -; $ -; $169,139; $ -; $6,000; $175,139. 100 Total cash; $3,942; $168,472; $1,445,521; $ -; $664,428; $2,282,363. 121 Accounts receivable -PHA projects; $ -; $ -; $39,617; $ -; $ -; $39,617. 122 Accounts receivable -HUD other projects; $62,633; $ -; $ -; $ -; $ -; $62,633. 125 Accounts receivable -miscellaneous; $ -; $-; $95,682; $ -; $-; $95,682. 126.2 Allowance for doubtful accounts -other; $ -; $ -; $(91,104); $ -; $ -; $(91,104). 128 Fraud recovery; $ -; $5,666; $119,466; $ -; $ -; $125,132. 128.1 Allowance for doubtful accounts -fraud; $ -; $(5,666); $(114,685); $ -; $ -; $(120,351). 120 Total receivables, net of allowance for doubtful accounts; $62,633; $ -; $48,976; $ -; $ -; $111,609. 142 Prepaid expenses and other assets; $ -; $ -; $10,058; $ -; $ -; $10,058. 150 Total current assets; $66,575; $168,472; $1,504,555; $ -; $664,428; $2,404,030. 290 Total assets and deferred outflow of resources; $66,575; $168,472; $1,504,555; $ -; $664,428; $2,404,030. 312 Accounts payable - 90 days; $180; $6; $6,733; $ -; $6,032; $12,951. 321 Accrued wagelpayroll taxes payable; $3,234; $1,880; $63,725; $ -; $2,931; $71,770. 333 Accounts payable -other government; $ -; $16; $10,484; $ -; $51; $10,551. 342 Unearned revenue; $61,899; $ -; $ -; $ -; $186,511; $248,410. 345 Other current liabilities; $ -; $ -; $169,139; $ -; $ -; $169,139. 346 Accrued liabilities -other; $1,262; $4,889; $105,514; $ -; $9,032; $120,697. 310 Total current liabilities; $66,575; $6,791; $355,595; $ -; $204,557; $633,518. 353 Non-current liabilities -other; $ -; $ -; $163,720; $ -; $ -; $163,720. 350 Total non-current liabilities; $ -; $ -; $163,720; $ -; $ -; $163,720. 300 Total liabilities; $66,575; $6,791; $519,315; $ -; $204,557; $797,238. 509.3 Restricted fund balance; $ -; $161,681; $985,240; $ -; $459,871; $1,606,792. 512.3 Unassigned fund balance; $ -; $ -; $ -; $ -; $ -; $ -. 513 Total equity -net assets/position; $ -; $161,681; $985,240; $459,871; $1,606,792. 600 Total liabilities, deferred inflows of resources and equity -net assets/position; $ 66,575; $168,472; $1,504,555; $ -; $664,428; $2,404,030. County of Hawaii Office of Housing and Community Development FINANCIAL DATA SCHEDULE (Continued) Fiscal Year Ended June 30, 2022 Line Item; Account Description; PIH Family Self -Sufficiency Program; Mainstream Vouchers Program; Section 8 Housing Choice Vouchers Program; HCC HCV CARES Act Funding; EHV Emergency Housing Voucher; Total. 70600 HUD PHA operating grants; $ 62,053; $ 721,665; $ 24,041,512; $ 428,606; $ 533,937; $ 25,787,773. 71100 Investment income -unrestricted; $ -; $8; $491; $ -; $489; $988. 71400 Fraud recovery; $ -; $4,326; $48,457; $ -; $ -; $52,783. 71500 Other revenue; $ -; $ -; $304,768; $ -; $ -; $304,768. 70000 Total revenue; $62,053; $725,999; $24,395,228; $428,606; $534,426; $26,146,312. 91100 Administrative salaries; $ -; $7,214; $1,426,048; $ -; $32,449; $1,465,711. 91400 Advertising and marketing; $ -; $ -; $1,579; $2,096; $ -; $3,675. 91500 Employee benefit contributions -administrative; $ -; $2,971; $612,585; $ -; $12,932; $628,488. 91600 Office expenses; $ -; $396; $332,062; $3,100; $2,607; $338,165. 91000 Total operating -administrative; $ -; $10,581; $2,372,274; $5,196; $47,988; $2,436,039. 92100 Tenant services -salaries; $41,789; $ -; $ -; $103,902; $ -; $145,691. 92300 Employee benefit contributions -tenant services; $20,084; $ -; $ -; $41,209; $ -; $61,293. 92400 Tenant services -other; $180; $ -; $ -; $248,011; $6,000; $254,191. 92500 Total tenant services; $62,053; $ -; $ -; $393,122; $6,000; $461,175. 93200 Electricity; $ -; $60; $28,211; $ -; $413; $28,684. 93000 Total utilities; $ -; $60; $28,211; $ -; $413; $28,684. 96200 Other general expenses; $ -; $187; $22,425; $ -; $ -; $22,612. 96000 Total other general expenses; $ -; $187; $22,425; $ -; $22,612. 96900 Total operating expenses; $62,053; $10,828; $2,422,910; $398,318; $54,401; $2,948,510. 97000 Excess of operating revenue over operating expenses; $ -; $715,171; $21,972,318; $30,288; $480,025; $23,197,802. 97300 Housing assistance payments; $ -; $656,771; $21,487,254; $ -; $64,157; $22,208,182. 97350 HAP portability -in; $ -; $ -; $262,363; $ -; $ -; $262,363. 97600 Capital outlays -governmental funds; $ -; $ -; $2,264; $30,288; $ -; $32,552. 90000 Total expenses; $62,053; $667,599; $24,174,791; $428,606; $118,558; $25,451,607. 10000 Excess (deficiency) of total revenue over (under) total expenses; $ -; $58,400; $220,437; $ -; $415,868; $ 694,705. 11030 Beginning equity; $25,430; $103,281; $764,803; $ -; $44,003; $937,517. 11040 Prior period adjustments, equity transfers and correction; $(25,430); $ -; $ -; $ -; $ -; $(25,430). 11170 Administrative fee equity; $ -; $ -; $689,561; $ -; $ -; $ 689,561. 11180 Housing assistance payments equity; $ -; $ -; $295,679; $ -; $ -; $295,679. 11190 Unit months available; $ -; $1,044; $24,993; $ -; $1,320; $27,357. 11210 Number of units months leased; $ -; $725; $24,389; $ -; $53; $25,167.