[go: up one dir, main page]

CN107492032A - A kind of business financial auditing reports management system and its database platform - Google Patents

A kind of business financial auditing reports management system and its database platform Download PDF

Info

Publication number
CN107492032A
CN107492032A CN201710837617.2A CN201710837617A CN107492032A CN 107492032 A CN107492032 A CN 107492032A CN 201710837617 A CN201710837617 A CN 201710837617A CN 107492032 A CN107492032 A CN 107492032A
Authority
CN
China
Prior art keywords
audit
financial
report
data
financial audit
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201710837617.2A
Other languages
Chinese (zh)
Inventor
杨红梅
杨冬梅
郭静
兀晓琦
霍焱
张茜
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fa Technology (guizhou) Co Ltd
Original Assignee
Fa Technology (guizhou) Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Fa Technology (guizhou) Co Ltd filed Critical Fa Technology (guizhou) Co Ltd
Priority to CN201710837617.2A priority Critical patent/CN107492032A/en
Publication of CN107492032A publication Critical patent/CN107492032A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Health & Medical Sciences (AREA)
  • General Engineering & Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The present invention relates to a kind of quickly financial audit reporting system, with reference to the use of EXCEL and WORD documents, general information in financial audit report and audit statement is integrated, accomplish directly to quote using embedded program, reduce the calculating of financial audit Report workout and the workload of editor, mistake during reducing the staff occurs, and improves the establishment efficiency and quality of financial audit report.Meanwhile by by the system networking, being developed into the network data base of financial audit management, can help to work out to form formal financial audit report, management organization for mandate, the enterprise customer authorized inquire about and used.The reliability of financial audit report and data is ensured, so as to preferably directly effectively realize the monitoring of the financial audit data to unit of auditing.

Description

