DWS 2017 Financials

DWS 2017 Financials, updated 1/17/18, 3:37 AM

The very best sunsets are at Driftwood Sands overlooking the Gulf of Mexico.

Driftwood Sands is a cozy beachfront 45 unit complex in Indian Rocks Beach.

About Driftwood Sands

Prestigious Driftwood Sands (DWS) is a private beachfront complex   located in scenic Indian Rocks Beach, Florida overlooking the Gulf of Mexico and its timeless sunsets.

The spacious condominiums feature 2-4 bedrooms, with many master bedroom suites overlooking the Gulf of Mexico, large double or walk in closets, laundry room, garage private storage lockers and private balconies all with gulf views.

The complex is a well-managed community with an active Board of Directors, Building maintenance superintendent, grounds committee and Property Management Company.

Amenities include assigned covered & guest parking, dual elevators, library/meeting suite, shuffleboard, poolside restrooms, direct beach access, outdoor shower, a beachfront pool, sundeck with lounge chairs and tables, and a waterfront covered pavilion equipped with gas/charcoal barbeques, granite countertop, sink and serving areas for all your entertaining needs. The Pavilion may be partially reserved by owners for private or family gatherings.

Tag Cloud

CONTENTS
FINANCIAL
HIGHLIGHTS

BALANCE
SHEET
BANK
RECONCILIATIONS
OPERATING
STATEMENT

BANK STATEMENTS
CHECK
REGISTER
GENERAL
LEDGER
Driftwood Sands Condo Association, Inc.
2618 Gulf Boulevard
Indian Rocks Bch, FL 33785
FINANCIAL STATEMENT
7300 Park Street
Seminole, FL 33777
Telephone (727) 581-2662 Fax (727) 584-2118
Website: www.resourcepropertymgmt.com
FOR THE MONTH OF DECEMBER 2017
DELINQUENCY/ PREPAID
REPORT
RESOURCE PROPERTY MANAGEMENT
Y/ PREPAID
RESOURCE
PROPERTY MANAGEMENT
TO: Board of Directors, Driftwood Sands Condominium Association, Inc.
FROM: Bobbie Wycoff, Accounting Executive
RE: December 2017 Financial Highlights
Beginning
Ending
Balance
Balance

Operating Cash
76,452.69
$
71,946.43
$

Note: Includes BB&T money market.


Reserve Funds
423,268.70
$
433,659.34
$
Prior Month
Ending
Current Month
Ending
Delinquent Owner Fees
(25.00)
$
(25.00)
$

Prepaid Owner Fees
6,846.56
$
4,448.56
$

