Date Gaps Analysis
Find missing statement periods across a set of bank statements in DocuClipper, catch coverage gaps before they break a reconciliation, underwriting review, or forensic investigation.
Last updated
DocuClipper's Date Gaps Analysis scans every bank statement in a project and flags any periods where coverage is missing. It's the fastest way to confirm continuous statement coverage before starting a reconciliation, an underwriting review, or a forensic investigation.
Lenders use it to verify a borrower submitted every month requested. Forensic accountants use it to detect undisclosed accounts or concealed periods. Bookkeepers use it to catch a missing statement before it breaks the reconciliation.
How does Date Gaps detection work?
DocuClipper groups the statements in a project by account, then walks each account's statements in date order. For every adjacent pair, it compares the period end date of the earlier statement to the period start date of the next statement.
If those dates don't line up — for example, statement A ends June 30 and statement B starts August 1 — the missing window (July 1–31) is reported as a gap. If they overlap — A ends July 5 and B starts July 1 — that's reported as an overlap, usually a duplicate upload.
The dates come from each statement's extracted metadata. If a statement's period was OCR'd incorrectly, the gap will be wrong too — fixing the period on that statement fixes the analysis.
Running the analysis
- Open the project that contains the statements.
- Click the Advanced Analysis tab.
- Select Date Gaps.
For each account, you'll see:
- Covered periods — the contiguous date ranges you have.
- Gaps — missing date ranges with start/end dates and the number of missing days.
- Overlaps — duplicate coverage where two statements cover the same window.
Why does DocuClipper say I have date gaps?
A gap means the analysis can't see continuous coverage between two adjacent statements. Common reasons:
- A statement was never uploaded. The most common cause. Request the missing month from the client.
- The account changed mid-period. The client switched accounts and only sent statements for the new one. You'll see a gap on the old account starting at the cutover.
- The statement period was mis-detected. OCR pulled the wrong start or end date from the statement header. Open the statement detail and correct the period.
- A statement spans a non-calendar period. Some banks issue statements on cycles that don't align to month boundaries. The analysis still works — it cares about period contiguity, not calendar months.
- An undisclosed account. In forensic work, gaps in one account that align with deposits or transfers from another can indicate a concealed account funneling money.
How do I fix a date gap?
Three options, depending on the cause:
- Upload the missing statement to the same project. The analysis updates automatically once extraction completes.
- Correct a mis-detected period. Open the offending statement, check the extracted period dates on the statement detail page, and fix them if OCR got them wrong.
- Treat the gap as intentional if you've confirmed the account was closed, dormant, or genuinely had no statement for that period. Document the reason in your workpaper — DocuClipper won't suppress the flag, but you can ignore it knowingly.
For overlaps, remove the duplicate statement from the project via the Documents sub-tab. See Managing Project Documents.
Use cases for lenders and underwriters
For SBA loans, bank loans, and any credit decision that relies on cash-flow analysis, complete coverage means every month in the requested review period has a statement on file. A single missing month can invalidate the cash-flow conclusion: you can't claim the borrower averaged $X in deposits if you have no data for July.
Date Gaps gives underwriters a single screen that proves coverage (or lists exactly what's missing to request from the borrower). It also catches a common borrower trick — submitting 11 of 12 months and hoping no one notices the gap.
Use cases for forensic accountants
In divorce, fraud, and asset-tracing engagements, gaps are a red flag. A respondent who provides "all my bank statements" but has July missing — when a real-estate closing happened that month — is hiding something. Date Gaps surfaces those windows immediately, and the overlap detection catches duplicate uploads designed to pad the production.
Pair Date Gaps with Flow of Funds Analysis and Transfers Analysis to trace money across accounts during the gap windows.
FAQs
Why does DocuClipper say I have date gaps?
A gap means two adjacent statements don't have contiguous period dates — the earlier statement ends before the next one begins. Usually it's a missing statement, an account that changed, or a mis-detected period from OCR.
How do I fix a date gap?
Either upload the missing statement to the project, correct the period dates on the statement that was extracted incorrectly, or accept the gap as intentional and document the reason. The analysis updates automatically as soon as a new statement is extracted.
Do I need 100% coverage for SBA underwriting?
Underwriting standards vary by lender and program, but for cash-flow-based credit decisions, complete coverage of the requested review period is the norm. A missing month undermines the cash-flow conclusion, so most underwriters require the gap closed before approval.
Can DocuClipper detect a hidden account?
Date Gaps detects missing periods within accounts you've uploaded — it can't directly see an account you don't know about. But in forensic work, gaps in one account that coincide with unexplained transfers in another often point to an undisclosed account. Combine Date Gaps with Transfers Analysis and Flow of Funds Analysis to build that picture.
What date range does Date Gaps check against?
It checks contiguity between adjacent statements per account — not against an external requested range. If you need to prove coverage from January through December, upload statements that span that range; the analysis will flag any missing periods between the earliest and latest statements you provided.