鄙人新作《EXCEL账务处理应用教程》

wangyanhua

<p>可是为什么我在使用时审核过凭证并不能生成账簿和报表?</p>

笨笨无悔

<p>楼主太厉害了</p>

sshkk1980

<p>用了您的软件感觉工作轻松多了，可是对于期末损益结转本年利润还是不会操作，希望您能给我举个准确的例子。谢谢！另外问一下您的账务处理具体使用方法不知什么时候能上传，我想更加熟练的应用它。</p>

第三杯茶

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>sshkk1980</i>在2008-10-9 14:58:00的发言：</b><br/><p>用了您的软件感觉工作轻松多了，可是对于期末损益结转本年利润还是不会操作，希望您能给我举个准确的例子。谢谢！另外问一下您的账务处理具体使用方法不知什么时候能上传，我想更加熟练的应用它。</p></div><p><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">编制期末转账凭证时，涉及到会计科目本月发生额结转的，如果是借方科目本月发生额结转到贷方，输入公式“</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-bidi-font-size: 10.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">=SUMIF(KMDM,"</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">科目代码</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-bidi-font-size: 10.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">",JFJE)</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">”；如果是贷方科目本月发生额结转到借方，输入公式“</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-bidi-font-size: 10.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">=SUMIF(KMDM,"</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">科目代码</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-bidi-font-size: 10.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">",DFJE)</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">”。如主营业务收入结转利润,在主营业务收入对应的借方金额栏输入<span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">“</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-bidi-font-size: 10.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">=SUMIF（KMDM，5101，DFJE）</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">”。</span></span></p>

shark100

请问老师,年度科目汇总已经完成,可是还是不能看到资产表 利润表,提示"会计核算未到期末或期末数据还未生成,请退出"另外怎样查看前几月的财务报表?

shark100

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>shark100</i>在2008-10-29 15:16:00的发言：</b><br/>请问老师,年度科目汇总已经完成,可是还是不能看到资产表 利润表,提示"会计核算未到期末或期末数据还未生成,请退出"另外怎样查看前几月的财务报表?</div><p></p><p>谢谢老师，我已经解决了.</p>

NHRNHR

<p>刚买了书，请多关照。</p>

gaohong33

<a href="http://www.excelpx.com/dispbbs.asp?BoardID=38&amp;replyID=163987&amp;ID=14176&amp;skin=1"><font size="+0">谢谢楼主!很实用!</font></a><u><font color="#0000ff">再顶一个</font></u>

Feiny

准备买书了哦，有问题到时候再请教哦

szjwm

纯支持一下