| Usefulness size limitation | |
It is usually best to try to match out netting numbers using references as detailed as possible,
E.g. Invoice Number/Contract Number/Customer/Date.
But the relevant information is not always available, which is why you are on this site.
One of the challenges of matching on Values, is that as a list of numbers get longer, there is more chance of matches that are Coincidental,
rather than meaningful.
This risk reduces as the individual Values get larger.
Here is a diagram giving an indication of how likely such Coincidental Matches are, for
completely random numbers.
The fact that most matching done with Sotozeo for accounting is many-to-one rather than many-to-many shifts the green area somewhat to the right,
which is helpful.
E.g. if your numbers average 3,000.00 then immediately finding only the meaningful match is typically highly likely up to 25 lines,
and fairly likely up to 30 lines.
This graph is only an indication - your particular numbers may give very different results,
E.g. the fewer Values with the minority sign,
the longer the list that will avoid Coincidental Matches:
See these two extreme examples:
| Values | Lines | Solutions |
| 2, 3, 5, 8, 13, 21, 34, 55, 89, -7, -11, -18, -29, -47, -76, -144, -151 |
17 | 78 |
| 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29,
30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 1048, 1049, -2097 |
50 | 1 |
|