wangyanhua 发表于 2008-10-9 11:05

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

笨笨无悔 发表于 2008-10-9 11:15

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

sshkk1980 发表于 2008-10-9 14:58

疑问

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

第三杯茶 发表于 2008-10-13 08:42

<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 发表于 2008-10-29 15:16

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

shark100 发表于 2008-10-30 10:03

<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 发表于 2008-12-10 16:26

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

gaohong33 发表于 2008-12-30 19:29

<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 发表于 2009-8-21 08:38

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

szjwm 发表于 2009-9-15 13:44

纯支持一下
页: 1 2 3 4 5 6 7 8 [9] 10 11 12
查看完整版本: 鄙人新作《EXCEL账务处理应用教程》