Spreadsheet: 72864d1273585478-reconciling-items-using-excel-daily-cash-amex-breakdown
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 784.99
 | 8/1/09 - 8/3 | 8/4 | 8/5 | 8/6 | 8/7 | 8/8 - 8/10 | 8/11 | 8/12 | 8/13 | 8/14 | 8/15 - 8/17 | 8/18 | 8/19 | 8/20 | 8/21 | 8/22 - 8/24 | 8/25 | 8/26 | 8/27 | 8/28 | 8/31 |  | 7/30 - 7/31
[NAME] | 2801.78 | 3286.37 | 3836.26 | 4692.09 | 4711.67 | 10976.29 | 1597.99 | 0 | 1705.75 | 4643.68 | 2888.02 | 3264.73 | 4788.84 | 1436.92 | 2403.81 | 1126.24 | 3235.91 | 1416.64 | 1486.05 | 214.81 | 0 | 60513.84999999999 | 574.6800000000001 | 61088.52999999999
Daily Cash | -111.3 | 169.23 | 2299.68 | 1287.99 | 621.92 | 0 | 1177.99 | 526.29 | 248.99 | 300.78 | 1193.22 | 1673.83 | 874.98 | 145.43 | 228.7 | 1681.45 | 160.91 | 450.2 | 98.42 | 0 | 40
 | 1873.07 | 683.61 | 511.38 | 1421.88 | 1262.22 |  | 420 | 59 | 1660.78 | 122.58 | 59 | 559.94 | 248.94 | 140.82 | 161.54 | 1056.29 | 945.38 | 272.85 | -128.53 |  | 255.69
 | 1593.9 | 1376.51 | 490.15 | 1945.42 | 1625.4 |  | 639.61 | 18.22 | 681.36 | 664.57 | 52 | 39.7 | 182.9 | 992.68 | 394.75 | 98.14 | 50.51 | 120 | 129.21 |  | 17.7
 | 490 | 632.3 | 767.07 | 56.38 | 300.69 |  | 319.24 | 11.42 | 988.79 | 854.25 | -59.52 | 1099.18 | 430.79 | 419.92 | -43.38 | 1.25 | 280.89 | 380 | 763 |  | 166.26
 |  | 125.23 | 349.69 | 222.89 | 401.1 |  |  | 131.97 |  | 765.38 | 89.31 | 247.78 | 6.92 | 243.11 |  | 12 | -140.82 | 20 | 75.71 |  | 206.44
 |  | 767.07 |  | 1658.14 | 1986.68 |  |  |  |  | 180.46 | 1107.99 | 10.41 | 3.5 | 368.23 |  | 300.69 | 96.04 | 3.73
 |  |  |  |  | 4730.28 |  |  |  |  | 1063.76 | 808.89 | 1157.99 |  | 5 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.23 |  |  | 3.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -468
Totals | 3845.67 | 3753.95 | 4417.97 | 6592.700000000001 | 10928.29 | 0 | 2556.84 | 746.9 | 3579.92 | 3951.78 | 3250.89 | 4788.83 | 1748.03 | 1854.5 | 741.61 | 3149.82 | 1416.09 | 1246.78 | 937.8100000000001 | 0 | 686.0899999999999 | 60194.46999999999
Difference | -1043.89 | -467.5799999999999 | -581.71 | -1900.610000000001 | -6216.620000000001 | 10976.29 | -958.8500000000001 | -746.9 | -1874.17 | 691.9000000000005 | -362.8699999999999 | -1524.1 | 3040.81 | -417.5799999999999 | 1662.2 | -2023.58 | 1819.82 | 169.8600000000001 | 548.2399999999999 | 214.81 | -686.0899999999999 | 319.3799999999999
Actual from Receipts | -111.3 | 683.61 | 349.69 | 222.89 | 1625.4 | 0 | 1177.99 | 526.29 | 248.99 | 1063.76 | -59.52 | 1157.99 | 3.5 | 4.08 | -43.38 | 300.69 | 160.91 | 450.2 | 75.71 | 0 | 206.44
 | 1873.07 | 169.23 | 767.07 | 1658.14 | 300.69 |  | 420 | 59 | 1660.78 | 180.46 | 89.31 | 10.41 | 6.92 | 3.23 | 394.75 | 12 | 945.38 | 272.85 | 98.42 |  | 166.26
 | 1593.9 | 1376.51 | 490.15 | 1287.99 | 401.1 |  | 639.61 | 18.22 | 681.36 | 765.38 | 808.89 | 1673.83 | 430.79 | -468 | 161.54 | 1.25 | 50.51 | 120 | -128.53 |  | 17.7
 | 490 | 632.3 | 511.38 | 1421.88 | 1986.68 |  | 319.24 | 11.42 | 988.79 | 300.78 | 52 | 559.94 | 182.9 | 5 | 228.7 | 98.14 | 280.89 | 20 | 129.21 |  | 255.69
 |  | 125.23 | 2299.68 | 1945.42 | 4730.28 |  |  | 131.97 |  | 122.58 | 1107.99 | 39.7 | 248.94 | 368.23 |  | 1056.29 | -140.82 | 380 | 763 |  | 40
 |  | 767.07 |  | 56.38 | 621.92 |  |  |  |  | 664.57 | 59 | 1099.18 | 874.98 | 140.82 |  | 1681.45 | 20 | 3.73
 |  |  |  |  | 1262.22 |  |  |  |  | 854.25 | 1193.22 | 247.78 |  | 243.11 |  |  | 3.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 145.43
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 992.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 419.92
Totals | 3845.67 | 3753.95 | 4417.969999999999 | 6592.700000000001 | 10928.29 | 0 | 2556.84 | 746.9 | 3579.92 | 3951.78 | 3250.89 | 4788.83 | 1748.03 | 1854.5 | 741.6099999999999 | 3149.82 | 1320.05 | 1246.78 | 937.81 | 0 | 686.0899999999999
Daily Cash Reported | 3845.67 | 3753.95 | 4417.97 | 6592.700000000001 | 10928.29 | 0 | 2556.84 | 746.9 | 3579.92 | 3951.78 | 3250.89 | 4788.83 | 1748.03 | 1854.5 | 741.61 | 3149.82 | 1416.09 | 1246.78 | 937.8100000000001 | 0 | 686.0899999999999
Difference | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -96.03999999999996 | 0 | 0 | 0 | 0 | -96.03999999999996
Note:  See July Bank Recon.  On 8/25, there is 96.04 more on daily cash than on daily settlement reports.  However, all amounts balance to daily reports.