财务费用预算管理系统表

1、【费用设定】【部门设定】中，录入费用明细以及部门信息和预算金额,2、【费用明细】点击费用录入按钮，通过窗体录入部门，费用明细以及金额,3、【统计报表】用自动生成，可根据实际修改公式，增加项目,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,,支出分类销售费用管理费用财务费用,1.0广告费招待费贷款利息,2.0宣传费办公费,3.0促消费,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,预算部门部门预算,1.0办公室,2.0财务部5000.0,3.0人事部,4.0后勤部,5.0信息部,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,日期部门费用分类明细金额备注,销售费用广告费600.0,管理费用招待费200.0,财务部财务费用贷款利息200.0,管理费用招待费50.0,部门名称销售费用管理费用财务费用费用合计预算状态,办公室600.0250.0850.0150.0,财务部5000.04800.0,人事部,后勤部,信息部,总计600.0250.02750.0,费用,预算,余额,比率0.7