Financial due diligence databook automation

Your firm’s Excel databook.
Less manual preparation.

Audit Sight populates your firm’s configured Excel financial due diligence databook from client trial balances and general ledgers. Keep your team’s format and spend more time understanding the business.

See your databook workflow →

Part of TAS OS, Audit Sight’s Transaction Advisory Operating System.

Your firm’s databook · Example output

Income statement
Illustrative company · USD in thousands

Account group20242025
Revenue12,00014,400
Cost of revenue(7,200)(8,640)
Gross profit4,8005,760
Operating expenses(3,600)(4,200)
Operating income1,2001,560
Income statementBalance sheetWorking capital

Illustrative workbook layout and sample figures, not a product screenshot. Available schedules depend on your configured template and source data.

Built around your firm

Start with the databook your team already uses.

Financial due diligence teams should not have to rebuild the same workbook for every deal. Audit Sight configures your firm’s template, then uses engagement accounting data and account mappings to populate it.

01 / Configure once

Bring your template.

During onboarding, we review your Excel databook, account groupings, and required schedules. We agree the supported scope and configure the template before your team generates workbooks.

02 / Prepare the data

Map client accounts.

Provide accounting data for the entities and periods in scope. Review the mapping of client accounts to your firm’s categories. AI can assist with mapping; your team checks the result.

03 / Review in Excel

Start with a populated file.

Generate the workbook using defined financial calculations. Download it to Excel, investigate the results, add your analysis, and prepare the conclusions your client needs.

Inputs and outputs

From client accounting data to your firm’s schedules.

Source detail determines what can be populated. A trial balance and a transaction-level general ledger support different levels of analysis. We confirm the data and template requirements for your workflow.

Financial statement, working capital, and other schedules are populated where supported by your configured template and available data. Professional review remains part of every engagement.

What you provideHow it is used
Your Excel databookConfiguration of your firm’s template and schedules.
Trial balances and general ledgersFinancial balances and supporting detail for the periods in scope.
Account mappingsGrouping client accounts into your firm’s categories.
Selected entitiesCombining data using the configured multi-entity template.

Supported accounting inputs

Use a connection, backup, or supported export.

QuickBooks Online

Connect QuickBooks Online to provide supported accounting data.

QuickBooks Desktop

Upload a QuickBooks Desktop backup for conversion.

Other accounting systems

Provide supported trial balance and general ledger exports. Data conversion may be needed depending on the file format and scope.

Banking data is separate.

A databook uses accounting data. For cash proof procedures, provide PDF bank statements or supported banking transaction exports separately. Explore proof of cash for transaction advisory →

More than the workbook

Keep databook preparation with the rest of the deal.

TAS OS brings request lists, documents, tasks, databooks, cash proofs, and Practice Intelligence into your transaction advisory workflow.

Track the work that needs to happen before and after the workbook is ready. Keep owners, deadlines, and deal progress visible to the team.

Explore financial due diligence software in TAS OS →

Before you choose

Practical questions about firm databooks.

Understand template setup, multi-entity work, and what happens when the data changes.

Comparing Claude and TAS OS for databooks →
Can Audit Sight populate our existing Excel FDD databook?

Yes. We start with your firm’s workbook and configure a supported template during onboarding. This is a configuration process, not a promise that every workbook, formula, or schedule works automatically without setup.

Can a databook include multiple entities?

Yes. Select the entities to include when you create the request. Available consolidating schedules depend on your configured template. Your team prepares and reviews intercompany elimination entries.

What happens when we refresh the accounting data?

A refresh generates a new workbook from the accounting data and account mappings in Audit Sight. Edits made in a downloaded Excel file do not carry into the new workbook. Keep your working copy separately if you have added analysis or adjustments.

Can we edit the generated workbook?

Yes. You can edit the downloaded Excel file, including formulas, schedules, analysis, adjustments, and formatting. Those edits remain in your downloaded file and are not automatically preserved in a newly generated workbook.

Does the software make our diligence conclusions?

No. Audit Sight combines AI-assisted preparation with defined financial calculations. Your team reviews the data, mappings, populated schedules, and exceptions, performs the remaining diligence, and draws conclusions.

How is firm databook automation priced?

Your proposal and order form define configuration, included products and usage, refresh terms, and any conversion or additional service fees. We review your template and engagement needs before proposing the scope.

See it with your workflow

Bring the databook.
We’ll talk through the build.

Show us the schedules your team prepares and the accounting data your clients provide. We’ll discuss template configuration, supported outputs, and how TAS OS fits your practice.

Request a TAS OS demo →

Review trust and security