进销存管理系统带财务管理表

北京市牛图文科技有限公司送货单,地址：XX区CC街道XX巷XXC号 电话：010-12388888NO:,客户名称：客户电话：制单人员：,客户地址：联 系 人：XS-181108-066送货日期：,序号产品名称规格单位数量单价（元）金额（元）备注白存根,红客户,黄回单,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,金额合计（大 写）：小写金额,注：以上货品请核对数量，如有质量问题，请在收货后3天内通知本公司。送货人： 收货人（签名）：,进 销 存 管 理 系 统,日期凭证单号出入类别收入发出结存,单价成本单价均价,1、【商品资料】【供应商信息】【客户信息】【员工信息】【账户信息】中，录入相应资料,编码列一定不能为空,不要纯数字的编码,2、【采购入库】【采购退货】双击选择供应商,商品信息,通过按钮进行单据的保存,查询,修改,删除操作, 【销售出库】【销售退货】双击选择客户,商品信息,通过按钮进行单据的保存,查询,修改,删除操作,3、【日常收入】双击选择日期,其他手录, 【日常支出】双击选择日期,其他手录,4、【账户总览】用于生成账户收支余总表, 【账户对账】用于生成账户收支明细报表,5、【采购付款】双击选择日期,供应商, 【供应总览】用于生成供应应付报表, 【供应对账】用于生成供应商往来明细报表,5、【销售收款】双击选择日期,供应商, 【客户总览】用于生成客户应收报表, 【客户对账】用于生成客户往来明细报表,7、【库存报表】录入起止日期,用于生成一定期间的出入库汇总表，点击利润按钮，自动生成利润报表,8、【明细检索】用于检索出入库明细记录,9、【单品台账】用于检索单品出入库明细记录,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,系统设置,序号项目参数,1.0初始化密码888888,2.0送货单打印格式抬头名称北京市牛图文科技有限公司,3.0公司联系地址(打印格式)XX区CC街道XX巷XXC号,4.0公司联系电话(打印格式)010-12388888,2.0入库单号样式选择 (示例)→→JH-181108-001,3.0其中:入库单单号字段一(自定义,如JH)JH,4.0 入库单单号字段二(日期格式)YYMMDD,5.0 入库单号默认位数(样式)000,6.0 间隔符-,7.0销售单号样式选择 (示例)→→XS-181108-0001,8.0其中:销售单单号字段一(自定义,如XS)XS,9.0 销售单单号字段二(日期格式)YYMMDD,10.0 销售单号默认位数(样式)000,11.0 间隔符-,应 付 账 款 总 览,2018/8/1~2018/10/31金额单位：元,序号编号供货商上期应付账款余额本期应付本期已付方向期末余额,1.0GY001广西红水河水泥股份有限公司1870086.757510000.0借-5639913.25,2.0GY002广西贵港川海商贸有限公司76866.0借-76866.0,合计1870086.757586866.0-5716779.25,应 付 明 细 账,编码：GY001供应商:广西红水河水泥股份有限公司（贵港）2018-8-1~2018-8-31,年单号编号品名规格单位借方贷方方向余额备注,月日数量单价金额,上期结转平,9.0JH-180809-001SP-001水泥P·O 42.5R_散装吨355.0贵港区域,9.0480000.01390086.75,10.0200000.01190086.75,13.01000000.0190086.75,23.0500000.0,8月本月合计2180000.0,8月本年累计2180000.0,应 收 明 细 账,编码：KH001客户:广西高强混凝土有限公司2018-9-1~2018-9-30,年单号编号品名规格单位借方贷方方向余额备注,月日数量单价金额,上期结转1162173.0,1.0XS-180901-00288.133478.01195651.0,2.0XS-180902-00390.5534409.01230060.0,4.0XS-180904-00884.332034.01262094.0,5.0XS-180905-01082.031160.01293254.0,5.0XS-180905-01085.5532509.01325763.0,6.0XS-180906-01287.4533231.01358994.0,8.0XS-180908-01489.7534105.01393099.0,10.0XS-180910-01884.932262.01425361.0,11.0XS-180911-02093.035340.01460701.0,12.0XS-180912-02387.6533307.01494008.0桂R08720,12.0XS-180912-02391.534770.01528778.0,13.0XS-180913-02696.8536803.01565581.0,13.0XS-180913-02687.3533193.01598774.0,14.0XS-180914-02985.7532585.01631359.0,85.7532585.01663944.0,88.9533801.01697745.0,84.231996.01729741.0,86.332794.01762535.0,18.0XS-180918-03688.733706.01796241.0,92.0534979.01831220.0桂R08628,85.932642.01863862.0桂R08720,87.7533345.01897207.0桂R03672,XS-180921-04387.5533269.01930476.0桂R66732,XS-180921-04383.7531825.01962301.0,150000.01812301.0,22.0XS-180922-04687.033060.01845361.0,85.3532433.01877794.0,85.0532319.01910113.0,90.9534561.01944674.0桂R35627,26.0XS-180926-05492.335074.01979748.0,90.2534295.02014043.0,92.5535169.02049212.0桂R36572,87.3533193.02082405.0,95.3536233.02118638.0桂R36572,93.2535435.02154073.0桂R35627,190000.01964073.0,200000.0,9月本月合计3005.01141900.0540000.0,9月本年累计6063.352304073.0540000.0,应 收 账 款 总 览,2018/8/1~2018/10/31金额单位：元,序号编号客户名称上期应收余额本期应收本期已收方向期末余额,1.0KH001广西高强混凝土有限公司530955.0530955.0,2.0KH002桂平市高强混凝土有限公司299934.0299934.0,3.0KH003广西新鸿强混凝土有限公司67032.067032.0,4.0KH004广西润勤投资有限公司平,合计897921.0897921.0,账 户 总 览,2018/8/1~2018/10/31金额单位：元,序号账户上期余额本期收入本期支出期末余额,1.0基本户480000.0-480000.0,2.0一般户,3.0现金,4.0建设银行,合计480000.0-480000.0,账 户 明 细 账,账户：基本户,年摘要收入支出方向余额,月日,上期结转平0.0,480000.0-480000.0,-280000.0,-480000.0,13.01000000.0-1480000.0,23.0-1980000.0,24.01000000.0,8月3180000.0,8月3180000.0,4.0-2930000.0,4.047387.0-2882613.0,600000.0-2282613.0,-2232613.0,-2182613.0,14212.0-2168401.0,-2218401.0,600000.0,-2718401.0,-2668401.0,-2618401.0,-2568401.0,-2518401.0,-2468401.0,-2468401.0,-2368401.0,-2618401.0,120000.0-2848401.0,30000.0,190000.0-2778401.0,-2578401.0,-2478401.0,-2678401.0,-2778401.0,9月3451599.03450000.0,9月3651599.06630000.0,60000.0-3038401.0,400000.0-2638401.0,-2938401.0,76866.0-3015267.0,179000.0-2836267.0,400000.0-3236267.0,120000.0-3356267.0,321000.0-3035267.0,-2985267.0,-2935267.0,-2635267.0,-2735267.0,16.0-2235267.0,16.0-2735267.0,-2585267.0,-2385267.0,-2535267.0,260000.0-2425267.0,40000.0-2385267.0,10月2450000.02156866.0,10月6101599.08786866.0,日期编号供应商金额账户备注,日期编号客户金额账户备注,客户编号客户名称联系地址联系电话联系人期初余额,KH001广西高强混凝土有限公司,KH002桂平市高强混凝土有限公司,KH003广西新鸿强混凝土有限公司,KH004广西润勤投资有限公司,KH005陈庆弟水泥制品厂,KH006梁健明,供应商编号供应商名称联系地址联系电话联系人期初余额,GY001广西红水河水泥股份有限公司（贵港）,GY002广西红水河水泥股份有限公司（桂平）,GY003广西贵港川海商贸有限公司,商品编号商品名称规格单位进价售价实时库存库存下限补货提示期初数量单价金额账户期初余额,SP-001P·O 42.5R_散装基本户,SP-002P·O 42.5_散装一般户,SP-003P·Ⅱ 42.5R_散装现金,建设银行,XX贸易有限公司采购单当前日期43412.0,当前单号6.0,供应商：开单日期:2018-11-8单据编号:JH-181108-006默认行数10.0,地 址:电 话：联 系 人：,序号商品编号名称规格单位数量单价金额备 注,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,合 计人民币(大写) 零元(小写):,备 注,开票员： 司磅员：财会：验收人：凌寒,XX贸易有限公司销售单当前日期43412.0备注类别订货号,地址：xx路3幢3-13号,联系电话：0000-12345678 联系人：当前单号66.0,收货单位：开单日期:2018-11-8单据编号:XS-181108-066默认行数10.0,地 址:电 话：联 系 人：,序号商品编号名称规格单位数量单价金额备 注,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,合 计人民币(大写) 零元,备 注,开票员： 司磅员：财会：验收人：凌寒,北京市牛图文科技有限公司入库单,地址：XX区CC街道XX巷XXC号 电话：010-12388888NO:,供 货 商：供货商电话：制单人员：23,地 址：联 系 人：JH-181108-006收货日期：,序号产品名称规格单位数量单价（元）金额（元）备注白存根,红客户,黄回单,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,金额合计（大 写）：人民币(大写) 零元小写金额,注：以上货品请核对数量，如有质量问题，请在收货后3天内通知本公司。23,行号单据类型日期单号单位编号往来单位地址电话联系人商品编号名称规格单位数量单价金额明细备注总备注制单人,1.043321.0JH-180809-0015267.85355.01870086.75贵港区域,2.0XS-180810-00184.432072.0桂KP0872,3.0XS-180810-00192.3535093.0桂R11685,4.0XS-180810-00288.633668.0,5.0XS-180810-00287.833364.0桂R11928,6.090.9534561.0桂AH2656,7.081.7531065.0桂R32702,8.088.5533649.0桂R33771,9.089.3533953.0,10.085.0532319.0,11.084.8532243.0,12.087.1533117.0,13.0XS-180812-00591.1534637.0,14.0XS-180812-00588.1533497.0,15.0XS-180812-00682.731426.0桂R13738,16.043325.0XS-180813-00786.732946.0,17.043325.0XS-180813-00787.433212.0,18.0XS-180814-00885.332414.0,19.094.235796.0,20.085.232376.0,21.094.4535891.0,22.085.532490.0,23.087.833364.0,24.087.233136.0,25.086.4532851.0,26.0JH-180816-002491.32171962.0武林港中转库,27.0JH-180816-002715.28250348.0,28.087.5533269.0,29.087.1533117.0桂R58166,30.085.2532395.0,31.043329.0XS-180817-01284.5532129.0,32.043329.0XS-180817-01289.2533915.0,33.084.131958.0,34.081.931122.0,35.085.332414.0,36.087.4533231.0,37.085.232376.0,38.085.832604.0,39.087.8533383.0,40.0XS-180819-01598.337354.0,41.0XS-180819-01691.4534751.0,42.0XS-180819-01691.3534713.0,43.043332.0XS-180820-01781.831084.0,44.043332.0XS-180820-01790.1534257.0,45.043333.0XS-180821-01886.832984.0,46.043333.0XS-180821-01892.6535207.0,47.0XS-180822-01994.6535967.0,48.0XS-180822-01989.133858.0,49.0XS-180822-02091.1534637.0,50.0XS-180823-02187.0533079.0,51.0XS-180823-02285.8532623.0,52.0XS-180823-02292.235036.0,53.043336.0XS-180824-02381.3530913.0,54.043337.0XS-180825-02487.2533155.0,55.043338.0XS-180826-02586.432832.0,56.0XS-180827-02692.7535245.0,57.0XS-180827-02692.535150.0,58.0XS-180827-02789.834124.0,59.0XS-180827-02785.3532433.0,60.0XS-180828-02886.732946.0桂R8720,61.056.2821386.4,62.050.6419243.2,63.054.5420725.2,64.0XS-180829-02986.933022.0,65.060.3422929.2,66.054.620748.0,67.060.923142.0,68.060.6623050.8,69.055.1220945.6,70.056.6421523.2,71.055.6221135.6桂KH3697,72.064.3424449.2,73.0XS-180830-03087.133098.0,74.0XS-180830-03084.932262.0,75.057.6421903.2,76.053.0220147.6,77.058.7222313.6桂KH3697,78.064.6424563.2,79.056.7221553.6,80.054.220596.0,81.061.7223453.6,82.051.5619592.8,83.060.3622936.8,84.0JH-180901-0031579.9360.0568764.0,85.02194.8335.0735258.0,86.0554.76325.0180297.0武林港中转库,87.05040.68325.01638221.0,88.0XS-180901-00158.3422169.2,89.0XS-180901-00161.3623316.8,90.0XS-180901-00288.133478.0,91.0XS-180902-00390.5534409.0,92.060.4222959.6,93.052.7620048.8,94.058.8622366.8,95.053.8418305.6,96.060.2620488.4,97.056.9619366.4,98.058.0419153.2,99.053.6420383.2,100.056.8621606.8,101.064.3624456.8,102.0XS-180903-00759.0420073.6,103.0XS-180904-00884.332034.0,104.052.920102.0,105.058.7222313.6,106.059.422572.0,107.056.8221591.6,108.050.7419281.2,109.021652.4,110.061.2823286.4,111.0XS-180905-01082.031160.0,112.0XS-180905-01085.5532509.0,113.059.6622670.8,114.053.620368.0,115.058.0222047.6,116.043349.0XS-180906-01287.4533231.0,117.053.7220413.6,118.058.622268.0,119.060.1422853.2,120.0XS-180908-01489.7534105.0,121.061.6423423.2,122.054.6620770.8,123.055.8821234.4,124.059.7222693.6,125.054.7820816.4,126.061.4823362.4,127.051.5817537.2,128.057.119414.0,129.059.6420277.6,130.051.6417557.6,131.059.3220168.8,132.056.6419257.6,133.043352.0XS-180909-01758.1422093.2,134.0XS-180910-01963.0823970.4,135.0XS-180910-01955.0220907.6,136.0XS-180910-01884.932262.0,137.0XS-180911-02093.035340.0,138.0XS-180911-02159.9422777.2,139.0XS-180911-02161.9223529.6,140.0XS-180911-02262.023560.0,141.0XS-180911-02252.8420079.2,142.0XS-180912-02387.6533307.0,143.0XS-180912-02391.534770.0,144.059.0222427.6,145.051.5419585.2,146.060.8623126.8,147.058.6822298.4,148.055.1418747.6,149.051.1817401.2,150.060.2219872.6,151.0XS-180913-02696.8536803.0,152.0XS-180913-02687.3533193.0,153.059.5622632.8,154.048.3818384.4,155.059.4822602.4,156.0XS-180913-02860.1220440.8,157.0XS-180913-02861.020740.0,158.0XS-180914-02985.7532585.0,159.061.2623278.8,160.061.9223529.6,161.054.3820664.4,162.060.9823172.4,163.051.1616882.8,164.048.2215912.6,165.051.6617047.8,166.085.7532585.0,167.088.9533801.0,168.084.231996.0,169.086.332794.0,170.0XS-180915-03359.2422511.2,171.019373.2,172.050.1217040.8,173.055.3618822.4,174.050.6416711.2,175.051.7217067.6,176.051.617544.0,177.056.9619366.4,178.056.9219352.8,179.052.4617836.4,180.052.2417761.6,181.051.9217133.6,182.054.3417932.2,183.0JH-180918-0041604.5561575.0,184.0XS-180918-03688.733706.0,185.056.5421485.2,186.061.5623392.8,187.056.921622.0,188.092.0534979.0桂R08628,189.085.932642.0,190.087.7533345.0桂R03672,191.060.6623050.8,192.061.9823552.4,193.051.8819714.4,194.0XS-180919-04053.9818353.2,195.0XS-180919-04054.9218672.8,196.055.318802.0,197.055.3418815.6,198.055.0418713.6,199.058.719958.0,200.058.419856.0,201.054.2818455.2,202.0XS-180921-042KH005陈庆弟水泥制品厂92.034960.0,203.0XS-180921-04387.5533269.0,204.0XS-180921-04383.7531825.0,205.0XS-180921-04455.5621112.8,206.0XS-180921-04553.8217760.6,207.0XS-180921-04548.5416018.2,208.0XS-180922-04687.033060.0,209.058.722306.0,210.060.122838.0,211.055.4421067.2,212.061.3223301.6,213.062.8823894.4,214.0XS-180923-04861.9823552.4,215.0XS-180923-04859.722686.0,216.0XS-180923-04956.218546.0桂R31667,217.0XS-180923-04948.9216143.6,218.0XS-180925-050KH005陈庆弟水泥制品厂87.433212.0桂R58166,219.085.3532433.0,220.085.0532319.0,221.090.9534561.0,222.0XS-180925-05263.1824008.4,223.0XS-180925-05261.8223491.6,224.0XS-180925-05348.215906.0,225.0XS-180926-05492.335074.0,226.060.2222883.6,227.059.1422473.2,228.060.7423081.2,229.0XS-180926-05652.0217166.6,230.0XS-180926-05650.0216506.6,231.061.4823362.4,232.056.6221515.6,233.061.823484.0,234.057.6219590.8,235.058.6219930.8,236.059.9820393.2,237.0XS-180928-05962.9823932.4,238.0XS-180928-05964.2624418.8,239.0XS-180928-06055.7618400.8,240.0XS-180928-06051.2816922.4,241.058.0822070.4,242.060.9623164.8,243.051.019380.0,244.052.3619896.8,245.055.8418985.6,246.019373.2,247.053.9417800.2,248.052.7617410.8,249.090.2534295.0,250.092.5535169.0,251.087.3533193.0,252.095.3536233.0,253.093.2535435.0,254.058.6222275.6,255.058.5222237.6,256.059.9422777.2,257.056.519210.0,258.055.8418985.6,259.061.3620862.4,260.060.020400.0,261.051.0616849.8,262.052.8417437.2,,单 品 账 簿,代码：SP-003名称：水泥2018/8/1~2018/10/31,日期单据号出入类别本期入库本期出库本期结存,月日成本,期初库存,1.0JH-180901-005入库,53.8418036.418305.62140.96717221.6,60.2620187.120488.42080.7697034.5,56.9619081.619366.42023.74677952.9,3.0XS-180903-00759.0419778.420073.61964.7658174.5,51.5817279.317537.21913.12640895.2,57.119128.519414.01856.02621766.7,59.6419979.420277.61796.38601787.3,51.6417299.417557.61744.74584487.9,59.3219872.220168.81685.42564615.7,56.6418974.419257.61628.78545641.3,12.0XS-180912-02555.1418471.918747.61573.64527169.4,12.0XS-180912-02551.1817145.317401.21522.46510024.1,13.0XS-180913-02860.1220140.220440.81462.34489883.9,13.0XS-180913-02861.020435.020740.01401.34469448.9,56.9819088.319373.21344.36450360.6,50.1216790.217040.81294.24433570.4,55.3618545.618822.41238.88415024.8,51.617286.017544.01187.28397738.8,56.9619081.619366.41130.32378657.2,56.9219068.219352.81073.4359589.0,52.4617574.117836.41020.94342014.9,52.2417500.417761.6968.7324514.5,19.0XS-180919-04053.9818083.318353.2914.72306431.2,19.0XS-180919-04054.9218398.218672.8859.8288033.0,55.318525.518802.0804.5269507.5,55.3418538.918815.6749.16250968.6,55.0418438.418713.6694.12232530.2,58.719664.519958.0635.42212865.7,58.419564.019856.0577.02193301.7,54.2818183.818455.2522.74175117.9,57.6219302.719590.8465.12155815.2,58.6219637.719930.8406.5136177.5,59.9820093.320393.2346.52116084.2,29.0XS-180929-06255.8418706.418985.6290.6897377.8,29.0XS-180929-06256.9819088.319373.2233.778289.5,56.518927.519210.0177.259362.0,55.8418706.418985.6121.3640655.6,61.3620555.620862.460.020100.0,60.020100.020400.0,本月合计746232.0,进销存报表,开始日期:43101.0,结束日期:43465.0,行号产品编号产品名称规格型号单位上期结存本期入库本期销售本期结存,均价成本利润,1.0SP-001P·O 42.5R_散装8452.253000425.758452.25354.9854476623000425.753211855.0211429.25,2.0SP-002P·O 42.5_散装6802.042240828.06802.04329.4346990022240828.02527111.2286283.2,3.0SP-003P·Ⅱ 42.5R_散装2194.8735258.02194.8335.0735258.0746232.010974.0,合计:17449.095976511.7517449.095976511.756485198.2508686.45,查询结果→→合 计1861.1707218.0,查询条件↓↓行号单据类型日期单号单位编号往来单位地址电话联系人商品编号名称规格单位数量单价金额明细备注总备注经手人,开始日期43313.020.043324.0XS-180812-00591.1534637.0桂R35627,结束日期43343.021.043324.0XS-180812-00588.1533497.0,单据类型22.043325.0XS-180813-00786.732946.0桂R57712,单 号23.043325.0XS-180813-00787.433212.0,往来单位24.043326.0XS-180814-00885.332414.0,货品编号31.043331.0XS-180819-01598.337354.0,货品名称34.043334.0XS-180822-01994.6535967.0,制单人35.043334.0XS-180822-01989.133858.0桂AG1702,37.043335.0XS-180823-02187.0533079.0,44.043340.0XS-180828-02886.732946.0桂R8720,46.084.131958.0,47.081.931122.0桂AG1702,48.085.332414.0桂AH2602,51.043333.0XS-180821-01886.832984.0桂R57712,52.043333.0XS-180821-01892.6535207.0,53.043339.0XS-180827-02692.7535245.0桂R35627,54.043339.0XS-180827-02692.535150.0,57.090.9534561.0桂AH2656,58.081.7531065.0桂R32702,59.088.5533649.0桂R33771,60.089.3533953.0,利 润 表,公司名称： 牛图文贸易有限公司 年 月 日 单位：元,项目本月数本年累计数,一、主营业务收入（当月销售收入）6485198.26485198.2,减：主营业务成本（采购）5976511.755976511.75,二、主营业务利润,加：日常收入,减：日常支出,三、净利润,四.库存资产（库存）,单位负责人： 财务负责人： 制表人：,编号姓名,A001丘玉冰