Civic Intelligence

Square Barn Elementary PTA C/O Mackeben Elementary School

990EZ • Fiscal year 2016 • EIN 20-3258908

Jul 01, 2015 to Jun 30, 2016 • Filed on Oct 13, 2016

800 Academic DriveAlgonquin, IL 60102

(847) 530-3268

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 2016

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2016

Net Margin

9th percentile

-43%

Higher net margin than 9% of similar nonprofits.

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

Top Officer Pay

83rd percentile

$0

Higher top officer pay than 83% of similar nonprofits.

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

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

Asset Growth

11th percentile

-41%

Faster asset growth than 11% of similar nonprofits.

2016 filings • 501(c)3 • <$500k nonprofits • Annualized from 2015 to 2016

Revenue Growth

82nd percentile

35%

Faster revenue growth than 82% of similar nonprofits.

2016 filings • 501(c)3 • <$500k nonprofits • Annualized from 2015 to 2016

Assets

Down

$31,259

Down $21,313 (-41%) from 2015

Net Assets

Down

$31,259

Down $21,313 (-41%) from 2015

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Up

$49,872

Up $12,866 (+35%) from 2015

Expenses

Up

$71,185

Up $39,738 (+126%) from 2015

Net Income

Down

-$21,313

Down $26,872 (-483%) from 2015

Historical Trend

Balance Sheet Trend

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

$60K$40K$20K$0Assets 2011: $43,412Liabilities 2011: $02011Assets 2012: $35,191Liabilities 2012: $02012Assets 2013: $29,110Net Assets 2013: $29,1102013Assets 2014: $47,013Net Assets 2014: $47,0132014Assets 2015: $52,572Net Assets 2015: $52,5722015Assets 2016: $31,259Net Assets 2016: $31,2592016Assets 2017: $27,544Net Assets 2017: $27,4692017Assets 2018: $18,050Liabilities 2018: $02018Assets 2019: $17,866Net Assets 2019: $17,8662019Assets 2020: $35,467Net Assets 2020: $35,4672020Assets 2021: $6,938Net Assets 2021: $6,9222021Assets 2022: $18,736Net Assets 2022: $18,7362022

Highlighted filing

2016

Assets$31,259
Liabilities-
Net Assets$31,259

Operations Trend

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

$100K$50K$0-$50KRevenue 2011: $39,250Expenses 2011: $31,044Net Income 2011: $8,2062011Revenue 2012: $36,559Expenses 2012: $44,780Net Income 2012: -$8,2212012Revenue 2013: $40,118Expenses 2013: $46,199Net Income 2013: -$6,0812013Revenue 2014: $43,730Expenses 2014: $25,827Net Income 2014: $17,9032014Revenue 2015: $37,006Expenses 2015: $31,447Net Income 2015: $5,5592015Revenue 2016: $49,872Expenses 2016: $71,185Net Income 2016: -$21,3132016Revenue 2017: $44,304Expenses 2017: $48,094Net Income 2017: -$3,7902017Revenue 2018: $45,753Expenses 2018: $55,247Net Income 2018: -$9,4942018Revenue 2019: $45,856Expenses 2019: $46,040Net Income 2019: -$1842019Revenue 2020: $48,189Expenses 2020: $30,588Net Income 2020: $17,6012020Revenue 2021: $1,815Expenses 2021: $30,360Net Income 2021: -$28,5452021Revenue 2022: $35,703Expenses 2022: $23,905Net Income 2022: $11,7982022

Highlighted filing

2016

Revenue$49,872
Expenses$71,185
Net Income-$21,313
Jump To
Filing Snapshot
Filing Period
Jul 1, 2015 to Jun 30, 2016
Signed
Oct 13, 2016
Return Version
2015v2.1
Gross Receipts
$92,513
Mission and Program Overview

Mission

To enhance local educational opportunities.

Program Services

DescriptionGrantsExpenses
PROVIDE FUNDS FOR SCHOOL IMPROVEMENTS. 39,591 PROVIDE FUNDS FOR FIELD TRIPS. 5,250 PROVIDE FUNDS FOR 5TH GRADE STUDENT TO ATTEND CHALLENGER LEARNING CENTER. $2,925--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
TAMMY DEESPresident-$0--
DIANE LARSONVice President-$0--
ASHLEY SEKULASecretary-$0--
LESLEY ENGLINGTreasurerPT$0--
Filing and Contact Details

Filer

Filer Name
Square Barn Elementary Pta
EIN
20-3258908
Phone
8475303268
Address
800 ACADEMIC DRIVE, Algonquin, IL 60102

Signing Officer

Name
Lesley Engling
Title
Treasurer
Phone
8475303268
Signed
2016-10-13

Preparer

Firm
H and R Block
Address
12040 PRINCETON DR, HUNTLEY, IL 60142
Preparer
Jim Graves
Phone
8476698186
Supplemental Narrative

Additional Explanations

Assemblies

6,073

Insurance

$ 382

Challenger 5TH Grade

2,925

