TWM562436U - Intelligent account checking system - Google Patents

Abstract

The novel intelligent reconciliation system is a communication connection to an online banking system. The online banking system includes a transaction detail list, and the transaction details include at least one payment data and at least one payment information. The intelligent reconciliation system includes a voucher reading identification module, an accounting accounting processing center and a comparison module. The voucher reading identification module is installed in an electronic device, and the voucher reading identification module includes an image character reading unit, and the image character reading unit reads a traditional invoice or a taxed certificate by OCR text recognition technology. Or a type of receipt, or scan a two-dimensional bar code of an electronic invoice to generate an incoming voucher data or a sales voucher data. The comparison module is used to compare the incoming voucher data with the bank payment data or for comparing the sales voucher data with the bank payment data. Wherein, when the input voucher data cannot correspond to the payment information, the input voucher data is marked as an accounts payable.

Description

Intelligent reconciliation system

The invention provides an intelligent reconciliation system, in particular to a smart reconciliation system with a voucher reading identification module and a comparison module.

The rapid and accurate circulation of information flow and gold flow plays an important role in enterprise management. In particular, if the goods (or services) and capital exchanges of enterprises can be efficiently reconciled through online banking, the efficiency of the enterprise can be improved. Correctness. In the traditional reconciliation mode, the reconciliation personnel need to manually compare the voucher data (such as: traditional invoice, tax certificate or various receipts) and the income and expenditure of the bank transaction details to confirm the actual internal business. The amount posted and posted. However, the traditional reconciliation method requires the requisitioner's experience to be higher, the comparison is time consuming, and there is more man-made comparison, so the actual reconciliation is not effective.

Therefore, how to more effectively and effectively grasp the vouchers of the actual accounts and accounts of the enterprises, and avoid the human error through the audit trail left by the online banking, which is worthy of consideration in the field.

The purpose of the present invention is to provide a smart reconciliation system that can more effectively and efficiently grasp the actual inflows of accounts and the voucher data of the accounts, and avoid human error.

The novel intelligent reconciliation system is a communication connection to an online banking system. The online banking system includes a transaction detail list, and the transaction details include at least one payment data and at least one payment information. The intelligent reconciliation system includes a voucher reading identification module, an accounting accounting processing center and a comparison module. The voucher reading identification module is installed in an electronic device, and the voucher reading identification module includes an image character reading unit, and the image character reading unit reads a traditional invoice & tax certificate by OCR character recognition technology or A variety of receipts to generate an entry voucher or a sales voucher. In addition, the accounting transaction processing center is installed on a server, and the input voucher data or the sales voucher data is transmitted to the accounting transaction processing center, and the transaction detailed list is downloaded to the accounting transaction processing center. In addition, the comparison module is configured to compare the input voucher data and the payment data or to compare the sales voucher data and the payment data, and the comparison module is installed on the server. Wherein, when the input voucher data cannot correspond to the payment information, the input voucher data is marked as an accounts payable, and when the sales voucher data cannot correspond to the payment information, the sales voucher data is Mark as an account receivable.

In the smart reconciliation system described above, wherein the transaction detail list is a TXT file.

In the smart reconciliation system described above, an encryption module is further included, and the encryption module encrypts the transaction list.

The smart reconciliation system described above further includes a monitoring module for monitoring the transaction list in the accounting transaction processing center, and when the payment information and the receipt information are changed The monitoring module sends a warning message.

In the above-mentioned smart reconciliation system, the voucher reading identification module further includes a code reading unit, and the bar code reading unit reads at least one electronic invoice to obtain the input voucher data or the sales voucher data. .

In the above described intelligent reconciliation system, the accounting transaction processing center includes a data voucher management unit, and the data voucher management unit includes a duplicate voucher filtering unit and a character analysis management unit. The duplicate voucher filtering unit is configured to check whether the inward voucher data or the sales voucher data is repeatedly established. In addition, the character analysis management unit includes a keyword database, and the keyword database includes a plurality of keyword correspondence tables, and the character analysis management unit classifies the input document data according to the content of the keyword correspondence table to generate A billing information.

In the above described smart reconciliation system, the voucher reading identification module further includes a manual input unit, and a department user establishes the content of an unreadable invoice by the manual input unit as the input voucher data. Or the sales certificate information.

