年度各月費用預算及執(zhí)行控制圖表（自動提取各月數據）

財務管理工具——預算管理,,,,,,,,,

年度各月費用預算及執(zhí)行控制圖表（根據支出明細自動提取各月數據）,,,,,,,,,

說明：本工具主要用于統(tǒng)計分析某一項目全年每月費用預算及實際支出情況，具體包括全年以及各月的實際與預算差額、差異率。（分析表格中各月的數據由支出費用明細表自動生成）,,,,,,,,,

支出費用明細（日常錄入數據，差額及差異率自動顯示）,,,,,,,,,

序號,日期/時間,費用項目類別,具體項目名稱,預算,實際,差額,差異率,支出方式,經手人

1,2016/1/20,費用類別1,,"￥4,800.00","￥5,600.00",￥800.00,16.67%,,

2,2016/1/20,費用類別3,,"￥2,300.00","￥2,600.00",￥300.00,13.04%,,

3,2016/2/21,費用類別5,,"￥5,000.00","￥5,600.00",￥600.00,12.00%,,

4,2016/2/23,費用類別2,,"￥3,000.00","￥3,200.00",￥200.00,6.67%,,

5,2016/2/25,費用類別1,,"￥1,200.00","￥1,600.00",￥400.00,33.33%,,

6,2016/2/26,費用類別5,,"￥1,500.00","￥1,000.00",￥-500.00,-33.33%,,

7,2016/3/2,費用類別4,,"￥1,800.00","￥1,500.00",￥-300.00,-16.67%,,

8,2016/3/14,費用類別3,,"￥2,100.00","￥2,800.00",￥700.00,33.33%,,

9,2016/3/25,費用類別2,,"￥2,400.00","￥2,700.00",￥300.00,12.50%,,

10,2016/4/25,費用類別1,,"￥2,700.00","￥2,700.00",￥0.00,0.00%,,

11,2016/4/25,費用類別1,,"￥3,000.00","￥2,700.00",￥-300.00,-10.00%,,

12,2016/4/26,費用類別6,,"￥3,300.00","￥3,600.00",￥300.00,9.09%,,

13,2016/5/26,費用類別5,,"￥3,600.00","￥3,800.00",￥200.00,5.56%,,

14,2016/5/27,費用類別3,,"￥3,900.00","￥4,500.00",￥600.00,15.38%,,

15,2016/5/28,費用類別2,,"￥4,200.00","￥4,300.00",￥100.00,2.38%,,

16,2016/5/29,費用類別3,,"￥4,500.00","￥3,900.00",￥-600.00,-13.33%,,

17,2016/6/1,費用類別1,,"￥4,800.00","￥4,900.00",￥100.00,2.08%,,

18,2016/6/3,費用類別4,,"￥5,100.00","￥4,900.00",￥-200.00,-3.92%,,

19,2016/6/5,費用類別2,,"￥5,400.00","￥5,900.00",￥500.00,9.26%,,

20,2016/6/22,費用類別3,,"￥5,700.00","￥6,000.00",￥300.00,5.26%,,

21,2016/7/12,費用類別2,,"￥6,000.00","￥6,100.00",￥100.00,1.67%,,

22,2016/7/13,費用類別6,,"￥6,300.00","￥6,800.00",￥500.00,7.94%,,

23,2016/7/27,費用類別1,,"￥6,600.00","￥6,900.00",￥300.00,4.55%,,

24,2016/8/8,費用類別3,,"￥6,900.00","￥7,400.00",￥500.00,7.25%,,

25,2016/8/29,費用類別6,,"￥7,200.00","￥7,500.00",￥300.00,4.17%,,

26,2016/8/31,費用類別2,,"￥7,500.00","￥7,500.00",￥0.00,0.00%,,

27,2016/9/1,費用類別2,,"￥7,500.00","￥7,800.00",￥300.00,4.00%,,

28,2016/9/2,費用類別6,,"￥7,500.00","￥7,800.00",￥300.00,4.00%,,

29,2016/9/3,費用類別1,,"￥7,500.00","￥7,200.00",￥-300.00,-4.00%,,

30,2016/9/30,費用類別2,,"￥7,500.00","￥7,800.00",￥300.00,4.00%,,

31,2016/10/1,費用類別3,,"￥7,500.00","￥7,800.00",￥300.00,4.00%,,

32,2016/10/2,費用類別2,,"￥7,500.00","￥5,800.00","￥-1,700.00",-22.67%,,

33,2016/10/3,費用類別1,,"￥7,500.00","￥7,100.00",￥-400.00,-5.33%,,

34,2016/10/31,費用類別3,,"￥7,500.00","￥7,800.00",￥300.00,4.00%,,

35,2016/11/1,費用類別2,,"￥7,800.00","￥8,500.00",￥700.00,8.97%,,

36,2016/11/2,費用類別3,,"￥8,100.00","￥9,000.00",￥900.00,11.11%,,

37,2016/11/3,費用類別1,,"￥8,100.00","￥9,000.00",￥900.00,11.11%,,

38,2016/12/1,費用類別6,,"￥8,100.00","￥9,900.00","￥1,800.00",22.22%,,

39,2016/12/2,費用類別4,,"￥8,100.00","￥8,000.00",￥-1