年度各月费用预算及执行控制图表（自动提取各月数据）

财务管理工具——预算管理,,,,,,,,,

年度各月费用预算及执行控制图表（根据支出明细自动提取各月数据）,,,,,,,,,

说明：本工具主要用于统计分析某一项目全年每月费用预算及实际支出情况，具体包括全年以及各月的实际与预算差额、差异率。（分析表格中各月的数据由支出费用明细表自动生成）,,,,,,,,,

支出费用明细（日常录入数据，差额及差异率自动显示）,,,,,,,,,

序号,日期/时间,费用项目类别,具体项目名称,预算,实际,差额,差异率,支出方式,经手人

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