20 19 Annual Work Summary of Bank Audit

It's the end of the year again, and writing an annual work summary is what every employee in our office wants to do at the end of the year! The following is the 20 19 Annual Work Summary of Bank Audit compiled by me for your reference only. Welcome to reading.

20 19 summary of the annual work of bank audit (I) According to the internal audit work arrangement of China Branch, internal control management risk analysis and evaluation activities were carried out throughout the bank in October19 and October 10. According to the internal control evaluation plan, the internal control system of the sub-branch was reviewed from five aspects: internal control environment, risk identification and evaluation, control activities, information exchange and feedback, supervision and evaluation, and regular risk analysis and evaluation were infiltrated into every functional department, every work link and every post of the bank. We will identify the supervision objects of the evaluation as front-line business personnel and managers at all levels; Focus on auditing key units, key positions and weak links; Check and supervise the systems established by various functional departments in a targeted manner, and pay attention to the loopholes and defects in the internal control system and management. The evaluation scope has been expanded and the evaluation level has been improved. Through audit and evaluation, * * * found more than ten hidden risks and weak links in important positions, listed them one by one, analyzed the causes of the problems, put forward reasonable preventive measures and suggestions, and reported them in writing to the leaders of the municipal branches and sub-branches to urge the internal control system to be strictly implemented throughout the bank. The work is summarized as follows:

First, actively carry out internal audit investigation.

According to the key work, weak links and risk points of the whole bank, we have determined two audit investigation items. They are "Investigation on Centralized Procurement Management of xx Sub-branch" and "Investigation on the Implementation of Foreign Exchange Regulations, Internal Control System and Business Operating Procedures of xx Sub-branch".

This year, X, we investigated the centralized procurement management of sub-branches, found some management deficiencies and operational irregularities, and put forward rectification opinions and suggestions.

On June 5438+065438+ 10 this year, we investigated the implementation of foreign exchange laws and regulations, internal control system and business operation process of the branch, and basically understood and mastered the foreign exchange management of Rui 'an Branch through on-site inquiry, consulting some files and observing the operation of the counter. According to the investigation, Ruian Branch can better implement foreign exchange laws and regulations, timely implement foreign exchange policies, establish a relatively sound internal control management system, and have clear business authorization and responsibilities. According to the internal control requirements of the superior bureau, combined with its own characteristics, we can refine and supplement various internal control systems, timely revise and improve various foreign exchange business operation procedures, job responsibilities of foreign exchange management positions, assessment methods for foreign exchange managers, and establish internal control supervision and inspection methods. However, many problems have also been found, and rectification suggestions have been put forward according to the different nature of the problems, which have been basically implemented. It has promoted the foreign exchange management department to better implement foreign exchange laws and policies, strictly enforce the internal management system, and standardize business operations.

Through the audit investigation this year, * * * found more than 20 violations and put forward 20 rectification suggestions, most of which have been rectified and implemented. The investigation report written separately has been reported to the president of the branch and the audit department of Zhongzhi.

Two, actively carry out the audit found that the problem "look back" activities.

Since 20 19, under the personal supervision of the president and led by internal audit, our sub-branch has carefully organized and carried out the inspection on the rectification of problems found in the audit, done a good job of "mending after the sheep is dead", strengthened the implementation of rectification and consolidated the effectiveness of audit supervision.

1, leaders attach importance to it and strengthen the awareness of rectification. Arrange to check the problems found in the audit since 20 19 and the rectification. Require relevant departments to further implement their responsibilities and formulate practical measures; Strengthen the awareness of rectification, actively find potential risks, and resolutely put an end to the recurrence of similar problems.

2, careful organization, to ensure the effectiveness of the rectification. Arrange special personnel to sort out all audit projects one by one and carefully check the rectification of problems; All departments are required to report the self-inspection, the reasons for not rectifying and the next specific rectification measures to the Internal Audit Department. On the basis of self-inspection by each department, the internal audit organization personnel conducted re-inspection.

3. Strengthen responsibilities and implement rectification measures. Establishment of accountability system for internal audit rectification of Rui 'an Sub-branch. After the problems found in the inspection are identified by the person directly responsible and the person in charge of the department, corresponding accountability measures are taken according to the causes, nature and circumstances of the problems, and economic penalties are given.

