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

 | CASH RECEIPTS - 2008
 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  | 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-Aerify
 | 18 HOLES PUBLIC | 636.51 | 256 | 35 | 116 | 253.05 | 263.73 | 359.55 | 170.18 | 221 | 189.42 | 61 | 322.1 | 276.74 | 291.21 | 770.04 | 71 | 55.23 | 0 | 102.26 | 67.34 | 165 | 0 | 81.27 | 243.02 | 40 | 280.27 | 119.68 | 347 | 514 | 20.17 | 0 | 6327.77 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 0 | 0 | 0 | 105 | 15 | 75 | 75 | 45 | 45 | 15 | 15 | 45 | 0 | 10 | 15 | 75 | 30 | 0 | 15 | 60 | 0 | 0 | 0 | 30 | 0 | 0 | 105 | 10 | 0 | 0 | 0 | 785 | 9 HOLES PUBLIC
 | MEMBER CART | 39.24 | 58.86 | 353.25 | 19.62 | 127.56 | 176.61 | 54.05 | 9.81 | 49.05 | 156.99 | 107.94 | 107.94 | 46.24 | 201.23 | 117.75 | 39.24 | 80.87 | 0 | 127.56 | 392.4 | 58.86 | 58.86 | 19.62 | 49.05 | 49.05 | 176.61 | 49.05 | 68.7 | 127.57 | 85.83 | 0 | 3009.410000000001 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 65 | 0 | 34.99 | 235 | 251.21 | 307.74 | 110 | 215.19 | 125 | 30 | 95 | 173.86 | 176.01 | 215 | 10 | 30 | 120 | 0 | 190 | 172.74 | 165 | 480 | 340 | 0 | 120 | 180.38 | 161.31 | 15 | 95 | 135 | 0 | 4248.43 | 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 | 664 | 147 | 248 | 217.12 | 248 | 224 | 260 | 390 | 40 | 480 | 176 | 220 | 199.45 | 315 | 460 | 64 | 140 | 0 | 183 | 140 | 260 | 620 | 276 | 348 | 288 | 152 | 248 | 320 | 440 | 36.5 | 0 | 7804.07 | BIG SUMMER CARD
 | TOURNAMENT | 167.24 | 65.75 | 103 | 71.25 | 80.5 | 84.5 | 222.79 | 131 | 57 | 178 | 44.5 | 131.96 | 85.01 | 186 | 192.6 | 86.25 | 102.25 | 0 | 93.5 | 140.97 | 173.5 | 224.75 | 127.5 | 71.82 | 50.25 | 193 | 97.25 | 152.34 | 178.5 | 139 | 0 | 3631.98 | TOURNAMENT
 | MEMBER GUEST | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 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 | 300 | 0 | 0 | 0 | 0 | 0 | 300 | ANNUAL DUES SINGLE
 | ANNUAL DUES FAMILY | 0 | 0 | 0 | 0 | 3088.35 | 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 | 3088.35 | 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 | 9.46 | 0 | 72.26 | 14.88 | 15 | 13.92 | 41.38 | 31.49 | 0 | 15 | 0.94 | 5.92 | 47.43 | 17 | 48.37 | 118.64 | 15.41 | 0 | 17.88 | 50.97 | 7 | 32.46 | 16.5 | 59.35 | 17 | 25 | 1 | 0 | 22.5 | 44 | 0 | 760.7600000000001 | MERCHANDISE
 | RENTAL CLUBS | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37 | RENTAL CLUBS
 | RANGE | 283.61 | 31.76 | 2.8 | 18.67 | 46.68 | 48.54 | 80.68 | 19.59 | 46.68 | 20.54 | 24.27 | 109.33 | 26.14 | 48.54 | 33.61 | 15.38 | 40.14 | 0 | 42.01 | 14 | 19.2 | 53.74 | 27.6 | 225.21 | 53.61 | 32.67 | 14 | 11.2 | 49.07 | 1.5 |  | 1440.77 | RANGE
 | [NAME]. SOLD - Pro | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65.41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 115.41 | [NAME]. SOLD - Pro
 | [NAME]. SOLD - Golf | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46.72 | 0 | 0 | 0 | 0 | 0 | 58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 104.72 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 0 | 0 | 42 | 18 | 0 | 0 | 0 | 0 | 0 | 42 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 12 | 0 | 0 | 0 | 0 |  | 176 | 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 | 1865.06 | 589.37 | 849.3 | 889.54 | 4143.35 | 1194.04 | 1203.45 | 1012.26 | 583.7299999999999 | 1141.67 | 566.65 | 1130.11 | 857.02 | 1364.39 | 1669.37 | 557.51 | 583.9 | 0 | 771.2099999999999 | 1038.42 | 848.5600000000001 | 1469.81 | 888.49 | 1026.45 | 665.91 | 1351.93 | 795.29 | 924.2400000000001 | 1426.64 | 462 | 0 | 31869.67000000001 | TOTAL
 | SALES TAX | 118.97 | 36.7 | 52.29 | 54.37 | 283.24 | 77.86 | 68.21 | 61.74 | 36.93 | 67.51 | 33.65 | 68.97 | 54.13 | 82.62 | 103.44 | 33.03 | 32.93 | 0 | 47.52 | 60.96 | 46.73 | 86.33 | 52.71 | 65.8 | 39.79 | 80.37 | 48.88 | 54.07 | 86.88 | 22.01 |  | 1958.64 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 1984.03 | 626.07 | 901.5899999999999 | 943.91 | 4426.59 | 1271.9 | 1271.66 | 1074 | 620.6599999999999 | 1209.18 | 600.3 | 1199.08 | 911.15 | 1447.01 | 1772.81 | 590.54 | 616.8299999999999 | 0 | 818.7299999999999 | 1099.38 | 895.2900000000001 | 1556.14 | 941.2 | 1092.25 | 705.6999999999999 | 1432.3 | 844.17 | 978.3100000000002 | 1513.52 | 484.01 | 0 | 33828.31 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem - Pro | 0 | 0 | 0 | 0 | 0 | 14.41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 14.41 | Less: [NAME]. Redeem Pro
 | LESS: [NAME]. Redeem - Golf | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.4 | 0 | 0 | 0 | 0 | 0 | 62.06 | 0 | 0 | 0 | 0 |  | 134.45 | Less: [NAME]. Redeem Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 27.82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 53.5 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 859.52 | 42.12 | 350 | 450 | 574.18 | 747.76 | 557.8 | 112.58 | 308.49 | 523 | 256.26 | 626.13 | 207.59 | 756.35 | 907.15 | 200.54 | 422.38 | 0 | 538.4 | 558 | 515.07 | 651.62 | 557.79 | 590.71 | 520 | 708.86 | 492.88 | 497.35 | 663.48 | 330.6 | 0 | 14526.61 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 1124.51 | 583.95 | 523.7699999999999 | 493.91 | 3852.41 | 509.7299999999998 | 713.8600000000004 | 940.43 | 312.1699999999998 | 686.1799999999998 | 344.04 | 572.9500000000002 | 677.88 | 690.6600000000002 | 865.6599999999997 | 390 | 194.4499999999999 | 0 | 280.3299999999999 | 489.98 | 380.22 | 904.5200000000001 | 383.4100000000001 | 501.5399999999997 | 185.6999999999999 | 661.3800000000002 | 351.29 | 480.9600000000002 | 850.04 | 153.41 | 0 | 19099.34 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 1425.77 | 884.55 | 824.5 | 794.41 | 4153.31 | 809.29 | 1015.18 | 1239.19 | 611.91 | 987.61 | 644.94 | 870.99 | 977.33 | 992.03 | 1172.28 | 691.4 | 496.05 | 0 | 582.87 | 789.65 | 682.3 | 1208.87 | 685.83 | 801.46 | 484.82 | 963.72 | 650.06 | 776.59 | 1151.21 | 454.39 | 0 | 27822.51 | TOTAL CASH ON HAND
 | LESS:DRAWER | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 8700 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 1125.77 | 584.55 | 524.5 | 494.41 | 3853.31 | 509.29 | 715.18 | 939.19 | 311.91 | 687.61 | 344.9400000000001 | 570.99 | 677.33 | 692.03 | 872.28 | 391.4 | 196.05 | 0 | 282.87 | 489.65 | 382.3 | 908.8699999999999 | 385.83 | 501.46 | 184.82 | 663.72 | 350.0599999999999 | 476.59 | 851.21 | 154.39 | 0 | 19122.51 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 1124.51 | 583.95 | 523.7699999999999 | 493.91 | 3852.41 | 509.7299999999998 | 713.8600000000004 | 940.43 | 312.1699999999998 | 686.1799999999998 | 344.04 | 572.9500000000002 | 677.88 | 690.6600000000002 | 865.6599999999997 | 390 | 194.4499999999999 | 0 | 280.3299999999999 | 489.98 | 380.22 | 904.5200000000001 | 383.4100000000001 | 501.5399999999997 | 185.6999999999999 | 661.3800000000002 | 351.29 | 480.9600000000002 | 850.04 | 153.41 | 0 | 19099.34 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 1.259999999999991 | 0.599999999999909 | 0.7300000000001319 | 0.5 | 0.900000000000091 | -0.4399999999998272 | 1.319999999999595 | -1.239999999999895 | -0.2599999999998772 | 1.430000000000177 | 0.900000000000091 | -1.96000000000015 | -0.5499999999999545 | 1.369999999999777 | 6.620000000000232 | 1.399999999999977 | 1.60000000000008 | 0 | 2.540000000000077 | -0.3300000000000409 | 2.079999999999927 | 4.349999999999795 | 2.419999999999959 | -0.07999999999969987 | -0.8799999999999386 | 2.339999999999804 | -1.230000000000018 | -4.370000000000118 | 1.170000000000073 | 0.9800000000000182 | 0 | 23.17000000000019 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 1125.77 | 584.55 | 524.5 | 494.41 | 3853.31 | 509.29 | 715.18 | 939.19 | 311.91 | 687.61 | 344.9400000000001 | 570.99 | 677.33 | 692.03 | 872.28 | 391.4 | 196.05 | 0 | 282.87 | 489.65 | 382.3 | 908.8699999999999 | 385.83 | 501.46 | 184.82 | 663.72 | 350.0599999999999 | 476.59 | 851.21 | 154.39 | 0 | 19122.51 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 954.9 | 463.27 | 471.01 | 466.19 | 3833.21 | 439.84 | 594.13 | 363.19 | 277.31 | 603.64 | 340.84 | 509.15 | 401.82 | 655.03 | 823.88 | 223.16 | 181.3 | 0 | 279.22 | 411.22 | 371.3 | 704 | 354.93 | 431.59 | 139.77 | 642.27 | 345.21 | 364.81 | 651.12 | 127.34 | 0 | 16424.65 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 170.87 | 121.28 | 53.49000000000001 | 28.21999999999997 | 20.10000000000036 | 69.44999999999999 | 121.05 | 576 | 34.59999999999997 | 83.97000000000003 | 4.10000000000008 | 61.84000000000003 | 275.51 | 37 | 48.39999999999998 | 168.24 | 14.75 | 0 | 3.649999999999977 | 78.42999999999995 | 10.99999999999994 | 204.8699999999999 | 30.90000000000003 | 69.87000000000006 | 45.04999999999998 | 21.45000000000005 | 4.849999999999966 | 111.78 | 200.09 | 27.04999999999998 | 0 | 2697.860000000004 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  | $187.26 partial restitution |  |  |  | $8.29 partial restitution
 |  |  |  |  |  |  |  |  |  |  |  |  | from juveniles charged |  |  |  | from juveniles charged
 |  |  |  |  |  |  |  |  |  |  |  |  | with golf cart break-ins |  |  |  | with golf cart break-ins