CN112101911A - Method and device for generating accounting entry - Google Patents

Method and device for generating accounting entry Download PDF

Info

Publication number
CN112101911A
CN112101911A CN202011000502.6A CN202011000502A CN112101911A CN 112101911 A CN112101911 A CN 112101911A CN 202011000502 A CN202011000502 A CN 202011000502A CN 112101911 A CN112101911 A CN 112101911A
Authority
CN
China
Prior art keywords
accounting
entry
transaction
data
generating
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.)
Withdrawn
Application number
CN202011000502.6A
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.)
Accumulus Technologies Tianjin Co Ltd
Original Assignee
Accumulus Technologies Tianjin 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 Accumulus Technologies Tianjin Co Ltd filed Critical Accumulus Technologies Tianjin Co Ltd
Priority to CN202011000502.6A priority Critical patent/CN112101911A/en
Publication of CN112101911A publication Critical patent/CN112101911A/en
Withdrawn legal-status Critical Current

Links

Images

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
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • 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

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Human Resources & Organizations (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Data Mining & Analysis (AREA)
  • Operations Research (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention provides a method and a device for generating an accounting entry, wherein the method comprises the following steps: reading target cash running water data in a database; matching the target cash flow data with a stored entry configuration rule to obtain a matched entry configuration rule; generating corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule; performing difference checking on the accounting entry data; and outputting the accounting entry data after the difference checking. The problem of by the conversion mapping process of cash transaction data to accounting entry, need rely on manual input's mode record, efficiency is very low and take place the mistake easily and lack the check-up process to the entry, highly rely on artifical check-up operation, waste time and energy, the closed loop is not enough to the flow is solved.

Description

Method and device for generating accounting entry
Technical Field
The invention relates to the field of data processing, in particular to a method and a device for generating an accounting entry.
Background
Financial work is one of the most important parts in enterprise management, and in normative financial work, all transaction cash flows finally need to record financial accounts according to professional accounting modes, such as compound accounting. To improve efficiency, most companies now put financial accounting work into computers and use professional financial management software for accounting management. The most important point in the account management is the maintenance of accounting documents and accounting entries, and the economic business can be clearly and accurately classified and analyzed according to the maintained documents and entries, so that the financial value is very high. The existing financial management software still has the defects that the conversion mapping process from cash transaction data to accounting entries is lacked, manual input is needed for recording, the efficiency is very low, errors are easy to occur, and once errors occur, the financial audit work of a company is greatly influenced; some methods and systems for automatically generating accounting entries exist in the market at present, but the methods and systems also need to perform natural language conversion on the flow of transactions, perform classification training to obtain accounting subject information, and prolong the time period for inputting accounting accounts; the existing accounting entry generation process at present lacks the check-up process to the entry, highly relies on artifical check-up operation, wastes time and energy, and the flow is closed loop inadequately.
Disclosure of Invention
The invention provides a method and a device for generating an accounting entry, which are used for solving the problems of automatic generation of the accounting entry and verification of the accounting entry in cash transaction pipelining.
In order to achieve the above-mentioned problems, the present invention is realized by:
in a first aspect, the present invention provides a method for generating an accounting entry, including:
reading target cash running water data in a database;
matching the target cash flow data with a stored entry configuration rule to obtain a matched entry configuration rule;
generating corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule;
performing difference checking on the accounting entry data;
and outputting the accounting entry data after the difference checking.
Optionally, before matching the cash flow data with the stored entry configuration rule, the method further includes: and acquiring and storing the recorded entry configuration rule.
Optionally, the entry configuration rule includes at least one of the following: the transaction type, accounting subject, accounting voucher serial number, transaction direction, transaction party, amount calculation mode and summary information of both transaction parties.
Optionally, the cash flow data includes at least one of: information of both parties of the transaction, transaction amount of both parties of the transaction, transaction type, transaction bank number and cash running serial number.
Optionally, the performing difference checking on the accounting entry data includes:
reading cash flow data in a database, summarizing transaction types of both transaction parties, and acquiring corresponding transaction amount;
summarizing the accounting subjects of both transaction parties in the accounting entry data, and acquiring corresponding transaction amount;
comparing the transaction amount corresponding to the target transaction type in the cash flow data with the transaction amount corresponding to the target accounting subject in the accounting entry data;
and determining final accounting entry data according to the comparison result.
In a second aspect, the present invention provides an apparatus for generating an accounting entry, including:
the flow reading module is used for reading target cash flow data in the database;
the first processing module is used for matching the target cash flow data with stored entry configuration rules to obtain matched entry configuration rules;
the generation entry module is used for generating corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule;
the difference checking module is used for performing difference checking on the accounting entry data;
and the output module is used for outputting the accounting entry data after the difference checking.
Optionally, the second processing module is configured to obtain and store the entered entry configuration rule.
Optionally, the difference checking module includes:
the first processing submodule is used for reading cash running water data in the database, summarizing transaction types of both parties of a transaction and acquiring corresponding transaction amount;
the second processing sub-module is used for summarizing the accounting subjects of both transaction parties in the accounting entry data and acquiring the corresponding transaction amount;
the third processing sub-module is used for comparing the transaction amount corresponding to the target transaction type in the cash flow data with the transaction amount corresponding to the target accounting subject in the accounting entry data;
and the fourth processing submodule is used for determining final accounting entry data according to the comparison result.
In a third aspect, an electronic device is provided, which comprises a processor, a memory and a program or instructions stored on the memory and executable on the processor, wherein the program or instructions, when executed by the processor, implement the steps of the method for generating an accounting entry according to any one of the first aspect.
In a fourth aspect, a readable storage medium is provided, on which a program or instructions are stored, which when executed by a processor implement the steps of the method of generating an accounting entry according to any one of the first aspect.
In the embodiment of the invention, the accounting entry is generated by cash transaction flow directly without intervention of financial staff, so that multiple processing of transaction data is avoided; meanwhile, the manual checking work caused by the error of the accounting entry is effectively reduced by checking the accuracy of the accounting entry.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a schematic structural diagram of a method for generating an accounting entry according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an apparatus for generating an accounting entry according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the drawings of the embodiments of the present invention. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the described embodiments of the invention, are within the scope of the invention.
Unless defined otherwise, technical or scientific terms used herein shall have the ordinary meaning as understood by one of ordinary skill in the art to which this invention belongs. The use of "first," "second," and similar terms in the present application do not denote any order, quantity, or importance, but rather the terms are used to distinguish one element from another. The terms "connected" or "coupled" and the like are not restricted to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", and the like are used merely to indicate relative positional relationships, and when the absolute position of the object being described is changed, the relative positional relationships are changed accordingly.
Referring to fig. 1, an embodiment of the present invention provides a method for generating an accounting entry, including:
step 11: reading target cash running water data in a database;
step 12: matching the target cash flow data with a stored entry configuration rule to obtain a matched entry configuration rule;
step 13: generating corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule;
step 14: performing difference checking on the accounting entry data;
step 15: and outputting the accounting entry data after the difference checking.
In the embodiment of the invention, the accounting document and the accounting entry are automatically generated by the cash flow data generated by the transaction system, and the accuracy and the integrity of the generated entry can be automatically verified, so that the follow-up financial analysis work is facilitated, the labor cost can be greatly reduced, the financial posting efficiency of a company is improved, and the error rate is reduced.
In this embodiment of the present invention, optionally, before matching the cash flow data with the stored entry configuration rule, the method further includes: and acquiring and storing the recorded entry configuration rule.
In the embodiment of the invention, the configuration of the accounting entry rule needs to be entered by financial staff in advance, and the accounting entry rule takes effect immediately after being entered; the design of the accounting entry rule needs to follow the basic principle of a double-entry accounting method, and meets the general requirements of 'necessarily having credit for borrowing and being equal to the credit for borrowing'; the format of the transaction flow is fixed and unchanged, which is different from the uncertainty of natural language, and the entry rule does not need to be maintained subsequently.
In this embodiment of the present invention, optionally, the entry configuration rule includes at least one of the following: the transaction type, accounting subject, accounting voucher serial number, transaction direction, transaction party, amount calculation mode and summary information of both transaction parties.
In this embodiment of the present invention, optionally, the cash flow data includes at least one of the following: information of both parties of the transaction, transaction amount of both parties of the transaction, transaction type, transaction bank number and cash running serial number.
In this embodiment of the present invention, optionally, the performing difference checking on the accounting entry data includes:
reading cash flow data in a database, summarizing transaction types of both transaction parties, and acquiring corresponding transaction amount;
summarizing the accounting subjects of both transaction parties in the accounting entry data, and acquiring corresponding transaction amount;
comparing the transaction amount corresponding to the target transaction type in the cash flow data with the transaction amount corresponding to the target accounting subject in the accounting entry data;
and determining final accounting entry data according to the comparison result.
In the embodiment of the invention, the accounting entry and the amount in the running water are collected according to the accounting subjects, the checking is carried out, and the accurate and error-free accounting entry is finally output.
In the embodiment of the invention, the accounting entry is generated by cash transaction flow directly without intervention of financial staff, so that multiple processing of transaction data is avoided; meanwhile, the manual checking work caused by the error of the accounting entry is effectively reduced by checking the accuracy of the accounting entry.
Referring to fig. 2, an embodiment of the present invention provides an apparatus for generating an accounting entry, including:
the flow reading module 21 is used for reading the target cash flow data in the database;
the first processing module 22 is configured to match the target cash flow data with a stored entry configuration rule, and acquire a matched entry configuration rule;
the generation entry module 23 is configured to generate corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule;
the difference checking module 24 is used for performing difference checking on the accounting entry data;
and the output module 25 is used for outputting the accounting entry data after the difference checking.
In the embodiment of the invention, the accounting document and the accounting entry are automatically generated by the cash flow data generated by the transaction system, and the accuracy and the integrity of the generated entry can be automatically verified, so that the follow-up financial analysis work is facilitated, the labor cost can be greatly reduced, the financial posting efficiency of a company is improved, and the error rate is reduced.
In the embodiment of the present invention, optionally, the second processing module is configured to obtain and store the entered entry configuration rule.
In the embodiment of the invention, the configuration of the accounting entry rule needs to be entered by financial staff in advance, and the accounting entry rule takes effect immediately after being entered; the design of the accounting entry rule needs to follow the basic principle of a double-entry accounting method, and meets the general requirements of 'necessarily having credit for borrowing and being equal to the credit for borrowing'; the format of the transaction flow is fixed and unchanged, which is different from the uncertainty of natural language, and the entry rule does not need to be maintained subsequently.
In this embodiment of the present invention, optionally, the difference checking module includes:
the first processing submodule is used for reading cash running water data in the database, summarizing transaction types of both parties of a transaction and acquiring corresponding transaction amount;
the second processing sub-module is used for summarizing the accounting subjects of both transaction parties in the accounting entry data and acquiring the corresponding transaction amount;
the third processing sub-module is used for comparing the transaction amount corresponding to the target transaction type in the cash flow data with the transaction amount corresponding to the target accounting subject in the accounting entry data;
and the fourth processing submodule is used for determining final accounting entry data according to the comparison result.
In the embodiment of the invention, the accounting entry and the amount in the running water are collected according to the accounting subjects, the checking is carried out, and the accurate and error-free accounting entry is finally output.
In the embodiment of the invention, the accounting entry is generated by cash transaction flow directly without intervention of financial staff, so that multiple processing of transaction data is avoided; meanwhile, the manual checking work caused by the error of the accounting entry is effectively reduced by checking the accuracy of the accounting entry.
Referring to fig. 3, an embodiment of the present invention further provides an electronic device 30, which includes a processor 31, a memory 32, and a program or an instruction stored in the memory 32 and executable on the processor 31, where the program or the instruction is executed by the processor 31 to implement the processes of the embodiment of the method for generating an accounting entry, and can achieve the same technical effects, and no further description is provided herein to avoid repetition.
The embodiment of the present invention further provides a readable storage medium, where a program or an instruction is stored on the readable storage medium, and when the program or the instruction is executed by a processor, the program or the instruction implements each process of the embodiment of the method for generating an accounting entry, and can achieve the same technical effect, and in order to avoid repetition, details are not repeated here.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element. Further, it should be noted that the scope of the methods and apparatus of embodiments of the present invention is not limited to performing functions in the order illustrated or discussed, but may include performing functions in a substantially simultaneous manner or in a reverse order based on the functions involved, e.g., the methods described may be performed in an order different than that described, and various steps may be added, omitted, or combined. In addition, features described with reference to certain examples may be combined in other examples.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
While the present invention has been described with reference to the embodiments shown in the drawings, the present invention is not limited to the embodiments, which are illustrative and not restrictive, and it will be apparent to those skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope of the invention as defined in the appended claims.

Claims (10)

1. A method of generating an accounting entry, comprising:
reading target cash running water data in a database;
matching the target cash flow data with a stored entry configuration rule to obtain a matched entry configuration rule;
generating corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule;
performing difference checking on the accounting entry data;
and outputting the accounting entry data after the difference checking.
2. The method of generating accounting entries of claim 1, wherein matching the cash flow data with stored entry configuration rules further comprises:
and acquiring and storing the recorded entry configuration rule.
3. The method of generating an accounting entry as claimed in claim 1,
the entry configuration rule includes at least one of: the transaction type, accounting subject, accounting voucher serial number, transaction direction, transaction party, amount calculation mode and summary information of both transaction parties.
4. The method of generating an accounting entry as claimed in claim 1,
the cash flow data includes at least one of: information of both parties of the transaction, transaction amount of both parties of the transaction, transaction type, transaction bank number and cash running serial number.
5. The method of generating an accounting entry as claimed in claim 1,
the performing difference checking on the accounting entry data comprises:
reading cash flow data in a database, summarizing transaction types of both transaction parties, and acquiring corresponding transaction amount;
summarizing the accounting subjects of both transaction parties in the accounting entry data, and acquiring corresponding transaction amount;
comparing the transaction amount corresponding to the target transaction type in the cash flow data with the transaction amount corresponding to the target accounting subject in the accounting entry data;
and determining final accounting entry data according to the comparison result.
6. An apparatus for generating accounting entries, comprising:
the flow reading module is used for reading target cash flow data in the database;
the first processing module is used for matching the target cash flow data with stored entry configuration rules to obtain matched entry configuration rules;
the generation entry module is used for generating corresponding accounting entry data according to the target cash flow data and the matched entry configuration rule;
the difference checking module is used for performing difference checking on the accounting entry data;
and the output module is used for outputting the accounting entry data after the difference checking.
7. The apparatus for generating an accounting entry as claimed in claim 6, further comprising:
and the second processing module is used for acquiring and storing the recorded entry configuration rule.
8. The apparatus for generating an accounting entry as claimed in claim 6,
the difference checking module comprises:
the first processing submodule is used for reading cash running water data in the database, summarizing transaction types of both parties of a transaction and acquiring corresponding transaction amount;
the second processing sub-module is used for summarizing the accounting subjects of both transaction parties in the accounting entry data and acquiring the corresponding transaction amount;
the third processing sub-module is used for comparing the transaction amount corresponding to the target transaction type in the cash flow data with the transaction amount corresponding to the target accounting subject in the accounting entry data;
and the fourth processing submodule is used for determining final accounting entry data according to the comparison result.
9. An electronic device comprising a processor, a memory and a program or instructions stored on the memory and executable on the processor, the program or instructions, when executed by the processor, performing the steps of the method of generating an accounting entry as claimed in any one of claims 1-5.
10. A readable storage medium, on which a program or instructions are stored, which program or instructions, when executed by a processor, carry out the steps of the method of generating an accounting entry according to any one of claims 1-5.
CN202011000502.6A 2020-09-22 2020-09-22 Method and device for generating accounting entry Withdrawn CN112101911A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011000502.6A CN112101911A (en) 2020-09-22 2020-09-22 Method and device for generating accounting entry

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011000502.6A CN112101911A (en) 2020-09-22 2020-09-22 Method and device for generating accounting entry

Publications (1)

Publication Number Publication Date
CN112101911A true CN112101911A (en) 2020-12-18

Family

ID=73754787

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011000502.6A Withdrawn CN112101911A (en) 2020-09-22 2020-09-22 Method and device for generating accounting entry

Country Status (1)

Country Link
CN (1) CN112101911A (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101710410A (en) * 2009-10-28 2010-05-19 金蝶软件(中国)有限公司 Method and system for checking accounting data
CN108764831A (en) * 2018-05-18 2018-11-06 连连银通电子支付有限公司 A kind of financial accounting method and system of real-time multi-task processing
CN108897686A (en) * 2018-06-28 2018-11-27 中国建设银行股份有限公司 It is complete to record separately automated testing method and device
CN109034988A (en) * 2018-07-26 2018-12-18 北京京东金融科技控股有限公司 A kind of accounting entry generation method and device
CN110989984A (en) * 2019-11-29 2020-04-10 中国银行股份有限公司 Data processing method, device and system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101710410A (en) * 2009-10-28 2010-05-19 金蝶软件(中国)有限公司 Method and system for checking accounting data
CN108764831A (en) * 2018-05-18 2018-11-06 连连银通电子支付有限公司 A kind of financial accounting method and system of real-time multi-task processing
CN108897686A (en) * 2018-06-28 2018-11-27 中国建设银行股份有限公司 It is complete to record separately automated testing method and device
CN109034988A (en) * 2018-07-26 2018-12-18 北京京东金融科技控股有限公司 A kind of accounting entry generation method and device
CN110989984A (en) * 2019-11-29 2020-04-10 中国银行股份有限公司 Data processing method, device and system

Similar Documents

Publication Publication Date Title
CN110263024B (en) Data processing method, terminal device and computer storage medium
CN109887153B (en) Finance and tax processing method and system
CN108985912B (en) Data reconciliation
US9037962B1 (en) Method and system for tracking and reporting data importation accuracy
US11062132B2 (en) System and method for identification of missing data elements in electronic documents
JP6680902B2 (en) Settlement processing method, settlement processing device, terminal device and storage medium
US20160042469A1 (en) System and method for financial transaction management
WO2023279039A1 (en) Ai-augmented auditing platform including techniques for applying a composable assurance integrity framework
US20140207631A1 (en) Systems and Method for Analyzing and Validating Invoices
US11042563B1 (en) Database interface system
CN111914729A (en) Voucher association method and device, computer equipment and storage medium
CN113205402A (en) Account checking method and device, electronic equipment and computer readable medium
CN111709830A (en) Credit limit determination method, device, equipment and medium
CN114187082A (en) Financial accounting and reimbursement method and system
CN115526605A (en) Enterprise internal control management-based approval method and system
CN111898611A (en) Method, device, equipment and medium for generating collection voucher combining RPA and AI
Sahu et al. Invoice processing using robotic process automation
TW202018616A (en) Intelligent accounting system and identification method for accounting documents
CN109324963B (en) Method for automatically testing profit result and terminal equipment
CN110941652A (en) Analysis method of bank flow data
CN112101911A (en) Method and device for generating accounting entry
KR101178998B1 (en) Method and System for Certificating Data
TWM615892U (en) Risk evaluation system for money laundering and financing of terrorism
CN113435986A (en) Financial data management method
CN113191875A (en) Credit granting method and device for new user, electronic equipment and storage medium

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
WW01 Invention patent application withdrawn after publication

Application publication date: 20201218

WW01 Invention patent application withdrawn after publication