Civic Intelligence

When in Need Consulting Solutions Inc.

990EZ • Fiscal year 2021 • EIN 27-3498680

Jan 01, 2021 to Dec 31, 2021 • Filed on Apr 07, 2022

Organization Profile
1559 Weymouth Circle Suite 102Westlake, OH 44145

(216) 588-1313

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2021

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2021

Net Margin

80th percentile

38%

Higher net margin than 80% of similar nonprofits.

2021 filings • 501(c)3 • <$500k nonprofits • Source year 2021

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

2021 filings • 501(c)3 • <$500k nonprofits • Source year 2021

Asset Growth

Score unavailable

No value available

A valid growth rate could not be computed from the available filing history.

Annualized from 2020 to 2021

Revenue Growth

20th percentile

-43%

Faster revenue growth than 20% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Flat

$0

Flat from 2020

Net Assets

Up

$41,954

Up $41,954 from 2020

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin80th percentile

Revenue

Down

$111,450

Down $83,050 (-43%) from 2020

Expenses

Up

$69,496

Up $45,631 (+191%) from 2020

Net Income

Down

$41,954

Down $128,681 (-75%) from 2020

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$200K$100K$0-$100K-$200KAssets 2017: $0Net Assets 2017: $02017Assets 2018: $92,707Net Assets 2018: $92,7072018Assets 2019: $0Liabilities 2019: $191,759Net Assets 2019: -$191,7592019Assets 2020: $0Net Assets 2020: $02020Assets 2021: $0Net Assets 2021: $41,9542021Assets 2022: $0Net Assets 2022: $02022Assets 2023: $0Net Assets 2023: $02023Assets 2024: $0Net Assets 2024: $02024

Highlighted filing

2021

Assets$0
Liabilities-
Net Assets$41,954
Open 2021 Filing

Operations Trend

Revenue Growth20th percentile

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

$200K$150K$100K$50K$0Revenue 2017: $125,640Expenses 2017: $110,733Net Income 2017: $14,9072017Revenue 2018: $150,000Expenses 2018: $72,200Net Income 2018: $77,8002018Revenue 2019: $126,000Expenses 2019: $26,948Net Income 2019: $99,0522019Revenue 2020: $194,500Expenses 2020: $23,865Net Income 2020: $170,6352020Revenue 2021: $111,450Expenses 2021: $69,496Net Income 2021: $41,9542021Revenue 2022: $143,222Expenses 2022: $3,100Net Income 2022: $140,1222022Revenue 2023: $170,354Expenses 2023: $3,384Net Income 2023: $166,9702023Revenue 2024: $100,500Expenses 2024: $3,011Net Income 2024: $97,4892024

Highlighted filing

2021

Revenue$111,450
Expenses$69,496
Net Income$41,954
Open 2021 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2021 to Dec 31, 2021
Signed
Apr 7, 2022
Return Version
2021v4.1
Gross Receipts
$111,450
Mission and Program Overview

Mission

personal growth and development

Program Services

DescriptionGrantsExpenses
COMUNNITY SUPPORT PROGRAM INCLUDING TOY, COAT AND HYGIENE GIVEAWAYS-$61,485
Case management services ASSIT CLIENT WITH BILL PAYING LIVING EXPENSE-$32,105
Domestic violence support program SUPPLY SHELTER AND CLOTHING FOR HOEMLESS-$15,956
Compensation and Service Providers
Top Officer Pay77th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
CYNTHIA LIGHTNERProgram ManagerPT$0--
TRACY MILLERBoard ChairPT$0--
KRISTPHER STOVALLProgram ManagerPT$0--
KIM SPENCERTreasurerPT$0--
Filing and Contact Details

Filer

Filer Name
When In Need Consulting Solutions
EIN
27-3498680
Address
1559 WEYMOUTH CIRCLE SUITE 102, WESTLAKE, OH 44145

Signing Officer

