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

 | CASH RECEIPTS - 2008
 |  | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY | MAY
 |  | 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
 |  |  |  |  |  |  |  | Closed - Aerify
 | 18 HOLES PUBLIC | 668.38 | 680.01 | 879.64 | 708 | 346.52 | 267 | 0 | 182.65 | 212 | 328.34 | 521 | 265.01 | 750.85 | 214 | 308.58 | 459.01 | 91 | 303 | 85.02 | 177 | 213 | 372.89 | 396.51 | 572.54 | 554 | 358 | 104 | 209.04 | 315 | 1505.9 | 270 | 12317.89 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 0 | 15 | 15 | 30 | 0 | 60 | 0 | 0 | 165 | 30 | 0 | 30 | 45 | 0 | 0 | 75 | 75 | 0 | 30 | 0 | 0 | 30 | 70 | 37 | 135 | 0 | 0 | 0 | 0 | 15 | 0 | 857 | 9 HOLES PUBLIC
 | MEMBER CART | 71.47 | 1147.61 | 269.9 | 37.37 | 115.85 | 400.43 | 0 | 19.62 | 9.81 | 124.26 | 19.62 | 107.91 | 78.48 | 47.74 | 29.43 | 68.67 | 93.85 | 68.86 | 29.43 | 206.07 | 19.62 | 166.8 | 68.67 | 68.67 | 58.86 | 196.23 | 274.74 | 9.81 | 19.62 | 392.52 | 85.35 | 4307.27 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 75 | 285 | 150 | 180 | 0 | 0 | 0 | 185 | 155 | 45 | 140 | 219.01 | 123.04 | 290 | 294.42 | 290.38 | 100 | 285 | 35 | 90 | 155 | 129.06 | 125 | 30 | 0 | 60 | 260 | 290 | 165 | 160 | 155 | 4470.91 | 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 | 447.99 | 180.01 | 224 | 528.01 | 687 | 401.41 | 0 | 164 | 189 | 284 | 488 | 248 | 347 | 308 | 464 | 192 | 526.5 | 440 | 120 | 253.5 | 204 | 332 | 528 | 254 | 456 | 505 | 252 | 208 | 304 | 232 | 616 | 10383.42 | BIG SUMMER CARD
 | SNACK BAR | 17 | 39.6 | 29 | 28.5 | 8.3 | 17.8 | 0 | 48 | 159.75 | 195.25 | 146.25 | 79.5 | 131.61 | 69 | 160.25 | 107 | 150.25 | 107.25 | 85.25 | 94 | 68.5 | 171 | 141 | 256.25 | 104.77 | 140.5 | 147.75 | 95.45 | 124.5 | 345.26 | 292.25 | 3560.79 | SNACK BAR
 | MEMBER GUEST | 0 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 163 | MEMBER GUEST
 | ANNUAL DUES SINGLE | 600 | 0 | 600 | 300 | 0 | 300 | 0 | 0 | 0 | 300 | 0 | 0 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2700 | 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 | 42.46 | 105.2 | 203.1 | 15.27 | 0.51 | 57.8 | 0 | 25.93 | 141.77 | 34.4 | 146 | 2 | 52 | 7.78 | 25.42 | 10.37 | 0 | 96 | 33 | 88 | 15 | 4 | 89.15 | 38 | 32.43 | 62.5 | 0.46 | 38.46 | 0 | 61 | 4.5 | 1432.51 | MERCHANDISE
 | RENTAL CLUBS | 0 | 0 | 0 | 0 | 0 | 14.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 0 | 15 | 0 | 7.01 | 0 | 0 | 7.01 | 0 | 0 | 7.01 | 0 | 0 | 0 | 0 | 0 | 57.06 | RENTAL CLUBS
 | RANGE | 94.28 | 27.07 | 58.81 | 84.01 | 22.6 | 28.4 | 0 | 5.6 | 7.47 | 54.14 | 99.36 | 42.01 | 44.81 | 28.94 | 63.91 | 14 | 43.87 | 30.4 | 15.87 | 38 | 39.2 | 42.01 | 17.74 | 28.94 | 56.95 | 15.87 | 48.55 | 48.61 | 24.27 | 28.01 | 44.8 | 1198.5 | 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 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 358 | 0 | 408 | [NAME]. SOLD - Pro
 | [NAME]. SOLD - Golf | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 93.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 113.45 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 72 | 14 | 0 | 0 | 0 | 0 | 0 | 60 | 14 | 0 | 0 | 0 | 0 | 0 | 48 | 18 | 144 | 0 | 404 | 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 | 2050.58 | 2574.5 | 2429.45 | 1911.16 | 1180.78 | 1546.86 | 0 | 630.8 | 1089.8 | 1395.39 | 1560.23 | 993.4399999999999 | 1872.79 | 1137.92 | 1360.01 | 1264.43 | 1080.47 | 1345.51 | 433.57 | 953.5799999999999 | 774.32 | 1561.76 | 1443.08 | 1285.4 | 1398.01 | 1345.11 | 1087.5 | 947.3700000000001 | 970.39 | 3241.690000000001 | 1507.9 | 42373.80000000001 | TOTAL
 | SALES TAX | 126.01 | 170.19 | 167.87 | 131.92 | 82.14 | 105.61 | 0 | 39.84 | 58.59 | 83.6 | 99.08 | 64.05 | 121.95 | 69.28 | 83.19 | 81.07 | 62.94 | 86.17 | 24.41 | 57.44 | 44.27 | 96.47 | 91.26 | 72.12 | 90.6 | 84.38 | 65.85 | 56.32 | 52.11 | 162.05 | 85.2 | 2615.98 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 2176.59 | 2744.69 | 2597.32 | 2043.08 | 1262.92 | 1652.47 | 0 | 670.64 | 1148.39 | 1478.99 | 1659.31 | 1057.49 | 1994.74 | 1207.2 | 1443.2 | 1345.5 | 1143.41 | 1431.68 | 457.98 | 1011.02 | 818.59 | 1658.23 | 1534.34 | 1357.52 | 1488.61 | 1429.49 | 1153.35 | 1003.69 | 1022.5 | 3403.740000000001 | 1593.1 | 44989.78 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem - Pro | 0 | 0 | 0 | 0 | 0 | 50.08 | 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 | 50.08 | Less: [NAME]. Redeem - Pro
 | LESS: [NAME]. Redeem - Golf | 0 | 59.07 | 0 | 0 | 42.8 | 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 | 101.87 | Less: [NAME]. Redeem - Golf
 | LESS: Credit  Book Redeemed | 32.11 | 0 | 184.82 | 0 | 0 | 0 | 0 | 15 | 40.5 | 8.82 | 134.03 | 21.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8.56 | 0 | 445.24 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 862.73 | 623.24 | 230.8 | 0 | 245.1 | 453.5 | 0 | 229.5 | 530.24 | 532.97 | 750 | 450.09 | 655 | 514.84 | 770.6 | 285.53 | 105.6 | 736.41 | 0 | 347.44 | 663.1 | 779.89 | 950 | 0 | 44.41 | 557.9 | 580.84 | 432.3 | 516 | 2594.39 | 618.05 | 16060.47 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 1281.75 | 2062.38 | 2181.699999999999 | 2043.08 | 975.0199999999999 | 1148.89 | 0 | 426.14 | 577.6499999999999 | 937.2 | 775.2799999999997 | 586 | 1339.74 | 692.36 | 672.6000000000003 | 1059.97 | 1037.81 | 695.2700000000003 | 457.98 | 663.5799999999999 | 155.49 | 878.34 | 584.3399999999999 | 1357.52 | 1444.2 | 871.5899999999998 | 572.5099999999999 | 571.3900000000001 | 506.5 | 800.7900000000009 | 975.05 | 28332.12 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 1589.07 | 2363.91 | 2480.25 | 2338.95 | 1280.59 | 1449.61 | 0 | 727.8 | 882.64 | 1232.64 | 1080.63 | 886.43 | 1637.97 | 996.12 | 963.75 | 1360.76 | 1343.83 | 999.89 | 753.78 | 970.13 | 468.28 | 1180.79 | 876.27 | 1659.65 | 1759.6 | 1172.1 | 876.89 | 875.26 | 811.13 | 1099.91 | 1301.55 | 37420.18 | TOTAL CASH ON HAND
 | LESS:DRAWER | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 9000 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 1289.07 | 2063.91 | 2180.25 | 2038.95 | 980.5899999999999 | 1149.61 | 0 | 427.8 | 582.64 | 932.6400000000001 | 780.6300000000001 | 586.43 | 1337.97 | 696.12 | 663.75 | 1060.76 | 1043.83 | 699.89 | 453.78 | 670.13 | 168.28 | 880.79 | 576.27 | 1359.65 | 1459.6 | 872.0999999999999 | 576.89 | 575.26 | 511.13 | 799.9100000000001 | 1001.55 | 28420.17999999999 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 1281.75 | 2062.38 | 2181.699999999999 | 2043.08 | 975.0199999999999 | 1148.89 | 0 | 426.14 | 577.6499999999999 | 937.2 | 775.2799999999997 | 586 | 1339.74 | 692.36 | 672.6000000000003 | 1059.97 | 1037.81 | 695.2700000000003 | 457.98 | 663.5799999999999 | 155.49 | 878.34 | 584.3399999999999 | 1357.52 | 1444.2 | 871.5899999999998 | 572.5099999999999 | 571.3900000000001 | 506.5 | 800.7900000000009 | 975.05 | 28332.12 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 7.319999999999936 | 1.529999999999745 | -1.449999999999363 | -4.130000000000337 | 5.57000000000005 | 0.7199999999997999 | 0 | 1.659999999999968 | 4.990000000000123 | -4.559999999999945 | 5.350000000000364 | 0.42999999999995 | -1.769999999999982 | 3.759999999999991 | -8.85000000000025 | 0.790000000000191 | 6.019999999999982 | 4.619999999999663 | -4.200000000000045 | 6.550000000000068 | 12.78999999999996 | 2.449999999999932 | -8.069999999999936 | 2.130000000000109 | 15.39999999999986 | 0.5100000000001046 | 4.380000000000109 | 3.869999999999891 | 4.629999999999995 | -0.8800000000007913 | 26.5 | 88.05999999999915 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 1289.07 | 2063.91 | 2180.25 | 2038.95 | 980.5899999999999 | 1149.61 | 0 | 427.8 | 582.64 | 932.6400000000001 | 780.6300000000001 | 586.43 | 1337.97 | 696.12 | 663.75 | 1060.76 | 1043.83 | 699.89 | 453.78 | 670.13 | 168.28 | 880.79 | 576.27 | 1359.65 | 1459.6 | 872.0999999999999 | 576.89 | 575.26 | 511.13 | 799.9100000000001 | 1001.55 | 28420.17999999999 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 1174.88 | 1911.41 | 1582.31 | 1487.04 | 593.21 | 1146.18 | 0 | 223.99 | 420.29 | 731.82 | 706.21 | 544.43 | 863.87 | 645.32 | 603.14 | 555.17 | 487.93 | 488.99 | 154.39 | 603.43 | 152.61 | 806.49 | 526.96 | 619.43 | 965.39 | 743.73 | 336.59 | 510.26 | 404.11 | 616.85 | 700.8 | 21307.23 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 114.1899999999998 | 152.4999999999998 | 597.94 | 551.9099999999999 | 387.3799999999999 | 3.429999999999836 | 0 | 203.8099999999999 | 162.35 | 200.8200000000001 | 74.42000000000007 | 42 | 474.1 | 50.79999999999995 | 60.61000000000001 | 505.59 | 555.8999999999999 | 210.9 | 299.39 | 66.70000000000005 | 15.66999999999996 | 74.29999999999995 | 49.30999999999995 | 740.2200000000001 | 494.2099999999999 | 128.3699999999999 | 240.3 | 65 | 107.02 | 183.0600000000001 | 300.75 | 7112.949999999997 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $8,000.00 per |  |  |  |  |  | $6,000.00 per
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Michigan Office |  |  |  |  |  | Michigan office