会计日历自然月情况下,由于企业的需求等情况,需要以不同的期间作为报表年度出具报表。
需要用函数取期间,然后round函数将这个取值变为数值,用IF函数判断是否大于某个期间,然后设置两个不同的公式。
具体操作:(举例需要设置每年4月到次年3月作为一个报表期间)
1、资产负债表:
期末数取数不变,
年初数需要修改公式,举例1001科目取数说明:
=IF(VALUE(RptInfo("期间"))>3,Acct("","1001","C","","","4","4"),Acct("","1001","C","","-1","4","4"))
2、利润表:
本期发生额不变,
本年累计数需要修改公式,举例6001科目取数说明:
=IF(VALUE(RptInfo("期间"))>3,Acct("","6001","SY","","","4",""),Acct("","6001","SY","","-1","4","12")+Acct("","6001","SY","","","1",""))
3、现金流量表:
本期发生额不变,
本年累计数需要修改公式,举例CI01.01.01现金流量项目取数说明:
=IF(VALUE(RptInfo("期间"))>3,AcctCash("","CI01.01.01","Z","",0,4,0),AcctCash("","CI01.01.01","Z","",-1,4,12)+AcctCash("","CI01.01.01","Z","",0,1,0))
设置需要参考正常期间的公式设置修改科目的取数即可,如果有科目有加核算维度等设置,科目和核算维度按照正常期间的设置,修改取数的年度和期间设置即可.
推荐阅读