New Search
FY12 <br />2011 -2012 Fed Ind Rate <br />52.57% <br />19317 7/2/2011 Steeck,Diane M 96 100022 EPA Grant Phase 2 93.69 0 C <br />19317 7/16/2011 Steeck,Diane M 96 100022 EPA Grant Phase 2 47.81 0 C <br />19317 8/27/2011 Steeck,Diane M 96 100022 EPA Grant Phase 2 63.74 0 C <br />Billing #5 <br />19317 9/24/2011 Steeck,Diane M 96 100022 EPA Grant Phase 2 63.74 0 C <br />19317 10/8/2011 Steeck,Diane M 96 100022 EPA Grant Phase 2 31.87 0 C <br />19317 10/22/2011 Steeck,Diane M 96 100022 EPA Grant Phase 2 31.87 0 C <br />Billing #6 <br />19317 <br />1/14/2012 Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />95.62 <br />0 C <br />19317 <br />1/28/2012 Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />95.62 <br />0 C <br />480.59 <br />Billing #7 <br />584.56 <br />307.30 <br />836.82 <br />11.50 <br />0.00 <br />19317 <br />4/21/2012 Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />47.81 <br />0 C <br />19317 <br />5/5/2012 Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />31.87 <br />0 C <br />19317 <br />6/2/2012 Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />191.22 <br />0 C <br />19317 <br />6/16/2012 Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />95.61 <br />0 C <br />145.24 <br />76.35 <br />221.59 <br />3.00 <br />73.11 <br />38.43 <br />111.00 <br />1.50 <br />98.11 <br />51.58 <br />148.00 <br />2.00 <br />316.46 <br />166.36 <br />480.59 <br />6.50 <br />584.56 <br />307.30 <br />836.82 <br />11.50 <br />0.00 <br />FY12 <br />74.00 <br />0.00 <br />98.11 <br />51.58 <br />148.00 <br />2.00 <br />48.72 <br />25.61 <br />74.00 <br />1.00 <br />48.88 <br />25.7 <br />74.00 <br />1.00 <br />195.71 <br />102.88 <br />296.00 <br />4.00 <br />222.00 <br />0.00 <br />(993.43) <br />444.00 <br />0.00 <br />(641.00) <br />$ <br />480.59 <br />146.14 <br />76.83 <br />222.00 <br />3.00 <br />147.19 <br />77.38 <br />222.00 <br />3.00 <br />293.33 <br />154.20 <br />444.00 <br />6.00 <br />79.55 <br />41.82 <br />111.00 <br />1.50 <br />52.68 <br />27.69 <br />74.00 <br />1.00 <br />316.12 <br />166.18 <br />444.00 <br />6.00 <br />136.21 <br />71.61 <br />207.82 <br />3.00 <br />584.56 <br />307.30 <br />836.82 <br />11.50 <br />0 C <br />0 C <br />0 C <br />0 C <br />0 C <br />0 C <br />0 C <br />0 C <br />1 st Qtr FY12 2nd Qtr FY12 3rd Qtr FY12 4th Qtr FY12 <br />FY12 <br />I Billing#5 Billing #6 Billing #7 Billing #8 <br />Billed /Revenue <br />$ (641.00) $ (296.00) $ (444.00) $ (837.00) <br />Actual Expense <br />$ 480.59 $ 296.00 $ 444.00 $ 836.82 <br />Adjustment <br />1 - 160.41 0.00 0.00 -0.18 <br />FY12 <br />234.00 <br />-12.41 <br />FY12 <br />111.00 <br />0.00 <br />FY12 <br />148.00 <br />0.00 <br />FY12 <br />493.00 <br />-12.41 <br />$ <br />851.00 <br />-14.18 <br />2,211.62 <br />-18.38 <br />$ <br />FY12 <br />148.00 <br />0.00 <br />FY12 <br />74.00 <br />0.00 <br />FY12 <br />74.00 <br />0.00 <br />Billing #3 <br />296.00 <br />0.00 <br />$ <br />2 <br />0.00 <br />$ <br />3 <br />Billing #4 <br />FY12 <br />222.00 <br />0.00 <br />FY12 <br />222.00 <br />0.00 <br />(993.43) <br />444.00 <br />0.00 <br />FY12 <br />111.00 <br />0.00 <br />FY12 <br />74.00 <br />0.00 <br />FY12 <br />444.00 <br />0.00 <br />FY12 <br />222.00 <br />-14.18 <br />$ <br />851.00 <br />-14.18 <br />FY12 Summary <br /># # # # # # ## <br />$ 2,057.41 <br />$ (160.59) Adjustment needed <br />AJE 81140 <br />AJE 81140 <br />Reconciliation through FY12 (June 30, 2012) <br />Billed <br />Actual <br />Difference <br />GL <br />Billing #1 <br />$ <br />(2,230.00) <br />$ <br />2,211.62 <br />-18.38 <br />$ <br />2 <br />Billing #2 <br />$ <br />(4 <br />$ <br />4,488.70 <br />14.85 <br />$ <br />5 <br />Billing #3 <br />$ <br />(2,927.40) <br />$ <br />2 <br />0.00 <br />$ <br />3 <br />Billing #4 <br />$ <br />(583.92) <br />$ <br />587.45 <br />3.53 <br />$ <br />(993.43) <br />Billing #5 <br />$ <br />(641.00) <br />$ <br />480.59 <br />- 160.41 <br />$ <br />493.00 <br />Billing #6 <br />$ <br />(296.00) <br />$ <br />296.00 <br />0.00 <br />$ <br />296.00 <br />Billing #7 <br />$ <br />(444.00) <br />$ <br />444.00 <br />0.00 <br />$ <br />444.00 <br />Billing #8 <br />$ <br />(837.00) <br />$ <br />836.82 <br />-0.18 <br />$ <br />851.00 <br />$ <br />(12,433.17) <br />$ <br />12 <br />- 160.59 <br />$ <br />12 <br />AJE - FY12 <br />$ <br />160.59 <br />$ <br />- <br />$ <br />(26.59) <br />Total To Date 1 $ ( 12,272.58)1 $ 12,2 1 $ 12,272.58 <br />FY 12 adjustments to LCOG billing <br />$ (160.41) Accrual charged in error <br />$ (0.18) Rounding charged in error <br />$ (160.59) Total FY13 -Qtr1 Inv <br />FY12 AJ to adjust GL for diff Fed Indirect / PSF model <br />$ 26.59 AJE 81140 <br />P: \Cdocs \Contracts \Grants \Fed Plan Recon.xls 2 10/29/2012 <br />