EXCEL版产成品进销存明细账

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

数量金额0011.5明式圆台0021.28明式圆台0031.38明式圆台0041.5花瓶圆台005战国沙发006罗汉床007绵绣中华008麒麟沙发0092.18电视柜010洋花大床011办公台0124号明式沙发0133号明式餐台014万字大床015法式大床016电脑台0172.4电脑柜018圈椅019隔万柜020红木家具021梳妆台022皇宫椅023办公家具024餐椅025026027028祥云衣柜0291.5如意圆台030祥云大床031032033034035036037038039040041042043044045046序号总帐科目祥云沙发合计存货明细表余额如意餐台步步高沙发一级明细二级明细数量金额046047048049050051052053054055056057058059060061062063064065066067068069070071072073074075076077078079080081082083084085086087088089090序号总帐科目合计存货明细表存货明细表余额一级明细二级明细数量金额091092093094095096097098099100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135序号序号总帐科目存货明细表余额总帐科目一级明细二级明细余额合计一级明细二级明细数量金额136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180数量金额序号序号余额总帐科目一级明细二级明细合计存货明细表总帐科目一级明细二级明细181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225数量金额226227序号合计存货明细表余额总帐科目一级明细二级明细228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270合计返回目录库存商品明细科目:规格:单位:套存放地点:第1页月日数量单价金额数量单价金额数量单价金额17021产成品入库146045.0884631.14借146045.0884631.14131022结转销售成本146045.0884631.14平31本月合计14.006,045.0884,631.1414.006,045.0884,631.14平31本年累计14.006,045.0884,631.1414.006,045.0884,631.14平228039产成品入库47197.4028789.60借47197.4028789.60228040结转销售成本47197.4028789.60平28本月合计47197.4028789.6047197.4028789.60平28本年累计47197.4028789.6047197.4028789.60平331030产成品入库117335.7580693.21借117335.7580693.21331031结转销售成本117335.7580693.21平31本月合计117335.7580693.21117335.7580693.21平31本年累计117335.7580693.21117335.7580693.21平430产成品入库1.006,942.436,942.43借1.006,942.436,942.43430030结转销售成本1.006,942.436,942.43平30本月合计1.006,942.436,942.431.006,942.436,942.43平30本年累计1.006,942.436,942.431.006,942.436,942.43平结存凭证字号摘要借/贷最高存量进销存帐最低存量总帐科目:1.5明式圆台2013年借方贷方-----------------0.000.00库存商品明细科目:规格:计量单位:第3页月日数量单价金额数量单价金额数量单价金额明细分类帐总帐科目:2013年借方贷方余额凭证字号摘要借/贷返回目录库存商品明细科目:规格:单位:套存放地点:第1页月日数量单价金额数量单价金额数量单价金额115021产成品入库123810.3145723.72借123810.3145723.72131022结转销售成本123810.3145723.72平31本月合计123810.3145723.72123810.3145723.72平31本年累计123810.3145723.72123810.3145723.72平228039产成品入库104536.6345366.34借104536.6345366.34228040结转销售成本104536.6345366.34平28本月合计104536.6345366.34104536.6345366.34平28本年累计104536.6345366.34104536.6345366.34平331030产成品入库114623.8450862.21借114623.8450862.21331031结转销售成本114623.8450862.21平31本月合计114623.8450862.21114623.8450862.21平31本年累计114623.8450862.21114623.8450862.21平430030产成品入库74375.9330631.48借74375.9330631.48430031结转销售成本74375.9330631.48平30本月合计74375.9330631.4874375.9330631.48平30本年累计74375.9330631.4874375.9330631.48平结存凭证字号摘要借/贷最高存量进销存帐最低存量总帐科目:1.28明式圆台2013年借方贷方库存商品明细科目:规格:计量单位:第2页月日数量单价金额数量单价金额数量单价金额2013年借方贷方余额凭证字号摘要借/贷明细分类帐总帐科目:1.28明式圆台返回目录库存商品明细科目:规格:单位:套存放地点:第1页月日数量单价金额数量单价金额数量单价金额115021产成品入库104711.3547113.45借104711.3547113.45131022结转销售成本104711.3547113.45平31本月合计104711.3547113.45104711.3547113.45平31本年累计104711.3547113.45104711.3547113.45平228039产成品入库75609.4339265.98借75609.4339265.98228040结转销售成本75609.4339265.98平28本月合计75609.4339265.9875609.4339265.98平28本年累计75609.4339265.9875609.4339265.98平331030产成品入库55717.2528586.25借55717.2528586.25331031结转销售成本55717.2528586.25平31本月合计55717.2528586.2555717.2528586.25平31本年累计55717.2528586.2555717.2528586.25平430030产成品入库95410.7148696.43借95410.7148696.43430031结转销售成本95410.7148696.43平30本月合计95410.7148696.4395410.7148696.43平30本年累计95410.7148696.4395410.7148696.43平结存凭证字号摘要借/贷最高存量进销存帐最低存量总帐科目:1.38明式圆台2013年借方贷方库存商品明细科目:规格:计量单位:第2页月日数量单价金额数量单价金额数量单价金额2013年借方贷方余额凭证字号摘要借/贷明细分类帐总帐科目:1.38明式圆台库存商品明细科目:规格:计量单位:第3页月日数量单价金额数量单价金额数量单价金额明细分类帐总帐科目:2013年借方贷方余额凭证字号摘要借/贷返回目录库存商品明细科目:规格:单位:套存放地点:第1页月日数量单价金额数量单价金额数量单价金额年初余额借3.007585.6622756.97115021产成品入库131022结转销售成本31本月合计31本年累计结存凭证字号摘要借/贷最高存量进销存帐最低存量总帐科目:1.5花瓶圆台2013年借方贷方库存商品明细科目:规格:计量单位:第3页月日数量单价金额数量单价金额数量单价金额明细分类帐总帐科目:2013年借方贷方余额凭证字号摘要借/贷返回目录库存商品明细科目:规格:单位:套存放地点:第1页月日数量单价金额数量单价金额数量单价金额112021产成品入库613504.0881024.45借613504.0881024.45131022结转销售成本613504.0881024.45平31本月合计613504.0881024.45613504.0881024.45平31本年累计613504.0881024.45613504.0881024.45平228039产成品入库516078.2380391.16借516078.2380391.16228040结转销售成本516078.2380391.16平28本月合计516078.2380391.16516078.2380391.16平28本年累计516078.2380391.16516078.2380391.16平331030产成品入库616387.2998323.71借616387.2998323.71331031结转销售成本616387.2998323.71平31本月合计616387.2998323.71616387.2998323.71平31本年累计616387.2998323.71616387.2998323.71平430030产成品入库315508.6746526.00借315508.6746526.00430031结转销售成本315508.6746526.00平30本月合计315508.6746526.00315508.6746526.00平30本年累计315508.6746526.00315508.6746526.00平结存凭证字号摘要借/贷最高存量进销存帐最低存量总帐科目:战国沙发2013年借方贷方库存商品明细科目:规格:计量单位:第2页月日数量单价金额数量单价金额数量单价金额2013年借方贷方余额凭证字号摘要借/贷明细分类帐总帐科目:战国沙发库存商品明细科目:规格:计量单位:第3页月日数量单价金额数量单价金额数量单价金额明细分类帐总帐科目:2013年借方贷方余额凭证字号摘要借/贷返回目录库存商品明细科目:规格:单位:套存放地点:第1页月日数量单价金额数量单价金额数量单价金额11年初余额借16133.526133.52331030产成品入库35984.4217,953.27借4.005984.4224086.79331031结转销售成本45984.4224086.79平31本月合计35984.4217,953.2745984.4224086.79平31本年累计35984.4217,953.2745984.4224086.79平430030产成品入库35663.5616990.69借35663.5616990.69430031结转销售成本35663.56

1 / 143
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功