Audit Trail Verifier
Overview
The Audit Trail Verifier skill provides systematic verification of financial data against source documentation during due diligence. It traces reported metrics back to bank statements, contracts, and other primary sources to validate accuracy and identify discrepancies.
Capabilities
Bank Statement Reconciliation
- Match reported revenue to bank deposits
- Verify cash balance accuracy
- Reconcile payment timing differences
- Identify unexplained discrepancies
Contract Verification
- Match revenue recognition to contract terms
- Verify pricing and payment terms
- Check contract status and renewal dates
- Validate customer counts against contracts
Invoice and Payment Tracking
- Trace invoices to payments received
- Analyze days sales outstanding (DSO)
- Identify collection issues
- Verify accounts receivable aging
Expense Verification
- Match expenses to supporting documentation
- Verify vendor contracts and commitments
- Check employee payroll against records
- Validate equity compensation records
Usage
Verify Revenue
Input: Reported revenue, bank statements, contracts
Process: Trace revenue to sources, reconcile differences
Output: Verification report, discrepancy list
Reconcile Cash
Input: Reported cash, bank statements
Process: Compare balances, identify differences
Output: Cash reconciliation, unexplained items
Verify Contracts
Input: Customer list, revenue claims, contract files
Process: Match contracts to revenue, check terms
Output: Contract verification summary, issues found
Audit Expenses
Input: Expense reports, supporting documentation
Process: Sample and verify expenses, check approvals
Output: Expense audit results, policy compliance
Verification Categories
| Category |
Key Verification Points |
| Revenue |
Bank deposits, contracts, invoices, recognition timing |
| Cash |
Bank statements, reconciliations, restricted cash |
| Receivables |
Aging, collectability, concentration |
| Payables |
Vendor agreements, payment terms, accruals |
| Payroll |
Employment records, compensation agreements |
Integration Points
- Financial Due Diligence: Core verification for financial DD
- Financial Model Validator: Validate historical data accuracy
- Legal Due Diligence: Coordinate contract reviews
- Financial Analyst (Agent): Support verification work
Red Flags
- Revenue not matching bank deposits
- Large reconciling items without explanation
- Significant revenue concentration in month-end
- Missing or incomplete contract documentation
- Unusual related party transactions
- Unexplained cash movements
Best Practices
- Request direct bank feeds or certified statements
- Sample test across periods, not just recent
- Focus on material items and unusual patterns
- Request management explanations for discrepancies
- Document verification trail thoroughly
1---
2name: audit-trail-verifier
3description: Verifies financial data against source documents, bank statements, contracts
4allowed-tools:
5 - Read
6 - Write
7 - Glob
8 - Grep
9 - Bash
10 - WebFetch
11metadata:
12 source: https://skillmd.com/skills/a5c-ai/audit-trail-verifier
13 specialization: venture-capital
14 domain: business
15 skill-id: vc-skill-012
16graph:
17 domains: [domain:venture-capital]
18 skillAreas: [skill-area:investment-analysis, skill-area:valuation-analysis, skill-area:financial-modeling]
19 roles: [role:financial-analyst]
20---
21
22# Audit Trail Verifier
23
24## Overview
25
26The Audit Trail Verifier skill provides systematic verification of financial data against source documentation during due diligence. It traces reported metrics back to bank statements, contracts, and other primary sources to validate accuracy and identify discrepancies.
27
28## Capabilities
29
30### Bank Statement Reconciliation
31- Match reported revenue to bank deposits
32- Verify cash balance accuracy
33- Reconcile payment timing differences
34- Identify unexplained discrepancies
35
36### Contract Verification
37- Match revenue recognition to contract terms
38- Verify pricing and payment terms
39- Check contract status and renewal dates
40- Validate customer counts against contracts
41
42### Invoice and Payment Tracking
43- Trace invoices to payments received
44- Analyze days sales outstanding (DSO)
45- Identify collection issues
46- Verify accounts receivable aging
47
48### Expense Verification
49- Match expenses to supporting documentation
50- Verify vendor contracts and commitments
51- Check employee payroll against records
52- Validate equity compensation records
53
54## Usage
55
56### Verify Revenue
57```
58Input: Reported revenue, bank statements, contracts
59Process: Trace revenue to sources, reconcile differences
60Output: Verification report, discrepancy list
61```
62
63### Reconcile Cash
64```
65Input: Reported cash, bank statements
66Process: Compare balances, identify differences
67Output: Cash reconciliation, unexplained items
68```
69
70### Verify Contracts
71```
72Input: Customer list, revenue claims, contract files
73Process: Match contracts to revenue, check terms
74Output: Contract verification summary, issues found
75```
76
77### Audit Expenses
78```
79Input: Expense reports, supporting documentation
80Process: Sample and verify expenses, check approvals
81Output: Expense audit results, policy compliance
82```
83
84## Verification Categories
85
86| Category | Key Verification Points |
87|----------|------------------------|
88| Revenue | Bank deposits, contracts, invoices, recognition timing |
89| Cash | Bank statements, reconciliations, restricted cash |
90| Receivables | Aging, collectability, concentration |
91| Payables | Vendor agreements, payment terms, accruals |
92| Payroll | Employment records, compensation agreements |
93
94## Integration Points
95
96- **Financial Due Diligence**: Core verification for financial DD
97- **Financial Model Validator**: Validate historical data accuracy
98- **Legal Due Diligence**: Coordinate contract reviews
99- **Financial Analyst (Agent)**: Support verification work
100
101## Red Flags
102
103- Revenue not matching bank deposits
104- Large reconciling items without explanation
105- Significant revenue concentration in month-end
106- Missing or incomplete contract documentation
107- Unusual related party transactions
108- Unexplained cash movements
109
110## Best Practices
111
1121. Request direct bank feeds or certified statements
1132. Sample test across periods, not just recent
1143. Focus on material items and unusual patterns
1154. Request management explanations for discrepancies
1165. Document verification trail thoroughly