Sounds like a terrible system that forces duplicate data entry, why not improve the existing system and connect the dots that way? The sad part is that it sounds like the existing systems make it too easy for the bad actors to explain their discrepancy with ignorance or negligence instead of willful data manipulation.