In the above described smart reconciliation system, the electronic device is a smart phone, a tablet, a notebook or a desktop computer.

The above described features and advantages will be more apparent from the following description.

6‧‧‧Server

81‧‧‧Traditional Invoices & Tax Certificates

82‧‧‧ Various receipts

83‧‧‧Electronic invoice

830‧‧‧2D barcode

84‧‧‧Unreadable invoices

9‧‧‧Internet Banking System

90‧‧‧Detailed list of transactions

91‧‧‧ Payment Information

92‧‧‧ Collection Information

10, 20‧‧‧Intelligent reconciliation system

11‧‧‧Electronic devices

110‧‧‧ lens

112‧‧‧Voucher reading identification module

1121‧‧‧Image character reading unit

1122‧‧‧Bar code reading unit

1123‧‧‧Manual input unit

12‧‧‧Accounting Processing Center

121‧‧‧ Entry Voucher Information

122‧‧‧Sales Voucher Information

123‧‧‧Information voucher management unit

1231‧‧‧Repeating Credential Filter Unit

1232‧‧‧Character Analysis Management Unit

1232A‧‧‧Keyword Database

13‧‧‧Accounting Information

14‧‧‧ Alignment module

25‧‧‧Encryption Module

26‧‧‧Monitoring module

FIG. 1 illustrates the smart reconciliation system 10 of the present embodiment.

FIG. 2 is a schematic diagram showing the electronic device 11 taking a traditional invoice & tax certificate 81.

FIG. 3 is a schematic diagram showing the electronic device 11 taking a photographed electronic invoice 83.

FIG. 4 illustrates a smart reconciliation system 20 of another embodiment.

The comparison module 14 of the smart reconciliation system 10 of the present embodiment can effectively compare the information flow with the gold flow, which can reduce human error, error and fraud. The detailed implementation and application of the intelligent reconciliation system 10 are as follows: : Please refer to FIG. 1 and FIG. 2 . FIG. 1 illustrates the smart reconciliation system 10 of the present embodiment. FIG. 2 is a schematic diagram of the electronic device 11 taking a traditional invoice & tax certificate 81 . The smart reconciliation system 10 is communicatively coupled to an online banking system 9, the online banking system 9 including a transaction detail list 90, the transaction details list 90 being, for example, a TXT file, and the transaction details 90 including at least one payment profile 91 and at least A receipt information 92. In detail, the payment information 91 is generated by the expenses incurred within the company, and the payment information 92 is generated by the fee of the company's income. The smart reconciliation system 10 of the present embodiment includes a voucher read identification module 112, an accounting transaction processing center 12, and a comparison module 14. The voucher reading identification module 112 is mounted on an electronic device 11, and the electronic device 11 includes a lens 110. The electronic device 11 is, for example, a smart phone, a tablet computer, a notebook computer, or a desktop computer. In addition, the voucher read identification module 112 includes an image character reading unit 1121. The image character reading unit 1121 reads a traditional invoice & tax certificate 81 or a receipt by using the lens 110 and the OCR character recognition technology. 82, to generate an entry voucher data 121 or a sales voucher data 122. In detail, when the traditional invoice & tax certificate 81 is an invoice or document belonging to the input expenditure, the image character reading unit 1121 recognizes the traditional invoice & tax certificate 81 by using OCR character recognition technology (Optical Character Recognition). To generate the entry voucher data 121. More specifically, the entry voucher data 121 continues to save the graphic in the traditional invoice & tax certificate 81, and the text becomes a text that can be calculated (the text is not an image file). Similarly, if the traditional invoice & tax certificate 81 is an invoice belonging to the sales revenue, the image character reading unit 1121 recognizes the traditional invoice & tax certificate 81 and generates a sales document information 122, which is also the same. The graphic in the traditional invoice & tax certificate 81 is saved, and the text becomes a text that can be calculated (the text is not one) Picture file). In the above, the image character reading unit 1121 can recognize the traditional invoice & tax certificate 81, and the image character reading unit 1121 can also read a receipt 82 by the OCR character recognition technology, and the input voucher data 121 is also generated. Or the sales certificate information 122.

