US 12,332,919 B1
Ledger reconciliation
Nathaniel Clinton Lanier, Boston, MA (US); and Devavrat Dilitkumar Shah, Newton, MA (US)
Assigned to Ikigai Labs, Inc., San Francisco, CA (US)
Filed by Ikigai Labs, Inc., San Francisco, CA (US)
Filed on Nov. 6, 2024, as Appl. No. 18/938,483.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2455 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/285 (2019.01) [G06F 16/2455 (2019.01)] 26 Claims
OG exemplary drawing
 
1. A method for storing and retrieving data in a computer memory comprising:
configuring said memory according to one or more tables for storing a plurality of records, each record having a plurality of fields, including at least a first field for representing an increase or a decrease in a first quantity;
further configuring said memory with a second column in at least one table for identifying a plurality of groups of related records for the plurality of records;
receiving first data for a first plurality of records, including for each record receiving a data column representing either an increase or a decrease in a first quantity, the records lacking data for identifying the plurality of groups of the plurality of records;
grouping records of the first plurality of records, including processing the first data to determine data for the column identifying the groups of related records, and storing said determined data in the second column in the at least one table; and
processing the first data according to grouping of records of the first plurality or records, including retrieving data in the second column;
wherein processing the first data according to grouping of records includes at least one of
determining records of the first plurality of records that belong to a same group, and
determining a record that does not belong to any group of the groups of related records, and further includes causing further processing of the data of determined record or records based on said processing of the first data;
wherein identifying the groups of related records includes computing aggregates of values of the first field in said groups of related records, and
wherein computing the aggregates includes determining a degree of balance of the first quantity according to a total of increase in the first quantity and a total decrease in the first quantity, and wherein identifying the groups includes determining a best overall balance of the first quantity over the groups of the plurality of groups.