Short Answer: Open the Skipped tab, click a skipped row to view the issue in the Skipped modal (e.g., 'Issue detected: Missing date'), then fix the source file and re-run reconciliation.
PreRequisites
-
You have access to the uploaded bank or books files and can edit or re-upload them.
-
The reconciliation shows skipped records (a Skipped pill is visible).
Steps
-
Open the reconciliation report and click the Skipped tab.
You will see sections like 'Skipped – Bank' and 'Skipped – Books' with the note 'Records ignored due to missing or invalid data'. -
Click a skipped row in the table to open the skipped-record details modal.
The modal shows the transaction details and an 'Issue detected' message (e.g., 'Missing date'). -
Note the exact issue detected, such as:
• Missing date
• Invalid date format
• Missing amount
• Mandatory column missing -
Open your original source file (bank statement or books file) and fix the issue in that row.
Examples:
• Add a missing date
• Correct the date format
• Fill in the amount
• Fix missing or invalid values -
Re-upload the file or re-run reconciliation.
The corrected records will now be processed instead of skipped.
Troubleshooting
-
Row shows 'Issue detected: Missing date'.
Likely Cause:
• The date cell is empty for that row in the source file.
Action:
• Add a valid date in the source file and re-run reconciliation.
-
Rows show 'Invalid date format' or similar errors.
Likely Cause:
• The date value does not match the expected format.
Action:
• Correct the date format (e.g., YYYY-MM-DD) in the source file and re-run reconciliation.
-
Row shows missing or invalid amount.
Likely Cause:
• The amount column is empty or contains non-numeric values.
Action:
• Ensure the amount column contains valid numeric values and re-run reconciliation.
Note: The Skipped section clearly indicates 'Records ignored due to missing or invalid data', helping you quickly identify and fix issues before re-running reconciliation.