11仓库管理--进销存账本

功能介绍：会用Excel电子表格，就会用我们的软件。只需输入进货和销售的记录，自动统计利润和库存。非常简单的记账本。=========软件使用说明===========1.白色的为可输入的区域，蓝色的为不可输入区域（不需输入，自动出现）2.商品编码输入要字母+数字的形式，比如：a0013.表格字段和整个结构不允许修改和删除，否则数据不能自动统计Excel进销存记账本V2.0当前库存供货商销售图表商品进货打印单据销售记录功能介绍：会用Excel电子表格，就会用我们的软件。只需输入进货和销售的记录，自动统计利润和库存。非常简单的记账本。=========软件使用说明===========1.白色的为可输入的区域，蓝色的为不可输入区域（不需输入，自动出现）2.商品编码输入要字母+数字的形式，比如：a0013.表格字段和整个结构不允许修改和删除，否则数据不能自动统计客户紫色填充格式公式到100行商品编码商品类别商品名称规格型号进货单价进货数量单位合计进货日期727金钥匙扣玫瑰金拉丝黑色带¥16.2018个¥291.602013.10.10727黑镍钥匙扣黑镍拉丝棕色带¥16.2016个¥259.202013.12.12727银钥匙扣白铜锡黑色带¥16.2015个¥243.002013.11.22727银铬钥匙扣白铜锡铬子带¥16.208个¥129.602013.11.22891C金钥匙扣玫瑰金拉丝黑色带¥12.9012个¥154.802013.11.6891C银钥匙扣白铜锡黑色带¥12.9012个¥154.802013.11.6970银钥匙扣白铜锡¥14.302个¥28.602013.10.10952金钥匙扣玫瑰金拉丝¥13.705个¥68.502013.10.10914银钥匙扣白铜锡¥14.902个¥29.802013.10.10937银钥匙扣白铜锡¥13.302个¥26.602013.10.10829B金钥匙扣玫瑰金拉丝¥11.908个¥95.202013.11.28829B银钥匙扣白铜锡¥11.905个¥59.502013.11.28705银钥匙扣白铜锡¥14.003个¥42.002013.11.28932银钥匙扣白铜锡¥16.703个¥50.102013.11.28701黑钥匙扣橡皮黑¥16.102个¥32.202013.10.13713黑钥匙扣黑色胶皮¥14.603个¥43.802013.10.10713红钥匙扣红色胶皮¥14.602个¥29.202013.12.11909银钥匙扣白铜锡¥12.803个¥38.402013.10.10712银钥匙扣白铜锡¥15.601个¥15.602013.10.10712黑镍钥匙扣黑镍拉丝¥15.602个¥31.202013.10.10975黑钥匙扣黑镍拉丝棕色带¥14.105个¥70.502013.10.10947银钥匙扣白铜锡¥12.203个¥36.602013.10.10947金钥匙扣玫瑰金拉丝¥12.202个¥24.402013.10.10723黑镍钥匙扣黑镍拉丝¥18.202个¥36.402013.11.6723银钥匙扣白铜锡¥18.202个¥36.402013.11.6917粉红钥匙扣粉红¥14.603个¥43.802013.11.6921银钥匙扣白铜锡¥18.602个¥37.202013.11.6水钻马包包链白色¥12.008个¥96.002013.12.20水钻小狗包包链红色¥13.003个¥39.002013.12.20返回主界面进货人供货商备注李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里李坤阿里2013.12.202013.12.20紫色填充为带公式行数到100行商品编码商品类别商品名称规格型号销售单价销售数量单位合计日期727黑镍钥匙扣黑镍拉丝棕色带¥27.006.00个¥162.002013.12.12727金钥匙扣玫瑰金拉丝黑色带¥27.0014.00个¥378.002013.12.15727银钥匙扣白铜锡黑色带¥27.005.00个¥135.002013.12.16727银铬钥匙扣白铜锡铬子带¥27.003.00个¥81.002013.12.11891C金钥匙扣玫瑰金拉丝黑色带¥25.0012.00个¥300.002013.12.12891C银钥匙扣白铜锡黑色带¥25.009.00个¥225.002013.12.10952金钥匙扣玫瑰金拉丝¥27.003.00个¥81.002013.12.12937银钥匙扣白铜锡¥27.001.00个¥27.002013.11.19829B金钥匙扣玫瑰金拉丝¥23.003.00个¥69.002013.11.26712黑镍钥匙扣黑镍拉丝¥30.001.00个¥30.002013.11.11947银钥匙扣白铜锡¥21.001.00个¥21.002013.10.20947金钥匙扣玫瑰金拉丝¥21.001.00个¥21.002013.10.20701黑钥匙扣橡皮黑¥29.001.00个¥29.002013.12.11713黑钥匙扣黑色胶皮¥27.001.00个¥27.002013.11.11713红钥匙扣红色胶皮¥27.001.00个¥27.002013.12.11975黑钥匙扣黑镍拉丝棕色带¥25.001.00个¥25.002012.12.19891C金钥匙扣玫瑰金拉丝黑色带¥25.001.00个¥25.002013.12.20891C银钥匙扣白铜锡黑色带¥25.001.00个¥25.002013.12.20727银钥匙扣白铜锡黑色带¥27.001.00个¥27.002013.12.20727银铬钥匙扣白铜锡铬子带¥27.001.00个¥27.002013.12.20返回主界面欠款金额供货商净利润备注商品编码商品类别商品名称规格型号单位¥64.80¥16.20727金钥匙扣玫瑰金拉丝黑色带个¥151.20¥16.20727黑镍钥匙扣黑镍拉丝棕色带个¥54.00¥16.20727银钥匙扣白铜锡黑色带个¥32.40¥16.20727银铬钥匙扣白铜锡铬子带个¥145.20¥12.90891C金钥匙扣玫瑰金拉丝黑色带个¥108.90¥12.90891C银钥匙扣白铜锡黑色带个¥39.90¥13.70970银钥匙扣白铜锡个¥13.70¥13.30952金钥匙扣玫瑰金拉丝个¥33.30¥11.90914银钥匙扣白铜锡个¥14.40¥15.60937银钥匙扣白铜锡个¥8.80¥12.20829B金钥匙扣玫瑰金拉丝个¥8.80¥12.20829B银钥匙扣白铜锡个¥12.90¥16.10705银钥匙扣白铜锡个¥12.40¥14.60932银钥匙扣白铜锡个¥12.40¥14.60701黑钥匙扣橡皮黑个¥10.90¥14.10713黑钥匙扣黑色胶皮个¥12.10¥12.90713红钥匙扣红色胶皮个¥12.10¥12.90909银钥匙扣白铜锡个¥10.80¥16.20712银钥匙扣白铜锡个¥10.80¥16.20712黑镍钥匙扣黑镍拉丝个#VALUE!975黑钥匙扣黑镍拉丝棕色带个#VALUE!947银钥匙扣白铜锡个#VALUE!947金钥匙扣玫瑰金拉丝个#VALUE!723黑镍钥匙扣黑镍拉丝个#VALUE!723银钥匙扣白铜锡个#VALUE!917粉红钥匙扣粉红个#VALUE!921银钥匙扣白铜锡个#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A全部商品列表#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A数量单价合计数量合计727金钥匙扣玫瑰金拉丝黑色带18¥16.20¥291.6014¥378.004727黑镍钥匙扣黑镍拉丝棕色带16¥16.20¥259.206¥162.0010727银钥匙扣白铜锡黑色带15¥16.20¥243.006¥162.009727银铬钥匙扣白铜锡铬子带8¥16.20¥129.604¥108.004891C金钥匙扣玫瑰金拉丝黑色带12¥12.90¥154.8013¥325.00-1891C银钥匙扣白铜锡黑色带12¥12.90¥154.8010¥250.002952金钥匙扣玫瑰金拉丝5¥13.70¥68.503¥81.002970银钥匙扣白铜锡2¥14.30¥28.600¥0.002914银钥匙扣白铜锡2¥14.90¥29.800¥0.002937银钥匙扣白铜锡2¥13.30¥26.601¥27.001829B金钥匙扣玫瑰金拉丝8¥11.90¥95.203¥69.005829B银钥匙扣白铜锡5¥11.90¥59.500¥0.005705银钥匙扣白铜锡3¥14.00¥42.000¥0.003932银钥匙扣白铜锡3¥16.70¥50.100¥0.003701黑钥匙扣橡皮黑2¥16.10¥32.201¥29.001713黑钥匙扣黑色胶皮3¥14.60¥43.801¥27.002713红钥匙扣红色胶皮2¥14.60¥29.201¥27.001909银钥匙扣白铜锡3¥12.80¥38.400¥0.003712银钥匙扣白铜锡1¥15.60¥15.600¥0.001712黑镍钥匙扣黑镍拉丝2¥15.60¥31.201¥30.001975黑钥匙扣黑镍拉丝棕色带5¥14.10¥70.501¥25.004947银钥匙扣白铜锡3¥12.20¥36.601¥21.002947金钥匙扣玫瑰金拉丝2¥12.20¥24.401¥21.001723黑镍钥匙扣黑镍拉丝2¥18.20¥36.400¥0.002723银钥匙扣白铜锡2¥18.20¥36.400¥0.002917粉红钥匙扣粉红3¥14.60¥43.800¥0.003921银钥匙扣白铜锡2¥18.60¥37.200¥0.002库存紫色填充格式公式到100行进货统计销售统计商品编码商品类别商品名称规格型号返回主界面¥151.20¥64.80¥64.80¥43.20¥157.30¥121.00¥39.90¥0.00¥0.00¥13.70¥33.30¥0.00¥0.00¥0.00¥12.90¥12.40¥12.40¥0.00¥0.00¥14.40¥10.90¥8.80¥8.80¥0.00¥0.00¥0.00¥0.00净利润年销售报表月份总销量净利润1#VALUE!#VALUE!2#VALUE!#VALUE!3#VALUE!#VALUE!4#VALUE!#VALUE!5#VALUE!#VALUE!6#VALUE!#VALUE!7#VALUE!#VALUE!8#VALUE!#VALUE!9#VALUE!#VALUE!10#VALUE!#VALUE!11#VALUE!#VALUE!12#VALUE!#VALUE!合计#VALUE!#VALUE!日期总销量净利润2013.12.12¥543.00¥249.902013.12.15¥378.00¥151.202013.12.16¥135.00¥54.002013.12.11¥137.00¥57.702013.12.12¥543.00¥249.902013.12.10¥225.00¥108.902013.12.12¥543.00¥249.902013.11.19¥27.00¥13.702013.11.26¥69.00¥33.302013.11.11¥57.00¥26