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

 | CASH RECEIPTS - 2008
 |  | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY | JANUARY
 |  | 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 | 70 | 1807.92 | 1170 | 3450.94 | 4145 | 5180 | 3770 | 5145.37 | 6924.75 | 4673.77 | 4151.33 | 4179.58 | 5210.98 | 2488.3 | 3455.28 | 4978.94 | 1851.1 | 4974.29 | 5005.25 | 3346.03 | 4191.15 | 3682.15 | 5331.72 | 4299.26 | 4262.59 | 5152.59 | 5662.54 | 4117.18 | 3027.32 | 3826.45 | 3636.82 | 123168.6 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 0 | 0 | 40 | 200 | 0 | 200 | 150 | 25 | 75 | 0 | 150 | 0 | 125 | 40 | 162 | 707.98 | 403.22 | 183.64 | 20 | 0 | 0 | 125 | 0 | 175 | 100 | 0 | 75 | 165 | 512 | 125 | 873.56 | 4632.4 | 9 HOLES PUBLIC
 | MEMBER CART | 210.28 | 638.78 | 46.72 | 1814.43 | 418.47 | 1130.14 | 987.8 | 978.58 | 185.49 | 371.44 | 821.79 | 441.99 | 23.36 | 280.34 | 148.57 | 222.44 | 268.66 | 651.45 | 310.55 | 0 | 890.15 | 504.63 | 491.72 | 397.16 | 343.41 | 610.76 | 292.03 | 385.48 | 525.66 | 279.06 | 420.52 | 15091.86 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 0 | 160.42 | 100 | 175 | 120 | 150 | 175 | 50 | 866.22 | 868.92 | 475 | 40 | 0 | 380.2 | 0 | 205 | 0 | 725 | 440 | 75 | 420 | 552 | 707.14 | 821.86 | 985.2 | 450 | 420 | 380 | 320 | 1015 | 193.64 | 11270.6 | 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 | 10 | 10.5 | 15 | 19.75 | 20 | 28 | 30.25 | 35.25 | 20.25 | 19.52 | 18.76 | 10.5 | 33 | 18.5 | 4.5 | 7 | 12.75 | 22.75 | 12.5 | 26.75 | 3.74 | 12.75 | 7.5 | 15.5 | 20.65 | 28.75 | 30.55 | 13.5 | 3.5 | 18 | 12 | 541.97 | TOURNAMENT
 | MEMBER GUEST | 0 | 0 | 0 | 0 | 90 | 60 | 0 | 63.55 | 0 | 0 | 440.7 | 0 | 0 | 0 | 0 | 0 | 0 | 860.66 | 42.99 | 0 | 0 | 0 | 0 | 0 | 641.81 | 0 | 0 | 0 | 0 | 0 | 0 | 2199.71 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 0 | 717 | 0 | 0 | 0 | 0 | 128.32 | 641.62 | 0 | 0 | 0 | 1218.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2705.59 | 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 | 16 | 9.88 | 64 | 213.15 | 75.8 | 59.54 | 8.5 | 55.26 | 81.79 | 30.47 | 24.43 | 194.67 | 83.46 | 17.22 | 46.92 | 31.39 | 257.99 | 98.09 | 29.73 | 5.84 | 31.92 | 96.97 | 95.3 | 139.96 | 12.47 | 50.51 | 122.76 | 56.46 | 73 | 131.96 | 20 | 2235.44 | MERCHANDISE
 | RENTAL CLUBS | 0 | 14.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 7.01 | 0 | 21.03 | 0 | 0 | 0 | 7 | 0 | 0 | 84.11 | RENTAL CLUBS
 | RANGE | 11.2 | 47.6 | 336.4 | 155.2 | 308.42 | 602.94 | 142.98 | 140 | 100.8 | 61.6 | 142.8 | 290 | 154 | 170.8 | 162.62 | 120.4 | 28 | 198.81 | 126 | 75.6 | 201 | 156.2 | 112.27 | 131.6 | 154.94 | 191.87 | 184.94 | 120.41 | 302.49 | 234.31 | 149.2 | 5315.399999999999 | 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 | 29 | 490.7 | 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 | 519.7 | [NAME]. SOLD - Pro
 | [NAME]. SOLD - Golf | 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 | 0 | 0 | 0 | 0 | 50 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 176 | 34 | 0 | 0 | 0 | 0 | 0 | 137 | 0 | 0 | 0 | 0 | 0 | 0 | 224 | 52 | 0 | 0 | 0 | 0 | 0 | 224 | 54 | 901 | 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 | 317.48 | 3435.12 | 2262.82 | 6028.469999999999 | 5177.690000000001 | 7410.620000000001 | 5392.849999999999 | 7134.63 | 8430.3 | 6087.760000000001 | 6224.81 | 6375.389999999999 | 5629.799999999999 | 3395.36 | 3979.89 | 6410.15 | 2821.719999999999 | 7714.690000000001 | 5987.02 | 3579.22 | 5744.969999999999 | 5129.7 | 6976.660000000002 | 6032.34 | 6542.099999999999 | 6484.48 | 6787.82 | 5238.03 | 4770.969999999999 | 5853.780000000001 | 5359.74 | 168716.38 | TOTAL
 | SALES TAX | 21.53 | 229.8 | 122.92 | 419.99 | 360.14 | 516.71 | 368.46 | 497.17 | 577.64 | 421.05 | 435.88 | 445.77 | 391.95 | 236.65 | 278.55 | 436.95 | 200.2 | 538.57 | 418.4 | 245.09 | 402.2 | 358.29 | 471.22 | 417.73 | 457.56 | 450.98 | 472.04 | 365.87 | 327.07 | 391.71 | 332.99 | 11611.08 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 339.01 | 3664.92 | 2385.74 | 6448.459999999999 | 5537.830000000001 | 7927.330000000001 | 5761.309999999999 | 7631.8 | 9007.939999999999 | 6508.810000000001 | 6660.690000000001 | 6821.16 | 6021.749999999999 | 3632.01 | 4258.440000000001 | 6847.099999999999 | 3021.919999999999 | 8253.26 | 6405.419999999999 | 3824.31 | 6147.169999999999 | 5487.99 | 7447.880000000002 | 6450.07 | 6999.66 | 6935.460000000001 | 7259.86 | 5603.9 | 5098.039999999999 | 6245.490000000001 | 5692.73 | 180327.46 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem Pro | 0 | 0 | 0 | 219.15 | 0 | 0 | 0 | 19.49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32.1 | 0 | 0 | 0 | 20.33 | 0 | 0 | 0 | 130.2 | 0 | 0 | 0 | 36.38 | 0 | 457.65 | Less: [NAME]. Redeem Pro
 | LESS: [NAME]. Redeem Golf | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41.8 | 0 | 0 | 0 | 0 | 0 | 35.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100.4 | 0 | 0 | 0 | 0 | 177.5 | Less: [NAME]. Redeem Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 0 | 0 | 4.82 | 80.9 | 0 | 0 | 20.87 | 0 | 0 | 54.48 | 0 | 0 | 0 | 0 | 181.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 343.06 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 0 | 489.45 | 757.8 | 1178.04 | 1045 | 50.78 | 301.66 | 1175.27 | 1237.4 | 332.15 | 426.27 | 0 | 81.07 | 671.14 | 671.36 | 1226.61 | 883.65 | 829.18 | 0 | 0 | 405.44 | 119.64 | 773.19 | 626.14 | 396.08 | 11.76 | 396.69 | 715.15 | 832.37 | 1595 | 1127.72 | 18356.01 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 339.01 | 3175.47 | 1627.94 | 5051.27 | 4488.010000000001 | 7795.650000000001 | 5459.65 | 6437.040000000001 | 7749.669999999998 | 6176.660000000002 | 6234.42 | 6766.68 | 5898.879999999999 | 2960.87 | 3587.08 | 5620.49 | 1956.279999999999 | 7391.98 | 6370.119999999999 | 3824.31 | 5741.73 | 5348.02 | 6674.690000000002 | 5823.929999999999 | 6603.58 | 6793.500000000001 | 6762.77 | 4888.75 | 4265.669999999999 | 4614.110000000001 | 4565.009999999999 | 160993.24 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 639.01 | 3534.5 | 1929.92 | 5352.65 | 4788.51 | 8100 | 5762.86 | 6737.77 | 8050.89 | 6491.33 | 6537.43 | 7066.05 | 6199.21 | 3267.82 | 3887.48 | 5927.91 | 2256.71 | 7692.29 | 6670.12 | 4123.31 | 6043.98 | 5652.74 | 6979.81 | 6125.71 | 6904.5 | 7098.86 | 7066.55 | 5194.12 | 4564.5 | 4918.26 | 4863 | 170427.8 | 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 | 339.01 | 3234.5 | 1629.92 | 5052.65 | 4488.51 | 7800 | 5462.86 | 6437.77 | 7750.89 | 6191.33 | 6237.43 | 6766.05 | 5899.21 | 2967.82 | 3587.48 | 5627.91 | 1956.71 | 7392.29 | 6370.12 | 3823.31 | 5743.98 | 5352.74 | 6679.81 | 5825.71 | 6604.5 | 6798.86 | 6766.55 | 4894.12 | 4264.5 | 4618.26 | 4563 | 161127.8 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 339.01 | 3175.47 | 1627.94 | 5051.27 | 4488.010000000001 | 7795.650000000001 | 5459.65 | 6437.040000000001 | 7749.669999999998 | 6176.660000000002 | 6234.42 | 6766.68 | 5898.879999999999 | 2960.87 | 3587.08 | 5620.49 | 1956.279999999999 | 7391.98 | 6370.119999999999 | 3824.31 | 5741.73 | 5348.02 | 6674.690000000002 | 5823.929999999999 | 6603.58 | 6793.500000000001 | 6762.77 | 4888.75 | 4265.669999999999 | 4614.110000000001 | 4565.009999999999 | 160993.24 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 0 | 59.02999999999975 | 1.980000000000246 | 1.380000000000109 | 0.4999999999990905 | 4.349999999998545 | 3.210000000000036 | 0.7299999999995634 | 1.220000000002074 | 14.66999999999825 | 3.010000000000218 | -0.6300000000001091 | 0.3300000000008367 | 6.949999999999818 | 0.3999999999996362 | 7.420000000000073 | 0.4300000000007458 | 0.3100000000004002 | 0 | -1 | 2.25 | 4.720000000000255 | 5.119999999998072 | 1.780000000000655 | 0.9200000000000728 | 5.359999999998763 | 3.779999999999745 | 5.369999999999891 | -1.169999999999163 | 4.149999999999636 | -2.009999999999309 | 134.5599999999979 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 339.01 | 3234.5 | 1629.92 | 5052.65 | 4488.51 | 7800 | 5462.86 | 6437.77 | 7750.89 | 6191.33 | 6237.43 | 6766.05 | 5899.21 | 2967.82 | 3587.48 | 5627.91 | 1956.71 | 7392.29 | 6370.12 | 3823.31 | 5743.98 | 5352.74 | 6679.81 | 5825.71 | 6604.5 | 6798.86 | 6766.55 | 4894.12 | 4264.5 | 4618.26 | 4563 | 161127.8 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 299.9 | 3008.55 | 1135.99 | 4584.34 | 3415.51 | 5111.04 | 3779.64 | 5623.22 | 6621.49 | 4031.8 | 4452.14 | 3978.19 | 3831.21 | 2879.51 | 2951.47 | 5299.36 | 1930.26 | 4730.57 | 4074.82 | 2433.27 | 4420.69 | 3731.74 | 5613.46 | 4798.86 | 5261.35 | 4880.36 | 4467.85 | 4233.57 | 3326.42 | 4448.33 | 4312.52 | 123667.43 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 39.11000000000001 | 225.9499999999998 | 493.9300000000001 | 468.3099999999995 | 1073 | 2688.96 | 1683.22 | 814.5500000000002 | 1129.400000000001 | 2159.53 | 1785.29 | 2787.86 | 2068 | 88.30999999999995 | 636.0100000000002 | 328.5500000000002 | 26.45000000000005 | 2661.72 | 2295.3 | 1390.04 | 1323.29 | 1621 | 1066.35 | 1026.85 | 1343.15 | 1918.5 | 2298.7 | 660.5500000000002 | 938.0799999999999 | 169.9300000000003 | 250.4799999999996 | 37460.36999999995 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =