READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — December 1, 2015 — General Ledger Audit Trail - Lord & Son Construction, Inc. — reading text
Part 1 of 1. These parts divide the reading text for browsing; they are not the source document's page numbers.
General Ledger Audit Trail - Lord & Son Construction, Inc. — extracted reading text
Machine-extracted OCR text · Review label: Known limitations
Compare this copy with the preserved source. Review labels describe the recorded status of this file; they do not guarantee that the text is error-free. Spacing and line breaks are retained, with long lines wrapped to fit the screen.
Lord & Son Construction, Inc.
Project Title: Shalimar Administrative Building (New Phase 2)
Purchasing Contract# C12-1995-FM
Expires: TBD
Retainage begins
w/ construction
10%
3160 3160 301
562132 562131 Total Const Cost Not Const Cost 2051100 Amount to be
Inv# Const Cost Pre-Const Cost Costto date Subjto Retain Sub to Retain Withheld Paid
1 26,361.70 26,361.70 26,361.70 - 26,361.70
2 21,961.70 21,961.70 21,961.70 - 21,961.70
3 34,098.25 34,098.25 34,098.25 - 34,098.25
4 61,835.80 61,835.80 61,835.80 - 61,835.80
5 20,339.55 20,339.55 20,339.55 - 20,339.55
6 % 10,280.85 10,280.85 10,280.85 - 10,280.85
7 14,561.70 14,561.70 14,561.70 - 14,561.70
8 15,474.04 15,474.04 15,474.04 - 15,474.04
9 12,061.70 12,061.70 12,061.70 - 12,061.70
10 20,754.89 20,754.89 20,754.89 - 20,754.89
1 81,920.86 81,920.86 81,920.86 - 81,920.86
12 71,675.43 71,675.43 71,675.43 - 71,675.43
13 289,187.06 289,187.06 289,187.06 - 289,187.06
14 218,375.99 218,375.99 218,375.99 - 218,375.99
15 131,311.27 131,311.27 131,311.27 - 131,311.27
Subtotal 865,603.79 164,597.00 1,030,200.79 1,030,200.79 - 1,030,200.79
16 ¥ 140,212.33 140,212.33 100,417.33 39,795.00 3,979.50 136,232.83
17 294,611.05 294,611.05 41,730.65 252,880.40 25,288.04 269,323.01
18 613,613.60 613,613.60 553,181.96 60,431.64 60,431.64 553,181.96
Reconcile const cost (240,834.69) 240,834.69
19 540,946.07 540,946.07 540,946.07 54,094.61 486,851.46
20 744,263.60 744,263.60 1,835.00 742,428.60 74,242.86 670,020.74
21 763,552.67 763,552.67 - 763,552.67 76,355.27 687,197.40
22 440,184.82 440,184.82 - 440,184.82 44,018.48 418,709.04
Retainage paid out to subcontractor Inv #22 (22,542.70)
23 780,884.60 780,884.60 - 780,884.60 78,088.46 702,796.14
24 713,618.60 713,618.60 2,340.00 711,278.60 71,127.86 642,490.74
25 494,263.12 494,263.12 - 494,263.12 49,426.31 444 836.81
26 708,585.82 708,585.82 708,585.82 70,858.58 637,727.24
27 614,974.80 614,974.80 614,974.80 61,497.48 553,477.32
28 744,273.39 744,273.39 744,273.39 37,213.67 707,059.72
% of Retainage paid out to Contractor Inv #28 for Substantial Completion (252,870.80) 252,870.80
29 241,196.04 241,196.04 1,260.00 239,936.04 11,996.80 229,199.24
30 36,871.50 443,206.07 480,077.57
Totals 8,700,784.30 164,597.00 8,865,381.30 1,527,002.54 7,375,250.26 886,412.14 8,902,252.79
* Invoice 6 (for $10,280.85) revised to Invoice 5; Invoice 5 (for $20,339.55) remained
** Construction begins with this invoice
*** Retainage reduced to 5%
Contract Total All Phases $ 904,667.00
Change Order 1 170,854.54
Change Order 2 558,880.00
Change Order 3 178,784.69
Change Order 4 4,024,754.21
Change Order 5 6,237,084.60
Change Order 6 (2,118,627.44)
Change Order 7 (741,693.02)
Change Order 8 287,192.13
Change Order 9 (516,872.26)
Change Order 10 (79,434.90)
Change Order 11 30,261.54
Change Order 12 (33,598.30)
Revised Contract Total S 8,902,252.79
Bal to finish plus retainage: $ 0.00
Date
Paid
01/09/14
02/28/13
06/13/13
03/28/13
08/29/13
12/26/13
01/09/14
02/13/14
02/27/14
03/13/14
05/15/14
06/05/14
06/18/14
07/17/14
08/14/14
09/18/14
10/30/14
11/14/14
12/12/14
01/08/15
02/12/15
03/13/15
04/16/15
05/14/15
06/12/15
07/16/15
08/06/15
09/17/15
09/17/15
Check
Number
V1302590
V1303747
V1306299
V1304381
V1308319
V1401877
V1402098
V1403104
V1403411
V1403862
V1405666
V1406102
V1406435
V1407144
V1408220
V1409070
V1500851
V1501352
V1502092
V1502702
V1503465
V1504214
V1505043
V1505768
V1506628
V1507451
V1507937
V1509222
V1509222
SUNGARD PENTAMATION, INC.
DATE: 11/20/2015
TIME: 09:09:49
ACCOUNTING PERIODS:
SELECTION CRITERIA:
TOTALED ON: FUND, ACCOUNT, PERIOD
FUND - 301 - CAPITAL PROJECTS FUND
ACCOUNT DATE TIE REFERENCE
2051100 CONTRACTS PAY-RETAINED%
09/30/13 19-1 NEW YEAR
TOTAL PERIOD 1
02/06/14 21-5 V1402709
TOTAL PERIOD 5
04/03/14 21-7 1404435
TOTAL PERIOD 7
05/01/14 21-8 1405089
TOTAL PERIOD 8
07/10/14 21-10 1406967
TOTAL PERIOD 10
09/11/14 21-12 1408872
09/18/14 21-12 V1409070
TOTAL PERIOD 12
TOTAL CONTRACTS PAY-RETAINEDS
TOTAL CAPITAL PROJECTS FUND
TOTAL REPORT
1/14 THRU 13/14
OKALOOSA COUNTY BOCC
GENERAL LEDGER AUDIT TRAIL
(INACTIVE ACCOUNTS INCLUDED)
genledgr.fund='301’ genledgr.account=' 2051100
VENDOR/PAYER
21101286 SKANSKA USA BUILDI
006087 GULF ATLANTIC CONS
006087 GULF ATLANTIC CONS
006087 GULF ATLANTIC CONS
006087 GULF ATLANTIC CONS
004002 LORD & SON CONSTRU
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
DEBIT
.00
10,000.
10,000.
00
00
.00
.00
.00
5,328.
5,328.
64
64
.00
.00
CREDIT
10,000.
2,058.
2,058.
1,668.
1,668.
1,601.
1,601.
3,9789.
3,979
33978
3,979.
35979
.00
10,000.
00
00
.00
67
67
63
63
34
34
50
50
50
50
50
PAGE NUMBER:
AUDIT221
DESCRIPTION
BEGINNING BALANCE
BEGINNING BALANCE
10,000.
CRTHSE ANNEX EXT
-10,000.
MARLER BOAT RAMP
2,058.
MARLER BOAT RAMP
1,668.
MARLER RAMP OUTDOOR
1,601.
MARLER RAMP/OUTDOOR
SHAL ADM BLDG PH2
-1,349.
NET
00
00
67
63
34
14
SUNGARD PENTAMATION, INC.
DATE: 11/20/2015 OKALOOSA COUNTY BOCC
TIME: 09:09:06 GENERAL LEDGER AUDIT TRAIL
ACCOUNTING PERIODS: 1/15 THRU 13/15
(INACTIVE ACCOUNTS INCLUDED)
SELECTION CRITERIA: genledgr.fund='301’ genledgr.account='2051100"
TOTALED ON: FUND,ACCOUNT, PERIOD
FUND - 301 - CAPITAL PROJECTS FUND
ACCOUNT DATE T/C REFERENCE VENDOR/PAYER DEBIT
2051100 CONTRACTS PAY-RETAINED%
10/01/14 19-1 NEW YEAR
10/30/14 21-1 V1500851 004002 LORD & SON CONSTRU
TOTAL PERIOD 1
11/14/14 21-2 V1501352 004002 LORD & SON CONSTRU
11/20/14 21-2 V1501439 004002 LORD & SON CONSTRU
TOTAL PERIOD 2
12/11/14 21-3 V1502011 004002 LORD & SON CONSTRU
12/12/14 21-3 V1502092 004002 LORD & SON CONSTRU
TOTAL PERIOD 3
01/08/15 21-4 004002 LORD & SON CONSTRU
01/08/15 21-4 004002 LORD & SON CONSTRU 74,242.
01/08/15 21-4 004002 LORD & SON CONSTRU
01/08/15 21-4 V1502702 004002 LORD & SON CONSTRU
01/15/15 21-4 V1502796 004002 LORD & SON CONSTRU
TOTAL PERIOD 4 74,242.
02/12/15 21-5 V1503465 004002 LORD & SON CONSTRU
02/12/15 21-5 V1503465 004002 LORD & SON CONSTRU
TOTAL PERIOD 5
03/13/15 21-6 V1504214 004002 LORD & SON CONSTRU
03/13/15 21-6 V1504214 004002 LORD & SON CONSTRU
TOTAL PERIOD 6
04/16/15 21-7 V1505043 004002 LORD & SON CONSTRU
04/16/15 21-7 V1505043 004002 LORD & SON CONSTRU
TOTAL PERIOD 7
05/14/15 21-8 V1505768 004002 LORD & SON CONSTRU
05/14/15 21-8 V1505768 004002 LORD & SON CONSTRU
TOTAL PERIOD 8
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
.00
.00
.00
86
86
.00
.00
.00
.00
CREDIT
29,267.
60,431.
4,885.
65,317,
8,328.
54,094.
62,423.
74,242.
158,107.
76,355.
6,760.
83,115.
21,475.
5y 552
27,028.
78,088.
14,806.
92,895
TL; 2T
14,752.
85,880.
.00
979,
25,288.
50
04
54
64
84
48
48
61
09
86
.00
74,242
9,622.
86
LS
87
27
31
58
78
55
33
46
93
39
86
38
24
PAGE NUMBER:
AUDIT221
DESCRIPTION
BEGINNING BALANCE
BEGINNING BALANCE
PH2 SHAL ADM BLDG
29,267.
SHAL ADM BLDG PH2
TO5SHERIFF/SHAL ADD'N
65,317,
SHERFF ADDITION
RETAINAGE
62,423.
SHAL ANNEX PH 2
SHAL ANNEX PH 2
SHAL ANNEX PH 2
RETAINAGE
SHAL SHERIFF OFFICE
83,865.
SHAL ADM PH 2
NEW ADD SHERIFF SHAL
83:;;115:
SHAL ADM PH2
NEW ADD SHERIFF SHAL
27,028.
SHAL ADM BLDG PH 2
NEW SHER OFFICE
92,895.
SHAL ADM PH 2
NEW SHERIFF OFFICE
85,880.
NET
54
48
09
01
58
39
24
SUNGARD PENTAMATION, INC. PAGE NUMBER:
DATE: 11/20/2015 OKALOOSA COUNTY BOCC AUDIT221
TIME: 09:09:06 GENERAL LEDGER AUDIT TRAIL
ACCOUNTING PERIODS: 1/15 THRU 13/15
(INACTIVE ACCOUNTS INCLUDED)
SELECTION CRITERIA: genledgr.fund='301’ genledgr.account='2051100"
TOTALED ON: FUND,ACCOUNT, PERIOD
FUND - 301 - CAPITAL PROJECTS FUND
ACCOUNT DATE i if o REFERENCE VENDOR/PAYER DEBIT CREDIT DESCRIPTION
2051100 CONTRACTS PAY-RETAINEDS% (cont’d)
06/12/15 21-9 V1506628 004002 LORD & SON CONSTRU 49,426.31 RETAINAGE
06/12/15 21-9 V1506628 004002 LORD & SON CONSTRU 12,022.52 RETAINAGE
06/12/15 21-9 V1506628 004002 LORD & SON CONSTRU 2,805.69 INV#9 CORRECTION
TOTAL PERIOD 9 .00 64,254.52 64,254.
07/16/15 21-10 V1507451 004002 LORD & SON CONSTRU 9,923.07 SHAL SHERIFF OFFC
07/16/15 21-10 V1507451 004002 LORD & SON CONSTRU 70,858.58 SHAL ADM PH2
TOTAL PERIOD 10 .00 80,781.65 80,781.
08/06/15 21-11 V1507937 004002 LORD & SON CONSTRU 61,497.48 SHALIMAR ADMIN BLDG
08/21/15 21-11 V1508414 004002 LORD & SON CONSTRU 712.39 5% RETAINAGE WH
08/21/15 21-11 V1508414 004002 LORD & SON CONSTRU 42,152.54 PARTIAL RETAINAGE PO
TOTAL PERIOD 11 42,152.54 62,209.87 20,057.
09/17/15 21-12 V1509222 004002 LORD & SON CONSTRU 37,213.67 PH2 SHAL ADM BLDG
09/17/15 21-12 V1509222 004002 LORD & SON CONSTRU 252,870.80 PH2 SHAL ADM BLDG
TOTAL PERIOD 12 252,870.80 37,213,677 =215::657:;
10/01/15 21-13 V1600029 004002 LORD & SON CONSTRU 919.04 NEW ADD SHAL SHERIFF
10/22/15 21-13 V1600748 004002 LORD & SON CONSTRU 48,938.80 RETAINAGE-FINAL PYMT
11/10/15 19-13 AJE13FG 11,996.80 ACCRUE 2015 EXPENSES
TOTAL PERIOD 13 48,938.80 12,915.84 -36,022.
TOTAL CONTRACTS PAY-RETAINED% 443,206.07
TOTAL CAPITAL PROJECTS FUND .00 443,206.07
TOTAL REPORT .00 443,206.07
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
NET
52
65
33
13
96