4, strict supervision, to achieve the goal of rectification. For individual problems that are not rectified, urge to formulate specific rectification measures in the next step. Through the "looking back" activity of rectifying problems found in the audit, the goal of "promoting improvement through rectification and promoting improvement through rectification" has been truly realized.

Three. Actively participate in the inspection of internal audit projects of municipal branches.

According to the unified arrangement of the internal audit department of China Branch, this year I mainly participated in the administrative law enforcement inspection of Taishun County Sub-branch, the performance audit of Yueqing Sub-branch, and the foreign exchange administrative audit of Wenzhou Central Sub-branch. I can treat every project I participate in seriously and dutifully, and complete the task with good quality and quantity.

20 19 summary of annual work of bank audit (2) death of the deceased. In a blink of an eye, I have been in the audit department of the county branch for a year. This year, I experienced a process from hesitation to adaptation to loving my post. 2065438+2009 10 is a transitional period for me to enter the society from school. After the hasty training of the head office, I devoted myself to the cause of the Postal Savings Bank with confidence and passion. At the beginning of my career, I was assigned to the position of front desk teller, where I spent the first half of my career. In the warm family of the sales department, I am busy and full, and I have learned a lot of business knowledge and truth. This is one of mine. I think I will spend 1 2 years here to learn and experience, to grow and improve. I always remember our headmaster's long-winded words on the first day of employment, "I have accumulated a lot, but I have made little progress". At that time, I was at the front desk with peace of mind, studying modestly and working hard. However, on 2014,65438+1October 1 1 received a notice of personnel change and asked me to report to the audit department. I was really at a loss. Auditing has always been a mysterious profession for me, and I have always been a little scared from the bottom of my heart. I thought and thought. On the one hand, I believe this is a well-thought-out decision of the bank leaders, and there must be a reason for this arrangement, which is also the trust of the bank leaders in me; On the other hand, from the perspective of my own long-term development, auditing can make me learn and absorb more. Since then, I have embarked on the path of auditors.

When I first entered the audit department, I was deeply at a loss and frustrated. My own understanding of personal savings business is far from enough. As an internal auditor, the necessary prerequisite is to be proficient in various businesses handled by banks, and then to control internal risks. Fortunately, the colleagues in the audit department are not as mysterious and daunting as I thought before, but warm and amiable. At first, I went to the countryside to study with them, and when I returned to the department, I began to learn various business systems and internal control links. Every time I encounter something I don't understand, I will take the initiative to ask my colleagues in the department, and my colleagues will explain it patiently and meticulously. With the enthusiastic help of my colleagues and my efforts, I began to participate in the audit work in a week or so. Although at the beginning, speed is often the foundation of team progress, there are even some problems in some places. My colleagues in the same team always wait patiently and correct me politely. It is under such circumstances that I began to grow up bit by bit.

So far, I have grown into a qualified employee in the audit front of our branch, and I can independently undertake an audit work and write a true and accurate audit report. In the past six months, we have conducted a routine audit on the credit department, corporate business department, accounting cashier and two tier-one outlets of the branch once a month, and carried out several special audits according to the requirements put forward by superiors, so as to find out hidden problems in time and put forward rectification suggestions to escort the huge ship of branch business development. At the same time, I also regularly audit the second-class postal outlets and agency outlets every quarter. I am responsible for issuing audit opinions to the inspection office of the county post office every week, reporting the problems existing in the postal outlets to the postal leaders in time, and putting forward reasonable rectification opinions.

The work of the Audit Department has no outstanding business data and no real achievements. We silently pay the bill for the branch in order to avoid financial cases and ensure the safety of the company's funds. At the same time, very few people do not understand our work, pay insufficient attention to the problems existing in the inspection, and fail to make timely rectification as required. In the process of inspection, some problems are repeated, which not only increases our workload, but also makes us very worried. For example, some postal outlets do not close the tail door. Every time we ask this question, they always have a lot of reasons. It is not because employees' own arbitrariness and laziness form habits and put habits above the system. Not long ago, there was a murder and robbery at a postal outlet in Gansu Province. The most fundamental point is that the salesperson did not implement the system himself and left the tailgate open, which allowed vicious opportunities to take advantage of it. I hope that through this matter, the employees of our outlets will learn from this painful experience. There are still many problems that similar habits override the system. For example, the handover procedures are not strictly performed during the shift change, the system of two locks and one sign is not implemented when leaving the cabinet temporarily, the phenomenon of single person coming to the cabinet, the mutual transaction system is not implemented at the end of the day, and the insurance certificate is not strictly regarded as cash custody. These are potential huge hidden dangers, and the root of these problems lies only in the teller's own habits and sense of responsibility. I suggest that we should strengthen the evaluation of these aspects to eliminate the root cause of severe pain with mild pain.

