Agent skill

account-reconciliation-automator

Automated account reconciliation skill with matching algorithms and exception handling

Stars 514
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/a5c-ai/babysitter/tree/main/library/specializations/domains/business/finance-accounting/skills/account-reconciliation-automator

Metadata

Additional technical details for this skill

domain
business
category
accounting-compliance
priority
high
specialization
finance-accounting

SKILL.md

Account Reconciliation Automator

Overview

The Account Reconciliation Automator skill provides automated reconciliation capabilities for financial accounts. It uses matching algorithms to reconcile balances and transactions, identifies exceptions, and streamlines the close process.

Capabilities

Bank Reconciliation Automation

  • Statement import and parsing
  • Transaction matching rules
  • Outstanding check tracking
  • Deposit in transit identification
  • Bank fee recognition
  • Interest income posting

Subledger to GL Matching

  • Accounts receivable reconciliation
  • Accounts payable reconciliation
  • Fixed asset subledger matching
  • Inventory valuation reconciliation
  • Prepaid expense verification
  • Accrual account validation

Three-Way Match Processing

  • Purchase order matching
  • Goods receipt verification
  • Invoice matching
  • Quantity tolerance checking
  • Price variance identification
  • Exception routing

Exception Identification

  • Unmatched item detection
  • Threshold-based flagging
  • Aging categorization
  • Priority assignment
  • Owner notification
  • Resolution tracking

Aging Analysis

  • Bucket categorization
  • Days outstanding calculation
  • Collectability assessment
  • Write-off identification
  • Reserve calculation support
  • Trend analysis

Variance Threshold Alerting

  • Configurable thresholds
  • Automatic escalation
  • Email notifications
  • Dashboard integration
  • Audit trail creation
  • Resolution documentation

Usage

Month-End Reconciliation

Input: GL balances, subledger reports, bank statements
Process: Execute matching rules, identify exceptions, generate reconciliation
Output: Certified reconciliation, exception list, adjustment entries

Daily Cash Reconciliation

Input: Bank feeds, cash receipts, disbursements
Process: Match transactions, identify timing differences
Output: Reconciled cash position, outstanding items list

Integration

Used By Processes

  • Month-End Close Process
  • External Audit Coordination
  • SOX Compliance and Testing

Tools and Libraries

  • BlackLine API
  • Trintech
  • Reconciliation platforms
  • RPA tools

Best Practices

  1. Establish reconciliation frequency by account risk
  2. Define matching rules with appropriate tolerances
  3. Set escalation timelines for aged exceptions
  4. Maintain documentation standards
  5. Implement certification workflows
  6. Build continuous monitoring for high-risk accounts

Expand your agent's capabilities with these related and highly-rated skills.

a5c-ai/babysitter

gsd-tools

Central utility skill for GSD operations. Provides config parsing, slug generation, timestamps, path operations, and orchestrates calls to other specialized skills. Acts as the unified entry point that the original gsd-tools.cjs provided via its lib/ modules (commands, config, core, init).

514 31
Explore
a5c-ai/babysitter

model-profile-resolution

Resolve model profile (quality/balanced/budget) at orchestration start and map agents to specific models. Enables cost/quality tradeoffs by selecting appropriate AI models for each agent role.

514 31
Explore
a5c-ai/babysitter

verification-suite

Plan structure validation, phase completeness checks, reference integrity verification, and artifact existence confirmation. Provides the structured verification layer ensuring GSD artifacts are well-formed and complete.

514 31
Explore
a5c-ai/babysitter

state-management

STATE.md reading, writing, and field-level updates. Provides cross-session state persistence via .planning/STATE.md with structured fields for current task, completed phases, blockers, decisions, and quick tasks.

514 31
Explore
a5c-ai/babysitter

git-integration

Git commit patterns, formats, and conventions for GSD methodology. Provides atomic commits per task, structured commit messages, planning file commits, branch management, and milestone tag operations.

514 31
Explore
a5c-ai/babysitter

frontmatter-parsing

YAML frontmatter parsing and manipulation for .planning/ documents. Provides read, write, update, query, and validation operations on frontmatter blocks in GSD markdown artifacts.

514 31
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results