|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
现金流量表的编制方法(详见附件)
现金流量表的编制.JPG
(112.75 KB, 下载次数: 12)
充值金币->
用友U870的设置现金流量表方法:
1、 进入 总账—设置——会计科目
会计科目编辑中将货币资金项目(如:现金、银行存款、其他货币资金)设置为“项目核算”
2、 再进入 总账—设置——编码方案——项目目录(如下图设置)进行项目定义
A、 项目大类:选定为现金流量项目 将待选科目全部 到已选科目中——点“确定”
B、 项目结构
C、 项目分类定义
D、 项目目录(如需改动请按“维护”进行修改或增加、删除)
3、 在总账——账表——现金流量表中实现,用友电子使用手册中有介绍,不在此介绍此方法
4、 下面介绍如何在UFO报表中编制现金流量表
A、打开 财务会计——UFO报表——新建
B、报表模板——您所在的行业 选“新会计制度科目“——财务报表 选”现金流量表“——确定——确定
C、在左下角为“格式“状态时录入各个单元格公式
现金流入类的单元格公式举例如下:
举例:销售商品、提供劳务收到的现金
单元格公式:LFS("1001",月,"J",,,"101",,"y")+LFS("1002",月,"J",,,"101",,"y")- LFS("1001",月,"D",,,"101",,"y")-LFS("1002",月,"D ",,,"101",,"y")-LFS("1009",月,"D",,,"101",,"y")
收到的税费返还
单元格公式:LFS("1001",月,"J",,,"102",,"y")+LFS("1002",月,"J",,,"102",,"y")+LFS("1009",月,"J",,,"102",,"y")- LFS("1001",月,"D",,,"102",,"y")-LFS("1002",月,"D",,,"102",,"y")-LFS("1009",月,"D",,,"102",,"y")
收到的其他与经营活动有关的现金
单元格公式:LFS("1001",月,"J",,,"103",,"y")+LFS("1002",月,"J",,,"103",,"y")+LFS("1009",月,"J",,,"103",,"y")- LFS("1001",月,"D",,,"103",,"y")-LFS("1002",月,"D",,,"103",,"y")-LFS("1009",月,"D",,,"103",,"y")
以此类推
现金流出类的单元格公式举例如下:
购买商品、接受劳务支付的现金
单元格公式:LFS("1001",月,"D",,,"104",,"y")+LFS("1002",月,"D",,,"104",,"y")+LFS("1009",月,"D",,,"104",,"y")- LFS("1001",月,"J",,,"104",,"y")-LFS("1002",月,"J",,,"104",,"y")-LFS("1009",月,"J",,,"104",,"y")
其余流出类公式单元设置以此类推
5、设置 关键字:年 月 后,每月记账完后,就可以录入关键字计算该表即可。
[ 本帖最后由 小豆子 于 2008-12-13 12:01 编辑 ] |
|