accounting department amazonaws com

Report 5 Downloads 56 Views
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)