Auditor

by wangzitian0

design

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 + Equity hold 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

  1. Import: Parse statement into BankStatementTransaction.
  2. Match: Generate candidate entries and calculate multi-dimensional scores.
  3. Execute:
    • Auto-post matches ≥ 85.
    • Queue matches 60-84 for manual review.
    • Flag unmatched items (< 60) for entry creation.
  4. 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.

artdesign

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.

designdata

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.

designdata

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.

designtestingdata

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,

artdesigncode

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.

designtestingtool

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.

designdata

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.

designdata

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.

designdata

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.

designtestingworkflow

Skill Information

Category:Creative
Last Updated:1/22/2026