IP Library Granted Patent US 12,423,761
Granted Patent B2
US 12,423,761 · App. 18/069,223 · Granted Sep 23, 2025

Transaction data processing systems and methods

Inventors: Delia Rusu (Wellington, NZ); Hayden Jeune (Wellington, NZ); Rebecca Dridan (Wellington, NZ); Soon-Ee Cheah (Wellington, NZ); Brett Calcott (Wellington, NZ); Zhimin Wang (Wellington, NZ); Quentin-Gabriel Thurier (Wellington, NZ); Fubiao Qin (Wellington, NZ); Niklas Patrick Pechan (Wellington, NZ)
Assignee: Xero Limited
G06Q40/12G06F40/279G06F40/284G06F40/30G06N20/00
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,423,761
App. No.
18/069,223
Granted
Sep 23, 2025
Kind
B2
Abstract

Described embodiments relate to determining a candidate financial record associated with a transaction between a first accounting entity and a second entity, and determining, using a numerical representation generation model, a numerical representation of the candidate financial record, the numerical representation generation model having been trained on a corpus generated from historical transaction records. The method further comprises providing, to a transaction attribute prediction model, the numerical representation of the candidate financial record, the transaction attribute prediction model having been trained using a dataset of previously reconciled financial records, each associated with a respective first transaction attribute; and determining, by the transaction attribute prediction model, at least one first transaction attribute associated with the candidate financial record.

Claims (56)

1. A computer-implemented method comprising:

determining, by an accounting system comprising memory, and one or more processors configured to execute instructions stored in memory, a candidate financial record associated with a transaction between a first accounting entity and a second accounting entity;

determining, by a numerical representation generation model of the accounting system, a numerical representation of the candidate financial record, the numerical representation generation model having been trained on a corpus generated from historical transaction records;

providing, by the numerical representation generation model and to a transaction attribute prediction model of the accounting system, the numerical representation of the candidate financial record, the transaction attribute prediction model having been trained using a dataset of previously reconciled financial records, each associated with a respective first transaction attribute, wherein the first transaction attributes are account code identifiers, and wherein the transaction attribute prediction model comprises an account code prediction model to determine an account code associated with the transaction;

providing, by the numerical representation generation model and to the transaction attribute prediction model, numerical representations of each of a plurality of accounting entity specified first transaction attributes, wherein the accounting entity specified first transaction attributes are accounting entity specified account code identifiers;

determining, by the transaction attribute prediction model, at least one first transaction attribute associated with the candidate financial record by determining the first transaction attribute associated with the candidate financial record as being one of the plurality of accounting entity specified first attributes, wherein the at least one first transaction attribute comprises an account code identifier; and

using, by the accounting system, the at least one first transaction attribute to: (i) reconcile the candidate financial record with a respective accounting record of the accounting system; or (ii) create a new accounting record in the accounting system;

wherein the account code prediction model comprises a neural network trained to:

determine a confidence score associated with the candidate financial record and each one of a plurality of account code identifiers associated with the first accounting entity; and

determine the at least one first transaction attribute as the account code identifiers having the highest confidence score.

2. The computer-implemented method of claim 1 , further comprising:

determining, using the numerical representation generation model, a numerical representation of the accounting entity specified first attributes, the numerical representation generation model having been trained on the corpus generated from historical transaction records.

3. The computer-implemented method of claim 1 , wherein the accounting entity specified first attributes comprises accounting system predefined first attributes.

4. The computer-implemented method of claim 1 , further comprising:

sending, to a computing device, the determined at least one first transaction attribute for presentation on a user interface of a reconciliation application.

5. The computer-implemented method of claim 4 , further comprising:

receiving, from the computing device, approval of an approved first transaction attribute of the determined at least one first transaction attributes; and

generating a reconciliation record associated with the transaction, the reconciliation record comprising the candidate financial record and the approved first transaction attribute.

6. The computer-implemented method of claim 1 , further comprising:

determining a confidence score associated with each of the determined at least one first transaction attribute; and

generating a reconciliation record associated with the transaction, the reconciliation record comprising the candidate financial record and the determined at least first transaction attributes having associated confidence scores than meet the confidence threshold.

7. The computer-implemented method of claim 1 , wherein determining the numerical representation of the candidate financial record comprises determining an average of the numerical representations of each token of a set of tokens.

8. The computer-implemented method of claim 1 , wherein the corpus for training the numerical representation generation model was generated using a combination of historical financial records and entity information associated with the respective historical financial records, and wherein the method further comprises:

