中国中铁财务信息平台导出科目余额表和凭证表操作说明及截图
- 格式:docx
- 大小:364.47 KB
- 文档页数:3
中国中铁项目物资管理信息系统V7.0 操作说明书中国中铁物资管理中心陕西梦龙科技开发有限公司2015年3月目录第一部分:系统简介第二部分:集团公司级管理员操作手册第三部分:子分公司级管理员操作手册第四部分:项目部材料员操作手册第五部分:项目部工区材料员操作手册第六部分:项目部库管员操作手册(条码管理手册)第七部分:项目部司磅员操作手册第一部分系统简介为贯彻落实中国中铁股份公司全面预算管理和精细化管理的要求,进一步完善物资管理信息化建设,提高现场物资收发及核算信息化管理水平,中国中铁物资管理中心要求我公司对中国中铁项目物资管理信息系统进行全面升级,确定中国中铁项目物资管理信息系统V7.0、中国中铁电子商务系统、中国中铁ERP系统基础数据共用中国中铁物资基础平台信息,通过物资过程控制等手段,延伸开发出条码管理子系统、物资过磅影像子系统,实现物资验收、盘点、发放的自动化,加强物资现场管理过程控制,实现现场物资管理实时化,满足各级管理部门工作要求。
中国中铁物资管理系统实施小组成员通过四年多时间的努力,中国中铁物资管理系统推广使用已取得比较好的效果,在中国中铁物资管理中心领导的安排下,这几年我公司技术人员深入项目部现场调研分析,发现在中国中铁各工程局物资管理普遍存在以下几方面的管理难点:1、在项目部层面物资管理难点有以下几个方面:A、项目部物资帐与实物不符,物资追溯难以建立;B、实物现场收发不规范,发票滞后,预点收量大且不规范,造成工程成本不真实;C、地材管理问题比较多,亏损比较普遍;D、砼超耗严重;E、项目部物资月度需用计划因受其他部门工作制约,不能按时编制提交;F、工程管理部门收方不及时,成本分析数据不能及时提供。
2、公司层管理难点有以下几个方面:A、因项目部不能及时提供物资需用计划,集中采购数量难以及时报送;B、供应商数量比较大,大宗物资及战略供应商集中供应物资数量难统计;C、以前大多采用分散式管理,管理层各种数据报表不能自动生成,各种消耗指标难以建立,不能给经营及管理工作提供比较及时、准确的数据;D、因项目部过程控制不严谨,导致公司成本分析不准确,精细化管理难以实现。
四公司中国中铁财务信息系统核算规范指南中国中铁财务信息系统核算规范指南(试行稿)为了规范各单位使用中国中铁CRECFIS2.0财务信息系统(以下简称“核算系统”),统一核算口径,明细核算内容;在集团公司的核算框架内,依照核算系统的具体功能,结合公司治理需求,特对核算系统制定本规范指南,请各单位遵照执行。
一、系统爱护原则1.会计科目爱护按集团和公司统一要求处理,不得自行增加科目。
需要在统一爱护之外单独增加私有明细科目的,应先向公司报告,公司研究有必要建立全公司统一私有明细科目的,公司将规范并公布科目名称及核算内容,供各会计主体使用。
公司研究没有必要建立全公司统一私有明细科目的,将给予处理建议意见,供需增设核算的会计主体参考使用。
2.辅助科目爱护必须按公司规范设置予以爱护,不得自行随意改动和增减编码及核算名称。
需要在统一爱护之外单独增加私有辅助科目的,应在私有辅助一至五中选择使用。
辅助科目中重点关注项目核算辅助,项目核算辅助是公司层面统一各单位辅助核算而采取的一种规范化设置,既方便各会计主体日常核算,也便于汇总层面数据查询。
项目核算辅助的要紧目的是通过辅助核算能够达到建立相关台账的功能,减少建立相关台账的工作量,因此同时会增加核算时的工作量。
3.为了便于核算系统数据衔接和相关辅助核算生成台账的需要,涉及成本类和损益类科目、以及辅助核算科目,都要在年初余额爱护中把借贷开累数据录入。
在建项目和新上项目必须按照规范指南要求进行年初余额爱护,收尾和清算项目可依照本项目情形能够不录入涉及辅助核算的借贷开累数据,然而涉及成本类和损益类科目的借贷开累数据需要录入。
4.所有明细科目除“客户往来”和“人员核算”辅助核算科目需要生成辅助明细账外,其他辅助核算科目均不需生成。
“项目核算”中只有“业主往来”、“个人往来”、“劳务往来”和“内部往来”辅助核算科目需要生成辅助明细账外,其他“项目核算”中的辅助核算科目均不需生成。
中国石油财务软件数据导出教程一、财务软件登陆;1、在桌面选择财务软件登陆图标2、出现登陆界面之后直接点击登录按钮:3、点击登录按钮之后弹出证书选择的选择框之后,选择登录者身份:4、选择登录身份之后显示签名成功的提升界面,然后输入密码,点击登录即可。
二、凭证导出方法:1、成功登录系统之后,点击账务管理,在账务管理的下拉菜单中,找到凭证查询,然后选择凭证流水查询。
2、选择凭证流水查询之后,出现查询界面,根据需要导出的期间,设置会计期间,在查询选项中选择详细内容中选择需要导出的所有项目;3、设置完所有条件后,显示出凭证流水明细账,点击右键选择转出;然后根据以上步骤导出第1期到第16期所有的数据。
导出凭证明细帐时须注注意:(1)、如企业某月数据量大于1万条记录时,则必须将界面中的滚动栏滚至界面最后,即界面中须出现合计栏目,而后再导出数据,则可把企业的该月的所有记录完整导出为电子表格。
否则将出现仅导出前1万条数据,数据不完整的问题。
(2)、如企业某月数据量超过65535条记录,须安装excel2007,方能一次性保存超大数据量的电子表格,否则将出现仅导出65535条记录,数据不完整的问题。
三、明细余额的导出方法:1、登陆财务软件以后,在账务管理——账务查询——科目余额——明细余额表、2、点击明细余额表后,选择会计期间和科目范围:4、选择完成后点击确认,出现科目余额表:4、在科目余额表点右键,选择转出:5、导出的Excel表中,根据Excel中左边的数据,可以选择需要显示的科目级次;(英文版)Two regulations promulgated for implementation is in the party in power for a long time and the rule of law conditions, the implementation of comprehensive strictly strategic plan, implementation in accordance with the rules and discipline to manage the party, strengthen inner-party supervision of major initiatives. The two regulations supporting each other, the < code > adhere to a positive advocate, focusing on morality is of Party members and Party leading cadres can see, enough to get a high standard; < rule > around the party discipline, disciplinary ruler requirements, listed as "negative list, focusing on vertical gauge, draw the party organizations and Party members do not touch the" bottom line ". Here, the main from four square face two party rules of interpretation: the first part introduces two party Revised regulations the necessity and the revision process; the second part is the interpretation of the two fundamental principles of the revision of laws and regulations in the party; the third part introduces two party regulations modified the main changes and needs to grasp several key problems; the fourth part on how to grasp the implementation of the two regulations of the party. < code > and < Regulations > revised the necessity and revised history of the CPC Central Committee the amendment to the Chinese CommunistParty members and leading cadres honest politics several guidelines > and < Chinese Communist Party discipline and Punishment Regulations > column 1 by 2015 to strengthen party laws and regulations focus. Two party regulations revision work lasted a Years, pooling the wisdom of the whole party, ideological consensus, draw historical experience, respect for the wisdom of our predecessors, which reflects the unity of inheritance and innovation; follow the correct direction, grasp the limited goals, adhere to the party's leadership, to solve the masses of the people reflect a focus on the problem. The new revision of the < code > and < rule >, reflects the party's 18 and the eighth session of the third, the spirit of the fourth plenary session, reflecting the experience of studying and implementing the General Secretary Xi Jinping series of important speech, reflects the party's eighteen years comprehensive strictly practice. (a) revised two regulations of the party need of < the ICAC guidelines > in < in 1997 Leaders as members of the Communist Party of China clean politics certain criteria (Trial) > based on revised, the promulgation and implementation of January 2010, to strengthen the construction of the contingent of leading cadres play an important role. But with the party to manage the party strictly administering the deepening, has not been able to fully meet the actual needs. Content is toocomplicated, "eight prohibition, 52 are not allowed to" hard to remember, and also difficult to put into practice; the second is concisely positive advocated by the lack of prohibited provisions excessive, no autonomy requirements; the third is banned terms and discipline law, both with the party discipline, disciplinary regulations repeat and Criminal law and other laws and regulations repeat; the fourth is to "clean" the theme is not prominent, not for the existing problems, and is narrow, only needle of county-level leading cadres above. < rule > is in 1997 < Chinese Communist Party disciplinary cases (Trial) > based on revision, in December 2003 the promulgation and implementation, to strengthen the construction of the party play very important role. Along with the development of the situation, which many provisions have been unable to fully meet the comprehensive strictly administering the practice needs. One is Ji law, more than half of the provisions and criminal law and other countries laws and regulations Repetition; two is the political discipline regulations is not prominent, not specific, for violation of the party constitution, damage the authority of Party Constitution of misconduct lack necessary and serious responsibility to pursue; third is the main discipline for the leading cadres, does not cover all Party members. Based on the above situation, need to < the criterion of a clean and honestadministration > and < rule > the two is likely to be more relevant regulations first amendment. By revising, really put the authority of Party discipline, the seriousness in the party tree and call up the majority of Party members and cadres of the party constitution of party compasses party consciousness. (II) two party regulations revision process the Central Committee of the Communist Party of China attaches great importance to two regulations revision . Xi Jinping, general books recorded in the Fifth Plenary Session of the eighth session of the Central Commission for Discipline Inspection, on the revised regulations < > made clear instructions. According to the central deployment, the Central Commission for Discipline Inspection from 2014 under six months begin study two regulations revision. The Standing Committee of the Central Commission for Discipline Inspection 4 review revised. Comrade Wang Qishan 14 times held a special meeting to study two regulations revision, amendment clarifies the direction, major issues of principle, path and target, respectively held a forum will listen to part of the province (area) secretary of the Party committee, Secretary of the Discipline Inspection Commission, part of the central ministries and state organs DepartmentThe first party committee is mainly responsible for people, views of experts and scholars and grassroots party organizations andParty members. Approved by the Central Committee of the Communist Party of China, on 7 September 2015, the general office of the Central Committee of the Party issued a notice to solicit the provinces (autonomous regions, municipalities) Party, the central ministries and commissions, state ministries and commissions of the Party (party), the General Political Department of the military, every 3 people organization of Party of two regulations revision opinion. Central Commission for Discipline Inspection of extensive solicitation of opinions, careful study, attracting, formed a revised sent reviewers. In October 8 and October 12, Central Committee Political Bureau Standing Committee and the Political Bureau of the Central Committee After consideration of the two regulations revised draft. On October 18, the Central Committee of the Communist Party of China formally issued two regulations. Can say, two laws amendment concentrated the wisdom of the whole party, embodies the party. Second, < code > and < Regulations > revision of the basic principles of two party regulations revision work and implement the party's eighteen, ten eight plenary, the spirit of the Fourth Plenary Session of the Eleventh Central Committee and General Secretary Xi Jinping important instructions on the revised < low political criterion > and < Regulations >, highlighting the ruling partycharacteristics, serious discipline, the discipline quite in front of the law, based on the current, a long-term, advance as a whole, with Bu Xiuding independent < rule > and < rule >. Main principle is: first, adhere to the party constitution to follow. The constitution about discipline and self-discipline required specific, awaken the party constitution of party compasses party consciousness, maintaining the authority of the constitution. General Secretary Xi Jinping pointed out that "no rules, no side round. Party constitution is the fundamental law, the party must follow the general rules. In early 2015 held the eighth session of the Central Commission for Discipline Inspection Fifth Plenary Session of the 16th Central Committee, Xi Jinping again pointed out that constitution is the party must follow the general rules, but also the general rules." the revision of the < code > and < rule > is Method in adhere to the regulations established for the purpose of combining rule of virtue is to adhere to the party constitution as a fundamental to follow, the constitution authority set up, wake up the party constitution and party rules the sense of discipline, the party constitution about discipline and self-discipline specific requirements. 4 second is to adhere to in accordance with the regulations governing the party and the party. The Party of rule of virtue "de", mainly refers to the party's ideals and beliefs, excellent traditional style. The revised the< code > closely linked to the "self-discipline", insisting on the positive initiative, for all members, highlight the "vital few", emphasized self-discipline, focusing on the morality, and the majority of Party members and the ideological and moral standards. The revised < > Ji method separately, Ji, Ji Yan to Method, as a "negative list", emphasizing the heteronomy, focusing on vertical gauge. Is this one high and one low, a positive reaction, the strict party discipline and practice results transformation for the integration of the whole party to observe moral and discipline requirements, for the majority of Party members and cadres provides benchmarking and ruler. Third, insist on to. In view of the problems existing in the party at the present stage, the main problems of Party members and cadres in the aspect of self-discipline and abide by the discipline to make clearly defined, especially the party's eighteen years strict political discipline and political rules, organization and discipline and to implement the central eight provisions of the spirit against the four winds and other requirements into Disciplinary provisions. Not one pace reachs the designated position, focusing on in line with reality, pragmatic and effective. After the revision of major changes, major changes in the < code > and < rule > modified and needs to grasp several key problems (a) < code > < code > adhere to according to regulationsgoverning the party and party with morals in combination, for at the present stage, the leadership of the party members and cadres and Party members in existing main problems of self-discipline, put forward principles, requirements and specifications, showing Communists noble moral pursuit, reflected at all times and in all over the world ethics from high from low 5 common requirements. One is closely linked to the "self-discipline", removal and no direct relation to the provisions of . the second is adhere to a positive advocate, "eight prohibition" 52 are not allowed to "about the content of the" negative list moved into synchronization amendment < cases >. Three is for all the party members, will apply object from the leadership of the party members and cadres to expand to all Party members, fully embodies the comprehensive strictly required. The fourth is prominent key minority, seize the leadership of the party members and cadres is the key, and put forward higher requirements than the ordinary Party members. Five is to simplify, and strive to achieve concise, easy to understand, easy to remember. The revised < code > is the ruling Party since the first insists on a positive advocate forAll Party members and the self-discipline norms, moral declaration issued to all members of the party and the National People's solemn commitment. > < criterion of a clean and honest administration consists of 4 parts, 18,more than 3600 words. After the revision of the < code >, a total of eight, 281 words, including lead, specification and Party member cadre clean fingered self-discipline norms, etc. Part 3 members low-cost clean and self-discipline, the main contents can be summarized as "four must" "eight code". Lead part, reiterated on ideal and faith, fundamental purpose, the fine traditions and work style, noble sentiments, such as "four must" the principle of requirements, strong tone of self-discipline, The higher request for 6 and supervised tenet, the foothold in permanent Bao the party's advanced nature and purity, to reflect the revised standards requirements. Members of self-discipline norms around the party members how to correctly treat and deal with the "public and private", "cheap and rot" thrifty and extravagance "bitter music", put forward the "four norms". Party leader cadre clean fingered self-discipline norms for the leadership of the party members and cadres of the "vital few", around the "clean politics", from civil servant of the color, the exercise of power, moral integrity, a good family tradition and other aspects of the leadership of the party members and cadres of the "four norms" < > < norm norm. "The Party member's self-discipline norms" and "party members and leading cadre clean fingered self-discipline norms," a total of eight, collectively referred to as the "eight". "Four must" and "eight" of thecontent from the party constitution and Party's several generation of leaders, especially Xi Jinping, general secretary of the important discussion, refer to the "three discipline and eight points for attention" statements, and reference some embody the Chinese nation excellent traditional culture essence of epigrams. (2) the revised regulations, the main changes in the revised Regulations > to fully adapt to the strictly requirements, reflects the according to the regulations governing the law of recognition of deepening, the realization of the discipline construction and Jin Ju. < rule > is party a ruler, members of the basic line and follow. And the majority of Party members and cadres of Party organizations at all levels should adhere to the bottom line of thinking, fear discipline, hold the bottom line, as a preventive measure, to keep the party's advanced nature and purity. 1, respect for the constitution, refinement and discipline. Revised < rule > from comprehensive comb physical constitution began, the party constitution and other regulations of the Party of Party organizations and Party discipline requirements refinement, clearly defined in violation of the party constitution will be in accordance with regulations to give the corresponding disciplinary action. The original 10 categories of misconduct, integration specification for political discipline, discipline, honesty and discipline masses Ji Law and discipline and discipline andother six categories, the content of < rule > real return to Party discipline, for the majority of Party members and listed a "negative list. 7 2, highlighting the political discipline and political rules. > < Regulations according to the stage of the discipline of outstanding performance, emphasizing political discipline and political rules, organization and discipline, in opposition to the party's leadership and the party's basic theory, basic line, basic program and basic experience, the basic requirement of behavior made prescribed punishment, increase the cliques, against the organization such as violation of the provisions, to ensure that the central government decrees and the Party of centralized and unified. 3, adhere to strict discipline in the law and discipline In front, Ji separated. Revised < Regulations > adhere to the problem oriented, do Ji separated. Any national law existing content, will not repeat the provisions, the total removal of 79 and criminal law, repeat the content of the public security management punishment law, and other laws and regulations. In the general reiterated that party organizations and Party members must conscientiously accept the party's discipline, die van comply with national laws and regulations; at the same time, to investigate violations of Party members and even criminal behavior of Party discipline and responsibility, > < Regulations distinguish five different conditions, with special provisions weremade provisions, so as to realize the connection of Party discipline and state law. 4, reflect Wind building and anti-corruption struggle of the latest achievements. < rule > the party's eighteen years implement the spirit of the central provisions of the eight, against the requirements of the "four winds" and transformation for disciplinary provisions, reflecting the style construction is always on the road, not a gust of wind. In the fight against corruption out of new problems, increase the trading rights, the use of authority relatives profit and other disciplinary terms. Prominent discipline of the masses, the new against the interests of the masses and ignore the demands of the masses and other disciplinary terms and make provisions of the disposition and the destruction of the party's close ties with the masses.Discipline to protect the party's purpose. 8 of these regulations, a total of three series, Chapter 15, 178, more than 24000 words, after the revision of the regulations a total of 3 series, Chapter 11, 133, 17000 words, divided into "general" and "special provisions" and "Supplementary Provisions" Part 3. Among them, add, delete, modify the provisions of the proportion of up to nearly 90%. 1, the general general is divided into five chapters. The first chapter to the regulations of the guiding ideology, principles and scope of application of the provisions, highlight the strengthening of the partyconstitution consciousness, maintenance the authority of Party Constitution, increase the party organizations and Party members must abide by the party constitution, Yan Centralized centralized, would examine at all levels of the amended provisions implementing and maintaining Party discipline, and consciously accept the party discipline, exemplary compliance with national laws and regulations. The second chapter of discipline concept, disciplinary action types and effects of the regulations, will be a serious warning from the original a year for a year and a half; increase the Party Congress representative, by leaving the party above (including leave probation) punishment, the party organization should be terminated its representative qualification provisions. The third chapter of the disciplinary rules of use prescribed in the discipline rectifying process, non convergence, not close hand classified as severely or heavier punishment. "Discipline straighten "At least eighteen years of five years, these five years is to pay close attention to the provisions of the central eight implementation and anti -" four winds ". The fourth chapter on suspicion of illegal party disciplinary distinguish five different conditions, with special provisions were made provisions, to achieve effective convergence of Party and country 9 method. < rule > the provisions of Article 27, Party organizations in thedisciplinary review found that party members have committed embezzlement, bribery, dereliction of duty dereliction of duty and other criminal law act is suspected of committing a crime shall give cancel party posts, probation or expelled from the party. The second is < Regulations > Article 28 the provisions of Party organizations in the disciplinary review But found that party members are stipulated in the criminal law, although not involved in a crime shall be investigated for Party discipline and responsibility should be depending on the specific circumstances shall be given a warning until expelled punishment. This situation and a difference is that the former regulation behavior has been suspected of a crime, the feeling is quite strict, and the latter for the behavior not involving crime, only the objective performance of the provisions of the criminal code of behavior, but the plot is a crime to slightly. < Regulations > the 29 provisions, Party organizations in the discipline review found that party members and other illegal behavior, affect the party's image, the damage to the party, the state and the people's interests, we should depend on the situation Seriousness given disciplinary action. The loss of Party members, seriously damaging the party's image of behavior, should be given expelled from the party. At this article is party member is in violation of the criminal law outside the other illegal acts, such as violatesthe public security administration punishment law, customs law, financial laws and regulations behavior. The fourth is < cases > Article 32 stipulates, minor party members and the circumstances of the crime, the people's Procuratorate shall make a decision not to initiate a prosecution, or the people's court shall make a conviction and exempted from criminal punishment shall be given within the party is removed from his post, probation or expelled from the party. Party members and crime, sheets were fined in accordance with For acts; the principal Ordinance amended the provisions of the preceding paragraph. This is the new content, in order to achieve Ji method effective convergence. Five is < > the thirty third article 10 of the provisions, the Party member due to an intentional crime is sentenced to criminal law (including probation) sheets or additional deprivation of political rights; due to negligence crime and was sentenced to three years or more (excluding three years) a penalty, shall give expelled punishment. Due to negligence crime is convicted and sentenced to three years (including three years) in prison or be sentenced to public surveillance, detention, shall in general be expelled from the party. For the individual may not be expelled from the party, should control Approval. This is followed and retained the original > < Regulations the provisions of punishment party authorization rules and report to a level partyorganizations. For is "party members with criminal acts, and by the criminal punishment, generally should be expelled from the party". The fifth chapter of probationary Party member of the discipline and discipline after missing members of the treatment and punishment decisions, such as the implementation of the provisions, clear the related party discipline and punishment decision made after, for duties, wages and other relevant alteration formalities for the longest time. 2, sub sub section will the original regulations of10 categories of acts of violation of discipline integration revised into 6 categories, respectively, in violation of the punishments for acts of political discipline "in violation of discipline behavior of punishment" in violation of integrity of disciplinary action points "of violation punishments for acts of mass discipline" "the violation of work discipline, punishment" in violation of discipline of life behavior punishment "6 chapters. 3, annex" Supplementary Provisions "clear authority making supplementary provisions of, cases of interpretative organ, as well as regulations implementation time and retroactivity etc.. 11 (3) learning understanding > < regulations needs to grasp several key problems The first problem -- about the violation of political discipline behavior > < new ordinance chapter 6 the political discipline column for the six disciplines, that is the main opposition to Party leadership and the opposition of the basictheory, basic line, basic program and basic experience, basic requirements of misconduct made provisions of the disposition, especially the eighteen since the CPC Central Committee put forward the Yan Mingzheng treatment of discipline and political rules requirements and practical achievements transformation for Discipline article, increase the false debate central policies, cliques, against the organization review, make no discipline of the principle of harmony terms. These are the party's eighteen years in comprehensive strictly Process combined with the practice of rich content. (1) false debate the central policies and undermine the Party of centralized and unified the problem is made in accordance with the provisions of the party constitution. Constitution in general programme requirements adhere to democratic centralism is one of the requirements of the construction of the party must adhere to the four cardinal. Application of this principle is not only the party the basic organization principle and is also the mass line in party life, it requires that we must fully develop inner-party democracy, respect for the dominant position of Party members, safeguarding the Party member democratic rights, give full play to the enthusiasm and creativity of the party organizations at all levels and Party members, at the same time, also must implement the right concentration, ensure the party's mission < the chaos in unity and concertedaction to ensure that the party's decision to get quickly and effectively implementing. The Party Central Committee formulated the major principles and policies, through different channels and ways, fully listen to the party organizations and Party members of the opinions and suggestions, but 12 is some people face to face not to say back blather "" will not say, after the meeting said, "" Taiwan does not say, and nonsense ", in fact, not only disrupt the people thought, some causing serious consequences, the damage to the Party of the centralized and unified, hinder the central policy implementation, but also a serious violation of the democratic system of principles. There is no doubt that shall, in accordance with the Regulations > 4 Specified in Article 6 to give the appropriate punishment. For did not cause serious consequences, to give criticism and education or the corresponding tissue processing. (2) about the destruction of the party's unity < New Regulations > the forty eighth to fifty second article, to damage Party's unity unified and violation of political discipline, punishment situation made explicit provisions. Article 52 of the new "in the party get round group, gangs seek private gain, cliques, cultivate private forces or through the exchange of interests, for their own to create momentum and other activities to gain political capital, given a serious warning or withdraw from their party posts disposition; if thecircumstances are serious, to give Leave a party to observation or expelled from the party. (3) on against the organization review of the provisions of the constitution, party loyalty honesty is party members must comply with the obligations. Members must obey the organization decision, shall not violate the organization decided encounters by asking questions to find organization, rely on the organization, shall not deceive the organization, against the organization. For example, after the investigation does not take the initiative to explain the situation, but to engage in offensive and defensive alliance, hiding the stolen money is against survey organization, is a violation of the behavior of political discipline. Article 24 of the original > < Regulations, although the provisions of the interference, hinder group review the behavior of the fabric can be severely or 13 Aggravated punishment, but did not put this kind of behavior alone as a discipline for qualitative amount of discipline. > < new regulations increase the Article 57, "anti organization review, one of the following acts, given a warning or serious warning; if the circumstances are relatively serious, giving removed from or placed on probation within the party post; if the circumstances are serious, give expelled from the party: (a) on supply or forged, destroyed, transfer, conceal evidence; (II) to prevent others expose, providing evidence。
注意:sap导表命令代码:FAGLL03或者FBL3N,其中上图为FAGLL03代码为例。
【附加总结类文档一篇,不需要的朋友可以下载后编辑删除,谢谢】2015年文化馆个人工作总结在XXXX年X月,本人从XXXX学院毕业,来到了实现我梦想的舞台--XX区文化馆工作。
在这里我用艰辛的努力,勤劳的付出,真诚而认真地工作态度认真的做好自身的每一项文化馆相关工作,取得了较为良好的工作业绩。
随着一场场活动的成功举办、一台台戏剧的成功出演,在这个带有着梦想和希望的舞台上,转眼之间我已在这里渡过了XX年的青春事业,我亦与舞台共同成长,逐步由一名青涩的毕业生,历练成为了今天的XXX。
梦想在于不断坚持,未来的旅途在于不断的前进,在这个承载着梦的舞台上,我持以坚定的信心和丰富的工作能力与工作经验,一步一步超前迈进着。
下面我将自身XX年来的工作能力情况总结如下:一、一专多能服务1、高端学识水平。
本人于XXXX年XX月毕业于XXXX大学XX专业。
随后于XXXX年X 月进入XX区文化馆从事XX工作,至今已有XX年的时间。
在本人从事文化馆XX工作的XX年里,我始终坚持积极探索、勤奋学习,做到辅助教学与实际工作相长,坚定与时俱进的思想理念,努力攻克各项困难,将提高效益型,能力型的工作绩效作为自己的奋斗目标,并在自身的素质方面进行了坚持不懈的强化与提高。
我深知,要不断充实自身能力,深化提升自身素质,才能够不断更新自我,超越自我,为我XX区文化馆的发展与活动做出奉献。
为此,我树立起了牢固的学习思想,除积极参加上级机关以及本馆内组织的各项思想教育以及业务培训活动外,我还一直坚持,利用业余时间阅读和学习各类与我文化馆工作相关的理论书籍与系列杂志等相关信息书籍,通过专业的培训和广泛的阅读,我吸取了优秀工作者以及高级文化工作人员的先进经验和优秀成果,在理论和实践结合的层面上逐渐开拓了视野,以高效提升了自身的专业能力和学识水平。
此外,我还实时关注党和国家的新政策、新方针,及时总结在党政新政策中有关于文化馆工作的相关内容,进行学习与研究,并结合党的十八大会议精神,落实自身的党政清廉作风,实际提升自身党性、提高自身综合素质能力。
新中大导出科目余额表-概述说明以及解释1.引言1.1 概述概述部分的内容:引言部分是文章开头的一段,主要是对文章的主题进行简要介绍和概述。
在这篇文章中,我们将探讨导出科目余额表的相关内容。
科目余额表是会计报表中的一种重要形式,用于反映企业在会计周期结束时各个科目的余额情况。
导出科目余额表是会计工作中一项非常重要的任务,通过导出科目余额表,我们可以全面了解企业在会计周期内的财务状况,为企业的财务决策提供重要参考。
在本文的正文部分,我们将首先探讨导出科目余额表的意义。
导出科目余额表不仅可以帮助企业了解财务状况,还可以辅助企业进行财务分析和决策。
其次,我们将介绍导出科目余额表的方法,包括通过会计软件导出和手工导出两种方式。
通过这些方法,企业可以快速准确地导出科目余额表,并进行相应的数据分析。
最后,在结论部分,我们将总结导出科目余额表的重要性,并展望导出科目余额表的未来发展。
随着信息技术的不断发展,导出科目余额表的方法和工具也将不断更新和改进,为企业的财务管理提供更加便捷和高效的支持。
通过本文的阅读,读者将能够全面了解导出科目余额表的意义和方法,以及其对企业财务管理的重要性。
希望本文能够对读者在实践中进行科目余额表导出和应用提供一定的参考和帮助。
1.2文章结构1.2 文章结构本文按照以下结构组织和阐述导出科目余额表的相关内容:第一部分为引言,主要概述本文要探讨的内容、文章的结构和目的。
第二部分是正文,主要包括导出科目余额表的意义和方法两个方面。
其中,在导出科目余额表的意义部分,将探讨科目余额表在财务管理中的重要性以及其对企业经营决策的作用。
在导出科目余额表的方法部分,将详细介绍如何使用财务软件或电子表格工具来导出科目余额表,并给出具体的操作步骤和注意事项。
第三部分为结论,将总结导出科目余额表的重要性,并展望其在未来发展中的前景和应用场景。
通过以上结构的组织,本文旨在全面阐述导出科目余额表的意义和方法,帮助读者更好地理解和运用科目余额表,提升财务管理和决策能力。
竭诚为您提供优质文档/双击可除中铁集团项目成本核算表格excel篇一:利用excel进行企业成本核算分析利用excel进行企业成本核算分析提要本文结合企业生产经营的特点,利用excel表设计符合自身需要的成本核算表,再利用成本核算表进行企业的成本分析,为企业经营决策提供依据。
关键词:excel表;成本核算;成本分析中图分类号:F23文献标识码:a一、成本核算的步骤企业的生产经营过程也是资产的消耗过程,因此生产经营成本按其经济性质分为劳动对象、劳动手段和活劳动耗费三大类。
企业成本核算过程中,在财务软件中应设置“生产成本”一级科目,借方用于归集所发生各项生产费用,贷方登记结转库存商品的成本。
在“生产成本”科目下设置“基本生产成本”和“辅助生产成本”两个二级科目。
根据成本要素在二级科目下设置三级科目,“直接材料”、“直接人工”、“动力”和“制造费用”用于成本核算。
在成本计算过程中,涉及成本的归集和分配,计算完工产品成本和月末在产品成本,进而计算产品的销售成本。
在核算中,结合企业自身生产经营特点,利用excel表进行成本计算和分析,通过表与表之间的链接,使得整个计算过程变得简洁,便于操作。
(表1)下面以品种法为例作介绍。
企业根据自身生产经营组织形式、产品工艺特点和需要掌握的成本分析资料,将产品分类进行核算。
表中以a产品成本核算为例,a产品领用的直接材料从金蝶等财务软件中生产成本-基本生产成本-直接材料科目下取数,财务软件系统一般都有导出成excel电子表格的功能,粘贴在生产费用表中,直接人工、动力、制造费用和辅助生产从财务软件中取数直接计入,也可以采用一定的分配标准分配计入,将本月发生的生产费用归集到生产费用表中,填入下面的生产成本明细账中。
(表2)制造部门将产品做好之后,完工入库,月末统计库存商品月报表。
报表之间的钩稽关系是:库存商品月报表本期进库数c1=产品成本计算表库存商品产量b2=库存商品明细账入库数b3;库存商品月报表本期出库数d2=库存商品明细账出库数d4=销售成本表销售数量b2。
在线客户端版简明操作手册目录第一章程序安装及用户登录 (1)1. 程序安装 (1)2. 用户登录 (2)3. 密码修改 (4)第二章数据管理 (5)1. 数据录入 (5)2. 提取上期数 (9)3. 汇总明细查看 (11)4. 历史数据查看 (11)5. 批量上报 (12)6. 自定义录入 (13)第三章批量操作 (18)1. 批量运算 (18)2. 批量审核 (20)3. 审核结果查看 (21)4. 批量导出 (22)第四章数据查询 (24)1. 过录查询 (24)第五章数据汇总 (26)1. 节点汇总 (26)第六章合并计算 (27)1. 合并计算 (27)第一章程序安装及用户登录1. 程序安装为确保《中国铁建报表大厅在线客户端》的正确安装和使用,请首先确认您的电脑已安装了系统组件:Microsoft .NET Framework 3.5 SP1。
可以在“控制面板->添加或删除程序”里查看,如图1.1.1。
注:Window 7操作系统已预装该组件。
图1.1.1 添加或删除程序Microsoft .NET Framework 3.5 SP1下载地址:精简版(中国铁建服务器):/down/dotNetFramework3.5 精简版安装.rar 完整版(天空软件站):/down/dotnetfx35.zip运行《中国铁建报表大厅》安装程序,根据提示,设置好安装路径等,完成安装。
如图1.1.2。
1.1.2 中国铁建报表大厅安装界面注:①. 对于Windows 7操作系统,安装完成后需要作如下设置:在程序图标上点击鼠标右键,选择“属性”,在“兼容性”页签下勾选“以管理员身份运行该程序”,并点击“确定”。
如图1.1.3。
②. 对于所有的64位操作系统,本软件均不支持。
图1.1.3 以管理员身份运行该程序2. 用户登录在确保网络申通的情况下,运行程序,填写好用户名、密码、服务器地址,点击【登录】按钮即可登录系统。
目录目录 (1)总述 (7)第一章系统安装 (9)1.1客户端安装 (9)1.2客户端配置 (15)1.3客户端登录界面 (17)第二章公用设置 (17)一、基础模块 (18)1、货币定义 (18)2、结算方式 (18)3、组织定义 (18)4、单位往来 (19)二、系统管理 (20)1、用户维护 (20)2、系统锁管理 (20)3、安全审计 (20)4、在线用户监控 (21)三、总账模块 (21)1、科目定义 (21)2、账集核算关系定义 (21)3、科目定义权限 (22)四、辅助模块 (22)1、专项核算 (22)第三章账务处理 (23)一、初始设置 (24)1、系统设置 (25)2、组织部门定义 (26)3、普通公司往来单位定义 (26)4、员工定义 (27)5、普通公司科目定义 (27)6、核算关系定义 (28)7、余额初始 (28)8、凭证类型定义 (29)9、原始凭证定义 (30)10、输出格式定义 (30)11、核算项目定义 (31)二、凭证处理 (31)2、审核 (32)3、记账 (33)4、凭证查询 (33)5、凭证打印 (33)6、凭证汇总表 (34)7、对方科目汇总表 (34)三、账表查询 (34)1、科目余额表 (34)2、二维余额表 (35)3、总账 (35)4、三栏式明细账 (35)5、多栏式明细账 (35)6、序时账 (36)7、其它日记账 (36)四、正式账页 (36)1、账务账页 (36)2、辅助账页 (37)五、出纳管理 (37)1、现金日记账 (37)2、银行日记账 (37)3、资金日报表 (37)4、结算号录入 (38)5、银行对账 (38)六、期末处理 (39)1、规则凭证定义 (39)2、规则凭证生成 (40)3、结转凭证定义 (40)4、结转凭证生成 (40)5、平衡检查 (40)6、月末结转 (40)7、年末结转 (41)8、会计期间维护 (42)第四章辅助管理 (43)一、专项核算账表查询 (43)1、项目余额表 (43)2、收支明细表 (43)3、项目三栏账 (43)4、分析项目多栏账 (43)5、分析科目多栏账 (43)6、任意余额表 (43)7、任意三栏账 (43)8、任意多栏账 (44)二、部门核算账表查询 (44)2、部门科目余额表 (44)3、部门二维余额表 (44)4、部门收支明细表 (44)5、部门三栏账 (44)6、分析部门多栏账 (44)7、分析科目多栏账 (45)8、部门属性余额表 (45)9、部门属性三栏账 (45)第五章往来管理 (46)一、个人往来账表查询 (46)1、个人余额表 (46)2、个人三栏账 (46)二、单位往来账表查询 (46)1、单位余额表 (46)2、单位二维余额表 (46)3、单位三栏账 (46)4、关联交易查询 (47)三、单位往来核销处理 (47)第六章报表管理 (49)一、报表管理 (49)1、新建报表 (50)2、打开报表 (51)3、报表启封封存 (51)4、报表数据审核 (52)5、报表删除 (52)二、报表字典管理 (52)1、报表类别定义 (52)2、报表类别划分 (53)3、数据类别定义 (53)4、数据单元定义 (53)5、划分数据单元 (54)6、报表数据关联 (54)三、报表内部操作 (55)1、报表属性 (55)2、格式另存为 (55)3、打印设置 (55)4、打印区域 (55)5、视图 (56)6、单元格 (56)四、报表公式处理 (57)1、公式定义的规则 (58)2、计算公式 (61)五、报表数据处理 (65)1、报表计算 (65)2、报表校验 (65)3、报表汇总 (65)4、报表调整 (66)5、定义自动计算 (66)六、报表财务函数 (67)1、科目函数 (67)2、部门函数 (68)3、个人往来函数 (68)4、往来单位函数 (69)5、专项核算函数 (69)6、产品函数 (70)7、凭证合计函数 (71)七、报表分析 (72)1、报表趋势分析 (72)2、报表底稿分析 (73)3、报表构成分析 (73)4、报表任意分析 (74)第七章固定资产 (75)一、固定资产初始 (75)1、资产项目定义及说明 (76)2、资产类别定义 (76)3、资产来源定义 (76)4、资产用途定义 (76)5、资产状态定义 (77)6、变更类型 (77)7、减少原因定义 (77)8、折旧方法定义 (77)1、单位项目定义 (78)2、资产卡片维护 (78)3、减值准备清单 (79)4、资产编号生成规则定义 (79)二、日常业务处理 (79)1、资产增加 (80)2、资产减少 (80)3、资产清理 (80)4、资产变卖 (81)5、资产变更确认 (81)6、减值准备 (81)7、资产准备审核 (81)8、固定资产调出清单 (82)9、大修理记录 (82)11、资产变更 (82)二、月末 (83)1、工作量输入 (83)2、计提折旧 (83)3、部门占用量输入 (83)4、折旧分摊 (84)5、月结 (84)6、年结 (84)三、报表查询 (84)1、资产明细余额表查询 (84)2、资产折旧明细表查询 (85)3、资产折旧汇总表查询 (85)4、资产折旧任意汇总表 (85)5、部门资产明细表 (85)6、部门折旧明细表 (85)7、资产卡片 (85)8、资产明细账 (85)9、资产明细账输出 (85)10、逾龄资产 (86)11、资产附属设备 (86)12、类别部门汇总表 (86)13、资产总账 (86)四、单据查询 (86)1、资产增加记录 (87)2、资产减少记录 (87)3、资产变更记录 (87)4、资产减值准备清单记录 (87)5、大修理记录 (87)6、资产调拨查询 (87)五、分析 (87)1、资产部门分析 (87)2、资产状态分析 (88)3、资产用途分析 (88)4、资产来源分析 (88)5、资产类别分析 (88)6、资产价值分析 (88)7、资产单位分析 (89)8、资产单位折旧预测 (89)第八章问题解决 (90)一、系统问题 (90)二、总帐系统问题 (92)三、报表系统问题 (97)四、固定资产系统问题 (98)总述集中浪潮财务管理系统是基于微软DNA多层体系开发的集中式财务浪潮财务管理系统,它面向集团企事业单位的集中核算,提供多会计实体、多单位的集中处理。
11、账表、凭证查询(1)查询报表1、执行“总账→账簿查询→余额表”命令,打开“发生额及余额查询条件”对话框,见下图。
选择查询条件,单击【确定】按钮。
2、屏幕弹出“发生额及余额表”窗口,如需要显示借、贷方累计发生额,再单击【累计】按钮即可。
(2)查询账簿。
1、查询原材料--主板(140301)数量金额明细账执行“总账→账簿查询→明细账”命令,打开“明细账查询条件”对话框,见下图。
选择查询条件,科目为:140301,单击【确定】按钮。
在屏幕弹出的“原材料明细账”窗口右上角,单击下拉按钮,选择“数量金额式“账页形式,屏幕即显示原材料--主板(140301)数量金额明细账2、查询销售部王利个人三栏明细账。
执行“总账→辅助查询→个人往来明细账→个人三栏式明细账”命令,打开“个人往来—三栏明细账”对话框,见下图。
选择部门:销售部,个人为:王利。
,单击【确定】按钮。
即显示王利个人往来明细账。
3、查询华荣公司三栏明细账。
执行“往来→账簿→客户往来明细账→客户三栏明细账”命令,打开“客户三栏明细账”对话框,见下图。
选择客户:华荣,科目为:1122 应收账款。
单击【确定】按钮。
即显示华荣公司应收账款三栏明细账。
(3)查询凭证1、执行“总账→凭证→查询凭证”命令,打开“凭证查询”对话框,如下图,单击【辅助条件】按钮,屏幕显示凭证查询辅助条件输入对话框。
2、在屏幕显示凭证查询辅助条件输入对话框,选择科目为:库存现金,金额为1000,如图所示,点击【确定】按钮,屏幕即显示满足查询条件的所有凭证。
3、屏幕显示现金支出在1000元以上的所有凭证窗口,如下图,双击窗口中任一凭证行,屏幕即显示该张凭证。
新中大财务软件数据导出(操作说明)提示:以下操作都是在财务软件中进行,也就是说,先运行新中大财务软件,然后再按以下步骤来操作一、标准数据接口导出数据(上海市标准或 98001标准)请仔细查看新中大财务软件的菜单多数情况操作步骤是:(系统管理 ->数据安全-> 生成审计数据)或者: (如新中大财务软件V6.0)(菜单)数据安全→生成审计数据1(菜单)数据安全→生成审计数据2(这两个菜单生成数据中,有一个生成的是98001标准,一个是上海市标准,其中的格式文件是:format.ini的是98001标准,它的数据更完整,生成的上海市标准的数据不够完整(如凭证没有摘要,这个标准的格式文件是SHCZ.txt),如果不能确定哪一下是98001标准,请两个都执行生成.)提示:导出的数据文件有多个,请一并复制到U盘,然后在审计大师的[财务数据]窗体的→[导入财务数据]→从标准数据接口中导入→选中format.ini 或SHCZ.txt或类似的文件名就可以导入数据。
例如:(1)第一步:主界面:系统管理(2)第二步:数据安全维护(菜单)→生成审计数据 (有的版本有两个生成审计数据,请都执行)(3)第三步:设置导出路径: (如下图:A:\ 改为你的U盘 ,比如 F:\A单位则是在F:\A单位下会有5个文件,见下图)(4)导入到审计大师中: 项目初始化→财务数据 ->导入财务数据 ->从标准数据接口中导入 -> 选中:format.ini二、导出数据到Excel文件提示:如果不支持上述的标准数据接口,请按以下方法导出。
(一)科目余额表导出财务会计功能→总账→账簿管理→汇总表→科目余额表→会计期选择→选第一期至第X期→确认→过滤→科目编码(选1-最低级)→其他→全部展开→F 系统功能→打印→转换输出→设文件名(XX公司余额表,选excel表) →确认。
(二)凭证导出财务会计功能→总账→凭证处理→凭证查询。