[原创]按2007年新会计准则写的《 EXCEL财务程序》

CPAEXCEL

<p class="MsoNormal" style="TEXT-JUSTIFY: inter-ideograph; MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 17.65pt; LINE-HEIGHT: 150%; TEXT-ALIGN: justify; mso-char-indent-count: 1.96;"><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">为了提高工作效率，自己写的<span lang="EN-US">EXCEL</span>财务程序：</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">1、</font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">模仿手工帐务处理方式，用<span lang="EN-US">EXCEL</span>生成各种会计资料，包括记账凭证、总账、明细账、科目余额表、试算平衡表、资产负债表、利润表、现金流量表等，同时自动备份保存以备查询、打印；</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">2、<span style="FONT: 7pt &quot;Times New Roman&quot;;"><font face="宋体"><font size="4">可</font></font></span></font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">打印记账凭证（单笔或批量）、总账和明细账、科目余额表、试算平衡表、资产负债表、利润表、现金流量表等会计资料；</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">3、<span style="FONT: 7pt &quot;Times New Roman&quot;;"><font face="宋体"><font size="4">可</font></font></span></font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">重复结帐；</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">4、<span style="FONT: 7pt &quot;Times New Roman&quot;;"><font face="宋体"><font size="4">可</font></font></span></font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">设置多套帐套；</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">5、</font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">可检查总账平衡和总账、明细账是否平衡；</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">6、<span style="FONT: 7pt &quot;Times New Roman&quot;;"><font face="宋体"><font size="4">操作直观、</font></font></span></font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">工作效率高：常用的业务（记帐凭证）保存在<span lang="EN-US">EXCEL</span>工作表，可逐笔记账也可直接在流水工作表里修改，点击“结帐”按钮便可完成所有帐务处理；</font><span lang="EN-US"><p><font size="4"></font></p></span></span></p><p><font size="4"></font></p><p><font face="宋体" size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><font size="7"><span lang="EN-US" style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><span style="mso-list: Ignore;"><font size="4">7、</font></span></span><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">使用<span lang="EN-US">2007</span>年执行的最新的会计科目</font>。</span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4"></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">希望与大家共同交流如何用EXCEL提高工作效率！</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span style="FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体;"><font size="4">我的邮箱：</font><a href="mailto:fanghaiquancn@sina.com"><font size="4">fanghaiquancn@sina.com</font></a></span></p><p></p><p> v3FMpk8I.rar (155.88 KB, 下载次数: 1492)

2007-11-19 21:42 上传

点击文件名下载附件
[原创]按2007年新会计准则写的《 EXCEL财务程序》

</p><p>2007年12月9日更新附件，见2楼和28楼。<br/></p><p></p>

[此贴子已经被作者于2007-12-9 7:15:34编辑过]

CPAEXCEL

<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><font face="Arial"><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><p><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">2007年12月9日更新附件，完善了界面、增加了例子。</span></span></p><p>part01: Wy6IkUto.rar (244.14 KB, 下载次数: 899)

2007-12-9 06:49 上传

点击文件名下载附件

</p><p>其余见28楼共9个附件<br/></p>

[此贴子已经被作者于2007-12-9 6:58:21编辑过]

davidhx

<p>真是太好了，，到处找新政策用的，，只是不知道怎么操作，不知道是不是我安装有错误，，我的邮箱是　<a href="mailto:ahxrhx@163.com">ahxrhx@163.com</a></p>

yyangllei

非常感、感谢

xrczld

<p>厉害，代码写到DLL里面去了。什么也没有。怎么做的？</p>

黎明前的黑暗

<p>为什么打不开呢?</p>

renkebu

<p>真是太好了，十分感谢!!请问:往来账户有限制吗?如果能增加数量明细账那就完美无缺了!!</p><p></p>

wxing601

<p>好好学习一下</p>

tq229926

厉害,期待你说一下怎么做出来的

格桑女子

<p>我的邮箱zhangli_1226217@163.com</p>