Transaction Services – FDD All-in-One Excel Workbook (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. Combines all core TS analyses in one integrated Excel workbook.
2. Delivers audit-friendly bridges, KPIs and dashboards ready for reports.
3. Easy to use and customise, with Clean and Example templates included.

SALES EXCEL DESCRIPTION

Editor Summary Transaction Services – FDD All-in-One Excel Workbook is an Excel-based integrated financial analysis workbook (XLSX with supplemental XLSX) by Finance Model Hub that combines 4 core models: Sales & Profitability, Quality of Earnings (QoE), Net Debt, and Working Capital. Read more Includes additional modules for Current Year Trading and business plan linkage, audit-friendly mappings from trial balance to pro-forma outputs, and both a Clean Template and a pre-populated Example Template. Target users include Transaction Services teams, financial and commercial due diligence practitioners, and factbook preparers. Sold as a digital download on Flevy with immediate digital download.

Use this workbook when you need to consolidate transaction services workstreams—QoE, sales/profitability, working capital, and net debt—into a single reconciled file for deal diligence, factbooks, or recurring management reviews.

  Transaction Services analysts mapping trial balance accounts and producing QoE adjustments, reclassifications, and EBITDA bridges for a sell-side or buy-side diligence.
  Financial due diligence consultants preparing factbooks and IC decks by generating KPIs, dashboards, and decision-ready bridges from account-level data.
  FP&A and corporate finance teams performing monthly working capital analysis, DSO/DPO/CCC tracking, and linking historic performance to forward business plans.

The model’s audit-friendly, end-to-end mapping from trial balance to reconciled bridges and KPIs follows standard transaction services and due diligence practice for consistent Earnings, Working Capital, Net Debt and commercial views.

This model combines and expands the following tools into one integrated workbook: Corporate Finance – Sales and Profitability Analysis Model, Corporate Finance – Quality of Earnings Model, Corporate Finance – Net Debt Analysis Model, and Corporate Finance – Working Capital Analysis Model.


Purpose of the tool

This Excel-based Transaction Services All-in-One Financial Analysis Workbook brings together all core TS workstreams in a single integrated file. It combines Quality of Earnings (QoE), multi-dimensional sales & profitability analysis, working capital (including aging), net debt & debt-like items, net asset / balance sheet analysis, as well as additional modules such as Current Year Trading (CYT) and business plan linkage.Starting from the trial balance and basic sales detail, the workbook guides you through mapping, classifications, adjustments and pro-forma entries and consolidates everything into decision-ready outputs: bridges, KPIs, dashboards and tables suitable for inclusion in factbooks, IC decks or due diligence reports. The structure is audit-friendly and designed to keep Earnings, Working Capital, Net Debt and commercial views fully consistent with each other. The tool is particularly useful for Transaction Services, financial & commercial due diligence and factbook preparation, but it can also serve as a robust integrated management reporting and analysis framework for recurring internal reviews. Each sheet includes a short "What to do / What to know" box with practical instructions, so you always know exactly what is expected on that tab and how it feeds into the overall model.

Key outputs

Within Earnings / QoE, the workbook provides reported, adjusted and pro-forma EBITDA and margins, supported by structured adjustment schedules (reclassifications, normalisations and pro-forma items) and clear, traceable bridges. For Sales & profitability, you get a sales overview including seasonality, analyses of sales by division, product, region and customer, and segment-level profitability views including EBITDA, EBIT, net profit and margin analysis. The Working capital & aging section shows net working capital by component with a clear OWC vs. Net Debt split, key metrics such as DIO, DSO, DPO, CCC and NWC as a percentage of sales / material expenses, as well as trade receivables and payables aging schedules and seasonality insights. In Net debt & debt-like items, the workbook covers net financial debt and other debt-like items (reported and pro-forma), delivers core leverage KPIs (Net Debt, Adjusted Net Debt / EBITDA, Net Debt / equity), and includes charts on net debt composition and development. Under Net assets & CYT / expense analysis / plan, it provides a consistent net asset structure with allocation to OWC, Net Debt and other categories, Current Year Trading (YTD/YTG) views with YoY comparisons, detailed breakdowns of Other operating income (OOI), Other operating expenses (OOE), personnel and material expenses, and a business plan module linking historic / LTM performance to forward-looking plan years.

Key inputs and assumptions

The model is built on trial balance / financial statements, ideally monthly and at account level. Where available, it also uses sales detail with segment information such as division, product, region and customer. In addition, you define mapping rules for net assets, working capital vs. net debt classification, and QoE categories. Optional business plan figures (sales, costs, EBITDA, etc.) can be added for the planning section.

How to use

First, set the core parameters (periods, segments, currency and plan horizon) in the Assumptions sheet. Then load your historical trial balance and sales detail into the relevant source / lead tabs and reconcile totals. Next, classify accounts for QoE, working capital vs. net debt and net asset categories, and enter the relevant adjustments (QoE, NWC, Net Debt and pro-forma items). Finally, navigate through the Earnings/QoE, Sales & Profitability, Working Capital, Net Debt, Net Assets, CYT and Plan tabs to review the integrated analyses, bridges and KPIs and use them in your reports and factbooks.

Customization and support

The workbook is highly customizable—you can easily adapt categories, segment structures, labels, KPIs and charts to your firm standards, sector specifics, or lender / investor reporting requirements. For more complex customizations or individual needs (for example firm-branded versions, additional modules, integration with existing templates, or client-specific setups), feel free to reach out and we can discuss a tailored solution. Each download includes both a fully blank "Clean Template" for working directly with your own data and a pre-populated Example Template that illustrates the model's logic and calculations using realistic sample data.

TOPIC FAQ

What are the core components covered in a transaction services financial model?

A transaction services model typically integrates Quality of Earnings, sales and profitability analysis, working capital and aging, net debt and debt-like items, net assets, Current Year Trading, and plan linkage. The Transaction Services – FDD All-in-One Excel Workbook explicitly assembles these modules into one integrated file.

How is Quality of Earnings captured in a due diligence workbook?

Quality of Earnings is captured by reconciling reported, adjusted and pro-forma EBITDA and margins, using structured adjustment schedules for reclassifications, normalisations and pro-forma items, and producing clear, traceable EBITDA bridges and adjustment schedules as the core output.

Which working capital metrics and schedules should a TS model include?

A due diligence workbook should show net working capital by component, OWC vs. Net Debt split, DIO, DSO, DPO, cash conversion cycle, NWC as a percentage of sales or material expenses, and trade receivables/payables aging schedules with seasonality insights.

How are net debt and debt-like items typically presented for deal analysis?

Net debt sections present reported and pro-forma net financial debt and other debt-like items, calculate leverage KPIs such as Net Debt, Adjusted Net Debt/EBITDA and Net Debt/equity, and visualize net debt composition and development in charts.

What should I check when choosing an all-in-one TS/FDD Excel workbook?

Look for an integrated, audit-friendly structure that maps trial balance and sales detail into classified QoE, working capital and net debt items; clear guidance on each sheet; customizable segments and KPIs; and inclusion of both a Clean Template and a pre-populated Example Template.

How should I assess the cost versus value of buying a TS template instead of building from scratch?

Evaluate whether an off-the-shelf workbook consolidates core TS workstreams, reduces file reconciliation effort, and provides ready-made outputs for factbooks and IC decks. The referenced model consolidates 4 core models into one integrated workbook and includes guidance boxes on each sheet.

What analyses are essential when preparing a factbook or IC deck for a sale process?

Essential analyses include reported/adjusted/pro-forma EBITDA with bridges, sales segmentation by division/product/region/customer, segment-level profitability, NWC metrics and aging, and net debt composition charts—outputs intended for inclusion in factbooks and IC decks.

What is the standard workflow to reconcile a target’s trial balance into pro-forma financials?

Standard workflow: set core parameters (periods, segments, currency, plan horizon), load trial balance and sales detail, reconcile totals, classify accounts for QoE/NWC/net debt, enter adjustments, then review integrated Earnings/QoE, Sales, Working Capital, Net Debt and Plan tabs to produce pro-forma entries.

Source: Best Practices in Sales, M&A, Due Diligence, Integrated Financial Model Excel: Transaction Services – FDD All-in-One Excel Workbook Excel (XLSX) Spreadsheet, Finance Model Hub