Champion Lakes income/expense 2005 

Jan Feb March April May June July Aug Sep Oct Nov Dec
Balance Forward $5,564.31 $12,469.28 $15,667.17 $18,269.30 $18,506.71 $18,490.54 $17,576.18 $17,292.08 $13,049.87 $11,725.04 $10,828.12 $3,284.05
 
Income  
   Dues $7,950 $3,959.00 $3,638.08 $1,664.13 $875.00 $250.00 $1,186.00 $761.25 $128.00 $61.92 $0.00 $500.00
   Late/Collection $0.00 $0.00 $280.00 $10.00 $90.00 $120.00 $80.00 $80.00 $40.00 $0.00 $0.00 $76.00
   Legal $000 $0.00 $0.00 $0.00 $0.00 $0.00 $132.50 $0.00 $132.00 $0.00 $0.00 $264.00
Total Income $7,950.00 $3,959.00 $3,918.08 $1,674.13 $965.00 $370.00 $1,398.50 $841.25 $300.00 $61.92 $0.00 $840.00
 
Expenses  
 Web Hosting $0.00 $0.00 $40.55 $0.00 $0.00 $0.00 $0.00 $0.00 $45.43 $0.00 $0.00 $0.00
   Copies $53.70 $8.78 $6.87 $49.42 $4.67 $4.81 $3.48 $3.21 $6.01 $5.16 $6.37 $64.55
   Postage $35.61 $0.00 $6.00 $44.91 $0.00 $4.65 $0.00 $0.00 $13.21 $0.00 $0.00 $0.00
   Bank Charges $0.00 $0.00 $10.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
   Statements $135.00 $0.00 $310.00   $0.00 $0.00 $68.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
 
   Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $300.00 $0.00 $0.00 $0.00
   Landscaping  $600.00 $600.00 $600.00 $600.00 $600.00 $600.00 $600.00 $600.00 $600.00 $300.00 $600.00 $600.00
   Excel Mgt $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00
 
   Repair Electric $0.00 $0.00 $141.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
   Repair Sprinklers $0.00 $0.00 $5.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,810.48 $0.00
   Flowers $0.00 $0.00 $0.00 $500.37 $0.00 $0.00 $629.12 $0.00 $0.00 $0.00 $2,552.54 $0.00
   Bi-Annual Partys $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $300.00 $0.00 $0.00 $0.00 $350.00 $0.00
   Legal $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,320.00 $132.00 $450.90 $0.00 $863.83
 
   Electric $43.72 $16.01 $18.06 $17.82 $0.00 $37.95 $0.00 $36.43 $19.44 $19.44 $0.00 $22.21
   Water $0.00 $13.32 $26.64 $64.20 $176.50 $389.15 $0.00 $522.82 $298.74 $0.00 $2,072.08 $439.69
 
   Insurance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,151.00 $0.00 $0.00 $0.00 $0.00
   Misc $0.00 $0.00 $0.00 $0.00 $50.00 $30.00 $0.00 $300.00 $60.00 $33.34 $2.60 $0.00
Total Expenses $1,018.03 $788.11 $1,315.95 $1,436.72 $981.17 $1,284.36 $1,682.60 $5,083.46 $1,624.83 $958.84 $7,544.07 $2,140.28
 
Balance $12,469.28 $15,667.17 $18,269.30 $18,506.71 $18,940.54 $17,576.18 $17,292.08 $13,049.87 $11,725.04 $10.828.12 $3,284.05 $1,983.77
A/R Balance  $13,575.00 $9616.00 $6,567.05 $5,192.92 $4,207.92 $3,216.00 $2,801.92 $2,060.67 $4,444.67 $5,313.65 $6,442.75 $6,443.75

2004 Financial Data

Jan - 

Feb - $13.32 is Jan water bill that cleared in Feb.

March -Repair electric $130 fix wire & add plug. $11.91 for light bulbs

            Statements $310  to send out 31 late letters to delinquent accounts.

            Web hosting $40.55 June-Dec 2004 $3.95/mo. $12.90/yr Championlakes.net domain name.

            Repair Sprinklers $5.81 Key to check water meter.

            Water $26.64 Feb & March water bill

            Bank Charge $5.00 bounce check & $5.11 Bank charge I'm looking into both these.

            Other income $70.00 overpaid dues, $210.00 late fees.

 

April -Other income $10 overpaid  dues.

           Copies and postage was high to pay for Annual meeting notice and late dues letters.

 

May - Other income $90 is late fees and overpaid dues.

            Misl Expense $50 is refunded overpaid dues.

 

June - $120.00 other is $30 NFS fee, $60 late fees, $30 prepaid 2006 dues.

           $37.75 electric bill was for May and June

           $30 Misc expense is refunded over paid dues to homeowners

           $68.40 was certified late dues letters to delinquent homeowners. 

July - 

Aug - $300 misc charge is a bounced check and fee. Electric and water covers July and Aug.

Sept - $60 misc charge is a bounced check and fee. A/R is increasing because of increasing legal fees and covenant fines.

Oct - $33.34 misc expense was $10 over paid dues refund, $20 bounce check fee, 3.34 taxes on proporty.

Nov - $2072.08 water bill is an error. the bill should have been $303.87 Excel is working to fix this. 

                  $149.05 Decembers bill

                  $277.035 Octobers bill

                  $13.12 Late fees

So we have over paid $16+$13.12=$29.12 late fees

Our account shows water bill withdraws of $2,511.77

Should show $758.75

Over payment of $1,753.02 + $29.12 late fees = $1,782.1

 $2,552.57 is for 3 live oak trees, 4 crepe Myrtles, flowers, rework entry flower beds

$!,810.48 is for irrigation repairs see link for details.

Dec - $64.55 copies is also for archiving 2005 records.

All HOA dues should be paid in January for the year.

Click here to see projected 2005 Budget


Current Venders/Contracts:

Excel Association management, Inc. Click Here to see contract

Contact - Jeremy Clark

Phone 972-881-7488

Address: P.O. Box 260997, Plano, TX 75206-0997

Jones Lawn Care & Landscape

Phone: 972-412-5303

Address: 8417 Victory St., Rowlett, TX 75089

B.H. Lane P.C.  CPA

Phone: 972-537-0703

Address: 720 January, Plano, TX 75025

Insurance - Davis-Dyer-Max

                  Certificate of liability insurance

 

Water - City of Rowlett

 

Electric - TXU Electric

 

Legal Affairs - Roberts, Markel, Guerry, P.C.

                    


Web Master:  Mike Kratz                                                                             Last update 19-Jul-2009