Actual
Monthly
Expenses
Budget
Variance
Maintenance and Repair
7,117.03
$
8,551.00
$
1,433.97
$
Utilities
8,312.20
$
6,118.00
$
(2,194.20)
$
Administrative
2,368.02
$
2,168.00
$
(200.02)
$
We have prepared your monthly financial statement and it is attached for your records. The financial
statements are prepared on a modified accrued basis. The following report highlights cash and expense
variances.
Note: Includes BOTO CD and Popular Bank money market.
Note: The delinquent balance represents all the delinquent owner fees which may include late fees
and accrued attorney collection fees.
Note: Under budget.
Note: Bi-monthly water, sewer and trash billing.
Note: Over budget due to holiday bonus, annual coupons and quarterly income tax payment.
5901 Sun Boulevard, Suite 103
St. Petersburg, FL 33715
(727) 864-0004
7300 Park Street
Seminole, FL 33777
(727) 581-2662
28100 US Hwy 19 N, Suite 205
Clearwater, FL 33761
(727) 796-5900
DRIFTWOOD SANDS CONDOMINIUM
BALANCE SHEET
December 31, 2017
Page 1
01/09/2018
ASSETS
OPERATING CASH
105-Petty Cash
300.00
109-BOTO Operating
11,338.96
110-BB&T-Money Market
60,607.47
Total Operating Cash
72,246.43
RESERVE ACCOUNT
209-BOTO Reserve
52,615.47
215-Popular Bank MM
264,845.76
225-BOTO CD;1709;1.15%;2/28/18
116,198.11
Total Reserve Account
433,659.34
OTHER ASSETS
310-Accounts Receivable
25.00
330-Deposit
100.00
335-PPD-Management Fee
630.00
Total Other Assets
755.00
TOTAL ASSETS
506,660.77
DRIFTWOOD SANDS CONDOMINIUM
BALANCE SHEET
December 31, 2017
Page 2
01/09/2018
LIABILITIES
RESERVE FUND & FUND BALANCES
510-Painting
87,264.42
520-Roofing
69,039.32
530-Paving
11,245.54
551-Balcony/Landings
1,248.67
552-Gazebo/Deck
3,062.27
560-Seawall
11,338.33
564-Elevator
115,798.05
565-Generator
868.01
570-Pool/Pool Heater
26,669.40
575-Hazard Insurance
16,727.58
576-Flood Insurance
3,710.04
587-Entry Doors
7,586.07
590-Deferred Maintenance
67,658.63
595-Unallocated Interest
11,443.01
Total Reserve Fund
433,659.34
OTHER LIABILITIES
620-Prepaid Fees
4,448.56
Total Other Liabilities
4,448.56
FUND BALANCES
900-Prior Years Fund Balance
70,613.95
910-Current Year Fund Balance
(2,061.08)
Total Fund Balances
68,552.87
TOTAL RES. FUND & FUND BAL.
506,660.77
Actual
Budget
Actual
Budget
Variance
Variance
YEAR TO DATE
BUDGET COMPARATIVE REPORT
DRIFTWOOD SANDS
CONDOMINIUM
01/09/2018
Page 1
For The Twelve Month Period Ended December 31,2017
ONE MONTH
17 Budget
INCOME
25,458.00
25,463.00
305,496.00
305,512.00
305,512.00
1010-Maintenance Fees
(5.00)
(16.00)
0.00
0.00
125.00
0.00
0.00
1040-Miscellaneous
0.00
125.00
0.00
25.00
400.00
300.00
300.00
1045-Kayak Storage
(25.00)
100.00
375.00
257.00
3,325.00
3,150.00
3,150.00
1050-Application fee
118.00
175.00
5.74
0.00
78.30
0.00
0.00
1800-Operating Interest
5.74
78.30
TOTAL OPERATING INCOME
$ 308,962.00
$ 308,962.00
$ 309,424.30
$ 25,745.00
$ 25,838.74
$ 93.74
$ 462.30
OTHER INCOME
1,250.00
1,250.00
15,000.00
15,000.00
15,000.00
1910-Prior Year Surplus
0.00
0.00
240.89
0.00
2,939.34
0.00
0.00
1995-Reserve Interest
240.89
2,939.34
TOTAL OTHER INCOME
$ 15,000.00
$ 15,000.00
$ 17,939.34
$ 1,250.00
$ 1,490.89
$ 240.89
$ 2,939.34
TOTAL INCOME
$ 323,962.00
$ 323,962.00
$ 327,363.64
$ 26,995.00
$ 27,329.63
$ 334.63
$ 3,401.64
EXPENSES & RESERVE FUNDING
MAINTENANCE & REPAIR
86.87
250.00
3,855.85
3,000.00
3,000.00
2020-Pool/Pool Heater
163.13
(855.85)
0.00
500.00
8,074.21
6,000.00
6,000.00
2040-Building Repair
500.00
(2,074.21)
470.45
663.00
6,721.68
8,000.00
8,000.00
2050-Building Supply
192.55
1,278.32
4,181.76
4,750.00
55,671.32
57,000.00
57,000.00
2055-RPM Dedicated Maintenance
568.24
1,328.68
42.27
513.00
4,569.72
6,200.00
6,200.00
2060-Elevator
470.73
1,630.28
536.16
587.00
5,305.61
7,000.00
7,000.00
2071-Grounds-Maintenance
50.84
1,694.39
1,676.00
750.00
16,797.94
9,000.00
9,000.00
2078-Fire Alarm
(926.00)
(7,797.94)
123.52
538.00
5,935.22
6,500.00
6,500.00
2080-Exterminating
414.48
564.78
TOTAL MAINTENANCE & REPAIR
$ 102,700.00
$ 102,700.00
$ 106,931.55
$ 8,551.00
$ 7,117.03
$ 1,433.97
$(4,231.55)
UTILITIES
610.38
713.00
8,120.36
8,600.00
8,600.00
4010-Electric
102.62
479.64
1,139.08
812.00
8,861.08
9,700.00
9,700.00
4020-Water
(327.08)
838.92
938.56
350.00
5,671.52
4,200.00
4,200.00
4025-Gas
(588.56)
(1,471.52)
2,235.67
1,337.00
15,410.35
16,000.00
16,000.00
4030-Sewer
(898.67)
589.65
1,242.88
656.00
7,457.28
7,850.00
7,850.00
4040-Trash
(586.88)
392.72
413.73
500.00
5,391.80
6,000.00
6,000.00
4050-Telephone
86.27
608.20
1,731.90
1,750.00
20,803.88
21,000.00
21,000.00
4070-Cable TV
18.10
196.12
TOTAL UTILITIES
$ 73,350.00
$ 73,350.00
$ 71,716.27
$ 6,118.00
$ 8,312.20
$(2,194.20)
$ 1,633.73
ADMINISTRATIVE
942.83
942.00
11,313.96
11,315.00
11,315.00
5010-Management Fee
(0.83)
1.04
1,073.19
212.00
3,000.42
2,500.00
2,500.00
5011-Office
(861.19)
(500.42)
0.00
19.00
241.25
250.00
250.00
5015-Division Fees/Corp Fee
19.00
8.75
0.00
25.00
150.00
300.00
300.00
5016-License & Fees
25.00
150.00
0.00
57.00
0.00
750.00
750.00
5020-Rental Application
57.00
750.00
146.00
663.00
10,201.93
8,000.00
8,000.00
5030-Professional Fee
517.00
(2,201.93)
200.00
87.00
1,061.00
1,000.00
1,000.00
5036-IRS Taxes & Tax Prep
(113.00)
(61.00)
6.00
163.00
72.00
2,000.00
2,000.00
5056-RPM Dedicated Insurance
157.00
1,928.00
TOTAL ADMINISTRATIVE
$ 26,115.00
$ 26,115.00
$ 26,040.56
$ 2,168.00
$ 2,368.02
$(200.02)
$ 74.44
TOTAL OPERATING EXPENSES
$ 202,165.00
$ 202,165.00
$ 204,688.38
$ 16,837.00
$ 17,797.25
$(960.25)
$(2,523.38)
Actual
Budget
Actual
Budget
Variance
Variance
YEAR TO DATE
BUDGET COMPARATIVE REPORT
DRIFTWOOD SANDS
CONDOMINIUM
01/09/2018
Page 2
For The Twelve Month Period Ended December 31,2017
ONE MONTH
17 Budget
RESERVES
459.00
459.00
5,508.00
5,508.00
5,508.00
9010-Painting
0.00
0.00
713.50
708.00
8,562.00
8,562.00
8,562.00
9020-Roofing
(5.50)
0.00
19.42
24.00
233.04
233.00
233.00
9030-Paving
4.58
(0.04)
66.83
65.00
801.96
802.00
802.00
9051-Balcony/Landings
(1.83)
0.04
435.50
430.00
5,226.00
5,226.00
5,226.00
9052-Gazebo/Deck
(5.50)
0.00
112.25
115.00
1,347.00
1,347.00
1,347.00
9060-Seawall
2.75
0.00
4,009.83
4,008.00
48,117.96
48,118.00
48,118.00
9064-Elevator
(1.83)
0.04
197.67
194.00
2,372.04
2,372.00
2,372.00
9065-Generator
(3.67)
(0.04)
197.92
197.00
2,375.04
2,375.00
2,375.00
9070-Pool/Pool Heater
(0.92)
(0.04)
3,075.17
3,077.00
36,902.04
36,902.00
36,902.00
9075-Hazard Insurance
1.83
(0.04)
322.92
322.00
3,875.04
3,875.00
3,875.00
9076-Flood Insurance
(0.92)
(0.04)
85.83
84.00
1,029.96
1,030.00
1,030.00
9087-Entry Doors
(1.83)
0.04
453.91
453.00
5,446.92
5,447.00
5,447.00
9090-Deferred Maintenance
(0.91)
0.08
240.89
0.00
2,939.34
0.00
0.00
9095-Reserve Interest
(240.89)
(2,939.34)
TOTAL RESERVES
$ 121,797.00
$ 121,797.00
$ 124,736.34
$ 10,136.00
$ 10,390.64
$(254.64)
$(2,939.34)
MISCELLANEOUS DISBURSEMENTS
TOTAL MISC DISBURSEMENTS
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
TOTAL EXPENSES/RESERVE FUNDING
$ 323,962.00
$ 323,962.00
$ 329,424.72
$ 26,973.00
$ 28,187.89
$(1,214.89)
$(5,462.72)
NET(INCOME LESS EXPENSES)
$ 0.00
$ 0.00
$(2,061.08)
$ 22.00
$(858.26)
$(880.26)
$(2,061.08)
RESERVE FUNDS
TRANSFERED FROM RESERVE
0.00
0.00
3,515.50
0.00
0.00
21052-Rsv Trans-Gazebo/Deck
0.00
3,515.50
0.00
0.00
11,684.70
0.00
0.00
21065-Rsv Trans-Generator
0.00
11,684.70
0.00
0.00
35,082.58
0.00
0.00
21075-Rsv Trans-Hazard Ins
0.00
35,082.58
0.00
0.00
10,165.00
0.00
0.00
21076-Rsv Trans-Flood Ins
0.00
10,165.00
0.00
0.00
8,600.00
0.00
0.00
21090-Rsv Trans-Deferred Maint
0.00
8,600.00
TOTAL RESERVE TRANSFERS
$ 0.00
$ 0.00
$ 69,047.78
$ 0.00
$ 0.00
$ 0.00
$ 69,047.78
DISBURSED FROM OPERATING
0.00
0.00
3,515.50
0.00
0.00
25052-Rsv Disb.-Gazebo/Deck
0.00
(3,515.50)
0.00
0.00
11,684.70
0.00
0.00
25065-Rsv Disb.-Generator
0.00
(11,684.70)
0.00
0.00
35,082.58
0.00
0.00
25075-Rsv Disb.-Hazard Ins
0.00
(35,082.58)
0.00
0.00
10,165.00
0.00
0.00
25076-Rsv Disb.-Flood Ins
0.00
(10,165.00)
0.00
0.00
8,600.00
0.00
0.00
25090-Rsv Disb.-Deferred Maint
0.00
(8,600.00)
TOTAL RESERVE DISBURSEMENTS
$ 0.00
$ 0.00
$ 69,047.78
$ 0.00
$ 0.00
$ 0.00
$(69,047.78)
NET RESERVE TRANSFERS & DISB.
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
$ 0.00
NET INCREASE (DECREASE)
$ 0.00
$ 0.00
$(2,061.08)
$ 22.00
$(858.26)
$(880.26)
$(2,061.08)
Check
Number
Vendor
Number
Vendor Name
Invoice
Amount
Date
Paid
01/04/2018
1
DRIFTWOOD SANDS
CONDOMINIUM
ACCOUNTS PAYABLE CHECK REGISTER
#
Inv
For December 01,2017 to December 31, 2017
Invoice #
GL
Code
5520
12/12/2017
Resource Management
1
1
253.19
office charges
#158
5011
253.19
5521
12/12/2017
Florida Chemical
35
1
86.87
118503
#433/Chemicals
2020
86.87
5522
12/12/2017
Orkin Pest Control
41
1
123.52
163576117
Acct# 336762
2080
123.52
5523
12/12/2017
Jeffrey Tomes
7211
1
146.00
reimb-website domain
5030
146.00
5524
12/19/2017
Home Depot Credit Services
34
2
792.11
12/05/17
6035 3225 0413 1859
2050
470.45
12/05/17
6035 3225 0413 1859
2071
321.66
5525
12/19/2017
SimplexGrinnell
451
1
898.00
79840683
Contract#694527
2078
898.00
5526
12/19/2017
Marshall Pest Control, Inc.
1432
1
214.50
11/30/17
Pest Control
2071
214.50
5527
12/19/2017
Arnold Kraemer
7258
1
550.00
Happy Holidays
5011
550.00
5528
12/19/2017
AT&T Mobility
9215
1
93.28
12/22/17
Acct#995131801
4050
93.28
5529
12/19/2017
EM ENGINEERING, INC
13108
1
42.27
190112117
Elevator monitoring
2060
42.27
5530
12/26/2017
Tyco Integrated Security LLC
78
2
0.00
84350946
Cust#292-15257393
2078
778.00
void
2078
-778.00
5531
12/26/2017
SimplexGrinnell
451
1
778.00
84350946
Contract# 292-15257393
2078
778.00
12 Check Total
14
1099 Amount 0.00
3,977.74
Name
Balance
01/09/2018
DRIFTWOOD SANDS
CONDOMINIUM
DELINQUENCY AND PREPAID REPORT
Note
For December 31,2017
Current
30 Days
60 Days
90 Days
Unit
Page 1
Delinquent
25.00
SSI Properties, Inc
25.00
201
Total Delinquents
0.00
25.00
0.00
25.00
0.00
Prepaid
-472.30
Anthony & Kristin Degina
-472.30
101
-1,556.00
D. & D. Brenton, M. Brenton
-1,556.00
104
-543.00
Mr. & Mrs. Juan Ling
-543.00
202
-512.00
Christopher & Amy Ingram
-512.00
204
-10.64
Mr & Mrs James Martinson
-10.64
304
-493.66
Mr. & Mrs. Carl A. Goldman
-493.66
305
ACH
-197.60
Mr. & Mrs. Ralph Montgomery
-197.60
309
-25.00
M2J Driftwood LLC
-25.00
501
-4.35
Ronald & Barbara Turner
-4.35
506
ACH
-499.01
Michael & Leigh Marks
-499.01
507
-35.00
Kevin & Amy Edmonson
-35.00
508
-100.00
John & Leslie Berlin
-100.00
509
Total Prepaids
-3,870.56
-4,448.56
-578.00
0.00
0.00
-3,870.56
-4,423.56
Totals
-578.00
25.00
0.00
Monthly Bank Reconciliation Report
For the Period 12/1/2017 to 12/31/2017
Client
Page 1
1/9/2018
158
DRIFTWOOD SANDS CONDOMINIUM
215-Popular Bank MM
Account
Balance Shown on this Statement
$164,845.76
6808423492
Outstanding Deposits
12/31/2017
Transfr from Boto
100,000.00
Total Outstanding Deposits
100,000.00
** No Outstanding Checks **
$264,845.76
Current Balance
Matures on 2/28/2018
225-BOTO CD
Rate: 1.15%
Account
Balance Shown on this Statement
$116,198.11
6901481709
** No Outstanding Checks **
** No Outstanding Deposits **
$116,198.11
Current Balance
109-BOTO Operating Account
Account
Balance Shown on this Statement
$12,575.23
8100000926
Outstanding Checks
5523 12/12/2017
Jeffrey Tomes
146.00
5529 12/19/2017
EM ENGINEERING, INC
42.27
5531 12/26/2017
SimplexGrinnell
778.00
12/31/2017
Annual Coupons
270.00
Total Outstanding Checks
1,236.27
** No Outstanding Deposits **
$11,338.96
Current Balance
Monthly Bank Reconciliation Report
For the Period 12/1/2017 to 12/31/2017
Client
Page 2
1/9/2018
158
DRIFTWOOD SANDS CONDOMINIUM
209-BOTO Reserve Account
Account
Balance Shown on this Statement
$152,615.47
8100000942
Outstanding Checks
242 12/31/2017
Transfer to Popular
100,000.00
Total Outstanding Checks
100,000.00
** No Outstanding Deposits **
$52,615.47
Current Balance
110-BB&T Savings
Account
Balance Shown on this Statement
$60,607.47
1100003555281
** No Outstanding Checks **
** No Outstanding Deposits **
$60,607.47
Current Balance
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 1
Check #
105-Petty Cash
Opening Balance
300.00
105
Total
0.00
0.00
Ending Balance
300.00
109-BOTO Operating
Opening Balance
15,850.20
109
Check Register Distributn
A/P
1
12/12/2017
609.58
Check Register Distributn
A/P
1
12/19/2017
2,590.16
Check Register Distributn
A/P
1
12/26/2017
778.00
Resource Mgmt
A/P
2
12/31/2017
5,448.83
1
Monthly Transfers
RES
3
12/31/2017
10,149.75
1
Checkbook Interface
CBK
4
12/31/2017
7,994.92
Owner Receivables
CM
5
12/31/2017
23,060.00
Total
27,571.24
23,060.00
Net Change
(4,511.24)
Ending Balance
11,338.96
110-BB&T-Money Market
Opening Balance
60,602.49
110
BB&T Interest
RES
3
12/31/2017
4.98
Total
0.00
4.98
Net Change
4.98
Ending Balance
60,607.47
209-BOTO Reserve
Opening Balance
142,415.52
209
Monthly Funding
RES
3
12/31/2017
10,149.75
1
Reserve Interest
RES
3
12/31/2017
50.20
Transfer to Popular
RES
3
12/31/2017
100,000.00
Total
100,000.00
10,199.95
Net Change
(89,800.05)
Ending Balance
52,615.47
215-Popular Bank MM
Opening Balance
164,763.84
215
Popular Interes
RES
3
12/31/2017
81.92
Transfer to Popular
RES
3
12/31/2017
100,000.00
Total
0.00
100,081.92
Net Change
100,081.92
Ending Balance
264,845.76
225-BOTO CD;1709;1.15%;2/
Opening Balance
116,089.34
225
CD Interest
RES
3
12/31/2017
108.77
Total
0.00
108.77
Net Change
108.77
Ending Balance
116,198.11
310-Accounts Receivable
Opening Balance
25.00
310
Owner Receivables
CM
5
12/31/2017
25.00
Owner Receivables
CM
5
12/31/2017
25.00
Total
25.00
25.00
Net Change
0.00
Ending Balance
25.00
330-Deposit
Opening Balance
100.00
330
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 2
Check #
Total
0.00
0.00
Ending Balance
100.00
335-PPD-Management Fee
Opening Balance
630.00
335
Total
0.00
0.00
Ending Balance
630.00
510-Painting
Opening Balance
(86,805.42)
510
Monthly Transfer
RES
3
12/31/2017
459.00
2
Total
459.00
0.00
Net Change
(459.00)
Ending Balance
(87,264.42)
520-Roofing
Opening Balance
(68,325.82)
520
Monthly Transfer
RES
3
12/31/2017
713.50
2
Total
713.50
0.00
Net Change
(713.50)
Ending Balance
(69,039.32)
530-Paving
Opening Balance
(11,226.12)
530
Monthly funding
RES
3
12/31/2017
19.42
2
Total
19.42
0.00
Net Change
(19.42)
Ending Balance
(11,245.54)
551-Balcony/Landings
Opening Balance
(1,181.84)
551
Monthly funding
RES
3
12/31/2017
66.83
2
Total
66.83
0.00
Net Change
(66.83)
Ending Balance
(1,248.67)
552-Gazebo/Deck
Opening Balance
(2,626.77)
552
Monthly funding
RES
3
12/31/2017
435.50
2
Total
435.50
0.00
Net Change
(435.50)
Ending Balance
(3,062.27)
560-Seawall
Opening Balance
(11,226.08)
560
Monthly funding
RES
3
12/31/2017
112.25
2
Total
112.25
0.00
Net Change
(112.25)
Ending Balance
(11,338.33)
564-Elevator
Opening Balance
(111,788.22)
564
Monthly funding
RES
3
12/31/2017
4,009.83
2
Total
4,009.83
0.00
Net Change
(4,009.83)
Ending Balance
(115,798.05)
565-Generator
Opening Balance
(670.34)
565
Monthly funding
RES
3
12/31/2017
197.67
2
Total
197.67
0.00
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 3
Check #
Net Change
(197.67)
Ending Balance
(868.01)
570-Pool/Pool Heater
Opening Balance
(26,471.48)
570
Monthly funding
RES
3
12/31/2017
197.92
2
Total
197.92
0.00
Net Change
(197.92)
Ending Balance
(26,669.40)
575-Hazard Insurance
Opening Balance
(13,652.41)
575
Monthly funding
RES
3
12/31/2017
3,075.17
2
Total
3,075.17
0.00
Net Change
(3,075.17)
Ending Balance
(16,727.58)
576-Flood Insurance
Opening Balance
(3,387.12)
576
Monthly funding
RES
3
12/31/2017
322.92
2
Total
322.92
0.00
Net Change
(322.92)
Ending Balance
(3,710.04)
587-Entry Doors
Opening Balance
(7,500.24)
587
Monthly funding
RES
3
12/31/2017
85.83
2
Total
85.83
0.00
Net Change
(85.83)
Ending Balance
(7,586.07)
590-Deferred Maintenance
Opening Balance
(67,204.72)
590
Monthly Funding
RES
3
12/31/2017
453.91
1
Total
453.91
0.00
Net Change
(453.91)
Ending Balance
(67,658.63)
595-Unallocated Interest
Opening Balance
(11,202.12)
595
Reserve Interest
RES
3
12/31/2017
50.20
Popular Interes
RES
3
12/31/2017
81.92
CD Interest
RES
3
12/31/2017
108.77
Total
240.89
0.00
Net Change
(240.89)
Ending Balance
(11,443.01)
620-Prepaid Fees
Opening Balance
(6,846.56)
620
Owner Receivables
CM
5
12/31/2017
6,846.56
Owner Receivables
CM
5
12/31/2017
4,448.56
Total
4,448.56
6,846.56
Net Change
2,398.00
Ending Balance
(4,448.56)
900-Prior Years Fund Bala
Opening Balance
(71,863.95)
900
Prior Year Surplus
A/P
2
12/31/2017
1,250.00
Total
0.00
1,250.00
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 4
Check #
Net Change
1,250.00
Ending Balance
(70,613.95)
1010-Maintenance Fees
Opening Balance
(280,038.00)
1010
Owner Receivables
CM
5
12/31/2017
25,458.00
Total
25,458.00
0.00
Net Change
(25,458.00)
Ending Balance
(305,496.00)
1040-Miscellaneous
Opening Balance
(125.00)
1040
Total
0.00
0.00
Ending Balance
(125.00)
1045-Kayak Storage
Opening Balance
(400.00)
1045
Total
0.00
0.00
Ending Balance
(400.00)
1050-Application fee
Opening Balance
(2,950.00)
1050
Deposit
CBK
4
12/31/2017
75.00
AP Dolski 502
Deposit
CBK
4
12/31/2017
75.00
AP Smith 307
Deposit
CBK
4
12/31/2017
75.00
AP Richter 409
Deposit
CBK
4
12/31/2017
75.00
AP Rozmus
Deposit
CBK
4
12/31/2017
75.00
AP McCormack 106
Total
375.00
0.00
Net Change
(375.00)
Ending Balance
(3,325.00)
1800-Operating Interest
Opening Balance
(72.56)
1800
Interest
CBK
4
12/31/2017
0.76
BB&T Interest
RES
3
12/31/2017
4.98
Total
5.74
0.00
Net Change
(5.74)
Ending Balance
(78.30)
1910-Prior Year Surplus
Opening Balance
(13,750.00)
1910
Prior Year Surplus
A/P
2
12/31/2017
1,250.00
Total
1,250.00
0.00
Net Change
(1,250.00)
Ending Balance
(15,000.00)
1995-Reserve Interest
Opening Balance
(2,698.45)
1995
Reserve Interest
RES
3
12/31/2017
50.20
Popular Interes
RES
3
12/31/2017
81.92
CD Interest
RES
3
12/31/2017
108.77
Total
240.89
0.00
Net Change
(240.89)
Ending Balance
(2,939.34)
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 5
Check #
2020-Pool/Pool Heater
Opening Balance
3,768.98
2020
Florida Chemical -118503
A/P
1
12/12/2017
86.87
5521
#433/Chemicals
Total
0.00
86.87
Net Change
86.87
Ending Balance
3,855.85
2040-Building Repair
Opening Balance
8,074.21
2040
Total
0.00
0.00
Ending Balance
8,074.21
2050-Building Supply
Opening Balance
6,251.23
2050
Home Depot Credit-12/05/1
A/P
1
12/19/2017
470.45
5524
6035 3225 0413 1859
Total
0.00
470.45
Net Change
470.45
Ending Balance
6,721.68
2055-RPM Dedicated Mainte
Opening Balance
51,489.56
2055
Resource Management
A/P
2
12/31/2017
4,500.00
1
Deposit
CBK
4
12/31/2017
318.24
RPM PR Nov
Total
318.24
4,500.00
Net Change
4,181.76
Ending Balance
55,671.32
2060-Elevator
Opening Balance
4,527.45
2060
EM ENGINEERING, I-1901121
A/P
1
12/19/2017
42.27
5529
Elevator monitoring
Total
0.00
42.27
Net Change
42.27
Ending Balance
4,569.72
2071-Grounds-Maintenance
Opening Balance
4,769.45
2071
Home Depot Credit-12/05/1
A/P
1
12/19/2017
321.66
5524
6035 3225 0413 1859
Marshall Pest Con-11/30/1
A/P
1
12/19/2017
214.50
5526
Pest Control
Total
0.00
536.16
Net Change
536.16
Ending Balance
5,305.61
2078-Fire Alarm
Opening Balance
15,121.94
2078
SimplexGrinnell -7984068
A/P
1
12/19/2017
898.00
5525
Contract#694527
SimplexGrinnell -8435094
A/P
1
12/26/2017
778.00
5531
Contract# 292-15257393
Total
0.00
1,676.00
Net Change
1,676.00
Ending Balance
16,797.94
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 6
Check #
2080-Exterminating
Opening Balance
5,811.70
2080
Orkin Pest Contro-1635761
A/P
1
12/12/2017
123.52
5522
Acct# 336762
Total
0.00
123.52
Net Change
123.52
Ending Balance
5,935.22
4010-Electric
Opening Balance
7,509.98
4010
Duke Energy
CBK
4
12/31/2017
610.38
Total
0.00
610.38
Net Change
610.38
Ending Balance
8,120.36
4020-Water
Opening Balance
7,722.00
4020
Pinellas County Utilities
CBK
4
12/31/2017
1,139.08
Total
0.00
1,139.08
Net Change
1,139.08
Ending Balance
8,861.08
4025-Gas
Opening Balance
4,732.96
4025
City of Clearwater
CBK
4
12/31/2017
938.56
Total
0.00
938.56
Net Change
938.56
Ending Balance
5,671.52
4030-Sewer
Opening Balance
13,174.68
4030
Pinellas County Utilities
CBK
4
12/31/2017
2,235.67
Total
0.00
2,235.67
Net Change
2,235.67
Ending Balance
15,410.35
4040-Trash
Opening Balance
6,214.40
4040
Pinellas County Utilities
CBK
4
12/31/2017
1,242.88
Total
0.00
1,242.88
Net Change
1,242.88
Ending Balance
7,457.28
4050-Telephone
Opening Balance
4,978.07
4050
AT&T Mobility -12/22/1
A/P
1
12/19/2017
93.28
5528
Acct#995131801
Frontier
CBK
4
12/31/2017
109.17
Frontier
CBK
4
12/31/2017
211.28
Total
0.00
413.73
Net Change
413.73
Ending Balance
5,391.80
4070-Cable TV
Opening Balance
19,071.98
4070
Bright House
CBK
4
12/31/2017
1,731.90
Total
0.00
1,731.90
Net Change
1,731.90
Ending Balance
20,803.88
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 7
Check #
5010-Management Fee
Opening Balance
10,371.13
5010
Resource Mgmt
A/P
2
12/31/2017
942.83
1
Total
0.00
942.83
Net Change
942.83
Ending Balance
11,313.96
5011-Office
Opening Balance
1,927.23
5011
Resource Manageme-office
A/P
1
12/12/2017
253.19
5520
#158
Arnold Kraemer
A/P
1
12/19/2017
550.00
5527
Happy Holidays
Annual Coupons
CBK
4
12/31/2017
270.00
Total
0.00
1,073.19
Net Change
1,073.19
Ending Balance
3,000.42
5015-Division Fees/Corp F
Opening Balance
241.25
5015
Total
0.00
0.00
Ending Balance
241.25
5016-License & Fees
Opening Balance
150.00
5016
Total
0.00
0.00
Ending Balance
150.00
5030-Professional Fee
Opening Balance
10,055.93
5030
Jeffrey Tomes
A/P
1
12/12/2017
146.00
5523
reimb-website domain
Total
0.00
146.00
Net Change
146.00
Ending Balance
10,201.93
5036-IRS Taxes & Tax Prep
Opening Balance
861.00
5036
Internal Revenue Service
CBK
4
12/31/2017
200.00
Total
0.00
200.00
Net Change
200.00
Ending Balance
1,061.00
5056-RPM Dedicated Insura
Opening Balance
66.00
5056
Resource Property MGMT
A/P
2
12/31/2017
6.00
Total
0.00
6.00
Net Change
6.00
Ending Balance
72.00
9010-Painting
Opening Balance
5,049.00
9010
Monthly Funding
RES
3
12/31/2017
459.00
1
Total
0.00
459.00
Net Change
459.00
Ending Balance
5,508.00
9020-Roofing
Opening Balance
7,848.50
9020
Monthly Funding
RES
3
12/31/2017
713.50
1
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 8
Check #
Total
0.00
713.50
Net Change
713.50
Ending Balance
8,562.00
9030-Paving
Opening Balance
213.62
9030
Monthly Funding
RES
3
12/31/2017
19.42
1
Total
0.00
19.42
Net Change
19.42
Ending Balance
233.04
9051-Balcony/Landings
Opening Balance
735.13
9051
Monthly Funding
RES
3
12/31/2017
66.83
1
Total
0.00
66.83
Net Change
66.83
Ending Balance
801.96
9052-Gazebo/Deck
Opening Balance
4,790.50
9052
Monthly Funding
RES
3
12/31/2017
435.50
1
Total
0.00
435.50
Net Change
435.50
Ending Balance
5,226.00
9060-Seawall
Opening Balance
1,234.75
9060
Monthly Funding
RES
3
12/31/2017
112.25
1
Total
0.00
112.25
Net Change
112.25
Ending Balance
1,347.00
9064-Elevator
Opening Balance
44,108.13
9064
Monthly Funding
RES
3
12/31/2017
4,009.83
1
Total
0.00
4,009.83
Net Change
4,009.83
Ending Balance
48,117.96
9065-Generator
Opening Balance
2,174.37
9065
Monthly Funding
RES
3
12/31/2017
197.67
1
Total
0.00
197.67
Net Change
197.67
Ending Balance
2,372.04
9070-Pool/Pool Heater
Opening Balance
2,177.12
9070
Monthly Funding
RES
3
12/31/2017
197.92
1
Total
0.00
197.92
Net Change
197.92
Ending Balance
2,375.04
9075-Hazard Insurance
Opening Balance
33,826.87
9075
Monthly Funding
RES
3
12/31/2017
3,075.17
1
Total
0.00
3,075.17
Net Change
3,075.17
Ending Balance
36,902.04
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 9
Check #
9076-Flood Insurance
Opening Balance
3,552.12
9076
Monthly Funding
RES
3
12/31/2017
322.92
1
Total
0.00
322.92
Net Change
322.92
Ending Balance
3,875.04
9087-Entry Doors
Opening Balance
944.13
9087
Monthly Transfers
RES
3
12/31/2017
85.83
2
Total
0.00
85.83
Net Change
85.83
Ending Balance
1,029.96
9090-Deferred Maintenance
Opening Balance
4,993.01
9090
Monthly Funding
RES
3
12/31/2017
453.91
2
Total
0.00
453.91
Net Change
453.91
Ending Balance
5,446.92
9095-Reserve Interest
Opening Balance
2,698.45
9095
Reserve Interest
RES
3
12/31/2017
50.20
Popular Interes
RES
3
12/31/2017
81.92
CD Interest
RES
3
12/31/2017
108.77
Total
0.00
240.89
Net Change
240.89
Ending Balance
2,939.34
21052-Rsv Trans-Gazebo/De
Opening Balance
(3,515.50)
21052
Total
0.00
0.00
Ending Balance
(3,515.50)
21065-Rsv Trans-Generator
Opening Balance
(11,684.70)
21065
Total
0.00
0.00
Ending Balance
(11,684.70)
21075-Rsv Trans-Hazard In
Opening Balance
(35,082.58)
21075
Total
0.00
0.00
Ending Balance
(35,082.58)
21076-Rsv Trans-Flood Ins
Opening Balance
(10,165.00)
21076
Total
0.00
0.00
Ending Balance
(10,165.00)
21090-Rsv Trans-Deferred
Opening Balance
(8,600.00)
21090
Total
0.00
0.00
Ending Balance
(8,600.00)
25052-Rsv Disb.-Gazebo/De
Opening Balance
3,515.50
25052
Total
0.00
0.00
Ending Balance
3,515.50
25065-Rsv Disb.-Generator
Opening Balance
11,684.70
25065
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 10
Check #
Total
0.00
0.00
Ending Balance
11,684.70
25075-Rsv Disb.-Hazard In
Opening Balance
35,082.58
25075
Total
0.00
0.00
Ending Balance
35,082.58
25076-Rsv Disb.-Flood Ins
Opening Balance
10,165.00
25076
Total
0.00
0.00
Ending Balance
10,165.00
25090-Rsv Disb.-Deferred
Opening Balance
8,600.00
25090
Total
0.00
0.00
Ending Balance
8,600.00
Detail General Ledger
Date
Journal
Code
Description
Debit
Credit
01/09/2018
DRIFTWOOD SANDS CONDOMINIUM
December 31, 2017
Page 11
Check #
TOTAL DEBITS
Opening Balance
Current
Ending Balance
871,061.00
170,083.31
905,133.27
TOTAL CREDITS
871,061.00
170,083.31
905,133.27
Seq
Day
Description
Debits
Account Name
01/09/2018
Page 1
Acct Number
Credits
JOURNAL ENTRIES - A/P Automatic Interface - Code A/P
December, 2017
DRIFTWOOD SANDS
CONDOMINIUM
1
12
Check Register Distributn
109-BOTO Operating
109
609.58
2
19
Check Register Distributn
109-BOTO Operating
109
2,590.16
3
26
Check Register Distributn
109-BOTO Operating
109
778.00
7
12
Florida Chemical -118503
2020-Pool/Pool Heater
2020
86.87
#433/Chemicals
8
19
Home Depot Credit-12/05/1
2050-Building Supply
2050
470.45
6035 3225 0413 1859
9
19
EM ENGINEERING, I-190
2060-Elevator
2060
42.27
Elevator monitoring
10
19
Home Depot Credit-12/05/1
2071-Grounds-Maintenance
2071
321.66
6035 3225 0413 1859
11
19
Marshall Pest Con-11/30/1
2071-Grounds-Maintenance
2071
214.50
Pest Control
13
19
SimplexGrinnell -7984068
2078-Fire Alarm
2078
898.00
Contract#694527
15
26
SimplexGrinnell -8435094
2078-Fire Alarm
2078
778.00
Contract# 292-15257393
16
12
Orkin Pest Contro-1635761
2080-Exterminating
2080
123.52
Acct# 336762
17
19
AT&T Mobility -12/22/1
4050-Telephone
4050
93.28
Acct#995131801
18
12
Resource Manageme-office
5011-Office
5011
253.19
#158
19
19
Arnold Kraemer
5011-Office
5011
550.00
Happy Holidays
20
12
Jeffrey Tomes
5030-Professional Fee
5030
146.00
reimb-website domain
3,977.74
3,977.74
359370000000
Total
Code A/P
Seq
Day
Description
Debits
Account Name
01/09/2018
Page 2
Acct Number
Credits
JOURNAL ENTRIES - Transfers & Adjustments - Code A/P
December, 2017
DRIFTWOOD SANDS
CONDOMINIUM
1
31
Resource Mgmt
5010-Management Fee
5010
942.83
4
31
Resource Mgmt
109-BOTO Operating
109
5,448.83
13
31
Resource Management
2055-RPM Dedicated Mainte
2055
4,500.00
20
31
Resource Property MGMT
5056-RPM Dedicated Insura
5056
6.00
21
31
Prior Year Surplus
900-Prior Years Fund Balance
900
1,250.00
22
31
Prior Year Surplus
1910-Prior Year Surplus
1910
1,250.00
6,698.83
6,698.83
150400000000
Total
Code A/P
Seq
Day
Description
Debits
Account Name
01/09/2018
Page 3
Acct Number
Credits
JOURNAL ENTRIES - Reserve Activity - Code RES
December, 2017
DRIFTWOOD SANDS
CONDOMINIUM
1
31
Monthly Transfer
510-Painting
510
459.00
2
31
Monthly Transfer
520-Roofing
520
713.50
3
31
Monthly funding
530-Paving
530
19.42
4
31
Monthly funding
551-Balcony/Landings
551
66.83
5
31
Monthly funding
552-Gazebo/Deck
552
435.50
6
31
Monthly funding
560-Seawall
560
112.25
7
31
Monthly funding
564-Elevator
564
4,009.83
8
31
Monthly funding
565-Generator
565
197.67
9
31
Monthly funding
570-Pool/Pool Heater
570
197.92
10
31
Monthly funding
575-Hazard Insurance
575
3,075.17
11
31
Monthly funding
576-Flood Insurance
576
322.92
12
31
Monthly funding
587-Entry Doors
587
85.83
13
31
Monthly Funding
209-BOTO Reserve
209
10,149.75
14
31
Monthly Funding
9010-Painting
9010
459.00
15
31
Monthly Funding
9020-Roofing
9020
713.50
16
31
Monthly Funding
9030-Paving
9030
19.42
17
31
Monthly Funding
9051-Balcony/Landings
9051
66.83
18
31
Monthly Funding
9052-Gazebo/Deck
9052
435.50
19
31
Monthly Funding
9060-Seawall
9060
112.25
20
31
Monthly Funding
9064-Elevator
9064
4,009.83
21
31
Monthly Funding
9065-Generator
9065
197.67
22
31
Monthly Funding
9070-Pool/Pool Heater
9070
197.92
23
31
Monthly Funding
9075-Hazard Insurance
9075
3,075.17
24
31
Monthly Funding
9076-Flood Insurance
9076
322.92
25
31
Monthly Transfers
9087-Entry Doors
9087
85.83
26
31
Monthly Transfers
109-BOTO Operating
109
10,149.75
29
31
Monthly Funding
590-Deferred Maintenance
590
453.91
30
31
Monthly Funding
9090-Deferred Maintenance
9090
453.91
31
31
Reserve Interest
1995-Reserve Interest
1995
50.20
32
31
Reserve Interest
209-BOTO Reserve
209
50.20
33
31
Reserve Interest
9095-Reserve Interest
9095
50.20
34
31
Reserve Interest
595-Unallocated Interest
595
50.20
35
31
BB&T Interest
1800-Operating Interest
1800
4.98
36
31
BB&T Interest
110-BB&T-Money Market
110
4.98
37
31
Popular Interes
1995-Reserve Interest
1995
81.92
38
31
Popular Interes
215-Popular Bank MM
215
81.92
39
31
Popular Interes
9095-Reserve Interest
9095
81.92
40
31
Popular Interes
595-Unallocated Interest
595
81.92
41
31
CD Interest
1995-Reserve Interest
1995
108.77
42
31
CD Interest
225-BOTO CD;1709;1.15%;
225
108.77
43
31
CD Interest
9095-Reserve Interest
9095
108.77
44
31
CD Interest
595-Unallocated Interest
595
108.77
45
31
Transfer to Popular
215-Popular Bank MM
215
100,000.00
46
31
Transfer to Popular
209-BOTO Reserve
209
100,000.00
120,786.26
120,786.26
1633560000000
Total
Code RES
Seq
Day
Description
Debits
Account Name
01/09/2018
Page 4
Acct Number
Credits
JOURNAL ENTRIES - Checkbook Interface - Code CBK
December, 2017
DRIFTWOOD SANDS
CONDOMINIUM
1
31
Frontier
4050-Telephone
4050
109.17
2
31
Internal Revenue Service
5036-IRS Taxes & Tax Prep
5036
200.00
3
31
City of Clearwater
4025-Gas
4025
938.56
4
31
Duke Energy
4010-Electric
4010
610.38
5
31
Pinellas County Utilities
4020-Water
4020
1,139.08
6
31
Pinellas County Utilities
4030-Sewer
4030
2,235.67
7
31
Pinellas County Utilities
4040-Trash
4040
1,242.88
8
31
Bright House
4070-Cable TV
4070
1,731.90
9
31
Frontier
4050-Telephone
4050
211.28
10
31
Deposit
1050-Application fee
1050
75.00
AP Dolski 502
11
31
Deposit
1050-Application fee
1050
75.00
AP Smith 307
12
31
Deposit
1050-Application fee
1050
75.00
AP Richter 409
13
31
Deposit
1050-Application fee
1050
75.00
AP Rozmus
14
31
Deposit
1050-Application fee
1050
75.00
AP McCormack 106
15
31
Deposit
2055-RPM Dedicated Mainte
2055
318.24
RPM PR Nov
16
31
Annual Coupons
5011-Office
5011
270.00
17
31
Interest
1800-Operating Interest
1800
0.76
18
31
Checkbook Interface
109-BOTO Operating
109
7,994.92
8,688.92
8,688.92
515560000000
Total
Code CBK
Seq
Day
Description
Debits
Account Name
01/09/2018
Page 5
Acct Number
Credits
JOURNAL ENTRIES - Owner Receivables - Code CM
December, 2017
DRIFTWOOD SANDS
CONDOMINIUM
1
31
Owner Receivables
109-BOTO Operating
109
23,060.00
2
31
Owner Receivables
1010-Maintenance Fees
1010
25,458.00
3
31
Owner Receivables
310-Accounts Receivable
310
25.00
4
31
Owner Receivables
620-Prepaid Fees
620
6,846.56
5
31
Owner Receivables
310-Accounts Receivable
310
25.00
6
31
Owner Receivables
620-Prepaid Fees
620
4,448.56
29,931.56
29,931.56
29790000000
Total
Code CM