Any existing programs that track the origin of data in your database?
The answer to the "systems/practices" would be to include a column with all data that is imported that signifies its source.

As for whether the issue was caused by your cleaning process, you simply need to save or log the changes that were made to each row, or enable change tracking.  Any of these solutions will introduce overhead that will affect performance, so let's be careful out there!