In addition, the accounting transaction processing center 12 is installed in a server 6, and the input voucher data 121 or the sales voucher data 122 is transmitted by the electronic device 11 to the accounting service processing center 12, and the transaction detail list 90 of the online banking system 9 It will also be downloaded to Accounting Service Processing Center 12. The accounting and accounting processing center 12 includes a data voucher management unit. The data voucher management unit includes a duplicate voucher filtering unit 1231 and a character analysis management unit 1232. The duplicate voucher filtering unit 1231 is configured to check the incoming voucher data 121 or pin. Whether the item voucher data 122 is repeatedly established. For example, the duplicate voucher filtering unit 1231 determines whether the entry voucher information 121 or the sales voucher document 122 has been stored in the accounting transaction processing center 12 based on the invoice number of the traditional invoice & tax certificate 81. As a result, the same invoice will not be re-recorded. In addition, if the source of the input voucher information 121 or the sales voucher data 122 is the receipt 82, the duplicate voucher filtering unit 1231 determines whether the input voucher data 121 or the sales voucher data 122 has been stored according to the date, item and amount of the receipt 82. In the accounting transaction processing center 12, it is also possible to prevent the same receipt from being re-recorded. In addition, the character analysis management unit 1232 includes a keyword database 1232A, and the keyword database 1232A includes a plurality of keyword correspondence tables, and the character analysis management unit inputs the document information 121 according to the contents of the keyword correspondence table. Or the sales voucher data 122 is classified to generate a billing data 13. For example, when the entry voucher data 121 includes the "pencil" keyword, the character analysis management unit 1232 finds the corresponding name "stationery article" in the keyword correspondence table, and the account number is "5153". Alternatively, when the entry voucher data 121 includes keywords such as "water fee" or "electricity fee", the character analysis management unit 1232 finds the corresponding name in the keyword correspondence table as "water". Electric gas fee, and the subject number is "5161". In this way, the entry voucher data 121 can be quickly classified by subject without manual processing.

Referring again to FIG. 1, the comparison module is also installed on the server 6, and the comparison module 14 is used for comparing the entry voucher data 121 with the payment information 91 or for comparing the sales voucher data 122 with the receipt data. 92. Thereafter, when the entry voucher data 121 cannot correspond to the payment information 91, the entry voucher information 121 is marked as an account payable. In detail, if the amount of the input voucher information 121 cannot match the payment of any of the payment materials 91, it means that the invoice or receipt of the other company's line number has been received, but the company has not actually paid within, so the input voucher information 121 must first be marked as an account payable. Moreover, when the sales item voucher data 122 cannot correspond to the payment information, the sales item voucher data 122 is also marked as an account receivable. Similarly, if the payment for the voucher information 122 cannot match the amount of any receipt information 92, it means that the invoice or receipt issued by the company has not been collected, that is, the other company's line number has not yet been received. The payment is actually made, so the sales voucher data 122 must also be marked as an account receivable to remind which funds will be received. Therefore, compared with the manual reconciliation method, the intelligent reconciliation system 10 can more quickly grasp the voucher data actually recorded and discharged within the company, effectively avoiding the loss of human reconciliation, and reducing the expenditure of the company's labor cost. .

Please refer to FIG. 1 and FIG. 3 simultaneously. FIG. 3 is a schematic diagram of the electronic device 11 taking an electronic invoice 83. The voucher read identification module 112 can read an electronic invoice 83 by the bar code reading unit 1122 and the lens 110 to generate the entry voucher data 121. In detail, the electronic invoice 83 itself has a two-dimensional barcode (QR code) 830, and the basic information of the input voucher data 121 is stored in the two-dimensional barcode 830, so when the lens 110 is aligned with the two-dimensional barcode 830 of the electronic invoice 83 The barcode reading unit 1122 can also read the input voucher data 121 or the sales item voucher data 122 from the two-dimensional bar code 830. In this way, the material voucher management unit 123 can perform subsequent processing. In addition, when the lens 110 of the electronic device 11 cannot read the traditional invoice & has When the tax certificate 81 or the various types of receipts 82 (the traditional invoice & tax certificate 81 or the type of receipt 82 is too old or the surface type is too vague), the department user of the electronic device 11 can manually input the unit 1123 The content of an unreadable invoice 84 is created as an entry voucher document 121 or a sales voucher document 122. In this way, the material voucher management unit 123 can still perform subsequent processing (generating the account information 13) for the input voucher data 121 or the sales voucher data 122.

