# US 2023/0067073 A1 · Systems and Methods for Improved Transaction Reconciliation

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

- Number: US 2023/0067073 A1
- Document ID: US20230067073A1
- Status: Published application
- Kind: A1
- Application number: 17/693,293
- Filed: 2022-03-11
- Published: 2023-03-02
- Earliest claimed: 2021-08-20
- Assignees: Xero Limited
- Applicants: Xero Limited
- Inventors: Craig McCormick; Juan Carlos Rada-Vilela; Anastasia Nadine Old; Qiuying Zhang; Stanley Roache; Rodger McNab
- Web page: https://patentgrep.com/patent/US20230067073A1

## CPC

- G06N 20/00: Machine learning
- G06Q 40/128: {Check-book balancing, updating or printing arrangements}
- G06F 16/35: Clustering; Classification
- G06Q 30/04: Billing or invoicing
- G06Q 40/02: Banking, e.g. interest calculation or account maintenance (credit or loans G06Q40/03)
- G06Q 40/12: Accounting
- G06Q 40/125: {Finance or payroll}
- G06Q 40/123: {Tax preparation or submission}
- G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
- 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
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Described embodiments relate to a method comprising determining a financial data item of a financial record to be reconciled, determining a candidate accounting record of a plurality of accounting records, and determining an accounting data item of the candidate accounting record, determining, as a first input to a classification model, a first similarity measure indicative of the similarity of the financial data item to the accounting data item, determining, as a second input to the classification model, a second similarity measure indicative of the similarity of the accounting data item to the financial data item, inputting, to the classification model, the first and second inputs, the classification model configured to determine a probability of the financial data item and the accounting data item corresponding to a common transaction, and outputting an indication of the probability of the financial data item and the accounting data item corresponding to a common transaction.

## Claims

### Claim 1

A method comprising:
determining a financial data item of a financial record to be reconciled, the financial data item comprising at least one financial data string having one or more financial data characters;
determining a candidate accounting record of a plurality of accounting records;
determining an accounting data item of the candidate accounting record, the accounting data item comprising at least one accounting data string having one or more accounting data characters;
determining, as a first input to a classification model, a first similarity measure indicative of the similarity of the financial data item to the accounting data item;
determining, as a second input to the classification model, a second similarity measure indicative of the similarity of the accounting data item to the financial data item;
inputting, to the classification model, the first and second inputs, the classification model configured to determine a probability of the financial data item and the accounting data item corresponding to a common transaction; and
outputting, from the classification model, an indication of the probability of the financial data item and the accounting data item corresponding to a common transaction.

### Claim 2 (depends on 1)

The method of claim 1, wherein determining the first similarity measure comprises determining a sum of the length of financial data strings of the financial data item that have at least two financial data characters present in the at least one accounting data string of the accounting data item, and wherein determining the second similarity measure comprises determining a sum of the length of accounting data strings of the accounting data item that have at least two accounting data characters present in the at least one financial data string of the financial data item.

### Claim 3 (depends on 1)

The method of claim 1, wherein prior to determining a sum of the length of financial data strings of the financial record, applying a first weight to number strings of the at least one financial data string and a second weight to alphabet strings of the at least one financial data string.

### Claim 4 (depends on 1)

The method of claim 1, wherein prior to determining a sum of the length of accounting data strings of the accounting record, applying a third weight to number strings of the at least one financial data string and a fourth weight to alphabet strings of the at least one financial data string.

### Claim 5 (depends on 1)

The method of claim 1, further comprising:
determining, as a third input to the classification model, an absolute date difference between an accounting date associated with the accounting data item and a financial date associated with the financial data item; and
inputting, to the classification model, the third input.

### Claim 6 (depends on 1)

The method of claim 1, further comprising:
determining, as a fourth input to the classification model, a due date associated with the accounting record; and
inputting, to the classification model, the fourth input.

### Claim 7 (depends on 1)

The method of claim 1, further comprising:
determining, as a fifth input to the classification model, a number of common data strings between the financial data item and the accounting data item; and
inputting, to the classification model, the fifth input.

### Claim 8 (depends on 1)

The method of claim 1, further comprising:
determining, as a sixth input to the classification model, a sum of the length of common data strings between the financial data item and the accounting data item; and
inputting, to the classification model, the sixth input.

### Claim 9

(canceled)

### Claim 10 (depends on 1)

The method of claim 1, comprising:
before determining the first and second inputs, pre-processing at least one of the financial data item and the accounting data item,
wherein pre-processing comprises:
determining one or more data strings of the financial data item or accounting data item that comprise alphanumeric words; and
for each determined alphanumeric word, modifying the financial data item or accounting data item to include a new data string for each numeral string comprising consecutive numerals of the alphanumeric word and a new data string for each alphabet string comprising consecutive letters of the alphanumeric word.

### Claim 11

(canceled)

### Claim 12

(canceled)

### Claim 13

(canceled)

### Claim 14

(canceled)

### Claim 15

(canceled)

### Claim 16 (depends on 1)

The method of claim 1, further comprising:
comparing the indication of the probability of the financial data item and the accounting data item of the candidate accounting record with a first threshold and a second threshold;
responsive to the indication exceeding the first threshold and the second threshold, automatically reconciling the transaction; and
responsive to the indication exceeding the first threshold but not exceeding the second threshold, presenting a suggestion for reconciling the transaction to a user via a user interface, and responsive to receiving approval from the user, reconciling the transaction.

### Claim 17

(canceled)

### Claim 18

