进销存应收应付收支管理发票统计表

1、设置基础资料表商品信息，客户信息，供应商信息，根据自己的实际进行设置，商品名称+规格型号必须唯一。2、入库明细,出库明细，日期，往来单位，商品信息双击选择，其他手录。3、应收总账,应付总账点击查询按钮，选择起止日期，自动生成报表。4、客户对账，供应商对账点击查询按钮，选择起止日期和往来单位，自动生成明细账。5、收支查询，点击查询按钮，选择起止日期，自动生成收支明细账。必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,进销存管理系统带发票统计,今天是：43292.043292.0,サンプル,银 行 明 细日期凭证号码收入支出摘要,2017-1-1~2018-1-3142786.0,日期凭证号码/单号收入支出摘要结余42826.0,期初余额,43120.0,2月本月合计,2月本年累计,42826.0,4月本月合计,4月本年累计,商品名称规格型号单位进货价销售价供应商名称联系地址联系电话客户名称联系地址联系电话,卫龙散装火烧干巴系列5kg21.42佳和良品蓝调一品,源氏散装我醉牛5kg28.028.84康城果岭,源氏散装辣派头系列5kg28.028.84涵碧景苑,J帕克大叔气旋棒棒糖支103.0117.42昌吉江南小镇,J帕克大叔气旋棒棒糖50g支8.259.41嘉和园,好祺至臻礼盒罐61.267.32航空嘉园,BIKA 香脆鱼仔酥包4.64.88朗月盛境,J尚嗨FICANA荔枝酸奶味威化饼干条1.61.81伊犁东城花园,J自然味良品酥脆饼干包10.45龙海新和居,道吉草木瓜干10.74,道吉草水晶香蕉片6.87.62,J澳顿燕麦薏米浆420G,J澳顿红糖玄米露420G,J澳顿核桃南瓜子浆420G,J尚嗨蜂蜜味早餐麦片,J尚嗨甜味玉米片,J尚嗨混合水果味玉米片,小猪佩奇注心巧克力饼干10.07,日期凭证号码/单号供货商名称商品名称规格型号单位借方(付款)贷方（进货）开票备注,商品名称规格型号单位数量单价金额金额,卫龙散装火烧干巴系列5kg20.0360.01000.0,源氏散装我醉牛5kg20.0560.0,25.0700.0,J帕克大叔气旋棒棒糖支103.0618.0,J帕克大叔气旋棒棒糖50g支41.08.25338.25,好祺至臻礼盒61.2122.4,BIKA 香脆鱼仔酥80.0368.0,J尚嗨FICANA荔枝酸奶味威化饼干条48.01.676.8,J自然味良品酥脆饼干16.0152.0,道吉草木瓜干85.5,道吉草水晶香蕉片35.06.8238.0,J澳顿燕麦薏米浆420G36.0,J澳顿红糖玄米露420G,J澳顿核桃南瓜子浆420G14.0252.0,J尚嗨蜂蜜味早餐麦片24.0386.4,J尚嗨甜味玉米片144.9,J尚嗨混合水果味玉米片23.0370.3,小猪佩奇注心巧克力饼干19.0,J尚嗨巧克力味早餐麦片16.0257.6,J小麦饼（黑芝麻）7.063.0,J小麦饼（白芝麻）54.0,J可可乐白咖啡味威化饼干180.01.9342.0,J可可乐焦糖爆米花味威化饼干240.01.9456.0,J汉斯香蒜味奶酪意大利面酱65.0669.5,J汉斯蘑菇味意大利面酱53.0545.9,J汉斯传统口味意大利面酱51.0525.3,J汉斯原味意大利面酱55.0566.5,J汉斯意式奶酪意大利面酱55.0566.5,J清净园包饭酱27.020.5553.5,J茱蒂丝奶油苏打饼干10.7299.6,周义黄金腿5kg2.951539.0115.1085,卫龙散装火烧干巴系列5kg3.75367.554,源氏散装我醉牛5kg2.13359.724,原味米酥酥1.509519.529.43525,麻辣米酥酥1.511519.529.47425,J塞浦丽娜牌100%果汁礼盒62.462.4,J塞浦丽娜牌101%果汁礼盒40.9240.92,JDANA苹果葡萄果汁饮料,J优孚桃子果汁饮料,J优孚热带水果汁饮料,3.08886.464,J欧曼思亲爱的泰迪曲奇饼干(巧克力味)32.8,J(混合坚果味)欧曼思亲爱的泰迪曲奇饼干32.8,J(混合莓果味)欧曼思亲爱的泰迪曲奇饼干49.2,J利葡原味面包干12.663.0,利葡椰子味面包干12.637.8,J可可乐抹茶卷心酥威化饼干,J可可乐巧克力卷心酥威化饼干,J可可乐香蕉卷心酥威化饼干32.4,J可可乐香草味卷心酥威化饼干,沙巴哇芭蕉干100g7.053.9,沙巴哇综合蔬果干100g7.142.6,沙巴哇菠萝蜜干果100g8.643.0,沙巴哇芋头条干100g10.08.686.0,JBIKA 蜜糖虾味酥13.8,JBIKA 香脆海鲜酥13.8,JBIKA 香脆鱿鱼酥,JBIKA 蜜糖蟹味酥,JBIKA鸡味香薯片,JBIKA菜味香薯片23.0,J甜猫蓝莓酸奶味威化饼干11.911.9,J伦敦必吃牌巨堡牛奶味卷蛋糕7.87.8,J欧曼思亲爱的泰迪曲奇饼干(巧克力榛子味),J倍乐思提拉米苏味扁桃仁夹心白巧克力,J倍乐思草莓混合巧克力,J倍乐思榴莲味夹心牛奶巧克力,J一皇香脆薯片(酸奶油口味)8.48.4,每日坚果15.045.0,5.9165.2,42826.05000.0,42826.0发票25543542.05000.0,日期凭证号码/单号客户名称商品名称规格型号单位借方（销售）贷方（收款）开票备注,商品名称规格型号单位数量单价金额金额,43114.0蓝调一品小猪佩奇注心巧克力饼干10.0720.14,107.12000.0,8000.0,112.92,J自然味良品酥脆饼干10.45104.5,道吉草水晶香蕉片7.6238.1,J澳顿燕麦薏米浆420G39.6,J澳顿红糖玄米露420G,59.4,J小麦饼（黑芝麻）7.09.4566.15,J小麦饼（白芝麻）9.4556.7,113.4,周义黄金腿5kg2.951540.56119.71284,3.75380.38926,2.13361.51572,原味米酥酥1.509522.2333.556185,麻辣米酥酥1.511522.2333.600645,J塞浦丽娜牌100%果汁礼盒68.6468.64,J塞浦丽娜牌101%果汁礼盒54.9154.91,JDANA苹果葡萄果汁饮料17.9817.98,J优孚桃子果汁饮料瓶,J优孚热带水果汁饮料瓶,3.08889.05792,J欧曼思亲爱的泰迪曲奇饼干(巧克力味)32.8,J(混合坚果味)欧曼思亲爱的泰迪曲奇饼干32.8,J(混合莓果味)欧曼思亲爱的泰迪曲奇饼干49.2,J利葡原味面包干13.3666.8,利葡椰子味面包干13.3640.08,J可可乐抹茶卷心酥威化饼干,J可可乐巧克力卷心酥威化饼干,J可可乐香蕉卷心酥威化饼干36.28,J可可乐香草味卷心酥威化饼干,沙巴哇芭蕉干100g7.09.1664.12,沙巴哇综合蔬果干100g8.7352.38,沙巴哇菠萝蜜干果100g9.849.0,沙巴哇芋头条干100g9.898.0,JBIKA 蜜糖虾味酥15.03,JBIKA 香脆海鲜酥15.03,JBIKA 香脆鱿鱼酥,JBIKA 蜜糖蟹味酥,JBIKA鸡味香薯片,JBIKA菜味香薯片25.05,每日坚果15.03.1547.25,107.1,112.92,J自然味良品酥脆饼干10.4562.7,59.4,113.4,J甜猫蓝莓酸奶味威化饼干13.0913.09,J伦敦必吃牌巨堡牛奶味卷蛋糕8.668.66,J欧曼思亲爱的泰迪曲奇饼干(巧克力榛子味)8.478.47,J倍乐思提拉米苏味扁桃仁夹心白巧克力,J倍乐思草莓混合巧克力,J倍乐思榴莲味夹心牛奶巧克力,J一皇香脆薯片(酸奶油口味)9.799.79,嘉和园39.6,214.2,11.0317.24,346.08,17.0159.97,道吉草木瓜干9.010.7496.66,道吉草水晶香蕉片7.6276.2,118.8,8.090.72,43128.0龙海新和居,42944.002554515发票025154355000.0,进销存报表,开始日期:43101.0,结束日期:43128.0,行号商品名称规格型号单位上期结存本期入库本期销售本期结存,均价成本利润,卫龙散装火烧干巴系列5kg23.753427.55423.753427.554508.7892681.23526,源氏散装我醉牛5kg22.133619.72423.13328.0647.724667.1557219.43172-1.0-28.0,3.0源氏散装辣派头系列5kg33.988951.66430.08828.0842.464867.7379225.273923.9109.2,4.0J帕克大叔气旋棒棒糖支6.0618.05.0103.0515.0587.172.1103.0,5.0J帕克大叔气旋棒棒糖50g支41.0338.2541.08.25338.25385.8147.56,6.0好祺至臻礼盒罐122.461.2122.4,7.0BIKA 香脆鱼仔酥包80.0368.060.04.6276.0292.816.820.092.0,8.0J尚嗨FICANA荔枝酸奶味威化饼干条48.076.81.648.076.8,J自然味良品酥脆饼干包152.0152.0167.215.2,10.0道吉草木瓜干85.585.596.6611.16,道吉草水晶香蕉片35.0238.015.06.8102.0114.312.320.0136.0,12.0J澳顿燕麦薏米浆420G36.036.039.63.6,13.0J澳顿红糖玄米露420G19.81.8,J澳顿核桃南瓜子浆420G252.0252.0277.225.2,15.0J尚嗨蜂蜜味早餐麦片24.0386.4177.1186.018.9113.0209.3,J尚嗨甜味玉米片144.9144.9152.197.29,17.0J尚嗨混合水果味玉米片23.0370.3177.1186.018.9112.0193.2,小猪佩奇注心巧克力饼干19.019.020.141.14,合计:391.8745224.492272.9744210.5924568.5029357.9109118.91013.9,应收账款报表,2018-1-1~2018-1-31金额单位：元,序号客户名称上期应收账款余额借方发生额贷方发生额方向期末余额上期未开票开票未开票余额备注,1.0蓝调一品,2.0康城果岭-535.09贷-535.09-11535.09-11535.09,3.0涵碧景苑,4.0昌吉江南小镇,5.0嘉和园,6.0航空嘉园,7.0朗月盛境,8.0伊犁东城花园,9.0龙海新和居,应 付 账 款 报 表,2016-12-1~2017-12-31金额单位：元,序号供应商名称上期应付账款余额借方发生额贷方发生额方向期末余额上期未开票开票未开票余额备注,1.0佳和良品5000.011147.33贷6147.336000.05147.33,应 付 明 细 账,供应商：2016-12-1~2017-12-31金额单位：元,年凭证号码/单号客户名称商品名称规格型号单位借方贷方方向余额开票金额未开票余额备注,月日数量单价金额,上期结转平,卫龙散装火烧干巴系列5kg20.0360.0360.0-640.0,源氏散装我醉牛5kg20.0560.0920.0-80.0,25.0700.01620.0620.0,J帕克大叔气旋棒棒糖支103.0618.02238.01238.0,J帕克大叔气旋棒棒糖50g支41.08.25338.252576.251576.25,好祺至臻礼盒61.2122.42698.651698.65,BIKA 香脆鱼仔酥80.0368.03066.652066.65,J尚嗨FICANA荔枝酸奶味威化饼干条48.01.676.83143.452143.45,J自然味良品酥脆饼干16.0152.03295.452295.45,道吉草木瓜干85.53380.952380.95,道吉草水晶香蕉片35.06.8238.03618.952618.95,J澳顿燕麦薏米浆420G36.03654.952654.95,J澳顿红糖玄米露420G3672.952672.95,J澳顿核桃南瓜子浆420G14.0252.03924.952924.95,J尚嗨蜂蜜味早餐麦片24.0386.44311.353311.35,J尚嗨甜味玉米片144.94456.253456.25,J尚嗨混合水果味玉米片23.0370.34826.553826.55,小猪佩奇注心巧克力饼干19.04845.553845.55,J尚嗨巧克力味早餐麦片16.0257.65103.154103.15,J小麦饼（黑芝麻）7.063.05166.154166.15,J小麦饼（白芝麻）54.05220.154220.15,J可可乐白咖啡味威化饼干180.01.9342.05562.154562.15,J可可乐焦糖爆米花味威化饼干240.01.9456.06018.155018.15,J汉斯香蒜味奶酪意大利面酱65.0669.56687.655687.65,J汉斯蘑菇味意大利面酱53.0545.97233.556233.55,J汉斯传统口味意大利面酱51.0525.37758.856758.85,J汉斯原味意大利面酱55.0566.58325.357325.35,J汉斯意式奶酪意大利面酱55.0566.58891.857891.85,J清净园包饭酱27.020.5553.59445.358445.35,J茱蒂丝奶油苏打饼干10.7299.69744.958744.95,周义黄金腿5kg2.951539.0115.10859860.05858860.0585,卫龙散装火烧干巴系列5kg3.75367.5549927.61258927.6125,源氏散装我醉牛5kg2.13359.7249987.33658987.3365,原味米酥酥1.509519.529.4352510016.771759016.77175,麻辣米酥酥1.511519.529.4742510046.2469046.246,J塞浦丽娜牌100%果汁礼盒62.462.410108.6469108.646,J塞浦丽娜牌101%果汁礼盒40.9240.9210149.5669149.566,JDANA苹果葡萄果汁饮料10165.7669165.766,J优孚桃子果汁饮料10173.9669173.966,J优孚热带水果汁饮料10182.1669182.166,3.08886.46410268.639268.63,J欧曼思亲爱的泰迪曲奇饼干(巧克力味)32.810301.439301.43,J(混合坚果味)欧曼思亲爱的泰迪曲奇饼干32.810334.239334.23,J(混合莓果味)欧曼思亲爱的泰迪曲奇饼干49.210383.439383.43,J利葡原味面包干12.663.010446.439446.43,利葡椰子味面包干12.637.810484.239484.23,J可可乐抹茶卷心酥威化饼干10500.439500.43,J可可乐巧克力卷心酥威化饼干10516.639516.63,J可可乐香蕉卷心酥威化饼干32.410549.039549.03,J可可乐香草味卷心酥威化饼干10565.239565.23,沙巴哇芭蕉干100g7.053.910619.139619.13,沙巴哇综合蔬果干100g7.142.610661.739661.73,沙巴哇菠萝蜜干果100g8.643.010704.739704.73,沙巴哇芋头条干100g10.08.686.010790.739790.73,JBIKA 蜜糖虾味酥13.810804.539804.53,JBIKA 香脆海鲜酥13.810818.339818.33,JBIKA 香脆鱿鱼酥10827.539827.53,JBIKA 蜜糖蟹味酥10836.739836.73,JBIKA鸡味香薯片10845.939845.93,JBIKA菜味香薯片23.010868.939868.93,J甜猫蓝莓酸奶味威化饼干11.911.910880.839880.83,J伦敦必吃牌巨堡牛奶味卷蛋糕7.87.810888.639888.63,J欧曼思亲爱的泰迪曲奇饼干(巧克力榛子味)10896.339896.33,J倍乐思提拉米苏味扁桃仁夹心白巧克力10907.139907.13,J倍乐思草莓混合巧克力10917.939917.93,J倍乐思榴莲味夹心牛奶巧克力10928.739928.73,J一皇香脆薯片(酸奶油口味)8.48.410937.139937.13,每日坚果15.045.010982.139982.13,5.9165.2,2月本月合计,本年累计,4.0,4.0发票25543542.0,4月本月合计6000.0,本年累计6000.0,应 收 明 细 账,客户:2018-1-1~2018-1-31金额单位：元,年单号客户名称商品名称规格型号单位借方贷方方向余额开票金额未开票余额备注,月日数量单价金额,上期结转平0.0-5000.0,卫龙散装火烧干巴系列5kg21.42107.1-1892.9-4892.9,源氏散装我醉牛5kg28.84144.2-1748.7-12748.7,源氏散装辣派头系列5kg28.84144.2-1604.5-12604.5,J帕克大叔气旋棒棒糖支117.42117.42-1487.08-12487.08,J帕克大叔气旋棒棒糖50g支12.09.41112.92-1374.16-12374.16,BIKA 香脆鱼仔酥4.8897.6-1276.56-12276.56,J自然味良品酥脆饼干10.45104.5-1172.06-12172.06,道吉草水晶香蕉片7.6238.1-1133.96-12133.96,J澳顿燕麦薏米浆420G2.039.6-1094.36-12094.36,J澳顿红糖玄米露420G-1074.56-12074.56,J澳顿核桃南瓜子浆420G59.4-1015.16-12015.16,J尚嗨蜂蜜味早餐麦片-964.43-11964.43,J尚嗨甜味玉米片-913.7-11913.7,J尚嗨混合水果味玉米片-862.97-11862.97,J尚嗨巧克力味早餐麦片-812.24-11812.24,J小麦饼（黑芝麻）7.09.4566.15-746.09-11746.09,J小麦饼（白芝麻）6.09.4556.7-689.39-11689.39,J可可乐白咖啡味威化饼干2.1121.1-668.29-11668.29,J可可乐焦糖爆米花味威化饼干1.98-648.49-11648.49,J茱蒂丝奶油苏打饼干11.34113.4,1月本月合计1464.91,本年累计1464.91