CN111126966A - Bill auditing method and device, computer equipment and computer-readable storage medium - Google Patents
Bill auditing method and device, computer equipment and computer-readable storage medium Download PDFInfo
- Publication number
- CN111126966A CN111126966A CN201911352933.6A CN201911352933A CN111126966A CN 111126966 A CN111126966 A CN 111126966A CN 201911352933 A CN201911352933 A CN 201911352933A CN 111126966 A CN111126966 A CN 111126966A
- Authority
- CN
- China
- Prior art keywords
- bill
- name
- value
- target
- information
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000012550 audit Methods 0.000 claims abstract description 51
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012163 sequencing technique Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 9
- 238000004458 analytical method Methods 0.000 description 2
- 230000011218 segmentation Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a bill auditing method, a device, computer equipment and a storage medium, which are characterized in that the bill information of a bill to be audited, including a project name and bill data corresponding to the project name, is acquired, target bill data related to the project name in a database is searched, the threshold value range of the bill data corresponding to the project name is determined according to the target bill data, finally, the bill value in the bill information of the bill to be audited is compared with the threshold value, and when the bill value of the bill to be audited is in the threshold value range, the bill to be audited is determined to pass the audit. Compared with the traditional bill auditing method, the scheme provided by the application can determine whether the bill passes the auditing by comparing the bill value in the bill to be audited with the related bill value which passes the auditing, so that the bill can be audited more quickly, and the bill auditing efficiency is improved.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a bill auditing method, a bill auditing device, computer equipment and a computer readable storage medium.
Background
In enterprise management, related information of an enterprise is generally required to be checked, an important link in the information checking is to check a bill, and in the process of checking the bill, key information in the bill is generally required to be approved and checked, however, in a large-scale enterprise, the number of bills required to be checked is very large, and when the large-scale bill is checked, particularly when the business of an issuing party who issues the first invoice is checked, the required time is long and errors are easy to occur.
Therefore, the traditional bill auditing method has the defect of low efficiency.
Disclosure of Invention
Based on this, it is necessary to provide a bill auditing method, apparatus, computer device and computer-readable storage medium for solving the technical problem of low auditing efficiency in the conventional technology.
A bill auditing method comprises the following steps:
acquiring bill information of a bill to be audited; the bill information comprises a matter name, a project name corresponding to the matter name and a bill numerical value corresponding to the project name;
when the project name is in the checked project name range associated with the item name, querying a database according to the project name; the database is used for sequencing the checked project names related to the item names and storing the sequenced project names in a target project name list; the database comprises bill information of a plurality of bills which pass the examination;
when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in a database; the database comprises bill information of a plurality of bills which pass the examination;
determining a threshold range of a bill numerical value corresponding to the project name according to the target bill numerical value;
comparing the bill value in the bill information of the bill to be audited with the threshold range, and determining that the bill to be audited passes the audit when the bill value of the bill to be audited is within the threshold range.
In one embodiment, the ticket information of the ticket to be audited includes: opening a name of a party;
when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in a database, including:
when the item name is preset before the target item name list, searching whether bill information of the bill which passes the examination and comprises the name of the issuer is stored in the database;
when the bill information of the bill which passes the audit and comprises the name of the issuer is stored in the database, the target bill value in the bill information of the bill which passes the audit and comprises the name of the issuer is obtained.
In one embodiment, after searching whether the database stores the ticket information of the approved ticket including the issuer name when the item name is in the preset number of times before the target item name list, the method includes:
when the database does not store bill information of the approved bill including the issuer name, acquiring a similar keyword corresponding to the project name;
searching whether bill information of the bills which pass the examination and comprise the similar keywords is stored in the database;
when the bill information of the bill which passes the examination and comprises the similar keyword is stored in the database, acquiring the bill value in the bill information of the bill which passes the examination and comprises the similar keyword as the target bill value.
In one embodiment, after the searching whether the database stores the ticket information of the approved tickets including the similar keywords, the method includes:
and when the database does not store the bill information of the bills which pass the examination and comprise the similar keywords, acquiring the bill value in the bill information of the bills which pass the examination and comprise the project names and/or the similar keywords in a third-party public database as the target bill value.
In one embodiment, the determining the threshold range of the ticket value corresponding to the project name according to the target ticket value includes:
acquiring the maximum value and the minimum value in the target bill numerical value;
and determining the threshold range of the bill value corresponding to the project name according to the maximum value and the minimum value.
In one embodiment, the determining the threshold range of the ticket value corresponding to the item name according to the maximum value and the minimum value includes:
taking the maximum value of the target bill value as a first maximum value of the threshold range;
taking the minimum value of the target bill value as a first minimum value of the threshold range;
determining a first threshold range of the bill numerical value corresponding to the project name according to the first maximum value and the first minimum value;
or the like, or, alternatively,
increasing the maximum value of the target bill value by a first preset proportion to serve as a second maximum value of the threshold range;
reducing the minimum value of the target bill value by a second preset proportion to serve as a second minimum value of the threshold range;
and determining a second threshold range of the bill numerical value corresponding to the project name according to the second maximum value and the second minimum value.
In one embodiment, further comprising:
when the bill information of the bill to be audited meets a first preset condition, determining that the bill to be audited does not pass the audit;
outputting error information of the to-be-audited bill which does not pass the audit so as to prompt a bill auditor to process the bill which does not pass the audit according to the error information;
the first preset condition comprises at least one of the following:
the project name is not in the range of the checked project name associated with the item name;
the bill value of the bill to be audited is out of the threshold range;
and/or the presence of a gas in the gas,
and when the item name in the bill information is out of the preset name of the target item name list, sending the bill information to a corresponding terminal of an auditor so that the auditor audits the bill.
A document audit device comprising:
the acquisition module is used for acquiring the bill information of the bill to be audited; the bill information comprises a matter name, a project name corresponding to the matter name and a bill numerical value corresponding to the project name;
the searching module is used for inquiring a database according to the project name when the project name is in the range of the checked project name associated with the item name; the database is used for sequencing the checked project names related to the item names and storing the sequenced project names in a target project name list; the database comprises bill information of a plurality of bills which pass the examination; when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in a database;
the threshold range determining module is used for determining the threshold range of the bill numerical value corresponding to the project name according to the target bill numerical value;
and the judging module is used for comparing the bill value in the bill information of the bill to be audited with the threshold range, and determining that the bill to be audited passes the audit when the bill value of the bill to be audited is in the threshold range.
A computer device comprising a processor and a memory, the memory storing a computer program which, when executed by the processor, implements a ticket auditing method as described above.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out a ticket auditing method as described above.
According to the bill auditing method, the bill auditing device, the computer equipment and the storage medium, the bill information of the bill to be audited including the project name and the bill data corresponding to the project name is obtained, the target bill data related to the project name in the database is searched, the threshold range of the bill data corresponding to the project name is determined according to the target bill data, finally, the bill value in the bill information of the bill to be audited is compared with the threshold, and when the bill value of the bill to be audited is in the threshold range, the bill to be audited is determined to pass the audit. Compared with the traditional bill auditing method, the scheme provided by the application can determine whether the bill passes the auditing by comparing the bill value in the bill to be audited with the related bill value which passes the auditing, so that the bill can be audited more quickly, and the bill auditing efficiency is improved.
Drawings
FIG. 1 is a diagram of an application scenario of a ticket auditing method in one embodiment;
FIG. 2 is a schematic flow chart diagram of a document auditing method in one embodiment;
FIG. 3 is a flow chart of a ticket auditing method in another embodiment;
FIG. 4 is a block diagram showing the structure of a bill auditing apparatus according to one embodiment;
FIG. 5 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
It should be noted that the terms "first \ second \ third" related to the embodiments of the present invention only distinguish similar objects, and do not represent a specific ordering for the objects, and it should be understood that "first \ second \ third" may exchange a specific order or sequence when allowed. It should be understood that the terms first, second, and third, as used herein, are interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in other sequences than those illustrated or otherwise described herein.
The bill auditing method provided by the invention can be applied to the application scene shown in fig. 1, and fig. 1 is an application scene diagram of the bill auditing method in one embodiment, wherein, the terminal 102 can include at least one database, and the terminal 102 can acquire the bill information of the bill which passes the auditing from the database and compare the bill information with the bill information of the bill to be audited. In one embodiment, as shown in FIG. 1, a server 104 is included, and the terminal 102 communicates with the server 104 over a network. The server 104 may include at least one database, which may include a third-party public database, where the database may store the ticket information that has passed the audit, and the terminal 102 may obtain the ticket information that has passed the audit from the server 104 and compare the obtained ticket information with the ticket information of the ticket to be audited. The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, and tablet computers, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In an embodiment, with reference to fig. 2, fig. 2 is a schematic flow chart of a ticket auditing method in an embodiment, which is described by taking the method as an example applied to the terminal in fig. 1, the ticket auditing method may include the following steps:
step S101, acquiring bill information of a bill to be audited; the bill information comprises a matter name, a project name corresponding to the matter name and a bill numerical value corresponding to the project name.
The to-be-checked bill may be a securities issued by a drawer according to law and paid by himself or by another person unconditionally to a payee or a ticket holder, and may be various securities and vouchers, such as stocks, enterprise bonds, invoices, bills of lading, drafts, bank notes, checks, and the like. The bill may contain various information, for example, a transaction name contained in the bill, item information corresponding to the transaction name, and a bill value corresponding to the item name, where the transaction name may be a travel fee, a charge, and the like, the item name may be item information contained in the bill, the item name may be one or more, the transaction name may correspond to one or more item names, each item name may further have a corresponding bill value, the bill value may be data information corresponding to the item name, for example, when the bill is a bill in a type, the item name is a charge, the item name may be a commodity name, the bill value corresponding to the commodity name may be tax point information of the commodity, and the commodity name and the tax point information in the bill may be in one-to-one correspondence. The terminal 102 may obtain the ticket information of the to-be-audited ticket, where the ticket information may include a transaction name in the ticket, a project name corresponding to the transaction name, and a ticket value corresponding to the project name.
Step S102, when the project name is in the checked project name range associated with the item name, inquiring a database according to the project name; the database is used for sequencing the checked project names related to the item names and storing the sequenced project names in a target project name list; the database comprises bill information of a plurality of bills which pass the audit.
In one embodiment, the database may be composed of ticket information of a plurality of tickets that have passed the audit, the tickets that have passed the audit may include tickets of a plurality of times, each piece of ticket information may include a transaction name, a project name corresponding to the transaction name, and a ticket value corresponding to the project name, the transaction name may be, for example, a travel fee, a hospitality fee, and the like, each transaction name may correspond to one or more project names, for example, the transaction name may be a travel fee, and the corresponding project name may be information such as an air ticket, a train ticket, and the like. Where project names may be repeated, each project name may have multiple ticket values. For example, the database may be a financial database, and the financial database may include invoice information in a plurality of invoices which have passed the audit, where the invoice information may include a transaction name, a commodity name corresponding to the transaction name, and tax point information corresponding to the commodity. The terminal 102 may search the target item name corresponding to the item name in the database according to the item name, and may sort the target item name corresponding to each item name according to a preset condition, where the preset condition may be sorting according to a matching degree of the item name corresponding to the item name, or sorting according to a number of times that the item name corresponding to the item name appears in the database. The terminal 102 may store the sorted result in a target item name list, and the terminal 102 may compare the item name in the ticket with the approved item name in the list.
And step S103, when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in the database.
The item name in the bill and the corresponding bill value thereof may be represented in the database as a two-dimensional string or array, for example, the item name may be [ item, bill value ], and when the bill is an invoice, the commodity name of the invoice and the corresponding tax point may be represented as [ commodity, tax point ]. When the item name corresponding to the item name in the bill is within the preset number of the target item name list, the terminal 102 may search a target bill numerical value related to the item name in the database, where the target bill numerical value may be one or more, each item name may correspond to one bill numerical value or may correspond to multiple bill numerical values, when there are multiple item names, the distribution of the multiple item names and the corresponding bill numerical values may be represented as [ item 1, bill numerical value 1], [ item 2, bill numerical value 2], and when the bill is an invoice, the distribution may be represented as [ item 1, tax point 1], [ item 2, tax point 2], and the like. The preset range may be several names in the top of the sorting result, for example, the first three names. Specifically, the item name corresponding to the item name in the ticket appears in the first three names of the sorting result, and it can be determined that the item name is within the preset range. When the database is set in the terminal 102, the target ticket value can be searched from the database in the terminal 102, and when the database is set in the server 104, the terminal 102 can send a query request to the server, and the server 104 can search the target ticket value in the database in the server 104 according to the query request.
And step S104, determining the threshold range of the bill value corresponding to the target name according to the target bill value.
The target ticket value may be the target ticket value found in step S102. The number of the target bill values searched by the terminal 102 may be one or multiple, and when the number of the target bill values is one, the range of the bill value corresponding to the project name may be the searched target bill value; when the target bill numerical value is multiple, that is, the number of the bill numerical values corresponding to one project name may be multiple, and the range of the bill numerical value corresponding to the project name may be determined according to the found multiple bill numerical values.
And step S105, comparing the bill value in the bill information of the bill to be audited with a threshold range, and determining that the bill to be audited passes the audit when the bill value of the bill to be audited is within the threshold range.
The to-be-audited bill may be the to-be-audited bill in the above step, the bill information of the to-be-audited bill may include the item name and the bill numerical value corresponding thereto, the terminal 102 may compare the bill numerical value corresponding to each item name in the to-be-audited bill with the threshold range of the target bill numerical value, when the bill numerical value corresponding to the item name is within the threshold range, it may be determined that the bill numerical value corresponding to the item name meets the requirement, and through the audit, for example, when the bill is an invoice, the tax point corresponding to the commodity in the invoice may be compared with the found historical tax point threshold range of the commodity, and when the tax point of the commodity in the invoice to be audited is within the threshold range, it may be determined that the invoice is approved.
In one embodiment, further comprising: when the bill information of the bill to be audited meets a first preset condition, determining that the bill to be audited does not pass the audit; outputting error information of the bill to be audited which does not pass the audit so as to prompt a bill auditor to process the bill which does not pass the audit according to the error information; the first preset condition includes at least one of: the project name is not in the checked project name range associated with the item name; the bill value of the bill to be audited is out of the threshold range; and/or when the item name in the ticket information is out of the preset name in front of the target item name list, sending the ticket information to a corresponding terminal of an auditor so that the auditor audits the ticket. In this embodiment, the terminal 102 may determine that the ticket to be audited does not pass the audit when the ticket to be audited meets the first preset condition. Wherein the first preset condition may be at least one of the following: the project name is not in the range of the checked project name associated with the item name; the bill value of the bill to be audited is out of the threshold range. The terminal 102 may also determine that the to-be-audited bill does not pass the audit according to other preset conditions. The terminal 102 may compare the ticket value corresponding to the item name in the to-be-audited ticket with the threshold range, and when the ticket value is outside the threshold range, the terminal 102 may determine that the to-be-audited ticket does not pass the audit. For example, when the bill is an invoice, the item name may be travel fee, and in this case, if the item name in the invoice is a commodity name and is not a range of item names corresponding to travel fee, the terminal 102 may determine that the item name is not within a range of checked item names associated with the item name, and the bill does not pass checking. The terminal 102 may further compare the tax point corresponding to the commodity in the invoice with the found historical tax point threshold range of the commodity, and when the tax point of the commodity in the invoice to be audited is outside the threshold range, it may be determined that the invoice does not pass the audit. After the terminal 102 determines that the ticket does not pass the audit, the terminal can mark the ticket that does not pass the audit, and can also output corresponding error information so as to prompt related auditors to process the ticket that does not pass the audit according to the error information. The terminal 102 may further determine whether the ticket needs to be manually checked according to the ordering of the project names in the database, for example, when the ticket is an invoice, the project names may be a hospitality fee, the project names may be commodity names, such as flower fees, and the commodity names meet the conditions of the hospitality fee, the terminal 102 may order the project names corresponding to the hospitality fee in the database according to preset conditions, such as the number of occurrences, and when the flower fees are not in the first preset names of the target project name list, such as not in the first three names, the relevant information of the ticket may be sent to relevant auditors, and the auditors may check the ticket. Through the embodiment, the terminal 102 can determine whether the bill passes the audit or needs manual audit according to various conditions, and can prompt relevant personnel in time after determining that the bill does not pass the audit, so that the audit efficiency is improved.
According to the bill auditing method, the bill information of the bill to be audited including the project name and the bill data corresponding to the project name is obtained, the target bill data related to the project name in the database is searched, the threshold range of the bill data corresponding to the project name is determined according to the target bill data, finally, the bill value in the bill information of the bill to be audited is compared with the threshold, and when the bill value of the bill to be audited is within the threshold range, the bill to be audited is determined to pass the audit. Compared with the traditional bill auditing method, the scheme provided by the application can determine whether the bill passes the auditing by comparing the bill value in the bill to be audited with the related bill value which passes the auditing, so that the bill can be audited more quickly, and the bill auditing efficiency is improved.
In one embodiment, the ticket information of the ticket to be audited includes: opening a name of a party; when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in the database, wherein the target bill numerical value comprises the following steps: when the item name is preset before the target item name list, searching whether bill information of the bill which passes the examination and comprises the name of the issuer is stored in a database; when the bill information of the bill which passes the audit and comprises the name of the issuer is stored in the database, the target bill value in the bill information of the bill which passes the audit and comprises the name of the issuer is obtained.
In this embodiment, the bill information of the bill to be audited may further include a name of the issuing party, where the name of the issuing party may be an individual issuing the bill, for example, when the bill is an invoice, the name of the issuing party may be a payee, and in addition, the information that the terminal 102 may obtain from the invoice may further include: invoice type, amount, tax number, etc. The terminal 102 may search the database for whether the billing information including the name of the issuer of the to-be-audited bill is stored, that is, whether the database stores a historical billing record related to the issuer, and the database may store the billing information of a plurality of bills that have passed the audit, and when the database stores the billing information including the name of the issuer of the to-be-audited bill, the terminal 102 may obtain the target billing value, that is, the billing value corresponding to each item name, from the searched billing information including the name of the issuer of the to-be-audited bill, for example, when the billing data is an invoice, the database may be a financial database, the terminal 102 may search the historical billing record including the name of the issuer in the financial database, and when the invoice including the name of the issuer is found, obtain the historical tax point corresponding to the commodity, as target tax points. When the terminal 102 finds the ticket information including the name of the issuer of the ticket to be audited, the ticket information may be at least one. Through the embodiment, the terminal 102 can search the database for the historical bill data including the name of the issuer in the bill to be audited, and determine the value of the target bill according to the value of the historical bill, so that the reasonable threshold range can be determined more quickly.
In one embodiment, when the item name is in the preset number of times before the target item name list, after whether the bill information of the bill which passes the audit and comprises the name of the issuer is stored in the database, the method comprises the following steps: when the bill information of the approved bill including the name of the issuer is not stored in the database, acquiring similar keywords corresponding to the name of the project; searching whether bill information of the bills which pass the examination and comprise similar keywords is stored in a database; when the bill information of the bills which pass the examination and comprise the similar keywords is stored in the database, acquiring the bill value in the bill information of the bills which pass the examination and comprise the similar keywords as the target bill value.
In this embodiment, the terminal 102 may search, in the database, whether the bill information includes the issuer name in the bill to be audited, and when the issuer name is not found in the database, the terminal 102 may obtain the similar keyword of the item name in the bill to be audited, where the similar keyword may be obtained through semantic analysis, for example, appropriate word segmentation may be performed on the item name, and corresponding processing of natural language is performed on each word segmentation to search for the corresponding similar keyword. Wherein the similar keyword may be at least one. The terminal 102 may search whether the ticket information including the similar keyword is stored in the database after the similar keyword is found, and when the related ticket information is found, the terminal 102 may obtain a ticket value corresponding to the similar keyword from the found ticket information including the similar keyword as the target ticket value. For example, when the bill is an invoice, the database may be a financial database, the terminal 102 may search the financial database for an invoice related to a similar keyword of a commodity name in the invoice, and after the invoice including the similar keyword is found, the terminal 102 may obtain a tax point corresponding to the similar keyword in the invoice as a target tax point. When the terminal 102 finds the ticket information including the similar keyword, the ticket information may be at least one. Through the embodiment, the terminal 102 can search the target bill value in the database according to the similar keyword of the project name, so that the target bill value can be searched more comprehensively, and the searched target bill value has higher validity.
In one embodiment, after searching whether the database stores the bill information of the approved bills including the similar keywords, the method comprises the following steps: and when the bill information of the bills which pass the examination and comprise the similar keywords is not stored in the database, acquiring the bill value in the bill information of the bills which pass the examination and comprise the project names and/or the similar keywords as the target bill value in the third-party public database.
In this embodiment, the third-party public database may be another bill information database that includes the item name or the similar keyword in the bill to be audited. The terminal 102 may search the third-party public database for the bill information related to the item name and the similar keyword thereof, and obtain the bill value related to the item name or the similar keyword from the searched bill information as the target bill value, for example, when the bill is an invoice, the third-party public database may be another public financial database, the terminal 102 may search the third-party public database for the commodity name and the similar keyword thereof in the invoice to be audited, the searched result may be a reimbursement record or invoice data, and the tax point related to the commodity or the similar keyword thereof may be found as the target tax point. The number of the searched bills may be at least one, and the bill information searched in the third-party public database may be newly issued. Through the embodiment, the terminal 102 can search the bill information related to the project name or the similar keyword in the third-party public database, so that the effect of searching the target bill value more comprehensively is achieved.
In one embodiment, determining a threshold range of ticket values for the item name based on the target ticket value comprises: acquiring the maximum value and the minimum value in the target bill numerical value; and determining the threshold range of the bill value corresponding to the project name according to the maximum value and the minimum value.
In this embodiment, the terminal 102 may obtain a maximum value and a minimum value of the target ticket values found in the database, where when the target ticket value is one, the maximum value and the minimum value may be the same value, and the terminal 102 may determine a threshold range of the ticket value according to the found target ticket value, and in an embodiment, determine the threshold range of the ticket value corresponding to the project name according to the maximum value and the minimum value, where the determining includes: taking the maximum value of the target bill value as a first maximum value of the threshold range; taking the minimum value of the target bill value as a first minimum value of a threshold range; determining a first threshold range of the bill value corresponding to the project name according to the first maximum value and the first minimum value; or, increasing the maximum value of the target bill value by a first preset proportion to be used as a second maximum value of the threshold range; reducing the minimum value of the target bill value by a second preset proportion to serve as a second minimum value of the threshold range; and determining a second threshold range of the bill value corresponding to the project name according to the second maximum value and the second minimum value. In this embodiment, the terminal 102 may use a maximum value of the searched target ticket values as a maximum value of the threshold range, use a minimum value of the searched target ticket values as a minimum value of the threshold range, and determine the threshold range of the ticket values corresponding to the item name according to the maximum value and the minimum value. Specifically, when the ticket is an invoice, the maximum value of the searched target tax point may be used as the maximum value of the tax point threshold range, the minimum value of the searched target tax point may be used as the minimum value of the tax point threshold range, and the threshold range of the tax point corresponding to the commodity name in the invoice is determined according to the maximum value and the minimum value. The terminal 102 may increase the maximum value by a first preset ratio to be another maximum value of the threshold range and decrease the minimum value by a second preset ratio to be another minimum value of the threshold range, for example, when the bill is an invoice, the terminal 102 may increase the maximum value of the tax point by the first preset ratio to be another maximum value of the threshold range and decrease the minimum value of the tax point by the second preset ratio to be another minimum value of the threshold range. The first preset proportion and the second preset proportion may be the same or different, for example, both the first preset proportion and the second preset proportion may be 10%, that is, the second maximum value may be 110% of the first maximum value, the second minimum value may be 90% of the first minimum value, and both the two threshold value ranges may be used as the threshold value ranges of the bill values in the bill to be audited. Through the embodiment, the terminal 102 can adjust the threshold range of the ticket value according to the actual situation, so as to more flexibly judge the validity of the ticket value in the ticket to be audited.
In one embodiment, as shown in fig. 3, fig. 3 is a schematic flow chart of a ticket auditing method in another embodiment. The method is illustrated as applied to the terminal in fig. 1, and the ticket may be an invoice. The terminal 102 may obtain invoice information, wherein the invoice information may include the type, amount, name and tax payment number of an invoice, and name of an invoice item, and then may search whether the financial database stores the invoice information of the name of the invoker, thereby determining whether the invoker is a first cooperation; when the cooperation is not the first time, searching historical invoicing records of the two parties in the financial database, and acquiring tax point distribution corresponding to the project names in the historical invoicing records; when the first cooperation is performed, the terminal 102 may extract the item name in the invoice, obtain a similar keyword through semantic analysis, find related reimbursement records and invoice data in the financial database according to the similar keyword, if no related data is found in the financial database, the terminal 102 may search a latest tax point related to the item name and the similar keyword from a third-party public database, the terminal 102 may find the item name and the tax point according to the above steps to form a distribution of the item name and a tax point distribution, for example, in the form of [ commodity 1, tax point 1], [ commodity 2, tax point 2], and may further determine a reasonable threshold range of the tax point of each item name according to the above information, when the tax point and the item name in the invoice to be audited are within the above threshold range, the invoice may be audited, otherwise, the invoice auditing method can provide warning for the auditing, and prompt related auditors that the invoice does not pass the auditing. Through the embodiment, the terminal 102 judges whether the invoice passes the audit according to whether the tax point in the invoice to be audited is within the reasonable threshold range, so that the invoice audit efficiency is improved.
In one embodiment, a bill auditing device is provided, and referring to fig. 4, fig. 4 is a block diagram of a structure of the bill auditing device in one embodiment, and the bill auditing device may include:
the acquiring module 400 is used for acquiring the bill information of the bill to be audited; the bill information comprises item names, project names and bill numerical values corresponding to the project names; the item name corresponds to the project name;
the searching module 401 is configured to search a target project name corresponding to the item name in the database when the project name is within the range corresponding to the item name, sort the target project name according to a preset condition, and compare the project name with a sorting result; the database comprises bill information of a plurality of bills which pass the examination; when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in the database;
a threshold range determining module 402, configured to determine, according to the target ticket value, a threshold range of the ticket value corresponding to the project name;
the judging module 403 is configured to compare a ticket value in the ticket information of the ticket to be audited with a threshold range, and determine that the ticket to be audited passes the audit when the ticket value of the ticket to be audited is within the threshold range.
The bill auditing device of the present invention corresponds to the bill auditing method of the present invention one to one, and the specific limitations of the bill auditing device can refer to the limitations of the bill auditing method in the above, and the technical features and the beneficial effects described in the embodiments of the bill auditing method are all applicable to the embodiments of the bill auditing device, and are not described herein again. All or part of the modules in the bill auditing device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, and the computer device may be a terminal, and its internal structure diagram may be as shown in fig. 5, and fig. 5 is an internal structure diagram of the computer device in one embodiment. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a ticket auditing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the configuration shown in fig. 5 is a block diagram of only a portion of the configuration associated with aspects of the present invention and is not intended to limit the computing devices to which aspects of the present invention may be applied, and that a particular computing device may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a processor and a memory, the memory storing a computer program, the processor implementing the ticket auditing method according to any one of the above embodiments when executing the computer program.
It will be understood by those skilled in the art that all or part of the processes in the method for auditing tickets according to any of the above embodiments may be implemented by instructing the relevant hardware through a computer program, which may be stored in a non-volatile computer-readable storage medium, and when executed, the computer program may include the processes of the above embodiments of the methods. Any reference to memory, storage, databases, or other media used in embodiments provided herein may include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
Accordingly, in an embodiment, there is also provided a computer-readable storage medium having a computer program stored thereon, wherein the program, when executed by a processor, implements a ticket auditing method according to any one of the above embodiments.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A bill auditing method is characterized by comprising the following steps:
acquiring bill information of a bill to be audited; the bill information comprises a matter name, a project name corresponding to the matter name and a bill numerical value corresponding to the project name;
when the project name is in the checked project name range associated with the item name, querying a database according to the project name; the database is used for sequencing the checked project names related to the item names and storing the sequenced project names in a target project name list; the database comprises bill information of a plurality of bills which pass the examination;
when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in a database;
determining a threshold range of a bill numerical value corresponding to the project name according to the target bill numerical value;
comparing the bill value in the bill information of the bill to be audited with the threshold range, and determining that the bill to be audited passes the audit when the bill value of the bill to be audited is within the threshold range.
2. The method according to claim 1, wherein the ticket information of the ticket to be audited comprises: opening a name of a party;
when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in a database, including:
when the item name is preset before the target item name list, searching whether bill information of the bill which passes the examination and comprises the name of the issuer is stored in the database;
when the bill information of the bill which passes the audit and comprises the name of the issuer is stored in the database, the target bill value in the bill information of the bill which passes the audit and comprises the name of the issuer is obtained.
3. The method according to claim 2, wherein after searching whether the database stores the ticket information of the ticket that has passed the audit and includes the name of the issuer when the name of the item is a preset number of times before the list of the target name of the item, the method comprises:
when the database does not store bill information of the approved bill including the issuer name, acquiring a similar keyword corresponding to the project name;
searching whether bill information of the bills which pass the examination and comprise the similar keywords is stored in the database;
when the bill information of the bill which passes the examination and comprises the similar keyword is stored in the database, acquiring the bill value in the bill information of the bill which passes the examination and comprises the similar keyword as the target bill value.
4. The method according to claim 3, wherein after the searching whether the database stores the ticket information of the approved tickets including the similar keywords, the method comprises:
and when the database does not store the bill information of the bills which pass the examination and comprise the similar keywords, acquiring the bill value in the bill information of the bills which pass the examination and comprise the project names and/or the similar keywords in a third-party public database as the target bill value.
5. The method of claim 1, wherein determining the threshold range of the ticket value corresponding to the item name based on the target ticket value comprises:
acquiring the maximum value and the minimum value in the target bill numerical value;
and determining the threshold range of the bill value corresponding to the project name according to the maximum value and the minimum value.
6. The method of claim 5, wherein determining the threshold range of the ticket value corresponding to the project name based on the maximum value and the minimum value comprises:
taking the maximum value of the target bill value as a first maximum value of the threshold range;
taking the minimum value of the target bill value as a first minimum value of the threshold range;
determining a first threshold range of the bill numerical value corresponding to the project name according to the first maximum value and the first minimum value;
or the like, or, alternatively,
increasing the maximum value of the target bill value by a first preset proportion to serve as a second maximum value of the threshold range;
reducing the minimum value of the target bill value by a second preset proportion to serve as a second minimum value of the threshold range;
and determining a second threshold range of the bill numerical value corresponding to the project name according to the second maximum value and the second minimum value.
7. The method of any of claims 1 to 6, further comprising:
when the bill information of the bill to be audited meets a first preset condition, determining that the bill to be audited does not pass the audit;
outputting error information of the to-be-audited bill which does not pass the audit so as to prompt a bill auditor to process the bill which does not pass the audit according to the error information;
the first preset condition comprises at least one of the following:
the project name is not in the range of the checked project name associated with the item name;
the bill value of the bill to be audited is out of the threshold range;
and/or the presence of a gas in the gas,
and when the item name in the bill information is out of the preset name of the target item name list, sending the bill information to a corresponding terminal of an auditor so that the auditor audits the bill.
8. A bill auditing apparatus, comprising:
the acquisition module is used for acquiring the bill information of the bill to be audited; the bill information comprises a matter name, a project name corresponding to the matter name and a bill numerical value corresponding to the project name;
the searching module is used for inquiring a database according to the project name when the project name is in the range of the checked project name associated with the item name; the database is used for sequencing the checked project names related to the item names and storing the sequenced project names in a target project name list; the database comprises bill information of a plurality of bills which pass the examination; when the item name is preset before the target item name list, searching a target bill numerical value related to the item name in a database;
the threshold range determining module is used for determining the threshold range of the bill numerical value corresponding to the project name according to the target bill numerical value;
and the judging module is used for comparing the bill value in the bill information of the bill to be audited with the threshold range, and determining that the bill to be audited passes the audit when the bill value of the bill to be audited is in the threshold range.
9. A computer device comprising a processor and a memory, the memory storing a computer program, wherein the processor when executing the computer program implements the steps of the document auditing method of any one of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the document auditing method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911352933.6A CN111126966A (en) | 2019-12-25 | 2019-12-25 | Bill auditing method and device, computer equipment and computer-readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911352933.6A CN111126966A (en) | 2019-12-25 | 2019-12-25 | Bill auditing method and device, computer equipment and computer-readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111126966A true CN111126966A (en) | 2020-05-08 |
Family
ID=70502418
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911352933.6A Pending CN111126966A (en) | 2019-12-25 | 2019-12-25 | Bill auditing method and device, computer equipment and computer-readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111126966A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111950985A (en) * | 2020-08-18 | 2020-11-17 | 山东泰和建设管理有限公司 | Cost control method and device, computer equipment and storage medium |
| CN114022098A (en) * | 2021-10-09 | 2022-02-08 | 浪潮通用软件有限公司 | Document auditing method and device and computer readable medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299259A (en) * | 2018-09-26 | 2019-02-01 | 深圳壹账通智能科技有限公司 | Enterprise's invoice data monitoring method, device, computer equipment and storage medium |
| CN109544254A (en) * | 2017-09-21 | 2019-03-29 | 华为技术有限公司 | Invoice information processing method, apparatus and system |
| CN109887153A (en) * | 2019-02-03 | 2019-06-14 | 国信电子票据平台信息服务有限公司 | A kind of property tax processing method and processing system |
| CN110288451A (en) * | 2019-05-15 | 2019-09-27 | 平安科技（深圳）有限公司 | A kind of finance method of charging out, system, equipment and storage medium |
-
2019
- 2019-12-25 CN CN201911352933.6A patent/CN111126966A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109544254A (en) * | 2017-09-21 | 2019-03-29 | 华为技术有限公司 | Invoice information processing method, apparatus and system |
| CN109299259A (en) * | 2018-09-26 | 2019-02-01 | 深圳壹账通智能科技有限公司 | Enterprise's invoice data monitoring method, device, computer equipment and storage medium |
| CN109887153A (en) * | 2019-02-03 | 2019-06-14 | 国信电子票据平台信息服务有限公司 | A kind of property tax processing method and processing system |
| CN110288451A (en) * | 2019-05-15 | 2019-09-27 | 平安科技（深圳）有限公司 | A kind of finance method of charging out, system, equipment and storage medium |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111950985A (en) * | 2020-08-18 | 2020-11-17 | 山东泰和建设管理有限公司 | Cost control method and device, computer equipment and storage medium |
| CN111950985B (en) * | 2020-08-18 | 2024-05-07 | 山东泰和建设管理有限公司 | Cost control method, device, computer equipment and storage medium |
| CN114022098A (en) * | 2021-10-09 | 2022-02-08 | 浪潮通用软件有限公司 | Document auditing method and device and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20060271450A1 (en) | Computer-based method for automatic remote coding of debtor credit databases with bankruptcy filing information | |
| US20070226095A1 (en) | Method for generating predictive models for a business problem via supervised learning | |
| CN109739957B (en) | Document information input method, device, equipment and storage medium based on data processing | |
| WO2019019777A1 (en) | Insurance policy premium-withdrawing processing method and apparatus, computer device, and storage medium | |
| JP2016181254A (en) | Automatic journalizing processing apparatus, automatic journalizing processing method, and automatic journalizing processing program | |
| CN111028072A (en) | Supply chain financial pre-loan tone data processing method and system | |
| CN111126966A (en) | Bill auditing method and device, computer equipment and computer-readable storage medium | |
| CN115409590A (en) | Unified account checking method, device, equipment and storage medium | |
| US20070255651A1 (en) | Batch processing of financial transactions | |
| CN115269437A (en) | Test case recommendation method and device, computer equipment and storage medium | |
| CN114240611A (en) | Method and device for accounting accuracy of service data, computer equipment and storage medium | |
| CN109947797B (en) | Data inspection device and method | |
| CN111292068B (en) | Contract information auditing method and device, electronic equipment and storage medium | |
| CN111143512A (en) | Bill information detection method and device and computer equipment | |
| CN110489434B (en) | Information processing method and related equipment | |
| CN114493820B (en) | Correlation verification type acquisition method and device suitable for financial data and storage medium | |
| CN111161088A (en) | Bill processing method, device and equipment | |
| CN112581295B (en) | Product data processing method, device, equipment and medium based on field splitting | |
| US20160125553A1 (en) | System of managing and analyzing irs account data | |
| US10235719B2 (en) | Centralized GAAP approach for multidimensional accounting to reduce data volume and data reconciliation processing costs | |
| CN107563599A (en) | Patent valve estimating system based on big data | |
| CN114511318A (en) | Account accounting method and device and electronic equipment | |
| CN110728566B (en) | Data processing method and device in reimbursement file, computer equipment and storage medium | |
| CN111858499A (en) | File identification method, system and device based on black and white list | |
| CN110378599A (en) | Ranking method, system, equipment and the computer storage medium of accident prevention quality |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200508 |
|
| RJ01 | Rejection of invention patent application after publication |