Name
Cynthia Lightner
Title
Program manager
Phone
2168200876
Signed
2022-04-07
Discuss with paid preparer
Yes

Preparer

Firm
S Browns Enterprises 1 LLC
Address
14077 Cedar Rd suite, South Euclid, OH 44118
Preparer
Krystal Armstrong
Phone
2163821046
Raw XML Appendix124 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0CYNTHIA LIGHTNER
IRS990EZ/BooksInCareOfDetail/PhoneNum02165881313
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01559 WEYMOUTH CIR SUITE 1
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0WESTLAKE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd044145
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt0111450
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt041954
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt048907
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/Form990TotalAssetsGrp/BOYAmt00
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/GrossReceiptsAmt0111450
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesEOYAmt041954
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt00
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt00
IRS990EZ/OccupancyRentUtltsAndMaintAmt012122
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt030
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0CYNTHIA LIGHTNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1TRACY MILLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2KRISTPHER STOVALL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3KIM SPENCER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PROGRAM MANAGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1BOARD CHAIR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PROGRAM MANAGER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt03092
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0personal growth and development
IRS990EZ/PrintingPublicationsPostageAmt05375
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0COMUNNITY SUPPORT PROGRAM INCLUDING TOY, COAT AND HYGIENE GIVEAWAYS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Case management services ASSIT CLIENT WITH BILL PAYING LIVING EXPENSE
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2Domestic violence support program SUPPLY SHELTER AND CLOTHING FOR HOEMLESS
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt061485
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt132105
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt215956
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt069496
IRS990EZ/TotalProgramServiceExpensesAmt0109546
IRS990EZ/TotalRevenueAmt0111450
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0111450
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0194500
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0126000
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt0150000
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0125640
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0707590
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct01.00000
IRS990ScheduleA/PublicSupportPY170Pct01.00000
IRS990ScheduleA/PublicSupportTotal170Amt0707590
IRS990ScheduleA/SupportSumAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0111450
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0194500
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0126000
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0150000
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0125640
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0707590
IRS990ScheduleA/TotalSupportAmt0707590
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
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0CYNTHIA LIGHTNER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Program manager
ReturnHeader/BusinessOfficerGrp/PhoneNum02168200876
ReturnHeader/BusinessOfficerGrp/SignatureDt02022-04-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0When In Need Consulting Solutions
ReturnHeader/Filer/BusinessNameControlTxt0WHEN
ReturnHeader/Filer/EIN0273498680
ReturnHeader/Filer/USAddress/AddressLine1Txt01559 WEYMOUTH CIRCLE SUITE 102
ReturnHeader/Filer/USAddress/CityNm0WESTLAKE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd044145
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0273990144
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0S BROWNS ENTERPRISES 1 LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt014077 Cedar Rd suite
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0South Euclid
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd044118
ReturnHeader/PreparerPersonGrp/PhoneNum02163821046
ReturnHeader/PreparerPersonGrp/PreparationDt02022-04-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KRYSTAL ARMSTRONG
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02022-10-13T16:47:47-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0CYNTHIA
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0LIGHTNER
ReturnHeader/TaxPeriodBeginDt02021-01-01
ReturnHeader/TaxPeriodEndDt02021-12-31
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$0
Liabilities
-
Net assets
$41,954
Revenue
$111,450
Expenses
$69,496
Net income
$41,954
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.00$0.00$1.01$0.03$0.97
2023Detailed filing. Detailed filing data is available for this year.$0.00$0.00$1.70$0.03$1.67
2022Detailed filing. Detailed filing data is available for this year.$0.00$0.00$1.43$0.03$1.40
2021Detailed filing. Detailed filing data is available for this year.$0.00$0.42$1.11$0.69$0.42
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.00$0.00$1.95$0.24$1.71
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.00$1.92$1.92$1.26$0.27$0.99
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.93$0.93$1.50$0.72$0.78
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.00$0.00$1.26$1.11$0.15