1樓：懷勝城識
1、應該是qc(1001,全年,,,,年)這個函式是取1001科目的年初數，qm(1001,月)是取1001科目的關鍵字月的期未餘額。
2、這個是系統預置的模版，裡面的公式是要適當調整的。
3、如果試算不平，你要查餘額表，明細賬找原因，一般模版公式設定好後（試算平衡），只要你不增加新的一級科目，都應該是平的。
2樓：利逸佘鈺
qm(〈科目編碼〉,[〈會計期間〉],[〈方向〉],[〈賬套號〉],[〈會計年度〉],[〈編碼1〉],[〈編碼2〉],[〈截止日期〉],[〈是否包含未記賬〉],[〈編碼1彙總〉],[〈編碼2彙總〉])
感覺你的公式裡好象少幾個逗號，在倒數第三個加y就行
3樓：俟瓊音勢哲
1模版中qm(1001,全年,,,,年)與qm(1001,月)：資產負債表編制時要求期間，qm指期末數，用「年」作為引數的指按照關鍵字「年」所指的當年期末資料，用「月」作為引數的指按照關鍵字「月」所指的當月份期末資料
2存貨中為何不包括生產成本
模版不應該出錯吧：存貨中有一個「業務核算」，裡面有一個「產成品成本分配」是用來做產成品的成本分配的（將總成本金額按照已經計算好的分配結果，確定當月產成品**和金額）
3存貨該對後下月資料又不對？？？：存貨核對，月末存貨核算需要進行記賬和期末處理，之後才形成下月的月初資料，已經處理完畢的，下月不可能會變化。
一直搞不懂為什麼
：只要實際使用和操作，才能理解
用友軟體的資產負債表公式，
4樓：月遺孤
這個問題處理起來特別簡單，你把應收賬款期末=qm("1131",全年,,,年,,）,中的科目改變一下就可以了，即應收賬款期末=qm("113101",全年,,,年,,）,預收賬款項=qm("113102",全年,,,年,,）就可以。你試試改下公式，然後重算一下
5樓：匿名使用者
應該是應收賬款明細科目的借方加預收賬款明細科目的借方之和吧，這個編輯公式的時候可以選借貸方的，選了方向就自動幫你取借方合計了，兩個加起來就行。
6樓：
公式中加上借貸方向試試結果
7樓：佳佳
這種用友軟體的資產非常的多
8樓：晃晃悠悠到家了
用友軟體股份****關於進一步做好企業工作的準備工作，他們的負債表都是一樣很糟糕的
用友軟體，詳細說明資產負債表及利潤表如何設定取數公式及生成報表資料。很急！！！
9樓：匿名使用者
問題中提到兩個大步驟：
第一，設定取數公式
第二，生成報表資料
以下為詳細解析步驟：
一、設定取數公式也就是設定報表公式
1、首先，開啟一張報表。
在這裡，以一張資產負債表為例。
將報表的狀態換成「格式」狀態，如下圖
2、選中要設定的科目，在這裡演示「短期借款」這個科目期末餘額的設定，
先選中d4這個單元格，然後點選上面的「fx」按鈕，如下圖所示：
3、這時，就會彈出「定義公式」對話方塊，如下圖所示：
4、輸入公式，要取的值是短期借款的期末餘額，所以要用期末函式
qm（），短期借款科目編號是2001，所以公式的輸入為qm("2001",月)，如下圖所示：
5、輸完公式，點選「確認」之後，如果公式輸入成功，就單元格就會顯示「公式單元」四個字，如下圖
6、這時，我們如果要看短期借款的期末餘額是多少，就要點選左下角「格式」，
變回「資料」狀態，會彈出提示框「是否整表重算」，如下圖所示：
7、點選「是」，就會變回「資料」狀態，短期借款的期末餘額數也會出來。
由於只是演示，所以賬套是沒有資料的，如果大家對賬套進行日常操作，是會有資料出來的。
其他科目的期末餘額都是同樣的設定方法，大家根據企業自身需要進行設定就好了。
二、生成報表資料
1、先開啟ufo報表--新建
2、點選格式--報表模板
3、選擇相應的行業（會計科目）
4、編輯會計科目，本月數fs(501,月,"貸",,年)，按照模板套用即可，雙擊即可彈出來公式編輯的介面，fs代表發生數。
501代表會計科目，根據實際的會計科目可以對公式進行調整。
5、第一種編輯本年累計數。這裡有兩種編輯方式。
一種的公式為：?c6+select(?d6,年@=年 and 月@=月+1)，這種公式如果計算出正確的本年累計數就需要做表頁的追加。
切換到資料狀態，點選編輯--追加--表頁，追加12月的即可。
這種公式不用做表頁的追加，直接單獨的表頁即可計算出來，當然這種公式也可以做表頁的追加喔。
擴充套件資料：
改革開放40年百名傑出民營企業家名單
（按姓氏筆畫為序排列）
丁佐巨集 月星集團****董事長
萬 隆 雙彙集團董事長
馬 雲 阿里巴巴集團董事局主席
馬有福 青海雪舟三絨集團董事長
王 偉 貴州興偉集團公司董事長
王 填 步步高集團董事長
王文京 用友軟體股份****董事長兼總裁
10樓：匿名使用者
傾情奉獻：
資產負債表公式如下
c7=qc("1001",全年,,,,,,,"y",,)+qc("1002",全年,,,,,,,"y",,)+qc("1012",全年,,,,,,,"y",,)
d7=qm("1001",月,,,,,,,"y",,)+qm("1002",月,,,,,,,"y",,)+qm("1012",月,,,,,,,"y",,)
g7=qc("2001",全年,,,,,,,"y",,)
h7=qm("2001",月,,,,,,,"y",,)
c8=qc("1101",全年,,,,,,,"y",,)
d8=qm("1101",月,,,,,,,"y",,)
g8=qc("2101",全年,,,,,,,"y",,)
h8=qm("2101",月,,,,,,,"y",,)
c9=qc("1121",全年,,,,,,,"y",,)
d9=qm("1121",月,,,,,,,"y",,)
g9=qc("2201",全年,,,,,,,"y",,)
h9=qm("2201",月,,,,,,,"y",,)
c10=qcex("112201",全年,"借",,,"",,,,"y",,,)+qcex("112202",全年,"借",,,"",,,,"y",,,)+qcex("112203",全年,"借",,,"",,,,"y",,,)+qcex("112204",全年,"借",,,"",,,,"y",,,)+qcex("112205",全年,"借",,,"",,,,"y",,,)+qcex("112206",全年,"借",,,"",,,,"y",,,)-qc("1231",全年,,,,,,,"y",,)+qcex("2203",全年,"借",,,"",,,,"y",,,)
d10=qmex("112201",月,"借",,,"",,,,"y",,,)+qmex("112202",月,"借",,,"",,,,"y",,,)+qmex("112203",月,"借",,,"",,,,"y",,,)+qmex("112204",月,"借",,,"",,,,"y",,,)+qmex("112205",月,"借",,,"",,,,"y",,,)+qmex("112206",月,"借",,,"",,,,"y",,,)-qm("1231",月,,,,,,,"y",,)+qmex("2203",月,"借",,,"",,,,"y",,,)
g10=qcex("2202",全年,"貸",,,,,,,"y",,)+qcex("1123",全年,"貸",,,"",,,,"y",,,)
h10=qmex("2202",月,"貸",,,,,,,"y",,)+qmex("1123",月,"貸",,,"",,,,"y",,,)
c11=qcex("1123",全年,"借",,,"",,,,"y",,,)+qcex("2202",全年,"借",,,"",,,,"y",,,)
d11=qmex("1123",月,"借",,,"",,,,"y",,,)+qmex("2202",月,"借",,,"",,,,"y",,,)
g11=qcex("112201",全年,"貸",,,"",,,,"y",,,)+qcex("112202",全年,"貸",,,"",,,,"y",,,)+qcex("112203",全年,"貸",,,"",,,,"y",,,)+qcex("112204",全年,"貸",,,"",,,,"y",,,)+qcex("112205",全年,"貸",,,"",,,,"y",,,)+qcex("112206",全年,"貸",,,"",,,,"y",,,)+qcex("2203",全年,"貸",,,"",,,,"y",,,)
h11=qmex("112201",月,"貸",,,"",,,,"y",,,)+qmex("112202",月,"貸",,,"",,,,"y",,,)+qmex("112203",月,"貸",,,"",,,,"y",,,)+qmex("112204",月,"貸",,,"",,,,"y",,,)+qmex("112205",月,"貸",,,"",,,,"y",,,)+qmex("112206",月,"貸",,,"",,,,"y",,,)+qmex("2203",月,"貸",,,"",,,,"y",,,)
c12=qc("1132",全年,,,,,,,"y",,)
d12=qm("1132",月,,,,,,,"y",,)
g12=qc("2211",全年,,,,,,,"y",,)
h12=qm("2211",月,,,,,,,"y",,)
c13=qc("1131",全年,,,,,,,"y",,)
d13=qm("1131",月,,,,,,,"y",,)
g13=qc("2221",全年,,,,,,,"y",,)
h13=qm("2221",月,,,,,,,"y",,)
c14=qcex("122101",全年,"借",,,"",,,,"y",,,)+qcex("122102",全年,"借",,,"",,,,"y",,,)+qcex("122103",全年,"借",,,"",,,,"y",,,)+qcex("2241",全年,"借",,,"",,,,"y",,,)
d14=qmex("122101",月,"借",,,"",,,,"y",,,)+qmex("122102",月,"借",,,"",,,,"y",,,)+qmex("122103",月,"借",,,"",,,,"y",,,)+qmex("2241",月,"借",,,"",,,,"y",,,)
g14=qc("2231",全年,,,,,,,"y",,)
h14=qm("2231",月,,,,,,,"y",,)
c15=qc("1401",全年,,,,,,,"y",,)+qc("1402",全年,,,,,,,"y",,)+qc("1403",全年,,,,,,,"y",,)+qc("1404",全年,,,,,,,"y",,)+qc("1405",全年,,,,,,,"y",,)+qc("1406",全年,,,,,,,"y",,)+qc("1407",全年,,,,,,,"y",,)+qc("1408",全年,,,,,,,"y",,)+qc("1411",全年,,,,,,,"y",,)+qc("1421",全年,,,,,,,"y",,)+qc("5001",全年,,,,,,,"y",,)+qc("5201",全年,,,,,,,"y",,)-qc("1471",全年,,,,,,,"y",,)
d15=qm("1401",月,,,,,,,"y",,)+qm("1402",月,,,,,,,"y",,)+qm("1403",月,,,,,,,"y",,)+qm("1404",月,,,,,,,"y",,)+qm("1405",月,,,,,,,"y",,)+qm("1406",月,,,,,,,"y",,)+qm("1407",月,,,,,,,"y",,)+qm("1408",月,,,,,,,"y",,)+qm("1411",月,,,,,,,"y",,)+qm("1421",月,,,,,,,"y",,)+qm("5001",月,,,,,,,"y",,)+qm("5201",月,,,,,,,"y",,)-qm("1471",月,,,,,,,"y",,)
g15=qc("2232",全年,,,,,,,"y",,)
h15=qm("2232",月,,,,,,,"y",,)
g16=qcex("122101",全年,"貸",,,"",,,,"y",,,)+qcex("122102",全年,"貸",,,"",,,,"y",,,)+qcex("122103",全年,"貸",,,"",,,,"y",,,)+qcex("2241",全年,"貸",,,"",,,,"y",,,)
h16=qmex("122101",月,"貸",,,"",,,,"y",,,)+qmex("122102",月,"貸",,,"",,,,"y",,,)+qmex("122103",月,"貸",,,"",,,,"y",,,)+qmex("2241",月,"貸",,,"",,,,"y",,,)
c17=qc("1472",全年,,,,,,,"y",,)
d17=qm("1472",月,,,,,,,"y",,)
c18=ptotal(?c7:?c17)
d18=ptotal(?d7:?d17)
g19=ptotal(?g7:?g18)
h19=ptotal(?h7:?h18)
c20=qc("1503",全年,,,,,,,"y",,)
d20=qm("1503",月,,,,,,,"y",,)
c21=qc("1501",全年,,,,,,,"y",,)-qc("1502",全年,,,,,,,"y",,)
d21=qm("1501",月,,,,,,,"y",,)-qm("1502",月,,,,,,,"y",,)
g21=qc("2501",全年,,,,,,,"y",,)
h21=qm("2501",月,,,,,,,"y",,)
c22=qc("153101",全年,,,,,,,"y",,)
d22=qm("153101",月,,,,,,,"y",,)
g22=qc("2502",全年,,,,,,,"y",,)
h22=qm("2502",月,,,,,,,"y",,)
c23=qc("1511",全年,,,,,,,"y",,)-qc("1512",全年,,,,,,,"y",,)
d23=qm("1511",月,,,,,,,"y",,)-qm("1512",月,,,,,,,"y",,)
g23=qc("2701",全年,,,,,,,"y",,)-qc("2702",全年,,,,,,,"y",,)
h23=qm("2701",月,,,,,,,"y",,)-qm("2702",月,,,,,,,"y",,)
c24=qc("1521",全年,,,,,,,"y",,)
d24=qm("1521",月,,,,,,,"y",,)
g24=qc("271101",全年,,,,,,,"y",,)+qc("271102",全年,,,,,,,"y",,)
h24=qm("271101",月,,,,,,,"y",,)+qm("271102",月,,,,,,,"y",,)
c25=qc("1601",全年,,,,,,,"y",,)-qc("1602",全年,,,,,,,"y",,)-qc("1603",全年,,,,,,,"y",,)
d25=qm("1601",月,,,,,,,"y",,)-qm("1602",月,,,,,,,"y",,)-qm("1603",月,,,,,,,"y",,)
g25=qc("2801",全年,,,,,,,"y",,)
h25=qm("2801",月,,,,,,,"y",,)
c26=qc("1604",全年,,,,,,,"y",,)
d26=qm("1604",月,,,,,,,"y",,)
g26=qc("2901",全年,,,,,,,"y",,)
h26=qm("2901",月,,,,,,,"y",,)
c27=qc("1605",全年,,,,,,,"y",,)
d27=qm("1605",月,,,,,,,"y",,)
c28=qc("1606",全年,,,,,,,"y",,)
d28=qm("1606",月,,,,,,,"y",,)
g28=ptotal(?g21:?g27)
h28=ptotal(?h21:?h27)
c29=qc("162101",全年,,,,,,,"y",,)+qc("162102",全年,,,,,,,"y",,)-qc("1622",全年,,,,,,,"y",,)
d29=qm("162101",月,,,,,,,"y",,)+qm("162102",月,,,,,,,"y",,)-qm("1622",月,,,,,,,"y",,)
g29=?g19+?g28
h29=?h19+?h28
c30=qc("1631",全年,,,,,,,"y",,)-qc("1632",全年,,,,,,,"y",,)
d30=qm("1631",月,,,,,,,"y",,)-qm("1632",月,,,,,,,"y",,)
c31=qc("1701",全年,,,,,,,"y",,)-qc("1702",全年,,,,,,,"y",,)-qc("1703",全年,,,,,,,"y",,)
d31=qm("1701",月,,,,,,,"y",,)-qm("1702",月,,,,,,,"y",,)-qm("1703",月,,,,,,,"y",,)
g31=qc("4001",全年,,,,,,,"y",,)
h31=qm("4001",月,,,,,,,"y",,)
c32=qc("5301",全年,,,,,,,"y",,)
d32=qm("5301",月,,,,,,,"y",,)
g32=qc("4002",全年,,,,,,,"y",,)
h32=qm("4002",月,,,,,,,"y",,)
c33=qc("1711",全年,,,,,,,"y",,)
d33=qm("1711",月,,,,,,,"y",,)
g33=qc("4201",全年,,,,,,,"y",,)
h33=qm("4201",月,,,,,,,"y",,)
c34=qc("1801",全年,,,,,,,"y",,)
d34=qm("1801",月,,,,,,,"y",,)
g34=qc("4101",全年,,,,,,,"y",,)
h34=qm("4101",月,,,,,,,"y",,)
c35=qc("1811",全年,,,,,,,"y",,)
d35=qm("1811",月,,,,,,,"y",,)
g35=qc("4103",全年,,,,,,,"y",,)+qc("4104",全年,,,,,,,"y",,)
h35=qm("4103",月,,,,,,,"y",,)+qm("4104",月,,,,,,,"y",,)
g36=?g31+?g32-?g33+?g34+?g35
h36=?h31+?h32-?h33+?h34+?h35
c37=ptotal(?c20:?c36)
d37=ptotal(?d20:?d36)
c38=c18+c37
d38=d18+d37
g38=g29+g36
h38=h29+h36
利潤表公式如下
c5=fs(6001,月,"貸",,,,,"y")+fs(6051,月,"貸",,,,,"y")
d5=lfs(6001,月,"貸",,,,,"y")+lfs(6051,月,"貸",,,,,"y")
c6=fs(6401,月,"借",,,,,"y")+fs(6402,月,"借",,,,,"y")
d6=lfs(6401,月,"借",,,,,"y")+lfs(6402,月,"借",,,,,"y")
c7=fs(6403,月,"借",,,,,"y")
d7=lfs(6403,月,"借",,,,,"y")
c8=fs(6601,月,"借",,,,,"y")
d8=lfs(6601,月,"借",,,,,"y")
c9=fs(6602,月,"借",,,,,"y")
d9=lfs(6602,月,"借",,,,,"y")
c10=fs(6603,月,"借",,,,,"y")
d10=lfs(6603,月,"借",,,,,"y")
c11=fs(6701,月,"借",,,,,"y")
d11=lfs(6701,月,"借",,,,,"y")
c12=fs(6101,月,"貸",,,,,"y")
d12=lfs(6101,月,"貸",,,,,"y")
c13=fs(6111,月,"借",,,,,"y")*-1
d13=lfs(6111,月,"借",,,,,"y")*-1
c15=?c5-?c6-?c7-?c8-?c9-?c10-?c11+?c12+?c13
d15=?d5-?d6-?d7-?d8-?d9-?d10-?d11+?d12+?d13
c16=fs(6301,月,"貸",,,,,"y")
d16=lfs(6301,月,"貸",,,,,"y")
c17=fs(6711,月,"借",,,,,"y")
d17=lfs(6711,月,"借",,,,,"y")
c19=?c15+?c16-?c17
d19=?d15+?d16-?d17
c20=fs(6801,月,"借",,,,,"y")
d20=lfs(6801,月,"借",,,,,"y")
c22=?c19-?c20
d22=?d19-?d20
把以上兩表的公式複製下來，分別貼上為兩個文字檔案（資產負債表.txt 利潤表.txt），開啟用友，進入ufo，開啟相應的報表模板，在「格式」狀態下，在公式列表視窗，匯入對應的公式文字檔案即可。
我這個報表公式是按實際工作設定的，非常實用，特別是應收應付按明細餘額分析法自動確定報表方向，另一個就是可以不記賬也能產生報表。
具體格式請自行調整，單元格的編號也要隨之變動。
求資產負債表，資產負債表 求公式
什麼是資產負債表。資產負債表 the balance sheet 亦稱財務狀況表，表示企業在一定日期 通常為各會計期末 的財務狀況 即資產 負債和業主權益的狀況 的主要會計報表。資產負債表 求公式 把資產負債表，利潤表中所有公式都告知你吧 1 資產負債表 首先是平衡公式 資產 負債 所有者權益。資產...
資產負債表求詳細解析，資產負債表 求詳細解析
存貨 11600 7600 25000 44200流動資產 貨幣 存貨 應收 借 應付 借 預付 借 預收 借 壞賬 800 106000 54000 4000 10000 1000 173800 固定資產 187000 7000 2500 177500資產合計 173800 177500 3513...
低負債資產負債表是什麼意思啊,資產負債表中的負債是什麼意思？
同學你好，很高興為您解答！clean balance sheet低負債資產負債表指一家公司的資產負債表內的債務很低，甚至無債務。從業報考條件 1 年滿 18 週歲 2 具有完全民事行為能力 3 具有高中以上文化程度 4 中國證監會規定的其他條件。考生一定要注意一下看自己是否能報考。希望我的回答能幫助...