Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
楼主: luckyisland

[原创]流耘EXCEL账务处理系统 Ver.2012.3.3极速版发布)增加一键打印账册功能

  [复制链接]
发表于 2010-11-5 22:35 | 显示全部楼层

<p><table cellspacing="0" cellpadding="0" width="509" border="0" style="WIDTH: 384pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="64" style="WIDTH: 48pt;"></col><col width="30" style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1097;"></col><col width="198" style="WIDTH: 149pt; mso-width-source: userset; mso-width-alt: 7241;"></col><col width="89" style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254;"></col><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1243;"></col><col width="94" style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437;"></col></colgroup><tbody><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl91" width="64" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">140202</font></td><td class="xl88" align="right" width="30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">2</font></td><td class="xl88" width="198" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 149pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><span style="mso-spacerun: yes;"><font face="MS Sans Serif">&nbsp; </font></span><font class="font5">其他债权投资</font></font></td><td class="xl89" width="89" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 67pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">金额式</font></td><td class="xl89" width="34" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 26pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">借</font></td><td class="xl90" width="94" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 71pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2"> </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl91" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">1421</font></td><td class="xl88" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">1</font></td><td class="xl89" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">其他长期资产</font></td><td class="xl89" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">金额式</font></td><td class="xl89" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">借</font></td><td class="xl90" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="MS Sans Serif" size="2">108900.00 </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl93" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffcc99;"><font face="MS Sans Serif" size="2">1431</font></td><td class="xl94" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="MS Sans Serif" size="2">1</font></td><td class="xl95" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2">委托贷款</font></td><td class="xl95" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2">金额式</font></td><td class="xl95" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2">借</font></td><td class="xl92" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="MS Sans Serif" size="2">0.00 </font></td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="319" border="0" style="WIDTH: 239pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="115" style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205;"></col><col width="31" style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1133;"></col><col width="81" style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962;"></col><col width="92" style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364;"></col></colgroup><tbody><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl90" width="115" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2"> </font></td><td class="xl92" width="31" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; WIDTH: 23pt; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">36</font></td><td class="xl95" width="81" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td><td class="xl95" width="92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; WIDTH: 69pt; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl90" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2"> </font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">37</font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl89" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2">固定资产合计</font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">38</font></td><td class="xl94" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#0000ff" size="2">2,849,216.59 </font></td><td class="xl94" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#0000ff" size="2">2,849,216.59 </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl88" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2">无形资产及其他资产:</font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">39</font></td><td class="xl93" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td><td class="xl93" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl88" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2"> 无形资产</font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">40</font></td><td class="xl94" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#0000ff" size="2"> </font></td><td class="xl94" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#0000ff" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl88" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2"> 长期待摊费用</font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">41</font></td><td class="xl94" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#0000ff" size="2"> </font></td><td class="xl94" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#0000ff" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl88" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2"> 其他长期资产</font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">42</font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl88" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2">  其中:待转销汇兑损失</font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">43</font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"><td class="xl91" height="18" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font size="2"> </font></td><td class="xl92" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman" size="2">44</font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"></font></td><td class="xl95" style="BORDER-RIGHT: #ece9d8 0.5pt; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent;"><font face="黑体" size="2"> </font></td></tr></tbody></table></p>
回复

使用道具 举报

发表于 2010-11-7 23:03 | 显示全部楼层
回复

使用道具 举报

发表于 2010-11-9 10:39 | 显示全部楼层
回复

使用道具 举报

发表于 2010-11-10 14:37 | 显示全部楼层

谢谢楼主了,如果能计算现金流量表就更好了
回复

使用道具 举报

发表于 2010-11-10 15:29 | 显示全部楼层

下载了,还没有用,不知道好不好,不过还是谢谢了啊!
回复

使用道具 举报

发表于 2010-11-11 21:59 | 显示全部楼层

好东东,收藏。
回复

使用道具 举报

发表于 2010-11-15 16:47 | 显示全部楼层

老师,不知何时更新,我们期盼
回复

使用道具 举报

发表于 2010-11-15 20:13 | 显示全部楼层

<p>谢谢分享!太感谢了。</p>
回复

使用道具 举报

发表于 2010-11-15 20:35 | 显示全部楼层

感谢

谢谢您的分享,并且谢谢您的辛苦劳动,我觉得您的这个财务处理系统真的很不错谢谢
回复

使用道具 举报

发表于 2010-11-15 20:40 | 显示全部楼层

也凑个热闹
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2025-8-16 03:11 , Processed in 0.708575 second(s), 6 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表