进销存汇总表.xlsx

进销存汇总表编码存货名称借贷方向期初余额数量期初单价期初余额金额本期借方发生数量入库单价本期借方发生金额本期贷方发生数量出库单价本期贷方发生金额借贷方向期末余额数量结存单价期末余额金额A0001海报借350.00 138.95 48,632.50 800.00 141.25 113,000.00 254.00 140.55 35,699.70 借896.00 140.55 125,932.80 A0002展板借360.00 96.29 34,664.40 1,000.00 102.30 102,300.00 360.00 100.71 36,255.28 借1,000.00 100.71 100,709.12 A0003明信片借159.00 42.90 6,821.10 2,500.00 40.32 100,800.00 155.00 40.47 6,273.51 借2,504.00 40.47 101,347.59 合计869.00 90,118.00 4,300.00 316,100.00 769.00 78,228.50 0.00 4,400.00 327,989.50 备注：此表已按加权平均法计算发出商品成本方式添加公式。