苏会计电算化操作详细讲义.doc

专业好文档(苏)会计电算化操作步骤本次考试分成两部分:基础部分、选择题40题、判断题20题.windows1题、word1题、excel1题实务部分:账务处理、会计报表、查询双击桌面“会计电算化练习”选择试卷(10套) 确定(注意考生须知)一、 账务处理选择实务题操作员的姓名:考试人确认(一)初始设置:1,基础设置单击”基础设置” 凭证类型分三类(收款、付款、转账) 确定,单击”基本设置” 部门核算方式核算部门确认2,初始科目会客1)科目设置单击”增加” 科目代码、名称、科目特征、余额方向确定(依次输入)单击“退出”2)初始科目余额:按题目要求填入科目的余额存入退出3,初始完成确认:1)验证:科目设置合法性检查: 确认确定科目余额汇总检查:同上核对往来账、部门账余额:同上试算平衡:同上连续完成上述工作:同上2)初始完成确认:确认数据备份确认确定选择是否:决定完成初始化选”是” 确定(二)日常账务单击”凭证处理” 记账凭证录入1,凭证类型:收款、付款、转账说明:1)借方有现金和银行存款科目时应选择”收款凭证”; 2)贷方有现金或银行存款科目的应选择”付款凭证”; 3)借、货双方都有现金或银行存款科目的应选择”付款凭证”; 4)借、货双方都没有现金或银行存款科目的应选择”转账凭证” 注意:”现金”属于”现金” “银行”属于”银行存款”2,凭证日期3,摘要内容:输入1-104,科目名称:直接输入科目代码或双击单元格选择所需科目说明:a. 科目是银行存款或产成品,点击确定后出现辅助核算对话框单击”退出”b. 科目是应收账款或应付账款,点确认后出现辅助核算对话框单击”单位帮助” 选定公司名称确认5,借、贷方金额输入第一张凭证单击”存入” 依次输入10张凭证退出关闭日常账务处理窗口返回二、报表(一)资产负债表操作员名称姓名考生确认资产负债表1,选择要求定义公式单元格单击选择函数、科目代码、(月份) 确认存入例如:应收票据:年初数:=j_qcye(112.1) 期未数:=j_qmye(112.2) 应付票据年初数:=d_qcye(202.1) 期未数:=d_qmye(202.2)j:借方 d:贷方 qcye:期初余额 qmye:期未余额112:代码 1:月份(二)损益表选择要求定义公式单元格单击选择函数、科目代码、(月份) 确认存入例如:产品销售收入:本月数=dfe(501) 本年累计数:=dlje(501)dfe:贷方发生额 dlje:贷方累计额 501:科目代码资产负债表资产类的科目属于”借方科目”,(其中:坏账资金积累和累计折旧属于“借方科目”);负债及所有者权益属于”贷方科目”;期初数:用函数命令“9”表示”借方” “10”表示”贷方”注:要选用月份:”1月份”期未数:用函数命令“11”表示”借方” “12”表示”贷方”损益表科目中有”收入”和科目前有”加”的属于贷方科目科目中有”支出”和科目前有”减”的属于借方科目本月数:用函数命令“1”表示”借方” “2”表示”贷方”本年累计数:用函数命令“5”表示”货方” “6”表示”借方”货币资金=现金+银行存款+其它贷币资金三、 系统管理及查询关闭报表窗口点返回点账务处理选”操作员管理”及输入密码:”12345” 单击权限管理操作员权限管理点增加输入姓名:如:1111,是否财务主管前打“” 点存入退出点击1111点修改全部赋予存入退出点击”系统服务”菜单更换操作员选择添加的操作员:如:1111确定单击账务处理第1和第2题有日常账务处理账簿查询打印根据题目:选凭证类型及输入凭证号确定点击窗口上方的填写答案按钮点增加一行输入题号:如第一题就输入题号”1”,填写相应的科目数额确定第3、4、5题用明细账输入明细账”科目选择”提示框:选择相应的代码单击确认点击窗口下方的填写答案按钮增加一行输入题号和答案确认退出。按“是”返回操作输完。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 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 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 first 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 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 to 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 said 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 mission. 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 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 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 they 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 games 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-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