IP Library Patent Application 18192428
Patent Application
App. No. 18/192,428

AI-AUGMENTED COMPOSABLE AND CONFIGURABLE MICROSERVICES FOR DETERMINING A ROLL FORWARD AMOUNT

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 None
App. No.
18/192,428
Abstract

Provided herein are methods and systems for determining a roll forward amount. The method can include identifying a starting balance, extracting reconciled data values from a database, each reconciled data value having a confidence score that indicates a confidence level that a reconciled data value of a first dataset is the same as a corresponding reconciled data value of a second dataset. The method can include identifying a first subset of the reconciled data values that are a first type and a second subset of the reconciled data values that are a second type, and determining a roll forward amount based on the starting balance, the first subset, and the second subset.

Claims (51)

1 . A method for determining a roll forward amount, wherein the method is performed by a system comprising one or more processors, the method comprising:

identifying a starting balance;

extracting a plurality of reconciled data values from a database, each of the plurality of reconciled data values having a corresponding confidence score indicating a confidence level that a reconciled data value of a first dataset of the plurality of datasets is the same as a corresponding reconciled data value of a second dataset of the plurality of datasets;

identifying a first subset of the plurality of reconciled data values that are a first type;

identifying a second subset of the plurality of reconciled data values that are a second type; and

determining a roll forward amount based on the starting balance, the first subset, and the second subset.

2 . The method of claim 1 , wherein the roll forward amount comprises a plurality of sub-amounts, each sub-amount having a confidence score.

3 . The method of claim 1 , wherein the roll forward amount is based on the plurality of data values within the first subset and the second subset having the confidence score above a predetermined threshold.

4 . The method of claim 3 , wherein the predetermined threshold is 90%.

5 . The method of claim 1 , comprising:

extracting a plurality of non-reconciled data values from the database, the non-reconciled data values each having a corresponding confidence score that is below the predetermined threshold;

computing an aggregate value based on the plurality of non-reconciled data values; and

reporting the aggregate value.

6 . The method of claim 5 , comprising determining a ratio between the aggregate value based on the plurality of non-reconciled data values and the roll forward amount.

7 . The method of claim 6 , comprising automatically retrieving additional data values from a new data source if the ratio is below a predetermined ratio threshold.

8 . The method of claim 6 , comprising triggering a human review process if the ratio is below a predetermined ratio threshold.

9 . The method of claim 1 , comprising, in response to determining the roll forward amount, automatically providing a suggestion based on the roll forward amount.

10 . The method of claim 1 , comprising classifying a plurality of data values from the plurality of datasets as reconciled or non-reconciled and storing the classified plurality of data values in the database.

11 . The method of claim 10 , wherein classifying the plurality of data values as reconciled or non-reconciled comprises:

identifying a plurality of related data values in a plurality of datasets;

determining, for each of the plurality of related data values of the first dataset:

a similarity score that indicates a degree of similarity between a respective data value of the plurality of related data values of the first dataset and a corresponding related data value of a second dataset comprising a plurality of corresponding related data values;

a confidence score that indicates a confidence level as to whether the similarity score is accurate; and

classifying the plurality of related data values of the first dataset as reconciled or non-reconciled based on the similarity score and/or the confidence score.

12 . The method of claim 11 , wherein identifying the related data values comprises:

extracting a plurality of data categories and corresponding data values from a dataset of a first data source of a plurality of data sources;

identifying one or more potential linking categories from the plurality of extracted data categories;

determining a validity of the one or more potential linking categories based on the corresponding data values of the one or more potential linking categories;

selecting one or more linking categories from the potential linking categories based on the validity of the selected one or more linking categories; and

identifying related data values between the plurality of datasets based on the selected one or more linking categories.

13 . The method of claim 12 , wherein the plurality of data sources do not share a common identifier.

14 . The method of claim 11 , wherein the plurality of datasets store data in one of a table, a report, a spreadsheet, a document, and a collection of documents.

15 . The method of claim 1 , wherein determining the roll forward amount comprises:

determining an aggregate value of the first subset of the plurality of reconciled data values;

determining an aggregate value of the second subset of the plurality of reconciled data values;

adding the aggregate value of the first subset to the starting balance to compute an intermediate value; and

subtracting the aggregate value of the second subset from the intermediate value.

16 . The method of claim 1 , wherein the determined roll forward amount is one of one of accounts receivable roll forward amount, an accounts payable roll forward amount, a fixed asset roll forward amount, and an inventory roll forward amount.

17 . The method of claim 1 , wherein the first subset corresponds to credit values and the second subset corresponds to debit values.

18 . A system for determining a roll forward amount, the system comprising one or more processors configured to cause the system to:

identify a starting balance;

extract a plurality of reconciled data values from a database, each of the plurality of reconciled data values having a corresponding confidence score indicating a confidence level that a reconciled data value of a first dataset of the plurality of datasets is the same as a corresponding reconciled data value of a second dataset of the plurality of datasets;

identify a first subset of the plurality of reconciled data values that are a first type;

identify a second subset of the plurality of reconciled data values that are a second type; and

determine a roll forward amount based on the starting balance, the first subset, and the second subset.

19 . A non-transitory computer-readable storage medium storing instructions for determining a roll forward amount, the instructions configured to be executed by a system comprising one or more processors to cause the system to:

identify a starting balance;

extract a plurality of reconciled data values from a database, each of the plurality of reconciled data values having a corresponding confidence score indicating a confidence level that a reconciled data value of a first dataset of the plurality of datasets is the same as a corresponding reconciled data value of a second dataset of the plurality of datasets;

identify a first subset of the plurality of reconciled data values that are a first type;

identify a second subset of the plurality of reconciled data values that are a second type; and

determine a roll forward amount based on the starting balance, the first subset, and the second subset.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 12, 2025
From: LI, CHUNG-SHENG; CHENG, WINNIE; FLAVELL, MARK JOHN; HAMER, NICHOLAS JOHN; DAVIES, RHODRI; GIACOMUCCI, THOMAS VINCENT; WOOLF, LACEY A.; BELTRAN, RAYMUND ANTHONY FLORAND; SHARPLES, CRAIG; CONNELLY, MATTHEW F.; LEONG, KEVIN MA; LIKENS, SCOTT; LIZOTTE, NANCY ALAYNE
To: PRICEWATERHOUSECOOPERS LLP
Reel/Frame 071271/0730 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 9, 2023
From: PRICEWATERHOUSECOOPERS LLP
To: PWC PRODUCT SALES LLC
Reel/Frame 065532/0034 →