Dare Graduation

$ 779

Environmental Education

650

Family Nights

246

Field Trips

5,250

Grant Programs

4,829

Media

131

Operating Expense

684

Reading Night K-2

425

School Improvements

39,491

Staff Appreciation

2,271

Weekly Readers

2,511

Membership Dues

1,499

Robert Crown 5TH Grade

2,190

Raw XML Appendix188 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/PersonNm0LESLEY ENGLING
IRS990EZ/BooksInCareOfDetail/PhoneNum08475303268
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0441 GLENROSE LANE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Lake in the Hills
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060156
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt052572
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt031259
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt06189
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-21313
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0750
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt052572
IRS990EZ/Form990TotalAssetsGrp/EOYAmt031259
IRS990EZ/FundraisingGrossIncomeAmt084884
IRS990EZ/GrossReceiptsAmt092513
IRS990EZ/InvestmentIncomeAmt021
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt01419
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt052572
IRS990EZ/NetAssetsOrFundBalancesEOYAmt031259
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt052572
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt031259
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0TAMMY DEES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1DIANE LARSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2ASHLEY SEKULA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3LESLEY ENGLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt070435
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO ENHANCE LOCAL EDUCATIONAL OPPORTUNITIES.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE FUNDS FOR SCHOOL IMPROVEMENTS. 39,591 PROVIDE FUNDS FOR FIELD TRIPS. 5,250 PROVIDE FUNDS FOR 5TH GRADE STUDENT TO ATTEND CHALLENGER LEARNING CENTER. $2,925
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt042641
IRS990EZ/SpecialEventsNetIncomeLossAmt042243
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0NC
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt071185
IRS990EZ/TotalRevenueAmt049872
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.SBEPTA.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt05239
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt02903
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt03285
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt02719
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt01449
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt015595
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt021
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt030
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt023
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt025
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt030
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0129
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt02369
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt01175
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt01285
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt01305
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt01331
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt07465
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearAmt084884
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus1YearAmt075276
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus2YearsAmt093931
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus3YearsAmt084579
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus4YearsAmt083604
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt0422274
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt021
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt030
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt023
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt025
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt030
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0129
IRS990ScheduleA/InvestmentIncomeCYPct00.00030
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.99970
IRS990ScheduleA/PublicSupportTotal509Amt0445334
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt092492
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt079354
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt098501
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt088603
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt086384
IRS990ScheduleA/Total509Grp/TotalAmt0445334
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt092513
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt079384
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt098524
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt088628
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt086414
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0445463
IRS990ScheduleG/CharitableDistributionRqrInd0false
IRS990ScheduleG/CntrctWith3rdPrtyForGameRevInd0false
IRS990ScheduleG/GamingInformationGrp/VolunteerLaborBingoInd0false
IRS990ScheduleG/GamingInformationGrp/VolunteerLaborOtherGamingInd0false
IRS990ScheduleG/GamingInformationGrp/VolunteerLaborPullTabsInd0false
IRS990ScheduleG/GamingWithNonmembersInd0false
IRS990ScheduleG/LicensedInd0false
IRS990ScheduleG/LicenseSuspendedEtcInd0false
IRS990ScheduleG/MemberOfOtherEntityInd0false
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt06,073
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1$ 382
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt22,925
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3$ 779
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4650
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5246
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt65,250
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt74,829
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8131
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9684
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10425
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1139,491
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt122,271
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt132,511
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt141,499
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt152,190
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0ASSEMBLIES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1INSURANCE
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2CHALLENGER 5TH GRADE
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3DARE GRADUATION
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4ENVIRONMENTAL EDUCATION
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FAMILY NIGHTS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6FIELD TRIPS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7GRANT PROGRAMS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8MEDIA
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9OPERATING EXPENSE
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc10READING NIGHT K-2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc11SCHOOL IMPROVEMENTS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc12STAFF APPRECIATION
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc13WEEKLY READERS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc14MEMBERSHIP DUES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc15ROBERT CROWN 5TH GRADE
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/PersonNm0LESLEY ENGLING
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum08475303268
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-10-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SQUARE BARN ELEMENTARY PTA
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0C/O MACKEBEN ELEMENTARY SCHOOL
ReturnHeader/Filer/BusinessNameControlTxt0SQUA
ReturnHeader/Filer/EIN0203258908
ReturnHeader/Filer/PhoneNum08475303268
ReturnHeader/Filer/USAddress/AddressLine1Txt0800 ACADEMIC DRIVE
ReturnHeader/Filer/USAddress/CityNm0Algonquin
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060102
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0H AND R BLOCK
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt012040 PRINCETON DR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0HUNTLEY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060142
ReturnHeader/PreparerPersonGrp/PhoneNum08476698186
ReturnHeader/PreparerPersonGrp/PreparationDt02016-10-20
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JIM GRAVES
ReturnHeader/ReturnTs02016-10-20T16:10:13Z
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02015-07-01
ReturnHeader/TaxPeriodEndDt02016-06-30
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings