Month-end and operational checks often mean comparing two systems’ exports. The goal is not just visual diff — it is to know which logical records exist in one file but not the other, and which matched records disagree on amount, status, or dates.
Pick the right key for your process
Use identifiers both files share: payment reference, invoice number, order id, or a composite such as entity code + document number. If keys are messy, trim whitespace and try case-insensitive matching before changing source systems.
What to look for in results
- Rows only in the “system A” export — may still be in flight or missing from B.
- Rows only in the “system B” export — duplicates, timing cuts, or mapping issues.
- Matched rows with column differences — amounts, tax codes, or status fields to research.
Export the slices you need from Columnics into Excel for tick-and-tie workpapers or tickets to engineering.