请教进销存财务问题

婧乐

<strong>请教进销存财务问题</strong><div style="PADDING-RIGHT: 0px; MARGIN-TOP: 10px; FONT-SIZE: 13px; OVERFLOW-X: hidden; WIDTH: 97%; WORD-BREAK: break-all; TEXT-INDENT: 24px; LINE-HEIGHT: 180%; HEIGHT: 200px; WORD-WRAP: break-word;"><p>财务让我做一个库存进销存的损益表.但我二和尚摸不着头脑的.知道这里财务高手很多的.请高手们帮帮我啊.</p><p><table cellspacing="0" cellpadding="0" width="504" border="0" style="WIDTH: 378pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2304;"></col><col></col><col span="6" width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">货号</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">前期结存</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">本期进货</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">本期出库</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">本期退货</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">本期结存</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">实存</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" align="right" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td class="xl22" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">787</font></td><td class="xl22" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">1122</font></td><td class="xl22" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">1122</font></td><td class="xl22" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">1085</font></td><td class="xl22" align="right" xfmla="=B2+C2-E2-D2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">-298</font></td><td class="xl22" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">822</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td colspan="6" height="19" style="BORDER-LEFT-COLOR: #f4f5f7; BORDER-BOTTOM-COLOR: #f4f5f7; BORDER-TOP-COLOR: #f4f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f4f5f7; mso-ignore: colspan;"><font face="宋体">此盘点表起止日期从2006年12月21日至2007年3月30日</font></td><td style="BORDER-LEFT-COLOR: #f4f5f7; BORDER-BOTTOM-COLOR: #f4f5f7; BORDER-TOP-COLOR: #f4f5f7; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f4f5f7;"></td></tr></tbody></table></p><p>如表:财务要求我做从06年12月21号至07年3月30日止的库存明细.请问,如果是以这个期限为准的话,我的公式应是哪个?</p><p>1.前期结存+本期进货-本期出库-本期退货</p><p>2.本期进货-本期出库-本期退货</p><p>可能我自己的方式方法有错误,请教论坛的老师指点了...</p><img title="dvubb" alt="图片点击可在新窗口打开查看" src="http://club.excelhome.net/Skins/Default/emot/em20.gif" align="middle" border="0"/>不胜感激</div>

mjp2575

<p>1.前期结存+本期进货-本期出库-本期退货</p><p>应该是这个</p>

xlonger

<p>本期退货 </p><p>是你退给你的供应商？</p><p></p><p>还是你的客户 退给你？</p><p></p><p>是否包括在本期出库里？</p>

xrczld

本期退货是正常退货还是损耗退货,如果是损耗退货(质量问题与保管不当的话)应该是减去,如果是正常退货的话,就不是这样拉