Transaction tracing and funds-flow analysis

A funds-flow engagement covers the full chain of custody for money, not a single hop. We trace a transfer from its origin account through every intermediate stop, whether that is another business account, a personal account within scope, a vendor, or an asset purchase that converts cash into something else entirely. Where the scope includes both business and personal accounts, we trace across that boundary rather than stopping at the business's own books.

We include a funds-flow schedule or diagram laid out chronologically, a source list mapping every dollar figure back to the bank, card, or processor statement it came from, and a written note on any point where a missing statement or an unreadable image breaks the chain. We also flag round-trip transfers, where money moves through two or three accounts and returns close to its starting point, and layering, where several small transfers converge into one larger account before moving again.

We begin with an intake call to establish the boundary of the matter: which accounts, which entities, which date range, and whether counsel wants the trace to start from specific transactions or run against a full account population. From there we collect statements, either directly from the client, through counsel's document production, or from bank records already gathered in the matter.

Each statement gets logged into a working file before any tracing starts, so we know exactly what we have and what is missing before we build the schedule. Tracing itself is manual line-item work supported by spreadsheet formulas and, for larger transaction populations, CaseWare IDEA to flag matching amounts and dates across accounts faster than a human eye alone. Every match gets a human review before it goes into the schedule; software finds candidates, it does not decide what counts.

The finished schedule and source list go through a senior reviewer's review before delivery. Where the matter is active litigation, we sequence delivery against filing deadlines counsel gives us at intake.

This work is engaged most often by attorneys building or defending a fraud, embezzlement, or breach-of-fiduciary-duty claim, by insurers reviewing a fidelity bond or crime-policy claim, and by business owners or boards who suspect a diversion of funds but do not yet have the trail laid out. It also shows up inside a partner or shareholder dispute, where one side wants to see exactly where distributions, loans, or draws actually went, and inside a divorce or family-law matter where business and personal accounts have been commingled.

It is not the right service if what you need is a routine monthly reconciliation or a bookkeeping catch-up with no dispute or investigation attached; our regular bookkeeping tiers cover that at a lower cost and a different cadence. It is also not a substitute for a criminal investigation with subpoena power. We trace what the available records show; we cannot compel a bank or a third party to produce a statement nobody has yet obtained.

The most common problem is a client who is certain money moved somewhere but has only ever seen it from one account's point of view, so the trail dead-ends at the first hop. We fix that by pulling the receiving account's own statements and continuing the trace from there, rather than stopping where the client's own visibility stops.

A close second is round-dollar or evenly-spaced transfers that look coordinated but turn out, once traced, to be legitimate recurring payments like rent or a loan amortization schedule. We trace those the same as any other transfer and let the schedule show what they actually were, rather than assuming a pattern means something it does not.

A third recurring problem is gaps: a statement that was never saved, an account at a bank that has since closed, or a period covered by an app-based account with no PDF export. We do not paper over a gap with an estimate; we log it in the source list and state exactly where the chain breaks, because a fabricated bridge is worse than an honest gap when the schedule is later tested under cross-examination.

Tracing itself runs primarily in Microsoft Excel, where we build the funds-flow schedule with formulas that tie every cell back to a cited source rather than a typed-in number. For a larger transaction population, CaseWare IDEA lets us run matching and duplicate-detection passes across tens of thousands of rows in a fraction of the time manual review would take, though every flagged match still gets a human check before it enters the schedule.

Where the underlying accounting file is in QuickBooks Online or Xero, we export transaction-level detail directly rather than working from screenshots or PDF reports, which keeps every figure traceable back to its original entry. Bank and card statements typically arrive as PDFs from the institution itself, which we convert to structured data before tracing begins so the schedule can be built and checked efficiently.

Funds-flow tracing is quoted per engagement, not sold as a flat monthly package, because the time required depends heavily on the number of accounts, the length of the period at issue, and how many statements survive versus need to be requested. A narrow trace covering two accounts over three months looks very different in scope from tracing twelve accounts across four entities over two years.

We give a written estimate after a scoping call where you describe the matter, the accounts involved, and any deadline counsel has set. If new accounts or a longer period surface once tracing is underway, which happens often in this type of work, we flag the scope change and requote before continuing rather than letting the bill grow silently.

Every figure on the funds-flow schedule ties to a page number on a specific source statement, and that source list is delivered alongside the schedule, not held back. Before delivery, a senior reviewer checks the schedule line by line against the underlying statements, and reviews the finished package for internal consistency and for anywhere the presentation could be misread as an opinion about intent rather than a factual trace.

We measure our own work the way a skeptical reader will: could someone unfamiliar with the matter pick up the source list and verify any single figure in under a minute. If the answer is no for even one line, the schedule goes back for revision before it goes out the door.