淘宝微信进货销售收入管理系统表

xxx公司淘宝店出售,进货,财务管理系统,说明:所有表格蓝色填充部分是自动计算的,进货记录货物清单库存记录出售记录财务分析, xxxxx进货记录,序号进货日期产品编号产品名称进货方进价进货数量备注,1.01234556xx洗面奶123.0,1234587护肤套装124.0,3.04551122眼霜,4587541护手霜,2233144滴眼液,6.04561122裙子,7.04456644裤子8.0,8.045332111短袖60.09.0,9.05565621衬衫52.07.0,4456566杯子,11.0,6.0,13.04456644裤子,14.045332111短袖60.01.0,5565621衬衫52.0,16.04456566杯子,17.0,18.03.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0, xxxxx货物清单,序号产品编号产品名称进货方进价建议零售价添加日期备注,1.01234556xx洗面奶123.0200.0,2.01234587护肤套装124.0200.0,3.04551122眼霜,4.04587541护手霜,5.02233144滴眼液,6.04561122裙子50.086.0,7.04456644裤子50.086.0,8.045332111短袖60.085.0,9.05565621衬衫52.065.0,10.04456566杯子,11.01122334西装89.0120.0,4556211牙膏10.0,13.0,14.0,16.0,17.0,18.0,19.0,21.0,22.0,23.0,24.0,26.0,27.0,28.0, xxxx库存记录,产品编号产品名称进货数量出售数量库存数量现有数量安全库存差值备注,1234556xx洗面奶,1234587护肤套装1.0-7.0,4551122眼霜8.0-2.0,4587541护手霜-10.0,2233144滴眼液7.0-3.0,4561122裙子-2.0,4456644裤子1.0,45332111短袖8.0,5565621衬衫12.0,4456566杯子-1.0,1122334西装12.0-4.0,4556211牙膏13.09.0-1.0,出售记录,说明：分摊运费 分摊运费成本和分摊优惠按照自己的规则进行定义，主要是一个订单编号有多个产品时需要进行分摊,序号出售日期出售年月订单编号产品编号产品名称进价出售单价出售数量进价成本分摊运费分摊优惠总收入运费分摊成本总盈利备注,43478.02019-1jd201906130011234587护肤套装124.0250.0124.0240.0230.0,43509.02019-2jd201906130024551122眼霜,4587541护手霜25.024.038.0,2233144滴眼液18.0,4561122裙子68.0200.0272.0268.0,6.04456644裤子56.0250.0280.0277.5,7.045332111短袖60.080.0120.0160.0158.0,9.04456566杯子49.5,1122334西装120.0445.0600.0597.5,11.04556211牙膏60.057.0,2233144滴眼液16.032.029.0,13.04561122裙子55.055.051.0,14.05565621衬衫58.0104.0116.0112.0,4456566杯子,16.01122334西装90.090.087.0,2019年历月销售分析,表1:历月销售收入与毛利,年月总收入进价成本运费成本总成本总盈利毛利率,2019-1240.0124.010.0134.0106.00.441666666667,2019-240.030.010.040.0,2019-3332.0239.08.0247.085.00.256024096386,2019-41092.0827.09.5836.5255.50.233974358974,2019-5,2019-6368.0325.020.0345.023.00.0625,2019-7,2019-8,2019-9,2019-10,2019-11,2019-12,汇总2072.01545.057.51602.5469.50.198833024405