# US 12,182,132 B2 · System and method of generating data for populating or updating accounting databases based on digitized accounting source documents

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 12,182,132 B2
- Document ID: US12182132B2
- Status: Granted
- Kind: B2
- Application number: 18/271,733
- Filed: 2021-12-21
- Published: 2024-03-07
- Granted: 2024-12-31
- Earliest claimed: 2021-01-27
- Assignees: MSCPW Corporation
- Applicants: MSCPW Corporation
- Inventors: Yang Mi; Ling Sun
- Web page: https://patentgrep.com/patent/US12182132B2

## CPC

- G06F 16/24575: {using context}
- G06F 16/93: Document management systems
- G06F 16/288: {Entity relationship models}
- G06Q 10/10: Office automation; Time management
- G06Q 30/04: Billing or invoicing
- G06Q 40/12: Accounting
- G06F 40/186: Templates
- G06F 40/205: Parsing
- G06F 40/279: Recognition of textual entities
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- 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

## Abstract

To generate data for populating/updating accounting databases based on digitized accounting source documents, access to an entity database comprising identifiers of entities associated with an accounting database and to a digital template library comprising processing templates for processing digitized accounting source documents is provided. Each entity in the entity database is associated with one processing template. A processor receives digitized data representing a digitized accounting source document; determines if the digitized data comprises an entity identifier that matches a particular identifier of a particular entity in the entity database; and in response to determining that the entity identifier matches the particular identifier of the particular entity in the entity database, retrieves from the template library a particular processing template associated with the particular entity; and processes the digitized data to generate processed data, according to the particular processing template, for populating/updating the accounting database.

## Claims

### Claim 1

A computer-assisted method of generating data for populating or updating accounting databases based on digitized accounting source documents, the method comprising, at a processor:
providing access to an entity database comprising identifiers of entities associated with an accounting database;
providing access to a digital template library comprising a plurality of processing templates for processing digitized accounting source documents, wherein each one of the entities in the entity database is associated with one of the processing templates;
receiving digitized data representing a digitized accounting source document;
determining if the digitized data comprises an entity identifier that matches a particular identifier of a particular entity in the entity database; and
in response to determining that the entity identifier matches the particular identifier of the particular entity in the entity database,
retrieving from the template library a particular processing template associated with the particular entity; and
processing the digitized data to generate processed data, according to the particular processing template, for populating or updating the accounting database based on the processed data,
wherein the accounting database comprises an inventory database and a non-inventory database, and the template library comprises a first set of processing templates for processing an inventory type of digitized accounting source documents and a second set of processing templates for processing a non-inventory type of digitized accounting source documents.

### Claim 2 (depends on 1)

The method of claim 1, wherein the determining comprises:
parsing the digitized data to locate a text string matching a keyword from a list of pre-defined keywords; and
parsing text or numerical strings located adjacent to the text string matching the keyword to identify the entity identifier.

### Claim 3 (depends on 1)

The method of claim 1, wherein the determining comprises:
(a) parsing the digitized data to identify a tax number as the entity identifier;
(b) parsing the digitized data to identify a business name as the entity identifier;
(c) parsing the digitized data to identify a uniform resource locator as the entity identifier; or
(d) selecting a record from the entity database,
(i) searching the digitized data for presence of a phone number matching a phone number from the selected record, and
(ii) if a matching phone number is present in the digitized data, identifying the entity associated with the selected record as the particular entity, otherwise iteratively selecting another record from the entity database and repeating (i) and (ii).

### Claim 4 (depends on 1)

The method of claim 1, wherein the particular processing template comprises format and content information indicative of a format and possible content in original accounting source documents issued by the particular entity.

### Claim 5 (depends on 4)

The method of claim 4, wherein the particular processing template defines an alias for a standard keyword, and wherein the processing comprises parsing the digitized data to locate the alias in the digitized accounting source document.

### Claim 6 (depends on 4)

The method of claim 4, wherein the particular processing template comprises relative location information for locating data information associated with a specific keyword or an alias thereof, wherein the processing comprises locating the data information associated with the specific keyword or the alias thereof in the digitized accounting source document based on the location of the specific keyword or the alias thereof and the relative location information.

### Claim 7 (depends on 4)

The method of claim 4, wherein the digitized accounting source document lists one or more lines of product, each line of product comprising a product identifier and an associated cost, and the particular processing template comprises a specific phrase for locating the first line in the one or more lines of product, and wherein the processing comprises:
parsing the digitized data to locate the line containing the specific phrase in the digitized accounting source document,
locating, based on the location of the line containing the specific phrase, the first line, and
parsing, line-by-line, starting from the first line, the one or more lines of product to obtain the product identifier and associated cost in each line of product.

### Claim 8 (depends on 4)

The method of claim 4, wherein the particular processing template is generated based on a base template, the base template defining a plurality of fields to be populated in the accounting database.

### Claim 9 (depends on 8)

The method of claim 8, wherein the particular processing template is modified from the base template based on user input.

### Claim 10 (depends on 4)

The method of claim 4, wherein the particular processing template is generated based on another processing template and modified based on user input.

### Claim 11 (depends on 8)

The method of claim 8, wherein the plurality of fields comprise mandatory fields, and the method further comprising automatically verifying values in the processed data for completeness and accuracy, based on an internal relationship among the digitized data, or based on one or more pre-defined verification rules.

### Claim 12 (depends on 1)

The method of claim 1, wherein each one of the first set of processing templates comprises information for identifying an inventory item and a unit of measure of the inventory item in the digitized data and instruction for determining a quantity of units of the inventory item indicated in the digitized accounting source document.

### Claim 13 (depends on 1)

The method of claim 1, wherein the digitized data is generated from a digitized document, wherein the digitized document comprises a plurality of ordered data structures representing multiple original accounting source documents, each original accounting source document represented by a pre-defined number of adjacent data structures in the ordered data structures, wherein generation of the digitized data comprises merging the pre-defined number of adjacent data structures in the digitized document to produce a single data structure representing the each original accounting source document.

### Claim 14 (depends on 13)

The method of claim 13, wherein the digitized document is a tabulated document, and the ordered data structures are tabs in the tabulated document, each one of the tabs representing a single page in one of the multiple original accounting source documents.

### Claim 15 (depends on 13)

The method of claim 13, wherein the digitized document has a document name and the pre-defined number is based on an upload parameter.

### Claim 16 (depends on 13)

The method of claim 13, wherein the single data structure is stored as a single tab in a saved tabulated document, or as a separate single document.

### Claim 17 (depends on 1)

The method of claim 1, comprising populating or updating the accounting database using the processed data.

### Claim 18 (depends on 1)

A computer system comprising:
a processor; and
a processor-readable medium storing thereon processor executable instructions that when executed by the processor adapt the processor to perform the method of claim 1,
the accounting database,
the entity database, and
the template library.

### Claim 19 (depends on 1)

A computer readable medium storing thereon processor executable instructions that when executed by a processor perform the method of claim 1.