An M&A due diligence checklist in Excel is a structured workbook, typically 8 tabs deep, that a buyer's deal team uses to track every request, document, red flag, and closing condition across the 200+ items examined between LOI and signing. It replaces email chaos with a single source of truth. Done well, it compresses a 60-to-90-day close and prevents the post-closing surprises that show up when categories like contracts and working capital are worked out of separate mailboxes.

The Bain 2026 M&A Report, looking back at 2025 activity, found that roughly 70% of deals among large, repeat acquirers now succeed, while the small-to-midcap segment that drives about 90% of U.S. M&A volume by count still lives with the historical 70-90% failure pattern. The gap is process. Serial buyers run the same 8-tab checklist every time. First-time and mid-market buyers reinvent it under time pressure and miss things.

Why the M&A due diligence checklist in Excel still beats deal-room software

Deal rooms hold documents. They do not track work. A buyer needs a live record of who requested what, when it landed, what it changed in the model, and whether it survived Q&A. That is a spreadsheet problem. Excel handles it with three columns most deal rooms cannot replicate cleanly: owner and status, plus a running tally of financial impact on the offer.

The checklist also runs backwards. On the day of closing, a buyer can filter the workbook to items still open and items that changed the price. Every diligence finding becomes a schedule to the SPA or a covenant. The Excel template is the audit trail.

  • Column A: Item ID (e.g., FIN-014, LEG-032)
  • Column B: Request description
  • Column C: Priority (P1 kills the deal, P2 changes the price, P3 conditions closing)
  • Column D: Assigned reviewer
  • Column E: Status (Requested / Received / Under review / Cleared / Flagged)
  • Column F: Date requested
  • Column G: Date received
  • Column H: Findings summary
  • Column I: Financial impact ($)
  • Column J: SPA schedule reference

Set that header row once. Every tab uses the same columns. That consistency is the reason the checklist scales from a $5M add-on acquisition to a $500M platform deal without redesign.

Actionable next step

Build the header row in a blank workbook and lock it as a template. Add a summary tab that pivots status across all 8 category tabs. That pivot becomes the weekly deal committee update.

Tabs 1 and 2: Financial and Legal (the foundation)

Financial due diligence is where the offer either holds or gets repriced. According to GF Data analysis reported by Middle Market Growth in fall 2025, sellers that commissioned a sell-side Quality of Earnings report saw TEV/EBITDA multiples of 7.4x on average, versus 7.0x for those that did not. The QoE is the anchor document on Tab 1. Buyers who skip it above $500K deal value are guessing.

Tab 1: Financial (approx. 45 items)

  • Three years of audited financial statements plus trailing twelve months
  • Monthly P&L, balance sheet, and cash flow for the last 24 months
  • Quality of Earnings report from a transaction CPA
  • Working capital calculation with the target working capital peg
  • Full accounts receivable aging by customer
  • Debt schedule with all loan and credit agreements
  • Capitalization table with fully diluted ownership
  • Tax returns (federal, state, local) for three years
  • Add-back schedule with supporting evidence for each adjustment

Valutico's 2025 guide on QoE adjustments notes the reported-to-adjusted EBITDA gap typically runs 20 to 30% in middle market deals. Anything wider than that is where a buyer flags P2 items on Tab 1 and starts pricing the risk into the offer or the escrow.

Tab 2: Legal and Corporate (approx. 35 items)

  • Certificate of incorporation and all amendments
  • Bylaws and shareholder agreements
  • Board and shareholder minutes for three years
  • All material contracts above a defined threshold (usually $50K or $100K)
  • Change-of-control provisions in every material contract
  • Litigation schedule: pending, threatened, and settled in the last five years
  • Insurance policies and claims history
  • Regulatory correspondence

Legal items generate the highest volume of Schedule references in the SPA. Every material contract and every threatened claim ends up on a disclosure schedule. If Tab 2 is disorganized, the SPA disclosure schedules will be too, and that is where post-closing indemnity claims are born.

Actionable next step

Number every legal document to match the Tab 2 item ID. When outside counsel asks for LEG-018, they get the same PDF the SPA disclosure schedule cites. This one habit removes 80% of the back-and-forth in signing week.

Tabs 3 and 4: Commercial and Operational (the value tabs)

Tab 3: Commercial (approx. 30 items)

  • Customer concentration analysis (top 10, top 20, top 50 as percent of revenue)
  • Customer contracts with renewal terms and pricing history
  • Cohort retention curves for the last three years
  • Pipeline by stage with weighted values
  • Win/loss analysis for the last 12 months
  • Competitive positioning and market share data
  • Pricing structure and discount schedules
  • Sales cycle length by segment

Commercial due diligence answers the question the QoE cannot: are these revenues sustainable? A buyer wants to know if the top three customers are up for renewal in the 12 months after close, and what the retention rate has been in that cohort. Concentration above 20% on a single customer with a change-of-control clause is a P1 item.

Tab 4: Operational (approx. 25 items)

  • Organization chart with FTE headcount by function
  • Supplier list with concentration analysis
  • Manufacturing or delivery capacity utilization
  • Facility leases and property agreements
  • Process documentation for revenue-critical workflows
  • Systems inventory (ERP, CRM, billing, HRIS)
  • Business continuity and disaster recovery plans
  • KPI dashboards for the last 24 months

Actionable next step

On Tab 3, add a chart that plots customer concentration against contract expiration dates. Any customer above 10% of revenue with a contract expiring inside 18 months of close should be pulled into a separate management interview. That interview goes on Tab 3 as its own item.

Tabs 5 and 6: Human Capital and Technology (the continuity tabs)