A method comprising:
identifying a first feature and a second feature for reconciling transactions of a first entity by a classification model,
each transaction being associated with a financial data item of a financial record, and with an accounting data item of an accounting record,
where the first feature is a first similarity measure indicative of the similarity of the financial data item to a candidate accounting data item, and the second feature is a second similarity measure indicative of the similarity of the candidate accounting data item to the financial data item
training, by one or more processors, the classification model with training data, the training data comprising values for first and second features of an associated financial record and accounting record pair and an outcome indicative of whether the associated financial record and accounting record pair were previously matched as belonging to a common transaction; and
providing the trained classification model for reconciling transactions.

### Claim 19 (depends on 18)

The method of claim 18,
wherein the financial data item comprises at least one financial data string having one or more financial data characters and the accounting data item comprises at least one accounting data string having one or more accounting data character, and
wherein the first feature comprises a number of financial data strings having at least two financial data characters present in the at least one accounting data string of the accounting data item and the second feature comprises a number of accounting data strings having at least two accounting data characters present in the at least one financial data string of the financial data item.

### Claim 20

A system comprising:
one or more processors; and
memory comprising computer executable instructions, which when executed by the one or more processors, cause the system to:
determine a financial data item of a financial record to be reconciled, the financial data item comprising at least one financial data string having one or more financial data characters;
determine a candidate accounting record of a plurality of accounting records:
determine an accounting data item of the candidate accounting record, the accounting data item comprising at least one accounting data string having one or more accounting data characters;
determine, as a first input to a classification model, a first similarity measure indicative of the similarity of the financial data item to the accounting data item;
determine, as a second input to the classification model, a second similarity measure indicative of the similarity of the accounting data item to the financial data item:
input, to the classification model, the first and second inputs, the classification model configured to determine a probability of the financial data item and the accounting data item corresponding to a common transaction; and
output, from the classification model, an indication of the probability of the financial data item and the accounting data item corresponding to a common transaction.

### Claim 21

A non-transitory machine-readable storage medium including instructions that, when executed by a machine, cause the machine to perform operations including:
determining a financial data item of a financial record to be reconciled, the financial data item comprising at least one financial data string having one or more financial data characters;
determining a candidate accounting record of a plurality of accounting records:
determining an accounting data item of the candidate accounting record, the accounting data item comprising at least one accounting data string having one or more accounting data characters;
determining, as a first input to a classification model, a first similarity measure indicative of the similarity of the financial data item to the accounting data item;
determining, as a second input to the classification model, a second similarity measure indicative of the similarity of the accounting data item to the financial data item;
inputting, to the classification model, the first and second inputs, the classification model configured to determine a probability of the financial data item and the accounting data item corresponding to a common transaction; and
outputting, from the classification model, an indication of the probability of the financial data item and the accounting data item corresponding to a common transaction.

### Claim 22 (depends on 13)

The system of claim 13, wherein the computer executable instructions, which when executed by the one or more processors, cause the system to determine the first similarity measure by determining a sum of the length of financial data strings of the financial data item that have at least two financial data characters present in the at least one accounting data string of the accounting data item, and to determine the second similarity measure by determining a sum of the length of accounting data strings of the accounting data item that have at least two accounting data characters present in the at least one financial data string of the financial data item.

### Claim 23 (depends on 13)

The system of claim 13, wherein the computer executable instructions, which when executed by the one or more processors, cause the system to apply a first weight to number strings of the at least one financial data string and a second weight to alphabet strings of the at least one financial data string, prior to determining a sum of the length of financial data strings of the financial record.

### Claim 24 (depends on 13)

The system of claim 13, wherein the computer executable instructions, which when executed by the one or more processors, cause the system to applying a third weight to number strings of the at least one financial data string and a fourth weight to alphabet strings of the at least one financial data string, prior to determining a sum of the length of accounting data strings of the accounting record.

### Claim 25

A system comprising:
one or more processors; and
memory comprising computer executable instructions, which when executed by the one or more processors, cause the system to:
identify a first feature and a second feature for reconciling transactions of a first entity by a classification model, each transaction being associated with a financial data item of a financial record, and with an accounting data item of an accounting record, where the first feature is a first similarity measure indicative of the similarity of the financial data item to a candidate accounting data item, and the second feature is a second similarity measure indicative of the similarity of the candidate accounting data item to the financial data item;
train the classification model with training data, the training data comprising values for first and second features of an associated financial record and accounting record pair and an outcome indicative of whether the associated financial record and accounting record pair were previously matched as belonging to a common transaction; and
provide the trained classification model for reconciling transactions.

### Claim 26 (depends on 18)

The non-transitory machine-readable storage medium of claim 18, wherein
determining the first similarity measure comprises determining a sum of the length of financial data strings of the financial data item that have at least two financial data characters present in the at least one accounting data string of the accounting data item, and wherein determining the second similarity measure comprises determining a sum of the length of accounting data strings of the accounting data item that have at least two accounting data characters present in the at least one financial data string of the financial data item.

### Claim 27

A non-transitory machine-readable storage medium including instructions that, when executed by a machine, cause the machine to perform operations including:
identifying a first feature and a second feature for reconciling transactions of a first entity by a classification model, each transaction being associated with a financial data item of a financial record, and with an accounting data item of an accounting record, where the first feature is a first similarity measure indicative of the similarity of the financial data item to a candidate accounting data item, and the second feature is a second similarity measure indicative of the similarity of the candidate accounting data item to the financial data item;
training the classification model with training data, the training data comprising values for first and second features of an associated financial record and accounting record pair and an outcome indicative of whether the associated financial record and accounting record pair were previously matched as belonging to a common transaction; and
providing the trained classification model for reconciling transactions.111
