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

 | 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] | [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 | 31 | TOTAL
 | 18 HOLES PUBLIC | 2568.32 | 5485.1 | 5519.69 | 3799.01 | 5520.78 | 2381.47 | 5788.79 | 2065.8 | 5026.12 | 4565.43 | 3884.32 | 6249.27 | 5603.64 | 4122 | 3963.36 | 2349.4 | 5248.89 | 4734.63 | 4785.95 | 2945.76 | 3524.46 | 490.01 | 3072.61 | 4580.13 | 4873.7 | 5070.36 | 3857.97 | 3474.88 | 2113.07 | 3775.58 | 3733.19 | 125173.69 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 175 | 50 | 45 | 291 | 570 | 270.06 | 50 | 0 | 265 | 125 | 294 | 150 | 25 | 150 | 100 | 0 | 125 | 334 | 0 | 50 | 100 | 0 | 0 | 200 | 345 | 0 | 0 | 75 | 0 | 50 | 0 | 3839.06 | 9 HOLES PUBLIC
 | MEMBER CART | 437.83 | 262.12 | 1099.47 | 759.3 | 296.69 | 327.06 | 929.38 | 230.92 | 291.11 | 549.02 | 1069.11 | 502.06 | 443.88 | 715.82 | 611.59 | 41.36 | 1369.67 | 630.8 | 671 | 256.98 | 487.19 | 501.11 | 537.36 | 325.19 | 659.3 | 210.7 | 759.3 | 281.24 | 499.52 | 192.04 | 381.72 | 16329.84 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 725 | 585 | 667.47 | 30 | 875 | 443.74 | 680 | 395 | 300 | 1175 | 710 | 1130 | 857.85 | 850 | 625 | 890 | 470 | 1010 | 1446.07 | 515 | 1350 | 170 | 0 | 1274 | 655 | 1339.33 | 1102.3 | 710 | 424.99 | 555 | 808.25 | 22769 | 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 | 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 | BIG SUMMER CARD
 | TOURNAMENT | 35.75 | 29 | 15 | 23.25 | 33.46 | 7.42 | 26.5 | 15.25 | 335.5 | 18 | 0 | 29 | 57.05 | 12.32 | 41 | 26.5 | 125.52 | 29 | 236 | 19 | 25.8 | 19.5 | 45.75 | 41 | 21 | 5 | 39.5 | 10 | 63 | 32.5 | 16.5 | 1434.07 | TOURNAMENT
 | MEMBER GUEST | 230 | 315 | 0 | 0 | 0 | 0 | 785.49 | 315 | 0 | 0 | 0 | 0 | 0 | 646.35 | 250 | 30 | 950 | 0 | 0 | 0 | 530.49 | 299 | 150 | 0 | 0 | 0 | 0 | 825.83 | 915 | 0 | 0 | 6242.16 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1060.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1060.26 | 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 | 57.1 | 117.77 | 152.92 | 26.01 | 80.14 | 135.88 | 154.06 | 105.72 | 224.5 | 57.5 | 96.5 | 39.42 | 137.3 | 60.31 | 136.7 | 228.7 | 148.01 | 128.71 | 5 | 43 | 240.08 | 91.96 | 101.1 | 96.5 | 172.87 | 112.08 | 111.4 | 120.89 | 222.22 | 18.38 | 29.5 | 3452.23 | MERCHANDISE
 | RENTAL CLUBS | 7.01 | 14.51 | 7 | 7.01 | 0 | 0 | 21.03 | 0 | 0 | 21.01 | 7.01 | 28.04 | 7.01 | 0 | 0 | 14.02 | 15 | 0 | 7.01 | 7.01 | 0 | 0 | 14.02 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 190.69 | RENTAL CLUBS
 | RANGE | 257.64 | 243.88 | 208.26 | 176.55 | 284.24 | 119.46 | 142.84 | 119.61 | 251.16 | 222.2 | 116.68 | 309.9 | 158.68 | 149.16 | 143.61 | 206.42 | 223.52 | 193.23 | 108.28 | 89.61 | 259.51 | 24.27 | 90.73 | 217.51 | 131.56 | 246.92 | 204.42 | 144.68 | 116.67 | 213.77 | 190.58 | 5565.550000000002 | 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 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | [NAME]. SOLD - Pro
 | [NAME]. SOLD - Golf | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 225 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 225 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 0 | 0 | 0 | 147.66 | 0 | 420 | 0 | 91 | 0 | 0 | 146 | 50 | 0 | 0 | 0 | 0 | 0 | 1035 | 0 | 0 | 0 | 0 | 235 | 0 | 159 | 56 | 0 | 0 | 0 | 0 | 2339.66 | 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 | 4493.650000000001 | 7102.380000000001 | 7714.81 | 5112.130000000001 | 7807.969999999999 | 3685.09 | 8998.09 | 3247.3 | 6784.389999999999 | 6733.160000000001 | 7237.88 | 8583.69 | 7340.410000000002 | 6705.96 | 5871.259999999999 | 3786.4 | 8900.610000000002 | 7060.37 | 8294.31 | 3926.360000000001 | 6517.53 | 1595.85 | 4011.57 | 7026.33 | 6865.43 | 7143.389999999999 | 6130.889999999999 | 5642.52 | 4354.47 | 4837.27 | 5159.74 | 188671.21 | TOTAL
 | SALES TAX | 306.75 | 493.27 | 533.53 | 354.23 | 544.66 | 255.53 | 595.43 | 224.62 | 436.24 | 461.49 | 507.07 | 589.27 | 506.87 | 468.83 | 406.49 | 255.5 | 498.51 | 495.29 | 491.93 | 272.06 | 454.76 | 108.56 | 196.32 | 462.48 | 476.46 | 486.34 | 420.27 | 394.48 | 297.55 | 336.62 | 360.62 | 12692.03 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 4800.400000000001 | 7595.650000000001 | 8248.34 | 5466.360000000001 | 8352.63 | 3940.62 | 9593.52 | 3471.92 | 7220.629999999999 | 7194.650000000001 | 7744.95 | 9172.960000000001 | 7847.280000000002 | 7174.79 | 6277.749999999999 | 4041.9 | 9399.120000000003 | 7555.66 | 8786.24 | 4198.420000000001 | 6972.29 | 1704.41 | 4207.89 | 7488.809999999999 | 7341.89 | 7629.73 | 6551.16 | 6037 | 4652.02 | 5173.89 | 5520.36 | 201363.24 | TOTAL RECEIPTS
 | LESS: [NAME]. Red. - Pro | 0 | 0 | 0 | 0 | 0 | 99.96 | 36.97 | 0 | 0 | 73.5 | 0 | 0 | 0 | 41.38 | 0 | 20 | 8.56 | 111.02 | 0 | 0 | 236.25 | 0 | 0 | 29.96 | 0 | 99.18 | 42.86 | 0 | 0 | 0 | 0 | 799.64 | Less: [NAME]. Red.  - Pro
 | LESS: [NAME]. Red.  - Golf | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27.82 | 0 | 0 | 0 | 0 | 53.5 | 0 | 0 | 0 | 0 | 0 | 28.63 | 159.95 | Less: [NAME]. Red.  - Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14.98 | 0 | 0 | 0 | 0 | 60.99 | 0 | 0 | 30.39 | 0 | 0 | 0 | 0 | 0 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 128.28 | 0 | 0 | 309.64 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 1469.3 | 875.43 | 81.8 | 174.14 | 0 | 892.72 | 607.71 | 0 | 320 | 1056.66 | 789.59 | 1880.7 | 1790.82 | 1202.52 | 650.55 | 185.58 | 44.69 | 292.6 | 829.16 | 1072.8 | 626 | 0 | 0 | 291.17 | 191.23 | 358.74 | 1341.5 | 1311.9 | 916.4 | 869.23 | 134.99 | 20257.93 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 3331.1 | 6720.220000000001 | 8116.54 | 5292.22 | 8352.63 | 2947.940000000001 | 8948.84 | 3456.94 | 6900.629999999999 | 6064.490000000001 | 6955.36 | 7292.260000000001 | 5995.470000000002 | 5930.889999999999 | 5627.199999999999 | 3805.93 | 9345.870000000003 | 7152.039999999999 | 7957.08 | 3097.800000000001 | 6110.04 | 1629.41 | 4207.89 | 7167.679999999999 | 7097.160000000001 | 7171.809999999999 | 5166.8 | 4725.1 | 3607.340000000001 | 4304.66 | 5356.74 | 179836.08 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 3631.14 | 7021.07 | 8420.41 | 5594.44 | 8646.82 | 3248.75 | 9255.42 | 3754.89 | 7205.17 | 6367.78 | 7254.87 | 7593.21 | 6301.03 | 6234.72 | 5929.66 | 4105.33 | 9655.14 | 7452.61 | 8258.91 | 3392.76 | 6409.56 | 1929.41 | 4513.66 | 7474.87 | 7396.53 | 7477.46 | 5472 | 5029.81 | 3911.07 | 4606.24 | 5649.09 | 189193.83 | TOTAL CASH ON HAND
 | LESS:DRAWER | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 9300 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 3331.14 | 6721.07 | 8120.41 | 5294.44 | 8346.82 | 2948.75 | 8955.42 | 3454.89 | 6905.17 | 6067.78 | 6954.87 | 7293.21 | 6001.03 | 5934.72 | 5629.66 | 3805.33 | 9355.14 | 7152.61 | 7958.91 | 3092.76 | 6109.56 | 1629.41 | 4213.66 | 7174.87 | 7096.53 | 7177.46 | 5172 | 4729.81 | 3611.07 | 4306.24 | 5349.09 | 179893.83 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 3331.1 | 6720.220000000001 | 8116.54 | 5292.22 | 8352.63 | 2947.940000000001 | 8948.84 | 3456.94 | 6900.629999999999 | 6064.490000000001 | 6955.36 | 7292.260000000001 | 5995.470000000002 | 5930.889999999999 | 5627.199999999999 | 3805.93 | 9345.870000000003 | 7152.039999999999 | 7957.08 | 3097.800000000001 | 6110.04 | 1629.41 | 4207.89 | 7167.679999999999 | 7097.160000000001 | 7171.809999999999 | 5166.8 | 4725.1 | 3607.340000000001 | 4304.66 | 5356.74 | 179836.08 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 0.03999999999950887 | 0.8499999999985448 | 3.869999999999891 | 2.219999999999345 | -5.809999999999491 | 0.8099999999994907 | 6.579999999999927 | -2.050000000000182 | 4.540000000000873 | 3.289999999999054 | -0.4899999999997817 | 0.9499999999989086 | 5.559999999997672 | 3.830000000000837 | 2.460000000000946 | -0.6000000000003638 | 9.269999999996799 | 0.5700000000006185 | 1.829999999999927 | -5.040000000000873 | -0.4799999999995634 | 0 | 5.769999999999527 | 7.190000000000509 | -0.6300000000010186 | 5.650000000000546 | 5.199999999999818 | 4.710000000000036 | 3.729999999999563 | 1.579999999999927 | -7.649999999999636 | 57.74999999999136 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 3331.14 | 6721.07 | 8120.41 | 5294.44 | 8346.82 | 2948.75 | 8955.42 | 3454.89 | 6905.17 | 6067.78 | 6954.87 | 7293.21 | 6001.03 | 5934.72 | 5629.66 | 3805.33 | 9355.14 | 7152.61 | 7958.91 | 3092.76 | 6109.56 | 1629.41 | 4213.66 | 7174.87 | 7096.53 | 7177.46 | 5172 | 4729.81 | 3611.07 | 4306.24 | 5349.09 | 179893.83 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 2802.96 | 5161.61 | 6281.28 | 3455.9 | 5580.48 | 2381.4 | 5714.06 | 1693.22 | 4680.05 | 5519.78 | 5397.16 | 6840.96 | 5554.21 | 4872.47 | 4044.3 | 2859.11 | 6277.75 | 5516.79 | 4485.31 | 2721.66 | 5081.16 | 874.75 | 3654.99 | 5247.21 | 5229.06 | 5832.93 | 4202.47 | 3876.87 | 3067.84 | 3863.09 | 4055.47 | 136826.3 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 528.1799999999998 | 1559.46 | 1839.13 | 1838.54 | 2766.34 | 567.3499999999999 | 3241.36 | 1761.67 | 2225.12 | 548 | 1557.71 | 452.25 | 446.8199999999997 | 1062.25 | 1585.36 | 946.2199999999998 | 3077.389999999999 | 1635.82 | 3473.599999999999 | 371.1000000000004 | 1028.400000000001 | 754.6600000000001 | 558.6700000000001 | 1927.66 | 1867.469999999999 | 1344.53 | 969.5299999999997 | 852.9400000000005 | 543.23 | 443.1499999999996 | 1293.62 | 43067.52999999997 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $393.76 refund
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from safe comp.