Excel模板：进销存-出入库存统计表.xlsx
出出入入库库存存统统计计汇汇总总序序号号品品名名物物料料编编码码型型号号 单单位位期期初初库库存存本本月月入入库库数数量量单单价价金金额额数数量量单单价价1商品1A001300*500只100￥0.80￥80.003000￥0.802商品2A002300*501袋101￥1.80￥181.803001￥1.803商品3A003300*502只102￥2.80￥285.603002￥2.804商品4A004300*503袋103￥3.80￥391.403003￥3.805商品5A005300*504只104￥4.80￥499.203004￥4.806商品6A006300*505袋105￥5.80￥609.003005￥5.807商品7A007300*506只106￥6.80￥720.803006￥6.808商品8A008300*507袋107￥7.80￥834.603007￥7.809商品9A009300*508只108￥8.80￥950.403008￥8.8010商品10A010300*509袋109￥9.80￥1,068.203009￥9.8011商品11A011300*510只110￥10.80￥1,188.003010￥10.8012商品12A012300*511袋111￥11.80￥1,309.803011￥11.8013商品13A013300*512只112￥12.80￥1,433.603012￥12.8014商品14A014300*513袋113￥13.80￥1,559.403013￥13.8015商品15A015300*514只114￥14.80￥1,687.203014￥14.8016商品16A016300*515袋115￥15.80￥1,817.003015￥15.8017商品17A017300*516只116￥16.80￥1,948.803016￥16.8018商品18A018300*517袋117￥17.80￥2,082.603017￥17.8019商品19A019300*518只118￥18.80￥2,218.403018￥18.8020商品20A020300*519袋119￥19.80￥2,356.203019￥19.8021商品21A021300*520只120￥20.80￥2,496.003020￥20.8022商品22A022300*521袋121￥21.80￥2,637.803021￥21.8023商品23A023300*522只122￥22.80￥2,781.603022￥22.80合合计计25532553￥31,137.4031,137.406925369253本本月月出出库库期期未未库库存存金金额额数数量量单单价价金金额额数数量量单单价价金金额额￥2,400.002800￥1.02￥2,856.00300.00￥0.80￥240.00￥5,401.802801￥2.02￥5,658.02301.00￥1.80￥541.80￥8,405.602802￥3.02￥8,462.04302.00￥2.80￥845.60￥11,411.402803￥4.02￥11,268.06303.00￥3.80￥1,151.40￥14,419.202804￥5.02￥14,076.08304.00￥4.80￥1,459.20￥17,429.002805￥6.02￥16,886.10305.00￥5.80￥1,769.00￥20,440.802806￥7.02￥19,698.12306.00￥6.80￥2,080.80￥23,454.602807￥8.02￥22,512.14307.00￥7.80￥2,394.60￥26,470.402808￥9.02￥25,328.16308.00￥8.80￥2,710.40￥29,488.202809￥10.02￥28,146.18309.00￥9.80￥3,028.20￥32,508.002810￥11.02￥30,966.20310.00￥10.80￥3,348.00￥35,529.802811￥12.02￥33,788.22311.00￥11.80￥3,669.80￥38,553.602812￥13.02￥36,612.24312.00￥12.80￥3,993.60￥41,579.402813￥14.02￥39,438.26313.00￥13.80￥4,319.40￥44,607.202814￥15.02￥42,266.28314.00￥14.80￥4,647.20￥47,637.002815￥16.02￥45,096.30315.00￥15.80￥4,977.00￥50,668.802816￥17.02￥47,928.32316.00￥16.80￥5,308.80￥53,702.602817￥18.02￥50,762.34317.00￥17.80￥5,642.60￥56,738.402818￥19.02￥53,598.36318.00￥18.80￥5,978.40￥59,776.202819￥20.02￥56,436.38319.00￥19.80￥6,316.20￥62,816.002820￥21.02￥59,276.40320.00￥20.80￥6,656.00￥65,857.802821￥22.02￥62,118.42321.00￥21.80￥6,997.80￥68,901.602822￥23.02￥64,962.44322.00￥22.80￥7,341.60￥818,197.40818,197.406465364653￥778,141.06778,141.0671537153￥85,417.4085,417.40 出出入入库库存存统统计计汇汇总总本本月月入入库库备备注注
