Transcription
Anclote Reserve HomeownersAssociationMonthly Financial StatementsMonth Ending:August 31, 2021Prepared by: CALM, LLC
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCBalance Sheet by ClassAs of August 31, 2021Operating FundASSETSCurrent AssetsChecking/Savings1000 · Operating Cash - BB&T10100 · Reserve Cash- BB&TReserve .76Total s Receivable1300 · Accounts Receivable10,482.800.0010,482.80Total Accounts Receivable10,482.800.0010,482.80Other Current Assets15000 · Due from Operating Fund1600 · Due from Other0.00670.35520.420.00520.42670.35Total Other Current 1,742.750.001,742.75Other Current Liabilities2100 · Due to Reserve Fund2300 · Prepaid otal Other Current 09.05Total Liabilities12,409.050.0012,409.05Equity32000 · Fund BalanceNet 1943,517.830.01-0.01-0.00Total Current AssetsTOTAL ASSETSLIABILITIES & EQUITYLiabilitiesCurrent LiabilitiesAccounts Payable2000 · Accounts PayableTotal Accounts PayableTotal Current LiabilitiesTotal EquityTOTAL LIABILITIES & EQUITYUNBALANCED CLASSESPage 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCProfit & Loss by ClassJanuary through August 2021Operating FundReserve FundTOTALIncome5000 · Maintenance Assessments5010 · Initial Assessments5020 · Quarterly Assessments5300 · Interest5301 · Interest Income Reserve5400 · Transfer In- Mailbox Reserves5500 · Transfer In - Street Reserves5600 · Transfer In - Gate Reserves5700 · Miscellaneous 81.2975.00Total 8,243.21Expense6000 · Management Fee6200 · Copy, Printing & Postage6400 · Accounting Fees / Tax Prep6700 · Misc. Administrative /Continges7000 · Streetlighting7100 · Electric Service7200 · Irrigation Water7300 · Grounds/Landscaping Maintenance7600 · Irrigation Repairs &Maintenance7800 · Gate Maintenance7900 · Access Cards8000 · Gate and Access Card Management9000 · Transfer Out - Street Reserves9100 · Transfer Out - Gate Reserves9200 · Transfer Out - Mailbox 721,307.686,652.932,281.29253.75Total 68.71Gross ProfitNet IncomePage 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCOperating FundJanuary through August 2021Jan 21Feb 21Mar 21Apr 21May 21Jun 21Jul 21Aug 21TOTALIncome5000 · Maintenance Assessments5010 · Initial Assessments5020 · Quarterly Assessments5300 · Interest5700 · Miscellaneous 60.180.00195.6114,000.0064,782.451.3775.00Total .23-7,370.7314,299.55-7,235.7114,179.93Gross ProfitExpense6000 · Management Fee6200 · Copy, Printing & Postage6400 · Accounting Fees / Tax Prep6700 · Misc. Administrative /Continges7000 · Streetlighting7100 · Electric Service7200 · Irrigation Water7300 · Grounds/Landscaping Maintenance7600 · Irrigation Repairs &Maintenance7800 · Gate Maintenance7900 · Access Cards8000 · Gate and Access Card Management9000 · Transfer Out - Street Reserves9100 · Transfer Out - Gate Reserves9200 · Transfer Out - Mailbox ReservesTotal ExpenseNet IncomePage 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCReserve FundJanuary through August 2021Jan 21Feb 21Mar 21Apr 21May 21Jun 21Jul 21Aug 21TOTALIncome5301 · Interest Income Reserve5400 · Transfer In- Mailbox Reserves5500 · Transfer In - Street Reserves5600 · Transfer In - Gate otal .652,445.14136.339,188.78Gross ProfitExpenseNet IncomePage 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCOperating Budget PerformanceAugust 2021Aug 21BudgetJan - Aug 21YTD BudgetAnnual BudgetIncome4000 · Developer Contributions5000 · Maintenance Assessments5010 · Initial Assessments5020 · Quarterly Assessments5100 · Developer Contribution5300 · Interest5301 · Interest Income Reserve5400 · Transfer In- Mailbox Reserves5500 · Transfer In - Street Reserves5600 · Transfer In - Gate Reserves5700 · Miscellaneous 00.000.00Total ost of Goods Sold50000 · Cost of Goods Sold0.000.000.000.000.00Total ,450.24135,675.36Expense6000 · Management Fee6100 · Legal Services6200 · Copy, Printing & Postage6300 · Office Supplies6400 · Accounting Fees / Tax Prep6500 · Web Site Administration6600 · Annual Corp. Report66900 · Reconciliation Discrepancies6700 · Misc. Administrative /Continges6800 · Liability & D/O Insurance6810 · Property Insurance6820 · Workers Compensation6830 · Umbrella7000 · Streetlighting7100 · Electric Service7200 · Irrigation Water7300 · Grounds/Landscaping Maintenance7500 · Landscape Replacement7600 · Irrigation Repairs &Maintenance7700 · Pressure Washing7800 · Gate Maintenance7900 · Access Cards8000 · Gate and Access Card Management8100 · Holiday Lights8200 · Misc. Grounds Exp / Contingency9000 · Transfer Out - Street Reserves9100 · Transfer Out - Gate Reserves9200 · Transfer Out - Mailbox Reserves9500 · Capital .2017,499.966,000.00666.720.00Total 24-7,235.710.0114,179.930.080.12Gross ProfitNet IncomePage 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCGeneral LedgerAs of August 31, 2021TypeDate1000 · Operating Cash - BB&TDeposit08/02/2021Bill Pmt -Check08/05/2021Bill Pmt -Check08/05/2021Bill Pmt -Check08/09/2021Deposit08/11/2021General Journal08/23/2021General Journal08/23/2021Bill Pmt -Check08/26/2021Bill Pmt -Check08/30/2021Bill Pmt -Check08/30/2021Bill Pmt Num2202212225656223ACHACHACHNameAmerican Access C.Sunrise LandcareSunrise LandcareCarr Riggs & IngramDoorKing Inc.Duke EnergyPasco County UtilitiesMemoSplitDepositGate access .Landscape M.12000 · Undep.2000 · Account.2000 · Account.2000 · Account.-SPLIT1500 · Due fro.2100 · Due to .2000 · Account.2000 · Account.2000 · Account.2000 · Account.12000 · Undep.5300 · InterestDepositDue from Res.Due form Ope.2020 Tax Ret.3106450023 .8780 Anclote .DepositInterestTotal 1000 · Operating Cash - BB&T10100 · Reserve Cash- BB&TGeneral Journal08/23/2021General Journal08/23/2021Deposit08/31/20215656Due from Res.Due from Ope.Interest21000 · Due to.15000 · Due fr.5301 · Interest .Q059712000 · Undep.12000 · Undep.12000 · Undep.-SPLIT12000 · Undep.Total 1300 · Accounts Receivable12000 · Undeposited 11/2021Payment08/31/2021Deposit08/31/2021Total 12000 · Undeposited 2DepositDepositDepositDeposit1300 · Account.1000 · Operati.1300 · Account.1300 · Account.1000 · Operati.1000 · Operati.1300 · Account.1000 · 017ARSR0021ARSR00175176 Night Star Trail5176 Night Star R00175176 Night Star Trail5176 Night Star TrailCredit209.384,543.65Total 10100 · Reserve Cash- BB&T1300 · Accounts 12100 · Inventory AssetTotal 12100 · Inventory Asset0.000.001400 · Prepaid ExpensesTotal 1400 · Prepaid Expenses0.000.00Page 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCGeneral LedgerAs of August 31, 2021TypeDate1500 · Due from Reserve FundGeneral Journal08/23/2021NumName56MemoSplitDue from Res.1000 · Operati.Total 1500 · Due from Reserve Fund15000 · Due from Operating FundGeneral Journal08/23/2021General Journal08/31/2021DebitCredit0.005655Due form Ope.Aug Reserve .10100 · Reserv.5500 · Transfer.Total 15000 · Due from Operating 670.35670.351600 · Due from OtherTotal 1600 · Due from Other0.000.001700 · Due from DeveloperTotal 1700 · Due from Developer2000 · Accounts PayableBillBillBillBillBillBillBillBillBill Pmt -CheckBill Pmt -CheckBill Pmt -CheckBill Pmt -CheckBill Pmt -CheckBill Pmt -CheckBill Pmt 0/202131064.0079 .3261 .6389 .8780 .207137377220221222223ACHACHACHDoorKing Inc.Duke EnergyDuke EnergyDuke EnergyPasco County UtilitiesCALM LLCSunrise LandcareAmerican Access C.American Access C.Sunrise LandcareSunrise LandcareCarr Riggs & IngramDoorKing Inc.Duke EnergyPasco County Utilities3106450023 .0079 Anclote .3261 Anclote .6389 Anclote .8780 Anclote .July Manage.Landscape M.Gate access .Gate access .Landscape M.2020 Tax Ret.3106450023 .8780 Anclote .7800 · Gate M.7000 · Streetlig.7100 · Electric .7000 · Streetlig.7200 · Irrigatio.6000 · Manage.7300 · Ground.8000 · Gate an.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.Total 2000 · Accounts 246.2011,753.347,713.845655Due from Ope.Aug Reserve .1000 · Operati.5500 · Transfer.Total 2100 · Due to Reserve Fund21000 · Due to Operating FundGeneral Journal08/23/2021Total 21000 · Due to Operating Fund-1,742.750.000.002050 · Accrued ExpensesTotal 2050 · Accrued Expenses2100 · Due to Reserve FundGeneral Journal08/23/2021General 88.95-1,742.7512,428.3656Due from Res.10100 · 12,428.36-1,422.750.001,422.751,422.750.000.00Page 2
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCGeneral LedgerAs of August 31, 0.002200 · Due to OtherTotal 2200 · Due to Other2300 · Prepaid ARSR01125176 Night Star TrailQ4 AssessmentQ4 AssessmentQ4 AssessmentQ4-Q1 22 Ass.Q4 AssessmentQ4 AssessmentQ4 AssessmentPrepaid Asse.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1000 · Operati.1300 · Account.Total 2300 · Prepaid .42-10,145.8824000 · Payroll LiabilitiesTotal 24000 · Payroll Liabilities0.000.0030000 · Opening Balance EquityTotal 30000 · Opening Balance Equity0.000.00-7,740.07-7,740.0732000 · Fund BalanceTotal 32000 · Fund Balance0.000.004000 · Developer ContributionsTotal 4000 · Developer Contributions-195.61-195.615000 · Maintenance AssessmentsTotal 5000 · Maintenance Assessments5010 · Initial AssessmentsInvoice08/13/2021Q05975176 Night Star TrailInitial Assess.1300 · Account.Total 5010 · Initial Assessments5020 · Quarterly AssessmentsInvoice08/13/20210.00Q05975176 Night Star TrailQuarterly Ass.1300 · Account.Total 5020 · Quarterly .000.005100 · Developer ContributionTotal 5100 · Developer Contribution5300 · InterestDepositTotal 5300 · Interest08/31/2021Interest1000 · Operati.0.000.18-1.19-1.370.18-1.37Page 3
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCGeneral LedgerAs of August 31, 2021TypeDateNumName5301 · Interest Income ReserveDeposit08/31/2021MemoInterestSplit0.0055Aug Reserve .5500 · Transfer.Total 5400 · Transfer In- Mailbox Reserves5500 · Transfer In - Street ReservesGeneral Journal08/31/20210.0055Aug Reserve .-SPLIT-Total 5500 · Transfer In - Street Reserves5600 · Transfer In - Gate ReservesGeneral Journal08/31/2021Credit10100 · Reserv.Total 5301 · Interest Income Reserve5400 · Transfer In- Mailbox ReservesGeneral Journal08/31/2021Debit0.0055Aug Reserve .5500 · Transfer.Total 5600 · Transfer In - Gate 0-75.005700 · Miscellaneous IncomeTotal 5700 · Miscellaneous Income0.000.0050000 · Cost of Goods SoldTotal 50000 · Cost of Goods Sold6000 · Management FeeBill08/01/2021Total 6000 · Management Fee6100 · Legal ServicesTotal 6100 · Legal Services6200 · Copy, Printing & PostageTotal 6200 · Copy, Printing & Postage6300 · Office SuppliesTotal 6300 · Office Supplies6400 · Accounting Fees / Tax PrepTotal 6400 · Accounting Fees / Tax PrepCALM LLCJuly Manage.2000 · 000.0055.6655.660.000.001,012.661,012.666500 · Web Site AdministrationTotal 6500 · Web Site Administration0.000.006600 · Annual Corp. ReportTotal 6600 · Annual Corp. Report0.000.0066000 · Payroll ExpensesTotal 66000 · Payroll Expenses0.000.00Page 4
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCGeneral LedgerAs of August 31, 0.0066900 · Reconciliation DiscrepanciesTotal 66900 · Reconciliation Discrepancies308.00308.006700 · Misc. Administrative /ContingesTotal 6700 · Misc. Administrative /Continges6800 · Liability & D/O InsuranceTotal 6800 · Liability & D/O Insurance0.000.006810 · Property InsuranceTotal 6810 · Property Insurance0.000.006820 · Workers CompensationTotal 6820 · Workers Compensation0.000.006830 · UmbrellaTotal 6830 · Umbrella0.000.007000 · StreetlightingBillBill08/01/202108/01/20210079 .6389 .Duke EnergyDuke Energy0079 Anclote .6389 Anclote .2000 · Account.2000 · Account.Total 7000 · Streetlighting7100 · Electric ServiceBill1,701.9008/01/20213261 .Duke Energy3261 Anclote .2000 · Account.Total 7100 · Electric Service7200 · Irrigation WaterBill08/01/2021Pasco County Utilities8780 Anclote .2000 · Account.7300 · Grounds/Landscaping MaintenanceBill08/02/20212071Total 7300 · Grounds/Landscaping Maintenance7500 · Landscape ReplacementTotal 7500 · Landscape Replacement7600 · Irrigation Repairs &MaintenanceTotal 7600 · Irrigation Repairs &Maintenance7700 · Pressure WashingTotal 7700 · Pressure WashingSunrise LandcareLandscape M.2000 · 46.20Total 7200 · Irrigation Water0.0029.1229.128780 99.920.000.00178.51178.510.000.00Page 5
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCGeneral LedgerAs of August 31, 2021TypeDate7800 · Gate MaintenanceBill08/01/2021Num31064.NameDoorKing Inc.MemoSplit3106450023 .2000 · Account.Total 7800 · Gate 50.00329.601,473.721,473.727900 · Access CardsTotal 7900 · Access Cards8000 · Gate and Access Card ManagementBill08/04/202137377American Access C.Gate access .2000 · Account.Total 8000 · Gate and Access Card 8100 · Holiday LightsTotal 8100 · Holiday Lights0.000.008200 · Misc. Grounds Exp / ContingencyTotal 8200 · Misc. Grounds Exp / Contingency0.000.009000 · Transfer Out - Street ReservesGeneral Journal08/31/202155Aug Reserve .5500 · Transfer.Total 9000 · Transfer Out - Street Reserves9100 · Transfer Out - Gate ReservesGeneral Journal08/31/202198.6355Aug Reserve .5500 · Transfer.Total 9100 · Transfer Out - Gate Reserves9200 · Transfer Out - Mailbox ReservesGeneral Journal08/31/2021Total 9200 · Transfer Out - Mailbox ReservesAug Reserve .5500 · 630.00253.759500 · Capital OutlayTotal 9500 · Capital Outlay0.000.00No accntTotal no accnt0.000.00TOTAL52,838.0652,838.060.00Page 6
Anclote Reserve HOA Prepayment Tracking SheetAccount #/Homeowmer 11ARSR0112TOTAL:PrepaymentAmount as of01/01/2021 203.25 203.25 406.50AmountApplied in Q1 209.38 (50.81) (50.81) (304.87)Prepaymentsadded in Q1 628.14 628.14 209.38 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 12,766.05PrepaymentBalance as of3/31/21 628.14 628.14 152.44 209.38 152.44 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 628.14 12,867.68AmountApplied in Q2 209.38 (209.38) (209.38) (50.81) (50.81) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (209.38) (6,173.64)AmountPrepaymentPrepayments Balance as of Applied in Q3 209.38added in Q26/30/21 418.76 (209.38) 209.38 628.14 (209.38) 101.63 (50.81) 209.38 418.76 (209.38) 101.63 (50.81) 418.76 (209.38) 418.76 418.76 (209.38) 418.76 418.76 (209.38) 418.76 418.76 (209.38) 418.76 418.76 418.76 (209.38) 418.76 418.76 (209.38) 418.76 418.76 (209.38) 418.76 (209.38) 418.76 (209.38) 418.76 (209.38) 418.76 (209.38) 418.76 (209.38) 209.38 209.38 418.76 418.76 418.76 (209.38) 418.76 418.76 418.76 (209.38) 418.76 418.76 418.76 (209.38) 418.76 418.76 (209.38) 418.76 418.76 418.76 418.76 418.76 418.76 (209.38) 418.76 (209.38) 5,862.64 12,556.68 (4,707.98)Prepaymentsadded in Q3 3.382,297.18PrepaymentBalance asof 8/31/21 209.38 418.76 50.82 209.38 50.82 209.38 209.38 418.76 209.38 628.14 209.38 418.76 418.76 209.38 209.38 418.76 209.38 209.38 209.38 209.38 418.76 418.76 209.38 418.76 418.76 418.76 209.38 628.14 418.76 418.76 418.76 412.76 10,145.88
Anclote Reserve HOA2021 Capital Reserve AllocationsQuarterly AssessmentJanuary 15,184.89February 1,256.28 March498.98April 12,277.34May 2,065.11June 4,722.57July 13,324.99August 742.30September - October-Reserve RequirementStreet ReserveGate ReserveMailbox Reserve18% 2,786.32 230.52 91.56 2,252.81 378.93 866.56 2,445.05 136.21 - - -72% 2,017.5525% 691.823% 76.95 166.9257.246.37 66.3022.732.53 1,631.24 559.35 62.22 274.3894.0910.47 627.47215.1623.93 1,770.44607.0867.53 - - -98.6333.823.76November -DecemberTotal 50,072.46 - 9,187.96 Total 6,652.92 2,281.28 253.75 9,187.96
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCReconciliation Summary1000 · Operating Cash - BB&T, Period Ending 08/31/2021Aug 31, 21Beginning BalanceCleared TransactionsChecks and Payments - 8 itemsDeposits and Credits - 5 itemsTotal Cleared leared Balance10,399.50Register Balance as of 08/31/202110,399.50Ending Balance10,399.50Page 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCReconciliation Detail1000 · Operating Cash - BB&T, Period Ending 08/31/2021TypeDateNumBeginning BalanceCleared TransactionsChecks and Payments - 8 itemsBill Pmt -Check08/05/2021221Bill Pmt -Check08/05/2021220Bill Pmt -Check08/09/2021222General Journal08/23/202156Bill Pmt -Check08/26/2021223Bill Pmt -Check08/30/2021ACHBill Pmt -Check08/30/2021ACHBill Pmt nrise LandcareAmerican Access C.Sunrise 543.65-19,638.05-19,638.05Cleared Balance-19,638.0510,399.50Register Balance as of 08/31/2021-19,638.0510,399.50Ending Balance-19,638.0510,399.50Carr Riggs & IngramDuke EnergyPasco County UtilitiesDoorKing Inc.XXXXXXXXTotal Checks and PaymentsDeposits and Credits - 5 itemsDeposit08/02/2021Deposit08/11/2021General 021Total Deposits and CreditsTotal Cleared TransactionsXXXXXPage 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCReconciliation Summary10100 · Reserve Cash- BB&T, Period Ending 08/31/2021Aug 31, 21Beginning BalanceCleared TransactionsChecks and Payments - 1 itemDeposits and Credits - 2 itemsTotal Cleared eared Balance21,444.76Register Balance as of 08/31/202121,444.76Ending Balance21,444.76Page 1
ANCLOTE RESERVE HOMEOWNERS ASSOCIATION, INCReconciliation Detail10100 · Reserve Cash- BB&T, Period Ending 08/31/2021TypeDateNumBeginning BalanceCleared TransactionsChecks and Payments - 1 itemGeneral 3Cleared Balance11,005.7321,444.76Register Balance as of 08/31/202111,005.7321,444.76Ending Balance11,005.7321,444.76XTotal Checks and PaymentsDeposits and Credits - 2 itemsGeneral Journal08/23/202156Deposit08/31/2021Total Deposits and CreditsTotal Cleared TransactionsXXPage 1
Anclote Reserve Homeowners Association Monthly Financial Statements Month Ending: August 31, 2021 Prepared by: CALM, LLC 2SHUDWLQJ )XQG5HVHUYH )XQG727 / 66(76 . Anclote Reserve HOA Prepayment Tracking Sheet Account #/ Homeowmer Name Prepayment Amount as of 01/01/2021 Amount Applied in Q1 - 209.38 Prepayments added in Q1