determining the accounting entity associated with the candidate financial record; and

determining one or more entity attributes from an accounting entity record associated with the first accounting entity;

wherein generating a set of tokens further comprises tokenizing each of the one or more entity attributes.

9. The computer-implemented method of claim 8 , wherein the one or more entity attributes comprise any one or more of: entity type; entity industry; and entity country.

10. The computer-implemented method of claim 1 , wherein determining the numerical representation of accounting entity specified first attribute comprises determining an average of the numerical representations of each token of the set of tokens.

11. The computer-implemented method of claim 1 , wherein the candidate financial record comprises financial data including any one or more of: payee data;

transaction reference; and transaction notes.

12. The computer-implemented method of claim 1 , wherein the at least one first transaction attribute comprises an identifier of the second entity.

13. The computer-implemented method of claim 1 , wherein the neural network comprises a feedforward neural network.

14. The computer-implemented method of claim 1 , wherein the at least one first transaction attribute is an identifier of the second entity and the transaction attribute prediction model comprises an entity prediction model to predict the second entity associated with the transaction.

15. The computer-implemented method of claim 1 , wherein the plurality of accounting entity specified first attributes comprises accounting entity defined first attributes.

16. An accounting 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 candidate financial record associated with a transaction between a first accounting entity and a second entity;

determine, using a numerical representation generation model, a numerical representation of the candidate financial record, the numerical representation generation model having been trained on a corpus generated from historical transaction records;

provide, to a transaction attribute prediction model, the numerical representation of the candidate financial record, the transaction attribute prediction model having been trained using a dataset of previously reconciled financial records, each associated with a respective first transaction attribute, wherein the first transaction attributes are account code identifiers, and wherein the transaction attribute prediction model comprises an account code prediction model to determine an account code associated with the transaction;

provide, to the transaction attribute prediction model, numerical representations of each of a plurality of accounting entity specified first attributes, wherein the accounting entity specified first transaction attributes are accounting entity specified account code identifiers;

determine, by the transaction attribute prediction model, at least one first transaction attribute associated with the candidate financial record by determining the first transaction attribute associated with the candidate financial record as being one of the plurality of accounting entity specified first attributes wherein the at least one first transaction attribute comprises an account code identifier; and

use, the at least one first transaction attribute to: (i) reconcile the candidate financial record with a respective accounting record of the accounting system; or (ii) create a new account record in the accounting system;

wherein the account code prediction model comprises a neural network trained to:

determine a confidence score associated with the candidate financial record and each one of a plurality of account code identifiers associated with the first accounting entity; and

determine the at least one first transaction attribute as the account code identifiers having the highest confidence score.

17. A computer-readable storage medium storing instructions that, when executed by a computer, cause the computer to perform operations including:

determining a candidate financial record associated with a transaction between a first accounting entity and a second entity;

determining, using a numerical representation generation model, a numerical representation of the candidate financial record, the numerical representation generation model having been trained on a corpus generated from historical transaction records;

providing, to a transaction attribute prediction model, the numerical representation of the candidate financial record, the transaction attribute prediction model having been trained using a dataset of previously reconciled financial records, each associated with a respective first transaction attribute, wherein the first transaction attributes are account code identifiers, and wherein the transaction attribute prediction model comprises an account code prediction model to determine an account code associated with the transaction;

providing, to the transaction attribute prediction model, numerical representations of each of a plurality of accounting entity specified first attributes, wherein the accounting entity specified first transaction attributes are accounting entity specified account code identifiers;

determining, by the transaction attribute prediction model, at least one first transaction attribute associated with the candidate financial record by determining the first transaction attribute associated with the candidate financial record as being one of the plurality of accounting entity specified first attributes wherein the at least one first transaction attribute comprises an account code identifier; and

using, the at least one first transaction attribute to: (i) reconcile the candidate financial record with a respective accounting record of the accounting system; or (ii) create a new account record in the accounting system;

wherein the account code prediction model comprises a neural network trained to:

determine a confidence score associated with the candidate financial record and each one of a plurality of account code identifiers associated with the first accounting entity; and

