Where’s the Evidence? How to Turn a Bank Statement Data Dump Into a Fraud Case That Wins

I have handled several cases in which the evidence seems lacking, especially at first. Sometimes all that is needed is for the attorney or client or other professional to write a narrative. This can get linked to evidence ‘dumps’, as having tens of thousands of pages of bank statements can be next to worthless otherwise.

Evidence is like the backbone of a court case. It’s what helps prove or disprove facts in a legal dispute. In court, evidence is used to support or challenge claims made by either the plaintiff or the defense.

Evidence can be physical things like documents, objects, or digital data, or it can be testimony from witnesses. The whole point of evidence is to help the judge or jury figure out what really happened.

For example, if someone’s accused of theft, evidence like security footage, witness statements, or physical evidence found at the scene can be important in determining guilt or innocence.

In a civil case, evidence shows negligence or contract breach, among other things. For example, it can show that contract terms were not complied with. Or in a tort case it can show a party was defrauded. In a personal injury case it shows damages were sustained.

As a CPA, CVA, CFE, Esq. who handles partner fraud and M&A fraud cases, I get hired after the client already gave attorney a 10,000-page bank statement dump. Here’s how I turn that into evidence that survives Sargon and wins at mediation.

Current Cases: 3 Types of “No Evidence” Cases I See

Case Type 1: The Fraud That Originated in Plaintiff’s Mind

One case I handled has almost no usable evidence so far, after many months. The case originated in the plaintiff’s mind, and I’m still not sure whether anything nefarious has occurred.

This is common in partner disputes: Partner A says “Partner B stole $500k” but when I ask for specifics, there’s no bank statement, no QuickBooks entry, just a feeling that distributions should have been higher.

My first step: I ask attorney to have client write a narrative – 2 pages max – answering:

• What specifically was taken? (cash, inventory, customers)
• When did it start? (month/year)
• How do you know? (saw Amex statement, vendor is spouse, etc.)
• What documents have you seen that prove it?

If client can’t write that, case is not ready for forensic accounting. It’s ready for more discovery.

Case Type 2: Police Report Filed But No Criminal Action

Another case I have was reported to the police as a fraud scheme. Apparently the officer had experience as a former contractor and understood it enough to document it. However I don’t believe anything further happened on the criminal end. I asked the client to thoroughly document/graph out how the fraud occurred as it was a new case to me. So far I have not received anything useful.

Police reports are helpful for narrative but rarely enough for civil damages. Officer documents victim’s story, but doesn’t get bank statements via subpoena or do forensic accounting.

In civil court, you need to prove fraud by preponderance (51%), not beyond reasonable doubt. But you still need: misrepresentation, knowledge, intent, reliance, damages under Civil Code 1709/1710. Police report shows it was reported – it doesn’t prove damages.

I ask client to graph out fraud: On whiteboard, show money flow – Company Bank → Partner Personal Amex → Tesla payment. That graph becomes Exhibit 1.

Case Type 3: Tons of Data, No Clarity

Yet another new case has tons of information in the form of bank statements etc. but there is no clarity in how the fraud was perpetrated. I told the plaintiff that – at a minimum – they would need to provide a narrative. Then someone needs to connect the assertions with the evidence.

This is 70% of my forensic cases. Attorney gives me 12,000 pages of bank statements with little description. Bank statements have thousands or tens of thousands of transactions, and often don’t have good descriptions. There are incomplete names and accounts/transactions referenced. It is of little help without a map.

Courts need frauds and complex matters to be thoroughly explained to them. Without all of the dots being connected these type of cases will never move forward.

My Forensic Evidence Framework: Narrative + Data + Link

Here’s how I solve “Where’s the evidence?” – I use a 3-part framework that judges and juries understand:

Part 1: The Narrative (Written by Client, Edited by Attorney)

2-3 page plain English story, with dates, amounts, and names. Example:

“In January 2021, managing partner John Doe began paying his personal American Express from Company operating account. Attached are 12 transfers totaling $84,000 from Company Wells Fargo account ending 1234 to Amex ending 5678. Company has no policy allowing personal expenses. Operating agreement Section 5.2 requires pro-rata distributions.”

This gives me searchable terms: Amex, $84k, Wells Fargo 1234, Section 5.2.

Part 2: The Data – Organized and Coded

I take bank statement dump and code every transaction:

Date	Payee	Amount	Category	Evidence Bates
1/15/21	Amex 5678	$7,000	Personal Amex – Alleged Misappropriation	WF 00012
2/15/21	Tesla Financial	$1,200	Personal Auto – Alleged Misappropriation	WF 00045

I use data analytics: Is payee spouse? Is payee “John Doe” personal mortgage company? Does amount match loan amortization?

For a recent case with $1.2M of alleged misappropriation, we coded 18,000 transactions into 12 categories in 2 weeks. That becomes damages summary.

Part 3: The Link – Connect Assertions to Evidence

This is where most cases fail. Attorney asserts “Partner stole $500k” but never links assertion to bank statement page.

My report does link:

“Assertion: Partner took $7,000 personal Amex payment on 1/15/21.
Evidence: See WF 00012, Company Wells Fargo statement showing $7,000 debit to Amex ending 5678, and Amex statement AMEX 00023 showing same $7,000 payment credited to John Doe personal account, with charges including $2,400 at Four Seasons Maui and $1,800 at Nordstrom – personal, not business.
Damages: $7,000 is included in damages as personal expense per operating agreement 5.2 requiring pro-rata distributions.”

Every dollar has a Bates stamp. That’s what survives cross-examination and Sargon challenge.

What Evidence Is Admissible? Business Records Exception

In California, bank statements and QuickBooks are hearsay unless you lay foundation under Evidence Code 1271 – Business Records Exception:

• Record made in regular course of business
• At or near time of act
• By someone with knowledge
• Foundation via declaration from custodian of records

I prepare custodian declarations for bank, QuickBooks, and POS data. Many forensic CPAs forget this – then their report is excluded because underlying data is hearsay.

What To Give Your Forensic Accountant So You Don’t Waste $15k

If you hire me for forensic accounting exam, give me this on Day 1:

1. 2-page narrative with dates, amounts, how you know
2. QuickBooks file (.QBW or online access) – not just P&L PDF
3. Bank statements in CSV or Excel, not just scanned PDFs – I can OCR but CSV saves $3k
4. Credit card statements – same
5. Operating agreement / bylaws highlighting distribution clause
6. Tax returns 3 years – K-1s show what should have been distributed vs what was
7. Any spreadsheets client already prepared tracking transactions – I re-check, summarize, calculate damages

Often I have counsel go back to those who made the accusations and get more detail/evidence of wrongdoings, and this becomes a starting point for my work. If there is a bookkeeper or CPA or if the client has already prepared spreadsheets tracking the transactions this helps to organize the case file. Once I know where to start I can re-check their work, summarize it and calculate damages.

What they do with my findings is up to the attorney/courts but at least I have thoroughly reviewed the financials, somewhat like an auditor would do.

If you are a business litigation attorney in California with a partner dispute where you have a data dump and need a narrative that connects the dots for court, contact me at hpaccounting.com. I turn 10,000 pages into a 10-page damages report that settles cases.