US5134564A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Computer aided reconfiliation method and apparatus
Assignee: Intuit Inc
•
Filing: 1989-10-19
•
Granted: 1992-07-28
•
Expires: 2009-10-19
Abstract
Abstract A method of reconciling a first list (a bank statement) formed of a first number of first records and a second list (bank customer's list of records) formed of a second number of second records where the records affect the account balance for the bank statement. For each unmatched record in the first list, a corresponding record from the second list is selected based upon a match value. Whenever the match value exceeds a threshold value, the corresponding records from the first and second lists are paired and thereafter, are removed from further reconciliation processing. The highest match value resulting from comparing record elements and other attributes of records from the first and second lists is determined as a probable match for reconciliation.
Inventors
- 👤 Eric C. W. Dunn
- 👤 Thomas A. Proulx
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 11:44
CPC Classifications
G; G06; G06Q; G06Q40/00; G06Q40/02; G06Q40/12; G06Q40/128
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
255 words
A method of reconciling in a computer a first list formed of a first number of first records in the computer with a second list formed of a second number of second records in the computer where, except for errors or omissions, each of said first records is identical to a corresponding one of said second records, the method comprising: for each one of said first records, comparing said one of said first records with one or more of said second records to determine match scores, one match score for each compared one of said second records, each match score designating the probability said one of said first records corresponds to the compared one of said second records, for each one of said first records having a match score exceeding a predetermined pairing threshold, pairing said one of said first records with the compared one of said second records whereby said one of said first records and the compared one of said second records are reconciled, for each one of said first records not having a match score exceeding said predetermined pairing threshold, matching said one of said first records with a group of second records where said group of second records is determined based upon the magnitudes of corresponding match scores for said second records, accepting or rejecting the pairing of said one of said first records with one of said second records in said group whereby, upon accepting, said one of said first records and the compared one said second records are reconciled.
Claim 2
Independent Claim
255 words
A method of reconciling in a computer a first list formed of a first number of first records in the computer with a second list formed of a second number of second records in the computer where, except for errors or omissions, each of said first records is identical to a corresponding one of said second records, the method comprising: for each one of said first records, comparing said one of said first records with one or more of said second records to determine match scores, one match score for each compared one of said second records, each match score designating the probability said one of said first records corresponds to the compared one of said second records, for each one of said first records having a match score exceeding a predetermined pairing threshold, pairing said one of said first records with the compared one of said second records whereby said one of said first records and the compared one of said second records are reconciled, for each one of said first records not having a match score exceeding said predetermined pairing threshold, matching said one of said first records with a group of second records where said group of second records is determined based upon the magnitudes of corresponding match scores for said second records, accepting or rejecting the pairing of said one of said first records with one of said second records in said group whereby, upon accepting, said one of said first records and the compared one said second records are reconciled.
Claim 3
Dependent Claim
23 words
The method of reconciling the first list and the second list of claim 1 wherein said accepting step is performed under user control.
Claim 4
Dependent Claim
66 words
The method of reconciling the first list and the second list of claim 1 further including, for one or more of said first records not paired with a second record, adding under user control a new second record to said second list corresponding to one of said first records whereby said one of said first records and the compared one of said second records are reconciled.
Claim 5
Dependent Claim
43 words
The method of reconciling the first list and the second list of claim 1 wherein said matching step is performed by determining said group to include only ones of said second records having match scores between said pairing threshold and an exclusion threshold.
Claim 6
Dependent Claim
52 words
The method of reconciling the first list and the second list of claim 1 wherein said matching step is performed by determining said group to include only a limited number of ones of said second records and to include ones of said second records having match scores closest to said pairing threshold.
Claim 7
Dependent Claim
183 words
The method of reconciling the first list and the second list of claim 1 wherein, said first list L1 has N first records designated R1(1), R1(2), . . . , R1(r1), . . . , R1(N); where each one of said records R1(r1) is formed of P elements E1(1), E1(2), E1(3), . . . , E1(e), . . . , E1(P), said second list L2 has M second records designated R2(1), R2(2), . . . , R2(r2), . . . , R2(M); where each one of said records R2(r2) is formed of P elements E2(1), E2(2), E2(3), . . . , E2(e), . . . , E2(P), said comparing step is performed for each first record R1(r1) by Q element comparing steps C(q), for q from 1,2, . . . , Q, whereby for each first record R1(r1) each of the first elements E1(e), for e from 1, 2, . . . , U, is compared with each of the second elements E2(e), for e from 1, 2, . . . , U, respectively, for the compared one of said second records R2(r2).
Claim 8
Dependent Claim
57 words
The method of reconciling the first list and the second list of claim 6 wherein the results of each element comparing step C(q) is a probability value P(1), for q from 1, 2, . . . , Q, and where said match score is the SUM P(q) for q from 1, 2, . . . , Q.
Claim 9
Dependent Claim
48 words
The method of reconciling the first list and the second list of claim 6 wherein said first list is a bank statement for a checking account, said second list is a customer's account information, and said elements include a date element, a check element and an amount element.
Claim 10
Dependent Claim
52 words
The method of reconciling the first list and the second list of claim 8 wherein said element comparing includes comparing to determine if the amount in the amount element of a first record R1(r1) is within an amount range of an amount in a corresponding amount element of a second record R2(r2).
Claim 11
Dependent Claim
161 words
The method of reconciling the first list and the second list of claim 9 wherein said element comparing for each first record R1(r1) with a second record R2(r2) includes, setting a probability value P date as a function of whether the date in the date element of said first record is within a date range of a date in a corresponding date element of said second record, setting a probability value P amount as a function of whether the amount in the amount element of said first record is within a amount rage of a amount in a corresponding amount element of said second record, setting a probability value P number as a function of whether the number in the number element of said first record is the same as the number in a corresponding number element of said second record, forming the match score MS equal to the sum of P date , P amount , and P number .
Claim 12
Dependent Claim
150 words
The method of reconciling the first list and the second list of claim 9 wherein said element comparing for each first record R1(r1) with a second record R2(r2) includes, setting a Date Score, P date (d1,d2,c1), probability value as a function of comparing the dates in the date elements d1 and d2 of R1(r1) and R2(r2), respectively, as a function of the number element, c1, of record R1(r1), setting an Amount Score, P amount (a1,a2), probability value as a function of comparing the amounts in the amount elements a1 and a2 of records R1(r1) and R2(r2), respectively, setting a Number Score, P number (c1,c2), probability value as a function of comparing the numbers in the number elements c1 and c2 of the records R1(r1) and R2(r2), respectively, forming the match score MS(r1,r2) as follows: if P date (d1,d2,c1)=0, MS(r1,r2)=0. if P date (d1,d2)=0, MS(r1,r2)=(P date (d1,d2,c1)+P amount (a1,a2)+P number (c1,c2))/3.
Claim 13
Dependent Claim
55 words
The method of reconciling the first list and the second list of claim 11 wherein the Date Score, P date (d1,d2,c1), is determined as one of the date score probability values sd i where i has one of the values 1, 2, . . . , 6 and where dd equals (d1-d2) as follows: ##STR7##
Claim 14
Dependent Claim
147 words
The method of reconciling the first list and the second list of claim 11 wherein the Amount Score, P amount (a1,a2), is determined as one of the amount score probability values sa i where i has one of the values 1, 2, . . . , 26, where g1 equals the sign of a1, where g2 equals the sign of a2, where l1 equals the number of digits in a1, where l2 equals the number of digits in a2, where D equals the number of digits differing in a1 and a2, and where T equals the sum of the arithmetic digit-wise difference between a1 and a2 as follows: ______________________________________
g1 = g2
g1 ≠ g2
______________________________________
##STR8## sa.sub.1 sa.sub.3 sa.sub.5 sa.sub.7 sa.sub.9
sa.sub.2 sa.sub.4 sa.sub.6 sa.sub.8
sa.sub.10
##STR9## sa.sub. 11 sa.sub.13 sa.sub.15 sa.sub.17
sa.sub.12 sa.sub.14 sa.sub.16 sa.sub.18
##STR10## sa.sub.19 sa.sub.21 sa.sub.23 sa.sub.25
sa.sub.20 sa.sub.22 sa.sub.24 sa.sub.26.
______________________________________
Claim 15
Dependent Claim
52 words
The method of reconciling the first list and the second list of claim 11 wherein the Number Score, P number (c1, c2), is determined as one of the number score probability values sn i , where i has one of the values 1, 2, . . . , 6, as follows: ##STR11##
Claim 16
Independent Claim
436 words
A method of reconciling in a computer a first list formed of a first number of first records in the computer with a second list formed of a second number of second records in the computer where, said first list L1 has N first records designated R1(1), R1(2), . . . , R1(r1), . . . , R1(N); where each one of said records R1(r1) is formed of P elements E1(1), E1(2), E1(3), . . . , E1(e), . . . , E1(P), said second list L2 has M second records designated R2(1), R2(2), . . . , R2(r2), . . . , R2(M); where each one of said records R2(r2) is formed of P elements E2(1), E2(2), E2(3), . . . , E2(e), . . . , E2(P), for each one of said first records, comparing said one of said first records with one or more of said second records to determine match scores, one match score for each compared one of said second records, each match score designating the probability said one of said first records corresponds to the compared one of said second records, and wherein said first list is a statement for a first listing of an account, said second list is a second listing of said account, and said elements include a date element and an amount element, said comparing step is performed for each first record R1(r1) by Q element comparing steps C(q), for q from 1, 2, . . . Q, whereby for each first record R1(r1) each of the first elements E1(e), for e from 1, 2, . . . , U, is compared with each of the second elements E2(e), for e from 1, 2, . . . , U, respectively, for the compared one of said second records R2(r2), for each one of said first records having a match score exceeding a predetermined pairing threshold, pairing said one of said first records with the compared one of said second records whereby said one of said first records and the compared one of said second records are reconciled. for each one of said first records not having a match score exceeding said predetermined pairing threshold, matching said one of said first records with a group of second records where said group of second records is determined based upon the magnitudes of corresponding match scores for said second records, accepting or rejecting the pairing of said one of said first records with one of said second records in said group whereby, upon accepting, said one of said first records and the compared one said second records are reconciled.
Claim 17
Independent Claim
436 words
A method of reconciling in a computer a first list formed of a first number of first records in the computer with a second list formed of a second number of second records in the computer where, said first list L1 has N first records designated R1(1), R1(2), . . . , R1(r1), . . . , R1(N); where each one of said records R1(r1) is formed of P elements E1(1), E1(2), E1(3), . . . , E1(e), . . . , E1(P), said second list L2 has M second records designated R2(1), R2(2), . . . , R2(r2), . . . , R2(M); where each one of said records R2(r2) is formed of P elements E2(1), E2(2), E2(3), . . . , E2(e), . . . , E2(P), for each one of said first records, comparing said one of said first records with one or more of said second records to determine match scores, one match score for each compared one of said second records, each match score designating the probability said one of said first records corresponds to the compared one of said second records, and wherein said first list is a statement for a first listing of an account, said second list is a second listing of said account, and said elements include a date element and an amount element, said comparing step is performed for each first record R1(r1) by Q element comparing steps C(q), for q from 1, 2, . . . Q, whereby for each first record R1(r1) each of the first elements E1(e), for e from 1, 2, . . . , U, is compared with each of the second elements E2(e), for e from 1, 2, . . . , U, respectively, for the compared one of said second records R2(r2), for each one of said first records having a match score exceeding a predetermined pairing threshold, pairing said one of said first records with the compared one of said second records whereby said one of said first records and the compared one of said second records are reconciled. for each one of said first records not having a match score exceeding said predetermined pairing threshold, matching said one of said first records with a group of second records where said group of second records is determined based upon the magnitudes of corresponding match scores for said second records, accepting or rejecting the pairing of said one of said first records with one of said second records in said group whereby, upon accepting, said one of said first records and the compared one said second records are reconciled.
Claim 18
Dependent Claim
47 words
The method of reconciling the first list and the second list of claim 15 wherein said element comparing includes string match comparing to determine if an element of a first record R1(r1) is the same or as similar to a corresponding element of a second record R2(r2).
Claim 19
Dependent Claim
25 words
The method of reconciling the first list and the second list of claim 16 wherein said string match comparing includes comparing to detect added characters.
Claim 20
Dependent Claim
25 words
The method of reconciling the first list and the second list of claim 16 wherein said string match comparing includes comparing to detect missing characters.
Claim 21
Dependent Claim
26 words
The method of reconciling the first list and the second list of claim 16 wherein said string match comparing includes comparing to detect transposition of characters.
Claim 22
Dependent Claim
51 words
The method of reconciling the first list and the second list of claim 15 wherein said element comparing includes comparing to determine if the date in the date element of a first record R1(r1) is within a date range of date in a corresponding date element of a second record R2(r2).
Claim 23
Independent Claim
307 words
A method of reconciling in a computer a first list formed of a first number of first records in the computer with a second list formed of a second number of second records in the computer where, except for errors or omissions, each of said first records is identical to a corresponding one of said second records, the method comprising, for each one of said first records, comparing said one of said first records with one or more of said second records to determine match scores, one match score for each compared one of said second records, each match score designating the probability said one of said first records corresponds to the compared one of said second records, for each one of said first records having a match score exceeding a predetermined pairing threshold, pairing said one of said first records with the compared one of said second records whereby said one of said first records and the compared one of said second records are reconciled, for each one of said first records having a match score between said predetermined pairing threshold and an exclusion threshold, matching said one of said first records with a group of second records where said group of second records is determined based upon the magnitudes of corresponding match scores for said second records, displaying to a user on a computer terminal said group of second records in an order based upon the magnitudes of corresponding match scores for said second records whereby the user is presented with records for pairing in the order of most likely correspondence of records, accepting or rejecting the pairing of said one of said first records with one of said second records in said group under user control whereby, upon accepting, said one of said first records and the compared one said second records are reconciled.
Claim 24
Independent Claim
307 words
A method of reconciling in a computer a first list formed of a first number of first records in the computer with a second list formed of a second number of second records in the computer where, except for errors or omissions, each of said first records is identical to a corresponding one of said second records, the method comprising, for each one of said first records, comparing said one of said first records with one or more of said second records to determine match scores, one match score for each compared one of said second records, each match score designating the probability said one of said first records corresponds to the compared one of said second records, for each one of said first records having a match score exceeding a predetermined pairing threshold, pairing said one of said first records with the compared one of said second records whereby said one of said first records and the compared one of said second records are reconciled, for each one of said first records having a match score between said predetermined pairing threshold and an exclusion threshold, matching said one of said first records with a group of second records where said group of second records is determined based upon the magnitudes of corresponding match scores for said second records, displaying to a user on a computer terminal said group of second records in an order based upon the magnitudes of corresponding match scores for said second records whereby the user is presented with records for pairing in the order of most likely correspondence of records, accepting or rejecting the pairing of said one of said first records with one of said second records in said group under user control whereby, upon accepting, said one of said first records and the compared one said second records are reconciled.
Claim 25
Dependent Claim
66 words
The method of reconciling the first list and the second list of claim 21 further including, for one or more of said first records not paired with a second record, adding under user control a new second record to said second list corresponding to one of said first records whereby said one of said first records and the compared one of said second records are reconciled.
Claim 26
Dependent Claim
39 words
The method of reconciling the first list and the second list of claim 21 further including generating a report summarizing the reconciliation results including a listing of unpaired records and balances of the first list and the second list.
Claim 27
Dependent Claim
32 words
The method of reconciling the first list and the second list of claim 21 further including the step of updating the second list to correct errors discovered as a result of reconciliation.
Claim 28
Dependent Claim
31 words
The method of reconciling the first list and the second list of claim 21 further including the step of updating the second list to add records as a result of reconciliation.
Claim 29
Dependent Claim
42 words
The method of reconciling the first list and the second list of claim 21 further including the step of updating the second list to indicate records in the second list paired with records in the first list as a result of reconciliation.
References Cited (Backward Citations)
US4047154A
Cited
US4417136A
Cited
US4523330A
Cited
US4737911A
Cited
US4813077A
Cited
US4866611A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1995-07-28 | 1996-01-27 | 1996-07-28 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 1999-07-28 | 2000-01-27 | 2000-07-28 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2003-07-28 | 2004-01-27 | 2004-07-28 | $7700.00 | Window Closed / Lapsed |