For the current audit work, I think we are still in the audit stage and have not really met the needs of internal audit. With the continuous development of our bank, I think it is inevitable to change from audit to internal audit. At the same time, the challenges we face will be more and more enormous, and the requirements for our own quality will be higher and higher. Over the past six months, I have participated in a lot of training on audit work, and the audit system on the audit line is constantly being introduced. Electronic audit system, credit audit system and employee violation points system have been launched one after another, and now a brand-new audit system will be launched soon. Working methods are constantly changing. The knowledge we have learned not only stays in the system, but also includes the application of new systems and new working methods. This is a brand-new challenge for us. Only by continuous learning can we adapt to the escalating work style, otherwise we will be eliminated. Only by not being complacent, studying hard and innovating, and constantly trying to sum up, can we maintain the freshness and vitality of audit work. Audit has opened a window for me to challenge, whether to build a car behind closed doors or go out bravely, there is no need to answer. This half year is the summary of work and the beginning of facing new challenges. I understand that I still have many shortcomings, such as incomplete theoretical knowledge and lack of interpersonal skills, which are all difficult problems that I need to solve urgently at present. For this reason, I made a study plan for myself and spent 2 hours every day to supplement my shortcomings in these areas. I also know that I don't lack the initiative to learn, but patience and perseverance. My enemy will always be myself, and I firmly believe that I can defeat myself.

The year's work is over, and the new work has just begun. Every day is a new challenge. I am confident that I will do better in the future audit work.

20 19 summary of annual work of bank audit (iii) 20 19 is coming to an end. In the past 20 19, our bank has been doing well and withstood the pressure of the financial crisis. In the most difficult year of the economy, our bank has made great progress, which is particularly commendable, so our bank must make a good summary.

In order to adapt to the development under the new situation, the financial audit department has established, improved and implemented various financial rules and regulations. As the nature of the company has changed, it is necessary to revise and improve the company's financial rules and regulations. According to the financial system of the municipal bureau (company), combined with the actual situation of the group company, the financial system of xx Group was compiled. In order to sum up the experience and lessons and better accomplish the tasks in 2020, our financial audit work is summarized as follows:

I. Audit work

1, according to the spirit of the audit work conference of the Municipal Finance Bureau, put forward requirements for the work of the financial audit department.

(1) Continue to consolidate and implement the financial management module, strengthen the management awareness and responsibility awareness of financial personnel, and give full play to the functional role of financial management. While fully implementing information management, our financial personnel are required to devote their time and energy to enterprise management. Every week, they go to accounting companies to learn about the operation of enterprises, give full play to their subjective initiative, and provide more valuable information and suggestions for operators. This requirement is taken as the main index of target assessment in 20 19.

(2) All employees should establish financial management as the core idea of enterprise management, enhance their sense of crisis, urgency and responsibility, strengthen their study, and strive to improve their own quality to meet the requirements of financial work under the new situation.

2, fully meet the national audit.

In order to meet the comprehensive inspection of the National Audit Office, according to the audit focus of the municipal bureau (company), our department audited the financial revenue and expenditure on June 5438+February 3 1, and combined with the actual internal audit work, closely focused on the hot, key and difficult issues of the group company, gave full play to the financial supervision and service functions, provided timely decision-making basis for the leaders of the group company, and made specific arrangements and deployments for the financial work involved in the audit.

3, financial audit and supervision positions

In order to strengthen the audit and supervision function of the group company's financial work, we recruited four experienced financial personnel who have been engaged in financial work for many years this year to enrich and strengthen the positions of financial audit, audit and financial management. The work responsibilities and categories of the four comrades were clarified, and it was required to revise and improve the responsibility system and assessment methods of various financial positions in this department as soon as possible, so as to lay a solid foundation for improving the quality and efficiency of financial work.

4. Formulated and studied the assessment method of post responsibility system in financial audit department.

In order to better perform the duties entrusted by the general manager, strengthen the financial management and audit inspection of the (group) company, standardize the financial order of the group, and mobilize the enthusiasm and sense of responsibility of the majority of financial personnel, the Financial Audit Department has specially formulated the Assessment Methods for the Post Responsibility System of the Financial Audit Department. Through careful study and discussion, everyone actively thought and agreed to perform their duties in strict accordance with the target assessment method.

