200 WEST HIGHLAND HOA
ACCOUNTING
CASH FLOW STATEMENT DEPARTMENT For the Period from June 1, 2016 to June 30 2016 ________________________________________________________________________________________________ OPERATING ACCOUNT - FOUNDATION BANK BEGINNING BALANCE
$81,438.44
Prepaid Assessments Homeowner Assessments Blue Canyon Const. Yes Energy Reimb Yes Energy Reimb Total Receipts Operating Expenses Transfer to Replacement Reserve ATM/POS Transaction - Five Corners Hardware Total Disbursements
7,151.39 22,921.83 147.97 1,388.79 910.25 32,520.23 (21,858.12) (7,337.00) (54.29) (29,195.12)
ENDING BALANCE
$84,763.55
REPLACEMENT RESERVE - PUGET SOUND BANK BEGINNING BALANCE
$490,271.58
Transfer from Operating Interest Income Total Receipts Disbursements: None
0.00
Total Disbursements ENDING BALANCE
7,337.00 158.80 7,495.80
0.00 $497,767.38
___________________________________________________________________________________________________________________________ 1500 112th Avenue NE, Bellevue, WA 98004 - www.kappesmiller.com - Phone (425) 646-2776 - Fax (425) 637-8685
200 West Highland
ACCOUNTING DEPARTMENT
Balance Sheet As of June 30, 2016 ASSETS Current Assets Operating Accounts
Checking Account Cash Clearing Account Prepaid Insurance Prepaid Expenses Total Operating Accounts
84,763.55 341.24 7,622.75 1,523.42 94,250.96
Reserve Accounts
Replacement Reserve Total Reserve Accounts
497,767.38 497,767.38
Total Assets
592,018.34
LIABILITY & HOMEOWNERS EQUITY Operating Liabilities
Prepaid Assessments Total Operating Liabilities
15,342.26 15,342.26
Homeowner Equity
Excess of Rev over Exp Retained Earnings Prior Year Income / Expenses Total Homeowner Equity Total Liability & Homeowners Equity
40,705.94 537,238.91 (1,268.77) 576,676.08 592,018.34
P.O. Box 50330, Bellevue, WA 98015-0330 ● 1500 112th Avenue NE, Bellevue, WA 98004 ● www.kappesmiller.com ● Phone (425) 646-2776 ● Fax (425) 637-8685
200 West Highland
ACCOUNTING DEPARTMENT
Income and Expense Statement January 1, 2016 Through December 31, 2016 For the Month Ending June 30, 2016 Current Budget
Current Actual
Current Variance
YTD Budget
YTD Actual
YTD Variance
Operating Revenue
Homeowner Assessment
28,871
28,871
0
173,230
173,240
Transfer to Reserves
(7,337)
(7,337)
0
(44,022)
(44,022)
0
0
0
0
0
600
600
1,440
2,299
859
8,640
10,924
2,284
22,974
23,833
859
137,848
140,742
2,894
1,917
704
1,213
11,502
6,287
5,215
71
0
71
426
269
157
167
0
167
1,002
0
1,002
Moving Fee Water & Sewer Riemb. Total Operating Revenue
10
Operating Expenses Maintenance Exp.
General Repair & Maint. Electrical Repair Plumbing Repairs Cleaning Supplies Janitorial Misc. Janitorial
67
85
(18)
402
595
(193)
1,450
0
1,450
8,700
5,778
2,922
8
0
8
48
0
48 498
83
0
83
498
0
Parking/Garage - R & M
150
0
150
900
304
596
Keys & Locks
250
0
250
1,500
0
1,500
Pest Control
73
237
(164)
438
693
(255)
310
0
310
1,860
1,290
570
2,105
1,939
166
12,630
10,995
1,635
0
0
0
0
821
(821)
25
0
25
150
0
150
HVAC
1,384
1,392
(8)
8,304
8,264
40
Elevator Contract
1,200
1,297
(97)
7,200
7,782
(582)
Fire & Life Safety
383
(14)
397
2,298
1,098
1,200
42
278
(236)
252
675
(423)
0
3,000
(3,000)
0
3,000
(3,000)
22
0
22
132
0
132
9,707
8,918
789
58,242
47,851
10,391
1,752
1,573
179
10,512
10,300
212
Common Area Carpet Cleaning
Window Cleaning Landscape Contract Landscape Maintenance Security
Fitness Center Fitness Equipment - Harrington Snow Removal Total Maintenance Exp. Service/Utility Exp.
Electricity
P.O. Box 50330, Bellevue, WA 98015-0330
●
1500 112th Avenue NE, Bellevue, WA 98004
●
www.kappesmiller.com
●
Phone (425) 646-2776
●
Fax (425) 637-8685
200 West Highland
ACCOUNTING DEPARTMENT
Income and Expense Statement January 1, 2016 Through December 31, 2016 For the Month Ending June 30, 2016 Current Budget
Current Actual
Current Variance
YTD Budget
YTD Actual
YTD Variance
1,688
3,761
(2,073)
10,128
9,759
369
Trash
332
713
(381)
1,992
2,444
(452)
Gas
989
507
482
5,934
4,670
1,264
390
839
(449)
2,340
2,866
(526)
5,151
7,393
(2,242)
30,906
30,039
867
Property Manager
2,200
2,200
0
13,200
13,200
0
Medical Insurance
42
0
42
252
0
252
133
212
(79)
798
1,312
(514)
75
815
(740)
450
1,812
(1,362)
83
0
83
498
0
498
2,533
3,227
(694)
15,198
16,324
(1,126)
106
Water & Sewer - Common Area
Telephone Total Service/Utility Exp. Payroll
Payroll Taxes Benefits Temporary Labor Total Payroll Administrative Exp.
208
514
(306)
1,248
1,142
1,470
1,479
(9)
8,820
8,766
54
Postage
72
0
72
432
180
252
Legal Expense
17
1,705
(1,688)
102
3,470
(3,368)
Accounting
102
Office Expenses Management Fee
17
0
17
102
0
Travel Miles & Parking
0
0
0
0
0
0
Professiona Dues & Lic. Total Administrative Exp.
8
0
8
48
0
48
1,792
3,698
(1,906)
10,752
13,558
(2,806)
56
0
56
336
0
336
Tax & License
Sewer Assessment Charge Licenses & Permits
8
0
8
48
10
38
Insurance Expense Total Tax & License
3,767
(2,245)
6,012
22,602
22,868
(266)
3,831
(2,245)
6,076
22,986
22,878
108
23,014
20,991
2,023
138,084
130,650
7,434
(40)
2,842
2,882
(236)
10,092
10,328
7,337
7,337
0
44,022
44,022
0
Total
Operating Expenses
Operating Gain(Loss) Reserve Revenue
Major Maintenance Assess
P.O. Box 50330, Bellevue, WA 98015-0330
●
1500 112th Avenue NE, Bellevue, WA 98004
●
www.kappesmiller.com
●
Phone (425) 646-2776
●
Fax (425) 637-8685
200 West Highland
ACCOUNTING DEPARTMENT
Income and Expense Statement January 1, 2016 Through December 31, 2016 For the Month Ending June 30, 2016 Current Budget
Interest Income - Reserve Total Reserve Revenue
Current Actual
Current Variance
YTD Budget
YTD Actual
YTD Variance
0
159
159
0
941
941
7,337
7,496
159
44,022
44,963
941
0
0
0
0
14,351
(14,351)
0
0
0
0
14,351
(14,351)
7,337
7,496
159
44,022
30,612
(13,410)
7,297
10,338
3,041
43,786
40,704
(3,082)
Reserve Expenses
Major Maintenance Expense Total Reserve Expenses Reserve Gain(Loss) Total Gain(Loss)
P.O. Box 50330, Bellevue, WA 98015-0330
●
1500 112th Avenue NE, Bellevue, WA 98004
●
www.kappesmiller.com
●
Phone (425) 646-2776
●
Fax (425) 637-8685
ACCOUNTING DEPARTMENT
200 West Highland HOA AP Check Register Date Range : 6/1/2016 To 6/30/2016 For Cash Account 1
Check
Check Date
000003 000005 010015 010262 010264 010265 010266 010267 010268 010269 010270 010271
06/30/2016 06/30/2016 06/30/2016 06/01/2016 06/08/2016 06/14/2016 06/14/2016 06/14/2016 06/14/2016 06/14/2016 06/14/2016 06/14/2016
010272
06/14/2016 1RAGA
Vendor 1FOUB 1COMP 1RBOU 1KMM 1AMBE 1200R 1APFR 1ARC 1CENL 1JAMS 1OTIS 1PSE
Vendor Name
Invoice Number
Vch #
Foundation Bank CompuPay Rick Bourgoin Kappes Miller Management Ambetter - U90082588 200 West Highland Reserve Advanced Pro Fitness Repair ARC CenturyLink James L. Strichartz, PSSC OTIS Elevator Company Puget Sound Energy
00493 00494 00492 00468 00471 00359 00473 00474 00475 00476 00477 00478
Ragen & Associates
00479 00480
06.30.16 td 06.30.16 pr 06.30.16 pr 20162609 U90082588
Invoice Date
06/14/2016 06/23/2016 06/28/2016 06/28/2016 06/28/2016 06/28/2016
1SEAU 1SEAL 1ASSO 1CENL 1CINU 1COMC
010279
06/28/2016 1HARN
Discount
Net Amount
Check Amount
05171601C 1457420 2062824230614B 05312016 SS05673616 20001673553
06/30/2016 06/30/2016 06/30/2016 06/01/2016 06/08/2016 06/01/2016 06/10/2016 06/10/2016 06/10/2016 06/10/2016 06/10/2016 06/10/2016
648.05 80.36 1,763.56 1,479.07 814.51 7,337.00 197.28 388.50 411.24 1,705.00 1,297.04 507.20
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
648.05 80.36 1,763.56 1,479.07 814.51 7,337.00 197.28 388.50 411.24 1,705.00 1,297.04 507.20
648.05 80.36 1,763.56 1,479.07 814.51 7,337.00 197.28 388.50 411.24 1,705.00 1,297.04 507.20
9389 9391
06/10/2016 06/10/2016
1,889.45 49.32 1,938.77
0.00 0.00 0.00
1,889.45 49.32 1,938.77
1,938.77
Total for Check Number 010272 010273 010274 010275 010276 010277 010278
Gross Amount
City of Seattle Utilities Seattle City Light Association Reserves, LLC CenturyLink Cintas Corp. Comcast
00481 00482 00483 00484 00485 00489
2-1284444-485021 1-1284409-365836 16570-6a 2062824230614B 460614618 8498320013257146
06/10/2016 06/23/2016 06/24/2016 06/24/2016 06/24/2016 06/24/2016
2,095.70 1,573.16 650.00 427.98 84.99 81.19
0.00 0.00 0.00 0.00 0.00 0.00
2,095.70 1,573.16 650.00 427.98 84.99 81.19
2,095.70 1,573.16 650.00 427.98 84.99 81.19
Vickie Harrington
00491 00496
06282016 06282016
06/28/2016 06/30/2016
6,000.00 -6,000.00
0.00 0.00 0.00
6,000.00 -6,000.00 0.00
0.00
20.05 25.05 45.10
45.10
Total for Check Number 010279 06/24/2016 06/24/2016
0.00
010280
06/28/2016 1KMM
Kappes Miller Management
00486 00487
20162919 20162995
45.10
0.00 0.00 0.00
010281 010282
06/28/2016 1SEAU 06/28/2016 1TERM
City of Seattle Utilities Terminix Processing Center
00490 00488
2-1284444-485021 355460668
06/28/2016 06/24/2016
2,378.39 236.74
0.00 0.00
2,378.39 236.74
2,378.39 236.74
010284
06/30/2016 1HARN
Vickie Harrington
00497
06282016-2
06/30/2016
3,000.00
0.00
3,000.00
3,000.00
29,140.83
0.00
29,140.83
29,140.83
29,140.83
0.00
29,140.83
29,140.83
Total for Check Number 010280
Cash Account 1 Totals Property/Company Totals for
200 West Highland HOA
20.05 25.05
P.O. Box 50330, Bellevue, WA 98015-0330 ● 1500 112th Avenue NE, Bellevue, WA 98004 ● www.kappesmiller.com ● Phone (425) 646-2776 ● Fax (425) 637-8685
ACCOUNTING DEPARTMENT
200 West Highland HOA AP Expense Distribution For Cash Account : All From 6/1/2016 To 6/30/2016 GL Account/ Voucher 1310-0000 00359
5220-0000 00483
5240-0000 00485
5285-0000 00488
5320-0000
Vendor
Description
Invoice No.
Check No.
Amount
Account Total
Replacement Reserve 1200R - 200 West Highland Reserve
2016 Reserve Transfer
010265
$7,337.00
$7,337.00
General Repair & Maint. 1ASSO - Association Reserves, LLC
50% Deposit on Reserve Study
16570-6a
010275
$650.00
$650.00
Supplies- Wet Mop, Gray mat
460614618
010277
$84.99
$84.99
Pest Control
355460668
010282
$236.74
$236.74
Cleaning Supplies 1CINU - Cintas Corp.
Pest Control 1TERM - Terminix Processing Center
Landscape Contract
00479
1RAGA - Ragen & Associates
Plant Material, install, 6/16 Maint.
1,889.45
1RAGA - Ragen & Associates
05/09 Transplant plant material
9389 9391
010272
00480
010272
$49.32
$1,938.77
06/16 Elevtor Maint.
SS05673616
010270
$1,297.04
$1,297.04
00473
1APFR - Advanced Pro Fitness Repair
Fitness Room Equipment Repair
010266
197.28
00489
1COMC - Comcast
06/26-07/25 Cable
05171601C 8498320013257146
010278
$81.19
Purchase of Precor, Concept 2 from Owner-107
06282016
010279
6,000.00
5440-0000 00477
5460-0000
5462-0000 00491
Elevator Contract 1OTIS - OTIS Elevator Company
Fitness Center $278.47
Fitness Equipment - Harrington 1HARN - Vickie Harrington
00496
1HARN - Vickie Harrington
Credit Voucher #00491
(6,000.00)
1HARN - Vickie Harrington
Purchase of Concept2 and Precor #107
06282016 06282016-2
010279
00497
010284
$3,000.00
$3,000.00
05/03-06/01 Electric
1-1284409-365836
010274
$1,573.16
$1,573.16
00481
1SEAU - City of Seattle Utilities
4/18-05/17 Water, Sewer, Garbage
2-1284444-485021
010273
1,030.68
00481
1SEAU - City of Seattle Utilities
4/18-05/17 Water, Sewer, Garbage
2-1284444-485021
010273
708.69
00490
1SEAU - City of Seattle Utilities
05/17-06/17 Water,Sewer, Garbage
1,042.95
00490
05/17-06/17 Water,Sewer, Garbage
2-1284444-485021 2-1284444-485021
010281
1SEAU - City of Seattle Utilities
010281
$979.11
4/18-05/17 Water, Sewer, Garbage
2-1284444-485021
010273
356.33
5510-0000 00482
5520-0000
5540-0000 00481
Electricity 1SEAL - Seattle City Light
Water & Sewer - Common Area
Trash 1SEAU - City of Seattle Utilities
P.O. Box 50330, Bellevue, WA 98015-0330
●
1500 112th Avenue NE, Bellevue, WA 98004
●
www.kappesmiller.com
●
Phone (425) 646-2776
●
Fax (425) 637-8685
$3,761.43
ACCOUNTING DEPARTMENT
200 West Highland HOA AP Expense Distribution For Cash Account : All From 6/1/2016 To 6/30/2016 GL Account/ Voucher 00490
5550-0000 00478
5560-0000
Vendor
Description
1SEAU - City of Seattle Utilities
Invoice No.
Amount
Check No.
Account Total
05/17-06/17 Water,Sewer, Garbage
2-1284444-485021
010281
$356.33
$712.66
04/26-05/25 Gas
20001673553
010271
$507.20
$507.20
Gas 1PSE - Puget Sound Energy
Telephone
00475
1CENL - CenturyLink
04/29-05/29 Telephone
411.24
1CENL - CenturyLink
05/29-06/29 Telephone
2062824230614B 2062824230614B
010268
00484
010276
$427.98
$839.22
06.30.16 payroll
06.30.16 pr
010015
$2,200.00
$2,200.00
00492
1RBOU - Rick Bourgoin
06.30.16 payroll
010015
(436.44)
00493
1FOUB - Foundation Bank
06.30.16 tax deposit
06.30.16 pr 06.30.16 td
000003
$648.05
$211.61
5.16 & 6.16 Health Benefits
U90082588
010264
$814.51
$814.51
010267
388.50 20.05
5610-0000
Property Manager
00492
1RBOU - Rick Bourgoin
5630-0000
5640-0000 00471
5710-0000
Payroll Taxes
Benefits 1AMBE - Ambetter - U90082588
Office Expenses
00474
1ARC - ARC
Architectural Plans Scanned
1457420
00486
1KMM - Kappes Miller Management
Postage
20162919
010280
00487
1KMM - Kappes Miller Management
Copy & Envelopes
25.05
00494
1COMP - CompuPay
06.30.16 payroll service fee
20162995 06.30.16 pr
010280 000005
$80.36
$513.96
Management Fee - June 2016
20162609
010262
$1,479.07
$1,479.07
05/16 General- Review file & Client
05312016
010269
$1,705.00
$1,705.00
5711-0000 00468
5730-0000 00476
Management Fee 1KMM - Kappes Miller Management
Legal Expense 1JAMS - James L. Strichartz, PSSC
Distribution Total Account Summary Account 1310-0000 5220-0000 5240-0000 5285-0000 5320-0000
Account Description
Debit
Replacement Reserve General Repair & Maint. Cleaning Supplies Pest Control Landscape Contract
P.O. Box 50330, Bellevue, WA 98015-0330
●
1500 112th Avenue NE, Bellevue, WA 98004
Credit
7,337.00 650.00 84.99 236.74 1,938.77 ●
www.kappesmiller.com
●
Phone (425) 646-2776
●
Fax (425) 637-8685
$29,140.83
ACCOUNTING DEPARTMENT
200 West Highland HOA AP Expense Distribution For Cash Account : All From 6/1/2016 To 6/30/2016
Account Description
Account 5440-0000 5460-0000 5462-0000 5510-0000 5520-0000 5540-0000 5550-0000 5560-0000 5610-0000 5630-0000 5640-0000 5710-0000 5711-0000 5730-0000 0110-0000
Debit
Elevator Contract Fitness Center Fitness Equipment - Harrington Electricity Water & Sewer - Common Area Trash Gas Telephone Property Manager Payroll Taxes Benefits Office Expenses Management Fee Legal Expense Checking
1,297.04 278.47 3,000.00 1,573.16 3,761.43 712.66 507.20 839.22 2,200.00 211.61 814.51 513.96 1,479.07 1,705.00 29,140.83 29,140.83
P.O. Box 50330, Bellevue, WA 98015-0330
●
1500 112th Avenue NE, Bellevue, WA 98004
Credit
●
www.kappesmiller.com
●
29,140.83
Phone (425) 646-2776
●
Fax (425) 637-8685
200 West Highland Owners
ACCOUNTING DEPARTMENT
Aging Report (Summarized) as of 06/30/2016 Unit Type
Unit
CURR
102
Daniel, William
0.00
(1,563.74)
CURR
104
Gold, Jeffery
0.00
(273.44)
CURR
202
Slattery, Mike & Judy
0.00
(1,296.32)
CURR
203
Fer, Mehmet
0.00
(58.50)
CURR
204
Choe, Martha
0.00
(764.19)
CURR
302
Bird, Sue
0.00
(58.50)
(58.50)
CURR
303
Poole, Mike
0.00
(8,107.11)
(8,107.11)
CURR
403
Lentz, Gretchen
0.00
(1,010.29)
(900.79)
CURR
502
DeWitt, Steven P.
0.00
(1,565.58)
(1,565.58)
CURR
504
Slater, Jerry
0.00
(1,062.47)
(1,062.47)
CURR
505
Kruger, Bob
0.00
(0.04)
(0.04)
Occupant Name
Deposits Held
Property Totals
P.O. Box 50330, Bellevue, WA 98015-0330
Balance Due
0.00
1500 112th Avenue NE, Bellevue, WA 98004
(15,760.18)
1-30 Days
31-60 Days
61-90 Days
Over 90 Days
(1,563.74) (273.44) (1,296.32) (58.50) (764.19)
(7,153.13)
www.kappesmiller.com
(109.50)
(109.50)
Phone (425) 646-2776
0.00
Fax (425) 637-8685
(8,497.55)