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

 | CASH RECEIPTS - 2008
 |  | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL | APRIL |  | APRIL
 |  | 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
 | 18 HOLES PUBLIC | 3574.45 | 2203.7 | 4566.69 | 2585.35 | 1073.47 | 3799.81 | 1962.74 | 3064.22 | 2494.99 | 3648.73 | 2817.56 | 798.31 | 770.11 | 2041.34 | 1749.25 | 2355.02 | 1841.36 | 1387.67 | 327 | 870 | 2121 | 855.46 | 742.81 | 1500.28 | 447.25 | 789 | 790 | 514 | 422.2 | 922.07 | 0 | 53035.83999999999 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 271 | 200 | 0 | 75 | 0 | 0 | 170 | 0 | 0 | 75 | 9.81 | 75 | 95 | 157 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 180 | 0 | 0 | 5 | 0 | 0 | 0 | 144 | 32.94 | 0 | 1539.75 | 9 HOLES PUBLIC
 | MEMBER CART | 417.25 | 173.79 | 128.48 | 310.21 | 669.36 | 208.39 | 215.4 | 647.65 | 191.08 | 315.38 | 732.18 | 508.05 | 164.85 | 239.67 | 354.64 | 238.29 | 432.2 | 445.74 | 453.17 | 46.72 | 444.34 | 385.48 | 113.06 | 116.8 | 781.96 | 302.83 | 29.43 | 175.66 | 74.28 | 47.18 | 0 | 9363.520000000004 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 888.95 | 641.07 | 250 | 570 | 535 | 585 | 25 | 348 | 426.07 | 540.28 | 660 | 665 | 725 | 108 | 515 | 744.76 | 702.81 | 320 | 495 | 580 | 445 | 445 | 549.76 | 160 | 80 | 300 | 360 | 340 | 260 | 152 | 0 | 13416.7 | 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 | 92 | 0 | 0 | 60 | 91 | 193 | 50.55 | 486.31 | 618 | 47.27 | 501 | 916.03 | 1044 | 20 | 800 | 265 | 490 | 548 | 810 | 1267 | 280 | 536 | 588 | 936 | 1176 | 1409 | 1236 | 1125 | 1961 | 560 | 0 | 18106.16 | BIG SUMMER CARD
 | TOURNAMENT | 12 | 21 | 18.5 | 16.5 | 29.93 | 39.5 | 6 | 13.5 | 25 | 27.15 | 20.5 | 32.75 | 28.5 | 10.5 | 7.5 | 25.5 | 23 | 21.6 | 13 | 30.51 | 21.35 | 16.75 | 13 | 21 | 15.25 | 58.25 | 51.25 | 22 | 25 | 9.5 | 0 | 675.7900000000001 | TOURNAMENT
 | MEMBER GUEST | 32.85 | 0 | 0 | 432.99 | 175 | 140 | 0 | 0 | 0 | 0 | 475 | 380 | 420 | 0 | 0 | 0 | 0 | 105 | 532.1 | 0 | 0 | 0 | 0 | 0 | 115 | 0 | 0 | 0 | 0 | 0 | 0 | 2807.94 | 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 | 300 | 0 | 300 | 900 | 0 | 1500 | 600 | 300 | 0 | 3900 | 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 | 22.5 | 124.93 | 14 | 303.89 | 158.38 | 61.42 | 142.9 | 280.4 | 50.88 | 174.42 | 110.26 | 98.8 | 56 | 51 | 141.44 | 273.84 | 49.76 | 185.43 | 82.53 | 180.77 | 253.41 | 55.46 | 282.5 | 215.46 | 91.75 | 295.95 | 133.95 | 161.52 | 63.93 | 10.5 | 0 | 4127.98 | MERCHANDISE
 | RENTAL CLUBS | 0 | 0 | 14.02 | 14.02 | 7.01 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 14.02 | 0 | 0 | 7.01 | 7.01 | 14.02 | 0 | 14.02 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 0 | 0 | 0 | 0 | 105.14 | RENTAL CLUBS
 | RANGE | 93.35 | 163.36 | 89.7 | 182.03 | 130.81 | 199.64 | 59.74 | 70.01 | 102.68 | 115.74 | 145.55 | 97.07 | 233.21 | 116.68 | 48.54 | 124.15 | 74.67 | 87.75 | 150.41 | 197.84 | 84.03 | 96.14 | 114.82 | 58.81 | 57.87 | 137.88 | 97.62 | 56.03 | 51.34 | 65.34 |  | 3302.810000000001 | 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 | 0 | 0 | 37.38 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 66.38 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 45 | 0 | 78 | 0 | 0 | 0 | 0 | 45 | 44 | 0 | 0 | 0 | 0 | 0 | 109 | 36 | 0 | 0 | 0 | 0 | 0 | 121 | 32 | 0 | 0 | 0 | 0 | 0 | 24 |  | 534 | 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 | 5404.35 | 3572.85 | 5081.389999999999 | 4627.990000000001 | 2907.34 | 5255.76 | 2639.33 | 4910.09 | 3953.7 | 4987.97 | 5471.86 | 3571.01 | 3550.69 | 2744.19 | 3616.37 | 4142.57 | 3706.81 | 3115.21 | 2863.21 | 3186.860000000001 | 3649.13 | 2570.29 | 2824.95 | 3040.35 | 3077.09 | 4192.91 | 2698.25 | 3894.21 | 3601.75 | 2123.53 | 0 | 110982.01 | TOTAL
 | SALES TAX | 375.92 | 242.91 | 354.78 | 317.6 | 200.25 | 361.17 | 182.04 | 346.42 | 272.02 | 344.52 | 381.83 | 244.18 | 244.02 | 191.53 | 252.71 | 279.37 | 255.55 | 213.92 | 195.12 | 218.9 | 247.98 | 178.91 | 188.17 | 209.18 | 214.47 | 287.37 | 184.88 | 265.15 | 246.97 | 144.66 |  | 7642.499999999999 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 5780.27 | 3815.76 | 5436.169999999999 | 4945.590000000001 | 3107.59 | 5616.93 | 2821.37 | 5256.51 | 4225.719999999999 | 5332.49 | 5853.69 | 3815.19 | 3794.71 | 2935.72 | 3869.08 | 4421.94 | 3962.360000000001 | 3329.13 | 3058.33 | 3405.760000000001 | 3897.11 | 2749.2 | 3013.12 | 3249.53 | 3291.56 | 4480.28 | 2883.13 | 4159.36 | 3848.72 | 2268.19 | 0 | 118624.51 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem - Pro | 71.5 | 70.41 | 10 | 173.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 24.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 399.93 | Less: [NAME]. Redeem - Pro
 | LESS: [NAME]. Redeem - Golf | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 13 | 0 | 225.98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 262.98 | Less: [NAME]. Redeem - Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 0 | 0 | 29.92 | 0 | 146.87 | 214.22 | 0 | 66.34 | 16.05 | 19.08 | 17.11 | 0 | 0 | 134.82 | 16.36 | 116.51 | 29.25 | 67.42 | 0 | 0 | 291.58 | 144.45 | 54.37 | 285.16 | 61.61 | 99.56 | 50 | 0 |  | 1860.68 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 512.64 | 765.19 | 963.17 | 515.32 | 771.4 | 0 | 248.81 | 1411.57 | 601.56 | 1305.45 | 1499.69 | 740.93 | 924.83 | 422.5 | 877.5 | 1665.03 | 1097.04 | 570.5 | 0 | 37.61 | 207.93 | 867.75 | 949.7 | 1005.07 | 352.74 | 341.82 | 0 | 642.35 | 419.87 | 140.99 | 0 | 19858.96 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 5196.13 | 2980.16 | 4462.999999999999 | 4256.330000000002 | 2306.27 | 5616.93 | 2425.69 | 3630.72 | 3624.159999999999 | 3960.7 | 4337.949999999999 | 3055.18 | 2852.77 | 2513.22 | 2991.58 | 2598.09 | 2848.96 | 2642.119999999999 | 2966.08 | 3300.73 | 3463.2 | 1857.37 | 1771.84 | 2100.01 | 2884.45 | 3853.3 | 2821.52 | 3417.45 | 3378.85 | 2127.2 | 0 | 96241.96000000002 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 5497.46 | 3281.18 | 4763.87 | 4558.4 | 2599.72 | 5928.19 | 2720.79 | 3933.04 | 3932 | 4261.66 | 4657.83 | 3355.1 | 3153.84 | 2813.81 | 3291.74 | 2885.81 | 3145.64 | 2949.16 | 3269.08 | 3606.7 | 3762.91 | 2161.83 | 2075.88 | 2389.75 | 3185.92 | 4152.55 | 3121.52 | 3727.04 | 3683.3 | 2424.33 | 0 | 105290.05 | 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 | 0 | 9000 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 5197.46 | 2981.18 | 4463.87 | 4258.4 | 2299.72 | 5628.19 | 2420.79 | 3633.04 | 3632 | 3961.66 | 4357.83 | 3055.1 | 2853.84 | 2513.81 | 2991.74 | 2585.81 | 2845.64 | 2649.16 | 2969.08 | 3306.7 | 3462.91 | 1861.83 | 1775.88 | 2089.75 | 2885.92 | 3852.55 | 2821.52 | 3427.04 | 3383.3 | 2124.33 | 0 | 96290.05 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 5196.13 | 2980.16 | 4462.999999999999 | 4256.330000000002 | 2306.27 | 5616.93 | 2425.69 | 3630.72 | 3624.159999999999 | 3960.7 | 4337.949999999999 | 3055.18 | 2852.77 | 2513.22 | 2991.58 | 2598.09 | 2848.96 | 2642.119999999999 | 2966.08 | 3300.73 | 3463.2 | 1857.37 | 1771.84 | 2100.01 | 2884.45 | 3853.3 | 2821.52 | 3417.45 | 3378.85 | 2127.2 | 0 | 96241.95999999998 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 1.329999999999927 | 1.019999999999982 | 0.8700000000008004 | 2.06999999999789 | -6.550000000000182 | 11.25999999999931 | -4.900000000000091 | 2.319999999999709 | 7.8400000000006 | 0.9600000000000364 | 19.88000000000102 | -0.08000000000038199 | 1.070000000000164 | 0.5899999999996908 | 0.1599999999998545 | -12.2800000000002 | -3.320000000000618 | 7.040000000000418 | 3 | 5.969999999999345 | -0.2900000000004184 | 4.460000000000036 | 4.039999999999736 | -10.25999999999976 | 1.470000000000255 | -0.7499999999995453 | 0 | 9.590000000000146 | 4.450000000000273 | -2.869999999999891 | 0 | 48.0899999999981 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 5197.46 | 2981.18 | 4463.87 | 4258.4 | 2299.72 | 5628.19 | 2420.79 | 3633.04 | 3632 | 3961.66 | 4357.83 | 3055.1 | 2853.84 | 2513.81 | 2991.74 | 2585.81 | 2845.64 | 2649.16 | 2969.08 | 3306.7 | 3462.91 | 1861.83 | 1775.88 | 2089.75 | 2885.92 | 3852.55 | 2821.52 | 3427.04 | 3383.3 | 2124.33 | 0 | 96290.05 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 3755.76 | 2588.33 | 3660.07 | 3540 | 902.39 | 2475.86 | 1916.07 | 3606.29 | 3008.3 | 3661.41 | 3892.41 | 2366.25 | 1839.06 | 1757.68 | 2571.69 | 2285.96 | 2722.3 | 1984.06 | 1759.38 | 1853.41 | 2157.25 | 1747.77 | 1755.33 | 1889.95 | 2346.57 | 2990.95 | 1801.37 | 3019.09 | 2225.49 | 1430.75 | 0 | 73511.2 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 1441.7 | 392.8499999999999 | 803.7999999999997 | 718.3999999999996 | 1397.33 | 3152.329999999999 | 504.72 | 26.75 | 623.6999999999998 | 300.25 | 465.4200000000001 | 688.8499999999999 | 1014.78 | 756.1299999999999 | 420.0499999999997 | 299.8499999999999 | 123.3399999999997 | 665.0999999999999 | 1209.7 | 1453.29 | 1305.66 | 114.0599999999999 | 20.55000000000018 | 199.8 | 539.3499999999999 | 861.6000000000004 | 1020.15 | 407.9499999999998 | 1157.81 | 693.5799999999999 | 0 | 22778.85000000001 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $85.33 Premium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assignment