Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for automatically completing accounting data based on bank statement data

A technology for automatic completion and accounting data, applied in the field of financial and taxation intelligence, it can solve the problems of heavy document supplementation, missing business documents, and heavy workload, saving the manual preparation process and improving work efficiency and accuracy. , the effect of improving the accuracy

Inactive Publication Date: 2019-02-19
厦门商集网络科技有限责任公司
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] (1) Manual comparison, heavy workload and error-prone; (2) Troubleshooting reasons, if you need to check business invoices, you need to search and compare in the entire pile of original invoices, which is inefficient; (3) Business documents are missing, and the documents are supplemented The workload is heavy; (4) The workload of compiling the "Bank Balance Reconciliation Statement" is heavy and error-prone

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for automatically completing accounting data based on bank statement data
  • Method and device for automatically completing accounting data based on bank statement data
  • Method and device for automatically completing accounting data based on bank statement data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0041] see figure 2 and image 3 , a method for automatically completing account data based on bank statement data, comprising the following steps:

[0042] Identify business bill images, extract bill information and generate bill structured data. The structured data includes the main information and bill details of the bill.

[0043] Upload the bank statement, extract the key information on the bank statement to generate bank statement structured data, perform an automatic reconciliation process with the bill structured data, and generate a reconciliation preview for indicating whether the reconciliation is successful.

[0044] The accountant checks whether the reconciliation preview is correct. If it is correct, click the mark selection button on the operation interface to mark the bill record as "reconciled"; For errors caused by missing documents, after automatically completing the documents through the bank statement, click the mark selection button on the operation in...

Embodiment 2

[0048] This embodiment provides a better implementation mode of the present invention to improve the efficiency of account reconciliation.

[0049] see Figure 2-5 , the business bill image is scanned and recognized by an OCR optical character recognizer; the bill structured data includes bill master information structured data and bill detail structured data, and the bill master information structured data is the main information of the bill, mainly The information includes company name, check number, invoice date, and total invoice amount; the detailed structural data of the bill is the detailed accounting data under the bill, including the detail number, amount direction, and detailed amount.

[0050] Further, the automatic reconciliation step is as follows: compare the key information in the bank statement structured data with the note structured data one by one. In this embodiment, the key information includes amount direction, check number, invoice Date and amount detai...

Embodiment 3

[0055] see figure 1 A device for automatically completing account data based on bank statement data includes a memory and a processor, the memory stores instructions, and the instructions are adapted to be loaded by the processor and perform the following steps:

[0056] Identify business bill images, extract bill information and generate bill structured data. The structured data includes the main information and bill details of the bill.

[0057] Upload the bank statement, extract the key information on the bank statement to generate bank statement structured data, perform an automatic reconciliation process with the bill structured data, and generate a reconciliation preview for indicating whether the reconciliation is successful.

[0058] The accountant checks whether the reconciliation preview is correct. If it is correct, click the mark selection button on the operation interface to mark the bill record as "reconciled"; For errors caused by missing documents, after autom...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method for automatically completing accounting data based on bank statement data. Firstly, the service bill image is identified and bill information is extracted to generatebill structured data. Then uploading the bank statement, extracting the key information on the bank statement to generate the structured data of the bank statement, and performing automatic reconciliation process with the structured data of the bill to generate a reconciliation preview for indicating whether the reconciliation is successful or not; The accountant then checks to see if the reconciliation preview is correct; If it is correct, mark this bill record as Reconciled; if it is incorrect, check the error cause; if it is small in amount but not bookkept and the document is lost, mark this bill record as Reconciled after the document is automatically filled in through the bank statement; if it is not posted or issued by the bank, mark this bill record as Outstanding Account; Finally, the marked bill records will be recorded, and bank balance reconciliation table will be generated automatically to complete reconciliation.

Description

technical field [0001] The invention relates to a method and equipment for automatically completing account data based on bank statement data, belonging to the field of financial and tax intelligence. Background technique [0002] The traditional bank statement reconciliation process is limited to technical reasons, there are many manual operations and the verification process is lengthy and cumbersome. [0003] The specific operation process is as figure 1 As shown, first obtain the bank statement (paper, PDF document or EXCEL document) from the bank, and then complete the accounting processing and sort out the "Bank Journal" and the bank's outstanding records of the previous period, and manually compare the "Bank Statement" and " "Bank Journal", records of outstanding accounts in the previous period, and records that meet the following conditions at the same time, mark as "reconciled" by ticking: [0004] (1) The check number or serial number is the same; (2) The directi...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06Q40/02G06Q40/00G06K9/32
CPCG06Q40/02G06Q40/125G06V20/63G06V30/10
Inventor 粱昌成连航杨惠端
Owner 厦门商集网络科技有限责任公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products