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.
Financial due diligence databook automation
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.
Income statement
Illustrative company · USD in thousands
| Account group | 2024 | 2025 |
|---|---|---|
| Revenue | 12,000 | 14,400 |
| Cost of revenue | (7,200) | (8,640) |
| Gross profit | 4,800 | 5,760 |
| Operating expenses | (3,600) | (4,200) |
| Operating income | 1,200 | 1,560 |
Illustrative workbook layout and sample figures, not a product screenshot. Available schedules depend on your configured template and source data.
Built around your firm
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.
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.
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.
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
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 provide | How it is used |
|---|---|
| Your Excel databook | Configuration of your firm’s template and schedules. |
| Trial balances and general ledgers | Financial balances and supporting detail for the periods in scope. |
| Account mappings | Grouping client accounts into your firm’s categories. |
| Selected entities | Combining data using the configured multi-entity template. |
Supported accounting inputs
Connect QuickBooks Online to provide supported accounting data.
Upload a QuickBooks Desktop backup for conversion.
Provide supported trial balance and general ledger exports. Data conversion may be needed depending on the file format and scope.
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
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
Understand template setup, multi-entity work, and what happens when the data changes.
Comparing Claude and TAS OS for databooks →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.
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.
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.
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.
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.
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
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 →