01 / Prepare the files
Keep the source behind every record.
The local workflow accepts bank, invoice and recorded-payment CSVs. Map columns and select the date format while retaining the original file and source identifiers for later investigation.
- Use one entity, account and completed period for the review set.
- Keep invoice IDs and existing payment allocations in the exports.
- Treat each file as a complete snapshot for its record type.
02 / Check the records
See invalid rows before they enter the set.
Validation separates included, excluded and invalid records and shows the totals. Duplicate identifiers and formatting errors remain visible so the preparer can correct the source file.
- Inspect the validation result and affected rows.
- Resolve blocking errors before committing the snapshot.
- Keep repeated imports and deliberate replacements distinct.
03 / Retain the history
Make a corrected import traceable.
A replacement is an explicit step. Previous versions and import history remain available in the local implementation, so the team can distinguish the active record set from earlier files.
- Review the active snapshot and its source file.
- Use search and filters to inspect the imported records.
- Keep reconciliation and accounting sign-off in your existing process.