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

 | CASH RECEIPTS - 2008
 |  | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER
 |  | 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 | 1041 | 1776.01 | 2070.7 | 2139.52 | 2288.63 | 596.13 | 854.38 | 1484.7 | 1960.3 | 1383.5 | 1986.03 | 762.61 | 490.8 | 667.6 | 1237.62 | 1531.02 | 993.7 | 1077 | 917 | 1794.43 | 686.01 | 1052 | 2128.03 | 1523 | 758 | 2802 | 2163 | 2535.31 | 2242 | 2402.32 | 3209.11 | 48553.45999999999 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 165 | 60 | 95 | 18 | 80 | 160 | 0 | 120 | 115 | 35 | 0 | 129.77 | 140 | 100 | 120 | 45 | 75 | 30 | 0 | 40 | 135 | 135 | 0 | 0 | 0 | 0 | 0 | 120 | 15 | 0 | 80 | 2012.77 | 9 HOLES PUBLIC
 | MEMBER CART | 627.07 | 335.65 | 534.46 | 327.24 | 710.88 | 785.14 | 46.76 | 265.52 | 323.97 | 245.42 | 200 | 613.02 | 431.62 | 161.72 | 516.5 | 472.59 | 154.61 | 303.86 | 612.74 | 474.5 | 31.8 | 475.81 | 432.39 | 375.06 | 46.76 | 365.92 | 493.68 | 93.52 | 252.29 | 137 | 417.42 | 11264.92 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 90 | 45 | 160 | 255 | 565 | 100 | 0 | 20 | 268.01 | 332 | 0 | 325 | 0 | 0 | 15 | 150 | 200 | 533.6 | 375 | 0 | 450 | 255 | 435 | 60 | 0 | 585 | 45 | 0 | 615 | 450 | 0 | 6328.610000000001 | 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 | 86.4 | 26.1 | 0 | 0 | 1163.7 | 1401.3 | 0 | 0 | 26.1 | 0 | 0 | 670.5 | 809.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11385.43 | 15570.45 | BIG SUMMER CARD
 | SNACK BAR | 4.25 | 4 | 64.5 | 25.89 | 23.5 | 27.27 | 20.75 | 4.5 | 0 | 5.75 | 1 | 9.19 | 7.3 | 19.25 | 12.51 | 17.5 | 8.5 | 16.8 | 18.25 | 35.91 | 33 | 17 | 5.5 | 10.5 | 8 | 42.57 | 37.65 | 45.25 | 40.5 | 15 | 22 | 603.5899999999999 | TOURNAMENT
 | MEMBER GUEST | 11 | 0 | 52 | 0 | 0 | 266 | 157 | 0 | 0 | 0 | 0 | 197.2 | 44 | 91 | 0 | 0 | 0 | 0 | 0 | 108 | 133 | 0 | 0 | 0 | 0 | 0 | 384 | 144 | 0 | 0 | 0 | 1587.2 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2616.84 | 0 | 0 | 0 | 128.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2745.14 | ANNUAL DUES SINGLE
 | ANNUAL DUES FAMILY | 0 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13738.34 | 0 | 1962.62 | 0 | 0 | 0 | 1962.62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1962.62 | 0 | 0 | 0 | 0 | 20226.2 | 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 | 44.96 | 7.47 | 1 | 49.94 | 67.07 | 92.47 | 1.25 | 0 | 9.47 | 70.41 | 52 | 113.27 | 78.79 | 73.27 | 20.23 | 136.48 | 12 | 0.94 | 21.22 | 80.7 | 56.98 | 49.02 | 138.95 | 58 | 0 | 84.44 | 139.18 | 68.91 | 52.38 | 177.67 | 6.99 | 1765.46 | MERCHANDISE
 | RENTAL CLUBS | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 7.01 | 0 | 0 | 7.01 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 0 | 7.01 | 7.01 | 28.04 | 35.05 | 14.02 | 7.01 | 14.02 | 0 | 0 | 140.2 | RENTAL CLUBS
 | RANGE | 30.86 | 52.35 | 100.95 | 44.85 | 273.38 | 60.77 | 116.16 | 79.49 | 93.44 | 52.34 | 23.37 | 39.26 | 65.99 | 65.48 | 228.08 | 46.73 | 80.39 | 112.17 | 72.01 | 78.56 | 97.54 | 119.64 | 62.61 | 92.56 | 5.61 | 138.15 | 105.39 | 192.84 | 93.48 | 180.45 | 89.73 | 2894.63 | 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 | 93.46 | 0 | 130.1 | 0 | 0 | 0 | 32.72 | 0 | 30 | 0 | 0 | 0 | 191.44 | 154.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 631.93 | [NAME]. SOLD - Pro
 | [NAME]. SOLD - Golf | 0 | 46.73 | 0 | 0 | 100 | 0 | 467.29 | 0 | 0 | 0 | 0 | 0 | 37.39 | 0 | 0 | 0 | 108 | 0 | 0 | 37.39 | 174.08 | 0 | 0 | 174.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1145.65 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 0 | 292 | 36 | 0 | 93.46 | 0 | 0 | 0 | 127 | 0 | 0 | 0 | 0 | 0 | 0 | 120 | 46 | 0 | 0 | 0 | 0 | 0 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 108 | 912.46 | 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 | 2014.14 | 3013.61 | 3396.71 | 2896.44 | 4108.460000000001 | 3344.94 | 3071.9 | 1974.21 | 2770.190000000001 | 16116.33 | 4879.24 | 4282.040000000001 | 1973.4 | 1987.74 | 2278.24 | 4394.659999999999 | 1752.2 | 2150.37 | 2023.23 | 2649.49 | 1797.41 | 2294.91 | 3365.2 | 2390.9 | 846.41 | 4053.130000000001 | 5344.540000000001 | 3206.84 | 3324.67 | 3362.44 | 15318.68 | 116382.67 | TOTAL
 | SALES TAX | 140.5 | 210.48 | 216.81 | 198.07 | 278.62 | 228.29 | 209.37 | 137.62 | 193.55 | 1118.62 | 327.42 | 293.16 | 133.33 | 132.59 | 158.34 | 306.08 | 112.1 | 145.9 | 140.12 | 182.64 | 117.05 | 159.24 | 234.95 | 159.42 | 58.65 | 279.56 | 366.99 | 216.63 | 229.73 | 234.08 | 265.97 | 7185.879999999999 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 2154.64 | 3224.09 | 3613.52 | 3094.51 | 4387.080000000001 | 3573.23 | 3281.27 | 2111.83 | 2963.740000000001 | 17234.95 | 5206.66 | 4575.200000000001 | 2106.73 | 2120.33 | 2436.58 | 4700.739999999999 | 1864.3 | 2296.27 | 2163.35 | 2832.13 | 1914.46 | 2454.15 | 3600.15 | 2550.32 | 905.06 | 4332.690000000001 | 5711.530000000001 | 3423.47 | 3554.4 | 3596.52 | 15584.65 | 123568.55 | TOTAL RECEIPTS
 | LESS:GiftCert.Redeem-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 | LESS: [NAME]. Redeemed - Pro
 | LESS:[NAME].Redeem-Golf | 16.05 | 64.2 | 0 | 0 | 0 | 0 | 0 | 21.4 | 0 | 0 | 0 | 0 | 42.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.05 | 0 | 0 | 0 | 0 | 0 | 64.2 | 173.66 | 0 | 212.93 | 0 | 611.29 | LESS: [NAME]. Redeem - Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 0 | 11.77 | 46.22 | 51.99 | 0 | 0 | 9.63 | 75.33 | 33.7 | 50.06 | 40.68 | 0 | 17.93 | 118.77 | 12.84 | 0 | 0 | 22.14 | 30 | 36.59 | 113.42 | 0 | 0 | 20 | 28.89 | 33.7 | 68.48 | 143.59 | 0 | 965.73 | LESS: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 137.04 | 808.64 | 1117.74 | 721.33 | 150.35 | 57.75 | 191.3 | 83.06 | 828 | 727.67 | 0 | 556.85 | 965.11 | 515.11 | 698.24 | 639.87 | 674.4 | 1129.28 | 813.33 | 146.75 | 181.12 | 601.23 | 237.38 | 475.01 | 0 | 0 | 931.57 | 0 | 581.5 | 1138.85 | 1120.11 | 16228.59 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 2001.55 | 2351.25 | 2495.78 | 2361.41 | 4190.51 | 3463.49 | 3089.97 | 2007.37 | 2126.110000000001 | 16431.95 | 5172.96 | 3968.29 | 1058.14 | 1605.22 | 1720.41 | 3942.099999999999 | 1177.06 | 1166.99 | 1350.02 | 2663.24 | 1687.29 | 1816.329999999999 | 3249.35 | 2075.31 | 905.06 | 4312.690000000001 | 4686.870000000001 | 3216.110000000001 | 2904.42 | 2101.15 | 14464.54 | 105762.94 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 2305.12 | 2650.42 | 2796.29 | 2663.82 | 4494.69 | 3766.11 | 3386.68 | 2313.92 | 2386.62 | 16737.92 | 5474.8 | 4270.17 | 1352.7 | 1905.22 | 2025.5 | 4246.52 | 1480.18 | 1468.92 | 1650.02 | 2967.01 | 1987.66 | 2119.56 | 3552.24 | 2375.92 | 1205.24 | 4615.94 | 4994.06 | 3517.33 | 3205.86 | 2405.18 | 14769.13 | 115090.75 | 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 | 2005.12 | 2350.42 | 2496.29 | 2363.82 | 4194.69 | 3466.11 | 3086.68 | 2013.92 | 2086.62 | 16437.92 | 5174.8 | 3970.17 | 1052.7 | 1605.22 | 1725.5 | 3946.52 | 1180.18 | 1168.92 | 1350.02 | 2667.01 | 1687.66 | 1819.56 | 3252.24 | 2075.92 | 905.24 | 4315.94 | 4694.06 | 3217.33 | 2905.86 | 2105.18 | 14469.13 | 105790.75 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 2001.55 | 2351.25 | 2495.78 | 2361.41 | 4190.51 | 3463.49 | 3089.97 | 2007.37 | 2126.110000000001 | 16431.95 | 5172.96 | 3968.29 | 1058.14 | 1605.22 | 1720.41 | 3942.099999999999 | 1177.06 | 1166.99 | 1350.02 | 2663.24 | 1687.29 | 1816.329999999999 | 3249.35 | 2075.31 | 905.06 | 4312.690000000001 | 4686.870000000001 | 3216.110000000001 | 2904.42 | 2101.15 | 14464.54 | 105762.94 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 3.569999999999709 | -0.8299999999999272 | 0.5100000000002183 | 2.409999999999854 | 4.179999999999382 | 2.619999999999891 | -3.289999999999964 | 6.550000000000182 | -39.49000000000069 | 5.969999999997526 | 1.840000000000146 | 1.879999999999654 | -5.439999999999827 | 0 | 5.089999999999918 | 4.420000000001892 | 3.120000000000118 | 1.930000000000064 | 0 | 3.770000000000437 | 0.3700000000001182 | 3.230000000000473 | 2.889999999999873 | 0.6099999999996726 | 0.1800000000000637 | 3.249999999999091 | 7.1899999999996 | 1.219999999999345 | 1.440000000000055 | 4.029999999999745 | 4.590000000000146 | 27.80999999999676 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 2005.12 | 2350.42 | 2496.29 | 2363.82 | 4194.69 | 3466.11 | 3086.68 | 2013.92 | 2086.62 | 16437.92 | 5174.8 | 3970.17 | 1052.7 | 1605.22 | 1725.5 | 3946.52 | 1180.18 | 1168.92 | 1350.02 | 2667.01 | 1687.66 | 1819.56 | 3252.24 | 2075.92 | 905.24 | 4315.94 | 4694.06 | 3217.33 | 2905.86 | 2105.18 | 14469.13 | 105790.75 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 1534.19 | 2344.31 | 2003.03 | 1917.76 | 2718.24 | 1954.51 | 2203.83 | 1404.58 | 2069.07 | 14231.92 | 2316.05 | 3586.07 | 1018.99 | 1589.78 | 1557.86 | 1659.27 | 1165.13 | 1162.8 | 1307.73 | 1616.72 | 1175.36 | 1752.33 | 2276.42 | 1406.04 | 729.44 | 2537.44 | 4399.1 | 1951.55 | 2444.23 | 2094.95 | 2874.6 | 73003.3 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 470.9299999999998 | 6.110000000000127 | 493.26 | 446.0600000000002 | 1476.45 | 1511.6 | 882.8499999999999 | 609.3400000000001 | 17.54999999999973 | 2205.999999999998 | 2858.75 | 384.0999999999999 | 33.71000000000004 | 15.44000000000005 | 167.6400000000001 | 2287.25 | 15.04999999999995 | 6.120000000000118 | 42.28999999999996 | 1050.29 | 512.3000000000002 | 67.23000000000002 | 975.8199999999997 | 669.8800000000001 | 175.8 | 1778.5 | 294.96 | 1265.78 | 461.6300000000001 | 10.23000000000002 | 11594.53 | 32787.45 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day |  |  |  |  |  | $1754.95 pymt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | deposit missing |  |  |  |  |  | for cart damage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from 2007 breakin