A kind of business financial auditing reports management system and its database platform
Technical field
This patent is related to the exploitation design of the establishment database of financial audit report, there is provided a kind of finance of simple and fast Audit Report workout system and cloud management platform, management organization is helped directly effectively to be monitored to the financial data of enterprise.
Background technology
Financial audit is usually that the production operation situation that year is carried out to enterprise is comprehensively audited from fiscal perspective, is carried For objective reliable financial information data.
Establishment financial audit report first has to check whether all kinds of forms are formulated and submitted complete, read over print-out specification, pay attention to Financial situation, management performance and the fund variation statement of the accounting period of form reflection and the analysis pair of other accounting periods Than whether relevant significant impact factor is disclosed, and to combine the audit of form content, and whether checking explanatory note explanation is true It is real.Main points of auditing are as follows.
The audit of balance sheet.
Focus on checking that correctness, the integrality of report item and the form of balance sheet preparation method reflect project With the consistency of content.
Check whether balance sheet is worked out according to subject as defined in accounting system and form, between double calculation form items Articulation.
Current balance sheet projects are digital compared with previous phase or each phase, identify whether or not and change larger or abnormal feelings Condition;Meanwhile the Articulation of balance sheet and other forms is checked, and carry out double calculation verification.
Whether comprehensive verification of assets debt table entry is consistent with ledger accounts or relevant detailed account numeral, with the current period of ledgers Amount and remaining sum classification section purpose current period amount each with its affiliated detailed account and remaining sum sum are mutually checked, check account and account it Between record whether be consistent.
Auditor is in above-mentioned inspection it should be particularly noted that through com-parison and analysis, if there is number and the enterprise of some projects The situation that production and operating activities are not consistent is traced to original certificate it is necessary to make emphasis inspection to these projects from ledger accounts, must It should be combined when wanting to the confirmation of nostro-nostro account, the item assets such as stock and fixed assets are made an inventory, examine the authenticity of form numeral.
The audit of profit and loss statement.
Check profit and loss statement in projects list it is whether complete, whether there is fail to fill in, mistake is filled out, check projects numeral between hook check Relation.
The Articulation of profit and loss statement and other forms is checked, pays special attention to check product sales revenue listed by profit and loss statement, production Number occurs for product selling cost, production payment loan and sales tax and additional this year, if, profit and loss statement consistent with its subordinate list number Whether listed net profit is consistent with statement of profit distribution numeral.
Whether verification profit and loss statement projects numeral is consistent to related ledgers, detailed account numeral, while is checked by analyzing, It was found that whether the change about profit and loss project numeral is abnormal, and doubtful point is made further to check.
With reference to the inspection about detailed account such as cost, income from sales, profit distribution, cost, items are examined Whether the item of digital such as income, investment return and non operating revenue and expenditure are accurate, to check relevant original certificate if necessary.
With reference to the inspection to tax-payment adjustment, whether correct, carry out detailed survey to each deduction, examine if examining the calculating of income tax Relevant detailed account and original certificate are looked into, pays attention to whetheing there is multiple row deduction or the problems such as amount deducted is above standard.
The audit of cash flow statement.
Check whether cash flow statement is worked out according to the regulation about the specific criterion of enterprise accounting.
Check determining whether appropriately for cash equivalents.
Whether the calculating of cash inflow discharge is complete, accurate in inspection business operation, investment activity and financial activity Really, whether the record with relevant accounting data and form is consistent.
Check whether the influence for being computed correctly exchange rate fluctuation to foreign currency cash flow.
Inspection is not related to current cash receipts and payments but the great throwing being had an impact to financial position of the enterprise or future cash flow Whether money activity, financial activity (such as with long-term investment, paying one's debts) are illustrated in cash flow statement note.
The audit of consolidated accounts.
Check the basis of consolidated accounts establishment.Audit:Comprehensive, the integrality of consolidated accounts content;Subsidiary provides money Material integrality (including subsidiary company accounting Policy Difference, parent company and subsidiary company's transaction, credit and debt, investment data, subsidiary profit Profit distribution, equity change data);Parent company and subsidiary company's closing day and the uniformity of accounting period;Accounting policy between parent company and subsidiary company Uniformity;The correctness of accounting processing of the parent company to investment in subsidiary.
Check and confirm consolidated accounts scope.According to the long-term investment account of parent company and show to throw between parent company and subsidiary Money and the enterprise for by the approval documents of investment relation, really belonging to consolidation scope., for the subsidiary that should merge and not merge Find out that why planting reason is not included consolidation scope;For the enterprise that should not merge and be merged, parent company is found out Situations such as with the presence or absence of (transfer) share is purchased without approval.
Check business group internal economic interaction situation.I.e. whether the data for the relevant economic interaction that inspection parent company provides Completely, and by checking the payment relation of consolidated accounts, the authenticity of consolidated accounts is verified.
1. check whether processing of the parent company to investment in subsidiary's income is provided to carry out core using equity method by accounting system Calculate, whether minority interest correctly reflects.Parent company is public to the number and son of subsidiary's equity share capital investment project Whether the share that parent company is held in department's owner's equity offsets.
2. the situation of repealing by implication of the credit and debt occurred between inspection subsidiary and parent company and between subsidiary.Root According to relevant information, examine credit and debt whether necessary being;Check parent company whether by program and provide will check consistent debt Power debt is offseted, and the situation inconsistent to credit and debt is checked item by item, it is determined that how much answering no payment and payment;Check internal Account receivable counts whether the provision for bad debts carried is offseted with administration fee, and whether amount of the offset is correct.
3. check whether repealing by implication for unrealized internal sales profit be correct.Taken out on the basis of firsthand information is checked Part offset entry is looked into, supports the internal sales between female, subsidiary and subsidiary and unrealized profits to investigate parent company The correctness and authenticity of pin.
Whether examination of auditor group company works out complete payment accounting entry, is recorded separately with defined payment program composition Tested, see with the presence or absence of collected and do not work out offset entry and offset entry establishment it is incorrect the problems such as.
Reliable independent Audit Report is provided in establishment on the basis of audit calculating is carried out to above-mentioned form, and by above-mentioned report Annex of the content of table as Audit Report.
Financially audit in the compilation process of report, typically first carry out the audit of items, take passages the critical data for needing to examine. Calculated in audit statement.Finally it is aggregated to form Audit Report.In above process, substantial amounts of financial data is plucked repeatedly Record is quoted, and amount of calculation is big, and documents editing task is heavy.For this reason, it is necessary to the associated working work(using MS-OFFICE The synchro edit of relevant information in financial audit report can be realized, reduces workload, while improving financial audit report quality, Ensure the uniformity about financial data.
Furthermore report such discipline inspection commission important monitoring information for financial audit, enterprise can specifically be needed according to it into Row adjustment so that the monitoring according to financial audit report is not true and reliable enough.Also it is necessary to financial audit report passing through one The more true and reliable mode of kind is presented and monitored.Also just provided to report that the exploitation of network data base designs for financial audit Certain market value basis.
The content of the invention
Embedded program and work together work(of the financial audit reports management system of this patent using MS-OFFICE softwares Can, exploitation devises the work system of financial audit Report workout, reduces amount of calculation and editor's task of financial audit report, The speed and quality of financial audit Report workout are improved, reduces inconsistent, mistake probability of occurrence.
Specifically, the composition of report of financially auditing includes:(1)Enterprise's Basic Information Table, include the basic letter of enterprise Breath, as enterprise name whole process, enterprise's abbreviation, registered address, business entity, status of a legal person demonstrate,prove number, business manager, contact person, Phone, the basic object of financial audit, audit basis, audit situation collect description, audit conclusion.(2)Balance sheet; (3)Profit and loss statement;(4)Cash flow statement;(5)Consolidated accounts.Data in these forms have corresponding computation rule, according to this A little rules, with reference to applying mechanically for calculation formula, can be significantly reduced the workload manually calculated and the mistake therefore brought.This The skill of sample, except financial audit report and financial statement are unexpected, has there is many applications in financial transaction.
For the either single data in the part that amount of calculation is larger, duplicate contents are more, this financial audit report is adopted Synchro edit is realized with the paste link function of PASTE SPECIAL.Quoted for the information of routine, this financial audit Report workout System carries out Fast synchronization editor by the way of bookmark pair is inserted.
Two kinds of synchro edit functions are used in combination, while effectively raising the corresponding speed of OFFICE softwares, effectively The effective program of utilization configuration, realize the purpose that quick establishment forms financial audit report.
On the basis of the management system of above-mentioned financial audit report, design and develop as network data base, different wealth Business audit unit can rely on the database to work out Audit Report.Meanwhile regulator, manager's representative can be single according to audit Position or the mandate of unit under auditing, inquire all previous financial audit report and financial data information.
Embodiment.
The financial audit Report workout and management system of simple and fast.
1st, financial audit Report workout and the composition of management system.
The financial audit Report workout system of the simple and fast of this patent have identical file press from both sides a following EXCEL and One WORD documents composition, EXCEL is by 5 tables(SHEETS)Composition, it is respectively:(1)Enterprise's Basic Information Table, including enterprise Essential information, such as enterprise name whole process, enterprise's abbreviation, registered address, business entity, status of a legal person card number, business manager, connection It is people, phone, the basic object of financial audit, audit basis, audit situation collect description, audit conclusion.(2)Asset-liabilities Table;(3)Profit and loss statement;(4)Cash flow statement;(5)Consolidated accounts.What a certain partial audit of enterprise did not designed, the form can be with Do not enable, but enabled in the lump in Report workout system of financially auditing.Main audit project is carried out according to financial service condition Order arrangement, the identical information inside Microsoft Excel synchronizes editor by the way of EXCEL formula.
2nd, the realization for Report workout and the management system operating mechanism of financially auditing.
The system carries out the establishment of financial audit report using the report template of WORD forms, and Audit Report is using routine Financial audit report is used as template framework, by by the essential information of audit enterprise, financial audit purpose, audit basis, audit feelings Condition collect description, audit conclusion is handled as the content of synchro edit, the mode of processing:Select database work form Corresponding form, carry out duplication paste operation.Then pasted, glued in the appropriate section of the Audit Report text of word forms The operating method of patch is:Editor>PASTE SPECIAL>Paste link>Unformatted text.So enter in EXCEL editings are thin During edlin, then opening word document synchronizes renewal can and realizes synchro edit.
During the financial audit report of the system establishment WORD forms, the form portion in conventional financial audit report template Divide, including the content of four table sections such as balance sheet, profit and loss statement, cash flow statement, consolidated accounts uses bookmark editor Mode carry out ECXCEL programmings.Its processing mode has three steps:First, the relevant position in WORD templates establishes above-mentioned 4 Individual label.Second foundation is the embedded program of the system, and synchro edit is realized by program.3rd step is to above table Content carries out audit verification item by item, and after confirmation, the embedded program can of runtime realizes the audit to WORD templates Report and outputed into edlin.
3rd, the exploitation and mandate of financial audit Report workout and management network data base.
, will according to the composition situation of standalone version financial audit database table(1)Enterprise's Basic Information Table,(2)Assets are born Debt table;(3)Profit and loss statement;(4)Cash flow statement;(5)Various pieces information in consolidated accounts etc. is independent, unified to form one Group data.Information plus audit unit and necessary user profile in addition, with the mould put for financial audit Report workout Plate file, form the network data base of financial audit management.
Specifically, the information included is needed to include in database:Audit enterprise and the essential information by audit enterprise, Such as enterprise name whole process, enterprise's abbreviation, registered address, business entity, status of a legal person card number, business manager, contact person, electricity Words, the basic object of financial audit, audit basis, audit situation collect the wealth inquired about in description, audit conclusion, audit process Business document and specific fund income and expenses.
For the management and inquiry with data of financially auditing, can by the mandate of audit unit or unit under auditing, with The form of Audit data or Audit Report is consulted or downloaded to the data of financial audit, can also be limited to some finance The access of data..

Claims (3)

1. a kind of calculating for combining tabular database data and the quick financial audit reporting system of WORD report files, quickly Establishment financial audit report, reduce account calculating, the workload of financial data establishment of financial audit process, it is characterised in that logical Cross and data form and WORD template functions are joined together using embedded program selectivity so that the table during financial audit The data of lattice database calculate and the financial data synchro edit of Audit Report, and the mistake during reducing the staff occurs, and carries The establishment efficiency and quality of height financial audit report.
2. pressing claim 1, the system application embedded program of this patent employs table database and makes a report on relevant financial audit data During establishment financial audit report, the template function of WORD documentations has been used, has been inserted in the bookmark location of word report templates Related typing Audit data and company information form financial audit report.
3. press claim 1, the database of the financial audit management system of network data base according to audit unit or can be examined The mandate of unit is counted, carries out the inquiry of financial audit data or Audit Report, it is ensured that the reliability of financial audit report and data.
CN201710837617.2A 2017-09-18 2017-09-18 A kind of business financial auditing reports management system and its database platform Pending CN107492032A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710837617.2A CN107492032A (en) 2017-09-18 2017-09-18 A kind of business financial auditing reports management system and its database platform

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710837617.2A CN107492032A (en) 2017-09-18 2017-09-18 A kind of business financial auditing reports management system and its database platform

Publications (1)

Publication Number Publication Date
CN107492032A true CN107492032A (en) 2017-12-19

Family

ID=60651905

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710837617.2A Pending CN107492032A (en) 2017-09-18 2017-09-18 A kind of business financial auditing reports management system and its database platform

Country Status (1)

Country Link
CN (1) CN107492032A (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108959349A (en) * 2018-04-23 2018-12-07 厦门快商通信息技术有限公司 A kind of financial audit circular for confirmation system
CN110070426A (en) * 2019-04-26 2019-07-30 四川志林信息技术有限公司 A kind of Audit Report generation method
CN110389990A (en) * 2019-07-25 2019-10-29 齐鲁工业大学 A comprehensive financial audit system based on big data
CN112200647A (en) * 2020-10-12 2021-01-08 广州智慧金财税科技有限公司 Audit quality determination method and system
TWI720761B (en) * 2019-12-25 2021-03-01 帳聯網路科技股份有限公司 Trading system for integrating stock transferring and tax filing and method thereof
CN113449499A (en) * 2021-08-31 2021-09-28 深圳市永兴元科技股份有限公司 Off-site data management method, device, equipment and storage medium
CN113553360A (en) * 2021-07-30 2021-10-26 北京金堤征信服务有限公司 Multi-enterprise relationship analysis method, apparatus, electronic device, storage medium and computer program
TWI811004B (en) * 2022-06-20 2023-08-01 大陸商鼎捷軟件股份有限公司 System and method for automatically checking finance
CN117371411A (en) * 2023-10-25 2024-01-09 中亿丰控股集团有限公司 Financial statement merging method, system, equipment and storage medium
CN119515583A (en) * 2025-01-15 2025-02-25 北京北方科诚信息技术股份有限公司 Decentralized financial statement system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102355461A (en) * 2011-09-29 2012-02-15 广州中浩控制技术有限公司 XBRL (Extensible Business Reporting Language) credible data storage method and credible data storage system
US20130185557A1 (en) * 2012-01-13 2013-07-18 Microsoft Corporation Detection of Invalid Escrow Keys
CN107145480A (en) * 2017-05-26 2017-09-08 上交所技术有限责任公司 A kind of method that XBRL Report workouts are carried out based on Word

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102355461A (en) * 2011-09-29 2012-02-15 广州中浩控制技术有限公司 XBRL (Extensible Business Reporting Language) credible data storage method and credible data storage system
US20130185557A1 (en) * 2012-01-13 2013-07-18 Microsoft Corporation Detection of Invalid Escrow Keys
CN107145480A (en) * 2017-05-26 2017-09-08 上交所技术有限责任公司 A kind of method that XBRL Report workouts are carried out based on Word

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
王广亚: "《执掌企业 理论、实践与省悟》", 31 January 2017 *

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108959349A (en) * 2018-04-23 2018-12-07 厦门快商通信息技术有限公司 A kind of financial audit circular for confirmation system
CN110070426A (en) * 2019-04-26 2019-07-30 四川志林信息技术有限公司 A kind of Audit Report generation method
CN110389990A (en) * 2019-07-25 2019-10-29 齐鲁工业大学 A comprehensive financial audit system based on big data
TWI720761B (en) * 2019-12-25 2021-03-01 帳聯網路科技股份有限公司 Trading system for integrating stock transferring and tax filing and method thereof
CN112200647A (en) * 2020-10-12 2021-01-08 广州智慧金财税科技有限公司 Audit quality determination method and system
CN113553360A (en) * 2021-07-30 2021-10-26 北京金堤征信服务有限公司 Multi-enterprise relationship analysis method, apparatus, electronic device, storage medium and computer program
CN113449499A (en) * 2021-08-31 2021-09-28 深圳市永兴元科技股份有限公司 Off-site data management method, device, equipment and storage medium
TWI811004B (en) * 2022-06-20 2023-08-01 大陸商鼎捷軟件股份有限公司 System and method for automatically checking finance
CN117371411A (en) * 2023-10-25 2024-01-09 中亿丰控股集团有限公司 Financial statement merging method, system, equipment and storage medium
CN117371411B (en) * 2023-10-25 2024-09-13 中亿丰控股集团有限公司 Financial statement merging method, system, equipment and storage medium
CN119515583A (en) * 2025-01-15 2025-02-25 北京北方科诚信息技术股份有限公司 Decentralized financial statement system

Similar Documents

Publication Publication Date Title
CN107492032A (en) A kind of business financial auditing reports management system and its database platform
US7418424B2 (en) Trade finance automation system
CN112700149A (en) Investment portfolio risk assessment system, method and computer equipment
CN106339940A (en) A method for detecting financial acquisition values and calculating a credit line
Rewczuk et al. Determinants of audit fees: Evidence from Poland
CN115099914B (en) A financial business accounting system and equipment based on NCC architecture
Qadri STORYTELLING CASE STUDY: HOW TO WIN A TAX DISPUTE AGAINST TAX AUTHORITY?
Murtezaj et al. The Study and Application of Moral Principles and Values in The Fields of Accounting and Auditing
CN112785271B (en) Method for managing cash flow of engineering project in full cycle
CN113807625A (en) Method for grading credit of electronic commerce enterprise main body
Vezenkoska et al. Internal audit of financial operations
Brown et al. Empirical evidence on put-call parity in Australia: a reconciliation and further evidence
KR102742455B1 (en) Future receivables securitization platform system using ai revenue forecasting analysis and operation method using the system
CN119762230A (en) A bond portfolio management method for corporate financing
Oroh et al. Evaluation of The Implementation of Psak 71 Concerning Expected Credit Loss on The Consolidated Financial Statements of The Company PT Waskita Karya (Persero) Tbk
Yeong et al. Financial reporting risks in relation to financial instruments
ARSLAN Principles for presentation of intangible fixed assets in financial reports within the scope of tas-38
JP2003150766A (en) Credit rating method, its device, recording medium, and program
Kuatov Accounting and auditing of short-term assets of the organization
Arslan Maddi Olmayan Duran Varlıkların TMS-38 Kapsamında Finansal Raporlarda Sunum İlkeleri
Patel Discover SAP ERP Financials
Doshi Financial Statements for Lawyers: Understanding the Basics
Deaconu et al. Realities And Accounting Perspectives In Romania Regarding The Production Of Furniture
CN118096210A (en) Financial company pricing method and device
CN119494734A (en) Data processing method and device, storage medium and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20171219

WD01 Invention patent application deemed withdrawn after publication