Bank Deposits Reconstruction in a Cash-Intensive Dental Practice
An office manager resigned from a four-dentist practice, and the owners engaged a forensic accountant after noticing that cash receipts seemed low. The practice management system reports collections of $2,382,000 for the fiscal year. Bank statements for the operating account show total deposits of $2,410,000, consisting of patient and insurer payments, a $180,000 equipment loan advance, a $95,000 transfer from the practice's money market account, and $2,000 of interest. Card payments are 88% of collections, and the processor nets its 2.6% fee before depositing. The manager was the only person who opened the mail, prepared deposits, and reconciled the account; the reconciliation file shows no unresolved items. The practice's outside accountant has told the owners that "the manager took roughly $240,000, the difference between production and deposits" and wants the forensic accountant to confirm that figure before a civil complaint is filed.
1. Reconstruct revenue-related deposits and compute the preliminary gap. What must be resolved before that gap can be called a loss?
Read the worked answer
Bridge from total deposits to revenue-related deposits:
- Total deposits: $2,410,000
- Less equipment loan proceeds (financing, not revenue): ($180,000)
- Less money market transfer (interaccount, not revenue): ($95,000)
- Less interest income: ($2,000)
- Revenue-related deposits: $2,133,000
- Add back card fees netted by the processor: 88% × $2,382,000 = $2,096,160 × 2.6% = +$54,500
- Fee-adjusted deposits: $2,187,500
- Software collections: $2,382,000
- Preliminary gap: $194,500
The accountant's $240,000 is wrong on its face - it compares gross production to deposits, mixing two different measures and ignoring contractual adjustments and write-offs, which never appear as deposits.
Items to resolve before calling any of this a loss: deposits in transit at the beginning and end of the year (a growing practice systematically understates deposits relative to collections); patient refunds and chargebacks; card batches settled after year-end; insurer payments issued directly to patients; cash discounts; and whether any deposits were recorded twice in the software. Each item must be documented, not assumed, and the net timing difference alone can move the number by tens of thousands.
2. Why is the bank deposits method insufficient on its own, and what corroborating procedure would you perform?
Read the worked answer
What the method does and does not do. A deposits reconstruction tests completeness of recorded revenue: it can show that receipts hitting the bank fall short of what the records say was earned. It cannot show who took the money, when, or whether the shortfall is theft rather than unrecorded adjustments. Concluding "the manager took it" from a deposit total is an attribution leap the data do not support, and it is the fastest way to have an expert opinion excluded.
Corroboration, in order of value:
- Source-document reconstruction. Obtain daily deposit slips, day sheets, and processor settlement reports for sampled months; trace each day's receipts from the schedule to the slip to the bank credit. This converts an inference into a transaction-level finding.
- Deposit-slip comparison. Signature and handwriting on slips, sequential numbering gaps, and slips that do not reconcile to the day sheet identify the mechanism and the timing.
- Second estimation method. A net-worth or expenditures analysis of the manager (subject to subpoena) tests whether her visible spending is consistent with her known income; it corroborates amount, not access.
- Systems evidence. Image the practice management server; deletion and edit logs and after-hours entries often reveal the pattern.
Only after the source documents are tied out should the loss be stated - and it should be stated as a range supported by a documented sampling methodology.
3. How should the conclusion be framed in a report intended for litigation, and what language should be avoided?
Read the worked answer
Engagement framing. Clarify at the outset whether the accountant is a consulting expert (advising counsel, work product protected) or a testifying expert (opinions discoverable and subject to cross-examination). The scope should state what was and was not examined - for example, whether the money market statements and credit card settlement reports were produced.
Assertions to avoid: "the manager stole," "fraud occurred," and "the loss is $240,000." Intent and identity are findings for the trier of fact; the accountant's job is to quantify unreconciled receipts and, if the evidence supports it, opine on the internal control failures that permitted the shortfall. Use hedged, quantified language: "receipts deposited were $X below amounts recorded as collected, after adjusting for A and B."
What the report must contain: the data relied upon and its source; every reconciliation and assumption, with the effect of changing each; the sampling methodology and extrapolation, including confidence level if sampling was used; the distinction between known loss (transaction-level) and estimated loss (extrapolated); and a statement of the opinion to a reasonable degree of professional certainty. Attach the schedules so the opposing expert can reproduce the math.
Preservation. Recommend a litigation hold immediately and note that if the practice management data were overwritten after the manager's departure, the gap between what can be proven and what can be estimated widens - and that widening should be disclosed, not buried.