Second, the financial work

1. Enhance the awareness of financial services. In 20 19, we will, as always, strengthen financial management, optimize the allocation of resources and improve the efficiency of fund use in accordance with the principle of "scientific, strict, standardized, transparent and efficient", and make the work clothes of group companies an important task of our department.

2. Strengthen financial management.

According to the requirements of the group company to standardize financial management, optimize financial audit procedures, improve the quality of financial services, and give full play to the participation of functional departments in enterprise management, the financial audit department adjusted the centralized financial management to a trial appointment system for financial personnel, and adopted the principle of "unified management and graded responsibility" for management. The financial audit department is mainly responsible for the financial supervision, financial analysis and financial report of various assets of the group company, the financial management of branches and subsidiaries, and the audit of financial internal accounting vouchers. , give full play to the functions of the financial audit department.

3. Budget management has been steadily advanced.

The first is to refine the budget content. According to the subsidiary ledger of each branch and subsidiary, analyze the implementation of income, cost and period expenses in detail, and make statistics by subject classification, so as to lay the foundation for the comprehensive budget of each branch and subsidiary in 20 19; The second is to improve budget transparency. After the budget plan is properly adjusted according to the feedback from the branches and subsidiaries, it will be examined and approved by the general manager, and then a formal document will be issued to the branches and subsidiaries, so that all units can have a comprehensive understanding of the company's budget and enhance the transparency of the budget; The third is to increase the rigidity of the budget. Pay attention to the problems existing in budget implementation and related situations, feed back the situation to the Budget Committee from time to time, strictly examine and approve the problems such as over-budget, and carry out special demonstration and analysis on the matters applying for adjustment according to the prescribed procedures before implementation. Over the past year, the overall implementation of the budget has been good, and the budget concepts of branches and subsidiaries have been greatly improved and strengthened, which has accumulated experience for doing a good job in the comprehensive budget for 20 19.

4. Vigorously rectify the financial order.

According to the work arrangement of special rectification of the financial order of the Municipal Bureau (company) and the work plan of self-inspection of financial revenue and expenditure, the Group Company focuses on the working idea of "standardizing the business behavior of the industry, promoting the healthy development of the tobacco industry, and creating and accumulating wealth for the country", and takes "finding out the family background, revealing hidden dangers, promoting standardization and promoting development" as the guiding ideology, and strictly follows the requirements of the Municipal Bureau (company) for self-inspection. From top to bottom, the financial audit department has made a self-examination on "off-balance-sheet accounts", "small treasury" and imaginary (chaotic) column costs, income distribution distortion, accounting distortion and other issues, and implemented the combination of strengthening economic responsibility audit and strengthening financial and economic order rectification. According to the principle of "improving while improving", the problems identified are classified according to time and nature, and the loopholes in management are found. Through this self-inspection, the supervision of state-owned assets has been effectively strengthened.

5. Strengthen the role of fund management.

In order to standardize the economic operation order of xx Group, strengthen the fund management of branches and subsidiaries, reduce and eliminate the risk of fund use, improve the efficiency of fund use and promote the healthy development of the Group. The group company brought the fund management center of the group company into the unified management of the settlement center of the municipal bureau (company) from 20 19 10. In order to ensure that the Group's fund management center can enter the settlement center of the municipal bureau (company) smoothly and in time, according to the requirements of the settlement center of the municipal bureau (company), we have carefully and strictly audited and compiled the annual and monthly capital revenue and expenditure budgets, management expense budgets, operating expenses and financial expenses of all branches and subsidiaries. At the same time, in order to ensure the orderly development of all work, it is emphasized that all branches and subsidiaries should intensify the collection of payment for goods to ensure the normal economic operation of the group company.

In order to give full play to financial functions, we have strengthened the standardization of basic accounting work, improved the quality of accounting information, and ensured the truthfulness, accuracy and completeness of accounting information. Strengthen the functions of financial forecasting, analysis and fund raising, strengthen the management of major investment funds, and provide effective and timely data and technical support for leadership decision-making.

Please pay attention to our present situation and the company's situation, and make full preparations for the company's great development in the coming year. The performance and market of our company decide that we will do a big job in the coming year, so we must work hard!

