资产负债表重分类公式设置
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
-------------------------------------------------------------------------------------------------------------------------
1、期末数据
-------------------------------------------------------------------------------------------------------------------------
借方应收=应收+预收-坏账
SUM(WLJE(,1122001,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,1122002,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,1122099,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2205001,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2205002,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2205099,0:Z,JFYE,,,,[JFYE]>0))-KMJE(,1241001,DFYE)
借方预付=预付+应付-坏账
SUM(WLJE(,1123001,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,1123002,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,1123099,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2202001,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2202002,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2202099,0:Z,JFYE,,,,[JFYE]>0))-KMJE(,1241003,DFYE)
借方其他应收=其他应收+其他应付-坏账
SUM(WLJE(,1231001,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,1231002,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,1231099,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2241001,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2241002,0:Z,JFYE,,,,[JFYE]>0))+SUM(WLJE(,2241099,0:Z,JFYE,,,,[JFYE]>0))-KMJE(,1241002,DFYE)
贷方应付=应付+预付
SUM(WLJE(,2202001,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,2202002,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,2202099,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1123001,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1123002,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1123099,0:Z,DFYE,,,,[DFYE]>0))
贷方预收=预收+应收
SUM(WLJE(,2205001,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,2205002,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,2205099,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1122001,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1122002,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1122099,0:Z,DFYE,,,,[DFYE]>0))
贷方其他应付=其他应付+其他应收
SUM(WLJE(,2241001,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,2241002,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,2241099,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1231001,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1231002,0:Z,DFYE,,,,[DFYE]>0))+SUM(WLJE(,1231099,0:Z,DFYE,,,,[DFYE]>0))
-------------------------------------------------------------------------------------------------------------------------
2、期初数据
-------------------------------------------------------------------------------------------------------------------------
借方应收=应收+预收-坏账
SUM(WLJE(,1122001,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,1122002,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,1122099,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2205001,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2205002,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2205099,0:Z,NCJF,,,,[NCJF]>0))-KMJE(,1241001,NCDF)
借方预付=预付+应付-坏账
SUM(WLJE(,1123001,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,1123002,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,1123099,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2202001,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2202002,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2202099,0:Z,NCJF,,,,[NCJF]>0))-KMJE(,1241003,NCDF)
借方其他应收=其他应收+其他应付-坏账
SUM(WLJE(,1231001,0:Z,NCJF,,
,,[NCJF]>0))+SUM(WLJE(,1231002,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,1231099,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2241001,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2241002,0:Z,NCJF,,,,[NCJF]>0))+SUM(WLJE(,2241099,0:Z,NCJF,,,,[NCJF]>0))-KMJE(,1241002,NCDF)
贷方应付=应付+预付
SUM(WLJE(,2202001,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,2202002,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,2202099,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1123001,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1123002,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1123099,0:Z,NCDF,,,,[NCDF]>0))
贷方预收=预收+应收
SUM(WLJE(,2205001,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,2205002,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,2205099,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1122001,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1122002,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1122099,0:Z,NCDF,,,,[NCDF]>0))
贷方其他应付=其他应付+其他应收
SUM(WLJE(,2241001,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,2241002,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,2241099,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1231001,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1231002,0:Z,NCDF,,,,[NCDF]>0))+SUM(WLJE(,1231099,0:Z,NCDF,,,,[NCDF]>0))