Short Answer: Skipped rows were ignored due to data validation issues for example 'Invalid date format'. Open the Skipped tab and a skipped row to see the exact 'Data quality issue' and raw values to fix in the source data.
PreRequisites
- You are on the 'Skipped' tab of the report
Steps
-
Open the 'Skipped' tab or click the 'Skipped' card.
You see 'Skipped – Side A' and 'Skipped – Side B' lists with issue descriptions. -
Click a skipped row to open 'Skipped transaction details' modal.
Modal opens and shows a 'Data quality issue' box with the reason for example 'Invalid date format'. -
Review the raw values in the modal Date (raw), Transaction ID, Amount (raw) and the issue text.
You can see exactly which field failed validation. -
Correct the source data by fixing date formats, providing missing dates, ensuring amounts are numeric or filling mandatory fields and re-run reconciliation.
Corrected records will be processed in the next reconciliation run.
Troubleshooting
-
Record is still skipped after correction and re-run.
LikelyCause: Updated source file was not uploaded or the wrong dataset was used.
Action: Confirm the corrected file is uploaded and then click 'Run new reconciliation'. -
Issue reads 'Invalid date format' but date looks valid.
LikelyCause: Date format in source doesn't match the expected format used by the recon.
Action: Convert dates in the source to the expected format and re-run.
Note: The modal includes the message: 'This row was skipped during reconciliation due to data validation errors. Please review and correct the source data.' Use that to guide fixes.