财务出纳管理系统表

使用说明：,1.基础资料录入账户和项目,2.期初下拉选择对应账户，录入期初金额,3.收入明细录入对应记录，行不够可以复制,4.支出明细录入对应记录，行不够可以复制,5.日报表，每日收支，项目汇总，账户明细，账户汇总选择条件，自动统计,,收支账户项目名称月日,现金差旅费1.01.0,微信办公费2.02.0,支付宝租金3.03.0,工行水电费4.04.0,建行营业收入5.05.0,6.06.0,7.07.0,8.08.0,9.09.0,10.010.0,11.011.0,12.012.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,收支账户期初金额备注期初汇总8000.0日期,现金1500.01日,微信1000.02日,支付宝500.03日,工行2000.04日,建行3000.05日,6日,7日,8日,9日,10日,11日,12日,13日,14日,15日,16日,17日,18日,19日,20日,21日,22日,23日,24日,25日,26日,27日,28日,29日,30日,31日,收 入 登 记 表,筛选汇总统计2500.0,月日收款摘要收款账户收入金额所属项目,0.0提现现金500.0,0.02.0收到张华货款微信1500.0营业收入,2.06.0废品处理现金500.0营业收入,支 出 登 记 表,筛选汇总统计1150.0,月日付款摘要付款账户支出金额所属项目,0.0提现工行500.0,0.05.0付张总差旅费现金500.0差旅费,6.0付水电费支付宝50.0水电费,6.0支付上半年租金微信100.0租金,2月6日出纳收支报表选择月2.0,收款摘要收款账户收入金额序付款摘要付款账户支出金额选择日6.0,废品处理现金500.01.0付水电费支付宝,2.0支付上半年租金微信100.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,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,收款小计500.0付款小计150.0,期初资金9000.051.0结存资金9350.0,每 日 收 支 表月份1.0,日期期初收入支出结存,期初,1.0,2.01500.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,合计2000.01000.0,汇总收入支出差额,650.01350.0,项目名称收入支出差额,差旅费500.0-500.0,办公费,租金100.0-100.0,水电费50.0-50.0,营业收入,汇总期初收入支出结存,8000.02500.01150.09350.0,收支账户期初收入支出结存,现金1000.02000.0,微信1000.0100.02400.0,支付宝50.0450.0,工行2000.0,建行3000.03000.0,1月微信收支账户微信,日期期初收入支出结存月份1.0,期初,1.0,2.01500.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,合计1500.0