Civic Intelligence

Square Barn Elementary PTA C/O Mackeben Elementary School

990EZ • Fiscal year 2015 • EIN 20-3258908

Jul 01, 2014 to Jun 30, 2015 • Filed on Oct 05, 2015

800 Academic DriveAlgonquin, IL 60102

(847) 659-3541

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

Up

$52,572

Up $5,559 (+12%) from 2014

Net Assets

Up

$52,572

Up $5,559 (+12%) from 2014

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

Revenue

Down

$37,006

Down $6,724 (-15%) from 2014

Expenses

Up

$31,447

Up $5,620 (+22%) from 2014

Net Income

Down

$5,559

Down $12,344 (-69%) from 2014

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

2015

Assets$52,572
Liabilities-
Net Assets$52,572

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

2015

Revenue$37,006
Expenses$31,447
Net Income$5,559
Jump To
Filing Snapshot
Filing Period
Jul 1, 2014 to Jun 30, 2015
Signed
Oct 5, 2015
Return Version
2014v5.0
Gross Receipts
$79,384
Mission and Program Overview

Mission

To enhance local educational opportunities.

Program Services

DescriptionGrantsExpenses
ALL OTHERS, INCLUDING: ASSEMBLIES, BOX TOPS, DARE GRADUATION, ENVIRONMENTAL EDUCATION, FAMILY EVENTS, GRANT PROGRAMS, READING NIGHT K-2, STAFF APPRECIATION AND WEEKLY READERS.-$11,038
PROVIDED FUNDS FOR SCHOOL IMPROVEMENT PROJECTS AT CONLEY AND MACKEBEN SCHOOLS.-$10,005
PROVIDED FUNDS FOR FIELD TRIPS FOR STUDENTS.-$6,675
PROVIDED FUNDS FOR 5TH GRADE STUDENTS TO ATTEND THE CHALLENGER LEARNING CENTER PROGRAM.-$2,540
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
SHANNON MITCHELLPresident-$0--
KATE JEDLICKAVP-Mackeben-$0--
CHRISTINE BLACKVP-Conley-$0--
DIANE LARSONTreasurerPT$0--
SARAH EMRICSONSecretary-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Fall Fundraiser$42,920$42,920$22,617$20,303
Spring Fundrais$16,570$16,570$7,689$8,881
Total Events$64,617$64,617$33,878$30,739
Filing and Contact Details

Filer

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

Signing Officer

Name
Shannon Mitchell
Title
President
Phone
8476593541
Signed
2015-10-05
Discuss with paid preparer
Yes

Preparer

Firm
Alliant Advisors Inc
Address
11608 DEAN ST SUITE 101, HUNTLEY, IL 60142
Preparer
Wade a Runge
Phone
8476691040
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses insurance 225 assemblies 2,484 box tops 81 challenger 5th grade 2,540 dare graduation 444 environmental education 325 family nights 245 filing fees 26 field trips 6,675 grant programs 1,635 media 119 operating expense 69 reading night k-2 629 school improvement prog 10,005 staff apprerciation 1,904 weekly readers 2,305 national & state dues 986 total 30,697

Form 990-ez, Part III, Line 31

All others, including: assemblies, box tops, dare graduation, environmental education, family events, grant programs, reading night k-2, staff appreciation and weekly readers.

