How do you ensure data integrity when importing data into accounting software?

Validate imports by reconciling control totals (counts and amounts) before and after, checking for duplicates and mapping fields to the correct nominal codes, running the import in a test/backup first, and reviewing the resulting trial balance. Opening balances and prior data must reconcile so the import doesn't corrupt the records.