How to catch missing days, duplicates, and overlapping statement periods

Missing days, duplicate transactions, and overlapping statement periods can derail reconciliation. Here's how to catch and fix these issues early.

Common period issues

• Missing days: Statement shows transactions from Jan 1-28 but Jan 29-31 are missing
• Duplicates: Same transaction appears in two consecutive statements
• Overlaps: Statement periods overlap (e.g., Jan 15 - Feb 15 and Feb 1 - Mar 1)
• Gaps: No statement for a period, creating reconciliation holes

Detection methods

1. Check that statement end date of one month matches (or is day before) the start date of the next.
2. Sort transactions by date and look for gaps in the date sequence.
3. Use Excel's duplicate detection to find transactions with identical amounts, dates, and descriptions.
4. Compare transaction counts month-over-month—sudden drops may indicate missing data.

Resolution workflow

• Request corrected statements from the client when gaps or duplicates are found.
• Document any missing periods in your reconciliation notes for audit purposes.
• Flag overlapping periods and reconcile only the unique transactions from each.
• Keep a log of statement issues to identify patterns (e.g., always missing the last 2 days of the month).