20 19 summary of the annual work of bank audit (iv) 20 18 X is a transitional period for me to enter the society from school. After the hurried training of the head office, I devoted myself to the cause of the Postal Savings Bank with confidence and enthusiasm. At the beginning of my career, I was assigned to the position of front desk teller. I spent the first half of my career here, busy in the warm family of the sales department. I learned a lot of business knowledge and truth. It's like my home is warm and sweet and my brothers and sisters are warm and energetic. We work together for the same goal. I think I will spend 1 2 years here to learn and experience, to grow and improve. I always remember our headmaster's long-winded words on the first day of employment, "I have accumulated a lot, but I have made little progress". At that time, I was at the front desk with peace of mind, studying modestly and working hard. But in June 1 1, 2065438, I received a notice of personnel change and asked me to report to the audit department. I was really at a loss. Auditing has always been a mysterious profession for me, and I have always been a little scared from the bottom of my heart. I thought and thought. On the one hand, I believe this is a well-thought-out decision of the bank leaders, and there must be a reason for this arrangement, which is also the trust of the bank leaders in me; On the other hand, from the perspective of my own long-term development, auditing can make me learn and absorb more. Since then, I have embarked on the path of auditors.

When I first entered the audit department, I was deeply at a loss and frustrated. My own understanding of personal savings business is far from enough. As an internal auditor, the necessary prerequisite is to be proficient in various businesses handled by banks, and then to control internal risks. Fortunately, the colleagues in the audit department are not as mysterious and daunting as I thought before, but warm and amiable. At first, I went to the countryside to study with them, and when I returned to the department, I began to learn various business systems and internal control links. Every time I encounter something I don't understand, I will take the initiative to ask my colleagues in the department, and my colleagues will explain it patiently and meticulously. With the enthusiastic help of my colleagues and my efforts, I began to participate in the audit work in a week or so. Although at the beginning, speed is often the foundation of team progress, there are even some problems in some places. My colleagues in the same team always wait patiently and correct me politely. It is under such circumstances that I began to grow up bit by bit.

So far, I have grown into a qualified employee in the audit front of our branch, and I can independently undertake an audit work and write a true and accurate audit report. In the past six months, we have conducted a routine audit on the credit department, corporate business department, accounting cashier and two tier-one outlets of the branch once a month, and carried out several special audits according to the requirements put forward by superiors, so as to find out hidden problems in time and put forward rectification suggestions to escort the huge ship of branch business development. At the same time, I also regularly audit the second-class postal outlets and agency outlets every quarter. I am responsible for issuing audit opinions to the inspection office of the county post office every week, reporting the problems existing in the postal outlets to the postal leaders in time, and putting forward reasonable rectification opinions.

The work of the Audit Department has no outstanding business data and no real achievements. We silently pay for the branch, the only purpose is to avoid financial cases and ensure the safety of corporate funds. At the same time, very few people do not understand our work, pay insufficient attention to the problems existing in the inspection, and fail to make timely rectification as required. In the process of inspection, some problems are repeated, which not only increases our workload, but also makes us very worried. For example, some postal outlets do not close the tail door. Every time we ask this question, they always have a lot of reasons. It is not because employees' own arbitrariness and laziness form habits and put habits above the system. Not long ago, there was a murder and robbery at a postal outlet in Gansu Province. The most fundamental point is that the salesperson did not implement the system himself and left the tailgate open, which allowed vicious opportunities to take advantage of it. I hope that through this matter, the employees of our outlets will learn from this painful experience. There are still many problems that similar habits override the system. For example, the handover procedures are not strictly performed during the shift change, the system of two locks and one sign is not implemented when leaving the cabinet temporarily, the phenomenon of single person coming to the cabinet, the mutual transaction system is not implemented at the end of the day, and the insurance certificate is not strictly regarded as cash custody. These are potential huge hidden dangers, and the root of these problems lies only in the teller's own habits and sense of responsibility. I suggest that we should strengthen the evaluation of these aspects to eliminate the root cause of severe pain with mild pain.

