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

 | CASH RECEIPTS - 2008
 |  | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY | JULY
 |  | 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 | 31 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLOSED | CLOSED
 | 18 HOLES PUBLIC | 108.02 | 78.02 | 62.42 | 90.02 | 326.01 | 359 | 224 | 174 | 196.03 | 30 | 517.12 | 310.01 | 150 | 118.04 | 0 | 0 | 0 | 149.89 | 255.02 | 510 | 281 | 84 | 247.5 | 251.84 | 258.89 | 687.86 | 683 | 89.01 | 147 | 28.99 | 134.47 | 6551.16 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 90 | 0 | 0 | 15 | 0 | 0 | 30 | 30 | 15 | 0 | 45 | 0 | 40 | 30 | 0 | 0 | 0 | 15 | 0 | 0 | 15 | 45 | 0 | 0 | 75 | 0 | 0 | 0 | 0 | 15 | 0 | 460 | 9 HOLES PUBLIC
 | MEMBER CART | 29.43 | 9.87 | 117.75 | 156.96 | 213.4 | 29.43 | 235.5 | 68.67 | 29.43 | 68.86 | 29.43 | 88.29 | 98.13 | 39.24 | 147.18 | 0 | 0 | 147.56 | 75.54 | 19.62 | 39.24 | 49.05 | 107.94 | 0 | 39.24 | 186.42 | 19.62 | 39.24 | 98.13 | 0 | 0 | 2183.17 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 165 | 60 | 83.68 | 118.02 | 170 | 315 | 80 | 0 | 30 | 225 | 147.06 | 135 | 210 | 235 | 60 | 0 | 0 | 210 | 85 | 60.06 | 80 | 30 | 130.7 | 60 | 166.7 | 30 | 170 | 129.99 | 40 | 95 | 165 | 3486.21 | 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 | 250 | 304 | 340 | 792 | 756 | 220 | 158 | 196 | 63.6 | 380 | 323 | 520 | 180 | 212 | 200 | 0 | 0 | 248 | 480 | 340 | 30 | 140 | 20 | 100 | 40 | 96 | 260 | 203 | 198 | 40 | 208 | 7297.6 | BIG SUMMER CARD
 | TOURNAMENT | 130 | 76.5 | 77.75 | 218.9 | 210.79 | 120.75 | 82.5 | 61.75 | 29.78 | 121.25 | 161.5 | 178.5 | 100.5 | 89.25 | 26.75 | 0 | 0 | 62 | 115.25 | 144.5 | 59.5 | 77 | 73 | 73 | 59.96 | 190.99 | 183.25 | 95 | 37.5 | 10 | 42.75 | 2910.17 | TOURNAMENT
 | MEMBER GUEST | 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 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 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 | 0 | 0.46 | 0 | 107.95 | 47.46 | 0.5 | 23.95 | 1.86 | 0.94 | 25 | 32.34 | 24.46 | 35 | 0.46 | 32 | 0 | 0 | 0 | 15 | 34.96 | 9.5 | 30.84 | 0 | 7 | 28 | 25.87 | 26 | 10.46 | 0 | 0 | 11.38 | 531.39 | MERCHANDISE
 | RENTAL CLUBS | 0 | 14.02 | 0 | 21.03 | 7.01 | 7.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 7.01 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 0 | 70.1 | RENTAL CLUBS
 | RANGE | 20.54 | 13.07 | 10.47 | 56.94 | 59.87 | 39.2 | 7.47 | 52 | 18.67 | 32.67 | 75.61 | 188.27 | 30.81 | 27.07 | 0 | 0 | 0 | 5.6 | 38.8 | 110.01 | 23.34 | 15.87 | 25.2 | 22 | 13.07 | 35.47 | 22.4 | 30.81 | 33.61 | 14.94 | 39.74 | 1063.52 | 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 | 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 | 0 | [NAME]. SOLD
 | [NAME]. SOLD - 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 | 0
 | CREDIT BOOK SOLD | 0 | 42 | 6 | 0 | 0 | 0 | 0 | 0 | 42 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 159 | 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 | 0 | HANDICAP FEES
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL | 792.99 | 597.94 | 698.07 | 1576.82 | 1790.54 | 1090.89 | 841.4200000000001 | 584.2800000000001 | 425.45 | 897.78 | 1331.06 | 1444.53 | 844.4399999999999 | 751.0600000000001 | 465.93 | 0 | 0 | 838.0500000000001 | 1371.62 | 1219.15 | 537.58 | 478.77 | 640.34 | 523.84 | 680.86 | 1252.61 | 1364.27 | 604.52 | 554.24 | 203.93 | 609.34 | 25012.32000000001 | TOTAL
 | SALES TAX | 46.44 | 33.58 | 43.04 | 95.19 | 109.05 | 67.98 | 52.1 | 34 | 24.8 | 53.37 | 81.54 | 88.01 | 52.11 | 46.38 | 30.76 | 0 | 0 | 52.99 | 87.46 | 72.47 | 33.51 | 28.18 | 37.24 | 30.34 | 43.52 | 71.6 | 82.71 | 34.33 | 36.21 | 13.6 | 38.63 | 1521.14 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 839.4300000000001 | 631.5200000000001 | 741.11 | 1672.01 | 1899.59 | 1158.87 | 893.5200000000001 | 618.2800000000001 | 450.2500000000001 | 951.15 | 1412.6 | 1532.54 | 896.55 | 797.44 | 496.69 | 0 | 0 | 891.0400000000001 | 1459.08 | 1291.62 | 571.09 | 506.95 | 677.58 | 554.1800000000001 | 724.38 | 1324.21 | 1446.98 | 638.85 | 590.45 | 217.53 | 647.97 | 26533.46 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem - Pro | 0 | 0 | 0 | 14.4 | 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 | 14.4 | Less: [NAME]. Redeemed
 | LESS: [NAME]. Redeem -Golf | 0 | 0 | 0 | 0 | 0 | 18.55 | 0 | 0 | 47.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | LESS: Credit  Book Redeemed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8.03 | 4.82 | 0 | 0 | 7.49 | 29.96 | 44.78 | 0 | 0 | 0 | 0 | 0 | 95.08 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 503.07 | 250 | 343.67 | 1112.73 | 555 | 400 | 219.16 | 338.08 | 52.08 | 737.1 | 842.92 | 993.54 | 435.13 | 431.05 | 250.07 | 0 | 0 | 200 | 582.42 | 459.8 | 229.25 | 287.82 | 438.14 | 383.45 | 351.16 | 651.45 | 740.73 | 302.05 | 171.13 | 170 | 329.9 | 12760.9 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 336.3600000000001 | 381.5200000000001 | 397.44 | 544.8800000000001 | 1344.59 | 740.3200000000002 | 674.3600000000001 | 280.2000000000001 | 351.0900000000001 | 214.05 | 569.6799999999997 | 539 | 461.42 | 366.39 | 246.62 | 0 | 0 | 691.0400000000001 | 876.66 | 823.7900000000002 | 320.97 | 219.13 | 239.4400000000001 | 163.2400000000001 | 343.2599999999999 | 627.9799999999998 | 706.25 | 336.8 | 419.3200000000001 | 47.53 | 318.0700000000001 | 13663.08 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 638.95 | 688.7 | 696.3 | 851.91 | 1648.89 | 1049.24 | 974.3 | 580.76 | 655.09 | 518.15 | 868.74 | 844.9 | 761.2 | 666.39 | 550.4 | 0 | 0 | 1002.54 | 1172.34 | 1124.59 | 620.93 | 519.15 | 539.75 | 461.43 | 576.15 | 927.98 | 1002.95 | 635.36 | 719.6 | 347.53 | 623.02 | 22267.24 | TOTAL CASH ON HAND
 | LESS:DRAWER | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 8700 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 338.95 | 388.7 | 396.3 | 551.91 | 1348.89 | 749.24 | 674.3 | 280.76 | 355.09 | 218.15 | 568.74 | 544.9 | 461.2 | 366.39 | 250.4 | 0 | 0 | 702.54 | 872.3399999999999 | 824.5899999999999 | 320.9299999999999 | 219.15 | 239.75 | 161.43 | 276.15 | 627.98 | 702.95 | 335.36 | 419.6 | 47.52999999999997 | 323.02 | 13567.24 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 336.3600000000001 | 381.5200000000001 | 397.44 | 544.8800000000001 | 1344.59 | 740.3200000000002 | 674.3600000000001 | 280.2000000000001 | 351.0900000000001 | 214.05 | 569.6799999999997 | 539 | 461.42 | 366.39 | 246.62 | 0 | 0 | 691.0400000000001 | 876.66 | 823.7900000000002 | 320.97 | 219.13 | 239.4400000000001 | 163.2400000000001 | 343.2599999999999 | 627.9799999999998 | 706.25 | 336.8 | 419.3200000000001 | 47.53 | 318.0700000000001 | 13581.4 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 2.589999999999975 | 7.17999999999995 | -1.140000000000043 | 7.029999999999859 | 4.300000000000409 | 8.919999999999845 | -0.0600000000001728 | 0.5599999999998886 | 3.999999999999943 | 4.100000000000023 | -0.9399999999997135 | 5.899999999999977 | -0.2199999999999136 | 0 | 3.779999999999973 | 0 | 0 | 11.49999999999989 | -4.32000000000005 | 0.7999999999997272 | -0.04000000000007731 | 0.01999999999998181 | 0.3099999999999454 | -1.810000000000059 | -67.10999999999996 | 0 | -3.299999999999955 | -1.439999999999998 | 0.2799999999999727 | 0 | 4.949999999999932 | -14.16000000000065 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 338.95 | 388.7 | 396.3 | 551.91 | 1348.89 | 749.24 | 674.3 | 280.76 | 355.09 | 218.15 | 568.74 | 544.9 | 461.2 | 366.39 | 250.4 | 0 | 0 | 702.54 | 872.3399999999999 | 824.5899999999999 | 320.9299999999999 | 219.15 | 239.75 | 161.43 | 276.15 | 627.98 | 702.95 | 335.36 | 419.6 | 47.52999999999997 | 323.02 | 13567.24 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 335.9 | 376.48 | 360.25 | 544.2 | 1198.12 | 648.97 | 568 | 261.51 | 198.46 | 210.45 | 493.45 | 528.75 | 443.15 | 366.39 | 135.25 | 0 | 0 | 523.85 | 778.91 | 683.29 | 268.24 | 209.15 | 222.06 | 160.31 | 243.04 | 623.13 | 625.51 | 201.47 | 418.6 | 32.1 | 264.35 | 11923.34 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 3.050000000000068 | 12.22000000000003 | 36.04999999999995 | 7.709999999999923 | 150.7700000000002 | 100.27 | 106.3 | 19.25 | 156.63 | 7.699999999999989 | 75.29000000000002 | 16.14999999999998 | 18.05000000000007 | 0 | 115.15 | 0 | 0 | 178.6899999999999 | 93.42999999999995 | 141.3 | 52.68999999999994 | 9.999999999999972 | 17.69 | 1.120000000000005 | 33.10999999999999 | 4.850000000000023 | 77.44000000000005 | 133.89 | 1 | 15.42999999999997 | 58.66999999999996 | 1643.900000000001 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  | $50.00 partial restitution |  |  |  |  |  |  | $1,345.29 partial restitution |  |  |  |  |  |  |  | $15,932.43 checks from |  |  |  |  |  |  | $50.00 partial restitution |  |  | $1509.55 partial restitution
 |  |  |  | from juveniles from |  |  |  |  |  |  | from juvenile from cart |  |  |  |  |  |  |  | SafeCo deposited |  |  |  |  |  |  | from juvenile from cart |  |  | from [NAME] cart
 |  |  |  | cart break-in last July |  |  |  |  |  |  | break-in in July  last year |  |  |  |  |  |  |  |  |  |  |  |  |  |  | break-in from last year |  |  | break-in from last year