Referring to FIG. 4, FIG. 4 illustrates another embodiment of the smart reconciliation system 20. The difference between the smart reconciliation system 20 and the smart reconciliation system 10 is that the smart reconciliation system 20 further includes an encryption module 25 and A monitoring module 26. The encryption module 25 is configured to encrypt the transaction detail list 90 in the accounting transaction processing center 12. Therefore, an external unauthorized person cannot modify the transaction details list 90 to ensure the correctness of the payment information 91 and the receipt information 92. In this way, the comparison of the data presented by the module 14 has a reference and operational value. In addition, the monitoring module 26 is configured to monitor the transaction detail list 90 in the accounting transaction processing center 12, and when the payment data 91 and the payment data 92 are changed, the monitoring module 26 issues a warning message. Specifically, when the encrypted transaction list 90 is still cracked, the monitoring module 26 will continuously monitor whether the payment data 91 and the receipt information 92 have changed. Moreover, when an external unauthorized person modifies the transaction details list 90, the monitoring module 26 issues a warning message to alert the user of the smart reconciliation system 20. As a result, the risk of the transaction list 90 being tampered with can be reduced.

In summary, the smart reconciliation system of the present invention utilizes the voucher read identification module 112 to scan and identify different types of invoices or receipts. Thereafter, the accounting data 13 is automatically generated via the accounting transaction processing center 12. Moreover, the system also uses the comparison module 14 to compare the entry voucher data 121 or the sales voucher data 122 to the transaction details list 90, so that the company can actually find the unpaid accounts payable and the accounts receivable receivable. .

Although the present invention has been disclosed in the above preferred embodiments, it is not intended to limit the present invention, and any one of ordinary skill in the art can make some modifications and refinements without departing from the spirit and scope of the present invention. Therefore, the scope of protection of this new type is subject to the definition of the scope of the patent application.

Claims (8)

A smart reconciliation system, the communication being connected to an online banking system, the online banking system comprising a transaction detail list, the transaction detail information comprising at least one payment data and at least one payment data, the smart reconciliation system comprising: The voucher reading identification module is installed in an electronic device, and the voucher reading identification module comprises an image character reading unit, and the image character reading unit reads a traditional invoice & tax by OCR text recognition technology a voucher or a type of receipt to generate an entry voucher data or a sales voucher data; an accounting transaction processing center, the accounting transaction processing center is installed on a server, and the input voucher data or the sales voucher data is Transferred to the accounting transaction processing center, and the transaction detail list is downloaded to the accounting transaction processing center; and a comparison module, the comparison module is connected to the accounting transaction processing center, and the comparison module is used for comparison The input voucher data and the payment data are used to compare the sales voucher data with the payment data, and the comparison module is installed on the server; wherein, when the input item is When the voucher data cannot correspond to the payment data, the input voucher data is marked as an accounts payable, and when the sales voucher data cannot correspond to the payment information, the sales voucher data is marked as one receivable. Account. The smart reconciliation system of claim 1, wherein the transaction list is a TXT file. The smart reconciliation system of claim 1, further comprising an encryption module, the encryption module encrypting the transaction list. The smart reconciliation system of claim 1, further comprising a monitoring module, wherein the monitoring module is configured to monitor the transaction list in the accounting transaction processing center, and when the payment information and the receipt The monitoring module issues a warning message when there is a change in the data. The smart reconciliation system of claim 1, wherein the voucher reading identification module further comprises a code reading unit, wherein the bar code reading unit reads at least one electronic invoice to obtain the input voucher data or The sales certificate information. The smart reconciliation system of claim 1, wherein the accounting transaction processing center comprises a data voucher management unit, and the data voucher management unit comprises: a duplicate voucher filtering unit, wherein the duplicate voucher filtering unit is configured to check Whether the input voucher data or the sales voucher data is repeatedly established; and a character analysis management unit includes a keyword database, the keyword database includes a plurality of keyword correspondence tables, and the character analysis management unit is based on The content of the keyword correspondence table classifies the input voucher data to generate a billing data. The smart reconciliation system of claim 1, wherein the voucher read identification module further comprises a manual input unit, and a department user inputs an unreadable invoice content by the manual input unit. The entry voucher data or the sales voucher data is established. The smart reconciliation system of claim 1, wherein the electronic device is a smart phone, a tablet computer, a notebook computer or a desktop computer.