Raw XML Appendix185 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/BOYAmt047013
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt052572
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt02903
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt05559
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0750
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt047013
IRS990EZ/Form990TotalAssetsGrp/EOYAmt052572
IRS990EZ/FundraisingGrossIncomeAmt075276
IRS990EZ/GrossReceiptsAmt079384
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt030
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt01175
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt047013
IRS990EZ/NetAssetsOrFundBalancesEOYAmt052572
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt047013
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt052572
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt42.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0SHANNON MITCHELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1KATE JEDLICKA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CHRISTINE BLACK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DIANE LARSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4SARAH EMRICSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VP-MACKEBEN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VP-CONLEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4SECRETARY
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt030697
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO ENHANCE LOCAL EDUCATIONAL OPPORTUNITIES.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDED FUNDS FOR SCHOOL IMPROVEMENT PROJECTS AT CONLEY AND MACKEBEN SCHOOLS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVIDED FUNDS FOR FIELD TRIPS FOR STUDENTS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2PROVIDED FUNDS FOR 5TH GRADE STUDENTS TO ATTEND THE CHALLENGER LEARNING CENTER PROGRAM.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt3ALL OTHERS, INCLUDING: ASSEMBLIES, BOX TOPS, DARE GRADUATION, ENVIRONMENTAL EDUCATION, FAMILY EVENTS, GRANT PROGRAMS, READING NIGHT K-2, STAFF APPRECIATION AND WEEKLY READERS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt010005
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt16675
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt22540
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt311038
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt042378
IRS990EZ/SpecialEventsNetIncomeLossAmt032898
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt031447
IRS990EZ/TotalProgramServiceExpensesAmt030258
IRS990EZ/TotalRevenueAmt037006
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.SBEPTA.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt02903
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt03285
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt02719
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt01449
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt0870
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt011226
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt030
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt023
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt025
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt030
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt029
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt0137
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt01175
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt01285
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt01305
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt01331
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt01325
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt06421
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearAmt075276
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus1YearAmt093931
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus2YearsAmt084579
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus3YearsAmt083604
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/CurrentTaxYearMinus4YearsAmt097857
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt0435247
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt030
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt023
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt025
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt030
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt029
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt0137
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/InvestmentIncomePYPct00.00000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.99970
IRS990ScheduleA/PublicSupportPY509Pct00.99970
IRS990ScheduleA/PublicSupportTotal509Amt0452894
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt079354
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt098501
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt088603
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt086384
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt0100052
IRS990ScheduleA/Total509Grp/TotalAmt0452894
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt079384
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt098524
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt088628
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt086414
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt0100081
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0453031
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt033878
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0FALL FUNDRAISER
IRS990ScheduleG/FundraisingEventInformationGrp/Event2Nm0SPRING FUNDRAIS
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt042920
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent2Amt016570
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsOtherEventsAmt05127
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt064617
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt042920
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent2Amt016570
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueOtherEventsAmt05127
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt064617
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt030739
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssOtherEventsAmt03572
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt033878
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt022617
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent2Amt07689
IRS990ScheduleG/FundraisingEventInformationGrp/OtherEventsTotalCnt01
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES INSURANCE 225 ASSEMBLIES 2,484 BOX TOPS 81 CHALLENGER 5TH GRADE 2,540 DARE GRADUATION 444 ENVIRONMENTAL EDUCATION 325 FAMILY NIGHTS 245 FILING FEES 26 FIELD TRIPS 6,675 GRANT PROGRAMS 1,635 MEDIA 119 OPERATING EXPENSE 69 READING NIGHT K-2 629 SCHOOL IMPROVEMENT PROG 10,005 STAFF APPRERCIATION 1,904 WEEKLY READERS 2,305 NATIONAL & STATE DUES 986 TOTAL 30,697
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ALL OTHERS, INCLUDING: ASSEMBLIES, BOX TOPS, DARE GRADUATION, ENVIRONMENTAL EDUCATION, FAMILY EVENTS, GRANT PROGRAMS, READING NIGHT K-2, STAFF APPRECIATION AND WEEKLY READERS.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART III, LINE 31
ReturnHeader/BuildTS02016-04-25 22:37:26Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0SHANNON MITCHELL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum08476593541
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-10-05
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SQUARE BARN ELEMENTARY PTA
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0C/O MACKEBEN ELEMENTARY SCHOOL
ReturnHeader/Filer/BusinessNameControlTxt0SQUA
ReturnHeader/Filer/EIN0203258908
ReturnHeader/Filer/PhoneNum08476593541
ReturnHeader/Filer/USAddress/AddressLine1Txt0800 ACADEMIC DRIVE
ReturnHeader/Filer/USAddress/CityNm0ALGONQUIN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060102
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0363473124
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ALLIANT ADVISORS INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt011608 DEAN ST SUITE 101
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0HUNTLEY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060142
ReturnHeader/PreparerPersonGrp/PhoneNum08476691040
ReturnHeader/PreparerPersonGrp/PreparationDt02015-10-05
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0WADE A RUNGE
ReturnHeader/ReturnTs02015-10-30T13:49:56-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02014-07-01
ReturnHeader/TaxPeriodEndDt02015-06-30
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings