Spreadsheet: 68676d1269270234-index-match-problem-example
Sheet: Balance Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January 2010
 |  |  |  |  |  |  |  |  |  |  |  |  | Comparative Balance Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December 2009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change from | %
 |  |  |  | 2006-04-30 00:00:00 | 2006-05-31 00:00:00 | 2006-06-30 00:00:00 | 2006-07-31 00:00:00 | 2006-08-31 00:00:00 | 2006-09-30 00:00:00 | 2006-10-31 00:00:00 | 2006-11-30 00:00:00 | 2006-12-31 00:00:00 | 2007-01-31 00:00:00 | 2007-02-28 00:00:00 | 2007-03-31 00:00:00 | 2007-04-30 00:00:00 | 2007-05-31 00:00:00 | 2007-06-30 00:00:00 | 2007-07-31 00:00:00 | 2007-08-31 00:00:00 | 2007-09-30 00:00:00 | 2007-10-31 00:00:00 | 2007-11-30 00:00:00 | 2007-12-31 00:00:00 | 2008-01-31 00:00:00 | 2008-02-28 00:00:00 | 2008-03-31 00:00:00 | 2008-04-30 00:00:00 | 2008-05-31 00:00:00 | 2008-06-30 00:00:00 | 2008-07-31 00:00:00 | 2008-08-31 00:00:00 | 2008-09-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | December 2009 | January 2010 | February 2010 | March 2010 | April 2010 | May 2010 | June 2010 | July 2010 | August 2010 | September 2010 | October 2010 | November 2010 | December 2010 | Prior Month | Change
 |  | Total Cash & Cash Equivalents |  | 991132.66 | 949619.76 | 958613.02 | 999770.05 | 1082878.65 | 1070053.56 | 1014469.99 | 1080079.29 | 1090494.27 | 1080368.48 | 1063256.99 | 1087862.64 | 1068500.9 | 1121782.97 | 1154311.14 | 1214580.91 | 1271528.17 | 1279805.59 | 1175291.39 | 1288988.23 | 1050104.23 | 999820.21 | 559181.59 | 711976.06 | 207369.67 | -41113.52 | 43403.68 | 325910.5 | 243941.3 | 104769.59 | 632373.15 | 191511.04 | 654991.55 | 403929.99 | 218299.48 | 132216.21 | 387710.66 | 361441.36 | 545788.18 | 357813.94 | 570677.23 | 912598.98 | 747127.16 | 782669.22 | 932456.64 | 536551.31 | 900375.59 |  |  |  |  |  |  |  |  |  |  | -395905.33
 |  | Total Restricted Cash |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total Advances |  | -2013.11 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5475.47 | 5612.54 | 3148.55 | 1912.21 | 9452.99 | 15553.4 | 53714.3 | 98222.49 | 143715.46 | 45458.08 | 1069669.38 | 47285.71 | 46452.6 | 40358.93 | 34319.82 | 32237 | 45018.43 | 100203.11 | 136902.21 | 247811.1 | 167455.59 | 122345.62 | 103787.34 | 125067.54 | 131447.06 | 135104.86 | 103457.37 | 117571.96 | 133568.43 | 227470.29 | 209761.69 | 330289.42 | 309765.37 | 296607.45 |  |  |  |  |  |  |  |  |  |  | -20524.04999999999
 |  | Total Accounts Receivable |  | 26555.93 | 1528.74 | 2172.66 | 1919.04 | 4689.61 | 9368.49 | 9034.68 | 13171.1 | 10753.14 | 9969.82 | 15140.68 | 34301.52 | 14024.56 | 14156.49 | 12073.63 | 19139.03 | 7626.88 | 467.79 | -168657.3 | 4123.18 | 35459.02 | 219283.66 | 99402.07 | 30063.14 | 157584.5 | 59500.12 | 534212.86 | 83700.71 | 128512.11 | 10066.56 | 223543 | 7950.94 | 69245.62 | 282821.21 | 236312.24 | 28540.96 | 55388.41 | 337527.39 | 423291.61 | 288379.28 | 113227.87 | 68108.63 | 18055.93 | 79893.98 | 30816.22 | 274263.16 | 113964.79 |  |  |  |  |  |  |  |  |  |  | 243446.94
 |  | Total Interest Receivable |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 5000 | 4000 | 0 | 0 | 0 | 0 | 0 | 17547.87 | 26847.07 | 18692.17 | 10501.54 | 11185.73 | 12295.11 | 3191.69 | 3544.67 | 7184.48 | 3503.1 | 3088.84 | 4308.59 | 1629.29 | 1117.36 | 0 | 0 | 2506.13 | 3001.46 | 659.15 | 8979.24 | 29950.05 | 26102.67 | 6828.46 | 0 | 9 |  | 15089.16 | 16646.44 | 18996.93 | 20321.71 | 22162.03 | 24882.38 |  |  |  |  |  |  |  |  |  |  | 1840.32
 |  | Total Loans Held for Sale |  | 75171.25 | 1510992.68 | 1919450.87 | 403097.63 | 331699.48 | 3529290.29 | 3931616.17 | 2270759.27 | 2518518.25 | 1525961.78 | 3213935.46 | 4643265.75 | 4295439.89 | 6396507.95 | 5237712.38 | 5117334.25 | 4440516.73 | 6597783.02 | 8673891.82 | 3951460.13 | 10756608.42 | 7963172.380000001 | 12725055.47 | 10377763.93 | 10868489.03 | 9114878.280000001 | 11706497.84 | 7818147.28 | 3256324.08 | 3926164.41 | 6520814.59 | 3391762.11 | 7050217.25 | 21218517.11 | 27774831.1 | 7075236.57 | 24116185.63 | 25586359.96 | 9885304.65 | 6172441.16 | 4008134.29 | 6741527.93 | 7464060.37 | 13580605.47 | 6598983.34 | 4249574.74 | 6017858.8 |  |  |  |  |  |  |  |  |  |  | -2349408.6
 | Total Current Assets |  |  | 1108709.03 | 2503596.59 | 3024134.98 | 1432697.96 | 1437332.36 | 4593989.19 | 5000505 | 3381088.56 | 3700494.79 | 2645668.18 | 4268830.13 | 5709486.560000001 | 5262265.54 | 8644882.879999999 | 8129144.579999999 | 7958152.92 | 6943312.810000001 | 9195045.6 | 11059914.02 | 6499261.869999999 | 11805228.86 | 8738922.120000001 | 13076284.36 | 12332430.7 | 11794576.42 | 9616356.58 | 12816557.59 | 8536832.190000001 | 3869561.12 | 4479652.56 | 8058671.1 | 4048141.11 | 9324940.42 | 24524996.09 | 29605645.92 | 9258358.700000001 | 26896602.8 | 28613046.12 | 11891838.92 | 7766770.74 | 5068456.27 | 8440324.52 | 9091740.559999999 | 14531572.26 | 9165716.850000001 | 6301488.840000001 | 7353789.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2520550.72 | -0.497301463350694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What am I doing wrong that this formula works for January and December but as soon as I change the date to another month it gives me #[NAME]??