蘇會(huì)計(jì)電算化操作詳細(xì)講義

1、專業(yè)好文檔(蘇)會(huì)計(jì)電算化操作步驟本次考試分成兩部分:基礎(chǔ)部分、選擇題40題、判斷題20題.windows1題、word1題、excel1題實(shí)務(wù)部分:賬務(wù)處理、會(huì)計(jì)報(bào)表、查詢雙擊桌面“會(huì)計(jì)電算化練習(xí)”選擇試卷(10套) 確定(注意考生須知)一、 賬務(wù)處理選擇實(shí)務(wù)題操作員的姓名:考試人確認(rèn)(一)初始設(shè)置:1,基礎(chǔ)設(shè)置單擊”基礎(chǔ)設(shè)置” 憑證類型分三類(收款、付款、轉(zhuǎn)賬) 確定,單擊”基本設(shè)置” 部門核算方式核算部門確認(rèn)2,初始科目會(huì)客1)科目設(shè)置單擊”增加” 科目代碼、名稱、科目特征、余額方向確定(依次輸入)單擊“退出”2)初始科目余額:按題目要求填入科目的余額存入退出3,初始完成確認(rèn):1)驗(yàn)證:

2、科目設(shè)置合法性檢查: 確認(rèn)確定科目余額匯總檢查:同上核對(duì)往來賬、部門賬余額:同上試算平衡:同上連續(xù)完成上述工作:同上2)初始完成確認(rèn):確認(rèn)數(shù)據(jù)備份確認(rèn)確定選擇是否:決定完成初始化選”是” 確定(二)日常賬務(wù)單擊”憑證處理” 記賬憑證錄入1,憑證類型:收款、付款、轉(zhuǎn)賬說明:1)借方有現(xiàn)金和銀行存款科目時(shí)應(yīng)選擇”收款憑證”; 2)貸方有現(xiàn)金或銀行存款科目的應(yīng)選擇”付款憑證”; 3)借、貨雙方都有現(xiàn)金或銀行存款科目的應(yīng)選擇”付款憑證”; 4)借、貨雙方都沒有現(xiàn)金或銀行存款科目的應(yīng)選擇”轉(zhuǎn)賬憑證” 注意:”現(xiàn)金”屬于”現(xiàn)金” “銀行”屬于”銀行存款”2,憑證日期3,摘要內(nèi)容:輸入1-104,科目名稱:

3、直接輸入科目代碼或雙擊單元格選擇所需科目說明:a. 科目是銀行存款或產(chǎn)成品,點(diǎn)擊確定后出現(xiàn)輔助核算對(duì)話框單擊”退出”b. 科目是應(yīng)收賬款或應(yīng)付賬款,點(diǎn)確認(rèn)后出現(xiàn)輔助核算對(duì)話框單擊”單位幫助” 選定公司名稱確認(rèn)5,借、貸方金額輸入第一張憑證單擊”存入” 依次輸入10張憑證退出關(guān)閉日常賬務(wù)處理窗口返回二、報(bào)表(一)資產(chǎn)負(fù)債表操作員名稱姓名考生確認(rèn)資產(chǎn)負(fù)債表1,選擇要求定義公式單元格單擊選擇函數(shù)、科目代碼、(月份) 確認(rèn)存入例如:應(yīng)收票據(jù):年初數(shù):=j_qcye(112.1) 期未數(shù):=j_qmye(112.2) 應(yīng)付票據(jù)年初數(shù):=d_qcye(202.1) 期未數(shù):=d_qmye(202.2)j:

4、借方 d:貸方 qcye:期初余額 qmye:期未余額112:代碼 1:月份(二)損益表選擇要求定義公式單元格單擊選擇函數(shù)、科目代碼、(月份) 確認(rèn)存入例如:產(chǎn)品銷售收入:本月數(shù)=dfe(501) 本年累計(jì)數(shù):=dlje(501)dfe:貸方發(fā)生額 dlje:貸方累計(jì)額 501:科目代碼資產(chǎn)負(fù)債表資產(chǎn)類的科目屬于”借方科目”,(其中:壞賬資金積累和累計(jì)折舊屬于“借方科目”);負(fù)債及所有者權(quán)益屬于”貸方科目”;期初數(shù):用函數(shù)命令“9”表示”借方” “10”表示”貸方”注:要選用月份:”1月份”期未數(shù):用函數(shù)命令“11”表示”借方” “12”表示”貸方”損益表科目中有”收入”和科目前有”加”的屬于

