Research question
When does the elapsed time between a recorded customer receipt and its appearance in a grouped bank deposit become evidence of an administrative exception? A long interval may signal missing settlement information, an unmatched deposit, a partial batch, or a receipt that followed a different path. It may also reflect an ordinary weekend, processor schedule, or deliberate holding period. The research challenge is to measure lag without declaring that age alone proves an error.
QuickBooks Online uses Undeposited Funds as a holding account for payments intended to be combined before deposit. Intuit explains that the grouped record should reflect the way transactions appear at the bank. That product model supports a temporal study: follow receipt cohorts from their recorded date to a documented clearing event, while preserving cases that do not fit a simple one-to-one sequence.
Cohort definition
The natural unit is a receipt event associated with a named QBO company, account, and observation window. Receipts enter a cohort based on the date recorded, with separate labels for payment channel and known settlement pattern. Each event remains in the cohort until it is linked to a bank deposit record, reversed through an authorized process, or classified as unresolved at the study cutoff.
Cohorts should not be formed from amount alone. Equal amounts can belong to different customers, and one bank deposit can combine several receipts. The analysis preserves receipt identifier, customer reference, receipt amount, recorded date, deposit identifier when known, bank posting date, batch reference, and evidence status. Those fields permit one-to-many and many-to-one relationships without forcing a false match.
Methodology: time-to-clear analysis
The method is a retrospective cohort design proposed from public documentation. Intuit's Undeposited Funds guidance defines the holding-account behavior. Intuit's bank deposit guidance provides product context for grouping payments. The IRS recordkeeping resource supports keeping records that explain entries, and the SBA finance management guide places bookkeeping and bank reconciliation within small-business financial administration.
For each receipt, elapsed calendar days are measured from recorded date to the earliest supported clearing event. Items still open at the cutoff are right-censored rather than assigned an invented completion date. The primary output is a distribution, not an average: median elapsed time, upper quartile, share still open at selected ages, and counts by unresolved-reason group. Calendar and business-day views can both be retained because bank processing patterns may cross weekends.
The design compares cohorts rather than imposing a universal target. Channel, weekday, batch practice, and bank account can stratify the population when sample size allows. A small population should be shown as individual intervals instead of percentages that imply more precision than the evidence supports.
Why a survival curve is more informative than an aging list
An aging list is a snapshot. A time-to-event curve shows how quickly a receipt cohort clears and how much remains unresolved as time passes. If most receipts clear in a narrow interval but a small tail remains open, the tail is a focused evidence question. If the whole distribution shifts after a processor or procedure change, the change may warrant investigation even when no item has crossed an arbitrary threshold.
Censoring is essential. A receipt recorded near the study end has had less opportunity to clear than one recorded at the beginning. Treating both as overdue creates observation bias. The curve also needs a stable study cutoff so a later refresh does not silently change the denominator.
Reason-coded interpretation
Open events can be grouped by observed reason: bank settlement not yet visible, deposit record found but batch composition unresolved, receipt amount differs from settlement evidence, reversal under authorized review, source reference missing, or path outside the selected bank account. The reason is an observation category, not a proposed journal treatment.
Reason codes prevent all old receipts from being treated as equivalent. A well-supported weekend delay differs from a six-week item with no bank reference. A processor settlement that combines gross receipts and fees differs from a missing deposit. The administrative record should preserve these distinctions and show the source searched, search period, last observation date, and person responsible for the next review.
Evidence tests for linked events
A proposed receipt-to-deposit link is stronger when the component amounts reconcile to the grouped deposit, the dates fit the documented settlement sequence, and a processor or bank reference supports the relationship. Customer name alone is weak because the bank may display a processor. An exact total alone is also weak when common amounts recur. Independent agreement across amount composition, reference, and timing creates a more reviewable link.
Negative evidence needs boundaries. Failing to locate a deposit in one account and one date range does not show that no deposit exists. The study record should state which bank accounts, reports, and dates were examined. That lets another authorized reviewer reproduce the search or expand it.
Administrative role and reviewer decision
A QBO support specialist can assemble the cohort, preserve identifiers, calculate elapsed intervals, group observed reasons, and collect bank or processor references. The specialist can identify breaks in the event chain and prepare a compact exception population. This is analytical preparation, not a direction to create, delete, reclassify, or reconcile an entry.
The owner or qualified accounting reviewer determines whether a receipt was recorded properly, whether a deposit relationship is valid, and what correction, if any, is permitted. The study should never use elapsed time as authority to change a transaction. Nor should it label small items immaterial, infer tax treatment, or treat a clearing event as proof that the broader account is reconciled.
Patterns worth investigating
A concentrated tail from one payment channel may indicate that settlement evidence is not reaching the review record. Repeated deposit totals with no component references may reveal a documentation weakness. A sudden distribution shift after a bank connection change may reflect timing or scope rather than poorer work. Differences by operator should not be interpreted as performance until account mix, channel, and observation time have been considered.
The strongest finding is reproducible: another reviewer can select the same population, apply the same event definition, and obtain the same intervals. A finding becomes actionable only after the reason categories point to a source, access, instruction, or review issue that an accountable person can assess.
Limitations
This is a proposed measurement design, not an empirical estimate of normal clearing time. Public documentation does not establish a standard number of days for every business. Bank holidays, processor practices, cash handling, multicurrency activity, reversals, migrations, and partial records can alter the sequence. QBO dates may represent entry timing rather than bank settlement timing.
The study can miss events outside the selected account or period. Historical links may have been edited. A grouped deposit can obscure relationships unless component evidence is retained. Small cohorts produce unstable percentiles, and reason coding can vary between reviewers. The design cannot establish accounting correctness, fraud absence, revenue recognition, or a complete bank reconciliation.
Conclusion
Undeposited receipt age is meaningful only inside a defined cohort with a supported clearing event and a stated observation cutoff. Time-to-clear analysis handles open events more honestly than a simple average and reveals whether delay is broad or concentrated in a reason-coded tail. QBOAssistant can prepare those intervals and evidence links for review. Any conclusion about the books or a corrective entry remains with the authorized owner or accounting professional.