determine the at least one first transaction attribute as the account code identifiers having the highest confidence score.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 20, 2022
From: RUSU, DELIA; JEUNE, HAYDEN; DRIDAN, REBECCA; CHEAH, SOON-EE; CALCOTT, BRETT; WANG, ZHIMIN; THURIER, QUENTIN-GABRIEL; QIN, FUBIAO; PECHAN, NIKLAS PATRICK
To: XERO LIMITED
Reel/Frame 062165/0437 →
Priority Claims (1)
AU 2020904805 · Dec 23, 2020 · national
Continuity (5)
Continuation 17749135 · May 20, 2022
Continuation 17693300 · Mar 11, 2022
Continuation PCTNZ2021050151 · Aug 25, 2021
Continuation PCTNZ2021050151 · Aug 25, 2021
Related Publication 20230123072A1 · Apr 20, 2023
References Cited (89)
US 4948174A · Thomson · 1990 [cited by examiner]
US 7206768B1 · deGroeve · 2007 [cited by examiner]
US 7483871B2 · Herz · 2009 [cited by examiner]
US 7536354B1 · deGroeve · 2009 [cited by examiner]
US 7912702B2 · Bennett · 2011 [cited by examiner]
US 8458067B2 · Arguelles · 2013 [cited by examiner]
US 8712887B2 · DeGroeve · 2014 [cited by examiner]
US 8930295B2 · Campbell · 2015 [cited by examiner]
US 9323784B2 · King · 2016 [cited by examiner]
US 9324119B2 · Singh · 2016 [cited by examiner]
US 9563920B2 · Lall · 2017 [cited by examiner]
US 9984344B2 · Singh · 2018 [cited by examiner]
US 10204312B2 · Singh · 2019 [cited by examiner]
US 10276170B2 · Gruber · 2019 [cited by examiner]
US 10318882B2 · Brueckner · 2019 [cited by examiner]
US 10664785B2 · Gill · 2020 [cited by examiner]
US 10740561B1 · Cao et al. · 2020 [cited by applicant]
US 10741185B2 · Gruber · 2020 [cited by examiner]
US 10789034B2 · Rao · 2020 [cited by examiner]
US 11416867B2 · Lopes · 2022 [cited by examiner]
US 11481689B2 · Dong et al. · 2022 [cited by applicant]
US 11868436B1 · Gokalp · 2024 [cited by examiner]
US 20030037041A1 · Hertz · 2003 [cited by examiner]
US 20070061260A1 · deGroeve · 2007 [cited by examiner]
US 20080052078A1 · Bennett · 2008 [cited by examiner]
US 20100057502A1 · Arguelles · 2010 [cited by examiner]
US 20110153653A1 · King · 2011 [cited by examiner]
US 20120303562A1 · Paguio · 2012 [cited by examiner]
US 20130091052A1 · Kaperdal · 2013 [cited by examiner]
US 20140074762A1 · Campbell · 2014 [cited by examiner]
US 20140279304A1 · Lall · 2014 [cited by examiner]
US 20160078361A1 · Brueckner · 2016 [cited by examiner]
US 20170012418A1 · Roux et al. · 2017 [cited by applicant]
US 20170236080A1 · Singh · 2017 [cited by examiner]
US 20170315767A1 · Rao · 2017 [cited by examiner]
US 20170330121A1 · Sullivan · 2017 [cited by examiner]
US 20180030060A1 · Petrukhin et al. · 2018 [cited by applicant]
US 20180285773A1 · Hsiao et al. · 2018 [cited by applicant]
US 20180314996A1 · Singh · 2018 [cited by examiner]
US 20180330412A1 · Fredriksson · 2018 [cited by examiner]
US 20190066204A1 · Teixeira · 2019 [cited by examiner]
US 20190066214A1 · Teixeira · 2019 [cited by examiner]
US 20190066215A1 · Teixeira · 2019 [cited by examiner]
US 20190066216A1 · Teixeira · 2019 [cited by examiner]
US 20190121904A1 · Gilling et al. · 2019 [cited by applicant]
US 20190244147A1 · Singh · 2019 [cited by examiner]
US 20190251057A1 · Robinson · 2019 [cited by examiner]
US 20190251058A1 · Robinson · 2019 [cited by examiner]
US 20200073882A1 · Guggilla et al. · 2020 [cited by applicant]
US 20200074565A1 · Dotter · 2020 [cited by examiner]
US 20200097812A1 · Csar et al. · 2020 [cited by applicant]
US 20200098053A1 · Lesner et al. · 2020 [cited by applicant]
US 20200210899A1 · Guo · 2020 [cited by applicant]
US 20200311816A1 · Calvin · 2020 [cited by examiner]
US 20200410583A1 · Hart · 2020 [cited by examiner]
US 20210011677A1 · Rao · 2021 [cited by examiner]
US 20210027392A1 · Goyal · 2021 [cited by examiner]
US 20210073847A1 · Whatley · 2021 [cited by examiner]
US 20210350382A1 · Lopes · 2021 [cited by examiner]
US 20220028010A1 · Jeske · 2022 [cited by examiner]
US 20220044313A1 · Cox · 2022 [cited by examiner]
US 20220103589A1 · Shen · 2022 [cited by examiner]
US 20220108262A1 · Cella · 2022 [cited by examiner]
US 20220351302A1 · Rusu et al. · 2022 [cited by applicant]
JP 2018198046A · 2018 [cited by examiner]
WO WO2006017630A2 · 2006 [cited by examiner]
WO WO2007033095A2 · 2007 [cited by examiner]
WO WO2007112374A2 · 2007 [cited by examiner]
WO WO2008036998A1 · 2008 [cited by examiner]
WO 2022139595A1 · 2022 [cited by applicant]
Tookitaki. “What is data reconciliation and what is it used for in finance?”. (May 20, 2020). Retrieved online Aug. 23, 2022. https://www.tookitaki.com/compliance_hub/what-is-reconciliation/ (Year: 2020). [cited by examiner]
Scor. “P&C loss development triangles and reserves as of Dec. 2019.” (2019). Retrieved online Aug. 23, 2022. https://www.scor.com/en/download/file?token=def502000af358d4c35cb6e36e1e747623a0f0c3c06f93e75768ec914fb31fe1cf… [cited by examiner]
Efrag. “Accounting for Crypto-Assets (Liabilities): Holder and Issuer Perspective.” (Jul. 2020). https://www.efrag.org/Assets/Download?assetUrl=/sites/webpublishing/SiteAssets/EFRAG%2520Discussion%2520Paper-Accounting%2… [cited by examiner]
Michael Casey et al. “The Impact of Blockchain Technology on Finance: A Catalyst for Change.” (2018). Retrieved online Aug. 23, 2022. https://www.sipotra.it/wp-content/uploads/2018/07/The-Impact-of-Blockchain-Technology… [cited by examiner]
Lavinia Andreea Samoila. “Multiple Entity Reconciliation.” (Sep. 2015). Retrieved online Aug. 23, 2022. http://www.diva-portal.org/smash/get/diva2:928531/FULLTEXT01.pdf (Year: 2015). [cited by examiner]
Casey, M., et al., “The Impact of Blockchain Technology on Finance: A Catalyst for Change”, Geneva Reports on the World Economy 21, pp. 106, (2018). [cited by applicant]
Efrag, “Accounting for Crypto-Assets (Liabilities): Holder and Issuer Perspective”, pp. 152, (Jul. 2020). [cited by applicant]
Samoila, A. L., “Multiple Entity Reconciliation”, KTH Royal Institute of Technology VionLabs, Stockholm, pp. 63, (Sep. 2015). [cited by applicant]
Scor, “P&C loss development triangles and reserves as of Dec. 2019”, pp. 1-24 (2019). [cited by applicant]
Tookitaki, “What is data reconciliation and what is it used for in finance?”, pp. 07, (May 20, 2020). [cited by applicant]
Weinberger, K., et al., “Feature Hashing for Large Scale Multitask Learning”, CML '09: Proceedings of the 26th Annual International Conference on Machine Learning Jun. 14-18, 2009, pp. 1113-1120, (Jun. 2009). [cited by applicant]
International Search Report and Written Opinion as issued in connection with International Patent Application No. PCT/NZ21/050151, mailed Dec. 20, 2021, 17 pages. [cited by applicant]
Non-Final Office Action in U.S. Appl. No. 17/749,135 mailed on Aug. 26, 2022, 14 pages. [cited by applicant]
Notice of Allowance in U.S. Appl. No. 17/749,135 mailed on Nov. 30, 2022, 14 pages. [cited by applicant]
Non-Final Office Action in U.S. Appl. No. 17/693,300 mailed on Mar. 13, 2024, 27 pages. [cited by applicant]
Non-Final Office Action in U.S. Appl. No. 17/842,523 mailed on Mar. 13, 2024, 27 pages. [cited by applicant]
Final Office Action in U.S. Appl. No. 17/693,300 mailed on Aug. 27, 2024, 34 pages. [cited by applicant]
Final Office Action in U.S. Appl. No. 17/842,523 mailed on Sep. 6, 2024, 32 pages. [cited by applicant]
Extended European Search Report in European Application No. 21911642.3 mailed Oct. 22, 2024, 12 pages. [cited by applicant]