5、貸方科目科目中有”支出”和科目前有”減”的屬于借方科目本月數(shù):用函數(shù)命令“1”表示”借方” “2”表示”貸方”本年累計(jì)數(shù):用函數(shù)命令“5”表示”貨方” “6”表示”借方”貨幣資金=現(xiàn)金+銀行存款+其它貸幣資金三、 系統(tǒng)管理及查詢關(guān)閉報(bào)表窗口點(diǎn)返回點(diǎn)賬務(wù)處理選”操作員管理”及輸入密碼:”12345” 單擊權(quán)限管理操作員權(quán)限管理點(diǎn)增加輸入姓名:如:1111,是否財(cái)務(wù)主管前打“” 點(diǎn)存入退出點(diǎn)擊1111點(diǎn)修改全部賦予存入退出點(diǎn)擊”系統(tǒng)服務(wù)”菜單更換操作員選擇添加的操作員:如:1111確定單擊賬務(wù)處理第1和第2題有日常賬務(wù)處理賬簿查詢打印根據(jù)題目:選憑證類型及輸入憑證號(hào)確定點(diǎn)擊窗口上方的填寫答案按鈕點(diǎn)

6、增加一行輸入題號(hào):如第一題就輸入題號(hào)”1”,填寫相應(yīng)的科目數(shù)額確定第3、4、5題用明細(xì)賬輸入明細(xì)賬”科目選擇”提示框:選擇相應(yīng)的代碼單擊確認(rèn)點(diǎn)擊窗口下方的填寫答案按鈕增加一行輸入題號(hào)和答案確認(rèn)退出。按“是”返回操作輸完。winger tuivasa-sheck, who scored two tries in the kiwis 20-18 semi-final win over england, has been passed fit after a lower-leg injury, while slater has been named at full-back but is still

7、 recovering from a knee injury aggravated against usa.both sides boast 100% records heading into the encounter but australia have not conceded a try since josh charnleys effort in their first pool match against england on the opening day.aussie winger jarryd hayne is the competitions top try scorer

8、with nine, closely followed by tuivasa-sheck with eight.but it is recently named rugby league international federation player of the year sonny bill williams who has attracted the most interest in the tournament so far.the kiwi - with a tournament high 17 offloads - has the chance of becoming the fi

9、rst player to win the world cup in both rugby league and rugby union after triumphing with the all blacks in 2011.id give every award back in a heartbeat just to get across the line this weekend, said williams.the (lack of) air up there watch mcayman islands-based webb, the head of fifas anti-racism

10、 taskforce, is in london for the football associations 150th anniversary celebrations and will attend citys premier league match at chelsea on sunday.i am going to be at the match tomorrow and i have asked to meet yaya toure, he told bbc sport.for me its about how he felt and i would like to speak t

11、o him first to find out what his experience was.uefa hasopened disciplinary proceedings against cskafor the racist behaviour of their fans duringcitys 2-1 win.michel platini, president of european footballs governing body, has also ordered an immediate investigation into the referees actions.cska sa

12、id they were surprised and disappointed by toures complaint. in a statement the russian side added: we found no racist insults from fans of cska. baumgartner the disappointing news: mission aborted.the supersonic descent could happen as early as sunda.the weather plays an important role in this miss

13、ion. starting at the ground, conditions have to be very calm - winds less than 2 mph, with no precipitation or humidity and limited cloud cover. the balloon, with capsule attached, will move through the lower level of the atmosphere (the troposphere) where our day-to-day weather lives. it will climb

14、 higher than the tip of mount everest (5.5 miles/8.85 kilometers), drifting even higher than the cruising altitude of commercial airliners (5.6 miles/9.17 kilometers) and into the stratosphere. as he crosses the boundary layer (called the tropopause),e can expect a lot of turbulence.the balloon will

15、 slowly drift to the edge of space at 120,000 feet ( then, i would assume, he will slowly step out onto something resembling an olympic diving platform.they blew it in 2008 when they got caught cold in the final and they will not make the same mistake against the kiwis in manchester.five years ago t

16、hey cruised through to the final and so far history has repeated itself here - the last try they conceded was scored by englands josh charnley in the opening game of the tournament.that could be classed as a weakness, a team under-cooked - but i have been impressed by the kangaroos focus in their ga

17、mes since then.they have been concentrating on the sort of stuff that wins you tough, even contests - strong defence, especially on their own goal-line, completing sets and a good kick-chase. theyve been great at all the unglamorous stuff that often goes unnoticed in the stands but not by your team-

18、mates.it is as though their entire tournament has been preparation for the final.in johnathan thurston, cooper cronk, cameron smith and either billy slater or greg inglis at full-back they have a spine that is unmatched in rugby league. they have played in so many high-pressure games - a priceless asset goi