Kuau Bayview Financial Records
1 |
Monthly Income & Expenses: 2004 | 2003 | 2002 | 2001 |
2 |
Monthly Balance Sheets: 2004 | 2003 | 2002 | 2001 |
3 |
Annual Income & Expenses: Year to Year Comparison |
4 |
Balance Sheets: Dec 31st Year to Year Comparison |
5 |
Annual Budget: 2004 |
6 |
Delinquencies: As of 5-12-04 there are two Lots whose 2004 maintenance fees are not fully paid, and a few overdue late fees. |
The Association is a non-profit corporation whose funds are kept in a Business Money Management Checking account in the Paia Bank of Hawaii. When interest rates rise enough to make it worthwhile, a portion of the reserve funds will be placed in a CD. The accounting records are maintained in QuickBooks Premier 2002 Accountant Edition. The accounting method is a modified accrual method very close to a cash method.
N.B. Negative amounts are designated with a minus sign throughout the tables.
2004 Monthly Income & Expenses (cash basis)
Entry |
Jan04 |
Feb04 |
Mar04 |
Apr04 |
May04 |
Jun04 |
Jul04 |
Aug04 |
Sep04 |
Oct04 |
Nov04 |
Dec04 |
2004 |
Maintenance Fees |
15,187.00 |
576.00 |
132.00 |
25.00 |
1536.00 |
||||||||
Startup Fees |
40.00 |
40.00 |
40.00 |
1595.00 |
|||||||||
Late Fees |
10.00 |
||||||||||||
Fines |
|||||||||||||
Bank Interest |
1.20 |
1.20 |
1.27 |
1.20 |
|||||||||
Total Income |
15,228.20 |
617.20 |
183.27 |
1596.20 |
|||||||||
Supplies & Equipment |
|||||||||||||
Postal Costs |
-4.52 |
4.52 |
|||||||||||
Copies & Faxes |
|||||||||||||
Landscaping |
350.00 |
150.00 |
205.00 |
||||||||||
Electricity |
26.04 |
26.05 |
26.05 |
26.05 |
26.05 |
||||||||
Water (irrigation) |
119.85 |
41.02 |
|||||||||||
Admin & Accounting |
250.00 |
200.00 |
|||||||||||
Insurance |
1000.00 |
1230.00 |
|||||||||||
Tax Preparation |
|||||||||||||
Corporate Filing |
7.50 |
||||||||||||
Legal Fees |
35.00 |
-40.48 |
|||||||||||
General Excise Tax |
.25 |
||||||||||||
Meeting Expenses |
5.00 |
||||||||||||
Bank Charges |
|||||||||||||
Total Expenses |
626.04 |
1181.15 |
176.05 |
1657.07 |
|||||||||
Net Profit or Loss |
14,602.16 |
-563.95 |
7.22 |
-60.87 |
2003 Monthly Income & Expenses (cash basis)
Entry |
Jan03 |
Feb03 |
Mar03 |
Apr03 |
May03 |
Jun03 |
Jul03 |
Aug03 |
Sep03 |
Oct03 |
Nov03 |
Dec03 |
2003 |
Maintenance Fees |
4,245.00 |
360.58 |
834.42 |
4,495.30 |
185.00 |
910.00 |
5,595.00 |
615.00 |
840.00 |
2,515.00 |
240.00 |
120.00 |
20,945.00 |
Startup Fees |
75.00 |
100.00 |
25.00 |
50.00 |
195.00 |
40.00 |
|
485.00 |
|||||
Late Fees |
25.00 |
60.00 |
5.00 |
30.00 |
15.00 |
10.00 |
30.00 |
25.00 |
20.00 |
45.00 |
265.00 |
||
Fines |
300.00 |
|
|
300.00 |
|||||||||
Bank Interest |
6.40 |
5.84 |
6.26 |
5.98 |
6.95 |
0.89 |
1.09 |
0.87 |
0.80 |
.91 |
.89 |
.94 |
37.82 |
Total Income |
4,276.40 |
426.42 |
845.68 |
4,530.98 |
206.95 |
985.89 |
5,696.09 |
670.87 |
890.80 |
3,035.91 |
300.89 |
165.94 |
22,032.82 |
Supplies & Equipment |
|
11.45 |
|
556.20 |
|
|
|
567.65 |
|||||
Postage |
38.97 |
-4.42 |
163.47 |
|
39.30 |
|
|
|
237.32 |
||||
Copies & Faxes |
20.25 |
150.16 |
41.55 |
7.32 |
219.28 |
||||||||
Landscaping |
350.00 |
350.00 |
350.00 |
350.00 |
|
350.00 |
350.00 |
700.00 |
350.00 |
350.00 |
350.00 |
350.00 |
4,200.00 |
Electricity |
26.03 |
26.03 |
26.03 |
26.03 |
22.56 |
41.03 |
26.03 |
26.03 |
26.03 |
26.02 |
26.03 |
297.85 |
|
Water |
101.85 |
95.10 |
79.35 |
113.10 |
124.35 |
|
122.35 |
636.10 |
|||||
Management |
520.84 |
520.84 |
520.84 |
520.84 |
|
520.84 |
|
|
598.96 |
3,203.16 |
|||
Insurance |
1,209.85 |
1,209.85 |
|||||||||||
Tax Preparation |
390.62 |
390.62 |
|||||||||||
Legal Fees |
400.00 |
3,500.00 |
-3,000.00 |
900.00 |
|||||||||
General Excise Tax |
6.06 |
17.40 |
1.26 |
-21.42 |
|
|
3.30 |
||||||
Meeting Expenses |
10.00 |
55.79 |
17.38 |
60.00 |
|
-60.00 |
|
83.17 |
|||||
Bank Charges |
15.00 |
15.00 |
|||||||||||
Total Expenses |
2,182.00 |
994.30 |
1,287.49 |
1,390.24 |
81.49 |
996.81 |
962.23 |
1,240.39 |
3,936.03 |
-2,521.04 |
316.02 |
1,097.34 |
11,963.30 |
Net Profit or Loss |
2,094.40 |
-567.88 |
-441.81 |
3,140.74 |
125.46 |
-10.92 |
4,733.86 |
-569.52 |
-3,045.23 |
5,556.95 |
-15.13 |
-931.40 |
10,069.52 |
2002 Monthly Income & Expenses
Entry |
Jan02 |
Feb02 |
Mar02 |
Apr02 |
May02 |
Jun02 |
Jul02 |
Aug02 |
Sep02 |
Oct02 |
Nov02 |
Dec02 |
2002 |
Maintenance Fees |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
6,900.00 |
6,900.00 |
27,600.00 |
||||
Late Fees |
30.00 |
60.00 |
80.00 |
75.00 |
100.00 |
90.00 |
-5.00 |
15.00 |
30.00 |
25.00 |
10.00 |
5.00 |
515.00 |
Startup Fees |
|||||||||||||
Bank Interest |
16.08 |
14.74 |
16.31 |
15.83 |
16.57 |
16.20 |
4.56 |
17.73 |
14.97 |
16.64 |
11.19 |
6.07 |
166.89 |
Fines |
|||||||||||||
Total Income |
2,346.08 |
2,374.74 |
2,396.31 |
2,390.83 |
2,416.57 |
2,406.20 |
6,899.56 |
32.73 |
44.97 |
6,941.64 |
21.19 |
11.07 |
28,281.89 |
Supplies & Equipment |
136.49 |
37.00 |
116.52 |
226.51 |
163.33 |
461.97 |
118.25 |
66.78 |
85.54 |
150.90 |
213.85 |
1,777.14 |
|
Postage |
168.20 |
||||||||||||
Copies & Faxes |
17.30 |
||||||||||||
Landscaping |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
520.00 |
350.00 |
358.30 |
350.00 |
350.00 |
6,968.30 |
Refuse Collection |
36.46 |
72.92 |
36.46 |
20.83 |
166.67 |
||||||||
Telephone |
|||||||||||||
Electricity |
26.55 |
26.55 |
26.54 |
26.54 |
26.54 |
26.54 |
53.08 |
26.54 |
26.24 |
26.04 |
26.03 |
317.19 |
|
Water |
133.35 |
70.35 |
358.35 |
299.85 |
99.60 |
101.85 |
1,063.35 |
||||||
Management |
607.00 |
607.00 |
607.00 |
607.00 |
607.00 |
854.39 |
807.27 |
494.79 |
494.79 |
520.84 |
520.84 |
520.84 |
7,248.76 |
Insurance |
285.91 |
287.67 |
124.58 |
124.58 |
124.58 |
479.48 |
213.33 |
213.33 |
213.33 |
213.33 |
204.18 |
204.18 |
3,009.58 |
Tax Preparation |
364.59 |
364.59 |
|||||||||||
Legal Fees |
-364.51 |
364.51 |
475.72 |
259.43 |
735.15 |
||||||||
General Excise Tax |
2.42 |
3.82 |
6.24 |
||||||||||
Property Tax |
29.99 |
29.99 |
|||||||||||
Meeting Expenses |
20.09 |
617.37 |
-150.00 |
487.46 |
|||||||||
Bad Debts |
410.56 |
80.00 |
490.56 |
||||||||||
Bank Charges |
286.02 |
156.38 |
77.68 |
57.57 |
5.00 |
582.65 |
|||||||
Corporate Filing |
5.00 |
5.00 |
|||||||||||
Total Expenses |
1,808.36 |
1,816.57 |
1,572.70 |
2,986.16 |
2,194.85 |
3,941.01 |
2,196.01 |
1,599.75 |
1,170.20 |
1,449.21 |
1,101.06 |
1,416.75 |
23,252.63 |
Net Profit or Loss |
537.72 |
558.17 |
823.61 |
-595.33 |
221.72 |
-1,534.81 |
4,703.55 |
-1,567.02 |
-1,125.23 |
5,492.43 |
-1,079.87 |
-1,405.68 |
5,029.26 |
2001 Monthly Income & Expenses
Entry |
Jan01 |
Feb01 |
Mar01 |
Apr01 |
May01 |
Jun01 |
Jul01 |
Aug01 |
Sep01 |
Oct01 |
Nov01 |
Dec01 |
2001 |
Maintenance Fees |
2,300.00 |
2,325.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
2,300.00 |
27,625.00 |
Late Fees |
60.00 |
50.00 |
35.00 |
40.00 |
60.00 |
50.00 |
20.06 |
60.00 |
75.00 |
95.00 |
60.00 |
90.00 |
700.06 |
Bank Interest |
33.65 |
28.24 |
31.32 |
27.59 |
28.96 |
28.38 |
26.53 |
26.78 |
25.90 |
23.21 |
19.61 |
17.60 |
317.77 |
Fines |
650.00 |
300.00 |
950.00 |
||||||||||
Total Income |
2,393.65 |
2,403.24 |
2,366.32 |
2,367.59 |
2,388.96 |
3,028.38 |
2,346.59 |
2,386.78 |
2,400.90 |
2,418.21 |
2,379.61 |
2,707.60 |
29,592.83 |
Supplies & Equipment |
169.08 |
163.31 |
36.00 |
165.87 |
196.41 |
270.38 |
102.34 |
120.84 |
36.00 |
196.10 |
20.06 |
525.94 |
2,002.33 |
Landscaping |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
720.00 |
8,640.00 |
Refuse Collection |
57.29 |
36.46 |
36.46 |
130.21 |
|||||||||
Telephone |
8.36 |
4.85 |
13.21 |
||||||||||
Electricity |
26.51 |
26.51 |
26.51 |
26.51 |
26.51 |
26.51 |
26.51 |
26.51 |
26.51 |
26.48 |
26.46 |
26.51 |
318.04 |
Water |
314.18 |
285.95 |
260.68 |
333.44 |
293.34 |
529.95 |
2,017.54 |
||||||
Management |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
590.00 |
7,080.00 |
Insurance |
112.52 |
121.55 |
121.49 |
121.49 |
121.49 |
121.49 |
121.49 |
121.49 |
121.49 |
143.42 |
126.34 |
321.75 |
1,676.01 |
Tax Preparation |
364.58 |
364.58 |
|||||||||||
Legal Fees |
2,216.42 |
2,805.70 |
85.94 |
5,108.06 |
|||||||||
General Excise Tax |
3.72 |
3.40 |
3.16 |
10.28 |
|||||||||
Property Tax |
30.00 |
30.01 |
60.01 |
||||||||||
Meeting Expenses |
57.81 |
168.05 |
382.87 |
132.81 |
66.67 |
10.00 |
44.79 |
863.00 |
|||||
Bank Charges |
35.00 |
||||||||||||
Corporate Filing |
5.00 |
5.00 |
|||||||||||
Total Expenses |
1,648.11 |
4,209.78 |
4,481.11 |
2,296.41 |
1,844.51 |
1,989.06 |
1,782.82 |
1,912.28 |
1,504.00 |
2,378.39 |
1,482.86 |
2,793.94 |
28,323.27 |
Net Profit or Loss |
745.54 |
-1,806.54 |
-2,114.79 |
71.18 |
544.45 |
1,039.32 |
563.77 |
474.50 |
896.90 |
39.82 |
896.75 |
-86.34 |
1,269.56 |
Entry |
1997 |
1998 |
1999 |
2000 |
2001 |
2002 |
2003 |
2004 |
Maintenance Fees |
11,180.00 |
22,275.00 |
26,650.00 |
27,600.00 |
27,625.00 |
27,600.00 |
22,080.00 |
17,664.00 |
Mailbox Assessment |
2,010.00 |
|||||||
Late Fees |
15.00 |
575.23 |
516.48 |
810.00 |
700.06 |
515.00 |
265.00 |
|
Startup Fees |
2,860.00 |
2,850.00 |
1,050.00 |
150.00 |
|
|
485.00 |
|
Bank Interest |
2.48 |
12.16 |
200.89 |
330.96 |
317.77 |
166.89 |
37.82 |
|
Fines |
950.00 |
300.00 |
||||||
Total Income |
14,057.48 |
27,722.39 |
28,417.37 |
28,890.96 |
29,592.83 |
28,281.89 |
22,867.82 |
|
Supplies & Equipment |
855.17 |
996.37 |
902.77 |
1,513.86 |
2,002.33 |
1,777.14 |
567.65 |
|
Postage |
237.32 |
|||||||
Copies & Faxes |
219.28 |
|||||||
Landscaping |
7,255.23 |
7,719.00 |
9,698.00 |
8,640.00 |
8,640.00 |
6,968.30 |
4,200.00 |
|
Refuse Collection |
1,027.57 |
52.08 |
182.28 |
88.54 |
130.21 |
166.67 |
|
|
Telephone |
3.00 |
12.04 |
15.22 |
13.21 |
||||
Electricity |
116.31 |
302.81 |
314.37 |
313.09 |
318.04 |
317.19 |
297.85 |
|
Water |
4,250.04 |
1,724.79 |
2,115.95 |
1,416.02 |
2,017.54 |
1,063.35 |
636.10 |
|
Management |
3,285.32 |
4,637.52 |
6,672.00 |
6,876.00 |
7,080.00 |
7,248.76 |
3,203.16 |
|
Insurance |
5,612.00 |
1,686.66 |
1,023.01 |
2,344.58 |
1,676.01 |
3,009.58 |
1,209.85 |
|
Tax Preparation |
312.50 |
312.50 |
338.54 |
364.58 |
364.59 |
390.62 |
|
|
Legal Fees |
2,317.07 |
5,108.06 |
735.15 |
900.00 |
|
|||
General Excise Tax |
0.76 |
0.32 |
5.79 |
15.65 |
10.28 |
6.24 |
3.30 |
|
Property Tax |
30.00 |
60.00 |
60.01 |
29.99 |
|
|
||
Meeting Expenses |
376.76 |
297.88 |
718.79 |
760.48 |
863.00 |
487.46 |
83.17 |
|
Bad Debts |
125.00 |
490.56 |
|
|
||||
Bank Charges |
35.00 |
582.65 |
15.00 |
|
||||
Misc Expense |
108.29 |
10.00 |
55.00 |
5.00 |
5.00 |
5.00 |
|
|
Mailboxes |
6,440.26 |
482.07 |
52.08 |
|||||
Total Expenses |
29,330.71 |
18,234.04 |
22,097.76 |
24,813.83 |
28,323.27 |
23,252.63 |
11,963.30 |
|
Net Profit or Loss |
-15,273.23 |
9,488.35 |
6,319.61 |
4,077.13 |
1,269.56 |
5,029.26 |
10,116.70 |
|