Bain's human due diligence research, referenced in their Wall Street Journal analysis, found that in successful deals nearly every acquirer identified key employees for retention during due diligence or within 30 days of announcement. In unsuccessful deals, only one-third had done that work. Tab 5 is where a buyer moves this from talking point to line item.

Tab 5: Human Capital (approx. 25 items)

  • Complete employee census with tenure, comp, and role
  • Employment agreements for the top 20 by comp
  • Non-compete, non-solicit, and IP assignment coverage rate
  • Equity and option grants with vesting schedules
  • Benefits plans (health, 401(k), bonus)
  • Open workers' compensation claims
  • Employee handbook and HR policies
  • Key-person identification with retention recommendation
  • Recent voluntary attrition rate by function

Tab 6: Technology and Intellectual Property (approx. 20 items)

  • Patent portfolio with expiration dates and jurisdictions
  • Trademark registrations by geography
  • Trade secret protection procedures
  • Software license inventory (owned and licensed-in)
  • Open-source software usage and license compliance
  • Cybersecurity posture (SOC 2, ISO 27001, penetration test results)
  • Data breach history
  • Customer data handling and GDPR/CCPA compliance
  • Source code escrow arrangements

Actionable next step

On Tab 5, add a "retention risk" column with three values: high, medium, low. Any employee marked high who does not have a signed retention agreement by signing goes on the closing conditions list on Tab 8. This is how key-person risk gets priced in rather than assumed away.

Tabs 7 and 8: Regulatory and Deal Terms (the risk transfer tabs)

Tab 7: Regulatory and Environmental (approx. 15 items)

  • All required licenses and permits with expiration and transfer provisions
  • Regulatory filings for the last three years
  • Government correspondence and inquiries
  • Environmental site assessments (Phase I and, if triggered, Phase II)
  • Historical environmental liabilities and remediation
  • Industry-specific compliance (HIPAA for healthcare, FDA, FCC, state DOI)
  • Export controls and sanctions screening

Tab 7 is small on item count and large on deal-killing potential. A missing state license in the target's biggest revenue jurisdiction can freeze the business the day after close. Every license on the tab needs a transferability column with the SPA closing condition mapped in.

Tab 8: Deal Terms and Closing (approx. 20 items)

Tab 8 is the transaction structure itself. It sits inside the M&A due diligence checklist in Excel because every finding from Tabs 1 through 7 ends up as a schedule, a rep, an escrow bucket, or a closing condition on Tab 8.

  • Purchase price allocation across cash, stock, rollover, earnout
  • Working capital target and true-up mechanism
  • Representations and warranties inventory
  • Escrow structure (general indemnity, PPA, special escrows)
  • Representations and Warranties Insurance (RWI) coverage terms
  • Survival periods by rep category
  • Sandbagging provisions
  • Materiality scrapes
  • Closing conditions checklist
  • Ancillary agreements (transition services, non-compete, employment)

The SRS Acquiom 2025 M&A Deal Terms Study, covering more than 2,200 private-target acquisitions totaling $505 billion in transaction value, reports the median general indemnification escrow at 10% of transaction value for deals without RWI and 0.5% for deals with RWI. The median PPA escrow held steady at about 1% of transaction value. On RWI deals, nearly half now carry an additional special escrow for items outside the general indemnity. Those benchmarks belong on Tab 8 as reference cells so the deal team can see instantly when a proposed structure is off-market.

Actionable next step

Create a cross-reference on Tab 8 that pulls every P1 finding from Tabs 1 through 7 into an "Escrow Justification" section. When the seller pushes back on escrow size, the workbook shows the specific findings that priced it.

How buyers actually run the checklist to close

The workflow is weekly, not continuous. Deal committee meets Monday. The pivot on the summary tab shows open items by tab and any items that changed the price since the last meeting. Legal and financial workstream leads each get 10 minutes, and so does whoever owns commercial. Everything else is offline.

  1. Week 1-2 after LOI: Send the full request list. Every item hits status "Requested" with a date.
  2. Week 3-4: First round of documents lands. Update status to "Received". First red flags surface on Tabs 1, 2, and 3.
  3. Week 5-6: QoE and legal review generate findings. Tab 8 gets first population of reps and escrow proposals.
  4. Week 7-8: Management interviews. Tabs 3, 4, and 5 close out. Remaining opens on Tab 6 and 7 get triaged.
  5. Week 9-10: Disclosure schedules drafted from Tabs 1-7. Final SPA negotiation runs off Tab 8.
  6. Week 11-12: Closing conditions from Tab 8 clear one by one. Wire, sign, close.

A first-time buyer can run this in Google Sheets. A serial acquirer running three to five deals a year needs the workbook version because the pivots, cross-references, and conditional formatting stop working reliably in browser spreadsheets at 200+ line items across 8 tabs.

The template is the difference between an 8-week close and a 20-week close

Building the 8-tab M&A due diligence checklist in Excel from scratch takes a deal team two to three weeks of clock time and produces a workbook that will still have missing categories on the first live deal. The value of a ready-made template is that it starts already populated with the 200+ items serial buyers run, the pivot logic on the summary tab, the SRS Acquiom benchmarks pre-loaded on Tab 8, and the SPA cross-references pre-wired.

ModelStack's M&A due diligence checklist template ships as a working Excel workbook with every tab, every column, every benchmark, and every formula in place. A deal team can open it on day one after LOI and start assigning items. That is the difference between a 60-day close and a 120-day close, and between a clean disclosure schedule and a post-closing indemnity claim.

Sources

Related: Browse all Investment Banking & M&A Templates on ModelStack.

Get started with a free template

Download our free Unit Economics Calculator — no signup required.

Download Free Template