百科问答

百科问答 国内资讯 公司资讯 政策法规 培训资料 产品下载

四会好业财模板设计的公式列表在哪里编辑?

发布时间:2025-8-21 

特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品8折优惠,另有话费赠送。

 



公式列表:

期初余额(QC):=QC("1001","","年","月")


年初余额(QC):=QC("1001","","年")


期末余额(QM):=QM("1001","","年","月")


取辅助项的余额:=QC("1001","","年","月","","项目_项目A")


辅助项录入的形式为“辅助项类型_辅助项的具体值”,例如项目_项目A,部门_销售部


发生额(FS):=FS("1001","","年","月","借","项目_项目A")


累计发生额(LFS):=LFS("1401","","年","月","借","项目_项目A")


净额(JE):=JE("5601","","年","月","项目_项目A")


累计净额(LJE):=LJE("5601","","年","月","项目_项目A")


本月金额与上月金额同页显示:本月=QM("1001","","年","月")


上月=QM("1001","","年","月-1")


具体取某个月的发生额:=JE("6605","","年","1")+JE("6606","","年","1")


在公式后面加减乘除一个固定值:=C5*0.25(不使用%,用小数代替)


取某个季度的净额:=LJE("5403","","年","季@1")


取某个科目的借方余额:=QM("222101","","年","月","自借")


取某个科目的辅助核算借方余额=QM("1221","","年","月","辅借")


取百分比、占比:=BFS(N6/N4,2)(N6单元格占N4单元格的比例)


X畅捷通软件.用友软件.企业云服务

截屏,微信识别二维码

客服QQ:5151867

(点击QQ号复制,添加好友)