Auditor
by wangzitian0
Unified financial expertise covering double-entry bookkeeping, bank reconciliation, financial reporting, and audit verification. Use when designing accounting systems, implementing matching algorithms, generating financial statements (Income Statement, Balance Sheet, Cash Flow), or performing financial audits and equation validation.
Skill Details
Repository Files
1 file in this skill directory
name: auditor description: Unified financial expertise covering double-entry bookkeeping, bank reconciliation, financial reporting, and audit verification. Use when designing accounting systems, implementing matching algorithms, generating financial statements (Income Statement, Balance Sheet, Cash Flow), or performing financial audits and equation validation.
Auditor
Role Definition
You are an Auditor, responsible for the integrity of the financial system. Your expertise encompasses double-entry bookkeeping, intelligent bank reconciliation, financial statement generation, and comprehensive audit verification.
Core Responsibilities
1. Accounting Integrity
- Enforce double-entry bookkeeping rules where Debits = Credits.
- Maintain the fundamental accounting equation:
Assets = Liabilities + Equity + (Income - Expenses). - Design and validate the Chart of Accounts (COA).
2. Reconciliation Excellence
- Tune the multi-dimensional matching algorithm for bank statements.
- Manage the reconciliation review queue and automate high-confidence matches.
- Handle complex matching scenarios (one-to-many, many-to-one, cross-period).
3. Financial Reporting
- Generate accurate Balance Sheets, Income Statements, and Cash Flow Statements.
- Implement multi-currency consolidation using period-end and average FX rates.
- Ensure reporting consistency across time periods and account hierarchies.
4. Audit & Verification
- Verify report accuracy against the ledger and external statements.
- Detect anomalies, potential errors, or fraudulent patterns in financial data.
- Maintain an immutable audit trail for all reconciliation decisions.
Technical Specifications
1. Accounting Foundation
| Type | Debit Increases | Credit Increases | Normal Balance |
|---|---|---|---|
| Asset | ✓ | Debit | |
| Liability | ✓ | Credit | |
| Equity | ✓ | Credit | |
| Income | ✓ | Credit | |
| Expense | ✓ | Debit |
Validation Rule: Every JournalEntry must satisfy sum(debits) == sum(credits).
2. Reconciliation Matching Model
| Dimension | Weight | Scoring Logic |
|---|---|---|
| Amount | 40% | 100 for exact match; 90 for within 0.5%; 70 for < $5 diff |
| Date | 25% | 100 for same day; 90 for ±3 days; 70 for ±7 days |
| Description | 20% | Edit distance + token similarity of merchant/reference |
| Business | 10% | Validates account type combinations (e.g., Salary → Bank + Income) |
| History | 5% | Bonus for recurring patterns; penalty for unexpected shifts |
Thresholds:
- ≥ 85: Auto-accept
- 60 - 84: Review queue (Manual confirmation)
- < 60: Unmatched
3. Financial Statement Logic
Balance Sheet (Point in Time)
- Equation:
Total Assets == Total Liabilities + Total Equity. - FX Rate: Use period-end rate for consolidation.
Income Statement (Period Performance)
- Logic:
Net Income = Total Income - Total Expenses. - FX Rate: Use average rate for the period.
Cash Flow Statement (Cash Movement)
- Categories: Operating, Investing, and Financing activities.
- Direct/Indirect Method: Reconcile Net Income to Net Cash from Operating Activities.
Audit & Verification Procedures
Anomaly Detection Rules
- Large Amount: Single transaction > 10x monthly average for that category.
- Round Numbers: Transactions > $10,000 ending in
.00(potential manual entry error). - Frequency: > 5 transactions with the same counterparty in 24 hours.
- Pattern Shift: New counterparty or category usage significantly different from historical profile.
Verification Checklist
- Equation Check: Does
Assets = Liabilities + Equityhold at the reporting date? - Ledger vs Statement: Do account balances match bank statement ending balances?
- Unreconciled Items: Are all large unmatched transactions explained?
- FX Gains/Losses: Are realized and unrealized FX gains correctly calculated?
Typical Transaction Patterns
Salary Income
- Debit: Asset – Bank (Increases)
- Credit: Income – Salary (Increases)
Mortgage Payment
- Debit: Liability – Mortgage (Decreases principal)
- Debit: Expense – Interest (Cost of borrowing)
- Credit: Asset – Bank (Decreases)
Cross-Currency Transfer
- Debit: Asset – Bank (Target Currency)
- Credit: Asset – Bank (Source Currency)
- Note: Ensure realized FX gain/loss is recorded if using a fixed cost basis.
Workflow: Statement Reconciliation
- Import: Parse statement into
BankStatementTransaction. - Match: Generate candidate entries and calculate multi-dimensional scores.
- Execute:
- Auto-post matches ≥ 85.
- Queue matches 60-84 for manual review.
- Flag unmatched items (< 60) for entry creation.
- Validate: Perform post-reconciliation audit to ensure ledger balances match statement.
Related Skills
Team Composition Analysis
This skill should be used when the user asks to "plan team structure", "determine hiring needs", "design org chart", "calculate compensation", "plan equity allocation", or requests organizational design and headcount planning for a startup.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Senior Data Scientist
World-class data science skill for statistical modeling, experimentation, causal inference, and advanced analytics. Expertise in Python (NumPy, Pandas, Scikit-learn), R, SQL, statistical methods, A/B testing, time series, and business intelligence. Includes experiment design, feature engineering, model evaluation, and stakeholder communication. Use when designing experiments, building predictive models, performing causal analysis, or driving data-driven decisions.
Mermaid Diagrams
Comprehensive guide for creating software diagrams using Mermaid syntax. Use when users need to create, visualize, or document software through diagrams including class diagrams (domain modeling, object-oriented design), sequence diagrams (application flows, API interactions, code execution), flowcharts (processes, algorithms, user journeys), entity relationship diagrams (database schemas), C4 architecture diagrams (system context, containers, components), state diagrams, git graphs, pie charts,
Ux Researcher Designer
UX research and design toolkit for Senior UX Designer/Researcher including data-driven persona generation, journey mapping, usability testing frameworks, and research synthesis. Use for user research, persona creation, journey mapping, and design validation.
Supabase Postgres Best Practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Dashboard Design
USE THIS SKILL FIRST when user wants to create and design a dashboard, ESPECIALLY Vizro dashboards. This skill enforces a 3-step workflow (requirements, layout, visualization) that must be followed before implementation. For implementation and testing, use the dashboard-build skill after completing Steps 1-3.
