Record Review

Alcohol Service Record Review Worksheet

A dram shop case produces records from many sources: point-of-sale data, receipts, incident reports, witness statements, deposition testimony, schedules, and police reports. This worksheet puts them in one place so counsel can see what each document shows, where the documents agree, and where they conflict, with every entry tied to its source document and page.

By Ryan Dahlstrom

Dram Shop Expert Witness | Last Updated: November 2026

Every Entry Is Tied to a Source Document

The worksheet records what each document shows, in the words or figures of that document, and cites where it was found. A time is entered exactly as it appears on the document it came from. If a receipt shows 10:42 PM and a witness says around 11:00, both are entered as they appear, each with its own source. Differences between records are noted in their own column rather than resolved by adjusting one record to match another.

This keeps the chronology defensible. Anyone reviewing it can go back to the cited page and see the same thing.

Four Tabs

  • Instructions. How to fill in each column, with the conventions that keep entries consistent.
  • Record Review. The working chronology, one row per entry, with dropdown lists for record type and status.
  • Example. A short, clearly labeled fictional example showing how entries from a receipt, an incident report, and a deposition sit side by side.
  • Records Received. An inventory of every production: producing party, Bates range, description, date range covered, and items requested but not received.

What Each Entry Records

ColumnWhat to enter
Record typePoint of sale, receipt, payment record, surveillance, incident report, witness statement, deposition, schedule or time clock, training record, police or EMS report, or other
Document and Bates numberThe document name and production number
Page or locationPage and line, row number, or file name and display time for video
Date and time as shownExactly as printed or displayed on that document
Person identifiedServer, bartender, manager, security, patron, or witness named in the record
What the document showsThe item, statement, or observation, quoted or closely paraphrased
Related entriesEntry numbers of other records about the same event
Differences from other recordsWhere this record and another record disagree
Open questionsFollow-up requests or deposition topics the entry raises

Keeping the Chronology Useful

  • Enter order entry, delivery, payment, and departure as separate entries when the records show them separately. A drink rung in is not the same as a drink delivered.
  • Record who rang an item in and who served it if the records identify different people.
  • Enter what a witness said they saw, attributed to that witness, without converting it into a conclusion.
  • Use the Records Received tab to track what has not been produced. Missing records are often as important as the ones in hand.
  • Sort by date and time as shown to see the night in order, then filter by person or record type.

Download the Alcohol Service Record Review Worksheet

Enter your name, email, and firm below and the file will download immediately. Every item on this page is also available to read above at no cost.

This resource is educational and does not provide legal advice. Counsel determines preservation obligations, applicable law, and case strategy in each matter.

Frequently Asked Questions

How is this different from a standard timeline?

Each entry cites the document and page it came from and records the time exactly as that document shows it. Differences between sources are listed rather than adjusted away, so the chronology can be checked against the record at any point.

Should times from different systems be adjusted to match?

The worksheet records each time as it appears on its source document. Where two records disagree, the difference is noted in its own column so counsel and any expert can address it with the underlying documents in hand.

Can the worksheet be used for negligent security cases?

Yes. The record types include incident reports, security logs, surveillance, and witness statements, which apply to ejection, assault, and crowd control matters as well as alcohol service.

Does the example contain real case information?

No. The example tab uses fictional names, venues, and records for illustration only.

Related Resources

Request Expert Consultation

Attorneys may request a curriculum vitae, fee schedule, and case consultation. Expert witness services are available to assist attorneys in analyzing alcohol service practices and dram shop liability issues.

Ryan Dahlstrom, dram shop and liquor liability expert witness

Ryan Dahlstrom – Dram Shop Expert Witness

Ryan Dahlstrom is an expert witness with over 35 years of hands-on experience in the hospitality and entertainment industries. He has managed and advised bars, restaurants, nightclubs, and multi-unit operations across the United States, and he specializes in cases involving dram shop liability, negligent security, and responsible alcohol service practices.

Ryan has been retained by both plaintiff and defense attorneys nationwide to provide expert opinions, deposition testimony, and courtroom analysis in complex alcohol-related cases. His deep understanding of state dram shop statutes, Safe Harbor protections, intoxication timeline analysis, and security standards makes him a trusted authority in litigation involving overservice, intoxication, and venue liability.