For the current audit work, I think we are still in the audit stage and have not really met the needs of internal audit. With the continuous development of our bank, I think it is inevitable to change from audit to internal audit. At the same time, the challenges we face will be more and more enormous, and the requirements for our own quality will be higher and higher. Over the past six months, I have participated in a lot of training on audit work, and the audit system on the audit line is constantly being introduced. Electronic audit system, credit audit system and employee violation points system have been launched one after another, and now a brand-new audit system will be launched soon. Working methods are constantly changing. The knowledge we have learned is not limited to the system. The application of the new system and new working methods are all brand-new challenges for us. Only by continuous learning can we adapt to the escalating work style, otherwise we will be eliminated. Only by not being complacent, studying hard and innovating, and constantly trying to sum up, can we maintain the freshness and vitality of audit work. Audit has opened a window for me to challenge, whether to build a car behind closed doors or go out bravely, there is no need to answer. This half year is the summary of work and the beginning of facing new challenges. I understand that I still have many shortcomings, such as incomplete theoretical knowledge and lack of interpersonal skills, which are all difficult problems that I need to solve urgently at present. For this reason, I made a study plan for myself and spent 2 hours every day to supplement my shortcomings in these areas. I also know that I don't lack the initiative to take risks and learn. What I lack is patience and perseverance. My biggest enemy will always be myself, and I firmly believe that I can overcome myself. Half a year's work is over, and the new work has just begun. Every day is a new challenge. I am confident that I will do better in the future audit work.

20 19 summary of the annual work of bank audit (5) It is the second year that I entered xx Bank in a blink of an eye. Two years is neither long nor short. Time has given me a deeper understanding of xx Bank, and also helped me to improve my business skills through my own study, leadership and colleagues' education, so that I can be more competent in my previous and ongoing work.

In the last year, as an employee of xx Bank, I personally experienced the great changes in our daily work and life brought by the share reform of xx Bank, such as the introduction of concepts such as economic added value and key performance appraisal indicators, which really changed the business philosophy of the division from focusing only on quantity expansion to focusing on quality improvement, and the resulting significant changes in post division and income distribution. The promulgation of various rules and regulations has put forward many more clear and detailed requirements for our xx Bank to "standardize its operation". Pay attention to detail management and meticulous management in the work, and have more preventive and disciplinary measures for illegal acts. In particular, the "special rectification activities for violations of laws and regulations" carried out in the bank once again sounded the alarm for us-the work should be not only "good" and "fast", but also "legal". At the end of the year, I signed up and was lucky enough to be transferred to the approval team of xx as a compliance review post.

From the personal loan comprehensive post in the wealth management center of the branch to the supervision and review post of the approval portfolio, corporate credit and personal large credit business are the main businesses, and this span is not small. However, with the educational care of leaders, the help and guidance of colleagues and my personal self-study efforts, I quickly overcame my initial inadaptability, and quickly integrated into my current post role by reading relevant books and interpreting documents and regulations. From the beginning of 20 19 to the end of 20 19, I completed the compliance review of 109 corporate loans and 3 corporate credit businesses, with a total amount of 474,352,624 yuan; Completed 67 corporate credit rating compliance reviews, including 29 aa, 34 A and 4 bbb; Received 332 personal loans, submitted for review and issued decision-making opinions, with a total amount of 64,634,750 yuan. Satisfied the task requirements of this position.

The examination and approval team of xx belongs to the examination and approval department of the Bank, and faces all business departments of the Bank, accepting and approving all kinds of credit businesses submitted by the credit business department of xx Bank. Therefore, establishing the concept of internal customers, taking the operation department as the customer we serve, and providing customers with high-quality, efficient and standardized services are the most basic requirements for me as an auditor of portfolio supervision. In daily business, I always try my best to help the business department, patiently answer their questions about approval, and often communicate with them through various compliant and effective channels to understand the actual situation and problems of the business department, report to the leaders and special auditors in time, try my best to help solve the contradiction between approval and operation caused by information asymmetry, provide a basis for effective decision-making between the leaders and special auditors, and realize the interests of xx Bank.

The examination and approval team of xx is a busy department with heavy daily workload. How to improve work efficiency and better fulfill work requirements is a problem that I often think about. At work, I find that a lot of working time is consumed in some relatively mechanical simple repetitive work. For example, in compliance audit, the calculation of some financial indicators of reporting units is relatively simple, but compliance auditors need to spend a lot of time and energy to check multiple financial indicators of multiple units. Through self-study, I compiled a table by using the formulas and functions in our commonly used execl spreadsheet software. I only need to fill in the relevant data in the balance sheet and cash flow statement of the enterprise, and the corresponding financial indicators such as asset-liability ratio, current ratio, quick ratio, profit rate, principal and interest guarantee multiple, mortgage rate and guarantee rate can be automatically calculated and generated, which greatly facilitates the work and improves the efficiency.