財務培訓-v13.0報表系統(tǒng)

?1993-2012金蝶（中國）④公開外傳金蝶 （中國）客戶服務中心金蝶K/3V13.0報表系統(tǒng)培訓假如你是你最關心什么？課前P*P*報表概述提供了多個行業(yè)的報表模板提供了豐富的取數(shù)公式快速進行自定義報表的編制P*報表常用功能單元屬性

行、列屬性表屬性表頁管理公式取數(shù)參數(shù)批量填充表頁匯總報表權(quán)限控制報表刪除和更名報表常用功能單元屬性字體顏色鎖定單元格對齊方式數(shù)字格式邊框設置P*報表常用功能行、列屬性行高、列寬行隱藏對齊方式數(shù)字格式P*報表常用功能表屬性行列外觀頁眉頁腳P*報表常用功能表頁管理表頁管理表頁鎖定思考：某表頁鎖定后，其他表頁修改公式，鎖定的表頁是否會相應改變P*報表常用功能公式取數(shù)參數(shù)缺省年度、開始期間、結(jié)束期間開始日期、結(jié)束日期核算項目ACCT函數(shù)包括未過賬憑證數(shù)值轉(zhuǎn)換P*報表常用功能P*報表常用功能表頁匯總鎖定單元格匯總表頁數(shù)據(jù)P*報表常用功能報表權(quán)限控制對每張報表進行明細權(quán)限分為：

、、打印、修改、更改權(quán)限、完全控制P*報表常用功能報表刪除和更名–

菜單【文件】→【打開】P*報表常用功能多賬套管理報表審核

舍位平衡

報表報表聯(lián)查報表打印引入引出P*報表常用功能多賬套管理實現(xiàn)從其他賬套中取數(shù)配置賬套設置公式P*報表常用功能報表審核審核報表數(shù)據(jù)設置審核條件審核報表P*報表常用功能舍位平衡用于報表的數(shù)值轉(zhuǎn)換設置舍位平衡公式進行舍位平衡思考：舍位平衡與數(shù)值轉(zhuǎn)換功能的區(qū)別？P*報表常用功能報表–

后報表不能編輯P*P*報表常用功能報表聯(lián)查–

聯(lián)查總賬、明細賬、數(shù)量金額總賬和數(shù)量金額明細賬思考：聯(lián)查各賬簿的按鈕灰顯是什么原因？P*報表常用功能報表打印縮放比例批量打印選定區(qū)域打印P*報表常用功能引入引出引出表頁引出報表引入文件P*常用報表函數(shù)常用報表函數(shù)ACCTACCTCASHACCTEXTREF_FIFRPTDATESYSINFO學完了就上場練練：1、請新建一個資產(chǎn)負債表以后刪除該報表2、請在資產(chǎn)負債表“存貨”中添加“生產(chǎn)成本”科目的年初余額和期末余額的取數(shù)公式3、請在資產(chǎn)負債表中添加一個表頁，將表頁名改成1月和2月，將表頁“1月”鎖定4、設置第3題的兩個表頁分別取賬套上一期和本期的數(shù)據(jù)5、將報表的所有的數(shù)字格式都改成為0不顯示，并且將報表設置成一張萬元表6、請新建一個用戶給用戶授予報表的所

限7、請將報表取數(shù)期間的日期打印在紙張的右上角8、需要在報表中將公司名稱打印在紙張的左上角9、請將資產(chǎn)負債表打印到一張A4紙上P*P*利潤表編制使用預設模板

本期金額的填列–

