Date Gaps Analysis #
Overview #
Date Gaps Analysis helps you identify missing transaction data in your financial records by showing which months have transaction data for each account. This is crucial for ensuring data completeness in financial investigations and audits.
What It Does #
- Identifies Missing Data: Shows which months are missing transaction data for each account
- Visual Representation: Uses color-coded charts where green indicates months with data and red indicates missing data gaps
- Account Coverage: Displays data availability across all your accounts in a single view
- Date Range Analysis: Allows you to specify custom date ranges for analysis
How to Use #
- Navigate to Date Gaps: Go to Analyze → Date Gaps tab
- Set Date Range:
- Enter start and end dates for your analysis period
- The system will auto-detect the full range if left blank
- Calculate Gaps: Click "Calculate Date Gaps" to generate the analysis
- Review Results:
- View the data table showing account/month combinations
- Check the visual chart for quick identification of gaps
- Green squares = data available, Red squares = missing data
Understanding the Results #
Data Table #
- Account: The account name
- Month: The month being analyzed (YYYY-MM format)
- Has Data: Checkmark (✓) if data exists, X if missing
Visual Chart #
- X-axis: Timeline showing months
- Y-axis: Different accounts
- Green rectangles: Months with transaction data
- Red rectangles: Months missing transaction data
Common Use Cases #
- Audit Preparation: Ensure complete data coverage before starting analysis
- Data Quality Check: Identify periods where statements might be missing
- Investigation Planning: Understand data limitations before drawing conclusions
- Client Communication: Show clients which additional documents are needed
Export Options #
The analysis results can be exported to CSV format for further analysis or reporting purposes.
Tips for Best Results #
- Run this analysis early in your investigation process
- Request missing statements for red-flagged periods
- Consider seasonal patterns that might explain certain gaps
- Use the date range filters to focus on specific investigation periods
