公式版应收账款自动统计表带发票统计表

应收账款自动统计模板(带发票统计),1、参数设置表录入客户名称以及期初余额和商品信息,2、凭证录入表，客户、品名列下拉选择,蓝色列有计算公式，自动显示，保护密码为空,3、报表查询下拉选择月份，自动统计，保护密码为空,4、明细账查询下拉选择客户，自动统计，保护密码为空,客户名称应收账款余额未开票余额品名单位,东华软件1000.0500.0鼠标个,浪潮集团2000.0600.0键盘个,用友软件3000.03000.0显示器台,一体机台,合计（动态）：43.099500.03500.0,2018.0单号客户名称品名单位借方已开票贷方备注,月日数量单价金额开票金额发票号码,14.0鼠标4000.0123456.0,18.07500.01500.0123456.0,9.027000.0,用友软件显示器,一体机6000.0,30.000000049000.0,0000004东华软件6000.0,0000001显示器5.010000.0,11.00000001一体机6.01500.09000.0,11.000000028.016000.0,12.00000002用友软件,13.0微信转账,应收账款累计报表,报表月份或累计：累计金额单位：元,序号客户名称上期应收账,款余额上期未开票金额借方,发生额已开票金额贷方,发生额方,向期末余额未开票金额备注,1.0东华软件1000.0500.06000.07000.06500.0,2.0浪潮集团2000.0600.088500.03500.02500.088000.085600.0,3.0用友软件3000.03000.05000.08000.08000.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,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,合 计6000.099500.02500.0103000.0,应收(浪潮集团)明细账4.08.0,客户：浪潮集团金额单位：元4.0,2018年凭证号码/单号摘要/品名及规格单位借方已开票贷方方,向余额未开票金额备注,月日数量单价金额开票金额发票号码,上期结转600.0,鼠标4000.0123456.06000.02600.0,18.07500.01500.0123456.013500.08600.0,29.027000.0,38500.0,38500.0,29.0一体机6000.046500.041600.0,30.000000049000.0,15000.0,53500.016.0,0000001显示器10000.065500.060600.0,0000001一体机1500.09000.074500.069600.0,00000028.016000.090500.0,微信转账16.0,35000.0,88500.0