ACCT取數(shù)公式上期金額的填列利潤表編制本期金額欄取本期實際損益發(fā)生額用本期金額=ACCT("6602",“SY","",0,0,0,"")P*ACCT取數(shù)公式上期金額欄取上年同期的實際損益發(fā)生額用上期金額–

填列方法：設置取數(shù)公式取數(shù)=ACCT("6602","SY","",-1,0,0,"")P*ACCT取數(shù)公式大部分的客戶都需要添加本年累計損益發(fā)生額這一列：用本年累計金額設置取數(shù)公式取數(shù)

=ACCT("6602","SL","",0,0,0,"")P*P*資產(chǎn)負債表編制應收賬款等往來項目公式設置存貨項目公式設置未分配利潤項目公式設置–

REF_F表間取數(shù)公式資產(chǎn)負債表編制應收賬款項目編制賬簿報表應收賬款期末余額=ACCT("1122","JY","",0,0,0,"")+ACCT("2203","JY","",0,0,0,"")年初余額=ACCT("1122","JC","",0,1,1,"")+ACCT("2203","JC","",0,1,1,"")應收賬款掛客戶核算項目期末余額=ACCT("1122|客戶|","JY","",0,0,0,"")+ACCT("2203|客戶|","JY","",0,0,0,"")年初余額=ACCT("1122|客戶|","JC","",0,1,1,"")+ACCT("2203|客戶|","JC","",0,1,1,"")P*資產(chǎn)負債表編制預收賬款項目編制賬簿報表預收賬款期末余額=ACCT("2203","DY","",0,0,0,"")+ACCT("1122","DY","",0,0,0,"")年初余額=ACCT("2203","DC","",0,1,1,"")+ACCT("1122","DC","",0,1,1,"")預收賬款掛客戶核算項目期末余額=ACCT("2203|客戶|","DY","",0,0,0,"")+ACCT("1122|客戶|","DY","",0,0,0,"")年初余額=ACCT("2203|客戶|","DC","",0,1,1,"")+ACCT("1122|客戶|","DC","",0,1,1,"")P*資產(chǎn)負債表編制應付賬款項目編制賬簿報表應付賬款期末余額=ACCT(“2202”,“DY”,“”,0,0,0,“”)+ACCT(“1123”,“DY”,“”,0,0,0,“”)年初余額=ACCT("2202","DC","",0,1,1,"")+ACCT("1123","DC","",0,1,1,"")應付賬款掛供應商核算項目期末余額=ACCT("2202|供應商|","DY","",0,0,0,"")+ACCT("1123|供應商|","DY","",0,0,0,"")年初余額=ACCT("2202|供應商|","DC","",0,1,1,"")+ACCT("1123|供應商|","DC","",0,1,1,"")P*資產(chǎn)負債表編制預付賬款項目編制賬簿報表預付賬款期末余額=ACCT("1123","JY","",0,0,0,"")+ACCT("2202","JY","",0,0,0,"")年初余額=ACCT("1123","JC","",0,1,1,"")+ACCT("2202","JC","",0,1,1,"")預付賬款掛供應商核算項目期末余額=ACCT(“1123|供應商|",“JY","",0,0,0,"")+ACCT(“2202|供應商|",“JY","",0,0,0,"")年初余額=ACCT(“1123|供應商|",“JC","",0,1,1,"")+ACCT(“2202|供應商|",“JC","",0,1,1,"")P*P*資產(chǎn)負債表編制存貨項目編制如果企業(yè)有在產(chǎn)品，則需要將科目“5001-生產(chǎn)成本”的期末余額歸集到存貨的期末余額中P*資產(chǎn)負債表編制未分配利潤項目賬結(jié)法未分配利潤項目期末余額=利潤分配科目余額+本年利潤科目余額未分配利潤期末余額=ACCT("4104","Y","",0,0,0,"")+ACCT("4103","Y","",0,0,0,"")表結(jié)法未分配利潤項目期末余額=利潤分配科目余額+利潤表凈利潤的累積發(fā)生額未分配利潤期末余額=ACCT("4104","Y","",0,0,0,"")+REF_F("利潤表","B18","","")三大報表的勾稽關系表內(nèi)勾稽關系：資產(chǎn)負債表=負債+權(quán)益利潤=收入-成本費用表外勾稽關系：損益表及利潤分配表中的未分配利潤=資產(chǎn)負債表中的未分配利潤資產(chǎn)負債表中現(xiàn)金及其等價物期末余額與期初余額之差=現(xiàn)金流量表中現(xiàn)金