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

 | CASH RECEIPTS - 2008
 |  | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER |  | NOVEMBER
 |  | 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 | 832.03 | 218 | 725 | 1448.5 | 1282 | 2823.26 | 1395.05 | 1353 | 2234.32 | 1634.8 | 2628.5 | 1102.3 | 1308.44 | 1685.3 | 888.89 | 1011.05 | 1434.1 | 1454.2 | 921.51 | 2743.98 | 2499.74 | 1057.68 | 1084.78 | 1564.22 | 1405.01 | 1624.41 | 1795.24 | 2456.42 | 1279.17 | 444.07 | 0 | 44334.96999999999 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 30 | 60 | 30 | 0 | 160 | 0 | 52.5 | 105 | 0 | 48.68 | 75 | 165 | 0 | 255 | 30 | 0 | 30 | 165 | 240 | 0 | 150 | 30 | 0 | 87 | 90 | 165 | 75 | 195 | 90 | 105 | 0 | 2433.18 | 9 HOLES PUBLIC
 | MEMBER CART | 896.3 | 303.72 | 761.63 | 844.34 | 593.87 | 280.34 | 642.23 | 953.07 | 136.42 | 652.3 | 338.74 | 535.47 | 408.84 | 233.6 | 479.22 | 70.14 | 443.99 | 487.07 | 217.21 | 268.79 | 163.66 | 420.78 | 385.54 | 266.45 | 315.55 | 591.08 | 292.18 | 425.78 | 564.76 | 38.34 | 0 | 13011.41 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 165 | 45 | 90 | 120 | 60 | 30 | 135.55 | 150 | 75 | 240 | 360 | 105 | 293.59 | 69 | 105 | 180 | 180 | 171.5 | 330 | 45 | 225 | 15 | 105 | 110 | 114 | 195 | 0 | 414 | 315 | 120 | 0 | 4562.639999999999 | 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 | 150 | 544 | 60 | 72 | 87 | 148 | 128 | 876.4 | 112.5 | 22.5 | 315 | 202.5 | 130.5 | 0 | 935.1 | 612.89 | 64.8 | 0 | 18.79 | 129.6 | 38 | 242.1 | 338.4 | 0 | 57 | 194.4 | 286.2 | 67.2 | 620.1 | 937.8 | 0 | 7390.780000000001 | BIG SUMMER CARD
 | SNACKS | 209.75 | 53.25 | 10.71 | 199.25 | 31.5 | 10 | 36.61 | 79.01 | 35.25 | 16 | 33.25 | 4.51 | 30.75 | 52 | 28.5 | 29 | 16.25 | 14 | 7 | 22.16 | 22 | 41.61 | 29.5 | 18.5 | 19 | 16.5 | 30 | 37 | 49.07 | 37 | 0 | 1218.93 | TOURNAMENT
 | MEMBER GUEST | 216 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 38 | 0 | 417 | 96 | 0 | 0 | 0 | 96 | 60 | 460 | 168 | 0 | 1585 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 0 | 0 | 1463 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 128.29 | 0 | 0 | 1010 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2601.29 | 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 | -608.01 | 0 | 0 | 0 | 0 | 0 | -608.01 | 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 | 17.46 | 56.1 | 16.35 | 12.5 | 43.95 | 6 | 71.47 | 0.92 | 63.96 | 17 | 5 | 49.46 | 180.95 | 100.83 | 26.46 | 6 | 6 | 79.74 | 17.38 | 34 | 2.35 | 73 | 55.67 | 108.92 | 28 | 21.39 | 100.37 | 33.74 | 0.46 | 50 | 0 | 1285.43 | MERCHANDISE
 | RENTAL CLUBS | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 7.01 | 7.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 0 | 14.02 | 0 | 7.01 | 0 | 0 | 0 | 6.56 | 7.5 | 0 | 14.02 | 0 | 7.01 | 0 | 84.65 | RENTAL CLUBS
 | RANGE | 80.4 | 42.01 | 58.81 | 29.87 | 38.28 | 170.05 | 191.53 | 266.88 | 203.66 | 42 | 98.96 | 205.23 | 21.47 | 57.87 | 75 | 209.38 | 55.11 | 43.9 | 57 | 301.03 | 64.48 | 217.89 | 96.31 | 136.45 | 57.08 | 41.13 | 73.14 | 86.92 | 77.99 | 61.72 | 0 | 3161.549999999999 | 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 | 74.77 | 0 | 0 | 0 | 0 | 74.77 | [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 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50
 | CREDIT BOOK SOLD | 0 | 0 | 0 | 0 | 0 | 48 | 0 | 0 | 0 | 0 | 0 | 115 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 219 | 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 | 2596.94 | 1322.08 | 3215.5 | 2726.46 | 2296.6 | 3522.660000000001 | 2652.94 | 3815.290000000001 | 2868.12 | 2673.28 | 3854.45 | 2494.47 | 2374.54 | 2581.89 | 2568.17 | 2118.46 | 3247.75 | 2415.41 | 1822.91 | 3616.559999999999 | 3172.24 | 2515.06 | 2191.2 | 2341.54 | 2092.2 | 2270.4 | 2822.9 | 3790.079999999999 | 3456.55 | 1968.94 | 0 | 81405.58999999998 | TOTAL
 | SALES TAX | 164.68 | 88.86 | 224.47 | 174.91 | 158.66 | 240.93 | 182.91 | 260.63 | 198.53 | 186.13 | 267.71 | 166.4 | 164.17 | 176.84 | 176.76 | 146.01 | 226.02 | 167.85 | 126.81 | 245.91 | 220.29 | 168.51 | 151.08 | 162.05 | 144.93 | 156.05 | 193.06 | 258.16 | 236.09 | 134.99 | 0 | 5570.400000000001 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 2761.62 | 1410.94 | 3439.97 | 2901.37 | 2455.26 | 3763.590000000001 | 2835.85 | 4075.920000000001 | 3066.650000000001 | 2859.41 | 4122.16 | 2660.87 | 2538.71 | 2758.73 | 2744.93 | 2264.47 | 3473.77 | 2583.26 | 1949.72 | 3862.469999999999 | 3392.53 | 2683.57 | 2342.28 | 2503.59 | 2237.13 | 2426.45 | 3015.96 | 4048.239999999999 | 3692.64 | 2103.93 | 0 | 86975.99000000002 | TOTAL RECEIPTS
 | LESS: [NAME]. Redm. - Pro | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19.57 | 0 | 0 |  | 40.97 | Less: [NAME]. Redeemed
 | LESS: [NAME]. Redm. - Golf | 0 | 0 | 0 | 0 | 10.7 | 0 | 85.32 | 0 | 0 | 0 | 0 | 53.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 107.98 | 0 | 0 | 0 | 0 | 0 | 0
 | LESS: Credit  Book Redeemed | 9.63 | 42.38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 171.74 | 88.16 | 0 | 0 | 0 | 84.25 | 14.98 | 36.38 | 0 | 0 | 26.96 | 0 | 0 | 0 | 86.67 | 0 | 0 | 0 |  | 561.15 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 576.3 | 500 | 563.84 | 888.95 | 598.67 | 1582.39 | 859.25 | 1656.38 | 668.86 | 331.46 | 203.7 | 12.73 | 699.2 | 586.12 | 482.32 | 0 | 409.23 | 317.2 | 755.18 | 1053.5 | 884.46 | 46.75 | 0 | 285.16 | 573.39 | 414.11 | 0 | 624.45 | 0 | 500 | 0 | 16073.6 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 2175.69 | 868.5599999999997 | 2876.13 | 2012.42 | 1845.89 | 2181.200000000001 | 1891.28 | 2419.540000000001 | 2397.79 | 2527.95 | 3918.46 | 2573.24 | 1667.769999999999 | 2084.45 | 2262.61 | 2264.47 | 3064.54 | 2181.81 | 1179.56 | 2772.589999999999 | 2508.07 | 2636.82 | 2315.32 | 2110.45 | 1663.74 | 2012.34 | 2929.29 | 3404.219999999999 | 3692.64 | 1603.93 | 0 | 70300.27000000002 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 2472.8 | 1170 | 3177.38 | 2318.22 | 2144.95 | 2485.01 | 2177.7 | 2777.85 | 2696.02 | 2828.8 | 4213.18 | 2878.47 | 1968.28 | 2390.83 | 2569.01 | 2565.5 | 3365.29 | 2475.1 | 1486.98 | 3068.5 | 2810.82 | 2941.67 | 2614.38 | 2412.54 | 1967.08 | 2313.9 | 3233.7 | 3707.34 | 3998.17 | 1906.73 | 0 | 79136.19999999998 | 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 | 2172.8 | 870 | 2877.38 | 2018.22 | 1844.95 | 2185.01 | 1877.7 | 2477.85 | 2396.02 | 2528.8 | 3913.18 | 2578.47 | 1668.28 | 2090.83 | 2269.01 | 2265.5 | 3065.29 | 2175.1 | 1186.98 | 2768.5 | 2510.82 | 2641.67 | 2314.38 | 2112.54 | 1667.08 | 2013.9 | 2933.7 | 3407.34 | 3698.17 | 1606.73 | 0 | 70136.2 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 2175.69 | 868.5599999999997 | 2876.13 | 2012.42 | 1845.89 | 2181.200000000001 | 1891.28 | 2419.540000000001 | 2397.79 | 2527.95 | 3918.46 | 2573.24 | 1667.769999999999 | 2084.45 | 2262.61 | 2264.47 | 3064.54 | 2181.81 | 1179.56 | 2772.589999999999 | 2508.07 | 2636.82 | 2315.32 | 2110.45 | 1663.74 | 2012.34 | 2929.29 | 3404.219999999999 | 3692.64 | 1603.93 | 0 | 70042.76999999999 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | -2.889999999999418 | 1.440000000000282 | 1.250000000000455 | 5.799999999999955 | -0.9400000000000546 | 3.809999999999491 | -13.57999999999993 | 58.30999999999904 | -1.770000000000437 | 0.8500000000003638 | -5.279999999999745 | 5.229999999999563 | 0.510000000000673 | 6.379999999999654 | 6.400000000000091 | 1.029999999999745 | 0.7499999999995453 | -6.710000000000036 | 7.420000000000073 | -4.089999999999236 | 2.750000000000455 | 4.850000000000364 | -0.9399999999995998 | 2.089999999999691 | 3.340000000000146 | 1.559999999999945 | 4.410000000000309 | 3.1200000000008 | 5.529999999999745 | 2.799999999999727 | 0 | 93.43000000000166 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 2172.8 | 870 | 2877.38 | 2018.22 | 1844.95 | 2185.01 | 1877.7 | 2477.85 | 2396.02 | 2528.8 | 3913.18 | 2578.47 | 1668.28 | 2090.83 | 2269.01 | 2265.5 | 3065.29 | 2175.1 | 1186.98 | 2768.5 | 2510.82 | 2641.67 | 2314.38 | 2112.54 | 1667.08 | 2013.9 | 2933.7 | 3407.34 | 3698.17 | 1606.73 | 0 | 70136.2 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 1614.97 | 853.37 | 2874.31 | 1942.81 | 1833.36 | 1973.29 | 1872.68 | 2385.1 | 2013.88 | 2216.24 | 2516.1 | 1461.67 | 1351.55 | 1529.52 | 1667.51 | 1042.54 | 2779.48 | 1502.97 | 1034.58 | 2478.14 | 2007.07 | 1357.25 | 1711.35 | 1458.11 | 1454.92 | 1505.77 | 1330.7 | 2501.21 | 2231.83 | 928.11 | 0 | 53430.38999999999 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 557.8300000000002 | 16.63 | 3.070000000000164 | 75.40999999999985 | 11.58999999999992 | 211.7200000000003 | 5.019999999999754 | 92.75 | 382.1399999999999 | 312.5600000000004 | 1397.08 | 1116.8 | 316.73 | 561.31 | 601.5000000000002 | 1222.96 | 285.8099999999999 | 672.1299999999999 | 152.4000000000001 | 290.3600000000001 | 503.7500000000002 | 1284.42 | 603.0300000000002 | 654.4300000000001 | 212.1599999999999 | 508.1300000000001 | 1603 | 906.1300000000001 | 1466.34 | 678.62 | 0 | 16705.81 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  | To Wachovia - |  |  |  |  |  |  |  |  |  |  |  |  |  | Transferred to
 |  |  |  |  |  | $2,500. Cover |  |  |  |  |  |  |  |  |  |  |  |  |  | Wachovia Bank
 |  |  |  |  |  | overdrafts |  |  |  |  |  |  |  |  |  |  |  |  |  | $737.93 for OD