Spreadsheet: 40288d1238594447-help-on-auto-update-of-cells-08ledgers
Sheet: SEP

 | CASH RECEIPTS - 2006
 |  | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER |  | SEPTEMBER
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | CLOSED - Rain
 | 18 HOLES PUBLIC | 196 | 148.01 | 178.05 | 137 | 466.94 | 195 | 132 | 40.48 | 64 | 0 | 95 | 242.04 | 287.38 | 110 | 18 | 94 | 265.2 | 75 | 503.28 | 447.5 | 329.51 | 79 | 40.5 | 85.5 | 173 | 364.87 | 391.02 | 222.04 | 242 | 49 | 0 | 5671.320000000001 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 0 | 0 | 15 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 24 | 57 | 28.5 | 0 | 37 | 0 | 0 | 15 | 45 | 15 | 30 | 20 | 0 | 0 | 26.21 | 42 | 15 | 0 | 0 | 0 | 0 | 429.71 | 9 HOLES PUBLIC
 | MEMBER CART | 233.04 | 215.88 | 0 | 147.18 | 39.24 | 104.97 | 9.81 | 412.14 | 107.94 | 0 | 29.43 | 37.27 | 76.37 | 29.43 | 8.84 | 97.16 | 18.65 | 55.95 | 150.12 | 16.19 | 19.62 | 17.68 | 9.81 | 137.37 | 146.21 | 320.88 | 152.1 | 19.81 | 98.13 | 98.13 | 0 | 2809.35 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 165 | 25 | 105 | 95 | 255.11 | 15 | 85 | 83 | 70 | 0 | 47.7 | 244.08 | 113.7 | 60 | 120.5 | 160 | 82.5 | 109 | 192.6 | 133.5 | 27 | 25 | 0 | 67 | 48 | 195 | 60 | 40 | 97.1 | 10 | 0 | 2730.79 | EARLY BIRD & TWLIGHT
 | LEAGUE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LEAGUE
 | BIG SUMMER CARD | 400 | 92 | 40 | 96 | 108 | 260 | 321 | 0 | 60 | 0 | 140 | 210.21 | 388 | 115 | 88.8 | 157 | 121.4 | 236 | 184.4 | 160 | 378 | 210.2 | 158 | 178 | 20 | 118.8 | 218 | 320 | 120 | 80 | 0 | 4978.81 | BIG SUMMER CARD
 | TOURNAMENT | 118.5 | 61.5 | 39.5 | 37 | 51.75 | 180.5 | 152 | 25 | 27 | 0 | 57.51 | 78.25 | 171.25 | 51.5 | 25.75 | 121.25 | 45.55 | 67 | 77 | 108 | 79 | 18 | 57 | 38.25 | 48.5 | 61 | 138 | 23 | 49.5 | 4.5 | 0 | 2012.56 | TOURNAMENT
 | MEMBER GUEST | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13.5 | 0 | 0 | 0 | 0 | 58.5 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ANNUAL DUES SINGLE
 | ANNUAL DUES FAMILY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ANNUAL DUES FAMILY
 | INITIATION | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | INITIATION
 | MERCHANDISE | 8.87 | 7.46 | 10 | 7.46 | 33.46 | 0 | 12 | 54 | 1 | 0 | 10.96 | 10 | 31.22 | 16 | 0.5 | 0.5 | 0.46 | 0 | 12.95 | 18.38 | 14.87 | 0 | 0.46 | 0.46 | 0 | 14.96 | 6 | 10.92 | 18 | 0 | 0 | 300.89 | MERCHANDISE
 | RENTAL CLUBS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | 7.01 | 0 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.02 | RENTAL CLUBS
 | RANGE | 18.67 | 202.8 | 15.87 | 5.6 | 27.07 | 23.87 | 67.23 | 8.4 | 0 | 0 | 8.4 | 5.6 | 30.4 | 22 | 0 | 5.6 | 2.8 | 18.67 | 2.8 | 8.4 | 39.2 | 16.8 | 0 | 29.87 | 25.2 | 33.62 | 55.2 | 25.2 | 19.6 | 0 |  | 718.8700000000002 | RANGE
 | MEMBER PAYMENTS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | MEMBER PAYMENTS
 | [NAME]. SOLD - Pro | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | [NAME]. SOLD - Pro
 | [NAME]. SOLD - Golf | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 514.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 564.01 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 0 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 0 |  | 108 | CREDIT BOOK SOLD
 | HANDICAP FEES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | HANDICAP FEES
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL | 1140.08 | 752.6500000000001 | 495.42 | 555.2400000000001 | 1011.57 | 779.34 | 824.04 | 623.02 | 329.94 | 0 | 412.9999999999999 | 1405.47 | 1133.83 | 403.93 | 309.39 | 645.51 | 566.56 | 576.62 | 1168.15 | 906.97 | 917.2 | 386.68 | 265.77 | 572.4499999999999 | 487.12 | 1151.13 | 1048.82 | 660.97 | 644.33 | 241.63 | 0 | 20416.83000000001 | TOTAL
 | SALES TAX | 71.03 | 48.4 | 28.99 | 36.31 | 61.1 | 41.42 | 48.16 | 41.33 | 21.21 | 0 | 24.92 | 92.99 | 61.4 | 24.15 | 18.49 | 36.72 | 30.19 | 35.71 | 76.36 | 56 | 58.76 | 25.24 | 14.64 | 34.55 | 30.76 | 72.03 | 58.34 | 44.04 | 41.68 | 16.6 |  | 1251.52 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 1211.11 | 801.0500000000001 | 524.41 | 591.5500000000002 | 1072.67 | 820.76 | 872.1999999999999 | 664.35 | 351.15 | 0 | 437.92 | 1498.46 | 1195.23 | 428.08 | 327.88 | 682.23 | 596.75 | 612.33 | 1244.51 | 962.97 | 975.96 | 411.92 | 280.41 | 606.9999999999999 | 517.88 | 1223.16 | 1107.16 | 705.01 | 686.01 | 258.23 | 0 | 21668.35 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem - Pro | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | Less: [NAME]. Redeem - Pro
 | LESS: [NAME]. Redeem-Golf | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | Less: [NAME]. Redeem - Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 10.7 | 0 | 0 | 0 | 0 | 57.78 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 68.48 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 488.19 | 229.91 | 327.88 | 337.18 | 725.62 | 479.33 | 507.71 | 75 | 150.33 | 0 | 235 | 600 | 737.17 | 100 | 290.15 | 340.27 | 305 | 357.56 | 778.17 | 458.3 | 311.63 | 350.14 | 179.4 | 228.09 | 367.65 | 807.13 | 669.02 | 435.97 | 181 | 108.66 | 0 | 11161.46 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 722.9199999999998 | 571.1400000000001 | 185.8299999999999 | 254.3700000000002 | 347.0500000000001 | 341.43 | 364.49 | 531.57 | 200.82 | 0 | 202.92 | 898.46 | 458.0600000000003 | 328.08 | 37.73000000000002 | 341.96 | 291.75 | 254.77 | 466.34 | 504.67 | 664.33 | 61.78000000000003 | 101.01 | 378.9099999999999 | 150.23 | 416.0299999999999 | 438.1399999999999 | 269.04 | 505.01 | 149.57 | 0 | 10438.41 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 1025.98 | 876.86 | 495.33 | 559.87 | 621.86 | 641.26 | 654.67 | 828.91 | 501.12 | 0 | 506.21 | 1198.91 | 759.16 | 632.11 | 341.56 | 647.16 | 590.54 | 557.12 | 766.91 | 809.52 | 949.84 | 361.5 | 413.75 | 673.64 | 451.6 | 717.67 | 731.47 | 569.56 | 805.81 | 449.57 | 0 | 19139.47 | TOTAL CASH ON HAND
 | LESS:DRAWER | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 8700 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 725.98 | 576.86 | 195.33 | 259.87 | 321.86 | 341.26 | 354.67 | 528.91 | 201.12 | 0 | 206.21 | 898.9100000000001 | 459.16 | 332.11 | 41.56 | 347.16 | 290.54 | 257.12 | 466.91 | 509.52 | 649.84 | 61.5 | 113.75 | 373.64 | 151.6 | 417.67 | 431.47 | 269.5599999999999 | 505.8099999999999 | 149.57 | 0 | 10439.47 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 722.9199999999998 | 571.1400000000001 | 185.8299999999999 | 254.3700000000002 | 347.0500000000001 | 341.43 | 364.49 | 531.57 | 200.82 | 0 | 202.92 | 898.46 | 458.0600000000003 | 328.08 | 37.73000000000002 | 341.96 | 291.75 | 254.77 | 466.34 | 504.67 | 664.33 | 61.78000000000003 | 101.01 | 378.9099999999999 | 150.23 | 416.0299999999999 | 438.1399999999999 | 269.04 | 505.01 | 149.57 | 0 | 10438.41 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 3.060000000000173 | 5.719999999999914 | 9.500000000000057 | 5.499999999999829 | -25.19000000000005 | -0.1700000000000159 | -9.819999999999993 | -2.660000000000082 | 0.3000000000000398 | 0 | 3.29000000000002 | 0.4500000000000455 | 1.099999999999682 | 4.03000000000003 | 3.829999999999984 | 5.199999999999932 | -1.210000000000036 | 2.349999999999966 | 0.5699999999999363 | 4.849999999999966 | -14.49000000000001 | -0.2800000000000296 | 12.74000000000004 | -5.269999999999868 | 1.370000000000005 | 1.6400000000001 | -6.669999999999845 | 0.5199999999999818 | 0.7999999999999545 | 0 | 0 | 1.059999999999718 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 725.98 | 576.86 | 195.33 | 259.87 | 321.86 | 341.26 | 354.67 | 528.91 | 201.12 | 0 | 206.21 | 898.9100000000001 | 459.16 | 332.11 | 41.56 | 347.16 | 290.54 | 257.12 | 466.91 | 509.52 | 649.84 | 61.5 | 113.75 | 373.64 | 151.6 | 417.67 | 431.47 | 269.5599999999999 | 505.8099999999999 | 149.57 | 0 | 10439.47 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 718.77 | 565.74 | 159.15 | 258.16 | 294.61 | 301.76 | 348.54 | 521.25 | 183.54 | 0 | 204.38 | 897.1 | 445.06 | 298.1 | 34.4 | 338.66 | 228.6 | 252.52 | 466.61 | 486.2 | 629.24 | 53.5 | 96.1 | 365.25 | 149.1 | 414.3 | 428.95 | 246.1 | 437.63 | 147.8 | 0 | 9971.12 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 7.210000000000036 | 11.12 | 36.17999999999998 | 1.70999999999998 | 27.25 | 39.5 | 6.129999999999939 | 7.659999999999968 | 17.58000000000001 | 0 | 1.829999999999984 | 1.810000000000059 | 14.09999999999997 | 34.00999999999999 | 7.160000000000004 | 8.499999999999943 | 61.93999999999997 | 4.599999999999994 | 0.2999999999999545 | 23.31999999999999 | 20.60000000000002 | 8 | 17.65000000000001 | 8.389999999999986 | 2.500000000000028 | 3.369999999999948 | 2.520000000000039 | 23.45999999999995 | 68.17999999999995 | 1.769999999999982 | 0 | 468.3499999999967 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The last 2 cash | deposits went
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | into new acct. | at SunTrust
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total amount of | $69.95.