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

 | CASH RECEIPTS - 2008
 |  | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST | AUGUST
 |  | 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 - Rain |  |  |  |  |  |  |  | CLOSED | CLOSED |  | CLOSED
 | 18 HOLES PUBLIC | 231.63 | 620.97 | 425.03 | 125.02 | 173 | 321.08 | 264 | 118.69 | 106.5 | 485 | 0 | 60 | 139 | 135 | 298.68 | 125.08 | 315 | 164.1 | 0 | 0 | 95.03 | 0 | 90 | 677 | 142 | 30 | 34.98 | 159.22 | 298.32 | 200.18 | 220.06 | 6054.57 | 18 HOLES PUBLIC
 | 9 HOLES PUBLIC | 15 | 75 | 15 | 0 | 15 | 10 | 90 | 10 | 0 | 15 | 0 | 30 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 15 | 30 | 45 | 410 | 9 HOLES PUBLIC
 | MEMBER CART | 39.24 | 193.77 | 39.24 | 49.05 | 122.1 | 19.62 | 274.74 | 19.62 | 78.48 | 117.75 | 0 | 186.42 | 0 | 107.94 | 19.62 | 107.91 | 19.62 | 29.43 | 0 | 0 | 9.81 | 0 | 117.72 | 19.62 | 29.43 | 19.62 | 117.75 | 0 | 64.67 | 85.35 | 49.05 | 1937.57 | MEMBER CART
 | EARLY BIRD & TWLIGHT | 250.81 | 290 | 40 | 20 | 133 | 10 | 75 | 411.15 | 85 | 250 | 0 | 90 | 110 | 225 | 202.74 | 195 | 45 | 40 | 0 | 0 | 30 | 0 | 229.72 | 115 | 15 | 110 | 155 | 65 | 93.02 | 30 | 45 | 3360.44 | 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 | 380 | 112 | 240 | 195.94 | 100 | 180 | 316 | 128 | 100 | 656 | 0 | 176 | 100 | 180 | 60 | 360 | 360 | 60 | 0 | 0 | 182 | 0 | 60 | 0 | 20 | 161.5 | 126.12 | 120 | 115 | 62 | 0 | 4550.56 | BIG SUMMER CARD
 | TOURNAMENT | 97.75 | 259.5 | 111.25 | 93.75 | 134.1 | 63.5 | 99 | 71.8 | 96.75 | 88.56 | 0 | 83 | 51 | 90.5 | 59.5 | 219.25 | 110.5 | 40.25 | 0 | 0 | 27.8 | 0 | 144.6 | 60 | 46.25 | 88.25 | 42.5 | 30.75 | 105.75 | 106.5 | 116.5 | 2538.86 | TOURNAMENT
 | MEMBER GUEST | 25 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 30 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 205 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 13.26 | 52.03 | 49.96 | 10 | 0.46 | 1 | 15.41 | 0 | 48.46 | 37.67 | 0 | 12 | 0 | 0.46 | 10 | 19.94 | 50 | 0 | 0 | 0 | 0 | 0 | 11.67 | 38.71 | 164.3 | 49.75 | 29.36 | 46.5 | 18.95 | 6.38 | 8.84 | 695.1100000000001 | MERCHANDISE
 | RENTAL CLUBS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.01 | RENTAL CLUBS
 | RANGE | 44.81 | 98.96 | 40.16 | 22 | 35.48 | 10.27 | 21.47 | 14 | 14 | 70.11 | 0 | 26.14 | 34.54 | 58.82 | 0 | 32.67 | 24.27 | 0 | 0 | 0 | 5.6 | 0 | 24.27 | 0 | 0 | 10.8 | 7.47 | 11.2 | 13.07 | 8.4 | 10.27 | 638.78 | 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 | 56.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 | 0 | 56.08 | [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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME]. SOLD - Golf
 | CREDIT BOOK SOLD | 0 | 0 | 0 | 0 | 0 | 36 | 10 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 0 | 0 | 0 | 0 | 118 | 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 | 1097.5 | 1702.23 | 960.64 | 515.76 | 789.2200000000001 | 651.47 | 1165.62 | 773.26 | 529.19 | 1750.09 | 0 | 663.56 | 464.54 | 817.7200000000001 | 650.54 | 1089.85 | 991.4 | 333.78 | 0 | 0 | 350.2400000000001 | 0 | 677.9799999999999 | 910.33 | 441.98 | 469.92 | 555.1800000000001 | 432.67 | 723.7800000000001 | 568.81 | 494.72 | 20571.98 | TOTAL
 | SALES TAX | 70.08 | 101.18 | 59.5 | 29.58 | 45.37 | 36.13 | 74.03 | 49.21 | 30.32 | 115.84 | 0 | 40.7 | 26.89 | 50.98 | 41.46 | 61.02 | 61.7 | 20.56 | 0 | 0 | 22.58 | 0 | 37.42 | 59.56 | 26.67 | 26.74 | 32.9 | 28.15 | 43.65 | 32.42 | 26.53 | 1251.170000000001 | SALES TAX
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 1167.58 | 1803.41 | 1020.14 | 545.34 | 834.5900000000001 | 687.6 | 1239.65 | 822.47 | 559.5100000000001 | 1865.93 | 0 | 704.26 | 491.43 | 868.7000000000002 | 692 | 1150.87 | 1053.1 | 354.34 | 0 | 0 | 372.8200000000001 | 0 | 715.3999999999999 | 969.8900000000001 | 468.65 | 496.66 | 588.08 | 460.82 | 767.4300000000001 | 601.2299999999999 | 521.25 | 21823.15000000001 | TOTAL RECEIPTS
 | LESS: [NAME]. Redeem-Pro | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49.76 | 0 | 0 | 0 | 60.45999999999999 | Less: [NAME]. Redeem-Pro
 | LESS: [NAME]. Redeem-Golf | 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]. Redeem-Golf
 | LESS: Credit  Book Redeemed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.36 | 5.75 | 0 | 0 | 0 | 0 | 0 | 9.63 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 133.11 | 0 | 0 | 0 | 0 | 0 | 0 | 199.85 | Less: Credit Book Redeemed
 | LESS:DISBURSEMENTS | 616.28 | 1039.67 | 489.09 | 77.73 | 428.91 | 220.27 | 738.5 | 422.48 | 277.93 | 710 | 0 | 292.68 | 232 | 435.37 | 510 | 548.02 | 498.17 | 164.5 | 0 | 0 | 219.91 | 0 | 592.92 | 381.15 | 175 | 187.13 | 300 | 180 | 538 | 325.55 | 374.82 | 10976.08 | LESS:DISBURSEMENTS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | NET DAILY RECEIPTS | 551.3 | 763.74 | 531.05 | 467.61 | 405.6800000000001 | 467.33 | 501.1500000000001 | 399.99 | 230.2200000000001 | 1150.18 | 0 | 411.58 | 259.43 | 433.3300000000002 | 171.3 | 593.22 | 554.9299999999998 | 189.84 | 0 | 0 | 152.9100000000001 | 0 | 122.4799999999999 | 588.7400000000001 | 160.54 | 309.53 | 288.08 | 231.06 | 229.4300000000001 | 275.6799999999999 | 146.43 | 10586.76000000001 | NET DAILY RECEIPTS
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ON HAND | 851.46 | 1065.88 | 827.68 | 766.87 | 712.08 | 769.06 | 802.23 | 695.02 | 533.95 | 1450.08 | 0 | 710.19 | 562.62 | 732.45 | 472.78 | 911.5 | 853.54 | 494.27 | 0 | 0 | 462.26 | 0 | 423.8 | 890.74 | 460.44 | 611.42 | 588.49 | 533.05 | 522.03 | 577.35 | 448.22 | 18729.46 | TOTAL CASH ON HAND
 | LESS:DRAWER | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 0 | 0 | 300 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 8100 | LESS:DRAWER
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - |  | - |  | -
 | TOTAL RECEIPTS | 551.46 | 765.8800000000001 | 527.68 | 466.87 | 412.08 | 469.0599999999999 | 502.23 | 395.02 | 233.95 | 1150.08 | 0 | 410.1900000000001 | 262.62 | 432.45 | 172.78 | 611.5 | 553.54 | 194.27 | 0 | 0 | 162.26 | 0 | 123.8 | 590.74 | 160.44 | 311.42 | 288.49 | 233.05 | 222.03 | 277.35 | 148.22 | 10629.46 | TOTAL RECEIPTS
 | NET RECEIPTS (ABOVE) | 551.3 | 763.74 | 531.05 | 467.61 | 405.6800000000001 | 467.33 | 501.1500000000001 | 399.99 | 230.2200000000001 | 1150.18 | 0 | 411.58 | 259.43 | 433.3300000000002 | 171.3 | 593.22 | 554.9299999999998 | 189.84 | 0 | 0 | 152.9100000000001 | 0 | 122.4799999999999 | 588.7400000000001 | 160.54 | 309.53 | 288.08 | 231.06 | 229.4300000000001 | 275.6799999999999 | 146.43 | 10586.76 | NET RECEIPTS (ABOVE)
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - |  | -
 | CASH OVER / SHORT | 0.1600000000000819 | 2.1400000000001 | -3.370000000000005 | -0.7400000000000091 | 6.39999999999992 | 1.729999999999905 | 1.079999999999927 | -4.970000000000027 | 3.729999999999961 | -0.09999999999990905 | 0 | -1.38999999999993 | 3.189999999999998 | -0.8800000000001091 | 1.480000000000018 | 18.27999999999997 | -1.389999999999873 | 4.430000000000007 | 0 | 0 | 9.349999999999937 | 0 | 1.320000000000107 | 1.999999999999886 | -0.1000000000000227 | 1.88999999999993 | 0.4099999999999682 | 1.989999999999952 | -7.400000000000091 | 1.67000000000013 | 1.79000000000002 | 42.69999999999985 | CASH OVER / SHORT
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 | TOTAL CASH ABOVE | 551.46 | 765.8800000000001 | 527.68 | 466.87 | 412.08 | 469.0599999999999 | 502.23 | 395.02 | 233.95 | 1150.08 | 0 | 410.1900000000001 | 262.62 | 432.45 | 172.78 | 611.5 | 553.54 | 194.27 | 0 | 0 | 162.26 | 0 | 123.8 | 590.74 | 160.44 | 311.42 | 288.49 | 233.05 | 222.03 | 277.35 | 148.22 | 10629.46 | TOTAL CASH ABOVE
 | LESS: AM EX  / VIS | 541.05 | 659.38 | 494.68 | 215.1 | 345.72 | 204.17 | 489.68 | 389.36 | 219.15 | 1074.22 | 0 | 403.14 | 173.57 | 430.45 | 170.16 | 542.25 | 417.84 | 181.27 | 0 | 0 | 149.6 | 0 | 119.1 | 576.21 | 157.84 | 308.97 | 268.61 | 228.35 | 220.69 | 268.3 | 133.64 | 9382.500000000002 | LESS: AM EX  / VIS
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | - |  | - |  | -
 | DEPOSIT TO BANK | 10.41000000000008 | 106.5000000000001 | 32.99999999999994 | 251.77 | 66.36000000000001 | 264.89 | 12.55000000000001 | 5.659999999999968 | 14.80000000000004 | 75.8599999999999 | 0 | 7.050000000000068 | 89.05000000000001 | 2.000000000000057 | 2.619999999999976 | 69.25 | 135.7 | 12.99999999999997 | 0 | 0 | 12.66 | 0 | 4.700000000000017 | 14.52999999999997 | 2.599999999999994 | 2.449999999999932 | 19.88 | 4.69999999999996 | 1.339999999999975 | 9.050000000000011 | 14.58000000000004 | 1246.959999999997 | DEPOSIT TO BANK
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = | = |  | = |  | =
 |  |  |  |  | $1680.00 Check from |  |  |  |  |  |  | $403.87 partial restitution |  |  |  |  |  |  |  | $176.08 partial reimbursent from
 |  |  |  |  | Michigan Realty |  |  |  |  |  |  | from juveniles from cart |  |  |  |  |  |  |  | juveniles who broke into
 |  |  |  |  |  |  |  |  |  |  |  | break-in last July |  |  |  |  |  |  |  | cart bar 8/1/08